aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
Commit message (Collapse)AuthorAgeFilesLines
* update oauth related tables to use bigint/int(10) for user_id column. this ↵Mario2018-05-201-4/+4
| | | | is to be more consistent with the rest of the tables and fixes issue #1180
* improve abconfig queriesMario Vavti2018-05-201-2/+1
|
* Active channels information is a bit imprecise. Provide a higher accuracy ↵zotlabs2018-04-161-0/+2
| | | | method. This will require a transition period
* OAuth2 integrationzotlabs2018-04-031-0/+52
|
* update mysql schemaMario Vavti2018-03-111-3/+0
|
* remove redundant commaMario Vavti2018-03-091-1/+1
|
* federated polls: GNU-Social requires us to preserve the original order of ↵zotlabs2018-03-071-1/+3
| | | | the poll answers for use in making a vote, unlike diaspora (which selects by guid) and activitypub (which selects by non-localisable text).
* federated polls: add poll_author which will be necessary for Diaspora federationzotlabs2018-03-061-0/+2
|
* missed one index in the last updateMario Vavti2018-02-281-0/+1
|
* another DB upgrade to address some long running maintenance queriesMario Vavti2018-02-261-2/+4
|
* provide DB compatibility for poll and voting implementations across several ↵zotlabs2018-02-221-0/+6
| | | | platforms
* more index finetuning to fix the expire queryMario Vavti2018-02-201-3/+3
|
* some more DB tuning.Mario Vavti2018-02-151-2/+4
|
* more db and queries finetuningMario Vavti2018-02-081-2/+2
|
* this will fix the cards query and keep the rest intactMario Vavti2018-02-041-2/+2
|
* superfluous ,Mario Vavti2018-02-041-1/+1
|
* remove indices from mysql schema fileMario Vavti2018-02-041-7/+0
|
* remove column item.diaspora_meta, action items 2 and 3 of hubzilla issue #828zotlabs2017-11-161-1/+0
|
* table structure for pseudo or proxy channels (pchan)zotlabs2017-10-191-0/+13
|
* db update to add index to item.resource_id we query this in wikis a lotMario Vavti2017-09-161-0/+1
|
* fix bogus semicolonWaitman Gobble2017-09-061-1/+1
| | | Line 655 should have comma instead of semicolon
* add combined index for item.uid and item.item_unseen. this speeds up ↵Mario Vavti2017-09-011-2/+3
| | | | notifications by a magnitude.
* db update to add index for item.obj_typegit-marijus2017-07-311-0/+1
|
* missing abook_{my,their}_perms in pg schema and missing keys in mysql schemaMario Vavti2017-07-051-0/+2
|
* cdav migration to corezotlabs2017-06-221-0/+171
|
* Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_mergezotlabs2017-06-111-3/+3
|\
| * some more innodb mysql scheme adjustmentsMario Vavti2017-06-101-15/+8
| |
| * convert schema_mysql engine to InnoDB and charset utf8mb4git-marijus2017-06-091-267/+267
| |
* | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_mergezotlabs2017-06-071-3/+3
|\|
| * Fixed TEXT fields with default values (fixes #803) in mysql creation script.Manuel Tancoigne2017-06-071-6/+6
| |
* | fix a merge mixup on install/schema_msyql.phpzotlabs2017-06-061-230/+230
| |
* | remove default for text/mediumtext sql fieldszotlabs2017-05-311-6/+6
| |
* | looks like a commit was lost someplace, but I'll re-do it later (convert sql ↵zotlabs2017-05-251-18/+18
| | | | | | | | schema files to default integers to int values); in any event change all the mysql strings that were 255 maxlength to 191 maxlength in case they get used as indexes down the line
* | put back obsolete permission fields in abook and channel schema files so we ↵zotlabs2017-05-251-0/+20
| | | | | | | | can restore the old data without choking when upgrading the table type
* | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_mergezotlabs2017-05-231-1/+1
|\|
| * schema fixeszotlabs2017-05-231-3/+3
| |
| * always wonder about people who say "do as I say, not as I do..."zotlabs2017-05-141-229/+229
| |
* | schema fixeszotlabs2017-05-221-3/+3
| |
* | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_mergezotlabs2017-05-051-0/+2
|\|
| * abook_not_here flag created to indicate singleton connections which are ↵zotlabs2017-05-031-0/+2
| | | | | | | | connected to this channel but not on this hub. abook_instance enumerates which hubs the connections is valid, but we ultimately need something more efficiently searchable to decide what operations are supported w/r/t this connection in the context of this hub. This flag is ignored during sync to clones although the code to set it correctly during channel creation, import, and sync has not yet been implemented.
* | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_mergezotlabs2017-04-261-0/+2
|\|
| * database support for client side e2ee for private mailzotlabs2017-04-251-0/+2
| |
| * backend infrastructure for 'channel protection password'; which will be used ↵zotlabs2017-04-121-0/+2
| | | | | | | | to optionally encrypt export files and resolve channel/identity ownership/hijacking disputes
* | database upgradezotlabs2017-04-231-211/+212
| |
* | remove fulltext indexes for innodbzotlabs2017-04-121-7/+1
| |
* | change default database settingszotlabs2017-04-121-62/+62
| |
* | backend infrastructure for 'channel protection password'; which will be used ↵zotlabs2017-04-121-0/+2
| | | | | | | | to optionally encrypt export files and resolve channel/identity ownership/hijacking disputes
* | db issueszotlabs2017-03-121-41/+0
|/
* Alter the queue so that each queue item stores the scheduled time of the ↵zotlabs2017-01-291-0/+2
| | | | | | | | next delivery. This keeps the query for queued items simple. We no longer group by posturl; as the queue update function will only keep one item per destination scheduled for shorter term processing. Others (multiple queued items for a single destination) will be scheduled for delivery far into the future and only delivered if the hub responds to the "active" or short term queue item.
* more vcard workzotlabs2016-12-211-0/+1
|