-- =====================================================================
-- Caresoft Imaging — seed data
-- Default password for every seeded account: Caresoft@2026
-- (hash below is password_hash('Caresoft@2026', PASSWORD_DEFAULT))
-- CHANGE EVERY ONE OF THESE BEFORE THE SERVER IS REACHABLE FROM OUTSIDE.
-- =====================================================================
USE `caresoft_imaging`;

SET @PW := '$2y$10$QKsLE2tFoABASnJVRgkYV.3eKYeddwauHQr4r0DOyr6NbyE7qJuZK';

-- --------------------------------------------------------------- tenant
INSERT INTO tenant (code,name,legal_name,city,state,country,contact_person,contact_email,contact_phone,
                    bed_count,plan,status,orthanc_base_url,orthanc_user,orthanc_ae_title,webhook_secret,storage_quota_gb)
VALUES ('demo','Demo Hospital & Research Centre','Demo Hospital Pvt Ltd','Mumbai','Maharashtra','India',
        'Dr Demo Admin','admin@demohospital.test','+91 22 0000 0000',180,'onprem','active',
        'http://127.0.0.1:8042','caresoft','CARESOFT','change-this-webhook-secret',2048);

SET @T := LAST_INSERT_ID();

INSERT INTO branch (tenant_id,name,code,address) VALUES (@T,'Main Campus','MAIN','Andheri East, Mumbai');

-- --------------------------------------------------------------- users
-- Level 1 — Caresoft platform
INSERT INTO app_user (tenant_id,level,role,full_name,email,username,password_hash,must_change_pw)
VALUES (NULL,1,'superadmin','Caresoft Platform Admin','imaging@caresoft.co.in','csadmin',@PW,1),
       (NULL,1,'support','Caresoft Support Desk','support@caresoft.co.in','cssupport',@PW,1);

-- Level 2 — client admin
INSERT INTO app_user (tenant_id,level,role,full_name,email,username,password_hash,must_change_pw)
VALUES (@T,2,'client_admin','Demo Hospital Administrator','admin@demohospital.test','demoadmin',@PW,1),
       (@T,2,'it_admin','Demo Hospital IT','it@demohospital.test','demoit',@PW,1);

-- Level 3 — end users
INSERT INTO app_user (tenant_id,level,role,full_name,email,username,password_hash,registration_no,qualification,must_change_pw)
VALUES (@T,3,'senior_radiologist','Dr Senior Radiologist','sr@demohospital.test','drsenior',@PW,'MMC/00000/2010','MD Radiodiagnosis',1),
       (@T,3,'radiologist','Dr Junior Radiologist','jr@demohospital.test','drjunior',@PW,'MMC/00001/2018','DNB Radiodiagnosis',1),
       (@T,3,'technician','Radiology Technician','tech@demohospital.test','demotech',@PW,NULL,NULL,1),
       (@T,3,'front_desk','Radiology Front Desk','desk@demohospital.test','demodesk',@PW,NULL,NULL,1);

-- --------------------------------------------------------------- modalities
INSERT INTO img_modality (tenant_id,name,modality_type,manufacturer,model,ae_title,host_ip,port,supports_mwl,supports_mpps,is_active)
VALUES (@T,'CT-1 Main','CT','Siemens','Somatom go.Now','CT1',   '10.0.10.21',104,1,1,1),
       (@T,'MR-1 Main','MR','GE','Signa Explorer 1.5T',        'MR1','10.0.10.22',104,1,0,1),
       (@T,'DX-1 Casualty','DX','Samsung','GC85A',             'DX1','10.0.10.23',104,1,0,1),
       (@T,'US-1 OPD','US','Philips','Affiniti 50',            'US1','10.0.10.24',104,0,0,1);

-- --------------------------------------------------------------- procedures
INSERT INTO img_procedure (tenant_id,code,name,modality_type,body_part,duration_min,contrast_used,price) VALUES
 (@T,'CT-BRAIN-P','CT Brain Plain','CT','Head',10,0,2500.00),
 (@T,'CT-ABD-C','CT Abdomen with Contrast','CT','Abdomen',25,1,6500.00),
 (@T,'CT-CHEST-P','CT Chest Plain (HRCT)','CT','Chest',15,0,4000.00),
 (@T,'MR-BRAIN-P','MRI Brain Plain','MR','Head',30,0,7000.00),
 (@T,'MR-LSPINE','MRI Lumbar Spine','MR','Spine',30,0,7500.00),
 (@T,'DX-CHEST-PA','X-Ray Chest PA','DX','Chest',5,0,350.00),
 (@T,'DX-KNEE-AP','X-Ray Knee AP/LAT','DX','Knee',5,0,450.00),
 (@T,'US-ABD','Ultrasound Whole Abdomen','US','Abdomen',20,0,1200.00);

