summaryrefslogtreecommitdiffstats
path: root/core/Application.php
Commit message (Collapse)AuthorAgeFilesLines
* add new index in repair step instead of on-migrateRobin Appelman2023-04-281-0/+3
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* Add parent index on filecacheLouis Chemineau2023-03-201-0/+4
| | | | Signed-off-by: Louis Chemineau <louis@chmn.me>
* Only check unsupported browsers on user renderingJohn Molakvoæ2022-10-281-0/+4
| | | | Signed-off-by: John Molakvoæ <skjnldsv@protonmail.com>
* Cleanup tags and Share componentCarl Schwan2022-09-291-2/+8
| | | | | | | | | - Port to LoggerInterface - Use IDBConnection and IQueryBuilder instead of raw SQL and OC_DB - Use IEventListener instead of hooks - Remove the now unused OC_DB and OC_DB_StatementWrapper legacy utils Signed-off-by: Carl Schwan <carl@carlschwan.eu>
* DB mounts table: Add index for mount_provider_classMarcel Klehr2022-08-011-0/+7
| | | | Signed-off-by: Marcel Klehr <mklehr@gmx.net>
* Merge pull request #31047 from nextcloud/enh/preferences-indexJulius Härtl2022-04-211-0/+7
|\ | | | | 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/+7
| | | | | | | | | | | | 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/+15
|/ | | | Signed-off-by: Carl Schwan <carl@carlschwan.eu>
* Add index for direct editing cleanup jobJulius Härtl2022-02-071-0/+7
| | | | Signed-off-by: Julius Härtl <jus@bitgrid.net>
* Add missing index for propertypath only queries against propertiesChristoph Wurst2021-12-231-0/+3
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Add an index for selecting the next jobJoas Schilling2021-12-011-0/+7
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* disable path prefix index on postgresql for nowRobin Appelman2021-10-081-1/+2
| | | | | | | 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/+4
| | | | | | | | | | | | 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>
* add better index for finding unindexed pathsRobin Appelman2021-10-071-0/+4
| | | | | | | | | | 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>
* Properly cleanup entries of WebAuthn on user deletionMorris Jobke2021-06-181-0/+2
| | | | Signed-off-by: Morris Jobke <hey@morrisjobke.de>
* Update php licensesJohn Molakvoæ (skjnldsv)2021-06-041-1/+0
| | | | Signed-off-by: John Molakvoæ (skjnldsv) <skjnldsv@protonmail.com>
* better cleanup of user files on user deletionRobin Appelman2021-04-271-0/+4
| | | | Signed-off-by: Robin Appelman <robin@icewind.nl>
* Revert "add a prefix index to filecache.path"Roeland Jago Douma2021-04-081-4/+0
|
* add a prefix index to filecache.pathRobin Appelman2021-03-191-0/+4
| | | | | | | | | | | | 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>
* Bump doctrine/dbal from 2.12.0 to 3.0.0Christoph Wurst2021-01-081-3/+4
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Update all license headers for Nextcloud 21Christoph Wurst2020-12-161-0/+1
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Add missing index on oc_cards and rename if it previously existedJulius Härtl2020-12-091-0/+4
| | | | Signed-off-by: Julius Härtl <jus@bitgrid.net>
* Add notification for user limitMorris Jobke2020-12-021-2/+2
| | | | Signed-off-by: Morris Jobke <hey@morrisjobke.de>
* Create primary keys on all tables and add a command to create the afterwardsJoas Schilling2020-11-101-0/+58
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Fix invalid usages of the new dispatcherRoeland Jago Douma2020-10-291-2/+4
| | | | Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>
* add size index for filecacheRobin Appelman2020-09-221-0/+4
| | | | | | improves performance of #23004 Signed-off-by: Robin Appelman <robin@icewind.nl>
* Update the license headers for Nextcloud 20Christoph Wurst2020-08-241-0/+1
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Clean up auth tokens when user is deletedChristoph Wurst2020-06-151-0/+2
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Add index to properties tableMario Danic2020-04-301-0/+7
| | | | Signed-off-by: Mario Danic <mario@lovelyhq.com>
* Update license headers for 19Christoph Wurst2020-04-291-1/+0
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Format control structures, classes, methods and functionChristoph Wurst2020-04-101-2/+0
| | | | | | | | | | | | | | | To continue this formatting madness, here's a tiny patch that adds unified formatting for control structures like if and loops as well as classes, their methods and anonymous functions. This basically forces the constructs to start on the same line. This is not exactly what PSR2 wants, but I think we can have a few exceptions with "our" style. The starting of braces on the same line is pracrically standard for our code. This also removes and empty lines from method/function bodies at the beginning and end. Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Merge pull request #19890 from nextcloud/enh/comments-reference-idJoas Schilling2020-04-021-0/+18
|\ | | | | Add optional comments reference_id
| * Add optional column oc_comments.reference_idJoas Schilling2020-03-311-0/+18
| | | | | | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* | Update the license headers for Nextcloud 19Christoph Wurst2020-03-311-1/+1
|/ | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Remove unused importsChristoph Wurst2020-03-251-1/+0
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Clean up 2FA provider registry when a user is deletedChristoph Wurst2020-01-081-0/+3
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Update license headersChristoph Wurst2019-12-051-2/+5
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Check and add index on principaluri for schedulingobjects tableThomas Citharel2019-10-081-0/+7
| | | | Signed-off-by: Thomas Citharel <tcit@tcit.fr>
* Add index on calendarid for calendarobject_props tableThomas Citharel2019-10-071-0/+8
| | | | Signed-off-by: Thomas Citharel <tcit@tcit.fr>
* Keep the old method as a fallback and adjust the testsJoas Schilling2019-07-161-2/+2
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Fix new core notifierJoas Schilling2019-07-151-18/+2
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Send emails when remote wipe starts/finishesChristoph Wurst2019-07-021-5/+9
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Decouple remote wipe notifcation channels with eventsChristoph Wurst2019-06-271-1/+13
| | | | Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Remote wipe supportRoeland Jago Douma2019-05-201-1/+10
| | | | | | | | This allows a user to mark a token for remote wipe. Clients that support this can then wipe the device properly. Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl> Signed-off-by: Christoph Wurst <christoph@winzerhof-wurst.at>
* Repair step for link sharesRoeland Jago Douma2019-04-161-0/+13
| | | | Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>
* Deduplicate index namesJoas Schilling2019-03-271-4/+4
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Make sure all tables have named indexesJoas Schilling2019-03-271-0/+38
| | | | Signed-off-by: Joas Schilling <coding@schilljs.com>
* Add twofactor_providers_uid indexRoeland Jago Douma2018-12-211-0/+8
| | | | | | Fixes #12943 Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>
* Fix index namesMorris Jobke2018-11-061-4/+4
| | | | * see #11527
* Add uid_owner and uid_initiator share tabe indicesRoeland Jago Douma2018-10-011-0/+6
| | | | Signed-off-by: Roeland Jago Douma <roeland@famdouma.nl>