/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : new_code_com

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 10/05/2024 16:47:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for erp_admin_department
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_department`;
CREATE TABLE `erp_admin_department`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织编码',
  `type` int(2) NULL DEFAULT 1 COMMENT '组织类型',
  `sort` int(11) NULL DEFAULT 1 COMMENT '排序',
  `tel` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  `notes` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `parent_id` int(11) NULL DEFAULT 0 COMMENT '上级',
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `facsimile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '传真',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10728 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织机构' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_admin_department
-- ----------------------------
INSERT INTO `erp_admin_department` VALUES (10725, '瑞诺科技', 'ruinuo', 1, 1, '', '2024-04-22 09:43:05', '2024-04-22 09:43:05', 1, 1, '', 0, '', '');
INSERT INTO `erp_admin_department` VALUES (10726, '技术部门', 'jishu', 2, 1, '', '2024-04-22 09:43:38', '2024-04-22 09:43:38', 1, 1, '', 10725, '', '');
INSERT INTO `erp_admin_department` VALUES (10727, '程序员', 'chengxuyuan', 3, 1, '', '2024-04-22 09:44:12', '2024-04-22 09:44:12', 1, 1, '', 10726, '', '');

-- ----------------------------
-- Table structure for erp_admin_file
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_file`;
CREATE TABLE `erp_admin_file`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `size` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件大小',
  `mime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件类型',
  `type` int(2) NULL DEFAULT 1 COMMENT '上传方式',
  `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '存储路径',
  `source_url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源url',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 66 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_admin_file