-- --------------------------------------------------------------- report templates
INSERT INTO img_report_template (tenant_id,name,modality_type,body_part,is_normal,body_html) VALUES
 (@T,'CT Brain — Normal','CT','Head',1,
  '<p><b>Technique:</b> Axial plain CT sections of the brain.</p><p><b>Findings:</b> Cerebral hemispheres, cerebellum and brainstem show normal attenuation. No intracranial haemorrhage, mass lesion or midline shift. Ventricles and sulcal spaces are normal for age. Visualised paranasal sinuses and mastoids are clear. No skull vault fracture.</p><p><b>Impression:</b> No acute intracranial abnormality.</p>'),
 (@T,'X-Ray Chest PA — Normal','DX','Chest',1,
  '<p><b>Findings:</b> Both lung fields are clear. Cardiac silhouette is within normal limits. Both hila are normal. Costophrenic angles are clear. Visualised bony thorax and soft tissues are unremarkable.</p><p><b>Impression:</b> Normal chest radiograph.</p>'),
 (@T,'MRI Lumbar Spine — Template','MR','Spine',0,
  '<p><b>Technique:</b> Multiplanar multisequence MRI of the lumbosacral spine.</p><p><b>Findings:</b> Vertebral alignment: ...<br>Vertebral bodies and marrow signal: ...<br>Discs L1-2 to L5-S1: ...<br>Spinal canal and neural foramina: ...<br>Conus medullaris: ...<br>Paraspinal soft tissues: ...</p><p><b>Impression:</b> ...</p>');

-- --------------------------------------------------------------- settings
INSERT INTO img_setting (tenant_id,skey,sval) VALUES
 (NULL,'site_name','Caresoft Imaging'),
 (NULL,'company_name','Caresoft Systems Private Limited'),
 (NULL,'site_url','https://imaging.caresoft.co.in'),
 (NULL,'contact_email','imaging@caresoft.co.in'),
 (NULL,'contact_phone','+91 22 4970 0000'),
 (NULL,'office_address','Mira Road East, Thane, Maharashtra 401107, India'),
 (NULL,'ga_measurement_id',''),
 (NULL,'viewer_type','stone'),
 (@T,'sla_routine_hours','24'),
 (@T,'sla_urgent_hours','4'),
 (@T,'sla_stat_minutes','30'),
 (@T,'block_unbilled_studies','warn'),
 (@T,'retention_years_adult','7'),
 (@T,'retention_years_paediatric','21'),
 (@T,'hot_tier_months','6'),
 (@T,'critical_escalate_minutes','15'),
 (@T,'critical_escalate_urgent_minutes','60'),
 (@T,'report_link_days','30'),
 (@T,'deliver_auto_patient','on'),
 (@T,'hospital_letterhead','Demo Hospital & Research Centre'),
 (@T,'hospital_address_line','Andheri East, Mumbai 400069 · +91 22 0000 0000'),
 (@T,'report_footer_note','This report is an interpretation of images and should be correlated clinically.');

-- --------------------------------------------------------------- retention rules
-- Deliberately long defaults. Shortening them is a decision each hospital
-- must take against its own state's requirement; lengthening costs only disk.
INSERT INTO img_retention_rule (tenant_id,name,modality_type,patient_group,hot_months,retain_years,priority) VALUES
 (@T,'Medico-legal cases',NULL,'medicolegal',12,25,10),
 (@T,'Children under 18', NULL,'paediatric', 12,21,20),
 (@T,'Mammography',       'MG','any',        12,10,30),
 (@T,'Adults, general',   NULL,'any',         6, 8,100);

