diff options
Diffstat (limited to 'internal/storage/storage.go')
| -rw-r--r-- | internal/storage/storage.go | 4 |
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) |
