03.01.01.sqldataprovider

SharpNuke源代码

    SkinSrc,
    ContainerSrc,
    TabPath,
    StartDate,
    EndDate,
	RefreshInterval,
	PageHeadText
)
values (
    @PortalId,
    @TabName,
    @IsVisible,
    @DisableLink,
    @ParentId,
    @IconFile,
    @Title,
    @Description,
    @KeyWords,
    0,
    @Url,
    @SkinSrc,
    @ContainerSrc,
    @TabPath,
    @StartDate,
    @EndDate,
    @RefreshInterval,
    @PageHeadText
)

select SCOPE_IDENTITY()

GO


if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}GetAllFiles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}GetAllFiles]
GO

CREATE procedure {databaseOwner}{objectQualifier}GetAllFiles

as

select FileId,
       PortalId,
       FileName,
       Extension,
       Size,
       WIdth,
       Height,
       ContentType,
	   Folder
from {databaseOwner}{objectQualifier}Files

GO


/* update admin controls to use current host module */
update {databaseOwner}{objectQualifier}modules 
set moduledefid=(
	select moduledefid
	from {databaseOwner}{objectQualifier}desktopmodules dm1
	join {databaseOwner}{objectQualifier}moduledefinitions  md1 on dm1.desktopmoduleid=md1.desktopmoduleid
	where dm1.foldername='Languages'
)
from {databaseOwner}{objectQualifier}modules m
join {databaseOwner}{objectQualifier}moduledefinitions md on m.moduledefid=md.moduledefid
join {databaseOwner}{objectQualifier}desktopmodules dm on md.desktopmoduleid=dm.desktopmoduleid
where not m.portalid is null and
dm.foldername='Custom Locales'

GO

/* delete old module */
delete {databaseOwner}{objectQualifier}desktopmodules
where foldername='Custom Locales'

GO

/* set control type for admin*/
update {databaseOwner}{objectQualifier}modulecontrols
set ControlType=2
from {databaseOwner}{objectQualifier}modulecontrols mc
join {databaseOwner}{objectQualifier}moduledefinitions md on mc.moduledefid=md.moduledefid
join {databaseOwner}{objectQualifier}desktopmodules dm on md.desktopmoduleid=dm.desktopmoduleid
where dm.foldername='Languages'
and (controlkey is null or controlkey='Language' or controlkey='FullEditor')

GO


/******************************/
/* Rename unnamed constraints */
/******************************/
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}AnonymousUsers DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}AnonymousUsers') 
      AND col.name = 'CreationDate' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}AnonymousUsers DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}AnonymousUsers') 
      AND col.name = 'LastActiveDate' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}AnonymousUsers ALTER COLUMN [CreationDate] [datetime] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}AnonymousUsers ALTER COLUMN [LastActiveDate] [datetime] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}AnonymousUsers ADD CONSTRAINT [DF_{objectQualifier}AnonymousUsers_CreationDate] DEFAULT (getdate()) FOR [CreationDate]
GO
ALTER TABLE {databaseOwner}{objectQualifier}AnonymousUsers ADD CONSTRAINT [DF_{objectQualifier}AnonymousUsers_LastActiveDate] DEFAULT (getdate()) FOR [LastActiveDate]
GO


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Banners DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Banners') 
      AND col.name = 'Views' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Banners DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Banners') 
      AND col.name = 'ClickThroughs' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Banners DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Banners') 
      AND col.name = 'Criteria' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Banners DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Banners') 
      AND col.name = 'Width' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Banners DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Banners') 
      AND col.name = 'Height' 
    ) 
EXEC (@sql)
GO

ALTER TABLE {databaseOwner}{objectQualifier}Banners ALTER COLUMN [Views] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Banners ALTER COLUMN [ClickThroughs] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Banners ALTER COLUMN [Criteria] [bit] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Banners ALTER COLUMN [Width] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Banners ALTER COLUMN [Height] [int] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}Banners ADD CONSTRAINT [DF_{objectQualifier}Banners_Views] DEFAULT (0) FOR [Views]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Banners ADD CONSTRAINT [DF_{objectQualifier}Banners_ClickThroughs] DEFAULT (0) FOR [ClickThroughs]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Banners ADD CONSTRAINT [DF_{objectQualifier}Banners_Criteria] DEFAULT (1) FOR [Criteria]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Banners ADD CONSTRAINT [DF_{objectQualifier}Banners_Width] DEFAULT (0) FOR [Width]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Banners ADD CONSTRAINT [DF_{objectQualifier}Banners_Height] DEFAULT (0) FOR [Height]
GO


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}DesktopModules') 
      AND col.name = 'SupportedFeatures' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules ALTER COLUMN [SupportedFeatures] [int] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules ADD CONSTRAINT [DF_{objectQualifier}DesktopModules_SupportedFeatures] DEFAULT (0) FOR [SupportedFeatures]
GO


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}HostSettings DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}HostSettings') 
      AND col.name = 'SettingIsSecure' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}HostSettings ALTER COLUMN [SettingIsSecure] [bit] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}HostSettings ADD CONSTRAINT [DF_{objectQualifier}HostSettings_Secure] DEFAULT (0) FOR [SettingIsSecure]
GO


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Lists DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Lists') 
      AND col.name = 'ParentID' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Lists DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Lists') 
      AND col.name = 'Level' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Lists DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Lists') 
      AND col.name = 'SortOrder' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Lists DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Lists') 
      AND col.name = 'DefinitionID' 
    ) 
EXEC (@sql)
GO

ALTER TABLE {databaseOwner}{objectQualifier}Lists ALTER COLUMN [ParentID] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Lists ALTER COLUMN [Level] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Lists ALTER COLUMN [SortOrder] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Lists ALTER COLUMN [DefinitionID] [int] NOT NULL
GO

ALTER TABLE {databaseOwner}{objectQualifier}Lists ADD CONSTRAINT [DF_{objectQualifier}Lists_ParentID] DEFAULT (0) FOR [ParentID]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Lists ADD CONSTRAINT [DF_{objectQualifier}Lists_Level] DEFAULT (0) FOR [Level]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Lists ADD CONSTRAINT [DF_{objectQualifier}Lists_SortOrder] DEFAULT (0) FOR [SortOrder]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Lists ADD CONSTRAINT [DF_{objectQualifier}Lists_DefinitionID] DEFAULT (0) FOR [DefinitionID]
GO


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}ModuleDefinitions DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}ModuleDefinitions') 
      AND col.name = 'DefaultCacheTime' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}ModuleDefinitions ALTER COLUMN [DefaultCacheTime] [int] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}ModuleDefinitions ADD CONSTRAINT [DF_{objectQualifier}ModuleDefinitions_DefaultCacheTime] DEFAULT (0) FOR [DefaultCacheTime]
GO


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Modules DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Modules') 
      AND col.name = 'AllTabs' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Modules DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Modules') 
      AND col.name = 'IsDeleted' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}Modules ALTER COLUMN [AllTabs] [bit] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Modules ALTER COLUMN [IsDeleted] [bit] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}Modules ADD CONSTRAINT [DF_{objectQualifier}Modules_AllTabs] DEFAULT (0) FOR [AllTabs]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Modules ADD CONSTRAINT [DF_{objectQualifier}Modules_IsDeleted] DEFAULT (0) FOR [IsDeleted]
GO


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Portals DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Portals') 
      AND col.name = 'UserRegistration' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Portals DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Portals') 
      AND col.name = 'BannerAdvertising' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Portals DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Portals') 
      AND col.name = 'HostFee' 
    ) 
EXEC (@sql)
GO