-- --------------------------------------------------------------- escalation chain
INSERT INTO img_escalation_contact (tenant_id,level,name,role,phone,email) VALUES
 (@T,1,'Duty Medical Officer','DMO','+910000000001','dmo@demohospital.test'),
 (@T,2,'Head of Radiology','HOD','+910000000002','hod@demohospital.test'),
 (@T,3,'Medical Superintendent','MS',NULL,'ms@demohospital.test');

-- --------------------------------------------------------------- CMS blocks (landing page)
INSERT INTO cms_block (block_key,label,block_group,content,input_type,sort_order) VALUES
 ('hero.eyebrow','Hero eyebrow','hero','RIS + PACS, built into your HIS','text',1),
 ('hero.headline','Hero headline','hero','Your radiology department, from the order to the signed report.','text',2),
 ('hero.sub','Hero subtext','hero','Caresoft Imaging connects every modality in your hospital, moves studies to the radiologist in seconds, and pushes the signed report straight back into the patient record. One vendor. One login. One support desk.','textarea',3),
 ('hero.cta_primary','Primary button text','hero','Book a demo','text',4),
 ('hero.cta_secondary','Secondary button text','hero','See how it works','text',5),
 ('hero.stat1_value','Stat 1 value','hero','1,000+','text',6),
 ('hero.stat1_label','Stat 1 label','hero','Hospitals running Caresoft','text',7),
 ('hero.stat2_value','Stat 2 value','hero','12+','text',8),
 ('hero.stat2_label','Stat 2 label','hero','Countries','text',9),
 ('hero.stat3_value','Stat 3 value','hero','20 yrs','text',10),
 ('hero.stat3_label','Stat 3 label','hero','Healthcare IT, bootstrapped','text',11),
 ('problem.title','Problem section title','problem','Most hospitals run two systems that do not speak to each other.','text',1),
 ('problem.body','Problem section body','problem','The HIS knows the order, the bill and the bed. The PACS knows the images. Between them sits a technician retyping patient names, a radiologist chasing a prior study, and a referring doctor waiting on a report that was signed two hours ago. Caresoft Imaging closes that gap because it is built by the people who built your HIS.','textarea',2),
 ('workflow.title','Workflow section title','workflow','How a study moves','text',1),
 ('workflow.sub','Workflow section subtext','workflow','Ten steps, no retyping, no orphan studies.','text',2),
 ('modules.title','Modules section title','modules','Eleven modules. One product.','text',1),
 ('modules.sub','Modules section subtext','modules','Everything a radiology department needs to run, measure and prove itself.','text',2),
 ('arch.title','Architecture section title','arch','Standards underneath, Caresoft on top','text',1),
 ('arch.body','Architecture section body','arch','Caresoft Imaging speaks DICOM the way every modality expects: C-STORE, C-FIND, C-MOVE, Modality Worklist, MPPS and DICOMweb. Images are stored by a hardened, standards-compliant archive service. Your workflow, reporting, delivery and analytics are pure Caresoft. Nothing is locked in a proprietary format, and your studies can be exported at any time.','textarea',2),
 ('cta.title','Closing CTA title','cta','See it running on your own machines','text',1),
 ('cta.body','Closing CTA body','cta','We will connect one modality at your site, send a real study through, and show you the report reaching the patient. Usually inside a day.','textarea',2),
 ('footer.tagline','Footer tagline','footer','Healthcare IT since 2004. CMMI Level 5. ISO 27001. Serving 1,000+ hospitals across India, Africa and the Middle East.','textarea',1);

