goods.sql

来自「一个比较好的」· SQL 代码 · 共 19 行

USE Shop
GO
CREATE TABLE Goods (
  Id 	Int IDENTITY (1, 1),
  Typeid 	Int,
  Name 	Varchar (50),
  Sn_Number 	Varchar (50),
  Producer 	Varchar (50),
  Package 	Varchar (50),
  SalePrice 	Float DEFAULT 0,
  StorePrice 	Float DEFAULT 0,
  Content 	Varchar (1000),
  PostTime 	Datetime,
  ReadCount 	Int DEFAULT 0,
  BuyCount 	Int DEFAULT 0,
  ImageFile 	Varchar (50)
)
GO