Tools/application/data/tools.sql

-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- 主机： localhost
-- 生成日期： 2020-07-03 09:09:54
-- 服务器版本： 8.0.12
-- PHP 版本： 7.3.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 数据库： `tools`
--

-- --------------------------------------------------------

--
-- 表的结构 `bp_column`
--

CREATE TABLE `bp_column` (
  `id` int(10) NOT NULL COMMENT '导航栏id',
  `catename` char(50) NOT NULL COMMENT '导航栏名称'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='导航栏表';

--
-- 转存表中的数据 `bp_column`
--

INSERT INTO `bp_column` (`id`, `catename`) VALUES
(1, '有趣网站'),
(2, '实用工具'),
(3, '网页特效'),
(4, '微信应用'),
(5, 'API应用'),
(6, '网页游戏');

-- --------------------------------------------------------

--
-- 表的结构 `bp_good`
--

CREATE TABLE `bp_good` (
  `id` int(10) NOT NULL COMMENT '工具id',
  `keywords` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关键字',
  `title` char(100) NOT NULL COMMENT '标题',
  `likes` int(50) NOT NULL DEFAULT '1' COMMENT '点赞',
  `author` char(50) NOT NULL COMMENT '作者',
  `column_id` int(10) NOT NULL COMMENT '导航栏id',
  `tags_id` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标签id,多个标签用英文逗号分割',
  `url` char(100) NOT NULL COMMENT '地址',
  `sort` int(10) NOT NULL DEFAULT '50' COMMENT '排序',
  `create_time` int(10) NOT NULL COMMENT '创建时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='工具信息表';

--
-- 转存表中的数据 `bp_good`
--

INSERT INTO `bp_good` (`id`, `keywords`, `title`, `likes`, `author`, `column_id`, `tags_id`, `url`, `sort`, `create_time`) VALUES
(58, 'M', 'openmoji', 3, '极风游', 2, '1,2', 'openmoji/lst', 50, 1593761163),
(3, '汉', '汉字转换为拼音', 15, '爱奇君', 1, '1', 'activex/lst', 30, 1593423223),
(4, '计', '在线计算器', 3, '爱奇君', 2, '1,2', 'calputer/lst', 40, 1593423223),
(5, '颜', '颜色代码选取器', 2, '爱奇君', 2, '1', 'color/lst', 50, 1593423223),
(6, '文', '文本对比', 2, '爱奇君', 2, '2', 'contrast/lst', 60, 1593423223),
(7, '英', '英文字母大小写转换', 2, '爱奇君', 2, '2', 'dxzh/lst', 70, 1593423223),
(9, '简', '简体繁体火星文转换', 4, '爱奇君', 2, '2', 'font/lst', 90, 1593423223),
(10, 'J', 'json/postman互转', 1, '爱奇君', 2, '2', 'jsonpost/lst', 1, 1593423223),
(11, '金', '金额数字转大写汉字', 2, '爱奇君', 2, '3', 'number/lst', 11, 1593423223),
(12, 'P', 'pdf转png/jpg', 1, '爱奇君', 2, '3', 'pdf/lst', 12, 1593423223),
(13, '格', 'PPT转PDF', 2, '爱奇君', 2, '3', 'ppt/lst', 13, 1593423223),
(14, '重', '在线文本去重', 3, '爱奇君', 2, '3', 'qc/lst', 14, 1593423223),
(15, 'Q', 'QQ强制对话', 1, '爱奇君', 2, '3', 'qqtalk/lst', 15, 1593423223),
(16, 'D', 'pdf转doc', 1, '爱奇君', 2, '3', 'pdfdoc/lst', 16, 1593423223),
(57, '字', 'FontAwesome字库', 2, '极风游', 2, '1,2', 'awesome/lst', 50, 1593761121),
(18, 'O', 'ocr图片文字识别', 1, '爱奇君', 2, '4', 'ocr/lst', 18, 1593423223),
(59, '解', '应用安装包解析', 1, '极风游', 2, '1,2', 'requpack/lst', 50, 1593761194),
(22, 'I', 'ping测试', 3, '爱奇君', 2, '1', 'ping/lst', 23, 1593423223),
(23, 'A', 'Alexa排名', 2, '爱奇君', 2, '2', 'alexa/lst', 24, 1593423223),
(24, '车', '赛车加载', 3, '爱奇君', 3, '2', 'cycle/lst', 25, 1593423223),
(25, '火', '火焰光标', 4, '爱奇君', 3, '4', 'fire/lst', 24, 1593423223),
(26, '蓝', '蓝色粒子', 2, '爱奇君', 3, '4', 'blue/lst', 27, 1593423223),
(27, '三', '三维菱形隧道', 1, '爱奇君', 3, '4', 'sw/lst', 28, 1593423223),
(28, '雷', '坐标雷达', 2, '爱奇君', 3, '4', 'ld/lst', 29, 1593423223),
(29, '车', '赛车小游戏', 12, '爱奇君', 6, '4', 'scgame/lst', 31, 1593423223);

-- --------------------------------------------------------

--
-- 表的结构 `bp_tags`
--

CREATE TABLE `bp_tags` (
  `id` mediumint(9) NOT NULL COMMENT '标签id',
  `tagname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标签名称'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='标签表';

--
-- 转存表中的数据 `bp_tags`
--

INSERT INTO `bp_tags` (`id`, `tagname`) VALUES
(1, '热门'),
(2, '推荐'),
(3, 'PDF'),
(4, '开发');

-- --------------------------------------------------------

--
-- 表的结构 `bp_user`
--

CREATE TABLE `bp_user` (
  `id` int(20) UNSIGNED NOT NULL,
  `uname` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '账号',
  `upass` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码',
  `status` int(1) DEFAULT '0' COMMENT '0正常，1为禁止',
  `last_login_ip` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '最后登陆IP',
  `last_login_time` int(11) UNSIGNED DEFAULT '0' COMMENT '最后登陆时间',
  `uid` tinyint(5) DEFAULT NULL COMMENT '用户组对应的id'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='用户表' ROW_FORMAT=COMPACT;

--
-- 转存表中的数据 `bp_user`
--

INSERT INTO `bp_user` (`id`, `uname`, `upass`, `status`, `last_login_ip`, `last_login_time`, `uid`) VALUES
(1, 'admin', '202cb962ac59075b964b07152d234b70', 0, '0.0.0.0', 1593423223, 1),
(2, 'test', '202cb962ac59075b964b07152d234b70', 0, '0.0.0.0', 1593413285, 2),
(3, 'test1', '202cb962ac59075b964b07152d234b70', 0, '0.0.0.0', 1592977918, 7);

-- --------------------------------------------------------

--
-- 表的结构 `bp_user_log`
--

CREATE TABLE `bp_user_log` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '管理员id',
  `uname` varchar(32) NOT NULL DEFAULT '' COMMENT '管理员用户名',
  `useragent` varchar(255) NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `ip` varchar(16) NOT NULL DEFAULT '' COMMENT 'ip地址',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '请求链接',
  `method` varchar(32) NOT NULL DEFAULT '' COMMENT '请求类型',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT '资源类型',
  `param` text NOT NULL COMMENT '请求参数',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '日志备注',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员日志' ROW_FORMAT=COMPACT;

--
-- 转存表中的数据 `bp_user_log`
--

INSERT INTO `bp_user_log` (`id`, `user_id`, `uname`, `useragent`, `ip`, `url`, `method`, `type`, `param`, `remark`, `create_time`) VALUES
(1, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3732.400 QQBrowser/10.5.3819.400', '0.0.0.0', 'http://localhost:85/lst.html', 'POST', 'html', '{\"uname\":\"admin\",\"upass\":\"123\"}', '登录操作', 1593400704),
(2, 2, 'test', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3732.400 QQBrowser/10.5.3819.400', '0.0.0.0', 'http://localhost:85/lst.html', 'POST', 'html', '{\"uname\":\"test\",\"upass\":\"123\"}', '登录操作', 1593413285),
(3, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3732.400 QQBrowser/10.5.3819.400', '0.0.0.0', 'http://localhost:85/lst.html', 'POST', 'html', '{\"uname\":\"admin\",\"upass\":\"123\"}', '登录操作', 1593414076),
(4, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:77.0) Gecko/20100101 Firefox/77.0', '0.0.0.0', 'http://localhost:85/lst.html', 'POST', 'html', '{\"uname\":\"admin\",\"upass\":\"123\"}', '登录操作', 1593414115),
(5, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3732.400 QQBrowser/10.5.3819.400', '0.0.0.0', 'http://localhost:85/lst.html', 'POST', 'html', '{\"uname\":\"admin\",\"upass\":\"123\"}', '登录操作', 1593414200),
(6, 1, 'admin', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.25 Safari/537.36 Core/1.70.3732.400 QQBrowser/10.5.3819.400', '0.0.0.0', 'http://localhost:85/lst.html', 'POST', 'html', '{\"uname\":\"admin\",\"upass\":\"123\"}', '登录操作', 1593423223);

--
-- 转储表的索引
--

--
-- 表的索引 `bp_column`
--
ALTER TABLE `bp_column`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `bp_good`
--
ALTER TABLE `bp_good`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `bp_tags`
--
ALTER TABLE `bp_tags`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `bp_user`
--
ALTER TABLE `bp_user`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `bp_user_log`
--
ALTER TABLE `bp_user_log`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `bp_column`
--
ALTER TABLE `bp_column`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '导航栏id', AUTO_INCREMENT=12;

--
-- 使用表AUTO_INCREMENT `bp_good`
--
ALTER TABLE `bp_good`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '工具id', AUTO_INCREMENT=60;

--
-- 使用表AUTO_INCREMENT `bp_tags`
--
ALTER TABLE `bp_tags`
  MODIFY `id` mediumint(9) NOT NULL AUTO_INCREMENT COMMENT '标签id', AUTO_INCREMENT=7;

--
-- 使用表AUTO_INCREMENT `bp_user`
--
ALTER TABLE `bp_user`
  MODIFY `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- 使用表AUTO_INCREMENT `bp_user_log`
--
ALTER TABLE `bp_user_log`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;