ualifier}PortalAlias SET HTTPAlias = @HTTPAlias, LastModifiedByUserID = @LastModifiedByUserID, LastModifiedOnDate = getdate() WHERE PortalID = @PortalID AND PortalAliasID = @PortalAliasID GO PRINT N'Creating {databaseOwner}[{objectQualifier}GetFolderMappings]' GO CREATE PROCEDURE {databaseOwner}[{objectQualifier}GetFolderMappings] @PortalID int AS BEGIN SELECT * FROM {databaseOwner}[{objectQualifier}FolderMappings] WHERE ISNULL(PortalID, -1) = ISNULL(@PortalID, -1) ORDER BY Priority END GO PRINT N'Creating {databaseOwner}[{objectQualifier}UpdateTabSetting]' GO CREATE PROCEDURE {databaseOwner}{objectQualifier}UpdateTabSetting @TabID INT, @SettingName NVARCHAR(50), @SettingValue NVARCHAR(2000), @LastModifiedByUserID INT AS UPDATE {databaseOwner}{objectQualifier}TabSettings SET SettingValue = @SettingValue, LastModifiedByUserID = @LastModifiedByUserID, LastModifiedOnDate = GETDATE() WHERE TabID = @TabID AND SettingName = @SettingName GO PRINT N'Creating {databaseOwner}[{objectQualifier}PortalDesktopModules]' GO CREATE TABLE {databaseOwner}[{objectQualifier}PortalDesktopModules] ( [PortalDesktopModuleID] [int] NOT NULL IDENTITY(1, 1), [PortalID] [int] NOT NULL, [DesktopModuleID] [int] NOT NULL, [CreatedByUserID] [int] NULL, [CreatedOnDate] [datetime] NULL, [LastModifiedByUserID] [int] NULL, [LastModifiedOnDate] [datetime] NULL ) GO PRINT N'Creating primary key [PK_{objectQualifier}PortalDesktopModules] on {databaseOwner}[{objectQualifier}PortalDesktopModules]' GO ALTER TABLE {databaseOwner}[{objectQualifier}PortalDesktopModules] ADD CONSTRAINT [PK_{objectQualifier}PortalDesktopModules] PRIMARY KEY CLUSTERED ([PortalDesktopModuleID]) GO PRINT N'Creating {databaseOwner}[{objectQualifier}AddPortalDesktopModule]' GO CREATE PROCEDURE {databaseOwner}{objectQualifier}AddPortalDesktopModule @PortalID int, @DesktopModuleId int, @CreatedByUserID int as insert into {databaseOwner}{objectQualifier}PortalDesktopModules ( PortalId, DesktopModuleId, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate ) valu