Changeset 204 for trunk/calendar/setup/tables_update.inc.php
- Timestamp:
- 03/05/08 16:23:24 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/calendar/setup/tables_update.inc.php
r166 r204 20 20 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.21'; 21 21 return $GLOBALS['setup_info']['calendar']['currentver']; 22 } 23 $test[] = '0.9.20'; 24 function calendar_upgrade0_9_20() 25 { 26 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.21'; 27 return $GLOBALS['setup_info']['calendar']['currentver']; 22 28 } 29 $test[] = '0.9.21'; 30 function calendar_upgrade0_9_21() 31 { 32 /* 33 $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cal','last_status',array( 34 'type' => 'char', 35 'precision' => '1', 36 'default' => 'N::bpchar')); 37 $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cal','last_update',array( 38 'type' => 'int8', 39 'precision' => '8', 40 'default' => '(date_part(\'epoch\'::text, (\'now\'::text)::timestamp(3) with time zone) * (1000)::double precision)')); 41 */ 42 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar"); 43 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision)"); 44 45 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.22'; 46 return $GLOBALS['setup_info']['calendar']['currentver']; 47 } 48 23 49 ?>
Note: See TracChangeset
for help on using the changeset viewer.