· 10 years ago · Sep 01, 2016, 02:34 PM
1DROP TABLE IF EXISTS `chinese_nation`;
2CREATE TABLE `chinese_nation` (
3 `id` bigint(20) NOT NULL AUTO_INCREMENT,
4 `code` varchar(4) NOT NULL,
5 `display_name` varchar(255) NOT NULL,
6 `name` varchar(125) NOT NULL,
7 `ping_yin` varchar(24) NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=InnoDB AUTO_INCREMENT=400 DEFAULT CHARSET=utf8;
10
11INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('01', '汉æ—', '汉æ—', 'HZ');
12INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('02', 'è’™å¤æ—', 'è’™å¤æ—', 'MGZ');
13INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('03', '回æ—', '回æ—', 'HZ');
14INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('04', 'è—æ—', 'è—æ—', 'CZ');
15INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('05', 'ç»´å¾å°”æ—', 'ç»´å¾å°”æ—', 'WWEZ');
16INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('06', 'è‹—æ—', 'è‹—æ—', 'MZ');
17INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('07', 'å½æ—', 'å½æ—', 'YZ');
18INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('08', '壮æ—', '壮æ—', 'ZZ');
19INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('09', '布ä¾æ—', '布ä¾æ—', 'BYZ');
20INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('10', 'æœé²œæ—', 'æœé²œæ—', 'CXZ');
21INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('11', '满æ—', '满æ—', 'MZ');
22INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('12', 'ä¾—æ—', 'ä¾—æ—', 'DZ');
23INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('13', '瑶æ—', '瑶æ—', 'YZ');
24INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('14', '白æ—', '白æ—', 'BZ');
25INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('15', '土家æ—', '土家æ—', 'TJZ');
26INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('16', '哈尼æ—', '哈尼æ—', 'HNZ');
27INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('17', '哈è¨å…‹æ—', '哈è¨å…‹æ—', 'HSKZ');
28INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('18', 'å‚£æ—', 'å‚£æ—', 'DZ');
29INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('19', '黎æ—', '黎æ—', 'LZ');
30INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('20', '傈僳æ—', '傈僳æ—', 'SSZ');
31INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('21', '佤æ—', '佤æ—', 'WZ');
32INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('22', '畲æ—', '畲æ—', 'SZ');
33INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('23', '高山æ—', '高山æ—', 'GSZ');
34INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('24', '拉祜æ—', '拉祜æ—', 'LHZ');
35INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('25', 'æ°´æ—', 'æ°´æ—', 'SZ');
36INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('26', '东乡æ—', '东乡æ—', 'DXZ');
37INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('27', '纳西æ—', '纳西æ—', 'NXZ');
38INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('28', '景颇æ—', '景颇æ—', 'JPZ');
39INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('29', '柯尔克åœæ—', '柯尔克åœæ—', 'KEKZZ');
40INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('30', '土æ—', '土æ—', 'TZ');
41INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('31', '达斡尔æ—', '达斡尔æ—', 'DWEZ');
42INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('32', '仫佬æ—', '仫佬æ—', 'MLZ');
43INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('33', '羌æ—', '羌æ—', 'QZ');
44INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('34', '布朗æ—', '布朗æ—', 'BLZ');
45INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('35', '撒拉æ—', '撒拉æ—', 'SLZ');
46INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('36', '毛å—æ—', '毛å—æ—', 'MNZ');
47INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('37', '仡佬æ—', '仡佬æ—', 'YLZ');
48INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('38', '锡伯æ—', '锡伯æ—', 'XBZ');
49INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('39', '阿昌æ—', '阿昌æ—', 'ACZ');
50INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('40', '普米æ—', '普米æ—', 'PMZ');
51INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('41', 'å¡”å‰å…‹æ—', 'å¡”å‰å…‹æ—', 'TJKZ');
52INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('42', '怒æ—', '怒æ—', 'NZ');
53INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('43', '乌åœåˆ«å…‹æ—', '乌åœåˆ«å…‹æ—', 'WZBKZ');
54INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('44', 'ä¿„ç½—æ–¯æ—', 'ä¿„ç½—æ–¯æ—', 'ELSZ');
55INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('45', '鄂温克æ—', '鄂温克æ—', 'EWKZ');
56INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('46', '德昂æ—', '德昂æ—', 'BLZ');
57INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('47', 'ä¿å®‰æ—', 'ä¿å®‰æ—', 'BAZ');
58INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('48', '裕固æ—', '裕固æ—', 'YGZ');
59INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('49', '京æ—', '京æ—', 'JZ');
60INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('50', '塔塔尔æ—', '塔塔尔æ—', 'TTEZ');
61INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('51', '独龙æ—', '独龙æ—', 'DLZ');
62INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('52', '鄂伦春æ—', '鄂伦春æ—', 'ELCZ');
63INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('53', '赫哲æ—', '赫哲æ—', 'HZZ');
64INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('54', '门巴æ—', '门巴æ—', 'MBZ');
65INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('55', 'çžå·´æ—', 'çžå·´æ—', 'LBZ');
66INSERT INTO `chinese_nation` (`code`, `display_name`, `name`, `ping_yin`) VALUES ('56', '基诺æ—', '基诺æ—', 'JNZ');