lib

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

0006_nostr_relay.up.sql (438B)

      1 CREATE TABLE IF NOT EXISTS nostr_relay (
      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     url TEXT NOT NULL UNIQUE,
      6     relay_id TEXT,
      7     name TEXT,
      8     description TEXT,
      9     pubkey TEXT,
     10     contact TEXT,
     11     supported_nips TEXT,
     12     software TEXT,
     13     version TEXT,
     14     data TEXT
     15 );