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

Timestamp:

06/15/12 17:00:17 (12 years ago)

Author:

gustavo

Message:

Ticket #2766 - Merge do branch das novas funcionalidaes para o trunk

Location:

trunk

Files:

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

trunk/expressoMail1_2/setup/tables_update.inc.php

@@ -267 +267 @@
             return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
         }
-        
+
+        $test[] = '2.4.7';
+        function expressoMail1_2_upgrade2_4_7() {
+                $oProc = $GLOBALS['phpgw_setup']->oProc;
+
+                //Criando nova tabela de contatos dinamicos
+                $oProc->CreateTable('expressomail_dynamic_contact',array(
+                        'fd' => array(
+                                'id' => array('type' => 'auto','nullable' => False),
+                                'owner' => array('type' => 'int','precision' => '16','nullable' => False),
+                                'name' => array('type' => 'varchar','precision' => '100','nullable' => true),
+                                'mail' => array('type' => 'varchar','precision' => '100','nullable' => False),
+                                'number_of_messages' => array('type' => 'int','precision' => '16','nullable' => False),
+                                'timestamp' => array('type' => 'int','precision' => '16','nullable' => False),
+                        ),
+                        'pk' => array('id'),
+                        'fk' => array(),
+                        'ix' => array(),
+                        'uc' => array()
+                        )
+                );
+
+                /* Cria um indice unico para um owner e mail para nao ocorrer duplicidade em e-mails para um mesmo owner  */
+                $oProc->query("ALTER TABLE expressomail_dynamic_contact ADD CONSTRAINT owner_mail UNIQUE (owner, mail)");
+
+                //Migra dados antigos para nova tabela
+                $oProc->query('SELECT * FROM phpgw_expressomail_contacts');
+                $return = array();
+                while($oProc->next_record())
+                        $return[$oProc->f('id_owner')] = $oProc->f('data');
+
+                foreach ($return as $owner => &$value) {
+                        $contacts = unserialize($value);
+                        foreach ($contacts as &$contact) {
+                                $info = explode('#', $contact['email']);
+                                $oProc->query("INSERT INTO expressomail_dynamic_contact (owner, name ,mail , number_of_messages ,timestamp) values ('".$owner."', '".$info[0]."', '".$info[1]."', 1, '".$contact['timestamp']."');");
+                        }
+                }
+
+                //Deleta tabela antiga
+                $oProc->DropTable('phpgw_expressomail_contacts');
+
+                /* Remove a restricao de quantidade de contatos recentes */
+                $oProc->query("DELETE FROM phpgw_config WHERE config_app = 'expressoMail1_2' AND config_name = 'expressoMail_Number_of_dynamic_contacts'");
+
+                $GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '2.4.8';
+            return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
+        }
 ?>