Home / Browse / Subtext / Mail / Archive

Donate

Subtext

Email Archive: subtext-commits (read-only)

[Subtext-commits] SF.net SVN: subtext: [3158] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2008-05-25 21:11

Revision: 3158
          http://subtext.svn.sourceforge.net/subtext/?rev=3158&view=rev
Author:   haacked
Date:     2008-05-25 14:11:28 -0700 (Sun, 25 May 2008)

Log Message:
-----------
Updated StoredProcedures.sql to reference the OpenID columns that were inadverdently removed.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-05-25 21:10:29 UTC (rev 3157)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-05-25 21:11:28 UTC (rev 3158)
@@ -3275,6 +3275,8 @@
 	, MobileSkinCssFile = @MobileSkinCssFile
 	, OpenIDUrl = @OpenIDUrl
 	, CardSpaceHash = @CardSpaceHash
+	, OpenIDServer = @OpenIDServer
+	, OpenIDDelegate = @OpenIDDelegate
 WHERE BlogId = @BlogId
 
 GO
@@ -3680,6 +3682,10 @@
 		, bgroup.Title AS BlogGroupTitle
 		, blog.MobileSkin
 		, blog.MobileSkinCssFile
+		, blog.OpenIDUrl
+		, blog.CardSpaceHash
+		, blog.OpenIDServer
+		, blog.OpenIDDelegate
 FROM [<dbUser,varchar,dbo>].[subtext_Config] blog
 	LEFT OUTER JOIN [<dbUser,varchar,dbo>].[subtext_BlogGroup] bgroup ON
 bgroup.Id = blog.BlogGroupId


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Thread View

Thread	Author	Date
[Subtext-commits] SF.net SVN: subtext: [1836] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql	<simo@us...>

[Subtext-commits] SF.net SVN: subtext: [1883] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <simo@us...> - 2006-10-25 08:46

Revision: 1883
          http://svn.sourceforge.net/subtext/?rev=1883&view=rev
Author:   simo
Date:     2006-10-25 01:46:16 -0700 (Wed, 25 Oct 2006)

