/* Navicat Premium Data Transfer Source Server : DP Demo测试服务器 Source Server Type : MySQL Source Server Version : 50737 Source Host : 140.143.236.86:3306 Source Schema : dpdemo Target Server Type : MySQL Target Server Version : 50737 File Encoding : 65001 Date: 17/07/2022 23:33:23 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for sys_nation_code -- ---------------------------- DROP TABLE IF EXISTS `sys_nation_code`; CREATE TABLE `sys_nation_code` ( `nation_code_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'PK', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民族名称', `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '民族编号', `sort` int(11) DEFAULT 99 COMMENT '排序，值越大越靠前', `status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '1' COMMENT '状态，1：有效；0：无效', `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '备注', `version` int(11) DEFAULT 0 COMMENT '版本号', `deleted_flag` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '软删除标识，1：软删除；0：未软删', `created_at` datetime(0) DEFAULT NULL COMMENT '创建时间', `created_by` int(11) DEFAULT NULL COMMENT '创建人', `updated_at` datetime(0) DEFAULT NULL COMMENT '更新时间', `updated_by` int(11) DEFAULT NULL COMMENT '更新人', `deleted_at` datetime(0) DEFAULT NULL COMMENT '删除时间', `deleted_by` int(11) DEFAULT NULL COMMENT '删除人', PRIMARY KEY (`nation_code_id`) USING BTREE, INDEX `idx_code`(`code`) USING BTREE, INDEX `idx_name`(`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '民族表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_nation_code -- ---------------------------- INSERT INTO `sys_nation_code` VALUES (1, '汉族', '01', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:36', NULL, '2020-04-28 14:32:36', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (2, '蒙古族', '02', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (3, '回族', '03', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (4, '藏族', '04', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (5, '维吾尔族', '05', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (6, '苗族', '06', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (7, '彝族', '07', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (8, '壮族', '08', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (9, '布依族', '09', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (10, '朝鲜族', '10', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:37', NULL, '2020-04-28 14:32:37', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (11, '满族', '11', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (12, '侗族', '12', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (13, '瑶族', '13', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (14, '白族', '14', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (15, '土家族', '15', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (16, '哈尼族', '16', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (17, '哈萨克族', '17', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (18, '傣族', '18', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (19, '黎族', '19', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (20, '傈僳族', '20', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (21, '佤族', '21', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (22, '畲族', '22', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (23, '高山族', '23', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (24, '拉祜族', '24', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (25, '水族', '25', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:38', NULL, '2020-04-28 14:32:38', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (26, '东乡族', '26', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (27, '纳西族', '27', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (28, '景颇族', '28', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (29, '柯尔克孜族', '29', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (30, '土族', '30', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (31, '达斡尔族', '31', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (32, '仫佬族', '32', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (33, '羌族', '33', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (34, '布朗族', '34', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (35, '撒拉族', '35', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (36, '毛难族', '36', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (37, '仡佬族', '37', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (38, '锡伯族', '38', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (39, '阿昌族', '39', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:39', NULL, '2020-04-28 14:32:39', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (40, '普米族', '40', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (41, '塔吉克族', '41', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (42, '怒族', '42', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (43, '乌孜别克族', '43', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (44, '俄罗斯族', '44', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (45, '鄂温克族', '45', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (46, '崩龙族', '46', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (47, '保安族', '47', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (48, '裕固族', '48', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (49, '京族', '49', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (50, '塔塔尔族', '50', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (51, '独龙族', '51', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:40', NULL, '2020-04-28 14:32:40', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (52, '鄂伦春族', '52', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:41', NULL, '2020-04-28 14:32:41', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (53, '赫哲族', '53', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:41', NULL, '2020-04-28 14:32:41', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (54, '门巴族', '54', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:41', NULL, '2020-04-28 14:32:41', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (55, '珞巴族', '55', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:41', NULL, '2020-04-28 14:32:41', NULL, NULL, NULL); INSERT INTO `sys_nation_code` VALUES (56, '基诺族', '56', 99, '1', NULL, NULL, '0', '2020-04-28 14:32:41', NULL, '2020-04-28 14:32:41', NULL, NULL, NULL); SET FOREIGN_KEY_CHECKS = 1;