DB_51Aspx/book.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [book]
GO
/****** Object:  Table [dbo].[t_user]    Script Date: 06/27/2021 14:13:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_user](
	[id] [varchar](20) NULL,
	[name] [varchar](20) NULL,
	[sex] [char](2) NULL,
	[psw] [varchar](20) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[t_user] ([id], [name], [sex], [psw]) VALUES (N'1001', N'张三', N'男', N'1')
INSERT [dbo].[t_user] ([id], [name], [sex], [psw]) VALUES (N'1002', N'李四', N'女', N'1')
/****** Object:  Table [dbo].[t_lend]    Script Date: 06/27/2021 14:13:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_lend](
	[no] [int] IDENTITY(1,1) NOT NULL,
	[uid] [varchar](50) NULL,
	[bid] [varchar](50) NULL,
	[datetime] [datetime] NULL,
 CONSTRAINT [PK_t_lend] PRIMARY KEY CLUSTERED 
(
	[no] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_book]    Script Date: 06/27/2021 14:13:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_book](
	[id] [varchar](50) NULL,
	[name] [varchar](50) NULL,
	[author] [varchar](50) NULL,
	[press] [varchar](50) NULL,
	[number] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[t_book] ([id], [name], [author], [press], [number]) VALUES (N'2', N'离散数学', N'未知', N'未知', 20)
INSERT [dbo].[t_book] ([id], [name], [author], [press], [number]) VALUES (N'3', N'概率论', N'未知', N'未知', 20)
/****** Object:  Table [dbo].[t_admin]    Script Date: 06/27/2021 14:13:58 ******/