数据库
create database bbs;
use bbs;
数据表
create table user(
uID INT PRIMARY KEY UNIQUE NOT NULL,
userName VARCHAR(20) NOT NULL,
userPassword VARCHAR(20) NOT NULL,
userEmail VARCHAR(10) NOT NULL,
userBirthday DATE NOT NULL,
userSex BIT NOT NULL,
userClass INT NOT NULL,
userStatement VARCHAR(150) NOT NULL,
userRegDate TIMESTAMP NOT NULL,
userPoint INT NOT NULL
);