/*
 Navicat Premium Dump SQL

 Source Server         : cf-mysql
 Source Server Type    : MySQL
 Source Server Version : 80042 (8.0.42)
 Source Host           : 192.168.0.81:3326
 Source Schema         : cf_v1

 Target Server Type    : MySQL
 Target Server Version : 80042 (8.0.42)
 File Encoding         : 65001

 Date: 22/09/2025 13:31:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES (1, '000000', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '初始化密码 123456');
INSERT INTO `sys_config` VALUES (2, '000000', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '是否开启注册用户功能（true开启，false关闭）');
INSERT INTO `sys_config` VALUES (3, '000000', 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, 'true:开启, false:关闭');


-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES (1, '000000', 1, '男', '0', 'sys_user_sex', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '性别男');
INSERT INTO `sys_dict_data` VALUES (2, '000000', 2, '女', '1', 'sys_user_sex', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '性别女');
INSERT INTO `sys_dict_data` VALUES (3, '000000', 3, '未知', '2', 'sys_user_sex', '', 'warning', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '性别未知');
INSERT INTO `sys_dict_data` VALUES (4, '000000', 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '显示菜单');
INSERT INTO `sys_dict_data` VALUES (5, '000000', 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '隐藏菜单');
INSERT INTO `sys_dict_data` VALUES (6, '000000', 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (7, '000000', 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '停用状态');
INSERT INTO `sys_dict_data` VALUES (12, '000000', 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '系统默认是');
INSERT INTO `sys_dict_data` VALUES (13, '000000', 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '系统默认否');
INSERT INTO `sys_dict_data` VALUES (14, '000000', 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '通知');
INSERT INTO `sys_dict_data` VALUES (15, '000000', 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '公告');
INSERT INTO `sys_dict_data` VALUES (16, '000000', 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (17, '000000', 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '关闭状态');
INSERT INTO `sys_dict_data` VALUES (18, '000000', 1, '新增', '1', 'sys_oper_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '新增操作');
INSERT INTO `sys_dict_data` VALUES (19, '000000', 2, '修改', '2', 'sys_oper_type', '', 'success', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '修改操作');
INSERT INTO `sys_dict_data` VALUES (20, '000000', 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '删除操作');
INSERT INTO `sys_dict_data` VALUES (21, '000000', 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '授权操作');
INSERT INTO `sys_dict_data` VALUES (22, '000000', 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '导出操作');
INSERT INTO `sys_dict_data` VALUES (23, '000000', 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '导入操作');
INSERT INTO `sys_dict_data` VALUES (24, '000000', 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '强退操作');
INSERT INTO `sys_dict_data` VALUES (25, '000000', 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '生成操作');
INSERT INTO `sys_dict_data` VALUES (26, '000000', 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '清空操作');
INSERT INTO `sys_dict_data` VALUES (27, '000000', 1, '成功', '0', 'sys_common_status', '', 'success', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '正常状态');
INSERT INTO `sys_dict_data` VALUES (28, '000000', 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '停用状态');
INSERT INTO `sys_dict_data` VALUES (29, '000000', 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '其他操作');
INSERT INTO `sys_dict_data` VALUES (30, '000000', 0, '密码认证', 'password', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '密码认证');
INSERT INTO `sys_dict_data` VALUES (31, '000000', 0, '短信认证', 'sms', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '短信认证');
INSERT INTO `sys_dict_data` VALUES (32, '000000', 0, '邮件认证', 'email', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '邮件认证');
INSERT INTO `sys_dict_data` VALUES (33, '000000', 0, '小程序认证', 'xcx', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '小程序认证');
INSERT INTO `sys_dict_data` VALUES (34, '000000', 0, '三方登录认证', 'social', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '三方登录认证');
INSERT INTO `sys_dict_data` VALUES (35, '000000', 0, 'PC', 'pc', 'sys_device_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, 'PC');
INSERT INTO `sys_dict_data` VALUES (36, '000000', 0, '安卓', 'android', 'sys_device_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '安卓');
INSERT INTO `sys_dict_data` VALUES (37, '000000', 0, 'iOS', 'ios', 'sys_device_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, 'iOS');
INSERT INTO `sys_dict_data` VALUES (38, '000000', 0, '小程序', 'xcx', 'sys_device_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '小程序');
INSERT INTO `sys_dict_data` VALUES (1000, '000000', 1, '灭活疫苗', '0', 'vaccine_type', NULL, NULL, 'Y', 100, 1, '2025-07-14 17:27:06', 1, '2025-07-14 17:27:06', NULL);
INSERT INTO `sys_dict_data` VALUES (1001, '000000', 1, '活疫苗', '1', 'vaccine_type', NULL, NULL, 'N', 100, 1, '2025-07-14 17:27:23', 1, '2025-07-14 17:27:28', NULL);
INSERT INTO `sys_dict_data` VALUES (1002, '000000', 2, '重组蛋白疫苗', '2', 'vaccine_type', NULL, NULL, 'Y', 100, 1, '2025-07-14 17:27:54', 1, '2025-07-14 17:27:54', NULL);
INSERT INTO `sys_dict_data` VALUES (1003, '000000', 1, '可用', '0', 'vaccine_status', NULL, NULL, 'Y', 100, 1, '2025-07-14 17:29:10', 1, '2025-07-14 17:29:10', NULL);
INSERT INTO `sys_dict_data` VALUES (1004, '000000', 2, '缺货', '1', 'vaccine_status', NULL, 'warning', 'N', 100, 1, '2025-07-14 17:30:14', 1, '2025-07-14 17:30:14', NULL);
INSERT INTO `sys_dict_data` VALUES (1005, '000000', 3, '过期', '2', 'vaccine_status', NULL, 'danger', 'N', 100, 1, '2025-07-14 21:27:55', 1, '2025-07-14 21:27:55', NULL);
INSERT INTO `sys_dict_data` VALUES (1006, '000000', 1, '公', '0', 'chicken_gender', NULL, 'primary', 'N', 100, 1, '2025-07-15 10:25:10', 1, '2025-07-15 10:25:10', NULL);
INSERT INTO `sys_dict_data` VALUES (1007, '000000', 2, '母', '1', 'chicken_gender', NULL, 'success', 'N', 100, 1, '2025-07-15 10:25:33', 1, '2025-07-15 10:25:43', NULL);
INSERT INTO `sys_dict_data` VALUES (1008, '000000', 1, '启用', '0', 'sop_status', NULL, 'primary', 'N', 100, 1, '2025-07-15 10:26:57', 1, '2025-07-15 10:27:08', NULL);
INSERT INTO `sys_dict_data` VALUES (1009, '000000', 2, '禁用', '1', 'sop_status', NULL, 'danger', 'N', 100, 1, '2025-07-15 10:27:48', 1, '2025-07-15 10:28:21', NULL);
INSERT INTO `sys_dict_data` VALUES (1011, '000000', 1, '闲置', '0', 'wing_tag_status', NULL, 'primary', 'Y', 100, 1, '2025-07-16 16:00:34', 1, '2025-07-16 16:00:34', NULL);
INSERT INTO `sys_dict_data` VALUES (1012, '000000', 2, '绑定中', '1', 'wing_tag_status', NULL, 'success', 'Y', 100, 1, '2025-07-16 16:00:59', 1, '2025-07-24 11:02:37', NULL);
INSERT INTO `sys_dict_data` VALUES (1014, '000000', 1, '正常', '0', 'chicken_coop_status', NULL, 'success', 'Y', 100, 1, '2025-07-16 17:11:30', 1, '2025-07-16 17:11:30', NULL);
INSERT INTO `sys_dict_data` VALUES (1015, '000000', 2, '异常', '1', 'chicken_coop_status', NULL, 'warning', 'N', 100, 1, '2025-07-16 17:11:43', 1, '2025-07-16 17:11:43', NULL);
INSERT INTO `sys_dict_data` VALUES (1016, '000000', 1, '正常', '0', 'chicken_cage_status', NULL, 'primary', 'Y', 100, 1, '2025-07-16 20:17:02', 1, '2025-07-24 11:04:48', NULL);
INSERT INTO `sys_dict_data` VALUES (1017, '000000', 2, '异常', '1', 'chicken_cage_status', NULL, 'info', 'N', 100, 1, '2025-07-16 20:17:29', 1, '2025-07-24 11:04:37', NULL);
INSERT INTO `sys_dict_data` VALUES (1019, '000000', 1, 'A系', 'A', 'variety_lineage', NULL, 'primary', 'Y', 100, 1, '2025-07-17 11:57:39', 1, '2025-07-17 11:57:39', NULL);
INSERT INTO `sys_dict_data` VALUES (1020, '000000', 2, 'B系', 'B', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:20', 1, '2025-07-17 13:20:20', NULL);
INSERT INTO `sys_dict_data` VALUES (1021, '000000', 3, 'C系', 'C', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:26', 1, '2025-07-17 13:20:26', NULL);
INSERT INTO `sys_dict_data` VALUES (1022, '000000', 4, 'D系', 'D', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1023, '000000', 5, 'E系', 'E', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1024, '000000', 6, 'F系', 'F', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1025, '000000', 7, 'G系', 'G', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1026, '000000', 8, 'H系', 'H', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1027, '000000', 9, 'I系', 'I', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1028, '000000', 10, 'J系', 'J', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1029, '000000', 11, 'K系', 'K', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1030, '000000', 12, 'L系', 'L', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:28', 1, '2025-07-17 13:20:28', NULL);
INSERT INTO `sys_dict_data` VALUES (1031, '000000', 13, 'M系', 'M', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:28', 1, '2025-07-17 13:20:28', NULL);
INSERT INTO `sys_dict_data` VALUES (1032, '000000', 14, 'N系', 'N', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:28', 1, '2025-07-17 13:20:28', NULL);
INSERT INTO `sys_dict_data` VALUES (1033, '000000', 15, 'O系', 'O', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:28', 1, '2025-07-17 13:20:28', NULL);
INSERT INTO `sys_dict_data` VALUES (1034, '000000', 1, '新建', '0', 'batch_status', NULL, 'primary', 'Y', 100, 1, '2025-07-17 14:23:50', 1, '2025-07-17 14:23:50', NULL);
INSERT INTO `sys_dict_data` VALUES (1035, '000000', 2, '育成中', '1', 'batch_status', NULL, 'success', 'Y', 100, 1, '2025-07-17 14:24:08', 1, '2025-07-17 14:24:19', NULL);
INSERT INTO `sys_dict_data` VALUES (1036, '000000', 3, '完成', '2', 'batch_status', NULL, 'info', 'N', 100, 1, '2025-07-17 15:05:34', 1, '2025-07-17 15:05:34', NULL);
INSERT INTO `sys_dict_data` VALUES (1037, '000000', 1, '在养', '0', 'chicken_status', NULL, 'success', 'Y', 100, 1, '2025-07-17 18:35:51', 1, '2025-07-17 18:35:51', NULL);
INSERT INTO `sys_dict_data` VALUES (1038, '000000', 2, '已淘汰', '1', 'chicken_status', NULL, 'warning', 'N', 100, 1, '2025-07-17 18:36:20', 1, '2025-07-17 18:36:20', NULL);
INSERT INTO `sys_dict_data` VALUES (1040, '000000', 1, '腿病', '1', 'chicken_cull_reason', NULL, 'primary', 'Y', 100, 1, '2025-07-17 18:56:40', 1, '2025-08-11 15:52:20', NULL);
INSERT INTO `sys_dict_data` VALUES (1041, '000000', 2, '腹水', '2', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:03', 1, '2025-08-11 15:52:27', NULL);
INSERT INTO `sys_dict_data` VALUES (1042, '000000', 3, '细菌感染', '3', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:15', 1, '2025-07-17 18:57:15', NULL);
INSERT INTO `sys_dict_data` VALUES (1043, '000000', 4, '外伤', '4', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:39', 1, '2025-07-17 18:57:39', NULL);
INSERT INTO `sys_dict_data` VALUES (1044, '000000', 1, '无害化', '0', 'chicken_disposal_method', NULL, 'primary', 'Y', 100, 1, '2025-07-17 18:58:01', 1, '2025-07-17 18:58:01', NULL);
INSERT INTO `sys_dict_data` VALUES (1045, '000000', 2, '食堂', '1', 'chicken_disposal_method', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:58:19', 1, '2025-07-17 18:58:19', NULL);
INSERT INTO `sys_dict_data` VALUES (1046, '000000', 3, '屠宰场', '2', 'chicken_disposal_method', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:58:31', 1, '2025-07-17 18:58:31', NULL);
INSERT INTO `sys_dict_data` VALUES (1047, '000000', 1, '正常', '0', 'family_status', NULL, 'primary', 'Y', 100, 1, '2025-07-18 10:26:25', 1, '2025-07-24 11:00:55', NULL);
INSERT INTO `sys_dict_data` VALUES (1048, '000000', 2, '异常', '1', 'family_status', NULL, 'info', 'N', 100, 1, '2025-07-18 10:26:48', 1, '2025-07-24 11:07:07', NULL);
INSERT INTO `sys_dict_data` VALUES (1050, '000000', 1, '好种蛋', '0', 'breeding_egg_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (1051, '000000', 2, '好菜蛋', '1', 'breeding_egg_type', NULL, 'primary', 'N', 100, 1, '2025-07-21 09:53:44', 1, '2025-07-21 09:54:30', NULL);
INSERT INTO `sys_dict_data` VALUES (1052, '000000', 3, '畸形蛋', '2', 'breeding_egg_type', NULL, 'info', 'N', 100, 1, '2025-07-21 09:54:03', 1, '2025-07-31 13:16:00', NULL);
INSERT INTO `sys_dict_data` VALUES (1053, '000000', 4, '破蛋', '3', 'breeding_egg_type', NULL, 'warning', 'N', 100, 1, '2025-07-21 09:54:21', 1, '2025-07-31 13:16:09', NULL);
INSERT INTO `sys_dict_data` VALUES (1054, '000000', 1, '待确认', '0', 'cage_change_status', NULL, 'primary', 'Y', 100, 1, '2025-07-28 13:53:25', 1, '2025-07-28 16:45:12', NULL);
INSERT INTO `sys_dict_data` VALUES (1055, '000000', 2, '审核通过', '1', 'cage_change_status', NULL, 'success', 'N', 100, 1, '2025-07-28 13:54:07', 1, '2025-07-28 13:54:07', NULL);
INSERT INTO `sys_dict_data` VALUES (1056, '000000', 3, '作废', '2', 'cage_change_status', NULL, 'info', 'N', 100, 1, '2025-07-28 13:54:31', 1, '2025-07-28 13:54:31', NULL);
INSERT INTO `sys_dict_data` VALUES (1057, '000000', 1, '祖代厂', '0', 'pull_out_type', NULL, 'primary', 'Y', 100, 1, '2025-07-30 12:35:30', 1, '2025-07-30 12:35:30', NULL);
INSERT INTO `sys_dict_data` VALUES (1058, '000000', 2, '食堂', '1', 'pull_out_type', NULL, 'primary', 'N', 100, 1, '2025-07-30 12:35:45', 1, '2025-07-30 12:35:45', NULL);
INSERT INTO `sys_dict_data` VALUES (1059, '000000', 3, '实验室', '2', 'pull_out_type', NULL, 'primary', 'N', 100, 1, '2025-07-30 12:35:54', 1, '2025-07-30 12:35:54', NULL);
INSERT INTO `sys_dict_data` VALUES (1060, '000000', 4, '菜蛋销售', '3', 'pull_out_type', NULL, 'primary', 'N', 100, 1, '2025-07-30 12:36:09', 1, '2025-07-30 12:36:09', NULL);
INSERT INTO `sys_dict_data` VALUES (1061, '000000', 5, '其它', '5', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:39', 1, '2025-07-17 18:57:39', NULL);
INSERT INTO `sys_dict_data` VALUES (1062, '000000', 0, '测定中', '0', 'measure_detail_status', NULL, 'primary', 'Y', 100, 1, '2025-08-12 09:34:50', 1, '2025-08-12 09:34:58', NULL);
INSERT INTO `sys_dict_data` VALUES (1063, '000000', 1, '结束', '1', 'measure_detail_status', NULL, 'info', 'N', 100, 1, '2025-08-12 09:35:16', 1, '2025-08-12 09:35:16', NULL);
INSERT INTO `sys_dict_data` VALUES (1064, '000000', 2, '淘汰', '2', 'measure_detail_status', NULL, 'warning', 'N', 100, 1, '2025-08-12 09:35:35', 1, '2025-08-12 09:35:35', NULL);
INSERT INTO `sys_dict_data` VALUES (1065, '000000', 1, '育成舍', '1', 'chicken_coop_type', NULL, 'primary', 'Y', 100, 1, '2025-08-18 11:55:32', 1, '2025-08-18 11:55:32', NULL);
INSERT INTO `sys_dict_data` VALUES (1066, '000000', 2, '产蛋舍', '2', 'chicken_coop_type', NULL, 'primary', 'N', 100, 1, '2025-08-18 11:55:44', 1, '2025-08-18 11:55:44', NULL);
INSERT INTO `sys_dict_data` VALUES (1067, '000000', 1, '弥勒育种场', '弥勒育种场', 'factory_info', NULL, 'primary', 'Y', 100, 1, '2025-08-18 11:58:30', 1, '2025-08-18 11:58:30', NULL);
INSERT INTO `sys_dict_data` VALUES (1068, '000000', 3, '育雏舍', '3', 'chicken_coop_type', NULL, 'primary', 'N', 100, 1, '2025-08-18 11:55:44', 1, '2025-08-18 11:55:44', NULL);
INSERT INTO `sys_dict_data` VALUES (1069, '000000', 4, '测定舍', '4', 'chicken_coop_type', NULL, 'primary', 'N', 100, 1, '2025-08-18 11:55:44', 1, '2025-08-18 11:55:44', NULL);
INSERT INTO `sys_dict_data` VALUES (1070, '000000', 3, '未知', '2', 'chicken_gender', NULL, NULL, 'N', 100, 1, '2025-09-08 09:06:34', 1, '2025-09-08 09:06:34', NULL);


-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES (1, '000000', '用户性别', 'sys_user_sex', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '用户性别列表');
INSERT INTO `sys_dict_type` VALUES (2, '000000', '隐藏状态', 'sys_show_hide', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '菜单隐藏状态列表(1隐藏0显示)');
INSERT INTO `sys_dict_type` VALUES (3, '000000', '启用状态', 'sys_normal_disable', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '系统启用状态列表');
INSERT INTO `sys_dict_type` VALUES (6, '000000', '系统是否', 'sys_yes_no', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '系统是否列表');
INSERT INTO `sys_dict_type` VALUES (7, '000000', '通知类型', 'sys_notice_type', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '通知类型列表');
INSERT INTO `sys_dict_type` VALUES (8, '000000', '通知状态', 'sys_notice_status', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '通知状态列表');
INSERT INTO `sys_dict_type` VALUES (9, '000000', '操作类型', 'sys_oper_type', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '操作类型列表');
INSERT INTO `sys_dict_type` VALUES (10, '000000', '操作状态', 'sys_common_status', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '操作状态列表');
INSERT INTO `sys_dict_type` VALUES (11, '000000', '授权类型', 'sys_grant_type', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '认证授权类型');
INSERT INTO `sys_dict_type` VALUES (12, '000000', '设备类型', 'sys_device_type', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '客户端设备类型');
INSERT INTO `sys_dict_type` VALUES (1000, '000000', '疫苗种类', 'vaccine_type', 100, 1, '2025-07-14 17:26:23', 1, '2025-07-14 17:26:23', '疫苗种类（0:灭活疫苗, 1:活疫苗, 2:重组蛋白疫苗）');
INSERT INTO `sys_dict_type` VALUES (1001, '000000', '疫苗状态', 'vaccine_status', 100, 1, '2025-07-14 17:28:35', 1, '2025-07-14 17:28:35', '状态（0:可用, 1:缺货, 2:过期）');
INSERT INTO `sys_dict_type` VALUES (1002, '000000', '家禽性别', 'chicken_gender', 100, 1, '2025-07-15 10:24:17', 1, '2025-09-08 09:06:14', '家禽性别（0：公 1：母  2：未知）');
INSERT INTO `sys_dict_type` VALUES (1003, '000000', 'sop状态', 'sop_status', 100, 1, '2025-07-15 10:26:34', 1, '2025-07-24 11:01:54', '状态（0:启用, 1:禁用）');
INSERT INTO `sys_dict_type` VALUES (1004, '000000', '翅号状态', 'wing_tag_status', 100, 1, '2025-07-16 15:58:49', 1, '2025-07-24 11:02:21', '状态（0:闲置, 1:已绑定）');
INSERT INTO `sys_dict_type` VALUES (1005, '000000', '鸡舍状态', 'chicken_coop_status', 100, 1, '2025-07-16 17:11:05', 1, '2025-07-16 17:11:05', '状态(0:正常 1:异常)');
INSERT INTO `sys_dict_type` VALUES (1006, '000000', '鸡笼状态', 'chicken_cage_status', 100, 1, '2025-07-16 20:16:21', 1, '2025-07-24 11:04:15', '状态（0:正常, 1:异常）');
INSERT INTO `sys_dict_type` VALUES (1007, '000000', '品系系别', 'variety_lineage', 100, 1, '2025-07-17 11:56:03', 1, '2025-07-17 11:56:33', 'A~O系,例：A系，B系。。。。O系');
INSERT INTO `sys_dict_type` VALUES (1008, '000000', '批次状态', 'batch_status', 100, 1, '2025-07-17 14:22:12', 1, '2025-07-17 14:22:12', '状态（0:新建, 1:育成中, 2:完成）');
INSERT INTO `sys_dict_type` VALUES (1009, '000000', '鸡个体状态', 'chicken_status', 100, 1, '2025-07-17 18:21:26', 1, '2025-07-24 09:38:54', '状态（0:在养, 1:已淘汰）');
INSERT INTO `sys_dict_type` VALUES (1010, '000000', '鸡个体淘汰原因', 'chicken_cull_reason', 100, 1, '2025-07-17 18:54:19', 1, '2025-08-11 15:55:42', '“腿病”、“腹水”、“细菌感染”、“外伤”，其他');
INSERT INTO `sys_dict_type` VALUES (1011, '000000', '鸡个体处置方式', 'chicken_disposal_method', 100, 1, '2025-07-17 18:55:31', 1, '2025-07-17 18:55:31', '“无害化”，“食堂”，“屠宰场”');
INSERT INTO `sys_dict_type` VALUES (1012, '000000', '家系配种状态', 'family_status', 100, 1, '2025-07-18 10:25:34', 1, '2025-07-24 11:06:51', '状态（0:正常, 1:异常）');
INSERT INTO `sys_dict_type` VALUES (1013, '000000', '种蛋类型', 'breeding_egg_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '蛋分类（0:好种蛋, 1:好菜蛋, 2:畸形蛋, 3:破蛋）');
INSERT INTO `sys_dict_type` VALUES (1014, '000000', '换笼状态', 'cage_change_status', 100, 1, '2025-07-28 13:52:49', 1, '2025-07-28 13:52:49', '换笼状态');
INSERT INTO `sys_dict_type` VALUES (1015, '000000', '外拉类型', 'pull_out_type', 100, 1, '2025-07-30 12:34:45', 1, '2025-07-30 12:34:59', '外拉类型（0：祖代厂 1:食堂 2:实验室 3:菜蛋销售）');
INSERT INTO `sys_dict_type` VALUES (1016, '000000', '测定记录详情状态', 'measure_detail_status', 100, 1, '2025-08-12 09:34:11', 1, '2025-08-12 09:34:11', '测定中，结束，淘汰');
INSERT INTO `sys_dict_type` VALUES (1017, '000000', '鸡舍类型', 'chicken_coop_type', 100, 1, '2025-08-18 11:53:36', 1, '2025-08-18 11:55:00', '1:育成舍 2：产蛋舍');
INSERT INTO `sys_dict_type` VALUES (1018, '000000', '厂区信息', 'factory_info', 100, 1, '2025-08-18 11:57:49', 1, '2025-08-18 11:57:49', '厂区信息');







-- ----------------------------
-- Records of sys_client
-- ----------------------------
INSERT INTO `sys_client` VALUES (1, '9579f8780cf24ae2959d03d11482b18a', 'pc', 'iwb123', 'password,social', 'pc', 1800, 604800, '0', '0', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14');
INSERT INTO `sys_client` VALUES (2, '35aee70ae7224eb9a48bc527955ddedc', 'app', 'iwb123', 'password,sms,social', 'android', 1800, 604800, '0', '0', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14');










-- ----------------------------
-- Records of sys_org
-- ----------------------------
INSERT INTO `sys_org` VALUES (100, '000000', 0, '0', '系统管理', NULL, 0, 1, '15888888888', 'vber@iwbnet.com', '0', '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL);
INSERT INTO `sys_org` VALUES (101, '000000', 100, '0,100', '弥勒养殖场', NULL, 0, 1, '15888888888', 'vber@iwbnet.com', '0', '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL);
INSERT INTO `sys_org` VALUES (201, '000000', 101, '0,100,101', '弥勒育种场', NULL, 0, NULL, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_org` VALUES (1000, '000000', 201, '0,100,101,201', '鸡舍管理员', '', 1, NULL, NULL, NULL, '0', '0', 100, 1, '2025-08-21 10:16:33', 1, '2025-08-21 10:16:33');



-- ----------------------------
-- Records of sys_oss
-- ----------------------------


-- ----------------------------
-- Records of sys_oss_config
-- ----------------------------
INSERT INTO `sys_oss_config` VALUES (1, '000000', 'local', '', '', '/preview/', '', '', '', 'N', '', '1', '0', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL);
INSERT INTO `sys_oss_config` VALUES (2, '000000', 'qiniu', 'x', 'x', 'vber', '', 's3-cn-north-1.qiniucs.com', '', 'N', '', '1', '1', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL);
INSERT INTO `sys_oss_config` VALUES (3, '000000', 'aliyun', 'x', 'x', 'vber', '', 'oss-cn-beijing.aliyuncs.com', '', 'N', '', '1', '1', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL);
INSERT INTO `sys_oss_config` VALUES (4, '000000', 'qcloud', 'x', 'x', 'vber-1250000000', '', 'cos.ap-beijing.myqcloud.com', '', 'N', 'ap-beijing', '1', '1', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL);
INSERT INTO `sys_oss_config` VALUES (5, '000000', 'minio', 'vber', 'vber123', 'vber', 'image', '127.0.0.1:9000', '', 'N', '', '1', '1', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL);


-- ----------------------------
-- Records of sys_post
-- ----------------------------
INSERT INTO `sys_post` VALUES (1, '000000', 100, 'default', NULL, '默认岗位', 1, '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL, '');


-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '000000', '超级管理员', 'super_admin', 1, '1', 1, 1, 1, '0', '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL, '超级管理员');
INSERT INTO `sys_role` VALUES (2, '000000', '默认角色', 'default', 2, '3', 1, 1, 1, '0', '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL, '默认角色');
INSERT INTO `sys_role` VALUES (1000, '000000', '鸡舍管理员', 'js_manager', 3, '5', 1, 1, 0, '0', '0', 100, 1, '2025-08-21 10:19:57', 1, '2025-08-21 15:16:04', NULL);
INSERT INTO `sys_role` VALUES (1001, '000000', '育种厂厂长', 'yzc', 4, '1', 1, 1, 0, '0', '0', 100, 1, '2025-09-05 16:36:54', 1, '2025-09-05 16:37:00', NULL);




-- ----------------------------
-- Records of sys_role_org
-- ----------------------------
INSERT INTO `sys_role_org` VALUES (2, 100);
INSERT INTO `sys_role_org` VALUES (2, 101);
INSERT INTO `sys_role_org` VALUES (2, 102);


-- ----------------------------
-- Records of sys_social
-- ----------------------------



-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
INSERT INTO `sys_tenant` VALUES (1, '000000', '管理组', '15888888888', 'XXX有限公司', NULL, NULL, '多租户通用后台管理管理系统', NULL, NULL, NULL, NULL, -1, '0', '0', 100, 1, '2025-07-10 14:59:14', NULL, NULL);



-- ----------------------------
-- Records of sys_tenant_package
-- ----------------------------


-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, '000000', 100, 'admin', 'Admin', 'sys_user', 'admin@iwbnet.com', '13812340010', '1', NULL, '$2a$10$2M15Bggh98qOy7aWrGUc2OHL4yvvNij/NtbnLfkASmCN/Xwco3rq.',NULL,NULL,NULL,NULL, '0', '0', '172.27.0.1', '2025-09-22 13:00:07', 100, 1, '2025-07-10 14:59:13', -1, '2025-09-22 13:00:07', '超级管理员');
INSERT INTO `sys_user` VALUES (2, '000000', 100, 'system', 'System', 'sys_user', 'system@iwbnet.com', '13812340011', '1', NULL, '$2a$10$rCiWvcYYyEIb.PTM940FweoU.qKwErcJFmFyQdopQ1ZT37q6UcaOm',NULL,NULL,NULL,NULL, '0', '0', '127.0.0.1', '2025-07-10 14:59:13', 100, 1, '2025-07-10 14:59:13', NULL, NULL, '系统管理员');
INSERT INTO `sys_user` VALUES (3, '000000', 1000, 'demo01', 'Demo01', 'sys_user', 'demo01@iwbnet.com', '13812340021', '1', NULL, '$2a$10$T2u3eqjhLe04ZUTGCPcYrONPpLEt03eDbdJdCD5JW.2PQhT/LixcO',NULL,NULL,NULL,NULL, '0', '0', '0:0:0:0:0:0:0:1', '2025-08-21 15:42:24', 100, 1, '2025-07-10 14:59:13', -1, '2025-08-21 15:42:24', '系统管理员');
INSERT INTO `sys_user` VALUES (4, '000000', 1000, 'demo02', 'Demo02', 'sys_user', 'demo02@iwbnet.com', '13812340022', '1', NULL, '$2a$10$YpB6Bww0qTHZu31uDAlmg.MhDYTNKuOzN3KhaBEPM.PDVrJxHHuhW',NULL,NULL,NULL,NULL, '0', '0', '127.0.0.1', '2025-07-10 14:59:13', 100, 1, '2025-07-10 14:59:13', 1, '2025-08-21 10:22:17', '系统管理员');
INSERT INTO `sys_user` VALUES (1000, '000000', 100, 'yf', 'fy', 'sys_user', '123@123.com', '13900000000', '0', NULL, '$2a$10$ZCieMrSd4YmzX5iUPnam9O9FDGex2G/qpFcmFYTGY17KhBdLL67ui',NULL,NULL,NULL,NULL, '0', '0', '', NULL, 100, 1, '2025-09-05 16:35:58', 1, '2025-09-07 09:36:22', NULL);


-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
INSERT INTO `sys_user_post` VALUES (1, 1);
INSERT INTO `sys_user_post` VALUES (2, 1);


-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (1, 1);
INSERT INTO `sys_user_role` VALUES (2, 1);
INSERT INTO `sys_user_role` VALUES (3, 1000);
INSERT INTO `sys_user_role` VALUES (4, 1000);
INSERT INTO `sys_user_role` VALUES (1000, 1001);



-- ----------------------------
-- Records of xxl_job_group
-- ----------------------------
INSERT INTO `xxl_job_group` VALUES (1, 'cf-job-executor', 'vber执行器', 0, 'http://172.27.0.5:6080/', '2025-09-22 13:28:56');



-- ----------------------------
-- Records of xxl_job_info
-- ----------------------------
INSERT INTO `xxl_job_info` VALUES (1, 1, '演示任务01', '2025-08-20 11:03:11', '2025-08-20 11:03:11', 'XXL', '', 'CRON', '0 0 0 * * ? *', 'DO_NOTHING', 'FIRST', 'demoJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:03:11', '', 0, 0, 0);
INSERT INTO `xxl_job_info` VALUES (2, 1, '日统计鸡舍批次信息', '2025-08-20 11:09:12', '2025-08-20 11:59:01', 'admin', '', 'CRON', '0 5 23 * * ?', 'DO_NOTHING', 'FIRST', 'staDayJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:09:12', '', 1, 1758467100000, 1758553500000);
INSERT INTO `xxl_job_info` VALUES (3, 1, '月统计鸡舍批次信息', '2025-08-20 11:17:16', '2025-08-20 11:17:16', 'admin', '', 'CRON', '0 10 23 L * ?', 'DO_NOTHING', 'FIRST', 'staMonthJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:17:16', '', 0, 0, 0);
INSERT INTO `xxl_job_info` VALUES (4, 1, '季度统计鸡舍批次信息', '2025-08-20 11:26:37', '2025-08-20 11:26:37', 'admin', '', 'CRON', '0 15 23 L 3,6,9,12 ?', 'DO_NOTHING', 'FIRST', 'staQuarterJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:26:37', '', 0, 0, 0);
INSERT INTO `xxl_job_info` VALUES (5, 1, '年统计鸡舍批次信息', '2025-08-20 11:28:08', '2025-08-20 11:28:08', 'admin', '', 'CRON', '0 20 23 L 12 ? *', 'DO_NOTHING', 'FIRST', 'staYearJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:28:08', '', 0, 0, 0);


-- ----------------------------
-- Records of xxl_job_registry
-- ----------------------------
INSERT INTO `xxl_job_registry` VALUES (63, 'EXECUTOR', 'cf-job-executor', 'http://172.27.0.5:6080/', '2025-09-22 13:28:55');



-- ----------------------------
-- Records of xxl_job_user
-- ----------------------------
INSERT INTO `xxl_job_user` VALUES (1, 'admin', '17c5381f3f2036518b1d464ca1237fe9', 1, NULL);
INSERT INTO `xxl_job_user` VALUES (2, 'system', '6b7754cc771284da49d560729e73a9fd', 1, '');



SET FOREIGN_KEY_CHECKS = 1;