-- --------------------------------------------------------------- features / modules
INSERT INTO cms_feature (section,icon,title,summary,sort_order) VALUES
 ('module','hdd-network','Equipment & modality management','Every machine registered with its AE title, conformance notes and DICOM echo heartbeat. AMC expiry, preventive maintenance and downtime tracked in the same place.',1),
 ('module','clipboard2-pulse','Orders & scheduling','Orders arrive from Caresoft HIS with the accession number already generated. Slot-based scheduling per modality, prep instructions sent to the patient before they arrive.',2),
 ('module','list-check','Modality worklist','The technician selects the patient on the console instead of typing the name. That single change removes the most common cause of mismatched studies.',3),
 ('module','shield-check','Ingestion & reconciliation','Studies land, metadata syncs, index rows write. Anything arriving without a matching order goes to an unmatched queue and is reconciled with a full audit trail.',4),
 ('module','person-gear','Technician workflow','Acquisition start and stop, repeat and reject analysis with reason codes, contrast log with batch number, film and consumable usage posted back to inventory.',5),
 ('module','file-medical','Radiologist worklist & reporting','Configurable worklist, automatic prior fetch, template library, macros, structured fields, draft and verify, e-sign, and full version history that is never overwritten.',6),
 ('module','exclamation-octagon','Critical findings','Flag it, notify the referring doctor instantly, capture the acknowledgement, escalate if nobody responds. Your NABH evidence writes itself.',7),
 ('module','broadcast','Teleradiology','Forward studies to a central node, allocate to internal, empanelled or outsourced radiologists, watch the SLA clock, and reconcile partner billing monthly.',8),
 ('module','send-check','Report delivery','Back into the HIS record, out to the patient by WhatsApp or QR, and into the referring physician portal. Signed, verifiable, and traceable to the moment it was viewed.',9),
 ('module','hdd-stack','Storage & lifecycle','Growth projections, hot-to-cold tiering, retention rules by patient category, verified backups, and a study export tool you can run yourself.',10),
 ('module','graph-up','MIS & analytics','Turnaround time, modality utilisation, repeat and reject rate, radiologist productivity, revenue by referrer. Drill from a number to the study behind it.',11);

INSERT INTO cms_feature (section,icon,title,summary,sort_order) VALUES
 ('outcome','stopwatch','Report turnaround you can prove','Every timestamp from order to verified signature is captured, so TAT stops being an argument and becomes a number.',1),
 ('outcome','link-45deg','No second login','Radiology sits inside the same Caresoft account, role matrix and audit log your hospital already uses.',2),
 ('outcome','box-arrow-up-right','No data hostage','Studies stay in standard DICOM and can be exported in bulk whenever you ask.',3),
 ('outcome','headset','One support desk','The same team that supports your HIS supports your imaging. No vendor pointing at the other vendor.',4);

-- --------------------------------------------------------------- blog
INSERT INTO cms_category (slug,name,description) VALUES
 ('pacs','PACS & imaging','Archiving, viewers, DICOM and storage'),
 ('radiology-ops','Radiology operations','Workflow, TAT, quality and staffing'),
 ('compliance','Compliance','NABH, ABDM, DPDP and medical device rules'),
 ('teleradiology','Teleradiology','Remote reading, SLAs and partner models');

