lybbs_mysql.sql

一个学习型的论坛适合于初学者的参考和学习

  forum smallint(4) unsigned NOT NULL default '0',
  forumname varchar(150) NOT NULL default '',
  forumexpand enum('1','0') NOT NULL default '1',
  forumadmin varchar(150) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_forum'
#



#
# Table structure for table 'lybbs_friend'
#

CREATE TABLE lybbs_friend (
  id int(6) unsigned NOT NULL,
  authorid int(10) unsigned NOT NULL default '0',
  friendname varchar(30) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY ix_friend_authorid (authorid),
  KEY ix_friend_friendname (friendname)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_friend'
#



#
# Table structure for table 'lybbs_grade'
#

CREATE TABLE lybbs_grade (
  usermode tinyint(2) unsigned NOT NULL default '0',
  grade tinyint(2) unsigned NOT NULL default '0',
  mpostmark int(10) unsigned NOT NULL default '0',
  mname varchar(20) NOT NULL default '',
  mgraphic varchar(20) NOT NULL default '',
  KEY ix_grade_grade (grade),
  KEY ix_grade_usermode (usermode)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_grade'
#

INSERT INTO lybbs_grade VALUES(0, 0, 0, '新手上路', '');
INSERT INTO lybbs_grade VALUES(0, 1, 12, '侠客', 'pips1.gif');
INSERT INTO lybbs_grade VALUES(0, 2, 50, '骑士', 'pips2.gif');
INSERT INTO lybbs_grade VALUES(0, 3, 80, '圣骑士', 'pips3.gif');
INSERT INTO lybbs_grade VALUES(0, 4, 150, '精灵', 'pips4.gif');
INSERT INTO lybbs_grade VALUES(0, 5, 250, '精灵王', 'pips4.gif');
INSERT INTO lybbs_grade VALUES(0, 6, 400, '风云使者', 'pips5.gif');
INSERT INTO lybbs_grade VALUES(0, 7, 700, '光明使者', 'pips5.gif');
INSERT INTO lybbs_grade VALUES(0, 8, 1000, '天使', 'pips6.gif');
INSERT INTO lybbs_grade VALUES(0, 9, 1500, '大天使', 'pips6.gif');
INSERT INTO lybbs_grade VALUES(0, 10, 2500, '精灵使', 'pips7.gif');
INSERT INTO lybbs_grade VALUES(0, 11, 5000, '法师', 'pips8.gif');
INSERT INTO lybbs_grade VALUES(0, 12, 8000, '大法师', 'pips8.gif');
INSERT INTO lybbs_grade VALUES(0, 13, 12000, '法王', 'pips9.gif');
INSERT INTO lybbs_grade VALUES(0, 14, 20000, '老法王', 'pips9.gif');
INSERT INTO lybbs_grade VALUES(0, 15, 30000, '天神', 'pips10.gif');
INSERT INTO lybbs_grade VALUES(0, 16, 50000, '天王', 'pips10.gif');
INSERT INTO lybbs_grade VALUES(0, 17, 100000, '法老', 'pips10.gif');
INSERT INTO lybbs_grade VALUES(0, 18, 99999999, '法老', 'pips10.gif');
INSERT INTO lybbs_grade VALUES(0, 19, 99999999, '法老', 'pips10.gif');
INSERT INTO lybbs_grade VALUES(0, 20, 99999999, '法老', 'pips10.gif');
INSERT INTO lybbs_grade VALUES(3, 0, 0, '高级天王 [荣誉]', 'pips10.gif');
INSERT INTO lybbs_grade VALUES(6, 0, 0, '终极天王 [荣誉]', 'pips10.gif');
INSERT INTO lybbs_grade VALUES(7, 0, 0, '究级天王 [荣誉]', 'pips10.gif');


#
# Table structure for table 'lybbs_icon'
#

CREATE TABLE lybbs_icon (
  id tinyint(2) unsigned NOT NULL default '0',
  onlineadmin varchar(20) NOT NULL default '',
  onlinesmod varchar(20) NOT NULL default '',
  onlinemod varchar(20) NOT NULL default '',
  onlinemember varchar(20) NOT NULL default '',
  onlinerz varchar(20) NOT NULL default '',
  onlineselfcolor varchar(8) NOT NULL default '',
  onlineguest varchar(20) NOT NULL default '',
  zg_havenew varchar(20) NOT NULL default '',
  zg_nonew varchar(20) NOT NULL default '',
  kf_havenew varchar(20) NOT NULL default '',
  kf_nonew varchar(20) NOT NULL default '',
  pl_havenew varchar(20) NOT NULL default '',
  pl_nonew varchar(20) NOT NULL default '',
  bm_havenew varchar(20) NOT NULL default '',
  bm_nonew varchar(20) NOT NULL default '',
  rz_havenew varchar(20) NOT NULL default '',
  rz_nonew varchar(20) NOT NULL default '',
  jh_pic varchar(20) NOT NULL default '',
  lm_pic varchar(20) NOT NULL default '',
  newthreadlogo varchar(20) NOT NULL default '',
  newpolllogo varchar(20) NOT NULL default '',
  newxzblogo varchar(20) NOT NULL default '',
  newreplylogo varchar(20) NOT NULL default '',
  wlogo varchar(20) NOT NULL default '',
  nwlogo varchar(20) NOT NULL default '',
  help_blogo varchar(20) NOT NULL default '',
  new_blogo varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_icon'
#

INSERT INTO lybbs_icon VALUES(1, 'messages0.gif', 'messages3.gif', 'messages4.gif', 'messages1.gif', 'messages5.gif', '#0000FF', 'messages2.gif', 'foldernew.gif', 'folder.gif', 'folderallnew.gif', 'folderall.gif', 'follownew.gif', 'follow.gif', 'lock_l.gif', 'lock_b.gif', 'rzfoldernew.gif', 'rzfolder.gif', 'jinghua.gif', 'shareforum.gif', 'newthread.gif', 'newpoll.gif', 'newxzb.gif', 'newreply.gif', 'w.gif', 'nw.gif', 'help_b.gif', 'topnew.gif');


#
# Table structure for table 'lybbs_moneyhiddeninfo'
#

CREATE TABLE lybbs_moneyhiddeninfo (
  id int(10) unsigned NOT NULL,
  postID int(10) unsigned NOT NULL default '0',
  postAuthorID int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY ix_moneyhiddeninfo_1 (postID,postAuthorID)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_moneyhiddeninfo'
#



#
# Table structure for table 'lybbs_post'
#

CREATE TABLE lybbs_postlist (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  postat int(10) NOT NULL default 0,
  titleicon varchar(20) NOT NULL default '',
  accessaryimg tinyint(1) NOT NULL default 0,
  accessaryext varchar(6) NOT NULL default '',
  accessarypath varchar(60) NOT NULL default '',
  clicktimes int(6) NOT NULL default 0,
  replynum int(8) NOT NULL default 0,
  votenum int(8) NOT NULL default 0,
  locktop tinyint(1) NOT NULL default 0,
  locktopid smallint(4) NOT NULL default 0,
  lockreply tinyint(1) NOT NULL default 0,
  lockvote tinyint(1) NOT NULL default 0,
  vote tinyint(1) NOT NULL default 0,
  elite tinyint(1) NOT NULL default 0,
  invisible tinyint(1) NOT NULL default 0,
  color varchar(7) NOT NULL default '',
  boldcode tinyint(1) NOT NULL default 0,
  lastauthorid int(10) NOT NULL default 0,
  lastauthor varchar(40) NOT NULL default '',
  lastpostat int(10) NOT NULL default 0,
  lastpostclue varchar(80) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forumid (forumid), 
  KEY authorid (authorid),
  KEY locktop (locktop),
  KEY elite (elite),
  KEY lastpostat (lastpostat)
) TYPE=MyISAM;

CREATE TABLE lybbs_posttopic (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  content text NOT NULL,
  postat int(10) NOT NULL default 0,
  postattime datetime NOT NULL default '1900-01-01 00:00:00',
  postip varchar(64) NOT NULL default '',
  titleicon varchar(20) NOT NULL default '',
  accessary tinyint(1) NOT NULL default 0,
  clicktimes int(6) NOT NULL default 0,
  replynum int(8) NOT NULL default 0,
  votenum int(8) NOT NULL default 0,
  locktop tinyint(1) NOT NULL default 0,
  locktopid smallint(4) NOT NULL default 0,
  lockreply tinyint(1) NOT NULL default 0,
  lockvote tinyint(1) NOT NULL default 0,
  vote tinyint(1) NOT NULL default 0,
  votecondition tinyint(2) NOT NULL default 0,
  elite tinyint(1) NOT NULL default 0,
  invisible tinyint(1) NOT NULL default 0,
  showsign tinyint(1) NOT NULL default 0,
  color varchar(7) NOT NULL default '',
  boldcode tinyint(1) NOT NULL default 0,
  viewmode tinyint(1) NOT NULL default 0,
  viewnumber int(10) NOT NULL default 0,
  lasteditauthorid int(10) NOT NULL default 0,
  lasteditauthor varchar(40) NOT NULL default '',
  lasteditat int(10) NOT NULL default 0,
  lasteditip varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forumid (forumid),
  KEY authorid (authorid),
  KEY postat (postat)
) TYPE=MyISAM;

CREATE TABLE lybbs_postreply (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  topicid int(10) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(90) NOT NULL default '',
  content text NOT NULL,
  postat int(10) NOT NULL default 0,
  postattime datetime NOT NULL default '1900-01-01 00:00:00',
  postip varchar(64) NOT NULL default '',
  titleicon varchar(20) NOT NULL default '',
  accessary tinyint(1) NOT NULL default 0,
  invisible tinyint(1) NOT NULL default 0,
  showsign tinyint(1) NOT NULL default 0,
  viewmode tinyint(1) NOT NULL default 0,
  viewnumber int(10) NOT NULL default 0,
  lasteditauthorid int(10) NOT NULL default 0,
  lasteditauthor varchar(40) NOT NULL default '',
  lasteditat int(10) NOT NULL default 0,
  lasteditip varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forumid (forumid),
  KEY topicid (topicid),
  KEY authorid (authorid),
  KEY postat (postat)
) TYPE=MyISAM;

CREATE TABLE lybbs_postvalidate (
  id int(10) NOT NULL default 0,
  forumid smallint(4) NOT NULL default 0,
  topicid int(10) NOT NULL default 0,
  authorid int(10) NOT NULL default 0,
  author varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  content text NOT NULL,
  postat int(10) NOT NULL default 0,
  postip varchar(64) NOT NULL default '',
  titleicon varchar(20) NOT NULL default '',
  accessary tinyint(1) NOT NULL default 0,
  accessaryimg tinyint(1) NOT NULL default 0,
  accessaryext varchar(6) NOT NULL default '',
  accessarypath varchar(60) NOT NULL default '',
  clicktimes int(6) NOT NULL default 0,
  replynum int(8) NOT NULL default 0,
  votenum int(8) NOT NULL default 0,
  locktop tinyint(1) NOT NULL default 0,
  locktopid smallint(4) NOT NULL default 0,
  lockreply tinyint(1) NOT NULL default 0,
  lockvote tinyint(1) NOT NULL default 0,
  vote tinyint(1) NOT NULL default 0,
  votecondition tinyint(2) NOT NULL default 0,