BookShop(网上书城)

CREATE DATABASE [BookShop] ON PRIMARY ( NAME = N'BookShop', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\BookShop.mdf' , SIZE = 10240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'BookShop_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\BookShop.ldf' , SIZE = 4672KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO USE [BookShop] GO /****** Object: Table [dbo].[Orders] Script Date: 12/12/2012 20:56:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Orders]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderDate] [datetime] NOT NULL, [UserId] [int] NOT NULL, [TotalPrice] [decimal](10, 2) NOT NULL ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[Orders] ON INSERT [dbo].[Orders] ([Id], [OrderDate], [UserId], [TotalPrice]) VALUES (89, CAST(0x0000A06C0176BB7B AS DateTime), 18, CAST(160.00 AS Decimal(10, 2))) SET IDENTITY_INSERT [dbo].[Orders] OFF /****** Object: Table [dbo].[UserStates] Script Date: 12/12/2012 20:56:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserStates]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) NOT NULL, CONSTRAINT [PK_UserStates] 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 CREATE UNIQUE NONCLUSTERED INDEX [IX_UserStates_Name] ON [dbo].[UserStates] ( [Name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'DefaultId', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserStates' GO SET IDENTITY_INSERT [dbo].[UserStates] ON INSERT [dbo].[UserStates] ([Id], [Name]) VALUES (2, N'无效') INSERT [dbo].[UserStates] ([Id], [Name]) VALUES (1, N'正常') SET IDENTITY_INSERT [dbo].[UserStates] OFF /****** Object: Table [dbo].[UserRoles] Script Date: 12/12/2012 20:56:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserRoles]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) NOT NULL, CONSTRAINT [PK_Roles] 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 CREATE UNIQUE NONCLUSTERED INDEX [IX_UserRoles_Name] ON [dbo].[UserRoles] ( [Name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'DefaultId', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserRoles' GO SET IDENTITY_INSERT [dbo].[UserRoles] ON INSERT [dbo].[UserRoles] ([Id], [Name]) VALUES (2, N'VIP 用户') INSERT [dbo].[UserRoles] ([Id], [Name]) VALUES (3, N'管理员') INSERT [dbo].[UserRoles] ([Id], [Name]) VALUES (1, N'普通用户') SET IDENTITY_INSERT [dbo].[UserRoles] OFF /****** Object: Table [dbo].[Publishers] Script Date: 12/12/2012 20:56:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Publishers]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](200) NOT NULL, CONSTRAINT [PK_Publisher] 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 CREATE UNIQUE NONCLUSTERED INDEX [IX_Publishers_Name] ON [dbo].[Publishers] ( [Name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE =