Database/Update/3.4/MsSql.sql

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

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

IF NOT EXISTS (SELECT 1 FROM sysobjects WHERE name = N'FluidContentType' AND TYPE = 'u')
BEGIN
	CREATE TABLE [dbo].[FluidContentType](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[Title] [nvarchar](100) NULL,
		[ContentSchema] [nvarchar](max) NULL,
		[Description] [nvarchar](500) NULL,
		[Status] [int] NULL,
		[CreateBy] [nvarchar](50) NULL,
		[CreatebyName] [nvarchar](100) NULL,
		[CreateDate] [datetime] NULL,
		[LastUpdateBy] [nvarchar](50) NULL,
		[LastUpdateByName] [nvarchar](100) NULL,
		[LastUpdateDate] [datetime] NULL
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
IF NOT EXISTS (SELECT 1 FROM sysobjects WHERE name = N'FluidContentValue' AND TYPE = 'u')
BEGIN
	CREATE TABLE [dbo].[FluidContentValue](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[ContentTypeID] [int] NULL,
		[Title] [nvarchar](100) NULL,
		[Content] [nvarchar](max) NULL,
		[Description] [nvarchar](500) NULL,
		[Status] [int] NULL,
		[CreateBy] [nvarchar](50) NULL,
		[CreatebyName] [nvarchar](100) NULL,
		[CreateDate] [datetime] NULL,
		[LastUpdateBy] [nvarchar](50) NULL,
		[LastUpdateByName] [nvarchar](100) NULL,
		[LastUpdateDate] [datetime] NULL,
		[ContentID] [nvarchar](100) NULL,
		[CultureID] [int] NULL,
		[Url] [nvarchar](200) NULL,
		[SEOTitle] [nvarchar](200) NULL,
		[SEOKeyWord] [nvarchar](200) NULL,
		[SEODescription] [nvarchar](200) NULL
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
IF NOT EXISTS (SELECT 1 FROM sysobjects WHERE name = N'FluidContentTemplate' AND TYPE = 'u')
BEGIN
	CREATE TABLE [dbo].[FluidContentTemplate](
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[Title] [nvarchar](100) NULL,
		[ApplyTo] [nvarchar](100) NULL,
		[Template] [nvarchar](max) NULL,
		[Description] [nvarchar](500) NULL,
		[Status] [int] NULL,
		[CreateBy] [nvarchar](50) NULL,
		[CreatebyName] [nvarchar](100) NULL,
		[CreateDate] [datetime] NULL,
		[LastUpdateBy] [nvarchar](50) NULL,
		[LastUpdateByName] [nvarchar](100) NULL,
		[LastUpdateDate] [datetime] NULL
	) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END

CREATE TABLE [dbo].[FluidContentGroup](
	[ID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
	[Title] [nvarchar](255) NULL,