owncloud / core

			$table->addUniqueIndex(['type', 'value', 'mount_id'], 'applicable_type_value_mount');

		}

		if (!$schema->hasTable("${prefix}external_config")) {

			$table = $schema->createTable("${prefix}external_config");

			$table->addColumn('config_id', 'bigint', [

				'autoincrement' => true,

				'notnull' => true,

				'length' => 20,

			]);

			// foreign key: external_mounts.mount_id

			$table->addColumn('mount_id', 'bigint', [

				'notnull' => true,

				'length' => 20,

			]);

			$table->addColumn('key', 'string', [

				'notnull' => true,

				'length' => 64,

			]);

			$table->addColumn('value', 'string', [

				'notnull' => true,

				'length' => 4096,

			]);

			$table->setPrimaryKey(['config_id']);

			$table->addIndex(['mount_id'], 'config_mount');

			$table->addUniqueIndex(['mount_id', 'key'], 'config_mount_key');

		}

		if (!$schema->hasTable("${prefix}external_options")) {

			$table = $schema->createTable("${prefix}external_options");

			$table->addUniqueIndex(['mount_id', 'key'], 'config_mount_key');

		}

		if (!$schema->hasTable("${prefix}external_options")) {

			$table = $schema->createTable("${prefix}external_options");

			$table->addColumn('option_id', 'bigint', [

				'autoincrement' => true,

				'notnull' => true,

				'length' => 20,

			]);

			// foreign key: external_mounts.mount_id

			$table->addColumn('mount_id', 'bigint', [

				'notnull' => true,

				'length' => 20,

			]);

			$table->addColumn('key', 'string', [

				'notnull' => true,

				'length' => 64,

			]);

			$table->addColumn('value', 'string', [

				'notnull' => true,

				'length' => 256,

			]);

			$table->setPrimaryKey(['option_id']);

			$table->addIndex(['mount_id'], 'option_mount');

			$table->addUniqueIndex(['mount_id', 'key'], 'option_mount_key');

		}

	}

}