lib

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

0016_farm_member.up.sql (475B)

      1 CREATE TABLE IF NOT EXISTS farm_member (
      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     farm_id CHAR(36) NOT NULL,
      6     member_pubkey CHAR(64) NOT NULL CHECK(length(member_pubkey) = 64),
      7     role TEXT NOT NULL,
      8     FOREIGN KEY (farm_id) REFERENCES farm(id) ON DELETE CASCADE,
      9     UNIQUE (farm_id, member_pubkey, role)
     10 );