/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80021
Source Host : localhost:3306
Source Schema : ywb_dictionary
Target Server Type : MySQL
Target Server Version : 80021
File Encoding : 65001
Date: 20/01/2022 09:35:54
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for base_currency
-- ----------------------------
DROP TABLE IF EXISTS `base_country`;
CREATE TABLE `base_country` (
`country_code` int(5) DEFAULT NULL COMMENT '国家代码',,
`two_letter` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '两位字母的国家代码',
`three_letter` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '三位字母的国家代码',
`country_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家名称'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of base_currency
-- ----------------------------
insert into `base_country` VALUES(20 , 'AD', 'AND', '安道尔');
insert into `base_country` VALUES(784 , 'AE', 'ARE', '阿联酋');
insert into `base_country` VALUES(4 , 'AF', 'AFG', '阿富汗');
insert into `base_country` VALUES(28 , 'AG', 'ATG', '安提瓜和巴布达');
insert into `base_country` VALUES(660 , 'AI', 'AIA', '安圭拉');
insert into `base_country` VALUES(8 , 'AL', 'ALB', '阿尔巴尼亚');
insert into `base_country` VALUES(51 , 'AM', 'ARM', '亚美尼亚');
insert into `base_country` VALUES(24 , 'AO', 'AGO', '安哥拉');
insert into `base_country` VALUES(10 , 'AQ', 'ATA', '南极洲');
insert into `base_country` VALUES(32 , 'AR', 'ARG', '阿根廷');
insert into `base_country` VALUES(16 , 'AS', 'ASM', '美属萨摩亚');
insert into `base_country` VALUES(40 , 'AT', 'AUT', '奥地利');
insert into `base_country` VALUES(36 , 'AU', 'AUS', '澳大利亚');
insert into `base_country` VALUES(533 , 'AW', 'ABW', '阿鲁巴');
insert into `base_country` VALUES(248 , 'AX', 'ALA', '奥兰');
insert into `base_country` VALUES(31 , 'AZ', 'AZE', '阿塞拜疆');
insert into `base_country` VALUES(70 , 'BA', 'BIH', '波斯尼亚和黑塞哥维那');
insert into `base_country` VALUES(52 , 'BB', 'BRB', '巴巴多斯');
insert into `base_country` VALUES(50 , 'BD', 'BGD', '孟加拉');
insert into `base_country` VALUES(56 , 'BE', 'BEL', '比利时');
insert into `base_country` VALUES(854 , 'BF', 'BFA', '布基纳法索');
insert into `base_country` VALUES(100 , 'BG', 'BGR', '保加利亚');
insert into `base_country` VALUES(48 , 'BH', 'BHR', '巴林');
insert into `base_country` VALUES(108 , 'BI', 'BDI', '布隆迪');
insert into `base_country` VALUES(204 , 'BJ', 'BEN', '贝宁');
insert into `base_country` VALUES(652 , 'BL', 'BLM', '圣巴泰勒米');
insert into `base_country` VALUES(60 , 'BM', 'BMU', '百慕大');
insert into `base_country` VALUES(96 , 'BN', 'BRN', '文莱');
insert into `base_country` VALUES(68 , 'BO', 'BOL', '玻利维亚');
insert into `base_country` VALUES(535 , 'BQ', 'BES', '加勒比荷兰');
insert into `base_country` VALUES(76 , 'BR', 'BRA', '巴西');
insert into `base_country` VALUES(44 , 'BS', 'BHS', '巴哈马');
insert into `base_country` VALUES(64 , 'BT', 'BTN', '不丹');
insert into `base_country` VALUES(74 , 'BV', 'BVT', '布韦岛');
insert into `base_country` VALUES(72 , 'BW', 'BWA', '博茨瓦纳');
insert into `base_country` VALUES(112 , 'BY', 'BLR', '白俄罗斯');
insert into `base_country` VALUES(84 , 'BZ', 'BLZ', '伯利兹');
insert into `base_country` VALUES(124 , 'CA', 'CAN', '加拿大');
insert into `base_country` VALUES(166 , 'CC', 'CCK', '科科斯（基林）群岛');
insert into `base_country` VALUES(180 , 'CD', 'COD', '刚果（金）');
insert into `base_country` VALUES(140 , 'CF', 'CAF', '中非');
insert into `base_country` VALUES(178 , 'CG', 'COG', '刚果（布）');
insert into `base_country` VALUES(756 , 'CH', 'CHE', '瑞士');
insert into `base_country` VALUES(384 , 'CI', 'CIV', '科特迪瓦');
insert into `base_country` VALUES(184 , 'CK', 'COK', '库克群岛');
insert into `base_country` VALUES(152 , 'CL', 'CHL', '智利');
insert into `base_country` VALUES(120 , 'CM', 'CMR', '喀麦隆');
insert into `base_country` VALUES(156 , 'CN', 'CHN', '中国');
insert into `base_country` VALUES(170 , 'CO', 'COL', '哥伦比亚');
insert into `base_country` VALUES(188 , 'CR', 'CRI', '哥斯达黎加');
insert into `base_country` VALUES(192 , 'CU', 'CUB', '古巴');
insert into `base_country` VALUES(132 , 'CV', 'CPV', '佛得角');
insert into `base_country` VALUES(531 , 'CW', 'CUW', '库拉索');
insert into `base_country` VALUES(162 , 'CX', 'CXR', '圣诞岛');
insert into `base_country` VALUES(196 , 'CY', 'CYP', '塞浦路斯');
insert into `base_country` VALUES(203 , 'CZ', 'CZE', '捷克');
insert into `base_country` VALUES(276 , 'DE', 'DEU', '德国');
insert into `base_country` VALUES(262 , 'DJ', 'DJI', '吉布提');
insert into `base_country` VALUES(208 , 'DK', 'DNK', '丹麦');
insert into `base_country` VALUES(212 , 'DM', 'DMA', '多米尼克');
insert into `base_country` VALUES(214 , 'DO', 'DOM', '多米尼加');
insert into `base_country` VALUES(12 , 'DZ', 'DZA', '阿尔及利亚');
insert into `base_country` VALUES(218 , 'EC', 'ECU', '厄瓜多尔');
insert into `base_country` VALUES(233 , 'EE', 'EST', '爱沙尼亚');
insert into `base_country` VALUES(818 , 'EG', 'EGY', '埃及');
insert into `base_country` VALUES(732 , 'EH', 'ESH', '阿拉伯撒哈拉民主共和国');
insert into `base_country` VALUES(232 , 'ER', 'ERI', '厄立特里亚');
insert into `base_country` VALUES(724 , 'ES', 'ESP', '西班牙');
insert into `base_country` VALUES(231 , 'ET', 'ETH', '埃塞俄比亚');
insert into `base_country` VALUES(246 , 'FI', 'FIN', '芬兰');
insert into `base_country` VALUES(242 , 'FJ', 'FJI', '斐济');
insert into `base_country` VALUES(238 , 'FK', 'FLK', '福克兰群岛');
insert into `base_country` VALUES(583 , 'FM', 'FSM', '密克罗尼西亚联邦');
insert into `base_country` VALUES(234 , 'FO', 'FRO', '法罗群岛');
insert into `base_country` VALUES(250 , 'FR', 'FRA', '法国');
insert into `base_country` VALUES(266 , 'GA', 'GAB', '加蓬');
