Changeset 6468 for sandbox/2.4.1-3/expressoMail1_2/setup/tables_update.inc.php

Timestamp:

06/12/12 17:28:36 (12 years ago)

Author:

gustavo

Message:

Ticket #2766 - Adicionado coluna na tabela ref. ao contatos recentes e acrescentando comentários.

File:

• sandbox/2.4.1-3/expressoMail1_2/setup/tables_update.inc.php (modified) (3 diffs)

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

@@ -275 +275 @@
                                 '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),
                         ),
@@ -284 +285 @@
                 );
 
+                /* 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');
@@ -294 +298 @@
                 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']."');");
+                        $oProc->query("INSERT INTO expressomail_dynamic_contact (owner, name ,mail , number_of_messages ,timestamp) values ('".$owner."', '".$info[0]."', '".$info[1]."', 1, '".$contact['timestamp']."');");
                 }
         }