Log Message:
-----------
Added a few stored procedures to manage plugin-blog connection

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-10-24 22:03:27 UTC (rev 1882)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-10-25 08:46:16 UTC (rev 1883)
@@ -415,13 +415,25 @@
 GO
 
 if exists (select * from dbo.sysobjects where id = object_id(N'[<dbUser,varchar,dbo>].[subtext_InsertPluginData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
-drop procedure [<dbUser,varchar,dbo>].[subtext_InsertPluginEntryData]
+drop procedure [<dbUser,varchar,dbo>].[subtext_InsertPluginData]
 GO
 
 if exists (select * from dbo.sysobjects where id = object_id(N'[<dbUser,varchar,dbo>].[subtext_UpdatePluginData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
-drop procedure [<dbUser,varchar,dbo>].[subtext_UpdatePluginEntryData]
+drop procedure [<dbUser,varchar,dbo>].[subtext_UpdatePluginData]
 GO
 
+if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[subtext_DeletePluginBlog]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
+drop procedure [<dbUser,varchar,dbo>].[subtext_DeletePluginBlog]
+GO
+
+if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[subtext_GetPluginBlog]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
+drop procedure [<dbUser,varchar,dbo>].[subtext_GetPluginBlog]
+GO
+
+if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[subtext_InsertPluginBlog]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
+drop procedure [<dbUser,varchar,dbo>].[subtext_InsertPluginBlog]
+GO
+
 SET QUOTED_IDENTIFIER OFF 
 GO
 SET ANSI_NULLS OFF 
@@ -4569,4 +4581,73 @@
 SET QUOTED_IDENTIFIER OFF 
 GO
 SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS OFF 
+GO
+
+CREATE PROCEDURE [<dbUser,varchar,dbo>].[subtext_DeletePluginBlog]
+(
+	@PluginID uniqueidentifier,
+	@BlogId int
+)
+as
+
+DELETE FROM [<dbUser,varchar,dbo>].[subtext_PluginBlog]
+WHERE PluginID=@PluginID and BlogID=@BlogId
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS OFF 
+GO
+
+CREATE PROCEDURE [<dbUser,varchar,dbo>].[subtext_GetPluginBlog]
+(
+	@BlogId int
+)
+
+AS
+
+SELECT PluiginID FROM [<dbUser,varchar,dbo>].[PluginBlog]
+WHERE
+BlogID=@BlogId
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER ON 
+GO
+SET ANSI_NULLS OFF 
+GO
+
+CREATE PROCEDURE [<dbUser,varchar,dbo>].[subtext_InsertPluginBlog]
+(
+	@PluginID uniqueidentifier,
+	@BlogId int
+)
+as
+
+INSERT INTO [<dbUser,varchar,dbo>].[subtext_PluginBlog]
+(
+	PluginID,
+	BlogID
+)
+VALUES
+(
+	@PluginID,
+	@BlogId
+)
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
 GO
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [1884] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <simo@us...> - 2006-10-25 09:59

Revision: 1884
          http://svn.sourceforge.net/subtext/?rev=1884&view=rev
Author:   simo
Date:     2006-10-25 02:59:45 -0700 (Wed, 25 Oct 2006)

Log Message:
-----------
Fixed some mistypes in stored procedures code

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-10-25 08:46:16 UTC (rev 1883)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-10-25 09:59:45 UTC (rev 1884)
@@ -4615,7 +4615,7 @@
 
 AS
 
-SELECT PluiginID FROM [<dbUser,varchar,dbo>].[PluginBlog]
+SELECT PluginID FROM [<dbUser,varchar,dbo>].[subtext_PluginBlog]
 WHERE
 BlogID=@BlogId
 GO


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [1911] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <simo@us...> - 2006-10-30 15:35

Revision: 1911
          http://svn.sourceforge.net/subtext/?rev=1911&view=rev
Author:   simo
Date:     2006-10-30 07:35:39 -0800 (Mon, 30 Oct 2006)

Log Message:
-----------
Fixed an error in one SP

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-10-29 22:18:33 UTC (rev 1910)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-10-30 15:35:39 UTC (rev 1911)
@@ -4520,11 +4520,40 @@
 GO
 
 
+
+
 SET QUOTED_IDENTIFIER OFF 
 GO
 SET ANSI_NULLS OFF 
 GO
 
+CREATE PROC [<dbUser,varchar,dbo>].[subtext_UpdatePluginData]
+(
+	@PluginID uniqueidentifier,
+	@BlogID int,
+	@EntryID int,
+	@Key nvarchar(256),
+	@Value ntext
+)
+AS
+
+UPDATE [<dbUser,varchar,dbo>].[subtext_PluginData]
+SET
+	[Value]=@Value
+FROM [<dbUser,varchar,dbo>].[subtext_PluginBlog]
+WHERE [<dbUser,varchar,dbo>].[subtext_PluginBlog].PluginID=@PluginID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].BlogID=@BlogID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].[Id]=[<dbUser,varchar,dbo>].[subtext_PluginData].BlogPluginID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].Enabled=1 AND [Key]=@Key AND EntryID=@EntryID
+GO
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS ON 
+GO
+
+SET QUOTED_IDENTIFIER OFF 
+GO
+SET ANSI_NULLS OFF 
+GO
+
+
 CREATE PROC [<dbUser,varchar,dbo>].[subtext_InsertPluginData]
 (
 	@PluginID uniqueidentifier,
@@ -4537,7 +4566,7 @@
 
 DECLARE @BlogPluginID int
 
-SELECT Id FROM [<dbUser,varchar,dbo>].[subtext_PluginData]
+SELECT @BlogPluginID=[Id] FROM [<dbUser,varchar,dbo>].[subtext_PluginBlog]
 WHERE PluginID=@PluginID AND BlogID=@BlogID
 
 INSERT INTO [<dbUser,varchar,dbo>].[subtext_PluginData]
@@ -4562,32 +4591,7 @@
 SET ANSI_NULLS ON 
 GO
 
-SET QUOTED_IDENTIFIER OFF 
-GO
-SET ANSI_NULLS OFF 
-GO
 
-CREATE PROC [<dbUser,varchar,dbo>].[subtext_UpdatePluginData]
-(
-	@PluginID uniqueidentifier,
-	@BlogID int,
-	@EntryID int,
-	@Key nvarchar(256),
-	@Value ntext
-)
-AS
-
-UPDATE [<dbUser,varchar,dbo>].[subtext_PluginData]
-SET
-	[Value]=@Value
-FROM [<dbUser,varchar,dbo>].[subtext_PluginBlog]
-WHERE [<dbUser,varchar,dbo>].[subtext_PluginBlog].PluginID=@PluginID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].BlogID=@BlogID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].[Id]=[<dbUser,varchar,dbo>].[subtext_PluginData].BlogPluginID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].Enabled=1 AND [Key]=@Key AND EntryID=@EntryID
-GO
-SET QUOTED_IDENTIFIER OFF 
-GO
-SET ANSI_NULLS ON 
-GO
-
 SET QUOTED_IDENTIFIER ON 
 GO
 SET ANSI_NULLS OFF 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2032] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <simo@us...> - 2006-11-18 23:33

