aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
Commit message (Collapse)AuthorAgeFilesLines
* mysql: remove some unused indices and add thr_parent index. pgsql: sync ↵Mario Vavti2019-03-191-5/+2
| | | | indices with mysql indices after testing on hub.disroot.org and add thr_parent
* Add expires for photoMax Kostikov2018-11-291-0/+2
|
* update sql schemas to include update column in pconfig tableMario Vavti2018-11-191-3/+3
| | | (cherry picked from commit ae97649948b8af575441e5a1f5b69db9f627a0e2)
* dreport updateszotlabs2018-11-121-0/+1
|
* didn't need xchan_portable_idzotlabs2018-11-081-2/+0
|
* item db updateszotlabs2018-11-081-0/+3
|
* z6 workzotlabs2018-11-051-0/+4
|
* fix issue #1281 - hubloc default valuesMario Vavti2018-10-061-1/+1
|
* Update schema_mysql.sqlMax Kostikov2018-09-271-3/+2
|
* important hyperdrive componentzotlabs2018-09-091-0/+11
|
* hubloc DB changes needed for z6zotlabs2018-08-131-1/+5
|
* add app_options fieldzotlabs2018-08-021-0/+1
|
* 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
| |