lib

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

0012_plot.up.sql (579B)

      1 CREATE TABLE IF NOT EXISTS plot (
      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     farm_id CHAR(36) NOT NULL,
      7     name TEXT NOT NULL,
      8     about TEXT,
      9     location_primary TEXT,
     10     location_city TEXT,
     11     location_region TEXT,
     12     location_country TEXT,
     13     FOREIGN KEY (farm_id) REFERENCES farm(id) ON DELETE CASCADE
     14 );
     15 
     16 CREATE UNIQUE INDEX IF NOT EXISTS plot_farm_d_tag_idx ON plot(farm_id, d_tag);