lybbs_mysql.sql

常见的bbs源代码

# MySQL-Front Dump 2.5
#
# Host: 127.0.0.1   Database: lybbs6
# --------------------------------------------------------
# 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 id (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),
  KEY id (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 id (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 id (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',
  viewmode varchar(10) NOT NULL default '',
  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 enum('0','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 id (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 VALUES(1, 0, 'admin', 'E10ADC3949BA59AB', '1', '0', '', '0', '0', '1', 0, '', '[e-mail]', '1', '', '', 'sect', 'secret', 'secret', 'secret', '1900-01-01', 'secret', 'secret', 'http://', '', '', '中国', '', '', 0, '', '', '0', 'noavatar.gif', '', 0, 0, now(), now(), now(), now(), '1', 0, 0, 0, 0, 1015, 102, 105, 1, '', '', '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),
  KEY id (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 id (id),
  KEY ix_db_forum (forum),
  KEY ix_db_parentid (parentid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_db'
#



#
# Table structure for table 'lybbs_encourage'
#

CREATE TABLE lybbs_encourage (
  id tinyint(2) unsigned NOT NULL default '0',
  coinname varchar(20) NOT NULL default '',
  addrecommendmoney smallint(4) unsigned NOT NULL default '0',
  addrecommendexperience smallint(4) unsigned NOT NULL default '0',
  addrecommendcharm smallint(4) unsigned NOT NULL default '0',
  addmoney smallint(4) unsigned NOT NULL default '0',
  replymoney smallint(4) unsigned NOT NULL default '0',
  loginmoney smallint(4) unsigned NOT NULL default '0',
  delmoney smallint(4) unsigned NOT NULL default '0',
  joinmoney smallint(4) unsigned NOT NULL default '0',
  addexperience smallint(4) unsigned NOT NULL default '0',
  replyexperience smallint(4) unsigned NOT NULL default '0',
  loginexperience smallint(4) unsigned NOT NULL default '0',
  delexperience smallint(4) unsigned NOT NULL default '0',
  joinexperience smallint(4) unsigned NOT NULL default '0',
  addcharm smallint(4) unsigned NOT NULL default '0',
  replycharm smallint(4) unsigned NOT NULL default '0',
  logincharm smallint(4) unsigned NOT NULL default '0',
  delcharm smallint(4) unsigned NOT NULL default '0',
  joincharm smallint(4) unsigned NOT NULL default '0',
  jingmoney SMALLINT(4) NOT NULL DEFAULT '0',
  jingexperience SMALLINT(4) NOT NULL DEFAULT '0',
  jingcharm SMALLINT(4) NOT NULL DEFAULT '0',
  jingindex SMALLINT(4) NOT NULL DEFAULT '0',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_encourage'
#

INSERT INTO lybbs_encourage VALUES(1, '凌元点', 100, 0, 10, 10, 8, 15, 20, 1000, 6, 6, 2, 10, 100, 8, 5, 5, 10, 100, 10, 10, 10, 10);


#
# Table structure for table 'lybbs_forum'
#

CREATE TABLE lybbs_forum (
  id smallint(4) unsigned NOT NULL,
  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),
  KEY id (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 id (id),