DROP TABLE IF EXISTS bbs1;
CREATE TABLE bbs1 (
AnnounceID int(11) NOT NULL auto_increment,
ParentID int(11) NOT NULL default '0',
Child int(11) NOT NULL default '0',
BoardID int(11) NOT NULL default '0',
UserName varchar(50) NOT NULL default '',
UserEmail varchar(255) NOT NULL default '',
Topic varchar(255) NOT NULL default '',
Body text NOT NULL,
DateAndTime datetime NOT NULL default '0000-00-00 00:00:00',
hits int(11) NOT NULL default '0',
length int(11) NOT NULL default '0',
RootID int(11) NOT NULL default '0',
layer int(11) NOT NULL default '0',
orders int(11) NOT NULL default '0',
isbest int(11) NOT NULL default '0',
ip varchar(20) NOT NULL default '',
Expression varchar(255) NOT NULL default '',
times int(11) NOT NULL default '0',
locktopic int(11) NOT NULL default '0',
signflag int(11) NOT NULL default '0',
emailflag int(11) NOT NULL default '0',
istop int(11) NOT NULL default '0',
isvote int(11) NOT NULL default '0',
PRIMARY KEY (AnnounceID),
KEY boardbbs1(BoardID)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `bbslink`
#
DROP TABLE IF EXISTS bbslink;
CREATE TABLE bbslink (
id int(11) NOT NULL auto_increment,
boardname char(50) NOT NULL default '',
readme char(255) NOT NULL default '',
url char(150) NOT NULL default '',
KEY id(id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `bbsnews`
#
DROP TABLE IF EXISTS bbsnews;
CREATE TABLE bbsnews (
id int(11) NOT NULL auto_increment,
boardid int(11) NOT NULL default '0',
title varchar(50) NOT NULL default '',
content text NOT NULL,
username varchar(50) NOT NULL default '',
addtime datetime NOT NULL default '0000-00-00 00:00:00',
KEY bbsnewsboardid(boardid),
KEY id(id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `board`
#
DROP TABLE IF EXISTS board;
CREATE TABLE board (
boardid int(11) NOT NULL default '0',
BoardType varchar(50) NOT NULL default '',
class int(11) NOT NULL default '0',
readme varchar(255) NOT NULL default '',
BoardMaster varchar(50) NOT NULL default '',
lockboard int(11) NOT NULL default '0',
boardskin int(11) NOT NULL default '0',
Tableback varchar(50) NOT NULL default '',
Tabletitle varchar(50) NOT NULL default '',
Tablebody varchar(50) NOT NULL default '',
aTablebody varchar(50) NOT NULL default '',
TableFont varchar(50) NOT NULL default '',
TableContent varchar(50) NOT NULL default '',
AlertFont varchar(50) NOT NULL default '',
lastpostuser varchar(50) NOT NULL default '',
lastposttime datetime NOT NULL default '0000-00-00 00:00:00',
lastbbsnum int(11) NOT NULL default '0',
lasttopicnum int(11) NOT NULL default '0',
strAllowForumCode int(11) NOT NULL default '0',
strAllowHTML int(11) NOT NULL default '0',
strIMGInPosts int(11) NOT NULL default '0',
strIcons int(11) NOT NULL default '0',
strflash int(11) NOT NULL default '0',
Forumlogo varchar(255) NOT NULL default '',
indexIMG varchar(255) NOT NULL default '',
lastrootid int(11) NOT NULL default '0',
lasttopic varchar(255) NOT NULL default '',
todayNum int(11) NOT NULL default '0',
boarduser text NOT NULL,
PRIMARY KEY (boardid)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `bookmark`
#
DROP TABLE IF EXISTS bookmark;
CREATE TABLE bookmark (
id int(11) NOT NULL auto_increment,
username varchar(50) NOT NULL default '',
url varchar(100) default NULL,
topic varchar(100) default NULL,
addtime varchar(19) default NULL,
KEY bookmarkUserName(username),
KEY id(id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `class`
#
DROP TABLE IF EXISTS class;
CREATE TABLE class (
id int(11) NOT NULL default '0',
class char(50) NOT NULL default ''
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `config`
#
DROP TABLE IF EXISTS config;
CREATE TABLE config (
ForumName varchar(20) NOT NULL default '',
ForumURL varchar(100) NOT NULL default '',
CompanyName varchar(40) NOT NULL default '',
HostUrl varchar(100) NOT NULL default '',
SMTPServer varchar(100) NOT NULL default '',
SystemEmail varchar(50) NOT NULL default '',
TimeAdjust varchar(10) NOT NULL default '',
ScriptTimeOut varchar(10) NOT NULL default '',
Logo varchar(100) NOT NULL default '',
Picurl varchar(50) NOT NULL default '',
Faceurl varchar(50) NOT NULL default '',
EmailFlag int(11) NOT NULL default '0',
Uploadpic int(11) NOT NULL default '0',
IpFlag int(11) NOT NULL default '0',
FromFlag int(11) NOT NULL default '0',
guestuser int(11) NOT NULL default '0',
guestlogin int(11) NOT NULL default '0',
openmsg varchar(20) NOT NULL default '',
badwords varchar(255) NOT NULL default '',
AnnounceMaxBytes varchar(20) NOT NULL default '',
MaxAnnouncePerPage varchar(15) NOT NULL default '',
Maxtitlelist varchar(15) NOT NULL default '',
Tablebackcolor varchar(15) NOT NULL default '',
aTablebackcolor varchar(15) NOT NULL default '',
Tabletitlecolor varchar(15) NOT NULL default '',
aTabletitlecolor varchar(15) NOT NULL default '',
Tablebodycolor varchar(15) NOT NULL default '',
aTablebodycolor varchar(15) NOT NULL default '',
TableFontcolor varchar(15) NOT NULL default '',
TableContentcolor varchar(15) NOT NULL default '',
AlertFontColor varchar(15) NOT NULL default '',
ContentTitle varchar(15) NOT NULL default '',
ads1 text NOT NULL,
ads2 text NOT NULL,
Copyright varchar(255) NOT NULL default '',
Version varchar(255) NOT NULL default '',
TitleFlag tinyint(3) unsigned NOT NULL default '0',
uploadFlag tinyint(3) unsigned NOT NULL default '0',
wealthReg int(11) NOT NULL default '0',
wealthAnnounce int(11) NOT NULL default '0',
wealthReannounce int(11) NOT NULL default '0',
wealthDel int(11) NOT NULL default '0',
wealthLogin int(11) NOT NULL default '0',
epReg int(11) NOT NULL default '0',
epAnnounce int(11) NOT NULL default '0',
epReannounce int(11) NOT NULL default '0',
epDel int(11) NOT NULL default '0',
epLogin int(11) NOT NULL default '0',
cpReg int(11) NOT NULL default '0',
cpAnnounce int(11) NOT NULL default '0',
cpReannounce int(11) NOT NULL default '0',
cpDel int(11) NOT NULL default '0',
cpLogin int(11) NOT NULL default '0',
TopicNum int(11) NOT NULL default '0',
BbsNum int(11) NOT NULL default '0',
TodayNum int(11) NOT NULL default '0',
UserNum int(11) NOT NULL default '0',
lastUser varchar(50) NOT NULL default '',
cookiepath varchar(50) NOT NULL default '',
Maxonline int(11) NOT NULL default '0',
MaxonlineDate varchar(50) NOT NULL default ''
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `friend`
#
DROP TABLE IF EXISTS friend;
CREATE TABLE friend (
F_id int(11) NOT NULL auto_increment,
F_username varchar(50) default NULL,
F_friend varchar(50) default NULL,
F_addtime varchar(19) default NULL,
KEY F_id(F_id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `log`
#
DROP TABLE IF EXISTS log;
CREATE TABLE log (
l_id int(11) NOT NULL auto_increment,
l_username varchar(50) default NULL,
l_content varchar(50) default NULL,
l_url varchar(255) default NULL,
l_addtime varchar(19) default NULL,
KEY l_id(l_id)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# 数据表的结构 `message`
#
DROP TABLE IF EXISTS message;
CREATE TABLE message (
id int(11) NOT NULL auto_increment,
sender varchar(50) default NULL,
incept varchar(50) default NULL,
title varchar(100) default NULL,
content text,
flag
jsp+mysql+javabean开发的鲤鱼论坛 BBS v1.0(附源码)
4星 · 超过85%的资源 需积分: 10 13 浏览量
2008-11-29
22:44:26
上传
评论 1
收藏 5.67MB RAR 举报 
jsp+mysql+javabean开发的鲤鱼论坛 BBS v1.0(附源码) （584个子文件） 
AddressTable1.class 91KB AddressTable0.class 85KB IPTable1.class 69KB IPTable2.class 68KB IPTable0.class 67KB _announce__jsp.class 63KB IPTable3.class 63KB _usersms__jsp.class 50KB _dispbbs__jsp.class 42KB _list__jsp.class 40KB _elist__jsp.class 37KB _index__jsp.class 34KB _admin_0board__jsp.class 33KB Forum.class 27KB _admin_0var__jsp.class 25KB _toplist__jsp.class 24KB _favlist__jsp.class 23KB _query__jsp.class 23KB _reg_01__jsp.class 23KB _admin_0link__jsp.class 22KB _chklogin__jsp.class 20KB _login__jsp.class 19KB _saveannounce__jsp.class 19KB _reg__jsp.class 19KB _admin_0wealth__jsp.class 18KB _admin_0user__jsp.class 17KB ForumMSGAdmin.class 16KB SqlQuery.class 14KB _admin_0updateboard__jsp.class 14KB _admin_0main__jsp.class 13KB _elogin__jsp.class 13KB ForumAdmin.class 12KB SMSManager.class 11KB UserManager.class 11KB User.class 10KB SkinUtil.class 10KB ForumFactory.class 9KB StringUtil.class 9KB ForumPropertiesManager.class 9KB MD5.class 8KB CodeViewer.class 7KB DBConnectionManager.class 7KB ForumMSG.class 7KB SysUtil.class 7KB ForumSearch.class 6KB _stat__jsp.class 6KB DBUtil.class 5KB OLUser.class 5KB ForumNewsAdmin.class 4KB FriendsManager.class 4KB ObjectFilter.class 4KB IPLocalizer.class 4KB StringUtils.class 4KB DBConnect.class 4KB DBConnectionManager$DBConnectionPool.class 4KB DateUtil.class 4KB EHCacheImpl.class 4KB ForumBookMark.class 3KB C3P0Connect.class 3KB ForumTopic.class 3KB BBSFilter.class 3KB OSCacheImpl.class 3KB ForumMSGPacker.class 3KB MarkerFilter.class 3KB Format.class 3KB SystemConfig.class 3KB ForumNewsManager.class 3KB SMSMSG.class 3KB CSSFilter.class 3KB ForumLinkAdmin.class 2KB Log.class 2KB ProxoolConnect.class 2KB GateWayFactory.class 2KB DBCPConnect.class 2KB ForumVote.class 2KB OLUserManager.class 2KB FontFilter.class 2KB ForumNews.class 2KB URLFilter.class 2KB TextStyleFilter.class 2KB ForumLinkFactory.class 2KB myTest.class 2KB AutoFilter.class 2KB FlashFilter.class 2KB MyFilter.class 2KB GCookie.class 2KB ubbTest.class 2KB ParamUtil.class 2KB Friend.class 2KB CodeFilter.class 2KB EmailFilter.class 2KB JNDIConnect.class 2KB IMGFilter.class 2KB ColorFilter.class 2KB CacheFactory.class 1KB DBFactory.class 1KB ForumTopicNotFoundException.class 1KB UserAlreadyExistException.class 1KB ForumNewsNotFoundException.class 1KB ForumLinkNotFoundException.class 1KB共 584 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
cainiaoliulanggou2014-02-25配置的过程的写的好简单啊，有点小迷惑
muguangkui
- 粉丝: 14
- 资源: 319
最新资源
- 基于CarNet实现裂缝检测python源码+文档说明+数据+图片(课程设计)
- 课程设计-基于耐火材料裂缝剥落检测python源码+课件
- 基于OpenCV的视频道路车道检测python源码+文档说明+实验演示+图片+使用方法(高分毕业设计)
- 基于OpenCV的案例:图像边缘、角点和轮廓检测，图像分割，图像增强;图片拼接；运动目标检测，颜色直方图比较，三帧帧差法，抠图
- SmartPlug-html大一笔记
- SmartPlug-proteusdemo
- Preliminary Findings on Handmade Rattan Baby Crib andBassinet Designs Regarding.zip
- aveebfq_v1.2.83_downyi.com.apk
- 基于有机发光二极管(OLED)的建模优化算法的matlab仿真源码+数据+文档说明+项目说明(高分课程设计)
- hash01-test.c 本人哈希表（一）的示例代码，仅供参考！
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
