book.sql

read8v20读吧.net书网 v2.0,自己珍藏的原代码,今天上传部分来给大家一起交流哈!

# phpMyAdmin SQL Dump
# version 2.5.5-rc2
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2004 年 10 月 25 日 22:00
# 服务器版本: 4.1.1
# PHP 版本: 4.3.4
# 
# 数据库 : `book`
# 
#
# 表的结构 `actlog`
#

CREATE TABLE actlog (
  id int(10) NOT NULL auto_increment,
  userid int(10) NOT NULL default '0',
  act varchar(100) NOT NULL default '',
  acttime int(10) NOT NULL default '0',
  ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (id)
)  COMMENT='操作记录表结构';

# --------------------------------------------------------

#
# 表的结构 `announcement`
#

CREATE TABLE announcement (
  id smallint(5) NOT NULL auto_increment,
  content text NOT NULL,
  posttime int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
)  COMMENT='网站公告表结构';

# --------------------------------------------------------

#
# 表的结构 `applybook`
#

CREATE TABLE applybook (
  id int(10) NOT NULL auto_increment,
  userid int(10) NOT NULL default '0',
  applytime int(10) NOT NULL default '0',
  checktime int(10) NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  typeid smallint(2) NOT NULL default '0',
  attrib varchar(10) NOT NULL default '',
  author varchar(50) NOT NULL default '',
  actor varchar(100) NOT NULL default '',
  introduction text NOT NULL,
  price smallint(5) NOT NULL default '0',
  PRIMARY KEY  (id)
)  PACK_KEYS=0 COMMENT='新书申请列表结构';

# --------------------------------------------------------

#
# 表的结构 `applyvip`
#

CREATE TABLE applyvip (
  id int(10) NOT NULL auto_increment,
  userid int(10) NOT NULL default '0',
  applytime int(10) NOT NULL default '0',
  checktime int(10) NOT NULL default '0',
  money int(10) NOT NULL default '0',
  ps text NOT NULL,
  PRIMARY KEY  (id)
)  COMMENT='VIP续费列表结构';

# --------------------------------------------------------

#
# 表的结构 `applywriter`
#

CREATE TABLE applywriter (
  id smallint(5) NOT NULL auto_increment,
  userid int(10) NOT NULL default '0',
  applytime int(10) NOT NULL default '0',
  checktime int(10) NOT NULL default '0',
  ps text NOT NULL,
  product text NOT NULL,
  PRIMARY KEY  (id)
)  COMMENT='作家申请列表结构';

# --------------------------------------------------------

#
# 表的结构 `book`
#

CREATE TABLE book (
  id int(10) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  authorid int(10) NOT NULL default '0',
  author varchar(20) NOT NULL default '',
  typeid smallint(2) NOT NULL default '0',
  actor varchar(100) NOT NULL default '',
  introduction text NOT NULL,
  attrib varchar(10) NOT NULL default '',
  initial char(2) NOT NULL default '',
  price smallint(5) NOT NULL default '0',
  click int(10) NOT NULL default '0',
  lastweekclick int(10) NOT NULL default '0',
  vote int(10) NOT NULL default '0',
  posttime int(10) NOT NULL default '0',
  updatetime int(10) NOT NULL default '0',
  newchapterid int(10) NOT NULL default '0',
  size int(10) NOT NULL default '0',
  state varchar(10) NOT NULL default '连载中',
  recommend smallint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
)  PACK_KEYS=0 COMMENT='书籍列表结构';

# --------------------------------------------------------

#
# 表的结构 `bookreview`
#

CREATE TABLE bookreview (
  id int(10) NOT NULL auto_increment,
  bookid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  content text NOT NULL,
  posttime int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
)  COMMENT='书评表结构';

# --------------------------------------------------------

#
# 表的结构 `booktype`
#

CREATE TABLE booktype (
  id smallint(2) NOT NULL auto_increment,
  typename varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
)  COMMENT='书籍类型表结构';

