SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [UserShopConfig](
	[ConfigID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NULL,
	[Account] [varchar](50) NULL,
	[Domain] [varchar](50) NULL,
	[CompanyName] [nvarchar](50) NULL,
	[Contact] [nvarchar](50) NULL,
	[Tel] [varchar](50) NULL,
	[MobileTel] [varchar](11) NULL,
	[Email] [varchar](50) NULL,
	[CompanyAddress] [nvarchar](100) NULL,
	[ShopBanner] [varchar](100) NULL,
	[ShopBannerLink] [varchar](100) NULL,
	[CompanyLogo] [varchar](100) NULL,
	[CompanyIntroduce] [nvarchar](max) NULL,
	[UpdateDate] [datetime] NULL CONSTRAINT [DF_UserShopConfig_UpdateDate]  DEFAULT (getdate()),
	[CreateDate] [datetime] NULL CONSTRAINT [DF_UserShopConfig_CreateDate]  DEFAULT (getdate()),
	[Status] [int] NULL,
	[Remark] [nvarchar](100) NULL,
 CONSTRAINT [PK_UserShopConfig] PRIMARY KEY CLUSTERED 
(
	[ConfigID] 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 IDENTITY_INSERT [UserShopConfig] ON 

INSERT [UserShopConfig] ([ConfigID], [UserID], [Account], [Domain], [CompanyName], [Contact], [Tel], [MobileTel], [Email], [CompanyAddress], [ShopBanner], [ShopBannerLink], [CompanyLogo], [CompanyIntroduce], [UpdateDate], [CreateDate], [Status], [Remark]) VALUES (1, 6, N'user@bixiu.net', N'demo', N'北京新天地软件公司', N'safd', N'123456789', N'13012345678', N'sssxx@outlook.com', N'北京市西城区南新华街58号', N'Upload/thumbnail/20131024/af929193ec884216834ed5e4ce4a6c68.jpg', N'http://demo.bixiu.net', N'Upload/shop/2014/11/18/2db8ed951d8643628934049d5a665688.jpg', N'<p><span ffcc99=""><span style="color:#ff6666;">1sdfasf</span></span></p><p><span ffcc99=""><span style="color:#ff6666;">sa</span></span></p><p><span ffcc99=""><span style="color:#ffff33;"><em><u>fdddddd</u></em></span></span></p><p><span ffcc99=""><span style="color:#ffff33;">asfdas</span></span></p><p><span ffcc99=""><span style="color:#ff6666;">f11</span></span></p>', NULL, NULL, 1, NULL)
SET IDENTITY_INSERT [UserShopConfig] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'配置编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'ConfigID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'配置所属用户id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'可选,配置所属用户账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'Account'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'绑定的二级域名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'Domain'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'CompanyName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'Contact'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'Tel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'移动电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'MobileTel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'Email'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'CompanyAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商铺横幅广告' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'ShopBanner'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'横幅广告链接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'ShopBannerLink'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Logo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'CompanyLogo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'企业简介' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'CompanyIntroduce'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'UpdateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态,0等待审核,1已审核,2已关闭' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserShopConfig', @level2type=N'COLUMN',@level2name=N'Status'
GO
