-- Touch Therapies Antigua — demo/production seed content.
-- Portable SQL: runs on both MySQL 8 and SQLite.
-- Default admin login: admin@touchtherapiesantigua.com / ChangeMe!2026
-- (change it immediately after first login).

INSERT INTO roles (id, name) VALUES (1, 'admin'), (2, 'editor');

INSERT INTO permissions (role_id, name) VALUES
(1, '*'),
(2, 'content.read'), (2, 'content.write');

INSERT INTO users (role_id, name, email, password_hash, active) VALUES
(1, 'Administrator', 'admin@touchtherapiesantigua.com', '$2y$10$HjSM.vG4EeV0BMHQISMtSOw9v09g3UiMpKdg1k/8vQ7maHsQK2LqC', 1);

INSERT INTO settings (name, value) VALUES
('company_name', 'Touch Therapies Antigua'),
('tagline', 'Your sanctuary for relaxation, rejuvenation, and wellness in the heart of Antigua'),
('logo_text', 'Touch Therapies'),
('address', 'St. John''s, Antigua & Barbuda'),
('phone', '+1 (268) 562-1286'),
('whatsapp', '+1 (268) 785-8166'),
('email', 'islandmassage@hotmail.com'),
('map_query', 'St. John''s, Antigua and Barbuda'),
('instagram_handle', '@touchtherapiesantigua'),
('meta_title', 'Touch Therapies Antigua — Caribbean Wellness & Massage'),
('meta_description', 'Your sanctuary for relaxation, rejuvenation, and wellness in the heart of Antigua. ITEC-certified massage and spa therapies in St. John''s.'),
('hours', '[{"day":"Sunday","time":"10:00 AM – 6:00 PM"},{"day":"Monday","time":"10:00 AM – 6:00 PM"},{"day":"Tuesday","time":"10:00 AM – 6:00 PM"},{"day":"Wednesday","time":"10:00 AM – 6:00 PM"},{"day":"Thursday","time":"10:00 AM – 6:00 PM"},{"day":"Friday","time":"10:00 AM – 6:00 PM"},{"day":"Saturday","time":"Closed","closed":true}]'),
('social', '{"facebook":"#","instagram":"#","whatsapp":"https://wa.me/12687858166"}');

INSERT INTO homepage_sections (section, content, active) VALUES
('hero', '{"kicker":"St. John''s · Antigua & Barbuda","title":"Your Sanctuary of","title_em":"Caribbean Wellness","subtitle":"Relaxation, rejuvenation, and healing in the heart of Antigua — where ITEC-certified hands meet the calm of the Caribbean Sea.","image":"https://images.unsplash.com/photo-1519046904884-53103b34b206?auto=format&fit=crop&w=2000&q=80","cta_primary":{"label":"Explore Treatments","href":"/treatments"},"cta_secondary":{"label":"Wellness Packages","href":"/packages"}}', 1),
('welcome', '{"eyebrow":"Welcome to Touch Therapies","title":"Where Island Calm Meets Professional Care","body":["Nestled in St. John''s, Touch Therapies Antigua has been the island''s trusted wellness sanctuary for over fifteen years. Our ITEC-certified therapists blend time-honoured Caribbean healing traditions with professional therapeutic technique.","From the moment you arrive, the rhythm of the island slows your pulse — warm sea air, gentle hands, and treatments crafted to restore body and mind."],"points":["ITEC Certified Professional Therapists","Authentic Caribbean techniques & natural products","Rated 5.0 on TripAdvisor & Google"],"image_main":"https://images.unsplash.com/photo-1600334129128-685c5582fd35?auto=format&fit=crop&w=1000&q=80","image_float":"https://images.unsplash.com/photo-1507525428034-b723cf961d3e?auto=format&fit=crop&w=800&q=80","years_badge":"15+"}', 1),
('signature', '{"eyebrow":"The Signature Experience","title":"The Wadadli Ritual — Antigua in a Massage","body":["Named after the island''s original Amerindian name, the Wadadli Massage is our love letter to Antigua: warm coconut oil, wave-like strokes, and the unhurried rhythm of island life. It''s the treatment our guests fly back for."],"image":"https://images.unsplash.com/photo-1544161515-4ab6ce6db874?auto=format&fit=crop&w=2000&q=80","facts":[{"value":"45 min","label":"Pure escape"},{"value":"$52","label":"USD per session"},{"value":"#1","label":"Guest favourite"}],"cta_label":"Reserve Your Ritual"}', 1),
('why', '{"eyebrow":"Why Choose Us","title":"Trusted Hands. Island Heart.","features":[{"icon":"star","title":"ITEC Certified","body":"Internationally certified professional therapists you can trust with your wellbeing."},{"icon":"clock","title":"15+ Years Experience","body":"A decade and a half of perfecting the art of Caribbean therapeutic massage."},{"icon":"heart","title":"Natural & Luxurious","body":"Premium Eminence products and island-grown botanicals in every treatment."},{"icon":"users","title":"10,000+ Happy Guests","body":"Locals and travellers alike return year after year — and tell their friends."}],"stats":[{"value":"15+","label":"Years of Experience"},{"value":"10,000+","label":"Happy Guests"},{"value":"5.0 ★","label":"TripAdvisor & Google"},{"value":"100%","label":"Certified Therapists"}]}', 1);

