SQL 表的创建和增加主键

use DBchat;
create table t_user(
Userid int not null,
Pwd nvarchar(100) not null,
Nickname nvarchar(10) not null,
Sex int,
Birthday datetime,
Currstate int,
friendshippolicy int
);
create table t_onlinestate(
Stateid int not null,
Statedesc nvarchar(10) not null
);
create table t_friendshippolicy(
Polid int not null,
Policy nvarchar(20) not null
);
create table t_friend(
Ufid int not null,
Userid int not null,
Friendid int not null
);
create table t_message(
Messageid int not null,
Fromuserid int not null,
Touserid int not null,
Content nvarchar(50),
Messagetype int,
State int,
Sendtime datetime
);
create table t_admin(
Adminid int,
Adminname nvarchar(20) not null,
Adminpwd nvarchar(100) not null
);

alter table t_admin alter column Adminid int not null;
alter table t_admin alter column Adminname nvarchar(20) not null;
alter table t_admin add constraint PK_t_admin_Adminid primary key(Adminid);
alter table t_user add constraint PK_t_user_Userid primary key(Userid);
alter table t_onlinestate add constraint PK_t_onlinestate_Stateid primary key(Stateid);
alter table t_friendshippolicy add constraint PK_t_friendshippolicy_Polid primary key(Polid);
alter table t_friend add constraint PK_t_friend_Ufid primary key(Ufid);
alter table t_message add constraint PK_t_message_Messageid primary key(Messageid);
alter table t_admin add constraint UQ_t_admin_Adminname unique(Adminname);