基于PHP的DF平台分站系统源码.zip

-- SQL Dump by Erik Edgren -- version 1.0 -- -- SQL Dump created: November 25th, 2020 @ 7:34 pm SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -------------------------------------------------------- -- -- Remove the table if it exists -- DROP TABLE IF EXISTS `fa_admin`; -- -- Create the table if it not exists -- CREATE TABLE IF NOT EXISTS `fa_admin` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名', `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称', `password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码', `salt` varchar(30) NOT NULL DEFAULT '' COMMENT '密码盐', `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像', `email` varchar(100) NOT NULL DEFAULT '' COMMENT '电子邮箱', `loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数', `logintime` int(10) DEFAULT NULL COMMENT '登录时间', `loginip` varchar(50) DEFAULT NULL COMMENT '登录IP', `createtime` int(10) DEFAULT NULL COMMENT '创建时间', `updatetime` int(10) DEFAULT NULL COMMENT '更新时间', `token` varchar(59) NOT NULL DEFAULT '' COMMENT 'Session标识', `status` varchar(30) NOT NULL DEFAULT 'normal' COMMENT '状态', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员表'; -- -- List the data for the table -- INSERT INTO `fa_admin` (`id`, `username`, `nickname`, `password`, `salt`, `avatar`, `email`, `loginfailure`, `logintime`, `loginip`, `createtime`, `updatetime`, `token`, `status`) VALUES ('1', 'admin', 'Admin', 'b4237d667725447dc1a4d9da902b5434', 'ed5c14', '/assets/img/avatar.png', 'admin@admin.com', '0', '1606303000', '113.101.34.109', '1492186163', '1606303000', '82118151-c98e-4d24-8e54-cf01baf3f354', 'normal'); -- -- Remove the table if it exists -- DROP TABLE IF EXISTS `fa_admin_log`; -- -- Create the table if it not exists -- CREATE TABLE IF NOT EXISTS `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) NOT NULL DEFAULT '' COMMENT '管理员名字', `url` varchar(1500) NOT NULL DEFAULT '' COMMENT '操作页面', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '日志标题', `content` text NOT NULL COMMENT '内容', `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP', `useragent` varchar(255) NOT NULL DEFAULT '' COMMENT 'User-Agent', `createtime` int(10) DEFAULT NULL COMMENT '操作时间', PRIMARY KEY (`id`), KEY `name` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=296 DEFAULT CHARSET=utf8 COMMENT='管理员日志表'; -- -- List the data for the table -- INSERT INTO `fa_admin_log` (`id`, `admin_id`, `username`, `url`, `title`, `content`, `ip`, `useragent`, `createtime`) VALUES ('1', '0', 'Unknown', '/admin/index/login?url=%2Fadmin', '登录', '{\"url\":\"\\/admin\",\"__token__\":\"8ff9dd269518c011687a8a8b4af672b5\",\"username\":\"admin\",\"captcha\":\"6753\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594798995'), ('2', '0', 'Unknown', '/admin/index/login?url=%2Fadmin', '登录', '{\"url\":\"\\/admin\",\"__token__\":\"760d3d920222a5d48f6d3781c799cc73\",\"username\":\"admin\",\"captcha\":\"3266\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594799003'), ('3', '1', 'admin', '/admin/myjsetting/edit/ids/39?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"MCB_PAY_URL\",\"value\":\"\",\"type\":\"text\",\"remarks\":\"\\u79d2\\u5145\\u5b9d\\u4ed8\\u6b3e\\u94fe\\u63a5\"},\"ids\":\"39\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594799230'), ('4', '1', 'admin', '/admin/myjsetting/edit/ids/40?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"MCB_CALLBACK_URL\",\"value\":\"\",\"type\":\"text\",\"remarks\":\"\\u79d2\\u5145\\u5b9d\\u4ed8\\u6b3e\\u56de\\u8c03\\u94fe\\u63a5\"},\"ids\":\"40\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594799235'), ('5', '1', 'admin', '/admin/myjsetting/edit/ids/38?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"MCB_APPID\",\"value\":\"\",\"type\":\"text\",\"remarks\":\"\\u79d2\\u5145\\u5b9dAPPID\"},\"ids\":\"38\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594799239'), ('6', '1', 'admin', '/admin/myjsetting/edit/ids/14?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"cfg_qq\",\"value\":\"1791271742\",\"type\":\"text\",\"remarks\":\"\\u5ba2\\u670dQQ\"},\"ids\":\"14\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594799255'), ('7', '1', 'admin', '/admin/myjsetting/edit/ids/14?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"cfg_qq\",\"value\":\"\",\"type\":\"text\",\"remarks\":\"\\u5ba2\\u670dQQ\"},\"ids\":\"14\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594799258'), ('8', '0', 'Unknown', '/admin/index/login?url=%2Fadmin', '登录', '{\"url\":\"\\/admin\",\"__token__\":\"136f7171c585142fd4f014a50cf82473\",\"username\":\"admin\",\"captcha\":\"6211\",\"keeplogin\":\"1\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', '1594799344'), ('9', '1', 'admin', '/admin/myjsetting/edit/ids/23?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"cfg_app_key\",\"value\":\"aa000000\",\"type\":\"text\",\"remarks\":\"\\u7262\\u7262\\u8bb0\\u5bc6\\u7801\"},\"ids\":\"23\"}', '120.37.220.176', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', '1594800194'), ('10', '1', 'admin', '/admin/myjsetting/edit/ids/22?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"cfg_app_id\",\"value\":\"13539413219\",\"type\":\"text\",\"remarks\":\"\\u7262\\u7262\\u8bb0\\u8d26\\u53f7\"},\"ids\":\"22\"}', '120.37.220.176', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', '1594800201'), ('11', '1', 'admin', '/admin/dashboard/update', '控制台', '[]', '120.37.220.176', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', '1594800208'), ('12', '1', 'admin', '/admin/index/login', '登录', '{\"__token__\":\"ec5028cd434f295e8ced91897bea1e27\",\"username\":\"admin\",\"captcha\":\"1543\"}', '120.37.220.176', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', '1594800241'), ('13', '1', 'admin', '/admin/myjsetting/edit/ids/1?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"cfg_basehost\",\"value\":\"lipin.773w.com\",\"type\":\"text\",\"remarks\":\"\\u7f51\\u7ad9\\u7f51\\u5740\"},\"ids\":\"1\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594800365'), ('14', '1', 'admin', '/admin/myjsetting/edit/ids/22?dialog=1', '参数设置 编辑', '{\"dialog\":\"1\",\"row\":{\"name\":\"cfg_app_id\",\"value\":\"\",\"type\":\"text\",\"remarks\":\"\\u7262\\u7262\\u8bb0\\u8d26\\u53f7\"},\"ids\":\"22\"}', '120.229.114.69', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36', '1594800441'), ('15', '1', 'admin