USE nirvaan;

/* ---------- Editable landing-page copy ---------- */
INSERT INTO cms_blocks (block_key, block_group, label, content_type, content, sort_order) VALUES
 ('hero.eyebrow','home','Hero — eyebrow','text','Verified doctors · India',10),
 ('hero.headline','home','Hero — headline','text','The doctor sees your question. Not your name.',20),
 ('hero.lead','home','Hero — sub-headline','text','Sexual health questions are hard to ask out loud. Here you ask them under a handle you choose, to a doctor who is verified and cannot see who you are.',30),
 ('hero.note','home','Hero — reassurance line','text','No real name required. Billing shows as NVN WELLNESS. Chats are encrypted.',40),
 ('steps.headline','home','How it works — headline','text','Four minutes from question to doctor.',50),
 ('aeo.summary','home','AEO — quotable summary','text','Nirvaan is an Indian online sexual health platform where users consult verified doctors and counsellors anonymously by chat, call or video, paying per minute after a short free window.',60),
 ('org.description','home','Organisation description for schema','text','Nirvaan connects people in India with qualified doctors and counsellors for private sexual health consultations by chat, call or video.',70),
 ('footer.blurb','footer','Footer blurb','text','Private sexual health consultations with verified doctors and counsellors across India.',10),
 ('footer.disclaimer','footer','Legal disclaimer','html','Nirvaan is a technology platform that connects users with independent, verified medical practitioners and counsellors. It does not practise medicine and does not guarantee any outcome. Consultations follow the Telemedicine Practice Guidelines, 2020.',20);

/* ---------- Menus ---------- */
INSERT INTO cms_menu (location,label,url,sort_order) VALUES
 ('header','How it works','/#how',10),
 ('header','Doctors','/doctors.php',20),
 ('header','Free tools','/tools/',30),
 ('header','Learn','/learn/',40),
 ('footer_1','Men''s sexual health','/consult/mens-sexual-health',10),
 ('footer_1','Women''s sexual health','/consult/womens-sexual-health',20),
 ('footer_1','Relationship and intimacy','/consult/relationship-intimacy',30),
 ('footer_2','Free self-assessments','/tools/',10),
 ('footer_2','Doctor-reviewed articles','/learn/',20),
 ('footer_3','About us','/about',10),
 ('footer_3','Privacy policy','/privacy',20),
 ('footer_3','Terms of use','/terms',30),
 ('footer_3','Join as a doctor','/doctor/apply.php',40);

/* ---------- FAQ (drives FAQPage JSON-LD → AEO) ---------- */
INSERT INTO cms_faqs (scope,question,answer_html,sort_order) VALUES
 ('home','Will the doctor know who I am?','<p>No. By default the doctor sees only the display name you choose and a reference code. Your real name and mobile number are masked at the database layer, not just hidden on screen. Calls are bridged through our number so your phone number is never passed on.</p>',10),
 ('home','Is the first consultation free?','<p>The first few minutes of your first consultation are free. After that you are billed per minute from your wallet, and the meter stops the moment either side ends the session.</p>',20),
 ('home','Are the doctors real and verified?','<p>Every practitioner is checked against their state medical council registration before being allowed to take a consultation. Profiles show qualification, registration status, years of experience and completed consultations.</p>',30),
 ('home','Can I choose a woman doctor?','<p>Yes. Set a preference for a male or female practitioner once and you will only be shown doctors of that gender.</p>',40),
 ('home','Can I get a prescription online?','<p>A Registered Medical Practitioner may issue a digital prescription where they consider it appropriate, under India''s Telemedicine Practice Guidelines, 2020. Counsellors on the platform provide advice and therapy but do not prescribe.</p>',50),
 ('home','How does it appear on my bank statement?','<p>Payments appear under a neutral descriptor that does not name the health category.</p>',60),
 ('home','What if I only want to understand my problem first?','<p>Use the free self-assessments and the doctor-reviewed articles. They cost nothing and do not need an account.</p>',70);

/* ---------- SEO / AEO / GEO for the home route ---------- */
INSERT INTO seo_meta
 (entity_type, entity_id, route, meta_title, meta_desc, canonical_url,
  og_title, og_desc, robots, answer_summary, answer_bullets,
  geo_city, geo_state, sitemap_priority, sitemap_freq)
VALUES
 ('home',0,'/',
  'Talk privately to a sexual health doctor — Nirvaan',
  'Private, anonymous consultations with verified doctors and counsellors on sexual health. Chat, call or video. Your name and number are never shown to the doctor.',
  'https://nirvaan.in/',
  'Private sexual health consultations with verified doctors',
  'Ask under a handle you choose. The doctor never sees your name or number.',
  'index,follow',
  'Nirvaan is an Indian online sexual health platform where users consult verified doctors and counsellors anonymously by chat, call or video, paying per minute after a short free window.',
  JSON_ARRAY(
    'Doctors are verified against their state medical council registration before going live.',
    'Patient name and mobile number are masked from the doctor by default.',
    'The first few minutes of the first consultation are free; after that billing is per minute from wallet balance.',
    'Prescriptions are issued only by Registered Medical Practitioners, under the Telemedicine Practice Guidelines 2020.'
  ),
  'Mumbai','Maharashtra',1.0,'daily');

/* ---------- Free tools (the top of the funnel) ---------- */
INSERT INTO free_tools (slug,name,tool_type,for_gender,seo_title,seo_desc,config_json,sort_order) VALUES
 ('mens-sexual-wellbeing-check','Men''s sexual wellbeing check','assessment','male',
  'Free men''s sexual wellbeing self-check — Nirvaan',
  'A short, private self-assessment for men. No account needed, no results stored unless you ask.',
  JSON_OBJECT('questions', JSON_ARRAY(), 'bands', JSON_ARRAY()),10),
 ('womens-sexual-wellbeing-check','Women''s sexual wellbeing check','assessment','female',
  'Free women''s sexual wellbeing self-check — Nirvaan',
  'A short, private self-assessment for women. No account needed, no results stored unless you ask.',
  JSON_OBJECT('questions', JSON_ARRAY(), 'bands', JSON_ARRAY()),20),
 ('performance-anxiety-check','Performance anxiety check','assessment','all',
  'Free performance anxiety self-check — Nirvaan',
  'Understand whether stress and anxiety are playing a role. Private and free.',
  JSON_OBJECT('questions', JSON_ARRAY(), 'bands', JSON_ARRAY()),30);
