- $this->addSql('ALTER TABLE '.$this->getTable('oauth2_clients').' ADD user_id INT(11) DEFAULT NULL');
- $this->addSql('ALTER TABLE '.$this->getTable('oauth2_clients').' ADD CONSTRAINT FK_clients_user_clients FOREIGN KEY (user_id) REFERENCES '.$this->getTable('user').' (id) ON DELETE CASCADE');
+ $clientsTable->addColumn('user_id', 'integer', ['notnull' => false]);
+
+ $clientsTable->addForeignKeyConstraint(
+ $this->getTable('user'),
+ ['user_id'],
+ ['id'],
+ ['onDelete' => 'CASCADE'],
+ $this->constraintName
+ );