summaryrefslogtreecommitdiff
path: root/db/08to09.sql
AgeCommit message (Collapse)Author
2009-11-10Adjusting indexes to make favorites query more efficient, based on feedback ↵Brion Vibber
from ops. fave_user_id_idx index changed from (user_id) to (user_id,modified), so the timestamp ordering can be done straight from the index while we're looking up the user's notices. Added to 08to09.sql and 08to09_pg.sql; may need to be run manually by folks doing development. (No harm if you don't update it, the favorites tab/rss feed will just stay inefficent.)
2009-11-02Added 'login' command that gives you a link that can be used to login to the ↵Craig Andrews
website
2009-08-29added missing parts to postgres update, and the config+user_role tables to ↵Brenda Wallace
both upgrade scripts
2009-08-26Save the mimetype for oEmbed linked urlCraig Andrews
2009-08-21update database to allow >140c in group descriptionsEvan Prodromou
2009-08-21Allow unlimited-size bios in profilesEvan Prodromou
2009-08-21allow unlimited text in messages in DBEvan Prodromou
2009-08-21update database to allow large postsEvan Prodromou
2009-08-04start upgrade script for 0.9.xEvan Prodromou