dotnetnuke.data.sqldataprovider

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

INSERT INTO {databaseOwner}[{objectQualifier}TabPermission] ([TabPermissionID], [TabID], [PermissionID], [RoleID], [AllowAccess]) VALUES (33, 34, 3, -2, 1)
INSERT INTO {databaseOwner}[{objectQualifier}TabPermission] ([TabPermissionID], [TabID], [PermissionID], [RoleID], [AllowAccess]) VALUES (34, 35, 3, -2, 1)
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}TabPermission] OFF
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}Tabs] ON
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (7, 1, NULL, N'Host', 1, NULL, 0, N'', 1, N'', N'', N'', 0, N'', NULL, NULL, N'//Host', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (18, 5, NULL, N'Module Definitions', 1, 7, 1, N'icon_moduledefinitions_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Module Definitions', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (16, 1, NULL, N'Host Settings', 1, 7, 1, N'icon_hostsettings_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Host Settings', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (19, 7, NULL, N'File Manager', 1, 7, 1, N'icon_filemanager_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//File Manager', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (17, 3, NULL, N'Portals', 1, 7, 1, N'icon_portals_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Portals', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (20, 9, NULL, N'Vendors', 1, 7, 1, N'icon_vendors_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Vendors', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (21, 11, NULL, N'SQL', 1, 7, 1, N'icon_sql_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//SQL', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (25, 13, NULL, N'Schedule', 1, 7, 1, N'icon_scheduler_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Schedule', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (27, 15, NULL, N'Languages', 1, 7, 1, N'icon_language_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Languages', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (29, 17, NULL, N'Search Admin', 1, 7, 1, N'icon_search_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Search Admin', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (33, 19, NULL, N'Lists', 1, 7, 1, N'icon_lists_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Lists', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (34, 21, NULL, N'Superuser Accounts', 1, 7, 1, N'icon_users_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Superuser Accounts', NULL, NULL)
INSERT INTO {databaseOwner}[{objectQualifier}Tabs] ([TabID], [TabOrder], [PortalID], [TabName], [IsVisible], [ParentId], [Level], [IconFile], [DisableLink], [Title], [Description], [KeyWords], [IsDeleted], [Url], [SkinSrc], [ContainerSrc], [TabPath], [StartDate], [EndDate]) VALUES (35, 23, NULL, N'Skins', 1, 7, 1, N'icon_skins_16px.gif', 0, N'', N'', N'', 0, N'', NULL, NULL, N'//Host//Skins', NULL, NULL)
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}Tabs] OFF
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}DesktopModules] ON
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (10, N'Security Roles', N'Administrators can manage the security roles defined for their portal. The module allows you to add new security roles, modify existing security roles, delete security roles, and manage the users assigned to security roles.', NULL, 0, 1, NULL, N'Security Roles', N'Security Roles', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (11, N'Tabs', N'Administrators can manage the Tabs within the portal. This module allows you to create a new tab, modify an existing tab, delete tabs, change the tab order, and change the hierarchical tab level.', NULL, 0, 1, NULL, N'Tabs', N'Tabs', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (12, N'Site Settings', N'The Site Settings module represents the local options for your portal. Local settings allow you to customize your portal to meet your business requirements.', NULL, 0, 1, NULL, N'Site Settings', N'Site Settings', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (13, N'User Accounts', N'Administrators can manage their registered users. This module allows you to add new users, modify existing users, delete users, and manage the security roles for users.', NULL, 0, 1, NULL, N'User Accounts', N'User Accounts', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (14, N'Vendors', N'Administrators can manage the Vendors and Banners associated to the portal. This module allows you to add a new vendor, modify an existing vendor, and delete a vendor.', NULL, 0, 1, NULL, N'Vendors', N'Vendors', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (15, N'Banners', N'Banner advertising is managed through the Vendors module in the Admin tab. You can select the number of banners to display as well as the banner type.', N'01.00.00', 0, 0, NULL, N'Banners', N'Banners', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (16, N'File Manager', N'Administrators can manage the files stored in their upload directory. This module allows you to upload new files, download files, delete files, and synchronize your upload directory. It also provides information on the amount of disk space used and available.', NULL, 0, 1, NULL, N'File Manager', N'File Manager', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (18, N'Site Log', N'Administrators can view the details of visitors using their portal. There are a variety of reports available to display information regarding site usage, membership, and volumes.', NULL, 0, 1, NULL, N'Site Log', N'Site Log', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (19, N'Bulk Email', N'Administrators can send bulk email to all users belonging to a particular Role.', NULL, 0, 1, NULL, N'Bulk Email', N'Bulk Email', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (22, N'Portals', N'The Super User can manage the various parent and child Portals within the site. This module allows you to add a new portal, modify an existing portal, and delete a portal.', NULL, 0, 1, NULL, N'Portals', N'Portals', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (23, N'Module Definitions', N'The Super User can manage the Desktop Modules installed on the system.', NULL, 0, 1, NULL, N'Module Definitions', N'Module Definitions', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (24, N'SQL', N'The Super User can execute SQL statements against the database.', NULL, 0, 1, NULL, N'SQL', N'SQL', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (30, N'Host Settings', N'The Super User can manage the configuration settings which apply to the entire site.', NULL, 0, 1, NULL, N'Host Settings', N'Host Settings', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (32, N'Account Login', N'Allows users to login to the portal.', N'01.00.00', 0, 0, NULL, N'Account Login', N'Account Login', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (33, N'User Account', N'Allows users to register and manage their account.', N'01.00.00', 0, 0, NULL, N'User Account', N'User Account', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (34, N'Recycle Bin', N'The Recycle Bin provides an interface for restoring or permanently deleting Tabs and Modules.', NULL, 0, 1, NULL, N'Recycle Bin', N'Recycle Bin', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (36, N'Module Definition Validator', N'The Module Definition Validator provides an interface for validating Module Definition files (.dnn) during PA development', NULL, 0, 1, NULL, N'Module Definition Validator', N'Module Definition Validator', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (37, N'Log Viewer', N'Allows you to view log entries for portal events.', NULL, 0, 1, N'', N'Log Viewer', N'Log Viewer', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (38, N'Schedule', N'Allows you to schedule tasks to be run at specified intervals.', NULL, 0, 1, N'', N'Schedule', N'Schedule', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (39, N'Skins', N'Allows you to manage your skins and containers.', NULL, 0, 1, N'', N'Skins', N'Skins', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (40, N'Template', N'Allows you to export a portal template to be used to build new portals.', NULL, 0, 1, N'', N'Template', N'Template', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (41, N'Languages', N'The Super User can manage the suported languages installed on the system.', NULL, 0, 1, N'', N'Languages', N'Languages', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (42, N'Custom Locales', N'Administrator can manage custom translations for portal.', NULL, 0, 1, N'', N'Custom Locales', N'Custom Locales', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (43, N'Search Admin', N'The Search Admininstrator provides the ability to manage search settings.', NULL, 0, 1, N'', N'Search Admin', N'Search Admin', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (44, N'Search Input', N'The Search Input module provides the ability to submit a search to a given search results module.', N'01.00.00', 0, 0, N'', N'Search Input', N'Search Input', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (45, N'Search Results', N'The Search Reasults module provides the ability to display search results.', N'01.00.00', 0, 0, N'', N'Search Results', N'Search Results', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (46, N'Site Wizard', N'The Administrator can use this user-friendly wizard to set up the common features of the Portal/Site.', NULL, 0, 1, N'', N'Site Wizard', N'Site Wizard', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (47, N'Portal Aliases', N'Allows you to view portal aliases.', NULL, 0, 1, N'', N'Portal Aliases', N'Portal Aliases', 0)
INSERT INTO {databaseOwner}[{objectQualifier}DesktopModules] ([DesktopModuleID], [FriendlyName], [Description], [Version], [IsPremium], [IsAdmin], [BusinessControllerClass], [FolderName], [ModuleName], [SupportedFeatures]) VALUES (48, N'Lists', N'Allows you to edit common lists.', NULL, 0, 1, N'', N'Lists', N'Lists', 0)
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}DesktopModules] OFF
SET IDENTITY_INSERT {databaseOwner}[{objectQualifier}ModuleDefinitions] ON
INSERT INTO {databaseOwner}[{objectQualifier}ModuleDefinitions] ([ModuleDefID], [FriendlyName], [DesktopModuleID], [DefaultCacheTime]) VALUES (12, N'Security Roles', 10, 0)