summaryrefslogtreecommitdiff
path: root/db/laconica.sql
AgeCommit message (Collapse)Author
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
2008-07-15move email settings to its own tabEvan Prodromou
darcs-hash:20080715221826-84dde-8a3692f95199818c11dbb0be159d07f1ab10cf6a.gz
2008-07-15replies from people you're not subscribed to over JabberEvan Prodromou
darcs-hash:20080715195513-84dde-454419c971015be385d9c4c35f7acbee419031f9.gz
2008-07-09Merge conflicts and kill a whole lot of trailing whitespace on lines.Mike Cochrane
darcs-hash:20080709224630-533db-b5399baef280133858dac9b89c2cd6a2aba9f861.gz
2008-07-09changes to databaseEvan Prodromou
darcs-hash:20080709193810-84dde-0ee9bd7b4783f5a66c2ffd6526728e4e267fb024.gz
2008-07-06some twiddles in the db for replies, plus the classEvan Prodromou
darcs-hash:20080706223839-84dde-269eba758843e45265a08379356cdfd84701e2cd.gz
2008-06-22First pass at replies support http://laconi.ca/PITS/00080matthew.gregg
Doesn't handle a reply to a user that has never updated. darcs-hash:20080623030837-982e4-532ccd8899fd8be00575f8840da0defb44cd56f8.gz
2008-07-05add queueing variables to confirm_addressEvan Prodromou
darcs-hash:20080706031234-84dde-42e06c969ef6e8a63c527c197d7f074f7346d223.gz
2008-07-04add a queued notice itemEvan Prodromou
darcs-hash:20080704040746-84dde-36803f820ea7c238613cf5728c59a18ff1eb442d.gz
2008-06-26don't bother with subscription hoohaw; just ask the user to do itEvan Prodromou
darcs-hash:20080626203103-34904-19ef53bc734622a310a705608f3e227e2f387904.gz
2008-06-23add table for remember me codesEvan Prodromou
darcs-hash:20080624020205-34904-be536546e7058ed77a6d45be4f91ffe201b3448e.gz
2008-06-22add flags to db for jabber and sms notificationEvan Prodromou
darcs-hash:20080623023859-84dde-1c72985ee0a840e59d1fac88f27f929f3c637b65.gz
2008-06-22auto-increment primary key for SMS carrierEvan Prodromou
darcs-hash:20080622164013-34904-4119be65edb5fc09dcbe11edf17c3401f1d19a33.gz
2008-06-22correctly use Confirm_addressEvan Prodromou
darcs-hash:20080622161607-34904-d8e042b80fe6acd3cb6ad763216a0b1817752cac.gz
2008-06-22qEvan Prodromou
darcs-hash:20080622154836-34904-0673a1ee33f35cdfd906251e50dadcbe8c4c90e7.gz
2008-06-20confirm email addressesEvan Prodromou
darcs-hash:20080620051536-5ed1f-231e427832dd20c861eb7a6dc1171315e90f455b.gz
2008-06-20add confirmemail tableEvan Prodromou
darcs-hash:20080620041012-5ed1f-20a7d4df375250f5c4eff90cdab80b22348b1088.gz
2008-06-18user_id in user_openid should not be uniqueEvan Prodromou
darcs-hash:20080618070430-84dde-403d695209ab88f2d0c4e54da333698c6fe5883a.gz
2008-06-18finish openidEvan Prodromou
Added some code to make finishing the OpenID login work. Changed the OID storage so that there's a "canonical" URL and a display URL. This is because of i-names, which is annoying. If the login succeeds, we try to find a local user associated with the canonical URL. If they don't exist, we let the user either create a new account, or login to an existing account and connect to it. A totally unrelated change is that the DB engine now uses InnoDB. darcs-hash:20080618052638-84dde-909e51dbd5b9eadadf18cd010868baa18ea2349a.gz
2008-06-17start openid rp integrationEvan Prodromou
darcs-hash:20080617133501-84dde-adec156ac58b84cce41ae0e9bde58cf7637e6c42.gz
2008-06-04move stoica schema to laconicaEvan Prodromou
darcs-hash:20080605024807-84dde-b6b112fc71f6337bf2d3605944191454aaeb28e2.gz