Revision: 2032
          http://svn.sourceforge.net/subtext/?rev=2032&view=rev
Author:   simo
Date:     2006-11-18 15:33:12 -0800 (Sat, 18 Nov 2006)

Log Message:
-----------
changed default timezone id from -5 to -1188006249

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-11-18 23:07:48 UTC (rev 2031)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-11-18 23:33:12 UTC (rev 2032)
@@ -2952,7 +2952,7 @@
 	, @Application
 	, @Host
 	, 'Blog Author'
-	, -5
+	, -1188006249
 	,'en-US'
 	, 10
 	, @Flag


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2069] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2006-11-23 08:23

Revision: 2069
          http://svn.sourceforge.net/subtext/?rev=2069&view=rev
Author:   haacked
Date:     2006-11-23 00:23:28 -0800 (Thu, 23 Nov 2006)

Log Message:
-----------
Added the DROP statements for the membership views.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-11-23 08:19:00 UTC (rev 2068)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-11-23 08:23:28 UTC (rev 2069)
@@ -77,6 +77,26 @@
 
 /* The Rest of the script */
 
+-- Views
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_MembershipUsers]
+GO
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_Profiles]
+GO
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_Roles]
+GO
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_UsersInRoles]
+GO
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_WebPartState_Paths]
+GO
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_WebPartState_Shared]
+GO
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_WebPartState_User]
+GO
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_Applications]
+GO
+DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_Users]
+
+
 -- Membership Provider Stored Procs
 IF EXISTS (SELECT * FROM [information_schema].[routines] WHERE routine_name = 'subtext_RegisterSchemaVersion' AND routine_schema = '<dbUser,varchar,dbo>')
 DROP PROCEDURE [<dbUser,varchar,dbo>].[subtext_RegisterSchemaVersion]


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2081] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2006-12-04 05:29

Revision: 2081
          http://svn.sourceforge.net/subtext/?rev=2081&view=rev
Author:   haacked
Date:     2006-12-03 21:29:20 -0800 (Sun, 03 Dec 2006)

Log Message:
-----------
Updated drop view statements to be idempotent.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-12-04 05:22:03 UTC (rev 2080)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-12-04 05:29:20 UTC (rev 2081)
@@ -94,25 +94,42 @@
 /* The Rest of the script */
 
 -- Views
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_MembershipUsers' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_MembershipUsers]
 GO
+
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_Profiles' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_Profiles]
 GO
+
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_Roles' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_Roles]
 GO
+
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_UsersInRoles' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_UsersInRoles]
 GO
+
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_WebPartState_Paths' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_WebPartState_Paths]
 GO
+
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_WebPartState_Shared' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_WebPartState_Shared]
 GO
+
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_WebPartState_User' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_WebPartState_User]
 GO
+
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_Applications' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_Applications]
 GO
+
+IF EXISTS (SELECT * FROM [information_schema].[views] WHERE table_name = 'vw_subtext_Users' AND table_schema = '<dbUser,varchar,dbo>')
 DROP VIEW [<dbUser,varchar,dbo>].[vw_subtext_Users]
+GO
 
-
 -- Membership Provider Stored Procs
 IF EXISTS (SELECT * FROM [information_schema].[routines] WHERE routine_name = 'subtext_RegisterSchemaVersion' AND routine_schema = '<dbUser,varchar,dbo>')
 DROP PROCEDURE [<dbUser,varchar,dbo>].[subtext_RegisterSchemaVersion]


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2082] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2006-12-04 05:33

