-- DentalCare 0.7.6.5 reference migration.
-- The supported updater applies these changes conditionally with the active table prefix.
ALTER TABLE `{{prefix}}payments` ADD COLUMN `request_token` CHAR(64) NULL AFTER `reference_no`;
ALTER TABLE `{{prefix}}payments` ADD UNIQUE INDEX `uq_payments_request_token` (`request_token`);
ALTER TABLE `{{prefix}}audit_logs` ADD COLUMN `record_hash` CHAR(64) NULL AFTER `new_values_json`;
ALTER TABLE `{{prefix}}audit_logs` ADD INDEX `idx_audit_record_hash` (`record_hash`);
