bbs.sql

实现功能：(1)管理员由1.浏览帖子2.添加主贴3.添加复帖4.更改 5.删除6.搜索帖子的权限 (2)注册会员有1.浏览帖子2.添加主贴3添加复帖4.搜索帖子的权限 (3)游客需注册

# SQL Manager 2005 for MySQL 3.6.5.8
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : BBS


SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `BBS`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

#
# Structure for the `messagetable` table : 
#

CREATE TABLE `messagetable` (
  `forumNumber` int(5) NOT NULL default '0',
  `account` varchar(20) default NULL,
  `nickName` varchar(20) default NULL,
  `subjectName` char(25) default NULL,
  `content` varchar(100) default NULL,
  `messageType` int(6) NOT NULL,
  `subMessageType` int(11) default NULL,
  `dataTime` varchar(50) default NULL,
  PRIMARY KEY  (`forumNumber`,`messageType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Structure for the `usertable` table : 
#

CREATE TABLE `usertable` (
  `account` varchar(40) NOT NULL default '000000',
  `nickName` varchar(20) NOT NULL default 'user',
  `code` varchar(20) default NULL,
  `userType` int(6) NOT NULL default '0',
  PRIMARY KEY  (`account`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Data for the `messagetable` table  (LIMIT 0,500)
#

INSERT INTO `messagetable` (`forumNumber`, `account`, `nickName`, `subjectName`, `content`, `messageType`, `subMessageType`, `dataTime`) VALUES 
  (3,'love521','love','qingdao','itisabeautifulcity',-1,NULL,'Fri Jul 11 14:43:54 CST 2008'),
  (4,'junge123','junge','invicible','comityispower',-1,NULL,'Fri Jul 11 14:47:41 CST 2008'),
  (7,'love521','love',NULL,'ilovethiscity',1,3,'Fri Jul 11 14:56:29 CST 2008'),
  (6,'junge123','junge',NULL,'bless',1,1,'Fri Jul 11 14:49:58 CST 2008'),
  (2,'china101','zhongguo','oneworldonedream','weareready,weareok,wearefriends',-1,NULL,'Fri Jul 11 14:42:16 CST 2008'),
  (1,'china101','zhongguo','olympicgames','welcometobeijing',-1,NULL,'Fri Jul 11 14:40:49 CST 2008'),
  (8,'liu11ge','xiaopihai',NULL,'yes',1,4,'Fri Jul 11 14:59:54 CST 2008'),
  (9,'liu11ge','xiaopihai','okiwillgo','wait2minute',-1,NULL,'Fri Jul 11 15:02:50 CST 2008'),
  (10,'bird321','bird',NULL,'thisyeariwillgothere',1,3,'Fri Jul 11 15:09:05 CST 2008'),
  (11,'bird321','bird','flyingfeels','thatisgreat',-1,NULL,'Fri Jul 11 15:09:52 CST 2008');

COMMIT;

#
# Data for the `usertable` table  (LIMIT 0,500)
#

INSERT INTO `usertable` (`account`, `nickName`, `code`, `userType`) VALUES 
  ('laoda','xiaomao','laoda',-1),
  ('bird321','bird','123321',0),
  ('love521','love','521',0),
  ('9999','superior','9999',0),
  ('@shihao@','loveboy','shihao',0),
  ('123xiaoshan','xiaoshan','123456',0),
  ('china101','zhongguo','china',0),
  ('niuniu','niuniu','niu99',0);

COMMIT;