summaryrefslogtreecommitdiff
path: root/db
AgeCommit message (Collapse)Author
2009-03-08PostgreSQL - use the specific sequence names required by DB_DataObject, ↵CiaranG
otherwise rebuilding can't work
2009-03-07PostgreSQL - propogated nonce table fix from MySQL version - see bug #1251 ↵CiaranG
or 1179ecd13d68e76d74ad94e2d3ca22d9681eeffe
2009-03-07Fix nonce usage in OAuth storeEvan Prodromou
The OAuth store was failing on getting a request token, because the token value was forced to be non-null in the DB. Let this value be null, and use the correct primary key (consumer, timestamp, nonce). Drop the reference to token table, and don't ever use it.
2009-03-05Merge branch '0.7.x' of git@gitorious.org:laconica/dev into 0.7.xCiaranG
2009-03-05PostgreSQL - the ts field in the OAuth nonce table needed to be an integer. ↵CiaranG
(fix submitted by oxygene)
2009-03-04Merge branch '0.7.x' of git@gitorious.org:laconica/dev into 0.7.xEvan Prodromou
2009-03-04PostgreSQL - added defaults for 'created' fields, so they work the same as ↵CiaranG
the MySQL version, and made sure all 'modified' fields are not null
2009-03-04all inserts in one statement for foreign servicesEvan Prodromou
2009-03-04add notice source to default installEvan Prodromou
2009-03-03PostgreSQL - added new emailnotifyattn field to user table, to match MySQL ↵CiaranG
version
2009-02-28don't use semicolons in commentsEvan Prodromou
2009-02-16add email notify flag for @-repliesEvan Prodromou
2009-02-12Make ID of SMS Carrier not autoincrementEvan Prodromou
Since we're doing fixed IDs for SMS Carrier, we change the definition so it's not auto increment.
2009-02-12Add fixed IDs to SMS carrier listEvan Prodromou
Changed the SMS carrier list to use a fixed ID number for each carrier distributed with the software. We claim IDs > 100000; admins can use IDs < 100000 for local values. I'd be pretty surprised if there were more than 100K wireless carriers in the world, but hey.
2009-02-12move carrier.sql to sms_carrier.sqlEvan Prodromou
2009-02-09add some indices for performanceEvan Prodromou
2009-02-05PostgreSQL - database creation script updated to cover 0.7.x featuresCiaranG
2009-01-30PostgreSQL - remaining changes to fix db create script up to laconica 0.6.4 ↵Ciaran Gultnieks
level
2009-01-23Merge branch 'master' of /var/www/mublogEvan Prodromou
Conflicts: actions/api.php actions/deletenotice.php actions/recoverpassword.php actions/remotesubscribe.php actions/tag.php actions/tagrss.php actions/twitapiaccount.php actions/twitapiusers.php classes/Notice.php classes/User.php lib/common.php lib/language.php lib/subs.php lib/twitterapi.php lib/util.php scripts/inbox_users.php scripts/update_translations.php Merged development trunk into laconica head. woohoo!
2009-01-14PostgreSQL - added the rest of the recently added tables for blocking, ↵CiaranG
notice inboxes, etc. Needs testing
2009-01-14Some more PostgreSQL script updates - some recently added fields were missingCiaranG
2009-01-14Added the inboxed field to the user table for PostgreSQL - resolves bug #892CiaranG
2009-01-13SQL setup for groups.Evan Prodromou
2008-12-05trac750 - Exoskeleton of a nascent Facebook appZach Copley
darcs-hash:20081206030132-7b5ce-96c38ab67edd3d58f8722ef25852a6143f05a86b.gz
2008-12-08database changes to say whether to deliver messages for a subscriptionEvan Prodromou
darcs-hash:20081209033637-5ed1f-df5ef40e57cc0e9485e34e2f5e46249dcb0d9130.gz
2008-12-03whitespace in laconica.sqlEvan Prodromou
darcs-hash:20081203222819-5ed1f-49d1657730072be304ea6455ac96637ab47191f3.gz
2008-12-03add profile block data objectEvan Prodromou
darcs-hash:20081203222619-5ed1f-b313092893c67a3ec1dc92a79aa7fed4ab583729.gz
2008-11-20add profile tags to DBEvan Prodromou
darcs-hash:20081120205506-84dde-e9aa0a70d3529f91909dbe29f03a46b40ef18fff.gz
2008-11-15Nudge featurecsarven
darcs-hash:20081116022735-eefa4-366f6deb85942f859ebd532e477b57737bcafbf8.gz
2008-11-13add inboxed and regenerate data objectsEvan Prodromou
darcs-hash:20081113210209-84dde-56052bac5ce490d54f3220baaa13f5bfc0e7618d.gz
2008-11-13trac31 pg support, fixing 2tu typo, set ur1.ca as default servicemillette
darcs-hash:20081113152718-099f7-42b60d02395f016c54c5f3c301f9dbe987c1283f.gz
2008-11-06trac31 url_auto_shortening by sgmurphymillette
darcs-hash:20081106205926-099f7-6bcfd7969a159a12b1ba6a9ee254e44a07b94761.gz
2008-11-12created timestamp on notice_inboxEvan Prodromou
darcs-hash:20081112172517-5ed1f-4e8534d7898e2134edf4c0a28417b4a5274617d4.gz
2008-10-22notice inboxEvan Prodromou
darcs-hash:20081022203600-5ed1f-344e77e348655806a27db2de043b55ba67afc73a.gz
2008-10-22add an index to subscription tokenEvan Prodromou
darcs-hash:20081022192750-5ed1f-3265f9f4954cff431a0c276c16a98b9c22d8d40b.gz
2008-09-29PostgreSQL: Put a default on confirm_address.address_extra to mimic mysql's ↵CiaranG
behaviour when a not-null field is not set in a new record darcs-hash:20080929060227-f6e2c-5996ad74cb5c89052417e36634a22b6e219bd92d.gz
2008-09-24PostgreSQL: Corrections to the two new table definitionsCiaranG
darcs-hash:20080924113550-f6e2c-8791d68684424ef028049ee9ed95b3853dd8f770.gz
2008-09-23PostgreSQL: New tables for private messages and invitations (untested)CiaranG
darcs-hash:20080923214601-f6e2c-350de6e8df8bb6e9e5f3dbb1ea43360fc55ee847.gz
2008-09-23Twitter bridge - pref setting to turn off sending @-replies to TwitterZach Copley
darcs-hash:20080924023615-7b5ce-c747e8236b3967824ed93f18285e1b6e0b46c3f0.gz
2008-09-17newmessage and showmessageEvan Prodromou
darcs-hash:20080917174741-5ed1f-c090055487bab0df52d25ad6550d3850ef5f7661.gz
2008-09-14PostgreSQL: support for full text searching (notice and people)CiaranG
darcs-hash:20080914201744-f6e2c-71b2a3aec4c0b91557465323d79645e7eab2bfd1.gz
2008-09-10PostgreSQL - reply.modified needs a defaultCiaranG
darcs-hash:20080910073741-f6e2c-fe856e1acbc14f77e8ad6502cf5e16de768e0e5f.gz
2008-09-09Initial support for PostgreSQLCiaranG
darcs-hash:20080909072224-f6e2c-881bd2e7fb032f336fecae9ca5ce527dd821d3dc.gz
2008-08-26Twitter integration - decided to change Twitter to service ID #1Zach Copley
darcs-hash:20080827021635-7b5ce-9b96743999aa85a505aecd5f25867937f0c34434.gz
2008-08-21Twitter integration - SQL ref data for Twitterzach
darcs-hash:20080822034054-462f3-3211b5a9a412f9496d46a9fb64b26d62a3b28d1f.gz
2008-09-16Database and classes for direct messagesEvan Prodromou
darcs-hash:20080916185126-84dde-2983718fc2ab11874c839489290b8a827985274d.gz
2008-09-16change some more tables to InnoDBEvan Prodromou
darcs-hash:20080916174515-84dde-f0adac3444809b2f3bfc145eaf8e6f394124e9cc.gz
2008-09-08initial non-Ajax version of favoritesEvan Prodromou
darcs-hash:20080908181624-84dde-8200e1d91eb5f560ef0f296c9e1c56f93ef1b0c5.gz
2008-08-26add a foreign_link table with prefs for the linkEvan Prodromou
darcs-hash:20080827032423-84dde-90a4d5931c2292c9ec5febd0c90ed18f6ab93e90.gz
2008-08-25clean up some whitespace in DB scriptEvan Prodromou
darcs-hash:20080826024015-84dde-4258c99348f5d665d99a82cf50444fab9391336c.gz
generated by cgit v1.2.3-54-g00ecf (git 2.45.2) at 2024-11-05 14:35:48 +0000