* update `Post` table schema and migration plan to index `type` column
* use `unsafeExecuteSql()` for adding index during migration
* Update SQL query to create index
Co-authored-by: Elias Nahum <nahumhbl@gmail.com>
* Update docs
* Remove `UNIQUE` from SQL query
Co-authored-by: Rahim Rahman <rahim.rahman@mattermost.com>
---------
Co-authored-by: Elias Nahum <nahumhbl@gmail.com>
Co-authored-by: Rahim Rahman <rahim.rahman@mattermost.com>
* started with the diagrams
* removed redundant tables
next step:
1. reconstruct id ( local id vs server id )
2. annotate fields with examples
3. recreate relationship
* work in progress
* work in progress
* fix association
* update postsInChannel
* removed SlashCommands from the Server database schema
* added missing associations in the models and updated docs/database
* exported server database
* update test
* code corrections following review
* update relationship
* update docs
* removed cyclic relationship
* Revert "removed cyclic relationship"
This reverts commit 4d784efb815c0430aa3f7cc433ac4125898d2621.
* removed isOptional from Draft
* linked myChannelSettings to myChannel instead of Channel
* update diagrams
* store null instead of empty string
* update thread association
Co-authored-by: Elias Nahum <nahumhbl@gmail.com>