diff options
| author | Vincent Ambo <tazjin@gmail.com> | 2018-04-14T15·47+0200 |
|---|---|---|
| committer | Vincent Ambo <tazjin@gmail.com> | 2018-04-14T15·47+0200 |
| commit | d1c45159b9bb23553768b06ce7ad97ec38e8b845 (patch) | |
| tree | f6dae457fddcb75bb6a3c65eec699868beb3b89f /migrations/2018-04-14-153202_add_stickies_improve_index/down.sql | |
| parent | c136d34e798f399c515b31d90fd1194b02005c96 (diff) | |
feat(db): Add support for stickies in database
Adds a 'sticky' column to threads and rewrites the thread index to take sticky markings into account when ordering threads. Stickies are not yet highlighted in any way in the forum overview.
Diffstat (limited to 'migrations/2018-04-14-153202_add_stickies_improve_index/down.sql')
| -rw-r--r-- | migrations/2018-04-14-153202_add_stickies_improve_index/down.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/migrations/2018-04-14-153202_add_stickies_improve_index/down.sql b/migrations/2018-04-14-153202_add_stickies_improve_index/down.sql new file mode 100644 index 000000000000..a67ada3d4a57 --- /dev/null +++ b/migrations/2018-04-14-153202_add_stickies_improve_index/down.sql @@ -0,0 +1,2 @@ +DROP VIEW thread_index; +ALTER TABLE threads DROP COLUMN sticky; |