INSERT INTO pages (slug, title, body, active) VALUES
('privacy', 'Privacy Policy', '<p>Touch Therapies Antigua respects your privacy. We collect only the information needed to manage bookings and enquiries — your name, contact details, and appointment preferences.</p><h2>What we collect</h2><p>Contact form submissions, booking details, and anonymous website analytics.</p><h2>How we use it</h2><p>To respond to enquiries, manage appointments, and improve our services. We never sell your data to third parties.</p><h2>Your rights</h2><p>You may request a copy or deletion of your personal data at any time by emailing us.</p>', 1),
('terms', 'Terms of Service', '<p>By booking a treatment with Touch Therapies Antigua you agree to the following terms.</p><h2>Bookings & payment</h2><p>Prices are quoted in USD. Payment is due at the time of service unless otherwise arranged.</p><h2>Cancellations</h2><p>Cancellations made 24+ hours in advance are fully refundable; later cancellations incur a 50% fee.</p><h2>Health conditions</h2><p>Please disclose any medical conditions, injuries, or pregnancy before your session so we can adapt your treatment safely.</p>', 1);

INSERT INTO treatment_categories (id, name) VALUES (1, 'Massage'), (2, 'Body');

INSERT INTO treatments (category_id, slug, name, description, duration, price, image, featured, status, sort_order) VALUES
(1, 'wadadli-massage', 'Wadadli Massage', 'Our signature island massage — flowing, rhythmic strokes inspired by the waves of Antigua''s own shores.', '45 minutes', 52.00, 'https://images.unsplash.com/photo-1544161515-4ab6ce6db874?auto=format&fit=crop&w=800&q=80', 1, 1, 1),
(1, 'hot-stone-massage', 'Hot Stone Massage', 'Warm volcanic stones ease deep muscle tension while radiant heat carries you into complete stillness.', '1 hour', 93.00, 'https://images.unsplash.com/photo-1600334089648-b0d9d3028eb2?auto=format&fit=crop&w=800&q=80', 1, 1, 2),
(1, 'couples-therapeutic-massage', 'Couples Therapeutic Massage', 'Side-by-side relaxation for two — the perfect shared escape for honeymoons and anniversaries.', '1 hour', 162.00, 'https://images.unsplash.com/photo-1591343395902-1adcb454c4e2?auto=format&fit=crop&w=800&q=80', 1, 1, 3),
(2, 'mud-wrap', 'Mud Wrap', 'A detoxifying full-body wrap with mineral-rich mud that softens skin and draws out impurities.', '1 hour', 85.00, 'https://images.unsplash.com/photo-1570172619644-dfd03ed5d881?auto=format&fit=crop&w=800&q=80', 1, 1, 4);

