Gitinn Home Explore Help
Register Sign In
u321574
/
bts
mirror of https://github.com/anyluckwell/bts
1
1
Fork 0
Files Issues 0 Wiki
Branch: master
Branches Tags
bts
/
php
/
lm_admin.sql

lm_admin.sql 42 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 阿里云
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50728
    7. 

  7.  Source Host           : rm-2ze41ef9a1037xwc8po.mysql.rds.aliyuncs.com:3306
    8. 

  8.  Source Schema         : any_anli
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50728
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 02/06/2020 13:00:41
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for lm_admin
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `lm_admin`;
    24. 

  24. CREATE TABLE `lm_admin`  (
    25. 

  25.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
    26. 

  26.   `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员用户名',
    27. 

  27.   `password` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员密码',
    28. 

  28.   `group_id` mediumint(8) NOT NULL COMMENT '分组ID',
    29. 

  29.   `email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
    30. 

  30.   `realname` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '真实姓名',
    31. 

  31.   `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话号码',
    32. 

  32.   `ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP地址',
    33. 

  33.   `mdemail` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '传递修改密码参数加密',
    34. 

  34.   `status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '审核状态',
    35. 

  35.   `avatar` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
    36. 

  36.   `create_time` int(11) NOT NULL COMMENT '添加时间',
    37. 

  37.   `update_time` int(11) NOT NULL COMMENT '更新时间',
    38. 

  38.   PRIMARY KEY (`id`) USING BTREE,
    39. 

  39.   INDEX `admin_username`(`username`) USING BTREE
    40. 

  40. ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台管理员' ROW_FORMAT = Compact;
    41. 

  41. 

  42. -- ----------------------------
    43. 

  43. -- Records of lm_admin
    44. 

  44. -- ----------------------------
    45. 

  45. 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);
    46. 

  46. INSERT INTO `lm_admin` VALUES (12, 'anyluck', '$2y$12$SkjoA8vfD2dS2JeXtKBNme4aY3MEVwTueKBO2YFGpG69q6GX1Owty', 1, '', '', '13323821192', '', '0', 1, '', 1590638270, 1590638270);
    47. 

  47. 

  48. -- ----------------------------
    49. 

  49. -- Table structure for lm_admin_log
    50. 

  50. -- ----------------------------
    51. 

  51. DROP TABLE IF EXISTS `lm_admin_log`;
    52. 

  52. CREATE TABLE `lm_admin_log`  (
    53. 

  53.   `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表id',
    54. 

  54.   `admin_id` int(10) NULL DEFAULT NULL COMMENT '管理员id',
    55. 

  55.   `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    56. 

  56.   `log_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    57. 

  57.   `log_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
    58. 

  58.   `log_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志描述',
    59. 

  59.   `log_agent` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    60. 

  60.   `log_ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'ip地址',
    61. 

  61.   `create_time` int(11) NULL DEFAULT NULL COMMENT '日志时间',
    62. 

  62.   `update_time` int(11) NULL DEFAULT NULL,
    63. 

  63.   `status` tinyint(1) NULL DEFAULT 1,
    64. 

  64.   PRIMARY KEY (`id`) USING BTREE,
    65. 

  65.   UNIQUE INDEX `id`(`id`) USING BTREE,
    66. 

  66.   INDEX `admin_id`(`admin_id`) USING BTREE
    67. 

  67. ) ENGINE = InnoDB AUTO_INCREMENT = 14224 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
    68. 

  68. 

  69. -- ----------------------------
    70. 

  70. -- Records of lm_admin_log
    71. 

  71. -- ----------------------------
    72. 

  72. INSERT INTO `lm_admin_log` VALUES (14204, 1, 'admin', '/admin/adminlog/adminuser.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);
    73. 

  73. 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);
    74. 

  74. 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);
    75. 

  75. 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);
    76. 

  76. 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);
    77. 

  77. 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);
    78. 

  78. INSERT INTO `lm_admin_log` VALUES (14210, 1, 'admin', '/admin/adminlog/adminuser.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);
    79. 

  79. 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);
    80. 

  80. 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);
    81. 

  81. 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);
    82. 

  82. 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);
    83. 

  83. INSERT INTO `lm_admin_log` VALUES (14215, 1, 'admin', '/admin/database/adminuser.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);
    84. 

  84. INSERT INTO `lm_admin_log` VALUES (14216, 1, 'admin', '/admin/database/adminuser.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);
    85. 

  85. 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);
    86. 

  86. 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);
    87. 

  87. 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);
    88. 

  88. 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);
    89. 

  89. 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);
    90. 

  90. 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);
    91. 

  91. INSERT INTO `lm_admin_log` VALUES (14223, 1, 'admin', '/admin/adminlog/adminuser.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);
    92. 

  92. 

  93. -- ----------------------------
    94. 

  94. -- Table structure for lm_auth_group
    95. 

  95. -- ----------------------------
    96. 

  96. DROP TABLE IF EXISTS `lm_auth_group`;
    97. 

  97. CREATE TABLE `lm_auth_group`  (
    98. 

  98.   `id` smallint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分组id',
    99. 

  99.   `title` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
    100. 

  100.   `status` tinyint(1) NULL DEFAULT 0 COMMENT '状态',
    101. 

  101.   `rules` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '规则',
    102. 

  102.   `create_time` int(11) NULL DEFAULT NULL COMMENT '添加时间',
    103. 

  103.   `update_time` int(11) NULL DEFAULT NULL,
    104. 

  104.   PRIMARY KEY (`id`) USING BTREE,
    105. 

  105.   UNIQUE INDEX `id`(`id`) USING BTREE,
    106. 

  106.   UNIQUE INDEX `title`(`title`) USING BTREE
    107. 

  107. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员分组' ROW_FORMAT = Compact;
    108. 

  108. 

  109. -- ----------------------------
    110. 

  110. -- Records of lm_auth_group
    111. 

  111. -- ----------------------------
    112. 

  112. 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);
    113. 

  113. 

  114. -- ----------------------------
    115. 

  115. -- Table structure for lm_auth_rule
    116. 

  116. -- ----------------------------
    117. 

  117. DROP TABLE IF EXISTS `lm_auth_rule`;
    118. 

  118. CREATE TABLE `lm_auth_rule`  (
    119. 

  119.   `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    120. 

  120.   `href` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接',
    121. 

  121.   `title` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
    122. 

  122.   `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型',
    123. 

  123.   `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态1 可以用，0 所有禁止使用',
    124. 

  124.   `auth_open` tinyint(2) NOT NULL DEFAULT 0 COMMENT '1公开 0不公开',
    125. 

  125.   `menu_status` tinyint(1) NULL DEFAULT 0 COMMENT '0 不显示，1 显示',
    126. 

  126.   `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标样式',
    127. 

  127.   `condition` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '条件',
    128. 

  128.   `pid` int(5) NOT NULL DEFAULT 0 COMMENT '父栏目ID',
    129. 

  129.   `sort` int(11) NULL DEFAULT 0 COMMENT '排序',
    130. 

  130.   `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
    131. 

  131.   `update_time` int(11) NULL DEFAULT NULL,
    132. 

  132.   PRIMARY KEY (`id`) USING BTREE,
    133. 

  133.   UNIQUE INDEX `id`(`id`) USING BTREE,
    134. 

  134.   INDEX `href`(`href`) USING BTREE
    135. 

  135. ) ENGINE = InnoDB AUTO_INCREMENT = 208 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限节点' ROW_FORMAT = Compact;
    136. 

  136. 

  137. -- ----------------------------
    138. 

  138. -- Records of lm_auth_rule
    139. 

  139. -- ----------------------------
    140. 

  140. INSERT INTO `lm_auth_rule` VALUES (1, 'System', '系统', 1, 1, 0, 1, 'fa fa-home', '', 0, 58, 1446535750, 1571966892);
    141. 

  141. INSERT INTO `lm_auth_rule` VALUES (2, 'System', '系统设置', 1, 1, 0, 1, 'fa fa-gears', '', 1, 0, 1446535789, 1571882291);
    142. 

  142. INSERT INTO `lm_auth_rule` VALUES (3, 'Database', '数据库管理', 1, 1, 0, 1, 'fa fa-database', '', 1, 0, 1446535805, 0);
    143. 

  143. INSERT INTO `lm_auth_rule` VALUES (4, 'Database/restore', '还原数据库', 2, 1, 0, 1, 'fa fa-database', '', 3, 0, 1446535750, 0);
    144. 

  144. INSERT INTO `lm_auth_rule` VALUES (5, 'Database/backup', '数据库备份', 2, 1, 0, 0, 'fa fa-database', '', 3, 0, 1446535834, 0);
    145. 

  145. INSERT INTO `lm_auth_rule` VALUES (6, 'Auth', '权限管理', 1, 1, 0, 1, 'fa fa-cog', '', 1, 0, 0, 0);
    146. 

  146. INSERT INTO `lm_auth_rule` VALUES (7, 'Auth/adminRule', '权限列表', 1, 1, 0, 1, 'fa fa-cog', '', 6, 0, 0, 0);
    147. 

  147. INSERT INTO `lm_auth_rule` VALUES (8, 'Auth/ruleEdit', '权限编辑', 2, 1, 0, 0, 'fa fa-cog', '', 7, 0, 0, 0);
    148. 

  148. INSERT INTO `lm_auth_rule` VALUES (9, 'Database/repair', '数据库修复', 2, 1, 0, 0, '', '', 3, 0, 0, 0);
    149. 

  149. INSERT INTO `lm_auth_rule` VALUES (10, 'Database/import', '数据还原', 2, 1, 0, 0, '', '', 3, 0, 0, 0);
    150. 

  150. INSERT INTO `lm_auth_rule` VALUES (11, 'Database/downFile', '数据下载', 2, 1, 0, 0, '', '', 3, 0, 0, 0);
    151. 

  151. INSERT INTO `lm_auth_rule` VALUES (12, 'Database/delSqlFiles', '删除数据库', 2, 1, 0, 0, '', '', 3, 0, 0, 0);
    152. 

  152. INSERT INTO `lm_auth_rule` VALUES (13, 'Database/index', '数据库列表', 1, 1, 0, 1, 'fa fa-database', '', 3, 1, 0, 0);
    153. 

  153. INSERT INTO `lm_auth_rule` VALUES (14, 'Auth/ruleState', '菜单显示或者隐藏', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
    154. 

  154. INSERT INTO `lm_auth_rule` VALUES (15, 'Auth/ruleOpen', '权限是否验证', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
    155. 

  155. INSERT INTO `lm_auth_rule` VALUES (16, 'Auth/ruleSort', '权限排序', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
    156. 

  156. INSERT INTO `lm_auth_rule` VALUES (17, 'Auth/ruleDel', '权限删除', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
    157. 

  157. INSERT INTO `lm_auth_rule` VALUES (18, 'Auth/ruleSelectDel', '权限批量删除', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
    158. 

  158. INSERT INTO `lm_auth_rule` VALUES (19, 'Auth/ruleAdd', '权限增加', 2, 1, 0, 0, '', '', 7, 0, 0, 0);
    159. 

  159. INSERT INTO `lm_auth_rule` VALUES (20, 'System/index', '站点设置', 1, 1, 0, 1, 'fa fa-gears', '', 2, 0, 0, 1567228601);
    160. 

  160. INSERT INTO `lm_auth_rule` VALUES (21, 'Adminlog/index', '日志管理', 1, 1, 0, 1, 'fa fa-life-ring', '', 2, 0, 0, 1566007925);
    161. 

  161. INSERT INTO `lm_auth_rule` VALUES (22, 'Database/optimize', '数据库优化', 1, 1, 0, 0, '', '', 3, 0, 0, 0);
    162. 

  162. INSERT INTO `lm_auth_rule` VALUES (26, 'Auth/group', '权限组', 1, 1, 0, 1, 'fa fa-globe', '', 6, 0, 0, 0);
    163. 

  163. INSERT INTO `lm_auth_rule` VALUES (27, 'Auth/groupDel', '用户组删除', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
    164. 

  164. INSERT INTO `lm_auth_rule` VALUES (28, 'Auth/groupAdd', '用户组添加', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
    165. 

  165. INSERT INTO `lm_auth_rule` VALUES (29, 'Auth/groupEdit', '用户组修改', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
    166. 

  166. INSERT INTO `lm_auth_rule` VALUES (30, 'Auth/groupState', '用户组状态修改', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
    167. 

  167. INSERT INTO `lm_auth_rule` VALUES (31, 'Auth/groupSelectDel', '用户组批量删除', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
    168. 

  168. INSERT INTO `lm_auth_rule` VALUES (32, 'Auth/groupAccess', '用户组显示权限', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
    169. 

  169. INSERT INTO `lm_auth_rule` VALUES (33, 'Auth/groupSetaccess', '用户组保存权限', 1, 1, 0, 0, '', '', 26, 0, 0, 0);
    170. 

  170. INSERT INTO `lm_auth_rule` VALUES (34, 'Uploads/uploads', '上传文件', 1, 1, 0, 0, 'fa fa-adjust', '', 2, 0, 0, 1571966280);
    171. 

  171. INSERT INTO `lm_auth_rule` VALUES (35, 'Auth/adminList', '管理员列表', 1, 1, 0, 1, 'fa fa-user-circle', '', 6, 0, 1, 0);
    172. 

  172. INSERT INTO `lm_auth_rule` VALUES (36, 'Auth/adminAdd', '添加管理员', 1, 1, 0, 0, '', '', 35, 0, 0, 0);
    173. 

  173. INSERT INTO `lm_auth_rule` VALUES (37, 'Auth/adminDel', '删除管理员', 1, 1, 0, 0, '', '', 35, 0, 0, 0);
    174. 

  174. INSERT INTO `lm_auth_rule` VALUES (38, 'Auth/adminState', '管理员状态', 1, 1, 0, 0, '', '', 35, 0, 0, 0);
    175. 

  175. INSERT INTO `lm_auth_rule` VALUES (39, 'Index/password', '修改密码', 1, 1, 0, 0, '', '', 2, 0, 0, 0);
    176. 

  176. INSERT INTO `lm_auth_rule` VALUES (40, 'Adminlog/delete', '删除日志', 1, 1, 0, 0, '', '', 21, 0, 0, 0);
    177. 

  177. INSERT INTO `lm_auth_rule` VALUES (148, 'System/configlist', '配置列表', 1, 1, 0, 1, 'fa fa-align-justify', '', 2, 0, 0, NULL);
    178. 

  178. INSERT INTO `lm_auth_rule` VALUES (149, 'System/configAdd', '添加配置', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
    179. 

  179. INSERT INTO `lm_auth_rule` VALUES (150, 'System/configEdit', '编辑配置', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
    180. 

  180. INSERT INTO `lm_auth_rule` VALUES (151, 'System/configDel', '删除配置', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
    181. 

  181. INSERT INTO `lm_auth_rule` VALUES (152, 'System/configState', '配置状态', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
    182. 

  182. INSERT INTO `lm_auth_rule` VALUES (153, 'System/configGroupAdd', '配置组添加', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
    183. 

  183. INSERT INTO `lm_auth_rule` VALUES (154, 'System/configGroupDel', '配置组删除', 1, 1, 0, 0, NULL, '', 148, 0, 0, NULL);
    184. 

  184. 

  185. -- ----------------------------
    186. 

  186. -- Table structure for lm_banner
    187. 

  187. -- ----------------------------
    188. 

  188. DROP TABLE IF EXISTS `lm_banner`;
    189. 

  189. CREATE TABLE `lm_banner`  (
    190. 

  190.   `id` int(11) NOT NULL AUTO_INCREMENT,
    191. 

  191.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
    192. 

  192.   `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片地址',
    193. 

  193.   `url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接地址',
    194. 

  194.   `status` int(1) NOT NULL DEFAULT 0 COMMENT '0 显示 1 不显示',
    195. 

  195.   `pai` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
    196. 

  196.   PRIMARY KEY (`id`) USING BTREE
    197. 

  197. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '轮播图' ROW_FORMAT = Dynamic;
    198. 

  198. 

  199. -- ----------------------------
    200. 

  200. -- Records of lm_banner
    201. 

  201. -- ----------------------------
    202. 

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

  203. 

  204. -- ----------------------------
    205. 

  205. -- Table structure for lm_config
    206. 

  206. -- ----------------------------
    207. 

  207. DROP TABLE IF EXISTS `lm_config`;
    208. 

  208. CREATE TABLE `lm_config`  (
    209. 

  209.   `id` smallint(5) NOT NULL AUTO_INCREMENT,
    210. 

  210.   `code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    211. 

  211.   `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
    212. 

  212.   `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '解释,备注',
    213. 

  213.   `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'site',
    214. 

  214.   `status` tinyint(1) NULL DEFAULT 1,
    215. 

  215.   `create_time` int(11) NULL DEFAULT NULL,
    216. 

  216.   `update_time` int(11) NULL DEFAULT NULL,
    217. 

  217.   PRIMARY KEY (`id`) USING BTREE,
    218. 

  218.   UNIQUE INDEX `id`(`id`) USING BTREE,
    219. 

  219.   UNIQUE INDEX `code`(`code`) USING BTREE
    220. 

  220. ) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置参数表' ROW_FORMAT = Compact;
    221. 

  221. 

  222. -- ----------------------------
    223. 

  223. -- Records of lm_config
    224. 

  224. -- ----------------------------
    225. 

  225. INSERT INTO `lm_config` VALUES (1, 'site_name', '千翼商城官网', '网站名称', 'site', 1, 0, 1590993472);
    226. 

  226. INSERT INTO `lm_config` VALUES (2, 'site_phone', '3', '网站客服服务电话', 'site', 0, 0, 1579406816);
    227. 

  227. INSERT INTO `lm_config` VALUES (3, 'site_state', '1', '状态', 'site', 1, 0, 0);
    228. 

  228. INSERT INTO `lm_config` VALUES (4, 'site_logo', '/storage/uploads/20200529/ad110b5e57ac537529fe3c2a2bf8cdfc.png', '网站logo图', 'site', 1, 0, 0);
    229. 

  229. INSERT INTO `lm_config` VALUES (5, 'site_mobile_logo', 'site_mobile_logo.png', '默认网站手机端logo', 'site', 0, 0, 1579406806);
    230. 

  230. INSERT INTO `lm_config` VALUES (6, 'site_logowx', 'site_logowx.jpg', '微信网站二维码', 'site', 0, 0, 1579406800);
    231. 

  231. INSERT INTO `lm_config` VALUES (7, 'site_icp', '2', 'ICP备案号', 'site', 1, 0, 0);
    232. 

  232. INSERT INTO `lm_config` VALUES (8, 'site_tel400', '40002541852', '解释,备注', 'site', 1, 0, 0);
    233. 

  233. INSERT INTO `lm_config` VALUES (9, 'site_email', 'www.794230322@outlook.com', '电子邮件', 'site', 1, 0, 0);
    234. 

  234. INSERT INTO `lm_config` VALUES (10, 'site_copyright', '千翼科技版权所有@2019', '底部版权信息', 'site', 1, 0, 0);
    235. 

  235. INSERT INTO `lm_config` VALUES (11, 'captcha_status_login', '1', '会员登录是否需要验证码', 'site', 1, 0, 0);
    236. 

  236. INSERT INTO `lm_config` VALUES (12, 'captcha_status_register', '1', '会员注册是否验证码', 'site', 1, 0, 0);
    237. 

  237. INSERT INTO `lm_config` VALUES (14, 'sms_appid', 'LTAIesI7qxnHLgKE', '短信平台账号', 'sms', 1, 0, 0);
    238. 

  238. INSERT INTO `lm_config` VALUES (15, 'sms_secret', 'sbA6wnefJLD7pv7WipcxL0M3IMb3l9', '短信平台密钥', 'sms', 1, 0, 0);
    239. 

  239. INSERT INTO `lm_config` VALUES (16, 'email_host', 'smtp.qq.com', '邮箱地址', 'email', 0, 0, 1579406788);
    240. 

  240. INSERT INTO `lm_config` VALUES (17, 'email_port', '25', '邮箱端口', 'email', 0, 0, 1579406821);
    241. 

  241. INSERT INTO `lm_config` VALUES (18, 'email_addr', '994927909@qq.com', '邮箱发件人地址', 'email', 0, 0, 1579406822);
    242. 

  242. INSERT INTO `lm_config` VALUES (19, 'email_id', '994927909@qq.com', '身份验证用户名', 'email', 0, 0, 1579406824);
    243. 

  243. INSERT INTO `lm_config` VALUES (20, 'email_pass', '11211', '用户名密码', 'email', 0, 0, 1579406828);
    244. 

  244. INSERT INTO `lm_config` VALUES (21, 'email_secure', 'smtp', '邮箱发送协议', 'email', 0, 0, 1579406829);
    245. 

  245. 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);
    246. 

  246. INSERT INTO `lm_config` VALUES (23, 'cache_open', '0', '是否开启缓存', 'site', 0, 0, 1579406834);
    247. 

  247. INSERT INTO `lm_config` VALUES (24, 'alioss_accessid', '', 'accessid', 'oss', 0, 0, 1579406846);
    248. 

  248. INSERT INTO `lm_config` VALUES (25, 'alioss_accesssecret', '', 'oss_accesssecret', 'oss', 0, 0, 1579406843);
    249. 

  249. INSERT INTO `lm_config` VALUES (26, 'alioss_bucket', '', 'oss_bucket', 'oss', 0, 0, 1579406841);
    250. 

  250. INSERT INTO `lm_config` VALUES (27, 'alioss_endpoint', '', 'oss_endpoint', 'oss', 0, 0, 1579406846);
    251. 

  251. INSERT INTO `lm_config` VALUES (28, 'aliendpoint_type', '0', 'aliendpoint_type', 'oss', 0, 0, 1579406848);
    252. 

  252. INSERT INTO `lm_config` VALUES (29, 'node_site_url', '', '站内IM服务器地址', 'im', 0, 0, 1579406849);
    253. 

  253. INSERT INTO `lm_config` VALUES (30, 'node_site_use', '0', '是否启用im', 'im', 0, 0, 1579406851);
    254. 

  254. INSERT INTO `lm_config` VALUES (31, 'qq_isuse', '1', '是否使用QQ互联', 'qq', 0, 0, 1579406852);
    255. 

  255. INSERT INTO `lm_config` VALUES (32, 'qq_appid', '', 'qq互联id', 'qq', 0, 0, 1579406856);
    256. 

  256. INSERT INTO `lm_config` VALUES (33, 'qq_appkey', '', 'qq秘钥', 'qq', 0, 0, 1579406857);
    257. 

  257. INSERT INTO `lm_config` VALUES (34, 'sina_isuse', '1', '是的使用微博登录', 'sina', 0, 0, 1579406858);
    258. 

  258. INSERT INTO `lm_config` VALUES (35, 'sina_wb_akey', '', '新浪id', 'sina', 0, 0, 1579406859);
    259. 

  259. INSERT INTO `lm_config` VALUES (36, 'sina_wb_skey', '', '新浪秘钥', 'sina', 0, 0, 1579406860);
    260. 

  260. INSERT INTO `lm_config` VALUES (37, 'sms_register', '0', '是否手机注册', 'mobile', 0, 0, 1579406861);
    261. 

  261. INSERT INTO `lm_config` VALUES (38, 'sms_login', '0', '是否手机登录', 'mobile', 0, 0, 1579406869);
    262. 

  262. INSERT INTO `lm_config` VALUES (39, 'sms_password', '0', '是否手机找回密码', 'mobile', 0, 0, 1579406872);
    263. 

  263. INSERT INTO `lm_config` VALUES (43, 'baidu_ak', '22bb7221fc279a484895afcc6a0bb33a', '百度地图AK密钥', 'baidu', 0, 0, 1579406873);
    264. 

  264. INSERT INTO `lm_config` VALUES (44, 'site_licence', '', '营业执照', 'site', 0, 0, 1579406874);
    265. 

  265. INSERT INTO `lm_config` VALUES (45, 'site_domain', 'https://www.quyum.com', '网站地址', 'site', 0, 0, 1579406875);
    266. 

  266. INSERT INTO `lm_config` VALUES (46, 'upload_file_max', '2048', '最大文件上传大小', 'upload', 1, 0, 0);
    267. 

  267. INSERT INTO `lm_config` VALUES (47, 'site_seo_title', '内容管理系统', '首页标题', 'site', 0, 0, 1579406877);
    268. 

  268. INSERT INTO `lm_config` VALUES (48, 'site_seo_keywords', '小程序,管理系统，thinkphp6', '首页关键词', 'site', 0, 0, 1579406880);
    269. 

  269. INSERT INTO `lm_config` VALUES (49, 'site_seo_desc', '', '首页描述', 'site', 0, 0, 1579406881);
    270. 

  270. INSERT INTO `lm_config` VALUES (50, 'upload_water', '1', '水印开始关闭', 'upload', 0, 0, 1579406891);
    271. 

  271. INSERT INTO `lm_config` VALUES (51, 'upload_water_position', '', '水印位置', 'upload', 0, 0, 1579406890);
    272. 

  272. INSERT INTO `lm_config` VALUES (52, 'sms_product', 'lemocms', '产品', 'sms', 0, 0, 1579406888);
    273. 

  273. INSERT INTO `lm_config` VALUES (53, 'sms_template', 'SMS_158941284', '模板id', 'sms', 0, 0, 1579406886);
    274. 

  274. INSERT INTO `lm_config` VALUES (54, 'appid', 'wx4025e13383042216', '微信appid', 'weixin', 0, 0, 1579406886);
    275. 

  275. INSERT INTO `lm_config` VALUES (55, 'appsecret', 'cde471d1aca9ee5e93bd250a96aee5a9', '微信密钥', 'weixin', 0, NULL, NULL);
    276. 

  276. INSERT INTO `lm_config` VALUES (56, 'access_token', NULL, '微信密钥', 'weixin', 1, NULL, NULL);
    277. 

  277. INSERT INTO `lm_config` VALUES (57, 'expires_in', NULL, '微信密钥时间', 'weixin', 1, NULL, NULL);
    278. 

  278. 

  279. -- ----------------------------
    280. 

  280. -- Table structure for lm_config_group
    281. 

  281. -- ----------------------------
    282. 

  282. DROP TABLE IF EXISTS `lm_config_group`;
    283. 

  283. CREATE TABLE `lm_config_group`  (
    284. 

  284.   `id` int(11) NOT NULL AUTO_INCREMENT,
    285. 

  285.   `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    286. 

  286.   `title` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    287. 

  287.   PRIMARY KEY (`id`) USING BTREE
    288. 

  288. ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
    289. 

  289. 

  290. -- ----------------------------
    291. 

  291. -- Records of lm_config_group
    292. 

  292. -- ----------------------------
    293. 

  293. INSERT INTO `lm_config_group` VALUES (1, 'site', '网站');
    294. 

  294. INSERT INTO `lm_config_group` VALUES (2, 'qq', 'qq');
    295. 

  295. INSERT INTO `lm_config_group` VALUES (3, 'sms', '短信');
    296. 

  296. INSERT INTO `lm_config_group` VALUES (4, 'email', '邮箱');
    297. 

  297. INSERT INTO `lm_config_group` VALUES (5, 'oss', 'oss');
    298. 

  298. INSERT INTO `lm_config_group` VALUES (6, 'sina', '新浪');
    299. 

  299. INSERT INTO `lm_config_group` VALUES (7, 'im', 'im');
    300. 

  300. INSERT INTO `lm_config_group` VALUES (8, 'upload', '上传');
    301. 

  301. INSERT INTO `lm_config_group` VALUES (9, 'mobile', '手机');
    302. 

  302. INSERT INTO `lm_config_group` VALUES (10, '百度', '百度配置');
    303. 

  303. 

  304. -- ----------------------------
    305. 

  305. -- Table structure for lm_field
    306. 

  306. -- ----------------------------
    307. 

  307. DROP TABLE IF EXISTS `lm_field`;
    308. 

  308. CREATE TABLE `lm_field`  (
    309. 

  309.   `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
    310. 

  310.   `moduleid` float UNSIGNED NOT NULL DEFAULT 0 COMMENT '模型id',
    311. 

  311.   `field` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段',
    312. 

  312.   `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名字',
    313. 

  313.   `required` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否必须',
    314. 

  314.   `minlength` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最少长度',
    315. 

  315.   `maxlength` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大长度',
    316. 

  316.   `rule` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规则',
    317. 

  317.   `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '错误提示',
    318. 

  318.   `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段类型',
    319. 

  319.   `is_search` tinyint(1) NULL DEFAULT 0 COMMENT '是否可以搜索 0  不可以，1 搜索',
    320. 

  320.   `value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    321. 

  321.   `field_define` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    322. 

  322.   `option` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '默认值',
    323. 

  323.   `sort` int(10) UNSIGNED NOT NULL DEFAULT 0,
    324. 

  324.   `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
    325. 

  325.   `create_time` int(11) NOT NULL DEFAULT 0,
    326. 

  326.   `update_time` int(11) NOT NULL DEFAULT 0,
    327. 

  327.   PRIMARY KEY (`id`) USING BTREE
    328. 

  328. ) ENGINE = InnoDB AUTO_INCREMENT = 94 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
    329. 

  329. 

  330. -- ----------------------------
    331. 

  331. -- Records of lm_field
    332. 

  332. -- ----------------------------
    333. 

  333. INSERT INTO `lm_field` VALUES (31, 32, 'column_id', '栏目', 1, 0, 6, '', '必须选择一个栏目', 'column_id', 0, '', NULL, '', 1, 1, 1571732224, 0);
    334. 

  334. INSERT INTO `lm_field` VALUES (32, 32, 'title', '标题', 1, 0, 80, '', '标题必须为1-80个字符', 'text', 0, '', NULL, '', 2, 1, 1571732224, 0);
    335. 

  335. INSERT INTO `lm_field` VALUES (33, 32, 'keywords', '关键词', 1, 0, 200, '', '关键词必须在0-200个内', 'text', 0, '', NULL, '', 3, 1, 1571732224, 0);
    336. 

  336. INSERT INTO `lm_field` VALUES (34, 32, 'description', 'SEO简介', 1, 0, 0, '', '', 'textarea', 0, '', NULL, '', 4, 1, 1571732224, 0);
    337. 

  337. INSERT INTO `lm_field` VALUES (35, 32, 'content', '内容', 0, 0, 255, '', '', 'editor', 0, 'ueditor', NULL, '0|ueditor', 5, 1, 1571732224, 0);
    338. 

  338. INSERT INTO `lm_field` VALUES (36, 32, 'create_time', '创建时间', 1, 0, 11, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1571732224, 0);
    339. 

  339. INSERT INTO `lm_field` VALUES (37, 32, 'update_time', '更新时间', 1, 0, 11, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1571732224, 0);
    340. 

  340. INSERT INTO `lm_field` VALUES (38, 32, 'status', '状态', 1, 0, 1, '', '', 'radio', 0, '1', NULL, '0|未发布,1|发布', 7, 1, 1571732224, 0);
    341. 

  341. INSERT INTO `lm_field` VALUES (39, 32, 'recommend', '允许评论', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止评论,1|允许评论', 8, 1, 1571732224, 0);
    342. 

  342. INSERT INTO `lm_field` VALUES (40, 32, 'readpoint', '阅读收费', 0, 0, 5, '', '', 'number', 0, '0', NULL, '', 9, 1, 1571732224, 0);
    343. 

  343. INSERT INTO `lm_field` VALUES (41, 32, 'is_read', '是否可阅读', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止,1|允许', 9, 1, 1571732224, 0);
    344. 

  344. INSERT INTO `lm_field` VALUES (42, 32, 'hits', '点击次数', 0, 0, 8, '', '', 'number', 0, '1', NULL, '', 10, 1, 1571732224, 0);
    345. 

  345. INSERT INTO `lm_field` VALUES (43, 32, 'visite', '访问权限', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|开启,1|关闭', 11, 1, 1571732224, 0);
    346. 

  346. INSERT INTO `lm_field` VALUES (44, 32, 'posid', '推荐位', 0, 0, 1, '', '', 'posid', 0, '', NULL, '', 12, 12, 1571732224, 0);
    347. 

  347. INSERT INTO `lm_field` VALUES (45, 32, 'tags', '标签', 0, 0, 255, '', '', 'text', 0, '', NULL, '', 14, 1, 1571732224, 0);
    348. 

  348. INSERT INTO `lm_field` VALUES (46, 2, 'column_id', '栏目', 1, 1, 6, '', '必须选择一个栏目', 'column_id', 0, '', NULL, '', 1, 1, 1571884340, 0);
    349. 

  349. INSERT INTO `lm_field` VALUES (47, 2, 'title', '标题', 1, 1, 80, '', '标题必须为1-80个字符', 'text', 0, '', NULL, '', 2, 1, 1571884340, 0);
    350. 

  350. INSERT INTO `lm_field` VALUES (48, 2, 'keywords', '关键词', 1, 0, 200, '', '关键词必须在0-200个内', 'text', 0, '', NULL, '', 3, 1, 1571884340, 0);
    351. 

  351. INSERT INTO `lm_field` VALUES (49, 2, 'description', 'SEO简介', 1, 0, 0, '', '', 'textarea', 0, '', NULL, '', 4, 1, 1571884340, 0);
    352. 

  352. INSERT INTO `lm_field` VALUES (50, 2, 'content', '内容', 0, 0, 0, '', '', 'editor', 0, 'ueditor', NULL, '0|ueditor', 5, 1, 1571884340, 0);
    353. 

  353. INSERT INTO `lm_field` VALUES (51, 2, 'create_time', '创建时间', 1, 0, 0, '', '', 'datetime', 0, '', NULL, '', 61, 1, 1571884340, 1571884945);
    354. 

  354. INSERT INTO `lm_field` VALUES (52, 2, 'update_time', '更新时间', 1, 0, 0, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1571884340, 0);
    355. 

  355. INSERT INTO `lm_field` VALUES (53, 2, 'status', '状态', 1, 0, 0, '', '', 'radio', 0, '1', NULL, '0|未发布,1|发布', 7, 1, 1571884340, 0);
    356. 

  356. INSERT INTO `lm_field` VALUES (54, 2, 'recommend', '允许评论', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止评论,1|允许评论', 8, 1, 1571884340, 0);
    357. 

  357. INSERT INTO `lm_field` VALUES (55, 2, 'readpoint', '阅读收费', 0, 0, 5, '', '', 'number', 0, '0', NULL, '', 9, 1, 1571884340, 0);
    358. 

  358. INSERT INTO `lm_field` VALUES (56, 2, 'is_read', '是否可阅读', 0, 0, 5, '', '', 'radio', 0, '1', NULL, '0|禁止,1|允许', 9, 1, 1571884340, 0);
    359. 

  359. INSERT INTO `lm_field` VALUES (57, 2, 'hits', '点击次数', 0, 0, 8, '', '', 'number', 0, '1', NULL, '', 10, 1, 1571884340, 0);
    360. 

  360. INSERT INTO `lm_field` VALUES (58, 2, 'visite', '访问权限', 0, 0, 0, '', '', 'radio', 0, '1', NULL, '0|开启,1|关闭', 11, 1, 1571884340, 0);
    361. 

  361. INSERT INTO `lm_field` VALUES (59, 2, 'posid', '推荐位', 0, 0, 0, '', '', 'posid', 0, '', NULL, '', 12, 12, 1571884340, 0);
    362. 

  362. INSERT INTO `lm_field` VALUES (60, 3, 'column_id', '栏目', 1, 0, 6, '', '必须选择一个栏目', 'column_id', 0, '', NULL, '', 1, 1, 1572145912, 0);
    363. 

  363. INSERT INTO `lm_field` VALUES (61, 3, 'title', '标题', 1, 0, 180, '', '标题必须为1-180个字符', 'text', 0, '', NULL, '', 2, 1, 1572145912, 0);
    364. 

  364. INSERT INTO `lm_field` VALUES (62, 3, 'keywords', '关键词', 1, 0, 80, '', '', 'text', 0, '', NULL, '', 3, 1, 1572145912, 0);
    365. 

  365. INSERT INTO `lm_field` VALUES (63, 3, 'description', 'SEO简介', 1, 0, 0, '', '', 'textarea', 0, '', NULL, '', 4, 1, 1572145912, 0);
    366. 

  366. INSERT INTO `lm_field` VALUES (64, 3, 'tags', '标签', 0, 0, 0, '', '', 'text', 0, '', NULL, '', 5, 1, 1, 0);
    367. 

  367. INSERT INTO `lm_field` VALUES (65, 3, 'content', '内容', 0, 0, 0, '', '', 'editor', 0, 'ueditor', NULL, '0|ueditor', 6, 1, 1572145912, 0);
    368. 

  368. INSERT INTO `lm_field` VALUES (78, 6, 'column_id', '栏目', 1, 0, 6, '', '必须选择一个栏目', 'column_id', 0, '', NULL, '', 1, 1, 1572870621, 0);
    369. 

  369. INSERT INTO `lm_field` VALUES (79, 6, 'title', '标题', 1, 0, 80, '', '标题必须为1-80个字符', 'text', 0, '', NULL, '', 2, 1, 1572870621, 0);
    370. 

  370. INSERT INTO `lm_field` VALUES (80, 6, 'keywords', '关键词', 1, 0, 200, '', '关键词必须在0-200个内', 'text', 0, '', NULL, '', 3, 1, 1572870621, 0);
    371. 

  371. INSERT INTO `lm_field` VALUES (81, 6, 'description', 'SEO简介', 1, 0, 0, '', '', 'textarea', 0, '', NULL, '', 4, 1, 1572870621, 0);
    372. 

  372. INSERT INTO `lm_field` VALUES (82, 6, 'content', '内容', 0, 0, 255, '', '', 'editor', 0, 'ueditor', NULL, '0|ueditor', 5, 1, 1572870621, 0);
    373. 

  373. INSERT INTO `lm_field` VALUES (83, 6, 'create_time', '创建时间', 1, 0, 11, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1572870621, 0);
    374. 

  374. INSERT INTO `lm_field` VALUES (84, 6, 'update_time', '更新时间', 1, 0, 11, '', '', 'datetime', 0, '', NULL, '', 6, 1, 1572870621, 0);
    375. 

  375. INSERT INTO `lm_field` VALUES (85, 6, 'status', '状态', 1, 0, 1, '', '', 'radio', 0, '1', NULL, '0|未发布,1|发布', 7, 1, 1572870621, 0);
    376. 

  376. INSERT INTO `lm_field` VALUES (86, 6, 'recommend', '允许评论', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止评论,1|允许评论', 8, 1, 1572870621, 0);
    377. 

  377. INSERT INTO `lm_field` VALUES (87, 6, 'readpoint', '阅读收费', 0, 0, 5, '', '', 'number', 0, '0', NULL, '', 9, 1, 1572870621, 0);
    378. 

  378. INSERT INTO `lm_field` VALUES (88, 6, 'is_read', '是否可阅读', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|禁止,1|允许', 9, 1, 1572870621, 0);
    379. 

  379. INSERT INTO `lm_field` VALUES (89, 6, 'hits', '点击次数', 0, 0, 8, '', '', 'number', 0, '1', NULL, '', 10, 1, 1572870621, 0);
    380. 

  380. INSERT INTO `lm_field` VALUES (90, 6, 'visite', '访问权限', 0, 0, 1, '', '', 'radio', 0, '1', NULL, '0|开启,1|关闭', 11, 1, 1572870621, 0);
    381. 

  381. INSERT INTO `lm_field` VALUES (91, 6, 'posid', '推荐位', 0, 0, 1, '', '', 'posid', 0, '', NULL, '', 12, 1, 1572870621, 0);
    382. 

  382. INSERT INTO `lm_field` VALUES (92, 6, 'tags', '标签', 0, 0, 255, '', '', 'text', 0, '', NULL, '', 14, 1, 1572870621, 0);
    383. 

  383. INSERT INTO `lm_field` VALUES (93, 6, 'occ_id', '土味乡情', 0, 0, 0, '', '', 'files', 0, '', 'varchar(255) NOT NULL DEFAULT \'\'', NULL, 50, 1, 1573720440, 1573720440);
    384. 

  384. 

  385. -- ----------------------------
    386. 

  386. -- Table structure for lm_field_type
    387. 

  387. -- ----------------------------
    388. 

  388. DROP TABLE IF EXISTS `lm_field_type`;
    389. 

  389. CREATE TABLE `lm_field_type`  (
    390. 

  390.   `id` int(11) NOT NULL AUTO_INCREMENT,
    391. 

  391.   `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字段类型',
    392. 

  392.   `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '中文类型名',
    393. 

  393.   `sort` int(4) NOT NULL DEFAULT 0 COMMENT '排序',
    394. 

  394.   `default_define` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '默认定义',
    395. 

  395.   `isoption` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否需要设置选项',
    396. 

  396.   `istring` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否自由字符',
    397. 

  397.   `rules` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '验证规则',
    398. 

  398.   PRIMARY KEY (`id`) USING BTREE
    399. 

  399. ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字段类型表' ROW_FORMAT = Compact;
    400. 

  400. 

  401. -- ----------------------------
    402. 

  402. -- Records of lm_field_type
    403. 

  403. -- ----------------------------
    404. 

  404. INSERT INTO `lm_field_type` VALUES (1, 'text', '输入框', 1, 'varchar(255) NOT NULL DEFAULT \'\'', 0, 1, '');
    405. 

  405. INSERT INTO `lm_field_type` VALUES (2, 'checkbox', '复选框', 2, 'varchar(50) NOT NULL DEFAULT \'\'', 1, 0, '');
    406. 

  406. INSERT INTO `lm_field_type` VALUES (3, 'textarea', '多行文本', 3, 'varchar(255) NOT NULL DEFAULT \'\'', 0, 1, '');
    407. 

  407. INSERT INTO `lm_field_type` VALUES (4, 'radio', '单选按钮', 4, 'char(10) NOT NULL DEFAULT \'\'', 1, 0, '');
    408. 

  408. INSERT INTO `lm_field_type` VALUES (5, 'switch', '开关', 5, 'tinyint(2) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, 'isBool');
    409. 

  409. INSERT INTO `lm_field_type` VALUES (6, 'array', '数组', 6, 'varchar(512) NOT NULL DEFAULT \'\'', 0, 0, '');
    410. 

  410. INSERT INTO `lm_field_type` VALUES (7, 'select', '下拉框', 7, 'char(10) NOT NULL DEFAULT \'\'', 1, 0, '');
    411. 

  411. INSERT INTO `lm_field_type` VALUES (8, 'image', '单张图', 8, 'int(5) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, 'isNumber');
    412. 

  412. INSERT INTO `lm_field_type` VALUES (9, 'tags', '标签', 10, 'varchar(255) NOT NULL DEFAULT \'\'', 0, 1, '');
    413. 

  413. INSERT INTO `lm_field_type` VALUES (10, 'number', '数字', 11, 'int(10) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, 'isNumber');
    414. 

  414. INSERT INTO `lm_field_type` VALUES (11, 'datetime', '日期和时间', 12, 'int(10) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, '');
    415. 

  415. INSERT INTO `lm_field_type` VALUES (12, 'ueditor', '百度编辑器', 13, 'text NOT NULL', 0, 1, '');
    416. 

  416. INSERT INTO `lm_field_type` VALUES (13, 'images', '多张图', 9, 'varchar(256) NOT NULL DEFAULT \'\'', 0, 0, '');
    417. 

  417. INSERT INTO `lm_field_type` VALUES (14, 'color', '颜色值', 17, 'varchar(7) NOT NULL DEFAULT \'\'', 0, 0, '');
    418. 

  418. INSERT INTO `lm_field_type` VALUES (15, 'file', '单文件', 15, 'int(5) UNSIGNED NOT NULL DEFAULT \'0\'', 0, 0, 'isNumber');
    419. 

  419. INSERT INTO `lm_field_type` VALUES (16, 'files', '多文件', 16, 'varchar(255) NOT NULL DEFAULT \'\'', 0, 0, '');
    420. 

  420. 

  421. -- ----------------------------
    422. 

  422. -- Table structure for lm_task
    423. 

  423. -- ----------------------------
    424. 

  424. DROP TABLE IF EXISTS `lm_task`;
    425. 

  425. CREATE TABLE `lm_task`  (
    426. 

  426.   `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    427. 

  427.   `type` int(11) NULL DEFAULT 0 COMMENT '0 实名制 1 下载注册 2 网页注册 3 关注投票 4 分享转发 5电子商务 6多天任务 7 特单任务',
    428. 

  428.   `user_id` int(11) NULL DEFAULT 0 COMMENT '用户id',
    429. 

  429.   `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '任务名称',
    430. 

  430.   `explain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '任务说明',
    431. 

  431.   `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '任务步骤',
    432. 

  432.   `num` int(11) NULL DEFAULT 0 COMMENT '剩余数量',
    433. 

  433.   `nums` int(11) NULL DEFAULT 0 COMMENT '总数量',
    434. 

  434.   `money` decimal(11, 2) NULL COMMENT '实际金额',
    435. 

  435.   `put_money` decimal(11, 2) NULL COMMENT '上架金额',
    436. 

  436.   `status` int(11) NULL DEFAULT 0 COMMENT '0 审核中 1 审核通过 2 审核失败 3 已完成 4 已禁止',
    437. 

  437.   `msg` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '审核失败原因 ',
    438. 

  438.   `repeat` int(11) NULL DEFAULT 0 COMMENT '0 可以重复做 1 不可以 ',
    439. 

  439.   `end_task_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '设置的结束时间',
    440. 

  440.   `push_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '提交时间',
    441. 

  441.   `create_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建时间',
    442. 

  442.   `update_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新时间',
    443. 

  443.   PRIMARY KEY (`id`) USING BTREE
    444. 

  444. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '任务列表' ROW_FORMAT = Compact;
    445. 

  445. 

  446. -- ----------------------------
    447. 

  447. -- Records of lm_task
    448. 

  448. -- ----------------------------
    449. 

  449. 

  450. -- ----------------------------
    451. 

  451. -- Table structure for lm_user
    452. 

  452. -- ----------------------------
    453. 

  453. DROP TABLE IF EXISTS `lm_user`;
    454. 

  454. CREATE TABLE `lm_user`  (
    455. 

  455.   `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    456. 

  456.   `user` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '用户',
    457. 

  457.   `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '呢称',
    458. 

  458.   `pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '密码',
    459. 

  459.   `openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '微信登录openid',
    460. 

  460.   `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT 'token',
    461. 

  461.   `money` decimal(20, 2) NULL COMMENT '账号余额',
    462. 

  462.   `push_money` decimal(20, 2) NULL COMMENT '发布余额',
    463. 

  463.   `status` int(1) NULL DEFAULT 0 COMMENT '0 正常 1 禁止登录',
    464. 

  464.   `status_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '封号时间',
    465. 

  465.   `create_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建时间',
    466. 

  466.   `vip_time` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '会员到期时间',
    467. 

  467.   `vip_level` int(1) NULL DEFAULT 0 COMMENT '0 普通会员 1 周卡 2月卡 3 年卡 ',
    468. 

  468.   PRIMARY KEY (`id`) USING BTREE
    469. 

  469. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户表' ROW_FORMAT = Compact;
    470. 

  470. 

  471. -- ----------------------------
    472. 

  472. -- Records of lm_user
    473. 

  473. -- ----------------------------
    474. 

  474. 

  475. SET FOREIGN_KEY_CHECKS = 1;
    476.