diff options
author | Maxence Lange <maxence@artificial-owl.com> | 2020-10-16 15:29:42 -0100 |
---|---|---|
committer | Maxence Lange <maxence@artificial-owl.com> | 2020-10-16 15:29:42 -0100 |
commit | 9d2e5c5d74bfa6461c88abf585df25eaccc1606b (patch) | |
tree | 605d63d520784c217acbb35f9436c1d977f50e81 /lib | |
parent | 19dfe49661fcee7e29f6b88e37cd71b19e0297b2 (diff) |
delete id_prim pkey is needed
Signed-off-by: Maxence Lange <maxence@artificial-owl.com>
Diffstat (limited to 'lib')
-rw-r--r-- | lib/Migration/Version0003Date20200823023900.php | 103 | ||||
-rw-r--r-- | lib/Migration/Version0003Date20200823023911.php | 2 |
2 files changed, 105 insertions, 0 deletions
diff --git a/lib/Migration/Version0003Date20200823023900.php b/lib/Migration/Version0003Date20200823023900.php new file mode 100644 index 00000000..33cba364 --- /dev/null +++ b/lib/Migration/Version0003Date20200823023900.php @@ -0,0 +1,103 @@ +<?php +declare(strict_types=1); + + +/** + * Nextcloud - Social Support + * + * This file is licensed under the Affero General Public License version 3 or + * later. See the COPYING file. + * + * @author Maxence Lange <maxence@artificial-owl.com> + * @copyright 2018, Maxence Lange <maxence@artificial-owl.com> + * @license GNU AGPL version 3 or any later version + * + * This program is free software: you can redistribute it and/or modify + * it under the terms of the GNU Affero General Public License as + * published by the Free Software Foundation, either version 3 of the + * License, or (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Affero General Public License for more details. + * + * You should have received a copy of the GNU Affero General Public License + * along with this program. If not, see <http://www.gnu.org/licenses/>. + * + */ + + +namespace OCA\Social\Migration; + + +use Closure; +use Doctrine\DBAL\DBALException; +use Doctrine\DBAL\Schema\SchemaException; +use Exception; +use OCP\DB\ISchemaWrapper; +use OCP\IDBConnection; +use OCP\Migration\IOutput; +use OCP\Migration\SimpleMigrationStep; + + +/** + * Class Version0003Date20200823023910 + * + * @package OCA\Social\Migration + */ +class Version0003Date20200823023900 extends SimpleMigrationStep { + + + /** @var IDBConnection */ + private $connection; + + + /** + * @param IDBConnection $connection + */ + public function __construct(IDBConnection $connection) { + $this->connection = $connection; + } + + + /** + * @param IOutput $output + * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper` + * @param array $options + * + * @return ISchemaWrapper + * @throws SchemaException + * @throws DBALException + */ + public function changeSchema(IOutput $output, Closure $schemaClosure, array $options): ISchemaWrapper { + /** @var ISchemaWrapper $schema */ + $schema = $schemaClosure(); + + if ($schema->hasTable('social_3_cache_actor')) { + $table = $schema->getTable('social_3_cache_actor'); + if ($table->hasPrimaryKey()) { + $kc = $table->getPrimaryKeyColumns(); + if (count($kc) === 1 && $kc[0] === 'id_prim') { + $table->dropPrimaryKey(); + } + } + } + + return $schema; + } + + + /** + * @param IOutput $output + * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper` + * @param array $options + * + * @throws Exception + */ + public function postSchemaChange(IOutput $output, Closure $schemaClosure, array $options) { + } + + +} + diff --git a/lib/Migration/Version0003Date20200823023911.php b/lib/Migration/Version0003Date20200823023911.php index 7047e5b7..39c37e2c 100644 --- a/lib/Migration/Version0003Date20200823023911.php +++ b/lib/Migration/Version0003Date20200823023911.php @@ -170,6 +170,8 @@ class Version0003Date20200823023911 extends SimpleMigrationStep { ] ] ); + + $table->addUniqueIndex(['id_prim']); } |