about summary refs log tree commit diff
path: root/migrations
AgeCommit message (Collapse)AuthorFilesLines
2018-04-14 fix(migrations): Change weighting of title vs. bodyVincent Ambo1-2/+2
After thinking for a little while I actually think the body of a post may be more relevant when searching for posts than the thread title. Right now this is just a hunch and we'll have to find out how it actually ends up working in real life.
2018-04-14 feat(migrations): Add materialized view & index for full text searchVincent Ambo2-0/+23
Adds a materialized view to be used for full-text searches that indexes the tsvector documents for each post.
2018-04-14 feat(db): Add support for stickies in databaseVincent Ambo4-16/+23
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.
2018-04-14 feat(db): Add view for ordering thread index by most recent postVincent Ambo2-0/+16
This implements the classic thread ordering expected by most forum users (i.e. the thread with the most recent post is at the top).
2018-04-14 feat(migrations): Drop 'body' column from threadsVincent Ambo2-0/+7
As a data model simplification, the text of a thread's top post should simply also go into the posts table.
2018-04-08 feat(migrations): Add author columns to tablesVincent Ambo2-0/+15
Adds columns for author names and emails to both threads and posts. "Users" don't (yet? who knows!) exist as independent entity in Converse, they are simply "inferred" via OIDC providers.
2018-04-08 feat(migrations): Default 'posted' columns to NOW()Vincent Ambo2-0/+4
2018-04-08 refactor(db): Establish Post->Thread associationVincent Ambo2-0/+2
This makes it possible to query posts by thread via Diesel.
2018-04-08 feat(migrations): Add posts & threads tablesVincent Ambo5-0/+57