summaryrefslogtreecommitdiff
path: root/db/laconica.sql
AgeCommit message (Collapse)Author
2009-08-11Revert "changed file.url column type from varcahr(255) to varchar(2047)"Brenda Wallace
This reverts commit c1b19929f6234c4b9e30e16bae419c89c38c1169.
2009-08-10changed file.url column type from varcahr(255) to varchar(2047)Brenda Wallace
2009-06-27session storageEvan Prodromou
2009-06-24change foreign_user.id to bigint (for Twitter, Facebook, etc.)Evan Prodromou
2009-06-22Database changes for file tablesEvan Prodromou
Some minor database changes for file tables. Namely: * Added a timestamp to all tables * Added a filename column for local files * Change some tables that had unnecessary auto-increment primary keys when they had another unique column that should act as the primary key * Change engine from MyISAM to InnoDB for a couple of files. Also, rebuilt the DB_DataObject files for all these tables.
2009-06-17Add design_id to User_groupZach Copley
2009-06-17Update background image settings to use bitflagsZach Copley
2009-06-16Added background image tile flag to DesignZach Copley
2009-06-15Merge branch '0.8.x' into userdesignZach Copley
* 0.8.x: (32 commits) updates to Status_network makeadmin action make admins of groups show aliases when showing a group Link and distribute notices tagged for a group alias Code for adding and saving group aliases Styles for group block add correct li for css magic for block stuff typo in profileminilist class return count from show try to get the right class for profileminilist fix perms for classes/statusnet.ini fixup perms for classes Added Group_alias class add a table for group aliases Cross-browser notice_attach Allow users to be unblocked from a group Some UI improvements for blocking and unblocking The rest of the things necessary to make group block work Make group block work ... Conflicts: db/laconica.sql lib/common.php
2009-06-14add a table for group aliasesEvan Prodromou
2009-06-14Merge branch '0.8.x' into groupblockEvan Prodromou
2009-06-14Commented all .sql fields for file/url related tables.Robin Millette
2009-06-14added group_block table to databaseEvan Prodromou
2009-06-09Merge branch '0.8.x' into userdesignEvan Prodromou
Conflicts: actions/designsettings.php
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-23move design items before timestampsEvan Prodromou
2009-05-22schema changes for user support of designsEvan Prodromou
2009-05-22add design table to DBEvan Prodromou
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