VB与sql图书管理系统数据库.rar

use master go IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'图书管理系统') DROP DATABASE [图书管理系统] GO CREATE DATABASE [图书管理系统] GO use [图书管理系统] 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].[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].[借还信息表] ( [借还ID] [decimal](18, 0) IDENTITY (1, 1) NOT NULL , [读者号] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [图书号] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [借书日期] [datetime] NULL , [续借日期] [datetime] NULL , [还书日期] [datetime] NULL , [罚款金额] [float] NULL , [备注] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[参数配置表] ( [借书时限] [int] NOT NULL , [续借时限] [int] NOT NULL , [最大借书量] [int] NOT NULL , [最高罚款额] [float] NULL , [每日罚款] [float] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[图书信息表] ( [图书号] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [分类号] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [题名] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [图书数量] [int] NOT NULL , [出版社] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [作者] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [ISBN号] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [主题词] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [版次] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [存储日期] [datetime] NULL , [备注] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[文献类型表] ( [分类号] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [分类名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [备注] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[用户信息表] ( [用户ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [用户名称] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [用户类别] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [密码] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [权限] [text] COLLATE Chinese_PRC_CI_AS NULL