-- Seed FAQ entries from existing static content

-- Worker FAQs
INSERT INTO faq_entries (category, question, answer, sort_order) VALUES
('worker', 'How does RateRight work for workers?', 'RateRight connects qualified construction workers with contractors who need skilled labour. Simply create your profile, verify your qualifications, and get matched with jobs that fit your skills and schedule.', 1),
('worker', 'Is RateRight free for workers?', 'Yes! It is completely free for workers to join, create a profile, and get matched with jobs. We do not charge any subscription fees or take a percentage of your earnings.', 2),
('worker', 'How do I get hired through RateRight?', 'Complete your profile with accurate information about your skills, experience, and certifications. Upload your White Card and any trade-specific licences. Contractors search our database and contact workers directly.', 3),
('worker', 'What trades does RateRight cover?', 'We cover all major construction trades including carpentry, plumbing, electrical, bricklaying, concreting, tiling, plastering, painting, landscaping, and general labour.', 4),
('worker', 'Do I need a White Card to join?', 'Yes, all workers must have a valid White Card (General Construction Induction Card) to work on Australian construction sites.', 5),
('worker', 'How quickly can I find work?', 'Many workers receive their first job invitation within 24–48 hours of profile approval.', 6),
('worker', 'How and when do I get paid?', 'Payment terms are agreed directly with the contractor before starting work. Most contractors pay weekly or fortnightly. RateRight does not handle payments.', 7),
('worker', 'Can I choose when and where I work?', 'Absolutely! You set your availability and preferred work locations in your profile.', 8),
('worker', 'How do I know if my application was successful?', E'You\'ll receive a notification in the app, plus an SMS and email when a contractor hires you. If the position is filled by someone else, you\'ll get a gentle heads-up so you can focus on other opportunities.', 9),
('worker', E'What happens if a job doesn\'t work out?', E'It happens. If the fit isn\'t right, both you and the contractor can leave constructive feedback. This helps improve future matches. There\'s no penalty — just keep your profile updated and you\'ll be matched to new jobs.', 10);

-- Contractor FAQs
INSERT INTO faq_entries (category, question, answer, sort_order) VALUES
('contractor', 'How does RateRight work for contractors?', 'RateRight gives you instant access to pre-verified construction workers. Search our database by trade, location, availability, and ratings.', 1),
('contractor', 'What is the $50 fee about?', 'We charge a flat $50 fee per successful hire. No subscriptions, no hidden costs, no percentage cuts.', 2),
('contractor', 'How long does the $50 cover?', 'Unlimited. Pay once, keep the worker forever. No ongoing fees whether they stay a day or 30 years.', 3),
('contractor', 'When do I pay the $50?', E'After you\'ve reviewed the worker\'s profile and decided to hire. We don\'t charge until there\'s a real match you want to proceed with.', 4),
('contractor', 'Is there a subscription or monthly fee?', 'No. Zero subscriptions. Zero monthly fees. You only pay $50 when you actually hire someone.', 5),
('contractor', 'What if I need 10 workers?', E'$50 each. Need 10 steelfixers? That\'s $500 total. An agency would charge $5–15/hour markup PER WORKER — you\'d pay that in the first week alone.', 6),
('contractor', 'How fast can I find workers?', 'Most contractors find suitable workers within hours. Many jobs are filled the same day they are posted.', 7),
('contractor', E'What if the worker isn\'t right after a day?', E'Leave constructive feedback — this helps the worker improve and the next contractor get a better match. Contact us and we\'ll help you find a replacement.', 8),
('contractor', 'What if the worker does not show up?', E'We take reliability seriously. Workers with no-shows are removed from the platform. Contact us immediately and we\'ll help you find a replacement quickly.', 9),
('contractor', 'How is this different from a labour hire company?', 'We''re a marketplace, not a labour hire company. You deal directly with workers. No agency markup. No middleman taking a cut of wages. Workers keep 100% of what you pay them.', 10),
('contractor', 'Do I handle payroll myself?', 'Yes. Workers are engaged directly by you, same as if you found them through a mate. Your normal payroll process applies.', 11),
('contractor', 'Are workers verified?', E'Yes. We verify White Cards and trade licences. If you suspect fraud, report it immediately — we\'ll investigate and remove bad actors.', 12),
('contractor', 'Can I see ratings before hiring?', E'Yes. Every worker has a profile with ratings from previous contractors. Ratings are constructive — they tell you what the worker is good at and where they can improve.', 13),
('contractor', 'Can I post a job or do I search?', E'Both! Post a job and we\'ll match you with qualified workers, or search our verified worker database by trade, location, and availability.', 14),
('contractor', 'How many workers can I contact?', 'As many as you need! There is no limit to how many workers you can view or contact.', 15),
('contractor', 'How do I get an invoice or receipt?', E'You\'ll receive an automatic receipt via email after payment. ABN invoices are available on request for your records.', 16),
('contractor', 'What areas does RateRight cover?', E'All of Australia. Sydney, Melbourne, Brisbane, Perth, Adelaide, Newcastle, and growing. Construction doesn\'t stop at city limits — neither do we.', 17),
('contractor', 'How do I contact a worker after hiring?', E'Immediately after hiring, you\'ll see the worker\'s phone number, email, and a direct call button on their profile. You can call, text, or email them straight from the app. We also send the worker an SMS and email so they know you\'re expecting to hear from them.', 18);

-- General FAQs
INSERT INTO faq_entries (category, question, answer, sort_order) VALUES
('general', 'Is RateRight a labour hire company?', 'No. RateRight is a marketplace that connects contractors directly with workers. No agency markup, no middleman. Workers keep 100% of their wages.', 1),
('general', 'How is payment handled?', 'Payment is arranged directly between the contractor and worker. RateRight does not process wages or take a percentage. We only charge a flat $50 hire fee to the contractor.', 2),
('general', 'What areas do you cover?', E'All of Australia. We\'re national from day one — Sydney, Melbourne, Brisbane, Perth, Adelaide, Newcastle, and every town in between.', 3),
('general', 'Is there a rating system?', 'Yes, both workers and contractors can rate each other after completing a job.', 4),
('general', 'How do I get started?', 'Simply visit our website and click Sign Up. Workers create a profile with their skills and qualifications. Contractors can start searching immediately.', 5),
('general', 'What makes RateRight different?', 'Unlike traditional labour hire companies, we charge contractors a simple flat fee with no ongoing subscriptions. Workers keep 100% of their wages.', 6);
