-- Disable foreign key checks for inserting data
SET FOREIGN_KEY_CHECKS = 0;

-- Admins
-- Password is 'password' (hashed)
INSERT INTO admins (name, email, password) VALUES 
('Super Admin', 'admin@helperlink.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi');

-- Lookups
INSERT INTO countries (name_en, phone_code) VALUES ('United Arab Emirates', '+971');

INSERT INTO cities (country_id, name_en) VALUES 
(1, 'Dubai'), (1, 'Abu Dhabi'), (1, 'Sharjah');

INSERT INTO nationalities (name_en) VALUES 
('Filipino'), ('Indonesian'), ('Sri Lankan'), ('Ethiopian'), ('Nepalese');

INSERT INTO languages (name_en, code) VALUES 
('English', 'en'), ('Arabic', 'ar'), ('Tagalog', 'tl'), ('Hindi', 'hi'), ('Urdu', 'ur');

INSERT INTO specialties (name_en) VALUES 
('Baby Care'), ('Elderly Care'), ('Pet Care'), ('Cooking'), ('Cleaning');

INSERT INTO skills (name_en) VALUES 
('Ironing'), ('Washing'), ('Driving'), ('Tutoring'), ('First Aid');

INSERT INTO service_models (name_en) VALUES 
('Live-in'), ('Live-out'), ('Part-time'), ('Full-time');

INSERT INTO accommodation_types (name_en) VALUES 
('Apartment'), ('Villa'), ('Townhouse'), ('Studio');

INSERT INTO interview_platforms (name) VALUES 
('Zoom'), ('Google Meet'), ('WhatsApp Video'), ('In-person');

INSERT INTO document_types (owner_type, name_en, is_required) VALUES 
('vendor', 'Trade License', 1),
('maid', 'Passport Copy', 1),
('maid', 'Visa Copy', 1),
('maid', 'Medical Certificate', 0);

-- CMS
INSERT INTO onboarding_screens (user_type, title_en, description_en, image, sort_order) VALUES 
('customer', 'Welcome to HelperLink', 'Find the best domestic helpers easily.', 'onboarding_1.png', 1),
('customer', 'Trusted Vendors', 'We partner with verified agencies.', 'onboarding_2.png', 2),
('customer', 'Easy Process', 'Interview, request quotation, and sign contract in app.', 'onboarding_3.png', 3);

INSERT INTO app_settings (setting_key, setting_value, setting_type) VALUES 
('app_name', 'HelperLink', 'text'),
('support_email', 'support@helperlink.com', 'text'),
('support_phone', '+971500000000', 'text'),
('terms_conditions', 'Terms and conditions text here...', 'text');

SET FOREIGN_KEY_CHECKS = 1;
