-- ========== INITIAL DATA =========


-- ========== PERMISSIONS ==========

INSERT INTO permissions (id, name, description, module, action) VALUES

    -- Employee permissions
    ('emp_read_kj34_hg5d_fg7s',      'employees:read',        'View employees',         'employees', 'read'),
    ('emp_create_nm78_io9p_kl0s',    'employees:create',      'Create employees',       'employees', 'create'),
    ('emp_update_we23_rt45_yu67',    'employees:update',      'Update employees',       'employees', 'update'),
    ('emp_delete_as89_df34_gh56',    'employees:delete',      'Delete employees',       'employees', 'delete'),
    ('emp_bulkdel_ab12_cd34_ef56',   'employees:bulkdelete',  'Bulk delete employees',  'employees', 'bulkdelete'),

    -- Permission permissions
    ('perm_read_zx12_cv34_bn56',     'permissions:read',        'View permissions',        'permissions', 'read'),
    ('perm_create_ui78_op90_kl12',   'permissions:create',      'Create permissions',      'permissions', 'create'),
    ('perm_update_fg34_hj56_kl78',   'permissions:update',      'Update permissions',      'permissions', 'update'),
    ('perm_delete_ty12_ui34_op56',   'permissions:delete',      'Delete permissions',      'permissions', 'delete'),
    ('perm_bulkdel_gh78_ij90_kl12',  'permissions:bulkdelete',  'Bulk delete permissions', 'permissions', 'bulkdelete'),

    -- Role permissions
    ('role_read_qw12_er34_ty56',     'roles:read',        'View roles',        'roles', 'read'),
    ('role_create_gh78_ij90_kl12',   'roles:create',      'Create roles',      'roles', 'create'),
    ('role_update_mn34_op56_rs78',   'roles:update',      'Update roles',      'roles', 'update'),
    ('role_delete_uv12_wx34_yz56',   'roles:delete',      'Delete roles',      'roles', 'delete'),
    ('role_bulkdel_mn34_op56_qr78',  'roles:bulkdelete',  'Bulk delete roles', 'roles', 'bulkdelete'),

    -- Category permissions
    ('cat_read_fg45_hj67_jk89',      'categories:read',        'View categories',        'categories', 'read'),
    ('cat_create_rt23_yu45_io78',    'categories:create',      'Create categories',      'categories', 'create'),
    ('cat_update_ws34_ed56_rf78',    'categories:update',      'Update categories',      'categories', 'update'),
    ('cat_delete_tg67_yh89_uj12',    'categories:delete',      'Delete categories',      'categories', 'delete'),
    ('cat_bulkdel_st90_uv12_wx34',   'categories:bulkdelete',  'Bulk delete categories', 'categories', 'bulkdelete'),

    -- Settings permissions
    ('set_read_mk45_lo67_ip89',      'settings:read',    'View settings',   'settings', 'read'),
    ('set_update_az12_sx34_cv56',    'settings:update',  'Update settings', 'settings', 'update'),

    -- Profile permissions
    ('prof_read_fr67_gt89_hj34',     'profile:read',    'View profile',   'profile', 'read'),
    ('prof_update_kl56_ty78_ui90',   'profile:update',  'Update profile', 'profile', 'update'),

    -- Audit permissions
    ('audit_read_vf45_cd67_xz89',    'audit:read',  'View audit logs', 'audit', 'read'),

    -- Menu permissions
    ('menu_read_hn12_mk34_lp56',     'menus:read',          'View menus',        'menus', 'read'),
    ('menu_create_rf78_tg90_yh12',   'menus:create',        'Create menus',      'menus', 'create'),
    ('menu_update_uj34_io56_kl78',   'menus:update',        'Update menus',      'menus', 'update'),
    ('menu_delete_qw12_er34_ty56',   'menus:delete',        'Delete menus',      'menus', 'delete'),
    ('menu_manage_as78_df90_gh12',   'menus:manage_items',  'Manage menu items', 'menus', 'manage_items'),
    ('menu_bulkdel_yz56_ab78_cd90',  'menus:bulkdelete',    'Bulk delete menus', 'menus', 'bulkdelete'),

    -- Page permissions
    ('page_read_zx45_cv67_bn89',     'pages:read',        'View pages',              'pages', 'read'),
    ('page_create_ty12_ui34_op56',   'pages:create',      'Create pages',            'pages', 'create'),
    ('page_update_fg78_hj90_kl12',   'pages:update',      'Update pages',            'pages', 'update'),
    ('page_delete_we34_rt56_yu78',   'pages:delete',      'Delete pages',            'pages', 'delete'),
    ('page_manage_io90_kl12_mn34',   'pages:manage',      'Manage page builder',     'pages', 'manage'),
    ('page_bulkdel_ef12_gh34_ij56',  'pages:bulkdelete',  'Bulk delete pages',       'pages', 'bulkdelete'),

    -- Sidebar permissions
    ('side_read_qw56_er78_ty90',     'sidebars:read',        'View sidebars',        'sidebars', 'read'),
    ('side_create_as12_df34_gh56',   'sidebars:create',      'Create sidebars',      'sidebars', 'create'),
    ('side_update_zx78_cv90_bn12',   'sidebars:update',      'Update sidebars',      'sidebars', 'update'),
    ('side_delete_ui34_op56_rs78',   'sidebars:delete',      'Delete sidebars',      'sidebars', 'delete'),

    -- Author permissions
    ('auth_read_mk90_lp12_hn34',     'authors:read',        'View authors',        'authors', 'read'),
    ('auth_create_tg56_yh78_uj90',   'authors:create',      'Create authors',      'authors', 'create'),
    ('auth_update_io12_kl34_mn56',   'authors:update',      'Update authors',      'authors', 'update'),
    ('auth_delete_fg78_hj90_kl12',   'authors:delete',      'Delete authors',      'authors', 'delete'),
    ('auth_bulkdel_qr34_st56_uv78',  'authors:bulkdelete',  'Bulk delete authors', 'authors', 'bulkdelete'),

    -- Content permissions
    ('cont_read_ty34_ui56_op78',     'content:read',        'View content',        'content', 'read'),
    ('cont_create_we90_rt12_yu34',   'content:create',      'Create content',      'content', 'create'),
    ('cont_update_as56_df78_gh90',   'content:update',      'Update content',      'content', 'update'),
    ('cont_delete_zx12_cv34_bn56',   'content:delete',      'Delete content',      'content', 'delete'),
    ('cont_bulkdel_wx90_yz12_ab34',  'content:bulkdelete',  'Bulk delete content', 'content', 'bulkdelete'),

    -- Redirect permissions
    ('redir_read_qw78_er90_ty12',    'redirects:read',        'View redirects',        'redirects', 'read'),
    ('redir_create_as34_df56_gh78',  'redirects:create',      'Create redirects',      'redirects', 'create'),
    ('redir_update_zx90_cv12_bn34',  'redirects:update',      'Update redirects',      'redirects', 'update'),
    ('redir_delete_ui56_op78_rs90',  'redirects:delete',      'Delete redirects',      'redirects', 'delete'),
    ('redir_bulkdel_cd56_ef78_gh90', 'redirects:bulkdelete',  'Bulk delete redirects', 'redirects', 'bulkdelete')