INSERT INTO packages (slug, name, tag, dates_label, description, included, price, price_label, promo_price, promo_label, image, active, sort_order) VALUES
('5-night-wellness-escape', '5-Night Wellness Escape', 'Nov 5–10, 2026', 'Limited spaces · Book early', 'Wake to Caribbean breakfasts, unwind with daily therapies, and let the island do the rest. Everything is arranged from the moment you land.', '["Guest house accommodation","Airport pickup & transfers","Daily Caribbean breakfast","45-min back massage","Luxury Eminence facial"]', 700.00, 'per person · double', 1000.00, 'single occupancy', 'https://images.unsplash.com/photo-1540541338287-41700207dee6?auto=format&fit=crop&w=1200&q=80', 1, 1);

INSERT INTO gallery (id, name) VALUES (1, 'Spa'), (2, 'Island');

INSERT INTO gallery_images (gallery_id, src, alt, size, active, sort_order) VALUES
(1, 'https://images.unsplash.com/photo-1544161515-4ab6ce6db874?auto=format&fit=crop&w=700&q=80', 'Massage therapy', 'tall', 1, 1),
(2, 'https://images.unsplash.com/photo-1507525428034-b723cf961d3e?auto=format&fit=crop&w=1000&q=80', 'Antigua beach', 'wide', 1, 2),
(1, 'https://images.unsplash.com/photo-1570172619644-dfd03ed5d881?auto=format&fit=crop&w=700&q=80', 'Facial treatment', NULL, 1, 3),
(1, 'https://images.unsplash.com/photo-1519823551278-64ac92734fb1?auto=format&fit=crop&w=700&q=80', 'Spa stones', NULL, 1, 4),
(1, 'https://images.unsplash.com/photo-1596178065887-1198b6148b2b?auto=format&fit=crop&w=700&q=80', 'Hot stone therapy', NULL, 1, 5),
(2, 'https://images.unsplash.com/photo-1540541338287-41700207dee6?auto=format&fit=crop&w=1000&q=80', 'Resort pool', 'wide', 1, 6);

INSERT INTO testimonials (client_name, location, review, rating, photo, date, approved, sort_order) VALUES
('Sarah M.', 'London, UK', 'The Wadadli Massage was the highlight of our entire trip to Antigua. I''ve had massages all over the world — nothing compares to this.', 5, 'https://images.unsplash.com/photo-1494790108377-be9c29b29330?auto=format&fit=crop&w=200&q=80', '2026-05-14', 1, 1),
('Danielle R.', 'Toronto, Canada', 'My husband and I did the couples massage for our anniversary. Professional, warm, and utterly relaxing. We''re already planning our return.', 5, 'https://images.unsplash.com/photo-1573496359142-b8d87734a5a2?auto=format&fit=crop&w=200&q=80', '2026-04-02', 1, 2),
('Marcus T.', 'New York, USA', 'Fifteen years of experience shows in every detail. The hot stone massage undid months of desk-job tension in one hour.', 5, 'https://images.unsplash.com/photo-1507003211169-0a1dd7228f2d?auto=format&fit=crop&w=200&q=80', '2026-03-19', 1, 3);

INSERT INTO team_members (name, position, bio, photo, socials, active, sort_order) VALUES
('Sharon Joseph', 'Founder & Lead Therapist', 'ITEC-certified with 15+ years of experience, Sharon founded Touch Therapies to share authentic Caribbean healing with the world.', 'https://images.unsplash.com/photo-1580489944761-15a19d654956?auto=format&fit=crop&w=700&q=80', '{"instagram":"#","facebook":"#"}', 1, 1),
('Kimberly Browne', 'Senior Massage Therapist', 'A specialist in deep tissue and hot stone therapy, Kimberly brings a decade of five-star spa experience.', 'https://images.unsplash.com/photo-1594744803329-e58b31de8bf5?auto=format&fit=crop&w=700&q=80', '{"instagram":"#"}', 1, 2),
('Andrea Charles', 'Wellness & Spa Therapist', 'Andrea crafts every facial and body wrap around island-grown botanicals and premium Eminence skincare.', 'https://images.unsplash.com/photo-1544005313-94ddf0286df2?auto=format&fit=crop&w=700&q=80', '{"instagram":"#"}', 1, 3);

