Changeset 284 for trunk/contactcenter/setup/tables_update.inc.php
- Timestamp:
- 05/21/08 16:56:17 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/contactcenter/setup/tables_update.inc.php
r203 r284 56 56 return $GLOBALS['setup_info']['contactcenter']['currentver']; 57 57 } 58 $test[] = '1.0.005';59 function contactcenter_upgrade1_0_005() {60 $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.14';61 return $GLOBALS['setup_info']['contactcenter']['currentver'];62 }63 $test[] = '1.14';64 function contactcenter_upgrade1_14() {65 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_connections ALTER COLUMN connection_value TYPE varchar(100)");66 $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.150';67 return $GLOBALS['setup_info']['contactcenter']['currentver'];68 }69 $test[] = '1.15';70 function contactcenter_upgrade1_15() {71 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar");72 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision)");73 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN category character varying(20)");74 75 $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.20';76 return $GLOBALS['setup_info']['contactcenter']['currentver'];77 }78 79 58 ?>
Note: See TracChangeset
for help on using the changeset viewer.