bbs.sql

质量越高得到的下载个数越多防卡死了几分鞍山市反反复复反反复复

/*
SQLyog Enterprise Trial - MySQL GUI v6.04
Host - 5.0.45-community-nt : Database - bbs
*********************************************************************
Server version : 5.0.45-community-nt
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `bbs`;

USE `bbs`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `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;

/*Data for the table `forum` */

insert  into `forum`(`id`,`forumname`,`manager`) values (1,'发言权','aaa'),(2,'革命胜利',''),(3,'PPP','');

/*Table structure for table `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;

/*Data for the table `response` */

insert  into `response`(`id`,`title`,`content`,`author`,`submittime`,`topicid`) values (1,'是这种运动啊','人员填写完用户名及密码后','ccc','2007-07-28',1),(2,'可以吗','必须一致，对话框、文本框、下拉列表框、按钮及下拉菜','ccc','2007-07-28',1);

/*Table structure for table `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;

/*Data for the table `topic` */

insert  into `topic`(`id`,`title`,`content`,`author`,`submittime`,`forumid`) values (1,'湖体运动','在某一话题的帖子列表页面中，注册用户可以单击页面右上角的回复主题链接，以发表相对于该主题的回复','ccc','2007-06-28',1);

/*Table structure for table `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;

/*Data for the table `user` */

insert  into `user`(`username`,`password`,`sex`,`email`,`icq`,`signature`,`grade`) values ('aaa','aaa','','','','','admin'),('bbb','bbb','0','a@b.c','','','banzhu'),('ccc','ccc','0','a@b.c','','','user'),('ddd','ddd','0','a@b.c','','','banzhu');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;