AppData/Install.sql

(开头部分) 2KB

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

/****** Object:  Table [dbo].[article]    Script Date: 2023/3/3 9:58:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[article](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[columnId] [int] NULL CONSTRAINT [DF_news_columnId]  DEFAULT ((0)),
	[state] [smallint] NULL CONSTRAINT [DF_news_state]  DEFAULT ((0)),
	[isGood] [tinyint] NULL CONSTRAINT [DF_news_isGood]  DEFAULT ((0)),
	[isHot] [tinyint] NULL CONSTRAINT [DF_news_isHot]  DEFAULT ((0)),
	[isTop] [tinyint] NULL CONSTRAINT [DF_news_isTop]  DEFAULT ((0)),
	[publishFrom] [tinyint] NULL CONSTRAINT [DF_news_publishFrom]  DEFAULT ((0)),
	[isOnline] [tinyint] NULL CONSTRAINT [DF_news_isOnline]  DEFAULT ((0)),
	[isExpire] [tinyint] NULL CONSTRAINT [DF_news_isExpire]  DEFAULT ((0)),
	[hasThumbnail] [tinyint] NULL CONSTRAINT [DF_news_hasThumbnail]  DEFAULT ((0)),
	[uid] [int] NULL CONSTRAINT [DF_news_uid]  DEFAULT ((0)),
	[username] [nvarchar](50) NULL,
	[replyState] [tinyint] NULL CONSTRAINT [DF_news_replyState]  DEFAULT ((0)),
	[clicks] [int] NULL CONSTRAINT [DF_news_clicks]  DEFAULT ((0)),
	[comments] [int] NULL CONSTRAINT [DF_news_comments]  DEFAULT ((0)),
	[title] [nvarchar](150) NULL,
	[thumbnail] [varchar](250) NULL,
	[content] [nvarchar](max) NULL,
	[thedate] [datetime] NULL CONSTRAINT [DF_news_thedate]  DEFAULT (getdate()),
	[introduction] [nvarchar](300) NULL,
	[author] [nvarchar](50) NULL,
	[relativeIds] [nvarchar](200) NULL,
	[isSubColumnData] [tinyint] NULL,
	[ip] [varchar](150) NULL,
 CONSTRAINT [PK_news_id] PRIMARY KEY CLUSTERED 
(
	[id] 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 ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[article_seo_set]    Script Date: 2023/3/3 9:58:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[article_seo_set](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[detailId] [int] NULL,
	[title] [nvarchar](150) NULL,
	[keywords] [nvarchar](150) NULL,
	[description] [nvarchar](250) NULL,
 CONSTRAINT [PK_news_seo_set_id] PRIMARY KEY CLUSTERED 
(
	[id] 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
/****** Object:  Table [dbo].[article_template_set]    Script Date: 2023/3/3 9:58:01 ******/

24 小时内免费解锁 3 个项目,之后 1 积分/个。 规则说明

AI 解读

登录后可用,每次 10 积分,解读结果公开显示在下面。

还没有人解读过这个文件。