<?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.                                               *
	\**************************************************************************/
	//	Since Expresso 1.2 using ExpressoMail 1.233		
	$test[] = '1.233';
	function expressoMail1_2_upgrade1_233() {
		$setup_info['expressoMail1_2']['currentver'] = '1.234';
		return $setup_info['expressoMail1_2']['currentver'];
	}
	$test[] = '1.234';
	function expressoMail1_2_upgrade1_234() {
    	$oProc = $GLOBALS['phpgw_setup']->oProc;            
            $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.235';
        return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
	}
	$test[] = '1.235';
	function expressoMail1_2_upgrade1_235() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.000';
		return $setup_info['expressoMail1_2']['currentver'];
	}		
	$test[] = '2.0.000';
	function expressoMail1_2_upgrade2_0_000() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.001';
		return $setup_info['expressoMail1_2']['currentver'];
	}
	$test[] = '2.0.001';
	function expressoMail1_2_upgrade2_0_001() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.002';
		return $setup_info['expressoMail1_2']['currentver'];
	}	
	$test[] = '2.0.002';
	function expressoMail1_2_upgrade2_0_002() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.003';
		return $setup_info['expressoMail1_2']['currentver'];
	}
	$test[] = '2.0.003';
	function expressoMail1_2_upgrade2_0_003() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.004';
		return $setup_info['expressoMail1_2']['currentver'];
	}
	$test[] = '2.0.004';
	function expressoMail1_2_upgrade2_0_004() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.005';
		return $setup_info['expressoMail1_2']['currentver'];
	}	
	$test[] = '2.0.005';
	function expressoMail1_2_upgrade2_0_005() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.006';
		return $setup_info['expressoMail1_2']['currentver'];
	}	
	$test[] = '2.0.006';
	function expressoMail1_2_upgrade2_0_006() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.007';
		return $setup_info['expressoMail1_2']['currentver'];
	}		
	$test[] = '2.0.007';
	function expressoMail1_2_upgrade2_0_007() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.008';
		return $setup_info['expressoMail1_2']['currentver'];
	}	
	$test[] = '2.0.008';
	function expressoMail1_2_upgrade2_0_008() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.009';
		return $setup_info['expressoMail1_2']['currentver'];
	}
	$test[] = '2.0.009';
	function expressoMail1_2_upgrade2_0_009() {
		$setup_info['expressoMail1_2']['currentver'] = '2.0.010';
		return $setup_info['expressoMail1_2']['currentver'];
	}
	$test[] = '2.0.010';
	function expressoMail1_2_upgrade2_0_010() {
		$setup_info['expressoMail1_2']['currentver'] = '2.1.000';
		return $setup_info['expressoMail1_2']['currentver'];
	}
	$test[] = '2.1.000';
	function expressoMail1_2_upgrade2_1_000() {
		$setup_info['expressoMail1_2']['currentver'] = '2.2.000';
		return $setup_info['expressoMail1_2']['currentver'];
	}	
	$test[] = '2.2.000';
	function expressoMail1_2_upgrade2_2_000() {
		$setup_info['expressoMail1_2']['currentver'] = '2.2.1';
		return $setup_info['expressoMail1_2']['currentver'];
	}
	$test[] = '2.2.1'; 
 	function expressoMail1_2_upgrade2_2_1() { 
 	    $setup_info['expressoMail1_2']['currentver'] = '2.2.2'; 
 	    return $setup_info['expressoMail1_2']['currentver']; 
 	} 
	$test[] = '2.2.2'; 
 	function expressoMail1_2_upgrade2_2_2() { 
 	    $setup_info['expressoMail1_2']['currentver'] = '2.2.4'; 
 	    return $setup_info['expressoMail1_2']['currentver']; 
 	}
 	$test[] = '2.2.4';
 	function expressoMail1_2_upgrade2_2_4() {
 		$setup_info['expressoMail1_2']['currentver'] = '2.2.6';
 		return $setup_info['expressoMail1_2']['currentver'];
 	}
 	$test[] = '2.2.6';
 	function expressoMail1_2_upgrade2_2_6() {
 		$setup_info['expressoMail1_2']['currentver'] = '2.2.8';
 		return $setup_info['expressoMail1_2']['currentver'];
 	}
 	$test[] = '2.2.8';
 	function expressoMail1_2_upgrade2_2_8() {
 		$setup_info['expressoMail1_2']['currentver'] = '2.2.10';
 		return $setup_info['expressoMail1_2']['currentver'];
 	}
 	$test[] = '2.2.10';
 	function expressoMail1_2_upgrade2_2_10() {
 		$setup_info['expressoMail1_2']['currentver'] = '2.3.0';
 		return $setup_info['expressoMail1_2']['currentver'];
 	} 	 	
	$test[] = '2.3.0'; 
 	function expressoMail1_2_upgrade2_3_0() { 
 	    $setup_info['expressoMail1_2']['currentver'] = '2.4.0'; 
 	    return $setup_info['expressoMail1_2']['currentver']; 
 	}
	$test[] = '2.4.0';
	function expressoMail1_2_upgrade2_4_0() {
    	$oProc = $GLOBALS['phpgw_setup']->oProc;            
            $oProc->CreateTable('expressomail_label',array(
				'fd' => array(
					'id' => array('type' => 'auto','nullable' => False),
					'user_id' => array('type' => 'int', 'precision' => '8','nullable' => true),
					'name' => array('type' => 'varchar','precision' => '255','nullable' => true),
					'border_color' => array('type' => 'varchar','precision' => '7','nullable' => true),
					'background_color' => array('type' => 'varchar','precision' => '7','nullable' => true),
					'font_color' => array('type' => 'varchar','precision' => '7','nullable' => true)
				),
				'pk' => array('id'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);
			$oProc->CreateTable('expressomail_followupflag',array(
				'fd' => array(
					'id' => array('type' => 'auto','nullable' => False),
					'user_id' => array('type' => 'int', 'precision' => '8','nullable' => true),
					'name' => array('type' => 'varchar','precision' => '255','nullable' => False)
				),
				'pk' => array('id'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);
			$oProc->CreateTable('expressomail_message_followupflag',array(
				'fd' => array(
					'id' => array('type' => 'auto','nullable' => False),
					'followupflag_id' => array('type' => 'int', 'precision' => '8','nullable' => False),					
					'border_color' => array('type' => 'varchar','precision' => '7','nullable' => true),
					'background_color' => array('type' => 'varchar','precision' => '7','nullable' => true),
					'font_color' => array('type' => 'varchar','precision' => '7','nullable' => true),
					'alarm_deadline' => array('type' => 'timestamp', 'nullable' => true),
					'done_deadline' => array('type' => 'timestamp', 'nullable' => true),
					'is_done' => array('type' => 'int', 'precision' => '8','nullable' => true)
				),
				'pk' => array('id'),
				'fk' => array(),
				'ix' => array(),
				'uc' => array()
				)
			);			
			$oProc->query("ALTER TABLE expressomail_message_followupflag ADD CONSTRAINT expressomail_message_followupflag_followupflag_id_fkey FOREIGN KEY (followupflag_id) REFERENCES expressomail_followupflag (id);");
			
			$oProc->query("INSERT INTO expressomail_followupflag(name) VALUES ('Follow up');");
			$oProc->query("INSERT INTO expressomail_followupflag(name) VALUES ('Read');");
			$oProc->query("INSERT INTO expressomail_followupflag(name) VALUES ('Forward');"); 
			$oProc->query("INSERT INTO expressomail_followupflag(name) VALUES ('Answer');"); 
			$oProc->query("INSERT INTO expressomail_followupflag(name) VALUES ('Don''t forward');");
			$oProc->query("INSERT INTO expressomail_followupflag(name) VALUES ('Don''t answer');");
			
			//Insert reservados para as labels padrões referentes ao thunderbir
			$oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('Important', '#ff0000', '#ff0000', '#ffffff');"); 
			$oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('Work', '#ff9900', '#ff9900', '#ffffff');"); 
			$oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('personal', '#009900', '#009900', '#ffffff');"); 
			$oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('todo', '#3333ff', '#3333ff', '#ffffff');"); 
			$oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('later', '#993399', '#993399', '#ffffff');");
						
		$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '2.4.1';
        return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
	}
        $test[] = '2.4.1';
	function expressoMail1_2_upgrade2_4_1() {
            $oProc = $GLOBALS['phpgw_setup']->oProc;            
            $oProc->CreateTable('expressomail_attachment',array(
			'fd' => array(
				'id' => array('type' => 'auto','nullable' => False),
				'source' => array('type' => 'blob','nullable' => False),
				'type' => array('type' => 'varchar','precision' => '50','nullable' => False),
				'name' => array('type' => 'varchar','precision' => '255','nullable' => False),
                                'disposition' => array('type' => 'varchar','precision' => '20','nullable' => true),
				'size' => array('type' => 'int','precision' => '16','nullable' => False),
                                'dtstamp' => array('type' => 'int','precision' => '16','nullable' => False),
				'owner' => array('type' => 'int', 'precision' => '8','nullable' => True)
			),
			'pk' => array('id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		)
			);						
		$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '2.4.2';
        return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
	}
?>