- Timestamp:
- 06/10/08 16:38:48 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/contactcenter/setup/tables_update.inc.php
r307 r308 64 64 function contactcenter_upgrade1_14() { 65 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.15 0';66 $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.15'; 67 67 return $GLOBALS['setup_info']['contactcenter']['currentver']; 68 68 } 69 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)"); 70 function contactcenter_upgrade1_15() { 71 $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cc_contact','last_status', array('type' => 'char', 'precision' => 1, 'default' => 'N')); 72 $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cc_contact','category', array('type' => 'varchar', 'precision' => 20)); 73 $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)") 74 or die("Coluna last_update criada anteriormente."); 74 75 75 76 $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.20'; … … 81 82 return $GLOBALS['setup_info']['contactcenter']['currentver']; 82 83 } 83 84 84 ?>
Note: See TracChangeset
for help on using the changeset viewer.