-- ============================================================
-- JobConnect - Seed Data
-- ============================================================

-- ------------------------------------------------------------
-- STATES (India)
-- ------------------------------------------------------------
INSERT INTO states (name) VALUES
('Bihar'),('Uttar Pradesh'),('Delhi'),('Maharashtra'),('West Bengal'),
('Jharkhand'),('Karnataka'),('Tamil Nadu'),('Telangana'),('Gujarat'),
('Rajasthan'),('Madhya Pradesh'),('Haryana'),('Punjab'),('Odisha'),
('Kerala'),('Assam'),('Chhattisgarh'),('Andhra Pradesh'),('Uttarakhand');

-- ------------------------------------------------------------
-- CITIES (sample per state - Bihar/UP given more since primary market)
-- ------------------------------------------------------------
INSERT INTO cities (state_id, name) VALUES
((SELECT id FROM states WHERE name='Bihar'), 'Patna'),
((SELECT id FROM states WHERE name='Bihar'), 'Gaya'),
((SELECT id FROM states WHERE name='Bihar'), 'Muzaffarpur'),
((SELECT id FROM states WHERE name='Bihar'), 'Bhagalpur'),
((SELECT id FROM states WHERE name='Bihar'), 'Darbhanga'),
((SELECT id FROM states WHERE name='Bihar'), 'Purnia'),
((SELECT id FROM states WHERE name='Uttar Pradesh'), 'Lucknow'),
((SELECT id FROM states WHERE name='Uttar Pradesh'), 'Kanpur'),
((SELECT id FROM states WHERE name='Uttar Pradesh'), 'Varanasi'),
((SELECT id FROM states WHERE name='Uttar Pradesh'), 'Noida'),
((SELECT id FROM states WHERE name='Uttar Pradesh'), 'Ghaziabad'),
((SELECT id FROM states WHERE name='Uttar Pradesh'), 'Prayagraj'),
((SELECT id FROM states WHERE name='Delhi'), 'New Delhi'),
((SELECT id FROM states WHERE name='Maharashtra'), 'Mumbai'),
((SELECT id FROM states WHERE name='Maharashtra'), 'Pune'),
((SELECT id FROM states WHERE name='Maharashtra'), 'Nagpur'),
((SELECT id FROM states WHERE name='West Bengal'), 'Kolkata'),
((SELECT id FROM states WHERE name='Jharkhand'), 'Ranchi'),
((SELECT id FROM states WHERE name='Jharkhand'), 'Jamshedpur'),
((SELECT id FROM states WHERE name='Karnataka'), 'Bengaluru'),
((SELECT id FROM states WHERE name='Tamil Nadu'), 'Chennai'),
((SELECT id FROM states WHERE name='Telangana'), 'Hyderabad'),
((SELECT id FROM states WHERE name='Gujarat'), 'Ahmedabad'),
((SELECT id FROM states WHERE name='Gujarat'), 'Surat'),
((SELECT id FROM states WHERE name='Rajasthan'), 'Jaipur'),
((SELECT id FROM states WHERE name='Madhya Pradesh'), 'Indore'),
((SELECT id FROM states WHERE name='Madhya Pradesh'), 'Bhopal'),
((SELECT id FROM states WHERE name='Haryana'), 'Gurugram'),
((SELECT id FROM states WHERE name='Haryana'), 'Faridabad'),
((SELECT id FROM states WHERE name='Punjab'), 'Ludhiana'),
((SELECT id FROM states WHERE name='Punjab'), 'Amritsar'),
((SELECT id FROM states WHERE name='Odisha'), 'Bhubaneswar'),
((SELECT id FROM states WHERE name='Kerala'), 'Kochi'),
((SELECT id FROM states WHERE name='Assam'), 'Guwahati'),
((SELECT id FROM states WHERE name='Chhattisgarh'), 'Raipur'),
((SELECT id FROM states WHERE name='Andhra Pradesh'), 'Visakhapatnam'),
((SELECT id FROM states WHERE name='Uttarakhand'), 'Dehradun');

-- ------------------------------------------------------------
-- JOB CATEGORIES (from PRD)
-- ------------------------------------------------------------
INSERT INTO job_categories (name, slug, icon, sort_order) VALUES
('Office Jobs', 'office-jobs', 'bi-building', 1),
('Field Jobs', 'field-jobs', 'bi-geo-alt', 2),
('Factory Jobs', 'factory-jobs', 'bi-gear', 3),
('Hospital Jobs', 'hospital-jobs', 'bi-heart-pulse', 4);

-- ------------------------------------------------------------
-- DEFAULT ADMIN (username: admin / password: Admin@123)
-- Password hash generated with PHP password_hash(), bcrypt
-- ------------------------------------------------------------
INSERT INTO admin_users (name, email, username, password, role, status) VALUES
('Super Admin', 'admin@jobconnect.local', 'admin', '$2y$10$ZGhD6O5xLLeGxfjXlUsemejp1MMu48BnD6H9DsydrDcJcRy6he5tC', 'super_admin', 1);

-- ------------------------------------------------------------
-- CMS PAGES (empty shells, admin fills later)
-- ------------------------------------------------------------
INSERT INTO cms_pages (slug, title, content) VALUES
('about-us', 'About Us', '<p>Content coming soon.</p>'),
('privacy-policy', 'Privacy Policy', '<p>Content coming soon.</p>'),
('terms', 'Terms & Conditions', '<p>Content coming soon.</p>'),
('contact-us', 'Contact Us', '<p>Content coming soon.</p>'),
('help-center', 'Help Center', '<p>Content coming soon.</p>');

-- ------------------------------------------------------------
-- SETTINGS
-- ------------------------------------------------------------
INSERT INTO settings (setting_key, setting_value) VALUES
('site_name', 'JobConnect'),
('support_email', 'support@jobconnect.local'),
('support_mobile', ''),
('otp_expiry_minutes', '10'),
('resume_max_size_mb', '5'),
('job_auto_expire_days', '30');