dbscript.sql

一个完整的BBS系统前台浏览和后台管理系统。基于JSP+Servlet+JavaBean MVC模式架构。

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.1.20-community-nt

--
-- Create schema bbs
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ bbs;
USE bbs;

--
-- Table structure for table `bbs`.`forum`
--

DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
  `id` int(11) NOT NULL auto_increment,
  `sort` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `description` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `bbs`.`forum`
--

INSERT INTO `forum` (`id`,`sort`,`name`,`description`) VALUES 
 (1,1,'JSP网站开发典型模块与实例精讲专区','《JSP网站开发典型模块与实例精讲》学习交流');

--
-- Table structure for table `bbs`.`topic`
--

DROP TABLE IF EXISTS `topic`;
CREATE TABLE `topic` (
  `id` int(11) NOT NULL auto_increment,
  `parentid` int(11) NOT NULL default '0',
  `forumid` int(11) NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `content` text,
  `postdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `replies` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `bbs`.`topic`
--

INSERT INTO `topic` (`id`,`parentid`,`forumid`,`username`,`title`,`content`,`postdate`,`replies`) VALUES 
 (1,0,1,'admin','jsp学习','jsp学习内容','2006-06-14 20:29:55',1),
 (2,1,1,'admin','','很好','2006-06-14 20:30:09',0);

--
-- Table structure for table `bbs`.`user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `password` varchar(20) NOT NULL default '',
  `email` varchar(100) default NULL,
  `nickname` varchar(20) NOT NULL default '',
  `degree` int(11) NOT NULL default '0',
  `registerdate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `bbs`.`user`
--

/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`,`username`,`password`,`email`,`nickname`,`degree`,`registerdate`) VALUES 
 (1,'test','test','[e-mail]','test',0,'2006-06-14 20:23:48'),
 (2,'admin','admin','[e-mail]','超级管理员',1,'2006-06-14 20:23:48');