Revision: 2082
          http://svn.sourceforge.net/subtext/?rev=2082&view=rev
Author:   haacked
Date:     2006-12-03 21:33:21 -0800 (Sun, 03 Dec 2006)

Log Message:
-----------
Forgot the drop statement for subtext_CreateHost.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-12-04 05:29:20 UTC (rev 2081)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2006-12-04 05:33:21 UTC (rev 2082)
@@ -317,6 +317,10 @@
 DROP FUNCTION [<dbUser,varchar,dbo>].[iter_charlist_to_table]
 GO
 
+IF EXISTS (SELECT * FROM [information_schema].[routines] WHERE routine_name = 'subtext_CreateHost' AND routine_schema = '<dbUser,varchar,dbo>')
+DROP PROCEDURE [<dbUser,varchar,dbo>].[subtext_CreateHost]
+GO
+
 IF EXISTS (SELECT * FROM [information_schema].[routines] WHERE routine_name = 'subtext_VersionAdd' AND routine_schema = '<dbUser,varchar,dbo>')
 DROP PROCEDURE [<dbUser,varchar,dbo>].[subtext_VersionAdd]
 GO


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2490] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <simo@us...> - 2007-04-23 06:20

Revision: 2490
          http://svn.sourceforge.net/subtext/?rev=2490&view=rev
Author:   simo
Date:     2007-04-22 23:20:25 -0700 (Sun, 22 Apr 2007)

Log Message:
-----------
the subtext_Membership_GetUserByName SP always returned DateTimeNull as LastActivityDate:
this fixes the problem.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-04-23 05:17:37 UTC (rev 2489)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-04-23 06:20:25 UTC (rev 2490)
@@ -4837,7 +4837,7 @@
 		, IsApproved
 		, CreateDate
         , LastLoginDate
-        , @CurrentTimeUtc
+        , LastActivityDate = @CurrentTimeUtc
         , LastPasswordChangedDate
         , UserId
         , IsLockedOut


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2605] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2007-05-13 07:28

Revision: 2605
          http://svn.sourceforge.net/subtext/?rev=2605&view=rev
Author:   haacked
Date:     2007-05-13 00:28:34 -0700 (Sun, 13 May 2007)

Log Message:
-----------
Fixed a DROP command in the sql script.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-05-13 07:16:44 UTC (rev 2604)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-05-13 07:28:34 UTC (rev 2605)
@@ -8030,10 +8030,8 @@
 GO
 GRANT EXECUTE ON [<dbUser,varchar,dbo>].[subtext_Profile_GetProfiles] TO [public]
 GO
-GRANT EXECUTE ON [<dbUser,varchar,dbo>].[subtext_Membership_FindUsersByName] TO [public]
+GRANT EXECUTE ON [<dbUser,varchar,dbo>].[subtext_Membership_FindUsersByNameOrEmail] TO [public]
 GO
-GRANT EXECUTE ON [<dbUser,varchar,dbo>].[subtext_Membership_FindUsersByEmail] TO [public]
-GO
 GRANT EXECUTE ON [<dbUser,varchar,dbo>].[subtext_Membership_GetAllUsers] TO [public]
 GO
 GRANT EXECUTE ON [<dbUser,varchar,dbo>].[subtext_Users_DeleteUser] TO [public]


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2633] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2007-05-20 22:36

Revision: 2633
          http://svn.sourceforge.net/subtext/?rev=2633&view=rev
Author:   haacked
Date:     2007-05-20 15:36:31 -0700 (Sun, 20 May 2007)

Log Message:
-----------
Since the owner of a blog is implicitly a member of "Administrators", but doesn't have to explicitly be a member of that role, I needed to update the subtext_Membership_GetAllUsers query to make sure to return the blog owner.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-05-20 22:01:35 UTC (rev 2632)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-05-20 22:36:31 UTC (rev 2633)
@@ -6674,6 +6674,12 @@
 				INNER JOIN [<dbUser,varchar,dbo>].[subtext_Applications] a
 					ON r.ApplicationId = a.ApplicationId
 			WHERE a.ApplicationName = @ApplicationName
