Changeset 5547 for trunk/expressoMail1_2/setup/tables_update.inc.php

Timestamp:

02/24/12 15:09:26 (12 years ago)

Author:

douglasz

Message:

Ticket #2486 - Atualizado o arquivo setup correções no salvamento de sinalizadores

File:

• trunk/expressoMail1_2/setup/tables_update.inc.php (modified) (1 diff)

trunk/expressoMail1_2/setup/tables_update.inc.php

@@ -141 +141 @@
             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'), ('Read'), ('Forward'), ('Answer'), ('Don''t forward'), ('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'];
+        }       
 ?>