lib

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

0007_media_image.up.sql (392B)


      1 CREATE TABLE IF NOT EXISTS media_image (
      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     file_path TEXT NOT NULL,
      6     mime_type TEXT NOT NULL,
      7     res_base TEXT NOT NULL,
      8     res_path TEXT NOT NULL,
      9     label TEXT,
     10     description TEXT
     11 );