/* 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', 'sbA6wnefJLD7pv7WipcxL0M3IMb3l9', '短信平台密钥', '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', 'cde471d1aca9ee5e93bd250a96aee5a9', '微信密钥', '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;