dotnetnuke.data.sqldataprovider

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

INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (13, N'Tabs', 11, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (14, N'Site Settings', 12, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (15, N'User Accounts', 13, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (19, N'Vendors', 14, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (20, N'Banners', 15, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (21, N'File Manager', 16, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (27, N'Site Log', 18, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (28, N'Bulk Email', 19, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (63, N'Portals', 22, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (64, N'Module Definitions', 23, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (65, N'SQL', 24, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (72, N'Host Settings', 30, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (74, N'Account Login', 32, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (75, N'User Account', 33, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (76, N'Recycle Bin', 34, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (78, N'Module Definition Validator', 36, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (79, N'Log Viewer', 37, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (80, N'Schedule', 38, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (81, N'Skins', 39, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (82, N'Export Template', 40, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (83, N'Languages', 41, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (84, N'Custom Portal Locale', 42, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (85, N'Search Admin', 43, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (86, N'Search Input', 44, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (87, N'Search Results', 45, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (88, N'Site Wizard', 46, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (89, N'Portal Aliases', 47, 0)
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (90, N'Lists', 48, 0)
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}ModuleDefinitions] OFF
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}Schedule] ON
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (1, 'DotNetNuke.Entities.Users.PurgeUsersOnline, DOTNETNUKE', 1, 'm', 5, 'm', 60, '', 0, 0, 'UsersOnline', NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (2, 'DotNetNuke.Services.Log.SiteLog.PurgeSiteLog, DOTNETNUKE', 1, 'd', 2, 'h', 10, '', 0, 0, 'SiteLog', NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (3, 'DotNetNuke.Services.Scheduling.PurgeScheduleHistory, DOTNETNUKE', 1, 'd', 2, 'd', 60, '', 0, 1, 'ScheduleHistory', NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (4, 'DotNetNuke.Services.Log.EventLog.PurgeLogBuffer, DOTNETNUKE', 1, 'm', 5, 'm', 60, '', 0, 0, 'EventLog', NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (5, 'DotNetNuke.Services.Log.EventLog.SendLogNotifications, DOTNETNUKE', 5, 'm', 10, 'm', 60, '', 0, 0, 'EventLog', NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (6, 'DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE', 30, 'm', 60, 'm', 60, '', 0, 1, 'SearchEngine', NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (7, 'DotNetNuke.Modules.Admin.ResourceInstaller.InstallResources, DOTNETNUKE', 30, 'm', 60, 'm', 60, '', 0, 0, 'ResourceInstaller', NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (8, 'DotNetNuke.Services.FileSystem.SynchronizeFileSystem, DOTNETNUKE', 1, 'h', 2, 'h', 10, '', 0, 0, 'FileSystemUtils', NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Schedule] ([ScheduleID], [TypeFullName], [TimeLapse], [TimeLapseMeasurement], [RetryTimeLapse], [RetryTimeLapseMeasurement], [RetainHistoryNum], [AttachToEvent], [CatchUpEnabled], [Enabled], [ObjectDependencies], [Servers]) VALUES (9, 'DotNetNuke.Services.Cache.PurgeCache, DOTNETNUKE', 2, 'h', 30, 'm', 10, '', 0, 0, '', NULL)
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}Schedule] OFF
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}Permission] ON
INSERT INTO {databaseOwner}[{objectQualifier}Permission] ([PermissionID], [PermissionCode], [ModuleDefID], [PermissionKey], [PermissionName]) VALUES (1, 'SYSTEM_MODULE_DEFINITION', -1, 'VIEW', 'View')
INSERT INTO {databaseOwner}[{objectQualifier}Permission] ([PermissionID], [PermissionCode], [ModuleDefID], [PermissionKey], [PermissionName]) VALUES (2, 'SYSTEM_MODULE_DEFINITION', -1, 'EDIT', 'Edit')
INSERT INTO {databaseOwner}[{objectQualifier}Permission] ([PermissionID], [PermissionCode], [ModuleDefID], [PermissionKey], [PermissionName]) VALUES (3, 'SYSTEM_TAB', -1, 'VIEW', 'View Tab')
INSERT INTO {databaseOwner}[{objectQualifier}Permission] ([PermissionID], [PermissionCode], [ModuleDefID], [PermissionKey], [PermissionName]) VALUES (4, 'SYSTEM_TAB', -1, 'EDIT', 'Edit Tab')
INSERT INTO {databaseOwner}[{objectQualifier}Permission] ([PermissionID], [PermissionCode], [ModuleDefID], [PermissionKey], [PermissionName]) VALUES (5, 'SYSTEM_FOLDER', -1, 'READ', 'View Folder')
INSERT INTO {databaseOwner}[{objectQualifier}Permission] ([PermissionID], [PermissionCode], [ModuleDefID], [PermissionKey], [PermissionName]) VALUES (6, 'SYSTEM_FOLDER', -1, 'WRITE', 'Write to Folder')
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}Permission] OFF
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}Modules] ON
INSERT INTO {databaseOwner}[{objectQualifier}Modules] ([ModuleID], [ModuleDefID], [ModuleTitle], [AllTabs], [IsDeleted], [InheritViewPermissions], [Header], [Footer], [StartDate], [EndDate], [PortalID]) VALUES (335, 83, N'Languages', 0, 0, 1, NULL, NULL, NULL, NULL, NULL)
INS