3 CREATE TABLE IF NOT EXISTS `processing_flags` (
4 `ID` INT(11) NOT NULL AUTO_INCREMENT,
5 `FLAG` varchar(200) NOT NULL,
6 `VALUE` varchar(200) NOT NULL,
7 `ENDPOINT` varchar(200) NOT NULL,
8 `DESCRIPTION` longtext NOT NULL,
9 `CREATION_TIMESTAMP` timestamp NULL DEFAULT current_timestamp(),
10 `UPDATE_TIMESTAMP` timestamp DEFAULT current_timestamp() ON UPDATE current_timestamp(),
12 UNIQUE KEY `UK_processing_flags` (`FLAG`)
13 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;