lib

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

0017_farm_member_claim.up.sql (426B)

      1 CREATE TABLE IF NOT EXISTS farm_member_claim (
      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     member_pubkey CHAR(64) NOT NULL CHECK(length(member_pubkey) = 64),
      6     farm_pubkey CHAR(64) NOT NULL CHECK(length(farm_pubkey) = 64),
      7     UNIQUE (member_pubkey, farm_pubkey)
      8 );