I have more info for you on the Prisma deploy error #4724
if you introspect and there is the foreign key between the 2 tables the relationship shows in the generated model but when deploying it it tries to regenerate “alter” the table and add the relationship...idk why it’s trying to alter when migrations is set to false.
Query is: ALTER TABLE portal_beta.publishers
ADD COLUMN source_id int NULL ,
ADD FOREIGN KEY (source_id) REFERENCES portal_beta.sources(id) ON DELETE SET NULL;
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
... 15 more
this is on MySQL