-- sat_form_logs must allow many rows per user (one per form create/update).
-- If PRIMARY KEY is only (user_id), MySQL raises ER_DUP_ENTRY on the second form.
-- Prefer: npm run migrate:sat-form-logs-pk

-- Example manual steps (adjust FK name from SHOW CREATE TABLE sat_form_logs):
-- ALTER TABLE sat_form_logs DROP FOREIGN KEY users_sat_form_logs;
-- ALTER TABLE sat_form_logs DROP PRIMARY KEY;
-- ALTER TABLE sat_form_logs ADD COLUMN log_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
-- ALTER TABLE sat_form_logs ADD INDEX idx_sat_form_logs_user_id (user_id);
-- ALTER TABLE sat_form_logs ADD CONSTRAINT users_sat_form_logs FOREIGN KEY (user_id) REFERENCES users(user_id);