ON CONFLICT (id) DO NOTHING;


-- ========== ROLES ==========

INSERT INTO roles (id, name, description) VALUES
    ('super_admin_role_kj34_hg5d_fg7s', 'super_admin', 'Full system access with all permissions'),
    ('admin_role_nm78_io9p_kl0s_xyz',   'admin',       'Administrative access with most permissions'),
    ('manager_role_we23_rt45_yu67_abc', 'manager',     'Manager level access with team management'),
    ('editor_role_as89_df34_gh56_def',  'editor',      'Content editor with limited administrative access'),
    ('viewer_role_zx12_cv34_bn56_ghi',  'viewer',      'Read-only access for viewing data')
ON CONFLICT (id) DO NOTHING;


-- ========== ADMIN USERS ==========

INSERT INTO admin_users (id, email, password_hash, first_name, last_name, is_active, is_verified) VALUES
    ('admin_user_1a2b_3c4d_5e6f_7g8h', 'admin@outreachexpert.co',          '$2a$12$UH62szUBeHfdbQ13wJbzceKCCHLmITFn6KXzzhItB3guYuPWZyV/.', 'Outreach', 'Expert',  true, true),
    ('admin_user_9j8k_7l6m_5n4b_3v2c', 'content.manager@outreachexpert.co', '$2a$12$Rp94uzWCKh0rdR35yLkzpeSTUVmITXp8MZyyjJtC5iwZrQXyD1E/', 'Content',  'Manager', true, true)
ON CONFLICT (id) DO NOTHING;


-- ========== ASSIGN ROLES TO USERS ==========

