-- Create default super admin
-- Email: admin@astrabank.local
-- Password: Admin@123

INSERT INTO users (full_name, email, password_hash, kyc_status, status)
VALUES ('Astrabank Admin', 'admin@astrabank.local', '$2y$10$SV/lBO8yvvOkYP6FYDQTbe6CJMz6V4mihV2rHWaCW316Z6kqLSz3y', 'verified', 'active');

SET @admin_id = LAST_INSERT_ID();

INSERT INTO user_roles (user_id, role_id)
SELECT @admin_id, r.id FROM roles r WHERE r.name='super_admin';