+			UNION
+			SELECT c.OwnerId 
+			FROM [<dbUser,varchar,dbo>].[subtext_Config] c
+				INNER JOIN [<dbUser,varchar,dbo>].[subtext_Applications] a
+					ON a.ApplicationId = c.ApplicationId
+			WHERE a.ApplicationName = @ApplicationName
 		)
 	ORDER BY UserName ASC
 	
@@ -6707,6 +6713,12 @@
 					INNER JOIN [<dbUser,varchar,dbo>].[subtext_Applications] a
 						ON r.ApplicationId = a.ApplicationId
 				WHERE a.ApplicationName = @ApplicationName
+				UNION
+				SELECT c.OwnerId 
+				FROM [<dbUser,varchar,dbo>].[subtext_Config] c
+					INNER JOIN [<dbUser,varchar,dbo>].[subtext_Applications] a
+						ON a.ApplicationId = c.ApplicationId
+				WHERE a.ApplicationName = @ApplicationName
 			)
 		)
 	ORDER BY UserName ASC
@@ -6725,6 +6737,12 @@
 				INNER JOIN [<dbUser,varchar,dbo>].[subtext_Applications] a
 					ON r.ApplicationId = a.ApplicationId
 			WHERE a.ApplicationName = @ApplicationName
+			UNION
+			SELECT c.OwnerId 
+			FROM [<dbUser,varchar,dbo>].[subtext_Config] c
+				INNER JOIN [<dbUser,varchar,dbo>].[subtext_Applications] a
+					ON a.ApplicationId = c.ApplicationId
+			WHERE a.ApplicationName = @ApplicationName
 		)
 END
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2692] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <ussherm@us...> - 2007-06-08 04:56

Revision: 2692
          http://svn.sourceforge.net/subtext/?rev=2692&view=rev
Author:   ussherm
Date:     2007-06-07 21:56:03 -0700 (Thu, 07 Jun 2007)

Log Message:
-----------
Fixing a broken Stored Proc - subtext_UpdateImage.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-07 04:47:19 UTC (rev 2691)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-08 04:56:03 UTC (rev 2692)
@@ -3374,7 +3374,7 @@
 	Width = @Width,
 	Height = @Height,
 	[File] = @File,
-	Active = @Active,
+	Active = @Active
 WHERE
 	ImageID = @ImageID AND BlogId = @BlogId
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2701] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <simo@us...> - 2007-06-10 10:31

Revision: 2701
          http://svn.sourceforge.net/subtext/?rev=2701&view=rev
Author:   simo
Date:     2007-06-10 03:31:09 -0700 (Sun, 10 Jun 2007)

Log Message:
-----------
Fixed pagable SPs: they were ordering entries and feedbacks on ID and not on date added

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-10 01:01:17 UTC (rev 2700)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-10 10:31:09 UTC (rev 2701)
@@ -1770,7 +1770,7 @@
 )
 AS
 
-DECLARE @FirstId int
+DECLARE @FirstDate datetime
 DECLARE @StartRow int
 DECLARE @StartRowIndex int
 
@@ -1778,10 +1778,10 @@
 
 SET ROWCOUNT @StartRowIndex
 -- Get the first entry id for the current page.
-SELECT	@FirstId = [ID] FROM [<dbUser,varchar,dbo>].[subtext_Content]
+SELECT	@FirstId = DateAdded FROM [<dbUser,varchar,dbo>].[subtext_Content]
 WHERE	BlogId = @BlogId 
 	AND PostType = @PostType 
-ORDER BY [ID] DESC
+ORDER BY DateAdded DESC
 
 -- Now, set the row count to MaximumRows and get
 -- all records >= @first_id
@@ -1808,9 +1808,9 @@
 FROM [<dbUser,varchar,dbo>].[subtext_Content] content
 	Left JOIN  subtext_EntryViewCount vc ON (content.[ID] = vc.EntryID AND vc.BlogId = @BlogId)
 WHERE 	content.BlogId = @BlogId 
-	AND content.[ID] <= @FirstId
+	AND content.DateAdded <= @FirstDate
 	AND PostType = @PostType
-ORDER BY content.[ID] DESC
+ORDER BY content.DateAdded DESC
  
 SELECT COUNT([ID]) AS TotalRecords
 FROM [<dbUser,varchar,dbo>].[subtext_Content] 