# --------------------------------------------------------
#
# 导出表中的数据 `booktype`
#

INSERT INTO booktype VALUES (1, '玄幻魔法');
INSERT INTO booktype VALUES (2, '武侠仙侠');
INSERT INTO booktype VALUES (3, '历史军事');
INSERT INTO booktype VALUES (4, '都市言情');
INSERT INTO booktype VALUES (5, '网络游戏');
INSERT INTO booktype VALUES (6, '推理灵异');
INSERT INTO booktype VALUES (7, '散文诗词');
INSERT INTO booktype VALUES (8, '科幻动漫');

# --------------------------------------------------------

#
# 表的结构 `buylist`
#

CREATE TABLE buylist (
  id int(10) NOT NULL auto_increment,
  userid int(10) NOT NULL default '0',
  chapterid int(10) NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  cost smallint(5) NOT NULL default '0',
  buytime int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
)  COMMENT='购买列表结构';

# --------------------------------------------------------

#
# 表的结构 `chapter`
#

CREATE TABLE chapter (
  id int(10) NOT NULL auto_increment,
  title varchar(100) NOT NULL default '',
  bookid int(10) NOT NULL default '0',
  chapterid int(10) NOT NULL default '0',
  posttime int(10) NOT NULL default '0',
  updatetime int(10) NOT NULL default '0',
  newchapter int(10) NOT NULL default '1',
  words int(10) NOT NULL default '0',
  tmpurl varchar(32) NOT NULL default '',
  volumeid int(10) NOT NULL default '0',
  volumename varchar(100) NOT NULL default '',
  PRIMARY KEY  (id)
)  PACK_KEYS=0 COMMENT='章节表结构';

# --------------------------------------------------------

#
# 表的结构 `favorite`
#

CREATE TABLE favorite (
  id int(10) NOT NULL auto_increment,
  userid int(10) NOT NULL default '0',
  bookid int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY userid (userid),
  KEY bookid (bookid)
)  COMMENT='收藏夹表结构';

# --------------------------------------------------------

#
# 表的结构 `forums`
#

CREATE TABLE forums (
  forumid smallint(5) NOT NULL auto_increment,
  catid smallint(5) NOT NULL default '0',
  typeid smallint(2) NOT NULL default '0',
  orderid smallint(5) NOT NULL default '0',
  forumname varchar(20) NOT NULL default '',
  forumdesc varchar(255) NOT NULL default '',
  forumtopics int(10) NOT NULL default '0',
  forumposts int(10) NOT NULL default '0',
  lastpostid int(10) NOT NULL default '0',
  PRIMARY KEY  (forumid)
)  COMMENT='论坛版块列表结构';

#
# 导出表中的数据 `forums`
#

INSERT INTO forums VALUES (1, 6, 1, 0, '公共论坛', '公共论坛', 23, 41, 74);
INSERT INTO forums VALUES (2, 6, 2, 0, '会员论坛', '会员论坛', 8, 17, 75);
INSERT INTO forums VALUES (3, 7, 3, 2, 'VIP论坛', 'VIP论坛', 0, 0, 0);
INSERT INTO forums VALUES (4, 7, 4, 1, '作家论坛', '作家论坛', 0, 0, 0);
INSERT INTO forums VALUES (5, 8, 5, 0, '公告论坛', '公告论坛', 6, 7, 49);
INSERT INTO forums VALUES (6, 0, 0, 0, '一般讨论区', '一般讨论区', 0, 0, 0);
INSERT INTO forums VALUES (7, 0, 0, 0, '高级讨论区', '高级讨论区', 0, 0, 0);
INSERT INTO forums VALUES (8, 0, 0, 0, '特殊讨论区', '特殊讨论区', 0, 0, 0);

# --------------------------------------------------------

#
# 表的结构 `forumsadmin`
#

CREATE TABLE forumsadmin (
  id smallint(5) NOT NULL auto_increment,
  forumid smallint(5) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
)  COMMENT='版主列表结构';

