SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [UploadConfig](
	[UploadConfigID] [int] NOT NULL CONSTRAINT [DF_UploadConfig_UploadConfigID]  DEFAULT ((1)),
	[SavePath] [varchar](100) NULL,
	[VisitPath] [varchar](100) NULL,
	[UploadType] [varchar](50) NULL,
	[MaximumSize] [int] NULL CONSTRAINT [DF_UploadConfig_MaximumSize]  DEFAULT ((1024)),
	[MarkType] [int] NULL CONSTRAINT [DF_UploadConfig_MarkType]  DEFAULT ((1)),
	[MarkCondition] [varchar](50) NULL CONSTRAINT [DF_UploadConfig_MarkCondition]  DEFAULT ((0)|(0)),
	[MarkPosition] [int] NULL CONSTRAINT [DF_UploadConfig_MarkPosition]  DEFAULT ((0)),
	[ImageMarkPath] [varchar](100) NULL,
	[TextMark] [nvarchar](50) NULL,
 CONSTRAINT [PK_UploadConfig] PRIMARY KEY CLUSTERED 
(
	[UploadConfigID] 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
INSERT [UploadConfig] ([UploadConfigID], [SavePath], [VisitPath], [UploadType], [MaximumSize], [MarkType], [MarkCondition], [MarkPosition], [ImageMarkPath], [TextMark]) VALUES (1, N'Upload/', N'UploadFiles/', N'.jpg|.jpeg|.gif|.png|.bmp', 501, 1, N'0|0', 0, N'', N'碧秀CMS')
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键,非自增长编号,固定为1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'UploadConfigID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保存相对路径(路径前不加/符号,结属要加/符号)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'SavePath'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'访问路径,当前网站下的Url相对路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'VisitPath'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许上传的文件类型,多个使用|符号分隔,如(默认为.jpeg|.jpg|.gif|.png)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'UploadType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许上传的最大文件大小,单位为kb,默认为1024kb' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'MaximumSize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表标类型(1为文本,2为图片)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'MarkType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加水印的条件(宽|高),大于或等于尺寸时才加水印(默认为0|0)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'MarkCondition'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片水印位置(0123456789),0表示不加水印' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'MarkPosition'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'使用图片做水印时,水印图片文件保存的相对位置' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'ImageMarkPath'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'使用文本做标记的文本内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UploadConfig', @level2type=N'COLUMN',@level2name=N'TextMark'
GO
