/*
 Navicat Premium Data Transfer

 Source Server         : fu_he4966_cn
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : fu.he4966.cn:3306
 Source Schema         : fu_he4966_cn

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

 Date: 22/12/2021 15:17:35
*/

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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '昵称',
  `password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码',
  `salt` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码盐',
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '电子邮箱',
  `loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `logintime` int(10) DEFAULT NULL COMMENT '登录时间',
  `loginip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '登录IP',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `token` varchar(59) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'Session标识',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员表';

-- ----------------------------
-- Records of fa_admin
-- ----------------------------
BEGIN;
INSERT INTO `fa_admin` VALUES (1, 'admin', 'Admin', '7058fdb42a4f1cf01b7a3bf1d9845d57', 'KN8o3s', '/assets/img/avatar.png', '496631085@qq.com', 0, 1640156366, '114.224.133.136', 1491635035, 1640156366, 'c26dc188-d9f4-4be5-be29-0de29d9f7afb', 'normal');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '管理员名字',
  `url` varchar(1500) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '操作页面',
  `title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '日志标题',
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
  `ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'IP',
  `useragent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'User-Agent',
  `createtime` int(10) DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `name` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=796 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员日志表';


BEGIN;
COMMIT;

-- ----------------------------
-- 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) DEFAULT NULL COMMENT '父id',
  `shortname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简称',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `mergename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '全称',
  `level` tinyint(4) DEFAULT NULL COMMENT '层级 0 1 2 省市区县',
  `pinyin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拼音',
  `code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '长途区号',
  `zip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮编',
  `first` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '首字母',
  `lng` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '经度',
  `lat` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '纬度',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='地区表';

-- ----------------------------
-- Records of fa_area
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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',
  `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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '物理路径',
  `imagewidth` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '宽度',
  `imageheight` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '高度',
  `imagetype` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片类型',
  `imageframes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片帧数',
  `filename` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文件名称',
  `filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `mimetype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'mime类型',
  `extparam` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '透传数据',
  `createtime` int(10) DEFAULT NULL COMMENT '创建日期',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `uploadtime` int(10) DEFAULT NULL COMMENT '上传时间',
  `storage` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `sha1` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '文件 sha1编码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='附件表';

-- ----------------------------
-- Records of fa_attachment
-- ----------------------------
BEGIN;
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');
INSERT INTO `fa_attachment` VALUES (2, 1, 0, '/uploads/20210622/a572d67db33e94f6dc8dd2e908c03ff2.jpg', '258', '258', 'jpg', 0, 'qrcode_for_gh_6f8842475043_258.jpg', 27557, 'image/jpeg', '', 1624348450, 1624348450, 1624348450, 'local', 'a9ea481cdc67e3dc4989f3f346206032337b0096');
INSERT INTO `fa_attachment` VALUES (3, 1, 0, '/uploads/20211214/1d6ef82fc20789599649cc8da10841ce.png', '646', '942', 'png', 0, 'ka_1.png', 334647, 'image/png', '', 1639466857, 1639466857, 1639466857, 'local', 'a8a4c6912ca4ce42bca95f786dbb02d36950f9d0');
INSERT INTO `fa_attachment` VALUES (4, 1, 0, '/uploads/20211214/7bd1881d51961274e432b0a2f1d95218.png', '190', '234', 'png', 0, 'ka_01.png', 50147, 'image/png', '', 1639466870, 1639466870, 1639466870, 'local', '7989a7370a54eef4f8d967c6bd8eec3dfd693e47');
INSERT INTO `fa_attachment` VALUES (5, 1, 0, '/uploads/20211214/d7c9872fb9b3a3c6f4a3fad4f1852f48.png', '190', '234', 'png', 0, 'ka_02.png', 50155, 'image/png', '', 1639466889, 1639466889, 1639466889, 'local', 'abffa9ec324f4d048832d175c1f960df778dde56');
INSERT INTO `fa_attachment` VALUES (6, 1, 0, '/uploads/20211214/164d0b5b5a36347f170bc247de7d48d2.png', '646', '942', 'png', 0, 'ka_2.png', 326707, 'image/png', '', 1639466894, 1639466894, 1639466894, 'local', '8cf0a93dc476e9b0ce01d2de4b03660224861794');
INSERT INTO `fa_attachment` VALUES (7, 1, 0, '/uploads/20211214/d02c40279d40d0fbd62fb65384d83250.png', '190', '234', 'png', 0, 'ka_03.png', 50758, 'image/png', '', 1639466910, 1639466910, 1639466910, 'local', 'a31cee63e1f1faf01901b9a14679b3cba79d8a0d');
INSERT INTO `fa_attachment` VALUES (8, 1, 0, '/uploads/20211214/15658f4cd72fab6caef1e412d6baae0f.png', '646', '942', 'png', 0, 'ka_3.png', 317852, 'image/png', '', 1639466915, 1639466915, 1639466915, 'local', 'f3548d929f32a015353465a8d495b26fc328a282');
INSERT INTO `fa_attachment` VALUES (9, 1, 0, '/uploads/20211214/ffed442dbcf99590330e56f9e637d0e4.png', '190', '234', 'png', 0, 'ka_04.png', 49516, 'image/png', '', 1639466927, 1639466927, 1639466927, 'local', 'ce558ac4fbf0377f0740fd47d110d0ea268ff883');
INSERT INTO `fa_attachment` VALUES (10, 1, 0, '/uploads/20211214/22aa650b9e82fda1dbf96792da68176b.png', '646', '942', 'png', 0, 'ka_4.png', 341830, 'image/png', '', 1639466932, 1639466932, 1639466932, 'local', 'f7b12c66d1ba639160f340b601d6cc87f4af2463');
INSERT INTO `fa_attachment` VALUES (11, 1, 0, '/uploads/20211215/60dcc6d3a32d7a9f64cb5d88700d0904.xlsx', '', '', 'xlsx', 0, '小程序登录名单(1)(1).xlsx', 9727, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '', 1639533425, 1639533425, 1639533425, 'local', '318fab41b4f1aa3606d9939c1ac6a0843bafc891');
INSERT INTO `fa_attachment` VALUES (12, 0, 0, '/uploads/20211215/b7131d7f721cd7904d6a16560c3c3ece.png', '502', '572', 'png', 0, 'KOIn0taAkKBWb7131d7f721cd7904d6a16560c3c3ece.png', 441963, 'image/png', '', 1639535584, 1639535584, 1639535584, 'local', 'c6f412ebe3b851ffdaf9534ccb8ade4cd20e84f2');
INSERT INTO `fa_attachment` VALUES (13, 0, 0, '/uploads/20211215/bc2e92d55208b59fa8ed6eaa8f0cf913.png', '448', '146', 'png', 0, 'zx2hERSWaEtAbc2e92d55208b59fa8ed6eaa8f0cf913.png', 19028, 'image/png', '', 1639536017, 1639536017, 1639536017, 'local', '54882cb6e2a5b54e245547ac742c8503e28c463b');
INSERT INTO `fa_attachment` VALUES (14, 0, 0, '/uploads/20211216/bc2e92d55208b59fa8ed6eaa8f0cf913.png', '448', '146', 'png', 0, 'Bqs6NEvYfhX5bc2e92d55208b59fa8ed6eaa8f0cf913.png', 19028, 'image/png', '', 1639617888, 1639617888, 1639617888, 'local', '54882cb6e2a5b54e245547ac742c8503e28c463b');
INSERT INTO `fa_attachment` VALUES (15, 0, 0, '/uploads/20211216/169bfb439af863545d2a3117473dcf51.jpg', '1279', '1706', 'jpg', 0, 'tmp_a2a3ac0aa9e5e52a26a4bd44f0fe056b.jpg', 407845, 'image/jpg', '', 1639618032, 1639618032, 1639618032, 'local', '75018488b6e60fa8fc165aa6a316b09e9a216ea4');
INSERT INTO `fa_attachment` VALUES (16, 0, 0, '/uploads/20211216/b487e8ebfc89b38200edd3a727a1cb8e.jpg', '1279', '1706', 'jpg', 0, 'tmp_ce6436ad35cfc02b236778d8ab32c175.jpg', 465828, 'image/jpg', '', 1639618058, 1639618058, 1639618058, 'local', '2757bb5191f91fc7f214537328737b470a1c047d');
INSERT INTO `fa_attachment` VALUES (17, 0, 0, '/uploads/20211216/5662b1c26e5ebbe3b75e07c2a8cdef6a.jpg', '1279', '1706', 'jpg', 0, 'tmp_204b0166b8cb11937436df2375f34513.jpg', 343630, 'image/jpg', '', 1639618100, 1639618100, 1639618100, 'local', '70c9ad146db29d81673ff0fbb10c0abbb8ad148c');
INSERT INTO `fa_attachment` VALUES (18, 0, 0, '/uploads/20211216/7726eb4e1fc26f78b9d3a90069b5c25d.jpg', '1279', '1706', 'jpg', 0, 'tmp_2302aa4c16e3144f8d0adb802750cf06.jpg', 445898, 'image/jpg', '', 1639618130, 1639618130, 1639618130, 'local', 'ac4d4b055b381e2de965ac656c053c0e193b3705');
INSERT INTO `fa_attachment` VALUES (19, 0, 0, '/uploads/20211216/9f9e0e2020b6a9130092cfddc9b5e768.jpg', '1279', '1706', 'jpg', 0, 'tmp_7014c851f7fdf99103edc7abb4db7f0f.jpg', 470586, 'image/jpg', '', 1639618174, 1639618174, 1639618174, 'local', '52ae9109577dfed583b365ab1fb15b3f2db945cf');
INSERT INTO `fa_attachment` VALUES (20, 0, 0, '/uploads/20211216/5ff6fb205e3a545c8fce79c73f4e16ef.jpg', '1279', '1706', 'jpg', 0, 'tmp_cf1df82d054bacd69bcd5441f48dae4a.jpg', 224981, 'image/jpg', '', 1639618209, 1639618209, 1639618209, 'local', 'de9c70ac610fcd58ea746b82c09652cdaf581c9c');
INSERT INTO `fa_attachment` VALUES (21, 0, 0, '/uploads/20211216/8c0455c37a1207b25e44795743c4dd0a.jpg', '1279', '1706', 'jpg', 0, 'tmp_868c4188cca5d4acd5c31c4054a5a0cb.jpg', 225790, 'image/jpg', '', 1639618225, 1639618225, 1639618225, 'local', '8fbaa71df10df9daff0c69a5803d3bfdd45df69c');
INSERT INTO `fa_attachment` VALUES (22, 0, 0, '/uploads/20211216/1985e4151eb00a9e03ca1cf41ba3032a.jpg', '1279', '1706', 'jpg', 0, 'tmp_1a18336960b522eb7f52678920568d51.jpg', 476581, 'image/jpg', '', 1639618546, 1639618546, 1639618546, 'local', '35f3b75e85ecd6087185a4b87a144eac5e8846f1');
INSERT INTO `fa_attachment` VALUES (23, 0, 0, '/uploads/20211216/9d999646e9abf6cdf1bcd1343e2c696a.jpg', '1279', '1706', 'jpg', 0, 'tmp_86cbab13b2541c73d600cdc5970c06e9.jpg', 227625, 'image/jpg', '', 1639618573, 1639618573, 1639618573, 'local', 'e1977bb82923455312f01a2c20a6ef0fc5f0ba76');
INSERT INTO `fa_attachment` VALUES (24, 0, 0, '/uploads/20211216/014f35bbd4e4d7f3535516995e6013cc.jpg', '1279', '1706', 'jpg', 0, 'tmp_1e9f7871b472a77d45562ab9eff50393.jpg', 217680, 'image/jpg', '', 1639618587, 1639618587, 1639618587, 'local', '195c023caad46d9525c26f6c3384316f55769054');
INSERT INTO `fa_attachment` VALUES (25, 0, 0, '/uploads/20211216/cc7a29e1f9a8863434be3a11eb63e0b8.jpg', '1279', '1706', 'jpg', 0, 'tmp_a03e007e24b059af542fff859150b94f.jpg', 236383, 'image/jpg', '', 1639618834, 1639618834, 1639618834, 'local', '560395edb57bff0154dd123f12ad771d160907e0');
INSERT INTO `fa_attachment` VALUES (26, 0, 0, '/uploads/20211216/a9037ccc7675ddb88827b2d82ce68987.jpg', '1279', '1706', 'jpg', 0, 'tmp_3b439ade29e047a51b37b9dd81be97d1.jpg', 336930, 'image/jpg', '', 1639618850, 1639618850, 1639618850, 'local', '6411389ae8369d1cd7674c106874cb39a67616cd');
INSERT INTO `fa_attachment` VALUES (27, 0, 0, '/uploads/20211216/04da2c262c03b7c9a83332f9ca7acdc0.jpg', '1279', '1706', 'jpg', 0, 'tmp_7f2771c9026dda304a5448b54d23289a.jpg', 264815, 'image/jpg', '', 1639618868, 1639618868, 1639618868, 'local', 'd1925fd952845560841434ce9e528d3a22d79822');
INSERT INTO `fa_attachment` VALUES (28, 0, 0, '/uploads/20211216/87f38ce3c1c0985206f35a1562de435a.jpg', '1279', '1706', 'jpg', 0, 'tmp_b04c233156c9d131d49d1620bd1f6138.jpg', 378551, 'image/jpg', '', 1639618884, 1639618884, 1639618884, 'local', 'b0835361c6c1c0c1612c9fa03795737d42f3aa21');
INSERT INTO `fa_attachment` VALUES (29, 0, 0, '/uploads/20211216/445d13e2f03148793f2e250c7e60a7fa.jpg', '1279', '1706', 'jpg', 0, 'tmp_a73d229eb573ea56c4ea0b53fdd50ffd.jpg', 200911, 'image/jpg', '', 1639618894, 1639618894, 1639618894, 'local', '812f1956179e00b081d68ae37d659735490ae046');
INSERT INTO `fa_attachment` VALUES (30, 0, 0, '/uploads/20211216/e689b286315a756f013cde0dc59c6698.jpg', '1279', '1706', 'jpg', 0, 'tmp_acb87a7c0ea7cff4ca5545372dff14ff.jpg', 215877, 'image/jpg', '', 1639618903, 1639618903, 1639618903, 'local', 'a6fbd1483605dea2b2490c3ed109fe387cacebb4');
INSERT INTO `fa_attachment` VALUES (31, 0, 0, '/uploads/20211222/0ea34c32d6daf54cb06b91a4b331f22f.jpg', '704', '1600', 'jpg', 0, 'tmp_56c7fcb5562750bf74f4f0b9c26fda7374b89a4305e3af8b.jpg', 100477, 'image/jpeg', '', 1640153958, 1640153958, 1640153958, 'local', '8961e494218b95481c9ad5d4a204df6d98fcd2c8');
INSERT INTO `fa_attachment` VALUES (32, 0, 0, '/uploads/20211222/3a345a19472d60edb2cbebbc693afb0d.jpg', '704', '1600', 'jpg', 0, 'tmp_5e9e23cfe122a9bc4fbde5ebc87a05ea357d7f1157a9f403.jpg', 121861, 'image/jpeg', '', 1640153973, 1640153973, 1640153973, 'local', '3b2a4c4b322aed2aac36cb4b000de09301defbe0');
INSERT INTO `fa_attachment` VALUES (33, 0, 0, '/uploads/20211222/d2dbcc037f3b2f6448ceeee59a594735.jpg', '704', '1600', 'jpg', 0, 'tmp_3bf9a74a59d03248a464f361603e7bd308c23b84631b8ecb.jpg', 111103, 'image/jpeg', '', 1640154032, 1640154032, 1640154032, 'local', '0908b0a7738a7caad09b019e0c9601975c58770a');
INSERT INTO `fa_attachment` VALUES (34, 0, 0, '/uploads/20211222/a7ec229f4f42c74e2cc3e9950850a583.jpg', '704', '1600', 'jpg', 0, 'tmp_2df9f35ee5eb82fae8636a66d7993807c8a5b252195b3d13.jpg', 125338, 'image/jpeg', '', 1640154067, 1640154067, 1640154067, 'local', '1e81354d42a4e6ae31a0a93036fa14b83302d38d');
INSERT INTO `fa_attachment` VALUES (35, 0, 0, '/uploads/20211222/ef10835a8ed49d1bca6b02fdb8b971db.jpg', '704', '1600', 'jpg', 0, 'tmp_40dc4e060259cb19b0cca6a990197a14a26b71e3464ced21.jpg', 120359, 'image/jpeg', '', 1640154083, 1640154083, 1640154083, 'local', '63bef77ab3e29404e789c903853f2d5be00ed43b');
INSERT INTO `fa_attachment` VALUES (36, 0, 0, '/uploads/20211222/a3c68dc8077b62c84f129257b32aeb6b.jpg', '704', '1600', 'jpg', 0, 'tmp_57b795b86d5082351b8bbda999302943bf5de5890b944113.jpg', 166166, 'image/jpeg', '', 1640154117, 1640154117, 1640154117, 'local', 'f640530788c4ba559b576eab85d92c3c60ccc486');
INSERT INTO `fa_attachment` VALUES (37, 0, 0, '/uploads/20211222/3c28902fc266d1a88b80a8b1f8e80959.jpg', '704', '1600', 'jpg', 0, 'tmp_0f3d2e86f6dd2493a836169091b97aee26581726321a74c7.jpg', 171714, 'image/jpeg', '', 1640154137, 1640154137, 1640154137, 'local', '0d2a812d1f92dcbc93cc4baa886971f8747665ad');
INSERT INTO `fa_attachment` VALUES (38, 0, 0, '/uploads/20211222/25fd882b8479047b64bcef4887acae16.jpg', '704', '1600', 'jpg', 0, 'tmp_7cd345b67c0136f24eccba3d80c80a6a343bc64d1e395752.jpg', 165440, 'image/jpeg', '', 1640154160, 1640154160, 1640154160, 'local', 'b9bad2dec4b9da3f69f52a85d2f9875344c050b3');
INSERT INTO `fa_attachment` VALUES (39, 0, 0, '/uploads/20211222/258a05c063ed287dae7fff1011e6cc70.jpg', '704', '1600', 'jpg', 0, 'tmp_77af965af90e826b611d13c56aa2f24f5643c1dd42d45911.jpg', 163292, 'image/jpeg', '', 1640154176, 1640154176, 1640154176, 'local', '137c953ace4663ed8f1d9b6144b46075629757bb');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '组名',
  `rules` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规则ID',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分组表';

-- ----------------------------
-- Records of fa_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_group` VALUES (1, 0, 'Admin group', '*', 1491635035, 1491635035, 'normal');
INSERT INTO `fa_auth_group` VALUES (2, 1, '管理员', '2,6,7,8,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,295,297,302,303,304,308,309,310,312,316,293,300,307,314', 1491635035, 1639533968, 'normal');
INSERT INTO `fa_auth_group` VALUES (3, 2, 'Third group', '', 1491635035, 1639533968, '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', '2,6,7,8,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34', 1491635035, 1639533968, 'normal');
COMMIT;

