/*
 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:关闭');
INSERT INTO `sys_config` VALUES (11, '000000', '维修人员USER_ID', 'sys.repair.userIds', '5,6', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修人员ID');
INSERT INTO `sys_config` VALUES (12, '000000', '可入孵出库的蛋类型', 'breeding:eggStore:incubation:eggType', '1,2,3', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修人员ID');
INSERT INTO `sys_config` VALUES (13, '000000', '仓库管理人员Ids', 'erp:Store:userIds', '1,2,3', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修人员ID');
INSERT INTO `sys_config` VALUES (14, '000000', '实验审核人员USER_ID', 'sys.experiment.review.userIds', '8,9', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '实验审核人员ID');
INSERT INTO `sys_config` VALUES (15, '000000', '销售组织结构ID', 'erp:sale:org:id', '1001', 'Y', 100, 1, '2025-10-28 16:36:05', 1, '2025-10-28 16:36:33', NULL);


-- ----------------------------
-- 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 (41, '000000', 0, '未读', '0', 'sys_notice_read_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '未读');
INSERT INTO `sys_dict_data` VALUES (42, '000000', 0, '已读', '1', 'sys_notice_read_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已读');
INSERT INTO `sys_dict_data` VALUES (100, '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 (101, '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 (102, '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 (103, '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 (104, '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 (105, '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 (106, '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 (107, '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 (108, '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 (109, '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 (111, '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 (112, '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 (114, '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 (115, '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 (116, '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 (117, '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 (119, '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 (120, '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 (121, '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 (122, '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 (123, '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 (124, '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 (125, '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 (126, '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 (127, '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 (128, '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 (129, '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 (130, '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 (131, '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 (132, '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 (133, '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 (134, '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 (135, '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 (136, '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 (137, '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 (138, '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 (140, '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 (141, '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 (142, '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 (143, '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 (172, '000000', 9, '转群', '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 (144, '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 (145, '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 (146, '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 (171, '000000', 9, '转群', '3', '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 (147, '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 (148, '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 (150, '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 (151, '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 (152, '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 (153, '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 (154, '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 (155, '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 (156, '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 (157, '000000', 1, '祖代厂孵化', '1', '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 (158, '000000', 2, '食堂', '2', '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 (159, '000000', 3, '实验室', '3', '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 (160, '000000', 4, '菜蛋销售', '4', '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 (161, '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 (162, '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 (163, '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 (164, '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 (165, '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 (166, '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 (167, '000000', 1, '育种厂', '0', '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 (173, '000000', 2, '祖代厂', '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 (168, '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 (169, '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 (170, '000000', 3, '未知', '2', 'chicken_gender', NULL, NULL, 'N', 100, 1, '2025-09-08 09:06:34', 1, '2025-09-08 09:06:34', NULL);
INSERT INTO `sys_dict_data` VALUES (174, '000000', 1, '育种厂', '0', 'batch_type', NULL, NULL, 'N', 100, 1, '2025-09-08 09:06:34', 1, '2025-09-08 09:06:34', NULL);
INSERT INTO `sys_dict_data` VALUES (175, '000000', 2, '祖代厂', '1', 'batch_type', NULL, NULL, 'N', 100, 1, '2025-09-08 09:06:34', 1, '2025-09-08 09:06:34', NULL);
INSERT INTO `sys_dict_data` VALUES (176, '000000', 3, '育种转祖代', '2', 'batch_type', 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 (13, '000000', '消息阅读状态', 'sys_notice_read_status', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '0：未读 1：已读');

INSERT INTO `sys_dict_type` VALUES (100, '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 (101, '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 (102, '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 (103, '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 (104, '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 (105, '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 (106, '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 (107, '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 (108, '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 (109, '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 (110, '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 (111, '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 (112, '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 (114, '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 (115, '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 (116, '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 (117, '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 (118, '000000', '厂区信息', 'factory_info', 100, 1, '2025-08-18 11:57:49', 1, '2025-08-18 11:57:49', '厂区信息');
INSERT INTO `sys_dict_type` VALUES (119, '000000', '批次类型', 'batch_type', 100, 1, '2025-07-17 14:22:12', 1, '2025-07-17 14:22:12', '状态（0:新建, 1:育成中, 2:完成）');

INSERT INTO `sys_dict_type` VALUES (301, '000000', '设备状态', 'device_status', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '0：正常运行 1：维修中 2：带病运行 3：退役');
INSERT INTO `sys_dict_data` VALUES (301, '000000', 0, '正常运行', '0', 'device_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修中');
INSERT INTO `sys_dict_data` VALUES (302, '000000', 0, '维修中', '1', 'device_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修中');
INSERT INTO `sys_dict_data` VALUES (303, '000000', 0, '带病运行', '2', 'device_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '带病运行');
INSERT INTO `sys_dict_data` VALUES (304, '000000', 0, '退役', '3', 'device_status', '', 'info', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '退役');

INSERT INTO `sys_dict_type` VALUES (302, '000000', '设备工单类型', 'device_order_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:故障报修 2:设备保养 3:清洁 4:消毒');
INSERT INTO `sys_dict_data` VALUES (307, '000000', 0, '故障报修', '1', 'device_order_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '故障报修');
INSERT INTO `sys_dict_data` VALUES (308, '000000', 0, '设备保养', '2', 'device_order_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备保养');
INSERT INTO `sys_dict_data` VALUES (309, '000000', 0, '清洁', '3', 'device_order_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '清洁');
INSERT INTO `sys_dict_data` VALUES (310, '000000', 0, '消毒', '4', 'device_order_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '消毒');

INSERT INTO `sys_dict_type` VALUES (303, '000000', '设备工单状态', 'device_order_status', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '0:待处理 1:处理中 2:已暂缓 3:待验收 4:验收未通过 5:已完成');
INSERT INTO `sys_dict_data` VALUES (311, '000000', 0, '待处理', '0', 'device_order_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '待处理');
INSERT INTO `sys_dict_data` VALUES (312, '000000', 0, '处理中', '1', 'device_order_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '处理中');
INSERT INTO `sys_dict_data` VALUES (313, '000000', 0, '已暂缓', '2', 'device_order_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已暂缓');
INSERT INTO `sys_dict_data` VALUES (314, '000000', 0, '待验收', '3', 'device_order_status', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '待验收');
INSERT INTO `sys_dict_data` VALUES (315, '000000', 0, '验收未通过', '4', 'device_order_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收未通过');
INSERT INTO `sys_dict_data` VALUES (316, '000000', 0, '已完成', '5', 'device_order_status', '', 'default', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已完成');

INSERT INTO `sys_dict_type` VALUES (304, '000000', '工单流转类型', 'device_order_flow_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:创建工单 2:修改工单 3:变更协助人 4:接收工单 5:暂缓工单 6:恢复工单 7:提交验收 8:验收通过 9:验收拒绝');
INSERT INTO `sys_dict_data` VALUES (319, '000000', 0, '创建工单', '1', 'device_order_flow_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '创建工单');
INSERT INTO `sys_dict_data` VALUES (320, '000000', 0, '修改工单', '2', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '修改工单');
INSERT INTO `sys_dict_data` VALUES (321, '000000', 0, '变更协助人', '3', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '变更协助人');
INSERT INTO `sys_dict_data` VALUES (322, '000000', 0, '接收工单', '4', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '接收工单');
INSERT INTO `sys_dict_data` VALUES (323, '000000', 0, '暂缓工单', '5', 'device_order_flow_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '暂缓工单');
INSERT INTO `sys_dict_data` VALUES (324, '000000', 0, '恢复工单', '6', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '恢复工单');
INSERT INTO `sys_dict_data` VALUES (325, '000000', 0, '提交验收', '7', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '提交验收');
INSERT INTO `sys_dict_data` VALUES (326, '000000', 0, '验收通过', '8', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收通过');
INSERT INTO `sys_dict_data` VALUES (327, '000000', 0, '验收拒绝', '9', 'device_order_flow_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收拒绝');

INSERT INTO `sys_dict_type` VALUES (305, '000000', '任务类型', 'device_task_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:设备保养 2:设备清洁');
INSERT INTO `sys_dict_data` VALUES (331, '000000', 0, '设备保养', '1', 'device_task_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备保养');
INSERT INTO `sys_dict_data` VALUES (332, '000000', 0, '设备清洁', '2', 'device_task_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备清洁');
INSERT INTO `sys_dict_data` VALUES (333, '000000', 0, '设备消毒', '3', 'device_task_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备消毒');

INSERT INTO `sys_dict_type` VALUES (306, '000000', '清洁类型', 'device_clean_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:清洁 2:消毒');
INSERT INTO `sys_dict_data` VALUES (335, '000000', 0, '清洁', '1', 'device_clean_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '清洁');
INSERT INTO `sys_dict_data` VALUES (336, '000000', 0, '消毒', '2', 'device_clean_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '消毒');

INSERT INTO `sys_dict_type` VALUES (307, '000000', '点检签到类型', 'device_inspection_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '0:未签到 1:签到');
INSERT INTO `sys_dict_data` VALUES (341, '000000', 0, '未签到', '0', 'device_inspection_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '未签到');
INSERT INTO `sys_dict_data` VALUES (342, '000000', 0, '签到', '1', 'device_inspection_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '签到');

INSERT INTO `sys_dict_type` VALUES (311, '000000', '实验样品类型', 'experiment_sample_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1：血液 2：粪便');
INSERT INTO `sys_dict_data` VALUES (351, '000000', 0, '血液', '1', 'experiment_sample_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '血液');
INSERT INTO `sys_dict_data` VALUES (352, '000000', 0, '粪便', '2', 'experiment_sample_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '粪便');

INSERT INTO `sys_dict_type` VALUES (312, '000000', '实验样品状态', 'experiment_sample_status', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1：新建 2：已采样 3：实验中 4：已销毁');
INSERT INTO `sys_dict_data` VALUES (355, '000000', 0, '已创建', '1', 'experiment_sample_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '新建');
INSERT INTO `sys_dict_data` VALUES (356, '000000', 0, '已采样', '2', 'experiment_sample_status', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已采样');
INSERT INTO `sys_dict_data` VALUES (357, '000000', 0, '实验中', '3', 'experiment_sample_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '实验中');
INSERT INTO `sys_dict_data` VALUES (358, '000000', 0, '已销毁', '4', 'experiment_sample_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已销毁');

INSERT INTO `sys_dict_type` VALUES (313, '000000', '实验类型', 'experiment_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1：平板凝集-沙门氏菌 2：ELISA-白血病P27抗原 3：ELISA-抗体 4：荧光定量PCR 5：HI-抗体');
INSERT INTO `sys_dict_data` VALUES (361, '000000', 0, '平板凝集-沙门氏菌', '1', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '平板凝集-沙门氏菌');
INSERT INTO `sys_dict_data` VALUES (362, '000000', 0, 'ELISA-白血病P27抗原', '2', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, 'ELISA-白血病P27抗原');
INSERT INTO `sys_dict_data` VALUES (363, '000000', 0, 'ELISA-抗体', '3', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, 'ELISA-抗体');
INSERT INTO `sys_dict_data` VALUES (364, '000000', 0, '荧光定量PCR', '4', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '荧光定量PCR');
INSERT INTO `sys_dict_data` VALUES (365, '000000', 0, 'HI-抗体', '5', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, 'HI-抗体');

INSERT INTO `sys_dict_type` VALUES (314, '000000', '实验状态', 'experiment_status', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1：新建 2：进行中 3：审核中 4：发回报告 5：已结束');
INSERT INTO `sys_dict_data` VALUES (371, '000000', 0, '未开始', '1', 'experiment_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '新建');
INSERT INTO `sys_dict_data` VALUES (372, '000000', 0, '进行中', '2', 'experiment_status', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '进行中');
INSERT INTO `sys_dict_data` VALUES (373, '000000', 0, '审核中', '3', 'experiment_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '审核中');
INSERT INTO `sys_dict_data` VALUES (374, '000000', 0, '发回报告', '4', 'experiment_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '发回报告');
INSERT INTO `sys_dict_data` VALUES (375, '000000', 0, '已结束', '5', 'experiment_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已结束');


INSERT INTO `sys_dict_type` VALUES (501, '000000', '仓库类型', 'store_house_type', 100, 1, '2025-10-15 12:00:00',  NULL, NULL, '1:故障报修 2:保养管理');
INSERT INTO `sys_dict_data` VALUES (501, '000000', 1, '饲料场原料仓库', '1', 'store_house_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '故障报修');
INSERT INTO `sys_dict_data` VALUES (502, '000000', 2, '饲料场半成品仓库', '2', 'store_house_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '保养管理');
INSERT INTO `sys_dict_data` VALUES (503, '000000', 3, '五金仓库', '3', 'store_house_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '保养管理');

INSERT INTO `sys_dict_type` VALUES (510, '000000', '种蛋类型', 'egg_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '蛋分类（1:纯系种蛋, 2:祖代蛋, 3:父母代蛋, 4:菜蛋, 3:畸形蛋, 4:破蛋）');
INSERT INTO `sys_dict_data` VALUES (511, '000000', 1, '纯系种蛋', '1', '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 (512, '000000', 2, '祖代蛋', '2', '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 (513, '000000', 3, '父母代蛋', '3', '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 (514, '000000', 3, '菜蛋', '3', '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 (515, '000000', 3, '畸形蛋', '3', '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 (516, '000000', 3, '破蛋', '3', '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_type` VALUES (520, '000000', '供应商等级', 'supplier_level', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '供应商等级分类（1:一级, 2:二级, 3:三级）');
INSERT INTO `sys_dict_data` VALUES (521, '000000', 1, '一级', '1', 'supplier_level', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (522, '000000', 2, '二级', '2', 'supplier_level', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (523, '000000', 3, '三级', '2', 'supplier_level', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (530, '000000', '物品类型', 'item_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '供应商等级分类（1:一级, 2:二级, 3:三级）');
INSERT INTO `sys_dict_data` VALUES (531, '000000', 1, '实体物品', '1', 'item_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (532, '000000', 2, '虚拟物品', '2', 'item_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (533, '000000', 9, '其它', '3', 'item_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (540, '000000', '单位类型', 'unit_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '供应商等级分类（1:一级, 2:二级, 3:三级）');
INSERT INTO `sys_dict_data` VALUES (541, '000000', 1, '长度', '1', 'unit_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (542, '000000', 2, '重量', '2', 'unit_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (543, '000000', 3, '体积', '3', 'unit_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 (544, '000000', 4, '通用数量', '4', 'unit_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);


INSERT INTO `sys_dict_type` VALUES (550, '000000', '入库业务类型', 'in_business_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '入库业务类型 普通采购、定期采购等');
INSERT INTO `sys_dict_data` VALUES (551, '000000', 1, '普通采购', '1', 'in_business_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (552, '000000', 2, '定期采购', '2', 'in_business_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (553, '000000', 3, '加工生产', '3', 'in_business_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);


INSERT INTO `sys_dict_type` VALUES (560, '000000', '入库种类', 'in_store_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '入库种类:（采购等）');
INSERT INTO `sys_dict_data` VALUES (561, '000000', 1, '采购', '1', 'in_store_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (562, '000000', 2, '半成品生产', '2', 'in_store_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);


INSERT INTO `sys_dict_type` VALUES (570, '000000', '出库业务类型', 'out_business_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '出库业务类型 直接领料，生产补料等');
INSERT INTO `sys_dict_data` VALUES (571, '000000', 1, '直接领料', '1', 'out_business_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (572, '000000', 2, '生产补料', '2', 'out_business_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);


INSERT INTO `sys_dict_type` VALUES (580, '000000', '出库种类', 'out_store_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '入库类别:（材料出库等）');
INSERT INTO `sys_dict_data` VALUES (581, '000000', 1, '材料出库', '1', 'out_store_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (582, '000000', 2, '半成品生产', '2', 'out_store_type', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (590, '000000', '仓库出入库状态', 'store_in_out_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '出入库状态:（0：待审核 1：通过 2：未通过）');
INSERT INTO `sys_dict_data` VALUES (591, '000000', 1, '待审核', '1', 'store_in_out_status', 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 (592, '000000', 2, '通过', '2', 'store_in_out_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (593, '000000', 3, '未通过', '3', 'store_in_out_status', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (594, '000000', 4, '作废', '4', 'store_in_out_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (600, '000000', '生产业务类型', 'production_business_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '出入库状态:（0：待审核 1：通过 2：未通过）');
INSERT INTO `sys_dict_data` VALUES (601, '000000', 1, '自制加工', '1', 'production_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (610, '000000', '生产单状态', 'production_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '生产单状态:（0：待审核 1：通过 2：未通过）');
INSERT INTO `sys_dict_data` VALUES (611, '000000', 1, '待审核', '1', 'production_status', 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 (612, '000000', 2, '通过', '2', 'production_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (613, '000000', 3, '未通过', '3', 'production_status', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (614, '000000', 4, '作废', '4', 'production_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (620, '000000', '客户类型', 'customer_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '生产单状态:（0：待审核 1：通过 2：未通过）');
INSERT INTO `sys_dict_data` VALUES (621, '000000', 1, '客户', '1', 'customer_type', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (622, '000000', 2, '供应商', '2', 'customer_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (630, '000000', '客户等级', 'customer_level', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '生产单状态:（0：待审核 1：通过 2：未通过）');
INSERT INTO `sys_dict_data` VALUES (631, '000000', 1, '一级', '1', 'customer_level', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (632, '000000', 2, '二级', '2', 'customer_level', 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 (633, '000000', 2, '三级', '3', 'customer_level', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (640, '000000', '客户销售绑定状态', 'customer_sale_bind_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '客户销售绑定状态:（ 1：绑定 2：已解绑）');
INSERT INTO `sys_dict_data` VALUES (641, '000000', 1, '绑定', '1', 'customer_sale_bind_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (642, '000000', 2, '已解绑', '2', 'customer_sale_bind_status', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (650, '000000', '订单状态', 'order_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '订单状态:（ 1：待审核 2：已审核 3:结清 4：退订中 5：已退订）');
INSERT INTO `sys_dict_data` VALUES (651, '000000', 1, '待审核', '1', 'order_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (652, '000000', 2, '已审核', '2', 'order_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (653, '000000', 3, '已结清', '3', 'order_status', 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 (654, '000000', 4, '退订中', '4', 'order_status', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (655, '000000', 5, '已退订', '5', 'order_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);

INSERT INTO `sys_dict_type` VALUES (660, '000000', '订单明细状态', 'order_item_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '订单明细状态:（ 1：待审核 2：已审核 3:已发货 4：退订中 5：已退订）');
INSERT INTO `sys_dict_data` VALUES (661, '000000', 1, '待审核', '1', 'order_item_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (662, '000000', 2, '已审核', '2', 'order_item_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (663, '000000', 3, '已发货', '3', 'order_item_status', 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 (664, '000000', 4, '退订中', '4', 'order_item_status', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);
INSERT INTO `sys_dict_data` VALUES (665, '000000', 5, '已退订', '5', 'order_item_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL);







-- ----------------------------
-- 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, '');







-- 一期带来的业务初始数据 --------------------------------
INSERT INTO `f_chicken_coop` VALUES (11, '02-001', '测定3舍', 1440, 0, 1, '0', NULL, 100, '1', 1, '2025-09-06 11:25:17', 1, '2025-09-07 08:37:41', NULL);
INSERT INTO `f_chicken_coop` VALUES (12, '02-002', ' 测定4舍', 1440, 0, 1, '0', NULL, 100, '1', 1, '2025-09-06 11:25:43', 1, '2025-09-07 08:38:03', NULL);
INSERT INTO `f_chicken_coop` VALUES (13, '03-001', '测定1舍', 1920, 0, 1, '0', NULL, 100, '1', 1, '2025-09-06 11:26:00', 1, '2025-09-07 08:38:55', NULL);
INSERT INTO `f_chicken_coop` VALUES (14, '2-003', '育成3舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:31:39', 1, '2025-09-07 08:52:56', NULL);
INSERT INTO `f_chicken_coop` VALUES (15, '2-004', '育成4舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:32:00', 1, '2025-09-07 08:52:59', NULL);
INSERT INTO `f_chicken_coop` VALUES (16, '2-005', '育成5舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:32:16', 1, '2025-09-07 08:53:02', NULL);
INSERT INTO `f_chicken_coop` VALUES (17, '2-006', '育成6舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:32:31', 1, '2025-09-07 08:53:05', NULL);
INSERT INTO `f_chicken_coop` VALUES (18, '2-006', '育成7舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:32:39', 1, '2025-09-07 08:33:38', NULL);
INSERT INTO `f_chicken_coop` VALUES (19, '2-007', '育成7舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:33:58', 1, '2025-09-07 08:53:07', NULL);
INSERT INTO `f_chicken_coop` VALUES (20, '2-008', '育成8', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:34:19', 1, '2025-09-07 08:53:09', NULL);
INSERT INTO `f_chicken_coop` VALUES (21, '2-009', '育成9', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:34:28', 1, '2025-09-07 08:53:11', NULL);
INSERT INTO `f_chicken_coop` VALUES (22, '2-010', '育成10', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:34:45', 1, '2025-09-07 08:53:13', NULL);
INSERT INTO `f_chicken_coop` VALUES (23, '2-011', '育成11', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:35:10', 1, '2025-09-07 08:53:15', NULL);
INSERT INTO `f_chicken_coop` VALUES (24, '2-012', '育成12', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:35:18', 1, '2025-09-07 08:53:17', NULL);
INSERT INTO `f_chicken_coop` VALUES (25, '03-002', '测定2舍', 1920, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:38:37', 1, '2025-09-07 08:39:30', NULL);
INSERT INTO `f_chicken_coop` VALUES (26, '03-001', '测定1舍', 1920, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:39:12', 1, '2025-09-07 08:53:19', NULL);
INSERT INTO `f_chicken_coop` VALUES (27, '03-002', '测定2舍', 1920, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:39:44', 1, '2025-09-07 08:53:21', NULL);
INSERT INTO `f_chicken_coop` VALUES (28, '03-003', '测定3舍', 1440, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:39:58', 1, '2025-09-07 08:53:23', NULL);
INSERT INTO `f_chicken_coop` VALUES (29, '03-004', '测定4舍', 1440, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:40:10', 1, '2025-09-07 08:53:25', NULL);
INSERT INTO `f_chicken_coop` VALUES (30, '02-003', '育成3舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:02:00', 1, '2025-09-07 09:02:00', NULL);
INSERT INTO `f_chicken_coop` VALUES (31, '02-004', '育成4舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:02:44', 1, '2025-09-07 09:02:44', NULL);
INSERT INTO `f_chicken_coop` VALUES (32, '02-005', '育成5舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:01', 1, '2025-09-07 09:08:01', NULL);
INSERT INTO `f_chicken_coop` VALUES (33, '02-006', '育成6舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:12', 1, '2025-09-07 09:08:12', NULL);
INSERT INTO `f_chicken_coop` VALUES (34, '02-007', '育成7舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:21', 1, '2025-09-07 09:08:21', NULL);
INSERT INTO `f_chicken_coop` VALUES (35, '02-008', '育成8舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:31', 1, '2025-09-07 09:08:31', NULL);
INSERT INTO `f_chicken_coop` VALUES (36, '02-009', '育成9舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:39', 1, '2025-09-07 09:08:39', NULL);
INSERT INTO `f_chicken_coop` VALUES (37, '02-010', '育成10舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:50', 1, '2025-09-07 09:08:50', NULL);
INSERT INTO `f_chicken_coop` VALUES (38, '02-011', '育成11舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:56', 1, '2025-09-07 09:09:08', NULL);
INSERT INTO `f_chicken_coop` VALUES (39, '02-012', '育成12舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:09:18', 1, '2025-09-07 09:09:18', NULL);
INSERT INTO `f_chicken_coop` VALUES (40, '03-001', '测定1舍', 1920, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:10:11', 1, '2025-09-07 09:10:11', NULL);
INSERT INTO `f_chicken_coop` VALUES (41, '03-002', '测定2舍', 1920, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:12:08', 1, '2025-09-07 09:12:08', NULL);
INSERT INTO `f_chicken_coop` VALUES (42, '03-003', '测定3舍', 1440, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:12:24', 1, '2025-09-07 09:12:24', NULL);
INSERT INTO `f_chicken_coop` VALUES (43, '03-004', '测定4舍', 1440, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:12:44', 1, '2025-09-07 09:12:44', NULL);

INSERT INTO `f_chicken_cage` VALUES (24, '02-001-1-810', 11, NULL, 0, 8, 100, 1, '2025-09-06 11:26:37', 1, '2025-09-07 08:37:22', NULL, '1');
INSERT INTO `f_chicken_cage` VALUES (25, '02-002-1-810', 12, NULL, 0, 8, 100, 1, '2025-09-06 11:26:47', 1, '2025-09-07 08:37:57', NULL, '1');
INSERT INTO `f_chicken_cage` VALUES (26, '2-003-810', 14, NULL, 0, 8, 100, 1, '2025-09-07 08:42:29', 1, '2025-09-07 08:51:55', NULL, '1');
INSERT INTO `f_chicken_cage` VALUES (27, '2-004-2-004-810', 15, NULL, 0, 810, 100, 1, '2025-09-07 08:50:53', 1, '2025-09-07 08:51:02', NULL, '1');
INSERT INTO `f_chicken_cage` VALUES (28, '02-003-810', 30, NULL, 0, 8, 100, 1, '2025-09-07 09:03:26', 1, '2025-09-07 09:04:05', NULL, '1');
INSERT INTO `f_chicken_cage` VALUES (29, '02-003-1-810', 30, NULL, 0, 8, 100, 1, '2025-09-07 15:10:24', 1, '2025-09-07 15:10:24', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (30, '02-004-1-810', 31, NULL, 0, 8, 100, 1, '2025-09-07 15:10:48', 1, '2025-09-07 15:10:48', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (31, '02-005-1-810', 32, NULL, 0, 8, 100, 1, '2025-09-07 15:11:00', 1, '2025-09-07 15:11:00', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (32, '02-006-1-810', 33, NULL, 0, 8, 100, 1, '2025-09-07 15:11:23', 1, '2025-09-07 15:11:23', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (33, '02-007-1-810', 34, NULL, 0, 8, 100, 1, '2025-09-07 15:11:30', 1, '2025-09-07 15:11:30', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (34, '02-008-1-810', 35, NULL, 0, 8, 100, 1, '2025-09-07 15:11:42', 1, '2025-09-07 15:11:42', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (35, '02-009-1-810', 36, NULL, 0, 8, 100, 1, '2025-09-07 15:11:51', 1, '2025-09-07 15:11:51', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (36, '02-010-1-810', 37, NULL, 0, 8, 100, 1, '2025-09-07 15:11:57', 1, '2025-09-07 15:11:57', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (37, '02-011-1-810', 38, NULL, 0, 8, 100, 1, '2025-09-07 15:12:04', 1, '2025-09-07 15:12:04', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (38, '02-012-1-810', 39, NULL, 0, 8, 100, 1, '2025-09-07 15:12:09', 1, '2025-09-07 15:12:09', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (39, '03-001-1-1920', 40, NULL, 0, 1, 100, 1, '2025-09-07 15:12:31', 1, '2025-09-07 15:12:31', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (40, '03-002-1-1920', 41, NULL, 0, 1, 100, 1, '2025-09-07 15:12:45', 1, '2025-09-07 15:12:45', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (41, '03-003-1-1440', 42, NULL, 0, 1, 100, 1, '2025-09-07 15:12:59', 1, '2025-09-07 15:12:59', NULL, '0');
INSERT INTO `f_chicken_cage` VALUES (42, '03-004-1-1440', 43, NULL, 0, 1, 100, 1, '2025-09-07 15:13:06', 1, '2025-09-07 15:13:06', NULL, '0');

INSERT INTO `f_feed` VALUES (12, '育雏前期料', NULL, 0, 100, 1, '2025-09-17 11:30:03', 1, '2025-09-17 11:30:03', NULL, '0');
INSERT INTO `f_feed` VALUES (13, '育雏后期料', NULL, 0, 100, 1, '2025-09-17 11:30:28', 1, '2025-09-17 11:30:28', NULL, '0');
INSERT INTO `f_feed` VALUES (14, '育成料', NULL, 0, 100, 1, '2025-09-17 11:30:36', 1, '2025-09-17 11:30:36', NULL, '0');
INSERT INTO `f_feed` VALUES (15, '低能肉鸡料（三段料）', NULL, 0, 100, 1, '2025-09-17 11:31:11', 1, '2025-09-17 11:31:11', NULL, '0');
INSERT INTO `f_feed` VALUES (16, '预产料', NULL, 0, 100, 1, '2025-09-17 11:31:27', 1, '2025-09-17 11:31:27', NULL, '0');
INSERT INTO `f_feed` VALUES (17, '产蛋前期料', NULL, 0, 100, 1, '2025-09-17 11:31:40', 1, '2025-09-17 11:31:40', NULL, '0');
INSERT INTO `f_feed` VALUES (18, '产蛋中期料', NULL, 0, 100, 1, '2025-09-17 11:31:52', 1, '2025-09-17 11:31:52', NULL, '0');
INSERT INTO `f_feed` VALUES (19, '产蛋后期料', NULL, 0, 100, 1, '2025-09-17 11:31:59', 1, '2025-09-17 11:31:59', NULL, '0');
INSERT INTO `f_feed` VALUES (20, '种公鸡料', NULL, 0, 100, 1, '2025-09-17 11:32:10', 1, '2025-09-17 11:32:10', NULL, '0');



INSERT INTO `f_vaccine` VALUES (10, '威支灵', 1, '勃林格', '2025-04-29', '2026-04-28', 0, NULL, 100, 1, '2025-09-17 10:29:20', 1, '2025-09-17 10:29:20', '0');
INSERT INTO `f_vaccine` VALUES (11, 'IB4-91', 1, '勃林格', '2024-10-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 10:30:59', 1, '2025-09-17 10:30:59', '0');
INSERT INTO `f_vaccine` VALUES (12, 'IB4-91', 1, '勃林格', '2024-10-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 10:35:06', 1, '2025-09-17 10:35:06', '0');
INSERT INTO `f_vaccine` VALUES (13, 'REO1133', 1, '默沙东', '2024-05-01', '2026-04-01', 0, NULL, 100, 1, '2025-09-17 10:37:17', 1, '2025-09-17 10:37:17', '0');
INSERT INTO `f_vaccine` VALUES (14, 'ND+IB二联油', 1, '默沙东', '2024-10-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 11:02:43', 1, '2025-09-17 11:02:43', '0');
INSERT INTO `f_vaccine` VALUES (15, 'ND+IB二联油', 0, '默沙东', '2024-10-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 11:04:54', 1, '2025-09-17 11:04:54', '0');
INSERT INTO `f_vaccine` VALUES (16, '喉痘', 1, '法国诗华', '2024-02-28', '2026-02-28', 0, NULL, 100, 1, '2025-09-17 11:09:31', 1, '2025-09-17 11:09:31', '0');
INSERT INTO `f_vaccine` VALUES (17, '沙门氏活苗SE', 1, '美国礼蓝', '2024-09-01', '2026-08-01', 0, NULL, 100, 1, '2025-09-17 11:12:18', 1, '2025-09-17 11:12:18', '0');
INSERT INTO `f_vaccine` VALUES (18, 'ND+IB+H9三联油苗', 0, '青岛易邦', '2025-06-17', '2026-06-16', 0, NULL, 100, 1, '2025-09-17 11:13:49', 1, '2025-09-17 11:13:49', '0');
INSERT INTO `f_vaccine` VALUES (19, 'Ma5clone30', 1, '默沙东', '2024-09-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 11:15:31', 1, '2025-09-17 11:15:31', '0');
INSERT INTO `f_vaccine` VALUES (20, '青岛H5+H7', 0, '青岛易邦', '2025-04-20', '2026-04-19', 0, NULL, 100, 1, '2025-09-17 11:16:33', 1, '2025-09-17 11:16:33', '0');
INSERT INTO `f_vaccine` VALUES (21, 'MG活苗（6/85株）', 1, '默沙东', '2024-01-01', '2026-03-01', 0, NULL, 100, 1, '2025-09-17 11:17:45', 1, '2025-09-17 11:17:45', '0');
INSERT INTO `f_vaccine` VALUES (22, 'IC铝胶苗', 0, '日本北里', '2025-02-01', '2027-02-06', 0, NULL, 100, 1, '2025-09-17 11:18:37', 1, '2025-09-17 11:18:37', '0');
INSERT INTO `f_vaccine` VALUES (23, 'ND+H9+FADV三联油苗', 0, '瑞普', '2025-01-02', '2026-07-04', 0, NULL, 100, 1, '2025-09-17 11:19:34', 1, '2025-09-17 11:19:34', '0');
INSERT INTO `f_vaccine` VALUES (24, 'H5+H7二联油苗', 0, '华南生物', '2025-04-02', '2026-04-01', 0, NULL, 100, 1, '2025-09-17 11:20:25', 1, '2025-09-17 11:20:25', '0');
INSERT INTO `f_vaccine` VALUES (25, 'CAV', 1, '默沙东', '2024-04-01', '2026-03-01', 0, NULL, 100, 1, '2025-09-17 11:21:17', 1, '2025-09-17 11:21:17', '0');
INSERT INTO `f_vaccine` VALUES (26, 'REO油苗', 0, '美国礼蓝', '2024-09-01', '2026-02-01', 0, NULL, 100, 1, '2025-09-17 11:22:07', 1, '2025-09-17 11:22:07', '0');
INSERT INTO `f_vaccine` VALUES (27, 'ILT（爱乐啼）', 0, '默沙东', '2024-01-09', '2027-01-08', 0, NULL, 100, 1, '2025-09-17 11:22:52', 1, '2025-09-17 11:22:52', '0');
INSERT INTO `f_vaccine` VALUES (28, 'AE+POX', 1, '默沙东', '2024-02-01', '2027-01-01', 0, NULL, 100, 1, '2025-09-17 11:23:46', 1, '2025-09-17 11:23:46', '0');
INSERT INTO `f_vaccine` VALUES (29, 'ILT（爱乐啼）', 1, '默沙东', '2024-01-09', '2027-01-08', 0, NULL, 100, 1, '2025-09-17 11:24:29', 1, '2025-09-17 11:24:29', '0');
INSERT INTO `f_vaccine` VALUES (30, 'ND+IB+H9+EDS', 0, '瑞普', '2024-04-01', '2027-04-07', 0, NULL, 100, 1, '2025-09-17 11:25:48', 1, '2025-09-17 11:25:48', '0');
INSERT INTO `f_vaccine` VALUES (31, 'MG油苗', 0, '瑞普', '2025-01-03', '2026-01-06', 0, NULL, 100, 1, '2025-09-17 11:26:37', 1, '2025-09-17 11:26:37', '0');
INSERT INTO `f_vaccine` VALUES (32, 'ND+IB+IBD+REO', 0, '默沙东', '2024-12-01', '2026-05-01', 0, NULL, 100, 1, '2025-09-17 11:27:28', 1, '2025-09-17 11:27:28', '0');
INSERT INTO `f_vaccine` VALUES (33, '沙门氏菌灭活疫苗', 0, '默沙东', '2025-05-01', '2027-11-01', 0, NULL, 100, 1, '2025-09-17 11:28:53', 1, '2025-09-17 11:28:53', '0');

INSERT INTO `f_drug` VALUES (9, '林可大观霉素', '北京康牧生物科技有限公司', '2024-11-07', '2026-11-06', 0, NULL, 100, 1, '2025-09-17 09:25:25', 1, '2025-09-17 09:25:25', '0');
INSERT INTO `f_drug` VALUES (10, '萜木真', '南京惠环生物科技有限公司', '2024-10-31', '2026-04-30', 0, NULL, 100, 1, '2025-09-17 09:27:01', 1, '2025-09-17 09:27:01', '0');
INSERT INTO `f_drug` VALUES (11, '枝原净', '礼蓝（上海）动物保健有限公司', '2025-01-01', '2027-12-01', 0, NULL, 100, 1, '2025-09-17 09:29:12', 1, '2025-09-17 09:29:12', '0');
INSERT INTO `f_drug` VALUES (12, '佳益多', '荷兰鹰凯动物保健集团', '2024-11-19', '2026-11-19', 0, NULL, 100, 1, '2025-09-17 09:30:30', 1, '2025-09-17 09:30:30', '0');
INSERT INTO `f_drug` VALUES (13, '维金100', '瑞普高科（天津）生物科技有限公司', '2025-03-14', '2027-03-13', 0, NULL, 100, 1, '2025-09-17 09:31:37', 1, '2025-09-17 09:31:37', '0');
INSERT INTO `f_drug` VALUES (14, '塞可新（有机酸）', '多卫捷（河北）生物科技有限公司', '2025-03-17', '2027-03-16', 0, NULL, 100, 1, '2025-09-17 09:32:40', 1, '2025-09-17 09:32:40', '0');
INSERT INTO `f_drug` VALUES (15, '磺胺氯吡嗪钠可溶性粉（安球生）', '南京惠牧生物科技有限公司', '2025-01-02', '2027-01-01', 0, NULL, 100, 1, '2025-09-17 09:33:38', 1, '2025-09-17 09:33:38', '0');
INSERT INTO `f_drug` VALUES (16, '肠治先锋', '南京生物科技有限公司', '2025-05-08', '2027-11-07', 0, NULL, 100, 1, '2025-09-17 09:35:06', 1, '2025-09-17 09:35:06', '0');
INSERT INTO `f_drug` VALUES (17, '百呼清', '南京生物科技有限公司', '2025-01-13', '2027-07-13', 0, NULL, 100, 1, '2025-09-17 09:36:13', 1, '2025-09-17 09:36:13', '0');
INSERT INTO `f_drug` VALUES (18, '山字', '礼蓝（上海）动物保健有限公司', '2024-07-01', '2026-06-30', 0, NULL, 100, 1, '2025-09-17 09:37:07', 1, '2025-09-17 09:37:07', '0');
INSERT INTO `f_drug` VALUES (19, '速服宁', '法国FC有限公司', '2024-07-01', '2026-06-30', 0, NULL, 100, 1, '2025-09-17 09:37:39', 1, '2025-09-17 09:37:39', '0');
INSERT INTO `f_drug` VALUES (20, '阿莫西林', '四川德成动物保健品有限公司', '2024-10-08', '2026-10-07', 0, NULL, 100, 1, '2025-09-17 09:38:28', 1, '2025-09-17 09:38:28', '0');
INSERT INTO `f_drug` VALUES (21, '沃尼妙林', '瑞普（天津）生物药业有限公司', '2025-03-04', '2027-03-03', 0, NULL, 100, 1, '2025-09-17 09:51:54', 1, '2025-09-17 09:51:54', '0');
INSERT INTO `f_drug` VALUES (22, '可安松', '荷兰鹰凯动物保健集团', '2024-11-19', '2026-11-19', 0, NULL, 100, 1, '2025-09-17 09:53:10', 1, '2025-09-17 09:53:10', '0');
INSERT INTO `f_drug` VALUES (23, '球易安', '南京惠环生物科技有限公司', '2025-08-15', '2027-08-15', 0, NULL, 100, 1, '2025-09-17 09:54:04', 1, '2025-09-17 09:54:04', '0');
INSERT INTO `f_drug` VALUES (24, '头孢喹肟', '瑞普生物', '2025-02-26', '2027-02-26', 0, NULL, 100, 1, '2025-09-17 09:55:07', 1, '2025-09-17 09:55:07', '0');
INSERT INTO `f_drug` VALUES (25, '利高', '硕螣动保', '2024-07-01', '2026-06-01', 0, NULL, 100, 1, '2025-09-17 09:56:15', 1, '2025-09-17 09:56:15', '0');
INSERT INTO `f_drug` VALUES (26, '亚易林', '瑞普生物', '2025-04-08', '2025-10-07', 0, NULL, 100, 1, '2025-09-17 09:56:58', 1, '2025-09-17 09:56:58', '0');
INSERT INTO `f_drug` VALUES (27, '乐培', '荷兰鹰凯动物保健集团', '2024-10-31', '2026-10-31', 1, NULL, 100, 1, '2025-09-17 09:58:06', 1, '2025-09-17 09:58:06', '0');

INSERT INTO `f_variety` VALUES (1, '白羽鸡', 'M', 6, '父系', 0, 100, 1, '2025-07-17 13:28:06', 1, '2025-09-06 10:20:30', NULL, '0');
INSERT INTO `f_variety` VALUES (2, '白羽鸡', 'N', 9, '母系', 0, 100, 1, '2025-07-17 13:28:19', 1, '2025-09-06 10:20:39', NULL, '0');
INSERT INTO `f_variety` VALUES (4, '白羽鸡', 'C', 4, '母系', 0, 100, 1, '2025-08-11 16:39:20', 1, '2025-09-06 10:20:51', NULL, '0');
INSERT INTO `f_variety` VALUES (6, '白羽鸡', 'D', 3, '母系', 0, 100, 1, '2025-08-21 12:56:01', 1, '2025-09-06 10:21:01', NULL, '0');
INSERT INTO `f_variety` VALUES (9, '白羽鸡', 'A', 2, '父系', 0, 100, 1, '2025-08-21 13:06:39', 1, '2025-09-06 10:21:15', NULL, '0');

SET FOREIGN_KEY_CHECKS = 1;
