lybbs_mysql.sql

常见的bbs源代码

#
# Dumping data for table 'lybbs_style'
#

INSERT INTO lybbs_style VALUES(1, '默认风格', '#000000', '#000000', '#FFFFFF', '', '#000000', '#7C96B8', 'lybbs/skins/default/bg/catbg.gif', '#ffffff', '#000000', '#000000', '#C4D0DF', '#FFFFFF', '#edf0f3', '#000000', '#000000', '#000000', '#e8f4ff', 'lybbs/skins/default/bg/menubg.gif', '#333333', '#FFFFFF', '#edf0f3', '', '', '#edf0f3', '#ffffff', '#000000', '#000000', '#000000', '#006699', '#98aab1', '#dee3e7', '#ffffff', '#d1d7dc', '#dee3e7', '#000000', '#000000', '#7C96B8', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(2, '碧海青天', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/bihaiqingtian/bg/forumbg.jpg', '#000000', '#90C8FF', 'lybbs/skins/bihaiqingtian/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#e8f4ff', '#ffffff', '#e8f4ff', '#000000', '#000000', '#000000', '#e8f4ff', 'lybbs/skins/default/bg/menubg.gif', '#333333', '#FFFFFF', '#edf0f3', '', '', '#FFFFFF', '#F2F8FF', '#000000', '#333333', '#555555', '#006699', '#98AAB1', '#DEE3E7', '#FFFFFF', '#D1D7DC', '#DEE3E7', '#000000', '#000000', '#90C8FF', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(3, '淡蓝典雅', '#000000', '#000000', '#FFFFFF', '', '#000000', '#7C96B8', '', '#FFFFFF', '#000000', '#000000', '#C4D0DF', '#ffffff', '#e8f4ff', '#000000', '#000000', '#000000', '#e8f4ff', 'lybbs/skins/default/bg/menubg.gif', '#333333', '#FFFFFF', '#edf0f3', '', '', '#FFFFFF', '#C4D0DF', '#000000', '#000000', '#000000', '#006699', '#98AAB1', '#DEE3E7', '#FFFFFF', '#D1D7DC', '#DEE3E7', '#000000', '#000000', '#7C96B8', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(4, '蓝色海洋', '#FFCC00', '#FFCC00', '#004782', '', '#FFCC00', '#0059a2', 'lybbs/skins/lanshehaiyang/bg/catbg.gif', '#FFFFFF', '#FFCC00', '#FFCC00', '#003366', '#004782', '#0059a2', '#000000', '#FFCC00', '#FFCC00', '#0059a2', '', '#FFCC00', '#FFFFFF', '#edf0f3', '', '', '#0059a2', '#004782', '#FFCC00', '#ffffff', '#ffffff', '#006699', '#98AAB1', '#DEE3E7', '#FFFFFF', '#D1D7DC', '#DEE3E7', '#FFCC00', '#FFCC00', '#000000', '98%', '#FFCC00', '#FFCC00', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(5, '浓浓绿意', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/nongnongluyi/bg/forumbg.gif', '#000000', '#669900', 'lybbs/skins/nongnongluyi/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#dbeedd', '#F4FCF3', '#E8F7E6', '#000000', '#000000', '#000000', '#99cc66', 'lybbs/skins/nongnongluyi/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#F4FCF3', '#FFFFFF', '#000000', '#000000', '#000000', '#006699', '#f3faf4', '#dbeedd', '#FFFFFF', '#dbeedd', '#DEE3E7', '#000000', '#000000', '#669900', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(6, '绿趣盎然', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/nongnongluyi/bg/forumbg.gif', '#000000', '#009999', 'lybbs/skins/luquangran/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#D3FAED', '#EDFFFA', '#E8F7F7', '#000000', '#000000', '#000000', '#009999', 'lybbs/skins/luquangran/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#D3FAED', '#EDFFFA', '#000000', '#000000', '#000000', '#009999', '#CCEEEE', '#E8F7F7', '#FFFFFF', '#E8F7F7', '#E8F7F7', '#000000', '#000000', '#009999', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(7, '绿色生机', '#000000', '#000000', '#FFFFFF', '', '#000000', '#A9D46D', 'lybbs/skins/lusheshengji/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#E3F1D1', '#FFFFFF', '#F4FAED', '#000000', '#000000', '#000000', '#A9D46D', 'lybbs/skins/lusheshengji/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#F4FAED', '#FFFFFF', '#000000', '#000000', '#000000', '#8fbc8f', '#f3faf4', '#dbeedd', '#FFFFFF', '#dbeedd', '#8fbc8f', '#000000', '#000000', '#A9D46D', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(8, '绿色淡雅', '#000000', '#000000', '#FFFFFF', '', '#000000', '#8fbc8f', 'lybbs/skins/lushedanya/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#dbeedd', '#FFFFFF', '#F4FAED', '#000000', '#000000', '#000000', '#8fbc8f', 'lybbs/skins/lushedanya/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#dbeedd', '#FFFFFF', '#000000', '#000000', '#000000', '#8fbc8f', '#f3faf4', '#dbeedd', '#FFFFFF', '#dbeedd', '#8fbc8f', '#000000', '#000000', '#8fbc8f', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(9, '橙黄瑰丽', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/nongnongluyi/bg/forumbg.gif', '#000000', '#FFB58B', 'lybbs/skins/chenghuangguili/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#FFECE0', '#FFFFFF', '#FFECE0', '#000000', '#000000', '#000000', '#FFB58B', 'lybbs/skins/chenghuangguili/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#FFECE0', '#FFFFFF', '#000000', '#000000', '#000000', '#006699', '#98AAB1', '#DEE3E7', '#FFFFFF', '#D1D7DC', '#DEE3E7', '#000000', '#000000', '#FFB58B', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(10, '红粉佳人', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/nongnongluyi/bg/forumbg.gif', '#000000', '#F2ABCF', 'lybbs/skins/hongfenjiaren/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#FBF4F4', '#FFFFFF', '#FCD8E3', '#000000', '#000000', '#000000', '#F2ABCF', 'lybbs/skins/hongfenjiaren/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#FDE7EC', '#FBF4F4', '#000000', '#000000', '#000000', '#D66565', '#F3E2E2', '#FBF4F4', '#FFFFFF', '#FBF4F4', '#FBF4F4', '#000000', '#000000', '#F2ABCF', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(11, '喜气洋洋', '#000000', '#000000', '#FFFFFF', '', '#000000', '#ff6600', 'lybbs/skins/xiqiyangyang/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#FFFAF7', '#FFFFFF', '#FFF0E6', '#000000', '#000000', '#000000', '#ff6600', 'lybbs/skins/xiqiyangyang/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#FFFAF7', '#FFFFFF', '#000000', '#000000', '#000000', '#FFFFFF', '#98AAB1', '#DEE3E7', '#FFFFFF', '#F9904B', '#DEE3E7', '#000000', '#000000', '#ff6600', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(12, '水晶紫色', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/shuijingzishe/bg/forumbg.gif', '#000000', '#FFB8D8', 'lybbs/skins/shuijingzishe/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#FFF0F8', '#FFFFFF', '#FFF0F8', '#000000', '#000000', '#000000', '#FFB8D8', 'lybbs/skins/shuijingzishe/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#FFF0F8', '#FFF8FF', '#000000', '#000000', '#000000', '#663399', '#E9DEF3', '#F3EEF9', '#FFFFFF', '#F3EEF9', '#F3EEF9', '#000000', '#000000', '#FFB8D8', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(13, '紫色淡雅', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/nongnongluyi/bg/forumbg.gif', '#000000', '#984B98', 'lybbs/skins/zishedanya/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#F7EEF7', '#FFFFFF', '#F7EEF7', '#000000', '#000000', '#000000', '#984B98', 'lybbs/skins/zishedanya/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#F7EEF7', '#FFFFFF', '#000000', '#000000', '#000000', '#984B98', '#ECF1FB', '#F7EEF7', '#FFFFFF', '#F7EEF7', '#F7EEF7', '#000000', '#000000', '#984B98', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(14, '浓郁咖啡', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/nongnongluyi/bg/forumbg.gif', '#000000', '#8c5d18', 'lybbs/skins/nongyukafei/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#EBDAC7', '#FFFFFF', '#efe3ce', '#000000', '#000000', '#000000', '#8c5d18', 'lybbs/skins/nongyukafei/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#F0E1D2', '#FFFFFF', '#000000', '#000000', '#000000', '#006699', '#98AAB1', '#DEE3E7', '#FFFFFF', '#D1D7DC', '#DEE3E7', '#000000', '#000000', '#8c5d18', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(15, '黄金时代', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/huangjingshidai/bg/forumbg.gif', '#000000', '#FFE151', 'lybbs/skins/huangjingshidai/bg/catbg.gif', '#FFFFFF', '#000000', '#000000', '#FFF8C9', '#FFFDE5', '#FFF1A3', '#000000', '#000000', '#000000', '#FFE151', 'lybbs/skins/huangjingshidai/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#FFF8C9', '#FFFDE5', '#000000', '#000000', '#000000', '#FFE151', '#98AAB1', '#DEE3E7', '#FFFFFF', '#D1D7DC', '#DEE3E7', '#000000', '#000000', '#FFE151', '98%', '#000000', '#000000', '#ffffff', '#333333');
INSERT INTO lybbs_style VALUES(16, '银装素裹', '#000000', '#000000', '#FFFFFF', 'lybbs/skins/yinzhuangsuguo/bg/forumbg.jpg', '#000000', '#DFDFDF', 'lybbs/skins/yinzhuangsuguo/bg/catbg.gif', '#000000', '#000000', '#000000', '#F7F7F7', '#FFFFFF', '#EEEEEE', '#000000', '#000000', '#000000', '#DFDFDF', 'lybbs/skins/yinzhuangsuguo/bg/menubg.gif', '#000000', '#FFFFFF', '#edf0f3', '', '', '#F7F7F7', '#FFFFFF', '#000000', '#000000', '#000000', '#006699', '#98AAB1', '#DEE3E7', '#D1D7DC', '#F7EEF7', '#DEE3E7', '#000000', '#000000', '#DFDFDF', '98%', '#000000', '#000000', '#ffffff', '#333333');


#
# Table structure for table 'lybbs_uploadinfo'
#

CREATE TABLE lybbs_uploadinfo (
  id mediumint(8) unsigned NOT NULL,
  postsid int(10) unsigned NOT NULL default '0',
  blogpostid INT(10) NOT NULL default '0',
  filename varchar(40) NOT NULL default '',
  fileext varchar(40) NOT NULL default '',
  filesize varchar(20) NOT NULL default '',
  uploaddate date NOT NULL default '1900-01-01',
  filewidth smallint(5) unsigned NOT NULL default '0',
  fileheight smallint(5) unsigned NOT NULL default '0',
  authorid INT(10)  NOT NULL DEFAULT 0,
  filerealname VARCHAR(60) NOT NULL DEFAULT '',
  filepath VARCHAR(80) NOT NULL DEFAULT '',
  forumid SMALLINT(4) NOT NULL DEFAULT '0',
  parentid INT(10) NOT NULL DEFAULT '0',
  title VARCHAR(255) NOT NULL DEFAULT '',
  PRIMARY KEY  (id),
  KEY id (id),
  KEY ix_uploadinfo_postsid (postsid),
  KEY ix_uploadinfo_blogpostid (blogpostid),
  KEY ix_uploadinfo_authorid (authorid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_uploadinfo'
#



#
# Table structure for table 'lybbs_usergroup'
#

CREATE TABLE lybbs_usergroup (
  id smallint(5) unsigned NOT NULL,
  groupname varchar(50) NOT NULL default '',
  groupquotasize INT(10) NOT NULL DEFAULT 0,
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_usergroup'
#



#
# Table structure for table 'lybbs_usergroupprivilege'
#

CREATE TABLE lybbs_usergroupprivilege (
  id smallint(5) unsigned NOT NULL,
  usergroupid smallint(5) unsigned NOT NULL default '0',
  dbid smallint(4) unsigned NOT NULL default '0',
  groupprivilege tinyint(2) unsigned NOT NULL default '1',
  PRIMARY KEY  (id),
  KEY id (id),
  KEY ix_usergroupprivilege_1 (usergroupid,dbid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_usergroupprivilege'
#



#
# Table structure for table 'lybbs_vote'
#

CREATE TABLE lybbs_vote (
  id smallint(5) unsigned NOT NULL,
  postsid int(10) unsigned NOT NULL default '0',
  votetitle varchar(50) NOT NULL default '',
  votenumber int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY id (id),
  KEY ix_vote_postsid (postsid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_vote'
#



#
# Table structure for table 'lybbs_voterecord'
#

CREATE TABLE lybbs_voterecord (
  id bigint(20) unsigned NOT NULL,
  postsid int(10) unsigned NOT NULL default '0',
  voteid smallint(5) unsigned NOT NULL default '0',
  votename varchar(50) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY id (id),
  KEY ix_voterecord_1 (postsid,votename),
  KEY ix_voterecord_voteid (voteid)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_voterecord'
#



#
# Table structure for table 'lybbs_webqq'
#

CREATE TABLE lybbs_webqq (
  id int(6) unsigned NOT NULL,
  fromname varchar(30) NOT NULL default '',
  toname varchar(30) NOT NULL default '',
  title varchar(200) NOT NULL default '',
  message text NOT NULL,
  sendat datetime NOT NULL default '0000-00-00 00:00:00',
  operation varchar(4) NOT NULL default '',
  viewed enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY id (id),
  KEY ix_webqq_1 (fromname,operation),
  KEY ix_webqq_2 (toname,operation)
) TYPE=MyISAM;



#
# Dumping data for table 'lybbs_webqq'
#

CREATE TABLE lybbs_post_weapon (
  postID INT(10) DEFAULT 0 NOT NULL,
  praiseCount1 INT(10) DEFAULT 0 NOT NULL,
  praiseCount2 INT(10) DEFAULT 0 NOT NULL,
  criticizeCount1 INT(10) DEFAULT 0 NOT NULL,
  criticizeCount2 INT(10) DEFAULT 0 NOT NULL,
  PRIMARY KEY(postID)
) TYPE=MyISAM;


CREATE TABLE lybbs_post_book (
  postID INT(10) DEFAULT 0 NOT NULL,
  authorID INT(10) DEFAULT 0 NOT NULL,
  INDEX(postID,authorID)
) TYPE=MyISAM;


CREATE TABLE lybbs_post_favorite (
  postID INT(10) DEFAULT 0 NOT NULL,
  authorID INT(10) DEFAULT 0 NOT NULL,
  INDEX(postID,authorID)
) TYPE=MyISAM;

CREATE TABLE lybbs_log (
  id INT (10) DEFAULT 0 NOT NULL,
  loglevel TINYINT (1) DEFAULT 0 NOT NULL,
  logaction VARCHAR (20) NOT NULL,
  logcontent VARCHAR (250) NOT NULL,
  loguser VARCHAR (40) NOT NULL,
  logip VARCHAR (64) NOT NULL,
  logtime BIGINT (13) DEFAULT 0 NOT NULL,
  PRIMARY KEY(id),
  INDEX(loglevel,logaction,loguser)
) TYPE=MyISAM;

CREATE TABLE lybbs_item (
  id tinyint(3) default 0 NOT NULL,
  itemname varchar(200) default '' NOT NULL,
  itemprice smallint(5) default 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE lybbs_item_apply (
  id int(10) default 0 NOT NULL,
  itemid tinyint(3) default 0 NOT NULL,
  authorid int(10) default 0 NOT NULL,
  author varchar(40) default '' NOT NULL,
  applyat bigint(13) default 0 NOT NULL,
  applystatus tinyint(1) default 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE lybbs_postvalidate (
  id INT (10) DEFAULT 0 NOT NULL, forum SMALLINT (4) DEFAULT 0 NOT NULL, db SMALLINT (4) DEFAULT 0 NOT NULL, orderby INT (10) DEFAULT 0 NOT NULL, parentid INT (10) DEFAULT 0 NOT NULL, titleimage VARCHAR (20) DEFAULT '' NOT NULL, authorid INT (10) DEFAULT 0 NOT NULL, author VARCHAR (30) DEFAULT '' NOT NULL, title VARCHAR (80) DEFAULT '' NOT NULL, postat DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL, ipfrom VARCHAR (64) DEFAULT '' NOT NULL, accessary CHAR (1) DEFAULT '0' NOT NULL, accessaryname VARCHAR(80) DEFAULT '' NOT NULL, vote CHAR (1) DEFAULT '0' NOT NULL, viewmode TINYINT (2) DEFAULT 0 NOT NULL, viewnumber SMALLINT (5) DEFAULT 0 NOT NULL, votecondition TINYINT (2) DEFAULT 0 NOT NULL, replynum INT(8) DEFAULT 0 NOT NULL,votenum INT(8) DEFAULT 0 NOT NULL,lastauthorid INT(10) DEFAULT 0 NOT NULL,lastauthor VARCHAR(30) DEFAULT '' NOT NULL,lastpostat BIGINT(13) DEFAULT 0 NOT NULL,lastpostclue VARCHAR(80) DEFAULT '' NOT NULL,
  PRIMARY KEY(id), 
  INDEX(db,parentid)
) TYPE=MyISAM;

CREATE TABLE lybbs_postdelete (
  id INT (10) DEFAULT 0 NOT NULL, forum SMALLINT (4) DEFAULT 0 NOT NULL, db SMALLINT (4) DEFAULT 0 NOT NULL, orderby INT (10) DEFAULT 0 NOT NULL, parentid INT (10) DEFAULT 0 NOT NULL, titleimage VARCHAR (20) DEFAULT '' NOT NULL, authorid INT (10) DEFAULT 0 NOT NULL, author VARCHAR (30) DEFAULT '' NOT NULL, title VARCHAR (80) DEFAULT '' NOT NULL, postat DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL, ipfrom VARCHAR (64) DEFAULT '' NOT NULL, accessary CHAR (1) DEFAULT '0' NOT NULL,accessaryname VARCHAR(80) DEFAULT '' NOT NULL, vote CHAR (1) DEFAULT '0' NOT NULL, viewmode TINYINT (2) DEFAULT 0 NOT NULL, viewnumber SMALLINT (5) DEFAULT 0 NOT NULL, votecondition TINYINT (2) DEFAULT 0 NOT NULL, replynum INT(8) DEFAULT 0 NOT NULL,votenum INT(8) DEFAULT 0 NOT NULL,lastauthorid INT(10) DEFAULT 0 NOT NULL,lastauthor VARCHAR(30) DEFAULT '' NOT NULL,lastpostat BIGINT(13) DEFAULT 0 NOT NULL,lastpostclue VARCHAR(80) DEFAULT '' NOT NULL,content TEXT NOT NULL,
  PRIMARY KEY(id), 
  INDEX(db,parentid)
) TYPE=MyISAM;

CREATE TABLE lyblog_album (
  id int(10) NOT NULL default '0',
  blogid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  dirid int(10) NOT NULL default '0',
  filename varchar(80) NOT NULL default '',
  filerealname varchar(100) NOT NULL default '',
  fileext varchar(40) NOT NULL default '',
  filesize int(10) NOT NULL default '0',
  filezoompath varchar(200) NOT NULL default '',
  filepath varchar(200) NOT NULL default '',
  uploadat bigint(14) NOT NULL default '0',
  orderby int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY blogid (blogid),
  KEY userid (userid),
  KEY dirid (dirid)
) TYPE=MyISAM;

CREATE TABLE lyblog_album_dir (
  id int(10) NOT NULL default '0',
  parentid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  dirname varchar(100) NOT NULL default '',
  dirdescription varchar(255) NOT NULL default '',
  dirtype tinyint(1) NOT NULL default '0',
  dirpass varchar(60) NOT NULL default '',
  dirimg varchar(200) NOT NULL default '',
  dircount int(10) NOT NULL default '0',
  createat bigint(14) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY userid (userid)
) TYPE=MyISAM;

CREATE TABLE lyblog_blog (
  id int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  domain varchar(40) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  description varchar(250) NOT NULL default '',
  bgpic varchar(100) NOT NULL default '',
  commentenabled tinyint(1) NOT NULL default '0',
  msgenabled tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY userid (userid),
  KEY ix_blog_domain (domain)
) TYPE=MyISAM;

CREATE TABLE lyblog_catalog (
  id int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  blogid int(10) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  PRIMARY KEY  (id,blogid),
  KEY ix_catalog_blogid (blogid),
  KEY ix_catalog_userid (userid)
) TYPE=MyISAM;

CREATE TABLE lyblog_comment (
  id int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  bloguserid int(10) NOT NULL default '0',
  postid int(10) NOT NULL default '0',
  title varchar(200) NOT NULL default '',
  content text NOT NULL,
  postat bigint(14) NOT NULL default '0',
  postip varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY postid (postid),
  KEY ix_comment_bloguserid (bloguserid)
) TYPE=MyISAM;

CREATE TABLE lyblog_favorite (
  id int(10) NOT NULL default '0',
  ownerid int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  url varchar(200) NOT NULL default '',
  title varchar(200) NOT NULL default '',
  content varchar(255) NOT NULL default '',
  postat bigint(14) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY ownerid (ownerid)
) TYPE=MyISAM;

CREATE TABLE lyblog_link (
  id smallint(5) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  name varchar(80) NOT NULL default '',
  link varchar(150) NOT NULL default '',
  description varchar(200) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY ix_link_userid (userid)
) TYPE=MyISAM;

CREATE TABLE lyblog_posts (
  id int(10) NOT NULL default '0',
  userid int(10) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  blogid int(10) NOT NULL default '0',
  catalogid int(10) NOT NULL default '0',
  catalogname varchar(100) NOT NULL default '',
  title varchar(200) NOT NULL default '',
  summary text NOT NULL,
  content text NOT NULL,
  postat bigint(14) NOT NULL default '0',
  postip varchar(64) NOT NULL default '',
  commentnum smallint(5) NOT NULL default '0',
  clicknum int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY userid (userid),
  KEY blogid (blogid),
  KEY catalogid (catalogid)
) TYPE=MyISAM;