8.1. Replacing trigger function: $GLOBALS['phpgw_setup']->db->query("CREATE OR REPLACE function share_catalog_delete() returns trigger as '". "begin if old.acl_appname = ''contactcenter'' and old.acl_location!=''run'' then delete from ". "phpgw_cc_contact_rels where id_contact=old.acl_location::bigint and id_related=old.acl_account ". "and id_typeof_contact_relation=1; end if; return new; end;' language 'plpgsql'"); return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.0.000'; function contactcenter_upgrade2_0_000() { $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.0.001'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.0.001'; function contactcenter_upgrade2_0_001() { $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.0.002'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.0.002'; function contactcenter_upgrade2_0_002() { $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.0.003'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.0.003'; function contactcenter_upgrade2_0_003() { $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.0.004'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.0.004'; function contactcenter_upgrade2_0_004() { $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.1.000'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.1.000'; function contactcenter_upgrade2_1_000() { $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN web_page character varying(100)"); $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN corporate_name character varying(100)"); $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN job_title character varying(40)"); $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ADD COLUMN department character varying(30)"); $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.2.000'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.2.000'; function contactcenter_upgrade2_2_000() { $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.2.1'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.2.1'; function contactcenter_upgrade2_2_1() { $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.2.2'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.2.3'; function contactcenter_upgrade2_2_3() { $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cc_contact ALTER COLUMN alias TYPE character varying(100);"); $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.2.3.1'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } $test[] = '2.2.3.1'; function contactcenter_upgrade2_2_3_1() { $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.4.0'; return $GLOBALS['setup_info']['contactcenter']['currentver']; } ?>