qq.sql

来自「局域网聊天程序,仿QQ,界面做的很不错,是上学期操作系统的试验.」· SQL 代码 · 共 62 行

create database QQData
use QQData

create table c(
	cid varchar(10) primary key,
	cp varchar(50) not null
)

create table cf(
	cid varchar(10),
	cfid varchar(10) not null
)

create table cg(
	cid varchar(10),
	cgid varchar(10) not null
)

create table g(
	cgid varchar(10) ,
	cgfid varchar(10) not null
)

insert c values('453153295','JfnnlDI7RTiF9RgfG2JNCw==')

insert c values('123456789','JfnnlDI7RTiF9RgfG2JNCw==')

insert c values('147258369','JfnnlDI7RTiF9RgfG2JNCw==')

insert c values('987654321','JfnnlDI7RTiF9RgfG2JNCw==')

insert cf values('453153295','123456789')

insert cf values('123456789','453153295')

insert cf values('453153295','987654321')

insert cf values('987654321','453153295')

insert cf values('147258369','453153295')

insert cf values('453153295','147258369')

insert cg values('453153295','123456')

insert cg values('453153295','654321')

insert cg values('123456789','123456')

insert cg values('987654321','654321')

insert cg values('147258369','123456')

insert g values('123456','147258369')

insert g values('123456','123456789')

insert g values('123456','453153295')

insert g values('654321','453153295')

insert g values('654321','987654321')