📄 lybbs_mysql.sql
字号:
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 '',
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 topicid (topicid),
KEY authorid (authorid),
KEY postat (postat)
) TYPE=MyISAM;
CREATE TABLE lybbs_postrecycle (
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,
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 '',
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 topicid (topicid),
KEY authorid (authorid),
KEY postat (postat)
) TYPE=MyISAM;
#
# 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)
) 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)
) TYPE=MyISAM;
#
# 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 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'
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -