Changeset 285 for trunk/contactcenter/setup/tables_update.inc.php

Timestamp:

05/23/08 17:10:39 (16 years ago)

Author:

brunocosta

Message:

Correção dos problemas gerados no commit anterior, a funcionalidade citada no ticket #199 foram temporariamente desativadas.

File:

• trunk/contactcenter/setup/tables_update.inc.php (modified) (1 diff)

trunk/contactcenter/setup/tables_update.inc.php

@@ -56 +56 @@
                 return $GLOBALS['setup_info']['contactcenter']['currentver'];
         }
+        $test[] = '1.0.005';
+        function contactcenter_upgrade1_0_005() {
+                $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.14';
+                return $GLOBALS['setup_info']['contactcenter']['currentver'];
+        }
+        $test[] = '1.14';
+        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';
+                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)");
+
+                $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.20';
+                return $GLOBALS['setup_info']['contactcenter']['currentver'];
+        }
+
 ?>