-- ----------------------------
INSERT INTO `erp_admin_file` VALUES (9, 'pic5.jpg', '81.769', 'jpg', 1, '/storage/upload/20231217\\02365fe03975e3b1bae219563a5b4ba5.jpg', 'http://ticket.com/admin/film/form/?id=&elem=datatable', '2023-12-17 21:06:35', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (10, '1701766058_656ee3aa7ee2c.jpeg', '527.233', 'jpeg', 1, '/storage/upload/20231217\\164d39e3c305c2a860ada4891c6fad62.jpeg', 'http://ticket.com/admin/film/form/?id=&elem=datatable', '2023-12-17 21:10:11', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (11, '1701766058_656ee3aa7ee2c.jpeg', '527.233', 'jpeg', 1, '/storage/upload/20231217\\7f5cd9b7c2d8b00dfd9abbdeaf01d504.jpeg', 'http://ticket.com/admin/film/form/?id=&elem=datatable', '2023-12-17 21:10:17', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (12, '1687848373_649a85b584fb6.png', '566.33', 'png', 1, '/storage/upload/20231217\\c23ca79c60fa9d1e54e7f7808b8adea1.png', 'http://ticket.com/store/goodslist/form/&elem=datatable', '2023-12-17 22:50:26', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (13, '1701766058_656ee3aa7ee2c.jpeg', '527.233', 'jpeg', 1, '/storage/upload/20231218\\0e0f7c02988d47842a59b1c91d030176.jpeg', 'http://ticket.com/store/goodslist/form/?id=234&elem=datatable', '2023-12-18 01:32:27', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (14, '1701766058_656ee3aa7ee2c.jpeg', '527.233', 'jpeg', 1, '/storage/upload/20231218\\6b81efec875e3794799de5b8b38c1963.jpeg', 'http://ticket.com/store/goodslist/form/?id=234&elem=datatable', '2023-12-18 01:32:35', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (16, '1687848373_649a85b584fb6.png', '566.33', 'png', 1, '/storage/upload/20231219\\a21bab0973902085cd492145b02b678d.png', 'http://ticket.com/admin/film/form/?id=1&elem=datatable', '2023-12-19 23:42:38', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (18, 'logo.png', '14.28', 'png', 1, '/storage/upload/20231222\\1d29cd16527575002890c81796288231.png', 'http://ticket.com/admin/setting/index/?type=system', '2023-12-22 20:00:10', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (22, 'logo.png', '14.28', 'png', 1, 'https://oss.ruinuocrm.com/uploads/20231223\\c06ed2b72296d0320b48a6293371a8e6.png', 'http://ticket.com/admin/setting/index/?type=system', '2023-12-23 09:43:27', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (24, 'c23ca79c60fa9d1e54e7f7808b8adea1.png', '566.33', 'png', 1, 'https://oss.ruinuocrm.com/uploads/20231229/4b97be33047b22601c4fd19b666cd9c7.png', 'http://ticket.com/store/goodslist/form/?id=234&elem=datatable', '2023-12-29 00:44:21', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (25, 'c23ca79c60fa9d1e54e7f7808b8adea1.png', '566.33', 'png', 1, 'https://oss.ruinuocrm.com/uploads/20231229/7a26e86d3647f99e540b3892a65e3441.png', 'http://ticket.com/store/goodslist/form/&elem=datatable', '2023-12-29 00:46:04', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (26, 'vlCYjdLqgCX2ee5312acf0c230b3667be14245d793ca.jpeg', '4.817', 'jpeg', 1, 'https://oss.ruinuocrm.com/uploads/20231229/14dccf62fe0ce8496a77309cdc00acd3.jpeg', 'https://servicewechat.com/wx4bfafdbc22f14b5c/devtools/page-frame.html', '2023-12-29 04:52:09', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (28, 'ad.png', '206.889', 'png', 1, 'https://oss.ruinuocrm.com/uploads/20240102/f22aec6c87cd4034df60d340b809ce9c.png', 'http://ticket.com/store/ad/form/?id=232&elem=datatable', '2024-01-02 09:58:35', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (29, 'logo.png', '14.28', 'png', 1, 'https://oss.ruinuocrm.com/uploads/20240102/769aef1f56ec97417ef845b6a8b88d55.png', 'http://ticket.com/store/ad/form/?id=&elem=datatable', '2024-01-02 10:22:56', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (30, 'ad.png', '206.889', 'png', 1, 'https://oss.ruinuocrm.com/uploads/20240103/aa3841dab4b2192daaa2301ff3b799d0.png', 'http://ticket.com/admin/film/form/?id=2008&elem=datatable', '2024-01-03 10:27:44', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (31, 'c23ca79c60fa9d1e54e7f7808b8adea1.png', '566.33', 'png', 1, 'https://oss.ruinuocrm.com/uploads/20240103/27988aca38e1068275a4778ca36d52e1.png', 'http://ticket.com/admin/film/form/?id=2008&elem=datatable', '2024-01-03 10:27:49', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (35, '89c4d6afc46ed23af6724e6c3087937c.jpeg', '72.376', 'jpeg', 2, 'https://oss.ruinuocrm.com/uploads/20240402/dc69af422854370dfde8b5aae5e3994c.jpeg', 'http://lowcode.com/design/demo/Form', '2024-04-02 11:44:34', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (38, 't2.png', '190.279', 'png', 2, 'https://oss.ruinuocrm.com/uploads/20240402/621772373d76ceb33eaa4c18f11c0116.png', 'http://lowcode.com/design/demo/Form', '2024-04-02 11:45:35', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (39, '6396e51436eb50cded450f087feb637e.jpeg', '74.444', 'jpeg', 2, 'https://oss.ruinuocrm.com/uploads/20240402/bc33fdf66c2cda619e712c411e23757c.jpeg', 'http://lowcode.com/design/demo/Form', '2024-04-02 11:46:56', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (40, 'bg_proc.jpg', '41.543', 'jpg', 2, 'https://oss.ruinuocrm.com/uploads/20240402/a63c31f258ec491be8471d5a83e310eb.jpg', 'http://lowcode.com/design/demo/Form', '2024-04-02 11:47:03', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (42, '5bc6a5c3d91c3.png', '683.667', 'png', 2, 'https://oss.ruinuocrm.com/uploads/20240402/d9cb63483d86bb6c30d2897c37c6999f.png', 'http://lowcode.com/design/demo/Form', '2024-04-02 11:50:27', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (59, '8de551843956d4be5935d5a40008187a904e604b.png', '11.099', 'png', 2, 'https://oss.ruinuocrm.com/uploads/20240421/446633b867afc8b3e4a27bda3f026b6d.png', 'http://lowcode.com/ruinuo/design.Setting/?id=13&type=2', '2024-04-21 23:55:25', NULL, 0, NULL);
INSERT INTO `erp_admin_file` VALUES (60, '77.xls', '19.968', 'xls', 1, '/storage/uploads/20240423/fa621209aab7939a5b3f02f777b05994.xls', 'http://lowcode.com/common/Component/excel?file=', '2024-04-23 14:59:18', NULL, 1, NULL);
INSERT INTO `erp_admin_file` VALUES (61, '77.xls', '19.968', 'xls', 1, '/storage/uploads/20240423/3a641e209b96b42c3673185a0f643fa5.xls', 'http://lowcode.com/common/Component/excel?file=', '2024-04-23 15:00:49', NULL, 1, NULL);
INSERT INTO `erp_admin_file` VALUES (62, 'logo.png', '14.28', 'png', 1, '/storage/uploads/20240427/06ccd011a22d5d6b5d58c723deb1b8fb.png', 'http://lowcode.com/ruinuo/design.form/browse/', '2024-04-27 15:28:11', NULL, 1, NULL);
INSERT INTO `erp_admin_file` VALUES (63, 'logo.png', '14.28', 'png', 1, '/storage/uploads/20240427/1487a21db8dc2880f231f8a25d7f4a24.png', 'http://lowcode.com/ruinuo/design.form/browse/', '2024-04-27 15:29:01', NULL, 1, NULL);
INSERT INTO `erp_admin_file` VALUES (64, 'bg_proc.jpg', '41.543', 'jpg', 1, '/storage/uploads/20240427/7a752c229ab2b77b5d9fc6c9401ba775.jpg', 'http://lowcode.com/ruinuo/design.form/browse/', '2024-04-27 15:29:27', NULL, 1, NULL);
INSERT INTO `erp_admin_file` VALUES (65, 'bg_proc.jpg', '41.543', 'jpg', 1, '/storage/uploads/20240427/2246d5eb21024554077ed00059c3966b.jpg', 'http://lowcode.com/ruinuo/design.form/browse/', '2024-04-27 15:29:44', NULL, 1, NULL);

-- ----------------------------
-- Table structure for erp_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_log`;
CREATE TABLE `erp_admin_log`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表id',
  `type` int(2) NULL DEFAULT 1 COMMENT '日志类别',
  `module` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '模块',
  `controller` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '控制器',
  `action` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '方法',
  `method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '请求方式',
  `url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '请求地址',
  `post_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'POST数据',
  `get_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'GET数据',
  `headers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '头部信息',
  `ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'ip地址',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '日志内容',
  `agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '请求头',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1629 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统日志' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for erp_admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_menu`;
CREATE TABLE `erp_admin_menu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
  `href` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部链接',
  `open_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打开方式',
  `parent_id` int(11) NULL DEFAULT 0 COMMENT '上级',
  `type` int(11) NULL DEFAULT 0 COMMENT '类型',
  `sort` int(11) NULL DEFAULT 0 COMMENT '排序',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  `is_admin` int(2) NULL DEFAULT 2 COMMENT '后台菜单',
  `app` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用',
  `controller` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '控制器',
  `action` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '方法',
  `query` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 268 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_admin_menu
-- ----------------------------
INSERT INTO `erp_admin_menu` VALUES (230, '系统管理', 'icon-mokuai', '', '_iframe', 260, 1, 1, NULL, '2024-04-21 17:18:56', NULL, 1, 1, '', '', '', '');
INSERT INTO `erp_admin_menu` VALUES (235, '权限管理', 'icon-ccaozuo', '', '_iframe', 260, 1, 2, NULL, '2024-04-21 17:19:10', NULL, 1, 1, '', '', '', '');
INSERT INTO `erp_admin_menu` VALUES (236, '用户管理', 'icon-stop1', '', '_iframe', 235, 2, 1, NULL, '2024-04-21 17:35:21', NULL, 1, 1, 'admin', 'user', 'index', '');
INSERT INTO `erp_admin_menu` VALUES (237, '菜单管理', 'icon-stop1', '', '_iframe', 235, 2, 2, NULL, '2024-04-21 17:34:37', NULL, 1, 1, 'admin', 'menu', 'index', '');
INSERT INTO `erp_admin_menu` VALUES (238, '系统日志', 'icon-stop1', NULL, '_iframe', 230, 2, 3, NULL, '2023-12-14 09:32:25', NULL, 1, 1, 'admin', 'oldlog', 'index', NULL);
INSERT INTO `erp_admin_menu` VALUES (239, '附件管理', 'icon-stop1', NULL, '_iframe', 230, 2, 2, NULL, '2023-12-14 09:43:16', NULL, 1, 1, 'admin', 'file', 'index', NULL);
INSERT INTO `erp_admin_menu` VALUES (240, '系统配置', 'icon-stop1', '', '_iframe', 230, 2, 1, NULL, '2024-04-21 23:56:41', NULL, 1, 1, 'ruinuo', 'design.setting', 'index', 'id=13');
INSERT INTO `erp_admin_menu` VALUES (241, '数据回收', 'icon-stop1', '', '_iframe', 230, 2, 5, NULL, '2023-12-14 09:43:30', NULL, 1, 1, 'admin', 'recycle', 'index', NULL);
INSERT INTO `erp_admin_menu` VALUES (245, '角色管理', 'icon-stop1', '', '_iframe', 235, 2, 4, NULL, '2024-04-21 17:32:45', NULL, 1, 1, 'admin', 'role', 'index', '');
INSERT INTO `erp_admin_menu` VALUES (247, '数据字典', 'icon-stop1', NULL, '_iframe', 230, 2, 6, '2023-12-11 17:58:20', '2023-12-14 09:43:51', 1, 1, 1, 'admin', 'options', 'index', NULL);
INSERT INTO `erp_admin_menu` VALUES (248, '数据验证', 'icon-stop1', NULL, '_iframe', 230, 2, 7, '2023-12-12 11:17:10', '2023-12-14 09:44:10', 1, 1, 1, 'admin', 'verify', 'index', NULL);
INSERT INTO `erp_admin_menu` VALUES (259, '按钮管理', 'icon-stop1', '', '_iframe', 235, 2, 3, '2024-01-05 12:24:08', '2024-04-21 17:40:29', 1, 1, 1, 'ruinuo', 'button', 'index', '1');
INSERT INTO `erp_admin_menu` VALUES (260, '系统', 'icon-danxuankuang', '', NULL, 0, 1, 1, '2024-04-21 17:18:47', '2024-04-22 00:50:31', 1, 1, 1, '', '', '', '');
INSERT INTO `erp_admin_menu` VALUES (261, '组织管理', 'icon-tupianshangchuan', '', NULL, 235, 2, 5, '2024-04-21 17:33:34', '2024-04-22 00:51:16', 1, 1, 1, 'admin', 'department', 'index', '');
INSERT INTO `erp_admin_menu` VALUES (262, '权限设置', 'icon-tishi', '', NULL, 235, 2, 6, '2024-04-22 10:17:47', '2024-04-22 10:17:47', 1, 1, 2, 'common', 'power', 'index', '');
INSERT INTO `erp_admin_menu` VALUES (263, '应用商店', 'icon-fuxuankuang', '', NULL, 230, 2, 8, '2024-04-25 17:05:54', '2024-04-25 17:05:54', 1, 1, 2, 'common', 'shop', 'index', '');
INSERT INTO `erp_admin_menu` VALUES (264, '工作空间', 'icon-biaoti', '', NULL, 260, 1, 1, '2024-04-25 20:24:20', '2024-04-25 20:24:41', 1, 1, 2, '', '', '', '');
INSERT INTO `erp_admin_menu` VALUES (265, '分析页', 'icon-tupianshangchuan', '', NULL, 264, 2, 1, '2024-04-25 20:25:25', '2024-04-25 20:25:25', 1, 1, 2, 'admin', 'Workbench', 'index', '');
INSERT INTO `erp_admin_menu` VALUES (266, '工作台', 'icon-fuwenben', '', NULL, 264, 2, 2, '2024-04-25 20:25:59', '2024-04-25 20:25:59', 1, 1, 2, 'admin', 'workbench', 'console', '');

-- ----------------------------
-- Table structure for erp_admin_options
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_options`;
CREATE TABLE `erp_admin_options`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
  `type` int(2) NULL DEFAULT 1 COMMENT '类型',
  `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接地址',
  `label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示字段',
  `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保存字段',
  `is_token` int(2) NULL DEFAULT 2 COMMENT '是否验证token',
  `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '配置',
  `notes` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  `mode_id` int(11) NULL DEFAULT 0 COMMENT '选择模块',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 84 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_admin_options
-- ----------------------------
INSERT INTO `erp_admin_options` VALUES (2, '是否', 'yesno', 1, NULL, NULL, NULL, 2, '[{\"url\":\"\",\"label\":\"是\",\"value\":\"1\"},{\"url\":\"\",\"label\":\"否\",\"value\":\"2\"}]', '', NULL, NULL, NULL, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (56, '数据库引擎', 'database_engine', 1, NULL, NULL, NULL, 2, '[{\"label\":\"MyISAM\",\"value\":\"MyISAM\"},{\"label\":\"InnoDB\",\"value\":\"InnoDB\"}]', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (57, '数据库字符集', 'database_collation', 1, NULL, NULL, NULL, 2, '[{\"label\":\"utf8_general_ci\",\"value\":\"utf8_general_ci\"},{\"label\":\"utf8mb4_unicode_ci\",\"value\":\"utf8mb4_unicode_ci\"}]', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (58, '数据库字段类型', 'database_field_type', 1, NULL, NULL, NULL, 2, '[{\"label\":\"年月日\",\"value\":\"date\"},{\"label\":\"年月日时分秒\",\"value\":\"datetime\"},{\"label\":\"时间戳\",\"value\":\"timestamp\"},{\"label\":\"整数\",\"value\":\"int\"},{\"label\":\"浮点数\",\"value\":\"float\"},{\"label\":\"金额\",\"value\":\"decimal\"},{\"label\":\"普通文本\",\"value\":\"varchar\"},{\"label\":\"长文本\",\"value\":\"text\"},{\"label\":\"巨型文本\",\"value\":\"longtext\"},{\"label\":\"json字符串\",\"value\":\"json\"}]', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (59, '数据库表', 'database_list', 2, '/common/options/databaselist/', 'comment,name', 'name', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (60, '应用列表', 'app_list', 2, '/common/options/applist/', 'name,num', 'id', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (61, '模型列表', 'mode_list', 2, '/common/options/modelist/', 'name,num', 'id', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (62, '按钮节点', 'button_node', 2, '/common/options/buttonnode/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (63, '按钮位置', 'button_position', 2, '/common/options/buttonposition/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (64, '按钮打开方式', 'button_type', 2, '/common/options/buttontype/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (65, '列表风格', 'lists_style', 2, '/common/options/listsstyle/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (66, '全部数据源', 'options_list', 2, '/common/options/optionslist/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (67, '全部验证规则', 'verify_list', 2, '/common/options/verifylist/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (68, '左侧数据来源', 'left_type', 2, '/common/options/lefttype/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (69, '表格编辑方式', 'update_type', 2, '/common/options/updatetype/', 'label', 'value', 2, '[]', NULL, '2023-12-22 19:54:54', NULL, 1, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (70, '关联方式', 'guanlian_type', 1, NULL, NULL, NULL, 2, '[{\"label\":\"正向关联\",\"value\":\"1\"},{\"label\":\"反向关联\",\"value\":\"2\"}]', NULL, '2023-12-19 12:12:26', NULL, 1, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (72, '按钮颜色', 'btn_theme', 2, '/common/options/btntheme/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (73, '表单字段权限方式', 'form_power', 2, '/common/options/formpower/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (74, '组织类型', 'department_type', 2, '/common/options/departmenttype/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (75, '组织列表', 'department_list', 2, '/common/options/departmentlist/', 'name', 'id', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (76, '后台用户列表', 'admin_user_list', 2, '/common/options/adminuserlist/', 'name', 'id', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (34, '后台菜单', 'admin_menu', 2, '/common/options/adminmenu/', 'title', 'id', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (35, '数据源类型', 'options_type', 1, '', '静态数据源', '1', 2, '[{\"label\":\"静态数据源\",\"value\":\"1\"},{\"label\":\"动态数据源\",\"value\":\"2\"},{\"label\":\"应用模块\",\"value\":\"3\"}]', '', NULL, '2024-04-26 13:04:19', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (36, '上传方式', 'upload_type', 1, NULL, NULL, NULL, 2, '[{\"label\":\"本地存储\",\"value\":\"1\"},{\"label\":\"阿里云\",\"value\":\"2\"},{\"label\":\"七牛云\",\"value\":\"3\"},{\"label\":\"腾讯云\",\"value\":\"4\"}]', NULL, '2023-12-12 11:35:51', '2023-12-14 14:49:22', 1, 1, 0);
INSERT INTO `erp_admin_options` VALUES (37, '标题对齐方式', 'label_type', 1, NULL, NULL, NULL, 2, '[{\"label\":\"顶对齐\",\"value\":\"form_top\"},{\"label\":\"左对齐\",\"value\":\"form_left\"},{\"label\":\"右对齐\",\"value\":\"form_right\"}]', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (38, '菜单类型', 'menu_type', 1, NULL, NULL, NULL, 2, '[{\"label\":\"目录\",\"value\":\"1\"},{\"value\":\"2\",\"label\":\"系统菜单\"},{\"value\":\"3\",\"label\":\"外部链接\"}]', NULL, '2023-12-14 13:35:54', NULL, 1, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (42, '后台角色', 'admin_role', 2, '/common/options/adminrole/', 'name', 'id', 2, '[]', NULL, '2023-12-14 16:16:48', '2024-01-03 12:01:38', 1, 1, 0);
INSERT INTO `erp_admin_options` VALUES (41, '日志分类', 'log_type', 1, '', '新增', '1', 2, '[{\"label\":\"新增\",\"value\":\"1\"},{\"label\":\"修改\",\"value\":\"2\"},{\"label\":\"删除\",\"value\":\"3\"},{\"label\":\"批量删除\",\"value\":\"4\"},{\"label\":\"详情\",\"value\":\"5\"},{\"label\":\"登录\",\"value\":\"6\"},{\"label\":\"导入\",\"value\":\"7\"},{\"label\":\"导出\",\"value\":\"8\"},{\"label\":\"错误\",\"value\":\"9\"}]', '', '2023-12-14 14:34:05', '2024-04-25 14:27:47', 1, 1, 0);
INSERT INTO `erp_admin_options` VALUES (52, '性别', 'sex', 1, NULL, NULL, NULL, 2, '[{\"label\":\"男\",\"value\":\"1\"},{\"label\":\"女\",\"value\":\"2\"},{\"label\":\"未知\",\"value\":\"3\"}]', NULL, '2023-12-19 12:12:26', NULL, 1, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (54, '缓存方式', 'cache_type', 1, NULL, NULL, NULL, 2, '[{\"label\":\"本地文件\",\"value\":\"1\"},{\"label\":\"redis\",\"value\":\"2\"}]', NULL, '2023-12-22 19:54:54', NULL, 1, NULL, 0);
INSERT INTO `erp_admin_options` VALUES (83, '流程状态', 'flow_status', 2, '/common/options/flowstatus/', 'label', 'value', 2, '[]', NULL, NULL, '2023-12-14 12:00:15', NULL, 1, 0);
INSERT INTO `erp_admin_options` VALUES (82, '流程分类', 'flow_cat', 3, '', 'name', 'id', 2, '[]', '', '2024-05-05 23:00:34', '2024-05-05 23:05:03', 1, 1, 23);

-- ----------------------------
-- Table structure for erp_admin_power
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_power`;
CREATE TABLE `erp_admin_power`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `mark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识(user=用户，role=角色，department=组织)',
  `mark_id` int(11) NULL DEFAULT NULL COMMENT '权限ID',
  `cat` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限类别(menu=菜单,button=按钮)',
  `cat_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '授权ID',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统权限' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for erp_admin_recycle
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_recycle`;
CREATE TABLE `erp_admin_recycle`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `table_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',
  `app` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用名称',
  `controller` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '控制器名称',
  `delete_json` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '删除内容',
  `delete_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除者IP',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 103 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据回收站' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for erp_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_role`;
CREATE TABLE `erp_admin_role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色编码',
  `home` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认首页',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  `notes` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_admin_role
-- ----------------------------
INSERT INTO `erp_admin_role` VALUES (33, '管理员', 'super', '/admin/workbench/index/', '2023-12-11 16:28:54', '2024-04-25 20:27:19', 1, 1, '22');
INSERT INTO `erp_admin_role` VALUES (34, '财务', 'caiwu', '/admin/workbench/index/', '2023-12-14 16:20:33', '2024-04-25 20:27:14', 1, 1, '');

-- ----------------------------
-- Table structure for erp_admin_setting
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_setting`;
CREATE TABLE `erp_admin_setting`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设置名称',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设置编码',
  `content` json NULL COMMENT '内容',
  `layout` json NULL COMMENT '布局',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 234 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户系统设置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_admin_setting
-- ----------------------------
INSERT INTO `erp_admin_setting` VALUES (1, NULL, '2024-01-05 11:53:23', NULL, 1, '系统设置', 'system', '{\"qiniu_id\": null, \"aliyun_id\": \"LTAI5tK77Cmv6qY2iBcxeg2c\", \"file_mine\": \"gif,jpg,p12,pem,png,jpeg\", \"file_size\": \"1500\", \"file_type\": \"2\", \"qcloud_id\": null, \"qiniu_url\": null, \"aliyun_url\": \"https://oss.ruinuocrm.com\", \"cache_type\": \"1\", \"file_local\": \"uploads\", \"qcloud_url\": null, \"redis_host\": \"127.0.0.1\", \"redis_pass\": \"890723\", \"redis_port\": \"6379\", \"system_jwt\": \"ruinuoqw_056jwt712_gd\", \"system_logo\": \"/storage/upload/20231222\\\\1d29cd16527575002890c81796288231.png\", \"system_name\": \"广州瑞诺科技有限公司\", \"qcloud_appid\": null, \"qiniu_bucket\": null, \"qiniu_secret\": null, \"aliyun_bucket\": \"nihaocesh\", \"aliyun_secret\": \"2W6fZ9Js6DR3DD16RxkUREQeD5ka83\", \"qcloud_bucket\": null, \"qcloud_region\": null, \"qcloud_secret\": null, \"aliyun_endpoint\": \"oss-cn-beijing.aliyuncs.com\"}', NULL);

-- ----------------------------
-- Table structure for erp_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `erp_admin_user`;
CREATE TABLE `erp_admin_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  `status` int(2) NULL DEFAULT 1 COMMENT '是否启用',
  `user` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `notes` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `role_ids` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属角色',
  `department_ids` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属组织',
  `upass` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `is_super` int(2) NULL DEFAULT 2 COMMENT '超级管理员',
  `path_id` int(11) NULL DEFAULT 0 COMMENT '我的上级',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_admin_user
-- ----------------------------
INSERT INTO `erp_admin_user` VALUES (1, NULL, '2024-04-23 14:18:21', NULL, 1, 1, 'admin', '总管理员', '15622276215', '后台总管理', '33', '10725', 'e10adc3949ba59abbe56e057f20f883e', 1, 0);
INSERT INTO `erp_admin_user` VALUES (3, '2024-04-21 11:54:33', '2024-04-25 14:28:38', 1, 1, 1, 'caiwu', '朱', '15622276214', '', '34', '10726', 'e10adc3949ba59abbe56e057f20f883e', 2, 0);

-- ----------------------------
-- Table structure for erp_ruinuo_app
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_app`;
CREATE TABLE `erp_ruinuo_app`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用编码',
  `notes` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '应用管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_app
-- ----------------------------
INSERT INTO `erp_ruinuo_app` VALUES (1, '低代码', 'ruinuo', '低代码', NULL, '2024-04-17 12:15:28', NULL, 0);
INSERT INTO `erp_ruinuo_app` VALUES (5, '后台管理', 'admin', '后台管理', '2024-04-07 11:14:44', '2024-04-17 12:15:21', 1, 0);

-- ----------------------------
-- Table structure for erp_ruinuo_button
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_button`;
CREATE TABLE `erp_ruinuo_button`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `mode_id` int(11) NULL DEFAULT 0 COMMENT '所属模块',
  `app_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应用编码',
  `mode_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块编码',
  `status` int(2) NULL DEFAULT 1 COMMENT '是否可用',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮名称',
  `position` int(2) NULL DEFAULT 1 COMMENT '按钮位置',
  `node` int(2) NULL DEFAULT 0 COMMENT '按钮节点',
  `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打开方式',
  `width` int(10) NULL DEFAULT 0 COMMENT '宽',
  `height` int(10) NULL DEFAULT 0 COMMENT '高',
  `action` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '方法名',
  `query` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数',
  `icon` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮图标',
  `sort` int(11) NULL DEFAULT 1 COMMENT '排序',
  `where` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示条件',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  `btn_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮样式',
  `is_drop` int(2) NULL DEFAULT 2 COMMENT '是否下拉',
  `is_admin` int(2) NULL DEFAULT 2 COMMENT '系统按钮',
  `is_power` int(2) NULL DEFAULT 2 COMMENT '是否设置权限',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 291 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '按钮管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_button
-- ----------------------------
INSERT INTO `erp_ruinuo_button` VALUES (126, 5, 'ruinuo', 'button', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-17 21:55:42', '2024-04-17 21:55:42', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (127, 5, 'ruinuo', 'button', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-17 21:55:42', '2024-04-17 21:55:42', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (128, 5, 'ruinuo', 'button', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-17 21:55:42', '2024-04-17 21:55:42', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (129, 5, 'ruinuo', 'button', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-17 21:55:42', '2024-04-17 21:55:42', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (130, 5, 'ruinuo', 'button', 2, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-17 21:55:42', '2024-04-17 21:55:42', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (131, 5, 'ruinuo', 'button', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-17 21:55:42', '2024-04-17 21:55:42', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (132, 5, 'ruinuo', 'button', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-17 21:55:42', '2024-04-17 21:55:42', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (133, 1, 'ruinuo', 'app', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-17 21:55:59', '2024-04-17 21:55:59', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (134, 1, 'ruinuo', 'app', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-17 21:55:59', '2024-04-17 21:55:59', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (135, 1, 'ruinuo', 'app', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-17 21:55:59', '2024-04-17 21:55:59', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (136, 1, 'ruinuo', 'app', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-17 21:55:59', '2024-04-17 21:55:59', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (137, 1, 'ruinuo', 'app', 2, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-17 21:55:59', '2024-04-17 21:55:59', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (138, 1, 'ruinuo', 'app', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-17 21:55:59', '2024-04-17 21:55:59', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (139, 1, 'ruinuo', 'app', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-17 21:55:59', '2024-04-17 21:55:59', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (140, 2, 'ruinuo', 'mode', 1, '新增', 1, 1, 'window', 1000, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-17 21:56:01', '2024-04-17 21:56:01', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (141, 2, 'ruinuo', 'mode', 1, '修改', 2, 1, 'window', 1000, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-17 21:56:01', '2024-04-17 21:56:01', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (142, 2, 'ruinuo', 'mode', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-17 21:56:01', '2024-04-17 21:56:01', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (143, 2, 'ruinuo', 'mode', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-17 21:56:01', '2024-04-17 21:56:01', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (144, 2, 'ruinuo', 'mode', 2, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-17 21:56:01', '2024-04-17 21:56:01', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (145, 2, 'ruinuo', 'mode', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-17 21:56:01', '2024-04-17 21:56:01', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (146, 2, 'ruinuo', 'mode', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-17 21:56:01', '2024-04-17 21:56:01', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (147, 3, 'ruinuo', 'form', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-17 21:56:03', '2024-04-17 21:56:03', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (148, 3, 'ruinuo', 'form', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-17 21:56:03', '2024-04-17 21:56:03', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (149, 3, 'ruinuo', 'form', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-17 21:56:03', '2024-04-17 21:56:03', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (150, 3, 'ruinuo', 'form', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-17 21:56:03', '2024-04-17 21:56:03', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (151, 3, 'ruinuo', 'form', 2, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-17 21:56:03', '2024-04-17 21:56:03', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (152, 3, 'ruinuo', 'form', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-17 21:56:03', '2024-04-17 21:56:03', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (153, 3, 'ruinuo', 'form', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-17 21:56:03', '2024-04-17 21:56:03', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (154, 4, 'ruinuo', 'lists', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-17 21:56:05', '2024-04-17 21:56:05', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (155, 4, 'ruinuo', 'lists', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-17 21:56:05', '2024-04-17 21:56:05', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (156, 4, 'ruinuo', 'lists', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-17 21:56:05', '2024-04-17 21:56:05', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (157, 4, 'ruinuo', 'lists', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-17 21:56:05', '2024-04-17 21:56:05', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (158, 4, 'ruinuo', 'lists', 2, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-17 21:56:05', '2024-04-17 21:56:05', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (159, 4, 'ruinuo', 'lists', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-17 21:56:05', '2024-04-17 21:56:05', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (160, 4, 'ruinuo', 'lists', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-17 21:56:05', '2024-04-17 21:56:05', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (161, 6, 'ruinuo', 'database', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-17 21:56:08', '2024-04-17 21:56:08', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (162, 6, 'ruinuo', 'database', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-17 21:56:08', '2024-04-17 21:56:08', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (163, 6, 'ruinuo', 'database', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-17 21:56:08', '2024-04-17 21:56:08', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (164, 6, 'ruinuo', 'database', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-17 21:56:08', '2024-04-17 21:56:08', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (165, 6, 'ruinuo', 'database', 2, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-17 21:56:08', '2024-04-17 21:56:08', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (166, 6, 'ruinuo', 'database', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-17 21:56:08', '2024-04-17 21:56:08', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (167, 6, 'ruinuo', 'database', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-17 21:56:08', '2024-04-17 21:56:08', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (168, 5, 'ruinuo', 'button', 1, '列表', 1, 2, NULL, 0, 0, 'lists', '', NULL, 8, NULL, '2024-04-17 21:59:25', '2024-04-17 21:59:25', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (170, 9, 'admin', 'user', 1, '新增', 1, 1, 'window', 700, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-17 22:26:44', '2024-04-17 22:26:44', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (171, 9, 'admin', 'user', 1, '修改', 2, 1, 'window', 700, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-17 22:26:44', '2024-04-17 22:26:44', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (172, 9, 'admin', 'user', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-17 22:26:44', '2024-04-17 22:26:44', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (173, 9, 'admin', 'user', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-17 22:26:44', '2024-04-17 22:26:44', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (174, 9, 'admin', 'user', 1, '查看', 2, 1, 'window', 700, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-17 22:26:44', '2024-04-17 22:26:44', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (175, 9, 'admin', 'user', 1, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-17 22:26:44', '2024-04-17 22:26:44', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (176, 9, 'admin', 'user', 1, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-17 22:26:44', '2024-04-17 22:26:44', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (177, 9, 'admin', 'user', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-17 22:26:44', '2024-04-17 22:26:44', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (178, 10, 'admin', 'menu', 1, '新增', 1, 1, 'window', 700, 700, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-17 22:33:49', '2024-04-17 22:33:49', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (179, 10, 'admin', 'menu', 1, '修改', 2, 1, 'window', 700, 700, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-17 22:33:49', '2024-04-17 22:33:49', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (180, 10, 'admin', 'menu', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-17 22:33:49', '2024-04-17 22:33:49', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (181, 10, 'admin', 'menu', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-17 22:33:49', '2024-04-17 22:33:49', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (182, 10, 'admin', 'menu', 1, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-17 22:33:49', '2024-04-17 22:33:49', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (183, 10, 'admin', 'menu', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-17 22:33:49', '2024-04-17 22:33:49', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (184, 10, 'admin', 'menu', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-17 22:33:49', '2024-04-17 22:33:49', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (185, 10, 'admin', 'menu', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-17 22:33:49', '2024-04-17 22:33:49', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (186, 3, 'ruinuo', 'form', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-17 23:08:02', '2024-04-17 23:08:02', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (187, 6, 'ruinuo', 'database', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-18 00:04:12', '2024-04-18 00:04:12', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (188, 1, 'ruinuo', 'app', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-18 00:04:24', '2024-04-18 00:04:24', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (189, 2, 'ruinuo', 'mode', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-18 00:04:27', '2024-04-18 00:04:27', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (190, 4, 'ruinuo', 'lists', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-18 00:04:37', '2024-04-18 00:04:37', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (191, 11, 'admin', 'role', 1, '新增', 1, 1, 'window', 700, 500, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-18 00:09:18', '2024-04-18 00:09:18', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (192, 11, 'admin', 'role', 1, '修改', 2, 1, 'window', 700, 500, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-18 00:09:18', '2024-04-18 00:09:18', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (193, 11, 'admin', 'role', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-18 00:09:18', '2024-04-18 00:09:18', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (194, 11, 'admin', 'role', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-18 00:09:18', '2024-04-18 00:09:18', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (195, 11, 'admin', 'role', 2, '查看', 2, 1, 'window', 700, 500, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-18 00:09:18', '2024-04-18 00:09:18', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (196, 11, 'admin', 'role', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-18 00:09:18', '2024-04-18 00:09:18', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (197, 11, 'admin', 'role', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-18 00:09:18', '2024-04-18 00:09:18', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (198, 11, 'admin', 'role', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-18 00:09:18', '2024-04-18 00:09:18', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (220, 14, 'admin', 'file', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-18 11:35:34', '2024-04-18 11:35:34', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (219, 14, 'admin', 'file', 1, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-18 11:35:34', '2024-04-18 11:35:34', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (218, 14, 'admin', 'file', 1, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-18 11:35:34', '2024-04-18 11:35:34', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (217, 14, 'admin', 'file', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-18 11:35:34', '2024-04-18 11:35:34', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (216, 14, 'admin', 'file', 2, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-18 11:35:34', '2024-04-18 11:35:34', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (215, 14, 'admin', 'file', 2, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-18 11:35:34', '2024-04-18 11:35:34', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (207, 13, 'admin', 'oldlog', 2, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (208, 13, 'admin', 'oldlog', 2, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (209, 13, 'admin', 'oldlog', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (210, 13, 'admin', 'oldlog', 1, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (211, 13, 'admin', 'oldlog', 1, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (212, 13, 'admin', 'oldlog', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (213, 13, 'admin', 'oldlog', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (214, 13, 'admin', 'oldlog', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (221, 14, 'admin', 'file', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-18 11:35:34', '2024-04-18 11:35:34', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (222, 14, 'admin', 'file', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-18 11:35:34', '2024-04-18 11:35:34', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (223, 15, 'ruinuo', 'setting', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (224, 15, 'ruinuo', 'setting', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (225, 15, 'ruinuo', 'setting', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (226, 15, 'ruinuo', 'setting', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (227, 15, 'ruinuo', 'setting', 1, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (228, 15, 'ruinuo', 'setting', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (229, 15, 'ruinuo', 'setting', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (230, 15, 'ruinuo', 'setting', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (231, 16, 'admin', 'department', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-22 09:18:18', '2024-04-22 09:18:18', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (232, 16, 'admin', 'department', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-22 09:18:18', '2024-04-22 09:18:18', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (233, 16, 'admin', 'department', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-22 09:18:18', '2024-04-22 09:18:18', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (234, 16, 'admin', 'department', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-22 09:18:18', '2024-04-22 09:18:18', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (235, 16, 'admin', 'department', 1, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-22 09:18:18', '2024-04-22 09:18:18', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (236, 16, 'admin', 'department', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-22 09:18:18', '2024-04-22 09:18:18', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (237, 16, 'admin', 'department', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-22 09:18:18', '2024-04-22 09:18:18', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (238, 16, 'admin', 'department', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-22 09:18:18', '2024-04-22 09:18:18', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (239, 19, 'admin', 'options', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (240, 19, 'admin', 'options', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (241, 19, 'admin', 'options', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (242, 19, 'admin', 'options', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (243, 19, 'admin', 'options', 1, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (244, 19, 'admin', 'options', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (245, 19, 'admin', 'options', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (246, 19, 'admin', 'options', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (247, 20, 'admin', 'recycle', 2, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-22 16:22:14', '2024-04-22 16:22:14', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (248, 20, 'admin', 'recycle', 2, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-22 16:22:14', '2024-04-22 16:22:14', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (249, 20, 'admin', 'recycle', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-22 16:22:14', '2024-04-22 16:22:14', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (250, 20, 'admin', 'recycle', 1, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-22 16:22:14', '2024-04-22 16:22:14', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (251, 20, 'admin', 'recycle', 1, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, '', '2024-04-22 16:22:14', '2024-04-25 12:24:36', NULL, 1, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (252, 20, 'admin', 'recycle', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-22 16:22:14', '2024-04-22 16:22:14', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (253, 20, 'admin', 'recycle', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-22 16:22:14', '2024-04-22 16:22:14', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (254, 20, 'admin', 'recycle', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-22 16:22:14', '2024-04-22 16:22:14', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (255, 21, 'admin', 'verify', 1, '新增', 1, 1, 'window', 0, 0, 'add', NULL, 'icon-add-bold', 1, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (256, 21, 'admin', 'verify', 1, '修改', 2, 1, 'window', 0, 0, 'edit', 'id={id}', 'icon-edit', 2, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL, 'btn_theme_1', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (257, 21, 'admin', 'verify', 1, '删除', 2, 1, 'ajax', 0, 0, 'delete', 'id={id}', 'icon-ashbin', 3, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (258, 21, 'admin', 'verify', 2, '批量删除', 1, 1, 'ajax', 0, 0, 'alldelete', 'ids={id}', 'icon-ashbin', 4, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL, 'btn_theme_2', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (259, 21, 'admin', 'verify', 1, '查看', 2, 1, 'window', 0, 0, 'detail', 'id={id}', 'icon-search', 5, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL, 'btn_theme_4', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (260, 21, 'admin', 'verify', 2, '导入', 1, 1, 'window', 0, 0, 'inexcel', NULL, 'icon-rising1', 6, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (261, 21, 'admin', 'verify', 2, '导出', 1, 1, 'ajax', 0, 0, 'outexcel', NULL, 'icon-sign-out', 7, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL, 'btn_theme_0', 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (262, 21, 'admin', 'verify', 1, '列表', 1, 2, NULL, 0, 0, 'lists', NULL, NULL, 8, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL, NULL, 2, 1, 2);
INSERT INTO `erp_ruinuo_button` VALUES (263, 6, 'ruinuo', 'database', 1, '同步', 1, 1, 'ajax', 0, 0, 'sync', '', 'icon-ccaozuo', 10, '', '2024-04-22 16:42:27', '2024-04-22 16:43:14', 1, 1, 'btn_theme_4', 2, 2, 2);
INSERT INTO `erp_ruinuo_button` VALUES (264, 2, 'ruinuo', 'mode', 1, '生成代码', 2, 1, 'ajax', 0, 0, 'filecode', 'id={id}', 'icon-ccaozuo', 4, '', '2024-04-22 16:45:44', '2024-04-22 16:45:44', 1, 1, 'btn_theme_4', 2, 2, 2);
INSERT INTO `erp_ruinuo_button` VALUES (273, 20, 'admin', 'recycle', 1, '恢复', 2, 1, 'ajax', 0, 0, 'restore', 'id={id}', '', 10, '', '2024-04-25 11:22:49', '2024-04-25 11:24:37', 1, 1, 'btn_theme_5', 2, 2, 2);
INSERT INTO `erp_ruinuo_button` VALUES (274, 6, 'ruinuo', 'database', 1, '同步', 2, 1, 'ajax', 0, 0, 'sync', 'table_name={name}', 'icon-ccaozuo', 10, '', '2024-04-27 14:47:14', '2024-04-27 14:48:22', 1, 1, 'btn_theme_4', 2, 2, 2);

-- ----------------------------
-- Table structure for erp_ruinuo_control
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_control`;
CREATE TABLE `erp_ruinuo_control`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` int(11) NULL DEFAULT 0 COMMENT '上级ID',
  `is_cat` int(11) NULL DEFAULT 2 COMMENT '是否分类',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
  `is_table` int(2) NULL DEFAULT 2 COMMENT '表格启用',
  `sort` int(10) NULL DEFAULT NULL COMMENT '排序',
  `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
  `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '属性配置',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 54 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设计控件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_control
-- ----------------------------
INSERT INTO `erp_ruinuo_control` VALUES (1, 0, 1, '输入框组件', NULL, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (2, 0, 1, '选择框组件', NULL, 2, 2, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (3, 0, 1, '布局组件', NULL, 2, 3, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (4, 0, 1, '高级组件', NULL, 2, 4, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (6, 1, 2, '单行文本', 'input', 1, 1, 'icon-input', 'field,title,hide_label,placeholder,value,col,readonly,hide,required,only,verify,prefix,suffix,group_prefix,group_suffix,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (7, 1, 2, '数字步进器', 'number', 1, 2, 'icon-shuzi', 'field,title,hide_label,placeholder,value,col,readonly,hide,required,only,verify,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (8, 1, 2, '手机', 'phone', 2, 3, 'icon-shouji1', 'field,title,hide_label,placeholder,value,col,readonly,hide,required,only,verify,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (9, 1, 2, '邮箱', 'email', 2, 4, 'icon-youxiang', 'field,title,hide_label,placeholder,value,col,readonly,hide,required,only,verify,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (10, 1, 2, '密码', 'password', 2, 5, 'icon-mima', 'field,title,hide_label,placeholder,value,col,readonly,required,verify,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (11, 1, 2, '多行文本', 'textarea', 1, 7, 'icon-textarea', 'field,title,hide_label,placeholder,value,col,height,follow,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (12, 1, 2, '标签输入', 'tags', 2, 6, 'icon-Tags', 'field,title,hide_label,placeholder,value,col,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (13, 1, 2, '编辑器', 'htmledit', 2, 8, 'icon-fuwenben', 'field,title,hide_label,value,col,height,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (14, 2, 2, '单选框', 'radio', 2, 1, 'icon-danxuankuang', 'field,title,hide_label,value,col,readonly,hide,required,options_num,help,event_val', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (15, 2, 2, '复选框', 'checkbox', 2, 2, 'icon-fuxuankuang', 'field,title,hide_label,value,col,readonly,hide,required,options_num,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (16, 2, 2, '开关', 'switch', 1, 3, 'icon-kaiguan', 'field,title,hide_label,value,col,text,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (17, 2, 2, '下拉框', 'select', 1, 4, 'icon-a-ziyuan30', 'field,title,hide_label,value,col,is_all,readonly,hide,required,only,options_num,help,event_val', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (18, 2, 2, '级联选择', 'cascader', 2, 5, 'icon-leftalignment', 'field,title,hide_label,value,col,is_all,readonly,hide,required,only,options_num,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (19, 2, 2, '树形下拉', 'tree', 2, 6, 'icon-siji', 'field,title,hide_label,value,col,is_all,readonly,hide,required,only,options_num,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (20, 2, 2, '日期选择', 'datetime', 1, 7, 'icon-riqi', 'field,title,hide_label,date_cat,placeholder,value,col,range,range_field,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (21, 2, 2, '颜色选择', 'color', 2, 8, 'icon-yanseziduan', 'field,title,hide_label,placeholder,value,col,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (22, 2, 2, '图标选择', 'icon', 2, 9, 'icon-vehivles', 'field,title,hide_label,value,col,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (23, 2, 2, '评分选择', 'rate', 2, 10, 'icon-tags', 'field,title,hide_label,placeholder,value,col,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (24, 2, 2, '滑块', 'slider', 2, 11, 'icon-m-huakuaikongjian', 'field,title,hide_label,value,col,min_val,max_val,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (25, 2, 2, '图片上传', 'upimg', 1, 13, 'icon-tupianshangchuan', 'field,title,hide_label,value,hide,col,hide,required,file_num,file_type,file_select,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (26, 2, 2, '文件上传', 'upfile', 1, 14, 'icon-yunshangchuan_o', 'field,title,hide_label,value,hide,col,hide,required,file_num,file_type,file_select,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (28, 3, 2, '栅格布局', 'grid', 2, 1, 'icon-keshihuapingtaiicon_zhagebuju', 'children,col', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (29, 3, 2, 'Tab布局', 'tab', 2, 2, 'icon-tabye', 'children,col', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (30, 3, 2, '卡片布局', 'card', 2, 3, 'icon-kapian', 'title,col,hide', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (31, 4, 2, '数组子表', 'jsontable', 2, 1, 'icon-24gl-table', 'field,title,hide_label,value,col,choose_url,is_all,database,database_field,is_curd,required,help,cols', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (32, 4, 2, '关联模型', 'subtable', 2, 2, 'icon-mokuai', 'title,hide_label,mode_id,mode_sub_id,mode_sub_post,is_curd,col,required,help,cols', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (34, 4, 2, '自动编号', 'ordernum', 2, 5, 'icon-bianhao', 'field,title,num_rule', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (35, 4, 2, '条形码', 'barcode', 2, 6, 'icon-tiaoxingma', 'title,hide_label,code_field,col,max_width', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (36, 4, 2, '二维码', 'qrcode', 2, 7, 'icon-31erweima', 'title,hide_label,code_field,col,max_width', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (37, 4, 2, '地图定位', 'map', 2, 8, 'icon-didiandingwei_o', 'field,title,hide_label,placeholder,value,col,readonly,hide,required,only,verify,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (39, 3, 2, '文本提示', 'tips', 2, 6, 'icon-tishi', 'content,col', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (41, 3, 2, '分割标题', 'legend', 2, 7, 'icon-biaoti', 'content', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (42, 3, 2, 'FLEX布局', 'flex', 2, 4, 'icon-html', 'col', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (44, 4, 2, '他表字段', 'openselect', 2, 3, 'icon-mokuai', 'field,title,hide_label,col,open_url,is_all,hide,required,only,verify,help,event_val', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (45, 1, 2, 'Markdown', 'markdown', 2, 9, 'icon-fuwenben', 'field,title,hide_label,value,col,height,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (46, 4, 2, '公式', 'gongshi', 2, 9, 'icon-didiandingwei_o', 'field,title,hide_label,gongshi_txt,placeholder,col,verify,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (51, 4, 2, '关联记录', 'choosetable', 2, 2, 'icon-mokuai', 'field,title,hide_label,mode_id,col,required,is_all,help,cols', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (52, 2, 2, '日期多选', 'dateall', 2, 9, 'icon-vehivles', 'field,title,hide_label,value,col,readonly,hide,required,help', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_control` VALUES (53, 2, 2, '树形选择', 'showtree', 1, 4, 'icon-a-ziyuan30', 'field,title,hide_label,value,col,is_all,readonly,hide,required,only,options_num,help,event_val', NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for erp_ruinuo_database
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_database`;
CREATE TABLE `erp_ruinuo_database`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',
  `old_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '旧表名',
  `comment` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注释',
  `engine` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '引擎',
  `rows` int(11) NULL DEFAULT NULL COMMENT '记录数',
  `collation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字符集',
  `field` json NULL COMMENT '字段',
  `field_num` int(11) NULL DEFAULT NULL COMMENT '字段数',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1001 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模型管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_database
-- ----------------------------
INSERT INTO `erp_ruinuo_database` VALUES (975, 'ruinuo_verify', 'ruinuo_verify', '验证管理', 'InnoDB', 21, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"guize\", \"title\": \"验证规则\", \"length\": \"500\", \"default\": null, \"old_field\": \"guize\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 8, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (977, 'admin_department', 'admin_department', '组织机构', 'InnoDB', 3, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"组织名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"组织编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"type\", \"title\": \"组织类型\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"type\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"sort\", \"title\": \"排序\", \"length\": \"11\", \"default\": \"1\", \"old_field\": \"sort\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"tel\", \"title\": \"电话\", \"length\": \"100\", \"default\": null, \"old_field\": \"tel\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"notes\", \"title\": \"备注\", \"length\": \"500\", \"default\": null, \"old_field\": \"notes\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"parent_id\", \"title\": \"上级\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"parent_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"address\", \"title\": \"地址\", \"length\": \"200\", \"default\": null, \"old_field\": \"address\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"facsimile\", \"title\": \"传真\", \"length\": \"50\", \"default\": null, \"old_field\": \"facsimile\"}]', 14, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (978, 'admin_file', 'admin_file', '附件管理', 'InnoDB', 28, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"文件名称\", \"length\": \"500\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"size\", \"title\": \"文件大小\", \"length\": \"50\", \"default\": null, \"old_field\": \"size\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"mime\", \"title\": \"文件类型\", \"length\": \"50\", \"default\": null, \"old_field\": \"mime\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"type\", \"title\": \"上传方式\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"type\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"url\", \"title\": \"存储路径\", \"length\": \"500\", \"default\": null, \"old_field\": \"url\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"source_url\", \"title\": \"来源url\", \"length\": \"500\", \"default\": null, \"old_field\": \"source_url\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 11, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (979, 'admin_log', 'admin_log', '系统日志', 'InnoDB', 1452, 'utf8mb4_unicode_ci', '[{\"key\": 2, \"type\": \"bigint\", \"field\": \"id\", \"title\": \"表id\", \"length\": \"20\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"type\", \"title\": \"日志类别\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"type\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"module\", \"title\": \"模块\", \"length\": \"50\", \"default\": null, \"old_field\": \"module\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"controller\", \"title\": \"控制器\", \"length\": \"50\", \"default\": null, \"old_field\": \"controller\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"action\", \"title\": \"方法\", \"length\": \"50\", \"default\": null, \"old_field\": \"action\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"method\", \"title\": \"请求方式\", \"length\": \"50\", \"default\": null, \"old_field\": \"method\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"url\", \"title\": \"请求地址\", \"length\": \"100\", \"default\": null, \"old_field\": \"url\"}, {\"key\": 2, \"type\": \"longtext\", \"field\": \"post_data\", \"title\": \"POST数据\", \"length\": 0, \"default\": null, \"old_field\": \"post_data\"}, {\"key\": 2, \"type\": \"longtext\", \"field\": \"get_data\", \"title\": \"GET数据\", \"length\": 0, \"default\": null, \"old_field\": \"get_data\"}, {\"key\": 2, \"type\": \"longtext\", \"field\": \"headers\", \"title\": \"头部信息\", \"length\": 0, \"default\": null, \"old_field\": \"headers\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"ip\", \"title\": \"ip地址\", \"length\": \"30\", \"default\": null, \"old_field\": \"ip\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"content\", \"title\": \"日志内容\", \"length\": 0, \"default\": null, \"old_field\": \"content\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"agent\", \"title\": \"请求头\", \"length\": 0, \"default\": null, \"old_field\": \"agent\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 17, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (995, 'ruinuo_setting', 'ruinuo_setting', '配置管理', 'MyISAM', 1, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"配置名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"配置编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"group_num\", \"title\": \"分组编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"group_num\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"fields\", \"title\": \"字段配置\", \"length\": 0, \"default\": null, \"old_field\": \"fields\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"values\", \"title\": \"数据值\", \"length\": 0, \"default\": null, \"old_field\": \"values\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"layout\", \"title\": \"布局\", \"length\": 0, \"default\": null, \"old_field\": \"layout\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"form_label\", \"title\": \"label对齐方式\", \"length\": \"50\", \"default\": null, \"old_field\": \"form_label\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"label_width\", \"title\": \"label宽度\", \"length\": \"2\", \"default\": \"0\", \"old_field\": \"label_width\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_system\", \"title\": \"是否系统\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_system\"}]', 14, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, 1);
INSERT INTO `erp_ruinuo_database` VALUES (994, 'ruinuo_mode', 'ruinuo_mode', '模块管理', 'InnoDB', 16, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"app_id\", \"title\": \"归属应用\", \"length\": \"11\", \"default\": null, \"old_field\": \"app_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"notes\", \"title\": \"备注\", \"length\": \"500\", \"default\": null, \"old_field\": \"notes\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"database\", \"title\": \"数据表\", \"length\": \"100\", \"default\": null, \"old_field\": \"database\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"sub_database\", \"title\": \"关联子表\", \"length\": 0, \"default\": null, \"old_field\": \"sub_database\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 11, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (992, 'ruinuo_form', 'ruinuo_form', '表单管理', 'MyISAM', 16, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"mode_id\", \"title\": \"所属模块\", \"length\": \"11\", \"default\": null, \"old_field\": \"mode_id\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"layout\", \"title\": \"布局\", \"length\": 0, \"default\": null, \"old_field\": \"layout\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"power_field\", \"title\": \"字段权限\", \"length\": 0, \"default\": null, \"old_field\": \"power_field\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"onclick\", \"title\": \"事件\", \"length\": 0, \"default\": null, \"old_field\": \"onclick\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"width\", \"title\": \"宽\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"width\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"height\", \"title\": \"高\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"height\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"form_label\", \"title\": \"label对齐方式\", \"length\": \"50\", \"default\": null, \"old_field\": \"form_label\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"label_width\", \"title\": \"label宽度\", \"length\": \"2\", \"default\": \"0\", \"old_field\": \"label_width\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"type\", \"title\": \"表单归属1为模块，2为配置\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"type\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"head_img\", \"title\": \"顶部图片\", \"length\": \"500\", \"default\": null, \"old_field\": \"head_img\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"notes\", \"title\": \"表单说明\", \"length\": \"500\", \"default\": null, \"old_field\": \"notes\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 16, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (993, 'ruinuo_lists', 'ruinuo_lists', '列表管理', 'MyISAM', 16, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"mode_id\", \"title\": \"所属控制器\", \"length\": \"11\", \"default\": null, \"old_field\": \"mode_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"sort\", \"title\": \"排序\", \"length\": \"11\", \"default\": \"1\", \"old_field\": \"sort\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"table_cols\", \"title\": \"表格字段\", \"length\": 0, \"default\": null, \"old_field\": \"table_cols\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"set_where\", \"title\": \"查询条件\", \"length\": 0, \"default\": null, \"old_field\": \"set_where\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"order_raw\", \"title\": \"排序\", \"length\": \"200\", \"default\": null, \"old_field\": \"order_raw\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"style\", \"title\": \"风格\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"style\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"page_num\", \"title\": \"每页显示数量\", \"length\": \"11\", \"default\": null, \"old_field\": \"page_num\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"power_field\", \"title\": \"权限字段\", \"length\": 0, \"default\": null, \"old_field\": \"power_field\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"power_role\", \"title\": \"通用角色权限\", \"length\": 0, \"default\": null, \"old_field\": \"power_role\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"power_department\", \"title\": \"通用部门权限\", \"length\": 0, \"default\": null, \"old_field\": \"power_department\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"tree_field\", \"title\": \"树形字段\", \"length\": \"50\", \"default\": null, \"old_field\": \"tree_field\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"tree_show_field\", \"title\": \"树形显示字段\", \"length\": \"50\", \"default\": null, \"old_field\": \"tree_show_field\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_left\", \"title\": \"开启左侧\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_left\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"left_title\", \"title\": \"左侧标题\", \"length\": \"50\", \"default\": null, \"old_field\": \"left_title\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"left_key_field\", \"title\": \"左侧主键字段\", \"length\": \"255\", \"default\": null, \"old_field\": \"left_key_field\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"left_show_field\", \"title\": \"左侧显示字段\", \"length\": \"255\", \"default\": null, \"old_field\": \"left_show_field\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"left_field\", \"title\": \"左侧关联字段\", \"length\": \"50\", \"default\": null, \"old_field\": \"left_field\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"left_type\", \"title\": \"左侧关联方式\", \"length\": \"2\", \"default\": null, \"old_field\": \"left_type\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"left_options\", \"title\": \"左侧关联数据源\", \"length\": \"50\", \"default\": null, \"old_field\": \"left_options\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"left_mode\", \"title\": \"左侧关联模块\", \"length\": \"11\", \"default\": null, \"old_field\": \"left_mode\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 27, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (990, 'ruinuo_control', 'ruinuo_control', '设计控件', 'MyISAM', 43, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"parent_id\", \"title\": \"上级ID\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"parent_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_cat\", \"title\": \"是否分类\", \"length\": \"11\", \"default\": \"2\", \"old_field\": \"is_cat\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_table\", \"title\": \"表格启用\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_table\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"sort\", \"title\": \"排序\", \"length\": \"10\", \"default\": null, \"old_field\": \"sort\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"icon\", \"title\": \"图标\", \"length\": \"50\", \"default\": null, \"old_field\": \"icon\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"config\", \"title\": \"属性配置\", \"length\": 0, \"default\": null, \"old_field\": \"config\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 13, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (991, 'ruinuo_database', 'ruinuo_database', '模型管理', 'MyISAM', 26, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"表名\", \"length\": \"100\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"old_name\", \"title\": \"旧表名\", \"length\": \"100\", \"default\": null, \"old_field\": \"old_name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"comment\", \"title\": \"注释\", \"length\": \"50\", \"default\": null, \"old_field\": \"comment\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"engine\", \"title\": \"引擎\", \"length\": \"50\", \"default\": null, \"old_field\": \"engine\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"rows\", \"title\": \"记录数\", \"length\": \"11\", \"default\": null, \"old_field\": \"rows\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"collation\", \"title\": \"字符集\", \"length\": \"50\", \"default\": null, \"old_field\": \"collation\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"field\", \"title\": \"字段\", \"length\": 0, \"default\": null, \"old_field\": \"field\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"field_num\", \"title\": \"字段数\", \"length\": \"11\", \"default\": null, \"old_field\": \"field_num\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"更新时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 13, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (989, 'ruinuo_button', 'ruinuo_button', '按钮管理', 'MyISAM', 132, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"mode_id\", \"title\": \"所属模块\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"mode_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"app_num\", \"title\": \"应用编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"app_num\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"mode_num\", \"title\": \"模块编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"mode_num\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"status\", \"title\": \"是否可用\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"status\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"title\", \"title\": \"按钮名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"title\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"position\", \"title\": \"按钮位置\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"position\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"node\", \"title\": \"按钮节点\", \"length\": \"2\", \"default\": \"0\", \"old_field\": \"node\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"type\", \"title\": \"打开方式\", \"length\": \"20\", \"default\": null, \"old_field\": \"type\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"width\", \"title\": \"宽\", \"length\": \"10\", \"default\": \"0\", \"old_field\": \"width\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"height\", \"title\": \"高\", \"length\": \"10\", \"default\": \"0\", \"old_field\": \"height\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"action\", \"title\": \"方法名\", \"length\": \"200\", \"default\": null, \"old_field\": \"action\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"query\", \"title\": \"参数\", \"length\": \"500\", \"default\": null, \"old_field\": \"query\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"icon\", \"title\": \"按钮图标\", \"length\": \"500\", \"default\": null, \"old_field\": \"icon\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"sort\", \"title\": \"排序\", \"length\": \"11\", \"default\": \"1\", \"old_field\": \"sort\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"where\", \"title\": \"显示条件\", \"length\": \"1000\", \"default\": null, \"old_field\": \"where\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"btn_class\", \"title\": \"按钮样式\", \"length\": \"50\", \"default\": null, \"old_field\": \"btn_class\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_drop\", \"title\": \"是否下拉\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_drop\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_admin\", \"title\": \"系统按钮\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_admin\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_power\", \"title\": \"是否设置权限\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_power\"}]', 24, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (988, 'ruinuo_app', 'ruinuo_app', '应用管理', 'InnoDB', 2, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"应用名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"应用编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"notes\", \"title\": \"备注\", \"length\": \"100\", \"default\": null, \"old_field\": \"notes\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 8, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (980, 'admin_menu', 'admin_menu', '菜单管理', 'MyISAM', 19, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"title\", \"title\": \"名称\", \"length\": \"200\", \"default\": null, \"old_field\": \"title\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"icon\", \"title\": \"图标\", \"length\": \"100\", \"default\": null, \"old_field\": \"icon\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"href\", \"title\": \"外部链接\", \"length\": \"200\", \"default\": null, \"old_field\": \"href\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"open_type\", \"title\": \"打开方式\", \"length\": \"50\", \"default\": null, \"old_field\": \"open_type\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"parent_id\", \"title\": \"上级\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"parent_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"type\", \"title\": \"类型\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"type\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"sort\", \"title\": \"排序\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"sort\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_admin\", \"title\": \"后台菜单\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_admin\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"app\", \"title\": \"应用\", \"length\": \"255\", \"default\": null, \"old_field\": \"app\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"controller\", \"title\": \"控制器\", \"length\": \"255\", \"default\": null, \"old_field\": \"controller\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"action\", \"title\": \"方法\", \"length\": \"255\", \"default\": null, \"old_field\": \"action\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"query\", \"title\": \"参数\", \"length\": \"255\", \"default\": null, \"old_field\": \"query\"}]', 17, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (981, 'admin_options', 'admin_options', '字典管理', 'MyISAM', 32, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"type\", \"title\": \"类型\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"type\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"url\", \"title\": \"链接地址\", \"length\": \"500\", \"default\": null, \"old_field\": \"url\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"label\", \"title\": \"显示字段\", \"length\": \"100\", \"default\": null, \"old_field\": \"label\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"value\", \"title\": \"保存字段\", \"length\": \"100\", \"default\": null, \"old_field\": \"value\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_token\", \"title\": \"是否验证token\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_token\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"config\", \"title\": \"配置\", \"length\": 0, \"default\": null, \"old_field\": \"config\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"notes\", \"title\": \"备注\", \"length\": \"200\", \"default\": null, \"old_field\": \"notes\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"mode_id\", \"title\": \"选择模块\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"mode_id\"}]', 15, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (982, 'admin_power', 'admin_power', '系统权限', 'InnoDB', 7, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"mark\", \"title\": \"权限标识(user=用户，role=角色，department=组织)\", \"length\": \"50\", \"default\": null, \"old_field\": \"mark\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"mark_id\", \"title\": \"权限ID\", \"length\": \"11\", \"default\": null, \"old_field\": \"mark_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"cat\", \"title\": \"权限类别(menu=菜单,button=按钮)\", \"length\": \"20\", \"default\": null, \"old_field\": \"cat\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"cat_ids\", \"title\": \"授权ID\", \"length\": 0, \"default\": null, \"old_field\": \"cat_ids\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 9, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (983, 'admin_recycle', 'admin_recycle', '数据回收站', 'InnoDB', 99, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"table_name\", \"title\": \"表名\", \"length\": \"100\", \"default\": null, \"old_field\": \"table_name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"app\", \"title\": \"应用名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"app\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"controller\", \"title\": \"控制器名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"controller\"}, {\"key\": 2, \"type\": \"text\", \"field\": \"delete_json\", \"title\": \"删除内容\", \"length\": 0, \"default\": null, \"old_field\": \"delete_json\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"delete_ip\", \"title\": \"删除者IP\", \"length\": \"50\", \"default\": null, \"old_field\": \"delete_ip\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}]', 10, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (984, 'admin_role', 'admin_role', '系统角色', 'InnoDB', 2, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"角色名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"num\", \"title\": \"角色编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"num\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"home\", \"title\": \"默认首页\", \"length\": \"200\", \"default\": null, \"old_field\": \"home\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"notes\", \"title\": \"备注\", \"length\": \"500\", \"default\": null, \"old_field\": \"notes\"}]', 9, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (985, 'admin_setting', 'admin_setting', '商户系统设置', 'MyISAM', 1, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"设置名称\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"code\", \"title\": \"设置编码\", \"length\": \"50\", \"default\": null, \"old_field\": \"code\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"content\", \"title\": \"内容\", \"length\": 0, \"default\": null, \"old_field\": \"content\"}, {\"key\": 2, \"type\": \"json\", \"field\": \"layout\", \"title\": \"布局\", \"length\": 0, \"default\": null, \"old_field\": \"layout\"}]', 9, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);
INSERT INTO `erp_ruinuo_database` VALUES (986, 'admin_user', 'admin_user', '后台用户', 'InnoDB', 2, 'utf8_general_ci', '[{\"key\": 2, \"type\": \"int\", \"field\": \"id\", \"title\": \"主键\", \"length\": \"11\", \"default\": null, \"old_field\": \"id\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"create_time\", \"title\": \"新增时间\", \"length\": 0, \"default\": null, \"old_field\": \"create_time\"}, {\"key\": 2, \"type\": \"datetime\", \"field\": \"update_time\", \"title\": \"修改时间\", \"length\": 0, \"default\": null, \"old_field\": \"update_time\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"create_id\", \"title\": \"新增人\", \"length\": \"11\", \"default\": null, \"old_field\": \"create_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"update_id\", \"title\": \"修改人\", \"length\": \"11\", \"default\": null, \"old_field\": \"update_id\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"status\", \"title\": \"是否启用\", \"length\": \"2\", \"default\": \"1\", \"old_field\": \"status\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"user\", \"title\": \"账号\", \"length\": \"100\", \"default\": null, \"old_field\": \"user\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"name\", \"title\": \"姓名\", \"length\": \"50\", \"default\": null, \"old_field\": \"name\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"phone\", \"title\": \"手机号\", \"length\": \"50\", \"default\": null, \"old_field\": \"phone\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"notes\", \"title\": \"备注\", \"length\": \"500\", \"default\": null, \"old_field\": \"notes\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"role_ids\", \"title\": \"所属角色\", \"length\": \"500\", \"default\": null, \"old_field\": \"role_ids\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"department_ids\", \"title\": \"所属组织\", \"length\": \"500\", \"default\": null, \"old_field\": \"department_ids\"}, {\"key\": 2, \"type\": \"varchar\", \"field\": \"upass\", \"title\": \"密码\", \"length\": \"50\", \"default\": null, \"old_field\": \"upass\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"is_super\", \"title\": \"超级管理员\", \"length\": \"2\", \"default\": \"2\", \"old_field\": \"is_super\"}, {\"key\": 2, \"type\": \"int\", \"field\": \"path_id\", \"title\": \"我的上级\", \"length\": \"11\", \"default\": \"0\", \"old_field\": \"path_id\"}]', 15, '2024-05-10 16:44:56', '2024-05-10 16:44:57', 1, NULL);

-- ----------------------------
-- Table structure for erp_ruinuo_form
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_form`;
CREATE TABLE `erp_ruinuo_form`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `mode_id` int(11) NULL DEFAULT NULL COMMENT '所属模块',
  `layout` json NULL COMMENT '布局',
  `power_field` json NULL COMMENT '字段权限',
  `onclick` json NULL COMMENT '事件',
  `width` int(11) NULL DEFAULT 0 COMMENT '宽',
  `height` int(11) NULL DEFAULT 0 COMMENT '高',
  `form_label` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'label对齐方式',
  `label_width` int(2) NULL DEFAULT 0 COMMENT 'label宽度',
  `type` int(2) NULL DEFAULT 1 COMMENT '表单归属1为模块，2为配置',
  `head_img` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '顶部图片',
  `notes` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单说明',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '表单管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_form
-- ----------------------------
INSERT INTO `erp_ruinuo_form` VALUES (1, 1, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"应用名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"13f2_1713145864323_55854\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"num\", \"title\": \"应用编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalpha\", \"elem_id\": \"527f_1713145865429_47652\", \"is_edit\": \"2\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"textarea\", \"help\": \"\", \"hide\": \"2\", \"field\": \"notes\", \"title\": \"备注\", \"value\": \"\", \"follow\": \"2\", \"height\": \"100\", \"elem_id\": \"1aca_1713145867771_56999\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', '[{\"add\": \"\", \"edit\": 1, \"field\": \"num\", \"detail\": \"\", \"role_ids\": \"\", \"user_ids\": \"\", \"department_ids\": \"\"}]', NULL, 700, 500, 'form_right', 0, 1, NULL, NULL, '2024-04-10 10:11:31', '2024-04-22 01:09:11', 1, 1);
INSERT INTO `erp_ruinuo_form` VALUES (2, 2, '[{\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"app_id\", \"title\": \"归属应用\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"80a9_1713158330350_51485\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"app_list\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"917e_1713158347824_39535\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"num\", \"title\": \"编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalpha\", \"elem_id\": \"6436_1713158348892_72953\", \"is_edit\": \"2\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"database\", \"title\": \"数据表\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"63c5_1713158381818_24279\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"database_list\"}, {\"tag\": \"legend\", \"content\": \"关联多表\", \"elem_id\": \"7c22_1713539549762_12296\"}, {\"col\": \"12\", \"tag\": \"tips\", \"content\": \"别名：重新定义一个简短的英文名，切记不要同字段名<br>\\n用途：只支持一对一正向或反向关联，可用于列表关联查询显示，也可用于表单关联存储<br>\\n重要：只有正向关联才可以实现关联删除\", \"elem_id\": \"3879_1713539527439_00372\"}, {\"col\": \"12\", \"tag\": \"jsontable\", \"cols\": [{\"field\": \"database\", \"title\": \"选择数据库\", \"width\": \"\", \"update\": \"select\", \"options\": \"database_list\", \"minWidth\": 160, \"required\": 1, \"options_num\": \"mode_list\"}, {\"field\": \"alias\", \"title\": \"别名\", \"update\": \"input\", \"minWidth\": 160, \"required\": 1}, {\"field\": \"type\", \"title\": \"与模型表关系\", \"width\": \"\", \"update\": \"select\", \"options\": \"guanlian_type\", \"minWidth\": 160, \"required\": 1, \"options_num\": \"guanlian_type\"}, {\"field\": \"sub_field\", \"title\": \"子表字段\", \"update\": \"input\", \"minWidth\": 160, \"required\": 1}, {\"field\": \"key_field\", \"title\": \"主表字段\", \"update\": \"input\", \"minWidth\": 160, \"required\": 1}], \"help\": \"\", \"hide\": \"2\", \"field\": \"sub_database\", \"title\": \"关联子表\", \"value\": \"\", \"elem_id\": \"9f03_1713158471976_70256\", \"required\": \"2\", \"hide_label\": \"1\"}]', '[{\"add\": \"\", \"edit\": 1, \"field\": \"num\", \"detail\": \"\", \"role_ids\": \"\", \"user_ids\": \"\", \"department_ids\": \"\"}]', NULL, 1000, 0, 'form_right', 0, 1, NULL, '', '2024-04-10 10:24:06', '2024-04-22 01:07:28', 1, 1);
INSERT INTO `erp_ruinuo_form` VALUES (3, 3, '[{\"tag\": \"legend\", \"content\": \"基础设置\", \"elem_id\": \"40ed_1713681524526_91964\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"width\", \"title\": \"弹窗宽度\", \"value\": \"0\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isinteger\", \"elem_id\": \"5697_1713189836321_73930\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"height\", \"title\": \"弹窗高度\", \"value\": \"0\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isinteger\", \"elem_id\": \"2757_1713189852143_50514\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"form_label\", \"title\": \"标题对齐\", \"value\": \"form_right\", \"is_all\": \"2\", \"elem_id\": \"89a8_1713189860044_16759\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"label_type\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"label_width\", \"title\": \"标题宽度\", \"value\": \"0\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isinteger\", \"elem_id\": \"91cb_1713189888866_88658\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"tag\": \"legend\", \"content\": \"字段权限\", \"elem_id\": \"8fe6_1713678055082_76044\"}, {\"col\": \"12\", \"tag\": \"tips\", \"content\": \"1、默认有表单对应权限的所有人可以新增、编辑、查看<br>\\n2、不可新增、编辑、查看权限没有打开的时候，则对应的权限无效<br>\\n3、相应的授权没有设置的时候，则所有人都不可操作\", \"elem_id\": \"466a_1713678299201_19542\"}, {\"col\": \"12\", \"tag\": \"jsontable\", \"cols\": [{\"field\": \"field\", \"title\": \"字段\", \"update\": \"input\", \"options\": \"\", \"minWidth\": 160, \"required\": 1}, {\"field\": \"add\", \"title\": \"不可新增\", \"width\": \"90\", \"update\": \"switch\", \"minWidth\": \"90\"}, {\"field\": \"edit\", \"title\": \"不可编辑\", \"width\": \"90\", \"update\": \"switch\", \"options\": \"\", \"minWidth\": \"90\"}, {\"field\": \"detail\", \"title\": \"不可查看\", \"width\": \"90\", \"update\": \"switch\", \"minWidth\": \"90\"}, {\"field\": \"user_ids\", \"title\": \"用户授权\", \"update\": \"select\", \"options\": \"admin_user_list\", \"minWidth\": 160}, {\"field\": \"role_ids\", \"title\": \"角色授权\", \"update\": \"select\", \"options\": \"admin_role\", \"minWidth\": 160}, {\"field\": \"department_ids\", \"title\": \"组织授权\", \"update\": \"select\", \"options\": \"department_list\", \"minWidth\": 160}], \"help\": \"\", \"hide\": \"2\", \"field\": \"power_field\", \"title\": \"字段权限\", \"value\": \"\", \"elem_id\": \"26e2_1713677074514_52253\", \"required\": \"2\", \"hide_label\": \"1\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, '2024-04-10 10:48:19', '2024-04-22 15:55:28', 1, 1);
INSERT INTO `erp_ruinuo_form` VALUES (4, 4, '[{\"tag\": \"legend\", \"content\": \"基础设置\", \"elem_id\": \"15db_1713179851895_87977\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"mode_id\", \"title\": \"所属控制器\", \"value\": \"{mode_id}\", \"is_all\": \"2\", \"elem_id\": \"4492_1713179597319_19968\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"mode_list\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"2744_1713179624512_88317\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"page_num\", \"title\": \"每页显示数量\", \"value\": \"30\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isinteger\", \"elem_id\": \"68fd_1713179653524_24521\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"order_raw\", \"title\": \"数据排序规则\", \"value\": \"id desc\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"1c23_1713179713538_65090\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"style\", \"title\": \"风格\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"2de4_1713179910656_70668\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": [{\"tag\": \"select\", \"field\": \"style\", \"required\": 1, \"event_val\": \"3\", \"field_val\": \"parent_id\", \"event_type\": \"=\", \"event_field\": \"tree_field\"}, {\"tag\": \"select\", \"field\": \"style\", \"required\": 1, \"event_val\": \"3\", \"field_val\": \"title\", \"event_type\": \"=\", \"event_field\": \"tree_show_field\"}], \"hide_label\": \"2\", \"options_num\": \"lists_style\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"tree_field\", \"title\": \"树形字段\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"27f9_1713179946460_13169\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"tree_show_field\", \"title\": \"树形显示字段\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"22a6_1713750542045_84650\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"sort\", \"title\": \"排序\", \"value\": \"1\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isinteger\", \"elem_id\": \"3ff8_1713180019465_22620\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"tag\": \"ordernum\", \"field\": \"num\", \"title\": \"编码\", \"elem_id\": \"74f3_1713240981292_30250\", \"num_rule\": [{\"rule_val\": \"m_\", \"rule_type\": \"3\"}, {\"rule_val\": \"YYYYMMDDHHIISS\", \"rule_type\": \"2\"}]}, {\"tag\": \"legend\", \"content\": \"数据权限\", \"elem_id\": \"3bd5_1713179849755_56113\"}, {\"col\": \"12\", \"tag\": \"jsontable\", \"cols\": [{\"field\": \"field\", \"title\": \"权限字段\", \"update\": \"input\", \"minWidth\": 160, \"required\": 2}, {\"field\": \"is_path\", \"title\": \"允许上级查看\", \"update\": \"switch\", \"minWidth\": 160}], \"help\": \"\", \"hide\": \"2\", \"field\": \"power_field\", \"title\": \"权限字段\", \"value\": \"\", \"elem_id\": \"4031_1713228895830_52445\", \"required\": \"2\", \"hide_label\": \"2\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"power_role\", \"title\": \"通用角色权限\", \"value\": \"\", \"is_all\": \"1\", \"elem_id\": \"9781_1713179834545_35095\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"admin_role\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"power_department\", \"title\": \"通用部门权限\", \"value\": \"\", \"is_all\": \"1\", \"elem_id\": \"17ea_1714029324244_50949\", \"readonly\": \"2\", \"required\": \"2\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"department_list\"}, {\"col\": \"12\", \"tag\": \"textarea\", \"help\": \"\", \"hide\": \"2\", \"field\": \"set_where\", \"title\": \"查询条件\", \"value\": \"\", \"follow\": \"2\", \"height\": \"100\", \"elem_id\": \"2a13_1713179783175_63488\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"填写sql语句，不懂的就不要乱填\"}, {\"tag\": \"legend\", \"content\": \"左侧设置\", \"elem_id\": \"2dd4_1713180070080_68594\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"is_left\", \"title\": \"开启左侧\", \"value\": \"2\", \"is_all\": \"2\", \"elem_id\": \"28c9_1713180081213_87076\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": [{\"tag\": \"select\", \"field\": \"is_left\", \"required\": 1, \"event_val\": \"1\", \"event_type\": \"=\", \"event_field\": \"left_title\"}, {\"tag\": \"select\", \"field\": \"is_left\", \"required\": 1, \"event_val\": \"1\", \"event_type\": \"=\", \"event_field\": \"left_show_field\"}, {\"tag\": \"select\", \"field\": \"is_left\", \"required\": 1, \"event_val\": \"1\", \"event_type\": \"=\", \"event_field\": \"left_field\"}, {\"tag\": \"select\", \"field\": \"is_left\", \"required\": 1, \"event_val\": \"1\", \"event_type\": \"=\", \"event_field\": \"left_key_field\"}, {\"tag\": \"select\", \"field\": \"is_left\", \"required\": 1, \"event_val\": \"1\", \"event_type\": \"=\", \"event_field\": \"left_type\"}], \"hide_label\": \"2\", \"options_num\": \"yesno\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"left_title\", \"title\": \"左侧标题\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"8919_1713180190309_12933\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"left_type\", \"title\": \"关联方式\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"6afd_1713180138367_48906\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"event_val\": [{\"tag\": \"select\", \"field\": \"left_type\", \"required\": 1, \"event_val\": \"1\", \"event_type\": \"=\", \"event_field\": \"left_options\"}, {\"tag\": \"select\", \"field\": \"left_type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"left_mode\"}], \"hide_label\": \"2\", \"options_num\": \"left_type\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"left_options\", \"title\": \"关联数据源\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"77fb_1714922775937_73214\", \"readonly\": \"2\", \"required\": \"2\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"options_list\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"left_mode\", \"title\": \"关联模块\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"3f9b_1714923040848_06300\", \"readonly\": \"2\", \"required\": \"2\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"mode_list\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"left_key_field\", \"title\": \"主键字段\", \"value\": \"value\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"3441_1713180187457_39252\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"left_show_field\", \"title\": \"显示字段\", \"value\": \"label\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"901b_1713180226162_59466\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"left_field\", \"title\": \"关联字段\", \"value\": \"id\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"8c43_1713180184648_03647\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, '2024-04-10 11:21:43', '2024-05-05 23:34:55', 1, 1);
INSERT INTO `erp_ruinuo_form` VALUES (5, 5, '[{\"tag\": \"legend\", \"content\": \"基础配置\", \"elem_id\": \"88c0_1713356897295_76035\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"mode_id\", \"title\": \"所属模块\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"61d2_1713181296353_91571\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"mode_list\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"title\", \"title\": \"按钮名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"7043_1713181342705_44147\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"icon\", \"help\": \"\", \"hide\": \"2\", \"field\": \"icon\", \"title\": \"按钮图标\", \"value\": \"\", \"elem_id\": \"95cb_1713181549860_43267\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"app_num\", \"title\": \"应用编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"252d_1713356767927_58682\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"mode_num\", \"title\": \"模块编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"6912_1713356765663_18924\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"action\", \"title\": \"方法名\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"144f_1713181468055_92095\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"query\", \"title\": \"参数\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"68d1_1713343708465_34785\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"where\", \"title\": \"显示条件\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"8cd6_1713356993695_97632\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"tag\": \"legend\", \"content\": \"高级配置\", \"elem_id\": \"2f2c_1713356899741_83462\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"position\", \"title\": \"按钮位置\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"3f40_1713181359953_26071\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": [], \"hide_label\": \"2\", \"options_num\": \"button_position\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"node\", \"title\": \"按钮节点\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"81a5_1713181378218_08143\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"button_node\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"btn_class\", \"title\": \"按钮样式\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"6e7d_1713181539797_34182\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"btn_theme\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"type\", \"title\": \"打开方式\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"1737_1713181426179_35742\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": [{\"tag\": \"select\", \"field\": \"type\", \"event_val\": \"window\", \"field_val\": \"\", \"event_type\": \"=\", \"event_field\": \"width\"}, {\"tag\": \"select\", \"field\": \"type\", \"event_val\": \"window\", \"field_val\": \"\", \"event_type\": \"=\", \"event_field\": \"height\"}], \"hide_label\": \"2\", \"options_num\": \"button_type\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"width\", \"title\": \"宽\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"863a_1713181456163_54233\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"height\", \"title\": \"高\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"7b3d_1713181457368_65392\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"sort\", \"title\": \"排序\", \"value\": \"1\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isinteger\", \"elem_id\": \"15f5_1713181559290_37362\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', NULL, NULL, 0, 0, 'form_right', 0, 1, NULL, '', '2024-04-11 12:04:02', '2024-04-17 20:40:37', 1, 1);
INSERT INTO `erp_ruinuo_form` VALUES (6, 6, '[{\"tag\": \"legend\", \"content\": \"基础设置\", \"elem_id\": \"2f12_1713774786845_25840\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"name\", \"title\": \"表名\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalphaAndDash\", \"elem_id\": \"241c_1713774796744_30488\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"3\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"comment\", \"title\": \"注释\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"1bf6_1713774801440_56663\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"engine\", \"title\": \"引擎\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"7702_1713774811468_36854\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"database_engine\"}, {\"col\": \"3\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"collation\", \"title\": \"字符集\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"3542_1713774817378_81278\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"database_collation\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"1\", \"only\": \"2\", \"field\": \"old_name\", \"title\": \"旧表名\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"6ddd_1714008067744_79404\", \"readonly\": \"1\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"tag\": \"legend\", \"content\": \"字段设置\", \"elem_id\": \"8098_1713774889393_87401\"}, {\"col\": \"12\", \"tag\": \"tips\", \"content\": \"系统默认字段无需创建：id(主键)，create_time(新增时间)，create__id(新增用户ID)，update_time(更新时间)，update_id(更新用户ID)\", \"elem_id\": \"1d01_1713775110156_71531\"}, {\"col\": \"12\", \"tag\": \"jsontable\", \"cols\": [{\"field\": \"field\", \"title\": \"字段名\", \"update\": \"input\", \"verify\": \"isalphaAndDash\", \"required\": 1}, {\"field\": \"title\", \"title\": \"注释\", \"update\": \"input\", \"required\": 1}, {\"field\": \"type\", \"title\": \"字段类型\", \"width\": \"\", \"update\": \"select\", \"options\": \"database_field_type\", \"required\": 1}, {\"field\": \"length\", \"title\": \"长度\", \"update\": \"input\"}, {\"field\": \"default\", \"title\": \"默认值\", \"update\": \"input\"}, {\"field\": \"key\", \"title\": \"索引\", \"update\": \"switch\"}], \"help\": \"\", \"hide\": \"2\", \"field\": \"field\", \"title\": \"字段\", \"value\": \"\", \"elem_id\": \"59fd_1713774900755_02838\", \"required\": \"2\", \"hide_label\": \"1\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, '2024-04-16 20:26:56', '2024-04-27 14:43:30', NULL, 1);
INSERT INTO `erp_ruinuo_form` VALUES (7, 9, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"user\", \"title\": \"账号\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalpha\", \"elem_id\": \"5fa1_1713363731998_35982\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"姓名\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"ischs\", \"elem_id\": \"96dd_1713364612872_31938\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"phone\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"phone\", \"title\": \"手机号\", \"value\": \"\", \"verify\": \"isphone\", \"elem_id\": \"20f4_1713364619520_73362\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"password\", \"help\": \"\", \"field\": \"upass\", \"title\": \"密码\", \"value\": \"\", \"verify\": \"\", \"elem_id\": \"4ee1_1713364623500_33012\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"path_id\", \"title\": \"我的上级\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"895a_1714031517484_96195\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"admin_user_list\"}, {\"col\": \"12\", \"tag\": \"tree\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"role_ids\", \"title\": \"所属角色\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"3a0d_1713364706522_37673\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"options_num\": \"admin_role\"}, {\"col\": \"12\", \"tag\": \"tree\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"department_ids\", \"title\": \"所属组织\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"59db_1713364717418_84771\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"options_num\": \"department_list\"}, {\"col\": \"12\", \"tag\": \"textarea\", \"help\": \"\", \"hide\": \"2\", \"field\": \"notes\", \"title\": \"备注\", \"value\": \"\", \"follow\": \"2\", \"height\": \"100\", \"elem_id\": \"8253_1713364685148_51496\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', '[]', NULL, 700, 0, 'form_right', 0, 1, NULL, '', '2024-04-17 22:22:43', '2024-05-10 16:14:07', 1, 1);
INSERT INTO `erp_ruinuo_form` VALUES (8, 10, '[{\"col\": \"12\", \"tag\": \"tree\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"parent_id\", \"title\": \"上级\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"7f9c_1713366111723_70634\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"options_num\": \"admin_menu\"}, {\"col\": \"12\", \"tag\": \"radio\", \"help\": \"\", \"hide\": \"2\", \"field\": \"type\", \"title\": \"类型\", \"value\": \"1\", \"elem_id\": \"1c8d_1713365650383_85795\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": [{\"tag\": \"radio\", \"field\": \"type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"app\"}, {\"tag\": \"radio\", \"field\": \"type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"controller\"}, {\"tag\": \"radio\", \"field\": \"type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"action\"}, {\"tag\": \"radio\", \"field\": \"type\", \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"query\"}, {\"tag\": \"radio\", \"field\": \"type\", \"required\": 1, \"event_val\": \"3\", \"event_type\": \"=\", \"event_field\": \"href\"}], \"hide_label\": \"2\", \"options_num\": \"menu_type\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"title\", \"title\": \"名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"5d15_1713363819696_32097\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"icon\", \"help\": \"\", \"hide\": \"2\", \"field\": \"icon\", \"title\": \"图标\", \"value\": \"\", \"elem_id\": \"833d_1713365767322_89178\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"app\", \"title\": \"应用\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"211b_1713365883120_87961\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"controller\", \"title\": \"控制器\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"7a55_1713365884758_51603\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"action\", \"title\": \"方法\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"7f59_1713365886203_87191\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"query\", \"title\": \"参数\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"62d8_1713365887686_34811\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"href\", \"title\": \"外部链接\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"4e1a_1713365921360_71193\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"number\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"sort\", \"title\": \"排序\", \"value\": \"1\", \"verify\": \"isinteger\", \"elem_id\": \"88d5_1713365785446_90741\", \"is_edit\": \"1\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', NULL, NULL, 700, 700, 'form_right', 0, 1, NULL, '', '2024-04-17 22:23:43', '2024-04-21 17:18:15', 1, 1);
INSERT INTO `erp_ruinuo_form` VALUES (9, 11, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"角色名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"67e2_1713748140552_89834\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"num\", \"title\": \"角色编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalpha\", \"elem_id\": \"5145_1713748141990_69378\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"home\", \"title\": \"默认首页\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"39ac_1713748301366_85589\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"textarea\", \"help\": \"\", \"hide\": \"2\", \"field\": \"notes\", \"title\": \"备注\", \"value\": \"\", \"follow\": \"2\", \"height\": \"100\", \"elem_id\": \"20dd_1713748144445_49428\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', '[]', NULL, 700, 500, 'form_right', 0, 1, NULL, NULL, '2024-04-18 00:09:18', '2024-04-25 20:54:43', NULL, 1);
INSERT INTO `erp_ruinuo_form` VALUES (12, 14, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"文件名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"2594_1713693429293_41870\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"size\", \"title\": \"文件大小\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"161c_1713693432857_77175\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"mime\", \"title\": \"文件类型\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"119c_1713693435997_91852\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"url\", \"title\": \"存储路径\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"6eff_1713693443426_65321\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"source_url\", \"title\": \"来源url\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"7479_1713693447982_62254\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, '2024-04-18 11:35:33', '2024-04-27 15:30:28', NULL, 1);
INSERT INTO `erp_ruinuo_form` VALUES (11, 13, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"module\", \"title\": \"模块\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"53d5_1714201390421_79306\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"controller\", \"title\": \"控制器\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"665d_1714201404123_46968\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"action\", \"title\": \"方法\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"2818_1714201407167_51112\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"method\", \"title\": \"请求方式\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"864a_1714201410731_78861\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"url\", \"title\": \"请求地址\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"58f3_1714201417666_62364\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"post_data\", \"title\": \"POST数据\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"544e_1714201422321_40032\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"get_data\", \"title\": \"GET数据\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"82dc_1714201428061_31270\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"headers\", \"title\": \"头部信息\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"3886_1714201432680_34170\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"ip\", \"title\": \"ip地址\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"545b_1714201438238_44465\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"content\", \"title\": \"日志内容\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"5c65_1714201443859_46075\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"agent\", \"title\": \"请求头\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"940f_1714201450135_33786\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}]', '[{\"add\": 1, \"edit\": 1, \"field\": \"action\", \"detail\": 1, \"role_ids\": \"\", \"user_ids\": \"\", \"department_ids\": \"\"}]', NULL, 0, 0, 'form_top', 0, 1, NULL, NULL, '2024-04-18 00:14:05', '2024-04-27 15:04:13', NULL, 1);
INSERT INTO `erp_ruinuo_form` VALUES (13, 15, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"group_num\", \"title\": \"分组编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalpha\", \"elem_id\": \"328b_1713706623253_68634\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"配置名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"66ac_1713706620720_79874\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"num\", \"title\": \"配置编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalpha\", \"elem_id\": \"763f_1713706621997_75315\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"label_width\", \"title\": \"label宽度\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isinteger\", \"elem_id\": \"34f7_1713706686890_44320\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"form_label\", \"title\": \"label对齐方式\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"2af5_1713706698099_85111\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"label_type\"}, {\"col\": \"12\", \"tag\": \"jsontable\", \"cols\": [{\"field\": \"title\", \"title\": \"字段名称\", \"update\": \"input\", \"required\": 1}, {\"field\": \"field\", \"title\": \"字段编码\", \"update\": \"input\", \"required\": 1}], \"help\": \"\", \"hide\": \"2\", \"field\": \"fields\", \"title\": \"字段配置\", \"value\": \"\", \"elem_id\": \"17ef_1713706779468_31931\", \"required\": \"1\", \"hide_label\": \"2\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, '2024-04-21 21:36:38', '2024-04-21 22:23:53', NULL, 1);
INSERT INTO `erp_ruinuo_form` VALUES (14, 16, '[{\"col\": \"12\", \"tag\": \"tree\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"parent_id\", \"title\": \"上级\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"fa5a_1713750277301_39294\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"options_num\": \"department_list\"}, {\"col\": \"12\", \"tag\": \"radio\", \"help\": \"\", \"hide\": \"2\", \"field\": \"type\", \"title\": \"组织类型\", \"value\": \"1\", \"elem_id\": \"14b5_1713748733098_96633\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"department_type\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"组织名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"20e6_1713748715576_28292\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"num\", \"title\": \"组织编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalpha\", \"elem_id\": \"8285_1713748716797_04908\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"tel\", \"title\": \"电话\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"685d_1713748749674_10704\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"facsimile\", \"title\": \"传真\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"6323_1713748753575_18305\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"address\", \"title\": \"地址\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"393b_1713748760196_11262\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"number\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"sort\", \"title\": \"排序\", \"value\": \"1\", \"verify\": \"isinteger\", \"elem_id\": \"3c56_1713748772151_92061\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"textarea\", \"help\": \"\", \"hide\": \"2\", \"field\": \"notes\", \"title\": \"备注\", \"value\": \"\", \"follow\": \"2\", \"height\": \"100\", \"elem_id\": \"449a_1713748776626_66818\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, '2024-04-22 09:18:18', '2024-04-22 09:44:55', NULL, 1);
INSERT INTO `erp_ruinuo_form` VALUES (15, 19, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"4c11_1713773633001_15633\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"num\", \"title\": \"编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalphaDash\", \"elem_id\": \"8223_1713773634058_70321\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"radio\", \"help\": \"\", \"hide\": \"2\", \"field\": \"type\", \"title\": \"类型\", \"value\": \"1\", \"elem_id\": \"282d_1713773648395_80006\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": [{\"tag\": \"radio\", \"field\": \"type\", \"required\": 1, \"event_val\": \"1\", \"event_type\": \"=\", \"event_field\": \"config\"}, {\"tag\": \"radio\", \"field\": \"type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"url\"}, {\"tag\": \"radio\", \"field\": \"type\", \"required\": 1, \"event_val\": \"2,3\", \"event_type\": \"in\", \"event_field\": \"label\"}, {\"tag\": \"radio\", \"field\": \"type\", \"required\": 1, \"event_val\": \"2,3\", \"event_type\": \"in\", \"event_field\": \"value\"}, {\"tag\": \"radio\", \"field\": \"type\", \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"is_token\"}, {\"required\": 1, \"event_val\": \"3\", \"event_type\": \"=\", \"event_field\": \"mode_id\"}], \"hide_label\": \"2\", \"options_num\": \"options_type\"}, {\"col\": \"12\", \"tag\": \"jsontable\", \"cols\": [{\"field\": \"label\", \"title\": \"名称\", \"update\": \"input\", \"required\": 1}, {\"field\": \"value\", \"title\": \"编码\", \"update\": \"input\", \"required\": 1}], \"help\": \"\", \"hide\": \"2\", \"field\": \"config\", \"title\": \"配置\", \"value\": \"\", \"elem_id\": \"41b8_1713773761898_42533\", \"required\": \"2\", \"hide_label\": \"2\"}, {\"col\": \"12\", \"tag\": \"select\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"mode_id\", \"title\": \"选择模块\", \"value\": \"\", \"is_all\": \"2\", \"elem_id\": \"6f3e_1714107879539_84384\", \"readonly\": \"2\", \"required\": \"2\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"mode_list\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"url\", \"title\": \"链接地址\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"938f_1713773713976_66286\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"label\", \"title\": \"显示字段\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"17ff_1713773715521_42916\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"value\", \"title\": \"保存字段\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"92c9_1713773716677_68441\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"radio\", \"help\": \"\", \"hide\": \"2\", \"field\": \"is_token\", \"title\": \"验证token\", \"value\": \"2\", \"elem_id\": \"2541_1713773734550_64432\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": \"\", \"hide_label\": \"2\", \"options_num\": \"yesno\"}, {\"col\": \"12\", \"tag\": \"textarea\", \"help\": \"\", \"hide\": \"2\", \"field\": \"notes\", \"title\": \"备注\", \"value\": \"\", \"follow\": \"2\", \"height\": \"100\", \"elem_id\": \"67a5_1713773952411_80707\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, NULL, '2024-04-26 13:08:32', NULL, 1);
INSERT INTO `erp_ruinuo_form` VALUES (16, 20, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"table_name\", \"title\": \"表名\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"9795_1713774245947_02347\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"app\", \"title\": \"应用名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"3a2c_1713774251112_74001\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"controller\", \"title\": \"控制器名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"4872_1713774255978_29665\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"jsontable\", \"cols\": \"\", \"help\": \"\", \"hide\": \"2\", \"field\": \"delete_json\", \"title\": \"删除内容\", \"value\": \"\", \"elem_id\": \"1bf1_1713774281510_26311\", \"required\": \"2\", \"hide_label\": \"2\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"delete_ip\", \"title\": \"删除者IP\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"6bbd_1713774267800_57394\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, '2024-04-22 16:22:14', '2024-04-22 16:25:02', NULL, 1);
INSERT INTO `erp_ruinuo_form` VALUES (17, 21, '[{\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"name\", \"title\": \"名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"710e_1713774483810_84892\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"1\", \"field\": \"num\", \"title\": \"编码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isalpha\", \"elem_id\": \"c499_1713774484799_10335\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"guize\", \"title\": \"验证规则\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"66bb_1713774485947_63969\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}]', NULL, NULL, 0, 0, NULL, 0, 1, NULL, NULL, '2024-04-22 16:27:43', '2024-04-27 14:08:16', NULL, 1);

-- ----------------------------
-- Table structure for erp_ruinuo_lists
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_lists`;
CREATE TABLE `erp_ruinuo_lists`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `mode_id` int(11) NULL DEFAULT NULL COMMENT '所属控制器',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
  `sort` int(11) NULL DEFAULT 1 COMMENT '排序',
  `table_cols` json NULL COMMENT '表格字段',
  `set_where` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '查询条件',
  `order_raw` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `style` int(2) NULL DEFAULT 1 COMMENT '风格',
  `page_num` int(11) NULL DEFAULT NULL COMMENT '每页显示数量',
  `power_field` json NULL COMMENT '权限字段',
  `power_role` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '通用角色权限',
  `power_department` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '通用部门权限',
  `tree_field` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '树形字段',
  `tree_show_field` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '树形显示字段',
  `is_left` int(2) NULL DEFAULT 2 COMMENT '开启左侧',
  `left_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '左侧标题',
  `left_key_field` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '左侧主键字段',
  `left_show_field` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '左侧显示字段',
  `left_field` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '左侧关联字段',
  `left_type` int(2) NULL DEFAULT NULL COMMENT '左侧关联方式',
  `left_options` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '左侧关联数据源',
  `left_mode` int(11) NULL DEFAULT NULL COMMENT '左侧关联模块',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '列表管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_lists
-- ----------------------------
INSERT INTO `erp_ruinuo_lists` VALUES (1, 1, '全部', 'all', 1, '[{\"id\": \"1713173698_1_1\", \"align\": \"\", \"field\": \"name\", \"group\": \"\", \"title\": \"应用名称\", \"width\": \"\", \"search\": \"like\", \"select\": \"\", \"update\": \"\", \"options\": \"\", \"position\": \"center\"}, {\"id\": \"1713173699_1_2\", \"field\": \"num\", \"title\": \"应用编码\", \"search\": \"like\", \"update\": \"\"}, {\"id\": \"1713238901_1_2\", \"field\": \"notes\", \"title\": \"备注\"}, {\"id\": \"1713238902_1_3\", \"field\": \"create_time\", \"title\": \"新增时间\"}]', '', 'id desc', 1, 30, '[]', '', NULL, '111', NULL, 2, '应用', 'id', 'name', 'app_id', 2, '1', 2, '2024-04-08 16:52:34', '2024-04-16 20:57:58', 0, 1);
INSERT INTO `erp_ruinuo_lists` VALUES (3, 5, '全部', '', 1, '[{\"id\": \"1713329495_3_11\", \"field\": \"id\", \"title\": \"主键\", \"width\": \"70\"}, {\"id\": \"1713264397_3_1\", \"field\": \"title\", \"title\": \"按钮名称\", \"width\": \"140\", \"search\": \"like\", \"update\": \"input\"}, {\"id\": \"1713264399_3_3\", \"field\": \"position\", \"title\": \"按钮位置\", \"width\": \"110\", \"search\": \"select\", \"options\": \"button_position\"}, {\"id\": \"1713264400_3_4\", \"tpl\": \"\", \"field\": \"node\", \"title\": \"按钮节点\", \"width\": \"110\", \"search\": \"select\", \"options\": \"button_node\"}, {\"id\": \"1713356553_3_13\", \"field\": \"app_num\", \"group\": \"\", \"title\": \"应用编码\", \"width\": \"110\"}, {\"id\": \"1713356553_3_14\", \"field\": \"mode_num\", \"group\": \"\", \"title\": \"模块编码\", \"width\": \"110\"}, {\"id\": \"1713343776_3_14\", \"field\": \"action\", \"group\": \"\", \"title\": \"方法名\", \"width\": \"110\", \"update\": \"\"}, {\"id\": \"1713343777_3_15\", \"field\": \"query\", \"group\": \"\", \"title\": \"参数\", \"width\": \"140\", \"update\": \"input\"}, {\"id\": \"1713330576_3_12\", \"field\": \"status\", \"title\": \"是否可用\", \"width\": \"90\", \"update\": \"switch\"}, {\"id\": \"1713339807_3_14\", \"field\": \"is_drop\", \"title\": \"是否下拉\", \"width\": \"90\", \"update\": \"switch\"}, {\"id\": \"1713264411_3_11\", \"field\": \"sort\", \"title\": \"排序\", \"width\": \"70\", \"update\": \"input\"}, {\"id\": \"1713264393_3_0\", \"hide\": 1, \"field\": \"mode_id\", \"title\": \"所属模块\", \"search\": \"url\", \"options\": \"\"}]', '', 'id desc,sort asc', 1, 30, '[]', '', NULL, '', NULL, 1, '应用模型', 'value', 'label', 'mode_id', 1, 'mode_list', NULL, '2024-04-16 11:53:14', '2024-04-17 13:18:07', 1, 1);
INSERT INTO `erp_ruinuo_lists` VALUES (2, 2, '全部', '', 1, '[{\"id\": \"1713329344_2_7\", \"field\": \"id\", \"title\": \"主键\", \"width\": \"70\"}, {\"id\": \"1713264201_2_0\", \"hide\": 1, \"field\": \"app_id\", \"title\": \"归属应用\", \"search\": \"url\", \"options\": \"\"}, {\"id\": \"1713264202_2_1\", \"field\": \"name\", \"title\": \"名称\", \"search\": \"like\"}, {\"id\": \"1713264204_2_2\", \"field\": \"num\", \"title\": \"编码\", \"search\": \"like\"}, {\"id\": \"1713264207_2_3\", \"field\": \"notes\", \"title\": \"备注\"}, {\"id\": \"1713264207_2_4\", \"field\": \"database\", \"title\": \"数据表\", \"search\": \"like\"}, {\"id\": \"1713264215_2_6\", \"field\": \"update_id\", \"title\": \"修改人\"}, {\"id\": \"1713264214_2_5\", \"field\": \"update_time\", \"title\": \"修改时间\", \"search\": \"datetime\"}]', '', 'id desc', 1, 30, '[]', '', '', '', '', 1, '应用列表', 'id', 'name', 'app_id', 2, '', 1, '2024-04-16 11:15:13', '2024-05-07 14:35:56', 1, 1);
INSERT INTO `erp_ruinuo_lists` VALUES (8, 4, '全部', '', 1, '[{\"id\": \"1713246388_8_0\", \"field\": \"name\", \"title\": \"名称\"}, {\"id\": \"1713246389_8_1\", \"field\": \"num\", \"title\": \"编码\"}, {\"id\": \"1713246392_8_2\", \"field\": \"order_raw\", \"title\": \"排序\"}, {\"id\": \"1713246393_8_3\", \"field\": \"style\", \"title\": \"风格\"}, {\"id\": \"1713246398_8_4\", \"field\": \"page_num\", \"title\": \"每页显示数量\"}]', '', 'id desc', 1, 30, '[]', '', NULL, '', NULL, 2, '', '', '', '', 0, '', NULL, '2024-04-16 13:46:22', '2024-04-16 13:46:22', 1, NULL);
INSERT INTO `erp_ruinuo_lists` VALUES (10, 6, '全部', 'm_1713270416', 1, '[{\"id\": \"m_1713270416\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}, {\"id\": \"1713774701_10_1\", \"field\": \"name\", \"title\": \"表名\", \"search\": \"like\"}, {\"id\": \"1713774701_10_2\", \"field\": \"comment\", \"title\": \"注释\", \"search\": \"like\"}, {\"id\": \"1713774702_10_3\", \"field\": \"engine\", \"title\": \"引擎\"}, {\"id\": \"1713774703_10_4\", \"field\": \"rows\", \"title\": \"记录数\"}, {\"id\": \"1713774704_10_5\", \"field\": \"collation\", \"title\": \"字符集\"}, {\"id\": \"1713774707_10_6\", \"field\": \"field_num\", \"title\": \"字段数\"}, {\"id\": \"1713774711_10_8\", \"field\": \"update_id\", \"title\": \"修改人\"}, {\"id\": \"1713774710_10_7\", \"field\": \"update_time\", \"title\": \"更新时间\"}]', NULL, 'id desc', 1, 30, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-16 20:26:56', '2024-04-16 20:26:56', NULL, NULL);
INSERT INTO `erp_ruinuo_lists` VALUES (15, 10, '全部', 'm_1713364429', 1, '[{\"id\": \"1713406623_15_2\", \"field\": \"title\", \"title\": \"名称\"}, {\"id\": \"1713406803_15_2\", \"field\": \"type\", \"title\": \"类型\", \"options\": \"menu_type\"}, {\"id\": \"1713406617_15_1\", \"hide\": 1, \"field\": \"parent_id\", \"title\": \"上级\"}, {\"id\": \"1713692284_15_8\", \"field\": \"sort\", \"title\": \"排序\", \"update\": \"input\"}, {\"id\": \"1713406819_15_3\", \"field\": \"app\", \"title\": \"应用\"}, {\"id\": \"1713406820_15_4\", \"field\": \"controller\", \"title\": \"控制器\"}, {\"id\": \"1713406820_15_5\", \"field\": \"action\", \"title\": \"方法\"}, {\"id\": \"1713406821_15_6\", \"field\": \"query\", \"title\": \"参数\"}, {\"id\": \"1713406834_15_7\", \"field\": \"href\", \"title\": \"外部链接\"}]', '', 'sort asc,id desc', 3, 30, '[]', '', '', 'parent_id', 'title', 2, '', 'value', 'label', 'id', 0, '', NULL, '2024-04-17 22:33:49', '2024-04-22 09:51:24', NULL, 1);
INSERT INTO `erp_ruinuo_lists` VALUES (13, 3, '全部', 'm_1713360218', 1, '[{\"id\": \"m_1713360218\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}]', NULL, 'id desc', 1, 30, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-17 21:23:38', '2024-04-17 21:23:38', NULL, NULL);
INSERT INTO `erp_ruinuo_lists` VALUES (14, 9, '全部', 'm_20240417222414', 1, '[{\"id\": \"1713363896_14_0\", \"field\": \"id\", \"title\": \"主键\"}, {\"id\": \"1713363900_14_1\", \"field\": \"user\", \"title\": \"账号\"}, {\"id\": \"1713363901_14_2\", \"field\": \"name\", \"title\": \"姓名\"}, {\"id\": \"1713363902_14_3\", \"field\": \"phone\", \"title\": \"手机号\"}, {\"id\": \"1713363916_14_4\", \"field\": \"role_ids\", \"title\": \"所属角色\", \"search\": \"select\", \"options\": \"admin_role\"}, {\"id\": \"1713765518_14_8\", \"field\": \"department_ids\", \"title\": \"所属组织\", \"search\": \"select\", \"options\": \"department_list\"}, {\"id\": \"1713763416_14_8\", \"field\": \"is_super\", \"title\": \"超级管理员\", \"update\": \"switch\"}, {\"id\": \"1713363924_14_6\", \"field\": \"status\", \"title\": \"是否启用\", \"update\": \"switch\"}, {\"id\": \"1713363926_14_7\", \"field\": \"create_time\", \"title\": \"新增时间\", \"width\": \"160\"}]', '', 'id desc', 1, 30, '[]', '', '', '', '', 2, '', 'value', 'label', 'id', 0, '', 0, '2024-04-17 22:24:14', '2024-05-05 23:35:13', 1, 1);
INSERT INTO `erp_ruinuo_lists` VALUES (16, 11, '全部', 'm_1713370157', 1, '[{\"id\": \"m_1713370157\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}, {\"id\": \"1713748201_16_1\", \"field\": \"name\", \"title\": \"角色名称\"}, {\"id\": \"1713748202_16_2\", \"field\": \"num\", \"title\": \"角色编码\"}, {\"id\": \"1713748246_16_5\", \"field\": \"home\", \"title\": \"默认首页\"}, {\"id\": \"1713748209_16_3\", \"field\": \"create_time\", \"title\": \"创建时间\"}]', '', 'id desc', 1, 30, '[]', '', NULL, '', NULL, 2, '', 'value', 'label', 'id', 0, '', NULL, '2024-04-18 00:09:18', '2024-04-19 15:58:31', NULL, 1);
INSERT INTO `erp_ruinuo_lists` VALUES (19, 14, '全部', 'm_1713411333', 1, '[{\"id\": \"1713437315_19_5\", \"field\": \"url\", \"title\": \"存储路径\"}, {\"id\": \"1713435104_19_1\", \"field\": \"name\", \"title\": \"文件名称\", \"search\": \"like\"}, {\"id\": \"1713437311_19_2\", \"field\": \"size\", \"title\": \"文件大小\"}, {\"id\": \"1713437312_19_3\", \"field\": \"mime\", \"title\": \"文件类型\", \"search\": \"like\"}, {\"id\": \"1713437316_19_6\", \"field\": \"source_url\", \"title\": \"来源url\"}, {\"id\": \"1713437317_19_7\", \"field\": \"create_time\", \"title\": \"上传时间\"}]', '', 'id desc', 5, 30, '[]', '', NULL, '', NULL, 2, '', 'value', 'label', 'id', 0, '', NULL, '2024-04-18 11:35:34', '2024-04-18 11:36:52', NULL, 1);
INSERT INTO `erp_ruinuo_lists` VALUES (18, 13, '全部', 'm_1713370445', 1, '[{\"id\": \"m_1713370445\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}, {\"id\": \"1713717304_18_1\", \"field\": \"type\", \"title\": \"日志类别\", \"search\": \"select\", \"options\": \"log_type\"}, {\"id\": \"1713717304_18_2\", \"field\": \"module\", \"title\": \"模块\", \"search\": \"like\"}, {\"id\": \"1713717305_18_3\", \"field\": \"controller\", \"title\": \"控制器\", \"search\": \"like\"}, {\"id\": \"1713717306_18_4\", \"field\": \"action\", \"title\": \"方法\", \"search\": \"like\"}, {\"id\": \"1713717449_18_9\", \"field\": \"ip\", \"title\": \"ip地址\"}, {\"id\": \"1713717306_18_5\", \"field\": \"method\", \"title\": \"请求方式\"}, {\"id\": \"1713717314_18_7\", \"field\": \"create_id\", \"title\": \"操作人\"}, {\"id\": \"1713717315_18_8\", \"field\": \"create_time\", \"title\": \"操作时间\", \"width\": \"160\", \"search\": \"datetime\"}]', NULL, 'id desc', 1, 30, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-18 00:14:05', '2024-04-18 00:14:05', NULL, NULL);
INSERT INTO `erp_ruinuo_lists` VALUES (20, 15, '全部', 'm_1713706597', 1, '[{\"id\": \"m_1713706597\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}, {\"id\": \"1713709472_20_5\", \"field\": \"group_num\", \"title\": \"分组编码\", \"search\": \"like\"}, {\"id\": \"1713707777_20_1\", \"field\": \"name\", \"title\": \"配置名称\", \"search\": \"like\"}, {\"id\": \"1713707778_20_2\", \"field\": \"num\", \"title\": \"配置编码\", \"search\": \"like\"}, {\"id\": \"1713707783_20_4\", \"field\": \"label_width\", \"title\": \"label宽度\"}, {\"id\": \"1713707783_20_5\", \"field\": \"form_label\", \"title\": \"label对齐方式\", \"options\": \"label_type\"}]', NULL, 'id desc', 1, 30, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21 21:36:38', '2024-04-21 21:36:38', NULL, NULL);
INSERT INTO `erp_ruinuo_lists` VALUES (21, 16, '全部', 'm_1713748698', 1, '[{\"id\": \"m_1713748698\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}, {\"id\": \"1713748879_21_1\", \"field\": \"name\", \"title\": \"组织名称\"}, {\"id\": \"1713748880_21_2\", \"field\": \"num\", \"title\": \"组织编码\"}, {\"id\": \"1713748889_21_7\", \"hide\": 1, \"field\": \"parent_id\", \"title\": \"上级\"}, {\"id\": \"1713748881_21_3\", \"field\": \"type\", \"title\": \"组织类型\", \"options\": \"department_type\"}, {\"id\": \"1713748882_21_4\", \"field\": \"tel\", \"title\": \"电话\"}, {\"id\": \"1713748885_21_5\", \"field\": \"facsimile\", \"title\": \"传真\"}, {\"id\": \"1713748887_21_6\", \"field\": \"address\", \"title\": \"地址\"}, {\"id\": \"1713748895_21_8\", \"field\": \"create_time\", \"title\": \"新增时间\"}]', '', 'id desc', 3, 30, '[]', '', '', 'parent_id', 'name', 2, '', 'value', 'label', 'id', 0, '', NULL, '2024-04-22 09:18:18', '2024-04-22 09:51:11', NULL, 1);
INSERT INTO `erp_ruinuo_lists` VALUES (22, 19, '全部', 'm_1713773958', 1, '[{\"id\": \"m_1713773958\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}, {\"id\": \"1713774002_22_1\", \"field\": \"name\", \"title\": \"名称\", \"search\": \"like\"}, {\"id\": \"1713774002_22_2\", \"field\": \"num\", \"title\": \"编码\", \"search\": \"like\"}, {\"id\": \"1713774004_22_3\", \"field\": \"type\", \"title\": \"类型\", \"search\": \"select\", \"options\": \"options_type\"}, {\"id\": \"1713774012_22_5\", \"field\": \"notes\", \"title\": \"备注\"}, {\"id\": \"1713774011_22_4\", \"field\": \"create_time\", \"title\": \"新增时间\", \"width\": \"160\", \"search\": \"datetime\"}]', NULL, 'id desc', 1, 30, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-22 16:19:18', '2024-04-22 16:19:18', NULL, NULL);
INSERT INTO `erp_ruinuo_lists` VALUES (23, 20, '全部', 'm_1713774134', 1, '[{\"id\": \"m_1713774134\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}, {\"id\": \"1713774183_23_1\", \"field\": \"table_name\", \"title\": \"表名\"}, {\"id\": \"1713774184_23_2\", \"field\": \"app\", \"title\": \"应用名称\"}, {\"id\": \"1713774185_23_3\", \"field\": \"controller\", \"title\": \"控制器名称\"}, {\"id\": \"1713774187_23_4\", \"field\": \"delete_ip\", \"title\": \"删除者IP\"}, {\"id\": \"1713774192_23_6\", \"field\": \"create_id\", \"title\": \"操作人\"}, {\"id\": \"1713774190_23_5\", \"field\": \"create_time\", \"title\": \"删除时间\"}]', NULL, 'id desc', 1, 30, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-22 16:22:14', '2024-04-22 16:22:14', NULL, NULL);
INSERT INTO `erp_ruinuo_lists` VALUES (24, 21, '全部', 'm_1713774463', 1, '[{\"id\": \"m_1713774463\", \"field\": \"id\", \"title\": \"主键\", \"width\": 70}, {\"id\": \"1713774530_24_1\", \"field\": \"name\", \"title\": \"名称\", \"search\": \"like\"}, {\"id\": \"1713774530_24_2\", \"field\": \"num\", \"title\": \"编码\", \"search\": \"like\"}, {\"id\": \"1713774533_24_3\", \"field\": \"guize\", \"title\": \"验证规则\"}, {\"id\": \"1713774534_24_5\", \"field\": \"create_id\", \"title\": \"新增人\"}, {\"id\": \"1713774533_24_4\", \"field\": \"create_time\", \"title\": \"新增时间\", \"search\": \"datetime\"}]', NULL, 'id desc', 1, 30, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-22 16:27:43', '2024-04-22 16:27:43', NULL, NULL);

-- ----------------------------
-- Table structure for erp_ruinuo_mode
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_mode`;
CREATE TABLE `erp_ruinuo_mode`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `app_id` int(11) NULL DEFAULT NULL COMMENT '归属应用',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
  `notes` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `database` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据表',
  `sub_database` json NULL COMMENT '关联子表',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模块管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_mode
-- ----------------------------
INSERT INTO `erp_ruinuo_mode` VALUES (1, 1, '应用管理', 'app', NULL, 'ruinuo_app', '[]', NULL, '2024-04-18 00:04:23', NULL, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (2, 1, '模块管理', 'mode', NULL, 'ruinuo_mode', '[]', NULL, '2024-04-18 00:04:27', NULL, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (3, 1, '表单管理', 'form', NULL, 'ruinuo_form', '[]', NULL, '2024-04-18 00:04:30', NULL, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (4, 1, '列表管理', 'lists', NULL, 'ruinuo_lists', '[]', NULL, '2024-04-18 00:04:36', NULL, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (5, 1, '按钮管理', 'button', NULL, 'ruinuo_button', '[]', NULL, '2024-04-18 00:04:42', NULL, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (6, 1, '数据库管理', 'database', NULL, 'ruinuo_database', '[]', '2024-04-16 20:21:09', '2024-04-18 00:04:47', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (9, 5, '后台用户', 'user', NULL, 'admin_user', '[]', '2024-04-17 22:19:54', '2024-04-18 00:04:53', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (10, 5, '菜单管理', 'menu', NULL, 'admin_menu', '[]', '2024-04-17 22:20:34', '2024-04-18 00:04:56', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (11, 5, '角色管理', 'role', NULL, 'admin_role', '[]', '2024-04-18 00:09:17', '2024-04-18 00:09:54', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (13, 5, '系统日志', 'oldlog', NULL, 'admin_log', '[]', '2024-04-18 00:14:05', '2024-04-22 01:05:58', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (14, 5, '附件管理', 'file', NULL, 'admin_file', '[]', '2024-04-18 11:35:33', '2024-04-21 13:10:20', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (15, 1, '配置管理', 'setting', NULL, 'ruinuo_setting', '[]', '2024-04-21 21:36:36', '2024-04-21 21:36:36', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (16, 5, '组织管理', 'department', NULL, 'admin_department', '[]', '2024-04-22 09:18:17', '2024-04-22 16:05:05', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (19, 5, '字典管理', 'options', NULL, 'admin_options', '[]', '2024-04-22 16:08:32', '2024-04-22 16:12:57', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (20, 5, '数据回收站', 'recycle', NULL, 'admin_recycle', '[]', '2024-04-22 16:22:14', '2024-04-22 16:22:14', 1, 1);
INSERT INTO `erp_ruinuo_mode` VALUES (21, 5, '验证管理', 'verify', NULL, 'ruinuo_verify', '[]', '2024-04-22 16:27:43', '2024-04-22 16:27:43', 1, 1);

-- ----------------------------
-- Table structure for erp_ruinuo_setting
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_setting`;
CREATE TABLE `erp_ruinuo_setting`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置编码',
  `group_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组编码',
  `fields` json NULL COMMENT '字段配置',
  `values` json NULL COMMENT '数据值',
  `layout` json NULL COMMENT '布局',
  `form_label` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'label对齐方式',
  `label_width` int(2) NULL DEFAULT 0 COMMENT 'label宽度',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  `is_system` int(2) NULL DEFAULT 2 COMMENT '是否系统',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_setting
-- ----------------------------
INSERT INTO `erp_ruinuo_setting` VALUES (13, '系统配置', 'system', 'admin', '[{\"field\": \"system_name\", \"title\": \"系统名称\"}, {\"field\": \"system_jwt\", \"title\": \"JWT密钥\"}, {\"field\": \"system_logo\", \"title\": \"系统logo\"}, {\"field\": \"redis_host\", \"title\": \"redis连接地址\"}, {\"field\": \"redis_port\", \"title\": \"redis端口\"}, {\"field\": \"redis_pass\", \"title\": \"redis密码\"}, {\"field\": \"file_type\", \"title\": \"默认存储方式\"}, {\"field\": \"file_mine\", \"title\": \"允许文件类型\"}, {\"field\": \"file_size\", \"title\": \"允许文件大小\"}, {\"field\": \"file_local\", \"title\": \"本地存储路径\"}, {\"field\": \"aliyun_id\", \"title\": \"阿里云accessId\"}, {\"field\": \"aliyun_secret\", \"title\": \"阿里云accessSecret\"}, {\"field\": \"aliyun_bucket\", \"title\": \"阿里云bucket\"}, {\"field\": \"aliyun_endpoint\", \"title\": \"阿里云endpoint\"}, {\"field\": \"aliyun_url\", \"title\": \"阿里云url\"}, {\"field\": \"qiniu_id\", \"title\": \"七牛云accessKey\"}, {\"field\": \"qiniu_secret\", \"title\": \"七牛云secretKey\"}, {\"field\": \"qiniu_bucket\", \"title\": \"七牛云bucket\"}, {\"field\": \"qiniu_url\", \"title\": \"七牛云url\"}, {\"field\": \"qcloud_region\", \"title\": \"腾讯云region\"}, {\"field\": \"qcloud_appid\", \"title\": \"腾讯云appId\"}, {\"field\": \"qcloud_id\", \"title\": \"腾讯云secretId\"}, {\"field\": \"qcloud_secret\", \"title\": \"腾讯云secretKey\"}, {\"field\": \"qcloud_bucket\", \"title\": \"腾讯云bucket\"}, {\"field\": \"qcloud_url\", \"title\": \"腾讯云cdn\"}, {\"field\": \"shop_key\", \"title\": \"应用商店KEY\"}, {\"field\": \"shop_url\", \"title\": \"应用商店URL\"}, {\"field\": \"baidu_key\", \"title\": \"百度地图KEY\"}]', '{\"qiniu_id\": \"\", \"shop_key\": \"42f365079960b3d5b9b4e1fab35d1721\", \"shop_url\": \"https://www.ruinuocrm.com/\", \"aliyun_id\": \"\", \"baidu_key\": \"d0W5oDspnVKXpMd7NYslCA7ZZk1DCIEH\", \"file_mine\": \"doc,docx,gif,ico,icon,jpg,mp3,mp4,p12,pem,png,rar,jpeg,xlsx,xls,zip\", \"file_size\": \"1500\", \"file_type\": \"1\", \"qcloud_id\": \"\", \"qiniu_url\": \"\", \"aliyun_url\": \"\", \"file_local\": \"uploads\", \"qcloud_url\": \"\", \"redis_host\": \"127.0.0.1\", \"redis_pass\": \"890723\", \"redis_port\": \"6379\", \"system_jwt\": \"ruinuoqw_056jwt712_gd\", \"system_logo\": \"https://oss.ruinuocrm.com/uploads/20240421/446633b867afc8b3e4a27bda3f026b6d.png\", \"system_name\": \"瑞诺科技低代码\", \"qcloud_appid\": \"\", \"qiniu_bucket\": \"\", \"qiniu_secret\": \"\", \"aliyun_bucket\": \"\", \"aliyun_secret\": \"\", \"qcloud_bucket\": \"\", \"qcloud_region\": \"\", \"qcloud_secret\": \"\", \"aliyun_endpoint\": \"\"}', '[{\"tag\": \"legend\", \"content\": \"基本设置\", \"elem_id\": \"60d4_1713710594237_11794\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"system_name\", \"title\": \"系统名称\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"4736_1713710392175_21729\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"system_jwt\", \"title\": \"JWT密钥\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"3bf6_1713710399348_87284\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"upimg\", \"help\": \"\", \"hide\": \"2\", \"field\": \"system_logo\", \"title\": \"系统logo\", \"value\": \"\", \"elem_id\": \"5ea7_1713710406989_03600\", \"file_num\": \"2\", \"required\": \"1\", \"file_type\": \"1\", \"hide_label\": \"2\", \"file_select\": \"2\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"shop_key\", \"title\": \"应用商店KEY\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"28c3_1714036265157_02341\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"shop_url\", \"title\": \"应用商店URL\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"7a3b_1714036259351_70572\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"baidu_key\", \"title\": \"百度地图KEY\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"94de_1714036260961_26774\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"\"}, {\"tag\": \"legend\", \"content\": \"Redis设置\", \"elem_id\": \"1290_1713710625358_93338\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"redis_host\", \"title\": \"连接地址\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"4b1e_1713710650328_50776\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"redis_port\", \"title\": \"端口\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"2de0_1713710651655_08563\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"redis_pass\", \"title\": \"密码\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"6e6c_1713710653045_86725\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"tag\": \"legend\", \"content\": \"上传设置\", \"elem_id\": \"2f32_1713710693152_65235\"}, {\"col\": \"12\", \"tag\": \"radio\", \"help\": \"\", \"hide\": \"2\", \"field\": \"file_type\", \"title\": \"默认存储方式\", \"value\": \"1\", \"elem_id\": \"806d_1713710705787_34359\", \"readonly\": \"2\", \"required\": \"1\", \"event_val\": [{\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"1\", \"event_type\": \"=\", \"event_field\": \"file_local\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"aliyun_id\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"aliyun_secret\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"aliyun_bucket\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"aliyun_endpoint\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"2\", \"event_type\": \"=\", \"event_field\": \"aliyun_url\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"3\", \"event_type\": \"=\", \"event_field\": \"qiniu_id\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"3\", \"event_type\": \"=\", \"event_field\": \"qiniu_secret\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"3\", \"event_type\": \"=\", \"event_field\": \"qiniu_bucket\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"3\", \"event_type\": \"=\", \"event_field\": \"qiniu_url\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"4\", \"event_type\": \"=\", \"event_field\": \"qcloud_region\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"4\", \"event_type\": \"=\", \"event_field\": \"qcloud_appid\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"4\", \"event_type\": \"=\", \"event_field\": \"qcloud_id\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"4\", \"event_type\": \"=\", \"event_field\": \"qcloud_secret\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"4\", \"event_type\": \"=\", \"event_field\": \"qcloud_bucket\"}, {\"tag\": \"radio\", \"field\": \"file_type\", \"required\": 1, \"event_val\": \"4\", \"event_type\": \"=\", \"event_field\": \"qcloud_url\"}], \"hide_label\": \"2\", \"options_num\": \"upload_type\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"file_mine\", \"title\": \"允许文件类型\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"175e_1713710729638_19635\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"file_size\", \"title\": \"允许文件大小\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"isinteger\", \"elem_id\": \"8952_1713716328187_40052\", \"readonly\": \"2\", \"required\": \"1\", \"hide_label\": \"2\", \"placeholder\": \"\", \"group_prefix\": \"\", \"group_suffix\": \"KB\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"file_local\", \"title\": \"本地存储路径\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"6a34_1713710760685_42227\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"aliyun_id\", \"title\": \"accessId\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"6405_1713710769771_40370\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"aliyun_secret\", \"title\": \"accessSecret\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"488d_1713710773722_31058\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"aliyun_bucket\", \"title\": \"bucket\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"49ae_1713710775323_14675\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"aliyun_endpoint\", \"title\": \"endpoint\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"8a72_1713710772201_14377\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"aliyun_url\", \"title\": \"url\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"7550_1713710812414_14934\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qiniu_id\", \"title\": \"accessKey\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"77a5_1713711006909_71375\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qiniu_secret\", \"title\": \"secretKey\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"101f_1713711005089_21749\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qiniu_bucket\", \"title\": \"bucket\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"1343_1713710999115_03859\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qiniu_url\", \"title\": \"url\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"50d9_1713710996881_73842\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qcloud_region\", \"title\": \"region\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"7a8c_1713711143999_24244\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qcloud_appid\", \"title\": \"appId\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"84b5_1713711159558_22041\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qcloud_id\", \"title\": \"secretId\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"456c_1713711157718_85089\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qcloud_secret\", \"title\": \"secretKey\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"8dcd_1713711155893_84811\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qcloud_bucket\", \"title\": \"bucket\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"709e_1713711154255_29162\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}, {\"col\": \"12\", \"tag\": \"input\", \"help\": \"\", \"hide\": \"2\", \"only\": \"2\", \"field\": \"qcloud_url\", \"title\": \"cdn\", \"value\": \"\", \"prefix\": \"\", \"suffix\": \"\", \"verify\": \"\", \"elem_id\": \"88ed_1713711151958_44437\", \"readonly\": \"2\", \"required\": \"2\", \"hide_label\": \"2\", \"placeholder\": \"\"}]', 'form_right', 0, '2024-04-21 21:50:53', '2024-04-25 17:20:58', 1, 1, 1);

-- ----------------------------
-- Table structure for erp_ruinuo_verify
-- ----------------------------
DROP TABLE IF EXISTS `erp_ruinuo_verify`;
CREATE TABLE `erp_ruinuo_verify`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
  `guize` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '验证规则',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` int(11) NULL DEFAULT NULL COMMENT '新增人',
  `update_id` int(11) NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '验证管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of erp_ruinuo_verify
-- ----------------------------
INSERT INTO `erp_ruinuo_verify` VALUES (90, '手机号', 'isphone', '/^1[134578]{1}[0-9]{9}$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (91, '身份证', 'iscard', '/(^([\\d]{15}|[\\d]{18}|[\\d]{17}x)$)/', NULL, '2024-04-27 14:03:57', NULL, 1);
INSERT INTO `erp_ruinuo_verify` VALUES (92, 'QQ号', 'isqq', '/^[1-9][0-9]{4,}$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (93, '日期', 'isdate', '/^\\d{4}(\\-|\\/|.)\\d{1,2}\\1\\d{1,2}$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (94, '时间', 'isdatetime', '/^\\d{4}[\\-](0?[1-9]|1[012])[\\-](0?[1-9]|[12][0-9]|3[01])(\\s+(0?[0-9]|1[0-9]|2[0-3])\\:(0?[0-9]|[1-5][0-9])\\:(0?[0-9]|[1-5][0-9]))?$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (95, '邮箱', 'isemail', '/^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (96, 'URL', 'isurl', '/^http(s?):\\/\\/(?:[A-Za-z0-9-_]+\\.)+[A-Za-z]{2,4}(?:[\\/\\?#][\\/=\\?%\\-&~`@[\\]\\\':+!\\.#\\w]*)?$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (97, '整数', 'isinteger', '/^[-\\+]?\\d+$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (98, '邮编', 'iszip', '/^[1-9]\\d{5}$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (99, 'ip地址', 'isip', '/^(?:(?:[01]?\\d{1,2}|2[0-4]\\d|25[0-5])\\.){3}(?:[01]?\\d{1,2}|2[0-4]\\d|25[0-5])$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (100, '金额', 'ismoney', '/^([1-9][\\d]{0,7}|0)(\\.[\\d]{1,2})?$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (101, '浮点数', 'isdouble', '/^[-\\+]?\\d+(\\.\\d+)?$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (102, '字母', 'isalpha', '/^[A-Za-z]+$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (103, '字母和数字', 'isalphaNum', '/^[A-Za-z0-9]+$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (104, '字母数字和下划线破折号', 'isalphaDash', '/^[A-Za-z0-9\\-\\_]+$/', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (105, '汉字', 'ischs', '/^[\\x{4e00}-\\x{9fa5}]+$/u', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (106, '汉字字母', 'ischsAlpha', '/^[\\x{4e00}-\\x{9fa5}a-zA-Z]+$/u', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (107, '汉字字母和数字', 'ischsAlphaNum', '/^[\\x{4e00}-\\x{9fa5}a-zA-Z0-9]+$/u', NULL, NULL, NULL, NULL);
INSERT INTO `erp_ruinuo_verify` VALUES (108, '汉字字母数字下划线破折号', 'ischsDash', '/^[\\x{4e00}-\\x{9fa5}a-zA-Z0-9\\_\\-]+$/u', NULL, '2023-12-14 16:44:37', NULL, 1);
INSERT INTO `erp_ruinuo_verify` VALUES (109, 'JSON', 'json', '/[^,:{}\\\\[\\\\]0-9.\\-+Eaeflnr-u \\n\\r\\t]/', NULL, '2024-04-23 14:16:32', NULL, 1);
INSERT INTO `erp_ruinuo_verify` VALUES (110, '字母和下划线破折号', 'isalphaAndDash', '/^[A-Za-z\\-\\_]+$/', '2024-04-27 12:56:32', '2024-04-27 12:56:32', 1, 1);

SET FOREIGN_KEY_CHECKS = 1;