SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for book_ad
-- ----------------------------
DROP TABLE IF EXISTS `book_ad`;
CREATE TABLE `book_ad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sort` int(5) DEFAULT '0',
`site_id` int(11) DEFAULT '0' COMMENT '站点id',
`title` varchar(255) DEFAULT '',
`status` tinyint(1) DEFAULT '1' COMMENT '1 已审核 0未审核',
`content` varchar(255) DEFAULT '',
`create_time` int(11) DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`),
KEY `site_id` (`site_id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for book_admin
-- ----------------------------
DROP TABLE IF EXISTS `book_admin`;
CREATE TABLE `book_admin` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`login_name` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
`real_name` varchar(32) NOT NULL DEFAULT '0' COMMENT '真实姓名',
`password` char(32) NOT NULL DEFAULT '' COMMENT '密码',
`role_id` int(5) NOT NULL DEFAULT '0' COMMENT '角色id字符串，如：2,3,4',
`phone` varchar(20) NOT NULL DEFAULT '0' COMMENT '手机号码',
`email` varchar(50) NOT NULL DEFAULT '' COMMENT '邮箱',
`salt` char(10) NOT NULL DEFAULT '' COMMENT '密码盐',
`last_login` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
`last_ip` char(15) NOT NULL DEFAULT '' COMMENT '最后登录IP',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态，1-正常 0禁用',
`remarks` varchar(255) NOT NULL DEFAULT '',
`create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_user_name` (`login_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='管理员表';
-- ----------------------------
-- Records of book_admin
-- ----------------------------
BEGIN;
INSERT INTO `book_admin` VALUES (1, 'admin', '超级管理员', 'ae059a68eddf6679dc7d4db22dbeb954', 0, '18812345678', '1225521@qq.com', 'JUKZ', 1550476509, '192.168.2.100', 1, '', 1538968554, 1539050745);
COMMIT;
-- ----------------------------
-- Table structure for book_article
-- ----------------------------
DROP TABLE IF EXISTS `book_article`;
CREATE TABLE `book_article` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章ID',
`sort` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`cid` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
`tags` varchar(255) NOT NULL DEFAULT '' COMMENT '标签',
`py_long` varchar(255) NOT NULL DEFAULT '' COMMENT '拼音全拼',
`py_short` varchar(50) NOT NULL DEFAULT '' COMMENT '拼音首字母',
`introduction` text NOT NULL COMMENT '简介',
`author` varchar(20) NOT NULL DEFAULT '' COMMENT '作者',
`full` tinyint(1) unsigned DEFAULT '0' COMMENT '0 连载中
本文地址：http://ww.kub2b.com/news/17575.html
企库往 http://ww.kub2b.com/ , 查看更多
