Removed unused and redundant ExtendedAttributes.DateModified column

JeremyCaney · JeremyCaney · commit 242593c48b89 · 2021-01-14T15:01:17.000-08:00
This is effectively replaced by `Version`, and is no longer utilized.
diff --git a/OnTopic.Data.Sql.Database/Tables/ExtendedAttributes.sql b/OnTopic.Data.Sql.Database/Tables/ExtendedAttributes.sql
@@ -9,7 +9,6 @@ CREATE
 TABLE	[dbo].[ExtendedAttributes] (
 	  [TopicID]		INT	NOT NULL,
 	  [AttributesXml]	XML	NOT NULL,
-	  [DateModified]	DATETIME	NOT NULL	DEFAULT GETUTCDATE(),
 	  [Version]		DATETIME	NOT NULL	DEFAULT GETUTCDATE(),
   CONSTRAINT	  [PK_ExtendedAttributes]		PRIMARY KEY	CLUSTERED (
 	    [TopicID]		ASC,
diff --git a/OnTopic.Data.Sql.Database/Utilities/Stored Procedures/DeleteConsecutiveExtendedAttributes.sql b/OnTopic.Data.Sql.Database/Utilities/Stored Procedures/DeleteConsecutiveExtendedAttributes.sql
@@ -33,7 +33,6 @@ Print('Initial Count: ' + CAST(@Count AS VARCHAR) + ' Extended Attributes in the
 WITH GroupedValues AS (
   SELECT	TopicID,
 	AttributesXml,
-	DateModified,
 	Version,
 	ValueGroup = ROW_NUMBER() OVER(PARTITION BY TopicID ORDER BY TopicID, Version)
 	- ROW_NUMBER() OVER(PARTITION BY TopicID, CAST(AttributesXml AS NVARCHAR(MAX)) ORDER BY TopicID, Version)
@@ -46,7 +45,6 @@ WITH GroupedValues AS (
 RankedValues AS (
   SELECT	TopicID,
 	AttributesXml,
-	DateModified,
 	Version,
 	ValueGroup,
 	ValueRank = ROW_NUMBER() OVER(PARTITION BY ValueGroup, TopicID, CAST(AttributesXml AS NVARCHAR(MAX)) ORDER BY TopicID, Version)
