购书网站ajax刷新功能,ASP.NET MVC3书店--第八节 使用Ajax的购物车（第一部分）...

CREATE TABLE [dbo].[Orders](

[OrderId] [int] IDENTITY(1,1) NOT NULL,

[OrderDate] [datetime] NOT NULL,

[Username] [nvarchar](256) NULL,

[FirstName] [nvarchar](160) NULL,

[LastName] [nvarchar](160) NULL,

[Address] [nvarchar](70) NULL,

[City] [nvarchar](40) NULL,

[State] [nvarchar](40) NULL,

[PostalCode] [nvarchar](10) NULL,

[Country] [nvarchar](40) NULL,

[Phone] [nvarchar](24) NULL,

[Email] [nvarchar](160) NULL,

[Total] [numeric](10, 2) NOT NULL,

CONSTRAINT

[PK__Invoice__D796AAB51A14E395] PRIMARY KEY

CLUSTERED

(

[OrderId] 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 TABLE [dbo].[OrderDetails](

[OrderDetailId] [int] IDENTITY(1,1) NOT NULL,

[OrderId] [int] NOT NULL,

[BookId] [int] NOT NULL,

[Quantity] [int] NOT NULL,

[UnitPrice] [numeric](10, 2) NOT NULL,

CONSTRAINT

[PK__InvoiceL__0D760AD91DE57479] PRIMARY KEY

CLUSTERED

(

[OrderDetailId] 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 NONCLUSTERED INDEX [IFK_Invoice_InvoiceLine] ON

[dbo].[OrderDetails]

(

[OrderId] 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

CREATE NONCLUSTERED INDEX [IPK_InvoiceLine] ON

[dbo].[OrderDetails]

(

[OrderDetailId] 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

ALTER TABLE [dbo].[OrderDetails] WITH CHECK

ADD

CONSTRAINT [FK__InvoiceLi__Invoi__2F10007B] FOREIGN

KEY([OrderId])

REFERENCES [dbo].[Orders] ([OrderId])

GO

ALTER TABLE [dbo].[OrderDetails] CHECK

CONSTRAINT

[FK__InvoiceLi__Invoi__2F10007B]

GO

ALTER TABLE [dbo].[OrderDetails] WITH CHECK

ADD

CONSTRAINT [FK_InvoiceLine_Books] FOREIGN

KEY([BookId])

REFERENCES [dbo].[Books] ([Id])

GO