Changeset 6468
- Timestamp:
- 06/12/12 17:28:36 (12 years ago)
- Location:
- sandbox/2.4.1-3
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
sandbox/2.4.1-3/expressoMail1_2/setup/default_records.inc.php
r5988 r6468 1 1 <?php 2 /**************************************************************************\ 3 * eGroupWare - Setup * 4 * http://www.egroupware.org * 5 * -------------------------------------------- * 6 * This program is free software; you can redistribute it and/or modify it * 7 * under the terms of the GNU General Public License as published by the * 8 * Free Software Foundation; either version 2 of the License, or (at your * 9 * option) any later version. * 10 \**************************************************************************/ 11 2 12 $oProc->query("ALTER TABLE expressomail_message_followupflag ADD CONSTRAINT expressomail_message_followupflag_followupflag_id_fkey FOREIGN KEY (followupflag_id) REFERENCES expressomail_followupflag (id);"); 3 13 … … 15 25 $oProc->query("INSERT INTO phpgw_hooks( \"hook_appname\", \"hook_location\", \"hook_filename\") VALUES ('expressoMail1_2', 'config_validate', 'hook_config_validate.inc.php')"); 16 26 17 27 /* Cria um indice unico para um owner e mail para nao ocorrer duplicidade em e-mails para um mesmo owner */ 28 $oProc->query("ALTER TABLE expressomail_dynamic_contact ADD CONSTRAINT owner_mail UNIQUE (owner, mail)"); 18 29 ?> -
sandbox/2.4.1-3/expressoMail1_2/setup/tables_current.inc.php
r6421 r6468 16 16 'name' => array('type' => 'varchar','precision' => '100','nullable' => true), 17 17 'mail' => array('type' => 'varchar','precision' => '100','nullable' => False), 18 'number_of_messages' => array('type' => 'int','precision' => '16','nullable' => False), 18 19 'timestamp' => array('type' => 'int','precision' => '16','nullable' => False), 19 20 ), -
sandbox/2.4.1-3/expressoMail1_2/setup/tables_update.inc.php
r6386 r6468 275 275 'name' => array('type' => 'varchar','precision' => '100','nullable' => true), 276 276 'mail' => array('type' => 'varchar','precision' => '100','nullable' => False), 277 'number_of_messages' => array('type' => 'int','precision' => '16','nullable' => False), 277 278 'timestamp' => array('type' => 'int','precision' => '16','nullable' => False), 278 279 ), … … 284 285 ); 285 286 287 /* Cria um indice unico para um owner e mail para nao ocorrer duplicidade em e-mails para um mesmo owner */ 288 $oProc->query("ALTER TABLE expressomail_dynamic_contact ADD CONSTRAINT owner_mail UNIQUE (owner, mail)"); 289 286 290 //Migra dados antigos para nova tabela 287 291 $oProc->query('SELECT * FROM phpgw_expressomail_contacts'); … … 294 298 foreach ($contacts as &$contact) { 295 299 $info = explode('#', $contact['email']); 296 $oProc->query("INSERT INTO expressomail_dynamic_contact (owner, name ,mail , timestamp) values ('".$owner."', '".$info[0]."', '".$info[1]."', '".$contact['timestamp']."');");300 $oProc->query("INSERT INTO expressomail_dynamic_contact (owner, name ,mail , number_of_messages ,timestamp) values ('".$owner."', '".$info[0]."', '".$info[1]."', 1, '".$contact['timestamp']."');"); 297 301 } 298 302 } -
sandbox/2.4.1-3/rest/setup/default_records.inc.php
r6368 r6468 1 1 <?php 2 3 /**************************************************************************\ 4 * eGroupWare - Setup * 5 * http://www.egroupware.org * 6 * -------------------------------------------- * 7 * This program is free software; you can redistribute it and/or modify it * 8 * under the terms of the GNU General Public License as published by the * 9 * Free Software Foundation; either version 2 of the License, or (at your * 10 * option) any later version. * 11 \**************************************************************************/ 2 12 3 13 $secret = substr(md5(rand().rand()), 0, 16); //Gera senha aleatoria
Note: See TracChangeset
for help on using the changeset viewer.