/*
 Navicat Premium Data Transfer

 Source Server         : 阿里云
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : rm-2ze41ef9a1037xwc8po.mysql.rds.aliyuncs.com:3306
 Source Schema         : any_anli

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

 Date: 02/06/2020 13:00:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for lm_admin
-- ----------------------------
DROP TABLE IF EXISTS `lm_admin`;
CREATE TABLE `lm_admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员用户名',
  `password` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员密码',
  `group_id` mediumint(8) NOT NULL COMMENT '分组ID',
  `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
  `realname` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '真实姓名',
  `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话号码',
  `ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP地址',
  `mdemail` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '传递修改密码参数加密',
  `status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '审核状态',
  `avatar` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
  `create_time` int(11) NOT NULL COMMENT '添加时间',
  `update_time` int(11) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `admin_username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台管理员' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_admin
-- ----------------------------
INSERT INTO `lm_admin` VALUES (1, 'admin', '$2y$12$Ak58w84WGSTMUYP5xwqACuo/skM/vX.GffuEDRt2dbeBPHdOqHeWC', 1, 'admin@admin.com', '😀😁😂😃😄😅😆😉😊😋', '10086', '127.0.0.1', '0', 1, '/storage/uploads/20200109\\c710700a3bb36d594ac98e792e4705b0.png', 1482132862, 1583136277);
INSERT INTO `lm_admin` VALUES (12, 'anyluck', '$2y$12$SkjoA8vfD2dS2JeXtKBNme4aY3MEVwTueKBO2YFGpG69q6GX1Owty', 1, '', '', '13323821192', '', '0', 1, '', 1590638270, 1590638270);

-- ----------------------------
-- Table structure for lm_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `lm_admin_log`;
CREATE TABLE `lm_admin_log`  (
  `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表id',
  `admin_id` int(10) NULL DEFAULT NULL COMMENT '管理员id',
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `log_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `log_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `log_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志描述',
  `log_agent` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `log_ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'ip地址',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '日志时间',
  `update_time` int(11) NULL DEFAULT NULL,
  `status` tinyint(1) NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE,
  INDEX `admin_id`(`admin_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14224 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_admin_log
-- ----------------------------
INSERT INTO `lm_admin_log` VALUES (14204, 1, 'admin', '/admin/adminlog/index.html', '点击菜单', '日志管理', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993441, 1590993441, 1);
INSERT INTO `lm_admin_log` VALUES (14205, 1, 'admin', '/admin/system/configlist.html', '点击菜单', '配置列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993447, 1590993447, 1);
INSERT INTO `lm_admin_log` VALUES (14206, 1, 'admin', '/admin/system/configlist.html', '点击菜单', '配置列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993448, 1590993448, 1);
INSERT INTO `lm_admin_log` VALUES (14207, 1, 'admin', '/admin/system/configedit.html', '{\"id\":\"1\"}', '编辑配置', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993468, 1590993468, 1);
INSERT INTO `lm_admin_log` VALUES (14208, 1, 'admin', '/admin/system/configedit.html', '{\"id\":\"1\",\"pid\":\"site\",\"code\":\"site_name\",\"value\":\"\\u5343\\u7ffc\\u5546\\u57ce\\u5b98\\u7f5122\",\"remark\":\"\\u7f51\\u7ad9\\u540d\\u79f0\"}', '编辑配置', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993472, 1590993472, 1);
INSERT INTO `lm_admin_log` VALUES (14209, 1, 'admin', '/admin/system/configedit.html', '{\"id\":\"1\"}', '编辑配置', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993475, 1590993475, 1);
INSERT INTO `lm_admin_log` VALUES (14210, 1, 'admin', '/admin/adminlog/index.html', '点击菜单', '日志管理', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993489, 1590993489, 1);
INSERT INTO `lm_admin_log` VALUES (14211, 1, 'admin', '/admin/system/configlist.html', '点击菜单', '配置列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993490, 1590993490, 1);
INSERT INTO `lm_admin_log` VALUES (14212, 1, 'admin', '/admin/system/configlist.html', '点击菜单', '配置列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993492, 1590993492, 1);
INSERT INTO `lm_admin_log` VALUES (14213, 1, 'admin', '/admin/database/restore.html', '点击菜单', '还原数据库', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993515, 1590993515, 1);
INSERT INTO `lm_admin_log` VALUES (14214, 1, 'admin', '/admin/database/restore.html', '点击菜单', '还原数据库', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993515, 1590993515, 1);
INSERT INTO `lm_admin_log` VALUES (14215, 1, 'admin', '/admin/database/index.html', '点击菜单', '数据库列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993518, 1590993518, 1);
INSERT INTO `lm_admin_log` VALUES (14216, 1, 'admin', '/admin/database/index.html', '点击菜单', '数据库列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993519, 1590993519, 1);
INSERT INTO `lm_admin_log` VALUES (14217, 1, 'admin', '/admin/auth/adminrule.html', '点击菜单', '权限列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993527, 1590993527, 1);
INSERT INTO `lm_admin_log` VALUES (14218, 1, 'admin', '/admin/auth/adminrule.html', '点击菜单', '权限列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993527, 1590993527, 1);
INSERT INTO `lm_admin_log` VALUES (14219, 1, 'admin', '/admin/auth/group.html', '点击菜单', '权限组', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993530, 1590993530, 1);
INSERT INTO `lm_admin_log` VALUES (14220, 1, 'admin', '/admin/auth/group.html', '点击菜单', '权限组', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993531, 1590993531, 1);
INSERT INTO `lm_admin_log` VALUES (14221, 1, 'admin', '/admin/auth/adminlist.html', '点击菜单', '管理员列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993533, 1590993533, 1);
INSERT INTO `lm_admin_log` VALUES (14222, 1, 'admin', '/admin/auth/adminlist.html', '点击菜单', '管理员列表', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590993533, 1590993533, 1);
INSERT INTO `lm_admin_log` VALUES (14223, 1, 'admin', '/admin/adminlog/index.html', '点击菜单', '日志管理', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36', '127.0.0.1', 1590995934, 1590995934, 1);

-- ----------------------------
-- Table structure for lm_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `lm_auth_group`;
CREATE TABLE `lm_auth_group`  (
  `id` smallint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分组id',
  `title` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `status` tinyint(1) NULL DEFAULT 0 COMMENT '状态',
  `rules` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '规则',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '添加时间',
  `update_time` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE,
  UNIQUE INDEX `title`(`title`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员分组' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_auth_group
-- ----------------------------
INSERT INTO `lm_auth_group` VALUES (1, '管理权限', 1, '155,173,174,156,169,170,172,157,176,158,177,159,178,179,180,161,181,182,183,162,184,185,163,164,166,167,168,165,1,2,20,21,40,34,39,148,149,150,151,152,153,154,73,3,4,5,9,10,11,12,22,13,6,7,8,14,15,16,17,18,19,26,27,28,29,30,31,32,33,35,36,37,38,', 1465114224, 1579664405);

-- ----------------------------
-- Table structure for lm_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `lm_auth_rule`;
CREATE TABLE `lm_auth_rule`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `href` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接',
  `title` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态1 可以用，0 所有禁止使用',
  `auth_open` tinyint(2) NOT NULL DEFAULT 0 COMMENT '1公开 0不公开',
  `menu_status` tinyint(1) NULL DEFAULT 0 COMMENT '0 不显示，1 显示',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标样式',
  `condition` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '条件',
  `pid` int(5) NOT NULL DEFAULT 0 COMMENT '父栏目ID',
  `sort` int(11) NULL DEFAULT 0 COMMENT '排序',
  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
  `update_time` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE,
  INDEX `href`(`href`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 208 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限节点' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_auth_rule
-- ----------------------------
INSERT INTO `lm_auth_rule` VALUES (1, 'System', '系统', 1, 1, 0, 1, 'fa fa-home', '', 0, 58, 1446535750, 1571966892);
INSERT INTO `lm_auth_rule` VALUES (2, 'System', '系统设置', 1, 1, 0, 1, 'fa fa-gears', '', 1, 0, 1446535789, 1571882291);
INSERT INTO `lm_auth_rule` VALUES (3, 'Database', '数据库管理', 1, 1, 0, 1, 'fa fa-database', '', 1, 0, 1446535805, 0);
INSERT INTO `lm_auth_rule` VALUES (4, 'Database/restore', '还原数据库', 2, 1, 0, 1, 'fa fa-database', '', 3, 0, 1446535750, 0);
INSERT INTO `lm_auth_rule` VALUES (5, 'Database/backup', '数据库备份', 2, 1, 0, 0, 'fa fa-database', '', 3, 0, 1446535834, 0);
INSERT INTO `lm_auth_rule` VALUES (6, 'Auth', '权限管理', 1, 1, 0, 1, 'fa fa-cog', '', 1, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (7, 'Auth/adminRule', '权限列表', 1, 1, 0, 1, 'fa fa-cog', '', 6, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (8, 'Auth/ruleEdit', '权限编辑', 2, 1, 0, 0, 'fa fa-cog', '', 7, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (9, 'Database/repair', '数据库修复', 2, 1, 0, 0, '', '', 3, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (10, 'Database/import', '数据还原', 2, 1, 0, 0, '', '', 3, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (11, 'Database/downFile', '数据下载', 2, 1, 0, 0, '', '', 3, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (12, 'Database/delSqlFiles', '删除数据库', 2, 1, 0, 0, '', '', 3, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (13, 'Database/index', '数据库列表', 1, 1, 0, 1, 'fa fa-database', '', 3, 1, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (14, 'Auth/ruleState', '菜单显示或者隐藏', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (15, 'Auth/ruleOpen', '权限是否验证', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (16, 'Auth/ruleSort', '权限排序', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (17, 'Auth/ruleDel', '权限删除', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (18, 'Auth/ruleSelectDel', '权限批量删除', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (19, 'Auth/ruleAdd', '权限增加', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (20, 'System/index', '站点设置', 1, 1, 0, 1, 'fa fa-gears', '', 2, 0, 0, 1567228601);
INSERT INTO `lm_auth_rule` VALUES (21, 'Adminlog/index', '日志管理', 1, 1, 0, 1, 'fa fa-life-ring', '', 2, 0, 0, 1566007925);
INSERT INTO `lm_auth_rule` VALUES (22, 'Database/optimize', '数据库优化', 1, 1, 0, 0, '', '', 3, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (26, 'Auth/group', '权限组', 1, 1, 0, 1, 'fa fa-globe', '', 6, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (27, 'Auth/groupDel', '用户组删除', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (28, 'Auth/groupAdd', '用户组添加', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (29, 'Auth/groupEdit', '用户组修改', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (30, 'Auth/groupState', '用户组状态修改', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (31, 'Auth/groupSelectDel', '用户组批量删除', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (32, 'Auth/groupAccess', '用户组显示权限', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (33, 'Auth/groupSetaccess', '用户组保存权限', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (34, 'Uploads/uploads', '上传文件', 1, 1, 0, 0, 'fa fa-adjust', '', 2, 0, 0, 1571966280);
INSERT INTO `lm_auth_rule` VALUES (35, 'Auth/adminList', '管理员列表', 1, 1, 0, 1, 'fa fa-user-circle', '', 6, 0, 1, 0);
INSERT INTO `lm_auth_rule` VALUES (36, 'Auth/adminAdd', '添加管理员', 1, 1, 0, 0, '', '', 35, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (37, 'Auth/adminDel', '删除管理员', 1, 1, 0, 0, '', '', 35, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (38, 'Auth/adminState', '管理员状态', 1, 1, 0, 0, '', '', 35, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (39, 'Index/password', '修改密码', 1, 1, 0, 0, '', '', 2, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (40, 'Adminlog/delete', '删除日志', 1, 1, 0, 0, '', '', 21, 0, 0, 0);
INSERT INTO `lm_auth_rule` VALUES (148, 'System/configlist', '配置列表', 1, 1, 0, 1, 'fa fa-align-justify', '', 2, 0, 0, NULL);
INSERT INTO `lm_auth_rule` VALUES (149, 'System/configAdd', '添加配置', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
INSERT INTO `lm_auth_rule` VALUES (150, 'System/configEdit', '编辑配置', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
INSERT INTO `lm_auth_rule` VALUES (151, 'System/configDel', '删除配置', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
INSERT INTO `lm_auth_rule` VALUES (152, 'System/configState', '配置状态', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
INSERT INTO `lm_auth_rule` VALUES (153, 'System/configGroupAdd', '配置组添加', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
INSERT INTO `lm_auth_rule` VALUES (154, 'System/configGroupDel', '配置组删除', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);

-- ----------------------------
-- Table structure for lm_banner
-- ----------------------------
DROP TABLE IF EXISTS `lm_banner`;
CREATE TABLE `lm_banner`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片地址',
  `url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接地址',
  `status` int(1) NOT NULL DEFAULT 0 COMMENT '0 显示 1 不显示',
  `pai` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '轮播图' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of lm_banner
-- ----------------------------
INSERT INTO `lm_banner` VALUES (1, '国寿少儿2', 'http://quyum.oss-cn-huhehaote.aliyuncs.com/guanwang/0008de7a746db7b41de523ef259f05f427e3d805.png', 'xcx.sdsxxkn.com2', 0, 2);

-- ----------------------------
-- Table structure for lm_config
-- ----------------------------
DROP TABLE IF EXISTS `lm_config`;
CREATE TABLE `lm_config`  (
  `id` smallint(5) NOT NULL AUTO_INCREMENT,
  `code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '解释,备注',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'site',
  `status` tinyint(1) NULL DEFAULT 1,
  `create_time` int(11) NULL DEFAULT NULL,
  `update_time` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE,
  UNIQUE INDEX `code`(`code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置参数表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_config
-- ----------------------------
INSERT INTO `lm_config` VALUES (1, 'site_name', '千翼商城官网', '网站名称', 'site', 1, 0, 1590993472);
INSERT INTO `lm_config` VALUES (2, 'site_phone', '3', '网站客服服务电话', 'site', 0, 0, 1579406816);
INSERT INTO `lm_config` VALUES (3, 'site_state', '1', '状态', 'site', 1, 0, 0);
INSERT INTO `lm_config` VALUES (4, 'site_logo', '/storage/uploads/20200529/ad110b5e57ac537529fe3c2a2bf8cdfc.png', '网站logo图', 'site', 1, 0, 0);
INSERT INTO `lm_config` VALUES (5, 'site_mobile_logo', 'site_mobile_logo.png', '默认网站手机端logo', 'site', 0, 0, 1579406806);
INSERT INTO `lm_config` VALUES (6, 'site_logowx', 'site_logowx.jpg', '微信网站二维码', 'site', 0, 0, 1579406800);
INSERT INTO `lm_config` VALUES (7, 'site_icp', '2', 'ICP备案号', 'site', 1, 0, 0);
INSERT INTO `lm_config` VALUES (8, 'site_tel400', '40002541852', '解释,备注', 'site', 1, 0, 0);
INSERT INTO `lm_config` VALUES (9, 'site_email', 'www.794230322@outlook.com', '电子邮件', 'site', 1, 0, 0);
INSERT INTO `lm_config` VALUES (10, 'site_copyright', '千翼科技版权所有@2019', '底部版权信息', 'site', 1, 0, 0);
INSERT INTO `lm_config` VALUES (11, 'captcha_status_login', '1', '会员登录是否需要验证码', 'site', 1, 0, 0);
INSERT INTO `lm_config` VALUES (12, 'captcha_status_register', '1', '会员注册是否验证码', 'site', 1, 0, 0);
INSERT INTO `lm_config` VALUES (14, 'sms_appid', 'LTAIesI7qxnHLgKE', '短信平台账号', 'sms', 1, 0, 0);
INSERT INTO `lm_config` VALUES (15, 'sms_secret', '[REDACTED]', '短信平台密钥', 'sms', 1, 0, 0);
INSERT INTO `lm_config` VALUES (16, 'email_host', 'smtp.qq.com', '邮箱地址', 'email', 0, 0, 1579406788);
INSERT INTO `lm_config` VALUES (17, 'email_port', '25', '邮箱端口', 'email', 0, 0, 1579406821);
INSERT INTO `lm_config` VALUES (18, 'email_addr', '994927909@qq.com', '邮箱发件人地址', 'email', 0, 0, 1579406822);
INSERT INTO `lm_config` VALUES (19, 'email_id', '994927909@qq.com', '身份验证用户名', 'email', 0, 0, 1579406824);
INSERT INTO `lm_config` VALUES (20, 'email_pass', '11211', '用户名密码', 'email', 0, 0, 1579406828);
INSERT INTO `lm_config` VALUES (21, 'email_secure', 'smtp', '邮箱发送协议', 'email', 0, 0, 1579406829);
INSERT INTO `lm_config` VALUES (22, 'upload_file_type', 'bmp|png|gif|jpg|jpeg|zip|rar|txt|ppt|xls|doc|mp3|mp4', '图片上传保存方式', 'upload', 1, 0, 0);
INSERT INTO `lm_config` VALUES (23, 'cache_open', '0', '是否开启缓存', 'site', 0, 0, 1579406834);
INSERT INTO `lm_config` VALUES (24, 'alioss_accessid', '', 'accessid', 'oss', 0, 0, 1579406846);
INSERT INTO `lm_config` VALUES (25, 'alioss_accesssecret', '', 'oss_accesssecret', 'oss', 0, 0, 1579406843);
INSERT INTO `lm_config` VALUES (26, 'alioss_bucket', '', 'oss_bucket', 'oss', 0, 0, 1579406841);
INSERT INTO `lm_config` VALUES (27, 'alioss_endpoint', '', 'oss_endpoint', 'oss', 0, 0, 1579406846);
INSERT INTO `lm_config` VALUES (28, 'aliendpoint_type', '0', 'aliendpoint_type', 'oss', 0, 0, 1579406848);
INSERT INTO `lm_config` VALUES (29, 'node_site_url', '', '站内IM服务器地址', 'im', 0, 0, 1579406849);
INSERT INTO `lm_config` VALUES (30, 'node_site_use', '0', '是否启用im', 'im', 0, 0, 1579406851);
INSERT INTO `lm_config` VALUES (31, 'qq_isuse', '1', '是否使用QQ互联', 'qq', 0, 0, 1579406852);
INSERT INTO `lm_config` VALUES (32, 'qq_appid', '', 'qq互联id', 'qq', 0, 0, 1579406856);
INSERT INTO `lm_config` VALUES (33, 'qq_appkey', '', 'qq秘钥', 'qq', 0, 0, 1579406857);
INSERT INTO `lm_config` VALUES (34, 'sina_isuse', '1', '是的使用微博登录', 'sina', 0, 0, 1579406858);
INSERT INTO `lm_config` VALUES (35, 'sina_wb_akey', '', '新浪id', 'sina', 0, 0, 1579406859);
INSERT INTO `lm_config` VALUES (36, 'sina_wb_skey', '', '新浪秘钥', 'sina', 0, 0, 1579406860);
INSERT INTO `lm_config` VALUES (37, 'sms_register', '0', '是否手机注册', 'mobile', 0, 0, 1579406861);
INSERT INTO `lm_config` VALUES (38, 'sms_login', '0', '是否手机登录', 'mobile', 0, 0, 1579406869);
INSERT INTO `lm_config` VALUES (39, 'sms_password', '0', '是否手机找回密码', 'mobile', 0, 0, 1579406872);
INSERT INTO `lm_config` VALUES (43, 'baidu_ak', '22bb7221fc279a484895afcc6a0bb33a', '百度地图AK密钥', 'baidu', 0, 0, 1579406873);
INSERT INTO `lm_config` VALUES (44, 'site_licence', '', '营业执照', 'site', 0, 0, 1579406874);
INSERT INTO `lm_config` VALUES (45, 'site_domain', 'https://www.quyum.com', '网站地址', 'site', 0, 0, 1579406875);
INSERT INTO `lm_config` VALUES (46, 'upload_file_max', '2048', '最大文件上传大小', 'upload', 1, 0, 0);
INSERT INTO `lm_config` VALUES (47, 'site_seo_title', '内容管理系统', '首页标题', 'site', 0, 0, 1579406877);
INSERT INTO `lm_config` VALUES (48, 'site_seo_keywords', '小程序,管理系统，thinkphp6', '首页关键词', 'site', 0, 0, 1579406880);
INSERT INTO `lm_config` VALUES (49, 'site_seo_desc', '', '首页描述', 'site', 0, 0, 1579406881);
INSERT INTO `lm_config` VALUES (50, 'upload_water', '1', '水印开始关闭', 'upload', 0, 0, 1579406891);
INSERT INTO `lm_config` VALUES (51, 'upload_water_position', '', '水印位置', 'upload', 0, 0, 1579406890);
INSERT INTO `lm_config` VALUES (52, 'sms_product', 'lemocms', '产品', 'sms', 0, 0, 1579406888);
INSERT INTO `lm_config` VALUES (53, 'sms_template', 'SMS_158941284', '模板id', 'sms', 0, 0, 1579406886);
INSERT INTO `lm_config` VALUES (54, 'appid', 'wx4025e13383042216', '微信appid', 'weixin', 0, 0, 1579406886);
INSERT INTO `lm_config` VALUES (55, 'appsecret', '[REDACTED]', '微信密钥', 'weixin', 0, NULL, NULL);
INSERT INTO `lm_config` VALUES (56, 'access_token', NULL, '微信密钥', 'weixin', 1, NULL, NULL);
INSERT INTO `lm_config` VALUES (57, 'expires_in', NULL, '微信密钥时间', 'weixin', 1, NULL, NULL);

-- ----------------------------
-- Table structure for lm_config_group
-- ----------------------------
DROP TABLE IF EXISTS `lm_config_group`;
CREATE TABLE `lm_config_group`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_config_group
-- ----------------------------
INSERT INTO `lm_config_group` VALUES (1, 'site', '网站');
INSERT INTO `lm_config_group` VALUES (2, 'qq', 'qq');
INSERT INTO `lm_config_group` VALUES (3, 'sms', '短信');
INSERT INTO `lm_config_group` VALUES (4, 'email', '邮箱');
INSERT INTO `lm_config_group` VALUES (5, 'oss', 'oss');
INSERT INTO `lm_config_group` VALUES (6, 'sina', '新浪');
INSERT INTO `lm_config_group` VALUES (7, 'im', 'im');
INSERT INTO `lm_config_group` VALUES (8, 'upload', '上传');
INSERT INTO `lm_config_group` VALUES (9, 'mobile', '手机');
INSERT INTO `lm_config_group` VALUES (10, '百度', '百度配置');

-- ----------------------------
-- Table structure for lm_field
-- ----------------------------
DROP TABLE IF EXISTS `lm_field`;
CREATE TABLE `lm_field`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `moduleid` float UNSIGNED NOT NULL DEFAULT 0 COMMENT '模型id',
  `field` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名字',
  `required` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否必须',
  `minlength` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最少长度',
  `maxlength` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大长度',
  `rule` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规则',
  `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '错误提示',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段类型',
  `is_search` tinyint(1) NULL DEFAULT 0 COMMENT '是否可以搜索 0  不可以，1 搜索',
  `value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field_define` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `option` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '默认值',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `create_time` int(11) NOT NULL DEFAULT 0,
  `update_time` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 94 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_field
-- ----------------------------
INSERT INTO `lm_field` VALUES (31, 32, 'column_id', '栏目', 1, 0, 6, '', '必须选择一个栏目', 'column_id', 0, '', NULL, '', 1, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (32, 32, 'title', '标题', 1, 0, 80, '', '标题必须为1-80个字符', 'text', 0, '', NULL, '', 2, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (33, 32, 'keywords', '关键词', 1, 0, 200, '', '关键词必须在0-200个内', 'text', 0, '', NULL, '', 3, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (34, 32, 'description', 'SEO简介', 1, 0, 0, '', '', 'textarea', 0, '', NULL, '', 4, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (35, 32, 'content', '内容', 0, 0, 255, '', '', 'editor', 0, 'ueditor', NULL, '0|ueditor', 5, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (36, 32, 'create_time', '创建时间', 1, 0, 11, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (37, 32, 'update_time', '更新时间', 1, 0, 11, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (38, 32, 'status', '状态', 1, 0, 1, '', '', 'radio', 0, '1', NULL, '0|未发布,1|发布', 7, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (39, 32, 'recommend', '允许评论', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止评论,1|允许评论', 8, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (40, 32, 'readpoint', '阅读收费', 0, 0, 5, '', '', 'number', 0, '0', NULL, '', 9, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (41, 32, 'is_read', '是否可阅读', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止,1|允许', 9, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (42, 32, 'hits', '点击次数', 0, 0, 8, '', '', 'number', 0, '1', NULL, '', 10, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (43, 32, 'visite', '访问权限', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|开启,1|关闭', 11, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (44, 32, 'posid', '推荐位', 0, 0, 1, '', '', 'posid', 0, '', NULL, '', 12, 12, 1571732224, 0);
INSERT INTO `lm_field` VALUES (45, 32, 'tags', '标签', 0, 0, 255, '', '', 'text', 0, '', NULL, '', 14, 1, 1571732224, 0);
INSERT INTO `lm_field` VALUES (46, 2, 'column_id', '栏目', 1, 1, 6, '', '必须选择一个栏目', 'column_id', 0, '', NULL, '', 1, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (47, 2, 'title', '标题', 1, 1, 80, '', '标题必须为1-80个字符', 'text', 0, '', NULL, '', 2, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (48, 2, 'keywords', '关键词', 1, 0, 200, '', '关键词必须在0-200个内', 'text', 0, '', NULL, '', 3, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (49, 2, 'description', 'SEO简介', 1, 0, 0, '', '', 'textarea', 0, '', NULL, '', 4, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (50, 2, 'content', '内容', 0, 0, 0, '', '', 'editor', 0, 'ueditor', NULL, '0|ueditor', 5, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (51, 2, 'create_time', '创建时间', 1, 0, 0, '', '', 'datetime', 0, '', NULL, '', 61, 1, 1571884340, 1571884945);
INSERT INTO `lm_field` VALUES (52, 2, 'update_time', '更新时间', 1, 0, 0, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (53, 2, 'status', '状态', 1, 0, 0, '', '', 'radio', 0, '1', NULL, '0|未发布,1|发布', 7, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (54, 2, 'recommend', '允许评论', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止评论,1|允许评论', 8, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (55, 2, 'readpoint', '阅读收费', 0, 0, 5, '', '', 'number', 0, '0', NULL, '', 9, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (56, 2, 'is_read', '是否可阅读', 0, 0, 5, '', '', 'radio', 0, '1', NULL, '0|禁止,1|允许', 9, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (57, 2, 'hits', '点击次数', 0, 0, 8, '', '', 'number', 0, '1', NULL, '', 10, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (58, 2, 'visite', '访问权限', 0, 0, 0, '', '', 'radio', 0, '1', NULL, '0|开启,1|关闭', 11, 1, 1571884340, 0);
INSERT INTO `lm_field` VALUES (59, 2, 'posid', '推荐位', 0, 0, 0, '', '', 'posid', 0, '', NULL, '', 12, 12, 1571884340, 0);
INSERT INTO `lm_field` VALUES (60, 3, 'column_id', '栏目', 1, 0, 6, '', '必须选择一个栏目', 'column_id', 0, '', NULL, '', 1, 1, 1572145912, 0);
INSERT INTO `lm_field` VALUES (61, 3, 'title', '标题', 1, 0, 180, '', '标题必须为1-180个字符', 'text', 0, '', NULL, '', 2, 1, 1572145912, 0);
INSERT INTO `lm_field` VALUES (62, 3, 'keywords', '关键词', 1, 0, 80, '', '', 'text', 0, '', NULL, '', 3, 1, 1572145912, 0);
INSERT INTO `lm_field` VALUES (63, 3, 'description', 'SEO简介', 1, 0, 0, '', '', 'textarea', 0, '', NULL, '', 4, 1, 1572145912, 0);
INSERT INTO `lm_field` VALUES (64, 3, 'tags', '标签', 0, 0, 0, '', '', 'text', 0, '', NULL, '', 5, 1, 1, 0);
INSERT INTO `lm_field` VALUES (65, 3, 'content', '内容', 0, 0, 0, '', '', 'editor', 0, 'ueditor', NULL, '0|ueditor', 6, 1, 1572145912, 0);
INSERT INTO `lm_field` VALUES (78, 6, 'column_id', '栏目', 1, 0, 6, '', '必须选择一个栏目', 'column_id', 0, '', NULL, '', 1, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (79, 6, 'title', '标题', 1, 0, 80, '', '标题必须为1-80个字符', 'text', 0, '', NULL, '', 2, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (80, 6, 'keywords', '关键词', 1, 0, 200, '', '关键词必须在0-200个内', 'text', 0, '', NULL, '', 3, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (81, 6, 'description', 'SEO简介', 1, 0, 0, '', '', 'textarea', 0, '', NULL, '', 4, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (82, 6, 'content', '内容', 0, 0, 255, '', '', 'editor', 0, 'ueditor', NULL, '0|ueditor', 5, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (83, 6, 'create_time', '创建时间', 1, 0, 11, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (84, 6, 'update_time', '更新时间', 1, 0, 11, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (85, 6, 'status', '状态', 1, 0, 1, '', '', 'radio', 0, '1', NULL, '0|未发布,1|发布', 7, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (86, 6, 'recommend', '允许评论', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止评论,1|允许评论', 8, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (87, 6, 'readpoint', '阅读收费', 0, 0, 5, '', '', 'number', 0, '0', NULL, '', 9, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (88, 6, 'is_read', '是否可阅读', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止,1|允许', 9, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (89, 6, 'hits', '点击次数', 0, 0, 8, '', '', 'number', 0, '1', NULL, '', 10, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (90, 6, 'visite', '访问权限', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|开启,1|关闭', 11, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (91, 6, 'posid', '推荐位', 0, 0, 1, '', '', 'posid', 0, '', NULL, '', 12, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (92, 6, 'tags', '标签', 0, 0, 255, '', '', 'text', 0, '', NULL, '', 14, 1, 1572870621, 0);
INSERT INTO `lm_field` VALUES (93, 6, 'occ_id', '土味乡情', 0, 0, 0, '', '', 'files', 0, '', 'varchar(255) NOT NULL DEFAULT \'\'', NULL, 50, 1, 1573720440, 1573720440);

-- ----------------------------
-- Table structure for lm_field_type
-- ----------------------------
DROP TABLE IF EXISTS `lm_field_type`;
CREATE TABLE `lm_field_type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字段类型',
  `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '中文类型名',
  `sort` int(4) NOT NULL DEFAULT 0 COMMENT '排序',
  `default_define` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '默认定义',
  `isoption` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否需要设置选项',
  `istring` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否自由字符',
  `rules` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '验证规则',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字段类型表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_field_type
-- ----------------------------
INSERT INTO `lm_field_type` VALUES (1, 'text', '输入框', 1, 'varchar(255) NOT NULL DEFAULT \'\'', 0, 1, '');
INSERT INTO `lm_field_type` VALUES (2, 'checkbox', '复选框', 2, 'varchar(50) NOT NULL DEFAULT \'\'', 1, 0, '');
INSERT INTO `lm_field_type` VALUES (3, 'textarea', '多行文本', 3, 'varchar(255) NOT NULL DEFAULT \'\'', 0, 1, '');
INSERT INTO `lm_field_type` VALUES (4, 'radio', '单选按钮', 4, 'char(10) NOT NULL DEFAULT \'\'', 1, 0, '');
INSERT INTO `lm_field_type` VALUES (5, 'switch', '开关', 5, 'tinyint(2) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, 'isBool');
INSERT INTO `lm_field_type` VALUES (6, 'array', '数组', 6, 'varchar(512) NOT NULL DEFAULT \'\'', 0, 0, '');
INSERT INTO `lm_field_type` VALUES (7, 'select', '下拉框', 7, 'char(10) NOT NULL DEFAULT \'\'', 1, 0, '');
INSERT INTO `lm_field_type` VALUES (8, 'image', '单张图', 8, 'int(5) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, 'isNumber');
INSERT INTO `lm_field_type` VALUES (9, 'tags', '标签', 10, 'varchar(255) NOT NULL DEFAULT \'\'', 0, 1, '');
INSERT INTO `lm_field_type` VALUES (10, 'number', '数字', 11, 'int(10) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, 'isNumber');
INSERT INTO `lm_field_type` VALUES (11, 'datetime', '日期和时间', 12, 'int(10) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, '');
INSERT INTO `lm_field_type` VALUES (12, 'ueditor', '百度编辑器', 13, 'text NOT NULL', 0, 1, '');
INSERT INTO `lm_field_type` VALUES (13, 'images', '多张图', 9, 'varchar(256) NOT NULL DEFAULT \'\'', 0, 0, '');
INSERT INTO `lm_field_type` VALUES (14, 'color', '颜色值', 17, 'varchar(7) NOT NULL DEFAULT \'\'', 0, 0, '');
INSERT INTO `lm_field_type` VALUES (15, 'file', '单文件', 15, 'int(5) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, 'isNumber');
INSERT INTO `lm_field_type` VALUES (16, 'files', '多文件', 16, 'varchar(255) NOT NULL DEFAULT \'\'', 0, 0, '');

-- ----------------------------
-- Table structure for lm_task
-- ----------------------------
DROP TABLE IF EXISTS `lm_task`;
CREATE TABLE `lm_task`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` int(11) NULL DEFAULT 0 COMMENT '0 实名制 1 下载注册 2 网页注册 3 关注投票 4 分享转发 5电子商务 6多天任务 7 特单任务',
  `user_id` int(11) NULL DEFAULT 0 COMMENT '用户id',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '任务名称',
  `explain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '任务说明',
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '任务步骤',
  `num` int(11) NULL DEFAULT 0 COMMENT '剩余数量',
  `nums` int(11) NULL DEFAULT 0 COMMENT '总数量',
  `money` decimal(11, 2) NULL COMMENT '实际金额',
  `put_money` decimal(11, 2) NULL COMMENT '上架金额',
  `status` int(11) NULL DEFAULT 0 COMMENT '0 审核中 1 审核通过 2 审核失败 3 已完成 4 已禁止',
  `msg` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '审核失败原因 ',
  `repeat` int(11) NULL DEFAULT 0 COMMENT '0 可以重复做 1 不可以 ',
  `end_task_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '设置的结束时间',
  `push_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '提交时间',
  `create_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建时间',
  `update_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '任务列表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_task
-- ----------------------------

-- ----------------------------
-- Table structure for lm_user
-- ----------------------------
DROP TABLE IF EXISTS `lm_user`;
CREATE TABLE `lm_user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用户',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '呢称',
  `pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '密码',
  `openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '微信登录openid',
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT 'token',
  `money` decimal(20, 2) NULL COMMENT '账号余额',
  `push_money` decimal(20, 2) NULL COMMENT '发布余额',
  `status` int(1) NULL DEFAULT 0 COMMENT '0 正常 1 禁止登录',
  `status_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '封号时间',
  `create_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建时间',
  `vip_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '会员到期时间',
  `vip_level` int(1) NULL DEFAULT 0 COMMENT '0 普通会员 1 周卡 2月卡 3 年卡 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of lm_user
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;
