Kann mir jemand bei meinem Problem helfen? Was muss ich in diesem Fall tun?
Fehler: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‚mail_template_to_operator_id‘
public function update(Connection $connection): void
{
$sql = <<<'SQL'
ALTER TABLE `form` ADD (
`mail_template_to_operator_id` BINARY(16),
`mail_template_to_customer_id` BINARY(16),
CONSTRAINT `fk.form.mail_template_to_operator_id` FOREIGN KEY (`mail_template_to_operator_id`)
REFERENCES `mail_template` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk.form.mail_template_to_customer_id` FOREIGN KEY (`mail_template_to_customer_id`)
REFERENCES `mail_template` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
);
SQL;
$connection->executeUpdate($sql);
}
Vielen Dank an jeden der mit weiterhelfen kann.