lybbs_mysql.sql

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

# MySQL-Front Dump 2.5
#
# Host: 127.0.0.1   Database: lybbs
# --------------------------------------------------------
# Server version 4.0.16-nt
# Set names, if mysql version is 4.1.x

#SET NAMES gbk;

#
# Table structure for table 'lybbs_admin'
#

CREATE TABLE lybbs_admin (
  id smallint(5) unsigned NOT NULL,
  authorid int(10) unsigned NOT NULL default '0',
  authorname varchar(30) NOT NULL default '',
  forum smallint(4) unsigned NOT NULL default '0',
  db smallint(4) unsigned NOT NULL default '0',
  usermode tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY ix_admin_db (db),
  KEY ix_admin_authorid (authorid),
  KEY ix_admin_authorname (authorname)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_admin'
#



#
# Table structure for table 'lybbs_allianceforum'
#

CREATE TABLE lybbs_allianceforum (
  id smallint(4) unsigned NOT NULL,
  forumname varchar(80) NOT NULL default '',
  forumurl varchar(150) NOT NULL default '',
  weblogo varchar(150) NOT NULL default '',
  forumdescription varchar(200) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_allianceforum'
#

INSERT INTO lybbs_allianceforum VALUES(1, '凌云论坛', 'http://www.lybbs.net', 'lybbs/images/lylogo.gif', 'LyBBS『凌云论坛』大本营');


#
# Table structure for table 'lybbs_allowprivate'
#

CREATE TABLE lybbs_allowprivate (
  id smallint(5) unsigned NOT NULL,
  authorid int(10) unsigned NOT NULL default '0',
  dbid smallint(4) unsigned NOT NULL default '0',
  checkpass enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY ix_allowprivate_1 (authorid,dbid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_allowprivate'
#



#
# Table structure for table 'lybbs_announcement'
#

CREATE TABLE lybbs_announcement (
  id int(8) unsigned NOT NULL,
  db smallint(4) unsigned NOT NULL default '0',
  author varchar(40) NOT NULL default '',
  title varchar(150) NOT NULL default '',
  content text NOT NULL,
  postat datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (id),
  KEY ix_announcement_db (db)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_announcement'
#



#
# Table structure for table 'lybbs_author'
#

CREATE TABLE lybbs_author (
  id int(10) unsigned NOT NULL,
  usergroupid smallint(5) unsigned NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  password varchar(40) NOT NULL default '',
  msgpopup enum('1','0') NOT NULL default '1',
  myinfo enum('0','1') NOT NULL default '0',
  mess varchar(255) NOT NULL default '',
  advpost enum('0','1') NOT NULL default '0',
  hidden enum('0','1') NOT NULL default '0',
  onlineview enum('1','0') NOT NULL default '1',
  threadages smallint(3) NOT NULL default '0',
  blogid int(10) NOT NULL default 0,
  email varchar(40) NOT NULL default '',
  showemail enum('0','1') NOT NULL default '0',
  lostquestion varchar(150) NOT NULL default '',
  lostanswer varchar(150) NOT NULL default '',
  sex varchar(4) NOT NULL default '',
  education varchar(10) NOT NULL default '',
  marry varchar(8) NOT NULL default '',
  work varchar(20) NOT NULL default '',
  birthday date NOT NULL default '1900-01-01',
  astro varchar(8) NOT NULL default '',
  usersx varchar(8) NOT NULL default '',
  homepage varchar(40) NOT NULL default '',
  qq varchar(16) NOT NULL default '',
  icq varchar(16) NOT NULL default '',
  country varchar(30) NOT NULL default '',
  province varchar(30) NOT NULL default '',
  city varchar(30) NOT NULL default '',
  timedifference tinyint(3) NOT NULL default '0',
  introdution varchar(255) NOT NULL default '',
  signature varchar(255) NOT NULL default '',
  notshowsignature enum('0','1') NOT NULL default '0',
  imagename varchar(30) NOT NULL default '',
  imageurl varchar(255) NOT NULL default '',
  imagewidth tinyint(3) unsigned NOT NULL default '0',
  imageheight tinyint(3) unsigned NOT NULL default '0',
  lastactivetime datetime NOT NULL default '0000-00-00 00:00:00',
  logintime datetime NOT NULL default '0000-00-00 00:00:00',
  activetime datetime NOT NULL default '0000-00-00 00:00:00',
  registertime datetime NOT NULL default '0000-00-00 00:00:00',
  isonline tinyint(1) NOT NULL default 0,
  mark int(6) unsigned NOT NULL default '0',
  nposts int(6) unsigned NOT NULL default '0',
  ndelete int(6) unsigned NOT NULL default '0',
  nreply int(6) unsigned NOT NULL default '0',
  money int(8) unsigned NOT NULL default '0',
  experience int(8) unsigned NOT NULL default '0',
  charm int(8) unsigned NOT NULL default '0',
  visittimes int(6) unsigned NOT NULL default '0',
  newmembertitle varchar(30) NOT NULL default '',
  newsocialpart varchar(40) NOT NULL default '',
  status char(1) NOT NULL default '0',
  allowprivate enum('0','1') NOT NULL default '0',
  styleid smallint(4) NOT NULL default '0',
  ipfrom varchar(64) NOT NULL default '',
  usermode tinyint(2) unsigned NOT NULL default '1',
  grade tinyint(2) NOT NULL default '0',
  freshtime smallint(5) unsigned NOT NULL default '0',
  warmindex INT(8) NOT NULL DEFAULT 0,
  lastposttime BIGINT(13) NOT NULL DEFAULT 0,
  lastloginip VARCHAR(64) NOT NULL DEFAULT '',
  PRIMARY KEY  (id),
  KEY ix_author_1 (username,password),
  KEY ix_author_usermode (usermode),
  KEY ix_author_usergroupid (usergroupid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_author'
#

INSERT INTO lybbs_author (id, usergroupid, username, password, msgpopup, myinfo, mess, advpost, hidden, onlineview, threadages, blogid, email, showemail, lostquestion, lostanswer, sex, education, marry, work, birthday, astro, usersx, homepage, qq, icq, country, province, city, timedifference, introdution, signature, notshowsignature, imagename, imageurl, imagewidth, imageheight, lastactivetime, logintime, activetime, registertime, isonline, mark, nposts, ndelete, nreply, money, experience, charm, visittimes, newmembertitle, newsocialpart, status, allowprivate, styleid, ipfrom, usermode, grade, freshtime, warmindex, lastposttime, lastloginip) VALUES (0, 0, 'Guest', '123456', '1', '0', '', '0', '0', '1', 0, 0, '[e-mail]', '0', '', '', 'sect', 'secret', 'secret', 'secret', '1900-01-01', 'secret', 'secret', 'http://', '', '', '', '', '', 0, '', '', '0', 'noavatar.gif', '', 0, 0, now(), now(), now(), now(), 0, 0, 0, 0, 0,0,0,0,0, '','', '0', '0',0, '127.0.0.1', 1,0,0,0,0,'127.0.0.1');

INSERT INTO lybbs_author (id, usergroupid, username, password, msgpopup, myinfo, mess, advpost, hidden, onlineview, threadages, blogid, email, showemail, lostquestion, lostanswer, sex, education, marry, work, birthday, astro, usersx, homepage, qq, icq, country, province, city, timedifference, introdution, signature, notshowsignature, imagename, imageurl, imagewidth, imageheight, lastactivetime, logintime, activetime, registertime, isonline, mark, nposts, ndelete, nreply, money, experience, charm, visittimes, newmembertitle, newsocialpart, status, allowprivate, styleid, ipfrom, usermode, grade, freshtime, warmindex, lastposttime, lastloginip) VALUES (1, 0, 'admin', 'E10ADC3949BA59AB', '1', '0', '', '0', '0', '1', 0, 0, '[e-mail]', '0', '', '', 'sect', 'secret', 'secret', 'secret', '1900-01-01', 'secret', 'secret', 'http://', '', '', '中国', '', '', 0, '', '', '0', 'noavatar.gif', '', 0, 0, now(), now(), now(), now(), 0, 0, 0, 0, 0,0,0,0,0, '','', '0', '0',0, '127.0.0.1', 7,0,0,0,0,'127.0.0.1');

#
# Table structure for table 'lybbs_reserve'
#

CREATE TABLE lybbs_reserve (
  id smallint(4) NOT NULL default '0',
  username varchar(250) NOT NULL default '',
  email varchar(250) NOT NULL default '',
  registerip varchar(250) NOT NULL default '',
  visitip varchar(250) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;


#
# Table structure for table 'lybbs_boardstatus'
#

CREATE TABLE lybbs_boardstatus (
  id tinyint(2) unsigned NOT NULL default '0',
  visittimes bigint(20) unsigned NOT NULL default '0',
  clicktimes bigint(20) unsigned NOT NULL default '0',
  maxonlinenumber smallint(5) unsigned NOT NULL default '0',
  recordat datetime NOT NULL default '0000-00-00 00:00:00',
  maxpostnumber INT(6) NOT NULL DEFAULT 0,
  postrecordat datetime NOT NULL default '1970-01-01 00:00:00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_boardstatus'
#

INSERT INTO lybbs_boardstatus VALUES(1, 0, 0, 0, now(), 0, now());


#
# Table structure for table 'lybbs_db'
#

CREATE TABLE lybbs_db (
  id smallint(4) unsigned NOT NULL,
  forum smallint(4) unsigned NOT NULL default '0',
  parentid smallint(4) unsigned NOT NULL default '0',
  disablepost enum('0','1') NOT NULL default '0',
  db smallint(4) unsigned NOT NULL default '0',
  dbname varchar(30) NOT NULL default '',
  dbdescription varchar(100) NOT NULL default '',
  htmlstat enum('0','1') NOT NULL default '0',
  lycodestat enum('0','1') NOT NULL default '0',
  privateforum enum('0','1') NOT NULL default '0',
  dbpassword varchar(30) NOT NULL default '',
  indexforum enum('0','1') NOT NULL default '0',
  startnewthreads varchar(20) NOT NULL default '',
  ratings enum('0','1') NOT NULL default '0',
  dbgraphic varchar(30) NOT NULL default '',
  teamlogo varchar(30) NOT NULL default '',
  teamurl varchar(60) NOT NULL default '',
  forumType varchar(100) NOT NULL default '',
  isvalidate enum('0','1') NOT NULL default '0',
  dbadmin varchar(150) NOT NULL default '',
  topicnumber int(10) NOT NULL default '0',
  replynumber int(10) NOT NULL default '0',
  lastpostgroupid int(10) NOT NULL default '0',
  lastposttitle varchar(80) NOT NULL default '',
  lastpostview varchar(120) NOT NULL default '',
  lastpostauthor varchar(40) NOT NULL default '',
  lastpostat bigint(13) NOT NULL default '0',
  timestatus TINYINT(2)  NOT NULL DEFAULT 0,
  timefromhour TINYINT(2)  NOT NULL DEFAULT 0,
  timefromminute TINYINT(2)  NOT NULL DEFAULT 0,
  timetohour TINYINT(2)  NOT NULL DEFAULT 0,
  timetominute TINYINT(2)  NOT NULL DEFAULT 0,
  PRIMARY KEY  (id),
  KEY ix_db_forum (forum),
  KEY ix_db_parentid (parentid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_db'
#


#
# Table structure for table 'lybbs_forum'
#

CREATE TABLE lybbs_forum (
  id smallint(4) unsigned NOT NULL,