CREATE TABLE IF NOT EXISTS processed_postback_events (
    event_id VARCHAR(150) NOT NULL PRIMARY KEY,
    click_id VARCHAR(64) NOT NULL,
    status VARCHAR(40) NOT NULL,
    processed_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;

INSERT INTO settings (setting_key, setting_value)
SELECT 'postback_secret_hash', SHA2(setting_value, 256)
FROM settings
WHERE setting_key = 'postback_secret' AND setting_value <> ''
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value);

DELETE FROM settings WHERE setting_key = 'postback_secret';