-- Fujifilm Recipe Tracker — database schema
-- Import this once in phpMyAdmin (or `mysql -u user -p dbname < schema.sql`)

CREATE TABLE IF NOT EXISTS recipes (
  id               VARCHAR(36)  NOT NULL PRIMARY KEY,
  name             VARCHAR(255) NOT NULL,
  film_sim         VARCHAR(255) DEFAULT '',
  grain            VARCHAR(255) DEFAULT '',
  color_chrome     VARCHAR(255) DEFAULT '',
  color_chrome_blue VARCHAR(255) DEFAULT '',
  white_balance    VARCHAR(255) DEFAULT '',
  wb_shift         VARCHAR(255) DEFAULT '',
  dynamic_range    VARCHAR(255) DEFAULT '',
  highlight        VARCHAR(255) DEFAULT '',
  shadow           VARCHAR(255) DEFAULT '',
  color            VARCHAR(255) DEFAULT '',
  sharpness        VARCHAR(255) DEFAULT '',
  noise_reduction  VARCHAR(255) DEFAULT '',
  clarity          VARCHAR(255) DEFAULT '',
  exposure         VARCHAR(255) DEFAULT '',
  comment          TEXT,
  photo            LONGTEXT,               -- stores the photo as a base64 data URL
  used_flag        TINYINT(1) NOT NULL DEFAULT 0,
  liked_flag       TINYINT(1) NOT NULL DEFAULT 0,
  created_at       BIGINT     NOT NULL,
  updated_at       BIGINT     NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;