Changeset 308 for trunk/contactcenter

Timestamp:

06/10/08 16:38:48 (16 years ago)

Author:

niltonneto

Message:

• Alteração para criar colunas usando função da API.
• Tratamento de erro para criação de coluna usando dbQuery.

File:

• trunk/contactcenter/setup/tables_update.inc.php (modified) (2 diffs)

trunk/contactcenter/setup/tables_update.inc.php

@@ -64 +64 @@
         function contactcenter_upgrade1_14() {                          
                 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_connections ALTER COLUMN connection_value TYPE varchar(100)");
-                $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.150';
+                $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.15';
                 return $GLOBALS['setup_info']['contactcenter']['currentver'];
         }
         $test[] = '1.15';
-        function contactcenter_upgrade1_15() {
-                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar");
-                $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)");
-                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN category character varying(20)");
+        function contactcenter_upgrade1_15() {          
+                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cc_contact','last_status', array('type' => 'char', 'precision' => 1, 'default' => 'N'));
+                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cc_contact','category', array('type' => 'varchar', 'precision' => 20));
+                $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)")
+                 or die("Coluna last_update criada anteriormente.");
 
                 $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.20';
@@ -81 +82 @@
                 return $GLOBALS['setup_info']['contactcenter']['currentver'];
         }
-
 ?>