<?php
	/**************************************************************************\
	* ExpressoLivre - Setup                                                     *
	* http://www.expressolivre.org                                              *
	* --------------------------------------------                             *
	* This program is free software; you can redistribute it and/or modify it  *
	* under the terms of the GNU General Public License as published by the    *
	* Free Software Foundation; either version 2 of the License, or (at your   *
	* option) any later version.                                               *
	\**************************************************************************/
	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.233'){
		$test[] = '1.233';
		function expressoMail1_2_upgrade1_233() {
            $oProc = $GLOBALS['phpgw_setup']->oProc;
            $oProc->CreateTable('phpgw_expressomail_contacts',array(
				'fd' => array(
					'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
					'data' => array( 'type' => 'text')
				),
				'pk' => array('id_owner'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);

            $oProc->CreateTable('phpgw_certificados',array(
				'fd' => array(
					'email' => array( 'type' => 'varchar', 'precision' => 60, 'nullable' => false),
					'chave_publica' => array( 'type' => 'text'),
					'expirado' => array('type' => 'bool', 'default' => 'false'),
					'revogado' => array('type' => 'bool', 'default' => 'false'),
					'serialnumber' => array('type' => 'int', 'precision' => 8, 'nullable' => false),
					'authoritykeyidentifier' => array( 'type' => 'text', 'nullable' => false),
				),
				'pk' => array('email','serialnumber','authoritykeyidentifier'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);

            $GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '1.334';
            return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
		}
	}	
	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.232'){
		$test[] = '1.232';													
		function expressoMail1_2_upgrade1_232() {
			$setup_info['expressoMail1_2']['currentver'] = '1.233';
			return $setup_info['expressoMail1_2']['currentver'];
		}
	}	
	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.231'){
		$test[] = '1.231';													
		function expressoMail1_2_upgrade1_231() {
			$setup_info['expressoMail1_2']['currentver'] = '1.232';
			return $setup_info['expressoMail1_2']['currentver'];
		}
	}
	
	function expressoMail1_2_upgrade1_230() {
		$oProc = $GLOBALS['phpgw_setup']->oProc;
		$oProc->CreateTable('phpgw_expressomail_contacts',array(
			'fd' => array(
				'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
				'data' => array( 'type' => 'text')
			),
			'pk' => array('id_owner'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()	)
		);
		$setup_info['expressoMail1_2']['currentver'] = '1.231';
		return $setup_info['expressoMail1_2']['currentver'];
	}		
				
	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.230'){
		$test[] = '1.230';													
		return expressoMail1_2_upgrade1_230();
	}
	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.222'){
		$test[] = '1.222';
		function expressoMail1_2_upgrade1_222() {
			$oProc = $GLOBALS['phpgw_setup']->oProc;
			$oProc->CreateTable('phpgw_expressomail_contacts',array(
				'fd' => array(
					'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
					'data' => array( 'type' => 'text')
				),
				'pk' => array('id_owner'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);
			$oProc->CreateTable('phpgw_certificados',array(
				'fd' => array(
					'email' => array( 'type' => 'varchar', 'precision' => 60, 'nullable' => false),
					'chave_publica' => array( 'type' => 'text'),
					'expirado' => array('type' => 'bool', 'default' => 'false')
				),
				'pk' => array('email'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);
			$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '1.223';
			return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
        }
	}
	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.2211'){
		$test[] = '1.2211';
		function expressoMail1_2_upgrade1_2211() {
			$oProc = $GLOBALS['phpgw_setup']->oProc;
			$oProc->CreateTable('phpgw_expressomail_contacts',array(
				'fd' => array(
					'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
					'data' => array( 'type' => 'text')
				),
				'pk' => array('id_owner'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);
			$oProc->CreateTable('phpgw_certificados',array(
				'fd' => array(
					'email' => array( 'type' => 'varchar', 'precision' => 60, 'nullable' => false),
					'chave_publica' => array( 'type' => 'text'),
					'expirado' => array('type' => 'bool', 'default' => 'false')
				),
				'pk' => array('email'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);
			$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '1.223';
			return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
        }
	}
	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.2201'){
		$test[] = '1.2201';
		function expressoMail1_2_upgrade1_2201() {return expressoMail1_2_upgrade1_230();}
	}
	
	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.2031'){
		$test[] = '1.2031';
		function expressoMail1_2_upgrade1_2031() {
			$oProc = $GLOBALS['phpgw_setup']->oProc;
			$oProc->CreateTable('phpgw_expressomail_contacts',array(
				'fd' => array(
					'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
					'data' => array( 'type' => 'text')
				),
				'pk' => array('id_owner'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);
			$oProc->CreateTable('phpgw_certificados',array(
				'fd' => array(
					'email' => array( 'type' => 'varchar', 'precision' => 60, 'nullable' => false),
					'chave_publica' => array( 'type' => 'text'),
					'expirado' => array('type' => 'bool', 'default' => 'false')
				),
				'pk' => array('email'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);
			$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '1.223';
			return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
        }
	}	
?>