bbs.sql

来自「要实现功能有：发帖」· SQL 代码 · 共 72 行

# SQL Manager 2005 Lite for MySQL 3.7.6.1
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : bbs


/*!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 gb2312 */;

SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `bbs`
    CHARACTER SET 'gb2312'
    COLLATE 'gb2312_chinese_ci';

USE `bbs`;

#
# Structure for the `bbs` table : 
#

CREATE TABLE `bbs` (
  `bid` int(11) NOT NULL auto_increment,
  `btitle` varchar(50) default NULL,
  `author` varchar(20) default NULL,
  `bdate` datetime default NULL,
  PRIMARY KEY  (`bid`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=gb2312;

#
# Structure for the `bdetail` table : 
#

CREATE TABLE `bdetail` (
  `id` int(11) NOT NULL auto_increment,
  `bid` int(11) default NULL,
  `detail` varchar(1000) default NULL,
  `resp` varchar(20) default NULL,
  `bdate` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `bid` (`bid`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=gb2312;

#
# Structure for the `user` table : 
#

CREATE TABLE `user` (
  `uname` varchar(20) default NULL,
  `upass` varchar(20) default NULL,
  `grade` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

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

INSERT INTO `user` (`uname`, `upass`, `grade`) VALUES 
  ('qwe','qwe',1),
  ('admin','admin',0),
  ('dx','dx',1);

COMMIT;



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;