03.01.01.sqldataprovider

SharpNuke源代码

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 = 'HostSpace' 
    ) 
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 = 'GUID' 
    ) 
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 = 'DefaultLanguage' 
    ) 
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 = 'TimezoneOffset' 
    ) 
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 = 'HomeDirectory' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ALTER COLUMN [UserRegistration] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Portals ALTER COLUMN [BannerAdvertising] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Portals ALTER COLUMN [HostFee] [money] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Portals ALTER COLUMN [HostSpace] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Portals ALTER COLUMN [GUID] [uniqueidentifier] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Portals ALTER COLUMN [DefaultLanguage] [nvarchar] (6) NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Portals ALTER COLUMN [TimezoneOffset] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Portals ALTER COLUMN [HomeDirectory] [varchar] (100) NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ADD CONSTRAINT [DF_{objectQualifier}Portals_UserRegistration] DEFAULT (0) FOR [UserRegistration]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ADD CONSTRAINT [DF_{objectQualifier}Portals_BannerAdvertising] DEFAULT (0) FOR [BannerAdvertising]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ADD CONSTRAINT [DF_{objectQualifier}Portals_HostFee] DEFAULT (0) FOR [HostFee]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ADD CONSTRAINT [DF_{objectQualifier}Portals_HostSpace] DEFAULT (0) FOR [HostSpace]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ADD CONSTRAINT [DF_{objectQualifier}Portals_GUID]  DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ADD CONSTRAINT [DF_{objectQualifier}Portals_DefaultLanguage] DEFAULT ('en-US') FOR [DefaultLanguage]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ADD CONSTRAINT [DF_{objectQualifier}Portals_TimezoneOffset]  DEFAULT ((-8)) FOR [TimezoneOffset]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Portals ADD CONSTRAINT [DF_{objectQualifier}Portals_HomeDirectory] DEFAULT ('') FOR [HomeDirectory]
GO


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


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}TabModules DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}TabModules') 
      AND col.name = 'DisplayTitle' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}TabModules DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}TabModules') 
      AND col.name = 'DisplayPrint' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}TabModules DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}TabModules') 
      AND col.name = 'DisplaySyndicate' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}TabModules ALTER COLUMN [DisplayTitle] [bit] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}TabModules ALTER COLUMN [DisplayPrint] [bit] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}TabModules ALTER COLUMN [DisplaySyndicate] [bit] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}TabModules ADD CONSTRAINT [DF_{objectQualifier}TabModules_DisplayTitle] DEFAULT (1) FOR [DisplayTitle]
GO
ALTER TABLE {databaseOwner}{objectQualifier}TabModules ADD CONSTRAINT [DF_{objectQualifier}TabModules_DisplayPrint] DEFAULT (1) FOR [DisplayPrint]
GO
ALTER TABLE {databaseOwner}{objectQualifier}TabModules ADD CONSTRAINT [DF_{objectQualifier}TabModules_DisplaySyndicate] DEFAULT (1) FOR [DisplaySyndicate]
GO



DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Tabs DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Tabs') 
      AND col.name = 'TabOrder' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Tabs DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Tabs') 
      AND col.name = 'IsVisible' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Tabs DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Tabs') 
      AND col.name = 'Level' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Tabs DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Tabs') 
      AND col.name = 'DisableLink' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Tabs DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Tabs') 
      AND col.name = 'IsDeleted' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ALTER COLUMN [TabOrder] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ALTER COLUMN [IsVisible] [bit] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ALTER COLUMN [Level] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ALTER COLUMN [DisableLink] [bit] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ALTER COLUMN [IsDeleted] [bit] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ADD CONSTRAINT [DF_{objectQualifier}Tabs_TabOrder] DEFAULT (0) FOR [TabOrder]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ADD CONSTRAINT [DF_{objectQualifier}Tabs_IsVisible] DEFAULT (1) FOR [IsVisible]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ADD CONSTRAINT [DF_{objectQualifier}Tabs_Level] DEFAULT (0) FOR [Level]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ADD CONSTRAINT [DF_{objectQualifier}Tabs_DisableLink] DEFAULT (0) FOR [DisableLink]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Tabs ADD CONSTRAINT [DF_{objectQualifier}Tabs_IsDeleted] DEFAULT (0) FOR [IsDeleted]
GO


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


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


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


DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Vendors DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Vendors') 
      AND col.name = 'ClickThroughs' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Vendors DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Vendors') 
      AND col.name = 'Views' 
    ) 
EXEC (@sql)
GO
DECLARE @sql NVARCHAR(2000) 
SET @sql = 'ALTER TABLE {databaseOwner}{objectQualifier}Vendors DROP CONSTRAINT ' + ( 
    SELECT obj.name 
    FROM SYSCOLUMNS col JOIN 
         SYSOBJECTS obj ON col.cdefault = obj.id 
    WHERE col.id = OBJECT_ID('{databaseOwner}{objectQualifier}Vendors') 
      AND col.name = 'Authorized' 
    ) 
EXEC (@sql)
GO
ALTER TABLE {databaseOwner}{objectQualifier}Vendors ALTER COLUMN [ClickThroughs] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Vendors ALTER COLUMN [Views] [int] NOT NULL
ALTER TABLE {databaseOwner}{objectQualifier}Vendors ALTER COLUMN [Authorized] [bit] NOT NULL
GO
ALTER TABLE {databaseOwner}{objectQualifier}Vendors ADD CONSTRAINT [DF_{objectQualifier}Vendors_ClickThroughs] DEFAULT (0) FOR [ClickThroughs]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Vendors ADD CONSTRAINT [DF_{objectQualifier}Vendors_Views] DEFAULT (0) FOR [Views]
GO
ALTER TABLE {databaseOwner}{objectQualifier}Vendors ADD CONSTRAINT [DF_{objectQualifier}Vendors_Authorized] DEFAULT (1) FOR [Authorized]
GO


/* Add index to Version table (if it's missing when upgrading from version 1.x to 3.x) */
if not exists (select * from dbo.sysindexes where name = 'IX_{objectQualifier}Version')
ALTER TABLE {databaseOwner}{objectQualifier}Version ADD CONSTRAINT [IX_{objectQualifier}Version] UNIQUE NONCLUSTERED  ([Major], [Minor], [Build])
GO

/* Drop stored procedure 'UpdateVersion' (left-over from 1.x) */
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}UpdateVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}UpdateVersion]
GO

/* Add LanguageSelector skinobject */
INSERT INTO {databaseOwner}[{objectQualifier}ModuleControls] ([ControlKey], [ControlSrc], [ControlType]) VALUES (N'LANGUAGE', N'Admin/Skins/Language.ascx', -2)
GO

/************************************************************/
/*****              SqlDataProvider                     *****/
/************************************************************/