Changeset 5645
- Timestamp:
- 03/06/12 16:07:18 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/expressoCalendar/setup/tables_update.php
r5618 r5645 21 21 $oProc->query('UPDATE calendar_participant SET acl = "rowi" where is_organizer = 1 '); 22 22 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'); 25 25 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'); 28 28 29 29 $oProc->query('ALTER TABLE attachment ADD COLUMN owner TYPE int');
Note: See TracChangeset
for help on using the changeset viewer.