942 lines
93 KiB
SQL
942 lines
93 KiB
SQL
/*
|
||
Navicat Premium Dump SQL
|
||
|
||
Source Server : localhost
|
||
Source Server Type : MySQL
|
||
Source Server Version : 50743 (5.7.43-log)
|
||
Source Host : localhost:3306
|
||
Source Schema : amlhc
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 50743 (5.7.43-log)
|
||
File Encoding : 65001
|
||
|
||
Date: 21/04/2026 20:38:32
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_admin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_admin`;
|
||
CREATE TABLE `fa_admin` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户名',
|
||
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '昵称',
|
||
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
|
||
`salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码盐',
|
||
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像',
|
||
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '电子邮箱',
|
||
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码',
|
||
`loginfailure` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '失败次数',
|
||
`logintime` bigint(16) NULL DEFAULT NULL COMMENT '登录时间',
|
||
`loginip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录IP',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`token` varchar(59) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'Session标识',
|
||
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `username`(`username`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_admin
|
||
-- ----------------------------
|
||
INSERT INTO `fa_admin` VALUES (1, 'admin', 'Admin', '44b046280e1684494c2e0488eeb0c17e', '8a0da6', '/assets/img/avatar.png', 'admin@admin.com', '', 0, 1776694806, '127.0.0.1', 1491635035, 1776694806, 'f2b8b205-eedc-41a5-a1b2-041bd1a2ea15', 'normal');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_admin_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_admin_log`;
|
||
CREATE TABLE `fa_admin_log` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员ID',
|
||
`username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '管理员名字',
|
||
`url` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作页面',
|
||
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '日志标题',
|
||
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
|
||
`ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'IP',
|
||
`useragent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'User-Agent',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '操作时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `name`(`username`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_admin_log
|
||
-- ----------------------------
|
||
INSERT INTO `fa_admin_log` VALUES (1, 0, 'Unknown', '/ByZjtVrKok.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776690607);
|
||
INSERT INTO `fa_admin_log` VALUES (2, 1, 'admin', '/ByZjtVrKok.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776690611);
|
||
INSERT INTO `fa_admin_log` VALUES (3, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776693828);
|
||
INSERT INTO `fa_admin_log` VALUES (4, 0, 'Unknown', '/ByZjtVrKok.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"916117771\",\"password\":\"***\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694372);
|
||
INSERT INTO `fa_admin_log` VALUES (5, 1, 'admin', '/ByZjtVrKok.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694380);
|
||
INSERT INTO `fa_admin_log` VALUES (6, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694391);
|
||
INSERT INTO `fa_admin_log` VALUES (7, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694393);
|
||
INSERT INTO `fa_admin_log` VALUES (8, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694402);
|
||
INSERT INTO `fa_admin_log` VALUES (9, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694416);
|
||
INSERT INTO `fa_admin_log` VALUES (10, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694549);
|
||
INSERT INTO `fa_admin_log` VALUES (11, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694609);
|
||
INSERT INTO `fa_admin_log` VALUES (12, 0, 'Unknown', '/ByZjtVrKok.php/index/logout', '', '{\"__token__\":\"***\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694645);
|
||
INSERT INTO `fa_admin_log` VALUES (13, 1, 'admin', '/ByZjtVrKok.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694649);
|
||
INSERT INTO `fa_admin_log` VALUES (14, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694671);
|
||
INSERT INTO `fa_admin_log` VALUES (15, 1, 'admin', '/ByZjtVrKok.php/index/login', '登录', '{\"__token__\":\"***\",\"username\":\"admin\",\"password\":\"***\",\"keeplogin\":\"1\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694806);
|
||
INSERT INTO `fa_admin_log` VALUES (16, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694830);
|
||
INSERT INTO `fa_admin_log` VALUES (17, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"example\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.5\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776694837);
|
||
INSERT INTO `fa_admin_log` VALUES (18, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695135);
|
||
INSERT INTO `fa_admin_log` VALUES (19, 1, 'admin', '/ByZjtVrKok.php/addon/install', '插件管理', '{\"name\":\"command\",\"force\":\"0\",\"uid\":\"18654\",\"token\":\"***\",\"version\":\"1.1.3\",\"faversion\":\"1.6.2.20260323\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695313);
|
||
INSERT INTO `fa_admin_log` VALUES (20, 1, 'admin', '/ByZjtVrKok.php/addon/state', '插件管理 / 禁用启用', '{\"name\":\"command\",\"action\":\"enable\",\"force\":\"0\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695314);
|
||
INSERT INTO `fa_admin_log` VALUES (21, 1, 'admin', '/ByZjtVrKok.php/command/get_field_list', '在线命令管理', '{\"table\":\"fa_admin\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695322);
|
||
INSERT INTO `fa_admin_log` VALUES (22, 1, 'admin', '/ByZjtVrKok.php/command/get_field_list', '在线命令管理', '{\"table\":\"fa_macaujc_history\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695327);
|
||
INSERT INTO `fa_admin_log` VALUES (23, 1, 'admin', '/ByZjtVrKok.php/command/get_field_list', '在线命令管理', '{\"table\":\"fa_admin\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695562);
|
||
INSERT INTO `fa_admin_log` VALUES (24, 1, 'admin', '/ByZjtVrKok.php/command/get_field_list', '在线命令管理', '{\"table\":\"fa_history\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695565);
|
||
INSERT INTO `fa_admin_log` VALUES (25, 1, 'admin', '/ByZjtVrKok.php/command/command/action/command', '在线命令管理 / 生成并执行命令', '{\"commandtype\":\"crud\",\"isrelation\":\"0\",\"local\":\"1\",\"delete\":\"0\",\"force\":\"0\",\"table\":\"fa_history\",\"controller\":\"\",\"model\":\"\",\"setcheckboxsuffix\":\"\",\"enumradiosuffix\":\"\",\"imagefield\":\"\",\"filefield\":\"\",\"intdatesuffix\":\"\",\"switchsuffix\":\"\",\"citysuffix\":\"\",\"selectpagesuffix\":\"\",\"selectpagessuffix\":\"\",\"ignorefields\":\"\",\"sortfield\":\"\",\"editorsuffix\":\"\",\"headingfilterfield\":\"\",\"tagsuffix\":\"\",\"jsonsuffix\":\"\",\"fixedcolumns\":\"\",\"action\":\"command\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695573);
|
||
INSERT INTO `fa_admin_log` VALUES (26, 1, 'admin', '/ByZjtVrKok.php/command/command/action/execute', '在线命令管理 / 生成并执行命令', '{\"commandtype\":\"crud\",\"isrelation\":\"0\",\"local\":\"1\",\"delete\":\"0\",\"force\":\"0\",\"table\":\"fa_history\",\"controller\":\"\",\"model\":\"\",\"setcheckboxsuffix\":\"\",\"enumradiosuffix\":\"\",\"imagefield\":\"\",\"filefield\":\"\",\"intdatesuffix\":\"\",\"switchsuffix\":\"\",\"citysuffix\":\"\",\"selectpagesuffix\":\"\",\"selectpagessuffix\":\"\",\"ignorefields\":\"\",\"sortfield\":\"\",\"editorsuffix\":\"\",\"headingfilterfield\":\"\",\"tagsuffix\":\"\",\"jsonsuffix\":\"\",\"fixedcolumns\":\"\",\"action\":\"execute\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695575);
|
||
INSERT INTO `fa_admin_log` VALUES (27, 1, 'admin', '/ByZjtVrKok.php/command/get_controller_list', '在线命令管理', '{\"q_word\":[\"\"],\"pageNumber\":\"1\",\"pageSize\":\"10\",\"andOr\":\"OR \",\"orderBy\":[[\"name\",\"ASC\"]],\"searchTable\":\"tbl\",\"showField\":\"name\",\"keyField\":\"id\",\"searchField\":[\"name\"],\"name\":\"\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695579);
|
||
INSERT INTO `fa_admin_log` VALUES (28, 1, 'admin', '/ByZjtVrKok.php/command/get_controller_list', '在线命令管理', '{\"q_word\":[\"his\"],\"pageNumber\":\"1\",\"pageSize\":\"10\",\"andOr\":\"OR \",\"orderBy\":[[\"name\",\"ASC\"]],\"searchTable\":\"tbl\",\"showField\":\"name\",\"keyField\":\"id\",\"searchField\":[\"name\"],\"name\":\"his\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695581);
|
||
INSERT INTO `fa_admin_log` VALUES (29, 1, 'admin', '/ByZjtVrKok.php/command/get_controller_list', '在线命令管理', '{\"q_word\":[\"\"],\"pageNumber\":\"1\",\"pageSize\":\"10\",\"andOr\":\"OR \",\"orderBy\":[[\"name\",\"ASC\"]],\"searchTable\":\"tbl\",\"showField\":\"name\",\"keyField\":\"id\",\"searchField\":[\"name\"],\"name\":\"\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695582);
|
||
INSERT INTO `fa_admin_log` VALUES (30, 1, 'admin', '/ByZjtVrKok.php/command/command/action/command', '在线命令管理 / 生成并执行命令', '{\"commandtype\":\"menu\",\"allcontroller\":\"0\",\"delete\":\"0\",\"force\":\"0\",\"controllerfile_text\":\"\",\"controllerfile\":\"History.php\",\"action\":\"command\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695583);
|
||
INSERT INTO `fa_admin_log` VALUES (31, 1, 'admin', '/ByZjtVrKok.php/command/command/action/execute', '在线命令管理 / 生成并执行命令', '{\"commandtype\":\"menu\",\"allcontroller\":\"0\",\"delete\":\"0\",\"force\":\"0\",\"controllerfile_text\":\"\",\"controllerfile\":\"History.php\",\"action\":\"execute\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 1776695585);
|
||
INSERT INTO `fa_admin_log` VALUES (32, 1, 'admin', '/ByZjtVrKok.php/command/get_field_list', '在线命令管理', '{\"table\":\"fa_admin\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773188);
|
||
INSERT INTO `fa_admin_log` VALUES (33, 1, 'admin', '/ByZjtVrKok.php/command/get_field_list', '在线命令管理', '{\"table\":\"fa_history\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773192);
|
||
INSERT INTO `fa_admin_log` VALUES (34, 1, 'admin', '/ByZjtVrKok.php/command/command/action/command', '在线命令管理 / 生成并执行命令', '{\"commandtype\":\"crud\",\"isrelation\":\"0\",\"local\":\"1\",\"delete\":\"1\",\"force\":\"0\",\"table\":\"fa_history\",\"controller\":\"\",\"model\":\"\",\"setcheckboxsuffix\":\"\",\"enumradiosuffix\":\"\",\"imagefield\":\"\",\"filefield\":\"\",\"intdatesuffix\":\"\",\"switchsuffix\":\"\",\"citysuffix\":\"\",\"selectpagesuffix\":\"\",\"selectpagessuffix\":\"\",\"ignorefields\":\"\",\"sortfield\":\"\",\"editorsuffix\":\"\",\"headingfilterfield\":\"\",\"tagsuffix\":\"\",\"jsonsuffix\":\"\",\"fixedcolumns\":\"\",\"action\":\"command\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773203);
|
||
INSERT INTO `fa_admin_log` VALUES (35, 1, 'admin', '/ByZjtVrKok.php/command/command/action/execute', '在线命令管理 / 生成并执行命令', '{\"commandtype\":\"crud\",\"isrelation\":\"0\",\"local\":\"1\",\"delete\":\"1\",\"force\":\"0\",\"table\":\"fa_history\",\"controller\":\"\",\"model\":\"\",\"setcheckboxsuffix\":\"\",\"enumradiosuffix\":\"\",\"imagefield\":\"\",\"filefield\":\"\",\"intdatesuffix\":\"\",\"switchsuffix\":\"\",\"citysuffix\":\"\",\"selectpagesuffix\":\"\",\"selectpagessuffix\":\"\",\"ignorefields\":\"\",\"sortfield\":\"\",\"editorsuffix\":\"\",\"headingfilterfield\":\"\",\"tagsuffix\":\"\",\"jsonsuffix\":\"\",\"fixedcolumns\":\"\",\"action\":\"execute\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773210);
|
||
INSERT INTO `fa_admin_log` VALUES (36, 1, 'admin', '/ByZjtVrKok.php/command/get_field_list', '在线命令管理', '{\"table\":\"fa_admin\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773237);
|
||
INSERT INTO `fa_admin_log` VALUES (37, 1, 'admin', '/ByZjtVrKok.php/command/get_controller_list', '在线命令管理', '{\"q_word\":[\"\"],\"pageNumber\":\"1\",\"pageSize\":\"10\",\"andOr\":\"OR \",\"orderBy\":[[\"name\",\"ASC\"]],\"searchTable\":\"tbl\",\"showField\":\"name\",\"keyField\":\"id\",\"searchField\":[\"name\"],\"name\":\"\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773241);
|
||
INSERT INTO `fa_admin_log` VALUES (38, 1, 'admin', '/ByZjtVrKok.php/command/get_controller_list', '在线命令管理', '{\"q_word\":[\"his\"],\"pageNumber\":\"1\",\"pageSize\":\"10\",\"andOr\":\"OR \",\"orderBy\":[[\"name\",\"ASC\"]],\"searchTable\":\"tbl\",\"showField\":\"name\",\"keyField\":\"id\",\"searchField\":[\"name\"],\"name\":\"his\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773242);
|
||
INSERT INTO `fa_admin_log` VALUES (39, 1, 'admin', '/ByZjtVrKok.php/command/get_controller_list', '在线命令管理', '{\"q_word\":[\"H\"],\"pageNumber\":\"1\",\"pageSize\":\"10\",\"andOr\":\"OR \",\"orderBy\":[[\"name\",\"ASC\"]],\"searchTable\":\"tbl\",\"showField\":\"name\",\"keyField\":\"id\",\"searchField\":[\"name\"],\"name\":\"H\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773248);
|
||
INSERT INTO `fa_admin_log` VALUES (40, 1, 'admin', '/ByZjtVrKok.php/command/get_controller_list', '在线命令管理', '{\"q_word\":[\"Hi\"],\"pageNumber\":\"1\",\"pageSize\":\"10\",\"andOr\":\"OR \",\"orderBy\":[[\"name\",\"ASC\"]],\"searchTable\":\"tbl\",\"showField\":\"name\",\"keyField\":\"id\",\"searchField\":[\"name\"],\"name\":\"Hi\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773249);
|
||
INSERT INTO `fa_admin_log` VALUES (41, 1, 'admin', '/ByZjtVrKok.php/command/get_controller_list', '在线命令管理', '{\"q_word\":[\"His\"],\"pageNumber\":\"1\",\"pageSize\":\"10\",\"andOr\":\"OR \",\"orderBy\":[[\"name\",\"ASC\"]],\"searchTable\":\"tbl\",\"showField\":\"name\",\"keyField\":\"id\",\"searchField\":[\"name\"],\"name\":\"His\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773251);
|
||
INSERT INTO `fa_admin_log` VALUES (42, 1, 'admin', '/ByZjtVrKok.php/command/execute/ids/1', '在线命令管理 / 再次执行命令', '{\"commandtype\":\"crud\",\"isrelation\":\"0\",\"local\":\"1\",\"delete\":\"0\",\"force\":\"0\",\"table\":\"fa_history\",\"controller\":\"\",\"model\":\"\",\"setcheckboxsuffix\":\"\",\"enumradiosuffix\":\"\",\"imagefield\":\"\",\"filefield\":\"\",\"intdatesuffix\":\"\",\"switchsuffix\":\"\",\"citysuffix\":\"\",\"selectpagesuffix\":\"\",\"selectpagessuffix\":\"\",\"ignorefields\":\"\",\"sortfield\":\"\",\"editorsuffix\":\"\",\"headingfilterfield\":\"\",\"tagsuffix\":\"\",\"jsonsuffix\":\"\",\"fixedcolumns\":\"\",\"ids\":\"1\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 1776773257);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_area
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_area`;
|
||
CREATE TABLE `fa_area` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`pid` int(10) NULL DEFAULT NULL COMMENT '父id',
|
||
`shortname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '简称',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`mergename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '全称',
|
||
`level` tinyint(4) NULL DEFAULT NULL COMMENT '层级:1=省,2=市,3=区/县',
|
||
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拼音',
|
||
`code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '长途区号',
|
||
`zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮编',
|
||
`first` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '首字母',
|
||
`lng` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
|
||
`lat` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `pid`(`pid`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '地区表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_area
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_attachment
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_attachment`;
|
||
CREATE TABLE `fa_attachment` (
|
||
`id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类别',
|
||
`admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员ID',
|
||
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
|
||
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '物理路径',
|
||
`imagewidth` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '宽度',
|
||
`imageheight` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '高度',
|
||
`imagetype` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片类型',
|
||
`imageframes` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '图片帧数',
|
||
`filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件名称',
|
||
`filesize` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文件大小',
|
||
`mimetype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'mime类型',
|
||
`extparam` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '透传数据',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建日期',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`uploadtime` bigint(16) NULL DEFAULT NULL COMMENT '上传时间',
|
||
`storage` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'local' COMMENT '存储位置',
|
||
`sha1` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件 sha1编码',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '附件表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_attachment
|
||
-- ----------------------------
|
||
INSERT INTO `fa_attachment` VALUES (1, '', 1, 0, '/assets/img/qrcode.png', 150, 150, 'png', 0, 'qrcode.png', 21859, 'image/png', '', 1491635035, 1491635035, 1491635035, 'local', '17163603d0263e4838b9387ff2cd4877e8b018f6');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_auth_group
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_auth_group`;
|
||
CREATE TABLE `fa_auth_group` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父组别',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '组名',
|
||
`rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规则ID',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分组表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_auth_group
|
||
-- ----------------------------
|
||
INSERT INTO `fa_auth_group` VALUES (1, 0, 'Admin group', '*', 1491635035, 1491635035, 'normal');
|
||
INSERT INTO `fa_auth_group` VALUES (2, 1, 'Second group', '13,14,16,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,40,41,42,43,44,45,46,47,48,49,50,55,56,57,58,59,60,61,62,63,64,65,1,9,10,11,7,6,8,2,4,5', 1491635035, 1491635035, 'normal');
|
||
INSERT INTO `fa_auth_group` VALUES (3, 2, 'Third group', '1,4,9,10,11,13,14,15,16,17,40,41,42,43,44,45,46,47,48,49,50,55,56,57,58,59,60,61,62,63,64,65,5', 1491635035, 1491635035, 'normal');
|
||
INSERT INTO `fa_auth_group` VALUES (4, 1, 'Second group 2', '1,4,13,14,15,16,17,55,56,57,58,59,60,61,62,63,64,65', 1491635035, 1491635035, 'normal');
|
||
INSERT INTO `fa_auth_group` VALUES (5, 2, 'Third group 2', '1,2,6,7,8,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34', 1491635035, 1491635035, 'normal');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_auth_group_access
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_auth_group_access`;
|
||
CREATE TABLE `fa_auth_group_access` (
|
||
`uid` int(10) UNSIGNED NOT NULL COMMENT '会员ID',
|
||
`group_id` int(10) UNSIGNED NOT NULL COMMENT '级别ID',
|
||
UNIQUE INDEX `uid_group_id`(`uid`, `group_id`) USING BTREE,
|
||
INDEX `uid`(`uid`) USING BTREE,
|
||
INDEX `group_id`(`group_id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限分组表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_auth_group_access
|
||
-- ----------------------------
|
||
INSERT INTO `fa_auth_group_access` VALUES (1, 1);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_auth_rule
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_auth_rule`;
|
||
CREATE TABLE `fa_auth_rule` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`type` enum('menu','file') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'file' COMMENT 'menu为菜单,file为权限节点',
|
||
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父ID',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '规则名称',
|
||
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '规则名称',
|
||
`icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图标',
|
||
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '规则URL',
|
||
`condition` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '条件',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`ismenu` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否为菜单',
|
||
`menutype` enum('addtabs','blank','dialog','ajax') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单类型',
|
||
`extend` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '扩展属性',
|
||
`py` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '拼音首字母',
|
||
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '拼音',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
|
||
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `name`(`name`) USING BTREE,
|
||
INDEX `pid`(`pid`) USING BTREE,
|
||
INDEX `weigh`(`weigh`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 99 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '节点表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_auth_rule
|
||
-- ----------------------------
|
||
INSERT INTO `fa_auth_rule` VALUES (1, 'file', 0, 'dashboard', 'Dashboard', 'fa fa-dashboard', '', '', 'Dashboard tips', 1, NULL, '', 'kzt', 'kongzhitai', 1491635035, 1491635035, 143, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (2, 'file', 0, 'general', 'General', 'fa fa-cogs', '', '', '', 1, NULL, '', 'cggl', 'changguiguanli', 1491635035, 1491635035, 137, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (3, 'file', 0, 'category', 'Category', 'fa fa-leaf', '', '', 'Category tips', 0, NULL, '', 'flgl', 'fenleiguanli', 1491635035, 1491635035, 119, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (4, 'file', 0, 'addon', 'Addon', 'fa fa-rocket', '', '', 'Addon tips', 1, NULL, '', 'cjgl', 'chajianguanli', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (5, 'file', 0, 'auth', 'Auth', 'fa fa-group', '', '', '', 1, NULL, '', 'qxgl', 'quanxianguanli', 1491635035, 1491635035, 99, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (6, 'file', 2, 'general/config', 'Config', 'fa fa-cog', '', '', 'Config tips', 1, NULL, '', 'xtpz', 'xitongpeizhi', 1491635035, 1491635035, 60, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (7, 'file', 2, 'general/attachment', 'Attachment', 'fa fa-file-image-o', '', '', 'Attachment tips', 1, NULL, '', 'fjgl', 'fujianguanli', 1491635035, 1491635035, 53, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (8, 'file', 2, 'general/profile', 'Profile', 'fa fa-user', '', '', '', 1, NULL, '', 'grzl', 'gerenziliao', 1491635035, 1491635035, 34, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (9, 'file', 5, 'auth/admin', 'Admin', 'fa fa-user', '', '', 'Admin tips', 1, NULL, '', 'glygl', 'guanliyuanguanli', 1491635035, 1491635035, 118, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (10, 'file', 5, 'auth/adminlog', 'Admin log', 'fa fa-list-alt', '', '', 'Admin log tips', 1, NULL, '', 'glyrz', 'guanliyuanrizhi', 1491635035, 1491635035, 113, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (11, 'file', 5, 'auth/group', 'Group', 'fa fa-group', '', '', 'Group tips', 1, NULL, '', 'jsz', 'juesezu', 1491635035, 1491635035, 109, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (12, 'file', 5, 'auth/rule', 'Rule', 'fa fa-bars', '', '', 'Rule tips', 1, NULL, '', 'cdgz', 'caidanguize', 1491635035, 1491635035, 104, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (13, 'file', 1, 'dashboard/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 136, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (14, 'file', 1, 'dashboard/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 135, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (15, 'file', 1, 'dashboard/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 133, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (16, 'file', 1, 'dashboard/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 134, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (17, 'file', 1, 'dashboard/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 132, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (18, 'file', 6, 'general/config/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 52, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (19, 'file', 6, 'general/config/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 51, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (20, 'file', 6, 'general/config/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 50, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (21, 'file', 6, 'general/config/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 49, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (22, 'file', 6, 'general/config/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 48, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (23, 'file', 7, 'general/attachment/index', 'View', 'fa fa-circle-o', '', '', 'Attachment tips', 0, NULL, '', '', '', 1491635035, 1491635035, 59, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (24, 'file', 7, 'general/attachment/select', 'Select attachment', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 58, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (25, 'file', 7, 'general/attachment/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 57, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (26, 'file', 7, 'general/attachment/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 56, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (27, 'file', 7, 'general/attachment/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 55, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (28, 'file', 7, 'general/attachment/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 54, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (29, 'file', 8, 'general/profile/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 33, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (30, 'file', 8, 'general/profile/update', 'Update profile', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 32, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (31, 'file', 8, 'general/profile/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 31, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (32, 'file', 8, 'general/profile/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 30, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (33, 'file', 8, 'general/profile/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 29, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (34, 'file', 8, 'general/profile/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 28, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (35, 'file', 3, 'category/index', 'View', 'fa fa-circle-o', '', '', 'Category tips', 0, NULL, '', '', '', 1491635035, 1491635035, 142, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (36, 'file', 3, 'category/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 141, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (37, 'file', 3, 'category/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 140, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (38, 'file', 3, 'category/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 139, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (39, 'file', 3, 'category/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 138, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (40, 'file', 9, 'auth/admin/index', 'View', 'fa fa-circle-o', '', '', 'Admin tips', 0, NULL, '', '', '', 1491635035, 1491635035, 117, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (41, 'file', 9, 'auth/admin/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 116, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (42, 'file', 9, 'auth/admin/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 115, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (43, 'file', 9, 'auth/admin/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 114, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (44, 'file', 10, 'auth/adminlog/index', 'View', 'fa fa-circle-o', '', '', 'Admin log tips', 0, NULL, '', '', '', 1491635035, 1491635035, 112, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (45, 'file', 10, 'auth/adminlog/detail', 'Detail', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 111, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (46, 'file', 10, 'auth/adminlog/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 110, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (47, 'file', 11, 'auth/group/index', 'View', 'fa fa-circle-o', '', '', 'Group tips', 0, NULL, '', '', '', 1491635035, 1491635035, 108, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (48, 'file', 11, 'auth/group/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 107, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (49, 'file', 11, 'auth/group/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 106, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (50, 'file', 11, 'auth/group/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 105, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (51, 'file', 12, 'auth/rule/index', 'View', 'fa fa-circle-o', '', '', 'Rule tips', 0, NULL, '', '', '', 1491635035, 1491635035, 103, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (52, 'file', 12, 'auth/rule/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 102, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (53, 'file', 12, 'auth/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 101, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (54, 'file', 12, 'auth/rule/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 100, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (55, 'file', 4, 'addon/index', 'View', 'fa fa-circle-o', '', '', 'Addon tips', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (56, 'file', 4, 'addon/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (57, 'file', 4, 'addon/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (58, 'file', 4, 'addon/del', 'Delete', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (59, 'file', 4, 'addon/downloaded', 'Local addon', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (60, 'file', 4, 'addon/state', 'Update state', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (63, 'file', 4, 'addon/config', 'Setting', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (64, 'file', 4, 'addon/refresh', 'Refresh', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (65, 'file', 4, 'addon/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (66, 'file', 0, 'user', 'User', 'fa fa-user-circle', '', '', '', 1, NULL, '', 'hygl', 'huiyuanguanli', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (67, 'file', 66, 'user/user', 'User', 'fa fa-user', '', '', '', 1, NULL, '', 'hygl', 'huiyuanguanli', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (68, 'file', 67, 'user/user/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (69, 'file', 67, 'user/user/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (70, 'file', 67, 'user/user/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (71, 'file', 67, 'user/user/del', 'Del', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (72, 'file', 67, 'user/user/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (73, 'file', 66, 'user/group', 'User group', 'fa fa-users', '', '', '', 1, NULL, '', 'hyfz', 'huiyuanfenzu', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (74, 'file', 73, 'user/group/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (75, 'file', 73, 'user/group/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (76, 'file', 73, 'user/group/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (77, 'file', 73, 'user/group/del', 'Del', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (78, 'file', 73, 'user/group/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (79, 'file', 66, 'user/rule', 'User rule', 'fa fa-circle-o', '', '', '', 1, NULL, '', 'hygz', 'huiyuanguize', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (80, 'file', 79, 'user/rule/index', 'View', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (81, 'file', 79, 'user/rule/del', 'Del', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (82, 'file', 79, 'user/rule/add', 'Add', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (83, 'file', 79, 'user/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (84, 'file', 79, 'user/rule/multi', 'Multi', 'fa fa-circle-o', '', '', '', 0, NULL, '', '', '', 1491635035, 1491635035, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (85, 'file', 0, 'command', '在线命令管理', 'fa fa-terminal', '', '', '', 1, NULL, '', 'zxmlgl', 'zaixianminglingguanli', 1776695313, 1776695313, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (86, 'file', 85, 'command/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1776695313, 1776695313, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (87, 'file', 85, 'command/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1776695313, 1776695313, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (88, 'file', 85, 'command/detail', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'xq', 'xiangqing', 1776695313, 1776695313, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (89, 'file', 85, 'command/command', '生成并执行命令', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'scbzxml', 'shengchengbingzhixingmingling', 1776695313, 1776695313, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (90, 'file', 85, 'command/execute', '再次执行命令', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zczxml', 'zaicizhixingmingling', 1776695313, 1776695313, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (91, 'file', 85, 'command/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1776695313, 1776695313, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (92, 'file', 85, 'command/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1776695313, 1776695313, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (93, 'file', 0, 'history', 'History', 'fa fa-circle-o\r', '', '', '', 1, NULL, '', 'H', 'History', 1776695585, 1776695585, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (94, 'file', 93, 'history/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'zk', 'zhakan', 1776695585, 1776695585, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (95, 'file', 93, 'history/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'tj', 'tianjia', 1776695585, 1776695585, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (96, 'file', 93, 'history/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'bj', 'bianji', 1776695585, 1776695585, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (97, 'file', 93, 'history/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'sc', 'shanchu', 1776695585, 1776695585, 0, 'normal');
|
||
INSERT INTO `fa_auth_rule` VALUES (98, 'file', 93, 'history/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 'plgx', 'pilianggengxin', 1776695585, 1776695585, 0, 'normal');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_category`;
|
||
CREATE TABLE `fa_category` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父ID',
|
||
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '栏目类型',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
|
||
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
|
||
`flag` set('hot','index','recommend') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
|
||
`image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片',
|
||
`keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '关键字',
|
||
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '描述',
|
||
`diyname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '自定义名称',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
|
||
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `weigh`(`weigh`, `id`) USING BTREE,
|
||
INDEX `pid`(`pid`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_category
|
||
-- ----------------------------
|
||
INSERT INTO `fa_category` VALUES (1, 0, 'page', '官方新闻', 'news', 'recommend', '/assets/img/qrcode.png', '', '', 'news', 1491635035, 1491635035, 1, 'normal');
|
||
INSERT INTO `fa_category` VALUES (2, 0, 'page', '移动应用', 'mobileapp', 'hot', '/assets/img/qrcode.png', '', '', 'mobileapp', 1491635035, 1491635035, 2, 'normal');
|
||
INSERT INTO `fa_category` VALUES (3, 2, 'page', '微信公众号', 'wechatpublic', 'index', '/assets/img/qrcode.png', '', '', 'wechatpublic', 1491635035, 1491635035, 3, 'normal');
|
||
INSERT INTO `fa_category` VALUES (4, 2, 'page', 'Android开发', 'android', 'recommend', '/assets/img/qrcode.png', '', '', 'android', 1491635035, 1491635035, 4, 'normal');
|
||
INSERT INTO `fa_category` VALUES (5, 0, 'page', '软件产品', 'software', 'recommend', '/assets/img/qrcode.png', '', '', 'software', 1491635035, 1491635035, 5, 'normal');
|
||
INSERT INTO `fa_category` VALUES (6, 5, 'page', '网站建站', 'website', 'recommend', '/assets/img/qrcode.png', '', '', 'website', 1491635035, 1491635035, 6, 'normal');
|
||
INSERT INTO `fa_category` VALUES (7, 5, 'page', '企业管理软件', 'company', 'index', '/assets/img/qrcode.png', '', '', 'company', 1491635035, 1491635035, 7, 'normal');
|
||
INSERT INTO `fa_category` VALUES (8, 6, 'page', 'PC端', 'website-pc', 'recommend', '/assets/img/qrcode.png', '', '', 'website-pc', 1491635035, 1491635035, 8, 'normal');
|
||
INSERT INTO `fa_category` VALUES (9, 6, 'page', '移动端', 'website-mobile', 'recommend', '/assets/img/qrcode.png', '', '', 'website-mobile', 1491635035, 1491635035, 9, 'normal');
|
||
INSERT INTO `fa_category` VALUES (10, 7, 'page', 'CRM系统 ', 'company-crm', 'recommend', '/assets/img/qrcode.png', '', '', 'company-crm', 1491635035, 1491635035, 10, 'normal');
|
||
INSERT INTO `fa_category` VALUES (11, 7, 'page', 'SASS平台软件', 'company-sass', 'recommend', '/assets/img/qrcode.png', '', '', 'company-sass', 1491635035, 1491635035, 11, 'normal');
|
||
INSERT INTO `fa_category` VALUES (12, 0, 'test', '测试1', 'test1', 'recommend', '/assets/img/qrcode.png', '', '', 'test1', 1491635035, 1491635035, 12, 'normal');
|
||
INSERT INTO `fa_category` VALUES (13, 0, 'test', '测试2', 'test2', 'recommend', '/assets/img/qrcode.png', '', '', 'test2', 1491635035, 1491635035, 13, 'normal');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_command
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_command`;
|
||
CREATE TABLE `fa_command` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '类型',
|
||
`params` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '参数',
|
||
`command` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '命令',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '返回结果',
|
||
`executetime` bigint(16) UNSIGNED NULL DEFAULT NULL COMMENT '执行时间',
|
||
`createtime` bigint(16) UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
|
||
`status` enum('successed','failured') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'failured' COMMENT '状态',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '在线命令表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_command
|
||
-- ----------------------------
|
||
INSERT INTO `fa_command` VALUES (1, 'crud', '{\"commandtype\":\"crud\",\"isrelation\":\"0\",\"local\":\"1\",\"delete\":\"0\",\"force\":\"0\",\"table\":\"fa_history\",\"controller\":\"\",\"model\":\"\",\"setcheckboxsuffix\":\"\",\"enumradiosuffix\":\"\",\"imagefield\":\"\",\"filefield\":\"\",\"intdatesuffix\":\"\",\"switchsuffix\":\"\",\"citysuffix\":\"\",\"selectpagesuffix\":\"\",\"selectpagessuffix\":\"\",\"ignorefields\":\"\",\"sortfield\":\"\",\"editorsuffix\":\"\",\"headingfilterfield\":\"\",\"tagsuffix\":\"\",\"jsonsuffix\":\"\",\"fixedcolumns\":\"\"}', 'php think crud --table=fa_history', 'Build Successed', 1776695574, 1776695574, 1776695574, 'successed');
|
||
INSERT INTO `fa_command` VALUES (2, 'menu', '{\"commandtype\":\"menu\",\"allcontroller\":\"0\",\"delete\":\"0\",\"force\":\"0\",\"controllerfile_text\":\"\",\"controllerfile\":\"History.php\"}', 'php think menu --controller=History', 'Build Successed!', 1776695585, 1776695585, 1776695585, 'successed');
|
||
INSERT INTO `fa_command` VALUES (3, 'crud', '{\"commandtype\":\"crud\",\"isrelation\":\"0\",\"local\":\"1\",\"delete\":\"1\",\"force\":\"0\",\"table\":\"fa_history\",\"controller\":\"\",\"model\":\"\",\"setcheckboxsuffix\":\"\",\"enumradiosuffix\":\"\",\"imagefield\":\"\",\"filefield\":\"\",\"intdatesuffix\":\"\",\"switchsuffix\":\"\",\"citysuffix\":\"\",\"selectpagesuffix\":\"\",\"selectpagessuffix\":\"\",\"ignorefields\":\"\",\"sortfield\":\"\",\"editorsuffix\":\"\",\"headingfilterfield\":\"\",\"tagsuffix\":\"\",\"jsonsuffix\":\"\",\"fixedcolumns\":\"\"}', 'php think crud --delete=1 --table=fa_history', '/mnt/d/code/php/amlhc/public/../application/admin/controller/History.php\n/mnt/d/code/php/amlhc/public/../application/admin/model/History.php\n/mnt/d/code/php/amlhc/public/../application/admin/validate/History.php\n/mnt/d/code/php/amlhc/application/admin/view/history/add.html\n/mnt/d/code/php/amlhc/application/admin/view/history/edit.html\n/mnt/d/code/php/amlhc/application/admin/view/history/index.html\n/mnt/d/code/php/amlhc/application/admin/view/history/recyclebin.html\n/mnt/d/code/php/amlhc/application/admin/lang/zh-cn/history.php\n/mnt/d/code/php/amlhc/public/assets/js/backend/history.js\nAre you sure you want to delete all those files? Type \'yes\' to continue: \nOperation is aborted!', 1776773210, 1776773210, 1776773210, 'failured');
|
||
INSERT INTO `fa_command` VALUES (4, 'crud', '{\"commandtype\":\"crud\",\"isrelation\":\"0\",\"local\":\"1\",\"delete\":\"0\",\"force\":\"0\",\"table\":\"fa_history\",\"controller\":\"\",\"model\":\"\",\"setcheckboxsuffix\":\"\",\"enumradiosuffix\":\"\",\"imagefield\":\"\",\"filefield\":\"\",\"intdatesuffix\":\"\",\"switchsuffix\":\"\",\"citysuffix\":\"\",\"selectpagesuffix\":\"\",\"selectpagessuffix\":\"\",\"ignorefields\":\"\",\"sortfield\":\"\",\"editorsuffix\":\"\",\"headingfilterfield\":\"\",\"tagsuffix\":\"\",\"jsonsuffix\":\"\",\"fixedcolumns\":\"\"}', 'php think crud --table=fa_history', 'Build Successed', 1776773257, 1776773257, 1776773257, 'successed');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_config`;
|
||
CREATE TABLE `fa_config` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '变量名',
|
||
`group` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分组',
|
||
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '变量标题',
|
||
`tip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '变量描述',
|
||
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
|
||
`visible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '可见条件',
|
||
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '变量值',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '变量字典数据',
|
||
`rule` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证规则',
|
||
`extend` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '扩展属性',
|
||
`setting` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '配置',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `name`(`name`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统配置' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_config
|
||
-- ----------------------------
|
||
INSERT INTO `fa_config` VALUES (1, 'name', 'basic', 'Site name', '请填写站点名称', 'string', '', '我的网站', '', 'required', '', '');
|
||
INSERT INTO `fa_config` VALUES (2, 'beian', 'basic', 'Beian', '粤ICP备15000000号-1', 'string', '', '', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (3, 'cdnurl', 'basic', 'Cdn url', '如果全站静态资源使用第三方云储存请配置该值', 'string', '', '', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (4, 'version', 'basic', 'Version', '如果静态资源有变动请重新配置该值', 'string', '', '1.0.3', '', 'required', '', '');
|
||
INSERT INTO `fa_config` VALUES (5, 'timezone', 'basic', 'Timezone', '', 'string', '', 'Asia/Shanghai', '', 'required', '', '');
|
||
INSERT INTO `fa_config` VALUES (6, 'forbiddenip', 'basic', 'Forbidden ip', '一行一条记录', 'text', '', '', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (7, 'languages', 'basic', 'Languages', '', 'array', '', '{\"backend\":\"zh-cn\",\"frontend\":\"zh-cn\"}', '', 'required', '', '');
|
||
INSERT INTO `fa_config` VALUES (8, 'fixedpage', 'basic', 'Fixed page', '请输入左侧菜单栏存在的链接', 'string', '', 'dashboard', '', 'required', '', '');
|
||
INSERT INTO `fa_config` VALUES (9, 'categorytype', 'dictionary', 'Category type', '', 'array', '', '{\"default\":\"Default\",\"page\":\"Page\",\"article\":\"Article\",\"test\":\"Test\"}', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (10, 'configgroup', 'dictionary', 'Config group', '', 'array', '', '{\"basic\":\"Basic\",\"email\":\"Email\",\"dictionary\":\"Dictionary\",\"user\":\"User\",\"example\":\"Example\"}', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (11, 'mail_type', 'email', 'Mail type', '选择邮件发送方式', 'select', '', '1', '[\"请选择\",\"SMTP\"]', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (12, 'mail_smtp_host', 'email', 'Mail smtp host', '错误的配置发送邮件会导致服务器超时', 'string', '', 'smtp.qq.com', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (13, 'mail_smtp_port', 'email', 'Mail smtp port', '(不加密默认25,SSL默认465,TLS默认587)', 'string', '', '465', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (14, 'mail_smtp_user', 'email', 'Mail smtp user', '（填写完整用户名）', 'string', '', '', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (15, 'mail_smtp_pass', 'email', 'Mail smtp password', '（填写您的密码或授权码）', 'password', '', '', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (16, 'mail_verify_type', 'email', 'Mail vertify type', '（SMTP验证方式[推荐SSL]）', 'select', '', '2', '[\"无\",\"TLS\",\"SSL\"]', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (17, 'mail_from', 'email', 'Mail from', '', 'string', '', '', '', '', '', '');
|
||
INSERT INTO `fa_config` VALUES (18, 'attachmentcategory', 'dictionary', 'Attachment category', '', 'array', '', '{\"category1\":\"Category1\",\"category2\":\"Category2\",\"custom\":\"Custom\"}', '', '', '', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_ems
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_ems`;
|
||
CREATE TABLE `fa_ems` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`event` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '事件',
|
||
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '邮箱',
|
||
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证码',
|
||
`times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验证次数',
|
||
`ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'IP',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '邮箱验证码表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_ems
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_history
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_history`;
|
||
CREATE TABLE `fa_history` (
|
||
`expect` int(11) NOT NULL COMMENT '期号',
|
||
`num1` int(11) NULL DEFAULT NULL,
|
||
`num2` int(11) NULL DEFAULT NULL,
|
||
`num3` int(11) NULL DEFAULT NULL,
|
||
`num4` int(11) NULL DEFAULT NULL,
|
||
`num5` int(11) NULL DEFAULT NULL,
|
||
`num6` int(11) NULL DEFAULT NULL,
|
||
`num7` int(11) NULL DEFAULT NULL,
|
||
`openTime` datetime NULL DEFAULT NULL,
|
||
PRIMARY KEY (`expect`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_history
|
||
-- ----------------------------
|
||
INSERT INTO `fa_history` VALUES (2025330, 20, 37, 32, 1, 11, 6, 36, '2025-11-26 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025331, 42, 24, 2, 22, 47, 21, 26, '2025-11-27 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025332, 44, 23, 45, 30, 19, 8, 26, '2025-11-28 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025333, 43, 31, 36, 11, 37, 27, 6, '2025-11-29 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025334, 35, 29, 41, 33, 1, 49, 46, '2025-11-30 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025335, 34, 35, 46, 31, 13, 3, 44, '2025-12-01 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025336, 20, 6, 15, 10, 13, 42, 17, '2025-12-02 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025337, 13, 44, 42, 24, 32, 14, 9, '2025-12-03 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025338, 41, 48, 34, 15, 25, 10, 8, '2025-12-04 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025339, 24, 22, 40, 36, 39, 31, 48, '2025-12-05 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025340, 45, 17, 15, 28, 22, 10, 16, '2025-12-06 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025341, 5, 34, 42, 7, 35, 12, 6, '2025-12-07 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025342, 41, 19, 17, 15, 24, 8, 4, '2025-12-08 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025343, 11, 45, 41, 28, 46, 35, 38, '2025-12-09 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025344, 11, 21, 42, 10, 47, 40, 27, '2025-12-10 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025345, 41, 23, 9, 11, 32, 3, 24, '2025-12-11 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025346, 11, 26, 40, 46, 34, 20, 3, '2025-12-12 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025347, 30, 8, 26, 37, 28, 24, 13, '2025-12-13 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025348, 31, 26, 44, 21, 22, 34, 16, '2025-12-14 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025349, 33, 11, 39, 4, 40, 46, 22, '2025-12-15 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025350, 7, 22, 42, 35, 16, 47, 49, '2025-12-16 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025351, 16, 15, 3, 12, 10, 11, 4, '2025-12-17 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025352, 25, 9, 29, 26, 10, 2, 44, '2025-12-18 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025353, 38, 6, 16, 46, 26, 48, 1, '2025-12-19 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025354, 21, 15, 4, 5, 28, 48, 30, '2025-12-20 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025355, 43, 9, 6, 28, 15, 30, 8, '2025-12-21 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025356, 40, 11, 8, 36, 13, 3, 24, '2025-12-22 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025357, 41, 35, 2, 13, 43, 24, 49, '2025-12-23 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025358, 26, 22, 43, 42, 18, 35, 7, '2025-12-24 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025359, 37, 38, 6, 23, 45, 42, 11, '2025-12-25 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025360, 27, 6, 44, 15, 39, 12, 41, '2025-12-26 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025361, 30, 11, 2, 38, 33, 20, 24, '2025-12-27 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025362, 45, 11, 37, 6, 30, 8, 23, '2025-12-28 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025363, 23, 21, 13, 4, 9, 15, 26, '2025-12-29 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025364, 31, 22, 2, 11, 43, 28, 12, '2025-12-30 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2025365, 49, 20, 29, 33, 10, 16, 26, '2025-12-31 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026001, 27, 8, 43, 33, 42, 11, 29, '2026-01-01 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026002, 48, 7, 4, 3, 15, 11, 22, '2026-01-02 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026003, 30, 44, 7, 15, 42, 17, 9, '2026-01-03 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026004, 22, 19, 7, 35, 49, 36, 45, '2026-01-04 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026005, 46, 19, 20, 36, 13, 17, 43, '2026-01-05 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026006, 35, 41, 15, 6, 46, 21, 13, '2026-01-06 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026007, 28, 40, 45, 34, 44, 15, 41, '2026-01-07 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026008, 5, 39, 36, 19, 29, 45, 21, '2026-01-08 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026009, 17, 18, 6, 49, 7, 22, 28, '2026-01-09 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026010, 23, 38, 24, 49, 11, 30, 27, '2026-01-10 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026011, 32, 10, 7, 5, 48, 15, 11, '2026-01-11 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026012, 25, 26, 33, 20, 41, 45, 11, '2026-01-12 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026013, 9, 19, 44, 27, 37, 6, 1, '2026-01-13 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026014, 38, 13, 12, 8, 43, 31, 26, '2026-01-14 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026015, 10, 8, 30, 20, 15, 33, 31, '2026-01-15 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026016, 34, 12, 48, 26, 40, 38, 6, '2026-01-16 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026017, 44, 18, 31, 41, 33, 2, 32, '2026-01-17 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026018, 40, 42, 43, 31, 25, 15, 39, '2026-01-18 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026019, 42, 22, 45, 19, 7, 25, 46, '2026-01-19 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026020, 9, 37, 14, 47, 11, 24, 12, '2026-01-20 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026021, 47, 45, 33, 7, 24, 10, 42, '2026-01-21 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026022, 39, 8, 20, 37, 46, 30, 18, '2026-01-22 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026023, 6, 29, 36, 38, 18, 31, 47, '2026-01-23 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026024, 10, 45, 25, 15, 23, 44, 28, '2026-01-24 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026025, 46, 10, 41, 6, 9, 14, 37, '2026-01-25 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026026, 44, 34, 24, 13, 37, 42, 19, '2026-01-26 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026027, 11, 16, 46, 10, 18, 49, 45, '2026-01-27 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026028, 17, 47, 28, 39, 32, 49, 3, '2026-01-28 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026029, 47, 8, 5, 4, 3, 18, 1, '2026-01-29 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026030, 3, 6, 47, 1, 35, 4, 41, '2026-01-30 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026031, 38, 25, 7, 19, 11, 5, 26, '2026-01-31 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026032, 23, 17, 11, 20, 10, 39, 6, '2026-02-01 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026033, 14, 22, 46, 33, 8, 11, 41, '2026-02-02 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026034, 38, 45, 35, 24, 30, 23, 19, '2026-02-03 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026035, 32, 47, 44, 36, 19, 41, 27, '2026-02-04 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026036, 44, 39, 11, 20, 27, 48, 1, '2026-02-05 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026037, 34, 42, 39, 13, 44, 45, 43, '2026-02-06 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026038, 6, 40, 49, 34, 12, 20, 42, '2026-02-07 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026039, 31, 20, 8, 29, 10, 4, 11, '2026-02-08 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026040, 46, 6, 29, 27, 11, 49, 28, '2026-02-09 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026041, 2, 8, 17, 44, 32, 27, 36, '2026-02-10 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026042, 38, 22, 17, 19, 1, 18, 16, '2026-02-11 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026043, 9, 35, 42, 40, 33, 3, 13, '2026-02-12 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026044, 46, 17, 39, 47, 48, 38, 19, '2026-02-13 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026045, 20, 38, 22, 13, 42, 27, 1, '2026-02-14 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026046, 13, 9, 20, 22, 39, 36, 3, '2026-02-15 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026047, 40, 35, 23, 42, 46, 47, 39, '2026-02-16 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026048, 8, 38, 29, 32, 46, 16, 24, '2026-02-17 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026049, 28, 42, 22, 49, 12, 31, 13, '2026-02-18 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026050, 10, 13, 30, 37, 33, 44, 23, '2026-02-19 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026051, 40, 42, 44, 6, 14, 38, 1, '2026-02-20 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026052, 15, 46, 14, 13, 40, 35, 38, '2026-02-21 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026053, 16, 12, 33, 17, 41, 18, 15, '2026-02-22 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026054, 37, 30, 11, 19, 49, 32, 48, '2026-02-23 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026055, 31, 28, 20, 21, 39, 9, 14, '2026-02-24 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026056, 45, 9, 6, 7, 10, 26, 48, '2026-02-25 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026057, 21, 29, 40, 30, 26, 34, 23, '2026-02-26 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026058, 20, 38, 13, 21, 33, 40, 31, '2026-02-27 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026059, 29, 19, 24, 43, 28, 12, 10, '2026-02-28 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026060, 5, 27, 40, 34, 39, 1, 9, '2026-03-01 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026061, 46, 17, 8, 25, 2, 37, 29, '2026-03-02 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026062, 46, 29, 6, 49, 35, 42, 24, '2026-03-03 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026063, 36, 26, 37, 2, 44, 31, 28, '2026-03-04 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026064, 8, 23, 40, 44, 34, 2, 18, '2026-03-05 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026065, 2, 45, 17, 38, 33, 24, 5, '2026-03-06 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026066, 24, 20, 36, 44, 2, 28, 37, '2026-03-07 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026067, 15, 30, 6, 1, 26, 9, 5, '2026-03-08 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026068, 49, 2, 1, 26, 38, 21, 23, '2026-03-09 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026069, 23, 16, 10, 34, 8, 36, 24, '2026-03-10 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026070, 47, 17, 23, 10, 41, 7, 25, '2026-03-11 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026071, 44, 30, 25, 5, 41, 8, 48, '2026-03-12 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026072, 12, 28, 1, 42, 25, 44, 46, '2026-03-13 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026073, 7, 29, 1, 33, 36, 14, 34, '2026-03-14 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026074, 12, 31, 49, 25, 24, 32, 10, '2026-03-15 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026075, 19, 22, 26, 20, 41, 27, 33, '2026-03-16 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026076, 12, 7, 24, 22, 3, 41, 2, '2026-03-17 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026077, 37, 32, 46, 25, 39, 30, 29, '2026-03-18 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026078, 18, 17, 10, 33, 2, 8, 46, '2026-03-19 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026079, 49, 34, 6, 20, 4, 43, 35, '2026-03-20 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026080, 21, 18, 17, 48, 9, 42, 3, '2026-03-21 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026081, 4, 36, 14, 15, 35, 41, 17, '2026-03-22 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026082, 3, 21, 33, 37, 41, 25, 27, '2026-03-23 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026083, 46, 8, 23, 36, 30, 1, 5, '2026-03-24 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026084, 7, 24, 2, 5, 20, 31, 16, '2026-03-25 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026085, 14, 13, 27, 33, 6, 20, 19, '2026-03-26 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026086, 15, 36, 14, 24, 26, 34, 12, '2026-03-27 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026087, 17, 1, 21, 29, 47, 2, 26, '2026-03-28 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026088, 16, 46, 18, 10, 12, 42, 27, '2026-03-29 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026089, 26, 44, 34, 5, 21, 22, 49, '2026-03-30 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026090, 48, 29, 20, 17, 37, 8, 36, '2026-03-31 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026091, 8, 17, 32, 5, 42, 24, 37, '2026-04-01 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026092, 46, 42, 25, 47, 38, 19, 6, '2026-04-02 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026093, 13, 18, 26, 47, 48, 4, 40, '2026-04-03 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026094, 16, 25, 4, 28, 43, 38, 17, '2026-04-04 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026095, 15, 39, 1, 38, 21, 48, 35, '2026-04-05 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026096, 35, 37, 26, 5, 25, 15, 43, '2026-04-06 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026097, 28, 8, 44, 26, 29, 46, 11, '2026-04-07 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026098, 24, 8, 3, 14, 32, 49, 17, '2026-04-08 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026099, 10, 32, 22, 18, 28, 17, 12, '2026-04-09 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026100, 24, 45, 4, 32, 3, 48, 33, '2026-04-10 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026101, 22, 8, 2, 34, 20, 12, 39, '2026-04-11 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026102, 47, 3, 32, 46, 39, 36, 20, '2026-04-12 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026103, 34, 3, 1, 30, 39, 4, 6, '2026-04-13 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026104, 20, 45, 39, 49, 3, 48, 1, '2026-04-14 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026105, 32, 44, 17, 19, 11, 36, 28, '2026-04-15 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026106, 31, 48, 5, 11, 46, 40, 22, '2026-04-16 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026107, 35, 10, 41, 43, 34, 6, 49, '2026-04-17 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026108, 6, 30, 26, 14, 48, 40, 45, '2026-04-18 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026109, 38, 7, 19, 24, 43, 8, 16, '2026-04-19 21:32:32');
|
||
INSERT INTO `fa_history` VALUES (2026110, 40, 3, 43, 29, 45, 19, 30, '2026-04-20 21:32:32');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_num
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_num`;
|
||
CREATE TABLE `fa_num` (
|
||
`num` int(11) NOT NULL COMMENT '数字',
|
||
`color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '波色',
|
||
`animal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生肖',
|
||
PRIMARY KEY (`num`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_num
|
||
-- ----------------------------
|
||
INSERT INTO `fa_num` VALUES (1, '红', '马');
|
||
INSERT INTO `fa_num` VALUES (2, '红', '蛇');
|
||
INSERT INTO `fa_num` VALUES (3, '蓝', '龙');
|
||
INSERT INTO `fa_num` VALUES (4, '蓝', '兔');
|
||
INSERT INTO `fa_num` VALUES (5, '绿', '虎');
|
||
INSERT INTO `fa_num` VALUES (6, '绿', '牛');
|
||
INSERT INTO `fa_num` VALUES (7, '红', '鼠');
|
||
INSERT INTO `fa_num` VALUES (8, '红', '猪');
|
||
INSERT INTO `fa_num` VALUES (9, '蓝', '狗');
|
||
INSERT INTO `fa_num` VALUES (10, '蓝', '鸡');
|
||
INSERT INTO `fa_num` VALUES (11, '绿', '猴');
|
||
INSERT INTO `fa_num` VALUES (12, '红', '羊');
|
||
INSERT INTO `fa_num` VALUES (13, '红', '马');
|
||
INSERT INTO `fa_num` VALUES (14, '蓝', '蛇');
|
||
INSERT INTO `fa_num` VALUES (15, '蓝', '龙');
|
||
INSERT INTO `fa_num` VALUES (16, '绿', '兔');
|
||
INSERT INTO `fa_num` VALUES (17, '绿', '虎');
|
||
INSERT INTO `fa_num` VALUES (18, '红', '牛');
|
||
INSERT INTO `fa_num` VALUES (19, '红', '鼠');
|
||
INSERT INTO `fa_num` VALUES (20, '蓝', '猪');
|
||
INSERT INTO `fa_num` VALUES (21, '绿', '狗');
|
||
INSERT INTO `fa_num` VALUES (22, '绿', '鸡');
|
||
INSERT INTO `fa_num` VALUES (23, '红', '猴');
|
||
INSERT INTO `fa_num` VALUES (24, '红', '羊');
|
||
INSERT INTO `fa_num` VALUES (25, '蓝', '马');
|
||
INSERT INTO `fa_num` VALUES (26, '蓝', '蛇');
|
||
INSERT INTO `fa_num` VALUES (27, '绿', '龙');
|
||
INSERT INTO `fa_num` VALUES (28, '绿', '兔');
|
||
INSERT INTO `fa_num` VALUES (29, '红', '虎');
|
||
INSERT INTO `fa_num` VALUES (30, '红', '牛');
|
||
INSERT INTO `fa_num` VALUES (31, '蓝', '鼠');
|
||
INSERT INTO `fa_num` VALUES (32, '绿', '猪');
|
||
INSERT INTO `fa_num` VALUES (33, '绿', '狗');
|
||
INSERT INTO `fa_num` VALUES (34, '红', '鸡');
|
||
INSERT INTO `fa_num` VALUES (35, '红', '猴');
|
||
INSERT INTO `fa_num` VALUES (36, '蓝', '羊');
|
||
INSERT INTO `fa_num` VALUES (37, '蓝', '马');
|
||
INSERT INTO `fa_num` VALUES (38, '绿', '蛇');
|
||
INSERT INTO `fa_num` VALUES (39, '绿', '龙');
|
||
INSERT INTO `fa_num` VALUES (40, '红', '兔');
|
||
INSERT INTO `fa_num` VALUES (41, '蓝', '虎');
|
||
INSERT INTO `fa_num` VALUES (42, '蓝', '牛');
|
||
INSERT INTO `fa_num` VALUES (43, '绿', '鼠');
|
||
INSERT INTO `fa_num` VALUES (44, '绿', '猪');
|
||
INSERT INTO `fa_num` VALUES (45, '红', '狗');
|
||
INSERT INTO `fa_num` VALUES (46, '红', '鸡');
|
||
INSERT INTO `fa_num` VALUES (47, '蓝', '猴');
|
||
INSERT INTO `fa_num` VALUES (48, '蓝', '羊');
|
||
INSERT INTO `fa_num` VALUES (49, '绿', '马');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_sms
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_sms`;
|
||
CREATE TABLE `fa_sms` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`event` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '事件',
|
||
`mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号',
|
||
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证码',
|
||
`times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验证次数',
|
||
`ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'IP',
|
||
`createtime` bigint(16) UNSIGNED NULL DEFAULT 0 COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短信验证码表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_sms
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_test
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_test`;
|
||
CREATE TABLE `fa_test` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`user_id` int(10) NULL DEFAULT 0 COMMENT '会员ID',
|
||
`admin_id` int(10) NULL DEFAULT 0 COMMENT '管理员ID',
|
||
`category_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '分类ID(单选)',
|
||
`category_ids` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类ID(多选)',
|
||
`tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标签',
|
||
`week` enum('monday','tuesday','wednesday') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '星期(单选):monday=星期一,tuesday=星期二,wednesday=星期三',
|
||
`flag` set('hot','index','recommend') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标志(多选):hot=热门,index=首页,recommend=推荐',
|
||
`genderdata` enum('male','female') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'male' COMMENT '性别(单选):male=男,female=女',
|
||
`hobbydata` set('music','reading','swimming') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '爱好(多选):music=音乐,reading=读书,swimming=游泳',
|
||
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标题',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
|
||
`image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片',
|
||
`images` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片组',
|
||
`attachfile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '附件',
|
||
`keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '关键字',
|
||
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '描述',
|
||
`city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '省市',
|
||
`array` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '数组:value=值',
|
||
`json` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '配置:key=名称,value=值',
|
||
`multiplejson` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '二维数组:title=标题,intro=介绍,author=作者,age=年龄',
|
||
`price` decimal(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '价格',
|
||
`views` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '点击',
|
||
`workrange` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '时间区间',
|
||
`startdate` date NULL DEFAULT NULL COMMENT '开始日期',
|
||
`activitytime` datetime NULL DEFAULT NULL COMMENT '活动时间(datetime)',
|
||
`year` year NULL DEFAULT NULL COMMENT '年',
|
||
`times` time NULL DEFAULT NULL COMMENT '时间',
|
||
`refreshtime` bigint(16) NULL DEFAULT NULL COMMENT '刷新时间',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`deletetime` bigint(16) NULL DEFAULT NULL COMMENT '删除时间',
|
||
`weigh` int(10) NULL DEFAULT 0 COMMENT '权重',
|
||
`switch` tinyint(1) NULL DEFAULT 0 COMMENT '开关',
|
||
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'normal' COMMENT '状态',
|
||
`state` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '状态值:0=禁用,1=正常,2=推荐',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '测试表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_test
|
||
-- ----------------------------
|
||
INSERT INTO `fa_test` VALUES (1, 1, 1, 12, '12,13', '互联网,计算机', 'monday', 'hot,index', 'male', 'music,reading', '我是一篇测试文章', '<p>我是测试内容</p>', '/assets/img/avatar.png', '/assets/img/avatar.png,/assets/img/qrcode.png', '/assets/img/avatar.png', '关键字', '我是一篇测试文章描述，内容过多时将自动隐藏', '广西壮族自治区/百色市/平果县', '[\"a\",\"b\"]', '{\"a\":\"1\",\"b\":\"2\"}', '[{\"title\":\"标题一\",\"intro\":\"介绍一\",\"author\":\"小明\",\"age\":\"21\"}]', 0.00, 0, '2020-10-01 00:00:00 - 2021-10-31 23:59:59', '2017-07-10', '2017-07-10 18:24:45', 2017, '18:24:45', 1491635035, 1491635035, 1491635035, NULL, 0, 1, 'normal', '1');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_user`;
|
||
CREATE TABLE `fa_user` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`group_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '组别ID',
|
||
`username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户名',
|
||
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '昵称',
|
||
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
|
||
`salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码盐',
|
||
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '电子邮箱',
|
||
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号',
|
||
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像',
|
||
`level` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级',
|
||
`gender` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性别',
|
||
`birthday` date NULL DEFAULT NULL COMMENT '生日',
|
||
`bio` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '格言',
|
||
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '余额',
|
||
`score` int(10) NOT NULL DEFAULT 0 COMMENT '积分',
|
||
`successions` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '连续登录天数',
|
||
`maxsuccessions` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '最大连续登录天数',
|
||
`prevtime` bigint(16) NULL DEFAULT NULL COMMENT '上次登录时间',
|
||
`logintime` bigint(16) NULL DEFAULT NULL COMMENT '登录时间',
|
||
`loginip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP',
|
||
`loginfailure` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '失败次数',
|
||
`loginfailuretime` bigint(16) NULL DEFAULT NULL COMMENT '最后登录失败时间',
|
||
`joinip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '加入IP',
|
||
`jointime` bigint(16) NULL DEFAULT NULL COMMENT '加入时间',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'Token',
|
||
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
|
||
`verification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `username`(`username`) USING BTREE,
|
||
INDEX `email`(`email`) USING BTREE,
|
||
INDEX `mobile`(`mobile`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_user
|
||
-- ----------------------------
|
||
INSERT INTO `fa_user` VALUES (1, 1, 'admin', 'admin', '9954e9ab7e25e0800824192642f3e026', '994709', 'admin@163.com', '13000000000', '/assets/img/avatar.png', 0, 0, '2017-04-08', '', 0.00, 0, 1, 1, 1491635035, 1491635035, '127.0.0.1', 0, 1491635035, '127.0.0.1', 1491635035, 0, 1491635035, '', 'normal', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_user_group
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_user_group`;
|
||
CREATE TABLE `fa_user_group` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '组名',
|
||
`rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '权限节点',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '添加时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员组表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_user_group
|
||
-- ----------------------------
|
||
INSERT INTO `fa_user_group` VALUES (1, '默认组', '1,2,3,4,5,6,7,8,9,10,11,12', 1491635035, 1491635035, 'normal');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_user_money_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_user_money_log`;
|
||
CREATE TABLE `fa_user_money_log` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
|
||
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '变更余额',
|
||
`before` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '变更前余额',
|
||
`after` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '变更后余额',
|
||
`memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员余额变动表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_user_money_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_user_rule
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_user_rule`;
|
||
CREATE TABLE `fa_user_rule` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`pid` int(10) NULL DEFAULT NULL COMMENT '父ID',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标题',
|
||
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
`ismenu` tinyint(1) NULL DEFAULT NULL COMMENT '是否菜单',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`weigh` int(10) NULL DEFAULT 0 COMMENT '权重',
|
||
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员规则表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_user_rule
|
||
-- ----------------------------
|
||
INSERT INTO `fa_user_rule` VALUES (1, 0, 'index', 'Frontend', '', 1, 1491635035, 1491635035, 1, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (2, 0, 'api', 'API Interface', '', 1, 1491635035, 1491635035, 2, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (3, 1, 'user', 'User Module', '', 1, 1491635035, 1491635035, 12, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (4, 2, 'user', 'User Module', '', 1, 1491635035, 1491635035, 11, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (5, 3, 'index/user/login', 'Login', '', 0, 1491635035, 1491635035, 5, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (6, 3, 'index/user/register', 'Register', '', 0, 1491635035, 1491635035, 7, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (7, 3, 'index/user/index', 'User Center', '', 0, 1491635035, 1491635035, 9, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (8, 3, 'index/user/profile', 'Profile', '', 0, 1491635035, 1491635035, 4, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (9, 4, 'api/user/login', 'Login', '', 0, 1491635035, 1491635035, 6, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (10, 4, 'api/user/register', 'Register', '', 0, 1491635035, 1491635035, 8, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (11, 4, 'api/user/index', 'User Center', '', 0, 1491635035, 1491635035, 10, 'normal');
|
||
INSERT INTO `fa_user_rule` VALUES (12, 4, 'api/user/profile', 'Profile', '', 0, 1491635035, 1491635035, 3, 'normal');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_user_score_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_user_score_log`;
|
||
CREATE TABLE `fa_user_score_log` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
|
||
`score` int(10) NOT NULL DEFAULT 0 COMMENT '变更积分',
|
||
`before` int(10) NOT NULL DEFAULT 0 COMMENT '变更前积分',
|
||
`after` int(10) NOT NULL DEFAULT 0 COMMENT '变更后积分',
|
||
`memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员积分变动表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_user_score_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_user_token
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_user_token`;
|
||
CREATE TABLE `fa_user_token` (
|
||
`token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Token',
|
||
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`expiretime` bigint(16) NULL DEFAULT NULL COMMENT '过期时间',
|
||
PRIMARY KEY (`token`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员Token表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_user_token
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for fa_version
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `fa_version`;
|
||
CREATE TABLE `fa_version` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`oldversion` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '旧版本号',
|
||
`newversion` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '新版本号',
|
||
`packagesize` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '包大小',
|
||
`content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '升级内容',
|
||
`downloadurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '下载地址',
|
||
`enforce` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '强制更新',
|
||
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
|
||
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
|
||
`weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
|
||
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '版本表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of fa_version
|
||
-- ----------------------------
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|