日期:2014-05-17 浏览次数:20457 次
CREATE TABLE users
(
id# int not null,
name char(10) not null,
gender char(7) not null,
birthdate datetime null,
qqid# char(20) not null
);
CREATE TABLE qq
(
qqid# char(20) not null,
timeforchat datetime not null,
chat text not null,
font varchar(100) not null
)
CREATE TABLE users
(
id int not null,
name char(10) not null,
gender char(7) not null,
birthdate datetime null,
qqid char(20) not null primary key
);
GO
CREATE TABLE qq
(
qqid char(20) not null constraint FK_QQ foreign key references users(qqid),
timeforchat datetime not null,
chat text not null,
font varchar(100) not null,
constraint PK_QQ primary key(qqid,timeforchat)
);