JumboTCMS_src/JumboTCMS.WebFile/install/scripts/sqlserver/step1.sql

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

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

if exists (select * from sysobjects where id = OBJECT_ID('[jcms_module_article]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [jcms_module_article]
GO
CREATE TABLE [dbo].[jcms_module_article] (
	[Id] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelId] [int] NOT NULL DEFAULT(0),
	[ClassId] [int] NOT NULL DEFAULT(0),
	[Title] [nvarchar] (150) NOT NULL DEFAULT (''),
	[CollItemID] [int] NOT NULL DEFAULT(0),
	[TColor] [nvarchar] (8) NOT NULL DEFAULT (''),
	[AddTime] [datetime] NOT NULL DEFAULT (getdate()),
	[AddDate] [datetime] NOT NULL DEFAULT (getdate()),
	[Summary] [ntext] NOT NULL DEFAULT ('') ,
	[Editor] [nvarchar] (20) NOT NULL DEFAULT (''),
	[Author] [nvarchar] (30) NOT NULL DEFAULT (''),
	[Tags] [nvarchar] (60) NOT NULL DEFAULT (''),
	[ViewNum] [int] NOT NULL DEFAULT(0),
	[IsPass] [int] NOT NULL DEFAULT(0),
	[IsImg] [int] NOT NULL DEFAULT(0),
	[Img] [nvarchar] (150) NOT NULL DEFAULT (''),
	[IsTop] [int] NOT NULL DEFAULT(0),
	[IsFocus] [int] NOT NULL DEFAULT(0),
	[IsHead] [int] NOT NULL DEFAULT(0),
	[UserId] [int] NOT NULL DEFAULT(0),
	[ReadGroup] [int] NOT NULL DEFAULT(0),
	[SourceFrom] [nvarchar] (30) NOT NULL DEFAULT (''),
	[Content] [ntext] NOT NULL DEFAULT (''),
	[FirstPage] [nvarchar] (150) NOT NULL DEFAULT (''),
	[AliasPage] [nvarchar] (150) NOT NULL DEFAULT (''),
	CONSTRAINT [PK_module_article] PRIMARY KEY CLUSTERED 
	(
		[Id]
	) ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


if exists (select * from sysobjects where id = OBJECT_ID('[jcms_module_article_collfilters]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [jcms_module_article_collfilters]
GO
CREATE TABLE [dbo].[jcms_module_article_collfilters] (
[Id] [int]  IDENTITY (1, 1)  NOT NULL,
[ChannelId] [int]  NOT NULL DEFAULT (0),
[ItemId] [int]  NOT NULL DEFAULT (0),
[Title] [nvarchar]  (50) NULL,
[Filter_Object] [int]  NOT NULL DEFAULT (0),
[Filter_Type] [int]  NOT NULL DEFAULT (0),
[Filter_Content] [ntext]  NULL,
[FisString] [ntext]  NULL,
[FioString] [ntext]  NULL,
[Filter_Rep] [ntext]  NULL,
[Flag] [int]  NOT NULL DEFAULT (0),
[PublicTf] [int]  NOT NULL DEFAULT (0))
GO
ALTER TABLE [jcms_module_article_collfilters] WITH NOCHECK ADD  CONSTRAINT [PK_jcms_module_article_collfilters] PRIMARY KEY  NONCLUSTERED ( [Id] )
GO


if exists (select * from sysobjects where id = OBJECT_ID('[jcms_module_article_colllogs]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [jcms_module_article_colllogs]