salesCompleted varchar(15) --销售完成时间

)

--房产咨询表;

if exists(select * from dbo.sysobjects where name='houseNews')

drop table houseNews

GO

create table houseNews(

houseNewId int not null, --自增长ID

houseNewTheme varchar(200) not null, --咨询主题

houseNewContent text, --咨询内容

houseNewDate varchar(15) --发布日期

)

--留言评论表

if exists(select * from dbo.sysobjects where name='Message')

drop table Message

GO

create table Message(

messageId int not null, --自增长ID

houseNumber varchar(15) not null, --房屋出租/出售编号(针对房屋编号留言)

messageContent varchar(200) not null, --留言内容

contact varchar(50), --联系方式

messageDate varchar(15) not null --留言时间

)

--添加约束

alter table userInfo add constraint pk_userId primary key (userId);

alter table userInfo add constraint DF_userRole default(0) for userRole;

alter table userInfo add constraint DF_registDate default(CONVERT(varchar(100), GETDATE(), 23)) for registDate;

alter table houseInfo add constraint pk_houseId primary key (houseId);

alter table employInfo add constraint pk_employId primary key (employId);

alter table employInfo add constraint DF_employPassWord default('888888') for employPassWord;

alter table employResult add constraint pk_employResultId primary key (employResultId);

alter table houseNews add constraint pk_houseNewId primary key (houseNewId);

alter table houseNews add constraint DF_houseNewDate default(CONVERT(varchar(100), GETDATE(), 23)) for houseNewDate;

alter table Message add constraint pk_messageId primary key (messageId);

alter table Message add constraint DF_messageDate default(CONVERT(varchar(100), GETDATE(), 23)) for messageDate;