summaryrefslogtreecommitdiff
path: root/db/laconica.sql
AgeCommit message (Collapse)Author
2009-05-27Upgraded foreign_id column to handle new 64-bit Facebook user IDs.Zach Copley
See: http://developers.facebook.com/news.php?blog=1&story=226
2009-05-22reformat laconica.sqlEvan Prodromou
2009-05-15Added sql files to handle attachments (not yet tested) Hoping someone will ↵Robin Millette
improve the postgres version.
2009-04-28Added dirty dates to Foreign_linkZach Copley
2009-04-19Merge branch '0.7.x' into 0.8.xSarven Capadisli
2009-04-18add reply_to index to noticeEvan Prodromou
2009-04-02Merge branch '0.7.x' into 0.8.xSarven Capadisli
2009-03-30trac#776 changed db collations from utf8_bin to utf8_general_ci for case ↵Robin Millette
insensitive search
2009-03-12Merge branch '0.7.x' into 0.8.xEvan Prodromou
Conflicts: classes/Notice.php lib/action.php lib/router.php lib/twitter.php
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-02-28Merge branch '0.7.x' into 0.8.xEvan Prodromou
2009-02-28don't use semicolons in commentsEvan Prodromou
2009-02-26Merge branch '0.7.x' into 0.8.xEvan Prodromou
2009-02-26add conversation id to noticeEvan 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-09add some indices for performanceEvan Prodromou
2009-01-13SQL setup for groups.Evan Prodromou
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-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-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
2008-08-25added a created timestamp to invitationsEvan Prodromou
darcs-hash:20080826023116-84dde-7d80c624b2dcfa637f58509c1d5ff7eca371512c.gz
2008-08-23data classes for invitationsEvan Prodromou
darcs-hash:20080823191015-84dde-05263d6e9a2535c726b98aacc5f3269f66fe22bd.gz
2008-09-15only use MyISAM for tables with fulltext indicesEvan Prodromou
darcs-hash:20080915053955-84dde-0bcb883b0075cfb3835aae5043c827aaa0b7099e.gz
2008-08-27change queue_item to use a compound primary keyEvan Prodromou
Breaking up to use multiple queue handlers means we need multiple queue items for the same notice. So, change the queue_item table to have a compound pkey, (notice_id,transport). darcs-hash:20080827211239-84dde-db118799bfd43be62fb02380829c64813c9334f8.gz
2008-08-19add database tables for foreign servicesEvan Prodromou
darcs-hash:20080819221214-84dde-15683b1e146b9e29064aa8ae04bc7daebfaf2e92.gz
2008-08-17trim whitespace in laconica.sqlEvan Prodromou
darcs-hash:20080817152133-84dde-36313e2aa0f37dd43ae8ed17c1194e4a2289a2eb.gz
2008-08-17restore fave table lost when doing utf8 upgradeEvan Prodromou
darcs-hash:20080817152108-84dde-9ca19fbe374ad021771f175f587f19902b3f927b.gz
2008-08-17Database uses UTF-8 by defaultEvan Prodromou
darcs-hash:20080817151728-84dde-6d5557db098a1273c0b9e3451b814e8d57759e57.gz
2008-08-13first step towards adding favorites to the systemEvan Prodromou
darcs-hash:20080813142637-84dde-9530d153eceb6bbedbb692755aa5c96d65d8e071.gz
2008-07-31extend length of source for noticesEvan Prodromou
darcs-hash:20080731152731-84dde-dc6bf652c38ae9a52950e65d7cb310f870a70640.gz
2008-07-22Index on the correct columnMike Cochrane
darcs-hash:20080722205335-533db-d7b4a6c727305cffedc443b5bfa15779a685d03a.gz
2008-07-21Resolve conflicts after pull from evanmikec
darcs-hash:20080721135637-edabd-cca33bc0a0936423b9fd2ffdf9413236123d680e.gz
2008-07-21Publish MicroIDs for email and mpp on profile and notice pages.mikec
darcs-hash:20080721120036-edabd-838335c0e23c80a657d353955b25b52a9a8624b2.gz
2008-07-20Explicitly set the character set on the handle column to fix ↵Mike Cochrane
http://laconi.ca/PITS/00262 darcs-hash:20080720113458-533db-0b0c2736c464195476562fb52f5a5bb1591d3d82.gz