網(wǎng)上書(shū)店項(xiàng)目總結(jié)報(bào)告-wenkub
2024-11-16 23 本頁(yè)面
【正文】 E_BOOKTYPE goif exists(select 1from r join o on( = and = 39。)and = 39。)where = object_id(39。)alter table booktypedrop constraint FK_BOOKTYPE_REFERENCE_BOOKTYPE goif exists(select 1from r join o on( = and = 39。)and = 39。)where = object_id(39。)alter table limitedrop constraint FK_LIMITE_REFERENCE_ADMINIST goif exists(select 1from r join o on( = and = 39。)and = 39。)where = object_id(39。)alter table ordersdrop constraint FK_ORDERS_REFERENCE_SHIPPED goif exists(select 1from r join o on( = and = 39。)and = 39。)where = object_id(39。)alter table ordersdrop constraint FK_ORDERS_REFERENCE_USERS go if exists(select 1from r join o on( = and = 39。)and = 39。)where = object_id(39。)alter table shippeddrop constraint FK_SHIPPED_REFERENCE_SALES goif exists(select 1from r join o on( = and = 39。)and = 39。)where = object_id(39。)alter table shoppingcardrop constraint FK_SHOPPING_REFERENCE_BOOKS goif exists(select 1from r join o on( = and = 39。)and = 39。)where = object_id(39。)alter table usersdrop constraint FK_USERS_REFERENCE_LIMITE goif exists(select 1from sysobjectswhere id = object_id(39。)drop table Administrators goif exists(select 1from sysobjectswhere id = object_id(39。)drop table Re_status goif exists(select 1from sysobjectswhere id = object_id(39。)drop table books goif exists(select 1from sysobjectswhere id = object_id(39。)drop table booktype goif exists(select 1from sysobjectswhere id = object_id(39。)drop table booktype2 goif exists(select 1from sysobjectswhere id = object_id(39。)drop table discount goif exists(select 1from sysobjectswhere id = object_id(39。)drop table leaveWords goif exists(select 1from sysobjectswhere id = object_id(39。)drop table limite goif exists(select 1from sysobjectswhere id = object_id(39。)drop table model goif exists(select 1from sysobjectswhere id = object_id(39。)drop table orders goif exists(select 1from sysobjectswhere id = object_id(39。)drop table publish goif exists(select 1from sysobjectswhere id = object_id(39。)drop table sales goif exists(select 1from sysobjectswhere id = object_id(39。)drop table shipped goif exists(select 1from sysobjectswhere id = object_id(39。)drop table shoppingcar goif exists(select 1from sysobjectswhere id = object_id(39。)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，Subjectvarchar(6)not null，Submit_datedatetimenull，Lword_texevarchar(4000)null，Re_statusvarchar(10)null，constraint PK_LEAVEWORDS primary key(Lword_id))go/*================*/ /* Table: limite*/ /*================*/ create table limite（usernamevarchar(20)not null，Administrator_idvarchar(50)null，user_limitevarchar(2)not null，constraint PK_LIMITE primary key(username))go/*================*/ /* Table: model*/ /*================*/ create table model（model_idvarchar(10)not null，username
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1