📄 01.00.00.sqldataprovider

📁 SharpNuke源代码
💻 SQLDATAPROVIDER
📖 第 1 页 / 共 5 页
字号:
12 3 4 5 下一页
/************************************************************/
/*****                 Create Tables                    *****/
/************************************************************/

CREATE TABLE [dbo].[BannerTypes] (
	[BannerTypeId] [int] IDENTITY (1, 1) NOT NULL ,
	[BannerTypeName] [nvarchar] (50) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Classification] (
	[ClassificationId] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassificationName] [nvarchar] (200) NOT NULL ,
	[ParentId] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CodeCountry] (
	[Code] [char] (2) NOT NULL ,
	[Description] [varchar] (100) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CodeCurrency] (
	[Code] [char] (3) NOT NULL ,
	[Description] [varchar] (100) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CodeFrequency] (
	[Code] [char] (1) NOT NULL ,
	[Description] [nvarchar] (50) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CodeRegion] (
	[Code] [char] (2) NOT NULL ,
	[Description] [varchar] (100) NOT NULL ,
	[Country] [char] (2) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[FAQs] (
	[ItemID] [int] IDENTITY (0, 1) NOT NULL ,
	[ModuleID] [int] NOT NULL ,
	[CreatedByUser] [nvarchar] (100) NULL ,
	[CreatedDate] [datetime] NULL ,
	[Question] [text] NULL ,
	[Answer] [text] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Files] (
	[FileId] [int] IDENTITY (1, 1) NOT NULL ,
	[PortalId] [int] NULL ,
	[FileName] [nvarchar] (100) NOT NULL ,
	[Extension] [nvarchar] (100) NOT NULL ,
	[Size] [int] NOT NULL ,
	[Width] [int] NULL ,
	[Height] [int] NULL ,
	[ContentType] [nvarchar] (200) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ModuleDefinitions] (
	[ModuleDefID] [int] IDENTITY (1, 1) NOT NULL ,
	[FriendlyName] [nvarchar] (128) NOT NULL ,
	[DesktopSrc] [nvarchar] (256) NULL ,
	[MobileSrc] [nvarchar] (256) NULL ,
	[AdminOrder] [int] NULL ,
	[EditSrc] [nvarchar] (256) NULL ,
	[Secure] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Portals] (
	[PortalID] [int] IDENTITY (-1, 1) NOT NULL ,
	[PortalAlias] [nvarchar] (200) NOT NULL ,
	[PortalName] [nvarchar] (128) NOT NULL ,
	[UploadDirectory] [nvarchar] (100) NOT NULL ,
	[LogoFile] [nvarchar] (50) NULL ,
	[FooterText] [nvarchar] (100) NULL ,
	[ExpiryDate] [datetime] NULL ,
	[UserRegistration] [int] NULL ,
	[BannerAdvertising] [int] NULL ,
	[AdministratorId] [int] NULL ,
	[PayPalId] [nvarchar] (50) NULL ,
	[Currency] [char] (3) NULL ,
	[HostFee] [nvarchar] (10) NULL ,
	[HostSpace] [int] NULL ,
	[AdministratorRoleId] [int] NULL ,
	[RegisteredRoleId] [int] NULL ,
	[GUID] [uniqueidentifier] NOT NULL CONSTRAINT DF_Portals_GUID DEFAULT newid()
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Users] (
	[UserID] [int] IDENTITY (1, 1) NOT NULL ,
	[FirstName] [nvarchar] (50) NOT NULL ,
	[LastName] [nvarchar] (50) NULL ,
	[Street] [nvarchar] (20) NULL ,
	[City] [nvarchar] (20) NULL ,
	[Region] [nvarchar] (20) NULL ,
	[PostalCode] [nvarchar] (10) NULL ,
	[Country] [nvarchar] (20) NULL ,
	[Password] [nvarchar] (20) NOT NULL ,
	[Email] [nvarchar] (100) NOT NULL ,
	[CreatedDate] [datetime] NULL ,
	[LastLoginDate] [datetime] NULL ,
	[Unit] [nvarchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Roles] (
	[RoleID] [int] IDENTITY (0, 1) NOT NULL ,
	[PortalID] [int] NULL ,
	[RoleName] [nvarchar] (50) NOT NULL ,
	[Description] [nvarchar] (1000) NULL ,
	[ServiceFee] [decimal](5, 2) NULL ,
	[BillingFrequency] [char] (1) NULL ,
	[TrialPeriod] [int] NULL ,
	[TrialFrequency] [char] (1) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SiteLog] (
	[SiteLogId] [int] IDENTITY (1, 1) NOT NULL ,
	[DateTime] [smalldatetime] NOT NULL ,
	[PortalId] [int] NOT NULL ,
	[UserId] [int] NULL ,
	[Referrer] [nvarchar] (255) NULL ,
	[Url] [nvarchar] (255) NULL ,
	[UserAgent] [nvarchar] (255) NULL ,
	[UserHostAddress] [nvarchar] (255) NULL ,
	[UserHostName] [nvarchar] (255) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Tabs] (
	[TabID] [int] IDENTITY (0, 1) NOT NULL ,
	[TabOrder] [int] NOT NULL ,
	[PortalID] [int] NULL ,
	[TabName] [nvarchar] (50) NOT NULL ,
	[MobileTabName] [nvarchar] (50) NOT NULL ,
	[AuthorizedRoles] [nvarchar] (256) NULL ,
	[ShowMobile] [bit] NOT NULL ,
	[LeftPaneWidth] [nvarchar] (5) NOT NULL ,
	[RightPaneWidth] [nvarchar] (5) NOT NULL ,
	[IsVisible] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[UserPortals] (
	[UserId] [int] NOT NULL ,
	[PortalId] [int] NOT NULL ,
	[Authorized] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[VendorLog] (
	[VendorLogId] [int] IDENTITY (1, 1) NOT NULL ,
	[DateTime] [datetime] NOT NULL ,
	[PortalId] [int] NOT NULL ,
	[VendorId] [int] NOT NULL ,
	[BannerId] [int] NULL ,
	[Search] [nvarchar] (200) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[VendorSearch] (
	[VendorSearchId] [int] IDENTITY (1, 1) NOT NULL ,
	[PortalId] [int] NULL ,
	[DateTime] [datetime] NOT NULL ,
	[Search] [nvarchar] (200) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Vendors] (
	[VendorId] [int] IDENTITY (1, 1) NOT NULL ,
	[VendorName] [nvarchar] (50) NOT NULL ,
	[Street] [nvarchar] (50) NULL ,
	[City] [nvarchar] (50) NULL ,
	[Region] [nvarchar] (50) NULL ,
	[Country] [nvarchar] (50) NULL ,
	[PostalCode] [nvarchar] (50) NULL ,
	[Telephone] [nvarchar] (50) NULL ,
	[PortalId] [int] NULL ,
	[Fax] [nvarchar] (50) NULL ,
	[Email] [nvarchar] (50) NULL ,
	[Website] [nvarchar] (100) NULL ,
	[Contact] [nvarchar] (50) NULL ,
	[ClickThroughs] [int] NOT NULL ,
	[Views] [int] NOT NULL ,
	[CreatedByUser] [nvarchar] (100) NULL ,
	[CreatedDate] [datetime] NULL ,
	[LogoFile] [nvarchar] (100) NULL ,
	[KeyWords] [text] NULL ,
	[Unit] [nvarchar] (50) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Banners] (
	[BannerId] [int] IDENTITY (1, 1) NOT NULL ,
	[VendorId] [int] NOT NULL ,
	[ImageFile] [nvarchar] (100) NOT NULL ,
	[BannerName] [nvarchar] (100) NOT NULL ,
	[URL] [nvarchar] (100) NULL ,
	[Impressions] [int] NOT NULL ,
	[CPM] [float] NOT NULL ,
	[Views] [int] NOT NULL ,
	[ClickThroughs] [int] NOT NULL ,
	[StartDate] [datetime] NULL ,
	[EndDate] [datetime] NULL ,
	[CreatedByUser] [nvarchar] (100) NOT NULL ,
	[CreatedDate] [datetime] NOT NULL ,
	[BannerTypeId] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Modules] (
	[ModuleID] [int] IDENTITY (0, 1) NOT NULL ,
	[TabID] [int] NOT NULL ,
	[ModuleDefID] [int] NOT NULL ,
	[ModuleOrder] [int] NOT NULL ,
	[PaneName] [nvarchar] (50) NOT NULL ,
	[ModuleTitle] [nvarchar] (256) NULL ,
	[AuthorizedEditRoles] [nvarchar] (256) NULL ,
	[CacheTime] [int] NOT NULL ,
	[ShowMobile] [bit] NULL ,
	[AuthorizedViewRoles] [nvarchar] (256) NULL ,
	[Alignment] [nvarchar] (10) NULL ,
	[Color] [nvarchar] (20) NULL ,
	[Border] [nvarchar] (1) NULL ,
	[IconFile] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[UserRoles] (
	[UserRoleID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserID] [int] NOT NULL ,
	[RoleID] [int] NOT NULL ,
	[ExpiryDate] [datetime] NULL ,
	[IsTrialUsed] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[VendorClassification] (
	[VendorClassificationId] [int] IDENTITY (1, 1) NOT NULL ,
	[VendorId] [int] NOT NULL ,
	[ClassificationId] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[VendorFeedback] (
	[VendorFeedbackId] [int] IDENTITY (1, 1) NOT NULL ,
	[VendorId] [int] NOT NULL ,
	[UserId] [int] NOT NULL ,
	[Date] [datetime] NOT NULL ,
	[Comment] [nvarchar] (4000) NOT NULL ,
	[Value] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Announcements] (
	[ItemID] [int] IDENTITY (0, 1) NOT NULL ,
	[ModuleID] [int] NOT NULL ,
	[CreatedByUser] [nvarchar] (100) NULL ,
	[CreatedDate] [datetime] NULL ,
	[Title] [nvarchar] (150) NULL ,
	[URL] [nvarchar] (150) NULL ,
	[ExpireDate] [datetime] NULL ,
	[Description] [nvarchar] (2000) NULL ,
	[Syndicate] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Contacts] (
	[ItemID] [int] IDENTITY (0, 1) NOT NULL ,
	[ModuleID] [int] NOT NULL ,
	[CreatedByUser] [nvarchar] (100) NULL ,
	[CreatedDate] [datetime] NULL ,
	[Name] [nvarchar] (50) NULL ,
	[Role] [nvarchar] (100) NULL ,
	[Email] [nvarchar] (100) NULL ,
	[Contact1] [nvarchar] (250) NULL ,
	[Contact2] [nvarchar] (250) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Discussion] (
	[ItemID] [int] IDENTITY (0, 1) NOT NULL ,
	[ModuleID] [int] NOT NULL ,
	[Title] [nvarchar] (100) NULL ,
	[CreatedDate] [datetime] NULL ,
	[Body] [nvarchar] (3000) NULL ,
	[DisplayOrder] [nvarchar] (750) NULL ,
	[CreatedByUser] [nvarchar] (100) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Documents] (
	[ItemID] [int] IDENTITY (0, 1) NOT NULL ,
	[ModuleID] [int] NOT NULL ,
	[CreatedByUser] [nvarchar] (100) NULL ,
	[CreatedDate] [datetime] NULL ,
	[URL] [nvarchar] (250) NULL ,
	[Title] [nvarchar] (150) NULL ,
	[Category] [nvarchar] (50) NULL ,
	[Syndicate] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[HtmlText] (
	[ModuleID] [int] NOT NULL ,
	[DesktopHtml] [ntext] NOT NULL ,
	[MobileSummary] [ntext] NOT NULL ,
	[MobileDetails] [ntext] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Links] (
	[ItemID] [int] IDENTITY (0, 1) NOT NULL ,
	[ModuleID] [int] NOT NULL ,
	[CreatedByUser] [nvarchar] (100) NULL ,
	[CreatedDate] [datetime] NULL ,
	[Title] [nvarchar] (100) NULL ,
	[Url] [nvarchar] (250) NULL ,
	[MobileUrl] [nvarchar] (250) NULL ,
	[ViewOrder] [int] NULL ,
	[Description] [nvarchar] (2000) NULL ,
	[NewWindow] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ModuleEvents] (
	[ItemID] [int] IDENTITY (0, 1) NOT NULL ,
	[ModuleID] [int] NOT NULL ,
	[Description] [nvarchar] (2000) NOT NULL ,
	[DateTime] [datetime] NOT NULL ,
	[Title] [nvarchar] (100) NOT NULL ,
	[ExpireDate] [datetime] NULL ,
	[CreatedByUser] [nvarchar] (200) NOT NULL ,
	[CreatedDate] [datetime] NOT NULL ,
	[Every] [int] NULL ,
	[Period] [char] (1) NULL ,
	[IconFile] [nvarchar] (256) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ModuleSettings] (
	[ModuleID] [int] NOT NULL ,
	[SettingName] [nvarchar] (50) NOT NULL ,
	[SettingValue] [nvarchar] (256) NOT NULL 
) ON [PRIMARY]
GO


/************************************************************/
/*****   Create Primary Keys, Foreign Key Constraints   *****/
/************************************************************/


ALTER TABLE [dbo].[BannerTypes] WITH NOCHECK ADD 
	CONSTRAINT [PK_BannerType] PRIMARY KEY  CLUSTERED 
	(
		[BannerTypeId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Classification] WITH NOCHECK ADD 
	CONSTRAINT [PK_VendorCategory] PRIMARY KEY  CLUSTERED 
	(
		[ClassificationId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CodeCurrency] WITH NOCHECK ADD 
	CONSTRAINT [PK_CodeCurrency] PRIMARY KEY  CLUSTERED 
	(
		[Code]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CodeFrequency] WITH NOCHECK ADD 
	CONSTRAINT [PK_CodeFrequency] PRIMARY KEY  CLUSTERED 
	(
		[Code]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Files] WITH NOCHECK ADD 
	CONSTRAINT [PK_File] PRIMARY KEY  CLUSTERED 
	(
		[FileId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SiteLog] WITH NOCHECK ADD 
	CONSTRAINT [PK_SiteLog] PRIMARY KEY  CLUSTERED 
	(
		[SiteLogId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[UserPortals] WITH NOCHECK ADD 
	CONSTRAINT [PK_UserPortals] PRIMARY KEY  CLUSTERED 
	(
		[UserId],
		[PortalId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[VendorLog] WITH NOCHECK ADD 
	CONSTRAINT [PK_VendorLog] PRIMARY KEY  CLUSTERED 
	(
		[VendorLogId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[VendorSearch] WITH NOCHECK ADD 
	CONSTRAINT [PK_VendorSearch] PRIMARY KEY  CLUSTERED 
	(
		[VendorSearchId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Vendors] WITH NOCHECK ADD 
	CONSTRAINT [PK_Vendor] PRIMARY KEY  CLUSTERED 
	(
		[VendorId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Banners] WITH NOCHECK ADD 
	CONSTRAINT [PK_Banner] PRIMARY KEY  CLUSTERED 
	(
		[BannerId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[UserRoles] WITH NOCHECK ADD 
	CONSTRAINT [PK_UserRoles] PRIMARY KEY  CLUSTERED 
	(
		[UserRoleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[VendorClassification] WITH NOCHECK ADD 
	CONSTRAINT [PK_VendorClassification] PRIMARY KEY  CLUSTERED 
	(
		[VendorClassificationId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[VendorFeedback] WITH NOCHECK ADD 
	CONSTRAINT [PK_VendorFeedback] PRIMARY KEY  CLUSTERED 
	(
		[VendorFeedbackId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ModuleDefinitions] WITH NOCHECK ADD 
	CONSTRAINT [DF_ModuleDefinitions_Secure] DEFAULT (1) FOR [Secure],
	CONSTRAINT [PK_ModuleDefinitions] PRIMARY KEY  NONCLUSTERED 
	(
		[ModuleDefID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Portals] WITH NOCHECK ADD 
	CONSTRAINT [PK_Portals] PRIMARY KEY  NONCLUSTERED 
	(
		[PortalID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Users] WITH NOCHECK ADD 
	CONSTRAINT [PK_Users] PRIMARY KEY  NONCLUSTERED 
	(
		[UserID]
	)  ON [PRIMARY] ,
	CONSTRAINT [IX_Users] UNIQUE  NONCLUSTERED 
	(
		[Email]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Roles] WITH NOCHECK ADD 
	CONSTRAINT [DF_Roles_ServiceFee] DEFAULT (0) FOR [ServiceFee],
	CONSTRAINT [PK_Roles] PRIMARY KEY  NONCLUSTERED 
	(
		[RoleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Tabs] WITH NOCHECK ADD 
	CONSTRAINT [DF_Tabs_IsVisible] DEFAULT (1) FOR [IsVisible],
	CONSTRAINT [PK_Tabs] PRIMARY KEY  NONCLUSTERED 
	(
		[TabID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Vendors] WITH NOCHECK ADD 
	CONSTRAINT [DF_Vendors_ClickThroughs] DEFAULT (0) FOR [ClickThroughs],
	CONSTRAINT [DF_Vendors_Views] DEFAULT (0) FOR [Views]
GO

ALTER TABLE [dbo].[Banners] WITH NOCHECK ADD 
	CONSTRAINT [DF_Banners_Views] DEFAULT (0) FOR [Views],
	CONSTRAINT [DF_Banners_ClickThroughs] DEFAULT (0) FOR [ClickThroughs]
GO

ALTER TABLE [dbo].[Modules] WITH NOCHECK ADD 
	CONSTRAINT [PK_Modules] PRIMARY KEY  NONCLUSTERED 
	(
		[ModuleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Announcements] WITH NOCHECK ADD 
	CONSTRAINT [PK_Announcements] PRIMARY KEY  NONCLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD 
	CONSTRAINT [PK_Contacts] PRIMARY KEY  NONCLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Discussion] WITH NOCHECK ADD 
	CONSTRAINT [PK_Discussion] PRIMARY KEY  NONCLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Documents] WITH NOCHECK ADD 
	CONSTRAINT [PK_Documents] PRIMARY KEY  NONCLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[HtmlText] WITH NOCHECK ADD 
	CONSTRAINT [PK_HtmlText] PRIMARY KEY  NONCLUSTERED 
	(
		[ModuleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Links] WITH NOCHECK ADD 
	CONSTRAINT [DF_Links_NewWindow] DEFAULT (0) FOR [NewWindow],
	CONSTRAINT [PK_Links] PRIMARY KEY  NONCLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ModuleEvents] WITH NOCHECK ADD 
	CONSTRAINT [PK_Events] PRIMARY KEY  NONCLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_ModuleSettings] ON [dbo].[ModuleSettings]([ModuleID], [SettingName]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Classification] ADD 
	CONSTRAINT [FK_Classification_Classification] FOREIGN KEY 
	(
		[ParentId]
	) REFERENCES [dbo].[Classification] (
		[ClassificationId]
	) NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Roles] ADD 
	CONSTRAINT [FK_Roles_CodeFrequency] FOREIGN KEY 
	(
		[BillingFrequency]
	) REFERENCES [dbo].[CodeFrequency] (
		[Code]
	) NOT FOR REPLICATION ,
	CONSTRAINT [FK_Roles_Portals] FOREIGN KEY 
	(
		[PortalID]
	) REFERENCES [dbo].[Portals] (
		[PortalID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[SiteLog] ADD 
	CONSTRAINT [FK_SiteLog_Portals] FOREIGN KEY 
	(
		[PortalId]
	) REFERENCES [dbo].[Portals] (
		[PortalID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Tabs] ADD 
	CONSTRAINT [FK_Tabs_Portals] FOREIGN KEY 
	(
		[PortalID]
	) REFERENCES [dbo].[Portals] (
		[PortalID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[UserPortals] ADD 
	CONSTRAINT [FK_UserPortals_Portals] FOREIGN KEY 
	(
		[PortalId]
	) REFERENCES [dbo].[Portals] (
		[PortalID]
	) ON DELETE CASCADE  NOT FOR REPLICATION ,
	CONSTRAINT [FK_UserPortals_Users] FOREIGN KEY 
	(
		[UserId]
	) REFERENCES [dbo].[Users] (
		[UserID]
	) NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[VendorLog] ADD 
	CONSTRAINT [FK_VendorLog_Portals] FOREIGN KEY 
	(
		[PortalId]
	) REFERENCES [dbo].[Portals] (
		[PortalID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[VendorSearch] ADD 
	CONSTRAINT [FK_VendorSearch_Portals] FOREIGN KEY 
	(
		[PortalId]
	) REFERENCES [dbo].[Portals] (
		[PortalID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Vendors] ADD 
	CONSTRAINT [FK_Vendor_Portals] FOREIGN KEY 
	(
		[PortalId]
	) REFERENCES [dbo].[Portals] (
		[PortalID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Banners] ADD 
	CONSTRAINT [FK_Banner_Vendor] FOREIGN KEY 
	(
		[VendorId]
	) REFERENCES [dbo].[Vendors] (
		[VendorId]
	) ON DELETE CASCADE  NOT FOR REPLICATION ,
	CONSTRAINT [FK_Banners_BannerType] FOREIGN KEY 
	(
		[BannerTypeId]
	) REFERENCES [dbo].[BannerTypes] (
		[BannerTypeId]
	) NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Modules] ADD 
	CONSTRAINT [FK_Modules_ModuleDefinitions] FOREIGN KEY 
	(
		[ModuleDefID]
	) REFERENCES [dbo].[ModuleDefinitions] (
		[ModuleDefID]
	) ON DELETE CASCADE  NOT FOR REPLICATION ,
	CONSTRAINT [FK_Modules_Tabs] FOREIGN KEY 
	(
		[TabID]
	) REFERENCES [dbo].[Tabs] (
		[TabID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[UserRoles] ADD 
	CONSTRAINT [FK_UserRoles_Roles] FOREIGN KEY 
	(
		[RoleID]
	) REFERENCES [dbo].[Roles] (
		[RoleID]
	) ON DELETE CASCADE  NOT FOR REPLICATION ,
	CONSTRAINT [FK_UserRoles_Users] FOREIGN KEY 
	(
		[UserID]
	) REFERENCES [dbo].[Users] (
		[UserID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[VendorClassification] ADD 
	CONSTRAINT [FK_VendorClassification_Classification] FOREIGN KEY 
	(
		[ClassificationId]
	) REFERENCES [dbo].[Classification] (
		[ClassificationId]
	) NOT FOR REPLICATION ,
	CONSTRAINT [FK_VendorClassification_Vendors] FOREIGN KEY 
	(
		[VendorId]
	) REFERENCES [dbo].[Vendors] (
		[VendorId]
	) NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[VendorFeedback] ADD 
	CONSTRAINT [FK_VendorFeedback_Vendors] FOREIGN KEY 
	(
		[VendorId]
	) REFERENCES [dbo].[Vendors] (
		[VendorId]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Announcements] ADD 
	CONSTRAINT [FK_Announcements_Modules] FOREIGN KEY 
	(
		[ModuleID]
	) REFERENCES [dbo].[Modules] (
		[ModuleID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Contacts] ADD 
	CONSTRAINT [FK_Contacts_Modules] FOREIGN KEY 
	(
		[ModuleID]
	) REFERENCES [dbo].[Modules] (
		[ModuleID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Discussion] ADD 
	CONSTRAINT [FK_Discussion_Modules] FOREIGN KEY 
	(
		[ModuleID]
	) REFERENCES [dbo].[Modules] (
		[ModuleID]
	) ON DELETE CASCADE  NOT FOR REPLICATION 
GO

ALTER TABLE [dbo].[Documents] ADD 
	CONSTRAINT [FK_Documents_Modules] FOREIGN KEY 
	(
12 3 4 5 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -