lyfz_repos/经典版源码/document/数据库表脚本/shangpin.sql

USE [db]
GO
/****** 对象:  Table [dbo].[shangpin]    脚本日期: 05/18/2015 09:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[shangpin](
	[spid] [nvarchar](50) NOT NULL CONSTRAINT [DF_shangpin_spid]  DEFAULT ('0'),		/* 商品id */
	[spname] [varchar](50) NULL,														/* 商品名 */
	[spdanwei] [varchar](50) NULL,														/* 商品单位 */
	[spjiaga1] [varchar](50) NULL,														/* 商品价格1:成本价 */
	[spjiage2] [varchar](50) NULL,														/* 商品价格2:卖价 */	
	[spjiage3] [varchar](50) NULL,														/* 商品价格3:供应商制作费 */	
	[splb] [varchar](50) NULL,															/* 商品类别 */
	[spbz] [varchar](max) NULL,															/* 商品备注 */
	[hide] [nvarchar](10) NULL,															/* 是否隐藏 */
 CONSTRAINT [PK_shangpin] PRIMARY KEY CLUSTERED 
(
	[spid] 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
SET ANSI_PADDING OFF