summaryrefslogtreecommitdiff
path: root/db
AgeCommit message (Collapse)Author
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-21add Cincinnati Bell WirelessEvan Prodromou
darcs-hash:20080821125306-84dde-58acb80666ed3a2b1ef4db3290aa3c5f0de12a9a.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-29Orange (UK) for carriersEvan Prodromou
darcs-hash:20080729182534-84dde-cd91e6914464a577208d569c2ff3f730f2deaf4a.gz
2008-07-22Index on the correct columnMike Cochrane
darcs-hash:20080722205335-533db-d7b4a6c727305cffedc443b5bfa15779a685d03a.gz
2008-07-22Add vodafone New ZealandMike Cochrane
darcs-hash:20080722082526-533db-7405614141475c597847d2eab6b6b96231254ed4.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-28four key SMS providers had ' (SMS)' appended to their patternsEvan Prodromou
darcs-hash:20080729032845-84dde-9582cfd621142d99cddc8b91d2b619e984e263a9.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-20first pass at list of SMS carriers for SMS-to-email gatewayEvan Prodromou
darcs-hash:20080720053458-84dde-1b1d4db642ef350d1f2c94f35ce7c685378bd9f5.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
2008-05-27server-side storage modelEvan Prodromou
First pass at a server-side storage model. New tables for consumers, tokens, and nonces, with associated classes. An OAuthDataStore class interfaces with the OAuth.php library to enable server logic. Some additional work to get pretty-OK random number generation into the utilities library. Use /dev/urandom if available; else use mt_rand(). darcs-hash:20080527200721-84dde-308c047af2ebc2c4d753c1e1e24af20fef862a7e.gz
2008-05-27client side of distributed subscription almost completeEvan Prodromou
darcs-hash:20080527114219-84dde-784ddf4d4650c17bc7a1e3e01219c6948dfc9b3d.gz
2008-05-22tags and XRDSEvan Prodromou
Starting the process of remote subscriptions. First, add the capacity to mint tags. May in the future want to allow some kind of UUID or URL for unique URIs. New config options for tag authority and date, and a function for minting tags. Store URIs in the DB. If the admin changes his/her tag config, this shouldn't change the URIs in the DB. Unless they really want to make that happen. Generate an XRDS document with the appropriate URLs for microblogging. Also, redefined some stuff in openmicroblogging.txt. And moved the file. darcs-hash:20080522183421-84dde-fe46f32e4050f2c4b6c850334103007ed7feabf7.gz