/****** 对象: Table [sq_tfr734688].[product_detail] 脚本日期: 12/17/2013 15:36:12 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [sq_tfr734688].[product_detail](

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

[product_name] [nvarchar](100) NOT NULL,

[summary] [nvarchar](300) NULL,

[description] [text] NULL,

[keywords] [nvarchar](50) NULL,

[category_id] [int] NOT NULL CONSTRAINT [DF_product_detail_category_id] DEFAULT (0),

[brand_id] [int] NOT NULL CONSTRAINT [DF_product_detail_brand_id] DEFAULT (0),

[integral] [int] NOT NULL CONSTRAINT [DF_product_detail_integral] DEFAULT (0),

[is_show] [bit] NOT NULL CONSTRAINT [DF_product_detail_is_show] DEFAULT (1),

[order_by] [int] NOT NULL CONSTRAINT [DF_product_detail_order_by] DEFAULT (0),

[is_recommend] [bit] NOT NULL CONSTRAINT [DF_product_detail_is_recommend] DEFAULT (0),

[is_new] [bit] NOT NULL CONSTRAINT [DF_product_detail_is_new] DEFAULT (0),

[is_hot] [bit] NOT NULL CONSTRAINT [DF_product_detail_is_hot] DEFAULT (0),

[is_discount] [bit] NOT NULL CONSTRAINT [DF_product_detail_is_discount] DEFAULT (0),

[is_delete] [bit] NOT NULL CONSTRAINT [DF_product_detail_is_delete] DEFAULT (0),

[is_comment] [bit] NOT NULL CONSTRAINT [DF_product_detail_is_comment] DEFAULT (1),

[price] [float] NOT NULL CONSTRAINT [DF_product_detail_price] DEFAULT (0),

[sale_price] [float] NOT NULL CONSTRAINT [DF_product_detail_sale_price] DEFAULT (0),

[sale_number] [int] NOT NULL CONSTRAINT [DF__product_d__sale___6A85CC04] DEFAULT (0),

[stock] [int] NOT NULL CONSTRAINT [DF__product_d__stock__6B79F03D] DEFAULT (0),

[html_name] [nvarchar](50) NULL,

[click_number] [int] NOT NULL CONSTRAINT [DF_product_detail_click_number] DEFAULT (0),

[create_date] [smalldatetime] NOT NULL CONSTRAINT [DF_product_detail_create_date] DEFAULT (getdate()),

[shop_ID] [nvarchar](16) NULL,

CONSTRAINT [PK_product_detail] 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] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO