dotnetnuke.data.sqldataprovider

完整的商业模板和强大的后台管理功能

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****	     Version 3.1.0 Data Install Script          *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for {databaseOwner} and {databaseOwner}    *****/
/*****                                                  *****/
/************************************************************/

SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @ptrval binary(16)

ALTER TABLE {databaseOwner}[{objectQualifier}TabModules] NOCHECK CONSTRAINT [FK_{objectQualifier}TabModules_{objectQualifier}Modules]
ALTER TABLE {databaseOwner}[{objectQualifier}TabModules] NOCHECK CONSTRAINT [FK_{objectQualifier}TabModules_{objectQualifier}Tabs]
ALTER TABLE {databaseOwner}[{objectQualifier}Modules] NOCHECK CONSTRAINT [FK_{objectQualifier}Modules_{objectQualifier}ModuleDefinitions]
ALTER TABLE {databaseOwner}[{objectQualifier}Modules] NOCHECK CONSTRAINT [FK_{objectQualifier}Modules_{objectQualifier}Portals]
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleDefinitions] NOCHECK CONSTRAINT [FK_{objectQualifier}ModuleDefinitions_{objectQualifier}DesktopModules]
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] NOCHECK CONSTRAINT [FK_{objectQualifier}Tabs_{objectQualifier}Portals]
ALTER TABLE {databaseOwner}[{objectQualifier}Tabs] NOCHECK CONSTRAINT [FK_{objectQualifier}Tabs_{objectQualifier}Tabs]
ALTER TABLE {databaseOwner}[{objectQualifier}TabPermission] NOCHECK CONSTRAINT [FK_{objectQualifier}TabPermission_{objectQualifier}Permission]
ALTER TABLE {databaseOwner}[{objectQualifier}TabPermission] NOCHECK CONSTRAINT [FK_{objectQualifier}TabPermission_{objectQualifier}Tabs]
ALTER TABLE {databaseOwner}[{objectQualifier}ModuleControls] NOCHECK CONSTRAINT [FK_{objectQualifier}ModuleControls_{objectQualifier}ModuleDefinitions]
ALTER TABLE {databaseOwner}[{objectQualifier}EventLogConfig] NOCHECK CONSTRAINT [FK_EventLogConfig_EventLogTypes]
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}EventLogConfig] ON
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (1, N'APPLICATION_START', NULL, 1, 10, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (2, N'APPLICATION_END', NULL, 1, 10, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (3, N'SCHEDULER_EXCEPTION', NULL, 1, 100, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (4, N'GENERAL_EXCEPTION', NULL, 1, 100, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (5, N'MODULE_LOAD_EXCEPTION', NULL, 1, 100, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (6, N'PAGE_LOAD_EXCEPTION', NULL, 1, 100, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (7, NULL, NULL, 1, -1, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (8, N'SCHEDULER_EVENT_STARTED', NULL, 0, -1, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (9, N'SCHEDULER_EVENT_PROGRESSING', NULL, 0, -1, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (10, N'SCHEDULER_EVENT_COMPLETED', NULL, 0, -1, 0, 1, 1, 1, N'', N'')
INSERT INTO {databaseOwner}[{objectQualifier}EventLogConfig] ([ID], [LogTypeKey], [LogTypePortalID], [LoggingIsActive], [KeepMostRecent], [EmailNotificationIsActive], [NotificationThreshold], [NotificationThresholdTime], [NotificationThresholdTimeType], [MailFromAddress], [MailToAddress]) VALUES (11, N'SCHEDULER_EVENT_FAILURE', NULL, 1, -1, 0, 1, 1, 1, N'', N'')
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}EventLogConfig] OFF
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}ModuleControls] ON
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (19, 12, NULL, NULL, N'Admin/Security/Roles.ascx', NULL, 0, NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (20, 12, N'Edit', N'Edit Security Roles', N'Admin/Security/EditRoles.ascx', N'icon_securityroles_32px.gif', 1, NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (21, 13, NULL, NULL, N'Admin/Tabs/Tabs.ascx', NULL, 0, NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (22, 13, N'Edit', N'Edit Tabs', N'Admin/Tabs/ManageTabs.ascx', N'icon_tabs_34px.gif', 1, NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (23, 14, NULL, NULL, N'Admin/Portal/SiteSettings.ascx', NULL, 0, NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (24, 15, NULL, NULL, N'Admin/Users/Users.ascx', NULL, 0, NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (25, 15, N'Edit', N'Edit User Accounts', N'Admin/Users/ManageUsers.ascx', N'icon_users_32px.gif', 1, NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (26, 19, NULL, NULL, N'Admin/Vendors/Vendors.ascx', NULL, 0, NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ModuleControlID], [ModuleDefID], [ControlKey], [ControlTitle], [ControlSrc], [IconFile], [ControlType], [ViewOrder], [HelpUrl]) VALUES (27, 19, N'Edit', N'Edit Vendors', N'Admin/Vendors/EditVendors.ascx', N'icon_vendors_32px.gif', -1, NULL, NULL)