Changeset 6468


Ignore:
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.

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  
    11<?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 
    212                        $oProc->query("ALTER TABLE expressomail_message_followupflag ADD CONSTRAINT expressomail_message_followupflag_followupflag_id_fkey FOREIGN KEY (followupflag_id) REFERENCES expressomail_followupflag (id);"); 
    313                         
     
    1525                        $oProc->query("INSERT INTO phpgw_hooks( \"hook_appname\", \"hook_location\", \"hook_filename\") VALUES ('expressoMail1_2', 'config_validate', 'hook_config_validate.inc.php')"); 
    1626 
    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)"); 
    1829?> 
  • sandbox/2.4.1-3/expressoMail1_2/setup/tables_current.inc.php

    r6421 r6468  
    1616                                'name' => array('type' => 'varchar','precision' => '100','nullable' => true), 
    1717                                'mail' => array('type' => 'varchar','precision' => '100','nullable' => False), 
     18                                'number_of_messages' => array('type' => 'int','precision' => '16','nullable' => False), 
    1819                                'timestamp' => array('type' => 'int','precision' => '16','nullable' => False), 
    1920                        ), 
  • sandbox/2.4.1-3/expressoMail1_2/setup/tables_update.inc.php

    r6386 r6468  
    275275                                'name' => array('type' => 'varchar','precision' => '100','nullable' => true), 
    276276                                'mail' => array('type' => 'varchar','precision' => '100','nullable' => False), 
     277                                'number_of_messages' => array('type' => 'int','precision' => '16','nullable' => False), 
    277278                                'timestamp' => array('type' => 'int','precision' => '16','nullable' => False), 
    278279                        ), 
     
    284285                ); 
    285286 
     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 
    286290                //Migra dados antigos para nova tabela 
    287291                $oProc->query('SELECT * FROM phpgw_expressomail_contacts'); 
     
    294298                foreach ($contacts as &$contact) { 
    295299                        $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']."');"); 
    297301                } 
    298302        } 
  • sandbox/2.4.1-3/rest/setup/default_records.inc.php

    r6368 r6468  
    11<?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  \**************************************************************************/ 
    212 
    313$secret = substr(md5(rand().rand()), 0, 16); //Gera senha aleatoria 
Note: See TracChangeset for help on using the changeset viewer.