开发工具:
文件大小: 2mb
下载次数: 0
上传时间: 2011-02-19
详细说明： 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 OBJE CTPROPERTY(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) ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
