diff options
Diffstat (limited to 'internal/storage/storage.go')
| -rw-r--r-- | internal/storage/storage.go | 12 |
1 files changed, 0 insertions, 12 deletions
diff --git a/internal/storage/storage.go b/internal/storage/storage.go index 806acac..d00d7bf 100644 --- a/internal/storage/storage.go +++ b/internal/storage/storage.go | |||
| @@ -99,18 +99,6 @@ func (s *Storage) initSchema(ctx context.Context) error { | |||
| 99 | ON events(tags) | 99 | ON events(tags) |
| 100 | WHERE deleted = 0; | 100 | WHERE deleted = 0; |
| 101 | 101 | ||
| 102 | -- Deletion events (NIP-09) | ||
| 103 | CREATE TABLE IF NOT EXISTS deletions ( | ||
| 104 | deleted_event_id TEXT PRIMARY KEY, -- ID of event being deleted | ||
| 105 | deletion_event_id TEXT NOT NULL, -- ID of deletion event | ||
| 106 | pubkey TEXT NOT NULL, -- Who requested deletion | ||
| 107 | created_at INTEGER NOT NULL, | ||
| 108 | FOREIGN KEY (deleted_event_id) REFERENCES events(id) | ||
| 109 | ) STRICT; | ||
| 110 | |||
| 111 | CREATE INDEX IF NOT EXISTS idx_deleted_event | ||
| 112 | ON deletions(deleted_event_id); | ||
| 113 | |||
| 114 | -- Replaceable events tracking (NIP-16, NIP-33) | 102 | -- Replaceable events tracking (NIP-16, NIP-33) |
| 115 | CREATE TABLE IF NOT EXISTS replaceable_events ( | 103 | CREATE TABLE IF NOT EXISTS replaceable_events ( |
| 116 | kind INTEGER NOT NULL, | 104 | kind INTEGER NOT NULL, |
