FOREIGN_KEYS_DISALLOWED schema lint error

​

What this error means

table "posts" has a foreign key constraint: foreign key constraints are not supported.

​

Why PlanetScale rejects it

​

How to fix it

• Enable foreign key constraint support for the database if your workload needs database-enforced referential integrity and the database meets the prerequisites.
• Remove the CONSTRAINT ... FOREIGN KEY clause and keep ordinary indexes for query performance.
• Enforce referential integrity in application code or background jobs instead of with database constraints.

CREATE TABLE posts (
  id bigint unsigned NOT NULL,
  author_id bigint unsigned NOT NULL,
  PRIMARY KEY (id),
  CONSTRAINT posts_author_fk FOREIGN KEY (author_id) REFERENCES users(id)
);

CREATE TABLE posts (
  id bigint unsigned NOT NULL,
  author_id bigint unsigned NOT NULL,
  PRIMARY KEY (id),
  KEY posts_author_idx (author_id)
);

​

Related docs

• Foreign key constraints
• Operating without foreign key constraints
• Strategies for maintaining referential integrity

​

Need help?