Changeset 5651


Ignore:
Timestamp:
03/06/12 18:01:43 (12 years ago)
Author:
acoutinho
Message:

Ticket #2434 - Melhorias na atualizacao do expressoCalendar

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/expressoCalendar/setup/tables_update.inc.php

    r5650 r5651  
    1515                $oProc = $GLOBALS['phpgw_setup']->oProc; 
    1616 
    17                 $oProc->query('ALTER TABLE calendar_participant ADD COLUMN acl character varying(10) not null DEFAULT "r" '); 
    18                 $oProc->query('ALTER TABLE calendar_participant ADD COLUMN receive_notification smallint not null DEFAULT 1 '); 
     17                $oProc->query("ALTER TABLE calendar_participant ADD COLUMN acl character varying(10) not null DEFAULT 'r' "); 
     18                 
     19                $oProc->query("ALTER TABLE calendar_participant ADD COLUMN receive_notification smallint not null DEFAULT 1 "); 
    1920                $oProc->query('ALTER TABLE calendar_participant RENAME COLUMN delegated_to TO delegated_from '); 
    20                 $oProc->query('UPDATE calendar_participant SET acl = "rowi" where is_organizer = 1 '); 
     21                 
     22                $oProc->query("UPDATE calendar_participant SET acl = 'rowi' where is_organizer = 1 "); 
    2123 
    2224                $oProc->query('ALTER TABLE calendar_object  ALTER COLUMN range_start TYPE bigint USING (date_part(\'epoch\',(cast(range_start as timestamp)))::bigint) * 1000'); 
     
    2628                $oProc->query('ALTER TABLE calendar_alarm ALTER COLUMN range_start TYPE bigint USING (date_part(\'epoch\',(cast(range_start as timestamp)))::bigint) * 1000'); 
    2729 
    28                 $oProc->query('ALTER TABLE attachment ADD COLUMN owner integer'); 
     30                $oProc->query("ALTER TABLE attachment ADD COLUMN owner integer"); 
    2931 
    3032                $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.001'; 
Note: See TracChangeset for help on using the changeset viewer.