summaryrefslogtreecommitdiff
path: root/db/laconica.sql
AgeCommit message (Collapse)Author
2009-03-30trac#776 changed db collations from utf8_bin to utf8_general_ci for case ↵Robin Millette
insensitive search
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-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-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
2008-07-18Patch for PITS 00032, 00033, 00034matthew.gregg
darcs-hash:20080719003417-982e4-7004f8a4dfb447f941457c30b0b2289eee5582e6.gz
2008-07-20First cut at hastags support.Mike Cochrane
darcs-hash:20080720055702-533db-193ed842b0d0a952bef71a3c5287213ada0ef15c.gz
2008-07-22add notice sources (currently unused)Evan Prodromou
darcs-hash:20080722164639-84dde-19c6300516443862da016120cf9eed40e5972b6d.gz
2008-07-22mark notices as localEvan Prodromou
darcs-hash:20080722141614-84dde-b80c6945fdb90a5f67acaba65a1e4c2b306b1f8e.gz
2008-07-21add flag for sms repliesEvan Prodromou
darcs-hash:20080721040551-84dde-f6c76d806969ccaa772da31235baaf7d9b065c15.gz
2008-07-20add sms email address to userEvan Prodromou
darcs-hash:20080721035919-84dde-e06f9094902522d2cd0ad71d65d565293f19db4a.gz
2008-07-20add autosubscribe flag to usersEvan Prodromou
darcs-hash:20080720200530-84dde-dade3117bdf510c1880d35f27bd9352995725175.gz
2008-07-19email settings for post by emailEvan Prodromou
darcs-hash:20080719202625-84dde-52b3d6710302f55e35ef57ea0aa4aff07cbeafaa.gz
2008-07-19add a transport flag to queue itemsEvan Prodromou
darcs-hash:20080719140906-84dde-9fcac26ee544ad53091808256f70b1745ac27a70.gz
2008-07-17mailer daemon startEvan Prodromou
darcs-hash:20080717132533-84dde-4ada5d4a103d92b9767726e723b26246205b9cbd.gz
2008-07-15unique key on a boolean value is not scalableEvan Prodromou
darcs-hash:20080715221946-84dde-cd843d283da019b102073bc64732f4abb89a6456.gz