Removed now-obsolete TopicIndex view

JeremyCaney · JeremyCaney · commit a4a28d68af78 · 2020-12-23T15:45:08.000-08:00
The `TopicIndex` extracted the latest version of the key attributes—i.e., `Key`, `ContentType`, and `ParentID`—from the `Attributes` table and pivoted them to columns. That complexity can now be handled by a straight query of the `Topics` table, as has already been implemented in the dependency functions and stored procedures (2dc4fb2). As such, the `TopicIndex` view is no longer used, and no longer serves a purpose, and can be safely removed.
diff --git a/OnTopic.Data.Sql.Database/OnTopic.Data.Sql.Database.sqlproj b/OnTopic.Data.Sql.Database/OnTopic.Data.Sql.Database.sqlproj
@@ -89,7 +89,6 @@
     <Build Include="Functions\GetExtendedAttribute.sql" />
     <Build Include="Functions\GetParentID.sql" />
     <Build Include="Functions\GetTopicID.sql" />
-    <Build Include="Functions\GetTopicIDByUniqueKey.sql" />
     <Build Include="Functions\GetUniqueKey.sql" />
     <Build Include="Stored Procedures\CreateTopic.sql" />
     <Build Include="Stored Procedures\DeleteTopic.sql" />
@@ -119,7 +118,6 @@
     <Build Include="Views\AttributeIndex.sql" />
     <Build Include="Views\AttributeIndex.sql" />
     <Build Include="Views\ExtendedAttributeIndex.sql" />
-    <Build Include="Views\TopicIndex.sql" />
     <Build Include="Views\VersionHistoryIndex.sql" />
   </ItemGroup>
   <ItemGroup>
diff --git a/OnTopic.Data.Sql.Database/README.md b/OnTopic.Data.Sql.Database/README.md
@@ -45,7 +45,6 @@ The following is a summary of the most relevant stored procedures.
 
 ## Views
 The majority of the views provide records corresponding to the latest version of records for each topic. These include:
-- **[`TopicIndex`](Views/TopicIndex.sql)**: Includes the core topic attributes, `topicId`, `Key`, `ParentId`, and `ContentType`.
 - **[`AttributeIndex`](Views/AttributeIndex.sql)**: Includes the `TopicId`, `AttributeKey` and `AttributeValue`.
 - **[`ExtendedAttributesIndex`](Views/ExtendedAttributeIndex.sql)**: Includes the `TopicId` and `AttributeXml`.
 - **[`VersionHistoryIndex`](Views/VersionHistoryIndex.sql)**: Includes up to the last five `Version` records for every `TopicId`.
diff --git a/OnTopic.Data.Sql.Database/Views/TopicIndex.sql b/OnTopic.Data.Sql.Database/Views/TopicIndex.sql
