Changeset 6386

Timestamp:

06/01/12 17:21:49 (11 years ago)

Author:

cristiano

Message:

Ticket #2768 - Migração dos contatos dinamicos para novo padrão

Location:

sandbox/2.4.1-3/expressoMail1_2/setup

Files:

• setup.inc.php (modified) (2 diffs)
• tables_current.inc.php (modified) (1 diff)
• tables_update.inc.php (modified) (1 diff)

sandbox/2.4.1-3/expressoMail1_2/setup/setup.inc.php

@@ -13 +13 @@
 $setup_info['expressoMail1_2']['name'] = 'expressoMail1_2';
 $setup_info['expressoMail1_2']['title'] = 'Expresso Mail';
-$setup_info['expressoMail1_2']['version'] = '2.4.6';
-$setup_info['expressoMail1_2']['app_order'] = 2;
-$setup_info['expressoMail1_2']['tables'][] = 'phpgw_expressomail_contacts';
+$setup_info['expressoMail1_2']['version'] = '2.4.7';
+$setup_info['expressoMail1_2']['app_order'] = 2
 $setup_info['expressoMail1_2']['tables'][] = 'phpgw_certificados';
 
@@ -22 +21 @@
 $setup_info['expressoMail1_2']['tables'][] = 'expressomail_message_followupflag';
 $setup_info['expressoMail1_2']['tables'][] = 'expressomail_followupflag';
+$setup_info['expressoMail1_2']['tables'][] = 'expressomail_dynamic_contact';
 
 

sandbox/2.4.1-3/expressoMail1_2/setup/tables_current.inc.php

@@ -12 +12 @@
                 'phpgw_expressomail_contacts' => array(
                         'fd' => array(
-                                'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
-                                'data' => array( 'type' => 'text')
+                                '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),
+                                'timestamp' => array('type' => 'int','precision' => '16','nullable' => False),
                         ),
-                        'pk' => array('id_owner'),
+                        'pk' => array('id'),
                         'fk' => array(),
                         'ix' => array(),
                         'uc' => array()
                 ),
+                
         'phpgw_certificados' => array(
             'fd' => array(

sandbox/2.4.1-3/expressoMail1_2/setup/tables_update.inc.php

@@ -263 +263 @@
             return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
         }
+
+        $test[] = '2.4.6';
+        function expressoMail1_2_upgrade2_4_6() {
+                $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),
+                                'timestamp' => array('type' => 'int','precision' => '16','nullable' => False),
+                        ),
+                        'pk' => array('id'),
+                        'fk' => array(),
+                        'ix' => array(),
+                        'uc' => array()
+                        )
+                );
+
+                //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 , timestamp) values ('".$owner."', '".$info[0]."', '".$info[1]."', '".$contact['timestamp']."');");
+                }
+        }
+        ////////////////////////////////////////////////////////////
+
+        //Deleta tabela antiga
+                $oProc->DropTable('phpgw_expressomail_contacts');
+        
+
+                $GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '2.4.7';
+            return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
+        }
         
 ?>