diff options
| author | Roeland Jago Douma <rullzer@users.noreply.github.com> | 2020-04-06 10:44:34 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-04-06 10:44:34 +0300 |
| commit | 9a4193f557f7c503a13903d165c55ead22c9b129 (patch) | |
| tree | fdfbbed04357234c056b91f1f439900b5a2b5e81 | |
| parent | d25885441e8a39ab198bf7137ff3b32f8c0e908d (diff) | |
| parent | 79dcd34a071d621a41a84448bbf5c66fd21b9c03 (diff) | |
Merge pull request #19761 from nextcloud/bugfix/19658/add_missing_index_to_original_migration
Add missing index to original migration
| -rw-r--r-- | apps/dav/lib/Migration/Version1004Date20170825134824.php | 1 | ||||
| -rw-r--r-- | apps/dav/lib/Migration/Version1006Date20180628111625.php | 1 | ||||
| -rw-r--r-- | core/Migrations/Version13000Date20170718121200.php | 9 |
3 files changed, 8 insertions, 3 deletions
diff --git a/apps/dav/lib/Migration/Version1004Date20170825134824.php b/apps/dav/lib/Migration/Version1004Date20170825134824.php index 81107a7c750..d25e387e32e 100644 --- a/apps/dav/lib/Migration/Version1004Date20170825134824.php +++ b/apps/dav/lib/Migration/Version1004Date20170825134824.php @@ -369,6 +369,7 @@ class Version1004Date20170825134824 extends SimpleMigrationStep { 'unsigned' => true, ]); $table->setPrimaryKey(['id']); + $table->addIndex(['principaluri'], 'schedulobj_principuri_index'); } if (!$schema->hasTable('cards_properties')) { diff --git a/apps/dav/lib/Migration/Version1006Date20180628111625.php b/apps/dav/lib/Migration/Version1006Date20180628111625.php index a09bb070d88..08a5951d8df 100644 --- a/apps/dav/lib/Migration/Version1006Date20180628111625.php +++ b/apps/dav/lib/Migration/Version1006Date20180628111625.php @@ -92,6 +92,7 @@ class Version1006Date20180628111625 extends SimpleMigrationStep { $calendarObjectsPropsTable->addIndex(['objectid', 'calendartype'], 'calendarobject_index'); $calendarObjectsPropsTable->addIndex(['name', 'calendartype'], 'calendarobject_name_index'); $calendarObjectsPropsTable->addIndex(['value', 'calendartype'], 'calendarobject_value_index'); + $calendarObjectsPropsTable->addIndex(['calendarid', 'calendartype'], 'calendarobject_calid_index'); } if ($schema->hasTable('calendarsubscriptions')) { diff --git a/core/Migrations/Version13000Date20170718121200.php b/core/Migrations/Version13000Date20170718121200.php index 757697e7e90..4df2f4cbdab 100644 --- a/core/Migrations/Version13000Date20170718121200.php +++ b/core/Migrations/Version13000Date20170718121200.php @@ -94,11 +94,13 @@ class Version13000Date20170718121200 extends SimpleMigrationStep { 'notnull' => true, 'length' => 4, ]); - $table->addColumn('storage_id', 'integer', [ + $table->addColumn('storage_id', Type::BIGINT, [ 'notnull' => true, + 'length' => 20, ]); - $table->addColumn('root_id', 'integer', [ + $table->addColumn('root_id', Type::BIGINT, [ 'notnull' => true, + 'length' => 20, ]); $table->addColumn('user_id', 'string', [ 'notnull' => true, @@ -108,8 +110,9 @@ class Version13000Date20170718121200 extends SimpleMigrationStep { 'notnull' => true, 'length' => 4000, ]); - $table->addColumn('mount_id', 'integer', [ + $table->addColumn('mount_id', Type::BIGINT, [ 'notnull' => false, + 'length' => 20, ]); $table->setPrimaryKey(['id']); $table->addIndex(['user_id'], 'mounts_user_index'); |