From 4c159eb4b020d079406e184825ec403b9d24d899 Mon Sep 17 00:00:00 2001 From: Caiwen Zhang Date: Thu, 7 Nov 2013 04:47:15 +0800 Subject: [PATCH] add Finland operators APN settings Change-Id: Ib1b3d94204660f2287d18b4d2be3bd672d34dec5 Signed-off-by: Caiwen Zhang --- resources/dnet_db_data.sql | 14 ++++++++++++-- 1 file changed, 12 insertions(+), 2 deletions(-) diff --git a/resources/dnet_db_data.sql b/resources/dnet_db_data.sql index c59da8e..94043cc 100644 --- a/resources/dnet_db_data.sql +++ b/resources/dnet_db_data.sql @@ -35,6 +35,10 @@ INSERT INTO "network_info" (network_info_id, network_name, mccmnc) VALUES (34, ' INSERT INTO "network_info" (network_info_id, network_name, mccmnc) VALUES (35, 'China Unicom', '46006'); INSERT INTO "network_info" (network_info_id, network_name, mccmnc) VALUES (36, 'China Mobile', '46007'); INSERT INTO "network_info" (network_info_id, network_name, mccmnc) VALUES (37, 'China Tietong', '46020'); +INSERT INTO "network_info" (network_info_id, network_name, mccmnc) VALUES (38, 'Elisa FI', '24405'); +INSERT INTO "network_info" (network_info_id, network_name, mccmnc) VALUES (39, 'DNA', '24412'); +INSERT INTO "network_info" (network_info_id, network_name, mccmnc) VALUES (40, 'Saunalahti', '24421'); +INSERT INTO "network_info" (network_info_id, network_name, mccmnc) VALUES (41, 'Sonera', '24491'); INSERT INTO "max_pdp"(network_info_id, max_pdp_3g) VALUES(1, 2); INSERT INTO "max_pdp"(network_info_id, max_pdp_3g) VALUES(2, 3); @@ -107,5 +111,11 @@ INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, au INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(67, 'China Mobile MMS','cmwap',1,NULL,NULL,1,'10.0.0.172:80','http://mmsc.monternet.com',300,0,0,NULL,0,NULL,NULL,32,2, 0, 1, 0); INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(68, 'China Mobile GPRS','cmnet',0,NULL,NULL,1,NULL,NULL,300,0,0,NULL,0,NULL,NULL,36,1,0,1,1); INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(69, 'China Mobile MMS','cmwap',1,NULL,NULL,1,'10.0.0.172:80','http://mmsc.monternet.com',300,0,0,NULL,0,NULL,NULL,36,2, 0, 1, 0); - - +INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(70, 'Elisa FI Internet','internet',0,NULL,NULL,1,NULL,NULL,300,0,0,NULL,0,NULL,NULL,38,1,0,1,1); +INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(71, 'Elisa FI MMS','mms',0,NULL,NULL,1,'213.161.41.57:80','http://mms.elisa.fi',300,0,0,NULL,0,NULL,NULL,38,1,0,1,0); +INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(72, 'DNA INTERNET','internet',0,NULL,NULL,1,NULL,NULL,300,0,0,NULL,0,NULL,NULL,39,1,0,1,1); +INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(73, 'DNA MMS','mms',1,'dna','mms',1,'10.1.1.2:8080','http://mmsc.dnafinland.fi',300,0,0,NULL,0,NULL,NULL,39,1,0,1,0); +INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(74, 'Saunalahti Internet','internet.saunalahti',0,NULL,NULL,1,NULL,NULL,300,0,0,NULL,0,NULL,NULL,40,1,0,1,1); +INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(75, 'Saunalahti MMS','mms.saunalahti.fi',0,NULL,NULL,1,'62.142.4.197:8080','http://mms.saunalahti.fi:8002',300,0,0,NULL,0,NULL,NULL,40,1,0,1,0); +INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(76, 'Sonera Internet','internet',0,NULL,NULL,1,NULL,NULL,300,0,0,NULL,0,NULL,NULL,41,1,0,1,1); +INSERT INTO "pdp_profile" (profile_id, profile_name, apn, auth_type, auth_id, auth_pwd, 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) VALUES(77, 'Sonera MMS','wap.sonera.net',0,NULL,NULL,1,'195.156.25.33:8080','http://mms.sonera.fi:8002',300,0,0,NULL,0,NULL,NULL,41,1,0,1,0); -- 2.7.4