lib

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

0002_farm.up.sql (563B)

      1 CREATE TABLE IF NOT EXISTS farm (
      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     d_tag TEXT NOT NULL,
      6     pubkey TEXT NOT NULL,
      7     name TEXT NOT NULL,
      8     about TEXT,
      9     website TEXT,
     10     picture TEXT,
     11     banner TEXT,
     12     location_primary TEXT,
     13     location_city TEXT,
     14     location_region TEXT,
     15     location_country TEXT
     16 );
     17 
     18 CREATE UNIQUE INDEX IF NOT EXISTS farm_pubkey_d_tag_idx ON farm(pubkey, d_tag);