代码拉取完成，页面将自动刷新
同步操作将从 琴海森林/JFinal-layui 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 10.3.13-MariaDB - mariadb.org binary distribution
-- 服务器操作系统: Win64
-- HeidiSQL 版本: 9.5.0.5196
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- 导出 jfinal-layui 的数据库结构
DROP DATABASE IF EXISTS `jfinal-layui`;
CREATE DATABASE IF NOT EXISTS `jfinal-layui` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `jfinal-layui`;
-- 导出 表 jfinal-layui.data_dictionary 结构
DROP TABLE IF EXISTS `data_dictionary`;
CREATE TABLE IF NOT EXISTS `data_dictionary` (
`id` varchar(32) NOT NULL COMMENT '主键',
`code` varchar(255) DEFAULT NULL COMMENT '字典编号',
`name` varchar(255) DEFAULT NULL COMMENT '字典名称',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`order_num` int(11) DEFAULT 1 COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='数据字典';
-- 正在导出表 jfinal-layui.data_dictionary 的数据：~1 rows (大约)
DELETE FROM `data_dictionary`;
/*!40000 ALTER TABLE `data_dictionary` DISABLE KEYS */;
INSERT INTO `data_dictionary` (`id`, `code`, `name`, `remark`, `order_num`) VALUES
('40288ae76812ae55016812bc5be9002c', 'logType', '日志类型', '系统日志，用于演示快速引用业务字典', 1);
/*!40000 ALTER TABLE `data_dictionary` ENABLE KEYS */;
-- 导出 表 jfinal-layui.data_dictionary_value 结构
DROP TABLE IF EXISTS `data_dictionary_value`;
CREATE TABLE IF NOT EXISTS `data_dictionary_value` (
`id` varchar(32) NOT NULL COMMENT '主键',
`value` varchar(255) DEFAULT NULL COMMENT '数据值',
`name` varchar(255) DEFAULT NULL COMMENT '数据名称',
`order_num` int(11) DEFAULT NULL COMMENT '排序',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`dictionary_code` varchar(32) DEFAULT NULL COMMENT '字典编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='字典数据表';
-- 正在导出表 jfinal-layui.data_dictionary_value 的数据：~3 rows (大约)
DELETE FROM `data_dictionary_value`;
/*!40000 ALTER TABLE `data_dictionary_value` DISABLE KEYS */;
INSERT INTO `data_dictionary_value` (`id`, `value`, `name`, `order_num`, `remark`, `dictionary_code`) VALUES
('40288ae76812ae55016812bcc5060037', '操作日志', '操作日志', 1, '字典编号：logType', 'logType'),
('40288ae76812ae55016812bcfc740039', '数据日志', '数据日志', 2, '字典编号：logType', 'logType'),
('40288ae76812ae55016812bd288b003b', '登录日志', '登录日志', 3, '字典编号：logType', 'logType');
/*!40000 ALTER TABLE `data_dictionary_value` ENABLE KEYS */;
-- 导出 表 jfinal-layui.data_dicts 结构
DROP TABLE IF EXISTS `data_dicts`;
CREATE TABLE IF NOT EXISTS `data_dicts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`value` varchar(50) NOT NULL COMMENT '字典值',
`name` varchar(50) NOT NULL COMMENT '字典中文',
`object` varchar(50) NOT NULL COMMENT '表名',
`field` varchar(50) NOT NULL COMMENT '字段名',
`ext` varchar(255) DEFAULT '' COMMENT '扩展Json',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2105 DEFAULT CHARSET=utf8 COMMENT='数据字典';
-- 正在导出表 jfinal-layui.data_dicts 的数据：~1,211 rows (大约)
DELETE FROM `data_dicts`;
/*!40000 ALTER TABLE `data_dicts` DISABLE KEYS */;
INSERT INTO `data_dicts` (`id`, `value`, `name`, `object`, `field`, `ext`) VALUES
(1, '1', '被套', 'product', 'category', ''),
(2, '2', '床单', 'product', 'category', ''),
(3, '3', '浴巾', 'product', 'category', ''),
(4, '4', '毛巾', 'product', 'category', ''),
(5, '5', '枕套', 'product', 'category', ''),
(6, '1', '纯棉', 'product', 'stuff', ''),
(7, '2', '涤纶', 'product', 'stuff', ''),
(8, '3', '纺纱', 'product', 'stuff', ''),
(9, '4', '轻纱', 'product', 'stuff', ''),
(10, '1', '90', 'product', 'size', ''),
(11, '2', '120', 'product', 'size', ''),
(12, '3', '150', 'product', 'size', ''),
(13, '4', '180', 'product', 'size', ''),
(14, '10', '待支付', 'orders', 'state', ''),
(15, '20', '已支付', 'orders', 'state', ''),
(16, '30', '已发货', 'orders', 'state', ''),
(17, '40', '已收货', 'orders', 'state', ''),
(33, '0', '正常', 'users', 'status', ''),
(34, '1', '封号', 'users', 'status', ''),
(35, '2', '禁言', 'users', 'status', ''),
(36, '3', '删除', 'users', 'status', ''),
(54, '0', '坦克', 'users', 'tag', ''),
(55, '1', 'ADC', 'users', 'tag', ''),
(56, '2', '打野', 'users', 'tag', ''),
(57, '3', 'AP', 'users', 'tag', ''),
(58, '0', '普通', 'test_info', 'status', ''),
(59, '1', '禁用', 'test_info', 'status', ''),
(60, '1', '潜水', 'test_info', 'tag', ''),
(61, '2', '冒泡', 'test_info', 'tag', ''),
(62, '3', '活跃', 'test_info', 'tag', ''),
(63, '4', '水货', 'test_info', 'tag', ''),
(64, '5', '喷子', 'test_info', 'tag', ''),
(65, '6', '山炮', 'test_info', 'tag', ''),
(148, '10', '待支付', 'v_orders', 'state', ''),
(149, '20', '已支付', 'v_orders', 'state', ''),
(150, '30', '已发货', 'v_orders', 'state', ''),
(151, '40', '已收货', 'v_orders', 'state', ''),
(158, '0', '国', 'area', 'lv', ''),
(159, '1', '省', 'area', 'lv', ''),
(160, '2', '市', 'area', 'lv', ''),
(161, '3', '区', 'area', 'lv', ''),
(198, '1', '普通商户', 'hotel', 'state', ''),
(199, '2', '签约商户', 'hotel', 'state', ''),
(204, '1', '正常', 'links', 'status', ''),
(205, '2', '禁用', 'links', 'status', ''),
(210, '1', '租赁商品', 'product', 'type', ''),
(211, '2', '积分商品', 'product', 'type', ''),
(273, '0', ' = ', 'yz_wh', 'compare', ''),
(274, '1', ' like ', 'yz_wh', 'compare', ''),
(275, '2', ' in ', 'yz_wh', 'compare', ''),
(276, '0', ' ', 'yz_wh', 'left_border', ''),
(277, '1', '(', 'yz_wh', 'left_border', ''),
(278, '0', ' ', 'yz_wh', 'left_placeholder', ''),
(279, '1', '%', 'yz_wh', 'left_placeholder', ''),
(280, '2', '_', 'yz_wh', 'left_placeholder', ''),
(281, '0', ' ', 'yz_wh', 'right_placeholder', ''),
(282, '1', '%', 'yz_wh', 'right_placeholder', ''),
(283, '2', '_', 'yz_wh', 'right_placeholder', ''),
(286, '0', ' and ', 'yz_wh', 'linked', ''),
(287, '1', ' or ', 'yz_wh', 'linked', ''),
(288, '2', ' and ( ', 'yz_wh', 'linked', ''),
(289, '3', ' or ( ', 'yz_wh', 'linked', ''),
(290, '0', ' ', 'yz_wh', 'right_border', ''),
(291, '1', ')', 'yz_wh', 'right_border', NULL),
(292, '2', '))', 'yz_wh', 'right_border', ''),
(297, '0', '真实', 'yz_fields', 'field_is_field', ''),
(298, '1', '虚拟', 'yz_fields', 'field_is_field', ''),
(299, '0', '顺序', 'yz_order', 'filed_order', ''),
(300, '1', '倒序', 'yz_order', 'filed_order', ''),
(301, '0', '顺序', 'yz_order', 'field_order', ''),
(302, '1', '倒序', 'yz_order', 'field_order', ''),
(303, '3', '浴巾', 'product', 'category', ''),
(308, '0', '全部', 'yz_fields', 'field_show', ''),
(309, '1', '转换值', 'yz_fields', 'field_show', ''),
(310, '2', '原值', 'yz_fields', 'field_show', ''),
(393, '0', '必填项', 'yz_fields', 'is_required', ''),
(394, '1', '选填项', 'yz_fields', 'is_required', ''),
(395, '2', '非必填项', 'yz_fields', 'is_required', ''),
(396, '0', '必填项', 'yz_wh', 'is_required', ''),
(397, '1', '选填项', 'yz_wh', 'is_required', ''),
(398, '2', '非必填项（有就参与sql条件）', 'yz_wh', 'is_required', NULL),
(554, '0', '未认证', 'yz_com', 'cestatus', ''),
(555, '1', '已认证', 'yz_com', 'cestatus', ''),
(565, '0', '目录', 'yz_menu', 'api_type', ''),
(566, '1', '查询接口', 'yz_menu', 'api_type', ''),
(567, '2', '新增接口', 'yz_menu', 'api_type', ''),
(568, '3', '修改接口', 'yz_menu', 'api_type', ''),
(569, '4', '详情接口', 'yz_menu', 'api_type', ''),
(570, '5', '删除接口', 'yz_menu', 'api_type', ''),
(571, '6', '网页接口', 'yz_menu', 'api_type', ''),
(572, '0', '包含', 'yz_menu', 'is_token', ''),
(573, '1', '不包含', 'yz_menu', 'is_token', ''),
(574, '0', '包含', 'yz_menu', 'is_devicetoken', ''),
(575, '1', '不包含', 'yz_menu', 'is_devicetoken', ''),
(576, '0', '无', 'yz_menu', 'is_intercept', ''),
(577, '1', '有', 'yz_menu', 'is_intercept', ''),
(592, '0', '整数', 'nc_device_action', 'rdatatype1', ''),
(593, '1', '浮点1位小数', 'nc_device_action', 'rdatatype1', ''),
(594, '2', '浮点2位小数', 'nc_device_action', 'rdatatype1', ''),
(595, '0', '。C', 'nc_device_action', 'rdataunit1', ''),
(596, '1', '%RH', 'nc_device_action', 'rdataunit1', ''),
(597, '2', 'PPM', 'nc_device_action', 'rdataunit1', ''),
(598, '3', 'Lux', 'nc_device_action', 'rdataunit1', ''),
(599, '0', '整数', 'nc_device_action', 'rdatatype2', ''),
(600, '1', '浮点1位小数', 'nc_device_action', 'rdatatype2', ''),
(601, '2', '浮点2位小数', 'nc_device_action', 'rdatatype2', ''),
(602, '0', '。C', 'nc_device_action', 'rdataunit2', ''),
(603, '1', '%RH', 'nc_device_action', 'rdataunit2', ''),
(604, '2', 'PPM', 'nc_device_action', 'rdataunit2', ''),
(605, '3', 'Lux', 'nc_device_action', 'rdataunit2', ''),
(606, '0', '整数', 'nc_device_action', 'rdatatype3', ''),
(607, '1', '浮点1位小数', 'nc_device_action', 'rdatatype3', ''),
(608, '2', '浮点2位小数', 'nc_device_action', 'rdatatype3', ''),
(609, '0', '。C', 'nc_device_action', 'rdataunit3', ''),
(610, '1', '%RH', 'nc_device_action', 'rdataunit3', ''),
(611, '2', 'PPM', 'nc_device_action', 'rdataunit3', ''),
(612, '3', 'Lux', 'nc_device_action', 'rdataunit3', ''),
(613, '0', '传感器', 'nc_device', 'dtype', ''),
(614, '1', '操控设备', 'nc_device', 'dtype', ''),
(615, '0', '企业', 'yz_com', 'cotype', ''),
(616, '1', '事业单位或社会团体', 'yz_com', 'cotype', ''),
(617, '2', '个体经营', 'yz_com', 'cotype', ''),
(618, '0', '10人以内', 'yz_com', 'comsize', ''),
(619, '1', '10-20人', 'yz_com', 'comsize', ''),
(620, '2', '20-50人', 'yz_com', 'comsize', ''),
(621, '3', '50-100人', 'yz_com', 'comsize', ''),
(622, '4', '100人及以上', 'yz_com', 'comsize', ''),
(623, '0', '非当前棚', 'v_nc_my_facility', 'dvalue', ''),
(624, '1', '当前棚', 'v_nc_my_facility', 'dvalue', ''),
(625, '0', '非当前棚', 'nc_my_facility', 'dvalue', ''),
(626, '1', '当前棚', 'nc_my_facility', 'dvalue', ''),
(633, '0', '不是', 've_quality', 'default', ''),
(634, '1', '是', 've_quality', 'default', ''),
(635, '0', '未登录', 'v_ve_vegroup_manager', 'login_status', ''),
(636, '1', '登录成功', 'v_ve_vegroup_manager', 'login_status', ''),
(637, '2', '登录失败', 'v_ve_vegroup_manager', 'login_status', ''),
(641, '0', '精品', 'v_ve_order', 'quality', ''),
(642, '1', '通货', 'v_ve_order', 'quality', ''),
(643, '2', '精品', 'v_ve_order', 'quality', ''),
(644, '0', '未付款', 'v_ve_order', 'repay_status', ''),
(645, '1', '未付清', 'v_ve_order', 'repay_status', ''),
(646, '2', '已付清', 'v_ve_order', 'repay_status', ''),
(647, '3', ' > ', 'yz_wh', 'compare', NULL),
(648, '4', ' < ', 'yz_wh', 'compare', NULL),
(649, '6', ' <= ', 'yz_wh', 'compare', NULL),
(650, '7', ' >= ', 'yz_wh', 'compare', NULL),
(660, '0', '正常', 'v_ve_group_type', 'states', ''),
(661, '1', '删除', 'v_ve_group_type', 'states', ''),
(662, '0', '不是', 'v_ve_group_type', 'defaults', ''),
(663, '1', '是', 'v_ve_group_type', 'defaults', ''),
(664, '0', '待回款', 'v_ve_bill_sales', 'status', ''),
(665, '1', '未回完', 'v_ve_bill_sales', 'status', ''),
(666, '2', '已回款', 'v_ve_bill_sales', 'status', ''),
(670, '0', '独立市场', 'v_ve_order', 'grouptype', ''),
(671, '1', '多租户市场', 'v_ve_order', 'grouptype', ''),
(672, '2', '租户', 'v_ve_order', 'grouptype', ''),
(675, '0', '生效', 'v_ve_vegroup_order', 'status', ''),
(676, '1', '取消', 'v_ve_vegroup_order', 'status', ''),
(677, '0', '生效', 'v_ve_vegroup_order3', 'STATUS', ''),
(678, '1', '取消', 'v_ve_vegroup_order3', 'STATUS', ''),
(679, '2', '完成订单', 'v_ve_vegroup_order3', 'STATUS', ''),
(682, '0', '交易中', 'v_ve_order', 'state', ''),
(683, '1', '交易完成', 'v_ve_order', 'state', ''),
(691, '0', '老板', 'v_ve_vegroup_manager_login', 'user_type', ''),
(692, '1', '员工', 'v_ve_vegroup_manager_login', 'user_type', ''),
(693, '0', '独立市场', 'v_ve_vegroup_manager_login', 'grouptype', ''),
(694, '1', '多租户市场', 'v_ve_vegroup_manager_login', 'grouptype', ''),
(695, '2', '租户', 'v_ve_vegroup_manager_login', 'grouptype', ''),
(696, '0', '自主注册', 'v_ve_vegroup_farmer2', 'source', ''),
(697, '1', '其它菜点导入', 'v_ve_vegroup_farmer2', 'source', ''),
(698, '2', '自己菜点导入', 'v_ve_vegroup_farmer2', 'source', ''),
(704, '0', '零星', 've_question_online', 'oc_area', ''),
(705, '1', '局部', 've_question_online', 'oc_area', ''),
(706, '2', '大面积', 've_question_online', 'oc_area', ''),
(707, '0', '有效评论', 've_question_comments', 'status', ''),
(708, '1', '取消评论', 've_question_comments', 'status', ''),
(709, '0', '有效评论', 've_video_comments', 'status', ''),
(710, '1', '取消评论', 've_video_comments', 'status', ''),
(711, '0', '越冬', 've_greenhouse_crops_rotation', 'crop_type', ''),
(712, '1', '早春', 've_greenhouse_crops_rotation', 'crop_type', ''),
(713, '8', ' not in ', 'yz_wh', 'compare', NULL),
(719, '0', '正常', 've_vegroup_type', 'states', ''),
(720, '1', '删除', 've_vegroup_type', 'states', ''),
(721, '0', '不是', 've_quality', 'defaults', ''),
(722, '1', '是', 've_quality', 'defaults', ''),
(723, '0', '正常', 've_quality', 'states', ''),
(724, '1', '删除', 've_quality', 'states', ''),
(741, '0', '未还', 've_bill_sales', 'status', ''),
(742, '1', '未还清', 've_bill_sales', 'status', ''),
(743, '2', '已还清', 've_bill_sales', 'status', ''),
(747, '0', '老板', 've_vegroup_manager', 'user_type', ''),
(748, '1', '员工', 've_vegroup_manager', 'user_type', ''),
(749, '0', '正常', 've_vegroup_manager', 'state', ''),
(750, '1', '已删除', 've_vegroup_manager', 'state', ''),
(751, '2', '秋延', 've_greenhouse_crops_rotation', 'crop_type', NULL),
(752, '0', '正常', 've_shipper', 'state', ''),
(753, '1', '已删', 've_shipper', 'state', ''),
(754, '0', '未还', 've_receivable_logs', 'status', ''),
(755, '1', '未还清', 've_receivable_logs', 'status', ''),
(756, '2', '已还清', 've_receivable_logs', 'status', ''),
(757, '0', '越冬', 'v_ve_greenhouse_crops_rotation_latest_new', 'crop_type', ''),
(758, '1', '早春', 'v_ve_greenhouse_crops_rotation_latest_new', 'crop_type', ''),
(759, '2', '秋延', 'v_ve_greenhouse_crops_rotation_latest_new', 'crop_type', ''),
(770, '0', '功能级', 'yz_power', 'role_type', ''),
(771, '1', '页面级', 'yz_power', 'role_type', ''),
(772, '0', '有效', 'yz_role_power', 'power_state', ''),
(773, '1', '取消', 'yz_role_power', 'power_state', ''),
(774, '0', '有效', 'v_yz_user_power', 'power_state', ''),
(775, '1', '取消', 'v_yz_user_power', 'power_state', ''),
(776, '0', '有效', 'v_yz_role_power', 'power_state', ''),
(777, '1', '取消', 'v_yz_role_power', 'power_state', ''),
(778, '0', '老板', 'v_yz_user_power', 'user_type', ''),
(779, '1', '员工', 'v_yz_user_power', 'user_type', ''),
(780, '0', '正常', 'v_ve_vegroup_manager_login', 'state', ''),
(781, '1', '已删除', 'v_ve_vegroup_manager_login', 'state', ''),
(782, '0', '有效', 've_sys_param', 'state', ''),
(783, '1', '失效', 've_sys_param', 'state', ''),
(784, '0', '有效', 've_device', 'state', ''),
(785, '1', '失效', 've_device', 'state', ''),
(792, '0', '实际收货价格', 'v_ve_vegroup_manager_login', 'accounting_method', ''),
(793, '1', '收货计划统一价格', 'v_ve_vegroup_manager_login', 'accounting_method', ''),
(794, '0', '年', 've_accounting_total', 'date_type', ''),
(795, '1', '月', 've_accounting_total', 'date_type', ''),
(796, '2', '日', 've_accounting_total', 'date_type', ''),
(797, '0', '代理费', 've_accounting_detail', 'ad_type', ''),
(798, '1', '差价', 've_accounting_detail', 'ad_type', ''),
(799, '10', '货款', 've_accounting_detail', 'ad_type', ''),
(800, '11', '工费(人工+材料)', 've_accounting_detail', 'ad_type', ''),
(801, '12', '人工', 've_accounting_detail', 'ad_type', ''),
(802, '13', '材料', 've_accounting_detail', 'ad_type', ''),
(803, '21', '工资', 've_accounting_detail', 'ad_type', ''),
(804, '22', '自担', 've_accounting_detail', 'ad_type', ''),
(805, '23', '其它', 've_accounting_detail', 'ad_type', ''),
(806, '0', '未收', 've_accounting_detail', 'account_type', ''),
(807, '1', '已收', 've_accounting_detail', 'account_type', ''),
(808, '2', '未支', 've_accounting_detail', 'account_type', ''),
(809, '3', '已支', 've_accounting_detail', 'account_type', ''),
(810, '0', '代理费', 've_accounting_detail_statistics', 'ad_type', ''),
(811, '1', '差价', 've_accounting_detail_statistics', 'ad_type', ''),
(812, '10', '货款', 've_accounting_detail_statistics', 'ad_type', ''),
(813, '11', '工费(人工+材料)', 've_accounting_detail_statistics', 'ad_type', ''),
(814, '12', '人工', 've_accounting_detail_statistics', 'ad_type', ''),
(815, '13', '材料', 've_accounting_detail_statistics', 'ad_type', ''),
(816, '21', '工资', 've_accounting_detail_statistics', 'ad_type', ''),
(817, '22', '自担', 've_accounting_detail_statistics', 'ad_type', ''),
(818, '23', '其它', 've_accounting_detail_statistics', 'ad_type', ''),
(819, '0', '未收', 've_accounting_detail_statistics', 'account_type', ''),
(820, '1', '已收', 've_accounting_detail_statistics', 'account_type', ''),
(821, '2', '未支', 've_accounting_detail_statistics', 'account_type', ''),
(822, '3', '已支', 've_accounting_detail_statistics', 'account_type', ''),
(823, '0', '年', 've_accounting_detail_statistics', 'date_type', ''),
(824, '1', '月', 've_accounting_detail_statistics', 'date_type', ''),
(825, '2', '日', 've_accounting_detail_statistics', 'date_type', ''),
(832, '0', '有效', 've_product_type', 'states', ''),
(833, '1', '无效', 've_product_type', 'states', ''),
(834, '0', '有效', 've_product', 'states', ''),
(835, '1', '无效', 've_product', 'states', ''),
(836, '0', '有效评论', 've_product_comments', 'states', ''),
(837, '1', '取消评论', 've_product_comments', 'states', ''),
(838, '0', '红包', 've_product_promotion_activity', 'type', ''),
(839, '1', '站内现金', 've_product_promotion_activity', 'type', ''),
(840, '2', '实物券', 've_product_promotion_activity', 'type', ''),
(841, '3', '积分', 've_product_promotion_activity', 'type', ''),
(844, '0', '有效', 've_product_promotion_activity', 'states', ''),
(845, '1', '过期', 've_product_promotion_activity', 'states', ''),
(846, '0', '收入', 've_product_coupon', 'flow_type', ''),
(847, '1', '支出', 've_product_coupon', 'flow_type', ''),
(848, '0', '交易记录', 've_product_promotion_activity', 'relational_record', ''),
(849, '0', '有效', 've_product_hot', 'states', NULL),
(850, '1', '取消', 've_product_hot', 'states', NULL),
(851, '0', '生效', 've_product_shopping_cart', 'states', ''),
(852, '1', '取消', 've_product_shopping_cart', 'states', ''),
(853, '2', '完成', 've_product_shopping_cart', 'states', ''),
(854, '0', '选中', 've_product_shopping_cart_detail', 'state', ''),
(855, '1', '取消', 've_product_shopping_cart_detail', 'state', ''),
(856, '0', '待付款', 've_product_order', 'states', NULL),
(857, '1', '待收货', 've_product_order', 'states', NULL),
(858, '2', '已完成', 've_product_order', 'states', NULL),
(859, '0', '选中', 've_product_order_detail', 'states', ''),
(860, '1', '取消', 've_product_order_detail', 'states', ''),
(861, '0', '选中', 've_product_shopping_cart_detail', 'states', ''),
(862, '1', '取消', 've_product_shopping_cart_detail', 'states', ''),
(863, '2', '已售罄', 've_product_shopping_cart_detail', 'states', ''),
(864, '0', '有效', 've_product_red_packet', 'states', ''),
(865, '1', '使用', 've_product_red_packet', 'states', ''),
(866, '2', '过期', 've_product_red_packet', 'states', ''),
(867, '0', '合作社地址', 've_farmer_address', 'is_group', ''),
(868, '1', '农户地址', 've_farmer_address', 'is_group', ''),
(869, '0', '有效', 've_farmer_address', 'states', ''),
(870, '1', '取消', 've_farmer_address', 'states', ''),
(871, '0', '默认', 've_farmer_address', 'is_default', ''),
(872, '1', '不默认', 've_farmer_address', 'is_default', ''),
(873, '3', '已取消', 've_product_order', 'states', NULL),
(874, '0', '自主注册', 've_vegroup_temporary_worker', 'source', ''),
(875, '1', '其它菜点导入', 've_vegroup_temporary_worker', 'source', ''),
(876, '2', '自己菜点导入', 've_vegroup_temporary_worker', 'source', ''),
(877, '0', '有效', 've_vegroup_temporary_worker', 'states', ''),
(878, '1', '删除', 've_vegroup_temporary_worker', 'states', ''),
(879, '0', '未付', 've_temporary_worker_account', 'state', ''),
(880, '1', '已付', 've_temporary_worker_account', 'state', ''),
(881, '0', '有效', 'v_ve_vegroup_temporary_worker', 'states', ''),
(882, '1', '删除', 'v_ve_vegroup_temporary_worker', 'states', ''),
(883, '0', '自主注册', 'v_ve_vegroup_temporary_worker', 'source', ''),
(884, '1', '其它菜点导入', 'v_ve_vegroup_temporary_worker', 'source', ''),
(885, '2', '自己菜点导入', 'v_ve_vegroup_temporary_worker', 'source', ''),
(888, '0', '有效', 've_packing_specification', 'states', ''),
(889, '1', '失效', 've_packing_specification', 'states', ''),
(890, '0', '未付', 've_temporary_worker_account', 'states', ''),
(891, '1', '已付', 've_temporary_worker_account', 'states', ''),
(892, '1', '已付', 've_temporary_worker_account', 'states', ''),
(893, '2', '添加', 'yz_log2', 'type', ''),
(894, '3', '修改|删除', 'yz_log2', 'type', ''),
(895, '0', '成功', 'yz_log2', 'states', ''),
(896, '1', '失败', 'yz_log2', 'states', ''),
(897, '0', '代理费', 'v_ve_accounting_detail2', 'ad_type', ''),
(898, '1', '差价', 'v_ve_accounting_detail2', 'ad_type', ''),
(899, '9', '预付款', 'v_ve_accounting_detail2', 'ad_type', ''),
(900, '10', '货款', 'v_ve_accounting_detail2', 'ad_type', ''),
(901, '11', '工费', 'v_ve_accounting_detail2', 'ad_type', ''),
(902, '12', '人工', 'v_ve_accounting_detail2', 'ad_type', ''),
(903, '13', '材料', 'v_ve_accounting_detail2', 'ad_type', ''),
(904, '21', '工资', 'v_ve_accounting_detail2', 'ad_type', ''),
(905, '22', '自担', 'v_ve_accounting_detail2', 'ad_type', ''),
(906, '23', '其它', 'v_ve_accounting_detail2', 'ad_type', ''),
(907, '0', '未收', 'v_ve_accounting_detail2', 'account_type', ''),
(908, '1', '已收', 'v_ve_accounting_detail2', 'account_type', ''),
(909, '2', '未支', 'v_ve_accounting_detail2', 'account_type', ''),
(910, '3', '已支', 'v_ve_accounting_detail2', 'account_type', ''),
(913, '0', '未登录', 've_vegroup_manager', 'login_status', ''),
(914, '1', '登录成功', 've_vegroup_manager', 'login_status', ''),
(915, '2', '登录失败', 've_vegroup_manager', 'login_status', ''),
(916, '0', '是', 've_vegroup_manager', 'is_num_code', ''),
(917, '1', '否', 've_vegroup_manager', 'is_num_code', ''),
(918, '0', '过磅', 've_order_logs2', 'style', ''),
(919, '1', '去皮', 've_order_logs2', 'style', ''),
(920, '2', '修改', 've_order_logs2', 'style', ''),
(921, '0', '正常', 've_base_sample_type', 'states', ''),
(922, '1', '删除', 've_base_sample_type', 'states', ''),
(923, '0', '正常', 've_base_sample_product', 'states', ''),
(924, '1', '删除', 've_base_sample_product', 'states', ''),
(925, '0', '有效', 've_weixin_guide_page', 'states', ''),
(926, '1', '无效', 've_weixin_guide_page', 'states', ''),
(927, '0', '有效', 'v_ve_weixin_guide_page', 'states', ''),
(928, '1', '无效', 'v_ve_weixin_guide_page', 'states', ''),
(929, '0', '正常', 've_super_shipper', 'states', ''),
(930, '1', '取消', 've_super_shipper', 'states', ''),
(931, '0', '未还', 'v_super_shipper_bill_sales', 'status', ''),
(932, '1', '未还清', 'v_super_shipper_bill_sales', 'status', ''),
(933, '2', '已还清', 'v_super_shipper_bill_sales', 'status', ''),
(936, '0', '过磅记录', 'v_ve_order', 'order_type', ''),
(937, '1', '调货记录', 'v_ve_order', 'order_type', ''),
(938, '0', '1笔', 'v_ve_vegroup_manager_login', 'out_num', ''),
(939, '1', '多笔', 'v_ve_vegroup_manager_login', 'out_num', ''),
(940, '0', '精品', 'v_farmer_order', 'quality', ''),
(941, '1', '通货', 'v_farmer_order', 'quality', ''),
(942, '2', '精品', 'v_farmer_order', 'quality', ''),
(943, '0', '未付款', 'v_farmer_order', 'repay_status', ''),
(944, '1', '未付清', 'v_farmer_order', 'repay_status', ''),
(945, '2', '已付清', 'v_farmer_order', 'repay_status', ''),
(946, '0', '交易中', 'v_farmer_order', 'state', ''),
(947, '1', '交易完成', 'v_farmer_order', 'state', ''),
(948, '0', '过磅记录', 'v_farmer_order', 'order_type', ''),
(949, '1', '过磅记录调货', 'v_farmer_order', 'order_type', ''),
(950, '2', '调货记录', 'v_farmer_order', 'order_type', ''),
(951, '0', '1笔', 'v_farmer_order', 'out_num', ''),
(952, '1', '多笔', 'v_farmer_order', 'out_num', ''),
(953, '0', '不显示', 'v_super_shipper_vegroup_order', 'real_time_states', ''),
(954, '1', '显示', 'v_super_shipper_vegroup_order', 'real_time_states', ''),
(955, '0', '不显示', 'v_super_shipper_bill_sales', 'historical_states', ''),
(956, '1', '显示', 'v_super_shipper_bill_sales', 'historical_states', ''),
(957, '0', '不显示', 've_shipper', 'real_time_states', ''),
(958, '1', '显示', 've_shipper', 'real_time_states', ''),
(959, '0', '不显示', 've_shipper', 'historical_states', ''),
(960, '1', '显示', 've_shipper', 'historical_states', ''),
(961, '0', '有效', 've_push_user_group', 'states', ''),
(962, '1', '失效', 've_push_user_group', 'states', ''),
(963, '0', '有效', 've_vegroup_message_type', 'states', ''),
(964, '1', '失效', 've_vegroup_message_type', 'states', ''),
(965, '0', '有效', 've_vegroup_message', 'states', ''),
(966, '1', '失效', 've_vegroup_message', 'states', ''),
(967, '0', '有效', 've_vegroup_manager_message', 'states', ''),
(968, '1', '失效', 've_vegroup_manager_message', 'states', ''),
(971, '0', '文本', 'v_ve_vegroup_manager_message', 'message_format', ''),
(972, '1', '视频', 'v_ve_vegroup_manager_message', 'message_format', ''),
(973, '2', '图片', 'v_ve_vegroup_manager_message', 'message_format', ''),
(974, '0', '有效', 'v_ve_vegroup_manager_message', 'states', ''),
(975, '1', '失效', 'v_ve_vegroup_manager_message', 'states', ''),
(976, '0', '未读', 'v_ve_vegroup_manager_message', 'is_read', ''),
(977, '1', '已读', 'v_ve_vegroup_manager_message', 'is_read', ''),
(1000, '0', '按天', 've_order', 'v_date_format', NULL),
(1001, '1', '按周', 've_order', 'v_date_format', NULL),
(1002, '2', '按月', 've_order', 'v_date_format', NULL),
(1003, '0', '汇总值', 've_order', 'v_data_format', NULL),
(1004, '1', '平均值', 've_order', 'v_data_format', NULL),
(1005, '2', '最小值', 've_order', 'v_data_format', NULL),
(1006, '3', '最大值', 've_order', 'v_data_format', NULL),
(1007, '0', '不展示', 've_training_course_video', 'is_hot', ''),
(1008, '1', '展示', 've_training_course_video', 'is_hot', ''),
(1009, '0', '自动生成', 've_training_course_video', 'v_is_auto_image', NULL),
(1010, '1', '手动添加', 've_training_course_video', 'v_is_auto_image', NULL),
(1011, '0', '有效', 've_packing_specification_brokerage', 'states', ''),
(1012, '1', '删除', 've_packing_specification_brokerage', 'states', ''),
(1013, '0', '有效', 've_order_packing', 'states', NULL),
(1014, '1', '删除', 've_order_packing', 'states', ''),
(1016, '0', '有效', 've_order_packing_specification', 'states', ''),
(1017, '1', '删除', 've_order_packing_specification', 'states', ''),
(1018, '0', '领件', 'v_ve_order_packing', 'states', ''),
(1019, '1', '删除', 'v_ve_order_packing', 'states', ''),
(1020, '2', '回件', 'v_ve_order_packing', 'states', ''),
(1021, '0', '领料', 've_order_packing', 'types', ''),
(1022, '1', '用件', 've_order_packing', 'types', ''),
(1023, '2', '损耗', 've_order_packing', 'types', ''),
(1024, '0', '不领取', 'v_ve_vegroup_manager_login', 'is_get_package', ''),
(1025, '1', '领取', 'v_ve_vegroup_manager_login', 'is_get_package', ''),
(1026, '0', '有人执守', 'v_ve_vegroup_manager_login', 'is_auto_record', ''),
(1027, '1', '无人执守', 'v_ve_vegroup_manager_login', 'is_auto_record', ''),
(1028, '0', '领件', 've_order_packing_brokerage_type', 'types', ''),
(1029, '1', '回件', 've_order_packing_brokerage_type', 'types', ''),
(1030, '2', '损耗', 've_order_packing_brokerage_type', 'types', ''),
(1031, '0', '有效', 've_order_packing_brokerage_type', 'states', ''),
(1032, '1', '删除', 've_order_packing_brokerage_type', 'states', ''),
(1037, '0', '正常', 'v_ve_vegroup_manager_login', 'other_config', ''),
(1038, '1', '小磅多框', 'v_ve_vegroup_manager_login', 'other_config', ''),
(1039, '2', '标箱整重', 'v_ve_vegroup_manager_login', 'other_config', ''),
(1040, '3', '领料去皮', 'v_ve_vegroup_manager_login', 'other_config', ''),
(1057, '0', '现金', 'v_ve_payment', 'payment_type', ''),
(1058, '1', '银行转账', 'v_ve_payment', 'payment_type', ''),
(1062, '0', '临商银行', 've_farmer_bank', 'bank', NULL),
(1063, '0', '使用中', 've_farmer_bank', 'states', ''),
(1064, '1', '已删除', 've_farmer_bank', 'states', ''),
(1065, '0', '不使用', 'v_ve_vegroup_manager_login', 'is_use_bank', ''),
(1066, '1', '使用', 'v_ve_vegroup_manager_login', 'is_use_bank', ''),
(1069, '0', '农户端未开价', 'v_ve_vegroup_order3', 'is_opening_price', ''),
(1070, '1', '农户端已开价', 'v_ve_vegroup_order3', 'is_opening_price', ''),
(1080, '0', '实时开价', 'v_ve_vegroup_manager_login', 'opening_price_type', ''),
(1081, '1', '定时开价', 'v_ve_vegroup_manager_login', 'opening_price_type', ''),
(1082, '2', '手动开价', 'v_ve_vegroup_manager_login', 'opening_price_type', ''),
(1087, '0', '否', 'v_ve_order', 'is_auto', ''),
(1088, '1', '是', 'v_ve_order', 'is_auto', ''),
(1089, '0', '农户端未开价', 'v_ve_order', 'is_opening_price', ''),
(1090, '1', '农户端已开价', 'v_ve_order', 'is_opening_price', ''),
(1091, '0', '未知', 'v_ve_order', 'is_peeling_all', ''),
(1092, '1', '除皮完成', 'v_ve_order', 'is_peeling_all', ''),
(1118, '401', '借记卡', 've_farmer_bank', 'account_type', ''),
(1119, '601', '企业户', 've_farmer_bank', 'account_type', ''),
(1120, '701', '二类户', 've_farmer_bank', 'account_type', ''),
(1121, '702', '三类户', 've_farmer_bank', 'account_type', ''),
(1122, 'I', '身份证', 've_farmer_bank', 'certificate_type', ''),
(1123, 'P', '护照', 've_farmer_bank', 'certificate_type', ''),
(1124, 'G', '军官证', 've_farmer_bank', 'certificate_type', ''),
(1125, 'U', '其他证件', 've_farmer_bank', 'certificate_type', ''),
(1126, 'U', '营业执照', 've_farmer_bank', 'company_cert_type', ''),
(1127, 'Y', '组织机构代码证', 've_farmer_bank', 'company_cert_type', ''),
(1128, 'V', '统一社会信用代码', 've_farmer_bank', 'company_cert_type', ''),
(1129, '0', '未申请', 've_farmer_bank', 'status', ''),
(1130, '1', '未确认', 've_farmer_bank', 'status', ''),
(1131, '2', '申请失败', 've_farmer_bank', 'status', ''),
(1132, '3', '审核中', 've_farmer_bank', 'status', ''),
(1133, '4', '审核通过', 've_farmer_bank', 'status', ''),
(1134, '5', '审核未通过', 've_farmer_bank', 'status', ''),
(1135, '0', '是', 've_farmer_bank', 'is_device', ''),
(1136, '1', '否', 've_farmer_bank', 'is_device', ''),
(1137, '1', '潍坊银行', 've_farmer_bank', 'bank', NULL),
(1138, '2', '农业银行', 've_farmer_bank', 'bank', NULL),
(1141, '0', '精品', 'v_ve_order3', 'quality', ''),
(1142, '1', '通货', 'v_ve_order3', 'quality', ''),
(1143, '2', '精品', 'v_ve_order3', 'quality', ''),
(1144, '0', '未付款', 'v_ve_order3', 'repay_status', ''),
(1145, '1', '未付清', 'v_ve_order3', 'repay_status', ''),
(1146, '2', '已付清', 'v_ve_order3', 'repay_status', ''),
(1147, '0', '交易中', 'v_ve_order3', 'state', ''),
(1148, '1', '交易完成', 'v_ve_order3', 'state', ''),
(1149, '0', '过磅记录', 'v_ve_order3', 'order_type', ''),
(1150, '1', '过磅记录调货', 'v_ve_order3', 'order_type', ''),
(1151, '2', '调货记录', 'v_ve_order3', 'order_type', ''),
(1152, '0', '否', 'v_ve_order3', 'is_auto', ''),
(1153, '1', '是', 'v_ve_order3', 'is_auto', ''),
(1154, '0', '农户端未开价', 'v_ve_order3', 'is_opening_price', ''),
(1155, '1', '农户端已开价', 'v_ve_order3', 'is_opening_price', ''),
(1156, '0', '未知', 'v_ve_order3', 'is_peeling_all', ''),
(1157, '1', '除皮完成', 'v_ve_order3', 'is_peeling_all', ''),
(1158, '0', '独立市场', 'v_ve_order3', 'grouptype', ''),
(1159, '1', '多租户市场', 'v_ve_order3', 'grouptype', ''),
(1160, '2', '租户', 'v_ve_order3', 'grouptype', ''),
(1161, '0', '有效', 've_greenhouse_work', 'status', ''),
(1162, '1', '删除', 've_greenhouse_work', 'status', ''),
(1180, '0', '未生成', 've_create_tomorrow_order', 'status', ''),
(1181, '1', '已生成', 've_create_tomorrow_order', 'status', ''),
(1182, '0', '注册', 'zm_sms', 'type', ''),
(1183, '1', '登录', 'zm_sms', 'type', ''),
(1184, '2', '身份验证', 'zm_sms', 'type', NULL),
(1185, '0', '未发送', 'zm_sms', 'returnstatus', ''),
(1186, '1', '发送成功', 'zm_sms', 'returnstatus', ''),
(1187, '2', '发送失败', 'zm_sms', 'returnstatus', ''),
(1188, '0', '生效', 'zm_sms', 'status', ''),
(1189, '1', '失效', 'zm_sms', 'status', ''),
(1190, '0', '否', 've_farmer', 'is_sms_verification', ''),
(1191, '1', '是', 've_farmer', 'is_sms_verification', ''),
(1192, '0', '微信', 've_farmer_applet', 'applet_type', ''),
(1193, '1', '支付宝', 've_farmer_applet', 'applet_type', ''),
(1194, '0', '本人', 've_farmer_applet', 'user_relationship', ''),
(1195, '1', '夫妻', 've_farmer_applet', 'user_relationship', ''),
(1196, '2', '子女', 've_farmer_applet', 'user_relationship', ''),
(1197, '3', '父母', 've_farmer_applet', 'user_relationship', ''),
(1198, '0', '允许查看', 've_farmer_applet', 'account_power', ''),
(1199, '1', '不允许查看', 've_farmer_applet', 'account_power', ''),
(1200, '0', '女', 've_farmer_applet', 'gender', ''),
(1201, '1', '男', 've_farmer_applet', 'gender', ''),
(1202, '0', '女', 've_farmer_applet', 'gender', ''),
(1203, '1', '男', 've_farmer_applet', 'gender', ''),
(1204, '0', '否', 've_farmer', 'is_applet_verification', ''),
(1205, '1', '是', 've_farmer', 'is_applet_verification', ''),
(1206, '0', '否', 've_farmer', 'is_identity_verification', ''),
(1207, '1', '是', 've_farmer', 'is_identity_verification', ''),
(1253, '0', '自主注册', 've_vegroup_farmer', 'source', ''),
(1254, '1', '其它菜点导入', 've_vegroup_farmer', 'source', ''),
(1255, '2', '自己菜点导入', 've_vegroup_farmer', 'source', ''),
(1256, '0', '正常', 've_vegroup_farmer', 'state', ''),
(1257, '1', '已删除', 've_vegroup_farmer', 'state', ''),
(1258, '0', '现金', 'v_bankrepay_payment', 'payment_type', ''),
(1259, '1', '银行转账', 'v_bankrepay_payment', 'payment_type', ''),
(1260, '0', '未审核', 've_video', 'states', ''),
(1261, '1', '审核通过', 've_video', 'states', ''),
(1262, '2', '审核不成功', 've_video', 'states', ''),
(1263, '3', '过期', 've_video', 'states', ''),
(1264, '0', '有效', 've_video_type', 'states', ''),
(1265, '1', '失效', 've_video_type', 'states', ''),
(1266, '0', '未审核', 'v_video_product', 'states', ''),
(1267, '1', '审核通过', 'v_video_product', 'states', ''),
(1268, '2', '审核不成功', 'v_video_product', 'states', ''),
(1269, '3', '过期', 'v_video_product', 'states', ''),
(1270, '0', '有效', 've_lucky_draw', 'states', ''),
(1271, '1', '无效', 've_lucky_draw', 'states', ''),
(1272, '0', '有效', 've_lucky_draw_model', 'states', ''),
(1273, '1', '无效', 've_lucky_draw_model', 'states', ''),
(1274, '0', '有效', 'v_ve_lucky_draw_model_video', 'states', ''),
(1275, '1', '无效', 'v_ve_lucky_draw_model_video', 'states', ''),
(1276, '0', '红包', 've_lucky_draw_model', 'type', ''),
(1277, '1', '代金券', 've_lucky_draw_model', 'type', ''),
(1278, '2', '实物', 've_lucky_draw_model', 'type', ''),
(1279, '0', '有效', 've_weixin_message', 'states', ''),
(1280, '1', '无效', 've_weixin_message', 'states', ''),
(1281, '0', '订阅', 've_weixin_farmer_subscribe_message', 'states', ''),
(1282, '1', '取消订阅', 've_weixin_farmer_subscribe_message', 'states', ''),
(1285, '0', '小视频', 've_relation_message', 'source_type', ''),
(1288, '0', '参与活动', 've_video_farmer_participate_active', 'states', ''),
(1289, '1', '取消参与活动', 've_video_farmer_participate_active', 'states', ''),
(1293, '0', '未兑换', 've_farmer_lucky_draw_detail', 'states', ''),
(1294, '1', '已兑换', 've_farmer_lucky_draw_detail', 'states', ''),
(1295, 'PRODUCT_1', '商品促销', 've_weixin_hb', 'scene_id', ''),
(1296, 'PRODUCT_2', '抽奖', 've_weixin_hb', 'scene_id', ''),
(1297, 'PRODUCT_3', '虚拟物品兑奖', 've_weixin_hb', 'scene_id', ''),
(1298, 'PRODUCT_4', '企业内部福利', 've_weixin_hb', 'scene_id', ''),
(1299, 'PRODUCT_5', '渠道分润', 've_weixin_hb', 'scene_id', ''),
(1300, 'PRODUCT_6', '保险回馈', 've_weixin_hb', 'scene_id', ''),
(1301, 'PRODUCT_7', '彩票派奖', 've_weixin_hb', 'scene_id', ''),
(1302, 'PRODUCT_8', '税务刮奖', 've_weixin_hb', 'scene_id', ''),
(1303, '0', '现金红包', 've_lucky_draw', 'draw_type', ''),
(1307, '1', '现金', 've_lucky_draw', 'draw_type', NULL),
(1308, '3', '现金', 've_lucky_draw_model', 'type', NULL),
(1309, '0', '测试', 've_app_version', 'states', ''),
(1310, '1', '生产', 've_app_version', 'states', ''),
(1311, '2', '作废', 've_app_version', 'states', ''),
(1317, '0', '未申请', 'v_farmer_bank_ny_view', 'status', ''),
(1318, '1', '未确认', 'v_farmer_bank_ny_view', 'status', ''),
(1319, '2', '申请失败', 'v_farmer_bank_ny_view', 'status', ''),
(1320, '3', '审核中', 'v_farmer_bank_ny_view', 'status', ''),
(1321, '4', '审核通过', 'v_farmer_bank_ny_view', 'status', ''),
(1322, '5', '审核未通过', 'v_farmer_bank_ny_view', 'status', ''),
(1323, '0', '独立市场', 've_vegroup', 'grouptype', ''),
(1324, '1', '多租户市场', 've_vegroup', 'grouptype', ''),
(1325, '2', '租户', 've_vegroup', 'grouptype', ''),
(1351, '0', '三天', 'v_ve_order_2_day_total', 'addtime', NULL),
(1352, '1', '七天', 'v_ve_order_2_day_total', 'addtime', NULL),
(1353, '2', '30天', 'v_ve_order_2_day_total', 'addtime', NULL),
(1354, '0', '近三月', 'v_ve_order_2_month_total', 'addtime', NULL),
(1355, '1', '近六月', 'v_ve_order_2_month_total', 'addtime', NULL),
(1356, '2', '近一年', 'v_ve_order_2_month_total', 'addtime', NULL),
(1357, '3', '近两年', 'v_ve_order_2_month_total', 'addtime', NULL),
(1358, '0', '最近10天', 'v_ve_order_2_price_total', 'addtime', NULL),
(1359, '1', '最近30天', 'v_ve_order_2_price_total', 'addtime', NULL),
(1360, '2', '最近90天', 'v_ve_order_2_price_total', 'addtime', NULL),
(1361, '1', '斤', 'v_ve_vegroup_manager_login', 'weight_unit', ''),
(1362, '2', '公斤', 'v_ve_vegroup_manager_login', 'weight_unit', ''),
(1365, '0', '未知', 've_order_auto', 'type', ''),
(1366, '1', '过磅', 've_order_auto', 'type', ''),
(1367, '2', '去皮', 've_order_auto', 'type', ''),
(1368, '1', '斤', 've_order_auto', 'weight_unit', ''),
(1369, '2', '公斤', 've_order_auto', 'weight_unit', ''),
(1374, '1', '斤', 've_device_smart_terminal', 'weight_unit', ''),
(1375, '2', '公斤', 've_device_smart_terminal', 'weight_unit', ''),
(1376, '0', '正常', 've_device_smart_terminal', 'states', ''),
(1377, '1', '删除', 've_device_smart_terminal', 'states', ''),
(1378, '1', '斤', 've_order_auto_disconnection', 'weight_unit', ''),
(1379, '2', '公斤', 've_order_auto_disconnection', 'weight_unit', ''),
(1382, '0', '未发放', 've_weixin_farmer_xj', 'states', ''),
(1383, '1', '已发放', 've_weixin_farmer_xj', 'states', ''),
(1384, '2', '发放失败', 've_weixin_farmer_xj', 'states', ''),
(1385, '0', '绑定银行卡', 'v_ve_vegroup_farmer2', 'bank_status', NULL),
(1386, '1', '未绑定', 'v_ve_vegroup_farmer2', 'bank_status', NULL),
(1387, '0', '活动进行中', 've_video_participate_active', 'states', ''),
(1388, '1', '活动取消', 've_video_participate_active', 'states', ''),
(1389, '0', '展示', 've_video_participate_active', 'show_states', ''),
(1390, '1', '不展示', 've_video_participate_active', 'show_states', ''),
(1391, '0', '全部', 've_video_participate_active', 'target_user', ''),
(1392, '1', '指定用户', 've_video_participate_active', 'target_user', ''),
(1393, 'navigate', '“navigate”', 've_video_participate_active', 'opentype', ''),
(1396, '0', '不收', 'v_ve_vegroup_manager_login', 'is_order_fee', ''),
(1397, '1', '收取', 'v_ve_vegroup_manager_login', 'is_order_fee', ''),
(1398, '0', '不计算', 'v_ve_vegroup_manager_login', 'is_calculate_loss', ''),
(1399, '1', '计算', 'v_ve_vegroup_manager_login', 'is_calculate_loss', ''),
(1411, '0', '过磅', 'v_ve_order_logs2', 'style', ''),
(1412, '1', '去皮', 'v_ve_order_logs2', 'style', ''),
(1413, '2', '修改', 'v_ve_order_logs2', 'style', ''),
(1414, '3', '调货', 'v_ve_order_logs2', 'style', ''),
(1415, '0', '使用中', 'v_ve_farmer_bank_active', 'states', ''),
(1416, '1', '已删除', 'v_ve_farmer_bank_active', 'states', ''),
(1417, '0', '临沂商业银行', 'v_ve_farmer_bank_active', 'bank', ''),
(1418, '1', '潍坊银行', 'v_ve_farmer_bank_active', 'bank', ''),
(1419, '2', '农业银行', 'v_ve_farmer_bank_active', 'bank', ''),
(1420, '401', '借记卡', 'v_ve_farmer_bank_active', 'account_type', ''),
(1421, '601', '企业户', 'v_ve_farmer_bank_active', 'account_type', ''),
(1422, '701', '二类户', 'v_ve_farmer_bank_active', 'account_type', ''),
(1423, '702', '三类户', 'v_ve_farmer_bank_active', 'account_type', ''),
(1424, 'I', '身份证', 'v_ve_farmer_bank_active', 'certificate_type', ''),
(1425, 'P', '护照', 'v_ve_farmer_bank_active', 'certificate_type', ''),
(1426, 'G', '军官证', 'v_ve_farmer_bank_active', 'certificate_type', ''),
(1427, 'U', '其他证件', 'v_ve_farmer_bank_active', 'certificate_type', ''),
(1428, 'U', '营业执照', 'v_ve_farmer_bank_active', 'company_cert_type', ''),
(1429, 'Y', '组织机构代码证', 'v_ve_farmer_bank_active', 'company_cert_type', ''),
(1430, 'V', '统一社会信用代码', 'v_ve_farmer_bank_active', 'company_cert_type', ''),
(1431, '0', '未申请', 'v_ve_farmer_bank_active', 'status', ''),
(1432, '1', '未确认', 'v_ve_farmer_bank_active', 'status', ''),
(1433, '2', '申请失败', 'v_ve_farmer_bank_active', 'status', ''),
(1434, '3', '审核中', 'v_ve_farmer_bank_active', 'status', ''),
(1435, '4', '审核通过', 'v_ve_farmer_bank_active', 'status', ''),
(1436, '5', '审核未通过', 'v_ve_farmer_bank_active', 'status', ''),
(1437, '0', '是', 'v_ve_farmer_bank_active', 'is_device', ''),
(1438, '1', '否', 'v_ve_farmer_bank_active', 'is_device', ''),
(1439, '2', '注销', 'v_ve_farmer_bank_active', 'states', ''),
(1440, '2', '注销', 've_farmer_bank', 'states', NULL),
(1443, '0', '正常', 've_vegroup_bank', 'state', ''),
(1444, '1', '已删除', 've_vegroup_bank', 'state', ''),
(1447, '2', '农业银行', 've_vegroup_bank', 'bank', ''),
(1448, '401', '借记卡', 've_vegroup_bank', 'account_type', ''),
(1449, '601', '企业户', 've_vegroup_bank', 'account_type', ''),
(1450, '701', '二类户', 've_vegroup_bank', 'account_type', ''),
(1451, '702', '三类户', 've_vegroup_bank', 'account_type', ''),
(1452, '1', '个人商户', 've_vegroup_bank', 'submertype', ''),
(1453, '2', '企业商户', 've_vegroup_bank', 'submertype', ''),
(1454, 'I', '身份证', 've_vegroup_bank', 'certificate_type', ''),
(1455, 'P', '护照', 've_vegroup_bank', 'certificate_type', ''),
(1456, 'G', '军官证', 've_vegroup_bank', 'certificate_type', ''),
(1457, 'U', '其他证件', 've_vegroup_bank', 'certificate_type', ''),
(1458, '610047', '营业执照', 've_vegroup_bank', 'company_cert_type', NULL),
(1459, '610049', '组织机构代码证', 've_vegroup_bank', 'company_cert_type', NULL),
(1460, 'V', '统一社会信用代码', 've_vegroup_bank', 'company_cert_type', ''),
(1461, '0', '未上传', 've_vegroup_bank', 'image_states', ''),
(1462, '1', '已上传', 've_vegroup_bank', 'image_states', ''),
(1463, '0', '未申请', 've_vegroup_bank', 'status', ''),
(1464, '1', '未确认', 've_vegroup_bank', 'status', ''),
(1465, '2', '申请失败', 've_vegroup_bank', 'status', ''),
(1466, '3', '审核中', 've_vegroup_bank', 'status', ''),
(1467, '4', '审核通过', 've_vegroup_bank', 'status', ''),
(1468, '5', '审核未通过', 've_vegroup_bank', 'status', ''),
(1469, '0', '是', 've_vegroup_bank', 'is_device', ''),
(1470, '1', '否', 've_vegroup_bank', 'is_device', ''),
(1471, '0', '未上传', 've_farmer_bank', 'image_states', ''),
(1472, '1', '已上传', 've_farmer_bank', 'image_states', ''),
(1479, '0', '预支款', 've_payment_advance', 'advance_type', NULL),
(1480, '1', '已还清', 've_payment_advance', 'advance_type', NULL),
(1481, '0', '正常', 've_payment_advance', 'states', ''),
(1482, '1', '完成', 've_payment_advance', 'states', NULL),
(1483, '0', '现金', 've_payment_advance', 'payment_type', ''),
(1484, '1', '银行转账', 've_payment_advance', 'payment_type', ''),
(1485, '0', '两位小数', 'v_ve_vegroup_manager_login', 'account_precision', ''),
(1486, '1', '整数（舍去小数）', 'v_ve_vegroup_manager_login', 'account_precision', ''),
(1487, '0', '精品', 'v_payment_order', 'quality', ''),
(1488, '1', '通货', 'v_payment_order', 'quality', ''),
(1489, '2', '精品', 'v_payment_order', 'quality', ''),
(1490, '0', '未付款', 'v_payment_order', 'repay_status', ''),
(1491, '1', '未付清', 'v_payment_order', 'repay_status', ''),
(1492, '2', '已付清', 'v_payment_order', 'repay_status', ''),
(1493, '0', '交易中', 'v_payment_order', 'state', ''),
(1494, '1', '交易完成', 'v_payment_order', 'state', ''),
(1495, '0', '过磅记录', 'v_payment_order', 'order_type', ''),
(1496, '1', '过磅记录调货', 'v_payment_order', 'order_type', ''),
(1497, '2', '调货记录', 'v_payment_order', 'order_type', ''),
(1498, '0', '否', 'v_payment_order', 'is_auto', ''),
(1499, '1', '是', 'v_payment_order', 'is_auto', ''),
(1500, '0', '农户端未开价', 'v_payment_order', 'is_opening_price', ''),
(1501, '1', '农户端已开价', 'v_payment_order', 'is_opening_price', ''),
(1502, '0', '未知', 'v_payment_order', 'is_peeling_all', ''),
(1503, '1', '除皮完成', 'v_payment_order', 'is_peeling_all', ''),
(1504, '0', '独立市场', 'v_payment_order', 'grouptype', ''),
(1505, '1', '多租户市场', 'v_payment_order', 'grouptype', ''),
(1506, '2', '租户', 'v_payment_order', 'grouptype', ''),
(1507, '0', '未付款', 'v_payment_order', 'payment_states', ''),
(1508, '1', '未付清', 'v_payment_order', 'payment_states', ''),
(1509, '2', '已付清', 'v_payment_order', 'payment_states', ''),
(1512, '0', '测试', 've_app2_version', 'states', ''),
(1513, '1', '生产', 've_app2_version', 'states', ''),
(1514, '2', '作废', 've_app2_version', 'states', ''),
(1519, '0', '按金额', 'v_ve_vegroup_manager_login', 'order_fee_type', ''),
(1520, '1', '按重量', 'v_ve_vegroup_manager_login', 'order_fee_type', ''),
(1525, '0', '定价', 've_vegroup_farmer_price', 'status', ''),
(1526, '1', '使用', 've_vegroup_farmer_price', 'status', ''),
(1527, '0', '是', 'v_ve_vegroup_manager_login', 'is_immediate_payment', ''),
(1528, '1', '否', 'v_ve_vegroup_manager_login', 'is_immediate_payment', ''),
(1529, '0', '先收货后定价', 'v_ve_vegroup_manager_login', 'transaction_mode', ''),
(1530, '1', '先定价后收货', 'v_ve_vegroup_manager_login', 'transaction_mode', ''),
(1538, '0', '有效', 've_device', 'is_hide', ''),
(1539, '1', '失效', 've_device', 'is_hide', ''),
(1540, '1', '斤', 've_device', 'weight_unit', ''),
(1541, '2', '公斤', 've_device', 'weight_unit', ''),
(1542, '1', '数据传输模块', 've_device', 'device_type', ''),
(1543, '2', '工业路由器', 've_device', 'device_type', NULL),
(1544, '0', '不是', 'v_ve_vegroup_type_tree', 'defaults', ''),
(1545, '1', '是', 'v_ve_vegroup_type_tree', 'defaults', ''),
(1546, '0', '正常', 'v_ve_vegroup_type_tree', 'states', ''),
(1547, '1', '删除', 'v_ve_vegroup_type_tree', 'states', ''),
(1548, '3', '工业路由器+DTU', 've_device', 'device_type', NULL),
(1549, '0', '二级商户关闭', 've_farmer_bank', 'v_shanghu_status', NULL),
(1550, '1', '二级商户开启', 've_farmer_bank', 'v_shanghu_status', NULL),
(1551, '0', '关闭', 've_farmer_bank', 'shanghu_status', ''),
(1552, '1', '开启', 've_farmer_bank', 'shanghu_status', ''),
(1555, '0', '列表', 'yz_log', 'type', ''),
(1556, '1', '详情', 'yz_log', 'type', ''),
(1557, '2', '添加', 'yz_log', 'type', ''),
(1558, '3', '修改', 'yz_log', 'type', ''),
(1559, '4', '删除', 'yz_log', 'type', ''),
(1560, '5', '网页', 'yz_log', 'type', ''),
(1561, '0', '使用中', 'v_ve_farmer_bank_for_group', 'states', ''),
(1562, '1', '已删除', 'v_ve_farmer_bank_for_group', 'states', ''),
(1563, '2', '注销', 'v_ve_farmer_bank_for_group', 'states', ''),
(1564, '0', '临沂商业银行', 'v_ve_farmer_bank_for_group', 'bank', ''),
(1565, '1', '潍坊银行', 'v_ve_farmer_bank_for_group', 'bank', ''),
(1566, '2', '农业银行', 'v_ve_farmer_bank_for_group', 'bank', ''),
(1567, '401', '借记卡', 'v_ve_farmer_bank_for_group', 'account_type', ''),
(1568, '601', '企业户', 'v_ve_farmer_bank_for_group', 'account_type', ''),
(1569, '701', '二类户', 'v_ve_farmer_bank_for_group', 'account_type', ''),
(1570, '702', '三类户', 'v_ve_farmer_bank_for_group', 'account_type', ''),
(1571, 'I', '身份证', 'v_ve_farmer_bank_for_group', 'certificate_type', ''),
(1572, 'P', '护照', 'v_ve_farmer_bank_for_group', 'certificate_type', ''),
(1573, 'G', '军官证', 'v_ve_farmer_bank_for_group', 'certificate_type', ''),
(1574, 'U', '其他证件', 'v_ve_farmer_bank_for_group', 'certificate_type', ''),
(1575, 'U', '营业执照', 'v_ve_farmer_bank_for_group', 'company_cert_type', ''),
(1576, 'Y', '组织机构代码证', 'v_ve_farmer_bank_for_group', 'company_cert_type', ''),
(1577, 'V', '统一社会信用代码', 'v_ve_farmer_bank_for_group', 'company_cert_type', ''),
(1578, '0', '未上传', 'v_ve_farmer_bank_for_group', 'image_states', ''),
(1579, '1', '已上传', 'v_ve_farmer_bank_for_group', 'image_states', ''),
(1580, '0', '未申请', 'v_ve_farmer_bank_for_group', 'status', ''),
(1581, '1', '未确认', 'v_ve_farmer_bank_for_group', 'status', ''),
(1582, '2', '申请失败', 'v_ve_farmer_bank_for_group', 'status', ''),
(1583, '3', '审核中', 'v_ve_farmer_bank_for_group', 'status', ''),
(1584, '4', '审核通过', 'v_ve_farmer_bank_for_group', 'status', ''),
(1585, '5', '审核未通过', 'v_ve_farmer_bank_for_group', 'status', ''),
(1586, '0', '是', 'v_ve_farmer_bank_for_group', 'is_device', ''),
(1587, '1', '否', 'v_ve_farmer_bank_for_group', 'is_device', ''),
(1588, '0', '关闭', 'v_ve_farmer_bank_for_group', 'shanghu_status', ''),
(1589, '1', '开启', 'v_ve_farmer_bank_for_group', 'shanghu_status', ''),
(1590, '0', '独立市场', 'v_nh_bank_vegroup', 'grouptype', ''),
(1591, '1', '多租户市场', 'v_nh_bank_vegroup', 'grouptype', ''),
(1592, '2', '租户', 'v_nh_bank_vegroup', 'grouptype', ''),
(1593, '0', '实际收货价格', 'v_nh_bank_vegroup', 'accounting_method', ''),
(1594, '1', '收货计划统一价格', 'v_nh_bank_vegroup', 'accounting_method', ''),
(1595, '0', '到自己', 'v_nh_bank_vegroup', 'receivable_state', ''),
(1596, '1', '不到自己', 'v_nh_bank_vegroup', 'receivable_state', ''),
(1597, '0', '1笔', 'v_nh_bank_vegroup', 'out_num', ''),
(1598, '1', '多笔', 'v_nh_bank_vegroup', 'out_num', ''),
(1599, '0', '两位小数（四舍五入）', 'v_nh_bank_vegroup', 'account_precision', ''),
(1600, '1', '整数（舍去小数）', 'v_nh_bank_vegroup', 'account_precision', ''),
(1601, '2', '整数（四舍五入）', 'v_nh_bank_vegroup', 'account_precision', ''),
(1602, '3', '一位小数（舍去小数）', 'v_nh_bank_vegroup', 'account_precision', ''),
(1603, '4', '一位小数（四舍五入）', 'v_nh_bank_vegroup', 'account_precision', ''),
(1604, '0', '不领取', 'v_nh_bank_vegroup', 'is_get_package', ''),
(1605, '1', '领取', 'v_nh_bank_vegroup', 'is_get_package', ''),
(1606, '0', '有人执守', 'v_nh_bank_vegroup', 'is_auto_record', ''),
(1607, '1', '无人执守', 'v_nh_bank_vegroup', 'is_auto_record', ''),
(1608, '0', '正常', 'v_nh_bank_vegroup', 'other_config', ''),
(1609, '1', '小磅多框', 'v_nh_bank_vegroup', 'other_config', ''),
(1610, '2', '标箱整重', 'v_nh_bank_vegroup', 'other_config', ''),
(1611, '3', '领料去皮', 'v_nh_bank_vegroup', 'other_config', ''),
(1612, '0', '不使用', 'v_nh_bank_vegroup', 'is_use_bank', ''),
(1613, '1', '使用', 'v_nh_bank_vegroup', 'is_use_bank', ''),
(1614, '0', '实时开价', 'v_nh_bank_vegroup', 'opening_price_type', ''),
(1615, '1', '定时开价', 'v_nh_bank_vegroup', 'opening_price_type', ''),
(1616, '2', '手动开价', 'v_nh_bank_vegroup', 'opening_price_type', ''),
(1617, '0', '不生成', 'v_nh_bank_vegroup', 'is_auto_create_tomorrow_order', ''),
(1618, '1', '自动生成', 'v_nh_bank_vegroup', 'is_auto_create_tomorrow_order', ''),
(1619, '0', '不是', 'v_nh_bank_vegroup', 'ismaster', ''),
(1620, '1', '是', 'v_nh_bank_vegroup', 'ismaster', ''),
(1621, '1', '斤', 'v_nh_bank_vegroup', 'weight_unit', ''),
(1622, '2', '公斤', 'v_nh_bank_vegroup', 'weight_unit', ''),
(1623, '0', '不收', 'v_nh_bank_vegroup', 'is_order_fee', ''),
(1624, '1', '收取', 'v_nh_bank_vegroup', 'is_order_fee', ''),
(1625, '0', '按金额', 'v_nh_bank_vegroup', 'order_fee_type', ''),
(1626, '1', '按重量', 'v_nh_bank_vegroup', 'order_fee_type', ''),
(1627, '0', '不计算', 'v_nh_bank_vegroup', 'is_calculate_loss', ''),
(1628, '1', '计算', 'v_nh_bank_vegroup', 'is_calculate_loss', ''),
(1629, '0', '是', 'v_nh_bank_vegroup', 'is_immediate_payment', ''),
(1630, '1', '否', 'v_nh_bank_vegroup', 'is_immediate_payment', ''),
(1631, '0', '先收货后定价', 'v_nh_bank_vegroup', 'transaction_mode', ''),
(1632, '1', '先定价后收货', 'v_nh_bank_vegroup', 'transaction_mode', ''),
(1633, '0', 'token', 've_vegroup_transfer_record', 'progress', ''),
(1634, '1', 'ticket', 've_vegroup_transfer_record', 'progress', ''),
(1635, '0', '未付款', 've_vegroup_transfer_record', 'states', ''),
(1636, '1', '付款成功', 've_vegroup_transfer_record', 'states', ''),
(1637, '2', '取消付款', 've_vegroup_transfer_record', 'states', ''),
(1638, '3', '付款失败', 've_vegroup_transfer_record', 'states', ''),
(1639, '4', '付款状态未知（手动处理）', 've_vegroup_transfer_record', 'states', ''),
(1640, '5', '内转成功', 've_vegroup_transfer_record', 'states', ''),
(1641, '6', '生成支付订单', 've_vegroup_transfer_record', 'states', ''),
(1642, '7', '退款失败', 've_vegroup_transfer_record', 'states', ''),
(1643, '8', '退款成功', 've_vegroup_transfer_record', 'states', ''),
(1644, '0', '农户付款', 've_vegroup_transfer_record', 'payment_type', ''),
(1645, '1', '农户预支', 've_vegroup_transfer_record', 'payment_type', ''),
(1646, '0', '现金', 'v_nh_group_payment', 'payment_type', ''),
(1647, '1', '银行转账', 'v_nh_group_payment', 'payment_type', ''),
(1648, '0', '支付未完成', 'v_nh_group_payment', 'states', ''),
(1649, '1', '支付完成', 'v_nh_group_payment', 'states', ''),
(1650, '0', '未生成', 'v_nh_group_payment', 'create_states', ''),
(1651, '1', '生成', 'v_nh_group_payment', 'create_states', ''),
(1669, '0', '精品', 've_order', 'quality', ''),
(1670, '1', '通货', 've_order', 'quality', ''),
(1671, '2', '精品', 've_order', 'quality', ''),
(1672, '0', '未付款', 've_order', 'repay_status', ''),
(1673, '1', '未付清', 've_order', 'repay_status', ''),
(1674, '2', '已付清', 've_order', 'repay_status', ''),
(1675, '0', '交易中', 've_order', 'state', ''),
(1676, '1', '交易完成', 've_order', 'state', ''),
(1677, '0', '过磅记录', 've_order', 'order_type', ''),
(1678, '1', '过磅记录调货', 've_order', 'order_type', ''),
(1679, '2', '调货记录', 've_order', 'order_type', ''),
(1680, '0', '否', 've_order', 'is_auto', ''),
(1681, '1', '是', 've_order', 'is_auto', ''),
(1682, '0', '农户端未开价', 've_order', 'is_opening_price', ''),
(1683, '1', '农户端已开价', 've_order', 'is_opening_price', ''),
(1686, '0', '未知', 've_order', 'is_peeling_all', ''),
(1687, '1', '除皮完成', 've_order', 'is_peeling_all', ''),
(1688, '0', '精品', 'v_ve_order_payment_detail', 'quality', ''),
(1689, '1', '通货', 'v_ve_order_payment_detail', 'quality', ''),
(1690, '2', '精品', 'v_ve_order_payment_detail', 'quality', ''),
(1691, '0', '未付款', 'v_ve_order_payment_detail', 'repay_status', ''),
(1692, '1', '未付清', 'v_ve_order_payment_detail', 'repay_status', ''),
(1693, '2', '已付清', 'v_ve_order_payment_detail', 'repay_status', ''),
(1694, '0', '交易中', 'v_ve_order_payment_detail', 'state', ''),
(1695, '1', '交易完成', 'v_ve_order_payment_detail', 'state', ''),
(1696, '0', '过磅记录', 'v_ve_order_payment_detail', 'order_type', ''),
(1697, '1', '过磅记录调货', 'v_ve_order_payment_detail', 'order_type', ''),
(1698, '2', '调货记录', 'v_ve_order_payment_detail', 'order_type', ''),
(1699, '0', '否', 'v_ve_order_payment_detail', 'is_auto', ''),
(1700, '1', '是', 'v_ve_order_payment_detail', 'is_auto', ''),
(1701, '0', '农户端未开价', 'v_ve_order_payment_detail', 'is_opening_price', ''),
(1702, '1', '农户端已开价', 'v_ve_order_payment_detail', 'is_opening_price', ''),
(1703, '0', '未知', 'v_ve_order_payment_detail', 'is_peeling_all', ''),
(1704, '1', '除皮完成', 'v_ve_order_payment_detail', 'is_peeling_all', ''),
(1705, '0', '使用中', 'v_ve_farmer_bank_for_nh_card', 'states', ''),
(1706, '1', '已删除', 'v_ve_farmer_bank_for_nh_card', 'states', ''),
(1707, '2', '注销', 'v_ve_farmer_bank_for_nh_card', 'states', ''),
(1708, '0', '临沂商业银行', 'v_ve_farmer_bank_for_nh_card', 'bank', ''),
(1709, '1', '潍坊银行', 'v_ve_farmer_bank_for_nh_card', 'bank', ''),
(1710, '2', '农业银行', 'v_ve_farmer_bank_for_nh_card', 'bank', ''),
(1711, '401', '借记卡', 'v_ve_farmer_bank_for_nh_card', 'account_type', ''),
(1712, '601', '企业户', 'v_ve_farmer_bank_for_nh_card', 'account_type', ''),
(1713, '701', '二类户', 'v_ve_farmer_bank_for_nh_card', 'account_type', ''),
(1714, '702', '三类户', 'v_ve_farmer_bank_for_nh_card', 'account_type', ''),
(1715, 'I', '身份证', 'v_ve_farmer_bank_for_nh_card', 'certificate_type', ''),
(1716, 'P', '护照', 'v_ve_farmer_bank_for_nh_card', 'certificate_type', ''),
(1717, 'G', '军官证', 'v_ve_farmer_bank_for_nh_card', 'certificate_type', ''),
(1718, 'U', '其他证件', 'v_ve_farmer_bank_for_nh_card', 'certificate_type', ''),
(1719, 'U', '营业执照', 'v_ve_farmer_bank_for_nh_card', 'company_cert_type', ''),
(1720, 'Y', '组织机构代码证', 'v_ve_farmer_bank_for_nh_card', 'company_cert_type', ''),
(1721, 'V', '统一社会信用代码', 'v_ve_farmer_bank_for_nh_card', 'company_cert_type', ''),
(1722, '0', '未上传', 'v_ve_farmer_bank_for_nh_card', 'image_states', ''),
(1723, '1', '已上传', 'v_ve_farmer_bank_for_nh_card', 'image_states', ''),
(1724, '0', '未申请', 'v_ve_farmer_bank_for_nh_card', 'status', ''),
(1725, '1', '未确认', 'v_ve_farmer_bank_for_nh_card', 'status', ''),
(1726, '2', '申请失败', 'v_ve_farmer_bank_for_nh_card', 'status', ''),
(1727, '3', '审核中', 'v_ve_farmer_bank_for_nh_card', 'status', ''),
(1728, '4', '审核通过', 'v_ve_farmer_bank_for_nh_card', 'status', ''),
(1729, '5', '审核未通过', 'v_ve_farmer_bank_for_nh_card', 'status', ''),
(1730, '0', '是', 'v_ve_farmer_bank_for_nh_card', 'is_device', ''),
(1731, '1', '否', 'v_ve_farmer_bank_for_nh_card', 'is_device', ''),
(1732, '0', '关闭', 'v_ve_farmer_bank_for_nh_card', 'shanghu_status', ''),
(1733, '1', '开启', 'v_ve_farmer_bank_for_nh_card', 'shanghu_status', ''),
(1734, '0', '农户', 've_farmer', 'v_user_type', NULL),
(1735, '1', '合作社管理员', 've_farmer', 'v_user_type', NULL),
(1736, '2', '收货商', 've_farmer', 'v_user_type', NULL),
(1737, '0', '未知', 've_abc_user', 'user_type', ''),
(1738, '1', '农户', 've_abc_user', 'user_type', ''),
(1739, '2', '合作社管理员', 've_abc_user', 'user_type', ''),
(1740, '3', '收货商', 've_abc_user', 'user_type', ''),
(1741, '0', '主卡', 've_vegroup_farmer_other_card', 'card_type', ''),
(1742, '1', '副卡', 've_vegroup_farmer_other_card', 'card_type', ''),
(1743, '0', '主卡', 've_vegroup_farmer_fee_ statistics_detail', 'card_type', ''),
(1744, '1', '副卡', 've_vegroup_farmer_fee_ statistics_detail', 'card_type', ''),
(1745, '0', '充值', 've_vegroup_farmer_fee_ statistics_detail', 'fee_type', ''),
(1746, '1', '过磅费', 've_vegroup_farmer_fee_ statistics_detail', 'fee_type', ''),
(1747, '2', '副卡押金', 've_vegroup_farmer_fee_ statistics_detail', 'fee_type', ''),
(1748, '3', '退卡押金', 've_vegroup_farmer_fee_ statistics_detail', 'fee_type', ''),
(1749, '0', '生效', 've_vegroup_farmer_other_card', 'states', ''),
(1750, '1', '已退卡', 've_vegroup_farmer_other_card', 'states', ''),
(1761, '0', '实际收货价格', 've_vegroup', 'accounting_method', ''),
(1762, '1', '收货计划统一价格', 've_vegroup', 'accounting_method', ''),
(1763, '0', '到自己', 've_vegroup', 'receivable_state', ''),
(1764, '1', '不到自己', 've_vegroup', 'receivable_state', ''),
(1765, '0', '1笔', 've_vegroup', 'out_num', ''),
(1766, '1', '多笔', 've_vegroup', 'out_num', ''),
(1767, '0', '两位小数（四舍五入）', 've_vegroup', 'account_precision', ''),
(1768, '1', '整数（舍去小数）', 've_vegroup', 'account_precision', ''),
(1769, '2', '整数（四舍五入）', 've_vegroup', 'account_precision', ''),
(1770, '3', '一位小数（舍去小数）', 've_vegroup', 'account_precision', ''),
(1771, '4', '一位小数（四舍五入）', 've_vegroup', 'account_precision', ''),
(1772, '5', '整数一位四舍入五', 've_vegroup', 'account_precision', ''),
(1773, '0', '不领取', 've_vegroup', 'is_get_package', ''),
(1774, '1', '领取', 've_vegroup', 'is_get_package', ''),
(1775, '0', '有人执守', 've_vegroup', 'is_auto_record', ''),
(1776, '1', '无人执守', 've_vegroup', 'is_auto_record', ''),
(1777, '0', '正常', 've_vegroup', 'other_config', ''),
(1778, '1', '小磅多框', 've_vegroup', 'other_config', ''),
(1779, '2', '标箱整重', 've_vegroup', 'other_config', ''),
(1780, '3', '领料去皮', 've_vegroup', 'other_config', ''),
(1781, '0', '不使用', 've_vegroup', 'is_use_bank', ''),
(1782, '1', '使用', 've_vegroup', 'is_use_bank', ''),
(1783, '0', '实时开价', 've_vegroup', 'opening_price_type', ''),
(1784, '1', '定时开价', 've_vegroup', 'opening_price_type', ''),
(1785, '2', '手动开价', 've_vegroup', 'opening_price_type', ''),
(1786, '0', '不生成', 've_vegroup', 'is_auto_create_tomorrow_order', ''),
(1787, '1', '自动生成', 've_vegroup', 'is_auto_create_tomorrow_order', ''),
(1788, '0', '不是', 've_vegroup', 'ismaster', ''),
(1789, '1', '是', 've_vegroup', 'ismaster', ''),
(1790, '1', '斤', 've_vegroup', 'weight_unit', ''),
(1791, '2', '公斤', 've_vegroup', 'weight_unit', ''),
(1792, '0', '不收', 've_vegroup', 'is_order_fee', ''),
(1793, '1', '收取', 've_vegroup', 'is_order_fee', ''),
(1794, '0', '按金额', 've_vegroup', 'order_fee_type', ''),
(1795, '1', '按重量', 've_vegroup', 'order_fee_type', ''),
(1796, '0', '不计算', 've_vegroup', 'is_calculate_loss', ''),
(1797, '1', '计算', 've_vegroup', 'is_calculate_loss', ''),
(1798, '0', '两位小数（四舍五入）', 've_vegroup', 'calculate_precision', ''),
(1799, '1', '整数（舍去小数）', 've_vegroup', 'calculate_precision', ''),
(1800, '2', '整数（四舍五入）', 've_vegroup', 'calculate_precision', ''),
(1801, '3', '一位小数（舍去小数）', 've_vegroup', 'calculate_precision', ''),
(1802, '4', '一位小数（四舍五入）', 've_vegroup', 'calculate_precision', ''),
(1803, '0', '是', 've_vegroup', 'is_immediate_payment', ''),
(1804, '1', '否', 've_vegroup', 'is_immediate_payment', ''),
(1805, '0', '否', 've_vegroup', 'transaction_mode', NULL),
(1806, '1', '是', 've_vegroup', 'transaction_mode', NULL),
(1807, '0', '不收', 've_vegroup', 'is_weighing_charge', ''),
(1808, '1', '收', 've_vegroup', 'is_weighing_charge', ''),
(1809, '0', '否', 've_vegroup', 'is_child_group_collection', ''),
(1810, '1', '代收', 've_vegroup', 'is_child_group_collection', ''),
(1811, '0', '有效', 'yz_user_power', 'power_state', ''),
(1812, '1', '取消', 'yz_user_power', 'power_state', ''),
(1813, '0', '测试', 've_app3_version', 'states', ''),
(1814, '1', '生产', 've_app3_version', 'states', ''),
(1815, '2', '作废', 've_app3_version', 'states', ''),
(1816, '0', '农户', 've_abc_wx_user', 'user_type', ''),
(1817, '1', '代办', 've_abc_wx_user', 'user_type', ''),
(1818, '2', '商贩', 've_abc_wx_user', 'user_type', ''),
(1819, '0', '默念', 've_abc_wx_user_phone', 'type', ''),
(1820, '1', '非默认', 've_abc_wx_user_phone', 'type', ''),
(1823, '3', '调货', 've_order_logs2', 'style', NULL),
(1824, '4', '开价', 've_order_logs2', 'style', NULL),
(1825, '5', '认领', 've_order_logs2', 'style', NULL),
(1826, '6', '取消认领', 've_order_logs2', 'style', NULL),
(1827, '7', '补交易单', 've_order_logs2', 'style', NULL),
(1828, '0', '未付款', 've_vegroup_farmer_fee_statistics_bank', 'states', ''),
(1829, '1', '付款成功', 've_vegroup_farmer_fee_statistics_bank', 'states', ''),
(1830, '0', '农户付款', 've_vegroup_farmer_fee_statistics_bank', 'payment_type', ''),
(1831, '1', '交易费', 've_vegroup_farmer_fee_statistics_bank', 'payment_type', ''),
(1832, '0', '农行转账', 've_vegroup_farmer_fee_statistics_bank', 'type', ''),
(1833, '1', '现金', 've_vegroup_farmer_fee_statistics_bank', 'type', ''),
(1834, '0', '测试', 've_app_terminal_version', 'states', ''),
(1835, '1', '生产', 've_app_terminal_version', 'states', ''),
(1836, '2', '作废', 've_app_terminal_version', 'states', ''),
(1853, '0', '不免费', 've_vegroup_farmer', 'free_fee_states', ''),
(1854, '1', '免费', 've_vegroup_farmer', 'free_fee_states', ''),
(1855, '0', '正常', 've_vegroup_car_order_detail', 'states', ''),
(1856, '1', '失效', 've_vegroup_car_order_detail', 'states', ''),
(1857, '0', '1次过磅', 've_vegroup_car_order_detail', 'order_type', ''),
(1858, '1', '二次过磅', 've_vegroup_car_order_detail', 'order_type', ''),
(1859, '0', '未付款', 've_vegroup_car_order_fee_bank', 'states', ''),
(1860, '1', '付款成功', 've_vegroup_car_order_fee_bank', 'states', ''),
(1861, '2', '付款失败', 've_vegroup_car_order_fee_bank', 'states', ''),
(1862, '1', '分销', 've_vegroup_car_order_fee_bank', 'type', ''),
(1863, '2', '出货', 've_vegroup_car_order_fee_bank', 'type', ''),
(1864, '3', '商贩进货', 've_vegroup_car_order_fee_bank', 'type', ''),
(1865, '0', '银行卡', 've_vegroup_car_order_fee_bank', 'pay_source', ''),
(1866, '1', '现金', 've_vegroup_car_order_fee_bank', 'pay_source', ''),
(1867, '0', '正常', 've_device_big_car', 'states', ''),
(1868, '1', '删除', 've_device_big_car', 'states', ''),
(1869, '0', '精品', 'v_order_today_list', 'quality', ''),
(1870, '1', '通货', 'v_order_today_list', 'quality', ''),
(1871, '2', '精品', 'v_order_today_list', 'quality', ''),
(1872, '0', '未付款', 'v_order_today_list', 'repay_status', ''),
(1873, '1', '未付清', 'v_order_today_list', 'repay_status', ''),
(1874, '2', '已付清', 'v_order_today_list', 'repay_status', ''),
(1875, '0', '交易中', 'v_order_today_list', 'state', ''),
(1876, '1', '交易完成', 'v_order_today_list', 'state', ''),
(1877, '0', '过磅记录', 'v_order_today_list', 'order_type', ''),
(1878, '1', '过磅记录调货', 'v_order_today_list', 'order_type', ''),
(1879, '2', '调货记录', 'v_order_today_list', 'order_type', ''),
(1880, '0', '否', 'v_order_today_list', 'is_auto', ''),
(1881, '1', '是', 'v_order_today_list', 'is_auto', ''),
(1882, '0', '农户端未开价', 'v_order_today_list', 'is_opening_price', ''),
(1883, '1', '农户端已开价', 'v_order_today_list', 'is_opening_price', ''),
(1884, '0', '未知', 'v_order_today_list', 'is_peeling_all', ''),
(1885, '1', '除皮完成', 'v_order_today_list', 'is_peeling_all', ''),
(1886, '0', '生效', 've_vegroup_order', 'status', ''),
(1887, '1', '取消', 've_vegroup_order', 'status', ''),
(1888, '2', '完成订单', 've_vegroup_order', 'status', ''),
(1889, '0', '农户端未开价', 've_vegroup_order', 'is_opening_price', ''),
(1890, '1', '农户端已开价', 've_vegroup_order', 'is_opening_price', ''),
(1893, '0', '正常', 've_farmer', 'state', ''),
(1894, '1', '注消', 've_farmer', 'state', ''),
(1897, '0', '自主注册', 've_farmer', 'add_source', ''),
(1898, '1', '合作社添加', 've_farmer', 'add_source', ''),
(1899, '0', '无卡', 've_farmer', 'card_states', ''),
(1900, '1', '有卡', 've_farmer', 'card_states', ''),
(1901, '0', '命令', 've_printer_model_detail', 'ptype', ''),
(1902, '1', '文本', 've_printer_model_detail', 'ptype', ''),
(1903, '0', '不是', 've_vegroup_manager_type', 'defaults', ''),
(1904, '1', '是', 've_vegroup_manager_type', 'defaults', ''),
(1909, '0', '下拉选择', 'v_ve_vegroup_manager_login', 'order_select_type', ''),
(1910, '1', '组合选择', 'v_ve_vegroup_manager_login', 'order_select_type', ''),
(1911, '0', '远程POS', 'v_ve_vegroup_manager_login', 'printer_model', ''),
(1912, '1', '本地POS', 'v_ve_vegroup_manager_login', 'printer_model', ''),
(1915, '0', '不隐藏', 've_channel', 'ishidden', ''),
(1916, '1', '隐藏', 've_channel', 'ishidden', ''),
(1917, '2', '半透明', 've_channel', 'ishidden', NULL),
(1918, '0', '生产', 've_crops_rotation', 'states', ''),
(1919, '1', '结束', 've_crops_rotation', 'states', ''),
(1920, '0', '有效', 've_crops_product_relation', 'states', ''),
(1921, '1', '失效', 've_crops_product_relation', 'states', ''),
(1922, '0', '开启', 've_abc_wx_menu', 'view_states', ''),
(1923, '1', '关闭', 've_abc_wx_menu', 'view_states', ''),
(1924, '0', '不获取', 've_abc_wx_menu', 'is_openid', ''),
(1925, '1', '获取', 've_abc_wx_menu', 'is_openid', ''),
(1926, '0', '开启', 've_abc_wx_menu', 'click_states', ''),
(1927, '1', '关闭', 've_abc_wx_menu', 'click_states', ''),
(1928, '0', '开启', 've_abc_wx_menu', 'states', ''),
(1929, '1', '关闭', 've_abc_wx_menu', 'states', ''),
(1930, '0', '主卡', 've_vegroup_farmer_fee_statistics_detail', 'card_type', ''),
(1931, '1', '副卡', 've_vegroup_farmer_fee_statistics_detail', 'card_type', ''),
(1932, '0', '充值', 've_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1933, '1', '过磅费', 've_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1934, '2', '免收过磅费', 've_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1935, '4', '代办代扣', 've_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1936, '5', '代办代付', 've_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1937, '6', '赠送过磅费', 've_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1938, '0', '银行卡', 've_vegroup_farmer_fee_statistics_detail', 'fee_source', ''),
(1939, '1', '现金', 've_vegroup_farmer_fee_statistics_detail', 'fee_source', ''),
(1940, '2', '赠送', 've_vegroup_farmer_fee_statistics_detail', 'fee_source', ''),
(1941, '0', '主卡', 'v_ve_vegroup_farmer_fee_statistics_detail', 'card_type', ''),
(1942, '1', '副卡', 'v_ve_vegroup_farmer_fee_statistics_detail', 'card_type', ''),
(1943, '0', '充值', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1944, '1', '过磅费', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1945, '2', '免收过磅费', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1946, '4', '代办代扣', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1947, '5', '代办代付', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1948, '6', '赠送过磅费', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_type', ''),
(1949, '0', '银行卡', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_source', ''),
(1950, '1', '现金', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_source', ''),
(1951, '2', '赠送', 'v_ve_vegroup_farmer_fee_statistics_detail', 'fee_source', ''),
(1954, '0', '现金', 've_payment', 'payment_type', ''),
(1955, '1', '银行转账', 've_payment', 'payment_type', ''),
(1956, '0', '支付未完成', 've_payment', 'states', ''),
(1957, '1', '支付完成', 've_payment', 'states', ''),
(1958, '0', '未生成', 've_payment', 'create_states', ''),
(1959, '1', '生成', 've_payment', 'create_states', ''),
(1960, '0', '收入', 've_payment', 'account_type', ''),
(1961, '1', '支出', 've_payment', 'account_type', ''),
(1962, '0', '是', 've_vegroup', 'is_disconnection_submission', ''),
(1963, '1', '否', 've_vegroup', 'is_disconnection_submission', ''),
(1964, '0', '下拉选择', 've_vegroup', 'order_select_type', ''),
(1965, '1', '组合选择', 've_vegroup', 'order_select_type', ''),
(1966, '0', '远程POS', 've_vegroup', 'printer_model', ''),
(1967, '1', '本地POS', 've_vegroup', 'printer_model', ''),
(1968, '0', '不打印', 've_vegroup', 'is_payment_printer', ''),
(1969, '1', '打印', 've_vegroup', 'is_payment_printer', ''),
(1970, '-1', '未关联银行卡', 'v_ve_vegroup_farmer_bank_states', 'shanghu_status', ''),
(1971, '0', '商户未开启', 'v_ve_vegroup_farmer_bank_states', 'shanghu_status', ''),
(1972, '1', '商户开启', 'v_ve_vegroup_farmer_bank_states', 'shanghu_status', ''),
(1973, '0', '未还', 've_bill_sales_total', 'status', ''),
(1974, '1', '未还清', 've_bill_sales_total', 'status', ''),
(1975, '2', '已还清', 've_bill_sales_total', 'status', ''),
(1976, '0', '生效', 'v_ve_vegroup_order4', 'STATUS', ''),
(1977, '1', '取消', 'v_ve_vegroup_order4', 'STATUS', ''),
(1978, '2', '完成订单', 'v_ve_vegroup_order4', 'STATUS', ''),
(1979, '0', '农户端未开价', 'v_ve_vegroup_order4', 'is_opening_price', ''),
(1980, '1', '农户端已开价', 'v_ve_vegroup_order4', 'is_opening_price', ''),
(1981, '0', '有效', 've_other_fee_model', 'states', ''),
(1982, '1', '删除', 've_other_fee_model', 'states', ''),
(1983, '0', '发布', 've_vegroup_procurement', 'states', ''),
(1984, '1', '预发布', 've_vegroup_procurement', 'states', ''),
(1985, '2', '结束', 've_vegroup_procurement', 'states', ''),
(1986, '0', '发布', 've_farmer_inquiry', 'states', ''),
(1987, '1', '已认领', 've_farmer_inquiry', 'states', ''),
(1988, '0', '认领', 've_farmer_inquiry_comment', 'states', ''),
(1989, '1', '确认认领', 've_farmer_inquiry_comment', 'states', ''),
(1990, '0', '可见', 've_vegroup', 'order_no_user_is_select', ''),
(1991, '1', '不可见', 've_vegroup', 'order_no_user_is_select', ''),
(1992, '0', '未删除', 've_archives_cate', 'isdelete', ''),
(1993, '1', '已删除', 've_archives_cate', 'isdelete', ''),
(1994, '1', '有效', 've_product_demand', 'available', ''),
(1995, '0', '无效', 've_product_demand', 'available', ''),
(1996, '1', '计划中', 've_product_demand', 'accept', ''),
(1997, '0', '暂无计划', 've_product_demand', 'accept', ''),
(1998, '0', '设备状态', 've_android_msg', 'code_type', ''),
(1999, '1', '取重量', 've_android_msg', 'code_type', ''),
(2000, '2', '打印', 've_android_msg', 'code_type', ''),
(2001, '3', '发声', 've_android_msg', 'code_type', ''),
(2002, '0', '不是', 've_vegroup_type', 'defaults', ''),
(2003, '1', '是', 've_vegroup_type', 'defaults', ''),
(2004, '3', '个体工商户', 've_vegroup_bank', 'submertype', NULL),
(2005, '4', '政府、金融机构及事业单位', 've_vegroup_bank', 'submertype', NULL),
(2012, '0', '开团', 'v_ve_product_buy_list', 'states', ''),
(2013, '1', '完成', 'v_ve_product_buy_list', 'states', ''),
(2014, '0', '农户', 'v_ve_product_buy_list', 'uster_type', ''),
(2015, '1', '商户', 'v_ve_product_buy_list', 'uster_type', ''),
(2016, '0', '开团', 'v_ve_product_buy_list', 'buy_states', ''),
(2017, '1', '完成', 'v_ve_product_buy_list', 'buy_states', ''),
(2018, '0', '未开团', 've_product', 'buy_states', ''),
(2019, '1', '已开团', 've_product', 'buy_states', ''),
(2020, '2', '开团结束', 've_product', 'buy_states', ''),
(2021, '0', '农户', 've_product_buy_manager', 'uster_type', ''),
(2022, '1', '商户', 've_product_buy_manager', 'uster_type', ''),
(2023, '1', '申请', 've_product_buy_manager', 'states', ''),
(2024, '2', '审核通过', 've_product_buy_manager', 'states', ''),
(2025, '3', '审核不通过', 've_product_buy_manager', 'states', ''),
(2026, '0', '农户', 've_product_buy_list', 'uster_type', ''),
(2027, '1', '商户', 've_product_buy_list', 'uster_type', ''),
(2028, '1', '开团', 've_product_buy_list', 'states', ''),
(2029, '2', '完成', 've_product_buy_list', 'states', ''),
(2030, '0', '参团', 've_product_buy_detail', 'states', ''),
(2031, '1', '付款', 've_product_buy_detail', 'states', NULL),
(2032, '0', '农户', 've_product_buy_detail', 'uster_type', ''),
(2033, '1', '商户', 've_product_buy_detail', 'uster_type', ''),
(2034, '2', '完成', 've_product_buy_detail', 'states', NULL),
(2035, '3', '收货', 've_product_buy_detail', 'states', NULL),
(2036, '0', '企业', 've_vegroup_bank', 'mer_attr', ''),
(2037, '1', '个人', 've_vegroup_bank', 'mer_attr', ''),
(2038, '0', '对公', 've_vegroup_bank', 'acct_type', ''),
(2039, '1', '对私', 've_vegroup_bank', 'acct_type', ''),
(2040, '2', '虚户', 've_vegroup_bank', 'acct_type', ''),
(2041, '0', '关闭', 've_vegroup_bank', 'shanghu_status', ''),
(2042, '1', '开启', 've_vegroup_bank', 'shanghu_status', ''),
(2043, '0', '企业', 've_farmer_bank', 'mer_attr', ''),
(2044, '1', '个人', 've_farmer_bank', 'mer_attr', ''),
(2045, '0', '对公', 've_farmer_bank', 'acct_type', ''),
(2046, '1', '对私', 've_farmer_bank', 'acct_type', ''),
(2047, '2', '虚户', 've_farmer_bank', 'acct_type', ''),
(2048, '3', '九江银行', 've_vegroup_bank', 'bank', NULL),
(2049, '3', '九江银行', 've_farmer_bank', 'bank', NULL),
(2050, '1', '斤', 'v_ve_order', 'weight_unit', ''),
(2051, '2', '公斤', 'v_ve_order', 'weight_unit', ''),
(2052, '0', '未付款', 've_product_transfer_record', 'states', ''),
(2053, '1', '付款成功', 've_product_transfer_record', 'states', ''),
(2054, '2', '取消付款', 've_product_transfer_record', 'states', ''),
(2055, '3', '付款失败', 've_product_transfer_record', 'states', ''),
(2056, '4', '付款状态未知（手动处理）', 've_product_transfer_record', 'states', ''),
(2057, '5', '内转成功', 've_product_transfer_record', 'states', ''),
(2058, '6', '生成支付订单', 've_product_transfer_record', 'states', ''),
(2059, '7', '退款失败', 've_product_transfer_record', 'states', ''),
(2060, '8', '退款成功', 've_product_transfer_record', 'states', ''),
(2061, '2', '农行', 've_product_transfer_record', 'bank', ''),
(2062, '3', '九江银行', 've_product_transfer_record', 'bank', ''),
(2063, '0', '正常', 've_product_gift', 'states', ''),
(2064, '1', '删除', 've_product_gift', 'states', ''),
(2065, '0', '农户', 've_farmer_applet', 'user_type', ''),
(2066, '1', '合作社管理员', 've_farmer_applet', 'user_type', ''),
(2067, '2', '收货商', 've_farmer_applet', 'user_type', ''),
(2068, '0', '农户红包', 've_jiujiang_bank_hb', 'hb_type', ''),
(2069, '1', '商户红包', 've_jiujiang_bank_hb', 'hb_type', ''),
(2070, '0', '未领取', 've_jiujiang_bank_hb', 'states', ''),
(2071, '1', '已领取 ', 've_jiujiang_bank_hb', 'states', ''),
(2072, '0', '未鉴定', 've_weixin_img_check', 'states', ''),
(2073, '1', '鉴定成功', 've_weixin_img_check', 'states', ''),
(2074, '2', '鉴定失败', 've_weixin_img_check', 'states', ''),
(2075, '0', '正常', 've_farmer_type', 'states', ''),
(2076, '1', '删除', 've_farmer_type', 'states', ''),
(2077, '0', '有效', 've_jiujiang_banner', 'states', ''),
(2078, '1', '删除', 've_jiujiang_banner', 'states', ''),
(2079, '0', '全部', 've_jiujiang_banner', 'user_type', ''),
(2080, '1', '农户', 've_jiujiang_banner', 'user_type', ''),
(2081, '2', '商户', 've_jiujiang_banner', 'user_type', ''),
(2082, '0', '无', 've_ve_type_choose_standard', 'value_type', ''),
(2083, '1', '选择项', 've_ve_type_choose_standard', 'value_type', ''),
(2084, '2', '主观评价', 've_ve_type_choose_standard', 'value_type', ''),
(2085, '0', '无', 've_ve_type_choose_standard_custom', 'value_type', ''),
(2086, '1', '选择项', 've_ve_type_choose_standard_custom', 'value_type', ''),
(2087, '2', '主观评价', 've_ve_type_choose_standard_custom', 'value_type', ''),
(2088, '0', '无', 'v_ve_ve_type_choose_standard_custom', 'value_type', ''),
(2089, '1', '选择项', 'v_ve_ve_type_choose_standard_custom', 'value_type', ''),
(2090, '2', '主观评价', 'v_ve_ve_type_choose_standard_custom', 'value_type', ''),
(2091, '0', '无', 'v_ve_ve_type_choose_type_value', 'value_type', ''),
(2092, '1', '选择项', 'v_ve_ve_type_choose_type_value', 'value_type', ''),
(2093, '2', '主观评价', 'v_ve_ve_type_choose_type_value', 'value_type', ''),
(2094, '0', '未付款', 've_vegroup_transfer_record_wx', 'states', ''),
(2095, '1', '付款成功', 've_vegroup_transfer_record_wx', 'states', ''),
(2096, '2', '取消付款', 've_vegroup_transfer_record_wx', 'states', ''),
(2097, '3', '付款失败', 've_vegroup_transfer_record_wx', 'states', ''),
(2098, '4', '付款状态未知（手动处理）', 've_vegroup_transfer_record_wx', 'states', ''),
(2099, '5', '内转成功', 've_vegroup_transfer_record_wx', 'states', ''),
(2100, '6', '生成支付订单', 've_vegroup_transfer_record_wx', 'states', ''),
(2101, '7', '退款失败', 've_vegroup_transfer_record_wx', 'states', ''),
(2102, '8', '退款成功', 've_vegroup_transfer_record_wx', 'states', ''),
(2103, '0', '农户付款', 've_vegroup_transfer_record_wx', 'payment_type', ''),
(2104, '1', '农户预支', 've_vegroup_transfer_record_wx', 'payment_type', '');
/*!40000 ALTER TABLE `data_dicts` ENABLE KEYS */;
-- 导出 表 jfinal-layui.data_object 结构
DROP TABLE IF EXISTS `data_object`;
CREATE TABLE IF NOT EXISTS `data_object` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(100) NOT NULL COMMENT '对象编码',
`name` varchar(100) NOT NULL COMMENT '对象名称',
`view_name` varchar(255) DEFAULT NULL COMMENT '查询数据视图',
`table_name` varchar(255) DEFAULT NULL COMMENT '保存数据主表',
`pk_name` varchar(50) DEFAULT NULL COMMENT '主键',
`data_source` varchar(50) DEFAULT 'main' COMMENT '数据源',
`is_single` tinyint(4) DEFAULT 1 COMMENT '单选多选：0=多选，1=单选',
`is_celledit` tinyint(1) DEFAULT 0 COMMENT '行内编辑：0=否，1=是',
`is_show_num` tinyint(1) DEFAULT 1 COMMENT '显示行号：0=否，1=是',
`is_first_load` tinyint(1) DEFAULT 1 COMMENT '是否初始加载：0=否，1=是',
`filter` varchar(500) DEFAULT NULL COMMENT '初始数据过滤条件',
`default_order` varchar(255) DEFAULT NULL COMMENT '默认排序字段(desc)',
`diy_card` varchar(255) DEFAULT NULL COMMENT '自定义卡片面板',
`diy_js` varchar(255) DEFAULT NULL COMMENT '依赖JS文件',
`biz_intercept` varchar(255) DEFAULT NULL COMMENT '自定义业务拦截器',
`view_sql` varchar(1000) DEFAULT NULL COMMENT '视图SQL',
`config` varchar(2000) DEFAULT NULL COMMENT '拓展配置',
PRIMARY KEY (`id`),
UNIQUE KEY `unique_code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='元对象';
-- 正在导出表 jfinal-layui.data_object 的数据：~0 rows (大约)
DELETE FROM `data_object`;
/*!40000 ALTER TABLE `data_object` DISABLE KEYS */;
/*!40000 ALTER TABLE `data_object` ENABLE KEYS */;
-- 导出 表 jfinal-layui.data_source 结构
DROP TABLE IF EXISTS `data_source`;
CREATE TABLE IF NOT EXISTS `data_source` (
`id` varchar(64) NOT NULL COMMENT '主键',
`db_type` varchar(20) NOT NULL COMMENT 'dbType',
`jdbc_url` varchar(500) NOT NULL COMMENT 'jdbcUrl',
`user` varchar(20) NOT NULL COMMENT 'user',
`password` varchar(255) NOT NULL COMMENT 'password',
`config_name` varchar(20) NOT NULL COMMENT 'configName',
`title` varchar(100) NOT NULL COMMENT '标题',
`state` int(2) DEFAULT 1 COMMENT '开机启动（0：否，1：是）',
`start` int(2) DEFAULT 0 COMMENT '启动（0：否，1：是）',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='数据源';
-- 正在导出表 jfinal-layui.data_source 的数据：~0 rows (大约)
DELETE FROM `data_source`;
/*!40000 ALTER TABLE `data_source` DISABLE KEYS */;
INSERT INTO `data_source` (`id`, `db_type`, `jdbc_url`, `user`, `password`, `config_name`, `title`, `state`, `start`, `create_time`) VALUES
('4028e38189dd4cb30189dd550e59002f', 'mysql', 'jdbc:mysql://localhost/cd_app?characterEncoding=UTF-8&useSSL=false&allowMultiQueries=true', 'root', '123', 'Main', '业务数据库', 1, 1, '2023-08-10 10:44:46');
/*!40000 ALTER TABLE `data_source` ENABLE KEYS */;
-- 导出 表 jfinal-layui.file_uploaded 结构
DROP TABLE IF EXISTS `file_uploaded`;
CREATE TABLE IF NOT EXISTS `file_uploaded` (
`id` bigint(20) NOT NULL,
`create_time` datetime DEFAULT NULL,
`file_name` varchar(200) DEFAULT NULL,
`file_size` bigint(20) DEFAULT NULL COMMENT 'KB',
`save_path` varchar(300) DEFAULT NULL,
`object_id` varchar(200) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='附件表';
-- 正在导出表 jfinal-layui.file_uploaded 的数据：~0 rows (大约)
DELETE FROM `file_uploaded`;
/*!40000 ALTER TABLE `file_uploaded` DISABLE KEYS */;
/*!40000 ALTER TABLE `file_uploaded` ENABLE KEYS */;
-- 导出 表 jfinal-layui.form_sql 结构
DROP TABLE IF EXISTS `form_sql`;
CREATE TABLE IF NOT EXISTS `form_sql` (
`id` varchar(64) NOT NULL COMMENT '主键',
`tree_id` varchar(64) NOT NULL COMMENT '树id',
`code` varchar(50) NOT NULL COMMENT 'sql编号',
`name` varchar(50) NOT NULL COMMENT 'sql名称',
`content` varchar(500) NOT NULL COMMENT 'sql内容',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`descp` varchar(255) DEFAULT NULL COMMENT 'sql说明',
`config_name` varchar(50) DEFAULT NULL COMMENT '数据源配置名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='表单自定义查询sql';
-- 正在导出表 jfinal-layui.form_sql 的数据：~2 rows (大约)
DELETE FROM `form_sql`;
/*!40000 ALTER TABLE `form_sql` DISABLE KEYS */;
INSERT INTO `form_sql` (`id`, `tree_id`, `code`, `name`, `content`, `create_time`, `descp`, `config_name`) VALUES
('4028830c6b5feeb4016b5ff3bee9000c', '4028830c6b5fcc89016b5fd976fc005a', 'query_user', '查询用户', 'select a.*,b.org_name from sys_user a,sys_org b where a.org_id=b.id group by a.id order by a.id desc ', '2019-06-16 19:02:18', 'test', NULL),
('4028832c6cf20578016cf209c0300013', '4028830c6b5fcc89016b5fd976fc005a', 'query_org', '部门下拉sql', 'select id value,org_name name from sys_org', '2019-09-02 20:53:41', NULL, NULL);
/*!40000 ALTER TABLE `form_sql` ENABLE KEYS */;
-- 导出 表 jfinal-layui.form_view 结构
DROP TABLE IF EXISTS `form_view`;
CREATE TABLE IF NOT EXISTS `form_view` (
`id` varchar(64) NOT NULL,
`tree_id` varchar(64) NOT NULL,
`name` varchar(255) NOT NULL,
`code` varchar(255) NOT NULL,
`status` varchar(50) NOT NULL,
`template_view` text NOT NULL,
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
`descp` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='在线表单';
-- 正在导出表 jfinal-layui.form_view 的数据：~6 rows (大约)
DELETE FROM `form_view`;
/*!40000 ALTER TABLE `form_view` DISABLE KEYS */;
INSERT INTO `form_view` (`id`, `tree_id`, `name`, `code`, `status`, `template_view`, `create_time`, `update_time`, `descp`) VALUES
('402880e87a1ca809017a1ca9c15c0009', '402880e87a1ca809017a1ca89dda0004', '自定义查询用户列表', 'query_user', 'DEPLOYED', '\n#@layoutT("列表首页")\n#define main()\n<div class="container-wrap">\n #@formStart()\n #@queryStart(\'名称\')\n <input type="search" name="user_code" autocomplete="off" class="layui-input" placeholder="名称"/>\n #@queryEnd()\n #@queryStart(\'分类\')\n <input type="search" name="user_name" autocomplete="off" class="layui-input" placeholder="标识键"/>\n #@queryEnd() \n #@formEnd()\n \n <!-- 表头按钮 -->\n <div class=\'layui-row f-index-toolbar\'>\n <div class=\'layui-col-xs12\'>\n <div class="layui-btn-group">\n <button id=\'addBtn_\' class="layui-btn layui-btn-normal layui-btn-sm">\n <i class="layui-icon"></i> 新增\n </button>\n <button id=\'refreshBtn_\' class="layui-btn layui-btn-normal layui-btn-sm">\n <i class="layui-icon"></i> 刷新\n </button> \n <button id=\'deleteBtn_\' class="layui-btn layui-btn-normal layui-btn-sm">\n <i class="layui-icon"></i> 删除\n </button> \n </div>\n </div>\n </div>\n \n <!-- 表格列表 -->\n <div class="layui-row f-index-toolbar">\n <div class="layui-col-xs12">\n <table id="maingrid" lay-filter="maingrid"></table>\n </div>\n </div>\n \n <!-- 每行的操作按钮 -->\n <script type="text/html" id="bar_maingrid">\n <a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>\n <a class="layui-btn layui-btn-xs layui-btn-danger" lay-event="del">删除</a>\n </script>\n</div>\n#end\n\n#define js()\n<!-- 分页表格 -->\n<script>\n var object="sys_user";\n var addViewCode="user_add";\n var editViewCode="user_update";\n gridArgs.title=\'系统树\';\n gridArgs.dataId=\'id\';\n gridArgs.deleteUrl=\'#(path)/portal/form/business/delete?object=\'+object+\'&primaryKey=\'+gridArgs.dataId;\n gridArgs.updateUrl=\'#(path)/portal/form/business/edit?object=\'+object+\'&primaryKey=\'+gridArgs.dataId+\'&viewCode=\'+editViewCode+\'&id=\';\n gridArgs.addUrl=\'#(path)/portal/form/business/add?viewCode=\'+addViewCode;\n gridArgs.gridDivId =\'maingrid\';\n initGrid({id : \'maingrid\'\n ,elem : \'#maingrid\'\n ,cellMinWidth: 80\n ,cols : [ [\n {title: \'主键\',field : \'id\',width : 35,checkbox : true}, \n {title:\'序号\',type:\'numbers\',width:35},\n {title: \'用户编号\', field: \'user_code\'},\n {title: \'名称\', field: \'user_name\' },\n {title: \'部门\', field: \'org_name\' },\n {title: \'性别\', field: \'sex\',templet:function(obj){\n return obj.sex==1? \'男\' : \'女\';\n }}, \n {title: \'操作\',fixed:\'right\',width : 180,align : \'left\',toolbar : \'#bar_maingrid\'} // 这里的toolbar值是模板元素的选择器\n ] ]\n ,url:"#(path)/portal/form/business/list"\n ,where:{"object":object,"primaryKey":gridArgs.dataId,"sqlCode":"query_user"}//初始化查询参数\n ,searchForm : \'searchForm\'\n });\n</script>\n\n#end\n', '2021-06-18 09:08:45', '2021-06-25 14:47:33', NULL),
('402880e87a1ca809017a1cabef51001d', '402880e87a1ca809017a1ca89dda0004', '用户添加页', 'user_add', 'DEPLOYED', '\n#@layoutT("添加页")\n#define main()\n <form action="javascript:void(0)" class="layui-form layui-form-pane f-form" method="post" lay-filter=\'saveForm\'> \n <input type="hidden" class="layui-input" name="object" value="sys_user"/>\n <input type="hidden" class="layui-input" name="primaryKey" value="id"/>\n <input type="hidden" class="layui-input" name="id" value=""/>\n\n #(token)\n <div class="layui-row layui-col-space1 task-row">\n #@colStart("用户编号",12)\n <input type="text" name="user_code" value="" class="layui-input" lay-verType=\'tips\'lay-verify="required|" required maxlength="50" placeHolder="必填" />\n #@colEnd()\n </div>\n \n <div class="layui-row layui-col-space1 task-row">\n #set(req=true)\n #@colStart("用户姓名",12)\n <input type="text" name="user_name" value="" class="layui-input" lay-verType=\'tips\' lay-verify="required|" maxlength="50" placeHolder="必填" required />\n #@colEnd()\n </div> \n \n <div class="layui-row layui-col-space1 task-row">\n #@colStart("部门",12)\n #@getOrgSelect(\'orgId\',\'org_id\')\n #@colEnd()\n </div>\n <div class="layui-row layui-col-space1 task-row">\n #@colStart("性别",12)\n <input name="sex" type="radio" value="1" title="男"/>\n <input name="sex" type="radio" value="0" title="女" />\n #@colEnd()\n </div>\n #@submitButton()\n </form>\n \n#end\n\n<!-- 截取url参数 -->\n#define js()\n<script type="text/javascript">\n \n</script>\n#end\n\n<!-- 保存数据 -->\n#define layuiFunc() \n var saveUrl="#(path)/portal/form/business/save";\n#end\n', '2021-06-18 09:11:08', '2021-06-18 09:45:23', NULL),
('402880e87a1ca809017a1cb21170003d', '402880e87a1ca809017a1ca89dda0004', '用户修改页', 'user_update', 'DEPLOYED', '\n#@layoutT("修改页")\n#define main()\n\n <form action="javascript:void(0)" class="layui-form layui-form-pane f-form" method="post" lay-filter=\'saveForm\'>\n <input type="hidden" class="layui-input" name="object" value="sys_user"/>\n <input type="hidden" class="layui-input" name="primaryKey" value="id"/>\n <input type="hidden" class="layui-input" name="id" value="#(record.id??)"/>\n #(token)\n <div class="layui-row layui-col-space1 task-row">\n #@colStart("用户编号1",12)\n <input type="text" name="user_code" value="#(record.user_code??)" class="layui-input" lay-verType=\'tips\'lay-verify="required|" required maxlength="50" placeHolder="必填" />\n #@colEnd()\n </div>\n \n <div class="layui-row layui-col-space1 task-row">\n #set(req=true)\n #@colStart("用户姓名",12)\n <input type="text" name="user_name" value="#(record.user_name??)" class="layui-input" lay-verType=\'tips\' lay-verify="required|" maxlength="50" placeHolder="必填" required />\n #@colEnd()\n </div> \n \n <div class="layui-row layui-col-space1 task-row">\n #@colStart("部门",12)\n #set(value=record.org_id??)\n #@getOrgSelect(\'orgId\',\'org_id\')\n #@colEnd()\n </div>\n <div class="layui-row layui-col-space1 task-row">\n #@colStart("性别",12)\n <input name="sex" type="radio" value="1" title="男" checked="checked"/>\n <input name="sex" type="radio" value="0" title="女" #if(record.sex??==0)checked="checked" #end />\n #@colEnd()\n </div>\n #@submitButton()\n </form>\n \n#end\n\n<!-- 获取对象数据 -->\n#define js()\n<script type="text/javascript">\n \n</script>\n#end\n\n<!-- 保存数据 -->\n#define layuiFunc()\n var saveUrl="#(path)/portal/form/business/update";\n#end\n', '2021-06-18 09:17:50', '2023-08-29 16:03:38', NULL),
('402880fa6a61eb68016a620b0dba0079', '107400000000002215', '添加页', 'view_add', 'DEPLOYED', '\n#@layoutT("添加页")\n#define main()\n <form action="javascript:void(0)" class="layui-form layui-form-pane f-form" method="post" lay-filter=\'saveForm\'> \n <input type="hidden" class="layui-input" name="object" value="sys_tree"/>\n <input type="hidden" class="layui-input" name="id" value=""/>\n <input type="hidden" class="layui-input" name="parent_id" value=""/>\n #(token)\n <div class="layui-row layui-col-space1 task-row">\n #@colStart("所属分类",12)\n <input type="text" name="type" value="form" class="layui-input layui-disabled" lay-verType=\'tips\'lay-verify="required|" required maxlength="50" placeHolder="必填" readonly="readonly" />\n #@colEnd()\n </div>\n \n <div class="layui-row layui-col-space1 task-row">\n #@colStart("名称",12)\n <input type="text" name="name" value="" class="layui-input" lay-verType=\'tips\' lay-verify="required|" maxlength="50" placeHolder="必填" required />\n #@colEnd()\n </div> \n \n <div class="layui-row layui-col-space1 task-row">\n #@colStart("序号",12)\n <input type="number" name="order_no" value="1" class="layui-input"/>\n #@colEnd()\n </div>\n <div class="layui-row layui-col-space1 task-row">\n #@colStart("附件",12)\n <div id="test"></div>\n #@colEnd()\n </div>\n #@submitButton()\n </form>\n \n#end\n\n<!-- 截取url参数 -->\n#define js()\n<script type="text/javascript">\n //附件上传\n #@formUploadButton(\'test\',\'test\') \n \n</script>\n#end\n\n<!-- 保存数据 -->\n#define layuiFunc() \n var saveUrl="#(path)/portal/form/business/save";\n#end\n', '2019-04-28 11:44:13', '2021-06-18 11:56:45', '测试添加页面'),
('402880fa6a62f77b016a62fd9dad005d', '107400000000002215', '修改页', 'view_update', 'DEPLOYED', '\n#@layoutT("修改页")\n#define main()\n\n <form action="javascript:void()" class="layui-form layui-form-pane f-form" method="post" lay-filter=\'saveForm\'>\n <input type="hidden" class="layui-input" name="object" value="sys_tree"/>\n <input type="hidden" class="layui-input" name="id" value="#(record.id??)"/>\n <input type="hidden" class="layui-input" name="parent_id" value="#(record.parent_id??)"/>\n #(token)\n <div class="layui-row layui-col-space1 task-row">\n #@colStart("所属分类",12)\n <input type="text" name="type" value="#(record.type??)" class="layui-input layui-disabled" lay-verType=\'tips\'lay-verify="required|" required maxlength="50" placeHolder="必填" readonly="readonly" />\n #@colEnd()\n </div>\n \n <div class="layui-row layui-col-space1 task-row">\n #@colStart("名称",12)\n <input type="text" name="name" value="#(record.name??)" class="layui-input" lay-verType=\'tips\' lay-verify="required|" maxlength="50" placeHolder="必填" required />\n #@colEnd()\n </div> \n \n <div class="layui-row layui-col-space1 task-row">\n #@colStart("序号",12)\n <input type="number" name="order_no" value="#(record.order_no??)" class="layui-input"/>\n #@colEnd()\n </div>\n \n <div class="layui-row layui-col-space1 task-row">\n #@colStart("附件",12)\n <div id="test"></div>\n #@colEnd()\n </div>\n \n #@submitButton()\n </form>\n \n#end\n\n<!-- 获取对象数据 -->\n#define js()\n<script type="text/javascript">\n //附件上传\n #@formUploadButton(\'test\',\'test\') \n</script>\n#end\n\n<!-- 保存数据 -->\n#define layuiFunc()\n var saveUrl="#(path)/portal/form/business/update";\n#end\n', '2019-04-28 16:09:09', '2021-06-18 12:00:45', '修改数据页面'),
('402880fa6a62f77b016a62fe58b60066', '107400000000002215', '列表页', 'view_table', 'DEPLOYED', '\n#@layoutT("列表首页")\n#define main()\n<div class="container-wrap">\n #@formStart()\n #@queryStart(\'名称\')\n <input type="search" name="name" autocomplete="off" class="layui-input" placeholder="名称"/>\n #@queryEnd()\n #@queryStart(\'分类\')\n <input type="search" name="type" autocomplete="off" class="layui-input" placeholder="标识键"/>\n #@queryEnd()\n #@formEnd()\n \n #@table()\n</div>\n#end\n\n#define js()\n<!-- 分页表格 -->\n<script>\n var object="sys_tree";\n var addViewCode="view_add";\n var updateViewCode="view_update";\n gridArgs.title=\'系统树\';\n gridArgs.dataId=\'id\';\n gridArgs.deleteUrl=\'#(path)/portal/form/business/delete?object=\'+object+\'&primaryKey=\'+gridArgs.dataId;\n gridArgs.updateUrl=\'#(path)/portal/form/business/edit?object=\'+object+\'&primaryKey=\'+gridArgs.dataId+\'&viewCode=\'+updateViewCode+\'&id=\';\n gridArgs.addUrl=\'#(path)/portal/form/business/add?viewCode=\'+addViewCode;\n gridArgs.gridDivId =\'maingrid\';\n initGrid({id : \'maingrid\'\n ,elem : \'#maingrid\'\n ,toolbar:\'#table_toolbar\'//开启头部工具栏，并为其绑定左侧模板\n ,cellMinWidth: 80\n ,cols : [ [\n {title: \'主键\',field : \'id\',width : 35,checkbox : true},\n {title:\'序号\',type:\'numbers\',width:35},\n {title: \'分类\', field: \'type\'},\n {title: \'名称\', field: \'name\' },\n {title: \'排序\', field: \'order_no\'},\n {title: \'操作\',fixed:\'right\',width : 180,align : \'left\',toolbar : \'#bar_maingrid\'} // 这里的toolbar值是模板元素的选择器\n ] ]\n ,url:"#(path)/portal/form/business/list"\n ,where:{"object":object,"primaryKey":gridArgs.dataId}\n ,searchForm : \'searchForm\'\n });\n</script>\n\n#end\n', '2019-04-28 16:09:57', '2021-06-25 14:50:58', '列表页');
/*!40000 ALTER TABLE `form_view` ENABLE KEYS */;
-- 导出 表 jfinal-layui.session 结构
DROP TABLE IF EXISTS `session`;
CREATE TABLE IF NOT EXISTS `session` (
`id` varchar(64) NOT NULL COMMENT '主键',
`user_code` varchar(100) DEFAULT NULL COMMENT '用户编号',
`expiret_time` bigint(20) DEFAULT NULL COMMENT '过期时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='session';
-- 正在导出表 jfinal-layui.session 的数据：~8 rows (大约)
DELETE FROM `session`;
/*!40000 ALTER TABLE `session` DISABLE KEYS */;
INSERT INTO `session` (`id`, `user_code`, `expiret_time`) VALUES
('0802cac0a46c4d188b7e474824856990', 'admin', 1692883185374),
('1411696f398740f49ea8ac24273c0cda', 'admin', 1693227325886),
('1ec31bc6265543e4af275ad467fb4d5f', 'admin', 1722848422405),
('440cc54a4edd4547a6ddd2736ea21368', 'admin', 1693346859043),
('9c18ed7e214b4b68a2d1909111f0c968', 'admin', 1722841530993),
('eb78256eb37944ca9450cd1da994a6a9', 'admin', 1692190840694),
('ff33eaa610004abea5d3e3a4ad26920a', 'admin', 1690201628614),
('ffe5a2a3d5a944e79b770fd2bd420079', 'admin', 1692970058419);
/*!40000 ALTER TABLE `session` ENABLE KEYS */;
-- 导出 表 jfinal-layui.sys_function 结构
DROP TABLE IF EXISTS `sys_function`;
CREATE TABLE IF NOT EXISTS `sys_function` (
`id` varchar(32) NOT NULL COMMENT '主键',
`func_name` varchar(80) DEFAULT NULL COMMENT '功能名称',
`is_stop` int(11) DEFAULT 0 COMMENT '是否启用(0:是,1:否)',
`link_page` text DEFAULT NULL COMMENT '功能url',
`parent_code` varchar(40) DEFAULT NULL COMMENT '上级编号',
`parent_name` varchar(100) DEFAULT NULL COMMENT '上级名称',
`func_type` int(11) DEFAULT 0 COMMENT '功能类型(0:菜单,1:按钮)',
`icon` varchar(100) DEFAULT NULL COMMENT '图标',
`order_no` int(11) DEFAULT NULL COMMENT '排序',
`descript` varchar(255) DEFAULT NULL COMMENT '注释',
`spread` int(11) DEFAULT 1 COMMENT '是否展开菜单(0:展开,1:不展开)',
`is_window_open` int(11) DEFAULT 0 COMMENT '是否在window页打开菜单（0:否,1:是）',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统功能表';
-- 正在导出表 jfinal-layui.sys_function 的数据：~75 rows (大约)
DELETE FROM `sys_function`;
/*!40000 ALTER TABLE `sys_function` DISABLE KEYS */;
INSERT INTO `sys_function` (`id`, `func_name`, `is_stop`, `link_page`, `parent_code`, `parent_name`, `func_type`, `icon`, `order_no`, `descript`, `spread`, `is_window_open`) VALUES
('data_dictionary', '业务字典', 0, '/portal/core/dictionary', 'sys_manager', '系统管理', 0, NULL, 5, NULL, 1, 0),
('data_dictionary_add', '添加', 0, '/portal/core/dictionary/save', 'data_dictionary', '数据字典', 1, NULL, 1, NULL, 1, 0),
('data_dictionary_delete', '删除', 0, '/portal/core/dictionary/delete', 'data_dictionary', '数据字典', 1, NULL, 3, NULL, 1, 0),
('data_dictionary_update', '修改', 0, '/portal/core/dictionary/update', 'data_dictionary', '数据字典', 1, NULL, 2, NULL, 1, 0),
('data_dictionary_value', '字典数据值', 0, NULL, 'data_dictionary', '数据字典', 1, NULL, 4, NULL, 1, 0),
('data_dictionary_value_add', '添加', 0, '/portal/core/dictionary/value/add', 'data_dictionary_value', '字典数据值', 1, NULL, 5, NULL, 1, 0),
('data_dictionary_value_delete', '删除', 0, '/portal/core/dictionary/value/delete', 'data_dictionary_value', '字典数据值', 1, NULL, 7, NULL, 1, 0),
('data_dictionary_value_update', '修改', 0, '/portal/core/dictionary/update', 'data_dictionary_value', '字典数据值', 1, NULL, 6, NULL, 1, 0),
('data_source_add', '添加', 0, '/portal/core/dataSource/save', 'data_source_manager', '数据源管理', 1, NULL, 1, NULL, 1, 0),
('data_source_delete', '删除', 0, '/portal/core/dataSource/delete', 'data_source_manager', '数据源管理', 1, NULL, 3, NULL, 1, 0),
('data_source_manager', '数据源管理', 0, '/portal/core/dataSource', 'sys_manager', '系统管理', 0, NULL, 15, NULL, 1, 0),
('data_source_start', '启动', 0, '/portal/core/dataSource/start', 'data_source_manager', '数据源管理', 1, NULL, 7, NULL, 1, 0),
('data_source_state', '开机启动', 0, '/portal/core/dataSource/updateFieldValue', 'data_source_manager', '数据源管理', 1, NULL, 5, NULL, 1, 0),
('data_source_update', '修改', 0, '/portal/core/dataSource/update', 'data_source_manager', '数据源管理', 1, NULL, 2, NULL, 1, 0),
('form_business_table', '测试表单', 0, '/portal/form/business/view_table', 'sys', '网站后台管理', 0, 'layui-icon-table', 7, NULL, 1, 0),
('form_sql_add', '添加', 0, '/portal/form/sql/save', 'sys_cus_sql', '自定义SQL', 1, NULL, 1, NULL, 1, 0),
('form_sql_delete', '删除', 0, '/portal/form/sql/delete', 'sys_cus_sql', '自定义SQL', 1, NULL, 3, NULL, 1, 0),
('form_sql_update', '修改', 0, '/portal/form/sql/update', 'sys_cus_sql', '自定义SQL', 1, NULL, 2, NULL, 1, 0),
('form_sys_tree', '表单分类树', 0, NULL, 'form_view_manager', '在线表单', 1, NULL, 6, NULL, 1, 0),
('form_sys_tree_add', '添加', 0, '/portal/form/sysTree/save', 'form_sys_tree', '表单分类树', 1, NULL, 7, NULL, 1, 0),
('form_sys_tree_delete', '删除', 0, '/portal/form/sysTree/delete', 'form_sys_tree', '表单分类树', 1, NULL, 9, NULL, 1, 0),
('form_sys_tree_update', '修改', 0, '/portal/form/sysTree/update', 'form_sys_tree', '表单分类树', 1, NULL, 8, NULL, 1, 0),
('form_view_add', '添加', 0, '/portal/form/view/save', 'form_view_manager', '在线表单', 1, NULL, 3, NULL, 1, 0),
('form_view_delete', '删除', 0, '/portal/form/view/delete', 'form_view_manager', '在线表单', 1, NULL, 5, NULL, 1, 0),
('form_view_manager', '在线表单', 0, '/portal/form/view', 'sys', '网站后台管理', 0, 'layui-icon-templeate-1', 6, NULL, 1, 0),
('form_view_update', '修改', 0, '/portal/form/view/update', 'form_view_manager', '在线表单', 1, NULL, 4, NULL, 1, 0),
('frame_main_view', '主页', 0, '/portal/go/home', 'frame', 'JFinal极速开发企业应用管理系统', 0, 'layui-icon-home', 0, NULL, 1, 0),
('generator_manager', '代码生成器', 0, NULL, 'sys', '网站后台管理', 0, 'layui-icon-fonts-code', 2, NULL, 1, 0),
('generator_single', '单表生成器', 0, '/portal/generator/code', 'generator_manager', '代码生成器', 0, NULL, 10, NULL, 1, 0),
('generator_subtable', '主从表生成器', 0, '/portal/generator/code/2', 'generator_manager', '代码生成器', 0, NULL, 20, NULL, 1, 0),
('generator_subtable_demo', '主从模板示例', 0, '/portal/core/sysOrg/2', 'generator_manager', '代码生成器', 0, NULL, 30, NULL, 1, 0),
('main_sys', '后台管理', 0, NULL, 'frame', 'JFinal极速开发企业应用管理系统', 0, 'layui-icon-align-center', 2, NULL, 1, 0),
('pub_fileList', '附件列表', 0, '/portal/getFileList', 'sys', '网站后台管理', 0, 'layui-icon-read', 5, NULL, 1, 0),
('query_user', '用户管理', 0, '/portal/form/business/query_user', 'main_sys', '后台管理', 0, NULL, 1, NULL, 1, 0),
('select_more_demo', '联级多选', 0, '/portal/go/common/demo/select', 'sys', '网站后台管理', 0, 'layui-icon-down', 60, NULL, 1, 0),
('sql_sys_tree', 'sql分类树', 0, NULL, 'sys_cus_sql', '自定义SQL', 1, NULL, 4, NULL, 1, 0),
('sql_sys_tree_add', '添加', 0, '/portal/form/sysTree/save', 'sql_sys_tree', 'sql分类树', 1, NULL, 5, NULL, 1, 0),
('sql_sys_tree_delete', '删除', 0, '/portal/form/sysTree/delete', 'sql_sys_tree', 'sql分类树', 1, NULL, 7, NULL, 1, 0),
('sql_sys_tree_update', '修改', 0, '/portal/form/sysTree/update', 'sql_sys_tree', 'sql分类树', 1, NULL, 6, NULL, 1, 0),
('sys', '网站后台管理', 0, NULL, 'frame', 'JFinal极速开发企业应用管理系统', 0, 'layui-icon-spread-left', 1, NULL, 1, 0),
('sys_cus_sql', '自定义SQL', 0, '/portal/form/sql', 'sys_manager', '系统管理', 0, NULL, 6, NULL, 1, 0),
('sys_druid', '性能监控', 0, '/assets/druid', 'sys', '网站后台管理', 0, 'layui-icon-engine', 3, NULL, 1, 0),
('sys_echart', 'Echart图表', 0, '/portal/echart', 'sys', '网站后台管理', 0, 'layui-icon-chart', 2, NULL, 1, 0),
('sys_func_add', '添加', 0, '/portal/core/sysFunc/save', 'sys_func_manager', '功能管理', 1, 'layui-icon-wu', 1, NULL, 1, 0),
('sys_func_delete', '删除', 0, '/portal/core/sysFunc/delete', 'sys_func_manager', '功能管理', 1, NULL, 3, NULL, 1, 0),
('sys_func_manager', '功能管理', 0, '/portal/core/sysFunc', 'sys_manager', '系统管理', 0, 'layui-icon-read', 1, NULL, 1, 0),
('sys_func_update', '修改', 0, '/portal/core/sysFunc/update', 'sys_func_manager', '功能管理', 1, NULL, 2, NULL, 1, 0),
('sys_log', '系统日志', 0, '/portal/core/sysLog', 'sys_manager', '系统管理', 0, NULL, 6, NULL, 1, 0),
('sys_manager', '系统管理', 0, NULL, 'sys', '网站后台管理', 0, 'layui-icon-set', 1, NULL, 1, 0),
('sys_org_add', '添加', 0, '/portal/core/sysOrg/add', 'sys_org_manager', '部门管理', 1, NULL, 1, NULL, 1, 0),
('sys_org_delete', '删除', 0, '/portal/core/sysOrg/delete', 'sys_org_manager', '部门管理', 1, NULL, 3, NULL, 1, 0),
('sys_org_manager', '部门管理', 0, '/portal/core/sysOrg', 'sys_manager', '系统管理', 0, 'layui-icon-wu', 4, NULL, 1, 0),
('sys_org_update', '修改 ', 0, '/portal/core/sysOrg/update', 'sys_org_manager', '部门管理', 1, NULL, 2, NULL, 1, 0),
('sys_pub_upload', '上传页面', 0, '/portal/toUpload', 'sys', '网站后台管理', 0, 'layui-icon-upload-drag', 4, NULL, 1, 0),
('sys_role_add', '添加', 0, '/portal/core/sysRole/save', 'sys_role_manager', '角色管理', 1, NULL, 1, NULL, 1, 0),
('sys_role_delete', '删除', 0, '/portal/core/sysRole/delete', 'sys_role_manager', '角色管理', 1, NULL, 3, NULL, 1, 0),
('sys_role_manager', '角色管理', 0, '/portal/core/sysRole', 'sys_manager', '系统管理', 0, 'layui-icon-wu', 2, NULL, 1, 0),
('sys_role_save_function', '权限分配按钮', 0, '/portal/core/sysRole/saveRoleFunction', 'sys_role_manager', '角色管理', 1, NULL, 4, NULL, 1, 0),
('sys_role_update', '修改', 0, '/portal/core/sysRole/update', 'sys_role_manager', '角色管理', 1, NULL, 2, NULL, 1, 0),
('sys_user_add', '添加', 0, '/portal/core/sysUser/save', 'sys_user_manager', '用户管理', 1, NULL, 1, NULL, 1, 0),
('sys_user_delete', '删除', 0, '/portal/core/sysUser/delete', 'sys_user_manager', '用户管理', 1, NULL, 3, NULL, 1, 0),
('sys_user_manager', '用户管理', 0, '/portal/core/sysUser', 'sys_manager', '系统管理', 0, 'layui-icon-wu', 3, NULL, 1, 0),
('sys_user_reset', '重置密码', 0, '/portal/core/sysUser/reset', 'sys_user_manager', '用户管理', 1, NULL, 5, NULL, 1, 0),
('sys_user_role', '角色', 0, '/portal/core/sysUser/userRole', 'sys_user_manager', '用户管理', 1, NULL, 6, NULL, 1, 0),
('sys_user_update', '修改', 0, '/portal/core/sysUser/update', 'sys_user_manager', '用户管理', 1, NULL, 2, NULL, 1, 0),
('table_edit', '可编辑表格', 0, '/portal/go/common/demo/layuiTableEdit', 'sys', '网站后台管理', 0, 'layui-icon-table', 50, NULL, 1, 0),
('ureport_course', '报表教程', 0, 'https://www.w3cschool.cn/ureport/ureport-dysp2ha7.html', 'ureport_manager', '报表管理', 0, NULL, 4, NULL, 1, 0),
('ureport_designer', '报表设计', 0, '/ureport/designer', 'ureport_manager', '报表管理', 0, NULL, 3, NULL, 1, 0),
('ureport_manager', '报表管理', 0, '/ureport/designer', 'sys', '网站后台管理', 0, 'layui-icon-app', 2, NULL, 1, 0),
('ureport_preview', '报表预览', 0, NULL, 'ureport_manager', '报表管理', 0, NULL, 5, NULL, 1, 0),
('ureport_preview_sys_log', '日志报表', 0, '/ureport/preview?_u=file:sysLog.ureport.xml', 'ureport_preview', '报表预览', 0, NULL, 4, NULL, 1, 0),
('ureport_preview_user', '用户报表', 0, '/ureport/preview?_u=file:user.ureport.xml', 'ureport_preview', '报表预览', 0, NULL, 5, NULL, 1, 0),
('veFarmer', '农户管理', 0, '/portal/business/veFarmer', 'generator_manager', '代码生成器', 0, 'layui-icon-username', 1, NULL, 1, 0),
('veFarmer2', '农户管理2', 0, '/portal/business/veFarmer', 'main_sys', '后台管理', 0, 'layui-icon-user', 1, NULL, 1, 0),
('video', '视频教程', 0, 'https://www.qinhaisenlin.com/video', 'frame', 'JFinal极速开发企业应用管理系统', 0, 'layui-icon-video', 10, NULL, 1, 1),
('xm_select_demo', 'xm-select组件示例', 0, '/portal/go/common/demo/xm-select-demo', 'sys', '网站后台管理', 0, 'layui-icon-slider', 70, NULL, 1, 0),
('xm_select_tree', 'xm-select-tree示例', 0, '/portal/go/common/demo/xm-select-tree', 'sys', '网站后台管理', 0, 'layui-icon-tree', 80, NULL, 1, 0);
/*!40000 ALTER TABLE `sys_function` ENABLE KEYS */;
-- 导出 表 jfinal-layui.sys_log 结构
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE IF NOT EXISTS `sys_log` (
`id` varchar(32) NOT NULL,
`url` varchar(255) DEFAULT NULL,
`method_name` varchar(255) DEFAULT NULL,
`data` text DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`user_code` varchar(255) DEFAULT NULL,
`remark` varchar(500) DEFAULT NULL,
`ip` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统日志';
-- 正在导出表 jfinal-layui.sys_log 的数据：~191 rows (大约)
DELETE FROM `sys_log`;
/*!40000 ALTER TABLE `sys_log` DISABLE KEYS */;
INSERT INTO `sys_log` (`id`, `url`, `method_name`, `data`, `create_time`, `user_code`, `remark`, `ip`) VALUES
('40288ae768132a540168132f5aa50003', '/pub/login/submit', '登录', '{password=[6e5ee632b5020f7ec3b7f1007a8ab4a09f1c6a64410ffbdffc0198d7cd1e025220ffac783ac7884e20124fbc3d48fcb76d17be558605cf9fe4bddf6f7558927d0b3a63f330fd476836459ee0ce921456c97d95cb3789b2490fa1e4779f647180fd237a0085cb75a66aaf79378b31226562f2998b239b1608112cf1aca2c49424],verifyCode=[],returnUrl=[/],userCode=[admin]}', '2019-01-03 18:08:17', 'admin(管理员)', '登录日志', '192.168.10.103'),
('40288ae768132a540168132f649b0005', '/portal/core/sysLog', '系统日志', '{}', '2019-01-03 18:08:20', 'admin(管理员)', '操作日志(系统管理)', '192.168.10.103'),
('40288ae768132a5401681332f6360008', '/portal/getFileList', '附件列表', '{}', '2019-01-03 18:12:13', 'admin(管理员)', '操作日志(网站后台管理)', '192.168.10.103'),
('40288ae768132a540168133305ca0009', '/portal/delete', '删除', '{}', '2019-01-03 18:12:17', 'admin(管理员)', '数据日志', '192.168.10.103'),
('40288ae768132a5401681333080d000a', '/portal/getFileList', '附件列表', '{}', '2019-01-03 18:12:18', 'admin(管理员)', '操作日志(网站后台管理)', '192.168.10.103'),
('40288ae768132a5401681333bd70000b', '/portal/core/sysUser', '用户管理', '{}', '2019-01-03 18:13:04', 'admin(管理员)', '操作日志(系统管理)', '192.168.10.103'),
('4028e3818980a443018980a49f550005', '/pub/login/submit', '登录', '{}', '2023-07-23 10:46:59', 'admin(管理员)', '登录日志', '192.168.99.1'),
('4028e381898549940189854ba4250003', '/pub/login/submit', '登录', '{}', '2023-07-24 08:27:54', 'admin(管理员)', '登录日志', '192.168.99.1'),
('4028e381898549940189854bd6a10009', '/portal/core/sysFunc', '功能管理', '{}', '2023-07-24 08:28:07', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e381898549940189854f8328000e', '/portal/core/sysFunc', '功能管理', '{}', '2023-07-24 08:32:07', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e381898549940189854fd6410015', '/portal/core/sysFunc', '功能管理', '{}', '2023-07-24 08:32:29', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e381898549940189856bfed8003e', '/portal/core/dictionary', '业务字典', '{}', '2023-07-24 09:03:14', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e38189854994018985998590004b', '/portal/core/dictionary', '业务字典', '{}', '2023-07-24 09:52:58', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e3818985499401898599c9be0050', '/portal/core/dictionary/value/add', '添加', '{"code":["logType"]}', '2023-07-24 09:53:15', 'admin(管理员)', '操作日志(字典数据值)', '192.168.99.1'),
('4028e381898549940189859adb9c0052', '/portal/form/sql', '自定义SQL', '{}', '2023-07-24 09:54:25', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e38189854994018986f2073f0064', '/portal/core/sysLog', '系统日志', '{}', '2023-07-24 16:09:15', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e3818985499401898705eedf006c', '/portal/core/sysUser', '用户管理', '{}', '2023-07-24 16:31:00', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e3818985499401898707f36f006f', '/portal/core/sysOrg', '部门管理', '{}', '2023-07-24 16:33:12', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e38189854994018987081ded0073', '/portal/core/dictionary', '业务字典', '{}', '2023-07-24 16:33:23', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e381898549940189870827650075', '/portal/form/sql', '自定义SQL', '{}', '2023-07-24 16:33:25', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e38189854994018987084a480078', '/portal/core/dataSource', '数据源管理', '{}', '2023-07-24 16:33:34', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e38189854994018987086138007a', '/portal/generator/code', '单表生成器', '{}', '2023-07-24 16:33:40', 'admin(管理员)', '操作日志(代码生成器)', '192.168.99.1'),
('4028e38189854994018987087dc8007b', '/portal/generator/code', '单表生成器', '{}', '2023-07-24 16:33:47', 'admin(管理员)', '操作日志(代码生成器)', '192.168.99.1'),
('4028e38189854994018987088ae7007c', '/portal/core/sysOrg', '部门管理', '{}', '2023-07-24 16:33:51', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e3818985499401898708c67b0081', '/portal/getFileList', '附件列表', '{}', '2023-07-24 16:34:06', 'admin(管理员)', '操作日志(网站后台管理)', '192.168.99.1'),
('4028e3818985499401898708d17c0082', '/portal/form/view', '在线表单', '{}', '2023-07-24 16:34:09', 'admin(管理员)', '操作日志(网站后台管理)', '192.168.99.1'),
('4028e381898549940189870f8d4f0092', '/portal/core/sysOrg', '部门管理', '{}', '2023-07-24 16:41:30', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e381898549940189872597b600ae', '/portal/core/sysRole', '角色管理', '{}', '2023-07-24 17:05:35', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e3818985499401898725af1000bd', '/portal/core/sysFunc', '功能管理', '{}', '2023-07-24 17:05:41', 'admin(管理员)', '操作日志(系统管理)', '192.168.99.1'),
('4028e38189dd4cb30189dd4cfd0a0005', '/pub/login/submit', '登录', '{}', '2023-08-10 10:35:57', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e38189dd4cb30189dd4e31d10010', '/portal/generator/code', '单表生成器', '{}', '2023-08-10 10:37:16', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189dd4cb30189dd518a74001a', '/portal/generator/code', '单表生成器', '{}', '2023-08-10 10:40:55', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189dd4cb30189dd528ed60023', '/portal/core/sysOrg', '部门管理', '{}', '2023-08-10 10:42:02', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd540f30002b', '/portal/core/dataSource', '数据源管理', '{}', '2023-08-10 10:43:40', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd550e660030', '/portal/core/dataSource/save', '添加', '{"dataSource.title":["业务数据库"],"dataSource.jdbcUrl":["jdbc:mysql://localhost/cd_app?characterEncoding=UTF-8&useSSL=false&allowMultiQueries=true"],"dataSource.configName":["Main"],"dataSource.password":["123"],"dataSource.id":[""],"dataSource.user":["root"],"dataSource.dbType":["mysql"],"_jfinal_token":["6312047440578349937"]}', '2023-08-10 10:44:46', 'admin(管理员)', '操作日志(数据源管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd5596280036', '/portal/generator/code', '单表生成器', '{}', '2023-08-10 10:45:21', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189dd4cb30189dd566eb0003f', '/pub/login/submit', '登录', '{}', '2023-08-10 10:46:16', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e38189dd4cb30189dd56870a0045', '/portal/generator/code', '单表生成器', '{}', '2023-08-10 10:46:22', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189dd4cb30189dd56a9d70048', '/portal/core/dataSource', '数据源管理', '{}', '2023-08-10 10:46:31', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd56cb34004a', '/portal/core/dataSource/start', '启动', '{"start":["1"],"id":["4028e38189dd4cb30189dd550e59002f"]}', '2023-08-10 10:46:40', 'admin(管理员)', '操作日志(数据源管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd572f03004e', '/portal/generator/code', '单表生成器', '{}', '2023-08-10 10:47:05', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189dd4cb30189dd63952f0062', '/portal/core/sysOrg', '部门管理', '{}', '2023-08-10 11:00:38', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd667a700076', '/portal/generator/code', '单表生成器', '{}', '2023-08-10 11:03:48', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189dd4cb30189dd79959700a4', '/portal/generator/code', '单表生成器', '{}', '2023-08-10 11:24:40', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189dd4cb30189dd7c694d00ae', '/portal/toUpload', '上传页面', '{}', '2023-08-10 11:27:45', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd7ca15a00af', '/portal/getFileList', '附件列表', '{}', '2023-08-10 11:27:59', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd7cb19500b0', '/portal/form/view', '在线表单', '{}', '2023-08-10 11:28:03', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e38189dd4cb30189dd86880e00b7', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-10 11:38:48', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de52bac20002', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-10 15:21:51', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de53a4160009', '/portal/core/sysOrg', '部门管理', '{}', '2023-08-10 15:22:50', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de54d81f000f', '/portal/core/sysFunc/save', '添加', '{"sysFunction.spread":["1"],"sysFunction.funcName":["农户管理"],"sysFunction.id":["veFarmer"],"sysFunction.funcType":["0"],"sysFunction.linkPage":["/portal/business/veFarmer"],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["5739139868799929900"],"sysFunction.parentCode":["generator_manager"],"sysFunction.icon":["layui-icon-username"],"sysFunction.isStop":["0"]}', '2023-08-10 15:24:09', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e38189de52960189de550f890013', '/portal/core/sysRole', '角色管理', '{}', '2023-08-10 15:24:23', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de5547d80019', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin"],"funcs":["frame,frame_main_view,sys,sys_manager,sys_func_manager,sys_func_add,sys_func_update,sys_func_delete,sys_role_manager,sys_role_add,sys_role_update,sys_role_delete,sys_role_save_function,sys_user_manager,sys_user_add,sys_user_update,sys_user_delete,sys_user_reset,sys_user_role,sys_org_manager,sys_org_add,sys_org_update,sys_org_delete,data_dictionary,data_dictionary_add,data_dictionary_update,data_dictionary_delete,data_dictionary_value,data_dictionary_value_add,data_dictionary_value_update,data_dictionary_value_delete,sys_cus_sql,form_sql_add,form_sql_update,form_sql_delete,sql_sys_tree,sql_sys_tree_add,sql_sys_tree_update,sql_sys_tree_delete,sys_log,data_source_manager,data_source_add,data_source_update,data_source_delete,data_source_state,data_source_start,sys_echart,generator_manager,veFarmer,generator_single,generator_subtable,generator_subtable_demo,ureport_manager,ureport_designer,ureport_course,ureport_preview,ureport_preview_sys_log,ureport_preview_user,sys_pub_upload,pub_fileList,form_view_manager,form_view_add,form_view_update,form_view_delete,form_sys_tree,form_sys_tree_add,form_sys_tree_update,form_sys_tree_delete,form_business_table,table_edit,select_more_demo,xm_select_demo,xm_select_tree,video"]}', '2023-08-10 15:24:38', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e38189de52960189de556402001b', '/portal/business/veFarmer', '农户管理', '{}', '2023-08-10 15:24:45', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189de52960189de572648002d', '/portal/core/sysRole', '角色管理', '{}', '2023-08-10 15:26:40', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de5b160a0036', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-10 15:30:58', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de5bcce9003c', '/portal/core/sysFunc/update', '修改', '{"sysFunction.spread":["1"],"sysFunction.funcName":["网站后台管理"],"sysFunction.id":["sys"],"sysFunction.funcType":["0"],"sysFunction.linkPage":[""],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["1918756022338921449"],"sysFunction.parentCode":["frame"],"sysFunction.icon":["layui-icon-spread-left"],"sysFunction.isStop":["0"]}', '2023-08-10 15:31:45', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e38189de52960189de5c073c0040', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-10 15:32:00', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de5d9bef004a', '/portal/core/sysFunc/updateFieldValue', '修改', '{"sysFunction.id":["video"],"sysFunction.is_window_open":["1"]}', '2023-08-10 15:33:44', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189de52960189de5ef08c0055', '/portal/core/sysUser', '用户管理', '{}', '2023-08-10 15:35:11', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de62e5d80058', '/portal/core/sysOrg', '部门管理', '{}', '2023-08-10 15:39:30', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de633c86006a', '/portal/core/dictionary', '业务字典', '{}', '2023-08-10 15:39:52', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de636b94006d', '/portal/form/sql', '自定义SQL', '{}', '2023-08-10 15:40:04', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de64ac430077', '/portal/core/sysLog', '系统日志', '{}', '2023-08-10 15:41:26', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de64cb80007a', '/portal/core/dataSource', '数据源管理', '{}', '2023-08-10 15:41:34', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189de52960189de64e05d007c', '/portal/echart', 'Echart图表', '{}', '2023-08-10 15:41:40', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e38189de52960189de6df290007f', '/portal/generator/code', '单表生成器', '{}', '2023-08-10 15:51:34', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189de52960189de6e03920080', '/portal/business/veFarmer', '农户管理', '{}', '2023-08-10 15:51:39', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189de52960189defbaf8300a1', '/portal/core/sysLog', '系统日志', '{}', '2023-08-10 18:26:23', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e229364d0006', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 09:14:59', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e229a2aa0009', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 09:15:26', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e33b5b41000f', '/portal/core/sysRole', '角色管理', '{}', '2023-08-11 14:14:25', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e34ccca00024', '/portal/business/veFarmer', '农户管理', '{}', '2023-08-11 14:33:28', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189e223700189e34cfa2c0029', '/portal/business/veFarmer/update', '修改', '{"veFarmer.devicetoken":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.town":[""],"veFarmer.loginData":["2022-04-02 13:26:04.0"],"veFarmer.phone":["18706682033"],"veFarmer.numCode5":[""],"veFarmer.numCode4":[""],"veFarmer.numCode3":[""],"veFarmer.name":["pgx"],"veFarmer.token":["4BD21BCC024030465A6B9A7629205E7A"],"veFarmer.numCode2":[""],"veFarmer.numCode1":[""],"veFarmer.province":["0"],"veFarmer.namePinyin":["sb"],"veFarmer.village":[""],"veFarmer.addSource":["0"],"_jfinal_token":["-5015971376811164016"],"veFarmer.region":["0"],"veFarmer.id":["11"],"veFarmer.city":["0"],"veFarmer.numCode":["11"],"veFarmer.addtime":["2019-05-11 14:32:13.0"],"veFarmer.openid":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.address":[""],"veFarmer.pinCodes":[""],"veFarmer.state":["0"],"veFarmer.password":["7698946764209BE8D1AE96CF1D7DF463"],"veFarmer.imge":["18706682033_1786.jpg"],"veFarmer.loginErrorNum":["0"],"veFarmer.cardStates":["1"]}', '2023-08-11 14:33:40', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189e223700189e34fc1d80033', '/portal/core/sysFunc/updateFieldValue', '修改', '{"sysFunction.id":["frame_main_view"],"sysFunction.spread":["0"]}', '2023-08-11 14:36:42', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189e223700189e34fc4f10034', '/portal/core/sysFunc/updateFieldValue', '修改', '{"sysFunction.id":["frame_main_view"],"sysFunction.spread":["1"]}', '2023-08-11 14:36:43', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189e223700189e359152c003b', '/portal/core/sysFunc/updateFieldValue', '修改', '{"sysFunction.id":["sys_manager"],"sysFunction.spread":["0"]}', '2023-08-11 14:46:53', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189e223700189e3592dbf003c', '/portal/core/sysFunc/updateFieldValue', '修改', '{"sysFunction.id":["sys_manager"],"sysFunction.spread":["1"]}', '2023-08-11 14:46:59', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189e223700189e3594c82003d', '/portal/core/sysFunc/updateFieldValue', '修改', '{"sysFunction.id":["sys_manager"],"sysFunction.spread":["0"]}', '2023-08-11 14:47:07', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189e223700189e35963c1003f', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 14:47:13', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e35970190043', '/portal/core/sysFunc/updateFieldValue', '修改', '{"sysFunction.id":["sys_manager"],"sysFunction.spread":["1"]}', '2023-08-11 14:47:16', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189e223700189e35980eb0045', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 14:47:21', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e35b93e20057', '/portal/core/sysFunc/save', '添加', '{"sysFunction.spread":["1"],"sysFunction.funcName":["后台管理"],"sysFunction.id":["main_sys"],"sysFunction.funcType":["0"],"sysFunction.linkPage":[""],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["-1752081272746651"],"sysFunction.parentCode":["frame"],"sysFunction.icon":["layui-icon-align-center"],"sysFunction.isStop":["0"]}', '2023-08-11 14:49:36', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e38189e223700189e35bbd62005b', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 14:49:47', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e35d0c6b0065', '/pub/login/submit', '登录', '{}', '2023-08-11 14:51:13', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e38189e223700189e35d323c006b', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 14:51:23', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e35dbe140077', '/portal/core/sysFunc/update', '修改', '{"sysFunction.spread":["1"],"sysFunction.funcName":["后台管理"],"sysFunction.id":["main_sys"],"sysFunction.funcType":["0"],"sysFunction.linkPage":[""],"sysFunction.orderNo":["2"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["1831390927917936236"],"sysFunction.parentCode":["frame"],"sysFunction.icon":["layui-icon-align-center"],"sysFunction.isStop":["0"]}', '2023-08-11 14:51:58', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e38189e223700189e35dd8ae007b', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 14:52:05', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e35f07b1008a', '/portal/core/sysFunc/save', '添加', '{"sysFunction.spread":["1"],"sysFunction.funcName":["农户管理2"],"sysFunction.id":["veFarmer2"],"sysFunction.funcType":["0"],"sysFunction.linkPage":["/portal/business/veFarmer"],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["8221547418135150090"],"sysFunction.parentCode":["main_sys"],"sysFunction.icon":["layui-icon-user"],"sysFunction.isStop":["0"]}', '2023-08-11 14:53:23', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e38189e223700189e35f4025008e', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 14:53:37', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e223700189e3604af90095', '/portal/core/sysFunc/update', '修改', '{"sysFunction.spread":["1"],"sysFunction.funcName":["功能管理"],"sysFunction.id":["sys_func_manager"],"sysFunction.funcType":["0"],"sysFunction.linkPage":["/portal/core/sysFunc"],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["-1579412010835044385"],"sysFunction.parentCode":["sys_manager"],"sysFunction.icon":["layui-icon-form"],"sysFunction.isStop":["0"]}', '2023-08-11 14:54:46', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e38189e223700189e36067760099', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-11 14:54:53', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e369470189e36a22930005', '/pub/login/submit', '登录', '{}', '2023-08-11 15:05:31', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e38189e369470189e36a33ca000b', '/portal/core/sysRole', '角色管理', '{}', '2023-08-11 15:05:35', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e38189e369470189e36a516d0011', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin"],"funcs":["frame,frame_main_view,sys,sys_manager,sys_func_manager,sys_func_add,sys_func_update,sys_func_delete,sys_role_manager,sys_role_add,sys_role_update,sys_role_delete,sys_role_save_function,sys_user_manager,sys_user_add,sys_user_update,sys_user_delete,sys_user_reset,sys_user_role,sys_org_manager,sys_org_add,sys_org_update,sys_org_delete,data_dictionary,data_dictionary_add,data_dictionary_update,data_dictionary_delete,data_dictionary_value,data_dictionary_value_add,data_dictionary_value_update,data_dictionary_value_delete,sys_cus_sql,form_sql_add,form_sql_update,form_sql_delete,sql_sys_tree,sql_sys_tree_add,sql_sys_tree_update,sql_sys_tree_delete,sys_log,data_source_manager,data_source_add,data_source_update,data_source_delete,data_source_state,data_source_start,sys_echart,generator_manager,veFarmer,generator_single,generator_subtable,generator_subtable_demo,ureport_manager,ureport_designer,ureport_course,ureport_preview,ureport_preview_sys_log,ureport_preview_user,sys_pub_upload,pub_fileList,form_view_manager,form_view_add,form_view_update,form_view_delete,form_sys_tree,form_sys_tree_add,form_sys_tree_update,form_sys_tree_delete,form_business_table,table_edit,select_more_demo,xm_select_demo,xm_select_tree,main_sys,veFarmer2,video"]}', '2023-08-11 15:05:43', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e38189e369470189e36adff50013', '/portal/form/view', '在线表单', '{}', '2023-08-11 15:06:19', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e38189e369470189e36b142f0016', '/portal/form/view', '在线表单', '{}', '2023-08-11 15:06:32', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e38189e369470189e36b631c001b', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin"],"funcs":["frame,frame_main_view,sys,sys_manager,sys_func_manager,sys_func_add,sys_func_update,sys_func_delete,sys_role_manager,sys_role_add,sys_role_update,sys_role_delete,sys_role_save_function,sys_user_manager,sys_user_add,sys_user_update,sys_user_delete,sys_user_reset,sys_user_role,sys_org_manager,sys_org_add,sys_org_update,sys_org_delete,data_dictionary,data_dictionary_add,data_dictionary_update,data_dictionary_delete,data_dictionary_value,data_dictionary_value_add,data_dictionary_value_update,data_dictionary_value_delete,sys_cus_sql,form_sql_add,form_sql_update,form_sql_delete,sql_sys_tree,sql_sys_tree_add,sql_sys_tree_update,sql_sys_tree_delete,sys_log,data_source_manager,data_source_add,data_source_update,data_source_delete,data_source_state,data_source_start,sys_echart,generator_manager,veFarmer,generator_single,generator_subtable,generator_subtable_demo,sys_druid,sys_pub_upload,pub_fileList,form_view_manager,form_view_add,form_view_update,form_view_delete,form_sys_tree,form_sys_tree_add,form_sys_tree_update,form_sys_tree_delete,form_business_table,table_edit,select_more_demo,xm_select_demo,xm_select_tree,main_sys,veFarmer2,video"]}', '2023-08-11 15:06:53', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e38189e369470189e36b7a2c001e', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-11 15:06:58', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e38189e369470189e3cc499e0023', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-11 16:52:43', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e38189e369470189e3d194800027', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-11 16:58:30', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e38189e369470189e3d34a15002f', '/pub/login/submit', '登录', '{}', '2023-08-11 17:00:22', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e38189e369470189e3d353da0031', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-11 17:00:24', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e38189e369470189e3d46cf90036', '/portal/business/veFarmer/update', '修改', '{"veFarmer.devicetoken":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.town":[""],"veFarmer.loginData":["2022-04-02 13:26:04.0"],"veFarmer.phone":["18706682033"],"veFarmer.numCode5":[""],"veFarmer.numCode4":[""],"veFarmer.numCode3":[""],"veFarmer.name":["pgx"],"veFarmer.token":["4BD21BCC024030465A6B9A7629205E7A"],"veFarmer.numCode2":[""],"veFarmer.numCode1":[""],"veFarmer.province":["0"],"veFarmer.namePinyin":["pgx"],"veFarmer.village":[""],"veFarmer.addSource":["0"],"_jfinal_token":["3911502821762508964"],"veFarmer.region":["0"],"veFarmer.id":["11"],"veFarmer.city":["0"],"veFarmer.numCode":["11"],"veFarmer.addtime":["2019-05-11 14:32:13.0"],"veFarmer.openid":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.address":[""],"veFarmer.pinCodes":[""],"veFarmer.state":["0"],"veFarmer.password":["7698946764209BE8D1AE96CF1D7DF463"],"veFarmer.imge":["18706682033_1786.jpg"],"veFarmer.loginErrorNum":["0"],"veFarmer.cardStates":["1"]}', '2023-08-11 17:01:36', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e38189e369470189e4119c03003c', '/portal/generator/code', '单表生成器', '{}', '2023-08-11 18:08:26', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e38189fbdbcc0189fbdbe9a20003', '/pub/login/submit', '登录', '{}', '2023-08-16 09:00:40', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a252005018a252041120005', '/pub/login/submit', '登录', '{}', '2023-08-24 09:19:45', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a252005018a2520685f000b', '/portal/form/sql', '自定义SQL', '{}', '2023-08-24 09:19:55', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a252093840010', '/portal/form/sql/update', '修改', '{"config_name":[""],"code":["query_org"],"tree_id":["4028830c6b5fcc89016b5fd976fc005a"],"name":["部门下拉sql"],"id":["4028832c6cf20578016cf209c0300013"],"content":["select id value,org_name name from sys_org"],"_jfinal_token":["-579810166484936806"],"descp":[""]}', '2023-08-24 09:20:06', 'admin(管理员)', '操作日志(自定义SQL)', '127.0.0.1'),
('4028e3818a252005018a25228e490012', '/portal/core/sysRole', '角色管理', '{}', '2023-08-24 09:22:16', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a252297e20015', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-24 09:22:18', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a2522abc30018', '/portal/core/dataSource', '数据源管理', '{}', '2023-08-24 09:22:23', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a2523248d001b', '/portal/core/sysLog', '系统日志', '{}', '2023-08-24 09:22:54', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a256975040020', '/portal/core/sysOrg', '部门管理', '{}', '2023-08-24 10:39:42', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a256985d70022', '/portal/core/sysOrg', '部门管理', '{}', '2023-08-24 10:39:47', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a2705e07d0039', '/portal/core/sysUser', '用户管理', '{}', '2023-08-24 18:10:11', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a2705e85b003c', '/portal/core/sysOrg', '部门管理', '{}', '2023-08-24 18:10:13', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a2705f0a6003e', '/portal/core/dictionary', '业务字典', '{}', '2023-08-24 18:10:15', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a252005018a2709a9c90053', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-24 18:14:19', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e3818a252005018a2709af380055', '/portal/generator/code', '单表生成器', '{}', '2023-08-24 18:14:20', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a2a09e2018a2a09f9870003', '/pub/login/submit', '登录', '{}', '2023-08-25 08:13:31', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a2a09e2018a2a0a03c70005', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-25 08:13:34', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a2a09e2018a2a0a0c400008', '/portal/form/sql', '自定义SQL', '{}', '2023-08-25 08:13:36', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a2a09e2018a2a0a1138000b', '/portal/core/sysLog', '系统日志', '{}', '2023-08-25 08:13:37', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a2a09e2018a2a0c8f6a000f', '/portal/echart', 'Echart图表', '{}', '2023-08-25 08:16:20', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a2a09e2018a2a0e2d000011', '/portal/echart', 'Echart图表', '{}', '2023-08-25 08:18:06', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a2a09e2018a2a11ce8c0013', '/portal/echart', 'Echart图表', '{}', '2023-08-25 08:22:04', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a2a09e2018a2a13f7840017', '/portal/generator/code', '单表生成器', '{}', '2023-08-25 08:24:26', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a2a09e2018a2a4a7dab001b', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-25 09:23:59', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e3818a2a09e2018a2a4ba73d0021', '/pub/login/submit', '登录', '{}', '2023-08-25 09:25:15', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a2a09e2018a2a4dd4c20029', '/pub/login/submit', '登录', '{}', '2023-08-25 09:27:38', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a2a09e2018a2b595738002f', '/portal/core/sysLog', '系统日志', '{}', '2023-08-25 14:19:49', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a2a09e2018a2b5f974f0035', '/portal/core/sysRole', '角色管理', '{}', '2023-08-25 14:26:39', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a39a353018a39a36be90003', '/pub/login/submit', '登录', '{}', '2023-08-28 08:55:25', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a39a353018a39a3dacd0009', '/portal/generator/code', '单表生成器', '{}', '2023-08-28 08:55:54', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a3ad74e018a3ad7785f0002', '/portal/generator/code', '单表生成器', '{}', '2023-08-28 14:31:54', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a3ad74e018a3b0dc74d0012', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-28 15:31:13', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e3818a3ad74e018a3b0e6e360014', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-28 15:31:56', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e3818a3ad74e018a3b11e6510016', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-28 15:35:43', 'admin(管理员)', '操作日志(后台管理)', '127.0.0.1'),
('4028e3818a3ad74e018a3b13d53c0019', '/portal/business/veFarmer/update', '修改', '{"veFarmer.devicetoken":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.town":[""],"veFarmer.loginData":["2022-04-02 13:26:04.0"],"veFarmer.phone":["18706682033"],"veFarmer.numCode5":[""],"veFarmer.numCode4":[""],"veFarmer.numCode3":[""],"veFarmer.name":["pgx"],"veFarmer.token":["4BD21BCC024030465A6B9A7629205E7A"],"veFarmer.numCode2":[""],"veFarmer.numCode1":[""],"veFarmer.province":["0"],"veFarmer.namePinyin":["pgx"],"veFarmer.village":[""],"veFarmer.addSource":["0"],"_jfinal_token":["8613274169569994423"],"veFarmer.region":["0"],"veFarmer.id":["11"],"veFarmer.city":["0"],"veFarmer.numCode":["11"],"veFarmer.addtime":["2019-05-11 14:32:13.0"],"veFarmer.openid":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.address":[""],"veFarmer.pinCodes":[""],"veFarmer.state":["0"],"veFarmer.password":["7698946764209BE8D1AE96CF1D7DF463"],"veFarmer.imge":["18706682033_1786.jpg"],"veFarmer.loginErrorNum":["0"],"veFarmer.cardStates":["1"]}', '2023-08-28 15:37:50', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e3818a3ad74e018a3b140e09001c', '/portal/business/veFarmer/update', '修改', '{"veFarmer.devicetoken":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.town":[""],"veFarmer.loginData":["2022-04-02 13:26:04.0"],"veFarmer.phone":["18706682033"],"veFarmer.numCode5":[""],"veFarmer.numCode4":[""],"veFarmer.numCode3":[""],"veFarmer.name":["pgx"],"veFarmer.token":["4BD21BCC024030465A6B9A7629205E7A"],"veFarmer.numCode2":[""],"veFarmer.numCode1":[""],"veFarmer.province":["0"],"veFarmer.namePinyin":["pgx"],"veFarmer.village":[""],"veFarmer.addSource":["0"],"_jfinal_token":["1886336265680986339"],"veFarmer.region":["0"],"veFarmer.id":["11"],"veFarmer.city":["0"],"veFarmer.numCode":["11"],"veFarmer.addtime":["2019-05-11 14:32:13.0"],"veFarmer.openid":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.address":[""],"veFarmer.pinCodes":[""],"veFarmer.state":["0"],"veFarmer.password":["7698946764209BE8D1AE96CF1D7DF463"],"veFarmer.imge":["18706682033_1786.jpg"],"veFarmer.loginErrorNum":["0"],"veFarmer.cardStates":["1"]}', '2023-08-28 15:38:04', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e3818a3ad74e018a3b14a443001f', '/portal/business/veFarmer/update', '修改', '{"veFarmer.devicetoken":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.town":[""],"veFarmer.loginData":["2022-04-02 13:26:04.0"],"veFarmer.phone":["18706682033"],"veFarmer.numCode5":[""],"veFarmer.numCode4":[""],"veFarmer.numCode3":[""],"veFarmer.name":["pgx"],"veFarmer.token":["4BD21BCC024030465A6B9A7629205E7A"],"veFarmer.numCode2":[""],"veFarmer.numCode1":[""],"veFarmer.province":["0"],"veFarmer.namePinyin":["pgx"],"veFarmer.village":[""],"veFarmer.addSource":["0"],"_jfinal_token":["-7877085787194580525"],"veFarmer.region":["0"],"veFarmer.id":["11"],"veFarmer.city":["0"],"veFarmer.numCode":["11"],"veFarmer.addtime":["2019-05-11 14:32:13.0"],"veFarmer.openid":["oerVO5YMGIa1kW-hlyp-hRQyqG8I"],"veFarmer.address":[""],"veFarmer.pinCodes":[""],"veFarmer.state":["0"],"veFarmer.password":["7698946764209BE8D1AE96CF1D7DF463"],"veFarmer.imge":["18706682033_1786.jpg"],"veFarmer.loginErrorNum":["0"],"veFarmer.cardStates":["1"]}', '2023-08-28 15:38:43', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e3818a3ad74e018a3b21b9ac0025', '/portal/generator/code', '单表生成器', '{}', '2023-08-28 15:53:00', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a3ad74e018a3b256fd5002f', '/portal/core/dataSource', '数据源管理', '{}', '2023-08-28 15:57:03', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f37622a0003', '/pub/login/submit', '登录', '{}', '2023-08-29 10:55:08', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a3f374a018a3f3794ad0009', '/portal/core/dictionary', '业务字典', '{}', '2023-08-29 10:55:21', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f39f8ec000f', '/portal/core/dictionary/value/add', '添加', '{"code":["logType"]}', '2023-08-29 10:57:58', 'admin(管理员)', '操作日志(字典数据值)', '127.0.0.1'),
('4028e3818a3f374a018a3f3a95580015', '/portal/core/dictionary/save', '添加', '{"dataDictionary.name":["xx测试"],"dataDictionary.id":[""],"dataDictionary.code":["xx"],"dataDictionary.orderNum":["1"],"dataDictionary.remark":[""],"_jfinal_token":["1287119146389434359"]}', '2023-08-29 10:58:38', 'admin(管理员)', '操作日志(数据字典)', '127.0.0.1'),
('4028e3818a3f374a018a3f3bf061001b', '/portal/core/dictionary/value/add', '添加', '{"code":["xx"]}', '2023-08-29 11:00:07', 'admin(管理员)', '操作日志(字典数据值)', '127.0.0.1'),
('4028e3818a3f374a018a3f3c1956001d', '/portal/core/dictionary/value/save', '添加', '{"dataDictionaryValue.dictionaryCode":["xx"],"dataDictionaryValue.name":["123"],"dataDictionaryValue.remark":["字典编号：xx"],"dataDictionaryValue.id":[""],"dataDictionaryValue.value":["1"],"_jfinal_token":["-8718048851852479149"],"dataDictionaryValue.orderNum":["1"]}', '2023-08-29 11:00:17', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e3818a3f374a018a3f3c2231001f', '/portal/core/dictionary/value/add', '添加', '{"code":["xx"]}', '2023-08-29 11:00:20', 'admin(管理员)', '操作日志(字典数据值)', '127.0.0.1'),
('4028e3818a3f374a018a3f3c39410021', '/portal/core/dictionary/value/save', '添加', '{"dataDictionaryValue.dictionaryCode":["xx"],"dataDictionaryValue.name":["222"],"dataDictionaryValue.remark":["字典编号：xx"],"dataDictionaryValue.id":[""],"dataDictionaryValue.value":["2"],"_jfinal_token":["-1710057200131452511"],"dataDictionaryValue.orderNum":["1"]}', '2023-08-29 11:00:26', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e3818a3f374a018a3f3dd2cc0029', '/portal/core/dictionary/value/delete', '删除', '{"ids[0]":["4028e3818a3f374a018a3f3c1948001c"]}', '2023-08-29 11:02:10', 'admin(管理员)', '操作日志(字典数据值)', '127.0.0.1'),
('4028e3818a3f374a018a3f3de4db002c', '/portal/core/dictionary/delete', '删除', '{"ids[0]":["xx"]}', '2023-08-29 11:02:15', 'admin(管理员)', '操作日志(数据字典)', '127.0.0.1'),
('4028e3818a3f374a018a3f40915e0038', '/portal/core/dictionary/save', '添加', '{"dataDictionary.name":["1"],"dataDictionary.id":[""],"dataDictionary.code":["1"],"dataDictionary.orderNum":["1"],"dataDictionary.remark":[""],"_jfinal_token":["-1157787206601297516"]}', '2023-08-29 11:05:10', 'admin(管理员)', '操作日志(数据字典)', '127.0.0.1'),
('4028e3818a3f374a018a3f410a79003c', '/portal/core/dictionary/delete', '删除', '{"ids[0]":["1"]}', '2023-08-29 11:05:41', 'admin(管理员)', '操作日志(数据字典)', '127.0.0.1'),
('4028e3818a3f374a018a3f528fb5003e', '/portal/core/sysUser', '用户管理', '{}', '2023-08-29 11:24:49', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f52b8b10044', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 11:25:00', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f52dd7a004a', '/portal/core/sysLog', '系统日志', '{}', '2023-08-29 11:25:09', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f52e0d0004d', '/portal/core/dataSource', '数据源管理', '{}', '2023-08-29 11:25:10', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f534bd9004f', '/portal/core/sysUser/userRole', '角色', '{"userName":["管理员"],"userCode":["admin"]}', '2023-08-29 11:25:38', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f5371bc0052', '/portal/core/sysUser/userRole', '角色', '{"userName":["管理员"],"userCode":["admin"]}', '2023-08-29 11:25:47', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f546261005a', '/portal/core/sysUser/userRole', '角色', '{"userName":["超级管理员"],"userCode":["superadmin"]}', '2023-08-29 11:26:49', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f5556f60063', '/portal/core/sysUser/userRole', '角色', '{"userName":["超级管理员"],"userCode":["superadmin"]}', '2023-08-29 11:27:52', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f55648f0066', '/portal/core/sysUser/userRole', '角色', '{"userName":["管理员"],"userCode":["admin"]}', '2023-08-29 11:27:55', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f5574410069', '/portal/core/sysUser/userRole', '角色', '{"userName":["超级管理员"],"userCode":["superadmin"]}', '2023-08-29 11:27:59', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f5a7b1f0078', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 11:33:28', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f5ad4d3007e', '/portal/core/sysFunc/update', '修改', '{"sysFunction.spread":["1"],"sysFunction.funcName":["原系统管理"],"sysFunction.id":["sys_manager"],"sysFunction.funcType":["0"],"sysFunction.linkPage":[""],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["5930119419151569533"],"sysFunction.parentCode":["sys"],"sysFunction.icon":["layui-icon-set"],"sysFunction.isStop":["0"]}', '2023-08-29 11:33:51', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f5af09d0082', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 11:33:59', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a3f5b1d860088', '/portal/core/sysFunc/update', '修改', '{"sysFunction.spread":["1"],"sysFunction.funcName":["系统管理"],"sysFunction.id":["sys_manager"],"sysFunction.funcType":["0"],"sysFunction.linkPage":[""],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["-5514287118630840388"],"sysFunction.parentCode":["sys"],"sysFunction.icon":["layui-icon-set"],"sysFunction.isStop":["0"]}', '2023-08-29 11:34:10', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e3818a3f374a018a4049dae8008f', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 15:54:56', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a4049e1e50092', '/portal/core/sysUser', '用户管理', '{}', '2023-08-29 15:54:58', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a404e6a50009b', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 15:59:55', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a404e717b009e', '/portal/core/sysUser', '用户管理', '{}', '2023-08-29 15:59:57', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a404ff54b00a8', '/portal/toUpload', '上传页面', '{}', '2023-08-29 16:01:36', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a3f374a018a404ffda500a9', '/portal/getFileList', '附件列表', '{}', '2023-08-29 16:01:38', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a3f374a018a405002be00aa', '/portal/form/view', '在线表单', '{}', '2023-08-29 16:01:40', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a3f374a018a4051239300bc', '/portal/form/sql', '自定义SQL', '{}', '2023-08-29 16:02:53', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a4051cfb400ca', '/portal/form/view/update', '修改', '{在线表单数据不存储}', '2023-08-29 16:03:38', 'admin(管理员)', '操作日志(在线表单)', '127.0.0.1'),
('4028e3818a3f374a018a40522bba00d3', '/portal/form/sql', '自定义SQL', '{}', '2023-08-29 16:04:01', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a405bc1bc00f0', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 16:14:29', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a3f374a018a406c6a6c0139', '/pub/login/submit', '登录', '{}', '2023-08-29 16:32:41', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a3f374a018a406c7c74013f', '/portal/form/view', '在线表单', '{}', '2023-08-29 16:32:46', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a406d1d018a406d22a30002', '/portal/form/view', '在线表单', '{}', '2023-08-29 16:33:28', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a406d1d018a406de6150009', '/portal/generator/code', '单表生成器', '{}', '2023-08-29 16:34:18', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a40760d018a40762ca40002', '/portal/form/sql', '自定义SQL', '{}', '2023-08-29 16:43:21', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a40760d018a4076370a0005', '/portal/generator/code', '单表生成器', '{}', '2023-08-29 16:43:23', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a40760d018a40768fcb000c', '/pub/login/submit', '登录', '{}', '2023-08-29 16:43:46', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a40760d018a4076a2330012', '/portal/generator/code', '单表生成器', '{}', '2023-08-29 16:43:51', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a407a74018a407a8d110004', '/pub/login/submit', '登录', '{}', '2023-08-29 16:48:07', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a407a74018a407a9cc4000a', '/portal/generator/code', '单表生成器', '{}', '2023-08-29 16:48:11', 'admin(管理员)', '操作日志(代码生成器)', '127.0.0.1'),
('4028e3818a407a74018a40a48ff0001c', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 17:34:01', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40ada3f9003e', '/portal/form/view', '在线表单', '{}', '2023-08-29 17:43:56', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a407a74018a40aec36f0046', '/portal/core/sysFunc/save', '添加', '{"sysFunction.spread":["1"],"sysFunction.funcName":["用户管理"],"sysFunction.id":["query_user"],"sysFunction.funcType":["0"],"sysFunction.linkPage":["/portal/form/business/query_user"],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["-206997732653697688"],"sysFunction.parentCode":["main_sys"],"sysFunction.icon":[""],"sysFunction.isStop":["0"]}', '2023-08-29 17:45:09', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e3818a407a74018a40aeff58004e', '/pub/login/submit', '登录', '{}', '2023-08-29 17:45:25', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a407a74018a40af23460055', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 17:45:34', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40af36c50058', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 17:45:39', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40af7056005e', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin"],"funcs":["frame,frame_main_view,sys,sys_manager,sys_func_manager,sys_func_add,sys_func_update,sys_func_delete,sys_role_manager,sys_role_add,sys_role_update,sys_role_delete,sys_role_save_function,sys_user_manager,sys_user_add,sys_user_update,sys_user_delete,sys_user_reset,sys_user_role,sys_org_manager,sys_org_add,sys_org_update,sys_org_delete,data_dictionary,data_dictionary_add,data_dictionary_update,data_dictionary_delete,data_dictionary_value,data_dictionary_value_add,data_dictionary_value_update,data_dictionary_value_delete,sys_cus_sql,form_sql_add,form_sql_update,form_sql_delete,sql_sys_tree,sql_sys_tree_add,sql_sys_tree_update,sql_sys_tree_delete,sys_log,data_source_manager,data_source_add,data_source_update,data_source_delete,data_source_state,data_source_start,sys_echart,generator_manager,veFarmer,generator_single,generator_subtable,generator_subtable_demo,sys_druid,sys_pub_upload,pub_fileList,form_view_manager,form_view_add,form_view_update,form_view_delete,form_sys_tree,form_sys_tree_add,form_sys_tree_update,form_sys_tree_delete,form_business_table,table_edit,select_more_demo,xm_select_demo,xm_select_tree,main_sys,query_user,veFarmer2,video"]}', '2023-08-29 17:45:54', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e3818a407a74018a40b04aa20067', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 17:46:49', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b11776006d', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin"],"funcs":["frame,frame_main_view,sys,sys_manager,sys_func_manager,sys_func_add,sys_func_update,sys_role_manager,sys_role_add,sys_role_update,sys_role_delete,sys_role_save_function,sys_user_manager,sys_user_add,sys_user_update,sys_user_delete,sys_user_reset,sys_user_role,sys_org_manager,sys_org_add,sys_org_update,sys_org_delete,data_dictionary,data_dictionary_add,data_dictionary_update,data_dictionary_delete,data_dictionary_value,data_dictionary_value_add,data_dictionary_value_update,data_dictionary_value_delete,sys_cus_sql,form_sql_add,form_sql_update,form_sql_delete,sql_sys_tree,sql_sys_tree_add,sql_sys_tree_update,sql_sys_tree_delete,sys_log,data_source_manager,data_source_add,data_source_update,data_source_delete,data_source_state,data_source_start,sys_echart,generator_manager,veFarmer,generator_single,generator_subtable,generator_subtable_demo,sys_druid,sys_pub_upload,pub_fileList,form_view_manager,form_view_add,form_view_update,form_view_delete,form_sys_tree,form_sys_tree_add,form_sys_tree_update,form_sys_tree_delete,form_business_table,table_edit,select_more_demo,xm_select_demo,xm_select_tree,main_sys,query_user,veFarmer2,video"]}', '2023-08-29 17:47:42', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e3818a407a74018a40b1320c006e', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin"],"funcs":["frame,frame_main_view,sys,sys_manager,sys_func_manager,sys_func_add,sys_func_delete,sys_role_manager,sys_role_add,sys_role_update,sys_role_delete,sys_role_save_function,sys_user_manager,sys_user_add,sys_user_update,sys_user_delete,sys_user_reset,sys_user_role,sys_org_manager,sys_org_add,sys_org_update,sys_org_delete,data_dictionary,data_dictionary_add,data_dictionary_update,data_dictionary_delete,data_dictionary_value,data_dictionary_value_add,data_dictionary_value_update,data_dictionary_value_delete,sys_cus_sql,form_sql_add,form_sql_update,form_sql_delete,sql_sys_tree,sql_sys_tree_add,sql_sys_tree_update,sql_sys_tree_delete,sys_log,data_source_manager,data_source_add,data_source_update,data_source_delete,data_source_state,data_source_start,sys_echart,generator_manager,veFarmer,generator_single,generator_subtable,generator_subtable_demo,sys_druid,sys_pub_upload,pub_fileList,form_view_manager,form_view_add,form_view_update,form_view_delete,form_sys_tree,form_sys_tree_add,form_sys_tree_update,form_sys_tree_delete,form_business_table,table_edit,select_more_demo,xm_select_demo,xm_select_tree,main_sys,query_user,veFarmer2,video"]}', '2023-08-29 17:47:49', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e3818a407a74018a40b14b0c0070', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 17:47:55', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b1793a0079', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 17:48:07', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b1a369007f', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin"],"funcs":["frame,frame_main_view,sys,sys_manager,sys_func_manager,sys_func_update,sys_func_delete,sys_role_manager,sys_role_add,sys_role_update,sys_role_delete,sys_role_save_function,sys_user_manager,sys_user_add,sys_user_update,sys_user_delete,sys_user_reset,sys_user_role,sys_org_manager,sys_org_add,sys_org_update,sys_org_delete,data_dictionary,data_dictionary_add,data_dictionary_update,data_dictionary_delete,data_dictionary_value,data_dictionary_value_add,data_dictionary_value_update,data_dictionary_value_delete,sys_cus_sql,form_sql_add,form_sql_update,form_sql_delete,sql_sys_tree,sql_sys_tree_add,sql_sys_tree_update,sql_sys_tree_delete,sys_log,data_source_manager,data_source_add,data_source_update,data_source_delete,data_source_state,data_source_start,sys_echart,generator_manager,veFarmer,generator_single,generator_subtable,generator_subtable_demo,sys_druid,sys_pub_upload,pub_fileList,form_view_manager,form_view_add,form_view_update,form_view_delete,form_sys_tree,form_sys_tree_add,form_sys_tree_update,form_sys_tree_delete,form_business_table,table_edit,select_more_demo,xm_select_demo,xm_select_tree,main_sys,query_user,veFarmer2,video"]}', '2023-08-29 17:48:18', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e3818a407a74018a40b1b3930081', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 17:48:22', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b1e2df008a', '/pub/login/submit', '登录', '{}', '2023-08-29 17:48:34', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a407a74018a40b1f1580090', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 17:48:38', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b227340096', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 17:48:51', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b2e38800a0', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 17:49:40', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b3038c00a6', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 17:49:48', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b32e7a00af', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin"],"funcs":["frame,frame_main_view,sys,sys_manager,sys_func_manager,sys_func_add,sys_func_update,sys_func_delete,sys_role_manager,sys_role_add,sys_role_update,sys_role_delete,sys_role_save_function,sys_user_manager,sys_user_add,sys_user_update,sys_user_delete,sys_user_reset,sys_user_role,sys_org_manager,sys_org_add,sys_org_update,sys_org_delete,data_dictionary,data_dictionary_add,data_dictionary_update,data_dictionary_delete,data_dictionary_value,data_dictionary_value_add,data_dictionary_value_update,data_dictionary_value_delete,sys_cus_sql,form_sql_add,form_sql_update,form_sql_delete,sql_sys_tree,sql_sys_tree_add,sql_sys_tree_update,sql_sys_tree_delete,sys_log,data_source_manager,data_source_add,data_source_update,data_source_delete,data_source_state,data_source_start,sys_echart,generator_manager,veFarmer,generator_single,generator_subtable,generator_subtable_demo,sys_druid,sys_pub_upload,pub_fileList,form_view_manager,form_view_add,form_view_update,form_view_delete,form_sys_tree,form_sys_tree_add,form_sys_tree_update,form_sys_tree_delete,form_business_table,table_edit,select_more_demo,xm_select_demo,xm_select_tree,main_sys,query_user,veFarmer2,video"]}', '2023-08-29 17:49:59', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e3818a407a74018a40b34cb100b0', '/portal/core/sysUser', '用户管理', '{}', '2023-08-29 17:50:07', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b4250700b6', '/portal/core/sysOrg', '部门管理', '{}', '2023-08-29 17:51:02', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40b83cf800c7', '/portal/core/sysUser/userRole', '角色', '{"userName":["管理员"],"userCode":["admin"]}', '2023-08-29 17:55:30', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a407a74018a40b8b96700cc', '/portal/core/sysUser/save', '添加', '{"sysUser.id":[""],"sysUser.mobile":[""],"sysUser.allowLogin":["0"],"sysUser.sex":["1"],"sysUser.address":[""],"sysUser.email":[""],"sysUser.userName":["测试"],"sysUser.passwd":["123456"],"sysUser.userCode":["15811111111"],"sysUser.tel":[""],"sysUser.orgId":["40288ae767ee75f70167ee7bae0a0001"],"_jfinal_token":["2994288354343866502"]}', '2023-08-29 17:56:02', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a407a74018a40b8c84f00cf', '/portal/core/sysUser/userRole', '角色', '{"userName":["测试"],"userCode":["15811111111"]}', '2023-08-29 17:56:06', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a407a74018a40b8deda00d2', '/portal/core/sysUser/saveUserRole', '添加', '{"userCode":["15811111111"],"role":["admin3"]}', '2023-08-29 17:56:12', 'admin(管理员)', '数据日志', '127.0.0.1'),
('4028e3818a407a74018a40b9160800d3', '/portal/core/sysUser/userRole', '角色', '{"userName":["测试"],"userCode":["15811111111"]}', '2023-08-29 17:56:26', 'admin(管理员)', '操作日志(用户管理)', '127.0.0.1'),
('4028e3818a407a74018a40b94e4f00d9', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin3"],"funcs":["frame,sys,sys_manager,sys_func_manager,sys_func_delete"]}', '2023-08-29 17:56:40', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e3818a407a74018a40b9620700dd', '/pub/login/submit', '登录', '{}', '2023-08-29 17:56:45', '15811111111(测试)', '登录日志', '127.0.0.1'),
('4028e3818a407a74018a40b96ac200df', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 17:56:47', '15811111111(测试)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40ba0e9800e2', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 17:57:29', '15811111111(测试)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40bc354700e8', '/pub/login/submit', '登录', '{}', '2023-08-29 17:59:50', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a407a74018a40bc4ff400ee', '/portal/form/view', '在线表单', '{}', '2023-08-29 17:59:57', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a407a74018a40bcbd6a00f6', '/portal/form/view', '在线表单', '{}', '2023-08-29 18:00:25', 'admin(管理员)', '操作日志(网站后台管理)', '127.0.0.1'),
('4028e3818a407a74018a40bdb44d00fd', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 18:01:28', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40bdd3570103', '/portal/core/sysRole/saveRoleFunction', '权限分配按钮', '{"roleCode":["admin3"],"funcs":["frame,sys,sys_manager,sys_func_manager,sys_func_delete,main_sys,query_user,veFarmer2"]}', '2023-08-29 18:01:36', 'admin(管理员)', '操作日志(角色管理)', '127.0.0.1'),
('4028e3818a407a74018a40bde8090107', '/pub/login/submit', '登录', '{}', '2023-08-29 18:01:42', '15811111111(测试)', '登录日志', '127.0.0.1'),
('4028e3818a407a74018a40bdf231010a', '/portal/business/veFarmer', '农户管理2', '{}', '2023-08-29 18:01:44', '15811111111(测试)', '操作日志(后台管理)', '127.0.0.1'),
('4028e3818a407a74018a40c30129011b', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 18:07:16', '15811111111(测试)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40c35a2e0124', '/pub/login/submit', '登录', '{}', '2023-08-29 18:07:39', 'admin(管理员)', '登录日志', '127.0.0.1'),
('4028e3818a407a74018a40c36cc7012a', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 18:07:43', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40c791b90136', '/portal/core/sysRole', '角色管理', '{}', '2023-08-29 18:12:15', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1'),
('4028e3818a407a74018a40c82ad8013c', '/portal/core/sysFunc/update', '修改', '{"sysFunction.spread":["1"],"sysFunction.funcName":["添加"],"sysFunction.id":["sys_func_add"],"sysFunction.funcType":["1"],"sysFunction.linkPage":["/portal/core/sysFunc/save"],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["-6471169280172050167"],"sysFunction.parentCode":["sys_func_manager"],"sysFunction.icon":["layui-icon-read"],"sysFunction.isStop":["0"]}', '2023-08-29 18:12:54', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e3818a407a74018a40c85c620142', '/portal/core/sysFunc/update', '修改', '{"sysFunction.spread":["1"],"sysFunction.funcName":["添加"],"sysFunction.id":["sys_func_add"],"sysFunction.funcType":["1"],"sysFunction.linkPage":["/portal/core/sysFunc/save"],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["5644768280098871407"],"sysFunction.parentCode":["sys_func_manager"],"sysFunction.icon":["layui-icon-wu"],"sysFunction.isStop":["0"]}', '2023-08-29 18:13:07', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e3818a407a74018a40c88cdf0149', '/portal/core/sysFunc/update', '修改', '{"sysFunction.spread":["1"],"sysFunction.funcName":["功能管理"],"sysFunction.id":["sys_func_manager"],"sysFunction.funcType":["0"],"sysFunction.linkPage":["/portal/core/sysFunc"],"sysFunction.orderNo":["1"],"sysFunction.isWindowOpen":["0"],"_jfinal_token":["-1187605184189732883"],"sysFunction.parentCode":["sys_manager"],"sysFunction.icon":["layui-icon-read"],"sysFunction.isStop":["0"]}', '2023-08-29 18:13:19', 'admin(管理员)', '操作日志(功能管理)', '127.0.0.1'),
('4028e3818a407a74018a40cc7fd4014d', '/portal/core/sysFunc', '功能管理', '{}', '2023-08-29 18:17:38', 'admin(管理员)', '操作日志(系统管理)', '127.0.0.1');
/*!40000 ALTER TABLE `sys_log` ENABLE KEYS */;
-- 导出 表 jfinal-layui.sys_org 结构
DROP TABLE IF EXISTS `sys_org`;
CREATE TABLE IF NOT EXISTS `sys_org` (
`id` varchar(32) NOT NULL COMMENT '主键',
`org_code` varchar(50) DEFAULT NULL COMMENT '部门编号和主键默认',
`parentid` varchar(40) DEFAULT NULL COMMENT '上级部门编号',
`parentid_name` varchar(50) DEFAULT NULL COMMENT '上级部门名称',
`org_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
`chief` varchar(30) DEFAULT NULL COMMENT '部门负责人姓名',
`phone` varchar(20) DEFAULT NULL COMMENT '部门负责人电话',
`mobile` varchar(20) DEFAULT NULL COMMENT '部门负责人手机号',
`email` varchar(40) DEFAULT NULL COMMENT '部门负责人邮件',
`descript` text DEFAULT NULL COMMENT '描述',
`lev` int(11) DEFAULT NULL COMMENT '级别',
`isstop` int(11) DEFAULT NULL COMMENT '是否停用\r\n1：停用；\r\n0：启用；',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门表';
-- 正在导出表 jfinal-layui.sys_org 的数据：~7 rows (大约)
DELETE FROM `sys_org`;
/*!40000 ALTER TABLE `sys_org` DISABLE KEYS */;
INSERT INTO `sys_org` (`id`, `org_code`, `parentid`, `parentid_name`, `org_name`, `chief`, `phone`, `mobile`, `email`, `descript`, `lev`, `isstop`) VALUES
('40288ae767ee75f70167ee7bae0a0001', '40288ae767ee75f70167ee7bae0a0001', 'ff808081616e1efd01616e2c89af0000', '绘宇智能', '人事部', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('40288ae767ee75f70167ee7c06ba0002', '40288ae767ee75f70167ee7c06ba0002', 'ff808081616e1efd01616e2c89af0000', '绘宇智能', '财务部', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('40288ae767ee75f70167ee7c94220003', '40288ae767ee75f70167ee7c94220003', 'ff80808161e4629f0161e49ac1d30001', '系统集成部', '研发部', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('40288ae767ee75f70167ee7cb5120004', '40288ae767ee75f70167ee7cb5120004', 'ff80808161e4629f0161e49ac1d30001', '系统集成部', '项目部', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('ff808081616e1efd01616e2c89af0000', 'ff808081616e1efd01616e2c89af0000', 'sys', '组织机构', '绘宇智能', '一木森', NULL, NULL, NULL, NULL, NULL, 1),
('ff80808161e4629f0161e49ac1d30001', 'ff80808161e4629f0161e49ac1d30001', 'ff808081616e1efd01616e2c89af0000', '绘宇智能', '系统集成部', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('sys', 'sys', '', '', '组织机构', '系统管理员', NULL, NULL, NULL, NULL, NULL, 1);
/*!40000 ALTER TABLE `sys_org` ENABLE KEYS */;
-- 导出 表 jfinal-layui.sys_role 结构
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE IF NOT EXISTS `sys_role` (
`id` varchar(32) NOT NULL,
`descript` varchar(200) DEFAULT NULL,
`is_stop` int(11) DEFAULT NULL,
`orgid` varchar(100) DEFAULT NULL,
`parent_id` varchar(100) DEFAULT NULL,
`role_code` varchar(100) DEFAULT NULL,
`role_name` varchar(100) DEFAULT NULL,
`user_code` varchar(100) DEFAULT NULL,
`visit_view` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色表';
-- 正在导出表 jfinal-layui.sys_role 的数据：~12 rows (大约)
DELETE FROM `sys_role`;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` (`id`, `descript`, `is_stop`, `orgid`, `parent_id`, `role_code`, `role_name`, `user_code`, `visit_view`) VALUES
('40288ae7677c6ab801677c6c30ac0001', NULL, 1, NULL, 'superadmin', 'admin', '管理员', NULL, NULL),
('40288ae767ab41450167ab8d9a1f0001', NULL, 1, NULL, 'admin', 'zjl', '总经理', NULL, NULL),
('40288ae767afdfee0167afe17c9c0001', NULL, 1, NULL, 'superadmin', 'xzb', '行政部', 'superadmin', NULL),
('40288ae767afdfee0167afe1c8c00002', NULL, 1, NULL, 'superadmin', 'jsb', '技术部', 'superadmin', NULL),
('40288ae767afdfee0167afe225390003', NULL, 1, NULL, 'jsb', 'yf', '研发部', 'superadmin', NULL),
('40288ae767afdfee0167afe269e80004', NULL, 1, NULL, 'jsb', 'xmb', '项目部', 'superadmin', NULL),
('40288ae767afdfee0167afe2e1410005', NULL, 1, NULL, 'yf', 'pt', '平台研发', 'superadmin', NULL),
('40288ae767afdfee0167afe33a480006', NULL, 1, NULL, 'yf', 'gis', 'gis研发', 'superadmin', NULL),
('40288ae767ed898c0167ed8c1e110001', NULL, 1, NULL, 'admin', 'admin3', '人事部', 'admin', NULL),
('40288ae767ee75f70167ee7fe5720005', NULL, 1, NULL, 'admin', 'xtjcb', '系统集成部', 'admin', NULL),
('40288ae767eeb06b0167eeb185410001', NULL, 1, NULL, 'xtjcb', 'yfb', '研发部', 'admin', NULL),
('ff80808161f5012f0161f53666ef0000', '管理系统所有角色', 1, 'ff808081616e1efd01616e2c89af0000', 'sys', 'superadmin', '超级管理员', 'admin', NULL);
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
-- 导出 表 jfinal-layui.sys_role_function 结构
DROP TABLE IF EXISTS `sys_role_function`;
CREATE TABLE IF NOT EXISTS `sys_role_function` (
`id` varchar(200) NOT NULL,
`function_id` varchar(100) DEFAULT NULL,
`role_code` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色功能关系表';
-- 正在导出表 jfinal-layui.sys_role_function 的数据：~344 rows (大约)
DELETE FROM `sys_role_function`;
/*!40000 ALTER TABLE `sys_role_function` DISABLE KEYS */;
INSERT INTO `sys_role_function` (`id`, `function_id`, `role_code`) VALUES
('admin-data_dictionary', 'data_dictionary', 'admin'),
('admin-data_dictionary_add', 'data_dictionary_add', 'admin'),
('admin-data_dictionary_delete', 'data_dictionary_delete', 'admin'),
('admin-data_dictionary_update', 'data_dictionary_update', 'admin'),
('admin-data_dictionary_value', 'data_dictionary_value', 'admin'),
('admin-data_dictionary_value_add', 'data_dictionary_value_add', 'admin'),
('admin-data_dictionary_value_delete', 'data_dictionary_value_delete', 'admin'),
('admin-data_dictionary_value_update', 'data_dictionary_value_update', 'admin'),
('admin-data_source_add', 'data_source_add', 'admin'),
('admin-data_source_delete', 'data_source_delete', 'admin'),
('admin-data_source_manager', 'data_source_manager', 'admin'),
('admin-data_source_start', 'data_source_start', 'admin'),
('admin-data_source_state', 'data_source_state', 'admin'),
('admin-data_source_update', 'data_source_update', 'admin'),
('admin-form_business_table', 'form_business_table', 'admin'),
('admin-form_sql_add', 'form_sql_add', 'admin'),
('admin-form_sql_delete', 'form_sql_delete', 'admin'),
('admin-form_sql_update', 'form_sql_update', 'admin'),
('admin-form_sys_tree', 'form_sys_tree', 'admin'),
('admin-form_sys_tree_add', 'form_sys_tree_add', 'admin'),
('admin-form_sys_tree_delete', 'form_sys_tree_delete', 'admin'),
('admin-form_sys_tree_update', 'form_sys_tree_update', 'admin'),
('admin-form_view_add', 'form_view_add', 'admin'),
('admin-form_view_delete', 'form_view_delete', 'admin'),
('admin-form_view_manager', 'form_view_manager', 'admin'),
('admin-form_view_update', 'form_view_update', 'admin'),
('admin-frame', 'frame', 'admin'),
('admin-frame_main_view', 'frame_main_view', 'admin'),
('admin-generator_manager', 'generator_manager', 'admin'),
('admin-generator_single', 'generator_single', 'admin'),
('admin-generator_subtable', 'generator_subtable', 'admin'),
('admin-generator_subtable_demo', 'generator_subtable_demo', 'admin'),
('admin-main_sys', 'main_sys', 'admin'),
('admin-pub_fileList', 'pub_fileList', 'admin'),
('admin-query_user', 'query_user', 'admin'),
('admin-select_more_demo', 'select_more_demo', 'admin'),
('admin-sql_sys_tree', 'sql_sys_tree', 'admin'),
('admin-sql_sys_tree_add', 'sql_sys_tree_add', 'admin'),
('admin-sql_sys_tree_delete', 'sql_sys_tree_delete', 'admin'),
('admin-sql_sys_tree_update', 'sql_sys_tree_update', 'admin'),
('admin-sys', 'sys', 'admin'),
('admin-sys_cus_sql', 'sys_cus_sql', 'admin'),
('admin-sys_druid', 'sys_druid', 'admin'),
('admin-sys_echart', 'sys_echart', 'admin'),
('admin-sys_func_add', 'sys_func_add', 'admin'),
('admin-sys_func_delete', 'sys_func_delete', 'admin'),
('admin-sys_func_manager', 'sys_func_manager', 'admin'),
('admin-sys_func_update', 'sys_func_update', 'admin'),
('admin-sys_log', 'sys_log', 'admin'),
('admin-sys_manager', 'sys_manager', 'admin'),
('admin-sys_org_add', 'sys_org_add', 'admin'),
('admin-sys_org_delete', 'sys_org_delete', 'admin'),
('admin-sys_org_manager', 'sys_org_manager', 'admin'),
('admin-sys_org_update', 'sys_org_update', 'admin'),
('admin-sys_pub_upload', 'sys_pub_upload', 'admin'),
('admin-sys_role_add', 'sys_role_add', 'admin'),
('admin-sys_role_delete', 'sys_role_delete', 'admin'),
('admin-sys_role_manager', 'sys_role_manager', 'admin'),
('admin-sys_role_save_function', 'sys_role_save_function', 'admin'),
('admin-sys_role_update', 'sys_role_update', 'admin'),
('admin-sys_user_add', 'sys_user_add', 'admin'),
('admin-sys_user_delete', 'sys_user_delete', 'admin'),
('admin-sys_user_manager', 'sys_user_manager', 'admin'),
('admin-sys_user_reset', 'sys_user_reset', 'admin'),
('admin-sys_user_role', 'sys_user_role', 'admin'),
('admin-sys_user_update', 'sys_user_update', 'admin'),
('admin-table_edit', 'table_edit', 'admin'),
('admin-veFarmer', 'veFarmer', 'admin'),
('admin-veFarmer2', 'veFarmer2', 'admin'),
('admin-video', 'video', 'admin'),
('admin-xm_select_demo', 'xm_select_demo', 'admin'),
('admin-xm_select_tree', 'xm_select_tree', 'admin'),
('admin3-frame', 'frame', 'admin3'),
('admin3-main_sys', 'main_sys', 'admin3'),
('admin3-query_user', 'query_user', 'admin3'),
('admin3-sys', 'sys', 'admin3'),
('admin3-sys_func_delete', 'sys_func_delete', 'admin3'),
('admin3-sys_func_manager', 'sys_func_manager', 'admin3'),
('admin3-sys_manager', 'sys_manager', 'admin3'),
('admin3-veFarmer2', 'veFarmer2', 'admin3'),
('jsb_frame', 'frame', 'jsb'),
('jsb_frame_main_view', 'frame_main_view', 'jsb'),
('jsb_sys', 'sys', 'jsb'),
('jsb_sys_druid', 'sys_druid', 'jsb'),
('jsb_sys_echart', 'sys_echart', 'jsb'),
('jsb_sys_func_add', 'sys_func_add', 'jsb'),
('jsb_sys_func_delete', 'sys_func_delete', 'jsb'),
('jsb_sys_func_manager', 'sys_func_manager', 'jsb'),
('jsb_sys_func_update', 'sys_func_update', 'jsb'),
('jsb_sys_manager', 'sys_manager', 'jsb'),
('jsb_sys_org_add', 'sys_org_add', 'jsb'),
('jsb_sys_org_delete', 'sys_org_delete', 'jsb'),
('jsb_sys_org_manager', 'sys_org_manager', 'jsb'),
('jsb_sys_org_update', 'sys_org_update', 'jsb'),
('jsb_sys_role_add', 'sys_role_add', 'jsb'),
('jsb_sys_role_delete', 'sys_role_delete', 'jsb'),
('jsb_sys_role_manager', 'sys_role_manager', 'jsb'),
('jsb_sys_role_update', 'sys_role_update', 'jsb'),
('jsb_sys_user_add', 'sys_user_add', 'jsb'),
('jsb_sys_user_delete', 'sys_user_delete', 'jsb'),
('jsb_sys_user_manager', 'sys_user_manager', 'jsb'),
('jsb_sys_user_reset', 'sys_user_reset', 'jsb'),
('jsb_sys_user_update', 'sys_user_update', 'jsb'),
('pt-frame', 'frame', 'pt'),
('pt-sys', 'sys', 'pt'),
('pt-sys_func_add', 'sys_func_add', 'pt'),
('pt-sys_func_delete', 'sys_func_delete', 'pt'),
('pt-sys_func_manager', 'sys_func_manager', 'pt'),
('pt-sys_func_update', 'sys_func_update', 'pt'),
('pt-sys_manager', 'sys_manager', 'pt'),
('pt-sys_role_add', 'sys_role_add', 'pt'),
('pt-sys_role_delete', 'sys_role_delete', 'pt'),
('pt-sys_role_manager', 'sys_role_manager', 'pt'),
('pt-sys_role_update', 'sys_role_update', 'pt'),
('pt-sys_user_add', 'sys_user_add', 'pt'),
('pt-sys_user_delete', 'sys_user_delete', 'pt'),
('pt-sys_user_manager', 'sys_user_manager', 'pt'),
('pt-sys_user_reset', 'sys_user_reset', 'pt'),
('pt-sys_user_update', 'sys_user_update', 'pt'),
('superadmin-frame', 'frame', 'superadmin'),
('superadmin-frame_main_view', 'frame_main_view', 'superadmin'),
('superadmin-sys', 'sys', 'superadmin'),
('superadmin-sys_druid', 'sys_druid', 'superadmin'),
('superadmin-sys_echart', 'sys_echart', 'superadmin'),
('superadmin-sys_func_add', 'sys_func_add', 'superadmin'),
('superadmin-sys_func_delete', 'sys_func_delete', 'superadmin'),
('superadmin-sys_func_manager', 'sys_func_manager', 'superadmin'),
('superadmin-sys_func_update', 'sys_func_update', 'superadmin'),
('superadmin-sys_manager', 'sys_manager', 'superadmin'),
('superadmin-sys_org_add', 'sys_org_add', 'superadmin'),
('superadmin-sys_org_delete', 'sys_org_delete', 'superadmin'),
('superadmin-sys_org_manager', 'sys_org_manager', 'superadmin'),
('superadmin-sys_org_update', 'sys_org_update', 'superadmin'),
('superadmin-sys_role_add', 'sys_role_add', 'superadmin'),
('superadmin-sys_role_delete', 'sys_role_delete', 'superadmin'),
('superadmin-sys_role_manager', 'sys_role_manager', 'superadmin'),
('superadmin-sys_role_update', 'sys_role_update', 'superadmin'),
('superadmin-sys_user_add', 'sys_user_add', 'superadmin'),
('superadmin-sys_user_delete', 'sys_user_delete', 'superadmin'),
('superadmin-sys_user_manager', 'sys_user_manager', 'superadmin'),
('superadmin-sys_user_reset', 'sys_user_reset', 'superadmin'),
('superadmin-sys_user_update', 'sys_user_update', 'superadmin'),
('superadmin-xm_select_demo', 'xm_select_demo', 'superadmin'),
('superadmin-xm_select_tree', 'xm_select_tree', 'superadmin'),
('superadmin_data_dictionary', 'data_dictionary', 'superadmin'),
('superadmin_data_dictionary_add', 'data_dictionary_add', 'superadmin'),
('superadmin_data_dictionary_delete', 'data_dictionary_delete', 'superadmin'),
('superadmin_data_dictionary_update', 'data_dictionary_update', 'superadmin'),
('superadmin_data_dictionary_value', 'data_dictionary_value', 'superadmin'),
('superadmin_data_dictionary_value_add', 'data_dictionary_value_add', 'superadmin'),
('superadmin_data_dictionary_value_delete', 'data_dictionary_value_delete', 'superadmin'),
('superadmin_data_dictionary_value_update', 'data_dictionary_value_update', 'superadmin'),
('superadmin_data_source_add', 'data_source_add', 'superadmin'),
('superadmin_data_source_delete', 'data_source_delete', 'superadmin'),
('superadmin_data_source_manager', 'data_source_manager', 'superadmin'),
('superadmin_data_source_start', 'data_source_start', 'superadmin'),
('superadmin_data_source_state', 'data_source_state', 'superadmin'),
('superadmin_data_source_update', 'data_source_update', 'superadmin'),
('superadmin_form_business_table', 'form_business_table', 'superadmin'),
('superadmin_form_sql_add', 'form_sql_add', 'superadmin'),
('superadmin_form_sql_delete', 'form_sql_delete', 'superadmin'),
('superadmin_form_sql_update', 'form_sql_update', 'superadmin'),
('superadmin_form_sys_tree', 'form_sys_tree', 'superadmin'),
('superadmin_form_sys_tree_add', 'form_sys_tree_add', 'superadmin'),
('superadmin_form_sys_tree_delete', 'form_sys_tree_delete', 'superadmin'),
('superadmin_form_sys_tree_update', 'form_sys_tree_update', 'superadmin'),
('superadmin_form_view_add', 'form_view_add', 'superadmin'),
('superadmin_form_view_delete', 'form_view_delete', 'superadmin'),
('superadmin_form_view_manager', 'form_view_manager', 'superadmin'),
('superadmin_form_view_update', 'form_view_update', 'superadmin'),
('superadmin_generator_manager', 'generator_manager', 'superadmin'),
('superadmin_generator_single', 'generator_single', 'superadmin'),
('superadmin_generator_subtable', 'generator_subtable', 'superadmin'),
('superadmin_generator_subtable_demo', 'generator_subtable_demo', 'superadmin'),
('superadmin_main_sys', 'main_sys', 'superadmin'),
('superadmin_pub_fileList', 'pub_fileList', 'superadmin'),
('superadmin_query_user', 'query_user', 'superadmin'),
('superadmin_select_more_demo', 'select_more_demo', 'superadmin'),
('superadmin_sql_sys_tree', 'sql_sys_tree', 'superadmin'),
('superadmin_sql_sys_tree_add', 'sql_sys_tree_add', 'superadmin'),
('superadmin_sql_sys_tree_delete', 'sql_sys_tree_delete', 'superadmin'),
('superadmin_sql_sys_tree_update', 'sql_sys_tree_update', 'superadmin'),
('superadmin_sys_cus_sql', 'sys_cus_sql', 'superadmin'),
('superadmin_sys_log', 'sys_log', 'superadmin'),
('superadmin_sys_pub_upload', 'sys_pub_upload', 'superadmin'),
('superadmin_sys_role_save_function', 'sys_role_save_function', 'superadmin'),
('superadmin_sys_user_role', 'sys_user_role', 'superadmin'),
('superadmin_table_edit', 'table_edit', 'superadmin'),
('superadmin_ureport_course', 'ureport_course', 'superadmin'),
('superadmin_ureport_designer', 'ureport_designer', 'superadmin'),
('superadmin_ureport_manager', 'ureport_manager', 'superadmin'),
('superadmin_ureport_preview', 'ureport_preview', 'superadmin'),
('superadmin_ureport_preview_sys_log', 'ureport_preview_sys_log', 'superadmin'),
('superadmin_ureport_preview_user', 'ureport_preview_user', 'superadmin'),
('superadmin_veFarmer', 'veFarmer', 'superadmin'),
('superadmin_veFarmer2', 'veFarmer2', 'superadmin'),
('superadmin_video', 'video', 'superadmin'),
('sys-xm_select_demo', 'xm_select_demo', 'sys'),
('sys-xm_select_tree', 'xm_select_tree', 'sys'),
('sys_data_dictionary', 'data_dictionary', 'sys'),
('sys_data_dictionary_add', 'data_dictionary_add', 'sys'),
('sys_data_dictionary_delete', 'data_dictionary_delete', 'sys'),
('sys_data_dictionary_update', 'data_dictionary_update', 'sys'),
('sys_data_dictionary_value', 'data_dictionary_value', 'sys'),
('sys_data_dictionary_value_add', 'data_dictionary_value_add', 'sys'),
('sys_data_dictionary_value_delete', 'data_dictionary_value_delete', 'sys'),
('sys_data_dictionary_value_update', 'data_dictionary_value_update', 'sys'),
('sys_data_source_add', 'data_source_add', 'sys'),
('sys_data_source_delete', 'data_source_delete', 'sys'),
('sys_data_source_manager', 'data_source_manager', 'sys'),
('sys_data_source_start', 'data_source_start', 'sys'),
('sys_data_source_state', 'data_source_state', 'sys'),
('sys_data_source_update', 'data_source_update', 'sys'),
('sys_form_business_table', 'form_business_table', 'sys'),
('sys_form_sql_add', 'form_sql_add', 'sys'),
('sys_form_sql_delete', 'form_sql_delete', 'sys'),
('sys_form_sql_update', 'form_sql_update', 'sys'),
('sys_form_sys_tree', 'form_sys_tree', 'sys'),
('sys_form_sys_tree_add', 'form_sys_tree_add', 'sys'),
('sys_form_sys_tree_delete', 'form_sys_tree_delete', 'sys'),
('sys_form_sys_tree_update', 'form_sys_tree_update', 'sys'),
('sys_form_view_add', 'form_view_add', 'sys'),
('sys_form_view_delete', 'form_view_delete', 'sys'),
('sys_form_view_manager', 'form_view_manager', 'sys'),
('sys_form_view_update', 'form_view_update', 'sys'),
('sys_frame', 'frame', 'sys'),
('sys_frame_main_view', 'frame_main_view', 'sys'),
('sys_generator_manager', 'generator_manager', 'sys'),
('sys_generator_single', 'generator_single', 'sys'),
('sys_generator_subtable', 'generator_subtable', 'sys'),
('sys_generator_subtable_demo', 'generator_subtable_demo', 'sys'),
('sys_main_sys', 'main_sys', 'sys'),
('sys_pub_fileList', 'pub_fileList', 'sys'),
('sys_query_user', 'query_user', 'sys'),
('sys_select_more_demo', 'select_more_demo', 'sys'),
('sys_sql_sys_tree', 'sql_sys_tree', 'sys'),
('sys_sql_sys_tree_add', 'sql_sys_tree_add', 'sys'),
('sys_sql_sys_tree_delete', 'sql_sys_tree_delete', 'sys'),
('sys_sql_sys_tree_update', 'sql_sys_tree_update', 'sys'),
('sys_sys', 'sys', 'sys'),
('sys_sys_cus_sql', 'sys_cus_sql', 'sys'),
('sys_sys_druid', 'sys_druid', 'sys'),
('sys_sys_echart', 'sys_echart', 'sys'),
('sys_sys_func_add', 'sys_func_add', 'sys'),
('sys_sys_func_delete', 'sys_func_delete', 'sys'),
('sys_sys_func_manager', 'sys_func_manager', 'sys'),
('sys_sys_func_update', 'sys_func_update', 'sys'),
('sys_sys_log', 'sys_log', 'sys'),
('sys_sys_manager', 'sys_manager', 'sys'),
('sys_sys_org_add', 'sys_org_add', 'sys'),
('sys_sys_org_delete', 'sys_org_delete', 'sys'),
('sys_sys_org_manager', 'sys_org_manager', 'sys'),
('sys_sys_org_update', 'sys_org_update', 'sys'),
('sys_sys_pub_upload', 'sys_pub_upload', 'sys'),
('sys_sys_role_add', 'sys_role_add', 'sys'),
('sys_sys_role_delete', 'sys_role_delete', 'sys'),
('sys_sys_role_manager', 'sys_role_manager', 'sys'),
('sys_sys_role_save_function', 'sys_role_save_function', 'sys'),
('sys_sys_role_update', 'sys_role_update', 'sys'),
('sys_sys_user_add', 'sys_user_add', 'sys'),
('sys_sys_user_delete', 'sys_user_delete', 'sys'),
('sys_sys_user_manager', 'sys_user_manager', 'sys'),
('sys_sys_user_reset', 'sys_user_reset', 'sys'),
('sys_sys_user_role', 'sys_user_role', 'sys'),
('sys_sys_user_update', 'sys_user_update', 'sys'),
('sys_table_edit', 'table_edit', 'sys'),
('sys_ureport_course', 'ureport_course', 'sys'),
('sys_ureport_designer', 'ureport_designer', 'sys'),
('sys_ureport_manager', 'ureport_manager', 'sys'),
('sys_ureport_preview', 'ureport_preview', 'sys'),
('sys_ureport_preview_sys_log', 'ureport_preview_sys_log', 'sys'),
('sys_ureport_preview_user', 'ureport_preview_user', 'sys'),
('sys_veFarmer', 'veFarmer', 'sys'),
('sys_veFarmer2', 'veFarmer2', 'sys'),
('sys_video', 'video', 'sys'),
('xmb_frame', 'frame', 'xmb'),
('xmb_sys', 'sys', 'xmb'),
('xmb_sys_druid', 'sys_druid', 'xmb'),
('xmb_sys_echart', 'sys_echart', 'xmb'),
('xtjcb-frame', 'frame', 'xtjcb'),
('xtjcb-sys', 'sys', 'xtjcb'),
('xtjcb-sys_func_add', 'sys_func_add', 'xtjcb'),
('xtjcb-sys_func_delete', 'sys_func_delete', 'xtjcb'),
('xtjcb-sys_func_manager', 'sys_func_manager', 'xtjcb'),
('xtjcb-sys_func_update', 'sys_func_update', 'xtjcb'),
('xtjcb-sys_manager', 'sys_manager', 'xtjcb'),
('xtjcb-sys_org_add', 'sys_org_add', 'xtjcb'),
('xtjcb-sys_org_delete', 'sys_org_delete', 'xtjcb'),
('xtjcb-sys_org_manager', 'sys_org_manager', 'xtjcb'),
('xtjcb-sys_org_update', 'sys_org_update', 'xtjcb'),
('xtjcb-sys_role_add', 'sys_role_add', 'xtjcb'),
('xtjcb-sys_role_delete', 'sys_role_delete', 'xtjcb'),
('xtjcb-sys_role_manager', 'sys_role_manager', 'xtjcb'),
('xtjcb-sys_role_update', 'sys_role_update', 'xtjcb'),
('xtjcb-sys_user_add', 'sys_user_add', 'xtjcb'),
('xtjcb-sys_user_delete', 'sys_user_delete', 'xtjcb'),
('xtjcb-sys_user_manager', 'sys_user_manager', 'xtjcb'),
('xtjcb-sys_user_reset', 'sys_user_reset', 'xtjcb'),
('xtjcb-sys_user_role', 'sys_user_role', 'xtjcb'),
('xtjcb-sys_user_update', 'sys_user_update', 'xtjcb'),
('xzb_frame', 'frame', 'xzb'),
('xzb_sys', 'sys', 'xzb'),
('xzb_sys_manager', 'sys_manager', 'xzb'),
('xzb_sys_user_add', 'sys_user_add', 'xzb'),
('xzb_sys_user_delete', 'sys_user_delete', 'xzb'),
('xzb_sys_user_manager', 'sys_user_manager', 'xzb'),
('xzb_sys_user_reset', 'sys_user_reset', 'xzb'),
('xzb_sys_user_update', 'sys_user_update', 'xzb'),
('yf_frame', 'frame', 'yf'),
('yf_sys', 'sys', 'yf'),
('yf_sys_func_add', 'sys_func_add', 'yf'),
('yf_sys_func_delete', 'sys_func_delete', 'yf'),
('yf_sys_func_manager', 'sys_func_manager', 'yf'),
('yf_sys_func_update', 'sys_func_update', 'yf'),
('yf_sys_manager', 'sys_manager', 'yf'),
('yf_sys_org_add', 'sys_org_add', 'yf'),
('yf_sys_org_delete', 'sys_org_delete', 'yf'),
('yf_sys_org_manager', 'sys_org_manager', 'yf'),
('yf_sys_org_update', 'sys_org_update', 'yf'),
('yf_sys_role_add', 'sys_role_add', 'yf'),
('yf_sys_role_delete', 'sys_role_delete', 'yf'),
('yf_sys_role_manager', 'sys_role_manager', 'yf'),
('yf_sys_role_update', 'sys_role_update', 'yf'),
('yf_sys_user_add', 'sys_user_add', 'yf'),
('yf_sys_user_delete', 'sys_user_delete', 'yf'),
('yf_sys_user_manager', 'sys_user_manager', 'yf'),
('yf_sys_user_reset', 'sys_user_reset', 'yf'),
('yf_sys_user_update', 'sys_user_update', 'yf'),
('zjl_frame', 'frame', 'zjl'),
('zjl_sys', 'sys', 'zjl'),
('zjl_sys_func_add', 'sys_func_add', 'zjl'),
('zjl_sys_func_delete', 'sys_func_delete', 'zjl'),
('zjl_sys_func_manager', 'sys_func_manager', 'zjl'),
('zjl_sys_func_update', 'sys_func_update', 'zjl'),
('zjl_sys_manager', 'sys_manager', 'zjl'),
('zjl_sys_org_add', 'sys_org_add', 'zjl'),
('zjl_sys_org_delete', 'sys_org_delete', 'zjl'),
('zjl_sys_org_manager', 'sys_org_manager', 'zjl'),
('zjl_sys_org_update', 'sys_org_update', 'zjl'),
('zjl_sys_role_add', 'sys_role_add', 'zjl'),
('zjl_sys_role_delete', 'sys_role_delete', 'zjl'),
('zjl_sys_role_manager', 'sys_role_manager', 'zjl'),
('zjl_sys_role_update', 'sys_role_update', 'zjl'),
('zjl_sys_user_add', 'sys_user_add', 'zjl'),
('zjl_sys_user_delete', 'sys_user_delete', 'zjl'),
('zjl_sys_user_manager', 'sys_user_manager', 'zjl'),
('zjl_sys_user_reset', 'sys_user_reset', 'zjl'),
('zjl_sys_user_update', 'sys_user_update', 'zjl');
/*!40000 ALTER TABLE `sys_role_function` ENABLE KEYS */;
-- 导出 表 jfinal-layui.sys_tree 结构
DROP TABLE IF EXISTS `sys_tree`;
CREATE TABLE IF NOT EXISTS `sys_tree` (
`id` varchar(64) NOT NULL COMMENT '主键',
`parent_id` varchar(64) DEFAULT NULL COMMENT '上级Id',
`name` varchar(50) DEFAULT NULL COMMENT '名称',
`type` varchar(50) DEFAULT NULL COMMENT '分类',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`order_no` int(11) DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统tree';
-- 正在导出表 jfinal-layui.sys_tree 的数据：~3 rows (大约)
DELETE FROM `sys_tree`;
/*!40000 ALTER TABLE `sys_tree` DISABLE KEYS */;
INSERT INTO `sys_tree` (`id`, `parent_id`, `name`, `type`, `create_time`, `order_no`) VALUES
('107400000000002215', NULL, '流程表单', 'form', '2019-04-25 14:00:52', 1),
('402880e87a1ca809017a1ca89dda0004', NULL, '自定义SQL表单', 'form', '2021-06-18 09:07:30', 1),
('4028830c6b5fcc89016b5fd976fc005a', NULL, '用户部门查询', 'sql', '2019-09-04 09:00:52', 1);
/*!40000 ALTER TABLE `sys_tree` ENABLE KEYS */;
-- 导出 表 jfinal-layui.sys_user 结构
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE IF NOT EXISTS `sys_user` (
`id` varchar(20) NOT NULL COMMENT '主键',
`user_code` varchar(20) DEFAULT NULL COMMENT '用户编号默认跟ID一样',
`user_name` varchar(20) DEFAULT NULL COMMENT '用户名称',
`passwd` varchar(100) DEFAULT NULL COMMENT '密码',
`org_id` varchar(50) DEFAULT NULL COMMENT '部门编号',
`post` varchar(50) DEFAULT NULL COMMENT '职务',
`sex` int(11) DEFAULT NULL COMMENT '1;男,0女',
`tel` varchar(40) DEFAULT NULL COMMENT '电话',
`mobile` varchar(30) DEFAULT NULL COMMENT '手机号码',
`email` varchar(40) DEFAULT NULL COMMENT 'EMAIL',
`address` varchar(100) DEFAULT NULL COMMENT '家庭地址',
`allow_login` int(11) DEFAULT NULL COMMENT '允许登录',
`deleted` int(11) DEFAULT 0 COMMENT '删除操作（1：删除未审核）',
`allow_login_time` datetime DEFAULT NULL COMMENT '允许登录时间或最后登录时间',
`failure_number` int(11) DEFAULT NULL COMMENT '登录错误次数',
`theme` varchar(100) DEFAULT NULL COMMENT '用户主题切换',
PRIMARY KEY (`id`) USING BTREE,
KEY `index_1_sys_user_orgid` (`org_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户';
-- 正在导出表 jfinal-layui.sys_user 的数据：~2 rows (大约)
DELETE FROM `sys_user`;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` (`id`, `user_code`, `user_name`, `passwd`, `org_id`, `post`, `sex`, `tel`, `mobile`, `email`, `address`, `allow_login`, `deleted`, `allow_login_time`, `failure_number`, `theme`) VALUES
('15811111111', '15811111111', '测试', '2f232a589ed4c0b57862546a5a080389', '40288ae767ee75f70167ee7bae0a0001', NULL, 1, NULL, NULL, NULL, NULL, 0, 0, '2023-08-29 18:01:42', 0, NULL),
('admin', 'admin', '管理员', '2f232a589ed4c0b57862546a5a080389', 'ff808081616e1efd01616e2c89af0000', NULL, 1, NULL, NULL, NULL, NULL, 0, 0, '2023-08-29 18:07:39', 0, NULL),
('superadmin', 'superadmin', '超级管理员', '2f232a589ed4c0b57862546a5a080389', 'ff808081616e1efd01616e2c89af0000', NULL, 1, NULL, NULL, NULL, NULL, 0, 0, '2019-01-02 18:12:29', 0, NULL);
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
-- 导出 表 jfinal-layui.sys_user_role 结构
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE IF NOT EXISTS `sys_user_role` (
`id` varchar(200) NOT NULL,
`role_code` varchar(50) DEFAULT NULL,
`user_code` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户角色关系表';
-- 正在导出表 jfinal-layui.sys_user_role 的数据：~14 rows (大约)
DELETE FROM `sys_user_role`;
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` (`id`, `role_code`, `user_code`) VALUES
('13-superadmin', '13', 'superadmin'),
('admin-admin', 'admin', 'admin'),
('admin3-15811111111', 'admin3', '15811111111'),
('admin3-admin', 'admin3', 'admin'),
('jsb-123', 'jsb', '123'),
('qinhaisenlin-admin', 'admin', 'qinhaisenlin'),
('superadmin-superadmin', 'superadmin', 'superadmin'),
('xmb-linwei', 'xmb', 'linwei'),
('xtjcb-admin', 'xtjcb', 'admin'),
('xzb-123', 'xzb', '123'),
('xzb-linwei', 'xzb', 'linwei'),
('xzb-qweq', 'xzb', 'qweq'),
('yfb-admin', 'yfb', 'admin'),
('zjl-linwei', 'zjl', 'linwei'),
('zjl-qweq', 'zjl', 'qweq');
/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
-- 导出 表 jfinal-layui.w_sys_tree 结构
DROP TABLE IF EXISTS `w_sys_tree`;
CREATE TABLE IF NOT EXISTS `w_sys_tree` (
`id` varchar(64) NOT NULL COMMENT '主键',
`parent_id` varchar(64) DEFAULT NULL COMMENT '上级Id',
`name` varchar(50) DEFAULT NULL COMMENT '名称',
`type` varchar(50) DEFAULT NULL COMMENT '分类',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`order_no` int(11) DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='测试在线表单用表';
-- 正在导出表 jfinal-layui.w_sys_tree 的数据：~0 rows (大约)
DELETE FROM `w_sys_tree`;
/*!40000 ALTER TABLE `w_sys_tree` DISABLE KEYS */;
/*!40000 ALTER TABLE `w_sys_tree` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手