02.02.02.sqldataprovider

完整的商业模板和强大的后台管理功能

	SELECT 217, 'p', 'en-US' UNION
	SELECT 218, 'per', 'en-US' UNION
	SELECT 219, 'perhaps', 'en-US' UNION
	SELECT 220, 'q', 'en-US' UNION
	SELECT 221, 'r', 'en-US' UNION
	SELECT 222, 'rather', 'en-US' UNION
	SELECT 223, 'recent', 'en-US' UNION
	SELECT 224, 'recently', 'en-US' UNION
	SELECT 225, 's', 'en-US' UNION
	SELECT 226, 'same', 'en-US' UNION
	SELECT 227, 'seem', 'en-US' UNION
	SELECT 228, 'seemed', 'en-US' UNION
	SELECT 229, 'seeming', 'en-US' UNION
	SELECT 230, 'seems', 'en-US' UNION
	SELECT 231, 'seven', 'en-US' UNION
	SELECT 232, 'several', 'en-US' UNION
	SELECT 233, 'she', 'en-US' UNION
	SELECT 234, 'she''d', 'en-US' UNION
	SELECT 235, 'she''ll', 'en-US' UNION
	SELECT 236, 'she''s', 'en-US' UNION
	SELECT 237, 'should', 'en-US' UNION
	SELECT 238, 'shouldn''t', 'en-US' UNION
	SELECT 239, 'since', 'en-US' UNION
	SELECT 240, 'so', 'en-US' UNION
	SELECT 241, 'some', 'en-US' UNION
	SELECT 242, 'somehow', 'en-US' UNION
	SELECT 243, 'someone', 'en-US' UNION
	SELECT 244, 'something', 'en-US' UNION
	SELECT 245, 'sometime', 'en-US' UNION
	SELECT 246, 'sometimes', 'en-US' UNION
	SELECT 247, 'somewhere', 'en-US' UNION
	SELECT 248, 'still', 'en-US' UNION
	SELECT 249, 'such', 'en-US' UNION
	SELECT 250, 't', 'en-US' UNION
	SELECT 251, 'taking', 'en-US' UNION
	SELECT 252, 'than', 'en-US' UNION
	SELECT 253, 'that', 'en-US' UNION
	SELECT 254, 'that''ll', 'en-US' UNION
	SELECT 255, 'that''s', 'en-US' UNION
	SELECT 256, 'that''ve', 'en-US' UNION
	SELECT 257, 'the', 'en-US' UNION
	SELECT 258, 'their', 'en-US' UNION
	SELECT 259, 'them', 'en-US' UNION
	SELECT 260, 'themselves', 'en-US' UNION
	SELECT 261, 'then', 'en-US' UNION
	SELECT 262, 'thence', 'en-US' UNION
	SELECT 263, 'there', 'en-US' UNION
	SELECT 264, 'there''d', 'en-US' UNION
	SELECT 265, 'there''ll', 'en-US' UNION
	SELECT 266, 'there''re', 'en-US' UNION
	SELECT 267, 'there''s', 'en-US' UNION
	SELECT 268, 'there''ve', 'en-US' UNION
	SELECT 269, 'thereafter', 'en-US' UNION
	SELECT 270, 'thereby', 'en-US' UNION
	SELECT 271, 'therefore', 'en-US' UNION
	SELECT 272, 'therein', 'en-US' UNION
	SELECT 273, 'thereupon', 'en-US' UNION
	SELECT 274, 'these', 'en-US' UNION
	SELECT 275, 'they', 'en-US' UNION
	SELECT 276, 'they''d', 'en-US' UNION
	SELECT 277, 'they''ll', 'en-US' UNION
	SELECT 278, 'they''re', 'en-US' UNION
	SELECT 279, 'they''ve', 'en-US' UNION
	SELECT 280, 'thirty', 'en-US' UNION
	SELECT 281, 'this', 'en-US' UNION
	SELECT 282, 'those', 'en-US' UNION
	SELECT 283, 'though', 'en-US' UNION
	SELECT 284, 'three', 'en-US' UNION
	SELECT 285, 'through', 'en-US' UNION
	SELECT 286, 'throughout', 'en-US' UNION
	SELECT 287, 'thru', 'en-US' UNION
	SELECT 288, 'thus', 'en-US' UNION
	SELECT 289, 'to', 'en-US' UNION
	SELECT 290, 'together', 'en-US' UNION
	SELECT 291, 'too', 'en-US' UNION
	SELECT 292, 'toward', 'en-US' UNION
	SELECT 293, 'towards', 'en-US' UNION
	SELECT 294, 'u', 'en-US' UNION
	SELECT 295, 'under', 'en-US' UNION
	SELECT 296, 'unless', 'en-US' UNION
	SELECT 297, 'unlike', 'en-US' UNION
	SELECT 298, 'unlikely', 'en-US' UNION
	SELECT 299, 'until', 'en-US' UNION
	SELECT 300, 'up', 'en-US' UNION
	SELECT 301, 'upon', 'en-US' UNION
	SELECT 302, 'us', 'en-US' UNION
	SELECT 303, 'used', 'en-US' UNION
	SELECT 304, 'using', 'en-US' UNION
	SELECT 305, 'v', 'en-US' UNION
	SELECT 306, 'very', 'en-US' UNION
	SELECT 307, 'via', 'en-US' UNION
	SELECT 308, 'w', 'en-US' UNION
	SELECT 309, 'was', 'en-US' UNION
	SELECT 310, 'wasn''t', 'en-US' UNION
	SELECT 311, 'we', 'en-US' UNION
	SELECT 312, 'we''d', 'en-US' UNION
	SELECT 313, 'we''ll', 'en-US' UNION
	SELECT 314, 'we''re', 'en-US' UNION
	SELECT 315, 'we''ve', 'en-US' UNION
	SELECT 316, 'well', 'en-US' UNION
	SELECT 317, 'were', 'en-US' UNION
	SELECT 318, 'weren''t', 'en-US' UNION
	SELECT 319, 'what', 'en-US' UNION
	SELECT 320, 'what''ll', 'en-US' UNION
	SELECT 321, 'what''s', 'en-US' UNION
	SELECT 322, 'what''ve', 'en-US' UNION
	SELECT 323, 'whatever', 'en-US' UNION
	SELECT 324, 'when', 'en-US' UNION
	SELECT 325, 'whence', 'en-US' UNION
	SELECT 326, 'whenever', 'en-US' UNION
	SELECT 327, 'where', 'en-US' UNION
	SELECT 328, 'where''s', 'en-US' UNION
	SELECT 329, 'whereafter', 'en-US' UNION
	SELECT 330, 'whereas', 'en-US' UNION
	SELECT 331, 'whereby', 'en-US' UNION
	SELECT 332, 'wherein', 'en-US' UNION
	SELECT 333, 'whereupon', 'en-US' UNION
	SELECT 334, 'wherever', 'en-US' UNION
	SELECT 335, 'whether', 'en-US' UNION
	SELECT 336, 'which', 'en-US' UNION
	SELECT 337, 'while', 'en-US' UNION
	SELECT 338, 'whither', 'en-US' UNION
	SELECT 339, 'who', 'en-US' UNION
	SELECT 340, 'who''d', 'en-US' UNION
	SELECT 341, 'who''ll', 'en-US' UNION
	SELECT 342, 'who''s', 'en-US' UNION
	SELECT 343, 'whoever', 'en-US' UNION
	SELECT 344, 'whole', 'en-US' UNION
	SELECT 345, 'whom', 'en-US' UNION
	SELECT 346, 'whomever', 'en-US' UNION
	SELECT 347, 'whose', 'en-US' UNION
	SELECT 348, 'why', 'en-US' UNION
	SELECT 349, 'will', 'en-US' UNION
	SELECT 350, 'with', 'en-US' UNION
	SELECT 351, 'within', 'en-US' UNION
	SELECT 352, 'without', 'en-US' UNION
	SELECT 353, 'won''t', 'en-US' UNION
	SELECT 354, 'would', 'en-US' UNION
	SELECT 355, 'wouldn''t', 'en-US' UNION
	SELECT 356, 'x', 'en-US' UNION
	SELECT 357, 'y', 'en-US' UNION
	SELECT 358, 'yes', 'en-US' UNION
	SELECT 359, 'yet', 'en-US' UNION
	SELECT 360, 'you', 'en-US' UNION
	SELECT 361, 'you''d', 'en-US' UNION
	SELECT 362, 'you''ll', 'en-US' UNION
	SELECT 363, 'you''re', 'en-US' UNION
	SELECT 364, 'you''ve', 'en-US' UNION
	SELECT 365, 'your', 'en-US' UNION
	SELECT 366, 'yours', 'en-US' UNION
	SELECT 367, 'yourself', 'en-US' UNION
	SELECT 368, 'yourselves', 'en-US' UNION
	SELECT 369, 'z', 'en-US'

