DB_51aspx/数据库脚本.txt

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

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

USE LiShuiBookWeb
GO
/****** 对象:  Table [dbo].[tb_Order]    脚本日期: 12/20/2012 16:17:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tb_Order](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Orderid] [nvarchar](50) NULL,
	[Ordeuser] [nvarchar](50) NULL,
	[Ordertime] [datetime] NULL CONSTRAINT [DF_tb_Order_Ordertime]  DEFAULT (getdate()),
	[IsCheckout] [nvarchar](50) NULL CONSTRAINT [DF_tb_Order_IsCheckout]  DEFAULT (N'否'),
	[OrderStite] [nvarchar](50) NULL CONSTRAINT [DF_tb_Order_OrderStite]  DEFAULT (N'新订单'),
	[fahuofansh] [nvarchar](50) NULL,
	[pingjia] [nvarchar](50) NULL CONSTRAINT [DF_tb_Order_pingjia]  DEFAULT (N'未评价'),
	[pingjiacontent] [text] NULL,
 CONSTRAINT [PK_tb_Order] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Admin]    脚本日期: 12/20/2012 16:17:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Admin](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Apwd] [nvarchar](50) NULL,
	[Aname] [nvarchar](50) NULL,
 CONSTRAINT [PK_Admin] PRIMARY KEY CLUSTERED 
(
	[id] 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
/****** 对象:  Table [dbo].[BookInfo]    脚本日期: 12/20/2012 16:17:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BookInfo](
	[BookID] [int] IDENTITY(1,1) NOT NULL,
	[BookName] [nvarchar](50) NULL,
	[BookTypeID] [int] NULL,
	[BookTypeName] [nvarchar](50) NULL,
	[BookClick] [int] NULL CONSTRAINT [DF_GoodsInfo_GoodsClick]  DEFAULT ((0)),
	[BookNum] [int] NULL CONSTRAINT [DF_GoodsInfo_GoodsNum]  DEFAULT ((1)),
	[BookPhoto] [nvarchar](50) NULL,
	[BookPrice] [float] NULL,
	[BookIntroduce] [text] NULL,
	[BookDate] [datetime] NULL CONSTRAINT [DF_GoodsInfo_GoodsDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_GoodsInfo] PRIMARY KEY CLUSTERED 
(
	[BookID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO