basket.sql

一个比较好的

USE Shop
GO
CREATE TABLE Basket (
  Id 	Int IDENTITY (1, 1),
  UserId 	Varchar (20),
  GoodsId 	Int,
  OrderTime 	Datetime,
  OrderCount 	Int DEFAULT 0,
  SalePrice 	Float DEFAULT 0,
  UserChecked 	Char (10) DEFAULT 0,
  OrderNumber 	Varchar (50),
  PostTime 	Datetime,
  AdminChecked 	Char (10) DEFAULT 0
)
GO