jsp版鲤鱼论坛mysql4.0+tomcat.rar

# MySQL-Front 3.2 (Build 14.8) # Host: . Database: forum # ------------------------------------------------------ # Server version 4.0.24-nt DROP DATABASE IF EXISTS `forum`; CREATE DATABASE `forum`; USE `forum`; # # Table structure for table liyunet_bbs1 # CREATE TABLE `liyunet_bbs1` ( `AnnounceID` int(11) NOT NULL auto_increment, `ParentID` int(11) default '0', `Child` int(11) default '0', `BoardID` int(11) default '0', `UserName` varchar(50) default NULL, `UserEmail` varchar(255) default NULL, `Topic` varchar(255) default NULL, `Body` text, `DateAndTime` datetime default NULL, `hits` int(11) default '0', `length` int(11) default '0', `RootID` int(11) default '0', `layer` int(11) default '0', `orders` int(11) default '0', `isbest` smallint(6) default '0', `ip` varchar(20) default NULL, `Expression` varchar(100) default NULL, `times` int(11) default '0', `locktopic` smallint(6) default '0', `signflag` smallint(6) default '0', `emailflag` smallint(6) default '0', `istop` smallint(6) default '0', `isvote` smallint(6) default '0', `ViewMode` smallint(6) default '0', `ViewNumber` smallint(6) default '0', PRIMARY KEY (`AnnounceID`) ) TYPE=MyISAM COMMENT='论坛帖子'; # # Dumping data for table liyunet_bbs1 # # # Table structure for table liyunet_bbslink # CREATE TABLE `liyunet_bbslink` ( `id` int(11) NOT NULL auto_increment, `boardname` varchar(150) NOT NULL default '', `readme` varchar(255) NOT NULL default '', `url` varchar(150) NOT NULL default '', `logo` varchar(150) default NULL, `status` smallint(6) default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='论坛链接'; # # Dumping data for table liyunet_bbslink # # # Table structure for table liyunet_bbsnews # CREATE TABLE `liyunet_bbsnews` ( `id` int(11) NOT NULL auto_increment, `boardid` int(11) default '0', `title` varchar(200) default NULL, `content` varchar(255) default NULL, `username` varchar(50) default NULL, `addtime` datetime default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='新闻消息'; # # Dumping data for table liyunet_bbsnews # # # Table structure for table liyunet_board # CREATE TABLE `liyunet_board` ( `boardid` int(11) NOT NULL auto_increment, `BoardType` varchar(50) NOT NULL default '', `class` int(11) NOT NULL default '0', `readme` varchar(255) NOT NULL default '', `BoardMaster` varchar(50) default NULL, `lockboard` smallint(6) default '0', `boardskin` int(11) default '1', `Tableback` varchar(50) default NULL, `Tabletitle` varchar(50) default NULL, `Tablebody` varchar(50) default NULL, `aTablebody` varchar(50) default NULL, `TableFont` varchar(50) default NULL, `TableContent` varchar(50) default NULL, `AlertFont` varchar(50) default NULL, `lastpostuser` varchar(50) default NULL, `lastposttime` datetime default NULL, `lastbbsnum` int(11) default '0', `lasttopicnum` int(11) default '0', `strAllowForumCode` smallint(6) default '0', `strAllowHTML` smallint(6) default '0', `strIMGInPosts` smallint(6) default '0', `strIcons` smallint(6) default '0', `strflash` smallint(6) default '0', `Forumlogo` varchar(255) default NULL, `indexIMG` varchar(255) default NULL, `lastrootid` int(11) default '0', `lasttopic` varchar(255) default NULL, `todayNum` int(11) default '0', `boarduser` varchar(255) default NULL, PRIMARY KEY (`boardid`) ) TYPE=MyISAM COMMENT='论坛版块'; # # Dumping data for table liyunet_board # INSERT INTO `liyunet_board` VALUES (1,'网站建设',1,'网站建设技术交流区，学习的过程中有什么不懂的就来吧！','',0,1,'#0099cc','#99ccff','#f2f8ff','#FFFFFF','#000000','#000000','#ff0000','','2006-10-01 00:00:00',0,0,1,1,1,1,1,'','',0,'',0,''); INSERT INTO `liyunet_board` VALUES (2,'Java技术',1,'探讨java技术，大家共同提高。','',0,1,'#0099cc','#99ccff','#f2f8ff','#FFFFFF','#000000','#000000','#ff0000','','2006-10-01 00:00:00',0,0,1,1,1,1,1,'','',0,'',0,''); INSERT INTO `liyunet_board` VALUES (3,'鲤鱼论坛',2,'<table align=left><tr><td><img src=pic/LOGO.gif align=top></td><td width=20></td></tr></table>大家对现在用的论坛有什么发现和好的想法吗？','',0,1,'#0099cc','#99ccff','#f2f8ff','#FFFFFF','#000000','#000000','#ff0000','','2006-10-01 00:00:00',0,0,1,1,1,1,1,'','',0,'',0,''); # # Table structure for table liyunet_bookmark # CREATE TABLE `liyunet_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` datetime default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='收藏夹'; # # Dumping data for table liyunet_bookmark # # # Table structure for table liyunet_class # CREATE TABLE `liyunet_class` ( `id` int(11) NOT NULL auto_increment, `class` varchar(50) NOT NULL default '', `orders` smallint(6) default '0', `note` varchar(150) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='论坛目录'; # # Dumping data for table liyunet_class # INSERT INTO `liyunet_class` VALUES (1,'鲤鱼网络 - Carp.net.cn',0,NULL); INSERT INTO `liyunet_class` VALUES (2,'版务处理 - LiyuNet.com',0,NULL); # # Table structure for table liyunet_config # CREATE TABLE `liyunet_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(4) NOT NULL default '0', `uploadFlag` tinyint(4) 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) N