Gecko [ paroquia-rio-de-mouro.pt ]

Name	Size	Permission	Date
Version20170101010100.php	21.05 KB	-rw-r--r--	2018-04-19 18:15
Version20170101215145.php	4.5 KB	-rw-r--r--	2018-04-19 18:15
Version20170111103310.php	4.2 KB	-rw-r--r--	2018-04-19 18:15
Version20170213215145.php	532 B	-rw-r--r--	2018-04-19 18:15
Version20170214112458.php	1.46 KB	-rw-r--r--	2018-04-19 18:15
Version20170221114437.php	953 B	-rw-r--r--	2018-04-19 18:15
Version20170221121536.php	1.7 KB	-rw-r--r--	2018-04-19 18:15
Version20170315173825.php	3.53 KB	-rw-r--r--	2018-04-19 18:15
Version20170320173955.php	1.21 KB	-rw-r--r--	2018-04-19 18:15
Version20170418154659.php	1.32 KB	-rw-r--r--	2018-04-19 18:15
Version20170516100103.php	2.17 KB	-rw-r--r--	2018-04-19 18:15
Version20170526104128.php	1.57 KB	-rw-r--r--	2018-04-19 18:15
Version20170605143658.php	745 B	-rw-r--r--	2018-04-19 18:15
Version20170711191432.php	673 B	-rw-r--r--	2018-04-19 18:15
Version20170804201253.php	1.07 KB	-rw-r--r--	2018-04-19 18:15
Version20170928120000.php	628 B	-rw-r--r--	2018-04-19 18:15
Version20171026130750.php	787 B	-rw-r--r--	2018-04-19 18:15
Version20180123131835.php	880 B	-rw-r--r--	2018-04-19 18:15
Version20180319102121.php	543 B	-rw-r--r--	2018-04-19 18:15

Rename

<?php

namespace OC\Migrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\DBAL\Types\Type;
use OCP\Migration\ISchemaMigration;

/**
 * migrate stable9 to stable10
 */
class Version20170101215145 implements ISchemaMigration {

public function changeSchema(Schema $schema, array $options) {
		$prefix = $options['tablePrefix'];

if (!$schema->hasTable("${prefix}authtoken")) {
			$authTokenTable = $schema->createTable("${prefix}authtoken");

$authTokenTable->addColumn(
				'id',
				Type::INTEGER,
				[
					'notnull' => true,
					'autoincrement' => 1,
					'unsigned' => true
				]
			);

$authTokenTable->addColumn(
				'uid',
				Type::STRING,
				[
					'length' => 64,
					'default' => '',
					'notnull' => true
				]
			);

$authTokenTable->addColumn(
				'login_name',
				Type::STRING,
				[
					'length' => 64,
					'default' => '',
					'notnull' => true
				]
			);

$authTokenTable->addColumn(
				'name',
				Type::TEXT,
				[
					'default' => '',
					'notnull' => true
				]
			);

$authTokenTable->addColumn(
				'token',
				Type::STRING,
				[
					'length' => 200,
					'default' => '',
					'notnull' => true
				]
			);

$authTokenTable->addColumn(
				'type',
				Type::SMALLINT,
				[
					'unsigned' => true,
					'default' => 0,
					'notnull' => true
				]
			);

$authTokenTable->addColumn(
				'last_activity',
				Type::INTEGER,
				[
					'unsigned' => true,
					'default' => 0,
					'notnull' => true
				]
			);

$authTokenTable->addColumn(
				'last_check',
				Type::INTEGER,
				[
					'unsigned' => true,
					'default' => 0,
					'notnull' => true
				]
			);

$authTokenTable->addColumn(
				'password',
				Type::TEXT,
				[
					'default' => null,
					'notnull' => false
				]
			);

$authTokenTable->setPrimaryKey(['id']);

$authTokenTable->addIndex(['last_activity'], 'authtoken_last_activity_index');

$authTokenTable->addUniqueIndex(['token'], 'authtoken_token_index');
		}

if (!$schema->hasTable("${prefix}systemtag_group")) {
			$systemTagGroupTable = $schema->createTable("${prefix}systemtag_group");

$systemTagGroupTable->addColumn(
				'gid',
				Type::STRING,
				[
					'length' => 255,
					'notnull' => true
				]
			);

$systemTagGroupTable->addColumn(
				'systemtagid',
				Type::INTEGER,
				[
					'unsigned' => true,
					'default' => 0,
					'notnull' => true
				]
			);

$systemTagGroupTable->setPrimaryKey(['gid', 'systemtagid']);
		}

if ($schema->hasTable("${prefix}jobs")) {
			$jobsTable = $schema->getTable("${prefix}jobs");

if (!$jobsTable->hasColumn('last_checked')) {
				$jobsTable->addColumn(
					'last_checked',
					Type::INTEGER,
					[
						'default' => 0,
						'notnull' => false
					]
				);
			}

if (!$jobsTable->hasColumn('reserved_at')) {
				$jobsTable->addColumn(
					'reserved_at',
					Type::INTEGER,
					[
						'default' => 0,
						'notnull' => false
					]
				);
			}
		}

if ($schema->hasTable("${prefix}calendarobjects")) {
			$calendarObjectsTable = $schema->getTable("${prefix}calendarobjects");

if (!$calendarObjectsTable->hasColumn('classification')) {
				$calendarObjectsTable->addColumn(
					'classification',
					Type::INTEGER,
					[
						'default' => 0,
						'notnull' => false
					]
				);
			}

if ($calendarObjectsTable->hasColumn('componenttype')) {
				$componentType = $calendarObjectsTable->getColumn('componenttype');
				// TODO: check what happens when this contained data with length > 8
				$componentType->setOptions(['length' => 8]);
			}

if ($calendarObjectsTable->hasColumn('firstoccurence')) {
				$firstOccurence = $calendarObjectsTable->getColumn('firstoccurence');
				$firstOccurence->setType(Type::getType(Type::BIGINT));
			}

if ($calendarObjectsTable->hasColumn('lastoccurence')) {
				$lastOccurence = $calendarObjectsTable->getColumn('lastoccurence');
				$lastOccurence->setType(Type::getType(Type::BIGINT));
			}
		}

if ($schema->hasTable("${prefix}calendars")) {
			$calendarsTable = $schema->getTable("${prefix}calendars");

if ($calendarsTable->hasColumn('components')) {
				$components = $calendarsTable->getColumn('components');
				$components->setOptions(['length' => 20]);
			}
		}

if ($schema->hasTable("${prefix}calendarsubscriptions")) {
			$calendarSubscriptionsTable = $schema->getTable("${prefix}calendarsubscriptions");

if ($calendarSubscriptionsTable->hasColumn('lastmodified')) {
				$lastModified = $calendarSubscriptionsTable->getColumn('lastmodified');
				$lastModified->setOptions(
					[
						'notnull' => true
					]
				);
			}
		}
	}
}