INSERT INTO admin_user_roles (id, admin_user_id, role_id) VALUES
    ('admin_user_role_9x8y_7z6w_5v4u_3t2s', 'admin_user_1a2b_3c4d_5e6f_7g8h', 'super_admin_role_kj34_hg5d_fg7s')
ON CONFLICT (id) DO NOTHING;


-- ========== ASSIGN PERMISSIONS TO SUPER ADMIN ROLE ==========

INSERT INTO role_permissions (id, role_id, permission_id, granted_by) VALUES

    -- Employee permissions
    ('role_perm_1a2b_3c4d_5e6f_7g8h', 'super_admin_role_kj34_hg5d_fg7s', 'emp_read_kj34_hg5d_fg7s',     NULL),
    ('role_perm_2b3c_4d5e_6f7g_8h9i', 'super_admin_role_kj34_hg5d_fg7s', 'emp_create_nm78_io9p_kl0s',   NULL),
    ('role_perm_3c4d_5e6f_7g8h_9i0j', 'super_admin_role_kj34_hg5d_fg7s', 'emp_update_we23_rt45_yu67',   NULL),
    ('role_perm_4d5e_6f7g_8h9i_0j1k', 'super_admin_role_kj34_hg5d_fg7s', 'emp_delete_as89_df34_gh56',   NULL),
    ('role_perm_8v9w_0x1y_2z3a_4b5c', 'super_admin_role_kj34_hg5d_fg7s', 'emp_bulkdel_ab12_cd34_ef56',  NULL),

    -- Permission permissions
    ('role_perm_5e6f_7g8h_9i0j_1k2l', 'super_admin_role_kj34_hg5d_fg7s', 'perm_read_zx12_cv34_bn56',    NULL),
    ('role_perm_6f7g_8h9i_0j1k_2l3m', 'super_admin_role_kj34_hg5d_fg7s', 'perm_create_ui78_op90_kl12',  NULL),
    ('role_perm_7g8h_9i0j_1k2l_3m4n', 'super_admin_role_kj34_hg5d_fg7s', 'perm_update_fg34_hj56_kl78',  NULL),
    ('role_perm_8h9i_0j1k_2l3m_4n5o', 'super_admin_role_kj34_hg5d_fg7s', 'perm_delete_ty12_ui34_op56',  NULL),
    ('role_perm_9w0x_1y2z_3a4b_5c6d', 'super_admin_role_kj34_hg5d_fg7s', 'perm_bulkdel_gh78_ij90_kl12', NULL),

    -- Role permissions
    ('role_perm_9i0j_1k2l_3m4n_5o6p', 'super_admin_role_kj34_hg5d_fg7s', 'role_read_qw12_er34_ty56',    NULL),
    ('role_perm_0j1k_2l3m_4n5o_6p7q', 'super_admin_role_kj34_hg5d_fg7s', 'role_create_gh78_ij90_kl12',  NULL),
    ('role_perm_1k2l_3m4n_5o6p_7q8r', 'super_admin_role_kj34_hg5d_fg7s', 'role_update_mn34_op56_rs78',  NULL),
    ('role_perm_2l3m_4n5o_6p7q_8r9s', 'super_admin_role_kj34_hg5d_fg7s', 'role_delete_uv12_wx34_yz56',  NULL),
    ('role_perm_0x1y_2z3a_4b5c_6d7e', 'super_admin_role_kj34_hg5d_fg7s', 'role_bulkdel_mn34_op56_qr78', NULL),

    -- Category permissions
    ('role_perm_3m4n_5o6p_7q8r_9s0t', 'super_admin_role_kj34_hg5d_fg7s', 'cat_read_fg45_hj67_jk89',    NULL),
    ('role_perm_4n5o_6p7q_8r9s_0t1u', 'super_admin_role_kj34_hg5d_fg7s', 'cat_create_rt23_yu45_io78',  NULL),
    ('role_perm_5o6p_7q8r_9s0t_1u2v', 'super_admin_role_kj34_hg5d_fg7s', 'cat_update_ws34_ed56_rf78',  NULL),
    ('role_perm_6p7q_8r9s_0t1u_2v3w', 'super_admin_role_kj34_hg5d_fg7s', 'cat_delete_tg67_yh89_uj12',  NULL),
    ('role_perm_1y2z_3a4b_5c6d_7e8f', 'super_admin_role_kj34_hg5d_fg7s', 'cat_bulkdel_st90_uv12_wx34', NULL),

    -- Settings permissions
    ('role_perm_7q8r_9s0t_1u2v_3w4x', 'super_admin_role_kj34_hg5d_fg7s', 'set_read_mk45_lo67_ip89',   NULL),
    ('role_perm_8r9s_0t1u_2v3w_4x5y', 'super_admin_role_kj34_hg5d_fg7s', 'set_update_az12_sx34_cv56', NULL),

    -- Profile permissions
    ('role_perm_9s0t_1u2v_3w4x_5y6z', 'super_admin_role_kj34_hg5d_fg7s', 'prof_read_fr67_gt89_hj34',   NULL),
    ('role_perm_0t1u_2v3w_4x5y_6z7a', 'super_admin_role_kj34_hg5d_fg7s', 'prof_update_kl56_ty78_ui90', NULL),

    -- Audit permissions
    ('role_perm_1u2v_3w4x_5y6z_7a8b', 'super_admin_role_kj34_hg5d_fg7s', 'audit_read_vf45_cd67_xz89', NULL),

    -- Menu permissions
    ('role_perm_2v3w_4x5y_6z7a_8b9c', 'super_admin_role_kj34_hg5d_fg7s', 'menu_read_hn12_mk34_lp56',    NULL),
    ('role_perm_3w4x_5y6z_7a8b_9c0d', 'super_admin_role_kj34_hg5d_fg7s', 'menu_create_rf78_tg90_yh12',  NULL),
    ('role_perm_4x5y_6z7a_8b9c_0d1e', 'super_admin_role_kj34_hg5d_fg7s', 'menu_update_uj34_io56_kl78',  NULL),
    ('role_perm_5y6z_7a8b_9c0d_1e2f', 'super_admin_role_kj34_hg5d_fg7s', 'menu_delete_qw12_er34_ty56',  NULL),
    ('role_perm_6z7a_8b9c_0d1e_2f3g', 'super_admin_role_kj34_hg5d_fg7s', 'menu_manage_as78_df90_gh12',  NULL),
    ('role_perm_2z3a_4b5c_6d7e_8f9g', 'super_admin_role_kj34_hg5d_fg7s', 'menu_bulkdel_yz56_ab78_cd90', NULL),

    -- Page permissions
    ('role_perm_7a8b_9c0d_1e2f_3g4h', 'super_admin_role_kj34_hg5d_fg7s', 'page_read_zx45_cv67_bn89',    NULL),
    ('role_perm_8b9c_0d1e_2f3g_4h5i', 'super_admin_role_kj34_hg5d_fg7s', 'page_create_ty12_ui34_op56',  NULL),
    ('role_perm_9c0d_1e2f_3g4h_5i6j', 'super_admin_role_kj34_hg5d_fg7s', 'page_update_fg78_hj90_kl12',  NULL),
    ('role_perm_0d1e_2f3g_4h5i_6j7k', 'super_admin_role_kj34_hg5d_fg7s', 'page_delete_we34_rt56_yu78',  NULL),
    ('role_perm_1e2f_3g4h_5i6j_7k8l', 'super_admin_role_kj34_hg5d_fg7s', 'page_manage_io90_kl12_mn34',  NULL),
    ('role_perm_3a4b_5c6d_7e8f_9g0h', 'super_admin_role_kj34_hg5d_fg7s', 'page_bulkdel_ef12_gh34_ij56', NULL),

    -- Sidebar permissions
    ('role_perm_2f3g_4h5i_6j7k_8l9m', 'super_admin_role_kj34_hg5d_fg7s', 'side_read_qw56_er78_ty90',    NULL),
    ('role_perm_3g4h_5i6j_7k8l_9m0n', 'super_admin_role_kj34_hg5d_fg7s', 'side_create_as12_df34_gh56',  NULL),
    ('role_perm_4h5i_6j7k_8l9m_0n1o', 'super_admin_role_kj34_hg5d_fg7s', 'side_update_zx78_cv90_bn12',  NULL),
    ('role_perm_5i6j_7k8l_9m0n_1o2p', 'super_admin_role_kj34_hg5d_fg7s', 'side_delete_ui34_op56_rs78',  NULL),

    -- Author permissions
    ('role_perm_6j7k_8l9m_0n1o_2p3q', 'super_admin_role_kj34_hg5d_fg7s', 'auth_read_mk90_lp12_hn34',    NULL),
    ('role_perm_7k8l_9m0n_1o2p_3q4r', 'super_admin_role_kj34_hg5d_fg7s', 'auth_create_tg56_yh78_uj90',  NULL),
    ('role_perm_8l9m_0n1o_2p3q_4r5s', 'super_admin_role_kj34_hg5d_fg7s', 'auth_update_io12_kl34_mn56',  NULL),
    ('role_perm_9m0n_1o2p_3q4r_5s6t', 'super_admin_role_kj34_hg5d_fg7s', 'auth_delete_fg78_hj90_kl12',  NULL),
    ('role_perm_5c6d_7e8f_9g0h_1i2j', 'super_admin_role_kj34_hg5d_fg7s', 'auth_bulkdel_qr34_st56_uv78', NULL),

    -- Content permissions
    ('role_perm_0n1o_2p3q_4r5s_6t7u', 'super_admin_role_kj34_hg5d_fg7s', 'cont_read_ty34_ui56_op78',    NULL),
    ('role_perm_1o2p_3q4r_5s6t_7u8v', 'super_admin_role_kj34_hg5d_fg7s', 'cont_create_we90_rt12_yu34',  NULL),
    ('role_perm_2p3q_4r5s_6t7u_8v9w', 'super_admin_role_kj34_hg5d_fg7s', 'cont_update_as56_df78_gh90',  NULL),
    ('role_perm_3q4r_5s6t_7u8v_9w0x', 'super_admin_role_kj34_hg5d_fg7s', 'cont_delete_zx12_cv34_bn56',  NULL),
    ('role_perm_6d7e_8f9g_0h1i_2j3k', 'super_admin_role_kj34_hg5d_fg7s', 'cont_bulkdel_wx90_yz12_ab34', NULL),

    -- Redirect permissions
    ('role_perm_4r5s_6t7u_8v9w_0x1y', 'super_admin_role_kj34_hg5d_fg7s', 'redir_read_qw78_er90_ty12',    NULL),
    ('role_perm_5s6t_7u8v_9w0x_1y2z', 'super_admin_role_kj34_hg5d_fg7s', 'redir_create_as34_df56_gh78',  NULL),
    ('role_perm_6t7u_8v9w_0x1y_2z3a', 'super_admin_role_kj34_hg5d_fg7s', 'redir_update_zx90_cv12_bn34',  NULL),
    ('role_perm_7u8v_9w0x_1y2z_3a4b', 'super_admin_role_kj34_hg5d_fg7s', 'redir_delete_ui56_op78_rs90',  NULL),
    ('role_perm_7e8f_9g0h_1i2j_3k4l', 'super_admin_role_kj34_hg5d_fg7s', 'redir_bulkdel_cd56_ef78_gh90', NULL)

