全球80%地区代码 包含中国，sql文件

/* SQLyog Ultimate v13.1.1 (64 bit) MySQL - 5.7.43 : Database - area_code_base ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`area_code_base` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `area_code_base`; /*Table structure for table `Turks_and_Caicos_Islands` */ DROP TABLE IF EXISTS `Turks_and_Caicos_Islands`; CREATE TABLE `Turks_and_Caicos_Islands` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pareat_id` int(11) DEFAULT NULL, `domestic_destination_code` varchar(255) DEFAULT NULL COMMENT '国内目的地代码', `area_name` varchar(255) DEFAULT NULL COMMENT '地区名称', `municipalities` varchar(255) DEFAULT NULL COMMENT '城市', `sn_from` varchar(255) DEFAULT NULL COMMENT 'Sn from', `sn_to` varchar(255) DEFAULT NULL COMMENT ' Sn to', `operator_name` varchar(255) DEFAULT NULL COMMENT '运营商名称', `number_type` varchar(255) DEFAULT NULL COMMENT '号码类型', PRIMARY KEY (`id`), KEY `country_code_fk_Turks_and_Caicos_Islands` (`pareat_id`), CONSTRAINT `country_code_fk_Turks_and_Caicos_Islands` FOREIGN KEY (`pareat_id`) REFERENCES `country_code` (`sn`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4; /*Data for the table `Turks_and_Caicos_Islands` */ insert into `Turks_and_Caicos_Islands`(`id`,`pareat_id`,`domestic_destination_code`,`area_name`,`municipalities`,`sn_from`,`sn_to`,`operator_name`,`number_type`) values (1,245,'649','','Grand Turk','2310000','2319999','CABLE & WIRELESS TC','M'), (2,245,'649','','Grand Turk','2320000','2329999','CABLE & WIRELESS TC','M'), (3,245,'649','','Grand Turk','2390000','2399999','CABLE & WIRELESS TC','M'), (4,245,'649','','Grand Turk','2410000','2419999','CABLE & WIRELESS TC','M'), (5,245,'649','','Grand Turk','2420000','2429999','CABLE & WIRELESS TC','M'), (6,245,'649','','Grand Turk','2430000','2439999','CABLE & WIRELESS TC','M'), (7,245,'649','','Grand Turk','2440000','2449999','CABLE & WIRELESS TC','M'), (8,245,'649','','Grand Turk','2450000','2459999','CABLE & WIRELESS TC','M'), (9,245,'649','','Grand Turk','2460000','2469999','CABLE & WIRELESS TC','M'), (10,245,'649','','Grand Turk','2470000','2479999','CABLE & WIRELESS TC','M'), (11,245,'649','','Provindenciales','3310000','3319999','DIGICEL (CAYMAN)','M'), (12,245,'649','','Provindenciales','3320000','3329999','DIGICEL (CAYMAN)','M'), (13,245,'649','','Provindenciales','3330000','3339999','DIGICEL (CAYMAN)','M'), (14,245,'649','','Grand Turk','3380000','3389999','DIGICEL (CAYMAN)','M'), (15,245,'649','','Provindenciales','3390000','3399999','DIGICEL (CAYMAN)','M'), (16,245,'649','','Provindenciales','3410000','3419999','DIGICEL (CAYMAN)','M'), (17,245,'649','','Provindenciales','3420000','3429999','DIGICEL (CAYMAN)','M'), (18,245,'649','','Provindenciales','3430000','3439999','DIGICEL (CAYMAN)','M'), (19,245,'649','','Provindenciales','3440000','3449999','DIGICEL (CAYMAN)','M'), (20,245,'649','','Provindenciales','3450000','3459999','DIGICEL (CAYMAN)','M'), (21,245,'649','','Provindenciales','3460000','3469999','DIGICEL (CAYMAN)','M'), (22,245,'649','','Provindenciales','3470000','3479999','DIGICEL (CAYMAN)','M'), (23,245,'649','','Grand Turk','4310000','4319999','ISLANDCOM TELECOM','M'), (24,245,'649','','Grand Turk','4320000','4329999','ISLANDCOM TELECOM','M'), (25,245,'649','','Grand Turk','4330000','4339999','ISLANDCOM TELECOM','M'), (26,245,'649','','Grand Turk','4410000','4419999','ISLANDCOM TELECOM','M'), (27,245,'649','','Grand Turk','4420000','4429999','ISLANDCOM TELECOM','M'), (28,245,'649','','Grand Turk','4430000','4439999','ISLANDCOM TELECOM','M'), (29,245,'649','','Grand Turk','4440000','4449999','CABLE & WIRELESS TC','G'), (30,245,'649','','Grand Turk','4450000','4459999','CABLE & WIRELESS TC','G'), (31,245,'649','','Grand Turk','4460000','4469999','CABLE & WIRELESS TC','G'), (32,245,'649','','Directory Assistance','5551212','5551212','MULTIPLE OCN LISTING','O'), (33,245,'649','','Provindenciales','9400000','9409999','CABLE & WIRELESS TC','G'), (34,245,'649','','Provindenciales','9410000','9419999','CABLE & WIRELESS TC','G'), (35,245,'649','','Provindenciales','9420000','9429999','CABLE & WIRELESS TC','G'), (36,245,'649','','Provindenciales','9430000','9439999','CABLE & WIRELESS TC','G'), (37,245,'649','','Provindenciales','9440000','9449999','CABLE & WIRELESS TC','G'), (38,245,'649','','Provindenciales','9450000','9459999','CABLE & WIRELESS TC','G'), (39,245,'649','','Grand Turk','9460000','9469999','CABLE & WIRELESS TC','G'), (40,245,'649','','Provindenciales','9470000','9479999','CABLE & WIRELESS TC','G'), (41,245,'649','','Provindenciales','9480000','9489999','CABLE & WIRELESS TC','G'), (42,245,'649','','Provindenciales','9490000','9499999','CABLE & WIRELESS TC','G'), (43,245,'649','','Provindenciales','9500000','9509999','CABLE & WIRELESS TC','G'), (44,245,'649','','Grand Turk','9660000','9669999','CABLE & WIRELESS TC','M'); /*Table structure for table `afghanistan` */ DROP TABLE IF EXISTS `afghanistan`; CREATE TABLE `afghanistan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pareat_id` int(11) DEFAULT NULL, `domestic_destination_code` varchar(255) DEFAULT NULL COMMENT '国内目的地代码', `area_name` varchar(255) DEFAULT NULL COMMENT '地区名称', `municipalities` varchar(255) DEFAULT NULL COMMENT '城市', `sn_from` varchar(255) DEFAULT NULL COMMENT 'Sn from', `sn_to` varchar(255) DEFAULT NULL COMMENT ' Sn to', `operator_name` varchar(255) DEFAULT NULL COMMENT '运营商名称', `number_type` varchar(255) DEFAULT NULL COMMENT '号码类型', PRIMARY KEY (`id`), KEY `country_code_fk_afghanistan` (`pareat_id`), CONSTRAINT `country_code_fk_afghanistan` FOREIGN KEY (`pareat_id`) REFERENCES `country_code` (`sn`) ) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4; /*Data for the table `afghanistan` */ insert into `afghanistan`(`id`,`pareat_id`,`domestic_destination_code`,`area_name`,`municipalities`,`sn_from`,`sn_to`,`operator_name`,`number_type`) values (1,2,'20',NULL,'Kabul','2000000','9999999','Afghan Telecom','G'), (2,2,'21',NULL,'Parwan','2000000','9999999','Afghan Telecom','G'), (3,2,'22',NULL,'Kapisa','2000000','9999999','Afghan Telecom','G'), (47,2,'23',NULL,'Bamyan','2000000','9999999','Afghan Telecom','G'), (48,2,'24',NULL,'Wardak','2000000','9999999','Afghan Telecom','G'), (49,2,'25',NULL,'Logar','2000000','9999999','Afghan Telecom','G'), (50,2,'26',NULL,'Daykundi','2000000','9999999','Afghan Telecom','G'), (51,2,'27',NULL,'Khost','2000000','9999999','Afghan Telecom','G'), (52,2,'28',NULL,'Panjshar','2000000','9999999','Afghan Telecom',' G'), (53,2,'30',NULL,'Kandahar','2000000','9999999','Afghan Telecom','G'), (54,2,'31',NULL,'Ghazni','2000000','9999999','Afghan Telecom','G'), (55,2,'32',NULL,'Uruzgan',' 2000000','9999999','Afghan Telecom','G'), (56,2,'33',NULL,'Zabul','2000000','9999999','Afghan Telecom ','G'), (57,2,'34',NULL,'Helmand','2000000','9999999','Afghan Telecom','G'), (58,2,'40',NULL,'Herat','2000000','9999999','Afghan Telecom','G'), (59,2,'41',NULL,'Badghis','2000000','9999999','Afghan Telecom','G'), (60,2,'42',NULL,'Ghor','2000000','9999999','Afghan Telecom','G'), (61,2,'43',NULL,'Farah','2000000','9999999','Afghan Telecom','G'), (62,2,'44',NULL,'Nimruz','2000000','9999999','Afghan Telecom','G'), (63,2,'50',NULL,'Balkh','2000000','9999999','Afghan Telecom','G'), (64,2,'51',NULL,'Kunduz','2000000','9999999','Afghan Telecom','G'), (65,2,'52',NULL,'Badkhshan ','2000000','9999999','Afghan Telecom','G'