Added index to btCoreConversionMessage.cnvMessageID for potential join to ConversionMessages table
Added index to btCoreGatheringDisplay.gaID for potential join to Gatherings table
Added index to btCorePageTypeComposerControlOutput.ptComposerOutputControlID for potential join to PageTypeComposerOutputControls table
Added index to btCoreStackDisplay.stID for potential join to Stacks table
Added index to btDiscussions.ptID for potential join to PageTypes table

Added index to btDiscussions.cnvDiscussionID for potential join to ConversationDiscussions table
Switched some fields in btFaqEntries to self closing tags

Added index for btFaqEntries.bID (bID, sortOrder) for where clause + order by, and for potential join to the Blocks table
Added index to btFlashContent.fID for potential join to Files table
Added index to btFormAnswers.asID for potential join to btFormAnswerSet table
Added index to btFormAnswerSet.uID for potential join to Users table
Added index to btFormQuestions.bID (bID, questionSetID) for query where and for potential join to Blocks table
Added index to btPageList.ptID for potential join to PageTypes table
Added index to btSlideshow.fsID for potential join to FileSets table
Added index to btSlideshowImg.fsID for potential join to FileSets table

Added index to btSlideshowImg.bID for potential join to Blocks table and for query where  + MAX(imgHeight)
Added index to btSocialLinks.bID (bID, displayOrder) for query where + order by and for potential join to Blocks table

Added index to btSocialLinks.slID for potential join to SocialLinks table
Added index to btSurveyOptions.bID (bID, displayOrder) for query where + order by and for potential join to Blocks table
Added index to btSurveyResults.optionID for join to btSurveyOptions table

Added index to btSurveyResults.cID (cID, optionID, bID) for join to Collections table and for query where

Added index to btSurveyResults.bID (bID, cID, uID) for join to Blocks table and for query where

Added index to btSurveyResults.uID for join to Users table
Added index to btVideo.fID for potential join to Files table
Merge pull request #445 from ExchangeCore/BlockTypeSetBlockTypes-contains-error

fix akID doesn't exist in BlockTypeSetBlockTypes table
Merge pull request #444 from evancooper/page_type_permissions_dashboard_page

page type permissions dashboard page bootstrappin
Merge pull request #443 from evancooper/seo_statistics_dashboard_page

SEO statistics dashboard page bootstrapping