Merge pull request #5772 from nextcloud/migrations-install

Install nextcloud via migrations instead of the db_structure.xml

19 files changed, 1193 insertions, 2379 deletions

diff --git a/build/files-checker.php b/build/files-checker.php
index 4d4e64e3614..66c44bd971b 100644
--- a/build/files-checker.php
+++ b/build/files-checker.php
@@ -58,7 +58,6 @@ $expectedFiles = [
 	'COPYING-README',
 	'core',
 	'cron.php',
-	'db_structure.xml',
 	'index.html',
 	'index.php',
 	'issue_template.md',
diff --git a/core/Command/Db/ConvertType.php b/core/Command/Db/ConvertType.php
index 16864e57dbc..a7839522934 100644
--- a/core/Command/Db/ConvertType.php
+++ b/core/Command/Db/ConvertType.php
@@ -28,6 +28,10 @@
 
 namespace OC\Core\Command\Db;
 
+use Doctrine\DBAL\DBALException;
+use Doctrine\DBAL\Schema\Table;
+use Doctrine\DBAL\Types\Type;
+use OC\DB\MigrationService;
 use OCP\DB\QueryBuilder\IQueryBuilder;
 use \OCP\IConfig;
 use OC\DB\Connection;
@@ -190,7 +194,7 @@ class ConvertType extends Command implements CompletionAwareInterface {
 			$this->clearSchema($toDB, $input, $output);
 		}
 
-		$this->createSchema($toDB, $input, $output);
+		$this->createSchema($fromDB, $toDB, $input, $output);
 
 		$toTables = $this->getTables($toDB);
 		$fromTables = $this->getTables($fromDB);
@@ -217,27 +221,43 @@ class ConvertType extends Command implements CompletionAwareInterface {
 		$this->convertDB($fromDB, $toDB, $intersectingTables, $input, $output);
 	}
 
-	protected function createSchema(Connection $toDB, InputInterface $input, OutputInterface $output) {
+	protected function createSchema(Connection $fromDB, Connection $toDB, InputInterface $input, OutputInterface $output) {
 		$output->writeln('<info>Creating schema in new database</info>');
+
+		$fromMS = new MigrationService('core', $fromDB);
+		$currentMigration = $fromMS->getMigration('current');
+		if ($currentMigration !== '0') {
+			$toMS = new MigrationService('core', $toDB);
+			$toMS->migrate($currentMigration);
+		}
+
 		$schemaManager = new \OC\DB\MDB2SchemaManager($toDB);
-		$schemaManager->createDbFromStructure(\OC::$SERVERROOT.'/db_structure.xml');
 		$apps = $input->getOption('all-apps') ? \OC_App::getAllApps() : \OC_App::getEnabledApps();
 		foreach($apps as $app) {
 			if (file_exists(\OC_App::getAppPath($app).'/appinfo/database.xml')) {
 				$schemaManager->createDbFromStructure(\OC_App::getAppPath($app).'/appinfo/database.xml');
+			} else {
+				// Make sure autoloading works...
+				\OC_App::loadApp($app);
+				$fromMS = new MigrationService($app, $fromDB);
+				$currentMigration = $fromMS->getMigration('current');
+				if ($currentMigration !== '0') {
+					$toMS = new MigrationService($app, $toDB);
+					$toMS->migrate($currentMigration);
+				}
 			}
 		}
 	}
 
 	protected function getToDBConnection(InputInterface $input, OutputInterface $output) {
 		$type = $input->getArgument('type');
-		$connectionParams = array(
+		$connectionParams = $this->connectionFactory->createConnectionParams();
+		$connectionParams = array_merge($connectionParams, [
 			'host' => $input->getArgument('hostname'),
 			'user' => $input->getArgument('username'),
 			'password' => $input->getOption('password'),
 			'dbname' => $input->getArgument('database'),
-			'tablePrefix' => $this->config->getSystemValue('dbtableprefix', 'oc_'),
-		);
+		]);
 		if ($input->getOption('port')) {
 			$connectionParams['port'] = $input->getOption('port');
 		}
@@ -264,18 +284,23 @@ class ConvertType extends Command implements CompletionAwareInterface {
 	/**
 	 * @param Connection $fromDB
 	 * @param Connection $toDB
-	 * @param $table
+	 * @param Table $table
 	 * @param InputInterface $input
 	 * @param OutputInterface $output
 	 * @suppress SqlInjectionChecker
 	 */
-	protected function copyTable(Connection $fromDB, Connection $toDB, $table, InputInterface $input, OutputInterface $output) {
+	protected function copyTable(Connection $fromDB, Connection $toDB, Table $table, InputInterface $input, OutputInterface $output) {
+		if ($table->getName() === $toDB->getPrefix() . 'migrations') {
+			$output->writeln('<comment>Skipping migrations table because it was already filled by running the migrations</comment>');
+			return;
+		}
+
 		$chunkSize = $input->getOption('chunk-size');
 
 		$query = $fromDB->getQueryBuilder();
 		$query->automaticTablePrefix(false);
 		$query->selectAlias($query->createFunction('COUNT(*)'), 'num_entries')
-			->from($table);
+			->from($table->getName());
 		$result = $query->execute();
 		$count = $result->fetchColumn();
 		$result->closeCursor();
@@ -293,12 +318,25 @@ class ConvertType extends Command implements CompletionAwareInterface {
 		$query = $fromDB->getQueryBuilder();
 		$query->automaticTablePrefix(false);
 		$query->select('*')
-			->from($table)
+			->from($table->getName())
 			->setMaxResults($chunkSize);
 
+		try {
+			$orderColumns = $table->getPrimaryKeyColumns();
+		} catch (DBALException $e) {
+			$orderColumns = [];
+			foreach ($table->getColumns() as $column) {
+				$orderColumns[] = $column->getName();
+			}
+		}
+
+		foreach ($orderColumns as $column) {
+			$query->addOrderBy($column);
+		}
+
 		$insertQuery = $toDB->getQueryBuilder();
 		$insertQuery->automaticTablePrefix(false);
-		$insertQuery->insert($table);
+		$insertQuery->insert($table->getName());
 		$parametersCreated = false;
 
 		for ($chunk = 0; $chunk < $numChunks; $chunk++) {
@@ -330,33 +368,35 @@ class ConvertType extends Command implements CompletionAwareInterface {
 		$progress->finish();
 	}
 
-	protected function getColumnType($table, $column) {
-		if (isset($this->columnTypes[$table][$column])) {
-			return $this->columnTypes[$table][$column];
+	protected function getColumnType(Table $table, $columnName) {
+		$tableName = $table->getName();
+		if (isset($this->columnTypes[$tableName][$columnName])) {
+			return $this->columnTypes[$tableName][$columnName];
 		}
-		$prefix = $this->config->getSystemValue('dbtableprefix', 'oc_');
 
-		$this->columnTypes[$table][$column] = false;
+		$type = $table->getColumn($columnName)->getType()->getName();
 
-		if ($table === $prefix . 'cards' && $column === 'carddata') {
-			$this->columnTypes[$table][$column] = IQueryBuilder::PARAM_LOB;
-		} else if ($column === 'calendardata') {
-			if ($table === $prefix . 'calendarobjects' ||
-				$table === $prefix . 'schedulingobjects') {
-				$this->columnTypes[$table][$column] = IQueryBuilder::PARAM_LOB;
-			}
+		switch ($type) {
+			case Type::BLOB:
+			case Type::TEXT:
+				$this->columnTypes[$tableName][$columnName] = IQueryBuilder::PARAM_LOB;
+				break;
+			default:
+				$this->columnTypes[$tableName][$columnName] = false;
 		}
 
-		return $this->columnTypes[$table][$column];
+		return $this->columnTypes[$tableName][$columnName];
 	}
 
 	protected function convertDB(Connection $fromDB, Connection $toDB, array $tables, InputInterface $input, OutputInterface $output) {
 		$this->config->setSystemValue('maintenance', true);
+		$schema = $fromDB->createSchema();
+
 		try {
 			// copy table rows
 			foreach($tables as $table) {
 				$output->writeln($table);
-				$this->copyTable($fromDB, $toDB, $table, $input, $output);
+				$this->copyTable($fromDB, $toDB, $schema->getTable($table), $input, $output);
 			}
 			if ($input->getArgument('type') === 'pgsql') {
 				$tools = new \OC\DB\PgSqlTools($this->config);
diff --git a/core/Command/Db/GenerateChangeScript.php b/core/Command/Db/GenerateChangeScript.php
deleted file mode 100644
index bbe8d29958e..00000000000
--- a/core/Command/Db/GenerateChangeScript.php
+++ /dev/null
@@ -1,89 +0,0 @@
-<?php
-/**
- * @copyright Copyright (c) 2016, ownCloud, Inc.
- *
- * @author Morris Jobke <hey@morrisjobke.de>
- * @author Thomas Müller <thomas.mueller@tmit.eu>
- *
- * @license AGPL-3.0
- *
- * This code is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Affero General Public License, version 3,
- * as published by the Free Software Foundation.
- *
- * 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, version 3,
- * along with this program.  If not, see <http://www.gnu.org/licenses/>
- *
- */
-
-namespace OC\Core\Command\Db;
-
-use Stecman\Component\Symfony\Console\BashCompletion\Completion;
-use Stecman\Component\Symfony\Console\BashCompletion\Completion\CompletionAwareInterface;
-use Stecman\Component\Symfony\Console\BashCompletion\Completion\ShellPathCompletion;
-use Stecman\Component\Symfony\Console\BashCompletion\CompletionContext;
-use Symfony\Component\Console\Command\Command;
-use Symfony\Component\Console\Input\InputArgument;
-use Symfony\Component\Console\Input\InputInterface;
-use Symfony\Component\Console\Output\OutputInterface;
-
-class GenerateChangeScript extends Command implements CompletionAwareInterface {
-	protected function configure() {
-		$this
-			->setName('db:generate-change-script')
-			->setDescription('generates the change script from the current connected db to db_structure.xml')
-			->addArgument(
-				'schema-xml',
-				InputArgument::OPTIONAL,
-				'the schema xml to be used as target schema',
-				\OC::$SERVERROOT . '/db_structure.xml'
-			)
-		;
-	}
-
-	protected function execute(InputInterface $input, OutputInterface $output) {
-
-		$file = $input->getArgument('schema-xml');
-
-		$schemaManager = new \OC\DB\MDB2SchemaManager(\OC::$server->getDatabaseConnection());
-
-		try {
-			$result = $schemaManager->updateDbFromStructure($file, true);
-			$output->writeln($result);
-		} catch (\Exception $e) {
-			$output->writeln('Failed to update database structure ('.$e.')');
-		}
-
-	}
-
-	/**
-	 * @param string $optionName
-	 * @param CompletionContext $context
-	 * @return string[]
-	 */
-	public function completeOptionValues($optionName, CompletionContext $context) {
-		return [];
-	}
-
-	/**
-	 * @param string $argumentName
-	 * @param CompletionContext $context
-	 * @return string[]
-	 */
-	public function completeArgumentValues($argumentName, CompletionContext $context) {
-		if ($argumentName === 'schema-xml') {
-			$helper = new ShellPathCompletion(
-				$this->getName(),
-				'schema-xml',
-				Completion::TYPE_ARGUMENT
-			);
-			return $helper->run();
-		}
-		return [];
-	}
-}
diff --git a/core/Command/Db/Migrations/GenerateCommand.php b/core/Command/Db/Migrations/GenerateCommand.php
index e6c38d06e5d..4db82d6eff4 100644
--- a/core/Command/Db/Migrations/GenerateCommand.php
+++ b/core/Command/Db/Migrations/GenerateCommand.php
@@ -36,9 +36,9 @@ use Symfony\Component\Console\Output\OutputInterface;
 
 class GenerateCommand extends Command {
 
-	private static $_templateSimple =
+	protected static $_templateSimple =
 		'<?php
-namespace <namespace>;
+namespace {{<namespace}};
 
 use Doctrine\DBAL\Schema\Schema;
 use OCP\Migration\SimpleMigrationStep;
@@ -47,7 +47,7 @@ use OCP\Migration\IOutput;
 /**
  * Auto-generated migration step: Please modify to your needs!
  */
-class <classname> extends SimpleMigrationStep {
+class {{classname}} extends SimpleMigrationStep {
 
 	/**
 	 * @param IOutput $output
@@ -66,7 +66,7 @@ class <classname> extends SimpleMigrationStep {
 	 * @since 13.0.0
 	 */
 	public function changeSchema(IOutput $output, \Closure $schemaClosure, array $options) {
-		return null;
+{{schemabody}}
 	}
 
 	/**
@@ -81,7 +81,7 @@ class <classname> extends SimpleMigrationStep {
 ';
 
 	/** @var IDBConnection */
-	private $connection;
+	protected $connection;
 
 	/**
 	 * @param IDBConnection $connection
@@ -123,16 +123,24 @@ class <classname> extends SimpleMigrationStep {
 	/**
 	 * @param MigrationService $ms
 	 * @param string $className
+	 * @param string $schemaBody
 	 * @return string
 	 */
-	private function generateMigration(MigrationService $ms, $className) {
+	protected function generateMigration(MigrationService $ms, $className, $schemaBody = '') {
+		if ($schemaBody === '') {
+			$schemaBody = "\t\t" . 'return null;';
+		}
+
+
 		$placeHolders = [
-			'<namespace>',
-			'<classname>',
+			'{{namespace}}',
+			'{{classname}}',
+			'{{schemabody}}',
 		];
 		$replacements = [
 			$ms->getMigrationsNamespace(),
 			$className,
+			$schemaBody,
 		];
 		$code = str_replace($placeHolders, $replacements, self::$_templateSimple);
 		$dir = $ms->getMigrationsDirectory();
@@ -147,7 +155,7 @@ class <classname> extends SimpleMigrationStep {
 		return $path;
 	}
 
-	private function ensureMigrationDirExists($directory) {
+	protected function ensureMigrationDirExists($directory) {
 		if (file_exists($directory) && is_dir($directory)) {
 			return;
 		}
diff --git a/core/Command/Db/Migrations/GenerateFromSchemaFileCommand.php b/core/Command/Db/Migrations/GenerateFromSchemaFileCommand.php
new file mode 100644
index 00000000000..54a4d95738e
--- /dev/null
+++ b/core/Command/Db/Migrations/GenerateFromSchemaFileCommand.php
@@ -0,0 +1,199 @@
+<?php
+/**
+ * @copyright Copyright (c) 2017 Joas Schilling <coding@schilljs.com>
+ *
+ * @author Joas Schilling <coding@schilljs.com>
+ * @author Julius Haertl <jus@bitgrid.net>
+ *
+ * @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 OC\Core\Command\Db\Migrations;
+
+
+use Doctrine\DBAL\Schema\Schema;
+use OC\DB\MDB2SchemaReader;
+use OC\DB\MigrationService;
+use OC\Migration\ConsoleOutput;
+use OCP\App\IAppManager;
+use OCP\IConfig;
+use OCP\IDBConnection;
+use Symfony\Component\Console\Input\InputInterface;
+use Symfony\Component\Console\Output\OutputInterface;
+
+class GenerateFromSchemaFileCommand extends GenerateCommand {
+
+	/** @var IConfig */
+	protected $config;
+
+	/** @var IAppManager */
+	protected $appManager;
+
+	public function __construct(IConfig $config, IAppManager $appManager, IDBConnection $connection) {
+		parent::__construct($connection);
+		$this->config = $config;
+		$this->appManager = $appManager;
+	}
+
+
+	protected function configure() {
+		parent::configure();
+
+		$this->setName('migrations:generate-from-schema');
+	}
+
+	public function execute(InputInterface $input, OutputInterface $output) {
+		$appName = $input->getArgument('app');
+		$version = $input->getArgument('version');
+
+		if (!preg_match('/^\d{1,16}$/',$version)) {
+			$output->writeln('<error>The given version is invalid. Only 0-9 are allowed (max. 16 digits)</error>');
+			return 1;
+		}
+
+		$schemaFile = $this->appManager->getAppPath($appName) . '/appinfo/database.xml';
+		if (!file_exists($schemaFile)) {
+			$output->writeln('<error>App ' . $appName . ' does not have a database.xml file</error>');
+			return 2;
+		}
+
+		$reader = new MDB2SchemaReader($this->config, $this->connection->getDatabasePlatform());
+		$schema = new Schema();
+		$reader->loadSchemaFromFile($schemaFile, $schema);
+
+		$schemaBody = $this->schemaToMigration($schema);
+
+		$ms = new MigrationService($appName, $this->connection, new ConsoleOutput($output));
+
+		$date = date('YmdHis');
+		$path = $this->generateMigration($ms, 'Version' . $version . 'Date' . $date, $schemaBody);
+
+		$output->writeln("New migration class has been generated to <info>$path</info>");
+		return 0;
+	}
+
+	/**
+	 * @param Schema $schema
+	 * @return string
+	 */
+	protected function schemaToMigration(Schema $schema) {
+		$content = <<<'EOT'
+		/** @var Schema $schema */
+		$schema = $schemaClosure();
+
+EOT;
+
+		foreach ($schema->getTables() as $table) {
+			$content .= str_replace('{{table-name}}', substr($table->getName(), 3), <<<'EOT'
+
+		if (!$schema->hasTable('{{table-name}}')) {
+			$table = $schema->createTable('{{table-name}}');
+
+EOT
+			);
+
+			foreach ($table->getColumns() as $column) {
+				$content .= str_replace(['{{name}}', '{{type}}'], [$column->getName(), $column->getType()->getName()], <<<'EOT'
+			$table->addColumn('{{name}}', '{{type}}', [
+
+EOT
+				);
+				if ($column->getAutoincrement()) {
+					$content .= <<<'EOT'
+				'autoincrement' => true,
+
+EOT;
+				}
+				$content .= str_replace('{{notnull}}', $column->getNotnull() ? 'true' : 'false', <<<'EOT'
+				'notnull' => {{notnull}},
+
+EOT
+				);
+				if ($column->getLength() !== null) {
+					$content .= str_replace('{{length}}', $column->getLength(), <<<'EOT'
+				'length' => {{length}},
+
+EOT
+					);
+				}
+				$default = $column->getDefault();
+				if ($default !== null) {
+					$default = is_numeric($default) ? $default : "'$default'";
+					$content .= str_replace('{{default}}', $default, <<<'EOT'
+				'default' => {{default}},
+
+EOT
+					);
+				}
+				$content .= <<<'EOT'
+			]);
+
+EOT;
+			}
+
+			$content .= <<<'EOT'
+
+EOT;
+
+			$primaryKey = $table->getPrimaryKey();
+			if ($primaryKey !== null) {
+				$content .= str_replace('{{columns}}', implode('\', \'', $primaryKey->getUnquotedColumns()), <<<'EOT'
+			$table->setPrimaryKey(['{{columns}}']);
+
+EOT
+				);
+			}
+
+			foreach ($table->getIndexes() as $index) {
+				if ($index->isPrimary()) {
+					continue;
+				}
+
+				if ($index->isUnique()) {
+					$content .= str_replace(
+						['{{columns}}', '{{name}}'],
+						[implode('\', \'', $index->getUnquotedColumns()), $index->getName()],
+						<<<'EOT'
+			$table->addUniqueIndex(['{{columns}}'], '{{name}}');
+
+EOT
+					);
+				} else {
+					$content .= str_replace(
+						['{{columns}}', '{{name}}'],
+						[implode('\', \'', $index->getUnquotedColumns()), $index->getName()],
+						<<<'EOT'
+			$table->addIndex(['{{columns}}'], '{{name}}');
+
+EOT
+					);
+				}
+			}
+
+			$content .= <<<'EOT'
+		}
+
+EOT;
+		}
+
+		$content .= <<<'EOT'
+		return $schema;
+EOT;
+
+		return $content;
+	}
+}
diff --git a/core/Migrations/Version13000Date20170718121200.php b/core/Migrations/Version13000Date20170718121200.php
new file mode 100644
index 00000000000..81743bd203f
--- /dev/null
+++ b/core/Migrations/Version13000Date20170718121200.php
@@ -0,0 +1,897 @@
+<?php
+namespace OC\Core\Migrations;
+
+use Doctrine\DBAL\Schema\Schema;
+use OCP\Migration\SimpleMigrationStep;
+use OCP\Migration\IOutput;
+
+/**
+ * Auto-generated migration step: Please modify to your needs!
+ */
+class Version13000Date20170718121200 extends SimpleMigrationStep {
+
+	/**
+	 * @param IOutput $output
+	 * @param \Closure $schemaClosure The `\Closure` returns a `Schema`
+	 * @param array $options
+	 * @since 13.0.0
+	 */
+	public function preSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
+	}
+
+	/**
+	 * @param IOutput $output
+	 * @param \Closure $schemaClosure The `\Closure` returns a `Schema`
+	 * @param array $options
+	 * @return null|Schema
+	 * @since 13.0.0
+	 */
+	public function changeSchema(IOutput $output, \Closure $schemaClosure, array $options) {
+		/** @var Schema $schema */
+		$schema = $schemaClosure();
+
+		if (!$schema->hasTable('appconfig')) {
+			$table = $schema->createTable('appconfig');
+			$table->addColumn('appid', 'string', [
+				'notnull' => true,
+				'length' => 32,
+				'default' => '',
+			]);
+			$table->addColumn('configkey', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('configvalue', 'text', [
+				'notnull' => false,
+			]);
+			$table->setPrimaryKey(['appid', 'configkey']);
+			$table->addIndex(['configkey'], 'appconfig_config_key_index');
+			$table->addIndex(['appid'], 'appconfig_appid_key');
+		}
+
+		if (!$schema->hasTable('storages')) {
+			$table = $schema->createTable('storages');
+			$table->addColumn('id', 'string', [
+				'notnull' => false,
+				'length' => 64,
+			]);
+			$table->addColumn('numeric_id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('available', 'integer', [
+				'notnull' => true,
+				'default' => 1,
+			]);
+			$table->addColumn('last_checked', 'integer', [
+				'notnull' => false,
+			]);
+			$table->setPrimaryKey(['numeric_id']);
+			$table->addUniqueIndex(['id'], 'storages_id_index');
+		}
+
+		if (!$schema->hasTable('mounts')) {
+			$table = $schema->createTable('mounts');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('storage_id', 'integer', [
+				'notnull' => true,
+			]);
+			$table->addColumn('root_id', 'integer', [
+				'notnull' => true,
+			]);
+			$table->addColumn('user_id', 'string', [
+				'notnull' => true,
+				'length' => 64,
+			]);
+			$table->addColumn('mount_point', 'string', [
+				'notnull' => true,
+				'length' => 4000,
+			]);
+			$table->addColumn('mount_id', 'integer', [
+				'notnull' => false,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addIndex(['user_id'], 'mounts_user_index');
+			$table->addIndex(['storage_id'], 'mounts_storage_index');
+			$table->addIndex(['root_id'], 'mounts_root_index');
+			$table->addIndex(['mount_id'], 'mounts_mount_id_index');
+			$table->addUniqueIndex(['user_id', 'root_id'], 'mounts_user_root_index');
+		}
+
+		if (!$schema->hasTable('mimetypes')) {
+			$table = $schema->createTable('mimetypes');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('mimetype', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addUniqueIndex(['mimetype'], 'mimetype_id_index');
+		}
+
+		if (!$schema->hasTable('filecache')) {
+			$table = $schema->createTable('filecache');
+			$table->addColumn('fileid', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('storage', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('path', 'string', [
+				'notnull' => false,
+				'length' => 4000,
+			]);
+			$table->addColumn('path_hash', 'string', [
+				'notnull' => true,
+				'length' => 32,
+				'default' => '',
+			]);
+			$table->addColumn('parent', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('name', 'string', [
+				'notnull' => false,
+				'length' => 250,
+			]);
+			$table->addColumn('mimetype', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('mimepart', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('size', 'bigint', [
+				'notnull' => true,
+				'length' => 8,
+				'default' => 0,
+			]);
+			$table->addColumn('mtime', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('storage_mtime', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('encrypted', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('unencrypted_size', 'bigint', [
+				'notnull' => true,
+				'length' => 8,
+				'default' => 0,
+			]);
+			$table->addColumn('etag', 'string', [
+				'notnull' => false,
+				'length' => 40,
+			]);
+			$table->addColumn('permissions', 'integer', [
+				'notnull' => false,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('checksum', 'string', [
+				'notnull' => false,
+				'length' => 255,
+			]);
+			$table->setPrimaryKey(['fileid']);
+			$table->addUniqueIndex(['storage', 'path_hash'], 'fs_storage_path_hash');
+			$table->addIndex(['parent', 'name'], 'fs_parent_name_hash');
+			$table->addIndex(['storage', 'mimetype'], 'fs_storage_mimetype');
+			$table->addIndex(['storage', 'mimepart'], 'fs_storage_mimepart');
+			$table->addIndex(['storage', 'size', 'fileid'], 'fs_storage_size');
+		}
+
+		if (!$schema->hasTable('group_user')) {
+			$table = $schema->createTable('group_user');
+			$table->addColumn('gid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('uid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['gid', 'uid']);
+			$table->addIndex(['uid'], 'gu_uid_index');
+		}
+
+		if (!$schema->hasTable('group_admin')) {
+			$table = $schema->createTable('group_admin');
+			$table->addColumn('gid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('uid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['gid', 'uid']);
+			$table->addIndex(['uid'], 'group_admin_uid');
+		}
+
+		if (!$schema->hasTable('groups')) {
+			$table = $schema->createTable('groups');
+			$table->addColumn('gid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['gid']);
+		}
+
+		if (!$schema->hasTable('preferences')) {
+			$table = $schema->createTable('preferences');
+			$table->addColumn('userid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('appid', 'string', [
+				'notnull' => true,
+				'length' => 32,
+				'default' => '',
+			]);
+			$table->addColumn('configkey', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('configvalue', 'text', [
+				'notnull' => false,
+			]);
+			$table->setPrimaryKey(['userid', 'appid', 'configkey']);
+		}
+
+		if (!$schema->hasTable('properties')) {
+			$table = $schema->createTable('properties');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('userid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('propertypath', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('propertyname', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('propertyvalue', 'text', [
+				'notnull' => true,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addIndex(['userid'], 'property_index');
+		}
+
+		if (!$schema->hasTable('share')) {
+			$table = $schema->createTable('share');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('share_type', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->addColumn('share_with', 'string', [
+				'notnull' => false,
+				'length' => 255,
+			]);
+			$table->addColumn('password', 'string', [
+				'notnull' => false,
+				'length' => 255,
+			]);
+			$table->addColumn('uid_owner', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('uid_initiator', 'string', [
+				'notnull' => false,
+				'length' => 64,
+			]);
+			$table->addColumn('parent', 'integer', [
+				'notnull' => false,
+				'length' => 4,
+			]);
+			$table->addColumn('item_type', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('item_source', 'string', [
+				'notnull' => false,
+				'length' => 255,
+			]);
+			$table->addColumn('item_target', 'string', [
+				'notnull' => false,
+				'length' => 255,
+			]);
+			$table->addColumn('file_source', 'integer', [
+				'notnull' => false,
+				'length' => 4,
+			]);
+			$table->addColumn('file_target', 'string', [
+				'notnull' => false,
+				'length' => 512,
+			]);
+			$table->addColumn('permissions', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->addColumn('stime', 'bigint', [
+				'notnull' => true,
+				'length' => 8,
+				'default' => 0,
+			]);
+			$table->addColumn('accepted', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->addColumn('expiration', 'datetime', [
+				'notnull' => false,
+			]);
+			$table->addColumn('token', 'string', [
+				'notnull' => false,
+				'length' => 32,
+			]);
+			$table->addColumn('mail_send', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->addColumn('share_name', 'string', [
+				'notnull' => false,
+				'length' => 64,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addIndex(['item_type', 'share_type'], 'item_share_type_index');
+			$table->addIndex(['file_source'], 'file_source_index');
+			$table->addIndex(['token'], 'token_index');
+		}
+
+		if (!$schema->hasTable('jobs')) {
+			$table = $schema->createTable('jobs');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('class', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('argument', 'string', [
+				'notnull' => true,
+				'length' => 4000,
+				'default' => '',
+			]);
+			$table->addColumn('last_run', 'integer', [
+				'notnull' => false,
+				'default' => 0,
+			]);
+			$table->addColumn('last_checked', 'integer', [
+				'notnull' => false,
+				'default' => 0,
+			]);
+			$table->addColumn('reserved_at', 'integer', [
+				'notnull' => false,
+				'default' => 0,
+			]);
+			$table->addColumn('execution_duration', 'integer', [
+				'notnull' => true,
+				'default' => 0,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addIndex(['class'], 'job_class_index');
+		}
+
+		if (!$schema->hasTable('users')) {
+			$table = $schema->createTable('users');
+			$table->addColumn('uid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('displayname', 'string', [
+				'notnull' => false,
+				'length' => 64,
+			]);
+			$table->addColumn('password', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['uid']);
+		}
+
+		if (!$schema->hasTable('authtoken')) {
+			$table = $schema->createTable('authtoken');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('uid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('login_name', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('password', 'text', [
+				'notnull' => false,
+			]);
+			$table->addColumn('name', 'text', [
+				'notnull' => true,
+				'default' => '',
+			]);
+			$table->addColumn('token', 'string', [
+				'notnull' => true,
+				'length' => 200,
+				'default' => '',
+			]);
+			$table->addColumn('type', 'smallint', [
+				'notnull' => true,
+				'length' => 2,
+				'default' => 0,
+			]);
+			$table->addColumn('remember', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->addColumn('last_activity', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('last_check', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('scope', 'text', [
+				'notnull' => false,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addUniqueIndex(['token'], 'authtoken_token_index');
+			$table->addIndex(['last_activity'], 'authtoken_last_activity_index');
+		}
+
+		if (!$schema->hasTable('bruteforce_attempts')) {
+			$table = $schema->createTable('bruteforce_attempts');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('action', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('occurred', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('ip', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('subnet', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('metadata', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addIndex(['ip'], 'bruteforce_attempts_ip');
+			$table->addIndex(['subnet'], 'bruteforce_attempts_subnet');
+		}
+
+		if (!$schema->hasTable('vcategory')) {
+			$table = $schema->createTable('vcategory');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('uid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('type', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('category', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addIndex(['uid'], 'uid_index');
+			$table->addIndex(['type'], 'type_index');
+			$table->addIndex(['category'], 'category_index');
+		}
+
+		if (!$schema->hasTable('vcategory_to_object')) {
+			$table = $schema->createTable('vcategory_to_object');
+			$table->addColumn('objid', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('categoryid', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('type', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['categoryid', 'objid', 'type']);
+			$table->addIndex(['objid', 'type'], 'vcategory_objectd_index');
+		}
+
+		if (!$schema->hasTable('systemtag')) {
+			$table = $schema->createTable('systemtag');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('name', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('visibility', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 1,
+			]);
+			$table->addColumn('editable', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 1,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addUniqueIndex(['name', 'visibility', 'editable'], 'tag_ident');
+		}
+
+		if (!$schema->hasTable('systemtag_object_mapping')) {
+			$table = $schema->createTable('systemtag_object_mapping');
+			$table->addColumn('objectid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('objecttype', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('systemtagid', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addUniqueIndex(['objecttype', 'objectid', 'systemtagid'], 'mapping');
+		}
+
+		if (!$schema->hasTable('systemtag_group')) {
+			$table = $schema->createTable('systemtag_group');
+			$table->addColumn('systemtagid', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('gid', 'string', [
+				'notnull' => true,
+			]);
+			$table->setPrimaryKey(['gid', 'systemtagid']);
+		}
+
+		if (!$schema->hasTable('file_locks')) {
+			$table = $schema->createTable('file_locks');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('lock', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('key', 'string', [
+				'notnull' => true,
+				'length' => 64,
+			]);
+			$table->addColumn('ttl', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => -1,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addUniqueIndex(['key'], 'lock_key_index');
+			$table->addIndex(['ttl'], 'lock_ttl_index');
+		}
+
+		if (!$schema->hasTable('comments')) {
+			$table = $schema->createTable('comments');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('parent_id', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('topmost_parent_id', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('children_count', 'integer', [
+				'notnull' => true,
+				'length' => 4,
+				'default' => 0,
+			]);
+			$table->addColumn('actor_type', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('actor_id', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('message', 'text', [
+				'notnull' => false,
+			]);
+			$table->addColumn('verb', 'string', [
+				'notnull' => false,
+				'length' => 64,
+			]);
+			$table->addColumn('creation_timestamp', 'datetime', [
+				'notnull' => false,
+			]);
+			$table->addColumn('latest_child_timestamp', 'datetime', [
+				'notnull' => false,
+			]);
+			$table->addColumn('object_type', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('object_id', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addIndex(['parent_id'], 'comments_parent_id_index');
+			$table->addIndex(['topmost_parent_id'], 'comments_topmost_parent_id_idx');
+			$table->addIndex(['object_type', 'object_id', 'creation_timestamp'], 'comments_object_index');
+			$table->addIndex(['actor_type', 'actor_id'], 'comments_actor_index');
+		}
+
+		if (!$schema->hasTable('comments_read_markers')) {
+			$table = $schema->createTable('comments_read_markers');
+			$table->addColumn('user_id', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('marker_datetime', 'datetime', [
+				'notnull' => false,
+			]);
+			$table->addColumn('object_type', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('object_id', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addIndex(['object_type', 'object_id'], 'comments_marker_object_index');
+			$table->addUniqueIndex(['user_id', 'object_type', 'object_id'], 'comments_marker_index');
+		}
+
+		if (!$schema->hasTable('credentials')) {
+			$table = $schema->createTable('credentials');
+			$table->addColumn('user', 'string', [
+				'notnull' => true,
+				'length' => 64,
+			]);
+			$table->addColumn('identifier', 'string', [
+				'notnull' => true,
+				'length' => 64,
+			]);
+			$table->addColumn('credentials', 'text', [
+				'notnull' => false,
+			]);
+			$table->setPrimaryKey(['user', 'identifier']);
+			$table->addIndex(['user'], 'credentials_user');
+		}
+
+		if (!$schema->hasTable('admin_sections')) {
+			$table = $schema->createTable('admin_sections');
+			$table->addColumn('id', 'string', [
+				'notnull' => true,
+				'length' => 64,
+			]);
+			$table->addColumn('class', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('priority', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addUniqueIndex(['class'], 'admin_sections_class');
+		}
+
+		if (!$schema->hasTable('admin_settings')) {
+			$table = $schema->createTable('admin_settings');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('class', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('section', 'string', [
+				'notnull' => false,
+				'length' => 64,
+			]);
+			$table->addColumn('priority', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addUniqueIndex(['class'], 'admin_settings_class');
+			$table->addIndex(['section'], 'admin_settings_section');
+		}
+
+		if (!$schema->hasTable('personal_sections')) {
+			$table = $schema->createTable('personal_sections');
+			$table->addColumn('id', 'string', [
+				'notnull' => true,
+				'length' => 64,
+			]);
+			$table->addColumn('class', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('priority', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addUniqueIndex(['class'], 'personal_sections_class');
+		}
+
+		if (!$schema->hasTable('personal_settings')) {
+			$table = $schema->createTable('personal_settings');
+			$table->addColumn('id', 'integer', [
+				'autoincrement' => true,
+				'notnull' => true,
+				'length' => 4,
+			]);
+			$table->addColumn('class', 'string', [
+				'notnull' => true,
+				'length' => 255,
+				'default' => '',
+			]);
+			$table->addColumn('section', 'string', [
+				'notnull' => false,
+				'length' => 64,
+			]);
+			$table->addColumn('priority', 'smallint', [
+				'notnull' => true,
+				'length' => 1,
+				'default' => 0,
+			]);
+			$table->setPrimaryKey(['id']);
+			$table->addUniqueIndex(['class'], 'personal_settings_class');
+			$table->addIndex(['section'], 'personal_settings_section');
+		}
+
+		if (!$schema->hasTable('accounts')) {
+			$table = $schema->createTable('accounts');
+			$table->addColumn('uid', 'string', [
+				'notnull' => true,
+				'length' => 64,
+				'default' => '',
+			]);
+			$table->addColumn('data', 'text', [
+				'notnull' => true,
+				'default' => '',
+			]);
+			$table->setPrimaryKey(['uid']);
+		}
+		return $schema;
+	}
+
+	/**
+	 * @param IOutput $output
+	 * @param \Closure $schemaClosure The `\Closure` returns a `Schema`
+	 * @param array $options
+	 * @since 13.0.0
+	 */
+	public function postSchemaChange(IOutput $output, \Closure $schemaClosure, array $options) {
+	}
+}
diff --git a/core/register_command.php b/core/register_command.php
index bfb1138c5e3..fd693729a72 100644
--- a/core/register_command.php
+++ b/core/register_command.php
@@ -82,12 +82,12 @@ if (\OC::$server->getConfig()->getSystemValue('installed', false)) {
 	$application->add(new OC\Core\Command\Config\System\GetConfig(\OC::$server->getSystemConfig()));
 	$application->add(new OC\Core\Command\Config\System\SetConfig(\OC::$server->getSystemConfig()));
 
-	$application->add(new OC\Core\Command\Db\GenerateChangeScript());
 	$application->add(new OC\Core\Command\Db\ConvertType(\OC::$server->getConfig(), new \OC\DB\ConnectionFactory(\OC::$server->getSystemConfig())));
 	$application->add(new OC\Core\Command\Db\ConvertMysqlToMB4(\OC::$server->getConfig(), \OC::$server->getDatabaseConnection(), \OC::$server->getURLGenerator(), \OC::$server->getLogger()));
 	$application->add(new OC\Core\Command\Db\Migrations\StatusCommand(\OC::$server->getDatabaseConnection()));
 	$application->add(new OC\Core\Command\Db\Migrations\MigrateCommand(\OC::$server->getDatabaseConnection()));
 	$application->add(new OC\Core\Command\Db\Migrations\GenerateCommand(\OC::$server->getDatabaseConnection()));
+	$application->add(new OC\Core\Command\Db\Migrations\GenerateFromSchemaFileCommand(\OC::$server->getConfig(), \OC::$server->getAppManager(), \OC::$server->getDatabaseConnection()));
 	$application->add(new OC\Core\Command\Db\Migrations\ExecuteCommand(\OC::$server->getDatabaseConnection(), \OC::$server->getConfig()));
 
 	$application->add(new OC\Core\Command\Encryption\Disable(\OC::$server->getConfig()));
diff --git a/db_structure.xml b/db_structure.xml
deleted file mode 100644
index 65bdb69d95d..00000000000
--- a/db_structure.xml
+++ /dev/null
@@ -1,2223 +0,0 @@
-<?xml version="1.0" encoding="utf-8" ?>
-<database>
-
-	<name>*dbname*</name>
-	<create>true</create>
-	<overwrite>false</overwrite>
-
-	<charset>utf8</charset>
-
-	<table>
-
-		<!--
-		Namespaced Key-Value Store for Application Configuration.
-		 - Keys are namespaced per appid.
-		 - E.g. (core, global_cache_gc_lastrun) -> 1385463286
-		-->
-		<name>*dbprefix*appconfig</name>
-
-		<declaration>
-
-			<field>
-				<name>appid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>32</length>
-			</field>
-
-			<field>
-				<name>configkey</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>configvalue</name>
-				<type>clob</type>
-				<notnull>false</notnull>
-			</field>
-
-			<index>
-				<name>appconfig_appid_key_index</name>
-				<primary>true</primary>
-				<unique>true</unique>
-				<field>
-					<name>appid</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>configkey</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-			<index>
-				<name>appconfig_config_key_index</name>
-				<field>
-					<name>configkey</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-			<index>
-				<name>appconfig_appid_key</name>
-				<field>
-					<name>appid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Bidirectional Map for Storage Names and Storage Ids.
-		 - Assigns each storage name a unique storage id integer.
-		 - Long storage names are hashed.
-		 - E.g.                     local::/tmp/ <-> 2
-		 - E.g. b5db994aa8c6625100e418406c798269 <-> 27
-		-->
-		<name>*dbprefix*storages</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>numeric_id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>available</name>
-				<type>integer</type>
-				<default>1</default>
-				<notnull>true</notnull>
-			</field>
-
-			<field>
-				<name>last_checked</name>
-				<type>integer</type>
-			</field>
-
-			<index>
-				<name>storages_id_index</name>
-				<unique>true</unique>
-				<field>
-					<name>id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<!-- a list of all mounted storage per user, populated on filesystem setup -->
-	<table>
-
-		<name>*dbprefix*mounts</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>storage_id</name>
-				<type>integer</type>
-				<notnull>true</notnull>
-			</field>
-
-			<!-- fileid of the root of the mount, foreign key: oc_filecache.fileid -->
-			<field>
-				<name>root_id</name>
-				<type>integer</type>
-				<notnull>true</notnull>
-			</field>
-
-			<field>
-				<name>user_id</name>
-				<type>text</type>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>mount_point</name>
-				<type>text</type>
-				<notnull>true</notnull>
-				<length>4000</length>
-			</field>
-
-			<field>
-				<name>mount_id</name>
-				<type>integer</type>
-			</field>
-
-			<index>
-				<name>mounts_user_index</name>
-				<unique>false</unique>
-				<field>
-					<name>user_id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>mounts_storage_index</name>
-				<unique>false</unique>
-				<field>
-					<name>storage_id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>mounts_root_index</name>
-				<unique>false</unique>
-				<field>
-					<name>root_id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>mounts_mount_id_index</name>
-				<unique>false</unique>
-				<field>
-					<name>mount_id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>mounts_user_root_index</name>
-				<unique>true</unique>
-				<field>
-					<name>user_id</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>root_id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Bidirectional Map for Mimetypes and Mimetype Id
-		 - Assigns each mimetype (and supertype) a unique mimetype id integer.
-		 - E.g.     application <-> 5
-		 - E.g. application/pdf <-> 6
-		-->
-		<name>*dbprefix*mimetypes</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>mimetype</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<index>
-				<name>mimetype_id_index</name>
-				<unique>true</unique>
-				<field>
-					<name>mimetype</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Main file table containing one row for each directory and file.
-		 - Assigns a unique integer fileid to each file (and directory)
-		 - Assigns an etag to each file (and directory)
-		 - Caches various file/dir properties such as:
-		  - path (filename, e.g. files/combinatoricslib-2.0_doc.zip)
-		  - path_hash = md5(path)
-		  - name (basename, e.g. combinatoricslib-2.0_doc.zip)
-		  - size (for directories this is the sum of all contained file sizes)
-		-->
-		<name>*dbprefix*filecache</name>
-
-		<declaration>
-
-			<field>
-				<name>fileid</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<length>4</length>
-			</field>
-
-			<!-- Foreign Key storages::numeric_id -->
-			<field>
-				<name>storage</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>path</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>4000</length>
-			</field>
-
-			<field>
-				<name>path_hash</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>32</length>
-			</field>
-
-			<!-- Foreign Key filecache::fileid -->
-			<field>
-				<name>parent</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>name</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>250</length>
-			</field>
-
-			<!-- Foreign Key mimetypes::id -->
-			<field>
-				<name>mimetype</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<!-- Foreign Key mimetypes::id -->
-			<field>
-				<name>mimepart</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>size</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>8</length>
-			</field>
-
-			<field>
-				<name>mtime</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>storage_mtime</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>encrypted</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-            <field>
-                <name>unencrypted_size</name>
-                <type>integer</type>
-                <default>0</default>
-                <notnull>true</notnull>
-                <length>8</length>
-            </field>
-
-			<field>
-				<name>etag</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>40</length>
-			</field>
-
-            <field>
-                <name>permissions</name>
-                <type>integer</type>
-                <default>0</default>
-                <notnull>false</notnull>
-                <length>4</length>
-            </field>
-
-			<field>
-				<name>checksum</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>255</length>
-			</field>
-
-
-            <index>
-				<name>fs_storage_path_hash</name>
-				<unique>true</unique>
-				<field>
-					<name>storage</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>path_hash</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>fs_parent_name_hash</name>
-				<field>
-					<name>parent</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>name</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>fs_storage_mimetype</name>
-				<field>
-					<name>storage</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>mimetype</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>fs_storage_mimepart</name>
-				<field>
-					<name>storage</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>mimepart</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>fs_storage_size</name>
-				<field>
-					<name>storage</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>size</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>fileid</name>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Stores which groups have which users as members in an n:m relationship.
-		 - Maps group id (gid) to a set of users (uid)
-		 - Maps user id (uid) to a set of groups (gid) (but without index)
-		-->
-		<name>*dbprefix*group_user</name>
-
-		<declaration>
-
-			<!-- Foreign Key groups::gid -->
-			<field>
-				<name>gid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<!-- Foreign Key users::uid -->
-			<field>
-				<name>uid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<index>
-				<name>gu_gid_uid_index</name>
-				<primary>true</primary>
-				<unique>true</unique>
-				<field>
-					<name>gid</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>uid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>gu_uid_index</name>
-				<field>
-					<name>uid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Stores which groups have which users as admins in an n:m relationship.
-		 - Maps group id (gid) to a set of users (uid)
-		 - Maps user id (uid) to a set of groups (gid)
-
-		NOTE: This could (very likely) be reduced to a single bit in group_user
-		      instead of repeating varchars gid and uid here
-		-->
-		<name>*dbprefix*group_admin</name>
-
-		<declaration>
-
-			<!-- Foreign Key groups::gid -->
-			<field>
-				<name>gid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<!-- Foreign Key users::uid -->
-			<field>
-				<name>uid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-			<index>
-				<name>group_admin_uid</name>
-				<field>
-					<name>uid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>ga_gid_uid_index</name>
-				<primary>true</primary>
-				<unique>true</unique>
-				<field>
-					<name>gid</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>uid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		A simple list of groups.
-		-->
-		<name>*dbprefix*groups</name>
-
-		<declaration>
-
-			<field>
-				<name>gid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<index>
-				<name>groups_pKey</name>
-				<primary>true</primary>
-				<field>
-					<name>gid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Namespaced Key-Value Store for User Preferences
-		 - Keys are namespaced per userid and appid.
-		 - E.g. (admin, files, cache_version) -> 5
-		-->
-		<name>*dbprefix*preferences</name>
-
-		<declaration>
-
-			<!-- Foreign Key users::uid -->
-			<field>
-				<name>userid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>appid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>32</length>
-			</field>
-
-			<field>
-				<name>configkey</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>configvalue</name>
-				<type>clob</type>
-				<notnull>false</notnull>
-			</field>
-
-			<index>
-				<name>pref_userid_appid_key_index</name>
-				<primary>true</primary>
-				<unique>true</unique>
-				<field>
-					<name>userid</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>appid</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>configkey</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		WebDAV properties.
-		-->
-		<name>*dbprefix*properties</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<autoincrement>1</autoincrement>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<!-- Foreign Key users::uid -->
-			<field>
-				<name>userid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>propertypath</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<field>
-				<name>propertyname</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<field>
-				<name>propertyvalue</name>
-				<type>clob</type>
-				<notnull>true</notnull>
-			</field>
-
-			<index>
-				<name>property_index</name>
-				<field>
-					<name>userid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Shares of all types (user-to-user, external-via-link, etc.)
-		-->
-		<name>*dbprefix*share</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<autoincrement>1</autoincrement>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<!-- Constant OCP\Share::SHARE_TYPE_* -->
-			<field>
-				<name>share_type</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<!-- Foreign Key users::uid or NULL -->
-			<field>
-				<name>share_with</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>255</length>
-			</field>
-			<field>
-				<name>password</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>255</length>
-			</field>
-
-			<!-- Foreign Key users::uid -->
-            <!-- This is the owner of the share
-                 which does not have to be the initiator of the share -->
-			<field>
-				<name>uid_owner</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<!-- Foreign Key users::uid -->
-            <!-- This is the initiator of the share -->
-			<field>
-				<name>uid_initiator</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-
-
-			<!-- Foreign Key share::id or NULL -->
-			<field>
-				<name>parent</name>
-				<type>integer</type>
-				<notnull>false</notnull>
-				<length>4</length>
-			</field>
-
-			<!-- E.g. file or folder -->
-			<field>
-				<name>item_type</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<!-- Foreign Key filecache::fileid -->
-			<field>
-				<name>item_source</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>255</length>
-			</field>
-
-			<field>
-				<name>item_target</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>255</length>
-			</field>
-
-			<!-- Foreign Key filecache::fileid -->
-			<field>
-				<name>file_source</name>
-				<type>integer</type>
-				<notnull>false</notnull>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>file_target</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>512</length>
-			</field>
-
-			<!-- Permission bitfield -->
-			<field>
-				<name>permissions</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<!-- Time of share creation -->
-			<field>
-				<name>stime</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>8</length>
-			</field>
-
-			<!-- Whether the receiver accepted the share, if share_with is set. -->
-			<field>
-				<name>accepted</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<!-- Time of share expiration -->
-			<field>
-				<name>expiration</name>
-				<type>timestamp</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<name>token</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>32</length>
-			</field>
-
-			<field>
-				<name>mail_send</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<field>
-				<name>share_name</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-			<index>
-				<name>item_share_type_index</name>
-				<field>
-					<name>item_type</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>share_type</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-			<index>
-				<name>file_source_index</name>
-				<field>
-					<name>file_source</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-			<index>
-				<name>token_index</name>
-				<field>
-					<name>token</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Scheduled background jobs.
-		See OC\BackgroundJob\JobList.
-		-->
-		<name>*dbprefix*jobs</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>class</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<field>
-				<name>argument</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>4000</length>
-			</field>
-
-			<field>
-				<!-- timestamp when the job was executed the last time -->
-				<name>last_run</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<!-- timestamp when the job was checked if it needs execution the last time -->
-				<name>last_checked</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<!-- timestamp when the job was reserved the last time, 1 day timeout -->
-				<name>reserved_at</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<!-- time for execution of the job -->
-				<name>execution_duration</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-			</field>
-
-			<index>
-				<name>job_class_index</name>
-				<field>
-					<name>class</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		List of usernames, their display name and login password.
-		-->
-		<name>*dbprefix*users</name>
-
-		<declaration>
-
-			<field>
-				<name>uid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>displayname</name>
-				<type>text</type>
-				<default></default>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>password</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<index>
-				<name>users_pKey</name>
-				<primary>true</primary>
-				<field>
-					<name>uid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-		<name>*dbprefix*authtoken</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<!-- Foreign Key users::uid -->
-			<field>
-				<name>uid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>login_name</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>password</name>
-				<type>clob</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<name>name</name>
-				<type>clob</type>
-				<default></default>
-				<notnull>true</notnull>
-			</field>
-
-			<field>
-				<name>token</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>200</length>
-			</field>
-
-			<field>
-				<name>type</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>2</length>
-			</field>
-
-			<field>
-				<name>remember</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>1</length>
-			</field>
-
-			<field>
-				<name>last_activity</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>last_check</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>scope</name>
-				<type>clob</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<index>
-				<name>authtoken_token_index</name>
-				<unique>true</unique>
-				<field>
-					<name>token</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>authtoken_last_activity_index</name>
-				<field>
-					<name>last_activity</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-	</table>
-
-	<table>
-
-		<!--
-		List of usernames, their display name and login password.
-		-->
-		<name>*dbprefix*bruteforce_attempts</name>
-
-		<declaration>
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>action</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>occurred</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>ip</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<field>
-				<name>subnet</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<field>
-				<name>metadata</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<index>
-				<name>bruteforce_attempts_ip</name>
-				<field>
-					<name>ip</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-			<index>
-				<name>bruteforce_attempts_subnet</name>
-				<field>
-					<name>subnet</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		List of tags (category) + a unique tag id (id) per user (uid) and type.
-		-->
-		<name>*dbprefix*vcategory</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<!-- Foreign Key users::uid -->
-			<field>
-				<name>uid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>type</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>category</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<index>
-				<name>uid_index</name>
-				<field>
-					<name>uid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>type_index</name>
-				<field>
-					<name>type</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>category_index</name>
-				<field>
-					<name>category</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-	</table>
-
-	<table>
-
-		<!--
-		Object-Tag associations per tag type.
-		-->
-		<name>*dbprefix*vcategory_to_object</name>
-
-		<declaration>
-
-		<field>
-			<name>objid</name>
-			<type>integer</type>
-			<default>0</default>
-			<notnull>true</notnull>
-			<unsigned>true</unsigned>
-			<length>4</length>
-		</field>
-
-		<!-- Foreign Key vcategory::id -->
-		<field>
-			<name>categoryid</name>
-			<type>integer</type>
-			<default>0</default>
-			<notnull>true</notnull>
-			<unsigned>true</unsigned>
-			<length>4</length>
-		</field>
-
-		<field>
-			<name>type</name>
-			<type>text</type>
-			<default></default>
-			<notnull>true</notnull>
-			<length>64</length>
-		</field>
-
-		<index>
-			<primary>true</primary>
-			<unique>true</unique>
-			<name>category_object_index</name>
-			<field>
-				<name>categoryid</name>
-				<sorting>ascending</sorting>
-			</field>
-			<field>
-				<name>objid</name>
-				<sorting>ascending</sorting>
-			</field>
-			<field>
-				<name>type</name>
-				<sorting>ascending</sorting>
-			</field>
-		</index>
-
-		<index>
-			<name>vcategory_objectd_index</name>
-			<field>
-				<name>objid</name>
-				<sorting>ascending</sorting>
-			</field>
-			<field>
-				<name>type</name>
-				<sorting>ascending</sorting>
-			</field>
-		</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-		<!--
-		List of system-wide tags
-		-->
-		<name>*dbprefix*systemtag</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<!-- Tag name -->
-			<field>
-				<name>name</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<!-- Visibility: 0 user-not-visible, 1 user-visible -->
-			<field>
-				<name>visibility</name>
-				<type>integer</type>
-				<default>1</default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<!-- Editable: 0 user-not-editable, 1 user-editable -->
-			<field>
-				<name>editable</name>
-				<type>integer</type>
-				<default>1</default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<index>
-				<name>tag_ident</name>
-				<unique>true</unique>
-				<field>
-					<name>name</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>visibility</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>editable</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-	</table>
-
-	<table>
-
-		<!--
-		System tag to object associations per object type.
-		-->
-		<name>*dbprefix*systemtag_object_mapping</name>
-
-		<declaration>
-
-		<!-- object id (ex: file id for files)-->
-		<field>
-			<name>objectid</name>
-			<type>text</type>
-			<default></default>
-			<notnull>true</notnull>
-			<length>64</length>
-		</field>
-
-		<!-- object type (ex: "files")-->
-		<field>
-			<name>objecttype</name>
-			<type>text</type>
-			<default></default>
-			<notnull>true</notnull>
-			<length>64</length>
-		</field>
-
-		<!-- Foreign Key systemtag::id -->
-		<field>
-			<name>systemtagid</name>
-			<type>integer</type>
-			<default>0</default>
-			<notnull>true</notnull>
-			<unsigned>true</unsigned>
-			<length>4</length>
-		</field>
-
-		<index>
-			<unique>true</unique>
-			<name>mapping</name>
-			<field>
-				<name>objecttype</name>
-				<sorting>ascending</sorting>
-			</field>
-			<field>
-				<name>objectid</name>
-				<sorting>ascending</sorting>
-			</field>
-			<field>
-				<name>systemtagid</name>
-				<sorting>ascending</sorting>
-			</field>
-		</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		System tag to group mapping
-		-->
-		<name>*dbprefix*systemtag_group</name>
-
-		<declaration>
-
-		<!-- Foreign Key systemtag::id -->
-		<field>
-			<name>systemtagid</name>
-			<type>integer</type>
-			<default>0</default>
-			<notnull>true</notnull>
-			<unsigned>true</unsigned>
-			<length>4</length>
-		</field>
-
-		<field>
-			<name>gid</name>
-			<type>string</type>
-			<notnull>true</notnull>
-		</field>
-
-		<index>
-			<name>systemtag_group</name>
-			<primary>true</primary>
-			<unique>true</unique>
-			<field>
-				<name>gid</name>
-				<sorting>ascending</sorting>
-			</field>
-			<field>
-				<name>systemtagid</name>
-				<sorting>ascending</sorting>
-			</field>
-		</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-
-		<!--
-		Table for storing transactional file locking
-		-->
-		<name>*dbprefix*file_locks</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>4</length>
-				<autoincrement>1</autoincrement>
-			</field>
-
-			<field>
-				<name>lock</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>key</name>
-				<type>text</type>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>ttl</name>
-				<type>integer</type>
-				<default>-1</default>
-				<notnull>true</notnull>
-				<length>4</length>
-			</field>
-
-			<index>
-				<primary>true</primary>
-				<unique>true</unique>
-				<name>lock_id_index</name>
-				<field>
-					<name>id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<unique>true</unique>
-				<name>lock_key_index</name>
-				<field>
-					<name>key</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>lock_ttl_index</name>
-				<field>
-					<name>ttl</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-		<!--
-		default place to store comment data
-		-->
-		<name>*dbprefix*comments</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>4</length>
-				<autoincrement>1</autoincrement>
-			</field>
-
-			<field>
-				<name>parent_id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>topmost_parent_id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>children_count</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<unsigned>true</unsigned>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>actor_type</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>actor_id</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>message</name>
-				<type>clob</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<name>verb</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>creation_timestamp</name>
-				<type>timestamp</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<name>latest_child_timestamp</name>
-				<type>timestamp</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<name>object_type</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>object_id</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<index>
-				<name>comments_parent_id_index</name>
-				<unique>false</unique>
-				<field>
-					<name>parent_id</name>
-					<sorting>descending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>comments_topmost_parent_id_idx</name>
-				<unique>false</unique>
-				<field>
-					<name>topmost_parent_id</name>
-					<sorting>descending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>comments_object_index</name>
-				<unique>false</unique>
-				<field>
-					<name>object_type</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>object_id</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>creation_timestamp</name>
-					<sorting>descending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>comments_actor_index</name>
-				<unique>false</unique>
-				<field>
-					<name>actor_type</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>actor_id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-		<!--
-		default place to store per user and object read markers
-		-->
-		<name>*dbprefix*comments_read_markers</name>
-
-		<declaration>
-
-			<field>
-				<name>user_id</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>marker_datetime</name>
-				<type>timestamp</type>
-				<default></default>
-				<notnull>false</notnull>
-			</field>
-
-			<field>
-				<name>object_type</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>object_id</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<index>
-				<name>comments_marker_object_index</name>
-				<unique>false</unique>
-				<field>
-					<name>object_type</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>object_id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>comments_marker_index</name>
-				<unique>true</unique>
-				<field>
-					<name>user_id</name>
-					<sorting>descending</sorting>
-				</field>
-				<field>
-					<name>object_type</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>object_id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-		<!--
-		Encrypted credentials storage
-		-->
-		<name>*dbprefix*credentials</name>
-
-		<declaration>
-
-			<field>
-				<name>user</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>identifier</name>
-				<type>text</type>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>credentials</name>
-				<type>clob</type>
-				<notnull>false</notnull>
-			</field>
-
-			<index>
-				<name>credentials_user_id</name>
-				<primary>true</primary>
-				<unique>true</unique>
-				<field>
-					<name>user</name>
-					<sorting>ascending</sorting>
-				</field>
-				<field>
-					<name>identifier</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>credentials_user</name>
-				<unique>false</unique>
-				<field>
-					<name>user</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-
-	</table>
-
-	<table>
-		<!-- Extra admin settings sections -->
-		<name>*dbprefix*admin_sections</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>class</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<field>
-				<name>priority</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<index>
-				<name>admin_sections_id_index</name>
-				<primary>true</primary>
-				<field>
-					<name>id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>admin_sections_class</name>
-				<unique>true</unique>
-				<field>
-					<name>class</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-	</table>
-
-	<table>
-		<!-- Extra admin settings -->
-		<name>*dbprefix*admin_settings</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>class</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<!-- id of the section, foreign key: admin_sections.id -->
-			<field>
-				<name>section</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>priority</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<index>
-				<name>admin_settings_id_index</name>
-				<primary>true</primary>
-				<field>
-					<name>id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>admin_settings_class</name>
-				<unique>true</unique>
-				<field>
-					<name>class</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>admin_settings_section</name>
-				<unique>false</unique>
-				<field>
-					<name>section</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-	</table>
-
-	<table>
-		<!-- Extra personal settings sections -->
-		<name>*dbprefix*personal_sections</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>class</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<field>
-				<name>priority</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<index>
-				<name>personal_sections_id_index</name>
-				<primary>true</primary>
-				<field>
-					<name>id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>personal_sections_class</name>
-				<unique>true</unique>
-				<field>
-					<name>class</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-	</table>
-
-	<table>
-		<!-- Extra personal settings -->
-		<name>*dbprefix*personal_settings</name>
-
-		<declaration>
-
-			<field>
-				<name>id</name>
-				<type>integer</type>
-				<default>0</default>
-				<notnull>true</notnull>
-				<autoincrement>1</autoincrement>
-				<length>4</length>
-			</field>
-
-			<field>
-				<name>class</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>255</length>
-			</field>
-
-			<!-- id of the section, foreign key: admin_sections.id -->
-			<field>
-				<name>section</name>
-				<type>text</type>
-				<default></default>
-				<notnull>false</notnull>
-				<length>64</length>
-			</field>
-
-			<field>
-				<name>priority</name>
-				<type>integer</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>1</length>
-			</field>
-
-			<index>
-				<name>personal_settings_id_index</name>
-				<primary>true</primary>
-				<field>
-					<name>id</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>personal_settings_class</name>
-				<unique>true</unique>
-				<field>
-					<name>class</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-			<index>
-				<name>personal_settings_section</name>
-				<unique>false</unique>
-				<field>
-					<name>section</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-	</table>
-
-	<table>
-
-		<name>*dbprefix*accounts</name>
-
-		<declaration>
-			<field>
-				<name>uid</name>
-				<type>text</type>
-				<default></default>
-				<notnull>true</notnull>
-				<length>64</length>
-			</field>
-			<field>
-				<name>data</name>
-				<type>clob</type>
-				<default></default>
-				<notnull>true</notnull>
-			</field>
-
-			<index>
-				<name>uid_index</name>
-				<primary>true</primary>
-				<unique>true</unique>
-				<field>
-					<name>uid</name>
-					<sorting>ascending</sorting>
-				</field>
-			</index>
-
-		</declaration>
-	</table>
-
-</database>
diff --git a/lib/composer/composer/autoload_classmap.php b/lib/composer/composer/autoload_classmap.php
index 749b3949f68..09231824703 100644
--- a/lib/composer/composer/autoload_classmap.php
+++ b/lib/composer/composer/autoload_classmap.php
@@ -423,9 +423,9 @@ return array(
     'OC\\Core\\Command\\Config\\System\\SetConfig' => $baseDir . '/core/Command/Config/System/SetConfig.php',
     'OC\\Core\\Command\\Db\\ConvertMysqlToMB4' => $baseDir . '/core/Command/Db/ConvertMysqlToMB4.php',
     'OC\\Core\\Command\\Db\\ConvertType' => $baseDir . '/core/Command/Db/ConvertType.php',
-    'OC\\Core\\Command\\Db\\GenerateChangeScript' => $baseDir . '/core/Command/Db/GenerateChangeScript.php',
     'OC\\Core\\Command\\Db\\Migrations\\ExecuteCommand' => $baseDir . '/core/Command/Db/Migrations/ExecuteCommand.php',
     'OC\\Core\\Command\\Db\\Migrations\\GenerateCommand' => $baseDir . '/core/Command/Db/Migrations/GenerateCommand.php',
+    'OC\\Core\\Command\\Db\\Migrations\\GenerateFromSchemaFileCommand' => $baseDir . '/core/Command/Db/Migrations/GenerateFromSchemaFileCommand.php',
     'OC\\Core\\Command\\Db\\Migrations\\MigrateCommand' => $baseDir . '/core/Command/Db/Migrations/MigrateCommand.php',
     'OC\\Core\\Command\\Db\\Migrations\\StatusCommand' => $baseDir . '/core/Command/Db/Migrations/StatusCommand.php',
     'OC\\Core\\Command\\Encryption\\ChangeKeyStorageRoot' => $baseDir . '/core/Command/Encryption/ChangeKeyStorageRoot.php',
@@ -489,6 +489,7 @@ return array(
     'OC\\Core\\Controller\\UserController' => $baseDir . '/core/Controller/UserController.php',
     'OC\\Core\\Middleware\\TwoFactorMiddleware' => $baseDir . '/core/Middleware/TwoFactorMiddleware.php',
     'OC\\Core\\Migrations\\Version13000Date20170705121758' => $baseDir . '/core/Migrations/Version13000Date20170705121758.php',
+    'OC\\Core\\Migrations\\Version13000Date20170718121200' => $baseDir . '/core/Migrations/Version13000Date20170718121200.php',
     'OC\\DB\\Adapter' => $baseDir . '/lib/private/DB/Adapter.php',
     'OC\\DB\\AdapterMySQL' => $baseDir . '/lib/private/DB/AdapterMySQL.php',
     'OC\\DB\\AdapterOCI8' => $baseDir . '/lib/private/DB/AdapterOCI8.php',
diff --git a/lib/composer/composer/autoload_static.php b/lib/composer/composer/autoload_static.php
index d92045f6c53..8f23eb53ecf 100644
--- a/lib/composer/composer/autoload_static.php
+++ b/lib/composer/composer/autoload_static.php
@@ -453,9 +453,9 @@ class ComposerStaticInit53792487c5a8370acc0b06b1a864ff4c
         'OC\\Core\\Command\\Config\\System\\SetConfig' => __DIR__ . '/../../..' . '/core/Command/Config/System/SetConfig.php',
         'OC\\Core\\Command\\Db\\ConvertMysqlToMB4' => __DIR__ . '/../../..' . '/core/Command/Db/ConvertMysqlToMB4.php',
         'OC\\Core\\Command\\Db\\ConvertType' => __DIR__ . '/../../..' . '/core/Command/Db/ConvertType.php',
-        'OC\\Core\\Command\\Db\\GenerateChangeScript' => __DIR__ . '/../../..' . '/core/Command/Db/GenerateChangeScript.php',
         'OC\\Core\\Command\\Db\\Migrations\\ExecuteCommand' => __DIR__ . '/../../..' . '/core/Command/Db/Migrations/ExecuteCommand.php',
         'OC\\Core\\Command\\Db\\Migrations\\GenerateCommand' => __DIR__ . '/../../..' . '/core/Command/Db/Migrations/GenerateCommand.php',
+        'OC\\Core\\Command\\Db\\Migrations\\GenerateFromSchemaFileCommand' => __DIR__ . '/../../..' . '/core/Command/Db/Migrations/GenerateFromSchemaFileCommand.php',
         'OC\\Core\\Command\\Db\\Migrations\\MigrateCommand' => __DIR__ . '/../../..' . '/core/Command/Db/Migrations/MigrateCommand.php',
         'OC\\Core\\Command\\Db\\Migrations\\StatusCommand' => __DIR__ . '/../../..' . '/core/Command/Db/Migrations/StatusCommand.php',
         'OC\\Core\\Command\\Encryption\\ChangeKeyStorageRoot' => __DIR__ . '/../../..' . '/core/Command/Encryption/ChangeKeyStorageRoot.php',
@@ -519,6 +519,7 @@ class ComposerStaticInit53792487c5a8370acc0b06b1a864ff4c
         'OC\\Core\\Controller\\UserController' => __DIR__ . '/../../..' . '/core/Controller/UserController.php',
         'OC\\Core\\Middleware\\TwoFactorMiddleware' => __DIR__ . '/../../..' . '/core/Middleware/TwoFactorMiddleware.php',
         'OC\\Core\\Migrations\\Version13000Date20170705121758' => __DIR__ . '/../../..' . '/core/Migrations/Version13000Date20170705121758.php',
+        'OC\\Core\\Migrations\\Version13000Date20170718121200' => __DIR__ . '/../../..' . '/core/Migrations/Version13000Date20170718121200.php',
         'OC\\DB\\Adapter' => __DIR__ . '/../../..' . '/lib/private/DB/Adapter.php',
         'OC\\DB\\AdapterMySQL' => __DIR__ . '/../../..' . '/lib/private/DB/AdapterMySQL.php',
         'OC\\DB\\AdapterOCI8' => __DIR__ . '/../../..' . '/lib/private/DB/AdapterOCI8.php',
diff --git a/lib/private/DB/MigrationService.php b/lib/private/DB/MigrationService.php
index 92041b5e324..45f6aee83f6 100644
--- a/lib/private/DB/MigrationService.php
+++ b/lib/private/DB/MigrationService.php
@@ -284,7 +284,8 @@ class MigrationService {
 			case 'latest':
 				$this->ensureMigrationsAreLoaded();
 
-				return @end($this->getAvailableVersions());
+				$migrations = $this->getAvailableVersions();
+				return @end($migrations);
 		}
 		return '0';
 	}
@@ -316,7 +317,8 @@ class MigrationService {
 		if (count($m) === 0) {
 			return '0';
 		}
-		return @end(array_values($m));
+		$migrations = array_values($m);
+		return @end($migrations);
 	}
 
 	/**
diff --git a/lib/private/DB/SchemaWrapper.php b/lib/private/DB/SchemaWrapper.php
index 0be45d8d3f7..d686d7e63e5 100644
--- a/lib/private/DB/SchemaWrapper.php
+++ b/lib/private/DB/SchemaWrapper.php
@@ -34,7 +34,7 @@ class SchemaWrapper {
 	protected $schema;
 
 	/** @var array */
-	protected $tablesToDelete;
+	protected $tablesToDelete = [];
 
 	/**
 	 * @param IDBConnection $connection
diff --git a/lib/private/Setup.php b/lib/private/Setup.php
index 5cd3c84ce92..f5bfca604a9 100644
--- a/lib/private/Setup.php
+++ b/lib/private/Setup.php
@@ -282,8 +282,7 @@ class Setup {
 
 		$class = self::$dbSetupClasses[$dbType];
 		/** @var \OC\Setup\AbstractDatabase $dbSetup */
-		$dbSetup = new $class($l, 'db_structure.xml', $this->config,
-			$this->logger, $this->random);
+		$dbSetup = new $class($l, $this->config, $this->logger, $this->random);
 		$error = array_merge($error, $dbSetup->validate($options));
 
 		// validate the data directory
diff --git a/lib/private/Setup/AbstractDatabase.php b/lib/private/Setup/AbstractDatabase.php
index 2fbec326a5d..0e0981e0771 100644
--- a/lib/private/Setup/AbstractDatabase.php
+++ b/lib/private/Setup/AbstractDatabase.php
@@ -38,8 +38,6 @@ abstract class AbstractDatabase {
 	/** @var IL10N */
 	protected $trans;
 	/** @var string */
-	protected $dbDefinitionFile;
-	/** @var string */
 	protected $dbUser;
 	/** @var string */
 	protected $dbPassword;
@@ -58,9 +56,8 @@ abstract class AbstractDatabase {
 	/** @var ISecureRandom */
 	protected $random;
 
-	public function __construct(IL10N $trans, $dbDefinitionFile, SystemConfig $config, ILogger $logger, ISecureRandom $random) {
+	public function __construct(IL10N $trans, SystemConfig $config, ILogger $logger, ISecureRandom $random) {
 		$this->trans = $trans;
-		$this->dbDefinitionFile = $dbDefinitionFile;
 		$this->config = $config;
 		$this->logger = $logger;
 		$this->random = $random;
diff --git a/lib/private/Setup/MySQL.php b/lib/private/Setup/MySQL.php
index b4ca02d2e84..d03e4858b61 100644
--- a/lib/private/Setup/MySQL.php
+++ b/lib/private/Setup/MySQL.php
@@ -51,11 +51,7 @@ class MySQL extends AbstractDatabase {
 
 		//fill the database if needed
 		$query='select count(*) from information_schema.tables where table_schema=? AND table_name = ?';
-		$result = $connection->executeQuery($query, [$this->dbName, $this->tablePrefix.'users']);
-		$row = $result->fetch();
-		if (!$row or $row['count(*)'] === '0') {
-			\OC_DB::createDbFromStructure($this->dbDefinitionFile);
-		}
+		$connection->executeQuery($query, [$this->dbName, $this->tablePrefix.'users']);
 	}
 
 	/**
diff --git a/lib/private/Setup/OCI.php b/lib/private/Setup/OCI.php
index 1bc6b08117f..3051987917c 100644
--- a/lib/private/Setup/OCI.php
+++ b/lib/private/Setup/OCI.php
@@ -165,14 +165,7 @@ class OCI extends AbstractDatabase {
 			$entry .= $this->trans->t('Offending command was: "%s"', array($query)) . '<br />';
 			$this->logger->warning( $entry, ['app' => 'setup.oci']);
 		}
-		$result = oci_execute($stmt);
-
-		if($result) {
-			$row = oci_fetch_row($stmt);
-		}
-		if(!$result or $row[0]==0) {
-			\OC_DB::createDbFromStructure($this->dbDefinitionFile);
-		}
+		oci_execute($stmt);
 	}
 
 	/**
diff --git a/lib/private/Setup/PostgreSQL.php b/lib/private/Setup/PostgreSQL.php
index 8267b065142..dbcb94d6d7f 100644
--- a/lib/private/Setup/PostgreSQL.php
+++ b/lib/private/Setup/PostgreSQL.php
@@ -105,11 +105,6 @@ class PostgreSQL extends AbstractDatabase {
 			throw new \OC\DatabaseSetupException($this->trans->t('PostgreSQL username and/or password not valid'),
 				$this->trans->t('You need to enter details of an existing account.'));
 		}
-
-
-		if (!$tablesSetup) {
-			\OC_DB::createDbFromStructure($this->dbDefinitionFile);
-		}
 	}
 
 	private function createDatabase(IDBConnection $connection) {
diff --git a/lib/private/Setup/Sqlite.php b/lib/private/Setup/Sqlite.php
index 87c0b82682f..d95e70c8b0c 100644
--- a/lib/private/Setup/Sqlite.php
+++ b/lib/private/Setup/Sqlite.php
@@ -41,6 +41,5 @@ class Sqlite extends AbstractDatabase {
 		}
 		//in case of sqlite, we can always fill the database
 		error_log("creating sqlite db");
-		\OC_DB::createDbFromStructure($this->dbDefinitionFile);
 	}
 }
diff --git a/version.php b/version.php
index d9e26eafcee..649c8ae7389 100644
--- a/version.php
+++ b/version.php
@@ -26,7 +26,7 @@
 // between betas, final and RCs. This is _not_ the public version number. Reset minor/patchlevel
 // when updating major/minor version number.
 
-$OC_Version = array(13, 0, 0, 1);
+$OC_Version = array(13, 0, 0, 2);
 
 // The human readable string
 $OC_VersionString = '13.0.0 alpha';