/*
MySQL Data Transfer
Source Host: localhost
Source Database: bbs
Target Host: localhost
Target Database: bbs
Date: 2011/1/6 11:00:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for forum
-- ----------------------------
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`id` int(4) NOT NULL,
`forumname` varchar(20) NOT NULL,
`manager` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for response
-- ----------------------------
DROP TABLE IF EXISTS `response`;
CREATE TABLE `response` (
`id` int(4) NOT NULL,
`title` varchar(300) NOT NULL,
`content` text,
`author` varchar(20) NOT NULL,
`submittime` date NOT NULL,
`topicid` int(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for topic
-- ----------------------------
DROP TABLE IF EXISTS `topic`;
CREATE TABLE `topic` (
`id` int(4) NOT NULL,
`title` varchar(300) NOT NULL,
`content` text,
`author` varchar(20) NOT NULL,
`submittime` date NOT NULL,
`forumid` int(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`username` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`sex` varchar(2) NOT NULL,
`email` varchar(50) NOT NULL,
`icq` varchar(20) default NULL,
`signature` varchar(300) default NULL,
`grade` varchar(20) default NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `forum` VALUES ('1', '发言权', 'aaa');
INSERT INTO `forum` VALUES ('2', '革命胜利', '');
INSERT INTO `forum` VALUES ('3', 'PPP', '');
INSERT INTO `response` VALUES ('1', '是这种运动啊', '人员填写完用户名及密码后', 'ccc', '2007-07-28', '1');
INSERT INTO `response` VALUES ('2', '可以吗', '必须一致,对话框、文本框、下拉列表框、按钮及下拉菜', 'ccc', '2007-07-28', '1');
INSERT INTO `topic` VALUES ('1', '湖体运动', '在某一话题的帖子列表页面中,注册用户可以单击页面右上角的回复主题链接,以发表相对于该主题的回复', 'ccc', '2007-06-28', '1');
INSERT INTO `user` VALUES ('aaa', 'aaa', '', '', '', '', 'admin');
INSERT INTO `user` VALUES ('bbb', 'bbb', '0', 'a@b.c', '', '', 'banzhu');
INSERT INTO `user` VALUES ('ccc', 'ccc', '0', 'a@b.c', '', '', 'user');
INSERT INTO `user` VALUES ('ddd', 'ddd', '0', 'a@b.c', '', '', 'banzhu');