commit af2c4a39e9c3a0ec704b23233d1e86fefc90e5fe
parent 28294772b1d1b97f1e84b57712a97e063e8fdb14
Author: triesap <137732411+triesap@users.noreply.github.com>
Date: Sat, 2 Nov 2024 11:02:09 +0000
Edit `nostr_profile_relay` SQL up migration
Diffstat:
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/crates/tauri/migrations/0005_nostr_profile_relay.sql b/crates/tauri/migrations/0005_nostr_profile_relay.sql
@@ -1,7 +1,7 @@
CREATE TABLE IF NOT EXISTS nostr_profile_relay (
- tb_pr_rl_0 CHAR(36),
- tb_pr_rl_1 CHAR(36),
- FOREIGN KEY (tb_pr_rl_0) REFERENCES nostr_profile(id) ON DELETE CASCADE,
- FOREIGN KEY (tb_pr_rl_1) REFERENCES nostr_relay(id) ON DELETE CASCADE,
+ tb_pr_rl_0 CHAR(36)
+ tb_pr_rl_1 CHAR(36)
+ FOREIGN KEY (tb_pr_rl_0) REFERENCES nostr_profile(id) ON DELETE CASCADE
+ FOREIGN KEY (tb_pr_rl_1) REFERENCES nostr_relay(id) ON DELETE CASCADE
PRIMARY KEY (tb_pr_rl_0, tb_pr_rl_1)
);
\ No newline at end of file