lib

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

0005_nostr_profile.up.sql (504B)

      1 CREATE TABLE IF NOT EXISTS nostr_profile (
      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     public_key CHAR(64) NOT NULL CHECK(length(public_key) = 64),
      6     profile_type TEXT NOT NULL,
      7     name TEXT NOT NULL,
      8     display_name TEXT,
      9     about TEXT,
     10     website TEXT,
     11     picture TEXT,
     12     banner TEXT,
     13     nip05 TEXT,
     14     lud06 TEXT,
     15     lud16 TEXT
     16 );