-- ----------------------------
-- 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 KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='权限分组表';

-- ----------------------------
-- Records of fa_auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_group_access` VALUES (1, 1);
INSERT INTO `fa_auth_group_access` VALUES (2, 2);
COMMIT;

-- ----------------------------
-- 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') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'file' COMMENT 'menu为菜单,file为权限节点',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则名称',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则名称',
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图标',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '规则URL',
  `condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '条件',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `ismenu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为菜单',
  `menutype` enum('addtabs','blank','dialog','ajax') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单类型',
  `extend` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '扩展属性',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `pid` (`pid`),
  KEY `weigh` (`weigh`)
) ENGINE=InnoDB AUTO_INCREMENT=321 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='节点表';

-- ----------------------------
-- Records of fa_auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_rule` VALUES (1, 'file', 0, 'dashboard', 'Dashboard', 'fa fa-dashboard', '', '', 'Dashboard tips', 1, NULL, '', 1491635035, 1491635035, 143, 'normal');
INSERT INTO `fa_auth_rule` VALUES (2, 'file', 0, 'general', 'General', 'fa fa-cogs', '', '', '', 1, NULL, '', 1491635035, 1491635035, 137, 'normal');
INSERT INTO `fa_auth_rule` VALUES (3, 'file', 0, 'category', '分类管理', 'fa fa-leaf', '', '', 'Category tips', 1, 'addtabs', '', 1491635035, 1624280138, 119, 'hidden');
INSERT INTO `fa_auth_rule` VALUES (4, 'file', 0, 'addon', 'Addon', 'fa fa-rocket', '', '', 'Addon tips', 1, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (5, 'file', 0, 'auth', 'Auth', 'fa fa-group', '', '', '', 1, NULL, '', 1491635035, 1491635035, 99, 'normal');
INSERT INTO `fa_auth_rule` VALUES (6, 'file', 2, 'general/config', 'Config', 'fa fa-cog', '', '', 'Config tips', 1, NULL, '', 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, '', 1491635035, 1491635035, 53, 'normal');
INSERT INTO `fa_auth_rule` VALUES (8, 'file', 2, 'general/profile', 'Profile', 'fa fa-user', '', '', '', 1, NULL, '', 1491635035, 1491635035, 34, 'normal');
INSERT INTO `fa_auth_rule` VALUES (9, 'file', 5, 'auth/admin', 'Admin', 'fa fa-user', '', '', 'Admin tips', 1, NULL, '', 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, '', 1491635035, 1491635035, 113, 'normal');
INSERT INTO `fa_auth_rule` VALUES (11, 'file', 5, 'auth/group', 'Group', 'fa fa-group', '', '', 'Group tips', 1, NULL, '', 1491635035, 1491635035, 109, 'normal');
INSERT INTO `fa_auth_rule` VALUES (12, 'file', 5, 'auth/rule', 'Rule', 'fa fa-bars', '', '', 'Rule tips', 1, NULL, '', 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-list', '', '', '', 1, NULL, '', 1491635035, 1491635035, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (67, 'file', 66, 'user/user', 'User', 'fa fa-user', '', '', '', 1, NULL, '', 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, '', 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, '', 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 (92, 'file', 0, 'cate', '栏目管理', 'fa fa-list-ol', '', '', '', 1, 'addtabs', '', 1623724295, 1624280174, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (93, 'file', 92, 'cate/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (94, 'file', 92, 'cate/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (95, 'file', 92, 'cate/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (96, 'file', 92, 'cate/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (97, 'file', 92, 'cate/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (98, 'file', 92, 'cate/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1623724295, 1623724295, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (149, 'file', 0, 'page', '单页管理', 'fa fa-pagelines', '', '', '', 1, 'addtabs', '', 1624239501, 1624280279, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (150, 'file', 149, 'page/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (151, 'file', 149, 'page/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (152, 'file', 149, 'page/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (153, 'file', 149, 'page/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (154, 'file', 149, 'page/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (155, 'file', 149, 'page/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624239501, 1624239501, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (156, 'file', 0, 'news', '信息动态', 'fa fa-newspaper-o', '', '', '', 1, 'addtabs', '', 1624262915, 1624280266, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (157, 'file', 156, 'news/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (158, 'file', 156, 'news/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (159, 'file', 156, 'news/recyclebin', '回收站', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (160, 'file', 156, 'news/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (161, 'file', 156, 'news/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (162, 'file', 156, 'news/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (163, 'file', 156, 'news/destroy', '真实删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (164, 'file', 156, 'news/restore', '还原', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (165, 'file', 156, 'news/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1624262915, 1624262915, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (286, 'file', 0, 'command', '在线命令管理', 'fa fa-terminal', '', '', '', 1, NULL, '', 1625232304, 1625232304, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (287, 'file', 286, 'command/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1625232304, 1625232304, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (288, 'file', 286, 'command/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1625232304, 1625232304, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (289, 'file', 286, 'command/detail', '详情', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1625232304, 1625232304, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (290, 'file', 286, 'command/execute', '运行', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1625232304, 1625232304, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (291, 'file', 286, 'command/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1625232304, 1625232304, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (292, 'file', 286, 'command/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1625232304, 1625232304, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (293, 'file', 0, 'card', '福卡管理', 'fa fa-cc-mastercard', '', '', '', 1, 'addtabs', '', 1639453074, 1639471240, 100, 'normal');
INSERT INTO `fa_auth_rule` VALUES (294, 'file', 293, 'card/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639453074, 1639453074, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (295, 'file', 293, 'card/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639453074, 1639453074, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (296, 'file', 293, 'card/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639453074, 1639453074, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (297, 'file', 293, 'card/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639453074, 1639453074, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (298, 'file', 293, 'card/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639453074, 1639453074, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (299, 'file', 293, 'card/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639453074, 1639453074, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (300, 'file', 0, 'prize', '奖品管理', 'fa fa-modx', '', '', '', 1, 'addtabs', '', 1639468146, 1639471211, 70, 'normal');
INSERT INTO `fa_auth_rule` VALUES (301, 'file', 300, 'prize/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468146, 1639468146, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (302, 'file', 300, 'prize/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468146, 1639468146, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (303, 'file', 300, 'prize/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468146, 1639468146, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (304, 'file', 300, 'prize/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468146, 1639468146, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (305, 'file', 300, 'prize/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468146, 1639468146, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (306, 'file', 300, 'prize/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468146, 1639468146, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (307, 'file', 0, 'user2', '会员管理', 'fa fa-user', '', '', '', 1, NULL, '', 1639468700, 1639468700, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (308, 'file', 307, 'user2/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468700, 1639468700, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (309, 'file', 307, 'user2/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468700, 1639468700, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (310, 'file', 307, 'user2/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468700, 1639468700, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (311, 'file', 307, 'user2/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468700, 1639468700, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (312, 'file', 307, 'user2/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468700, 1639468700, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (313, 'file', 307, 'user2/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639468700, 1639468700, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (314, 'file', 0, 'ranking', '领奖排名', 'fa fa-list-ol', '', '', '', 1, 'addtabs', '', 1639471079, 1639471176, 50, 'normal');
INSERT INTO `fa_auth_rule` VALUES (315, 'file', 314, 'ranking/import', 'Import', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639471079, 1639531937, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (316, 'file', 314, 'ranking/index', '查看', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639471079, 1639531937, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (317, 'file', 314, 'ranking/add', '添加', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639471079, 1639531937, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (318, 'file', 314, 'ranking/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639471079, 1639531937, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (319, 'file', 314, 'ranking/del', '删除', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639471079, 1639531937, 0, 'normal');
INSERT INTO `fa_auth_rule` VALUES (320, 'file', 314, 'ranking/multi', '批量更新', 'fa fa-circle-o', '', '', '', 0, NULL, '', 1639471079, 1639531937, 0, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_card
-- ----------------------------
DROP TABLE IF EXISTS `fa_card`;
CREATE TABLE `fa_card` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '福卡id',
  `name` varchar(255) DEFAULT NULL COMMENT '福卡名',
  `small_image` varchar(255) DEFAULT NULL COMMENT '小图',
  `image` varchar(255) DEFAULT NULL COMMENT '福卡图',
  `ratio` decimal(4,2) DEFAULT NULL COMMENT '中奖比例',
  `num` int(10) DEFAULT '0' COMMENT '已发放数量',
  `stock` int(10) DEFAULT NULL COMMENT '总数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='福卡管理';

-- ----------------------------
-- Records of fa_card
-- ----------------------------
BEGIN;
INSERT INTO `fa_card` VALUES (1, '未抽到卡', '', '', 0.00, 7, 1000);
INSERT INTO `fa_card` VALUES (2, '协作并进', '/uploads/20211214/ffed442dbcf99590330e56f9e637d0e4.png', '/uploads/20211214/22aa650b9e82fda1dbf96792da68176b.png', 34.00, 1, 200);
INSERT INTO `fa_card` VALUES (3, '学习创新', '/uploads/20211214/d02c40279d40d0fbd62fb65384d83250.png', '/uploads/20211214/15658f4cd72fab6caef1e412d6baae0f.png', 33.00, 6, 600);
INSERT INTO `fa_card` VALUES (4, '使命认同', '/uploads/20211214/d7c9872fb9b3a3c6f4a3fad4f1852f48.png', '/uploads/20211214/164d0b5b5a36347f170bc247de7d48d2.png', 0.00, 0, 10);
INSERT INTO `fa_card` VALUES (5, '诚信敬业', '/uploads/20211214/7bd1881d51961274e432b0a2f1d95218.png', '/uploads/20211214/1d6ef82fc20789599649cc8da10841ce.png', 33.00, 1, 200);
COMMIT;

-- ----------------------------
-- Table structure for fa_cate
-- ----------------------------
DROP TABLE IF EXISTS `fa_cate`;
CREATE TABLE `fa_cate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('channel','page','link','list') DEFAULT NULL COMMENT '类型',
  `model_id` int(10) unsigned DEFAULT '0' COMMENT '模型ID',
  `parent_id` int(10) unsigned DEFAULT '0' COMMENT '父ID',
  `name` varchar(30) DEFAULT '' COMMENT '栏目名称',
  `image` varchar(100) DEFAULT '' COMMENT '图片',
  `flag` varchar(100) DEFAULT '' COMMENT '标志',
  `seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
  `keywords` varchar(255) DEFAULT '' COMMENT '关键字',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `outlink` varchar(255) DEFAULT '' COMMENT '链接',
  `items` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '文章数量',
  `weigh` int(10) DEFAULT NULL,
  `tpl` varchar(100) DEFAULT '' COMMENT '栏目页模板',
  `listtpl` varchar(100) DEFAULT '' COMMENT '列表页模板',
  `showtpl` varchar(100) DEFAULT '' COMMENT '详情页模板',
  `pagesize` smallint(5) NOT NULL DEFAULT '10' COMMENT '分页大小',
  `isnav_switch` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否导航显示',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `status` enum('1','2') DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
  `diyname` varchar(100) DEFAULT NULL COMMENT '自定义名称',
  `table_name` varchar(255) DEFAULT NULL COMMENT '数据库表名',
  PRIMARY KEY (`id`),
  KEY `weigh` (`weigh`,`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COMMENT='栏目管理';

-- ----------------------------
-- Records of fa_cate
-- ----------------------------
BEGIN;
INSERT INTO `fa_cate` VALUES (52, 'page', 0, 0, 'TpMeCms介绍', '/cms/images/about-1.jpg', '', '', '', 'TpMeCMS是一款基于FastAdmin框架开发的，FastAdmin基于ThinkPHP5+Bootstrap开发的框架,核心代码简洁、明了，适用于微信小程序/公众号，PC网站，手机网站，App（Api接口）等集于一体的Tp框架，后台直接生成数据库的增删改查，方便二次开开发，了解thinkphp5即可上手   ', '', 0, 60, '', 'about', 'about', 1, 1, 1624065594, 1624921664, '1', 'about', 'fa_page');
INSERT INTO `fa_cate` VALUES (59, 'list', 0, 0, '信息动态', '', '', '', '', '', '', 0, 28, '', 'news', 'show', 2, 1, 1624068742, 1626656034, '1', 'news', 'fa_news');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '栏目类型',
  `name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `flag` set('hot','index','recommend') COLLATE utf8mb4_unicode_ci DEFAULT '',
  `image` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片',
  `keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '关键字',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '描述',
  `diyname` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '自定义名称',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `weigh` (`weigh`,`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分类表';

-- ----------------------------
-- Records of fa_category
-- ----------------------------
BEGIN;
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', 'TpMeCMS1', 'test1', 'recommend', '/assets/img/qrcode.png', '', '', 'test1', 1491635035, 1491635035, 12, 'normal');
INSERT INTO `fa_category` VALUES (13, 0, 'test', 'TpMeCMS2', 'test2', 'recommend', '/assets/img/qrcode.png', '', '', 'test2', 1491635035, 1491635035, 13, 'normal');
COMMIT;

-- ----------------------------
-- 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) NOT NULL DEFAULT '' COMMENT '类型',
  `params` varchar(1500) NOT NULL DEFAULT '' COMMENT '参数',
  `command` varchar(1500) NOT NULL DEFAULT '' COMMENT '命令',
  `content` text COMMENT '返回结果',
  `executetime` int(10) unsigned DEFAULT NULL COMMENT '执行时间',
  `createtime` int(10) unsigned DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) unsigned DEFAULT NULL COMMENT '更新时间',
  `status` enum('successed','failured') NOT NULL DEFAULT 'failured' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='在线命令表';

-- ----------------------------
-- Records of fa_command
-- ----------------------------
BEGIN;
INSERT INTO `fa_command` VALUES (1, 'crud', '[\"--force=1\",\"--table=fa_cate\",\"--fields=id,name,image,tpl,isnav,createtime,status\"]', 'php think crud --force=1 --table=fa_cate --fields=id,name,image,tpl,isnav,createtime,status', 'Build Successed', 1623724286, 1623724286, 1623724286, 'successed');
INSERT INTO `fa_command` VALUES (2, 'crud', '[\"--table=fa_card\",\"--fields=name,image,id,ratio\"]', 'php think crud --table=fa_card --fields=name,image,id,ratio', 'Build Successed', 1639453067, 1639453067, 1639453067, 'successed');
INSERT INTO `fa_command` VALUES (3, 'menu', '[\"--controller=Card\"]', 'php think menu --controller=Card', 'Build Successed!', 1639453074, 1639453074, 1639453074, 'successed');
INSERT INTO `fa_command` VALUES (4, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Undefined variable: content', 1639453433, 1639453433, 1639453433, 'failured');
INSERT INTO `fa_command` VALUES (5, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639453454, 1639453454, 1639453454, 'successed');
INSERT INTO `fa_command` VALUES (6, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639453456, 1639453456, 1639453456, 'successed');
INSERT INTO `fa_command` VALUES (7, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639453462, 1639453462, 1639453462, 'successed');
INSERT INTO `fa_command` VALUES (8, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639457184, 1639457184, 1639457184, 'successed');
INSERT INTO `fa_command` VALUES (9, 'api', '[\"--force=1\"]', 'php think api --force=1', NULL, 1639459276, 1639459276, 1639459276, 'failured');
INSERT INTO `fa_command` VALUES (10, 'api', '[\"--force=1\"]', 'php think api --force=1', NULL, 1639459279, 1639459279, 1639459279, 'failured');
INSERT INTO `fa_command` VALUES (11, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639459289, 1639459289, 1639459290, 'successed');
INSERT INTO `fa_command` VALUES (12, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639459501, 1639459501, 1639459501, 'successed');
INSERT INTO `fa_command` VALUES (13, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639459527, 1639459527, 1639459528, 'successed');
INSERT INTO `fa_command` VALUES (14, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639459537, 1639459537, 1639459537, 'successed');
INSERT INTO `fa_command` VALUES (15, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639459572, 1639459572, 1639459572, 'successed');
INSERT INTO `fa_command` VALUES (16, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639460181, 1639460181, 1639460181, 'successed');
INSERT INTO `fa_command` VALUES (17, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639461948, 1639461948, 1639461948, 'successed');
INSERT INTO `fa_command` VALUES (18, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639462099, 1639462099, 1639462099, 'successed');
INSERT INTO `fa_command` VALUES (19, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639464868, 1639464868, 1639464868, 'successed');
INSERT INTO `fa_command` VALUES (20, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639465647, 1639465647, 1639465647, 'successed');
INSERT INTO `fa_command` VALUES (21, 'crud', '[\"--table=fa_card\",\"--fields=name,image,id,ratio,small_image\"]', 'php think crud --table=fa_card --fields=name,image,id,ratio,small_image', 'controller already exists!\nIf you need to rebuild again, use the parameter --force=true', 1639466815, 1639466815, 1639466815, 'failured');
INSERT INTO `fa_command` VALUES (22, 'crud', '[\"--force=1\",\"--table=fa_card\",\"--fields=name,image,id,ratio,small_image\"]', 'php think crud --force=1 --table=fa_card --fields=name,image,id,ratio,small_image', 'Build Successed', 1639466818, 1639466818, 1639466818, 'successed');
INSERT INTO `fa_command` VALUES (23, 'crud', '[\"--force=1\",\"--table=fa_card\",\"--fields=name,image,id,ratio,small_image\"]', 'php think crud --force=1 --table=fa_card --fields=name,image,id,ratio,small_image', 'Build Successed', 1639466871, 1639466871, 1639466871, 'successed');
INSERT INTO `fa_command` VALUES (24, 'crud', '[\"--table=fa_prize\",\"--fields=id,weigh_id,name\"]', 'php think crud --table=fa_prize --fields=id,weigh_id,name', 'Build Successed', 1639467627, 1639467627, 1639467627, 'successed');
INSERT INTO `fa_command` VALUES (25, 'menu', '[\"--controller=Prize\"]', 'php think menu --controller=Prize', 'Build Successed!', 1639468146, 1639468146, 1639468146, 'successed');
INSERT INTO `fa_command` VALUES (26, 'crud', '[\"--force=1\",\"--table=fa_prize\",\"--fields=id,rank,name\",\"--relation=fa_ranking\",\"--relationmode=belongsto\",\"--relationforeignkey=rank\",\"--relationprimarykey=weigh\",\"--relationfields=uid\"]', 'php think crud --force=1 --table=fa_prize --fields=id,rank,name --relation=fa_ranking --relationmode=belongsto --relationforeignkey=rank --relationprimarykey=weigh --relationfields=uid', 'Build Successed', 1639468333, 1639468333, 1639468333, 'successed');
INSERT INTO `fa_command` VALUES (27, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639468445, 1639468445, 1639468445, 'successed');
INSERT INTO `fa_command` VALUES (28, 'crud', '[\"--table=fa_user\",\"--controller=user2\",\"--model=user2\",\"--fields=id,username,nickname,mobile,avatar,logintime,loginip,jointime,createtime,updatetime,job_number\"]', 'php think crud --table=fa_user --controller=user2 --model=user2 --fields=id,username,nickname,mobile,avatar,logintime,loginip,jointime,createtime,updatetime,job_number', 'Build Successed', 1639468689, 1639468689, 1639468689, 'successed');
INSERT INTO `fa_command` VALUES (29, 'menu', '[\"--controller=User2\"]', 'php think menu --controller=User2', 'Build Successed!', 1639468700, 1639468700, 1639468700, 'successed');
INSERT INTO `fa_command` VALUES (30, 'crud', '[\"--table=fa_prize\",\"--fields=id,name,price,min,max,image\"]', 'php think crud --table=fa_prize --fields=id,name,price,min,max,image', 'controller already exists!\nIf you need to rebuild again, use the parameter --force=true', 1639469286, 1639469286, 1639469286, 'failured');
INSERT INTO `fa_command` VALUES (31, 'crud', '[\"--force=1\",\"--table=fa_prize\",\"--fields=id,name,price,min,max,image\"]', 'php think crud --force=1 --table=fa_prize --fields=id,name,price,min,max,image', 'Build Successed', 1639469291, 1639469291, 1639469291, 'successed');
INSERT INTO `fa_command` VALUES (32, 'crud', '[\"--table=fa_ranking\",\"--fields=id,uid,time,weigh\",\"--relation=fa_prize\",\"--relationmode=belongsto\",\"--relationforeignkey=weigh\",\"--relationprimarykey=min\",\"--relationfields=name,price\"]', 'php think crud --table=fa_ranking --fields=id,uid,time,weigh --relation=fa_prize --relationmode=belongsto --relationforeignkey=weigh --relationprimarykey=min --relationfields=name,price', 'model already exists!\nIf you need to rebuild again, use the parameter --force=true', 1639471056, 1639471056, 1639471056, 'failured');
INSERT INTO `fa_command` VALUES (33, 'crud', '[\"--force=1\",\"--table=fa_ranking\",\"--fields=id,uid,time,weigh\",\"--relation=fa_prize\",\"--relationmode=belongsto\",\"--relationforeignkey=weigh\",\"--relationprimarykey=min\",\"--relationfields=name,price\"]', 'php think crud --force=1 --table=fa_ranking --fields=id,uid,time,weigh --relation=fa_prize --relationmode=belongsto --relationforeignkey=weigh --relationprimarykey=min --relationfields=name,price', 'Build Successed', 1639471072, 1639471072, 1639471072, 'successed');
INSERT INTO `fa_command` VALUES (34, 'menu', '[\"--controller=Ranking\"]', 'php think menu --controller=Ranking', 'Build Successed!', 1639471079, 1639471079, 1639471079, 'successed');
INSERT INTO `fa_command` VALUES (35, 'menu', '[\"--controller=Ranking\"]', 'php think menu --controller=Ranking', 'Build Successed!', 1639531937, 1639531937, 1639531937, 'successed');
INSERT INTO `fa_command` VALUES (36, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639531940, 1639531940, 1639531940, 'successed');
INSERT INTO `fa_command` VALUES (37, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639531962, 1639531962, 1639531963, 'successed');
INSERT INTO `fa_command` VALUES (38, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639555880, 1639555880, 1639555880, 'successed');
INSERT INTO `fa_command` VALUES (39, 'api', '[\"--force=1\"]', 'php think api --force=1', 'Build Successed!', 1639617092, 1639617092, 1639617092, 'successed');
INSERT INTO `fa_command` VALUES (40, 'crud', '[\"--table=fa_card\"]', 'php think crud --table=fa_card', 'controller already exists!\nIf you need to rebuild again, use the parameter --force=true', 1640156387, 1640156387, 1640156387, 'failured');
INSERT INTO `fa_command` VALUES (41, 'crud', '[\"--force=1\",\"--table=fa_card\"]', 'php think crud --force=1 --table=fa_card', 'Build Successed', 1640156391, 1640156391, 1640156391, 'successed');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '变量名',
  `group` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '分组',
  `title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '变量标题',
  `tip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '变量描述',
  `type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
  `value` text COLLATE utf8mb4_unicode_ci COMMENT '变量值',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '变量字典数据',
  `rule` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证规则',
  `extend` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '扩展属性',
  `setting` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '配置',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统配置';

-- ----------------------------
-- Records of fa_config
-- ----------------------------
BEGIN;
INSERT INTO `fa_config` VALUES (1, 'name', 'basic', 'Site name', '请填写站点名称', 'string', '集福', '', 'required', '', NULL);
INSERT INTO `fa_config` VALUES (2, 'beian', 'basic', 'Beian', '粤ICP备15000000号-1', 'string', '蜀ICP备2020032960号-1', '', '', '', NULL);
INSERT INTO `fa_config` VALUES (3, 'cdnurl', 'basic', 'Cdn url', '如果全站静态资源使用第三方云储存请配置该值', 'string', '', '', '', '', NULL);
INSERT INTO `fa_config` VALUES (4, 'version', 'basic', 'Version', '如果静态资源有变动请重新配置该值', 'string', '1.0.1', '', 'required', '', NULL);
INSERT INTO `fa_config` VALUES (5, 'timezone', 'basic', 'Timezone', '', 'string', 'Asia/Shanghai', '', 'required', '', NULL);
INSERT INTO `fa_config` VALUES (6, 'forbiddenip', 'basic', 'Forbidden ip', '一行一条记录', 'text', '', '', '', '', NULL);
INSERT INTO `fa_config` VALUES (7, 'languages', 'basic', 'Languages', '', 'array', '{\"backend\":\"zh-cn\",\"frontend\":\"zh-cn\"}', '', 'required', '', NULL);
INSERT INTO `fa_config` VALUES (8, 'fixedpage', 'basic', 'Fixed page', '请尽量输入左侧菜单栏存在的链接', 'string', 'dashboard', '', 'required', '', NULL);
INSERT INTO `fa_config` VALUES (9, 'categorytype', 'dictionary', 'Category type', '', 'array', '{\"default\":\"Default\",\"page\":\"Page\",\"article\":\"Article\",\"test\":\"Test\"}', '', '', '', NULL);
INSERT INTO `fa_config` VALUES (10, 'configgroup', 'dictionary', 'Config group', '', 'array', '{\"basic\":\"Basic\",\"email\":\"Email\",\"dictionary\":\"Dictionary\",\"user\":\"User\",\"example\":\"Example\",\"weixin\":\"Weixin\"}', '', '', '', NULL);
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', '10000', '', '', '', '');
INSERT INTO `fa_config` VALUES (15, 'mail_smtp_pass', 'email', 'Mail smtp password', '（填写您的密码或授权码）', 'string', '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', '10000@qq.com', '', '', '', '');
INSERT INTO `fa_config` VALUES (18, 'app_id', 'weixin', '小程序Appid', '小程序Appid', 'string', 'wx4ca333dbce2e0993', '', '', '', NULL);
INSERT INTO `fa_config` VALUES (19, 'secret', 'weixin', '小程序密匙', '小程序密匙secret', 'string', 'ee4aefaf8c339c47eb2b7a6659c3c234', '', '', '', NULL);
INSERT INTO `fa_config` VALUES (20, 'mch_id', 'weixin', '微信商户号', '微信商户号', 'string', '1679466040', '', '', '', NULL);
INSERT INTO `fa_config` VALUES (21, 'key', 'weixin', 'API 密钥', '微信商户号密匙', 'string', 'xxxxxxxxxxxxxxxxxxxxxx', '', '', '', NULL);
INSERT INTO `fa_config` VALUES (22, 'wx_app_id', 'weixin', '公众号Appid', '微信公众号Appid', 'string', 'wxe8ed1781937ff05c', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (23, 'wx_secret', 'weixin', '公众号密匙', '微信公众号的密匙', 'string', 'de073be26de9bf6866de10c19fd04b72', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (24, 'tel', 'basic', '联系手机', '联系手机号码', 'string', '19999999999', '', 'mobile', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (25, 'index_url', 'basic', '网站首页地址', '网站首页地址', 'string', '/cms/index/index', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (26, 'wxqr_img', 'weixin', '公众号二维码', '关注微信公众号二维码', 'image', '/uploads/20210622/a572d67db33e94f6dc8dd2e908c03ff2.jpg', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (27, 'addr', 'basic', '联系地址', '联系地址', 'string', '无锡市惠山区宇野网络大厦', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (28, 'addr2', 'basic', '联系地址2', '联系地址2', 'string', 'B1108', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (29, 'email', 'basic', '邮箱', '邮箱地址', 'string', '496631085@qq.com', '', 'email', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (30, 'banquan', 'basic', '版权', '底部版权信息', 'string', 'TpMeCms © 2021 版权所有', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (31, 'technical_support', 'basic', '技术支持', '技术支持', 'string', '技术支持：TpMeCMS', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (32, 'route_switch', 'basic', '自定义路由开关', '开启后使用的(栏目管理>自定义名称)', 'switch', '1', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (33, 'everyday_scan_num', 'basic', '每天扫码次数', '每天识别次数，未识别成功也算一次', 'number', '10', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (34, 'ali_ocr_id', 'basic', '阿里OCR识别', '阿里OCR AccessKey ID', 'string', 'LTAI5tRuMrZnqq496631085', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (35, 'ali_ocr_secret', 'basic', '阿里OCR Secret', '阿里OCR AccessKey Secret', 'string', 'S5et6ue0T5FwTrRuz1qq496631085', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (36, 'tencent_ocr_id', 'basic', '腾讯id', '腾讯OCR id', 'string', 'AKIDA9tMYT7UaQ0KPDk0zh8qq496631085', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (37, 'tencent_ocr_secret', 'basic', '腾讯OCR 密钥', '腾讯OCR 密钥', 'string', 'sUptfBQO6Zqqqqqq496631085', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
INSERT INTO `fa_config` VALUES (38, 'open_prize', 'basic', '开奖', '', 'switch', '0', '', '', '', '{\"table\":\"\",\"conditions\":\"\",\"key\":\"\",\"value\":\"\"}');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '事件',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '邮箱',
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证码',
  `times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
  `ip` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'IP',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱验证码表';

-- ----------------------------
-- Records of fa_ems
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fa_news
-- ----------------------------
DROP TABLE IF EXISTS `fa_news`;
CREATE TABLE `fa_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT '' COMMENT '文章标题',
  `image` varchar(255) DEFAULT '' COMMENT '缩略图',
  `images` varchar(1500) DEFAULT '' COMMENT '组图',
  `seotitle` varchar(255) DEFAULT '' COMMENT 'SEO标题',
  `keywords` varchar(255) DEFAULT '' COMMENT '关键字',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `tags` varchar(255) DEFAULT '' COMMENT 'TAG',
  `weigh` int(10) DEFAULT NULL,
  `views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `publishtime` int(10) DEFAULT NULL COMMENT '发布时间',
  `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
  `memo` varchar(100) DEFAULT '' COMMENT '备注',
  `content` text COMMENT '内容',
  `status` enum('1','2') NOT NULL DEFAULT '1' COMMENT '状态:1=正常,2=隐藏',
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `channel` (`weigh`,`id`),
  KEY `weigh` (`weigh`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COMMENT='信息动态';

-- ----------------------------
-- Records of fa_news
-- ----------------------------
BEGIN;
INSERT INTO `fa_news` VALUES (1, 'TpMeCMS后台添加和编辑页面的文件下拉等输入框代码替换', '/cms/images/s01.jpg', '/cms/images/s01.jpg', '', '', 'TpMeCMS', 'admin,view,后台html,上传视频,上传多图', 0, 29, NULL, 1626750254, NULL, NULL, '', '<p><b>1</b></p>', '1');
INSERT INTO `fa_news` VALUES (111, 'TpMeCMS介绍及下载地址', '/cms/images/news-1.jpg', '/cms/images/news-1.jpg', '', '', '', '标签,分割', 111, 51, 1624004284, 1627722058, 1624004236, NULL, '', '<p>TpMeCMS开源地址Gitee：&nbsp;&nbsp;<a href=\"https://gitee.com/xiaohe4966/tp-me-cms\" target=\"_blank\">https://gitee.com/xiaohe4966/tp-me-cms</a></p><p>完整静态打包地址Github：&nbsp;<a href=\"https://github.com/xiaohe4966/TpMeCMS\">https://github.com/xiaohe4966/TpMeCMS</a><a href=\"https://github.com/xiaohe4966/TpMeCMS\"></a></p><p><br></p><p>完整示例网站：<a href=\"http://yunshang.he4966.cn/cms/index/index\" target=\"_blank\">http://yunshang.he4966.cn/cms/index/index</a>  <script src=\'https://gitee.com/xiaohe4966/tp-me-cms/widget_preview\' async defer></script>\n<div id=\"osc-gitee-widget-tag\"></div>\n<style>\n.osc_pro_color {color: #4183c4 !important;}\n.osc_panel_color {background-color: #ffffff !important;}\n.osc_background_color {background-color: #ffffff !important;}\n.osc_border_color {border-color: #0671b8 !important;}\n.osc_desc_color {color: #666666 !important;}\n.osc_link_color * {color: #5c095c !important;}\n</style></p>', '1');
INSERT INTO `fa_news` VALUES (112, '员工列表', '/cms/images/news-2.jpg', '/cms/images/services-1.jpg', 'International standard laboratory', '公共服务平台关键字', '/cms/images/services-1.jpg', '', 112, 21, 1624263266, 1624934496, 1624263230, 1624934496, '', '<p>zheshi miaos&nbsp;</p>', '1');
INSERT INTO `fa_news` VALUES (113, 'Fastadmin 后台表格每行数据加按钮弹新页面教程及更具条件显示或隐藏', '', '', '', '', '', '', 113, 17, 1626143944, 1627636259, 1626143865, NULL, '', '<p>在对应的js里面编辑</p><p><br></p><p>找到如下代码：</p><pre><code class=\"lang-js\">    {field: \'operate\', title: __(\'Operate\'), table: table,<br></code></pre><p>并在后面添加：可自行修改</p><pre><code class=\"lang-js\">                        {field: \'operate\', title: __(\'Operate\'), table: table,\r\n                            buttons: [\r\n                                {\r\n                                    name: \'editprice\',\r\n                                    text: \'编辑附近大学\',\r\n                                    title: \'编辑附近大学\',\r\n                                    classname: \'btn btn-xs btn-success btn-dialog\',\r\n                                    icon: \'fa fa-folder-o\',\r\n                                    url: \'shop/yuyue_order2/editprice\'\r\n                                }\r\n                            ], \r\n                            events: Table.api.events.operate, formatter: Table.api.formatter.operate}<br></code></pre><p><br></p><p><br></p><p><br></p><p>如果要更具条件来显示或隐藏该按钮在里面加入</p><pre><code class=\"lang-js\">   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;hidden:function(row){\r\n                                            if(row.xiaohe==0){//xiaohe就是这个数据的字段 自行修改\r\n                                                return false; //显示该按钮\r\n                                            }else{\r\n                                                return true;&nbsp;&nbsp;//隐藏该按钮\r\n                                            }\r\n                                        },<br></code></pre><p>示例用法</p><pre><code>       {field: \'operate\', title: __(\'Operate\'), table: table,\r\n                            buttons: [\r\n                                {\r\n                                    name: \'editprice\',\r\n                                    text: \'编辑附近大学\',\r\n                                    title: \'编辑附近大学\',\r\n                                    classname: \'btn btn-xs btn-success btn-dialog\',\r\n                                    icon: \'fa fa-folder-o\',\r\n\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//隐藏按钮条件\r\n   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;hidden:function(row){\r\n                                            if(row.end_status==0){  // 自行修改条件\r\n                                                return false; //显示该按钮\r\n                                            }else{\r\n                                                return true;  //隐藏该按钮\r\n                                            }\r\n                                    },\r\n\r\n                                    url: \'shop/yuyue_order2/editprice\'\r\n                                }\r\n                            ], \r\n                            events: Table.api.events.operate, formatter: Table.api.formatter.operate}<br></code></pre>', '1');
INSERT INTO `fa_news` VALUES (114, '宝塔定时任务执行每30秒执行一次', '', '', '', '', '', '', 114, 10, 1626857801, 1626857801, 1626857661, NULL, '', '<p>更改前</p><pre><code class=\"lang-bash\">#!/bin/bash\r\nPATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin\r\nexport PATH\r\ncurl -sS --connect-timeout 10 -m 3600 \'http://newk3.he4966.cn/api/twhttp/update_data\'\r\necho \"----------------------------------------------------------------------------\"\r\nendDate=`date +\"%Y-%m-%d %H:%M:%S\"`\r\necho \"★[$endDate] Successful\"\r\necho \"----------------------------------------------------------------------------\"\r\n<br></code></pre><p><br></p><p><br></p><p><br></p><p>更改后</p><pre><code class=\"lang-bash\">#!/bin/bash\r\nPATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin\r\nexport PATH\r\nstep=30 //时间\r\nfor (( i = 0; i &lt; 60; i=(i+step) )); do\r\ncurl -sS --connect-timeout 10 -m 3600 \'http://newk3.he4966.cn/api/twhttp/update_data\'\r\necho \"----------------------------------------------------------------------------\"\r\nendDate=`date +\"%Y-%m-%d %H:%M:%S\"`\r\necho \"★[$endDate] Successful\"\r\necho \"----------------------------------------------------------------------------\"\r\nsleep $step\r\ndone\r\nexit 0\r\n<br></code></pre>', '1');
COMMIT;

-- ----------------------------
-- Table structure for fa_page
-- ----------------------------
DROP TABLE IF EXISTS `fa_page`;
CREATE TABLE `fa_page` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `cate_id` tinyint(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `description` varchar(255) DEFAULT NULL COMMENT '简介',
  `createtime` int(11) DEFAULT NULL,
  `updatetime` int(11) unsigned DEFAULT '0' COMMENT '更新时间',
  `weigh` int(10) DEFAULT '50',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='单页管理';

-- ----------------------------
-- Records of fa_page
-- ----------------------------
BEGIN;
INSERT INTO `fa_page` VALUES (2, 52, '简单介绍', '<div style=\"line-height: 1.4;\"><div style=\"line-height: 1.4;\"><span style=\"font-size: 18px;\">TpMeCMS是一款基于FastAdmin框架开发的，FastAdmin基于ThinkPHP5+Bootstrap开发的框架,核心代码简洁、明了，适用于微信小程序/公众号，PC网站，手机网站，App（Api接口）等集于一体的Tp框架，后台直接生成数据库的增删改查，方便二次开开发，了解thinkphp5即可上手</span></div><br><br><div style=\"line-height: 1.4;\"><span style=\"font-size: 18px;\">## TpMeCMS由来</span></div><div style=\"line-height: 1.4;\"><span style=\"font-size: 18px;\">    用过FastAdmin的插件cms，SIYUCMS，行云海CMS等，功能功能各有优点缺点，发现自己的项目经常使用（微信小程序/公众号，PC网站，手机网站，App（Api接口）等），结合还需要二次开发，才能使用，于是就使用自己熟悉等thinkphp5，FastAdmin来开发自己的cms框架</span></div><br><div style=\"line-height: 1.4;\"><span style=\"font-size: 18px;\">## TpMeCMS主要优点</span></div><div style=\"line-height: 1.4;\"><span style=\"font-size: 18px;\">    集成微信小程序和微信公众号功能，后台集成栏目管理等，接口可以直接拷贝app\\cms\\controller\\Cms</span></div></div>\r\n', '', 1580966471, 1624921164, 11);
COMMIT;

-- ----------------------------
-- Table structure for fa_prize
-- ----------------------------
DROP TABLE IF EXISTS `fa_prize`;
CREATE TABLE `fa_prize` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '奖品名称',
  `price` decimal(10,2) NOT NULL COMMENT '价值多元',
  `min` int(10) NOT NULL COMMENT '从第几名（包含）',
  `max` int(10) NOT NULL COMMENT '到第几名(不包含）',
  `image` varchar(255) DEFAULT NULL COMMENT '奖品图',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='奖品管理';

-- ----------------------------
-- Records of fa_prize
-- ----------------------------
BEGIN;
INSERT INTO `fa_prize` VALUES (1, '小米笔记本一台', 4999.00, 1, 2, '/uploads/20211214/1d6ef82fc20789599649cc8da10841ce.png');
INSERT INTO `fa_prize` VALUES (2, '小米手机', 1999.00, 2, 50, '');
INSERT INTO `fa_prize` VALUES (3, '电高压锅', 499.00, 50, 951, '');
COMMIT;

-- ----------------------------
-- Table structure for fa_ranking
-- ----------------------------
DROP TABLE IF EXISTS `fa_ranking`;
CREATE TABLE `fa_ranking` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL COMMENT '用户ID',
  `time` int(10) DEFAULT NULL COMMENT '合成时间',
  `weigh` int(10) DEFAULT NULL COMMENT '排名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='合成排名';

-- ----------------------------
-- Records of fa_ranking
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fa_scan_log
-- ----------------------------
DROP TABLE IF EXISTS `fa_scan_log`;
CREATE TABLE `fa_scan_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned DEFAULT NULL,
  `time` int(10) DEFAULT NULL COMMENT '扫码时间',
  `image` varchar(255) DEFAULT NULL COMMENT '图片',
  `content` varchar(255) DEFAULT NULL COMMENT '识别的内容',
  `date` varchar(20) DEFAULT NULL COMMENT '日期',
  `status` enum('1','2','3','4','5') DEFAULT '1' COMMENT '状态:1=待识别,2=识别失败,3=未有福字,4=有福',
  `card_id` int(10) DEFAULT NULL COMMENT '福卡id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=504 DEFAULT CHARSET=utf8mb4 COMMENT='扫码记录';

-- ----------------------------
-- Records of fa_scan_log
-- ----------------------------
BEGIN;
INSERT INTO `fa_scan_log` VALUES (473, 1, 1639617257, NULL, '福', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (474, 1, 1639617319, NULL, '', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (475, 1, 1639617778, NULL, '福', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (476, 1, 1639617784, NULL, '福', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (477, 1, 1639617880, NULL, '福', '2021-12-16', '4', 3);
INSERT INTO `fa_scan_log` VALUES (478, 4, 1639617889, NULL, '四方精创', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (479, 4, 1639618033, NULL, 'y', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (480, 4, 1639618059, NULL, '母', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (481, 4, 1639618101, NULL, '福', '2021-12-16', '4', 3);
INSERT INTO `fa_scan_log` VALUES (482, 4, 1639618131, NULL, 'Mt', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (483, 4, 1639618175, NULL, '1心母', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (484, 4, 1639618210, NULL, '福', '2021-12-16', '4', NULL);
INSERT INTO `fa_scan_log` VALUES (485, 4, 1639618226, NULL, '福', '2021-12-16', '4', 3);
INSERT INTO `fa_scan_log` VALUES (486, 4, 1639618548, NULL, '福', '2021-12-16', '4', NULL);
INSERT INTO `fa_scan_log` VALUES (487, 4, 1639618574, NULL, '公8', '2021-12-16', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (488, 4, 1639618588, NULL, '福', '2021-12-16', '4', 3);
INSERT INTO `fa_scan_log` VALUES (489, 4, 1639618835, NULL, '福', '2021-12-16', '4', NULL);
INSERT INTO `fa_scan_log` VALUES (490, 4, 1639618851, NULL, '福', '2021-12-16', '4', 2);
INSERT INTO `fa_scan_log` VALUES (491, 4, 1639618869, NULL, '福', '2021-12-16', '4', 5);
INSERT INTO `fa_scan_log` VALUES (492, 4, 1639618885, NULL, '福', '2021-12-16', '4', NULL);
INSERT INTO `fa_scan_log` VALUES (493, 4, 1639618895, NULL, '福', '2021-12-16', '4', NULL);
INSERT INTO `fa_scan_log` VALUES (494, 4, 1639618904, NULL, '福', '2021-12-16', '4', 3);
INSERT INTO `fa_scan_log` VALUES (495, 4, 1640153959, NULL, '片搜x', '2021-12-22', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (496, 4, 1640153974, NULL, '公TX1', '2021-12-22', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (497, 4, 1640154033, NULL, '片搜X', '2021-12-22', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (498, 4, 1640154067, NULL, 'bn', '2021-12-22', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (499, 4, 1640154084, NULL, '瘦5X', '2021-12-22', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (500, 4, 1640154118, NULL, '不', '2021-12-22', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (501, 4, 1640154137, NULL, '', '2021-12-22', '3', NULL);
INSERT INTO `fa_scan_log` VALUES (502, 4, 1640154160, NULL, '福', '2021-12-22', '4', NULL);
INSERT INTO `fa_scan_log` VALUES (503, 4, 1640154177, NULL, '福', '2021-12-22', '4', NULL);
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '事件',
  `mobile` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号',
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证码',
  `times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
  `ip` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'IP',
  `createtime` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短信验证码表';

-- ----------------------------
-- Records of fa_sms
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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',
  `admin_id` int(10) NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID(单选)',
  `category_ids` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类ID(多选)',
  `week` enum('monday','tuesday','wednesday') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '星期(单选):monday=星期一,tuesday=星期二,wednesday=星期三',
  `flag` set('hot','index','recommend') COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '标志(多选):hot=热门,index=首页,recommend=推荐',
  `genderdata` enum('male','female') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'male' COMMENT '性别(单选):male=男,female=女',
  `hobbydata` set('music','reading','swimming') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '爱好(多选):music=音乐,reading=读书,swimming=游泳',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '标题',
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
  `image` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片',
  `images` varchar(1500) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '图片组',
  `attachfile` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '附件',
  `keywords` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '关键字',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '描述',
  `city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '省市',
  `json` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '配置:key=名称,value=值',
  `price` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格',
  `views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击',
  `startdate` date DEFAULT NULL COMMENT '开始日期',
  `activitytime` datetime DEFAULT NULL COMMENT '活动时间(datetime)',
  `year` year(4) DEFAULT NULL COMMENT '年',
  `times` time DEFAULT NULL COMMENT '时间',
  `refreshtime` int(10) DEFAULT NULL COMMENT '刷新时间(int)',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `deletetime` int(10) DEFAULT NULL COMMENT '删除时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `switch` tinyint(1) NOT NULL DEFAULT '0' COMMENT '开关',
  `status` enum('normal','hidden') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
  `state` enum('0','1','2') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '状态值:0=禁用,1=正常,2=推荐',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='TpMeCMS表';

-- ----------------------------
-- Records of fa_test
-- ----------------------------
BEGIN;
INSERT INTO `fa_test` VALUES (1, 0, 12, '12,13', 'monday', 'hot,index', 'male', 'music,reading', '我是一篇TpMeCMS文章', '<p>我是TpMeCMS内容</p>', '/assets/img/avatar.png', '/assets/img/avatar.png,/assets/img/qrcode.png', '/assets/img/avatar.png', '关键字', '描述', '广西壮族自治区/百色市/平果县', '{\"a\":\"1\",\"b\":\"2\"}', 0.00, 0, '2017-07-10', '2017-07-10 18:24:45', 2017, '18:24:45', 1491635035, 1491635035, 1491635035, NULL, 0, 1, 'normal', '1');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '昵称',
  `password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码',
  `salt` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '密码盐',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '电子邮箱',
  `mobile` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号',
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像',
  `level` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '等级',
  `gender` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `bio` varchar(100) COLLATE utf8mb4_unicode_ci 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` int(10) DEFAULT NULL COMMENT '上次登录时间',
  `logintime` int(10) DEFAULT NULL COMMENT '登录时间',
  `loginip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '登录IP',
  `loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `joinip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '加入IP',
  `jointime` int(10) DEFAULT NULL COMMENT '加入时间',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `token` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'Token',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
  `verification` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证',
  `wx_openid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信openid',
  `openid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '小程序openid',
  `unionid` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开放平台',
  `sex` enum('0','1','2') COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '性别:1=男,2=女,0=未知',
  `city` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '城市',
  `job_number` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '工号',
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `email` (`email`),
  KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员表';

-- ----------------------------
-- Records of fa_user
-- ----------------------------
BEGIN;
INSERT INTO `fa_user` VALUES (1, 1, 'admin', NULL, '0572b025eed660dbaca171aba0ec7eb3', '31yOIq', 'admin@163.com', '13888888888', NULL, 0, 0, '2017-04-08', '', 0.00, 0, 1, 1, 1639471422, 1639471468, '114.224.133.136', 0, '127.0.0.1', 1491635035, 0, 1639471468, '', 'normal', '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `fa_user` VALUES (4, 0, 'test', 'test', '2c751a2b9c2306e1a10a28faf24a53f5', 'KY6EGI', 'test@pct.cn', '16394707648', '', 1, 0, NULL, '', 0.00, 0, 2, 3, 1640143962, 1640153929, '112.96.165.9', 0, '114.224.133.136', 1639470764, 1639470764, 1640153929, '', 'normal', '', NULL, NULL, NULL, '0', NULL, 'test');
INSERT INTO `fa_user` VALUES (5, 0, '1000000', '1000000', '7152f3800e967abb3705fc531df62dfc', '9EOZ2F', '1000000@pct.cn', '16394712883', '', 1, 0, NULL, '', 0.00, 0, 2, 2, 1639471288, 1639535692, '114.224.133.136', 0, '114.224.133.136', 1639471288, 1639471288, 1639535692, '', 'normal', '', NULL, NULL, NULL, '0', NULL, '1000000');
INSERT INTO `fa_user` VALUES (6, 0, 'FH8888', 'Xiaohe', '6f008ac86f42ef29d011f0aa51dfc88b', 'obh1MV', 'FH30088@test.com', '18000000001', '', 1, 0, NULL, '', 0.00, 0, 1, 1, 1639533806, 1639533806, '114.224.133.136', 0, '114.224.133.136', 1639533582, 1639533582, 1639533806, '', 'normal', '', NULL, NULL, NULL, '0', NULL, 'FH30088');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '组名',
  `rules` text COLLATE utf8mb4_unicode_ci COMMENT '权限节点',
  `createtime` int(10) DEFAULT NULL COMMENT '添加时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `status` enum('normal','hidden') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员组表';

-- ----------------------------
-- Records of fa_user_group
-- ----------------------------
BEGIN;
INSERT INTO `fa_user_group` VALUES (1, '默认组', '1,2,3,4,5,6,7,8,9,10,11,12', 1491635035, 1491635035, 'normal');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员余额变动表';

-- ----------------------------
-- Records of fa_user_money_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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) DEFAULT NULL COMMENT '父ID',
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '标题',
  `remark` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `ismenu` tinyint(1) DEFAULT NULL COMMENT '是否菜单',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) DEFAULT '0' COMMENT '权重',
  `status` enum('normal','hidden') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员规则表';

-- ----------------------------
-- Records of fa_user_rule
-- ----------------------------
BEGIN;
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');
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员积分变动表';

-- ----------------------------
-- Records of fa_user_score_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fa_user_token
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_token`;
CREATE TABLE `fa_user_token` (
  `token` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Token',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `expiretime` int(10) DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员Token表';

-- ----------------------------
-- Records of fa_user_token
-- ----------------------------
BEGIN;
INSERT INTO `fa_user_token` VALUES ('056645948f656c265f43532419f041c670ab0d95', 1, 1639467639, 1642059639);
COMMIT;

-- ----------------------------
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '旧版本号',
  `newversion` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '新版本号',
  `packagesize` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '包大小',
  `content` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '升级内容',
  `downloadurl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '下载地址',
  `enforce` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '强制更新',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='版本表';

-- ----------------------------
-- Records of fa_version
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fa_wechat_user
-- ----------------------------
DROP TABLE IF EXISTS `fa_wechat_user`;
CREATE TABLE `fa_wechat_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `openid` varchar(50) DEFAULT NULL,
  `type_status` enum('1','2') DEFAULT '1' COMMENT '类型:1=微信公众号,2=微信小程序',
  `user_id` int(10) DEFAULT NULL COMMENT '用户id',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `subscribe_time` int(10) DEFAULT NULL COMMENT '订阅时间',
  `unsubscribe_time` int(10) DEFAULT NULL COMMENT '取消订阅时间',
  `status` enum('1','2','3') DEFAULT '1' COMMENT '当前状态:1=未关注,2:已关注,3=已取消',
  `nickname` varchar(255) DEFAULT NULL COMMENT '微信昵称',
  `headimage` varchar(255) DEFAULT NULL COMMENT '微信头像',
  `unionid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of fa_wechat_user
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;