

INSERT INTO counsellors (
  id,
  user_id,
  account_type,
  display_name,
  bio,
  specializations,
  languages_spoken,
  experience_years,
  license_number,
  hourly_rate_inr,
  chat_enabled,
  audio_enabled,
  video_enabled,
  show_on_map,
  rating_avg,
  rating_count,
  verification_status
)
VALUES 
(
  'cns_priya',
  'usr_counsellor_priya',
  'individual',
  'Dr. Priya Mehta',
  'Clinical psychologist focused on CBT, anxiety, and relationship support.',
  ARRAY['Anxiety','CBT','Relationship Counselling'],
  ARRAY['en','hi','gu'],
  9,
  'MH-DEMO-001',
  900,
  TRUE,
  TRUE,
  TRUE,
  TRUE,
  4.9,
  120,
  'approved'
),
(
  'cns_aarav',
  'usr_counsellor_aarav',
  'individual',
  'Aarav Sen',
  'Trauma counsellor specializing in somatic experiencing and mindfulness strategies.',
  ARRAY['Trauma','Grief','Mindfulness'],
  ARRAY['en','hi','bn'],
  6,
  'MH-DEMO-002',
  750,
  TRUE,
  TRUE,
  TRUE,
  TRUE,
  4.8,
  80,
  'approved'
),
(
  'cns_nisha',
  'usr_counsellor_nisha',
  'individual',
  'Nisha Iyer',
  'CBT therapist focusing on burnout recovery, ADHD coaching, and stress management.',
  ARRAY['CBT','Burnout','ADHD'],
  ARRAY['en','ta','ml'],
  4,
  'MH-DEMO-003',
  650,
  TRUE,
  TRUE,
  TRUE,
  TRUE,
  4.7,
  55,
  'approved'
)
ON CONFLICT (id) DO NOTHING;

INSERT INTO availability_slots (id, counsellor_id, slot_date, start_time, end_time, session_type, is_booked)
VALUES
  ('slot_cns_priya_1', 'cns_priya', CURRENT_DATE, '16:00', '17:00', 'video', FALSE),
  ('slot_cns_priya_2', 'cns_priya', CURRENT_DATE + INTERVAL '1 day', '11:00', '12:00', 'video', FALSE),
  ('slot_cns_aarav_1', 'cns_aarav', CURRENT_DATE, '15:00', '16:00', 'video', FALSE),
  ('slot_cns_nisha_1', 'cns_nisha', CURRENT_DATE, '17:00', '18:00', 'video', FALSE)
ON CONFLICT (id) DO NOTHING;

INSERT INTO wallets (id, owner_type, owner_id, currency, status)
VALUES
  ('wal_demo_user', 'user', 'usr_demo_user', 'INR', 'active'),
  ('wal_platform', 'platform', 'platform', 'INR', 'active'),
  ('wal_cns_priya', 'counsellor', 'usr_counsellor_priya', 'INR', 'active'),
  ('wal_cns_aarav', 'counsellor', 'usr_counsellor_aarav', 'INR', 'active'),
  ('wal_cns_nisha', 'counsellor', 'usr_counsellor_nisha', 'INR', 'active')
ON CONFLICT (id) DO NOTHING;

INSERT INTO ledger_entries (id, wallet_id, direction, amount_paise, entry_type, created_at)
VALUES
  ('led_seed_credit', 'wal_demo_user', 'credit', 125000, 'seed_credit', NOW())
ON CONFLICT (id) DO NOTHING;

INSERT INTO services_catalog (id, name, category, is_active, is_free, price_paise)
VALUES
  ('svc_ai_chat', 'AI Counselling Chat', 'AI Support', TRUE, TRUE, 0),
  ('svc_dream', 'Dream Analysis PDF Report', 'Analysis Reports', TRUE, FALSE, 4900)
ON CONFLICT (id) DO NOTHING;
