cove-chat/bin-test/migrations/106_guild_members-foreign.sql
CanadianBaconBoi e27a0d33d7 Initial Commit
2026-02-17 18:22:49 +01:00

5 lines
250 B
SQL

ALTER TABLE guild_members
ADD FOREIGN KEY (guild_id) REFERENCES guilds(id) ON DELETE CASCADE,
ADD FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
ADD FOREIGN KEY (voice_channel_id) REFERENCES channels(id) ON DELETE SET NULL