create_admin_user.sql

-- =====================================================
-- ResulogicX Admin User Creation Script
-- =====================================================
-- Run this in pgAdmin to create the default admin user
--
-- Credentials:
-- Email:    admin@resulogic.org
-- Password: Admin@12345
-- =====================================================

BEGIN;

-- 1. Delete existing admin if it exists (optional - comment out if you want to keep existing)
DELETE FROM users WHERE email = 'admin@resulogic.org' AND role = 'ADMIN';

-- 2. Insert the admin user
INSERT INTO users (
    first_name,
    last_name,
    email,
    password,
    role,
    status,
    email_verified,
    country,
    gender,
    age_group,
    created_at,
    updated_at
) VALUES (
    'Super',
    'Admin',
    'admin@resulogic.org',
    '$2a$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2uheWG/igi.',  -- BCrypt hash for: Admin@12345
    'ADMIN',
    'ACTIVE',
    true,
    'N/A',
    'N/A',
    'NOT_SPECIFIED',
    CURRENT_TIMESTAMP,
    CURRENT_TIMESTAMP
);

-- 3. Verify the admin was created
SELECT
    id,
    first_name,
    last_name,
    email,
    role,
    status,
    email_verified,
    created_at
FROM users
WHERE email = 'admin@resulogic.org';

COMMIT;

-- =====================================================
-- Expected Output:
-- Should show one row with:
--   - first_name: Super
--   - last_name: Admin
--   - email: admin@resulogic.org
--   - role: ADMIN
--   - status: ACTIVE
--   - email_verified: true
-- =====================================================

-- Login Credentials:
-- Email:    admin@resulogic.org
-- Password: Admin@12345