【正文】 p_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。 go /*==============================================================*/ /* Table: FetherInformations */ /*==============================================================*/ create table FetherInformations ( fid int not null, fAddress varchar(20) not null, ftime datetime not null, ffee double precision not null, contents text not null, fstate varchar(6) not null, constraint PK_FORGETHERINFORMATIONS primary key nonclustered (fid) ) go declare CurrentUser sysname select CurrentUser = user_name() execute sp_addextendedproperty 39。, 39。, CurrentUser, 39。, 39。, 39。) drop table TrystInformations go /*==============================================================*/ /* Table: Associators */ /*==============================================================*/ create table Associators ( aid int not null, password varchar(20) null, name varchar(20) not null, sex bit not null, birthday datetime not null, age int null, image image not null, luckanimal varchar(2) null, constellation varchar(6) null, nation varchar(20) not null, identitycard varchar(18) not null, politicsstate varchar(20) null, county varchar(20) null, homeadd varchar(20) not null, residence varchar(10) null, height real null, weight real null, bodytape varchar(20) null, healthstate varchar(6) not null, edubackground varchar(6) not null, major varchar(20) null, college varchar(20) null, inemonth int not null, familymembers varchar(20) not null, housestate varchar(6) null, carstate varchar(6) null, marriagestate varchar(6) not null, workunit varchar(20) not null, unitquality varchar(20) null, profession varchar(20) null, appellation varchar(20) null, workadd varchar(20) null, characters varchar(6) null, 使用了 character數(shù)據(jù)類型關(guān)鍵字，現(xiàn)在改為 characters interest varchar(20) null, skill varchar(20) null, phone varchar(11) not null, qq varchar(10) not null, varchar(50) not null, jointime datetime not null, updatetime datetime not null, states varchar(6) not null, 使用了 state關(guān)鍵字，現(xiàn)在給為 states trystcounts int null, constraint PK_ASSOCIATORS primary key nonclustered (aid) ) go declare CurrentUser sysname select CurrentUser = user_name() execute sp_addextendedproperty 39。) and type = 39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。) and name = 39。) drop table JoinFethersInformations go if exists (select 1 from sysindexes where id = object_id(39。) and type = 39。 and indid 0 and indid 255) drop index FK go if exists (select 1 from sysobjects where id = object_id(39。) and name = 39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysindexes where id = object_id(39。) and name = 39。) drop table FetherInformations go if exists (select 1 from sysindexes where id = object_id(39。) and type = 39。) drop table Associators go if exists (select 1 from sysobjects where id = object_id(39。) and type = 39。) drop view View_LoginCheck go if exists (select 1 from sysobjects