1 PRAGMA journal_mode = PERSIST;
2 PRAGMA synchronous = OFF;
3 PRAGMA locking_mode = EXCLUSIVE;
4 PRAGMA temp_store = MEMORY;
5 PRAGMA cache_size=-5000;
7 DROP TABLE IF EXISTS "pdp_profile_upgrade";
8 CREATE TABLE pdp_profile_upgrade(
9 profile_id INTEGER PRIMARY KEY,
16 roam_pdp_protocol INTEGER,
20 traffic_class INTEGER,
21 is_static_ip_addr INTEGER,
23 is_static_dns_addr INTEGER,
26 network_info_id INTEGER,
27 svc_category_id INTEGER,
30 default_internet_con INTEGER,
32 is_roaming_apn INTEGER,
33 profile_enable INTEGER
36 INSERT INTO pdp_profile_upgrade
37 SELECT profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, pdp_protocol, pdp_protocol, proxy_ip_addr, home_url, linger_time, traffic_class, is_static_ip_addr, ip_addr, is_static_dns_addr, dns_addr1, dns_addr2, network_info_id, svc_category_id, hidden, editable, default_internet_con, user_defined, is_roaming_apn, profile_enable
40 DROP TABLE 'pdp_profile';
41 ALTER TABLE 'pdp_profile_upgrade' RENAME TO 'pdp_profile';
43 DROP INDEX IF EXISTS "pdp_profile_ix_1";
44 CREATE INDEX pdp_profile_ix_1 ON pdp_profile (network_info_id);