0009_nostr_profile_relay.up.sql (264B)
1 CREATE TABLE IF NOT EXISTS nostr_profile_relay ( 2 tb_pr CHAR(36), 3 tb_rl CHAR(36), 4 FOREIGN KEY (tb_pr) REFERENCES nostr_profile(id) ON DELETE CASCADE, 5 FOREIGN KEY (tb_rl) REFERENCES nostr_relay(id) ON DELETE CASCADE, 6 PRIMARY KEY (tb_pr, tb_rl) 7 );