@@ -1847,7 +1847,7 @@
 )
 AS
 
-DECLARE @FirstId int
+DECLARE @FirstDate datetime
 DECLARE @StartRow int
 DECLARE @StartRowIndex int
 
@@ -1855,14 +1855,14 @@
 
 SET ROWCOUNT @StartRowIndex
 -- Get the first entry id for the current page.
-SELECT	@FirstId = content.[ID] 
+SELECT	@FirstDate = DateAdded 
 FROM [<dbUser,varchar,dbo>].[subtext_Content] content
 	INNER JOIN [<dbUser,varchar,dbo>].[subtext_Links] links ON content.[ID] = ISNULL(links.PostID, -1)
 	INNER JOIN [<dbUser,varchar,dbo>].[subtext_LinkCategories] cats ON (links.CategoryID = cats.CategoryID)
 WHERE	content.BlogId = @BlogId 
 	AND content.PostType = @PostType 
 	AND cats.CategoryID = @CategoryID
-ORDER BY content.[ID] DESC
+ORDER BY content.DateAdded DESC
 
 -- Now, set the row count to MaximumRows and get
 -- all records >= @first_id
@@ -1891,10 +1891,10 @@
 	INNER JOIN [<dbUser,varchar,dbo>].[subtext_LinkCategories] cats ON (l.CategoryID = cats.CategoryID)
 	Left JOIN  subtext_EntryViewCount vc ON (content.[ID] = vc.EntryID AND vc.BlogId = @BlogId)
 WHERE 	content.BlogId = @BlogId 
-	AND content.[ID] <= @FirstId
+	AND content.DateAdded <= @FirstDate
 	AND content.PostType = @PostType
 	AND cats.CategoryID = @CategoryID
-ORDER BY content.[ID] DESC
+ORDER BY content.DateAdded DESC
  
 SELECT COUNT(content.[ID]) AS TotalRecords
 FROM [<dbUser,varchar,dbo>].[subtext_Content] content
@@ -1935,7 +1935,7 @@
 IF @ExcludeFeedbackStatusMask IS NULL
 	SET @ExcludeFeedbackStatusMask = ~0
 
-DECLARE @FirstId int
+DECLARE @FirstDate datetime
 DECLARE @StartRow int
 DECLARE @StartRowIndex int
 
@@ -1943,13 +1943,13 @@
 
 SET ROWCOUNT @StartRowIndex
 -- Get the first entry id for the current page.
-SELECT @FirstId = f.[Id] 
+SELECT @FirstDate = DateCreated 
 FROM [<dbUser,varchar,dbo>].[subtext_FeedBack] f
 WHERE 	f.BlogId = @BlogId 
 	AND (f.StatusFlag & @StatusFlag = @StatusFlag)
 	AND (f.StatusFlag & @ExcludeFeedbackStatusMask = 0) -- Make sure the status doesn't have any of the excluded statuses set
 	AND (f.FeedbackType = @FeedbackType OR @FeedbackType IS NULL)
-ORDER BY f.[ID] DESC
+ORDER BY DateCreated DESC
 
 -- Now, set the row count to MaximumRows and get
 -- all records >= @first_id
@@ -1979,11 +1979,11 @@
 	LEFT OUTER JOIN [<dbUser,varchar,dbo>].[subtext_Content] c 
 		ON c.Id = f.EntryId
 WHERE 	f.BlogId = @BlogId 
-	AND f.[Id] <= @FirstId
+	AND f.DateCreated <= @FirstDate
 	AND f.StatusFlag & @StatusFlag = @StatusFlag
 	AND (f.StatusFlag & @ExcludeFeedbackStatusMask = 0) -- Make sure the status doesn't have any of the excluded statuses set
 	AND (f.FeedbackType = @FeedbackType OR @FeedbackType IS NULL)
-ORDER BY f.[Id] DESC
+ORDER BY DateCreated DESC
  
 SELECT COUNT(f.[Id]) AS TotalRecords
 FROM [<dbUser,varchar,dbo>].[subtext_FeedBack] f


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2702] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2007-06-10 22:05

Revision: 2702
          http://svn.sourceforge.net/subtext/?rev=2702&view=rev