# --------------------------------------------------------

#
# 表的结构 `msg`
#

CREATE TABLE msg (
  id int(10) NOT NULL auto_increment,
  fromuser int(10) NOT NULL default '0',
  touser int(10) NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  content text NOT NULL,
  type smallint(2) NOT NULL default '0',
  msgtime int(10) NOT NULL default '0',
  isread smallint(2) NOT NULL default '0',
  PRIMARY KEY  (id)
)  COMMENT='短消息列表结构';

# --------------------------------------------------------

#
# 表的结构 `posts`
#

CREATE TABLE posts (
  postid int(10) NOT NULL auto_increment,
  topicid int(10) NOT NULL default '0',
  forumid smallint(5) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  topicpost smallint(2) NOT NULL default '0',
  content text NOT NULL,
  posttime int(10) NOT NULL default '0',
  ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (postid)
)  COMMENT='论坛贴子列表结构';

# --------------------------------------------------------

#
# 表的结构 `sitelinks`
#

CREATE TABLE sitelinks (
  id smallint(5) NOT NULL auto_increment,
  sitename varchar(20) NOT NULL default '',
  siteurl varchar(100) NOT NULL default '',
  siteinfo varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
)  COMMENT='友情连接列表结构';

# --------------------------------------------------------

#
# 表的结构 `topics`
#

CREATE TABLE topics (
  topicid int(10) NOT NULL auto_increment,
  forumid smallint(5) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(20) NOT NULL default '',
  title varchar(100) NOT NULL default '',
  view int(10) NOT NULL default '0',
  reply int(10) NOT NULL default '0',
  topictype smallint(2) NOT NULL default '0',
  topicicon smallint(2) NOT NULL default '0',
  posttime int(10) NOT NULL default '0',
  lastposttime int(10) NOT NULL default '0',
  lastpostuser int(10) NOT NULL default '0',
  PRIMARY KEY  (topicid)
)  PACK_KEYS=0 COMMENT='论坛主题列表结构';

# --------------------------------------------------------

#
# 表的结构 `user`
#

CREATE TABLE user (
  id int(10) NOT NULL auto_increment,
  username varchar(20) NOT NULL default '',
  password varchar(32) NOT NULL default '',
  qq int(10) NOT NULL default '0',
  email varchar(30) NOT NULL default '',
  homepage varchar(50) NOT NULL default '',
  groupid smallint(2) NOT NULL default '2',
  priv smallint(5) NOT NULL default '3',
  isactive smallint(5) NOT NULL default '1',
  experience int(10) NOT NULL default '0',
  mark int(10) NOT NULL default '0',
  postnum int(10) NOT NULL default '0',
  replynum int(10) NOT NULL default '0',
  msgfriends varchar(255) NOT NULL default '',
  introduction varchar(255) NOT NULL default '',
  truename varchar(16) NOT NULL default '',
  secretemail varchar(30) NOT NULL default '',
  birthday varchar(10) NOT NULL default '',
  postcode int(7) NOT NULL default '0',
  address varchar(255) NOT NULL default '',
  telephone varchar(20) NOT NULL default '',
  banktype int(2) NOT NULL default '0',
  bankaccount varchar(20) NOT NULL default '',
  idcard varchar(18) NOT NULL default '',
  money int(10) NOT NULL default '0',
  otherinfo varchar(255) NOT NULL default '',
  lastentertime int(10) NOT NULL default '0',
  PRIMARY KEY  (id,username),
  UNIQUE KEY username (username)
)  PACK_KEYS=0 COMMENT='用户表结构';



INSERT INTO user VALUES (1, 'admin', '098f6bcd4621d373cade4e832627b4f6', '0', '[e-mail]', '', 32, 63, 1, 15, 0, 1, 0, 'test,', '', '', '[e-mail]', '', 0, '', '', 0, '', '', 0, '', 1099109169);