02.02.02.sqldataprovider

SharpNuke源代码

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****              Upgrade 02.02.02                    *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for {databaseOwner} and {objectQualifier}  *****/
/*****                                                  *****/
/************************************************************/

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}AddHtmlText    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}AddHtmlText') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}AddHtmlText
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}UpdateHtmlText    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}UpdateHtmlText') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}UpdateHtmlText
GO

ALTER TABLE {databaseOwner}{objectQualifier}HtmlText ADD
  [DesktopSummary] [ntext] ,
	[CreatedByUser] int NULL,
	[CreatedDate] [datetime] NULL
GO

update {objectQualifier}HtmlText
set    CreatedDate = getdate()
GO

ALTER TABLE {databaseOwner}{objectQualifier}HtmlText DROP
  COLUMN MobileSummary,
  COLUMN MobileDetails
GO


create procedure {databaseOwner}{objectQualifier}AddHtmlText

@ModuleId       int,
@DesktopHtml    ntext,
@DesktopSummary ntext,
@UserID         int

as

insert into {objectQualifier}HtmlText (
  ModuleId,
  DesktopHtml,
  DesktopSummary,
  CreatedByUser,
  CreatedDate
) 
values (
  @ModuleId,
  @DesktopHtml,
  @DesktopSummary,
  @UserID,
  getdate()
)

GO

create procedure {databaseOwner}{objectQualifier}UpdateHtmlText

@ModuleId       int,
@DesktopHtml    ntext,
@DesktopSummary ntext,
@UserID         int

as

update {objectQualifier}HtmlText
set    DesktopHtml    = @DesktopHtml,
       DesktopSummary = @DesktopSummary,
       CreatedByUser  = @UserID,
       CreatedDate    = getdate()
where  ModuleId = @ModuleId

GO

/************************************************************/
/*****  SearchIndexer                                   *****/
/************************************************************/

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchIndexers    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchIndexers') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchIndexers
GO

CREATE TABLE {databaseOwner}{objectQualifier}SearchIndexer 
(
	SearchIndexerID int IDENTITY (1, 1) NOT NULL ,
	SearchIndexerAssemblyQualifiedName char (200)  NOT NULL ,
	CONSTRAINT PK_SearchIndexer PRIMARY KEY  CLUSTERED 
	(
		SearchIndexerID
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

INSERT INTO {databaseOwner}{objectQualifier}SearchIndexer 
(SearchIndexerAssemblyQualifiedName)
VALUES ('DotNetNuke.Services.Search.ModuleIndexer, dotnetnuke.search')
GO

create procedure {databaseOwner}{objectQualifier}GetSearchIndexers

as

select {objectQualifier}SearchIndexer.*
from {objectQualifier}SearchIndexer

GO


ALTER TABLE {databaseOwner}{objectQualifier}DesktopModules ADD
	BusinessControllerClass nvarchar (200)
GO

update {databaseOwner}{objectQualifier}DesktopModules
set    BusinessControllerClass   = 'DotNetNuke.Modules.Announcements.AnnouncementsController, DotNetNuke.Modules.Announcements'
where  FriendlyName = 'Announcements'
GO

update {databaseOwner}{objectQualifier}DesktopModules
set    BusinessControllerClass   = 'DotNetNuke.Modules.Contacts.ContactController, DotNetNuke.Modules.Contacts'
where  FriendlyName = 'Contacts'
GO

update {databaseOwner}{objectQualifier}DesktopModules
set    BusinessControllerClass   = 'DotNetNuke.Modules.Discussions.DiscussionController, DotNetNuke.Modules.Discussions'
where  FriendlyName = 'Discussions'
GO

update {databaseOwner}{objectQualifier}DesktopModules
set    BusinessControllerClass   = 'DotNetNuke.Modules.Documents.DocumentController, DotNetNuke.Modules.Documents'
where  FriendlyName = 'Documents'
GO

update {databaseOwner}{objectQualifier}DesktopModules
set    BusinessControllerClass   = 'DotNetNuke.Modules.Events.EventController, DotNetNuke.Modules.Events'
where  FriendlyName = 'Events'
GO

update {databaseOwner}{objectQualifier}DesktopModules
set    BusinessControllerClass   = 'DotNetNuke.Modules.FAQs.FAQsController, DotNetNuke.Modules.FAQs'
where  FriendlyName = 'FAQs'
GO

update {databaseOwner}{objectQualifier}DesktopModules
set    BusinessControllerClass   = 'DotNetNuke.Modules.Html.HtmlTextController, DotNetNuke.Modules.Html'
where  FriendlyName = 'Text/HTML'
GO

update {databaseOwner}{objectQualifier}DesktopModules
set    BusinessControllerClass   = 'DotNetNuke.Modules.Links.LinkController, DotNetNuke.Modules.Links'
where  FriendlyName = 'Links'
GO

/************************************************************/
/*****  Search Storage                                  *****/
/************************************************************/

CREATE TABLE {databaseOwner}{objectQualifier}SearchItem (
	[SearchItemID] [int] IDENTITY (1, 1) NOT NULL ,
	[Title] [nvarchar] (200)  NOT NULL ,
	[Link] [nvarchar] (256)  NOT NULL ,
	[Description] [nvarchar] (2000)  NOT NULL ,
	[Author] [int] NULL ,
	[PubDate] [datetime] NOT NULL ,
	[ModuleId] [int] NOT NULL ,
	[SearchKey] [nvarchar] (100)  NOT NULL ,
	[Content] [text]  NOT NULL ,
	[Guid] [nvarchar] (40)  NULL ,
	[HitCount] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE {databaseOwner}{objectQualifier}SearchItemWord (
	[SearchItemWordID] [int] IDENTITY (1, 1) NOT NULL ,
	[SearchItemID] [int] NOT NULL ,
	[SearchWordsID] [int] NOT NULL ,
	[Occurrences] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE {databaseOwner}{objectQualifier}SearchItemWordPosition (
	[SearchItemWordPositionID] [int] IDENTITY (1, 1) NOT NULL ,
	[SearchItemWordID] [int] NOT NULL ,
	[ContentPosition] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE {databaseOwner}{objectQualifier}SearchWord (
	[SearchWordsID] [int] IDENTITY (1, 1) NOT NULL ,
	[Word] [nvarchar] (100)  NOT NULL ,
	[IsCommon] [bit] NULL ,
	[HitCount] [int] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE {databaseOwner}{objectQualifier}SearchItem WITH NOCHECK ADD 
	CONSTRAINT PK_{objectQualifier}SearchItem PRIMARY KEY  CLUSTERED 
	(
		[SearchItemID]
	)  ON [PRIMARY] 
GO

CREATE  UNIQUE  INDEX IX_{objectQualifier}SearchItem ON {databaseOwner}{objectQualifier}SearchItem([ModuleId], [SearchKey]) ON [PRIMARY]
GO

ALTER TABLE {databaseOwner}{objectQualifier}SearchItemWord WITH NOCHECK ADD 
	CONSTRAINT PK_{objectQualifier}SearchItemWords PRIMARY KEY  CLUSTERED 
	(
		[SearchItemWordID]
	)  ON [PRIMARY] 
GO

ALTER TABLE {databaseOwner}{objectQualifier}SearchItemWordPosition WITH NOCHECK ADD 
	CONSTRAINT PK_{objectQualifier}SearchItemWordPosition PRIMARY KEY  CLUSTERED 
	(
		[SearchItemWordPositionID]
	)  ON [PRIMARY] 
GO

ALTER TABLE {databaseOwner}{objectQualifier}SearchWord WITH NOCHECK ADD 
	CONSTRAINT PK_{objectQualifier}SearchWord PRIMARY KEY  CLUSTERED 
	(
		[SearchWordsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE {databaseOwner}{objectQualifier}SearchItemWord ADD 
	CONSTRAINT FK_{objectQualifier}SearchItemWord_{objectQualifier}SearchItem FOREIGN KEY 
	(
		[SearchItemID]
	) REFERENCES {databaseOwner}{objectQualifier}SearchItem (
		[SearchItemID]
	) ON DELETE CASCADE  ON UPDATE CASCADE ,
	CONSTRAINT FK_{objectQualifier}SearchItemWord_{objectQualifier}SearchWord FOREIGN KEY 
	(
		[SearchWordsID]
	) REFERENCES {databaseOwner}{objectQualifier}SearchWord (
		[SearchWordsID]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
GO

ALTER TABLE {databaseOwner}{objectQualifier}SearchItemWordPosition ADD 
	CONSTRAINT FK_{objectQualifier}SearchItemWordPosition_{objectQualifier}SearchItemWord FOREIGN KEY 
	(
		[SearchItemWordID]
	) REFERENCES {databaseOwner}{objectQualifier}SearchItemWord (
		[SearchItemWordID]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
GO


/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchItem    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchItem') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchItem
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}ListSearchItem    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}ListSearchItem') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}ListSearchItem
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}AddSearchItem    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}AddSearchItem') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}AddSearchItem
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}UpdateSearchItem    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}UpdateSearchItem') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}UpdateSearchItem
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}DeleteSearchItem    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DeleteSearchItem') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}DeleteSearchItem
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchItemWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchItemWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchItemWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}ListSearchItemWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}ListSearchItemWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}ListSearchItemWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchItemWordBySearchItem    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchItemWordBySearchItem') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchItemWordBySearchItem
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchItemWordBySearchWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchItemWordBySearchWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchItemWordBySearchWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}AddSearchItemWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}AddSearchItemWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}AddSearchItemWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}UpdateSearchItemWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}UpdateSearchItemWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}UpdateSearchItemWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}DeleteSearchItemWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DeleteSearchItemWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}DeleteSearchItemWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}ListSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}ListSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}ListSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchItemWordPositionBySearchItemWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchItemWordPositionBySearchItemWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchItemWordPositionBySearchItemWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}AddSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}AddSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}AddSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}UpdateSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}UpdateSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}UpdateSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}DeleteSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DeleteSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}DeleteSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}ListSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}ListSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}ListSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchItemWordPositionBySearchItemWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchItemWordPositionBySearchItemWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchItemWordPositionBySearchItemWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}AddSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}AddSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}AddSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}UpdateSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}UpdateSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}UpdateSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}DeleteSearchItemWordPosition    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DeleteSearchItemWordPosition') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}DeleteSearchItemWordPosition
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}GetSearchWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSearchWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSearchWord
GO

/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}ListSearchWord    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}ListSearchWord') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}ListSearchWord
GO


/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}AddSearchWord    Script Date: Sunday, September 26, 2004 ******/