INSERT INTO cms_post (category_id,slug,title,excerpt,answer_summary,key_takeaways,body_html,is_published,published_at,reading_minutes,author_name) VALUES
 (1,'what-is-pacs-and-how-does-it-work',
  'What is a PACS, and how does it actually work in a hospital?',
  'A plain explanation of Picture Archiving and Communication Systems: the four parts every PACS has, how images travel from the machine to the radiologist, and what separates a real PACS from a shared folder.',
  'A PACS is the system that receives images from imaging machines, stores them in the DICOM standard, and delivers them to radiologists and referring doctors on demand. It has four parts: the modalities that produce images, the archive that stores them, the network that moves them, and the viewers that display them. A PACS replaces film and CDs entirely.',
  "A PACS has four parts: modalities, archive, network, viewers.\nDICOM is the standard that lets machines from different manufacturers talk to one archive.\nModality Worklist is what stops technicians retyping patient names.\nWithout RIS integration a PACS stores images but does not run a department.\nStorage grows 1.5 to 3 TB a year for a hospital running CT and MR.",
  '<p>Ask five hospital owners what a PACS is and you will get five answers, most of them describing a place where images are kept. That is half of it. The archive is one part of four, and the other three are where departments succeed or struggle.</p><h2>The four parts</h2><p><b>Modalities.</b> The machines: CT, MRI, X-ray, ultrasound, mammography, nuclear medicine. Nearly all of them speak DICOM, the imaging standard that has been in place since the early 1990s. A machine that speaks DICOM can send to any compliant archive, which is why you are not locked to the machine vendor for storage.</p><h2>Where most implementations go wrong</h2><p>The failure is rarely technical. It is that the PACS was installed as an image store and nobody connected it to the order. The technician still types the patient name at the console. One typo and the study is orphaned, sitting in the archive attached to a patient who does not exist.</p><p>Modality Worklist solves this. The order is raised in the HIS, published to the worklist, and the technician selects a patient from a list instead of typing. It is a small configuration change with a disproportionate effect on data quality.</p><h2>Storage is the running cost nobody budgets</h2><p>A mid-size hospital running CT, MR and routine radiography generates roughly 1.5 to 3 TB a year. Multiply by your retention obligation, add headroom, and plan backup at twice that. Ask any vendor quoting you a PACS to show the storage line separately.</p>',
  1,'2026-06-18 10:00:00',7,'Caresoft Systems'),
 (2,'reduce-radiology-report-turnaround-time',
  'How to reduce radiology report turnaround time without hiring',
  'TAT is usually lost in four specific gaps, none of which are the radiologist reading speed. Here is how to find them in your own data and close them.',
  'Radiology turnaround time is usually lost in waiting, not in reading. The four common gaps are order-to-arrival, arrival-to-acquisition, acquisition-to-allocation, and verified-to-delivered. Measuring each separately, rather than reporting a single end-to-end average, shows which one to fix first and usually removes hours without adding staff.',
  "Measure four segments separately, not one end-to-end average.\nAllocation delay is often the largest single gap.\nStat and urgent studies need a separate clock and a separate escalation.\nDelivery delay after signature is invisible unless you timestamp it.\nRepeat rate directly inflates acquisition time and is worth tracking by technician.",
  '<p>When a hospital tells us their turnaround time is eighteen hours, the first question is: eighteen hours of what? Almost always the number is order-to-report, one average across all modalities and all priorities, and it hides everything useful.</p><h2>Split the clock</h2><p>There are four segments worth measuring on their own. Order to patient arrival. Arrival to acquisition complete. Acquisition to allocation to a radiologist. Report verified to report delivered. Each has a different owner and a different fix.</p><h2>Allocation is usually the worst offender</h2><p>In most departments studies sit in a common pool until someone picks them up. Overnight, that can be six hours of nothing happening. Automatic allocation with an SLA clock and an escalation rule turns that from a habit into a managed queue.</p><h2>The delivery gap is invisible</h2><p>A report signed at 14:10 and handed over at the counter at 19:00 is a five-hour delay that never appears in any dashboard, because most systems stop the clock at signature. Timestamp the delivery too.</p>',
  1,'2026-07-02 10:00:00',6,'Caresoft Systems'),
 (3,'nabh-requirements-radiology-department',
  'NABH requirements for a radiology department: the evidence you need',
  'The documentation NABH assessors actually ask for in radiology, and how to produce it as a by-product of daily work rather than a scramble before the visit.',
  'NABH assessment of a radiology department focuses on documented evidence rather than intent: repeat and reject analysis with reason codes, communication of critical findings with acknowledgement, turnaround time monitoring against a defined standard, radiation safety records, and equipment maintenance logs. Each of these can be captured automatically during normal work.',
  "Repeat and reject analysis must have reason codes, not just a count.\nCritical findings need a documented acknowledgement, not just a phone call.\nTAT needs a defined standard to be measured against.\nEquipment maintenance and calibration records are checked.\nEvidence collected daily beats evidence assembled the week before assessment.",
  '<p>Departments that struggle with NABH in radiology rarely lack the practice. They lack the record of it. The radiologist did call the physician about the intracranial bleed; there is simply nothing to show that the call happened, who took it, or when.</p><h2>Critical findings</h2><p>The standard expects a defined list of critical findings, a defined communication route, and evidence of acknowledgement. A flag in the reporting screen that sends a message and records the acknowledgement produces that evidence as a by-product.</p><h2>Repeat and reject</h2><p>A count is not enough. Assessors look for reason codes, trends and action taken. Positioning, motion, exposure, artefact and equipment fault are the standard categories.</p>',
  1,'2026-07-21 10:00:00',6,'Caresoft Systems'),
 (4,'teleradiology-models-for-indian-hospitals',
  'Teleradiology models for Indian hospitals: which one fits you',
  'In-house after-hours cover, empanelled radiologists, or a full outsourced partner. What each costs you in money, control and turnaround.',
  'Indian hospitals typically choose between three teleradiology models: internal radiologists reading remotely after hours, empanelled independent radiologists paid per study, and a full outsourced teleradiology provider. Internal cover gives the most control, empanelment gives the best cost per study for moderate volumes, and full outsourcing suits low-volume or overnight-only requirements.',
  "Internal remote reading keeps control and needs no new contracts.\nEmpanelment suits moderate volume at a predictable per-study rate.\nFull outsourcing suits low overnight volume.\nWhichever model, the SLA clock and audit trail must stay in your system.\nPartner billing reconciliation is where most arrangements leak money.",
  '<p>The technology question in teleradiology is largely settled: a browser, a secure link and a study that has been forwarded to a central node. The harder question is commercial.</p><h2>Keep the clock on your side</h2><p>Whichever model you choose, the SLA measurement and the audit trail should live in your own system, not the partner\'s. When a dispute arises about a delayed stat report, you need your own timestamps.</p><h2>Reconciliation</h2><p>Partner invoices are usually accepted with a glance. Studies allocated, studies completed, studies within SLA, and studies rejected should reconcile to the rupee every month.</p>',
  1,'2026-08-04 10:00:00',5,'Caresoft Systems');

