TASK: Sql changes for communityforums_Topics_Properties

[johnhenley]

identify any stored procedures or other sql objects dependent on TopicData column in communityforums_Topics

create new SqlDataProvider script

Create new table for communityforums_Topic_Properties

• Columns
  Id (pk) int
  TopicId int
  PropertyId int
  Value

• Indexes
  Pk
  Propertyid
  Topicid

• Add FK to topics table with cascade delete

• Add fk to property table

(Need to do cascade delete in code from property table row delete)

Write script to migrate data from xml nodes in communityforums_Topics table TopicData column into newly created table

Drop TopicData column from communityforums_Topics table

Add drop statements to uninstall script to drop foreign keys and communityforums_Topic_Properties