add Finland operators APN settings

Change-Id: Ib1b3d94204660f2287d18b4d2be3bd672d34dec5
Signed-off-by: Caiwen Zhang <caiwen.zhang@intel.com>

diff --git a/resources/dnet_db_data.sql b/resources/dnet_db_data.sql
index c59da8e..94043cc 100644 (file)
--- 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);