【正文】 bject_id(39。sales39。)and = 39。FK_SALES_REFERENCE_ORDERS39。)alter table salesdrop constraint FK_SALES_REFERENCE_ORDERS goif exists(select 1from r join o on( = and = 39。F39。)where = object_id(39。shipped39。)and = 39。FK_SHIPPED_REFERENCE_SALES39。)alter table shippeddrop constraint FK_SHIPPED_REFERENCE_SALES goif exists(select 1from r join o on( = and = 39。F39。)where = object_id(39。shoppingcar39。)and = 39。FK_SHOPPING_REFERENCE_BOOKTYPE39。)alter table shoppingcardrop constraint FK_SHOPPING_REFERENCE_BOOKTYPE goif exists(select 1from r join o on( = and = 39。F39。)where = object_id(39。shoppingcar39。)and = 39。FK_SHOPPING_REFERENCE_BOOKS39。)alter table shoppingcardrop constraint FK_SHOPPING_REFERENCE_BOOKS goif exists(select 1from r join o on( = and = 39。F39。)where = object_id(39。shoppingcar39。)and = 39。FK_SHOPPING_REFERENCE_USERS39。)alter table shoppingcardrop constraint FK_SHOPPING_REFERENCE_USERS goif exists(select 1from r join o on( = and = 39。F39。)where = object_id(39。users39。)and = 39。FK_USERS_REFERENCE_LIMITE39。)alter table usersdrop constraint FK_USERS_REFERENCE_LIMITE goif exists(select 1from sysobjectswhere id = object_id(39。Administrators39。)andtype = 39。U39。)drop table Administrators goif exists(select 1from sysobjectswhere id = object_id(39。Re_status39。)andtype = 39。U39。)drop table Re_status goif exists(select 1from sysobjectswhere id = object_id(39。books39。)andtype = 39。U39。)drop table books goif exists(select 1from sysobjectswhere id = object_id(39。booktype39。)andtype = 39。U39。)drop table booktype goif exists(select 1from sysobjectswhere id = object_id(39。booktype239。)andtype = 39。U39。)drop table booktype2 goif exists(select 1from sysobjectswhere id = object_id(39。discount39。)andtype = 39。U39。)drop table discount goif exists(select 1from sysobjectswhere id = object_id(39。leaveWords39。)andtype = 39。U39。)drop table leaveWords goif exists(select 1from sysobjectswhere id = object_id(39。limite39。)andtype = 39。U39。)drop table limite goif exists(select 1from sysobjectswhere id = object_id(39。model39。)andtype = 39。U39。)drop table model goif exists(select 1from sysobjectswhere id = object_id(39。orders39。)andtype = 39。U39。)drop table orders goif exists(select 1from sysobjectswhere id = object_id(39。publish39。)andtype = 39。U39。)drop table publish goif exists(select 1from sysobjectswhere id = object_id(39。sales39。)andtype = 39。U39。)drop table sales goif exists(select 1from sysobjectswhere id = object_id(39。shipped39。)andtype = 39。U39。)drop table shipped goif exists(select 1from sysobjectswhere id = object_id(39。shoppingcar39。)andtype = 39。U39。)drop table shoppingcar goif exists(select 1from sysobjectswhere id = object_id(39。users39。)andtype = 39。U39。)drop table users go/*================*/ /* Table: Administrators*/ /*================*/ create table Administrators（Administrator_idvarchar(50)not null，Usernamevarchar(20)null，Administrator_namevarchar(20)not null，Administrator_password varchar(50)not null，“Administrator_emall” varchar(30)null，constraint PK_ADMINISTRATORS primary key(Administrator_id))go/*================*/ /* Table: Re_status*/ /*================*/ create table Re_status（Administrator_idvarchar(50)not null，Usernamevarchar(10)not null，Re_status_datedatetimenot null，Subjectvarchar(10)not null，re_ststus_texevarchar(2000)null，Re_statusvarchar(2)not null，constraint PK_RE_STATUS primary key(Administrator_id))go/*================*/ /* Table: books*/ /*================*/ create table books（bookIDvarchar(50)not null，Smalltype_idvarchar(50)null，Pub_idvarchar(50)null，titlevarchar(80)not null，pricedouble precisionnot null，authorvarchar(10)not null，Versionvarchar(20)null，Publishdatedatetimenull，introductionvarchar(2000)null，typevarchar(50)not null，stock_qtyintnull，constraint PK_BOOKS primary key(bookID))go/*================*/ /* Table: booktype*/ /*================*/ create table booktype（Smalltype_idvarchar(50)not null，Bigtype_idvarchar(50)not null，Bigtype_namevarchar(50)not null，constraint PK_BOOKTYPE primary key(Smalltype_id))go/*================*/ /* Table: booktype2*/ /*================*/ create table booktype2（Smalltype_idvarchar(50)not null，Smalltype_namevarchar(50)not null，Bigtype_idvarchar(50)not null，constraint PK_BOOKTYPE2 primary key(Smalltype_id))go/*================*/ /* Table: discount*/ /*================*/ create table discount（datetimevarchar(10)not null，discountdouble precisionnot null，remarkdatetimenot null，constraint PK_DISCOUNT primary key(datetime))go/*================*/ /* Table: leaveWords*/ /*================*/ create table leaveWords（Lword_idvarchar(50)not null，use_Usernamevarchar(20)null，Usernamevarchar(6)not null，Sub