-- Phase 9 starter content. Import after diabeasy_schema.sql.

INSERT INTO blog_categories (slug, name, description, sort_order) VALUES
('understanding-your-numbers','Understanding your numbers','What each test on your report actually means.',10),
('complications','Preventing complications','Eyes, kidneys, feet and heart — catching problems early.',20),
('living-with-diabetes','Living with diabetes','Food, activity and daily routine, for Indian households.',30),
('for-families','For families','Helping a parent manage diabetes from another city.',40);

INSERT INTO faqs (question, answer, context, sort_order) VALUES
('Is it really free?','Yes. Sending your report and getting the explanation costs nothing. Later we may offer paid services like booking a lab test, but reading your report will stay free.','home',10),
('Is my report data safe?','Your reports are stored privately and are never sold. We do not share them with any lab, pharmacy or insurer without asking you first and getting your separate permission. You can ask us to delete everything at any time.','home',20),
('Do you replace my doctor?','No, and we never try to. We explain what your numbers mean and suggest questions to ask. We never change medicines, never diagnose, and never tell you to skip a consultation.','home',30),
('Who actually reads my report?','Our system reads it first, then a trained person checks every value before the summary reaches you. We would rather be slower and right.','home',40),
('What if the photo is not clear?','We will tell you and ask for another one. We never guess at a number we cannot read properly.','home',50),
('Can I manage my parents reports too?','Yes. One account can hold reports for your whole family, each kept separately. Most people start by adding a parent.','home',60),
('Do I need to install an app?','No. Everything works on WhatsApp. There is a website too if you prefer a bigger screen, but nothing to download.','home',70);

INSERT INTO cms_pages (slug, title, page_type, status, meta_title, meta_desc, content) VALUES
('about','About Diabeasy','static','published','About Diabeasy — built by Caresoft',
 'Diabeasy is built by Caresoft Systems, whose healthcare software runs in over 1,000 hospitals.',
 '<p>Diabeasy exists because of a gap we kept seeing. Someone gets a lab report, understands almost none of it, and files it away. Three months later they get another one and never compare the two.</p><p>We are built by Caresoft Systems, a healthcare software company running in more than 1,000 hospitals across 12 countries. We know what is in a lab report and we know what happens when nobody explains it.</p><h2>What we do not do</h2><p>We do not diagnose. We do not prescribe. We do not tell anyone to skip their doctor. Every summary is checked by a person before it reaches you.</p>'),
('privacy','Privacy','legal','draft','Privacy — Diabeasy','How Diabeasy handles your health data.',
 '<p><strong>This is a placeholder. Have it reviewed by a lawyer before publishing.</strong></p><p>It must cover, at minimum: what data is collected, the lawful basis, retention period, who it is shared with, how to withdraw consent, how to request deletion, and your grievance officer contact under the DPDP Act 2023.</p>'),
('terms','Terms of use','legal','draft','Terms of use — Diabeasy','Terms for using Diabeasy.',
 '<p><strong>This is a placeholder. Have it reviewed by a lawyer before publishing.</strong></p><p>It must state clearly that Diabeasy is an information service, not medical advice, and does not create a doctor-patient relationship.</p>');