Mysql 民族数据库

民族数据库

-- ----------------------------
-- Table structure for xf_mz
-- ----------------------------
DROP TABLE IF EXISTS `xf_mz`;
CREATE TABLE `xf_mz`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of xf_mz
-- ----------------------------
INSERT INTO `xf_mz` VALUES (1, '汉族');
INSERT INTO `xf_mz` VALUES (2, '蒙古族');
INSERT INTO `xf_mz` VALUES (3, '回族');
INSERT INTO `xf_mz` VALUES (4, '藏族');
INSERT INTO `xf_mz` VALUES (5, '维吾尔族');
INSERT INTO `xf_mz` VALUES (6, '苗族');
INSERT INTO `xf_mz` VALUES (7, '彝族');
INSERT INTO `xf_mz` VALUES (8, '壮族');
INSERT INTO `xf_mz` VALUES (9, '布依族');
INSERT INTO `xf_mz` VALUES (10, '朝鲜族');
INSERT INTO `xf_mz` VALUES (11, '满族');
INSERT INTO `xf_mz` VALUES (12, '侗族');
INSERT INTO `xf_mz` VALUES (13, '瑶族');
INSERT INTO `xf_mz` VALUES (14, '白族');
INSERT INTO `xf_mz` VALUES (15, '土家族');
INSERT INTO `xf_mz` VALUES (16, '哈尼族');
INSERT INTO `xf_mz` VALUES (17, '哈萨克族');
INSERT INTO `xf_mz` VALUES (18, '傣族');
INSERT INTO `xf_mz` VALUES (19, '黎族');
INSERT INTO `xf_mz` VALUES (20, '傈僳族');
INSERT INTO `xf_mz` VALUES (21, '佤族');
INSERT INTO `xf_mz` VALUES (22, '畲族');
INSERT INTO `xf_mz` VALUES (23, '高山族');
INSERT INTO `xf_mz` VALUES (24, '拉祜族');
INSERT INTO `xf_mz` VALUES (25, '水族');
INSERT INTO `xf_mz` VALUES (26, '东乡族');
INSERT INTO `xf_mz` VALUES (27, '纳西族');
INSERT INTO `xf_mz` VALUES (28, '景颇族');
INSERT INTO `xf_mz` VALUES (29, '柯尔克孜族');
INSERT INTO `xf_mz` VALUES (30, '土族');
INSERT INTO `xf_mz` VALUES (31, '达斡尔族');
INSERT INTO `xf_mz` VALUES (32, '仫佬族');
INSERT INTO `xf_mz` VALUES (33, '羌族');
INSERT INTO `xf_mz` VALUES (34, ' 布朗族');
INSERT INTO `xf_mz` VALUES (35, ' 撒拉族');
INSERT INTO `xf_mz` VALUES (36, ' 毛难族');
INSERT INTO `xf_mz` VALUES (37, ' 仡佬族');
INSERT INTO `xf_mz` VALUES (38, ' 锡伯族');
INSERT INTO `xf_mz` VALUES (39, ' 阿昌族');
INSERT INTO `xf_mz` VALUES (40, ' 普米族');
INSERT INTO `xf_mz` VALUES (41, ' 塔吉克族');
INSERT INTO `xf_mz` VALUES (42, ' 怒族');
INSERT INTO `xf_mz` VALUES (43, ' 乌孜别克族');
INSERT INTO `xf_mz` VALUES (44, ' 俄罗斯族');
INSERT INTO `xf_mz` VALUES (45, ' 鄂温克族');
INSERT INTO `xf_mz` VALUES (46, ' 崩龙族');
INSERT INTO `xf_mz` VALUES (47, ' 保安族');
INSERT INTO `xf_mz` VALUES (48, ' 裕固族');
INSERT INTO `xf_mz` VALUES (49, ' 京族');
INSERT INTO `xf_mz` VALUES (50, ' 塔塔尔族');
INSERT INTO `xf_mz` VALUES (51, ' 独龙族');
INSERT INTO `xf_mz` VALUES (52, ' 鄂伦春族');
INSERT INTO `xf_mz` VALUES (53, ' 赫哲族');
INSERT INTO `xf_mz` VALUES (54, ' 门巴族');
INSERT INTO `xf_mz` VALUES (55, ' 珞巴族');
INSERT INTO `xf_mz` VALUES (56, ' 基诺族');
INSERT INTO `xf_mz` VALUES (57, ' 其他');

SET FOREIGN_KEY_CHECKS = 1;