DB_51aspx/2014年/2014年7月分/点菜62.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

GO
CREATE TABLE [dbo].[wx_diancai_blacklist](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[openid] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL,
	[blackName] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
	[blackDate] [datetime] NULL,
	[createDate] [datetime] NULL,
	[shopid] [int] NULL,
 CONSTRAINT [PK_wx_diancai_blacklist_id] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_diancai_blacklist', @level2type=N'COLUMN', @level2name=N'id'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户openid' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_diancai_blacklist', @level2type=N'COLUMN', @level2name=N'openid'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_diancai_blacklist', @level2type=N'COLUMN', @level2name=N'blackName'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'拉黑日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_diancai_blacklist', @level2type=N'COLUMN', @level2name=N'blackDate'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'黑名单' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_diancai_blacklist'




GO
CREATE TABLE [dbo].[wx_diancai_caipin_category](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[shopid] [int] NULL,
	[sortid] [int] NULL,
	[categoryName] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
	[miaoshu] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
	[isStart] [bit] NULL,
	[createDate] [datetime] NULL,
 CONSTRAINT [PK_wx_diancaory_id] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_diancai_caipin_category', @level2type=N'COLUMN', @level2name=N'id'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商家id' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_diancai_caipin_category', @level2type=N'COLUMN', @level2name=N'shopid'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示顺序' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_diancai_caipin_category', @level2type=N'COLUMN', @level2name=N'sortid'