-- --------------------------------------------------------------- testimonials
INSERT INTO cms_testimonial (quote,author_name,author_title,hospital_name,city,country,rating,bed_count,is_featured,sort_order) VALUES
 ('The change we noticed first was not the images. It was that nobody types a patient name at the CT console any more. Our orphan studies went to zero in the first month.',
  'Dr A. Ramesh','Head of Radiology','Multi-speciality Hospital','Coimbatore','India',5,240,1,1),
 ('We ran two vendors for eleven years and spent half our support calls establishing whose problem it was. One vendor for HIS and imaging ended that argument permanently.',
  'Mr S. Bhattacharya','Chief Operating Officer','Group Hospital','Kolkata','India',5,410,1,2),
 ('The critical findings acknowledgement log was the single item our NABH assessor spent the longest on, and it was the easiest thing we produced.',
  'Dr Meera K.','Quality Head','Charitable Trust Hospital','Pune','India',5,175,1,3),
 ('Our radiologist reads from home three nights a week now. Same worklist, same templates, no VPN gymnastics for him to learn.',
  'Dr J. Owour','Medical Director','District Referral Hospital','Nairobi','Kenya',5,120,0,4),
 ('Storage was the thing we had underestimated for years. Seeing the projected exhaustion date on a dashboard changed how we budget.',
  'Mr P. Nair','IT Manager','Speciality Hospital','Kochi','India',4,150,0,5);

-- --------------------------------------------------------------- FAQ (AEO)
INSERT INTO cms_faq (scope,question,answer,sort_order) VALUES
 ('home','Does Caresoft Imaging work with our existing imaging machines?',
  'Yes. Almost every modality manufactured in the last two decades speaks DICOM, and Caresoft Imaging connects over standard DICOM services: C-STORE for receiving images, Modality Worklist for sending the patient list to the console, and MPPS where the machine supports it. Each machine is registered with its AE title and tested during installation. Genuinely legacy analogue equipment can be brought in through a frame grabber or manual upload.',1),
 ('home','Can we run it on our own server, or does it have to be cloud?',
  'Both are supported. Most hospitals run a site node inside their own LAN so that image retrieval stays on local network speed, with optional forwarding to a Caresoft cloud node for teleradiology. Smaller clinics and diagnostic centres often run cloud-only over a VPN. The application is the same in either case.',2),
 ('home','How much storage will we need?',
  'A hospital running CT, MRI and routine radiography typically generates between 1.5 and 3 TB per year. Multiply that by your retention requirement, add about 30 percent headroom, and plan backup capacity at roughly twice the primary. Caresoft Imaging shows consumed storage, growth rate and a projected exhaustion date so this stops being a surprise.',3),
 ('home','Does it integrate with Caresoft HIS?',
  'Natively. Orders, patient demographics, ADT movements, billing status and patient merges flow from the HIS into imaging, and study status, finalised reports, image links and consumable usage flow back. It is a single sign-on and a single audit trail, not a bridge between two products.',4),
 ('home','Is the viewer approved for primary diagnostic reporting?',
  'The Caresoft Imaging web viewer is provided for clinical review, referring physician access and patient access. A viewer used for primary diagnostic interpretation is regulated as a software medical device, and Caresoft is pursuing that certification as a separate track. Where a hospital requires a certified primary-read viewer today, Caresoft Imaging runs alongside one and continues to own the order, worklist, reporting, delivery and analytics.',5),
 ('home','What happens to our images if we ever change vendor?',
  'They stay in standard DICOM format and can be exported in bulk at any time using the built-in export tool. Nothing is held in a proprietary container. We would rather earn the renewal than trap the data.',6),
 ('home','Can radiologists report from outside the hospital?',
  'Yes. Remote reading is a core capability rather than an add-on. Studies can be forwarded to a central node, allocated to internal, empanelled or outsourced radiologists, and read in a browser with the same worklist and templates used inside the hospital. SLA clocks and the audit trail stay in your system.',7),
 ('home','How long does implementation take?',
  'A single-modality proof of concept usually runs in a day. A full department, with all modalities connected, templates loaded, users trained and HIS integration live, typically takes four to eight weeks depending on the number of machines and how much legacy data is being migrated.',8);

