lib

Core libraries for Radroots
git clone https://radroots.dev/git/lib.git
Log | Files | Refs | README | LICENSE

0018_nostr_event_head.up.sql (607B)

      1 CREATE TABLE IF NOT EXISTS nostr_event_head (
      2     id CHAR(36) PRIMARY KEY NOT NULL UNIQUE CHECK(length(id) = 36),
      3     created_at DATETIME NOT NULL CHECK(length(created_at) = 24),
      4     updated_at DATETIME NOT NULL CHECK(length(updated_at) = 24),
      5     key TEXT NOT NULL UNIQUE,
      6     kind INTEGER NOT NULL,
      7     pubkey CHAR(64) NOT NULL CHECK(length(pubkey) = 64),
      8     d_tag TEXT NOT NULL,
      9     last_event_id CHAR(64) NOT NULL CHECK(length(last_event_id) = 64),
     10     last_created_at INTEGER NOT NULL,
     11     content_hash TEXT NOT NULL
     12 );
     13 
     14 CREATE INDEX IF NOT EXISTS nostr_event_head_kind_idx ON nostr_event_head(kind);