lybbs_mysql.sql

来自「常见的bbs源代码」· SQL 代码 · 共 1,049 行 · 第 1/3 页

  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),
  KEY id (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 id (id),
  KEY ix_moneyhiddeninfo_1 (postID,postAuthorID)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_moneyhiddeninfo'
#



#
# Table structure for table 'lybbs_postcontent'
#

CREATE TABLE lybbs_postcontent (
  postID int(10) unsigned NOT NULL default '0',
  content text NOT NULL,
  PRIMARY KEY  (postID)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_postcontent'
#



#
# Table structure for table 'lybbs_posts'
#

CREATE TABLE lybbs_posts (
  id int(10) unsigned NOT NULL,
  forum smallint(4) unsigned NOT NULL default '0',
  db smallint(4) unsigned NOT NULL default '0',
  clicktimes int(6) unsigned NOT NULL default '0',
  hotpost enum('0','1') NOT NULL default '0',
  parentid int(10) unsigned NOT NULL default '0',
  istop tinyint(1) NOT NULL default 0,
  topid SMALLINT(4) NOT NULL DEFAULT 0,
  titlelock enum('0','1') NOT NULL default '0',
  titleimage varchar(20) NOT NULL default '',
  authorid int(10) unsigned NOT NULL default '0',
  author varchar(30) NOT NULL default '',
  title varchar(100) NOT NULL default '',
  postat datetime NOT NULL default '0000-00-00 00:00:00',
  ipfrom varchar(64) NOT NULL default '',
  accessary enum('0','1') NOT NULL default '0',
  accessaryname varchar(80) NOT NULL default '',
  vote char(1) NOT NULL default '0',
  jinghua enum('0','1') NOT NULL default '0',
  forumType varchar(20) NOT NULL default '',
  addType varchar(200) NOT NULL default '',
  isvalidate enum('0','1') NOT NULL default '0',
  showsignature TINYINT(1) NOT NULL default 0,
  isrecommend TINYINT(2) NOT NULL DEFAULT 0,
  color VARCHAR(8) NOT NULL DEFAULT '',
  boldcode TINYINT(1) NOT NULL DEFAULT 0,
  viewmode TINYINT(2) NOT NULL DEFAULT 0,
  viewnumber INT(10) NOT NULL DEFAULT 0,
  votecondition TINYINT(2) NOT NULL DEFAULT 0,
  replynum INT(8) NOT NULL DEFAULT 0,
  votenum INT(8) NOT NULL DEFAULT 0,
  lastauthorid INT(10) NOT NULL DEFAULT 0,
  lastauthor VARCHAR(30) NOT NULL DEFAULT '',
  lastpostat BIGINT(13) NOT NULL DEFAULT 0,
  lastpostclue VARCHAR(80) NOT NULL DEFAULT '',
  PRIMARY KEY  (id),
  KEY id (id),
  KEY ix_posts_db (db),
  KEY ix_posts_authorid (authorid),
  KEY ix_posts_author (author),
  KEY ix_posts_parentid (parentid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_posts'
#



#
# Table structure for table 'lybbs_publicstyle'
#

CREATE TABLE lybbs_publicstyle (
  id tinyint(2) unsigned NOT NULL default '0',
  advpost enum('0','1') NOT NULL default '0',
  allowattachment enum('0','1') NOT NULL default '0',
  announcemove enum('0','1') NOT NULL default '0',
  arrawpostflash enum('0','1') NOT NULL default '0',
  arrawpostfontsize enum('0','1') NOT NULL default '0',
  arrawpostmedia enum('0','1') NOT NULL default '0',
  arrawpostpic enum('0','1') NOT NULL default '0',
  arrawpostsound enum('0','1') NOT NULL default '0',
  arrawsignflash enum('0','1') NOT NULL default '0',
  arrawsignfontsize enum('0','1') NOT NULL default '0',
  arrawsignmedia enum('0','1') NOT NULL default '0',
  arrawsignpic enum('0','1') NOT NULL default '0',
  arrawsignsound enum('0','1') NOT NULL default '0',
  arrowavaupload enum('0','1') NOT NULL default '0',
  arrowupload enum('0','1') NOT NULL default '0',
  arrowuserdel enum('0','1') NOT NULL default '0',
  autofreshtime smallint(5) unsigned NOT NULL default '0',
  banfreshtime tinyint(2) unsigned NOT NULL default '0',
  boarddispsign enum('0','1') NOT NULL default '0',
  boardlogo varchar(30) NOT NULL default '',
  cinoption tinyint(3) unsigned NOT NULL default '0',
  defaultheight tinyint(3) unsigned NOT NULL default '0',
  defaultsmileheight tinyint(3) unsigned NOT NULL default '0',
  defaultsmilewidth tinyint(3) unsigned NOT NULL default '0',
  defaultwidth tinyint(3) unsigned NOT NULL default '0',
  dispquickreply enum('0','1') NOT NULL default '0',
  dispview enum('0','1') NOT NULL default '0',
  editjhmpself enum('0','1') NOT NULL default '0',
  editusertitleself enum('0','1') NOT NULL default '0',
  hottopicmark tinyint(2) unsigned NOT NULL default '0',
  hotpollmark tinyint(3) unsigned NOT NULL default '0',
  infosopen tinyint(2) unsigned NOT NULL default '0',
  imageviewnumber tinyint(2) unsigned NOT NULL default '0',
  logdelmax tinyint(2) unsigned NOT NULL default '0',
  look enum('0','1') NOT NULL default '0',
  maxdeloneday tinyint(3) unsigned NOT NULL default '0',
  maxinslegth tinyint(3) unsigned NOT NULL default '0',
  maxinsline tinyint(2) unsigned NOT NULL default '0',
  maxlistpost tinyint(2) unsigned NOT NULL default '0',
  maxpollitem tinyint(3) unsigned NOT NULL default '0',
  maxposticonheight tinyint(3) unsigned NOT NULL default '0',
  maxposticonwidth tinyint(3) unsigned NOT NULL default '0',
  maxpostreport tinyint(2) unsigned NOT NULL default '0',
  maxsavepost tinyint(2) unsigned NOT NULL default '0',
  maxsignlegth smallint(3) unsigned NOT NULL default '0',
  maxsignline tinyint(2) unsigned NOT NULL default '0',
  maxsmail tinyint(2) unsigned NOT NULL default '0',
  maxthreads tinyint(2) unsigned NOT NULL default '0',
  maxtopics tinyint(2) unsigned NOT NULL default '0',
  maxtoptopic tinyint(2) unsigned NOT NULL default '0',
  maxupload smallint(5) NOT NULL default '0',
  membergone tinyint(2) unsigned NOT NULL default '0',
  movetopicname enum('0','1') NOT NULL default '0',
  newmarktime tinyint(3) unsigned NOT NULL default '0',
  newmsgpop enum('0','1') NOT NULL default '0',
  newrefers tinyint(2) unsigned NOT NULL default '0',
  noself enum('0','1') NOT NULL default '0',
  onlineview enum('0','1') NOT NULL default '0',
  pagechange enum('0','1') NOT NULL default '0',
  paraspace tinyint(3) unsigned NOT NULL default '0',
  pvtip enum('0','1') NOT NULL default '0',
  quotemode enum('0','1') NOT NULL default '0',
  refreshforum enum('0','1') NOT NULL default '0',
  regaccess enum('0','1') NOT NULL default '0',
  searchopen enum('0','1') NOT NULL default '0',
  sendwelcomemessage enum('0','1') NOT NULL default '0',
  showskin enum('0','1') NOT NULL default '0',
  smocanseeip enum('0','1') NOT NULL default '0',
  sortalltopic enum('0','1') NOT NULL default '0',
  sortposticonshow enum('0','1') NOT NULL default '0',
  statsopen enum('0','1') NOT NULL default '0',
  timetoshow tinyint(3) unsigned NOT NULL default '0',
  linesperpage tinyint(2) unsigned NOT NULL default '0',
  wordspace tinyint(3) NOT NULL default '0',
  xzbopen enum('0','1') NOT NULL default '0',
  defaultusergroupid smallint(5) unsigned NOT NULL default '0',
  defaultguestgroupid smallint(5) unsigned NOT NULL default '0',
  deletetype enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_publicstyle'
#

INSERT INTO lybbs_publicstyle VALUES(1, '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', '0', '1', '0', '1', '1', '1', 0, 0, '1', 'mainlogo.gif', 0, 32, 13, 13, 32, '1', '1', '1', '1', 15, 10, 0, 10, 2, '1', 0, 200, 5, 6, 22, 120, 120, 10, 24, 250, 5, 3, 25, 12, 3, 500, 15, '1', 24, '1', 25, '1', '1', '0', 130, '0', '0', '0', '0', '1', '1', '1', '1', '0', '1', '1', 1, 0, 0, '1', 0, 0, '1');


#
# Table structure for table 'lybbs_style'
#

CREATE TABLE lybbs_style (
  id smallint(4) unsigned NOT NULL,
  title varchar(30) NOT NULL default '',
  adminglow varchar(8) NOT NULL default '',
  adminnamecolor varchar(8) NOT NULL default '',
  backgroundcolor varchar(8) NOT NULL default '',
  backgroundpic varchar(60) NOT NULL default '',
  banglow varchar(8) NOT NULL default '',
  catback varchar(8) NOT NULL default '',
  catbackpic varchar(60) NOT NULL default '',
  catfontcolor varchar(8) NOT NULL default '',
  fontcolormisc varchar(8) NOT NULL default '',
  fonthighlight varchar(8) NOT NULL default '',
  forumcolorone varchar(8) NOT NULL default '',
  forumcolortwo varchar(8) NOT NULL default '',
  forumcolorthree varchar(8) NOT NULL default '',
  forumfontcolor varchar(8) NOT NULL default '',
  lastpostfontcolor varchar(8) NOT NULL default '',
  memglow varchar(8) NOT NULL default '',
  menubackground varchar(8) NOT NULL default '',
  menubackpic varchar(60) NOT NULL default '',
  menufontcolor varchar(8) NOT NULL default '',
  miscbackone varchar(8) NOT NULL default '',
  miscbacktwo varchar(8) NOT NULL default '',
  otherbackpic varchar(60) NOT NULL default '',
  otherbackpic1 varchar(60) NOT NULL default '',
  postcolorone varchar(8) NOT NULL default '',
  postcolortwo varchar(8) NOT NULL default '',
  posternamecolor varchar(8) NOT NULL default '',
  postfontcolorone varchar(8) NOT NULL default '',
  postfontcolortwo varchar(8) NOT NULL default '',
  scbarrowcolor varchar(8) NOT NULL default '',
  scbdarkcolor varchar(8) NOT NULL default '',
  scbfacecolor varchar(8) NOT NULL default '',
  scbhighlightcolor varchar(8) NOT NULL default '',
  scblightcolor varchar(8) NOT NULL default '',
  scbshadowcolor varchar(8) NOT NULL default '',
  smoglow varchar(8) NOT NULL default '',
  smonamecolor varchar(8) NOT NULL default '',
  tablebordercolor varchar(8) NOT NULL default '',
  tablewidth varchar(8) NOT NULL default '',
  teamglow varchar(8) NOT NULL default '',
  teamnamecolor varchar(8) NOT NULL default '',
  titlecolor varchar(8) NOT NULL default '',
  titlefontcolor varchar(8) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;