dbo.community_custom_redirect.sql

来自「非常不错的学校在线考试分析系统」· SQL 代码 · 共 30 行

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