-- --------------------------------------------------------
-- 主机: localhost
-- 服务器版本: 5.7.14 - MySQL Community Server (GPL)
-- 服务器操作系统: Win32
-- HeidiSQL 版本: 9.5.0.5196
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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' */;
-- 导出 表 buc09.mstr_country 结构
CREATE TABLE IF NOT EXISTS `mstr_country` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`EN_NAME` varchar(255) DEFAULT NULL COMMENT '国家名称英文',
`CN_NAME` varchar(255) DEFAULT NULL COMMENT '国家名称中文',
`CODE` varchar(255) DEFAULT NULL COMMENT '编号(简称)',
`AREA_CODE` varchar(255) DEFAULT NULL COMMENT '区号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=243 DEFAULT CHARSET=utf8 COMMENT='国际电话号码区号';
-- 正在导出表 buc09.mstr_country 的数据:~242 rows (大约)
DELETE FROM `mstr_country`;
/*!40000 ALTER TABLE `mstr_country` DISABLE KEYS */;
INSERT INTO `mstr_country` (`id`, `EN_NAME`, `CN_NAME`, `CODE`, `AREA_CODE`) VALUES
(1, 'Afghanistan', '阿富汗', 'AF', '93'),
(2, 'Albania', '阿尔巴尼亚', 'AL', '355'),
(3, 'Algeria', '阿尔及利亚', 'DZ', '213'),
(4, 'American Samoa', '萨摩亚', 'AS', '684'),
(5, 'Andorra', '安道尔共和国', 'AD', '376'),
(6, 'Angola', '安哥拉', 'AO', '244'),
(7, 'Anguilla', '安圭拉', 'AI', '1-264'),
(8, 'Antarctica', '南极洲', 'AQ', '672'),
(9, 'Antigua and Barbuda', '安提瓜和巴布达', 'AG', '1-268'),
(10, 'Argentina', '阿根廷', 'AR', '54'),
(11, 'Armenia', '亚美尼亚', 'AM', '374'),
(12, 'Aruba', '阿鲁巴', 'AW', '297'),
(13, 'Australia', '澳大利亚', 'AU', '61'),
(14, 'Austria', '奥地利', 'AT', '43'),
(15, 'Azerbaijan', '阿塞拜疆', 'AZ', '994'),
(16, 'Bahamas', '巴哈马', 'BS', '1-242'),
(17, 'Bahrain', '巴林', 'BH', '973'),
(18, 'Bangladesh', '孟加拉国', 'BD', '880'),
(19, 'Barbados', '巴巴多斯', 'BB', '1-246'),
(20, 'Belarus', '白俄罗斯', 'BY', '375'),
(21, 'Belgium', '比利时', 'BE', '32'),
(22, 'Belize', '伯利兹城', 'BZ', '501'),
(23, 'Benin', '贝宁', 'BJ', '229'),
(24, 'Bermuda', '百慕大', 'BM', '1-441'),
(25, 'Bhutan', '不丹', 'BT', '975'),
(26, 'Bolivia', '玻利维亚', 'BO', '591'),
(27, 'Bosnia and Herzegovina', '波斯尼亚和黑塞哥维那', 'BA', '387'),
(28, 'Botswana', '博茨瓦纳', 'BW', '267'),
(29, 'Bouvet Island', '布维岛', 'BV', ''),
(30, 'Brazil', '巴西', 'BR', '55'),
(31, 'British Indian Ocean Territory', '英属印度洋领地', 'IO', '1-284'),
(32, 'Brunei Darussalam', '文莱达鲁萨兰国', 'BN', '673'),
(33, 'Bulgaria', '保加利亚', 'BG', '359'),
(34, 'Burkina Faso', '布基纳法索', 'BF', '226'),
(35, 'Burundi', '布隆迪', 'BI', '257'),
(36, 'Cambodia', '柬埔寨', 'KH', '855'),
(37, 'Cameroon', '喀麦隆', 'CM', '237'),
(38, 'Canada', '加拿大', 'CA', '1'),
(39, 'Cape Verde', '佛得角', 'CV', '238'),
(40, 'Cayman Islands', '开曼群岛', 'KY', '1-345'),
(41, 'Central African Republic', '中非共和国', 'CF', '236'),
(42, 'Chad', '乍得', 'TD', '235'),
(43, 'Chile', '智利', 'CL', '56'),
(44, 'China', '中国', 'CN', '86'),
(45, 'Christmas Island', '圣延岛', 'CX', '61'),
(46, 'Cocos (Keeling) Islands', '科科斯群岛', 'CC', '61'),
(47, 'Colombia', '哥伦比亚', 'CO', '57'),
(48, 'Comoros', '科摩罗', 'KM', '269'),
(49, 'Congo', '刚果', 'CG', '242'),
(50, 'Congo, The Democratic Republic Of The', '刚果民主共和国', 'ZR', '243'),
(51, 'Cook Islands', '库克群岛', 'CK', '682'),
(52, 'Costa Rica', '哥斯达黎加', 'CR', '506'),
(53, 'Cote D\'Ivoire', 'Cote D\'Ivoire', 'CI', '225'),
(54, 'Croatia (local name: Hrvatska)', '克罗地亚', 'HR', '385'),
(55, 'Cuba', '古巴', 'CU', '53'),
(56, 'Cyprus', '塞浦路斯', 'CY', '357'),
(57, 'Czech Republic', '捷克', 'CZ', '420'),
(58, 'Denmark', '丹麦', 'DK', '45'),
(59, 'Djibouti', '吉布提', 'DJ', '253'),
(60, 'Dominica', '多米尼克国', 'DM', '1-767'),
(61, 'Dominican Republic', '多米尼加共和国', 'DO', '1-809'),
(62, 'East Timor', '东帝汶', 'TP', '670'),
(63, 'Ecuador', '厄瓜多尔', 'EC', '593'),
(64, 'Egypt', '埃及', 'EG', '20'),
(65, 'El Salvador', '萨尔瓦多', 'SV', '503'),
(66, 'Equatorial Guinea', '赤道几内亚', 'GQ', '240'),
(67, 'Eritrea', '厄立特里亚国', 'ER', '291'),
(68, 'Estonia', '爱沙尼亚', 'EE', '372'),
(69, 'Ethiopia', '埃塞俄比亚', 'ET', '251'),
(70, 'Falkland Islands (Malvinas)', '福克兰群岛', 'FK', '500'),
(71, 'Faroe Islands', '法罗群岛', 'FO', '298'),
(72, 'Fiji', '斐济', 'FJ', '679'),
(73, 'Finland', '芬兰', 'FI', '358'),
(74, 'France', '法国', 'FR', '33'),
(75, 'France Metropolitan', '法国大都会', 'FX', '33'),
(76, 'French Guiana', '法属圭亚那', 'GF', '594'),
(77, 'French Polynesia', '法属玻里尼西亚', 'PF', '689'),
(78, 'French Southern Territories', 'French Southern Territories', 'TF', ''),
(79, 'Gabon', '加蓬', 'GA', '241'),
(80, 'Gambia', ' 冈比亚', 'GM', '220'),
(81, 'Georgia', '格鲁吉亚', 'GE', '995'),
(82, 'Germany', '德国', 'DE', '49'),
(83, 'Ghana', '加纳', 'GH', '233'),
(84, 'Gibraltar', '直布罗陀', 'GI', '350'),
(85, 'Greece', '希腊', 'GR', '30'),
(86, 'Greenland', '格陵兰', 'GL', '299'),
(87, 'Grenada', '格林纳达', 'GD', '1-473'),
(88, 'Guadeloupe', '瓜德罗普岛', 'GP', '590'),
(89, 'Guam', '关岛', 'GU', '1-671'),
(90, 'Guatemala', '危地马拉', 'GT', '502'),
(91, 'Guinea', '几内亚', 'GN', '224'),
(92, 'Guinea-Bissau', '几内亚比绍', 'GW', '245'),
(93, 'Guyana', '圭亚那', 'GY', '592'),
(94, 'Haiti', '海地', 'HT', '509'),
(95, 'Heard and Mc Donald Islands', 'Heard and Mc Donald Islands', 'HM', ''),
(96, 'Honduras', '洪都拉斯', 'HN', '504'),
(97, 'Hong Kong', '香港', 'HK', '852'),
(98, 'Hungary', '匈牙利', 'HU', '36'),
(99, 'Iceland', '冰岛', 'IS', '354'),
(100, 'India', '印度', 'IN', '91'),
(101, 'Indonesia', '印度尼西亚', 'ID', '62'),
(102, 'Iran (Islamic Republic of)', 'Iran (Islamic Republic of)', 'IR', '98'),
(103, 'Iraq', '伊拉克', 'IQ', '964'),
(104, 'Ireland', '爱尔兰', 'IE', '353'),
(105, 'Isle of Man', '英国属地曼岛', 'IM', ''),
(106, 'Israel', '以色列', 'IL', '972'),
(107, 'Italy', '意大利', 'IT', '39'),
(108, 'Jamaica', '牙买加', 'JM', '1-876'),
(109, 'Japan', '日本', 'JP', '81'),
(110, 'Jordan', '约旦', 'JO', '962'),
(111, 'Kazakhstan', '哈萨克', 'KZ', '7'),
(112, 'Kenya', '肯尼亚', 'KE', '254'),
(113, 'Kiribati', '吉尔巴斯', 'KI', '686'),
(114, 'Kuwait', '科威特', 'KW', '965'),
(115, 'Kyrgyzstan', '吉尔吉斯', 'KG', '996'),
(116, 'Lao People\'s Democratic Republic', 'Lao People\'s Democratic Republic', 'LA', ''),
(117, 'Latvia', '拉脱维亚', 'LV', '371'),
(118, 'Lebanon', '黎巴嫩', 'LB', '961'),
(119, 'Lesotho', '莱索托', 'LS', '266'),
(120, 'Liberia', '利比里亚', 'LR', '231'),
(121, 'Libyan Arab Jamahiriya', '利比亚', 'LY', '218'),
(122, 'Liechtenstein', '列支敦士登', 'LI', '423'),
(123, 'Lithuania', '立陶宛', 'LT', '370'),
(124, 'Luxembourg', '卢森堡', 'LU', '352'),
(125, 'Macau', '澳门地区', 'MO', '853'),
(126, 'Madagascar', '马达加斯加', 'MG', '261'),
(127, 'Malawi', '马拉维', 'MW', '265'),
(128, 'Malaysia', '马来西亚', 'MY', '60'),
(129, 'Maldives', '马尔代夫', 'MV', '960'),
(130, 'Mali', '马里', 'ML', '223'),
(131, 'Malta', '马尔他', 'MT', '356'),