ALTER TABLE mra_eis_terminals
  ADD COLUMN IF NOT EXISTS is_blocked TINYINT(1) NOT NULL DEFAULT 0,
  ADD COLUMN IF NOT EXISTS blocked_at DATETIME DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS block_reason TEXT NULL,
  ADD COLUMN IF NOT EXISTS latest_config_response MEDIUMTEXT NULL,
  ADD COLUMN IF NOT EXISTS last_server_datetime DATETIME DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS last_server_sync_at DATETIME DEFAULT NULL;

ALTER TABLE mra_eis_site_products
  ADD COLUMN IF NOT EXISTS levy_rate_id VARCHAR(50) DEFAULT NULL;

ALTER TABLE mra_eis_item_product_map
  ADD COLUMN IF NOT EXISTS levy_rate_id VARCHAR(50) DEFAULT NULL;

ALTER TABLE mra_eis_product_code_map
  ADD COLUMN IF NOT EXISTS levy_rate_id VARCHAR(50) DEFAULT NULL;

ALTER TABLE sold_items
  ADD COLUMN IF NOT EXISTS vat5_certificate_number VARCHAR(120) DEFAULT NULL;