SET IDENTITY_INSERT {databaseOwner}{objectQualifier}SearchCommonWords OFF
GO

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

CREATE PROCEDURE {databaseOwner}{objectQualifier}GetDefaultLanguageByModule
(
	@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	

SELECT DISTINCT m.ModuleID, p.DefaultLanguage
FROM            {objectQualifier}Modules  m
INNER JOIN      {objectQualifier}Tabs t ON m.TabID = t.TabID
INNER JOIN      {objectQualifier}Portals p ON p.PortalID = t.PortalID
WHERE		        m.ModuleID in (SELECT ModuleID FROM @TempList)
ORDER BY        m.ModuleID	
		
END

GO

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

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

CREATE PROCEDURE {databaseOwner}{objectQualifier}GetSearchResultModules

@PortalID INT

AS
SELECT  {objectQualifier}Modules.TabID,
	      {objectQualifier}Tabs.TabName + ' - <' + {objectQualifier}Modules.ModuleTitle + '>' AS SearchTabName
FROM    {objectQualifier}ModuleDefinitions INNER JOIN
        {objectQualifier}Modules ON {objectQualifier}ModuleDefinitions.ModuleDefID = {objectQualifier}Modules.ModuleDefID INNER JOIN
        {objectQualifier}Tabs ON {objectQualifier}Modules.TabID = {objectQualifier}Tabs.TabID
WHERE	FriendlyName = 'Search Results'
AND     {objectQualifier}Tabs.PortalID = @PortalID
AND     {objectQualifier}Tabs.IsDeleted = 0
AND     {objectQualifier}Modules.IsDeleted = 0
ORDER BY SearchTabName

GO


/************************************************************/
/*****  Cleanup old search code                         *****/
/************************************************************/

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

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

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

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

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

/****** Object:  Table {databaseOwner}{objectQualifier}Search    Script Date: Sunday, September 26, 2004 ******/
if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Search') and OBJECTPROPERTY(id, N'IsTable') = 1)
drop table {databaseOwner}{objectQualifier}Search
GO

INSERT INTO {databaseOwner}{objectQualifier}Schedule VALUES ('DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE', 5, 'm', 10, 'm', 60, '', 0, 1, 'SearchEngine')
GO

drop procedure {databaseOwner}{objectQualifier}GetPortal
GO

create procedure {databaseOwner}{objectQualifier}GetPortal

@PortalId  int

as

select P.*,
       'SuperTabId' = ( select TabId from {objectQualifier}Tabs where PortalId is null and ParentId is null ),
       'AdministratorRoleName' = ( select RoleName from {databaseOwner}{objectQualifier}Roles where RoleId = P.AdministratorRoleID ),
       'RegisteredRoleName' = ( select RoleName from {databaseOwner}{objectQualifier}Roles where RoleId = P.RegisteredRoleID )
from {objectQualifier}Portals P
where  PortalId = @PortalId

GO

drop  procedure {databaseOwner}{objectQualifier}GetPortalTabModules
GO

create procedure {databaseOwner}{objectQualifier}GetPortalTabModules

@PortalId int, 
@TabId int

as

select M.*,
       MC.ModuleControlId,
       MC.ControlSrc,
       MC.ControlType,
       MC.ControlTitle,
       MC.HelpURL,
       DM.*
from {databaseOwner}{objectQualifier}Modules M
inner join {databaseOwner}{objectQualifier}Tabs T on M.TabId = T.TabId
inner join {databaseOwner}{objectQualifier}ModuleDefinitions MD on M.ModuleDefId = MD.ModuleDefId
inner join {databaseOwner}{objectQualifier}ModuleControls MC on MD.ModuleDefId = MC.ModuleDefId
inner join {databaseOwner}{objectQualifier}DesktopModules DM on MD.DesktopModuleId = DM.DesktopModuleId
where  (M.TabId = @TabId or (M.AllTabs = 1 and T.PortalId = @PortalId))
and    ControlKey is null
order by ModuleOrder

GO

insert into {objectQualifier}ModuleControls ( ControlKey, ControlTitle, ModuleDefID, ControlSrc, IconFile, ControlType, ViewOrder )
values ( 'Help', 'Module Help', null, 'controls/Help.ascx', 'icon_help_32px.gif', 0, null )
GO


ALTER TABLE {databaseOwner}{objectQualifier}UrlTracking ADD
	TrackClicks bit NOT NULL CONSTRAINT DF_{objectQualifier}UrlTracking_{objectQualifier}TrackClicks DEFAULT 1,
	ModuleId int NULL,
        NewWindow bit NOT NULL CONSTRAINT DF_{objectQualifier}UrlTracking_{objectQualifier}NewWindow DEFAULT 0
GO


update {databaseOwner}{objectQualifier}UrlTracking
set    ModuleId = ( select min(ModuleId) from {objectQualifier}UrlLog where {objectQualifier}UrlLog.UrlTrackingID = {objectQualifier}UrlTracking.UrlTrackingID )
GO

ALTER TABLE {databaseOwner}{objectQualifier}UrlLog
	DROP COLUMN ModuleID
GO

ALTER TABLE {databaseOwner}{objectQualifier}UrlTracking
	DROP CONSTRAINT IX_UrlTracking
GO

ALTER TABLE {databaseOwner}{objectQualifier}UrlTracking ADD CONSTRAINT
	IX_{objectQualifier}UrlTracking UNIQUE NONCLUSTERED 
	(
	PortalID,
	Url,
	ModuleId
	) ON [PRIMARY]

GO

drop procedure {databaseOwner}{objectQualifier}AddUrlTracking
GO

create procedure {databaseOwner}{objectQualifier}AddUrlTracking

@PortalID     int,
@Url          nvarchar(255),
@UrlType      char(1),
@LogActivity  bit,
@TrackClicks  bit,
@ModuleId     int,
@NewWindow    bit

as

insert into {objectQualifier}UrlTracking (
  PortalID,
  Url,
  UrlType,
  Clicks,
  LastClick,
  CreatedDate,
  LogActivity,
  TrackClicks,
  ModuleId,
  NewWindow
)
values (
  @PortalID,
  @Url,
  @UrlType,
  0,
  null,
  getdate(),
  @LogActivity,
  @TrackClicks,
  @ModuleId,
  @NewWindow
)