-- ------------------------------------------------------
-- AC preventive check LUW table for SAP_BASIS 7.31+
-- ------------------------------------------------------

CREATE TABLE IF NOT EXISTS `sod_preventive_check_luw` (
  `luw` CHAR(32) NOT NULL,
  `handle` CHAR(32) NOT NULL,
  `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `action` ENUM('continue', 'cancel', 'workflow') NULL,
  `recorded` TINYINT NOT NULL DEFAULT 0,
  PRIMARY KEY (`luw`, `handle`));
