fedimovies/fedimovies-models/migrations/V0011__mention.sql

6 lines
208 B
MySQL
Raw Permalink Normal View History

2021-11-11 19:10:28 +00:00
CREATE TABLE mention (
post_id UUID NOT NULL REFERENCES post (id) ON DELETE CASCADE,
profile_id UUID NOT NULL REFERENCES actor_profile (id) ON DELETE CASCADE,
PRIMARY KEY (post_id, profile_id)
);