ON CONFLICT (id) DO NOTHING;

-- Insert GENERAL Categories
INSERT INTO categories (id, name, slug, description, status, category_type, is_indexable, meta_title, meta_description, created_at, updated_at) VALUES
('cat_gen_001', 'Technology', 'technology', 'All about technology, gadgets, software, and IT industry news', true, 'GENERAL', true, 'Technology Category', 'Explore the latest technology trends, gadgets, and software updates', NOW(), NOW()),
('cat_gen_002', 'Business', 'business', 'Business strategies, entrepreneurship, marketing, and management', true, 'GENERAL', true, 'Business Category', 'Learn business strategies, entrepreneurship tips, and marketing insights', NOW(), NOW()),
('cat_gen_003', 'Health & Wellness', 'health-wellness', 'Health tips, wellness practices, fitness guides, and nutrition advice', true, 'GENERAL', true, 'Health & Wellness Category', 'Discover health tips, wellness practices, and fitness guides', NOW(), NOW()),
('cat_gen_004', 'Travel', 'travel', 'Travel destinations, guides, tips, and adventure stories', true, 'GENERAL', true, 'Travel Category', 'Explore travel destinations, guides, and adventure stories', NOW(), NOW()),
('cat_gen_005', 'Food & Cooking', 'food-cooking', 'Recipes, cooking tips, food reviews, and culinary adventures', true, 'GENERAL', true, 'Food Category', 'Discover recipes, cooking tips, and culinary adventures', NOW(), NOW()),
('cat_gen_006', 'Fashion', 'fashion', 'Fashion trends, style guides, clothing reviews, and beauty tips', true, 'GENERAL', true, 'Fashion Category', 'Stay updated with fashion trends, style guides, and beauty tips', NOW(), NOW()),
('cat_gen_007', 'Sports', 'sports', 'Sports news, game analysis, athlete profiles, and fitness', true, 'GENERAL', true, 'Sports Category', 'Get latest sports news, game analysis, and athlete updates', NOW(), NOW()),
('cat_gen_008', 'Education', 'education', 'Learning resources, educational tips, career guidance', true, 'GENERAL', true, 'Education Category', 'Find learning resources, educational tips, and career guidance', NOW(), NOW())

