ALTER TABLE members ADD COLUMN photo_path VARCHAR(255) NULL AFTER address;
ALTER TABLE member_registrations ADD COLUMN photo_path VARCHAR(255) NULL AFTER email;
CREATE TABLE IF NOT EXISTS backup_history (
 id BIGINT AUTO_INCREMENT PRIMARY KEY, backup_type ENUM('database','full_data') NOT NULL, file_name VARCHAR(255) NOT NULL, file_size BIGINT NOT NULL DEFAULT 0, checksum_sha256 VARCHAR(64) NULL, created_by INT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY(created_by) REFERENCES users(id) ON DELETE SET NULL, INDEX idx_backup_created(created_at)
) ENGINE=InnoDB;
INSERT INTO settings(setting_key,setting_value) VALUES ('public_member_check_enabled','1'),('member_activity_window_days','90') ON DUPLICATE KEY UPDATE setting_value=VALUES(setting_value);