java web项目——BBS论坛（程序源论坛）

/* Navicat MySQL Data Transfer Source Server : MySQL Source Server Version : 50615 Source Host : localhost:3306 Source Database : mrbbs Target Server Type : MYSQL Target Server Version : 50615 File Encoding : 65001 Date: 2016-12-08 11:29:21 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `base_userinfo` -- ---------------------------- DROP TABLE IF EXISTS `base_userinfo`; CREATE TABLE `base_userinfo` ( `base_id` varchar(64) NOT NULL, `base_name` varchar(10) DEFAULT NULL, `base_sex` char(10) DEFAULT NULL, `base_age` int(11) DEFAULT NULL, `base_fatieshu` int(11) DEFAULT NULL, `base_huitieshu` int(11) DEFAULT NULL, `base_photo` varchar(255) DEFAULT NULL, `base_shenfenzheng` varchar(20) DEFAULT NULL, `username` varchar(20) DEFAULT NULL, PRIMARY KEY (`base_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of base_userinfo -- ---------------------------- INSERT INTO `base_userinfo` VALUES ('1', '小明明', '男', '18', '15', '80', null, '220105198888882011', 'admin1'); INSERT INTO `base_userinfo` VALUES ('2', '明日科技', '男', '20', '20', '16', null, '111111111111111111', 'mrsoft'); INSERT INTO `base_userinfo` VALUES ('3', '明日', '男', '17', '5', '2', null, '222222222222222222', 'mingrisoft'); -- ---------------------------- -- Table structure for `forum_banzhu` -- ---------------------------- DROP TABLE IF EXISTS `forum_banzhu`; CREATE TABLE `forum_banzhu` ( `banzhu_id` int(11) NOT NULL AUTO_INCREMENT, `main_type` varchar(64) NOT NULL, `username` varchar(20) NOT NULL, `creatime` datetime NOT NULL, `creatuser` varchar(64) NOT NULL, PRIMARY KEY (`banzhu_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='版主版块对照表'; -- ---------------------------- -- Records of forum_banzhu -- ---------------------------- INSERT INTO `forum_banzhu` VALUES ('1', 'javase', 'admin1', '2016-07-05 00:00:00', 'admin1'); -- ---------------------------- -- Table structure for `forum_dictionary` -- ---------------------------- DROP TABLE IF EXISTS `forum_dictionary`; CREATE TABLE `forum_dictionary` ( `dict_id` int(11) NOT NULL AUTO_INCREMENT, `dict_group` varchar(45) DEFAULT NULL, `dict_key` varchar(45) DEFAULT NULL, `dict_value` varchar(45) DEFAULT NULL, `dict_parent` varchar(64) DEFAULT NULL, `dict_order` int(11) DEFAULT NULL, `dict_isleaf` char(1) DEFAULT NULL, PRIMARY KEY (`dict_id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of forum_dictionary -- ---------------------------- INSERT INTO `forum_dictionary` VALUES ('1', 'dict', '0', '数据字典', '0', '0', null); INSERT INTO `forum_dictionary` VALUES ('2', 'forumType', 'forumType', '论坛主版块', '1', '1', 'n'); INSERT INTO `forum_dictionary` VALUES ('3', 'forumType', 'forumJava', 'Java专区', '2', '2', 'n'); INSERT INTO `forum_dictionary` VALUES ('4', 'forumType', 'forumDB', '数据库专区', '2', '3', 'n'); INSERT INTO `forum_dictionary` VALUES ('5', 'java', 'javase', 'Java SE 专区版块', '3', '4', 'y'); INSERT INTO `forum_dictionary` VALUES ('6', 'database', 'mysql', 'MySQL', '4', '5', 'y'); INSERT INTO `forum_dictionary` VALUES ('7', 'java', 'php', 'PHP 专区版块', '3', '6', 'y'); INSERT INTO `forum_dictionary` VALUES ('8', 'java', 'net', '.Net 专区版块', '3', '7', 'y'); INSERT INTO `forum_dictionary` VALUES ('9', 'java', 'jsp', 'JSP技术专区', '3', '8', 'y'); INSERT INTO `forum_dictionary` VALUES ('10', 'fenlei', 'default', '默认', '0', '1', 'y'); INSERT INTO `forum_dictionary` VALUES ('11', 'fenlei', 'xinjishu', '新技术', '0', '2', 'y'); INSERT INTO `forum_dictionary` VALUES ('12', 'fenlei', 'xinqingtucao', '心情吐槽', '0', '3', 'y'); INSERT INTO `forum_dictionary` VALUES ('13', 'feilei', 'jishujianjie', '趋势分析', '0', '4', 'y'); INSERT INTO `forum_dictionary` VALUES ('14', 'fenlei', 'jishutuijian', '技术推荐', '0', '5', 'y'); -- ---------------------------- -- Table structure for `forum_info` -- ---------------------------- DROP TABLE IF EXISTS `forum_info`; CREATE TABLE `forum_info` ( `info_id` int(11) NOT NULL AUTO_INCREMENT, `info_reply` int(11) NOT NULL COMMENT '回复数量', `info_see` int(11) NOT NULL COMMENT '查看数', `info_lastuser` varchar(20) NOT NULL COMMENT '最后回复', `info_lastime` datetime NOT NULL COMMENT '最后回复时间', `main_id` varchar(64) NOT NULL, PRIMARY KEY (`info_id`), KEY `info_main_id_idx` (`main_id`), CONSTRAINT `info_main_id` FOREIGN KEY (`main_id`) REFERENCES `forum_main` (`main_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='记录帖子的一些常用状态.'; -- ---------------------------- -- Records of forum_info -- ---------------------------- INSERT INTO `forum_info` VALUES ('55', '0', '0', '于国良', '2016-10-10 15:59:08', '874a3c5e-a7c1-4c40-8699-6ebf780250b3'); INSERT INTO `forum_info` VALUES ('56', '1', '0', '于国良', '2016-10-10 16:10:51', '498cf08b-3fdd-4a86-898a-47fb56463aa8'); INSERT INTO `forum_info` VALUES ('57', '0', '0', '于国良', '2016-10-10 16:15:23', 'c8eb9513-1ebc-4f11-baf5-556cc20ca1c4'); INSERT INTO `forum_info` VALUES ('58', '1', '0', '于国良', '2016-10-10 16:17:35', 'b90d6d9e-a31c-4609-9329-455e94ac5277'); INSERT INTO `forum_info` VALUES ('59', '0', '0', '于国良', '2016-10-10 16:19:57', '8d0f8371-e384-4d7e-8858-657b4cf1d88b'); INSERT INTO `forum_info` VALUES ('60', '1', '0', '明日', '2016-11-17 13:39:22', '6eee1fd4-3ca6-46fb-ba4a-cda8efe450b3'); INSERT INTO `forum_info` VALUES ('61', '0', '0', '于国良', '2016-10-10 16:25:05', '19eb01fc-60d4-4fbe-ba86-beef18229754'); INSERT INTO `forum_info` VALUES ('62', '0', '0', '于国良', '2016-10-10 16:25:58', 'b60a407b-4c32-4472-9011-06b8f62b8fed'); INSERT INTO `forum_info` VALUES ('63', '0', '0', '于国良', '2016-10-10 16:26:49', '00f8fbcc-10ae-4c03-bab8-a90a0c1253d6'); INSERT INTO `forum_info` VALUES ('64', '0', '0', '于国良', '2016-10-10 16:27:48', '417bc4c6-11f7-4f8a-9352-5e0b69815c95'); INSERT INTO `forum_info` VALUES ('65', '0', '0', '于国良', '2016-10-10 16:33:06', 'd32b060e-128e-420f-b33d-6fc09a1c41b9'); INSERT INTO `forum_info` VALUES ('66', '0', '0', '于国良', '2016-10-10 16:34:48', 'f5645146-a783-45f4-b3a4-8ceb2676a41d'); INSERT INTO `forum_info` VALUES ('67', '1', '0', '于国良', '2016-10-10 16:36:52', 'aa9eaf58-fa8c-4095-bdb3-01fadd8b83fd'); INSERT INTO `forum_info` VALUES ('68', '2', '0', '明日科技', '2016-11-16 10:34:43', '8c6ba414-6c52-42f7-a2e4-7ea1a3357af1'); INSERT INTO `forum_info` VALUES ('69', '3', '0', '明日科技', '2016-11-10 13:58:35', '59c5318e-06cc-4ecc-b4e1-daf27339fc07'); INSERT INTO `forum_info` VALUES ('70', '0', '0', '于国良', '2016-10-10 16:41:09', 'a3b24a4e-1457-4374-b8a1-f075724f55db'); INSERT INTO `forum_info` VALUES ('71', '0', '0', '于国良', '2016-10-31 09:28:23', '030c72c0-b685-4e4e-994d-2f86a456b7f5'); INSERT INTO `forum_info` VALUES ('72', '0', '0', '于国良', '2016-11-08 15:21:38', '50ab643b-f7db-4c8b-8f88-0006bb290bd4'); INSERT INTO `forum_info` VALUES ('73', '1', '0', '于国良', '2016-11-08 15:25:50', 'f42729ca-ebab-48db-9fe5-579de25ab8e8'); INSERT INTO `forum_info` VALUES ('74', '0', '0', '于国良', '2016-11-09 13:46:14', '64e59ecb-8de4-4822-b72b-710e4945805b'); INSERT INTO `forum_info` VALUES ('75', '0', '0', '于国良', '2016-11-09 13:46:24', '277d0d20-8059-4958-b19e-83736c0e70dc'); INSERT INTO `forum_info` VALUES ('76', '0', '0', '明日科技', '2016-11-10 13:14:52', '026c7111-8904-4245-b9a4-d1f949a91097'); INSERT INTO `forum_info` VALUES ('77', '1', '0', '明日', '2016-11-17 13:32:10', 'b61a76a9-f9e2-49d7-a0cc-86324051c8c3'); INSERT INTO `forum_info` VALUES ('78', '0', '0', '明日', '2016-11-17 13:40:17', '897