Author:   haacked
Date:     2007-06-10 15:05:01 -0700 (Sun, 10 Jun 2007)

Log Message:
-----------
Fixing a minor error in the subtext_GetPageableEntries stored procedure. One of the vars was lesft as @FirstId and should've been changed to @FirstDate.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-10 10:31:09 UTC (rev 2701)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-10 22:05:01 UTC (rev 2702)
@@ -1778,7 +1778,7 @@
 
 SET ROWCOUNT @StartRowIndex
 -- Get the first entry id for the current page.
-SELECT	@FirstId = DateAdded FROM [<dbUser,varchar,dbo>].[subtext_Content]
+SELECT	@FirstDate = DateAdded FROM [<dbUser,varchar,dbo>].[subtext_Content]
 WHERE	BlogId = @BlogId 
 	AND PostType = @PostType 
 ORDER BY DateAdded DESC


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2703] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2007-06-11 00:01

Revision: 2703
          http://svn.sourceforge.net/subtext/?rev=2703&view=rev
Author:   haacked
Date:     2007-06-10 17:00:58 -0700 (Sun, 10 Jun 2007)

Log Message:
-----------
Fixed the paging for subtext_GetFeedback. Need to apply fix to other paging queries.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-10 22:05:01 UTC (rev 2702)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-11 00:00:58 UTC (rev 2703)
@@ -1936,6 +1936,7 @@
 	SET @ExcludeFeedbackStatusMask = ~0
 
 DECLARE @FirstDate datetime
+DECLARE @FirstId int
 DECLARE @StartRow int
 DECLARE @StartRowIndex int
 
@@ -1943,13 +1944,14 @@
 
 SET ROWCOUNT @StartRowIndex
 -- Get the first entry id for the current page.
-SELECT @FirstDate = DateCreated 
+SELECT @FirstDate = DateCreated,
+	@FirstId = f.Id
 FROM [<dbUser,varchar,dbo>].[subtext_FeedBack] f
 WHERE 	f.BlogId = @BlogId 
 	AND (f.StatusFlag & @StatusFlag = @StatusFlag)
 	AND (f.StatusFlag & @ExcludeFeedbackStatusMask = 0) -- Make sure the status doesn't have any of the excluded statuses set
 	AND (f.FeedbackType = @FeedbackType OR @FeedbackType IS NULL)
-ORDER BY DateCreated DESC
+ORDER BY DateCreated DESC, f.Id DESC
 
 -- Now, set the row count to MaximumRows and get
 -- all records >= @first_id
@@ -1980,6 +1982,7 @@
 		ON c.Id = f.EntryId
 WHERE 	f.BlogId = @BlogId 
 	AND f.DateCreated <= @FirstDate
+	AND f.Id <= @FirstId
 	AND f.StatusFlag & @StatusFlag = @StatusFlag
 	AND (f.StatusFlag & @ExcludeFeedbackStatusMask = 0) -- Make sure the status doesn't have any of the excluded statuses set
 	AND (f.FeedbackType = @FeedbackType OR @FeedbackType IS NULL)


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [2725] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <simo@us...> - 2007-06-14 05:59

Revision: 2725
          http://svn.sourceforge.net/subtext/?rev=2725&view=rev
Author:   simo
Date:     2007-06-13 22:59:28 -0700 (Wed, 13 Jun 2007)

Log Message:
-----------
a "-- GO HERE" inside the StoredProcedures.sql script was being executed.
For the moment removed the comment in the script: maybe it's better to fix the script runner to try not to run SQL comments

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-14 05:48:23 UTC (rev 2724)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2007-06-14 05:59:28 UTC (rev 2725)
@@ -2362,8 +2362,8 @@
 GRANT  EXECUTE  ON [<dbUser,varchar,dbo>].[subtext_GetPageableReferrers]  TO [public]
 GO
 
--- GO HERE
 
+
 SET QUOTED_IDENTIFIER OFF 
 GO
 SET ANSI_NULLS ON 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [3099] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <simo@us...> - 2008-04-07 08:17

Revision: 3099
          http://subtext.svn.sourceforge.net/subtext/?rev=3099&view=rev
Author:   simo
Date:     2008-04-07 01:17:30 -0700 (Mon, 07 Apr 2008)

