VB 图书馆信息管理系统(SQL).rar

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_借还信息表_图书信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[借还信息表] DROP CONSTRAINT FK_借还信息表_图书信息表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_预约信息表_图书信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[预约信息表] DROP CONSTRAINT FK_预约信息表_图书信息表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_图书信息表_文献类型表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[图书信息表] DROP CONSTRAINT FK_图书信息表_文献类型表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_借还信息表_读者信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[借还信息表] DROP CONSTRAINT FK_借还信息表_读者信息表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_预约信息表_读者信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[预约信息表] DROP CONSTRAINT FK_预约信息表_读者信息表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[借还信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[借还信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[参数配置表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[参数配置表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[图书信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[文献类型表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[文献类型表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用户信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[用户信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[读者信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[读者信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[预约信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[预约信息表] GO CREATE TABLE [dbo].[借还信息表] ( [borrowID] [decimal](18, 0) IDENTITY (1, 1) NOT NULL , [readerID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [bookID] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [dateBorrow] [datetime] NULL , [dateBorrow2] [datetime] NULL , [dateBack] [datetime] NULL , [fineR] [float] NULL , [remarkBorrow] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[参数配置表] ( [borrowTL] [int] NOT NULL , [borrow2TL] [int] NOT NULL , [maxBooks] [int] NOT NULL , [maxFines] [float] NULL , [finedaily] [float] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[图书信息表] ( [bookID] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [categoryID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [volume] [int] NOT NULL , [press] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [ISBN] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [keywords] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [publishTime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [dateStorage] [datetime] NULL , [remarkBook] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[文献类型表] ( [categoryID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [category] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [remarkCG] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[用户信息表] ( [userID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [userName] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [userType] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [password] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [competence] [text] COLLATE Chinese_PRC_CI_AS NULL , [identificationU] [char