hasTable('trusted_servers')) { $table = $schema->createTable('trusted_servers'); $table->addColumn('id', Types::INTEGER, [ 'autoincrement' => true, 'notnull' => true, 'length' => 4, ]); $table->addColumn('url', Types::STRING, [ 'notnull' => true, 'length' => 512, ]); $table->addColumn('url_hash', Types::STRING, [ 'notnull' => true, 'default' => '', ]); $table->addColumn('token', Types::STRING, [ 'notnull' => false, 'length' => 128, ]); $table->addColumn('shared_secret', Types::STRING, [ 'notnull' => false, 'length' => 256, ]); $table->addColumn('status', Types::INTEGER, [ 'notnull' => true, 'length' => 4, 'default' => 2, ]); $table->addColumn('sync_token', Types::STRING, [ 'notnull' => false, 'length' => 512, ]); $table->setPrimaryKey(['id']); $table->addUniqueIndex(['url_hash'], 'url_hash'); } return $schema; } }