Log Message:
-----------
I hate updating old SPs... in a future version we might want to use some more automatic way of versioning DB, like RikMigrations or something similar

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-04-07 08:05:01 UTC (rev 3098)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-04-07 08:17:30 UTC (rev 3099)
@@ -2477,7 +2477,7 @@
 	AND (EntryName = @EntryName OR @EntryName IS NULL) 
 	AND (BlogId = @BlogId OR  @BlogId IS NULL)
 	AND PostConfig & 1 <> CASE @IsActive WHEN 1 THEN 0 Else -1 END
-ORDER BY [ID] DESC
+ORDER BY [<dbUser,varchar,dbo>].[subtext_Content].[ID] DESC
 
 IF @IncludeCategories = 1
 BEGIN


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [3155] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <twyford@us...> - 2008-05-25 20:54

Revision: 3155
          http://subtext.svn.sourceforge.net/subtext/?rev=3155&view=rev
Author:   twyford
Date:     2008-05-25 13:54:49 -0700 (Sun, 25 May 2008)

Log Message:
-----------
adding in missing columns.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-05-25 09:19:05 UTC (rev 3154)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-05-25 20:54:49 UTC (rev 3155)
@@ -3238,6 +3238,8 @@
 	, @MobileSkinCssFile nvarchar(100) = NULL
 	, @OpenIDUrl varchar(255) = NULL
 	, @CardSpaceHash nvarchar(512) = NULL
+	, @OpenIDServer varchar(255) = NULL
+	, @OpenIDDelegate varchar(255) = NULL
 )
 AS
 UPDATE [<dbUser,varchar,dbo>].[subtext_Config]


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [3158] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <haacked@us...> - 2008-05-25 21:11

Revision: 3158
          http://subtext.svn.sourceforge.net/subtext/?rev=3158&view=rev
Author:   haacked
Date:     2008-05-25 14:11:28 -0700 (Sun, 25 May 2008)

Log Message:
-----------
Updated StoredProcedures.sql to reference the OpenID columns that were inadverdently removed.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-05-25 21:10:29 UTC (rev 3157)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-05-25 21:11:28 UTC (rev 3158)
@@ -3275,6 +3275,8 @@
 	, MobileSkinCssFile = @MobileSkinCssFile
 	, OpenIDUrl = @OpenIDUrl
 	, CardSpaceHash = @CardSpaceHash
+	, OpenIDServer = @OpenIDServer
+	, OpenIDDelegate = @OpenIDDelegate
 WHERE BlogId = @BlogId
 
 GO
@@ -3680,6 +3682,10 @@
 		, bgroup.Title AS BlogGroupTitle
 		, blog.MobileSkin
 		, blog.MobileSkinCssFile
+		, blog.OpenIDUrl
+		, blog.CardSpaceHash
+		, blog.OpenIDServer
+		, blog.OpenIDDelegate
 FROM [<dbUser,varchar,dbo>].[subtext_Config] blog
 	LEFT OUTER JOIN [<dbUser,varchar,dbo>].[subtext_BlogGroup] bgroup ON
 bgroup.Id = blog.BlogGroupId


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Subtext-commits] SF.net SVN: subtext: [3165] trunk/SubtextSolution/Subtext.Installation/ Scripts/StoredProcedures.sql

From: <ussherm@us...> - 2008-05-26 15:55

Revision: 3165
          http://subtext.svn.sourceforge.net/subtext/?rev=3165&view=rev
Author:   ussherm
Date:     2008-05-26 08:55:06 -0700 (Mon, 26 May 2008)

Log Message:
-----------
Missing one of the parameters from the subtext_GetLinkCollectionByPostID Sproc... was causing an IndexOutOfBoundsException when trying to load a post.

Modified Paths:
--------------
    trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql

Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-05-26 06:17:16 UTC (rev 3164)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql	2008-05-26 15:55:06 UTC (rev 3165)
@@ -1591,6 +1591,7 @@
 	, CategoryID
 	, PostID = ISNULL(PostID, -1)
 	, NewWindow 
+	, Rel
 FROM [<dbUser,varchar,dbo>].[subtext_Links]
 WHERE PostID = @PostID 
 	AND BlogId = @BlogId


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.