text: /*
   Navicat Premium Data Transfer
  
   Source Server         : db_lee
   Source Server Type    : MySQL
   Source Server Version : 80026
   Source Host           : localhost:3306
   Source Schema         : unit
  
   Target Server Type    : MySQL
   Target Server Version : 80026
   File Encoding         : 65001
  
   Date: 14/02/2022 16:30:41
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for nationalities_of_china
  -- ----------------------------
  DROP TABLE IF EXISTS `nationalities_of_china`;
  CREATE TABLE `nationalities_of_china`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `code_number` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数字代码',
    `code_letters` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字母代码',
    `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民族名称',
    `name_full` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '民族全名',
    `name_roman` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '罗马字母拼写法',
    `name_pinyin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称拼音',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '中国民族表(nationalities of China)' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of nationalities_of_china
  -- ----------------------------
  INSERT INTO `nationalities_of_china` VALUES (1, '01', 'HA', '汉族', NULL, 'Han', 'hàn zú');
  INSERT INTO `nationalities_of_china` VALUES (2, '02', 'MG', '蒙古族', NULL, 'Mongol', 'měng gǔ zú\r\n');
  INSERT INTO `nationalities_of_china` VALUES (3, '03', 'HU', '回族', NULL, 'Hui', 'huí zú');
  INSERT INTO `nationalities_of_china` VALUES (4, '04', 'ZA', '藏族', NULL, 'Zang', 'zàng zú');
  INSERT INTO `nationalities_of_china` VALUES (5, '05', 'UG', '维吾尔族', NULL, 'Uygur', 'wéi wú ěr zú');
  INSERT INTO `nationalities_of_china` VALUES (6, '06', 'MH', '苗族', NULL, 'Miao', 'miáo zú');
  INSERT INTO `nationalities_of_china` VALUES (7, '07', 'YI', '彝族', NULL, 'Yi', 'yí zú');
  INSERT INTO `nationalities_of_china` VALUES (8, '08', 'ZH', '壮族', NULL, 'Zhuang', 'zhuàng zú\r\n');
  INSERT INTO `nationalities_of_china` VALUES (9, '09', 'BY', '布依族', NULL, 'Buyei', 'bù yī zú');
  INSERT INTO `nationalities_of_china` VALUES (10, '10', 'CS', '朝鲜族', NULL, 'Chosen', 'cháo xiǎn zú');
  INSERT INTO `nationalities_of_china` VALUES (11, '11', 'MA', '满族', NULL, 'Man', 'mǎn zú');
  INSERT INTO `nationalities_of_china` VALUES (12, '12', 'DO', '侗族', NULL, 'Dong', 'dòng zú');
  INSERT INTO `nationalities_of_china` VALUES (13, '13', 'YA', '瑶族', NULL, 'Yao', 'yáo zú');
  INSERT INTO `nationalities_of_china` VALUES (14, '14', 'BA', '白族', NULL, 'Bai', 'bái zú');
  INSERT INTO `nationalities_of_china` VALUES (15, '15', 'TJ', '土家族', NULL, 'Tujia', 'tǔ jiā zú');
  INSERT INTO `nationalities_of_china` VALUES (16, '16', 'HN', '哈尼族', NULL, 'Hani', 'hā ní zú');
  INSERT INTO `nationalities_of_china` VALUES (17, '17', 'KZ', '哈萨克族', NULL, 'Kazak', 'hā sà kè zú');
  INSERT INTO `nationalities_of_china` VALUES (18, '18', 'DA', '傣族', NULL, 'Dai', 'dǎi zú');
  INSERT INTO `nationalities_of_china` VALUES (19, '19', 'LI', '黎族', NULL, 'Li', 'lí zú');
  INSERT INTO `nationalities_of_china` VALUES (20, '20', 'LS', '傈僳族', NULL, 'Lisu', 'lì sù zú');
  INSERT INTO `nationalities_of_china` VALUES (21, '21', 'VA', '佤族', NULL, 'Va', 'wǎ zú');
  INSERT INTO `nationalities_of_china` VALUES (22, '22', 'SH', '畲族', NULL, 'She', 'shē zú');
  INSERT INTO `nationalities_of_china` VALUES (23, '23', 'GS', '高山族', NULL, 'Gaoshan', 'gāo shān zú');
  INSERT INTO `nationalities_of_china` VALUES (24, '24', 'LH', '拉祜族', NULL, 'Lahu', 'lā hù zú');
  INSERT INTO `nationalities_of_china` VALUES (25, '25', 'SU', '水族', NULL, 'Sui', 'shuǐ zú');
  INSERT INTO `nationalities_of_china` VALUES (26, '26', 'DX', '东乡族', NULL, 'Dongxiang', 'dōng xiāng zú');
  INSERT INTO `nationalities_of_china` VALUES (27, '27', 'NX', '纳西族', NULL, 'Naxi', 'nà xī zú');
  INSERT INTO `nationalities_of_china` VALUES (28, '28', 'JP', '景颇族', NULL, 'Jingpo', 'jǐng pō zú\r\n');
  INSERT INTO `nationalities_of_china` VALUES (29, '29', 'KG', '柯尔克孜族', NULL, 'Kirgiz', 'kē ěr kè zī zú');
  INSERT INTO `nationalities_of_china` VALUES (30, '30', 'TU', '土族', NULL, 'Tu', 'tǔ zú');
  INSERT INTO `nationalities_of_china` VALUES (31, '31', 'DU', '达斡尔族', NULL, 'Daur', 'dá wò ěr zú');
  INSERT INTO `nationalities_of_china` VALUES (32, '32', 'ML', '仫佬族', NULL, 'Mulao', 'mù lǎo zú');
  INSERT INTO `nationalities_of_china` VALUES (33, '33', 'QI', '羌族', NULL, 'Qiang', 'qiāng zú');
  INSERT INTO `nationalities_of_china` VALUES (34, '34', 'BL', '布朗族', NULL, 'Blang', 'bù lǎng zú');
  INSERT INTO `nationalities_of_china` VALUES (35, '35', 'SL', '撒拉族', NULL, 'Salar', 'sā lā zú');
  INSERT INTO `nationalities_of_china` VALUES (36, '36', 'MN', '毛南族', NULL, 'Maonan', 'máo nán zú');
  INSERT INTO `nationalities_of_china` VALUES (37, '37', 'GL', '仡佬族', NULL, 'Gelao', 'gě lǎo zú');
  INSERT INTO `nationalities_of_china` VALUES (38, '38', 'XB', '锡伯族', NULL, 'Xibe', 'xī bó zú');
  INSERT INTO `nationalities_of_china` VALUES (39, '39', 'AC', '阿昌族', NULL, 'Achang', 'ā chāng zú');
  INSERT INTO `nationalities_of_china` VALUES (40, '40', 'PM', '普米族', NULL, 'Pumi', 'pǔ mǐ zú\r\n');
  INSERT INTO `nationalities_of_china` VALUES (41, '41', 'TA', '塔吉克族', NULL, 'Tajik', 'tǎ jí kè zú');
  INSERT INTO `nationalities_of_china` VALUES (42, '42', 'NU', '怒族', NULL, 'Nu', 'nù zú');
  INSERT INTO `nationalities_of_china` VALUES (43, '43', 'UZ', '乌孜别克族', NULL, 'Uzbek', 'wū zī bié kè zú');
  INSERT INTO `nationalities_of_china` VALUES (44, '44', 'RS', '俄罗斯族', NULL, 'Russ', 'é luó sī zú');
  INSERT INTO `nationalities_of_china` VALUES (45, '45', 'EW', '鄂温克族', NULL, 'Ewenki', 'è wēn kè zú');
  INSERT INTO `nationalities_of_china` VALUES (46, '46', 'DE', '德昂族', NULL, 'Deang', 'dé áng zú');
  INSERT INTO `nationalities_of_china` VALUES (47, '47', 'BN', '保安族', NULL, 'Bonan', 'bǎo ān zú');
  INSERT INTO `nationalities_of_china` VALUES (48, '48', 'YG', '裕固族', NULL, 'Yugur', 'yù gù zú');
  INSERT INTO `nationalities_of_china` VALUES (49, '49', 'GI', '京族', NULL, 'Gin', 'jīng zú');
  INSERT INTO `nationalities_of_china` VALUES (50, '50', 'TT', '塔塔尔族', NULL, 'Tatar', 'tǎ tǎ ěr zú');
  INSERT INTO `nationalities_of_china` VALUES (51, '51', 'DR', '独龙族', NULL, 'Derung', 'dú lóng zú');
  INSERT INTO `nationalities_of_china` VALUES (52, '52', 'OR', '鄂伦春族', NULL, 'Oroqen', 'è lún chūn zú');
  INSERT INTO `nationalities_of_china` VALUES (53, '53', 'HZ', '赫哲族', NULL, 'Hezhen', 'hè zhé zú');
  INSERT INTO `nationalities_of_china` VALUES (54, '54', 'MB', '门巴族', NULL, 'Monba', 'mén bā zú');
  INSERT INTO `nationalities_of_china` VALUES (55, '55', 'LB', '珞巴族', NULL, 'Lhoba', 'luò bā zú');
  INSERT INTO `nationalities_of_china` VALUES (56, '56', 'JN', '基诺族', NULL, 'Jino', 'jī nuò zú');
  
  SET FOREIGN_KEY_CHECKS = 1;
  