if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Borrow_Info_Book_Info]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Borrow_Info] DROP CONSTRAINT FK_Borrow_Info_Book_Info
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Borrow_Info_Proof_Info]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Borrow_Info] DROP CONSTRAINT FK_Borrow_Info_Proof_Info
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Admin_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Admin_Info]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Book_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Book_Info]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Borrow_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Borrow_Info]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Proof_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Proof_Info]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Punish_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Punish_Info]
GO
CREATE TABLE [dbo].[Admin_Info] (
[User_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[WorkID] [float] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Book_Info] (
[Book_ID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Book_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Writer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Press] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Price] [float] NOT NULL ,
[InLibrary_Date] [smalldatetime] NOT NULL ,
[Total_Amount] [int] NOT NULL ,
[Now_Amount] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Borrow_Info] (
[BorrowID] [int] NOT NULL ,
[Proof_ID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Book_ID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Borrow_Date] [smalldatetime] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Proof_Info] (
[Proof_ID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Sex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Birth_Time] [smalldatetime] NOT NULL ,
[Address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ID_Number] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Tel_Number] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Now_Borrow_Amount] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Punish_Info] (
[Puni_ID] [int] NOT NULL ,
[Proof_ID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Book_ID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Borrow_Date] [smalldatetime] NOT NULL ,
[Return_Date] [smalldatetime] NOT NULL ,
[Puni_Money] [float] NOT NULL
) ON [PRIMARY]
GO
Insert into Book_Info values ('10001', '数据库原理','杜胜胜','中国地质大学大学',50,'2009-11-17 0:17:00',5,5)
Insert into Proof_Info values (1, '童红兵','Male','2009-11-17 0:17:00','武汉','1','027-87433110',0)
Insert into Borrow_Info values (1, 1,10001,'2009-11-17 0:17:00')
Insert into Punish_Info values (1, 1,10001,'2009-11-17 0:17:00','2005-11-17 0:17:00',10)
2037
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
