aboutsummaryrefslogtreecommitdiffstats
path: root/core/Migrations
Commit message (Collapse)AuthorAgeFilesLines
* add new index in repair step instead of on-migrateRobin Appelman2023-04-281-1/+1
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* allow storing multiple mounts for the same rootid in the mount cacheRobin Appelman2023-04-282-1/+52
| | | | | | | | | | | | currently `[$userId, $rootId]` is used as the unique key for storing mounts in the mount cache, however there are cases where the same rootid is mounted in multiple places for a user which currently leads to not all of those mounts being added to the cache. Previously this didn't matter as the mount cache was only used to list users with access to a specific file, so a user having access to the file multiple times didn' change anything. With 24 the mount cache is used for more cases and multiple mounts for the same id becomes relevant. While I think there isn't a real negative effect atm besides missing the optimized path we should ensure that the mounts are properly listed Signed-off-by: Robin Appelman <robin@icewind.nl>
* Merge pull request #37146 from nextcloud/artonge/feat/migrate_metadata_to_valueLouis2023-04-043-3/+154
|\ | | | | Migrate metadata JSON column to new value TEXT column
| * Migrate metadata as JSON to value as STRINGLouis Chemineau2023-04-033-3/+154
| | | | | | | | Signed-off-by: Louis Chemineau <louis@chmn.me>
* | Add parent index on filecacheLouis Chemineau2023-03-201-0/+1
|/ | | | Signed-off-by: Louis Chemineau <louis@chmn.me>
* add a safeguard for Version23000Date20210721100600.phpSimon L2023-01-271-17/+19
| | | | Signed-off-by: Simon L <szaimen@e.mail.de>
* composer run cs:fixCôme Chilliet2023-01-2024-25/+0
| | | | Signed-off-by: Côme Chilliet <come.chilliet@nextcloud.com>
* PublickKeyTokenProvider: Fix password update routine with password hashMarcel Klehr2023-01-041-0/+57
| | | | Signed-off-by: Marcel Klehr <mklehr@gmx.net>
* Fix migration parameter handlingJoas Schilling2022-10-131-9/+8
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* fix querybuilder instance recuseArthur Schiwon2022-10-131-10/+12
| | | | | | ...and execute delete query Signed-off-by: Arthur Schiwon <blizzz@arthur-schiwon.de>
* Delete theming background preferencesChristopher Ng2022-10-131-4/+10
| | | | Signed-off-by: Christopher Ng <chrng8@gmail.com>
* New code being newJoas Schilling2022-10-131-3/+1
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Fix SQL errorsJoas Schilling2022-10-131-3/+5
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Fix missing background on upgradeChristopher Ng2022-10-131-0/+65
| | | | Signed-off-by: Christopher Ng <chrng8@gmail.com>
* Update Version24000Date20220404230027.phptimm2k2022-09-151-1/+1
| | | Signed-off-by: timm2k <timm2k@gmx.de>
* DB mounts table: Add index for mount_provider_classMarcel Klehr2022-08-011-0/+1
| | | | Signed-off-by: Marcel Klehr <mklehr@gmx.net>
* Add comments expire dateVitor Mattos2022-06-151-0/+57
| | | | | | https://github.com/nextcloud/spreed/pull/7327 Signed-off-by: Vitor Mattos <vitor@php.rio>
* Add new share attributes columnVincent Petry2022-06-081-0/+52
| | | | | | To store more extended permissions in the future. Signed-off-by: Vincent Petry <vincent@nextcloud.com>
* Fix older migrations to the version patternJoas Schilling2022-04-252-3/+3
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add missing indexJoas Schilling2022-04-251-0/+53
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Merge pull request #31047 from nextcloud/enh/preferences-indexJulius Härtl2022-04-211-0/+1
|\ | | | | Additional index on oc_preferences to make queries without a user filter faster
| * Additional index on oc_preferences to make sure that gettingh values without ↵Julius Härtl2022-04-191-0/+1
| | | | | | | | | | | | a user filter is fast Signed-off-by: Julius Härtl <jus@bitgrid.net>
* | Add a metadata service to store file metadataCarl Schwan2022-04-131-0/+62
|/ | | | Signed-off-by: Carl Schwan <carl@carlschwan.eu>
* Update Version24000Date20211222112246.phpJoas Schilling2022-03-151-2/+4
|
* store mountprovider for each mount in the mounts tableRobin Appelman2022-02-231-0/+37
| | | | | | this enabled more fine grained filesystem setup Signed-off-by: Robin Appelman <robin@icewind.nl>
* Merge pull request #31042 from nextcloud/enh/direct_edit_indexVincent Petry2022-02-101-0/+1
|\ | | | | Add index for direct editing cleanup job
| * Add index for direct editing cleanup jobJulius Härtl2022-02-071-0/+1
| | | | | | | | Signed-off-by: Julius Härtl <jus@bitgrid.net>
* | Allow apps to specify if their background job can be delayedJoas Schilling2022-02-071-0/+55
|/ | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add a primary key to ratelimit_entries tableJoas Schilling2022-01-283-20/+139
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Fix column size to work with Oracle. Add unit testsVitor Mattos2022-01-211-4/+4
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Add comments reactionsVitor Mattos2022-01-211-0/+96
| | | | Signed-off-by: Vitor Mattos <vitor@php.rio>
* Add hashed attribute column for indexed job existence checkJulius Härtl2022-01-181-0/+67
| | | | Signed-off-by: Julius Härtl <jus@bitgrid.net>
* Check style updateCarl Schwan2022-01-131-1/+1
| | | | Signed-off-by: Carl Schwan <carl@carlschwan.eu>
* Add missing index for propertypath only queries against propertiesChristoph Wurst2021-12-231-0/+1
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Migrate profile_config id column to bigintChristopher Ng2021-12-141-0/+42
| | | | Signed-off-by: Christopher Ng <chrng8@gmail.com>
* Use bigint for autoincremented columnChristopher Ng2021-12-141-1/+1
| | | | Signed-off-by: Christopher Ng <chrng8@gmail.com>
* Use proper app id (settings instead of core)Julius Härtl2021-12-131-1/+1
| | | | Signed-off-by: Julius Härtl <jus@bitgrid.net>
* Lowercase all core=>email valuesJoas Schilling2021-12-131-0/+63
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Merge pull request #29996 from zordsdavini/patch-1Pytal2021-12-092-1/+55
|\
| * Update core/Migrations/Version23000Date20211203110726.phpPytal2021-12-091-8/+4
| | | | | | | | | | Co-authored-by: John Molakvoæ <skjnldsv@users.noreply.github.com> Signed-off-by: Christopher Ng <chrng8@gmail.com>
| * Fix relation "user_id" already exists migration errorChristopher Ng2021-12-032-1/+59
| | | | | | | | Signed-off-by: Christopher Ng <chrng8@gmail.com>
* | Add an index for selecting the next jobJoas Schilling2021-12-011-0/+1
|/ | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Merge pull request #28541 from nextcloud/path-prefix-index2Robin Appelman2021-10-191-0/+4
|\ | | | | add a prefix index to filecache.path, attempt 2
| * disable path prefix index on postgresql for nowRobin Appelman2021-10-081-1/+4
| | | | | | | | | | | | | | having the index work properly for the queries we need it for requires some additional options which dbal does not support at the momement. to prevent making it harder to add the correct index later on we don't create the index for now on postgresql Signed-off-by: Robin Appelman <robin@icewind.nl>
| * add a prefix index to filecache.pathRobin Appelman2021-10-081-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | The reason that `filecache.path` hasn't had an index added is the mysql limitation of ~1kb for indexeded fields, which is to small for the `path`, however mysql supports indexing only the first N bytes of a column instead of the entire column, allowing us to add an index even if the column is to long. Because the index doesn't cover the entire column it can't be used in all situations where a normal index would be used, but it does cover the `path like 'folder/path/%'` queries that are used in various places. Sqlite and Postgresql don't support prefix indexes, but they also don't have the 1kb limit and DBAL handles the differences in index creation. Signed-off-by: Robin Appelman <robin@icewind.nl>
* | Profile backendChristopher Ng2021-10-191-0/+69
|/ | | | Signed-off-by: Christopher Ng <chrng8@gmail.com>
* add better index for finding unindexed pathsRobin Appelman2021-10-071-0/+1
| | | | | | | | | | for the following query 'SELECT "path" FROM "oc_filecache" WHERE ("storage" = $storage) AND ("size" < 0) ORDER BY "fileid" DESC LIMIT 1;' currently the database will in some cases decide to priorize the sort by fileid over the filter when picking what index to use, resulting in a much slower query. by creating an index that allows first sorting by fileid and also filter by storage and size this case will be greatly sped up Signed-off-by: Robin Appelman <robin@icewind.nl>
* Add admin privilege delegation for admin settingsCarl Schwan2021-09-291-0/+62
| | | | | | | This makes it possible for selected groups to access some settings pages. Signed-off-by: Carl Schwan <carl@carlschwan.eu>
* Implement review feedbackLukas Reschke2021-09-131-2/+2
| | | | Signed-off-by: Lukas Reschke <lukas@statuscode.ch>
* Apply suggestions from code review Lukas Reschke2021-09-131-2/+3
| | | | | Signed-off-by: Lukas Reschke <lukas@statuscode.ch> Co-authored-by: Joas Schilling <213943+nickvergessen@users.noreply.github.com>
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-23 13:54:41 +0000