-- Run once in phpMyAdmin.
-- Indicator protocol set from the cloud panel (per weighbridge) + what the agent reports back (raw text, port state, applied version).
CREATE TABLE tblIndicator_Setting (
  device_id   VARCHAR(50) NOT NULL PRIMARY KEY,
  config_json TEXT NOT NULL,
  version     INT NOT NULL DEFAULT 1,
  updated_by  INT NULL,
  updated_at  DATETIME NULL,
  FOREIGN KEY (device_id) REFERENCES tblWeighbridge(device_id) ON DELETE CASCADE
) ENGINE=InnoDB;

CREATE TABLE tblAgent_Status (
  device_id       VARCHAR(50) NOT NULL PRIMARY KEY,
  applied_version INT NOT NULL DEFAULT 0,
  config_error    VARCHAR(255) NULL,
  port_state      VARCHAR(20) NULL,
  signal_ok       TINYINT(1) NULL,
  agent_version   VARCHAR(40) NULL,
  last_weight     VARCHAR(20) NULL,
  raw_tail        TEXT NULL,
  last_seen       DATETIME NULL,
  FOREIGN KEY (device_id) REFERENCES tblWeighbridge(device_id) ON DELETE CASCADE
) ENGINE=InnoDB;