summaryrefslogtreecommitdiff
path: root/db
AgeCommit message (Collapse)Author
2010-10-25Merge commit 'refs/merge-requests/2223' of ↵Zach Copley
git://gitorious.org/statusnet/mainline into integration
2010-10-25Updated mustard description and linkMichele macno Azzolari
2010-10-20Use a new table (oauth_token_association) to associate authorizedZach Copley
request tokins with OAuth client applications and profiles.
2010-10-20Revert DB change for OAuth. Change compound key for oauth_application_userZach Copley
back to (profile_id, application_id). I think we can get away without a DB change by only issuing one anonymous access token per user.
2010-10-19Add support for an anonymous OAuth consumer. Note: this requires aZach Copley
small DB tweak. Oauth_application_user needs to have the primary compound key: (profile_id, application_id, token). http://status.net/open-source/issues/2761 This should also make it possible to have multiple access tokens per application. http://status.net/open-source/issues/2788
2010-09-16Ticket #2725 - add StatusNet Mobile & platform variants to default notice ↵Brion Vibber
sources lists. To add just these to an existing table: INSERT INTO notice_source (code, name, url, created) VALUES ('StatusNet Mobile', 'StatusNet Mobile', 'http://status.net/mobile', now()), ('StatusNet iPhone', 'iPhone', 'http://status.net/iphone', now()), ('StatusNet Android', 'Android', 'http://status.net/android', now()), ('StatusNet Blackberry', 'Blackberry', 'http://status.net/blackberry', now());
2010-08-16Merge remote branch 'shiny/0.9.x' into 0.9.xBrenda Wallace
2010-08-16Merge commit 'origin/0.9.x' into 0.9.xBrenda Wallace
2010-08-16removed the notice.location column from postgres def -- snuck in on a git ↵Brenda Wallace
commit by Patrick G
2010-07-28SQL script to update status_network tableJames Walker
2010-07-28leaving tags column in (for now)James Walker
2010-07-20normalizing tags for status_networkJames Walker
2010-06-28Merge branch 'master' into 0.9.xBrion Vibber
2010-06-28Add notice source for StatusNet DesktopZach Copley
2010-06-11Merge branch 'testing' of gitorious.org:statusnet/mainline into 0.9.xBrion Vibber
2010-06-07Merge branch 'testing' of gitorious.org:statusnet/mainline into 0.9.xBrion Vibber
Conflicts: plugins/OpenID/openid.php
2010-06-04Add gNewBook to notice sourcesZach Copley
2010-05-31Added DarterosStatus to notice sourcesZach Copley
2010-05-27added the inbox table to postgres upgrade scriptBrenda Wallace
2010-05-27added the inbox table to postgres upgrade scriptBrenda Wallace
2010-05-27added user_location_prefs to upgrade scriptBrenda Wallace
2010-05-27added user_location_prefs to upgrade scriptBrenda Wallace
2010-05-25the sent column wasn't being populated, needed defaultBrenda Wallace
2010-05-22queue_item in _pg now matches mysqlBrenda Wallace
2010-05-22migration of data in queue_item to new tableBrenda Wallace
2010-05-22fixed up comment syntaxBrenda Wallace
2010-05-22Merge commit 'mainline/0.9.x' into 0.9.xBrenda Wallace
2010-05-22added verifier and verified_callback to postgres schema and update scriptBrenda Wallace
2010-05-21Add TweetDeck to notice sourcesZach Copley
2010-05-21Add TweetDeck to notice sourcesZach Copley
2010-05-21added comsumer_secret to consumer table on postgresBrenda Wallace
2010-05-21add comsumer_secret column to consumerBrenda Wallace
2010-05-17updated database for postgresPatrick Georgi
2010-05-04Add Emacs Identica-mode to notice sourcesZach Copley
2010-05-04Add Emacs Identica-mode to notice sourcesZach Copley
2010-03-04Roll up some missing items from 08to09.sql; now hits all changed ↵Brion Vibber
tables/columns/keys in core. Added partial data conversions: user_groups -> local_user: ids, names filled out; mainpage, uri left null notice -> conversation: stub entry added to push the autoincrement past existing notice items
2010-03-04Create new field in consumer table in 08to09.sqlCiaran Gultnieks
2010-03-04Added oauth_appication tables to 08to09.sqlBrion Vibber
Conflicts: db/08to09.sql
2010-03-01Add index on group_index.notice_id, needed to pull list of target groups for ↵Brion Vibber
inbox delivery. Index was present on live identi.ca database but missing from master definitions: group_inbox_notice_id_idx
2010-03-01Add index on post_id for file_to_post, needed for efficient lookups of ↵Brion Vibber
files/urls attached to a given post.
2010-02-25add beta5 to beta6 scriptEvan Prodromou
2010-02-25Not sure how this ended up in wrong-cased dir...Brion Vibber
2010-02-25Add 'mainpage' to User_groupEvan Prodromou
Add the mainpage attribute to user_group objects.
2010-02-24Make user_group able to handle remote groupsEvan Prodromou
We add a local_group table to store data about local groups. It has the unique key for nickname, so /group/<nickname> looks up here. Updated DB data object classes and data files.
2010-02-17- conversation.uri needs to be nullableZach Copley
- factory method for creating new local conversations
2010-02-16New Conversation DO to handle remote notices as conversation rootsZach Copley
2010-02-05OAuth app name should not be nullZach Copley
2010-02-02Better token revocationZach Copley
2010-02-02OAuth app names should be unique.Zach Copley
2010-01-27fix update script -- read the diff wrong and put a couple fields on wrong ↵Brion Vibber
table (whoops)