📄 dbo.community_custom_redirect.sql
字号:
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'Community_Custom_Redirect')
BEGIN
DROP Table dbo.Community_Custom_Redirect
END
GO
CREATE TABLE dbo.Community_Custom_Redirect
(
[redirect_communityID] [int] NOT NULL ,
[redirect_SourceURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[redirect_DestinationURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[redirect_isSectionRedirect] [bit] NOT NULL
)
GO
ALTER TABLE [dbo].[Community_Custom_Redirect] WITH NOCHECK ADD
CONSTRAINT [PK_Community_Custom_Redirect] PRIMARY KEY CLUSTERED
(
[redirect_communityID],
[redirect_SourceURL]
)
GO
ALTER TABLE [dbo].[Community_Custom_Redirect] ADD
CONSTRAINT [FK_Community_Custom_Redirect_Community_Communities] FOREIGN KEY
(
[redirect_communityID]
) REFERENCES [dbo].[Community_Communities] (
[community_id]
) ON DELETE CASCADE
GO
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -