02.02.02.sqldataprovider

SharpNuke源代码

	[IsCommon] = @IsCommon,
	[HitCount] = @HitCount
WHERE
	[SearchWordsID] = @SearchWordsID
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}DeleteSearchWord
	@SearchWordsID int
AS

DELETE FROM {databaseOwner}{objectQualifier}SearchWord
WHERE
	[SearchWordsID] = @SearchWordsID
GO


CREATE PROC {databaseOwner}{objectQualifier}DeleteSearchItems
(
	@ModuleList varchar(1000)
)
AS
BEGIN
	SET NOCOUNT ON

	DECLARE @TempList table
	(
		ModuleID int
	)

	DECLARE @ModuleID varchar(10), @Pos int

	SET @ModuleList = LTRIM(RTRIM(@ModuleList))+ ','
	SET @Pos = CHARINDEX(',', @ModuleList, 1)

	IF REPLACE(@ModuleList, ',', '') <> ''
	BEGIN
		WHILE @Pos > 0
		BEGIN
			SET @ModuleID = LTRIM(RTRIM(LEFT(@ModuleList, @Pos - 1)))
			IF @ModuleID <> ''
			BEGIN
				INSERT INTO @TempList (ModuleID) VALUES (CAST(@ModuleID AS int)) 
			END
			SET @ModuleList = RIGHT(@ModuleList, LEN(@ModuleList) - @Pos)
			SET @Pos = CHARINDEX(',', @ModuleList, 1)

		END
	END	

	DELETE
	FROM	{databaseOwner}{objectQualifier}SearchItem
	WHERE	ModuleID in 
		(SELECT ModuleID FROM @TempList)
		
END
GO

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

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


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

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

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

CREATE TABLE {databaseOwner}{objectQualifier}SearchCommonWords (
	[CommonWordID] [int] IDENTITY (1, 1) NOT NULL ,
	[CommonWord] [nvarchar] (255)  NOT NULL ,
	[Locale] [nvarchar] (10)  NULL ,
	CONSTRAINT [PK_{objectQualifier}SearchCommonWords] PRIMARY KEY  CLUSTERED 
	(
		[CommonWordID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}GetSearchCommonWordByID
	@CommonWordID int
	
AS

SELECT
	[CommonWordID],
	[CommonWord],
	[Locale]
FROM
	{databaseOwner}{objectQualifier}SearchCommonWords
WHERE
	[CommonWordID] = @CommonWordID
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}GetSearchCommonWordsByLocale
	@Locale nvarchar(10)
	
AS

SELECT
	[CommonWordID],
	[CommonWord],
	[Locale]
FROM
	{databaseOwner}{objectQualifier}SearchCommonWords
WHERE
	[Locale] = @Locale
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}AddSearchCommonWord
	@CommonWord nvarchar(255),
	@Locale nvarchar(10)
AS

INSERT INTO {databaseOwner}{objectQualifier}SearchCommonWords (
	[CommonWord],
	[Locale]
) VALUES (
	@CommonWord,
	@Locale
)

select SCOPE_IDENTITY()
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}UpdateSearchCommonWord
	@CommonWordID int, 
	@CommonWord nvarchar(255), 
	@Locale nvarchar(10) 
AS

UPDATE {databaseOwner}{objectQualifier}SearchCommonWords SET
	[CommonWord] = @CommonWord,
	[Locale] = @Locale
WHERE
	[CommonWordID] = @CommonWordID
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}DeleteSearchCommonWord
	@CommonWordID int
AS

DELETE FROM {databaseOwner}{objectQualifier}SearchCommonWords
WHERE
	[CommonWordID] = @CommonWordID
GO

TRUNCATE TABLE {databaseOwner}{objectQualifier}SearchCommonWords

DBCC CHECKIDENT ('{databaseOwner}{objectQualifier}SearchCommonWords', RESEED, 1)

SET IDENTITY_INSERT {databaseOwner}{objectQualifier}SearchCommonWords ON

INSERT INTO {databaseOwner}{objectQualifier}SearchCommonWords (
	[CommonWordID],
	[CommonWord],
	[Locale]
)
	SELECT 1, 'a', 'en-US' UNION
	SELECT 2, 'about', 'en-US' UNION
	SELECT 3, 'above', 'en-US' UNION
	SELECT 4, 'according', 'en-US' UNION
	SELECT 5, 'across', 'en-US' UNION
	SELECT 6, 'actually', 'en-US' UNION
	SELECT 7, 'adj', 'en-US' UNION
	SELECT 8, 'after', 'en-US' UNION
	SELECT 9, 'afterwards', 'en-US' UNION
	SELECT 10, 'again', 'en-US' UNION
	SELECT 11, 'against', 'en-US' UNION
	SELECT 12, 'all', 'en-US' UNION
	SELECT 13, 'almost', 'en-US' UNION
	SELECT 14, 'alone', 'en-US' UNION
	SELECT 15, 'along', 'en-US' UNION
	SELECT 16, 'already', 'en-US' UNION
	SELECT 17, 'also', 'en-US' UNION
	SELECT 18, 'although', 'en-US' UNION
	SELECT 19, 'always', 'en-US' UNION
	SELECT 20, 'among', 'en-US' UNION
	SELECT 21, 'amongst', 'en-US' UNION
	SELECT 22, 'an', 'en-US' UNION
	SELECT 23, 'and', 'en-US' UNION
	SELECT 24, 'another', 'en-US' UNION
	SELECT 25, 'any', 'en-US' UNION
	SELECT 26, 'anyhow', 'en-US' UNION
	SELECT 27, 'anyone', 'en-US' UNION
	SELECT 28, 'anything', 'en-US' UNION
	SELECT 29, 'anywhere', 'en-US' UNION
	SELECT 30, 'are', 'en-US' UNION
	SELECT 31, 'aren''t', 'en-US' UNION
	SELECT 32, 'around', 'en-US' UNION
	SELECT 33, 'as', 'en-US' UNION
	SELECT 34, 'at', 'en-US' UNION
	SELECT 35, 'b', 'en-US' UNION
	SELECT 36, 'be', 'en-US' UNION
	SELECT 37, 'became', 'en-US' UNION
	SELECT 38, 'because', 'en-US' UNION
	SELECT 39, 'become', 'en-US' UNION
	SELECT 40, 'becomes', 'en-US' UNION
	SELECT 41, 'becoming', 'en-US' UNION
	SELECT 42, 'been', 'en-US' UNION
	SELECT 43, 'before', 'en-US' UNION
	SELECT 44, 'beforehand', 'en-US' UNION
	SELECT 45, 'begin', 'en-US' UNION
	SELECT 46, 'behind', 'en-US' UNION
	SELECT 47, 'being', 'en-US' UNION
	SELECT 48, 'below', 'en-US' UNION
	SELECT 49, 'beside', 'en-US' UNION
	SELECT 50, 'besides', 'en-US' UNION
	SELECT 51, 'between', 'en-US' UNION
	SELECT 52, 'beyond', 'en-US' UNION
	SELECT 53, 'both', 'en-US' UNION
	SELECT 54, 'but', 'en-US' UNION
	SELECT 55, 'by', 'en-US' UNION
	SELECT 56, 'c', 'en-US' UNION
	SELECT 57, 'can', 'en-US' UNION
	SELECT 58, 'can''t', 'en-US' UNION
	SELECT 59, 'cannot', 'en-US' UNION
	SELECT 60, 'caption', 'en-US' UNION
	SELECT 61, 'co', 'en-US' UNION
	SELECT 62, 'could', 'en-US' UNION
	SELECT 63, 'couldn''t', 'en-US' UNION
	SELECT 64, 'd', 'en-US' UNION
	SELECT 65, 'did', 'en-US' UNION
	SELECT 66, 'didn''t', 'en-US' UNION
	SELECT 67, 'do', 'en-US' UNION
	SELECT 68, 'does', 'en-US' UNION
	SELECT 69, 'doesn''t', 'en-US' UNION
	SELECT 70, 'don''t', 'en-US' UNION
	SELECT 71, 'during', 'en-US' UNION
	SELECT 72, 'e', 'en-US' UNION
	SELECT 73, 'each', 'en-US' UNION
	SELECT 74, 'eg', 'en-US' UNION
	SELECT 75, 'eight', 'en-US' UNION
	SELECT 76, 'eighty', 'en-US' UNION
	SELECT 77, 'either', 'en-US' UNION
	SELECT 78, 'else', 'en-US' UNION
	SELECT 79, 'elsewhere', 'en-US' UNION
	SELECT 80, 'end', 'en-US' UNION
	SELECT 81, 'ending', 'en-US' UNION
	SELECT 82, 'enough', 'en-US' UNION
	SELECT 83, 'etc', 'en-US' UNION
	SELECT 84, 'even', 'en-US' UNION
	SELECT 85, 'ever', 'en-US' UNION
	SELECT 86, 'every', 'en-US' UNION
	SELECT 87, 'everyone', 'en-US' UNION
	SELECT 88, 'everything', 'en-US' UNION
	SELECT 89, 'everywhere', 'en-US' UNION
	SELECT 90, 'except', 'en-US' UNION
	SELECT 91, 'f', 'en-US' UNION
	SELECT 92, 'few', 'en-US' UNION
	SELECT 93, 'first', 'en-US' UNION
	SELECT 94, 'for', 'en-US' UNION
	SELECT 95, 'found', 'en-US' UNION
	SELECT 96, 'from', 'en-US' UNION
	SELECT 97, 'further', 'en-US' UNION
	SELECT 98, 'g', 'en-US' UNION
	SELECT 99, 'h', 'en-US' UNION
	SELECT 100, 'had', 'en-US' UNION
	SELECT 101, 'has', 'en-US' UNION
	SELECT 102, 'hasn''t', 'en-US' UNION
	SELECT 103, 'have', 'en-US' UNION
	SELECT 104, 'haven''t', 'en-US' UNION
	SELECT 105, 'he', 'en-US' UNION
	SELECT 106, 'he''d', 'en-US' UNION
	SELECT 107, 'he''ll', 'en-US' UNION
	SELECT 108, 'he''s', 'en-US' UNION
	SELECT 109, 'hence', 'en-US' UNION
	SELECT 110, 'her', 'en-US' UNION
	SELECT 111, 'here', 'en-US' UNION
	SELECT 112, 'here''s', 'en-US' UNION
	SELECT 113, 'hereafter', 'en-US' UNION
	SELECT 114, 'hereby', 'en-US' UNION
	SELECT 115, 'herein', 'en-US' UNION
	SELECT 116, 'hereupon', 'en-US' UNION
	SELECT 117, 'hers', 'en-US' UNION
	SELECT 118, 'herself', 'en-US' UNION
	SELECT 119, 'him', 'en-US' UNION
	SELECT 120, 'himself', 'en-US' UNION
	SELECT 121, 'his', 'en-US' UNION
	SELECT 122, 'how', 'en-US' UNION
	SELECT 123, 'however', 'en-US' UNION
	SELECT 124, 'hundred', 'en-US' UNION
	SELECT 125, 'i', 'en-US' UNION
	SELECT 126, 'i''d', 'en-US' UNION
	SELECT 127, 'i''ll', 'en-US' UNION
	SELECT 128, 'i''m', 'en-US' UNION
	SELECT 129, 'i''ve', 'en-US' UNION
	SELECT 130, 'ie', 'en-US' UNION
	SELECT 131, 'if', 'en-US' UNION
	SELECT 132, 'in', 'en-US' UNION
	SELECT 133, 'indeed', 'en-US' UNION
	SELECT 134, 'instead', 'en-US' UNION
	SELECT 135, 'into', 'en-US' UNION
	SELECT 136, 'is', 'en-US' UNION
	SELECT 137, 'isn''t', 'en-US' UNION
	SELECT 138, 'it', 'en-US' UNION
	SELECT 139, 'it''s', 'en-US' UNION
	SELECT 140, 'its', 'en-US' UNION
	SELECT 141, 'itself', 'en-US' UNION
	SELECT 142, 'j', 'en-US' UNION
	SELECT 143, 'k', 'en-US' UNION
	SELECT 144, 'l', 'en-US' UNION
	SELECT 145, 'last', 'en-US' UNION
	SELECT 146, 'later', 'en-US' UNION
	SELECT 147, 'latter', 'en-US' UNION
	SELECT 148, 'latterly', 'en-US' UNION
	SELECT 149, 'least', 'en-US' UNION
	SELECT 150, 'less', 'en-US' UNION
	SELECT 151, 'let', 'en-US' UNION
	SELECT 152, 'let''s', 'en-US' UNION
	SELECT 153, 'like', 'en-US' UNION
	SELECT 154, 'likely', 'en-US' UNION
	SELECT 155, 'ltd', 'en-US' UNION
	SELECT 156, 'm', 'en-US' UNION
	SELECT 157, 'made', 'en-US' UNION
	SELECT 158, 'make', 'en-US' UNION
	SELECT 159, 'makes', 'en-US' UNION
	SELECT 160, 'many', 'en-US' UNION
	SELECT 161, 'maybe', 'en-US' UNION
	SELECT 162, 'me', 'en-US' UNION
	SELECT 163, 'meantime', 'en-US' UNION
	SELECT 164, 'meanwhile', 'en-US' UNION
	SELECT 165, 'might', 'en-US' UNION
	SELECT 166, 'miss', 'en-US' UNION
	SELECT 167, 'more', 'en-US' UNION
	SELECT 168, 'moreover', 'en-US' UNION
	SELECT 169, 'most', 'en-US' UNION
	SELECT 170, 'mostly', 'en-US' UNION
	SELECT 171, 'mr', 'en-US' UNION
	SELECT 172, 'mrs', 'en-US' UNION
	SELECT 173, 'much', 'en-US' UNION
	SELECT 174, 'must', 'en-US' UNION
	SELECT 175, 'my', 'en-US' UNION
	SELECT 176, 'myself', 'en-US' UNION
	SELECT 177, 'n', 'en-US' UNION
	SELECT 178, 'namely', 'en-US' UNION
	SELECT 179, 'near', 'en-US' UNION
	SELECT 180, 'neither', 'en-US' UNION
	SELECT 181, 'never', 'en-US' UNION
	SELECT 182, 'nevertheless', 'en-US' UNION
	SELECT 183, 'next', 'en-US' UNION
	SELECT 184, 'nine', 'en-US' UNION
	SELECT 185, 'ninety', 'en-US' UNION
	SELECT 186, 'no', 'en-US' UNION
	SELECT 187, 'not', 'en-US' UNION
	SELECT 188, 'nobody', 'en-US' UNION
	SELECT 189, 'none', 'en-US' UNION
	SELECT 190, 'nonetheless', 'en-US' UNION
	SELECT 191, 'noone', 'en-US' UNION
	SELECT 192, 'nor', 'en-US' UNION
	SELECT 193, 'nothing', 'en-US' UNION
	SELECT 194, 'now', 'en-US' UNION
	SELECT 195, 'nowhere', 'en-US' UNION
	SELECT 196, 'o', 'en-US' UNION
	SELECT 197, 'of', 'en-US' UNION
	SELECT 198, 'off', 'en-US' UNION
	SELECT 199, 'often', 'en-US' UNION
	SELECT 200, 'on', 'en-US' UNION
	SELECT 201, 'once', 'en-US' UNION
	SELECT 202, 'one', 'en-US' UNION
	SELECT 203, 'one''s', 'en-US' UNION
	SELECT 204, 'only', 'en-US' UNION
	SELECT 205, 'onto', 'en-US' UNION
	SELECT 206, 'or', 'en-US' UNION
	SELECT 207, 'other', 'en-US' UNION
	SELECT 208, 'others', 'en-US' UNION
	SELECT 209, 'otherwise', 'en-US' UNION
	SELECT 210, 'our', 'en-US' UNION
	SELECT 211, 'ours', 'en-US' UNION
	SELECT 212, 'ourselves', 'en-US' UNION
	SELECT 213, 'out', 'en-US' UNION
	SELECT 214, 'over', 'en-US' UNION
	SELECT 215, 'overall', 'en-US' UNION
	SELECT 216, 'own', 'en-US' UNION