SSH+mysql制作BBS

/* MySQL Data Transfer Source Host: localhost Source Database: mybbs Target Host: localhost Target Database: mybbs Date: 2012/6/15 13:12:34 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL, `account` varchar(15) NOT NULL, `password` varchar(20) NOT NULL, `qx` int(11) NOT NULL, `nickName` varchar(10) DEFAULT NULL, `name` varchar(10) DEFAULT NULL, `photoPath` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Table structure for board -- ---------------------------- DROP TABLE IF EXISTS `board`; CREATE TABLE `board` ( `id` int(11) NOT NULL, `parentId` int(11) DEFAULT NULL, `aid` int(11) NOT NULL, `name` varchar(20) NOT NULL, `description` varchar(50) DEFAULT NULL, `boardImg` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK598EEE623006E2D` (`parentId`), KEY `FK598EEE6DCE3688D` (`aid`), CONSTRAINT `FK598EEE623006E2D` FOREIGN KEY (`parentId`) REFERENCES `board` (`id`), CONSTRAINT `FK598EEE6DCE3688D` FOREIGN KEY (`aid`) REFERENCES `admin` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Table structure for post -- ---------------------------- DROP TABLE IF EXISTS `post`; CREATE TABLE `post` ( `id` int(11) NOT NULL, `aid` int(11) DEFAULT NULL, `sid` int(11) DEFAULT NULL, `bid` int(11) NOT NULL, `name` varchar(40) NOT NULL, `content` varchar(255) DEFAULT NULL, `publishTime` datetime DEFAULT NULL, `count` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK3498A0DCF657E5` (`bid`), KEY `FK3498A011328B` (`sid`), KEY `FK3498A0DCE3688D` (`aid`), CONSTRAINT `FK3498A011328B` FOREIGN KEY (`sid`) REFERENCES `student` (`id`), CONSTRAINT `FK3498A0DCE3688D` FOREIGN KEY (`aid`) REFERENCES `admin` (`id`), CONSTRAINT `FK3498A0DCF657E5` FOREIGN KEY (`bid`) REFERENCES `board` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Table structure for reply -- ---------------------------- DROP TABLE IF EXISTS `reply`; CREATE TABLE `reply` ( `id` int(11) NOT NULL, `aid` int(11) DEFAULT NULL, `sid` int(11) DEFAULT NULL, `pid` int(11) NOT NULL, `content` varchar(255) NOT NULL, `publishTime` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK67612EA11328B` (`sid`), KEY `FK67612EADCE3688D` (`aid`), CONSTRAINT `FK67612EA11328B` FOREIGN KEY (`sid`) REFERENCES `student` (`id`), CONSTRAINT `FK67612EADCE3688D` FOREIGN KEY (`aid`) REFERENCES `admin` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Table structure for student -- ---------------------------- DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `id` int(11) NOT NULL, `stuNum` varchar(15) NOT NULL, `realName` varchar(10) DEFAULT NULL, `nickName` varchar(20) DEFAULT NULL, `password` varchar(20) NOT NULL, `qq` varchar(20) DEFAULT NULL, `email` varchar(30) DEFAULT NULL, `major` varchar(20) DEFAULT NULL, `className` varchar(20) DEFAULT NULL, `photoPath` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `admin` VALUES ('1', 'cs', 'cs', '1', 'aaaa', 'cs', 'cs'); INSERT INTO `admin` VALUES ('2', 'c', 'c', '1', 'c', 'c', 'c'); INSERT INTO `board` VALUES ('1', '1', '1', '学生论坛', '这里，你可以尽情的发表你的看法', '1'); INSERT INTO `board` VALUES ('2', '2', '1', '教师论坛', '这里有老师为你提供在线答疑', '1'); INSERT INTO `board` VALUES ('3', '2', '1', '灌水区', '你可以随便发言论', '1'); INSERT INTO `board` VALUES ('4', '3', '1', '哇哈哈', '喝哇哈哈啊', '1'); INSERT INTO `board` VALUES ('5', '4', '1', '手机软件下载', '孜阿坝是，下吧下吧，多下点', '1'); INSERT INTO `board` VALUES ('6', '4', '1', '游戏专区', '各种游戏 ，蛮好玩', '1'); INSERT INTO `board` VALUES ('7', '5', '1', '娱乐专区', '这里有各种各样的娱乐新闻', '1'); INSERT INTO `board` VALUES ('8', null, '1', '234234', '546546', null); INSERT INTO `board` VALUES ('10', null, '1', 'werwe', 'werewr', null); INSERT INTO `board` VALUES ('11', null, '1', '23542354', 'efwerewr', null); INSERT INTO `board` VALUES ('12', null, '1', '234234', '235423534', null); INSERT INTO `board` VALUES ('13', null, '1', 'asdasd', 'asdasd', null); INSERT INTO `board` VALUES ('14', null, '1', 'werwer', 'werwerwe', null); INSERT INTO `post` VALUES ('3', null, '1', '3', 'tertiary而特二', '而特二', '2012-06-12 16:57:51', '234'); INSERT INTO `post` VALUES ('5', null, '1', '5', '哈户数', '神鼎飞丹砂对', '2012-06-04 19:35:23', '43'); INSERT INTO `post` VALUES ('6', null, '1', '4', 'qweqweqwe', 'qweqweqweqwe', '2012-06-05 17:57:23', '12'); INSERT INTO `post` VALUES ('7', null, '1', '2', 'werwer', '<img border=\"0\" alt=\"\" src=\"kindeditor/plugins/emoticons/0.gif\" width=\"24\" height=\"24\" />fgetr', '2012-05-29 17:57:27', '123'); INSERT INTO `post` VALUES ('8', null, '1', '2', 'qweqe', '而特而特而特', '2012-06-04 17:57:30', '123'); INSERT INTO `post` VALUES ('9', null, null, '1', '璁や负 ', '<p>sdfsdfsdf</p>', null, null); INSERT INTO `post` VALUES ('10', '1', null, '1', '体育 体育体育', '而特恩恩让人听而特', '2012-01-04 22:28:48', '345'); INSERT INTO `post` VALUES ('11', '1', null, '1', 'werwer', 'qweqw', '2012-05-30 22:29:09', '567'); INSERT INTO `post` VALUES ('12', '1', null, '1', 'iiiiiiiiiiiii', 'llllllllloooooooooooo', '2012-06-13 22:28:53', '345'); INSERT INTO `post` VALUES ('13', '1', null, '1', '儿童儿童', '55555555', '2012-06-23 22:28:57', '567'); INSERT INTO `post` VALUES ('14', '1', null, '1', 'uuuuu', '鄂尔泰而特', '2012-06-29 22:28:44', '567'); INSERT INTO `post` VALUES ('15', '1', null, '1', 'sssss', 'sssssssss', '2012-05-27 22:29:01', '345567'); INSERT INTO `post` VALUES ('16', '1', null, '1', '与体育', '儿童儿童', '2012-06-12 22:28:41', '567'); INSERT INTO `post` VALUES ('17', '1', null, '1', '日语如', '电饭锅而过', '2012-06-20 22:29:07', '567'); INSERT INTO `post` VALUES ('18', '1', null, '1', '如啼眼日语', '666666', '2012-06-26 22:29:14', '5434'); INSERT INTO `post` VALUES ('19', '1', null, '1', '如啼眼 ', '而特而特二', '2012-06-26 22:29:17', '567'); INSERT INTO `post` VALUES ('20', '1', null, '1', '风光好飞 ', '而特而特而特', '2012-06-02 22:29:21', '34'); INSERT INTO `post` VALUES ('21', '1', null, '2', '反光镜和风格', '而特而特而特', '2012-06-26 22:28:33', '54654'); INSERT INTO `post` VALUES ('22', '1', null, '1', '预警航天员', '6565656<img border=\"0\" alt=\"\" src=\"kindeditor/plugins/emoticons/47.gif\" width=\"24\" height=\"24\" />', '2012-06-19 22:28:29', '657'); INSERT INTO `post` VALUES ('23', '1', null, '1', '为娃儿娃儿', '<img border=\"0\" alt=\"\" src=\"kindeditor/plugins/emoticons/0.gif\" width=\"24\" height=\"24\" />', '2012-06-04 22:28:26', '534'); INSERT INTO `post` VALUES ('31', null, null, '1', 'werwerw', '<p>aaaaassdsfsfsdf</p>', null, null); INSERT INTO `post` VALUES ('32', '1', null, '3', 'uyiuyiuy', 'kuyiuyi<img border=\"0\" alt=\"\" src=\"kindeditor/plugins/emoticons/0.gif\" width=\"24\" height=\"24\" />', null, null); INSERT INTO `post` VALUES ('33', '1', null, '1', '45984984984', '65496498498', null, null); INSERT INTO `post` VALUES ('34', '1', null, '1', '45984984984', '65496498498', null, null); INSERT INTO `post` VALUES ('37', '1', null, '11', 'asdasdasd', 'asdasdas', '2012-06-15 00:05:12', null); INSERT INTO `post` VALUES ('38', '1', null, '1', 'werwer', 'werwerwer', '2012-06-15 00:18:14', null); INSERT INTO `post` VALUES ('39', '1', null, '1', 'werwer', 'werwerwrwer', '2012-06-15 00:40:49', null); INSERT INTO `post` VALUE