summaryrefslogtreecommitdiff
path: root/db
AgeCommit message (Collapse)Author
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 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)
2010-01-27Rename rc3to09.sql to rc3torc4.sql to avoid confusion if we add a ↵Brion Vibber
last-minute change after this!
2010-01-27Add new oauth tables and modifications to 'consumer' table for rc4Brion Vibber
2010-01-26Site metadata tags in status_network: single 'tags' field, pipe-separated.Brion Vibber
$sn->tags() returns tag list as array; $sn->hasTag('blah') to check for a particular tag only Could be used to control things in config file: $sn = Status_network::setupSite($_server, $_path, $_wildcard); if (!$sn) { die("No such site"); } if ($sn->hasTag('individual')) { /* blah */ } Note memcached keys are unchanged; if tags are changed from an external tool clear: statusnet:<dbname>:status_network:<key>:<val> for <key>s 'nickname', 'hostname', and 'pathname'
2010-01-24Add verifier and verified callback to token for OAuth 1.0aZach Copley
2010-01-24Remove verifier from Oauth_application_user (not needed there)Zach Copley
2010-01-24Callback URL can be nullZach Copley
2010-01-24Decided we didn't need to keep the token secret in theZach Copley
Oauth_application_user record
2010-01-24Associate request tokens with OAuth apps and app usersZach Copley
2010-01-24Workflow for registering new OAuth apps pretty much done.Zach Copley
2010-01-24Changed the OAuth app tables to refer to profiles instead of users.Zach Copley
Added an owner column to oauth_application.
2010-01-24Add new OAuth application tables and DataObjects. Also add a newZach Copley
column for consumer secret to consumer table.