ON CONFLICT (id) DO NOTHING;

-- Insert SPECIAL Categories (with pricing)
INSERT INTO categories (id, name, slug, description, status, category_type, is_indexable, meta_title, meta_description, created_at, updated_at) VALUES
('cat_spec_001', 'Premium Technology', 'premium-technology', 'High-end technology content with exclusive insights', true, 'SPECIAL', true, 'Premium Technology', 'Exclusive high-end technology insights and premium content', NOW(), NOW()),
('cat_spec_002', 'Luxury Travel', 'luxury-travel', 'Luxury travel experiences, exclusive destinations, premium hotels', true, 'SPECIAL', true, 'Luxury Travel', 'Discover luxury travel experiences and exclusive destinations', NOW(), NOW()),
('cat_spec_003', 'Gourmet Food', 'gourmet-food', 'Gourmet cooking, fine dining, exclusive recipes', true, 'SPECIAL', true, 'Gourmet Food', 'Explore gourmet cooking, fine dining, and exclusive recipes', NOW(), NOW()),
('cat_spec_004', 'High-End Fashion', 'high-end-fashion', 'Designer fashion, luxury brands, exclusive style guides', true, 'SPECIAL', true, 'High-End Fashion', 'Discover designer fashion, luxury brands, and exclusive style', NOW(), NOW()),
('cat_spec_005', 'Elite Sports', 'elite-sports', 'Professional sports analysis, elite athlete training', true, 'SPECIAL', true, 'Elite Sports', 'Professional sports analysis and elite athlete training insights', NOW(), NOW()),
('cat_spec_006', 'Executive Business', 'executive-business', 'C-level business strategies, executive leadership', true, 'SPECIAL', true, 'Executive Business', 'C-level business strategies and executive leadership insights', NOW(), NOW())

