CREATE DATABASE shujuzidian CREATE TABLE roles ( roleid int CONSTRAINT r_PRIM PRIMARY KEY, rolename varchar(20) not null, ) CREATE TABLE users (userid int CONSTRAINT u_PRIM PRIMARY KEY, username varchar (20) NOT NULL, nickname varchar(20)not null, telephone varchar(20) not null, email varchar (20), age int check(age between 18 and 60), sex varchar(4) check(sex='男'or sex='女'), address varchar(200) DEFAULT'地址不详', remark varchar (200), roleid int CONSTRAINT r_FORE FOREIGN KEY REFERENCES roles(roleid), status int DEFAULT'1', password varchar(10) DEFAULT'123', ) CREATE TABLE user_group ( groupid int CONSTRAINT g_PRIM PRIMARY KEY, groupname varchar(20) not null, ) CREATE TABLE friendship ( userid int CONSTRAINT u_FORE FOREIGN KEY REFERENCES users(userid), friendid int CONSTRAINT f_FORE FOREIGN KEY REFERENCES users(userid), gruopid int CONSTRAINT g_FORE FOREIGN KEY REFERENCES user_group(groupid), ) CREATE TABLE chat_log ( logid int CONSTRAINT l_PRIM PRIMARY KEY, senderid int CONSTRAINT s_FORE FOREIGN KEY REFERENCES users(userid), recriverid int CONSTRAINT m_FORE FOREIGN KEY REFERENCES users(userid), sendtime varchar (20)not null, sendcontent varchar(200) not null, remark varchar (200), )
, 相关下载链接:
https://download.csdn.net/download/qq_43934844/87504477?utm_source=bbsseo