CREATE TABLE IF NOT EXISTS `bloom_gbg` (
`Guid` VARCHAR(255) NOT NULL,
`Package` VARCHAR(255) DEFAULT '',
`Module` VARCHAR(255) DEFAULT 'ObjServiceGBG',
`CheckType` VARCHAR(32) NOT NULL DEFAULT 'identity',
`Status` VARCHAR(32) DEFAULT '',
`RiskScore` INT DEFAULT NULL,
`RiskLevel` VARCHAR(16) DEFAULT '',
`bloom_payload` LONGTEXT,
`bloom_level` INT DEFAULT 0,
`create_date` DATETIME DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`Guid`, `CheckType`),
KEY `idx_status` (`Status`),
KEY `idx_check_type` (`CheckType`),
KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation}
SELECT remoteurl, username, remotepassword
FROM def_remoteconnections
WHERE remote = '{remote}'
SELECT bloom_payload,
TIMESTAMPDIFF(DAY, create_date, NOW())
AS age_days
FROM `{bloom_table}`
WHERE Guid = '{safe_id}'
AND CheckType = '{check_type}'
AND bloom_level = 0
ORDER BY create_date DESC
LIMIT 1
REPLACE INTO `{bloom_table}`
(Guid, CheckType, Status, bloom_payload,
bloom_level, create_date)
VALUES
('{safe_id}', '{check_type}', '{status}',
'{safe_payload}', 0, NOW())