Changeset 5645


Ignore:
Timestamp:
03/06/12 16:07:18 (12 years ago)
Author:
acoutinho
Message:

Ticket #2434 - Melhoria no script de atualizacao da nova agenda

File:
1 edited

Legend:

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

    r5618 r5645  
    2121                $oProc->query('UPDATE calendar_participant SET acl = "rowi" where is_organizer = 1 '); 
    2222 
    23                 $oProc->query('ALTER TABLE calendar_object  ALTER COLUMN range_start TYPE bigint USING (date_part("epoch",(cast(range_start as timestamp)))::int * 1000)'); 
    24                 $oProc->query('ALTER TABLE calendar_object  ALTER COLUMN range_end TYPE bigint USING (date_part("epoch",(cast(range_end as timestamp)))::int * 1000)'); 
     23                $oProc->query('ALTER TABLE calendar_object  ALTER COLUMN range_start TYPE bigint USING (date_part(\'epoch\',(cast(range_start as timestamp)))::bigint) * 1000'); 
     24                $oProc->query('ALTER TABLE calendar_object  ALTER COLUMN range_end TYPE bigint USING (date_part(\'epoch\',(cast(range_end as timestamp)))::bigint) * 1000'); 
    2525 
    26                 $oProc->query('ALTER TABLE calendar_alarm ALTER COLUMN range_end TYPE bigint USING (date_part("epoch",(cast(range_end as timestamp)))::int) * 1000)'); 
    27                 $oProc->query('ALTER TABLE calendar_alarm ALTER COLUMN range_start TYPE bigint USING (date_part("epoch",(cast(range_start as timestamp)))::int) * 1000)'); 
     26                $oProc->query('ALTER TABLE calendar_alarm ALTER COLUMN range_end TYPE bigint USING (date_part(\'epoch\',(cast(range_end as timestamp)))::bigint) * 1000'); 
     27                $oProc->query('ALTER TABLE calendar_alarm ALTER COLUMN range_start TYPE bigint USING (date_part(\'epoch\',(cast(range_start as timestamp)))::bigint) * 1000'); 
    2828 
    2929                $oProc->query('ALTER TABLE attachment ADD COLUMN owner TYPE int'); 
Note: See TracChangeset for help on using the changeset viewer.