source: companies/serpro/contactcenter/setup/tables_update.inc.php @ 903

<?php
        /**************************************************************************\
        * phpGroupWare - Setup                                                     *
        * http://www.phpgroupware.org                                              *
        * --------------------------------------------                             *
        * This program is free software; you can redistribute it and/or modify it  *
        * under the terms of the GNU General Public License as published by the    *
        * Free Software Foundation; either version 2 of the License, or (at your   *
        * option) any later version.                                               *
        \**************************************************************************/    
        $test[] = '0.4.1';
        function contactcenter_upgrade0_4_1() {
                
                $oProc = $GLOBALS['phpgw_setup']->oProc;
                $oProc->DropTable('phpgw_cc_city');
                $oProc->DropTable('phpgw_cc_state');
                $oProc->CreateTable(
                        'phpgw_cc_state',array(
                                'fd' => array(
                                        'id_state' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
                                        'id_country' => array( 'type' => 'char', 'nullable' => false, 'precision' => 2),
                                        'state_name' => array( 'type' => 'varchar', 'precision' => 30),
                                        'state_symbol' => array( 'type' => 'varchar', 'precision' => 10)
                                ),
                                'pk' => array('id_state'),
                                'fk' => array('id_country' => array('phpgw_common_country_list' => 'id_country')),
                                'ix' => array(),
                                'uc' => array()
                        )
                );
                $oProc->CreateTable(
                        'phpgw_cc_city', array(
                                'fd' => array(
                                        'id_city' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false ),
                                        'id_state' => array( 'type' => 'int', 'precision' => 8 ),
                                        'id_country' => array( 'type' => 'char', 'nullable' => false, 'precision' => 2),
                                        'city_timezone' => array( 'type' => 'int', 'precision' => 2 ),
                                        'city_geo_location' => array(  'type'  => 'varchar', 'precision' => 40 ),
                                        'city_name' => array( 'type'  => 'varchar', 'precision' => 60, 'nullable' => 'false' ),                         
                                ),
                                'pk' => array('id_city'),
                                'fk' => array('id_state'   => array('phpgw_cc_state' => 'id_state')     ),
                                'ix' => array(),
                                'uc' => array()
                        )               
                );              
                
                include("states_pt-br.inc.php"); 
                include("cities_pt-br.inc.php");
                $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.0.0';
                return $GLOBALS['setup_info']['contactcenter']['currentver'];
        }
        $test[] = '1.0.0';
        function contactcenter_upgrade1_0_0() {
                $GLOBALS['setup_info']['contactcenter']['currentver'] = '1.0.005';
                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'];
        }

?>