-- ========== 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);

-- Insert Websites with various configurations
INSERT INTO websites (
    id, name, slug, domain, da, dr, traffic, spam_score, backlinks, link_type,
    base_price, sale_price, content_service_price, category_id, user_id,
    niches, niche_pricing, description, meta_title, meta_description,
    is_indexable, status, featured, featured_image, featured_image_alt_text, created_at, updated_at
) VALUES
-- Website 1: Tech Blog (Active, Featured)
(
    'web_001', 'TechCrunch', 'techcrunch', 'techcrunch.com',
    85, 82, '2500000', 5, 150000, 'Dofollow',
    499.99, NULL, 30.00, 'cat_gen_001', 'user_001',
    '["cat_gen_002", "cat_gen_003", "cat_gen_004"]', '{}',
    'Leading technology news and analysis website covering startups, gadgets, and innovation',
    'TechCrunch | Technology News and Analysis', 'Latest technology news, startup coverage, and gadget reviews',
    true, 'active', true, 'https://example.com/images/techcrunch.jpg', 'TechCrunch website logo and featured image',
    NOW(), NOW()
),
-- Website 2: Business Insider (Active)
(
    'web_002', 'Business Insider', 'business-insider', 'businessinsider.com',
    88, 85, '5000000', 8, 250000, 'Dofollow',
    599.99, 499.99, 35.00, 'cat_gen_002', 'user_002',
    '["cat_gen_001", "cat_gen_008"]', '{}',
    'Business news, financial insights, and market analysis',
    'Business Insider | Business News and Financial Insights', 'Latest business news, financial markets, and economic analysis',
    true, 'active', false, 'https://example.com/images/business-insider.jpg', 'Business Insider featured image',
    NOW(), NOW()
),
-- Website 3: Healthline (Active, with Special Niches)
(
    'web_003', 'Healthline', 'healthline', 'healthline.com',
    75, 70, '1500000', 10, 80000, 'Dofollow',
    399.99, NULL, 25.00, 'cat_gen_003', 'user_003',
    '["cat_gen_001", "cat_gen_005"]', '{"cat_spec_003": 599.99, "cat_spec_001": 699.99}',
    'Health and wellness information, medical news, and fitness guides',
    'Healthline | Trusted Health and Wellness Information', 'Evidence-based health information, medical news, and fitness guides',
    true, 'active', false, 'https://example.com/images/healthline.jpg', 'Healthline featured image with wellness concept',
    NOW(), NOW()
),
-- Website 4: Travel + Leisure (Active, with Special Niches)
(
    'web_004', 'Travel + Leisure', 'travel-leisure', 'travelandleisure.com',
    72, 68, '1200000', 12, 60000, 'Nofollow',
    349.99, 299.99, 28.00, 'cat_gen_004', 'user_004',
    '["cat_gen_005", "cat_gen_006"]', '{"cat_spec_002": 499.99, "cat_spec_003": 449.99}',
    'Travel guides, destination reviews, and vacation inspiration',
    'Travel + Leisure | Best Travel Destinations and Guides', 'Discover amazing travel destinations, hotel reviews, and vacation tips',
    true, 'active', true, 'https://example.com/images/travel-leisure.jpg', 'Beautiful travel destination featured image',
    NOW(), NOW()
),
-- Website 5: Epicurious (Active)
(
    'web_005', 'Epicurious', 'epicurious', 'epicurious.com',
    65, 62, '800000', 15, 45000, 'Dofollow',
    299.99, 249.99, 22.00, 'cat_gen_005', 'user_005',
    '["cat_gen_003", "cat_gen_006"]', '{}',
    'Recipes, cooking tips, and food inspiration for home cooks',
    'Epicurious | Recipes and Cooking Inspiration', 'Find delicious recipes, cooking tips, and food inspiration',
    true, 'active', false, 'https://example.com/images/epicurious.jpg', 'Delicious food recipe featured image',
    NOW(), NOW()
),
-- Website 6: Vogue (Active, Featured, with Special Niches)
(
    'web_006', 'Vogue', 'vogue', 'vogue.com',
    90, 88, '8000000', 3, 500000, 'Dofollow',
    799.99, 699.99, 50.00, 'cat_gen_006', 'user_006',
    '["cat_gen_001", "cat_gen_004"]', '{"cat_spec_004": 999.99, "cat_spec_001": 899.99}',
    'Fashion, beauty, culture, and lifestyle magazine',
    'Vogue | Fashion, Beauty, and Lifestyle', 'Latest fashion trends, beauty tips, and cultural insights',
    true, 'active', true, 'https://example.com/images/vogue.jpg', 'Vogue fashion editorial featured image',
    NOW(), NOW()
),
-- Website 7: ESPN (Active)
(
    'web_007', 'ESPN', 'espn', 'espn.com',
    92, 90, '12000000', 2, 1000000, 'Dofollow',
    899.99, NULL, 45.00, 'cat_gen_007', 'user_007',
    '["cat_gen_001", "cat_gen_002"]', '{"cat_spec_005": 1099.99}',
    'Sports news, scores, analysis, and exclusive coverage',
    'ESPN | Sports News and Scores', 'Breaking sports news, live scores, and expert analysis',
    true, 'active', true, 'https://example.com/images/espn.jpg', 'ESPN sports action featured image',
    NOW(), NOW()
),
-- Website 8: Coursera (Active)
(
    'web_008', 'Coursera', 'coursera', 'coursera.org',
    82, 78, '1800000', 6, 120000, 'Nofollow',
    449.99, 399.99, 32.00, 'cat_gen_008', 'user_008',
    '["cat_gen_001", "cat_gen_002", "cat_gen_003"]', '{"cat_spec_006": 649.99}',
    'Online courses, certificates, and degrees from top universities',
    'Coursera | Online Courses and Certificates', 'Learn from top universities with online courses and certificates',
    true, 'active', false, 'https://example.com/images/coursera.jpg', 'Coursera online learning featured image',
    NOW(), NOW()
),
-- Website 9: Inactive Website
(
    'web_009', 'Old Tech Blog', 'old-tech-blog', 'oldtechblog.com',
    45, 40, '50000', 35, 5000, 'Nofollow',
    99.99, NULL, 15.00, 'cat_gen_001', 'user_001',
    '["cat_gen_005"]', '{}',
    'Outdated technology blog with legacy content',
    'Old Tech Blog | Legacy Technology Content', 'Archive of old technology articles and reviews',
    true, 'inactive', false, NULL, NULL,
    NOW(), NOW()
),
-- Website 10: Sold Out Website
(
    'web_010', 'Premium Fashion', 'premium-fashion', 'premiumfashion.com',
    95, 92, '5000000', 2, 300000, 'Dofollow',
    999.99, NULL, 60.00, 'cat_gen_006', 'user_006',
    '["cat_gen_001", "cat_gen_004", "cat_gen_008"]', '{"cat_spec_004": 1499.99, "cat_spec_001": 1299.99}',
    'Premium fashion content, designer interviews, exclusive access',
    'Premium Fashion | Exclusive Designer Content', 'Exclusive fashion content, designer interviews, and luxury insights',
    true, 'sold_out', true, 'https://example.com/images/premium-fashion.jpg', 'Luxury fashion editorial featured image',
    NOW(), NOW()
),
-- Website 11: Business News (Active, with Executive Business Special)
(
    'web_011', 'Business News Daily', 'business-news-daily', 'businessnewsdaily.com',
    78, 75, '900000', 9, 75000, 'Dofollow',
    549.99, 499.99, 38.00, 'cat_gen_002', 'user_002',
    '["cat_gen_001", "cat_gen_008"]', '{"cat_spec_006": 799.99}',
    'Daily business news, entrepreneurship tips, and market trends',
    'Business News Daily | Entrepreneurship and Market Trends', 'Daily business news, startup advice, and market insights',
    true, 'active', false, 'https://example.com/images/business-news.jpg', 'Business news and market trends featured image',
    NOW(), NOW()
),
-- Website 12: Wellness Today (Active)
(
    'web_012', 'Wellness Today', 'wellness-today', 'wellnesstoday.com',
    55, 52, '300000', 18, 15000, 'Nofollow',
    199.99, 149.99, 18.00, 'cat_gen_003', 'user_003',
    '["cat_gen_005", "cat_gen_006"]', '{}',
    'Holistic wellness, mental health, and natural remedies',
    'Wellness Today | Holistic Health and Wellness', 'Discover holistic wellness, mental health tips, and natural remedies',
    true, 'active', false, 'https://example.com/images/wellness-today.jpg', 'Wellness and mental health featured image',
    NOW(), NOW()
)

ON CONFLICT (id) DO NOTHING;

-- Note: For niche_pricing JSONB fields, the format is:
-- {"cat_spec_001": 699.99, "cat_spec_002": 499.99}
-- Where the keys are category IDs from the SPECIAL categories table