diff options
author | Sean Molenaar <sean@seanmolenaar.eu> | 2021-02-04 21:45:21 +0100 |
---|---|---|
committer | Sean Molenaar <SMillerDev@users.noreply.github.com> | 2021-02-05 09:37:17 +0100 |
commit | 6e9e2512eaa94c753119e22b6224de267d9fd968 (patch) | |
tree | da7e068c509153bef4147cc2d08765cd15fbb085 /lib/Migration | |
parent | 76298c011b6a22baf213221345e1f87ae0ec3cd7 (diff) |
DB: Remove unused fields
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
Diffstat (limited to 'lib/Migration')
-rw-r--r-- | lib/Migration/Version150203Date20210204203051.php | 76 |
1 files changed, 76 insertions, 0 deletions
diff --git a/lib/Migration/Version150203Date20210204203051.php b/lib/Migration/Version150203Date20210204203051.php new file mode 100644 index 000000000..840ae9849 --- /dev/null +++ b/lib/Migration/Version150203Date20210204203051.php @@ -0,0 +1,76 @@ +<?php + +declare(strict_types=1); + +namespace OCA\News\Migration; + +use Closure; +use OCP\DB\ISchemaWrapper; +use OCP\Migration\IOutput; +use OCP\Migration\SimpleMigrationStep; +use function PHPUnit\Framework\returnValue; + +/** + * Auto-generated migration step: Please modify to your needs! + */ +class Version150203Date20210204203051 extends SimpleMigrationStep { + + /** + * @param IOutput $output + * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper` + * @param array $options + */ + public function preSchemaChange(IOutput $output, Closure $schemaClosure, array $options): void { + } + + /** + * @param IOutput $output + * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper` + * @param array $options + * @return null|ISchemaWrapper + */ + public function changeSchema(IOutput $output, Closure $schemaClosure, array $options): ?ISchemaWrapper { + /** @var ISchemaWrapper $schema */ + $schema = $schemaClosure(); + + if ($schema->hasTable('news_items') && + $schema->getTable('news_items')->hasColumn('last_modified') && + $schema->getTable('news_items')->getColumn('last_modified')->getUnsigned() + ) { + $schema->getTable('news_items') + ->getColumn('last_modified') + ->setUnsigned(false); + } + + if ($schema->hasTable('news_items') && + $schema->getTable('news_items')->hasColumn('updated_date') + ) { + $schema->getTable('news_items') + ->dropColumn('updated_date'); + } + + if ($schema->hasTable('news_items') && + $schema->getTable('news_items')->hasColumn('status') + ) { + $schema->getTable('news_items') + ->dropColumn('status'); + } + + if ($schema->hasTable('news_feeds') && + $schema->getTable('news_feeds')->hasColumn('http_etag') + ) { + $schema->getTable('news_feeds') + ->dropColumn('http_etag'); + } + + return $schema; + } + + /** + * @param IOutput $output + * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper` + * @param array $options + */ + public function postSchemaChange(IOutput $output, Closure $schemaClosure, array $options): void { + } +} |