ON CONFLICT (id) DO NOTHING;


-- Insert Users (password_hash is bcrypt hash of 'password123' - you should generate actual hashes)
-- Note: These are sample users. In production, use proper password hashing
INSERT INTO users (id, email, password_hash, first_name, last_name, display_name, phone, is_active, email_verified, two_factor_enabled, created_at, updated_at) VALUES
('user_001', 'john.doe@example.com', '$2b$10$YourHashHere1234567890abcdefghijklmnopqrstuvwxyz', 'John', 'Doe', 'John Doe', '+1234567890', true, true, false, NOW(), NOW()),
('user_002', 'jane.smith@example.com', '$2b$10$YourHashHere1234567890abcdefghijklmnopqrstuvwxyz', 'Jane', 'Smith', 'Jane Smith', '+1234567891', true, true, false, NOW(), NOW()),
('user_003', 'michael.brown@example.com', '$2b$10$YourHashHere1234567890abcdefghijklmnopqrstuvwxyz', 'Michael', 'Brown', 'Michael Brown', '+1234567892', true, true, false, NOW(), NOW()),
('user_004', 'sarah.wilson@example.com', '$2b$10$YourHashHere1234567890abcdefghijklmnopqrstuvwxyz', 'Sarah', 'Wilson', 'Sarah Wilson', '+1234567893', true, true, false, NOW(), NOW()),
('user_005', 'david.lee@example.com', '$2b$10$YourHashHere1234567890abcdefghijklmnopqrstuvwxyz', 'David', 'Lee', 'David Lee', '+1234567894', true, true, false, NOW(), NOW()),
('user_006', 'emily.chen@example.com', '$2b$10$YourHashHere1234567890abcdefghijklmnopqrstuvwxyz', 'Emily', 'Chen', 'Emily Chen', '+1234567895', true, true, false, NOW(), NOW()),
('user_007', 'robert.taylor@example.com', '$2b$10$YourHashHere1234567890abcdefghijklmnopqrstuvwxyz', 'Robert', 'Taylor', 'Robert Taylor', '+1234567896', true, true, false, NOW(), NOW()),
('user_008', 'lisa.anderson@example.com', '$2b$10$YourHashHere1234567890abcdefghijklmnopqrstuvwxyz', 'Lisa', 'Anderson', 'Lisa Anderson', '+1234567897', true, true, false, NOW(), NOW())

ON CONFLICT (id) DO NOTHING;

-- Note: To generate actual password hashes, you can use:
-- const bcrypt = require('bcrypt');
-- const hash = await bcrypt.hash('password123', 10);