summaryrefslogtreecommitdiffstats
path: root/internal/storage/storage.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/storage/storage.go')
-rw-r--r--internal/storage/storage.go4
1 files changed, 2 insertions, 2 deletions
diff --git a/internal/storage/storage.go b/internal/storage/storage.go
index 64fc4c6..806acac 100644
--- a/internal/storage/storage.go
+++ b/internal/storage/storage.go
@@ -101,8 +101,8 @@ func (s *Storage) initSchema(ctx context.Context) error {
101 101
102 -- Deletion events (NIP-09) 102 -- Deletion events (NIP-09)
103 CREATE TABLE IF NOT EXISTS deletions ( 103 CREATE TABLE IF NOT EXISTS deletions (
104 event_id TEXT PRIMARY KEY, -- ID of deletion event 104 deleted_event_id TEXT PRIMARY KEY, -- ID of event being deleted
105 deleted_event_id TEXT NOT NULL, -- ID of event being deleted 105 deletion_event_id TEXT NOT NULL, -- ID of deletion event
106 pubkey TEXT NOT NULL, -- Who requested deletion 106 pubkey TEXT NOT NULL, -- Who requested deletion
107 created_at INTEGER NOT NULL, 107 created_at INTEGER NOT NULL,
108 FOREIGN KEY (deleted_event_id) REFERENCES events(id) 108 FOREIGN KEY (deleted_event_id) REFERENCES events(id)