Changeset 5651
- Timestamp:
- 03/06/12 18:01:43 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/expressoCalendar/setup/tables_update.inc.php
r5650 r5651 15 15 $oProc = $GLOBALS['phpgw_setup']->oProc; 16 16 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 "); 19 20 $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 "); 21 23 22 24 $oProc->query('ALTER TABLE calendar_object ALTER COLUMN range_start TYPE bigint USING (date_part(\'epoch\',(cast(range_start as timestamp)))::bigint) * 1000'); … … 26 28 $oProc->query('ALTER TABLE calendar_alarm ALTER COLUMN range_start TYPE bigint USING (date_part(\'epoch\',(cast(range_start as timestamp)))::bigint) * 1000'); 27 29 28 $oProc->query( 'ALTER TABLE attachment ADD COLUMN owner integer');30 $oProc->query("ALTER TABLE attachment ADD COLUMN owner integer"); 29 31 30 32 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.001';
Note: See TracChangeset
for help on using the changeset viewer.