CREATE TABLE IF NOT EXISTS crypto_wallet_audit (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 wallet_id INT UNSIGNED NOT NULL,
 admin_id INT UNSIGNED NOT NULL,
 changed_by_admin_id INT UNSIGNED NOT NULL,
 network VARCHAR(32) NOT NULL,
 old_address VARCHAR(255) NULL,
 new_address VARCHAR(255) NOT NULL,
 old_is_active TINYINT(1) NULL,
 new_is_active TINYINT(1) NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 INDEX idx_wallet_audit_admin (admin_id),
 FOREIGN KEY (wallet_id) REFERENCES crypto_wallets(id) ON DELETE RESTRICT,
 FOREIGN KEY (admin_id) REFERENCES admins(id) ON DELETE RESTRICT,
 FOREIGN KEY (changed_by_admin_id) REFERENCES admins(id) ON DELETE RESTRICT
);