-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.6
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema smsd
--
CREATE DATABASE IF NOT EXISTS smsd;
USE smsd;
--
-- Definition of table `smsd`.`sms_int-dail-code`
--
DROP TABLE IF EXISTS `smsd`.`sms_int-dail-code`;
CREATE TABLE `smsd`.`sms_int-dail-code` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country` char(32) DEFAULT NULL,
`prefix_code` char(8 ) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smsd`.`sms_int-dail-code`
--
/*!40000 ALTER TABLE `sms_int-dail-code` DISABLE KEYS */;
LOCK TABLES `sms_int-dail-code` WRITE;
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (1,'Abkhazia','+7840');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (2,'Afghanistan','+93');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (3,'Albania','+355');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (4,'Algeria','+213');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (5,'American Samoa','+1684');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (6,'ANAC Satellite','+857');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (7,'Andorra','+376');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (8,'Angola','+244');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (9,'Anguilla','+1264');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (10,'Antigua and Barbuda','+1268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (11,'Argentina','+54');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (12,'Armenia','+374');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (13,'Aruba','+297');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (14,'Ascension','+247');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (15,'Australia','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (16,'Australian External Territories','+672');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (17,'Austria','+43');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (18,'Azerbaijan','+994');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (19,'Bahamas','+1242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (20,'Bahrain','+973');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (21,'Bangladesh','+880');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (22,'Barbados','+1246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (23,'Barbuda','+1268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (24,'Belarus','+375');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (25,'Belgium','+32');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (26,'Belize','+501');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (27,'Benin','+229');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (28,'Bermuda','+1441');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (29,'Bhutan','+975');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (30,'Bolivia','+591');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (31,'Bosnia and Herzegovina','+387');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (32,'Botswana','+267');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (33,'Brazil','+55');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (34,'British Indian Ocean Territory','+246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (35,'British Virgin Islands','+1284');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (36,'Brunei','+673');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (37,'Bulgaria','+359');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (38,'Burkina Faso','+226');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (39,'Burundi','+257');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (40,'Cambodia','+855');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (41,'Cameroon','+237');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (42,'Canada','+1');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (43,'Cape Verde','+238');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (44,'Cayman Islands','+1345');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (45,'Central African Republic','+236');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (46,'Chad','+235');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (47,'Chatham Island (New Zealand)','+64');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (48,'Chile','+56');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (49,'China','+86');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (50,'Christmas Island','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (51,'Cocos-Keeling Islands','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (52,'Colombia','+57');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (53,'Comoros','+269');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (54,'Congo','+242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (55,'Congo - Brazzaville','+242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (56,'Congo, Dem. Rep. of (Zaire)','+243');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (57,'Congo - Kinshasa','+243');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (58,'Cook Islands','+682');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (59,'Costa Rica','+506');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (60,'Ivory Coast','+225');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (61,'Croatia','+385');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (62,'Cuba','+53');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (63,'Cuba (Guantanamo Bay)','+5399');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (64,'Curaçao','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (65,'Cyprus','+357');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (66,'Czech Republic','+420');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (67,'Denmark','+45');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (68,'Diego Garcia','+246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (69,'Djibouti','+253');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (70,'Dominica','+1767');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (71,'Dominican Republic','+1809');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (72,'East Timor','+670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (73,'Easter Island','+56');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (74,'Ecuador','+593');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (75,'Egypt','+20');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (76,'El Salvador','+503');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (77,'Ellipso (Mobile Satellite service)','+8812');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (78,'EMSAT (Mobile Satellite service)','+88213');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (79,'Equatorial Guinea','+240');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (80,'Eritrea','+291');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (81,'Estonia','+372');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (82,'Ethiopia','+251');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (83,'Falkland Islands','+500');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (84,'Faroe Islands','+298');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (85,'Fiji','+679');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (86,'Finland','+358');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (87,'France','+33');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (88,'French Antilles','+596');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (89,'French Guiana','+594');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (90,'French Polynesia','+689');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (91,'Gabon','+241');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (92,'Gambia','+220');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (93,'Georgia','+995');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (94,'Germany','+49');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (95,'Ghana','+233');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (96,'Gibraltar','+350');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (97,'Global Mobile Satellite System (GMSS)','+881');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (98,'Globalstar (Mobile Satellite Service)','+8818');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (99,'Greece','+30');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (100,'Greenland','+299');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (101,'Grenada','+1473');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (102,'Guadeloupe','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (103,'Guam','+1671');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (104,'Guantanamo Bay','+5399');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (105,'Guatemala','+502');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (106,'Guinea','+224');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (107,'Guinea-Bissau','+245');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (108,'Guyana','+592');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (109,'Haiti','+509');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (110,'Honduras','+504');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (111,'Hong Kong','+852');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (112,'Hungary','+36');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (113,'Iceland','+354');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (114,'ICO Global (Mobile Satellite Service)','+8810');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (115,'India','+91');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (116,'Indonesia','+62');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (117,'Inmarsat SNAC','+870');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (118,'International Freephone Service','+800');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (119,'International Shared Cost Service (ISCS)','+808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (120,'Iran','+98');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (121,'Iraq','+964');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (122,'Ireland','+353');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (123,'Iridium (Mobile Satellite service)','+8816');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (124,'Israel','+972');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (125,'Italy','+39');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (126,'Jamaica','+1876');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (127,'Japan','+81');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (128,'Jordan','+962');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (129,'Kazakhstan','+76');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (130,'Kenya','+254');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (131,'Kiribati','+686');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (132,'North Korea','+850');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (133,'South Korea','+82');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (134,'Kuwait','+965');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (135,'Kyrgyzstan','+996');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (136,'Laos','+856');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (137,'Latvia','+371');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (138,'Lebanon','+961');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (139,'Lesotho','+266');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (140,'Liberia','+231');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (141,'Libya','+218');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (142,'Liechtenstein','+423');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (143,'Lithuania','+370');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (144,'Luxembourg','+352');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (145,'Macau SAR China','+853');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (146,'Macedonia','+389');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (147,'Madagascar','+261');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (148,'Malawi','+265');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (149,'Malaysia','+60');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (150,'Maldives','+960');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (151,'Mali','+223');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (152,'Malta','+356');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (153,'Marshall Islands','+692');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (154,'Martinique','+596');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (155,'Mauritania','+222');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (156,'Mauritius','+230');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (157,'Mayotte','+262');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (158,'Mexico','+52');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (159,'Micronesia','+691');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (160,'Midway Island','+1808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (161,'Moldova','+373');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (162,'Monaco','+377');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (163,'Mongolia','+976');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (164,'Montenegro','+382');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (165,'Montserrat','+1664');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (166,'Morocco','+212');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (167,'Mozambique','+258');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (168,'Myanmar','+95');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (169,'Namibia','+264');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (170,'Nauru','+674');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (171,'Nepal','+977');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (172,'Netherlands','+31');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (173,'Netherlands Antilles','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (174,'Nevis','+1869');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (175,'New Caledonia','+687');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (176,'New Zealand','+64');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (177,'Nicaragua','+505');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (178,'Niger','+227');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (179,'Nigeria','+234');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (180,'Niue','+683');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (181,'Norfolk Island','+672');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (182,'Northern Mariana Islands','+1670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (183,'Norway','+47');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (184,'Oman','+968');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (185,'Pakistan','+92');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (186,'Palau','+680');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (187,'Palestinian territories','+970');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (188,'Panama','+507');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (189,'Papua New Guinea','+675');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (190,'Paraguay','+595');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (191,'Peru','+51');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (192,'Philippines','+63');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (193,'Poland','+48');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (194,'Portugal','+351');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (195,'Puerto Rico','+1787');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (196,'Qatar','+974');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (197,'Réunion','+262');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (198,'Romania','+40');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (199,'Russia','+7');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (200,'Rwanda','+250');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (201,'Saint Barthélemy','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (202,'Saint Helena','+290');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (203,'Saint Kitts and Nevis','+1869');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (204,'Saint Lucia','+1758');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (205,'Saint Martin','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (206,'Saint Pierre and Miquelon','+508');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (207,'Saint Vincent and the Grenadines','+1784');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (208,'Samoa','+685');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (209,'San Marino','+378');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (210,'São Tomé and Príncipe','+239');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (211,'Saudi Arabia','+966');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (212,'Senegal','+221');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (213,'Serbia','+381');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (214,'Seychelles','+248');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (215,'Sierra Leone','+232');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (216,'Singapore','+65');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (217,'Sint Maarten','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (218,'Slovakia','+421');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (219,'Slovenia','+386');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (220,'Solomon Islands','+677');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (221,'Somalia','+252');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (222,'South Africa','+27');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (223,'South Georgia and the South Sandwich Islands','+500');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (224,'Spain','+34');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (225,'Sri Lanka','+94');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (226,'Sudan','+249');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (227,'Suriname','+597');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (228,'Swaziland','+268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (229,'Sweden','+46');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (230,'Switzerland','+41');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (231,'Syria','+963');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (232,'Taiwan','+886');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (233,'Tajikistan','+992');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (234,'Tanzania','+255');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (235,'Thailand','+66');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (236,'Thuraya (Mobile Satellite service)','+88216');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (237,'Timor-Leste','+670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (238,'Togo','+228');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (239,'Tokelau','+690');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (240,'Tonga','+676');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (241,'Trinidad and Tobago','+1868');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (242,'Tunisia','+216');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (243,'Turkey','+90');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (244,'Turkmenistan','+993');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (245,'Turks and Caicos Islands','+1649');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (246,'Tuvalu','+688');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (247,'Uganda','+256');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (248,'Ukraine','+380');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (249,'United Arab Emirates','+971');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (250,'United Kingdom','+44');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (251,'United States','+1');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (252,'Universal Personal Telecommunications (UPT)','+878');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (253,'Uruguay','+598');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (254,'U.S. Virgin Islands','+1340');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (255,'Uzbekistan','+998');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (256,'Vanuatu','+678');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (257,'Vatican','+39066');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (258,'Venezuela','+58');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (259,'Vietnam','+84');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (260,'Wake Island','+1808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (261,'Wallis and Futuna','+681');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (262,'Yemen','+967');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (263,'Zambia','+260');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (264,'Zanzibar','+255');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (265,'Zimbabwe','+263');
UNLOCK TABLES;
/*!40000 ALTER TABLE `sms_int-dail-code` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
--
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.6
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema smsd
--
CREATE DATABASE IF NOT EXISTS smsd;
USE smsd;
--
-- Definition of table `smsd`.`sms_int-dail-code`
--
DROP TABLE IF EXISTS `smsd`.`sms_int-dail-code`;
CREATE TABLE `smsd`.`sms_int-dail-code` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country` char(32) DEFAULT NULL,
`prefix_code` char(8 ) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `smsd`.`sms_int-dail-code`
--
/*!40000 ALTER TABLE `sms_int-dail-code` DISABLE KEYS */;
LOCK TABLES `sms_int-dail-code` WRITE;
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (1,'Abkhazia','+7840');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (2,'Afghanistan','+93');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (3,'Albania','+355');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (4,'Algeria','+213');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (5,'American Samoa','+1684');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (6,'ANAC Satellite','+857');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (7,'Andorra','+376');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (8,'Angola','+244');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (9,'Anguilla','+1264');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (10,'Antigua and Barbuda','+1268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (11,'Argentina','+54');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (12,'Armenia','+374');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (13,'Aruba','+297');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (14,'Ascension','+247');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (15,'Australia','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (16,'Australian External Territories','+672');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (17,'Austria','+43');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (18,'Azerbaijan','+994');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (19,'Bahamas','+1242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (20,'Bahrain','+973');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (21,'Bangladesh','+880');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (22,'Barbados','+1246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (23,'Barbuda','+1268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (24,'Belarus','+375');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (25,'Belgium','+32');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (26,'Belize','+501');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (27,'Benin','+229');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (28,'Bermuda','+1441');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (29,'Bhutan','+975');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (30,'Bolivia','+591');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (31,'Bosnia and Herzegovina','+387');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (32,'Botswana','+267');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (33,'Brazil','+55');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (34,'British Indian Ocean Territory','+246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (35,'British Virgin Islands','+1284');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (36,'Brunei','+673');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (37,'Bulgaria','+359');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (38,'Burkina Faso','+226');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (39,'Burundi','+257');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (40,'Cambodia','+855');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (41,'Cameroon','+237');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (42,'Canada','+1');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (43,'Cape Verde','+238');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (44,'Cayman Islands','+1345');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (45,'Central African Republic','+236');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (46,'Chad','+235');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (47,'Chatham Island (New Zealand)','+64');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (48,'Chile','+56');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (49,'China','+86');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (50,'Christmas Island','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (51,'Cocos-Keeling Islands','+61');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (52,'Colombia','+57');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (53,'Comoros','+269');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (54,'Congo','+242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (55,'Congo - Brazzaville','+242');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (56,'Congo, Dem. Rep. of (Zaire)','+243');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (57,'Congo - Kinshasa','+243');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (58,'Cook Islands','+682');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (59,'Costa Rica','+506');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (60,'Ivory Coast','+225');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (61,'Croatia','+385');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (62,'Cuba','+53');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (63,'Cuba (Guantanamo Bay)','+5399');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (64,'Curaçao','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (65,'Cyprus','+357');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (66,'Czech Republic','+420');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (67,'Denmark','+45');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (68,'Diego Garcia','+246');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (69,'Djibouti','+253');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (70,'Dominica','+1767');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (71,'Dominican Republic','+1809');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (72,'East Timor','+670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (73,'Easter Island','+56');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (74,'Ecuador','+593');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (75,'Egypt','+20');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (76,'El Salvador','+503');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (77,'Ellipso (Mobile Satellite service)','+8812');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (78,'EMSAT (Mobile Satellite service)','+88213');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (79,'Equatorial Guinea','+240');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (80,'Eritrea','+291');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (81,'Estonia','+372');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (82,'Ethiopia','+251');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (83,'Falkland Islands','+500');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (84,'Faroe Islands','+298');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (85,'Fiji','+679');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (86,'Finland','+358');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (87,'France','+33');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (88,'French Antilles','+596');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (89,'French Guiana','+594');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (90,'French Polynesia','+689');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (91,'Gabon','+241');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (92,'Gambia','+220');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (93,'Georgia','+995');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (94,'Germany','+49');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (95,'Ghana','+233');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (96,'Gibraltar','+350');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (97,'Global Mobile Satellite System (GMSS)','+881');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (98,'Globalstar (Mobile Satellite Service)','+8818');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (99,'Greece','+30');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (100,'Greenland','+299');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (101,'Grenada','+1473');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (102,'Guadeloupe','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (103,'Guam','+1671');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (104,'Guantanamo Bay','+5399');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (105,'Guatemala','+502');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (106,'Guinea','+224');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (107,'Guinea-Bissau','+245');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (108,'Guyana','+592');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (109,'Haiti','+509');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (110,'Honduras','+504');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (111,'Hong Kong','+852');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (112,'Hungary','+36');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (113,'Iceland','+354');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (114,'ICO Global (Mobile Satellite Service)','+8810');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (115,'India','+91');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (116,'Indonesia','+62');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (117,'Inmarsat SNAC','+870');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (118,'International Freephone Service','+800');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (119,'International Shared Cost Service (ISCS)','+808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (120,'Iran','+98');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (121,'Iraq','+964');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (122,'Ireland','+353');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (123,'Iridium (Mobile Satellite service)','+8816');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (124,'Israel','+972');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (125,'Italy','+39');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (126,'Jamaica','+1876');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (127,'Japan','+81');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (128,'Jordan','+962');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (129,'Kazakhstan','+76');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (130,'Kenya','+254');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (131,'Kiribati','+686');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (132,'North Korea','+850');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (133,'South Korea','+82');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (134,'Kuwait','+965');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (135,'Kyrgyzstan','+996');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (136,'Laos','+856');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (137,'Latvia','+371');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (138,'Lebanon','+961');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (139,'Lesotho','+266');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (140,'Liberia','+231');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (141,'Libya','+218');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (142,'Liechtenstein','+423');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (143,'Lithuania','+370');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (144,'Luxembourg','+352');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (145,'Macau SAR China','+853');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (146,'Macedonia','+389');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (147,'Madagascar','+261');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (148,'Malawi','+265');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (149,'Malaysia','+60');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (150,'Maldives','+960');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (151,'Mali','+223');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (152,'Malta','+356');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (153,'Marshall Islands','+692');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (154,'Martinique','+596');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (155,'Mauritania','+222');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (156,'Mauritius','+230');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (157,'Mayotte','+262');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (158,'Mexico','+52');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (159,'Micronesia','+691');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (160,'Midway Island','+1808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (161,'Moldova','+373');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (162,'Monaco','+377');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (163,'Mongolia','+976');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (164,'Montenegro','+382');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (165,'Montserrat','+1664');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (166,'Morocco','+212');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (167,'Mozambique','+258');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (168,'Myanmar','+95');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (169,'Namibia','+264');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (170,'Nauru','+674');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (171,'Nepal','+977');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (172,'Netherlands','+31');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (173,'Netherlands Antilles','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (174,'Nevis','+1869');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (175,'New Caledonia','+687');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (176,'New Zealand','+64');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (177,'Nicaragua','+505');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (178,'Niger','+227');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (179,'Nigeria','+234');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (180,'Niue','+683');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (181,'Norfolk Island','+672');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (182,'Northern Mariana Islands','+1670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (183,'Norway','+47');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (184,'Oman','+968');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (185,'Pakistan','+92');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (186,'Palau','+680');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (187,'Palestinian territories','+970');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (188,'Panama','+507');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (189,'Papua New Guinea','+675');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (190,'Paraguay','+595');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (191,'Peru','+51');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (192,'Philippines','+63');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (193,'Poland','+48');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (194,'Portugal','+351');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (195,'Puerto Rico','+1787');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (196,'Qatar','+974');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (197,'Réunion','+262');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (198,'Romania','+40');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (199,'Russia','+7');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (200,'Rwanda','+250');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (201,'Saint Barthélemy','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (202,'Saint Helena','+290');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (203,'Saint Kitts and Nevis','+1869');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (204,'Saint Lucia','+1758');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (205,'Saint Martin','+590');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (206,'Saint Pierre and Miquelon','+508');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (207,'Saint Vincent and the Grenadines','+1784');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (208,'Samoa','+685');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (209,'San Marino','+378');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (210,'São Tomé and Príncipe','+239');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (211,'Saudi Arabia','+966');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (212,'Senegal','+221');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (213,'Serbia','+381');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (214,'Seychelles','+248');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (215,'Sierra Leone','+232');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (216,'Singapore','+65');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (217,'Sint Maarten','+599');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (218,'Slovakia','+421');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (219,'Slovenia','+386');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (220,'Solomon Islands','+677');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (221,'Somalia','+252');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (222,'South Africa','+27');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (223,'South Georgia and the South Sandwich Islands','+500');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (224,'Spain','+34');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (225,'Sri Lanka','+94');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (226,'Sudan','+249');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (227,'Suriname','+597');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (228,'Swaziland','+268');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (229,'Sweden','+46');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (230,'Switzerland','+41');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (231,'Syria','+963');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (232,'Taiwan','+886');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (233,'Tajikistan','+992');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (234,'Tanzania','+255');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (235,'Thailand','+66');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (236,'Thuraya (Mobile Satellite service)','+88216');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (237,'Timor-Leste','+670');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (238,'Togo','+228');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (239,'Tokelau','+690');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (240,'Tonga','+676');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (241,'Trinidad and Tobago','+1868');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (242,'Tunisia','+216');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (243,'Turkey','+90');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (244,'Turkmenistan','+993');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (245,'Turks and Caicos Islands','+1649');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (246,'Tuvalu','+688');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (247,'Uganda','+256');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (248,'Ukraine','+380');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (249,'United Arab Emirates','+971');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (250,'United Kingdom','+44');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (251,'United States','+1');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (252,'Universal Personal Telecommunications (UPT)','+878');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (253,'Uruguay','+598');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (254,'U.S. Virgin Islands','+1340');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (255,'Uzbekistan','+998');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (256,'Vanuatu','+678');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (257,'Vatican','+39066');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (258,'Venezuela','+58');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (259,'Vietnam','+84');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (260,'Wake Island','+1808');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (261,'Wallis and Futuna','+681');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (262,'Yemen','+967');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (263,'Zambia','+260');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (264,'Zanzibar','+255');
INSERT INTO `smsd`.`sms_int-dail-code` VALUES (265,'Zimbabwe','+263');
UNLOCK TABLES;
/*!40000 ALTER TABLE `sms_int-dail-code` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Have fun with it