summaryrefslogtreecommitdiff
path: root/db
AgeCommit message (Collapse)Author
2009-11-12Fix index on notice for efficient querying of notice(s) by order for a profile.Brion Vibber
Should resolve performance problem with Profile::getCurrentNotice()
2009-11-10Performance fix for subscription/subscriber lists based on feedback from ops.Brion Vibber
Extended subscription table indexes for subscriber and subscribed to include the created field, which is used to sort for display. This lets us skip a filesort and do the join much more efficiently. Alter table from 08to09.sql needs to be run manually (though no ill effects if you forget other than not getting the perf improvement).
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-11-02Merge branch '0.8.x' into 0.9.xEvan Prodromou
Conflicts: README
2009-10-31Add SocialOomphEvan Prodromou
2009-10-31add and update choqokEvan Prodromou
2009-10-21Revert "lat,lon -> lat,long"Evan Prodromou
This reverts commit 61d948cffee0aff4fd7853421ec0849458ea34c9.
2009-10-21lat,lon -> lat,longEvan Prodromou
2009-10-21add a couple of location namespacesEvan Prodromou
2009-10-21add location-related tables and columnsEvan Prodromou
2009-10-19Revert "Revert "fixed up some invalid comment syntax - this is ANSI SQL""Evan Prodromou
This reverts commit c0eca0e59b1b9bb74d4457348d1e310e18cc082f.
2009-10-19Revert "Revert "upgrade script for postgres""Evan Prodromou
This reverts commit d72748eb8e71f81e7cddca610ec98a8910dd347f. Conflicts: db/08to09_pg.sql
2009-10-19Revert "upgrade script for postgres"Evan Prodromou
This reverts commit d46f2ee350b9bf2c70371f7bcd2f2793e7ed8110.
2009-10-19Revert "added missing parts to postgres update, and the config+user_role ↵Evan Prodromou
tables to both upgrade scripts" This reverts commit e9edb803bc66028204defcfa659cccbf23da97c6.
2009-10-19Revert "fixed up some invalid comment syntax - this is ANSI SQL"Evan Prodromou
This reverts commit 6704ddddf227865de43c1fdd846b68f76f723fe6.
2009-10-19Merge branch 'testing' of git@gitorious.org:statusnet/mainline into testingEvan Prodromou
2009-10-01change DB so OpenIDPlugin manages OpenID tablesEvan Prodromou
2009-09-23Merge branch '0.8.x' into 0.9.xEvan Prodromou
Conflicts: actions/requesttoken.php classes/File.php install.php lib/noticeform.php
2009-09-15Add Jiminy to notice sourcesZach Copley
2009-09-15Add Jiminy to notice sourcesZach Copley
2009-09-13Add ChinaMobile as an email to SMS carrierCraig Andrews
2009-08-31fixed up some invalid comment syntax - this is ANSI SQLBrenda Wallace
2009-08-31added missing parts to postgres update, and the config+user_role tables to ↵Brenda Wallace
both upgrade scripts Conflicts: db/08to09.sql
2009-08-31upgrade script for postgresBrenda Wallace
2009-08-31fixed up some invalid comment syntax - this is ANSI SQLBrenda Wallace
2009-08-29added missing parts to postgres update, and the config+user_role tables to ↵Brenda Wallace
both upgrade scripts
2009-08-28added the user_role tableBrenda Wallace
2009-08-28added config tableBrenda Wallace
2009-08-27Merge branch '0.9.x' of git@gitorious.org:laconica/mainline into 0.9.xEvan Prodromou
Conflicts: classes/laconica.ini
2009-08-27add table for user rolesEvan Prodromou
2009-08-27Merge branch '0.8.x' into 0.9.xEvan Prodromou
Conflicts: EVENTS.txt actions/finishremotesubscribe.php actions/postnotice.php actions/public.php actions/remotesubscribe.php actions/showstream.php actions/updateprofile.php actions/userauthorization.php classes/laconica.ini lib/common.php lib/oauthstore.php lib/omb.php
2009-08-26Save the mimetype for oEmbed linked urlCraig Andrews
2009-08-26accidentally changed the URL for Laconica ToolsEvan Prodromou
2009-08-25global search and replace for laconica -> statusnetEvan Prodromou
2009-08-25Rename Laconica to StatusNetEvan Prodromou
2009-08-25Take token field out of foreign_linkZach Copley
This undoes patch a49272d448d75a6ab74515352345d8baacb96f1f
2009-08-24Merge branch '0.8.x' into testingEvan Prodromou
Conflicts: actions/twitterauthorization.php lib/oauthclient.php lib/twitter.php lib/twitterapi.php lib/twitteroauthclient.php scripts/twitterstatusfetcher.php
2009-08-24Add new Foreign_link col to store OAuth access tokenZach Copley
2009-08-21Merge branch 'dbconfig' into 0.9.xEvan Prodromou
Conflicts: lib/common.php
2009-08-21Merge branch '0.8.x' into 0.9.xEvan Prodromou
Conflicts: actions/updateprofile.php actions/userauthorization.php classes/User_group.php index.php install.php lib/accountsettingsaction.php lib/logingroupnav.php
2009-08-21Add table for configuration settingsEvan Prodromou
Add a table for configuration settings.
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-11Revert "changed file.url column type from varcahr(255) to varchar(2047)"Brenda Wallace
This reverts commit c1b19929f6234c4b9e30e16bae419c89c38c1169.
2009-08-11Revert "change file.url to from a varchar(255) to varchar(2047)"Brenda Wallace
This reverts commit 002cc755b2a521486b0216e2d6f8a3952bda0bae. mysql doesn't allow varchar > 255 chars reverting until have a working solution
2009-08-11change file.url to from a varchar(255) to varchar(2047)Brenda Wallace
because urls get translated from tinyurl.com etc into their originals before saving and urls can be that long
2009-08-11upgrade script for postgresBrenda Wallace