MF00889- ASP.NET简易库存管理源码.zip

if exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F') where r.fkeyid = object_id('Warehouse') and o.name = 'FK_WAREHOUS_RELATIONS_USERS') alter table Warehouse drop constraint FK_WAREHOUS_RELATIONS_USERS go if exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F') where r.fkeyid = object_id('Warehouse') and o.name = 'FK_WAREHOUS_RELATIONS_GOODS') alter table Warehouse drop constraint FK_WAREHOUS_RELATIONS_GOODS go if exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F') where r.fkeyid = object_id('WarehouseLoging') and o.name = 'FK_WAREHOUS_RELATIONS_USERS') alter table WarehouseLoging drop constraint FK_WAREHOUS_RELATIONS_USERS go if exists (select 1 from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F') where r.fkeyid = object_id('WarehouseLoging') and o.name = 'FK_WAREHOUS_RELATIONS_GOODS') alter table WarehouseLoging drop constraint FK_WAREHOUS_RELATIONS_GOODS go if exists (select 1 from sysobjects where id = object_id('Goods') and type = 'U') drop table Goods go if exists (select 1 from sysobjects where id = object_id('PrintSettings') and type = 'U') drop table PrintSettings go if exists (select 1 from sysobjects where id = object_id('Users') and type = 'U') drop table Users go if exists (select 1 from sysindexes where id = object_id('Warehouse') and name = 'Relationship_2_FK' and indid > 0 and indid < 255) drop index Warehouse.Relationship_2_FK go if exists (select 1 from sysindexes where id = object_id('Warehouse') and name = 'Relationship_1_FK' and indid > 0 and indid < 255) drop index Warehouse.Relationship_1_FK go if exists (select 1 from sysobjects where id = object_id('Warehouse') and type = 'U') drop table Warehouse go if exists (select 1 from sysindexes where id = object_id('WarehouseLoging') and name = 'Relationship_4_FK' and indid > 0 and indid < 255) drop index WarehouseLoging.Relationship_4_FK go if exists (select 1 from sysindexes where id = object_id('WarehouseLoging') and name = 'Relationship_3_FK' and indid > 0 and indid < 255) drop index WarehouseLoging.Relationship_3_FK go if exists (select 1 from sysobjects where id = object_id('WarehouseLoging') and type = 'U') drop table WarehouseLoging go /*==============================================================*/ /* Table: Goods */ /*==============================================================*/ create table Goods ( gid int identity, gcode varchar(50) null, gname varchar(100) null, "from" varchar(100) null, specifications varchar(50) null, batchNumber varchar(50) null, unit varchar(50) null, price decimal(2) null, endTime datetime null, remark varchar(200) null, constraint PK_GOODS primary key (gid) ) go /*==============================================================*/ /* Table: PrintSettings */ /*==============================================================*/ create table PrintSettings ( pid int identity, title varchar(50) null, pleft int null, ptop int null, ptype varchar(20) null, pagewidth int null, pageheight int null, constraint PK_PRINTSETTINGS primary key (pid) ) go /*==============================================================*/ /* Table: Users */ /*==============================================================*/ create table Users ( uid int identity, uname varchar(200) null, upassword varchar(200) null, constraint PK_USERS primary key (uid) ) go /*==============================================================*/ /* Table: Warehouse */ /*==============================================================*/ create table Warehouse ( gcount int null, inTime datetime null, id int identity, uid int null, gid int null, pageNum varchar(50) null, constraint PK_WAREHOUSE primary key nonclustered (id) ) go /*==============================================================*/ /* Index: Relationship_1_FK */ /*==============================================================*/ create nonclustered index Relationship_1_FK on Warehouse (uid ASC) go /*==============================================================*/ /* Index: Relationship_2_FK */ /*==============================================================*/ create nonclustered index Relationship_2_FK on Warehouse (gid ASC) go /*==============================================================*/ /* Table: WarehouseLoging */ /*==============================================================*/ create table WarehouseLoging ( gcount int null, wtype int null, createTime datetime null, currGCount int null, printNum int null, remark varchar(200) null, id int identity, uid int null, gid int null, constraint PK_WAREHOUSELOGING primary key nonclustered (id) ) go /*==============================================================*/ /* Index: Relationship_3_FK */ /*==============================================================*/ create nonclustered index Relationship_3_FK on WarehouseLoging (uid ASC) go /*==============================================================*/ /* Index: Relationship_4_FK */ /*==============================================================*/ create nonclustered index Relationship_4_FK on WarehouseLoging (gid ASC) go alter table Warehouse add constraint FK_WAREHOUS_RELATIONS_USERS foreign key (uid) references Users (uid) go alter table Warehouse add constraint FK_WAREHOUS_RELATIONS_GOODS foreign key (gid) references Goods (gid) go alter table WarehouseLoging add constraint FK_WAREHOUS_RELATIONS_USERS foreign key (uid) references Users (uid) go alter table WarehouseLoging add constraint FK_WAREHOUS_RELATIONS_GOODS foreign key (gid) references Goods (gid) go