summaryrefslogtreecommitdiff
path: root/db/statusnet.sql
AgeCommit message (Collapse)Author
2010-04-26Give users more control over URL shorteningEvan Prodromou
Users and administrators can set how long an URL can be before it's shortened, and how long a notice can be before all its URLs are shortened. They can also turn off shortening altogether. Squashed commit of the following: commit d136b390115829c4391b3666bb1967f190a0de35 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:39:00 2010 -0400 use site and user settings to determine when to shorten URLs commit 1e1c851ff3cb2da5e0dc3a0b06239a9d9c618488 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:38:40 2010 -0400 add a method to force shortening URLs commit 4d29ca0b91201f6df42940297ed5b64b070efe49 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:37:41 2010 -0400 static method for getting best URL shortening service commit a9c6a3bace0af44bcf38d1c790425a7be9c72147 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:37:11 2010 -0400 allow 0 in numeric entries in othersettings commit 767ff2f7ecfd7e76e8418fc79d45e61898f09382 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:36:46 2010 -0400 allow 0 or blank string in inputs commit 1e21af42a685f600f4a53f49a194013e78b12f20 Author: Evan Prodromou <evan@status.net> Date: Mon Apr 26 02:01:11 2010 -0400 add more URL-shortening options to othersettings commit 869a6be0f5779aff69018d02f9ac0273946040d9 Author: Evan Prodromou <evan@status.net> Date: Sat Apr 24 14:22:51 2010 -0400 move url shortener superclass to lib from plugin commit 9c0c9863d532942b99184f14e923fc3c050f8177 Author: Evan Prodromou <evan@status.net> Date: Sat Apr 24 14:20:28 2010 -0400 documentation and whitespace on UrlShortenerPlugin commit 7a1dd5798f0fcf2c03d1257a18ddcb9008879de0 Author: Evan Prodromou <evan@status.net> Date: Sat Apr 24 14:05:46 2010 -0400 add defaults for URL shortening commit d259c37ad231ca0010c60e5cfd397bb1732874a4 Author: Evan Prodromou <evan@status.net> Date: Sat Apr 24 13:40:10 2010 -0400 Add User_urlshortener_prefs Add a table for URL shortener prefs, a corresponding class, and the correct mumbo-jumbo in statusnet.ini to make everything work.
2010-03-24Use InnoDB and UTF-8 options when creating user_im_prefs table, to match othersBrion Vibber
2010-03-08Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: classes/statusnet.ini db/statusnet.sql lib/jabber.php lib/xmppmanager.php
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 '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-24Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: EVENTS.txt db/statusnet.sql lib/queuemanager.php
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-16Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: lib/queuemanager.php
2010-02-05OAuth app name should not be nullZach Copley
2010-02-05OAuth app name should not be nullZach Copley
2010-02-02Merge branch '0.9.x' into 1.0.xCraig Andrews
Conflicts: EVENTS.txt lib/imqueuehandler.php lib/jabber.php lib/util.php plugins/Xmpp/Sharing_XMPP.php
2010-02-02Better token revocationZach Copley
2010-02-02OAuth app names should be unique.Zach Copley
2010-02-02Better token revocationZach Copley
2010-02-01OAuth app names should be unique.Zach Copley
2010-01-27Create IM plugin, Pluginize XMPP, Create AIM pluginCraig Andrews
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.
2010-01-22Merge branch 'testing' into 0.9.xEvan Prodromou
2010-01-21XMPP queued output & initial retooling of DB queue manager to support ↵Brion Vibber
non-Notice objects. Queue handlers for XMPP individual & firehose output now send their XML stanzas to another output queue instead of connecting directly to the chat server. This lets us have as many general processing threads as we need, while all actual XMPP input and output go through a single daemon with a single connection open. This avoids problems with multiple connected resources: * multiple windows shown in some chat clients (psi, gajim, kopete) * extra load on server * incoming message delivery forwarding issues Database changes: * queue_item drops 'notice_id' in favor of a 'frame' blob. This is based on Craig Andrews' work branch to generalize queues to take any object, but conservatively leaving out the serialization for now. Table updater (preserves any existing queued items) in db/rc3to09.sql Code changes to watch out for: * Queue handlers should now define a handle() method instead of handle_notice() * QueueDaemon and XmppDaemon now share common i/o (IoMaster) and respawning thread management (RespawningDaemon) infrastructure. * The polling XmppConfirmManager has been dropped, as the message is queued directly when saving IM settings. * Enable $config['queue']['debug_memory'] to output current memory usage at each run through the event loop to watch for memory leaks To do: * Adapt XMPP i/o to component connection mode for multi-site support. * XMPP input can also be broken out to a queue, which would allow the actual notice save etc to be handled by general queue threads. * Make sure there are no problems with simply pushing serialized Notice objects to queues. * Find a way to improve interactive performance of the database-backed queue handler; polling is pretty painful to XMPP. * Possibly redo the way QueueHandlers are injected into a QueueManager. The grouping used to split out the XMPP output queue is a bit awkward.
2010-01-14Add verifier and verified callback to token for OAuth 1.0aZach Copley
2010-01-14Remove verifier from Oauth_application_user (not needed there)Zach Copley
2010-01-14Callback URL can be nullZach Copley
2010-01-14Decided we didn't need to keep the token secret in theZach Copley
Oauth_application_user record
2010-01-14Associate request tokens with OAuth apps and app usersZach Copley
2010-01-14Workflow for registering new OAuth apps pretty much done.Zach Copley
2010-01-14Changed the OAuth app tables to refer to profiles instead of users.Zach Copley
Added an owner column to oauth_application.
2010-01-14Add new OAuth application tables and DataObjects. Also add a newZach Copley
column for consumer secret to consumer table.
2010-01-09add an inbox blob tableEvan Prodromou
2009-12-28add table user_location_prefsEvan Prodromou
2009-12-11add repeat_of column to notice tableEvan Prodromou
2009-12-10remove forward table from db scriptsEvan Prodromou
2009-12-08add forward tableEvan Prodromou
2009-12-05Added 'login' command that gives you a link that can be used to login to the ↵Craig Andrews
website
2009-11-20Revert "Added 'login' command that gives you a link that can be used to ↵Evan Prodromou
login to the website" This reverts commit b9d40f723bce8e01ddcbbb989bd7035b92cd9af8. Conflicts: actions/login.php classes/statusnet.ini db/08to09.sql db/08to09_pg.sql db/statusnet_pg.sql lib/command.php lib/commandinterpreter.php
2009-11-16Rename user_role to profile_roleEvan Prodromou
Renamed the user_role table to profile_role. Remote users can have a role on the site; that 'role' may be negative (silenced or sandboxed).
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-10-21Revert "lat,lon -> lat,long"Evan Prodromou
This reverts commit 61d948cffee0aff4fd7853421ec0849458ea34c9.
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-29 01:55:39 +0000