没有任何框架,只要使用sql即可,适合毕业设计+项目作业。
create database bbs;
CREATE TABLE `user` (
`username` varchar(18) NOT NULL,
`email` varchar(30) NOT NULL,
`password` varchar(50) NOT NULL,
`grade` int(11) NOT NULL DEFAULT '0',
`photo` mediumblob,
`nickname` varchar(50) NOT NULL,
PRIMARY KEY (`username`),
UNIQUE KEY `nickname_UNIQUE` (`nickname`)
);
CREATE TABLE `tieba` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`content` varchar(600) NOT NULL,
`name` varchar(18) NOT NULL,
`tieba_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`hidden` int(11) NOT NULL DEFAULT '1',
`judgetieba` varchar(50) DEFAULT NULL,
`nickname` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE `tiezi` (
`id` int(11) NOT NULL,
`title` varchar(100) DEFAULT NULL,
`name` varchar(18) NOT NULL,
`content` varchar(600) NOT NULL,
`floor` int(11) NOT NULL AUTO_INCREMENT,
`tiezi_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`hidden` int(11) NOT NULL DEFAULT '1',
`nickname` varchar(50) NOT NULL,
PRIMARY KEY (`floor`)
);
CREATE TABLE `fileshare` (
`filename` varchar(100) NOT NULL,
`file` longblob NOT NULL,
`nickname` varchar(45) NOT NULL,
`fileupdate_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`filename`)
);