-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.0.45-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
--
-- Create schema bbs
--
CREATE DATABASE IF NOT EXISTS bbs;
USE bbs;
--
-- Definition of table `friends`
--
DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
`friendsId` int(11) NOT NULL auto_increment COMMENT '关系ID',
`anotherUserId` int(11) default NULL COMMENT '被动用户ID',
`relationSign` int(11) default NULL COMMENT '好友标记(0黑名单1好友2未确认好友)',
`user_userId` int(11) NOT NULL COMMENT '主动用户ID',
PRIMARY KEY (`friendsId`,`user_userId`),
KEY `fk_friends_user` (`user_userId`),
CONSTRAINT `fk_friends_user` FOREIGN KEY (`user_userId`) REFERENCES `user` (`userId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='关系表';
--
-- Dumping data for table `friends`
--
/*!40000 ALTER TABLE `friends` DISABLE KEYS */;
/*!40000 ALTER TABLE `friends` ENABLE KEYS */;
--
-- Definition of table `function`
--
DROP TABLE IF EXISTS `function`;
CREATE TABLE `function` (
`functionId` int(11) NOT NULL auto_increment COMMENT '功能ID',
`functionName` varchar(20) default NULL COMMENT '功能名',
`functionAdd` varchar(20) default NULL COMMENT '功能地址',
PRIMARY KEY (`functionId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312 COMMENT='功能表';
--
-- Dumping data for table `function`
--
/*!40000 ALTER TABLE `function` DISABLE KEYS */;
INSERT INTO `function` (`functionId`,`functionName`,`functionAdd`) VALUES
(1,'删除用户','delete.jsp');
/*!40000 ALTER TABLE `function` ENABLE KEYS */;
--
-- Definition of table `group`
--
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
`groupId` int(11) NOT NULL auto_increment COMMENT '组ID',
`groupName` varchar(20) default NULL COMMENT '组名',
`groupDescribe` varchar(40) default NULL COMMENT '组描述',
PRIMARY KEY (`groupId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312 COMMENT='用户组表';
--
-- Dumping data for table `group`
--
/*!40000 ALTER TABLE `group` DISABLE KEYS */;
INSERT INTO `group` (`groupId`,`groupName`,`groupDescribe`) VALUES
(1,'超级管理员','管理一切事务'),
(2,'管理员','管理除设置管理员以外的一切事务'),
(3,'版主','管理主题和回复'),
(4,'普通用户','普通功能');
/*!40000 ALTER TABLE `group` ENABLE KEYS */;
--
-- Definition of table `group_has_function`
--
DROP TABLE IF EXISTS `group_has_function`;
CREATE TABLE `group_has_function` (
`group_groupId` int(11) NOT NULL COMMENT '用户组ID',
`function_functionId` int(11) NOT NULL COMMENT '功能ID',
PRIMARY KEY (`group_groupId`,`function_functionId`),
KEY `fk_group_has_function_group` (`group_groupId`),
KEY `fk_group_has_function_function` (`function_functionId`),
CONSTRAINT `fk_group_has_function_function` FOREIGN KEY (`function_functionId`) REFERENCES `function` (`functionId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_group_has_function_group` FOREIGN KEY (`group_groupId`) REFERENCES `group` (`groupId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='用户组功能表';
--
-- Dumping data for table `group_has_function`
--
/*!40000 ALTER TABLE `group_has_function` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_has_function` ENABLE KEYS */;
--
-- Definition of table `integral`
--
DROP TABLE IF EXISTS `integral`;
CREATE TABLE `integral` (
`integralId` int(11) NOT NULL auto_increment COMMENT '积分ID',
`integralNum` int(11) default NULL COMMENT '积分',
`grade` varchar(8) default NULL COMMENT '积分等级',
PRIMARY KEY (`integralId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312 COMMENT='用户积分表';
--
-- Dumping data for table `integral`
--
/*!40000 ALTER TABLE `integral` DISABLE KEYS */;
INSERT INTO `integral` (`integralId`,`integralNum`,`grade`) VALUES
(1,100,'小兵'),
(2,300,'副班长'),
(3,500,'班长'),
(4,800,'副排长'),
(5,1100,'排长');
/*!40000 ALTER TABLE `integral` ENABLE KEYS */;
--
-- Definition of table `modright`
--
DROP TABLE IF EXISTS `modright`;
CREATE TABLE `modright` (
`modrightId` int(11) NOT NULL auto_increment COMMENT '权限ID ',
`right` tinyint(1) default '0' COMMENT '能否访问',
`module_modId` int(11) NOT NULL COMMENT '模块ID',
`group_groupId` int(11) NOT NULL COMMENT '组ID',
PRIMARY KEY (`modrightId`,`module_modId`,`group_groupId`),
KEY `fk_modright_module` (`module_modId`),
KEY `fk_modright_group` (`group_groupId`),
CONSTRAINT `fk_modright_group` FOREIGN KEY (`group_groupId`) REFERENCES `group` (`groupId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_modright_module` FOREIGN KEY (`module_modId`) REFERENCES `module` (`modId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 COMMENT='模块权限表';
--
-- Dumping data for table `modright`
--
/*!40000 ALTER TABLE `modright` DISABLE KEYS */;
/*!40000 ALTER TABLE `modright` ENABLE KEYS */;
--
-- Definition of table `module`
--
DROP TABLE IF EXISTS `module`;
CREATE TABLE `module` (
`modId` int(11) NOT NULL auto_increment COMMENT '模块ID',
`modType` varchar(30) default NULL COMMENT '论坛类型',
`modInfo` varchar(200) default NULL COMMENT '模块介绍',
`modTodayNum` smallint(6) default '0' COMMENT '模块一天的总主题数',
`modTopicNum` mediumint(9) default '0' COMMENT '模块主题总数',
`modReNum` int(11) default '0' COMMENT '模块回复总数',
`isAudit` tinyint(1) default '0' COMMENT '是否审核(false 否 true 是)',
`modState` tinyint(1) default '1' COMMENT '模块状态(1 普通模块 2 会员论坛 3 嘉宾论坛 4 加密论坛 5 关闭论坛)',
`modPwd` varchar(16) default NULL COMMENT '加密论坛的密码',
`modCreTime` datetime default NULL COMMENT '模块创建时间',
`module_modId` int(11) default NULL,
`user_userId` int(11) NOT NULL,
PRIMARY KEY (`modId`,`user_userId`),
KEY `fk_module_module` (`module_modId`),
KEY `fk_module_user` (`user_userId`),
CONSTRAINT `fk_module_module` FOREIGN KEY (`module_modId`) REFERENCES `module` (`modId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_module_user` FOREIGN KEY (`user_userId`) REFERENCES `user` (`userId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=gb2312 COMMENT='论坛模块表';
--
-- Dumping data for table `module`
--
/*!40000 ALTER TABLE `module` DISABLE KEYS */;
INSERT INTO `module` (`modId`,`modType`,`modInfo`,`modTodayNum`,`modTopicNum`,`modReNum`,`isAudit`,`modState`,`modPwd`,`modCreTime`,`module_modId`,`user_userId`) VALUES
(2,'.Net技术专区','.Net基础知识 .Net数据库编程 ASP.net C# VB.net ',0,0,0,0,NULL,NULL,NULL,NULL,1),
(3,'数据库技术专区','讨论数据库的相关技术，包括：SQL，DBMS原理，备份与恢复，数据库编程接口等',0,1,0,0,0,NULL,NULL,NULL,1),
(4,'项目实战专区','该专区会随时发布一些项目，要求同学们参与进来 ',0,0,0,0,NULL,NULL,NULL,NULL,1),
(5,'畅所欲言','怎么想怎么说 ',0,1,0,0,0,NULL,NULL,NULL,1),
(18,'asdf','dfas',0,0,0,0,NULL,NULL,NULL,NULL,2),
(22,'afsdf','fasdf',0,2,3,0,0,NULL,NULL,NULL,2),
(23,'asdfas','dfasdfa',0,0,0,0,NULL,NULL,NULL,NULL,2),
(24,'asdfgqw','asdfasdf',0,0,0,0,NULL,NULL,NULL,NULL,2);
/*!40000 ALTER TABLE `module` ENABLE KEYS */;
--
-- Definition of table `note`
--
DROP TABLE IF EXISTS `note`;
CREATE TABLE `note` (
`note
- 1
- 2
- 3
前往页