Changeset 5547 for trunk/expressoMail1_2
- Timestamp:
- 02/24/12 15:09:26 (12 years ago)
- Location:
- trunk/expressoMail1_2/setup
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/expressoMail1_2/setup/setup.inc.php
r5298 r5547 12 12 $setup_info['expressoMail1_2']['name'] = 'expressoMail1_2'; 13 13 $setup_info['expressoMail1_2']['title'] = 'Expresso Mail'; 14 $setup_info['expressoMail1_2']['version'] = '2.4. 0';14 $setup_info['expressoMail1_2']['version'] = '2.4.1'; 15 15 $setup_info['expressoMail1_2']['app_order'] = 2; 16 16 $setup_info['expressoMail1_2']['tables'][] = 'phpgw_expressomail_contacts'; 17 17 $setup_info['expressoMail1_2']['tables'][] = 'phpgw_certificados'; 18 19 $setup_info['expressoMail1_2']['tables'][] = 'expressomail_label'; 20 $setup_info['expressoMail1_2']['tables'][] = 'expressomail_followupflag'; 21 $setup_info['expressoMail1_2']['tables'][] = 'expressomail_message_followupflag'; 22 18 23 $setup_info['expressoMail1_2']['enable'] = 1; 19 24 -
trunk/expressoMail1_2/setup/tables_current.inc.php
r1035 r5547 33 33 'ix' => array(), 34 34 'uc' => array() 35 ), 36 37 'expressomail_label' => array( 38 'fd' => array( 39 'id' => array('type' => 'auto','nullable' => False), 40 'user_id' => array('type' => 'int', 'precision' => '8','nullable' => true), 41 'name' => array('type' => 'varchar','precision' => '255','nullable' => true), 42 'border_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 43 'background_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 44 'font_color' => array('type' => 'varchar','precision' => '7','nullable' => true) 45 ), 46 'pk' => array('id'), 47 'fk' => array(), 48 'ix' => array(), 49 'uc' => array() 50 ), 51 52 'expressomail_followupflag' => array( 53 'fd' => array( 54 'id' => array('type' => 'auto','nullable' => False), 55 'user_id' => array('type' => 'int', 'precision' => '8','nullable' => true), 56 'name' => array('type' => 'varchar','precision' => '255','nullable' => False) 57 ), 58 'pk' => array('id'), 59 'fk' => array(), 60 'ix' => array(), 61 'uc' => array() 62 ), 63 64 'expressomail_message_followupflag' => array( 65 'fd' => array( 66 'id' => array('type' => 'auto','nullable' => False), 67 'followupflag_id' => array('type' => 'int', 'precision' => '8','nullable' => False), 68 'border_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 69 'background_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 70 'font_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 71 'alarm_deadline' => array('type' => 'timestamp', 'nullable' => true), 72 'done_deadline' => array('type' => 'timestamp', 'nullable' => true), 73 'is_done' => array('type' => 'int', 'precision' => '8','nullable' => true) 74 ), 75 'pk' => array('id'), 76 'fk' => array(), 77 'ix' => array(), 78 'uc' => array() 79 ) 35 80 ) 81 36 82 ); 37 83 ?> -
trunk/expressoMail1_2/setup/tables_update.inc.php
r5311 r5547 141 141 return $setup_info['expressoMail1_2']['currentver']; 142 142 } 143 $test[] = '2.4.0'; 144 function expressoMail1_2_upgrade2_4_0() { 145 $oProc = $GLOBALS['phpgw_setup']->oProc; 146 $oProc->CreateTable('expressomail_label',array( 147 'fd' => array( 148 'id' => array('type' => 'auto','nullable' => False), 149 'user_id' => array('type' => 'int', 'precision' => '8','nullable' => true), 150 'name' => array('type' => 'varchar','precision' => '255','nullable' => true), 151 'border_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 152 'background_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 153 'font_color' => array('type' => 'varchar','precision' => '7','nullable' => true) 154 ), 155 'pk' => array('id'), 156 'fk' => array(), 157 'ix' => array(), 158 'uc' => array() 159 ) 160 ); 161 $oProc->CreateTable('expressomail_followupflag',array( 162 'fd' => array( 163 'id' => array('type' => 'auto','nullable' => False), 164 'user_id' => array('type' => 'int', 'precision' => '8','nullable' => true), 165 'name' => array('type' => 'varchar','precision' => '255','nullable' => False) 166 ), 167 'pk' => array('id'), 168 'fk' => array(), 169 'ix' => array(), 170 'uc' => array() 171 ) 172 ); 173 $oProc->CreateTable('expressomail_message_followupflag',array( 174 'fd' => array( 175 'id' => array('type' => 'auto','nullable' => False), 176 'followupflag_id' => array('type' => 'int', 'precision' => '8','nullable' => False), 177 'border_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 178 'background_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 179 'font_color' => array('type' => 'varchar','precision' => '7','nullable' => true), 180 'alarm_deadline' => array('type' => 'timestamp', 'nullable' => true), 181 'done_deadline' => array('type' => 'timestamp', 'nullable' => true), 182 'is_done' => array('type' => 'int', 'precision' => '8','nullable' => true) 183 ), 184 'pk' => array('id'), 185 'fk' => array(), 186 'ix' => array(), 187 'uc' => array() 188 ) 189 ); 190 $oProc->query("ALTER TABLE expressomail_message_followupflag ADD CONSTRAINT expressomail_message_followupflag_followupflag_id_fkey FOREIGN KEY (followupflag_id) REFERENCES expressomail_followupflag (id);"); 191 $oProc->query("INSERT INTO expressomail_followupflag(name) VALUES ('Follow up'), ('Read'), ('Forward'), ('Answer'), ('Don''t forward'), ('Don''t answer');"); 192 193 //Insert reservados para as labels padrões referentes ao thunderbir 194 $oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('Important', '#ff0000', '#ff0000', '#ffffff');"); 195 $oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('Work', '#ff9900', '#ff9900', '#ffffff');"); 196 $oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('personal', '#009900', '#009900', '#ffffff');"); 197 $oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('todo', '#3333ff', '#3333ff', '#ffffff');"); 198 $oProc->query("INSERT INTO expressomail_label(name, font_color, border_color, background_color) VALUES ('later', '#993399', '#993399', '#ffffff');"); 199 200 $GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '2.4.1'; 201 return $GLOBALS['setup_info']['expressoMail1_2']['currentver']; 202 } 143 203 ?>
Note: See TracChangeset
for help on using the changeset viewer.