Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | more index finetuning to fix the expire query | Mario Vavti | 2018-02-20 | 1 | -3/+3 |
| | |||||
* | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge | zotlabs | 2018-02-16 | 1 | -2/+4 |
|\ | |||||
| * | some more DB tuning. | Mario Vavti | 2018-02-15 | 2 | -3/+21 |
| | | |||||
* | | refactor of the DB update system. Updates are now stored individually in ↵ | zotlabs | 2018-02-16 | 1 | -3115/+0 |
|/ | | | | Zotlabs/Update/_nnnn.php and are objects; so only the pending updates need to be loaded and executed rather than all historical updates. There is one single number (DB_UPDATE_VERSION) representing the current version and it is EQUAL TO the last known update. A dummy update _1201 was created to address the difference in counting behaviour; it will be executed on the next change of DB_UPDATE_VERSION as well as the next update. The database config values are also loaded from disk on every update immediately before setting the update lock in order to reduce timing conflicts and race conditions. | ||||
* | more db and queries finetuning | Mario Vavti | 2018-02-08 | 2 | -3/+17 |
| | |||||
* | this will fix the cards query and keep the rest intact | Mario Vavti | 2018-02-04 | 2 | -3/+15 |
| | |||||
* | superfluous , | Mario Vavti | 2018-02-04 | 1 | -1/+1 |
| | |||||
* | remove indices from mysql schema file | Mario Vavti | 2018-02-04 | 1 | -7/+0 |
| | |||||
* | remove some never used indices which prevented our item queries to find the ↵ | Mario Vavti | 2018-02-04 | 1 | -1/+18 |
| | | | | right query execution plan in mysql and adjust some queries to optimze the result | ||||
* | remove column item.diaspora_meta, action items 2 and 3 of hubzilla issue #828 | zotlabs | 2017-11-16 | 2 | -3/+12 |
| | |||||
* | typo | zotlabs | 2017-10-19 | 1 | -1/+1 |
| | |||||
* | table structure for pseudo or proxy channels (pchan) | zotlabs | 2017-10-19 | 3 | -1/+65 |
| | |||||
* | remove server role selection details from install documentation, no longer ↵ | zotlabs | 2017-10-02 | 1 | -30/+10 |
| | | | | needed | ||||
* | db update to add index to item.resource_id we query this in wikis a lot | Mario Vavti | 2017-09-16 | 3 | -2/+18 |
| | |||||
* | wiki mimetype selection. We can add text/plain as soon as we add code to ↵ | zotlabs | 2017-09-12 | 1 | -1/+17 |
| | | | | purify and render it specifically. | ||||
* | remove semicolon from update query - this is probably trivial | Mario Vavti | 2017-09-07 | 1 | -1/+1 |
| | |||||
* | fix bogus semicolon | Waitman Gobble | 2017-09-06 | 1 | -1/+1 |
| | | | Line 655 should have comma instead of semicolon | ||||
* | add combined index for item.uid and item.item_unseen. this speeds up ↵ | Mario Vavti | 2017-09-01 | 3 | -3/+19 |
| | | | | notifications by a magnitude. | ||||
* | update installation requirements - php 5.6 and mysql 5.5.3 | zotlabs | 2017-08-17 | 1 | -2/+2 |
| | |||||
* | db update to add index for item.obj_type | git-marijus | 2017-07-31 | 3 | -1/+15 |
| | |||||
* | update r1191: return update_success if table principals exists otherwise ↵ | Mario Vavti | 2017-07-10 | 1 | -404/+414 |
| | | | | proceed with creating cdav tables. | ||||
* | remove if not exist clause on index creation - it seems to be supported in ↵ | Mario Vavti | 2017-07-08 | 1 | -1/+1 |
| | | | | mariadb only | ||||
* | use if not exists clause to not error if the index was already there | Mario Vavti | 2017-07-05 | 1 | -1/+1 |
| | |||||
* | missing abook_{my,their}_perms in pg schema and missing keys in mysql schema | Mario Vavti | 2017-07-05 | 2 | -0/+6 |
| | |||||
* | update_version bump | Mario Vavti | 2017-07-05 | 1 | -1/+1 |
| | |||||
* | missing semicolon | Mario Vavti | 2017-07-05 | 1 | -1/+1 |
| | |||||
* | db-update for cdav | Mario Vavti | 2017-07-04 | 1 | -0/+410 |
| | |||||
* | add the cdav pgsql schemas | Mario Vavti | 2017-07-04 | 1 | -0/+222 |
| | |||||
* | cdav migration to core | zotlabs | 2017-06-22 | 1 | -0/+171 |
| | |||||
* | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge | zotlabs | 2017-06-11 | 1 | -3/+3 |
|\ | |||||
| * | some more innodb mysql scheme adjustments | Mario Vavti | 2017-06-10 | 1 | -15/+8 |
| | | |||||
| * | convert schema_mysql engine to InnoDB and charset utf8mb4 | git-marijus | 2017-06-09 | 1 | -267/+267 |
| | | |||||
* | | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge | zotlabs | 2017-06-07 | 1 | -3/+3 |
|\| | |||||
| * | Fixed TEXT fields with default values (fixes #803) in mysql creation script. | Manuel Tancoigne | 2017-06-07 | 1 | -6/+6 |
| | | |||||
* | | fix a merge mixup on install/schema_msyql.php | zotlabs | 2017-06-06 | 1 | -230/+230 |
| | | |||||
* | | remove default for text/mediumtext sql fields | zotlabs | 2017-05-31 | 1 | -6/+6 |
| | | |||||
* | | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge | zotlabs | 2017-05-30 | 1 | -1/+6 |
|\| | |||||
| * | fix update_r1189() for mysql and postgres | Mario Vavti | 2017-05-28 | 1 | -1/+6 |
| | | |||||
* | | more deprecate server_role | zotlabs | 2017-05-29 | 1 | -8/+0 |
| | | |||||
* | | looks like a commit was lost someplace, but I'll re-do it later (convert sql ↵ | zotlabs | 2017-05-25 | 1 | -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 ↵ | zotlabs | 2017-05-25 | 1 | -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_merge | zotlabs | 2017-05-23 | 1 | -1/+1 |
|\| | |||||
| * | schema fixes | zotlabs | 2017-05-23 | 1 | -3/+3 |
| | | |||||
* | | Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge | zotlabs | 2017-05-22 | 2 | -2/+2 |
|\| | |||||
| * | resolve merge conflict | zotlabs | 2017-05-20 | 2 | -24/+24 |
| | | |||||
| * | Merge pull request #778 from beardyunixer/dev | git-marijus | 2017-05-17 | 1 | -1/+1 |
| |\ | | | | | | | Update nginx | ||||
| | * | Update nginx | Thomas Willingham | 2017-05-15 | 1 | -1/+1 |
| | | | |||||
| * | | always wonder about people who say "do as I say, not as I do..." | zotlabs | 2017-05-14 | 3 | -429/+429 |
| |/ | |||||
* | | schema fixes | zotlabs | 2017-05-22 | 1 | -3/+3 |
| | | |||||
* | | danger - do not use 'char(n)' with postgres it creates a thing called a ↵ | zotlabs | 2017-05-15 | 2 | -24/+24 |
| | | | | | | | | bpchar which is different than a normal text field in subtle ways. |