读吧书网3.5数据表结构初稿
CREATE TABLE IF NOT EXISTS `rd8_read8_advertise` (`pos` varchar(255) NOT NULL default '',
`ad` mediumtext NOT NULL,
PRIMARY KEY (`pos`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告投放';
CREATE TABLE IF NOT EXISTS `rd8_read8_announce` (
`id` smallint(5) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`dateline` int(10) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `dateline` (`dateline`),
KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='网站公告表结构';
CREATE TABLE IF NOT EXISTS `rd8_read8_api` (
`id` int(10) unsigned NOT NULL auto_increment,
`address` varchar(255) NOT NULL default '',
`code` varchar(255) NOT NULL default '',
`charset` enum('GBK','UTF-8','BIG5') NOT NULL default 'UTF-8',
`gate` enum('Discuz!','PHPWind') NOT NULL default 'PHPWind',
`active` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `address` (`address`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='通行证';
CREATE TABLE IF NOT EXISTS `rd8_read8_author` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`pseudonym` varchar(255) NOT NULL default '',
`pinyin` varchar(255) NOT NULL default '',
`uid` mediumint(8) unsigned NOT NULL default '0',
`avatar` varchar(255) NOT NULL default '',
`column_name` varchar(255) NOT NULL default '',
`intro` text NOT NULL,
`announcement` text NOT NULL,
`sample` text NOT NULL,
`vip` tinyint(1) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `pseudonym` (`pseudonym`),
UNIQUE KEY `pinyin` (`pinyin`),
UNIQUE KEY `uid` (`uid`),
KEY `dateline` (`dateline`),
KEY `active` (`active`),
KEY `vip` (`vip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='作家';
CREATE TABLE IF NOT EXISTS `rd8_read8_author_commend` (
`author_id` mediumint(8) unsigned NOT NULL default '0',
`book_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`author_id`,`book_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='作家推荐栏';
CREATE TABLE IF NOT EXISTS `rd8_read8_author_interview` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`author_id` mediumint(8) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`content` longtext NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `author_id` (`author_id`),
KEY `title` (`title`),
KEY `dateline` (`dateline`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='作家访谈';
CREATE TABLE IF NOT EXISTS `rd8_read8_author_link` (
`author_id` mediumint(8) unsigned NOT NULL default '0',
`lid` tinyint(1) unsigned NOT NULL auto_increment,
`link_author` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`author_id`,`lid`),
KEY `link_author` (`link_author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='作家友链';
CREATE TABLE IF NOT EXISTS `rd8_read8_banlist` (
`id` mediumint(8) NOT NULL auto_increment,
`kind` varchar(255) NOT NULL default '',
`word` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `kind` (`kind`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='封禁列表';
CREATE TABLE IF NOT EXISTS `rd8_read8_cache` (
`id` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL default '',
`sql` mediumtext NOT NULL,
`twod` tinyint(1) unsigned NOT NULL default '0',
`group` varchar(255) NOT NULL default '',
`with` varchar(255) NOT NULL default '',
`active` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='自定义缓存';
CREATE TABLE IF NOT EXISTS `rd8_read8_class_novel` (
`category` varchar(255) NOT NULL default '',
`id` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`priority` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) NOT NULL default '1',
`deltime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`category`,`id`),
KEY `title` (`title`),
KEY `priority` (`priority`),
KEY `dateline` (`dateline`),
KEY `active` (`active`),
KEY `deltime` (`deltime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='长篇分类';
CREATE TABLE IF NOT EXISTS `rd8_read8_class_story` (
`category` varchar(255) NOT NULL default '',
`id` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`priority` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) NOT NULL default '1',
`deltime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`category`,`id`),
KEY `title` (`title`),
KEY `priority` (`priority`),
KEY `dateline` (`dateline`),
KEY `active` (`active`),
KEY `deltime` (`deltime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='短篇分类';
CREATE TABLE IF NOT EXISTS `rd8_read8_class_system` (
`category` varchar(255) NOT NULL default '',
`id` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`category`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='系统分类';
CREATE TABLE IF NOT EXISTS `rd8_read8_collect_rule_multi` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`parent` varchar(255) NOT NULL default '',
`page_list` varchar(255) NOT NULL default '',
`page_start` int(10) unsigned NOT NULL default '0',
`page_end` int(10) unsigned NOT NULL default '0',
`bid_start` varchar(255) NOT NULL default '',
`bid_end` varchar(255) NOT NULL default '',
`bid_regexp` varchar(255) NOT NULL default '',
`lastupdate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `parent` (`parent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='批量采集规则';
CREATE TABLE IF NOT EXISTS `rd8_read8_collect_rule_single` (
`id` int(10) unsigned NOT NULL auto_increment,
`mark` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`page_info` varchar(255) NOT NULL default '',
`general_regexp_1` varchar(255) NOT NULL default '',
`title_start` varchar(255) NOT NULL default '',
`title_end` varchar(255) NOT NULL default '',
`title_regexp` varchar(255) NOT NULL default '',
`author_start` varchar(255) NOT NULL default '',
`author_end` varchar(255) NOT NULL default '',
`author_regexp` varchar(255) NOT NULL default '',
`subject_start` varchar(255) NOT NULL default '',
`subject_end` varchar(255) NOT NULL default '',
`subject_regexp` varchar(255) NOT NULL default '',
`subject_pos` mediumtext NOT NULL,
`content_start` varchar(255) NOT NULL default '',
`content_end` varchar(255) NOT NULL default '',
`content_regexp` varchar(255) NOT NULL default '',
`content_pos` mediumtext NOT NULL,
`intro_start` varchar(255) NOT NULL default '',
`intro_end` varchar(255) NOT NULL default '',
`intro_regexp` varchar(255) NOT NULL default '',
`cover_start` varchar(255) NOT NULL default '',
`cover_end` varchar(255) NOT NULL default '',
`cover_prefix` varchar(255) NOT NULL default '',
`cover_regexp` varchar(255) NOT NULL default '',
`page_list` varchar(255) NOT NULL default '',
`general_regexp_2` varchar(255) NOT NULL default '',
`volume_start` varchar(255) NOT NULL default '',
`volume_end` varchar(255) NOT NULL default '',
`volume_regexp` varchar(255) NOT NULL default '',
`chapter_link_start` varchar(255) NOT NULL default '',
`chapter_link_end` varchar(255) NOT NULL default '',
`chapter_title_start` varchar(255) NOT NULL default '',
`chapter_title_end` varchar(255) NOT NULL default '',
`chapter_regexp` varchar(255) NOT NULL default '',
`chapter_title_pos` tinyint(1) unsigned NOT NULL default '2',
`page_read` varchar(255) NOT NULL default '',
`general_regexp_3` varchar(255) NOT NULL default '',
`page_final` varchar(255) NOT NULL default '',
`text_start` varchar(255) NOT NULL default '',
`text_end` varchar(255) NOT NULL default '',
`text_regexp` varchar(255) NOT NULL default '',
`replacements` mediumtext NOT NULL,
`image` tinyint(1) unsigned NOT NULL default '0',
`image_prefix` varchar(255) NOT NULL default '',
`compression` tinyint(1) unsigned NOT NULL default '0',
`charsets` tinyint(1) unsigned NOT NULL default '0',
`lastupdate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `mark` (`mark`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='站点采集规则';
CREATE TABLE IF NOT EXISTS `rd8_read8_favorite` (
`uid` mediumint(8) unsigned NOT NULL default '0',
`fid` mediumint(8) unsigned NOT NULL auto_increment,
`gid` tinyint(1) unsigned NOT NULL default '0',
`bid` int(10) unsigned NOT NULL default '0',
`cid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`,`fid`),
KEY `gid` (`gid`),
KEY `bid` (`bid`),
KEY `cid` (`cid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收藏';
CREATE TABLE IF NOT EXISTS `rd8_read8_favorite_category` (
`uid` mediumint(8) unsigned NOT NULL default '0',
`gid` tinyint(1) unsigned NOT NULL auto_increment,
`category` char(19) NOT NULL default '',
PRIMARY KEY (`uid`,`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收藏分类';
CREATE TABLE IF NOT EXISTS `rd8_read8_focus` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `dateline` (`dateline`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='首页焦点图';
CREATE TABLE IF NOT EXISTS `rd8_read8_help` (
`id` int(10) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`reply` text NOT NULL,
`replytime` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `title` (`title`),
KEY `dateline` (`dateline`),
KEY `replytime` (`replytime`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='求助投诉';
CREATE TABLE IF NOT EXISTS `rd8_read8_justnow` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` char(255) NOT NULL default '',
`book_id` int(10) unsigned NOT NULL default '0',
`book_title` char(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`module` char(10) NOT NULL default '',
`action` char(10) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `book_id` (`book_id`),
KEY `dateline` (`dateline`),
KEY `module` (`module`),
KEY `action` (`action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='就在刚才';
CREATE TABLE IF NOT EXISTS `rd8_read8_links` (
`id` tinyint(255) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`logo` varchar(255) NOT NULL default '',
`apply` tinyint(1) unsigned NOT NULL default '0',
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`ps` text NOT NULL,
`priority` tinyint(255) unsigned NOT NULL default '255',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='书网友情链接';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`pinyin` varchar(255) NOT NULL default '',
`initial` char(2) NOT NULL default '',
`author` varchar(255) NOT NULL default '',
`author_id` mediumint(8) unsigned NOT NULL default '0',
`typewriter` varchar(255) NOT NULL default '',
`typewriter_id` mediumint(8) unsigned NOT NULL default '0',
`subject` tinyint(1) unsigned NOT NULL default '0',
`content` tinyint(1) unsigned NOT NULL default '0',
`style` tinyint(1) unsigned NOT NULL default '0',
`role_lead` varchar(255) NOT NULL default '',
`role_support` varchar(255) NOT NULL default '',
`license` tinyint(1) unsigned NOT NULL default '3',
`description` varchar(255) NOT NULL default '',
`tag` varchar(255) NOT NULL default '',
`path` varchar(255) NOT NULL default '',
`intro` text NOT NULL,
`state` tinyint(1) unsigned NOT NULL default '1',
`vip` tinyint(1) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`lastupdate` int(10) unsigned NOT NULL default '0',
`lastchapter` smallint(5) unsigned NOT NULL default '0',
`words` mediumint(8) unsigned NOT NULL default '0',
`hash` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `pinyin` (`pinyin`),
KEY `initial` (`initial`),
KEY `author` (`author`),
KEY `author_id` (`author_id`),
KEY `subject` (`subject`),
KEY `content` (`content`),
KEY `style` (`style`),
KEY `role_lead` (`role_lead`),
KEY `role_support` (`role_support`),
KEY `license` (`license`),
KEY `description` (`description`),
KEY `tag` (`tag`),
KEY `state` (`state`),
KEY `dateline` (`dateline`),
KEY `lastupdate` (`lastupdate`),
KEY `lastchapter` (`lastchapter`),
KEY `words` (`words`),
KEY `hash` (`hash`),
KEY `typewriter_id` (`typewriter_id`),
KEY `path` (`path`),
KEY `title` (`title`),
KEY `vip` (`vip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_apply` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`author` varchar(255) NOT NULL default '',
`author_id` mediumint(8) unsigned NOT NULL default '0',
`subject` tinyint(1) unsigned NOT NULL default '0',
`content` tinyint(1) unsigned NOT NULL default '0',
`style` tinyint(1) unsigned NOT NULL default '0',
`role_lead` varchar(255) NOT NULL default '',
`role_support` varchar(255) NOT NULL default '',
`license` tinyint(1) unsigned NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`tag` varchar(255) NOT NULL default '',
`intro` text NOT NULL,
`sample` text NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`verifytime` int(10) unsigned NOT NULL default '0',
`book_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `author_id` (`author_id`),
KEY `subject` (`subject`),
KEY `content` (`content`),
KEY `style` (`style`),
KEY `role_lead` (`role_lead`),
KEY `role_support` (`role_support`),
KEY `license` (`license`),
KEY `description` (`description`),
KEY `tag` (`tag`),
KEY `dateline` (`dateline`),
KEY `verifytime` (`verifytime`),
KEY `book_id` (`book_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说申请';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_attach` (
`id` int(10) unsigned NOT NULL auto_increment,
`book_id` int(10) unsigned NOT NULL default '0',
`chapter_id` int(10) unsigned NOT NULL default '0',
`file` char(3) NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `book_id` (`book_id`,`chapter_id`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说附件';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_chapter` (
`book_id` int(10) unsigned NOT NULL default '0',
`id` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`priority` smallint(5) unsigned NOT NULL default '0',
`volume_id` tinyint(1) unsigned NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`locked` tinyint(1) unsigned NOT NULL default '0',
`vip` varchar(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`lastupdate` int(10) unsigned NOT NULL default '0',
`words` smallint(5) unsigned NOT NULL default '0',
`hash` varchar(255) NOT NULL default '',
PRIMARY KEY (`book_id`,`id`),
KEY `priority` (`priority`),
KEY `volume_id` (`volume_id`),
KEY `locked` (`locked`),
KEY `vip` (`vip`),
KEY `dateline` (`dateline`),
KEY `lastupdate` (`lastupdate`),
KEY `words` (`words`),
KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说章节';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_commend` (
`commend` tinyint(1) unsigned NOT NULL default '0',
`book_id` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`commend`,`book_id`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说推荐';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_comment` (
`book_id` int(10) unsigned NOT NULL default '0',
`id` mediumint(8) unsigned NOT NULL auto_increment,
`chapter_id` smallint(5) unsigned NOT NULL default '0',
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`ip` int(10) unsigned NOT NULL default '0',
`digest` tinyint(1) unsigned NOT NULL default '0',
`sticky` tinyint(1) unsigned NOT NULL default '0',
`highlight` varchar(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`book_id`,`id`),
KEY `chapter_id` (`chapter_id`),
KEY `uid` (`uid`),
KEY `title` (`title`),
KEY `ip` (`ip`),
KEY `digest` (`digest`),
KEY `sticky` (`sticky`),
KEY `highlight` (`highlight`),
KEY `dateline` (`dateline`),
KEY `active` (`active`),
FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说评论';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_draft` (
`id` int(10) unsigned NOT NULL auto_increment,
`book_id` int(10) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`insertbefore` smallint(5) unsigned NOT NULL default '0',
`volumetitle` varchar(255) NOT NULL default '',
`vip` tinyint(1) unsigned NOT NULL default '0',
`article` mediumtext NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`pubtime` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `book_id` (`book_id`),
KEY `dateline` (`dateline`),
KEY `pubtime` (`pubtime`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说定时发布';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_external` (
`book_id` int(10) unsigned NOT NULL default '0',
`click_today` int(10) unsigned NOT NULL default '0',
`click_week` int(10) unsigned NOT NULL default '0',
`click_month` int(10) unsigned NOT NULL default '0',
`click_total` int(10) unsigned NOT NULL default '0',
`vote_today` int(10) unsigned NOT NULL default '0',
`vote_week` int(10) unsigned NOT NULL default '0',
`vote_month` int(10) unsigned NOT NULL default '0',
`vote_total` int(10) unsigned NOT NULL default '0',
`rate_week` int(10) unsigned NOT NULL default '0',
`rate_month` int(10) unsigned NOT NULL default '0',
`rate_total` int(10) unsigned NOT NULL default '0',
`favo_today` int(10) unsigned NOT NULL default '0',
`favo_week` int(10) unsigned NOT NULL default '0',
`favo_month` int(10) unsigned NOT NULL default '0',
`favo_total` int(10) unsigned NOT NULL default '0',
`commend_today` int(10) unsigned NOT NULL default '0',
`commend_week` int(10) unsigned NOT NULL default '0',
`commend_month` int(10) unsigned NOT NULL default '0',
`commend_total` int(10) unsigned NOT NULL default '0',
`digg_today` int(10) unsigned NOT NULL default '0',
`digg_week` int(10) unsigned NOT NULL default '0',
`digg_month` int(10) unsigned NOT NULL default '0',
`digg_total` int(10) unsigned NOT NULL default '0',
`bury_today` int(10) unsigned NOT NULL default '0',
`bury_week` int(10) unsigned NOT NULL default '0',
`bury_month` int(10) unsigned NOT NULL default '0',
`bury_total` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`book_id`),
KEY `click_week` (`click_week`),
KEY `click_month` (`click_month`),
KEY `click_total` (`click_total`),
KEY `vote_week` (`vote_week`),
KEY `vote_month` (`vote_month`),
KEY `vote_total` (`vote_total`),
KEY `rate_week` (`rate_week`),
KEY `rate_month` (`rate_month`),
KEY `rate_total` (`rate_total`),
KEY `favo_week` (`favo_week`),
KEY `favo_month` (`favo_month`),
KEY `favo_total` (`favo_total`),
KEY `commend_week` (`commend_week`),
KEY `commend_month` (`commend_month`),
KEY `commend_total` (`commend_total`),
KEY `digg_week` (`digg_week`),
KEY `digg_month` (`digg_month`),
KEY `digg_total` (`digg_total`),
KEY `bury_week` (`bury_week`),
KEY `bury_month` (`bury_month`),
KEY `bury_total` (`bury_total`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说扩展数据';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_rate` (
`book_id` int(10) unsigned NOT NULL default '0',
`rate` tinyint(1) unsigned NOT NULL default '0',
KEY `book_id` (`book_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说评分记录';
CREATE TABLE IF NOT EXISTS `rd8_read8_novel_volume` (
`book_id` int(10) unsigned NOT NULL default '0',
`id` tinyint(1) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`chapter_priority` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`book_id`,`id`),
UNIQUE KEY `title` (`title`),
KEY `chapter_priority` (`chapter_priority`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='小说卷';
CREATE TABLE IF NOT EXISTS `rd8_read8_pay` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`price` mediumint(8) unsigned NOT NULL default '0',
`vmoney` mediumint(8) unsigned NOT NULL default '0',
`gate` char(3) NOT NULL default 'ALI',
`state` tinyint(1) unsigned NOT NULL default '0',
`suctime` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) NOT NULL default '1',
`deltime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `price` (`price`),
KEY `vmoney` (`vmoney`),
KEY `state` (`state`),
KEY `suctime` (`suctime`),
KEY `dateline` (`dateline`),
KEY `active` (`active`),
KEY `deltime` (`deltime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='充值记录';
CREATE TABLE IF NOT EXISTS `rd8_read8_pm` (
`id` int(10) unsigned NOT NULL auto_increment,
`from` varchar(255) NOT NULL default '',
`from_id` mediumint(8) unsigned NOT NULL default '0',
`to` varchar(255) NOT NULL default '',
`to_id` mediumint(8) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`content` mediumtext NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`isread` tinyint(1) unsigned NOT NULL default '0',
`isinbox` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `from` (`from`),
KEY `from_id` (`from_id`),
KEY `to` (`to`),
KEY `to_id` (`to_id`),
KEY `title` (`title`),
KEY `dateline` (`dateline`),
KEY `isread` (`isread`),
KEY `isinbox` (`isinbox`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='站内短信';
CREATE TABLE IF NOT EXISTS `rd8_read8_sessions` (
`sid` char(32) NOT NULL,
`ip` char(15) NOT NULL,
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` char(255) NOT NULL,
`expire` int(10) NOT NULL default '0',
`secode` char(255) NOT NULL default '',
UNIQUE KEY `sid` (`sid`),
KEY `uid` (`uid`),
KEY `expire` (`expire`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='在线列表';
CREATE TABLE IF NOT EXISTS `rd8_read8_sessions_acp` (
`id` mediumint(8) unsigned NOT NULL default '0',
`uid` mediumint(8) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`pswd` varchar(32) NOT NULL default '',
`privilege` text NOT NULL,
`loginip` varchar(20) NOT NULL default '',
`isfounder` smallint(1) unsigned NOT NULL default '0',
`expire` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `uid` (`uid`),
KEY `expire` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理员在线表';
CREATE TABLE IF NOT EXISTS `rd8_read8_shop` (
`id` int(10) unsigned NOT NULL auto_increment,
`book_id` int(10) unsigned NOT NULL default '0',
`chapter_id` int(10) unsigned NOT NULL default '0',
`user_id` int(10) unsigned NOT NULL default '0',
`price` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `book_id` (`book_id`),
KEY `chapter_id` (`chapter_id`),
KEY `user_id` (`user_id`),
KEY `price` (`price`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='VIP 购买记录';
CREATE TABLE IF NOT EXISTS `rd8_read8_story` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`author` varchar(255) NOT NULL default '',
`typewriter` mediumint(8) unsigned NOT NULL default '0',
`subject` tinyint(1) unsigned NOT NULL default '0',
`content` tinyint(1) unsigned NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`tag` varchar(255) NOT NULL default '',
`body` mediumtext NOT NULL,
`state` tinyint(1) unsigned NOT NULL default '1',
`dateline` int(10) unsigned NOT NULL default '0',
`lastupdate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `title` (`title`),
KEY `author` (`author`),
KEY `typewriter` (`typewriter`),
KEY `subject` (`subject`),
KEY `content` (`content`),
KEY `description` (`description`),
KEY `tag` (`tag`),
KEY `state` (`state`),
KEY `dateline` (`dateline`),
KEY `lastupdate` (`lastupdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='短篇文学';
CREATE TABLE IF NOT EXISTS `rd8_read8_story_commend` (
`commend` tinyint(1) unsigned NOT NULL default '0',
`book_id` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`commend`,`book_id`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='短篇文学推荐';
CREATE TABLE IF NOT EXISTS `rd8_read8_story_comment` (
`book_id` int(10) unsigned NOT NULL default '0',
`id` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`ip` int(10) unsigned NOT NULL default '0',
`digest` tinyint(1) unsigned NOT NULL default '0',
`sticky` tinyint(1) unsigned NOT NULL default '0',
`highlight` varchar(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`book_id`,`id`),
KEY `uid` (`uid`),
KEY `title` (`title`),
KEY `ip` (`ip`),
KEY `digest` (`digest`),
KEY `sticky` (`sticky`),
KEY `highlight` (`highlight`),
KEY `dateline` (`dateline`),
KEY `active` (`active`),
FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='短篇文学评论';
CREATE TABLE IF NOT EXISTS `rd8_read8_story_external` (
`book_id` int(10) unsigned NOT NULL default '0',
`click_today` int(10) unsigned NOT NULL default '0',
`click_week` int(10) unsigned NOT NULL default '0',
`click_month` int(10) unsigned NOT NULL default '0',
`click_total` int(10) unsigned NOT NULL default '0',
`vote_today` int(10) unsigned NOT NULL default '0',
`vote_week` int(10) unsigned NOT NULL default '0',
`vote_month` int(10) unsigned NOT NULL default '0',
`vote_total` int(10) unsigned NOT NULL default '0',
`rate_week` int(10) unsigned NOT NULL default '0',
`rate_month` int(10) unsigned NOT NULL default '0',
`rate_total` int(10) unsigned NOT NULL default '0',
`favo_today` int(10) unsigned NOT NULL default '0',
`favo_week` int(10) unsigned NOT NULL default '0',
`favo_month` int(10) unsigned NOT NULL default '0',
`favo_total` int(10) unsigned NOT NULL default '0',
`commend_today` int(10) unsigned NOT NULL default '0',
`commend_week` int(10) unsigned NOT NULL default '0',
`commend_month` int(10) unsigned NOT NULL default '0',
`commend_total` int(10) unsigned NOT NULL default '0',
`digg_today` int(10) unsigned NOT NULL default '0',
`digg_week` int(10) unsigned NOT NULL default '0',
`digg_month` int(10) unsigned NOT NULL default '0',
`digg_total` int(10) unsigned NOT NULL default '0',
`bury_today` int(10) unsigned NOT NULL default '0',
`bury_week` int(10) unsigned NOT NULL default '0',
`bury_month` int(10) unsigned NOT NULL default '0',
`bury_total` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`book_id`),
KEY `click_week` (`click_week`),
KEY `click_month` (`click_month`),
KEY `click_total` (`click_total`),
KEY `vote_week` (`vote_week`),
KEY `vote_month` (`vote_month`),
KEY `vote_total` (`vote_total`),
KEY `rate_week` (`rate_week`),
KEY `rate_month` (`rate_month`),
KEY `rate_total` (`rate_total`),
KEY `favo_week` (`favo_week`),
KEY `favo_month` (`favo_month`),
KEY `favo_total` (`favo_total`),
KEY `commend_week` (`commend_week`),
KEY `commend_month` (`commend_month`),
KEY `commend_total` (`commend_total`),
KEY `digg_week` (`digg_week`),
KEY `digg_month` (`digg_month`),
KEY `digg_total` (`digg_total`),
KEY `bury_week` (`bury_week`),
KEY `bury_month` (`bury_month`),
KEY `bury_total` (`bury_total`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='短篇文学扩展数据';
CREATE TABLE IF NOT EXISTS `rd8_read8_story_rate` (
`book_id` int(10) unsigned NOT NULL default '0',
`rate` tinyint(1) unsigned NOT NULL default '0',
KEY `book_id` (`book_id`),
KEY `rate` (`rate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='短篇文学评分';
CREATE TABLE IF NOT EXISTS `rd8_read8_system` (
`config` varchar(20) NOT NULL default '',
`index` varchar(50) NOT NULL default '',
`value` mediumtext NULL,
PRIMARY KEY (`config`,`index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='系统设置';
CREATE TABLE IF NOT EXISTS `rd8_read8_user` (
`uid` mediumint(8) NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`pwd` varchar(32) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`credit` int(10) NOT NULL default '0',
`vmoney` int(10) NOT NULL default '0',
`sms` int(10) NOT NULL default '0',
`dateline` int(10) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户';
CREATE TABLE IF NOT EXISTS `rd8_read8_user_acp` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`pswd` varchar(32) NOT NULL default '',
`privilege` mediumtext NOT NULL,
`lastlogin` int(10) unsigned NOT NULL default '0',
`lastloginip` varchar(20) NOT NULL default '',
`adduser` mediumint(8) unsigned NOT NULL default '0',
`accessip` text NOT NULL,
`error` smallint(1) unsigned NOT NULL default '0',
`isfounder` smallint(1) unsigned NOT NULL default '0',
`history` text NOT NULL,
`changepswdtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `uid` (`uid`),
KEY `pswd` (`pswd`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理员';
CREATE TABLE IF NOT EXISTS `rd8_read8_user_typewriter` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL default '0',
`novel_add` tinyint(1) unsigned NOT NULL default '0',
`novel_edit` tinyint(1) unsigned NOT NULL default '0',
`novel_del` tinyint(1) NOT NULL default '0',
`chapter_add` tinyint(1) unsigned NOT NULL default '0',
`chapter_edit` tinyint(1) unsigned NOT NULL default '0',
`chapter_del` tinyint(1) NOT NULL default '0',
`overstep` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='录入员'; :em21: :em21: :em21: 看不懂不过还是支持下 板凳啊 文本内容，不在数据库里么？
读吧书网小说系统互动群欢迎各位的加入
读吧书网小说系统互动群欢迎各位的加入主群号： 68460550
2群号： 70392224
欢迎各位站长进来讨论、交流、分享！~ 不懂啊，还是支持下啊
[url=http://blog.11di.cn/read.php/431.htm][img]http://blog.11di.cn/1.gif[/img][/url]
页:
[1]