-- --------------------------------------------------------------- SEO
INSERT INTO cms_seo (entity_type,entity_ref,meta_title,meta_desc,meta_keywords,robots,changefreq,priority) VALUES
 ('home','-','Caresoft Imaging — RIS & PACS software for hospitals | Caresoft Systems',
  'Hospital RIS and PACS built into your HIS. Connect every modality, run the radiology worklist, report and e-sign, deliver to patients, and measure turnaround time. From Caresoft Systems, serving 1,000+ hospitals.',
  'PACS software India, RIS PACS, hospital imaging software, DICOM archive, radiology information system, teleradiology software, HIS integrated PACS','index,follow','weekly',1.0),
 ('blog_index','-','Radiology & PACS insights — Caresoft Imaging',
  'Practical writing on PACS, radiology workflow, turnaround time, NABH evidence and teleradiology, from the team behind Caresoft HIS.',
  'radiology blog, PACS articles, radiology workflow, NABH radiology','index,follow','weekly',0.8);

-- --------------------------------------------------------------- GEO pages
INSERT INTO cms_geo_location (slug,city,state,country,latitude,longitude,service_area,office_address,office_phone,hospitals_served,intro_html,sort_order) VALUES
 ('mumbai','Mumbai','Maharashtra','India',19.0760,72.8777,'Mumbai, Navi Mumbai, Thane, Palghar and Raigad','Mira Road East, Thane, Maharashtra 401107','+91 22 4970 0000',180,
  '<p>Caresoft has supported hospitals across Mumbai and the MMR for two decades, with an implementation and support team based in Thane. On-site response for imaging installations in Mumbai, Navi Mumbai and Thane is same-day for critical issues.</p>',1),
 ('delhi-ncr','Delhi NCR','Delhi','India',28.6139,77.2090,'New Delhi, Gurugram, Noida, Ghaziabad and Faridabad',NULL,'+91 22 4970 0000',120,
  '<p>Caresoft Imaging is deployed across hospitals in Delhi, Gurugram and Noida, including multi-branch groups running a shared teleradiology node across sites.</p>',2),
 ('kolkata','Kolkata','West Bengal','India',22.5726,88.3639,'Kolkata, Howrah, Durgapur and Siliguri',NULL,'+91 22 4970 0000',95,
  '<p>A long-standing base of hospital installations across West Bengal, with imaging rollouts running alongside existing Caresoft HIS sites.</p>',3),
 ('nairobi','Nairobi','Nairobi County','Kenya',-1.2921,36.8219,'Nairobi and East Africa',NULL,'+91 22 4970 0000',18,
  '<p>Caresoft serves hospitals across East Africa, with imaging deployments designed for constrained bandwidth: local site nodes, throttled forwarding, and offline-tolerant acquisition.</p>',4);

-- --------------------------------------------------------------- pages
INSERT INTO cms_page (slug,title,body_html,is_published,show_in_nav,nav_order) VALUES
 ('privacy-policy','Privacy Policy','<p>Placeholder. Replace with the Caresoft group privacy policy, updated for imaging data and the Digital Personal Data Protection Act, 2023.</p>',1,0,1),
 ('terms','Terms of Use','<p>Placeholder. Replace with the Caresoft group terms of use.</p>',1,0,2),
 ('security','Security & compliance','<p>Placeholder. Cover ISO 27001 scope, encryption in transit and at rest, audit logging, role-based access, break-glass procedure, backup and restore testing.</p>',1,1,3);