INSERT INTO blog_categories (id, name) VALUES (1, 'Wellness'), (2, 'Island Life'), (3, 'Travel');

INSERT INTO blogs (category_id, slug, title, excerpt, body, image, tags, status, published_at) VALUES
(1, 'benefits-of-hot-stone-massage', '5 Benefits of Hot Stone Massage You Didn''t Know', 'Beyond deep relaxation, warmed stones improve circulation, ease chronic pain, and calm the nervous system.', '<p>Hot stone massage is more than an indulgence — it is one of the most therapeutic treatments on our menu.</p><h2>1. Improved circulation</h2><p>The radiant heat of volcanic stones dilates blood vessels, improving oxygen flow to tired muscles.</p><h2>2. Deeper muscle release</h2><p>Heat lets your therapist work deeper layers of tissue without added pressure.</p><h2>3. A calmer nervous system</h2><p>Warmth signals safety to the body, easing it out of fight-or-flight.</p><h2>4. Better sleep</h2><p>Guests routinely report their best night of sleep after a hot stone session.</p><h2>5. Relief from chronic pain</h2><p>Regular sessions can ease arthritis and fibromyalgia symptoms.</p>', 'https://images.unsplash.com/photo-1596178065887-1198b6148b2b?auto=format&fit=crop&w=800&q=80', '["massage","hot stone","wellness"]', 'published', '2026-06-10 09:00:00'),
(2, 'wadadli-antiguas-signature-treatment', 'Why the Wadadli Massage Is Antigua''s Signature Treatment', 'The story behind our most-loved therapy — and the island name that inspired it.', '<p>Before Antigua was Antigua, the island''s first inhabitants called it <em>Wadadli</em>. Our signature massage honours that heritage.</p><p>Warm coconut oil, wave-like strokes and an unhurried rhythm make it the treatment our guests cross oceans to repeat.</p>', 'https://images.unsplash.com/photo-1506929562872-bb421503ef21?auto=format&fit=crop&w=800&q=80', '["wadadli","signature","antigua"]', 'published', '2026-05-22 09:00:00'),
(3, 'planning-your-caribbean-wellness-retreat', 'Planning Your Caribbean Wellness Retreat', 'What to pack, when to come, and how to make the most of five restorative nights in Antigua.', '<p>A wellness retreat is the reset button modern life rarely offers. Here is how to plan yours.</p><h2>When to come</h2><p>November through April brings perfect weather; our 5-Night Wellness Escape runs November 5–10.</p><h2>What to pack</h2><p>Light layers, reef-safe sunscreen, and as few obligations as possible.</p>', 'https://images.unsplash.com/photo-1414235077428-338989a2e8c0?auto=format&fit=crop&w=800&q=80', '["retreat","travel","packages"]', 'published', '2026-04-30 09:00:00');

INSERT INTO faqs (question, answer, active, sort_order) VALUES
('Do I need to book in advance?', 'We recommend booking at least 48 hours ahead, especially in high season (November–April). WhatsApp us for same-day availability.', 1, 1),
('What should I bring to my appointment?', 'Just yourself. We provide towels, robes, and premium oils and products. Arrive 10 minutes early to unwind before your session.', 1, 2),
('Do you offer mobile / in-villa services?', 'Yes — our therapists can come to your villa, yacht, or hotel anywhere on Antigua. Contact us for mobile rates.', 1, 3),
('What is your cancellation policy?', 'Cancellations made 24 hours or more before your appointment are fully refundable. Later cancellations incur a 50% fee.', 1, 4),
('Are your therapists certified?', 'Every therapist is ITEC certified (International Therapy Examination Council) with a minimum of five years of professional experience.', 1, 5);
