-- Run once in phpMyAdmin (after migration 15).
-- Camera photos are now taken for every weighing (auto) and on demand (manual override); live view shows the latest frame per camera.
ALTER TABLE tblTransaction_Photo
  ADD COLUMN seq_no    INT NULL,
  ADD COLUMN source    VARCHAR(10) NOT NULL DEFAULT 'auto',
  ADD COLUMN is_active TINYINT(1) NOT NULL DEFAULT 1;

ALTER TABLE tblCamera_Capture_Request
  ADD COLUMN seq_no INT NULL,
  ADD COLUMN source VARCHAR(10) NOT NULL DEFAULT 'auto',
  MODIFY COLUMN status ENUM('Pending','Processing','Done','Failed') DEFAULT 'Pending';

ALTER TABLE tblTransaction_Setting
  ADD COLUMN camera_auto_capture  TINYINT(1) NOT NULL DEFAULT 1,
  ADD COLUMN camera_manual_button TINYINT(1) NOT NULL DEFAULT 0;

CREATE TABLE tblCamera_Live (
  camera_id       INT NOT NULL PRIMARY KEY,
  requested_until DATETIME NULL,
  frame_at        DATETIME NULL,
  FOREIGN KEY (camera_id) REFERENCES tblCamera_Setting(camera_id) ON DELETE CASCADE
) ENGINE=InnoDB;