-- 30 demo leads so the dashboard renders (delete before importing real data)
insert into leads (account_id,first_name,last_name,country,email,phone,nationality,dob,promo_code,promo_prefix,promo_suffix,points,logged_at,source_date,source_month) values
  ('DEMO-001','Priya','Tan','Indonesia','priya1001@example.com',null,'Indian','1966-06-19','KEVO75','KEVO75','KEVO75',0,'2026-06-29','2026-06-29','2026-06'),
  ('DEMO-002','James','Whitmore','Singapore','james1002@example.com','+91773960310','British','1987-01-27','KCGM','KCGM','KCGM',400,'2026-06-30','2026-06-30','2026-06'),
  ('DEMO-003','Sofia','Rossi',null,'sofia1003@example.com','+66706252221','Australian','1995-03-10','RPM-SUNCITY','RPM','SUNCITY',3400,'2025-08-09','2025-08-09','2025-08'),
  ('DEMO-004','Liam','Okafor','United Arab Emirates','liam1004@example.com','+971785753514','Spanish','1972-06-04','RPM-NASAB','RPM','NASAB',250,'2026-06-30','2026-06-30','2026-06'),
  ('DEMO-005','Mei','Nguyen',null,null,'+49742164119','Emirati','1989-10-15','RPM-MERIDIAN','RPM','MERIDIAN',3400,'2026-06-30','2026-06-30','2026-06'),
  ('DEMO-006','Noah','Patel','Singapore',null,'+971766453392','French','1981-12-15','SOCIALKARMA','SOCIALKARMA','SOCIALKARMA',0,'2026-01-27','2026-01-27','2026-01'),
  ('DEMO-007','Aisha','Muller','Thailand','aisha1007@example.com','+49756599395','Spanish','1962-11-03','RPM-MERIDIAN','RPM','MERIDIAN',1200,'2026-06-18','2026-06-18','2026-06'),
  ('DEMO-008','Lucas','Santos','Germany',null,'+49709229206','British','1965-05-16','KEVO75','KEVO75','KEVO75',400,'2026-06-04','2026-06-04','2026-06'),
  ('DEMO-009','Emma','Khan','United Kingdom','emma1009@example.com','+49789745048','Emirati','1982-01-15','RPM-SQUARECLUB','RPM','SQUARECLUB',3400,'2026-06-02','2026-06-02','2026-06'),
  ('DEMO-010','Ravi','Lim',null,null,null,'Australian','1968-12-08','RPM-NASAB','RPM','NASAB',250,'2026-06-30','2026-06-30','2026-06'),
  ('DEMO-011','Chloe','Costa','Australia','chloe1011@example.com','+66757783637','Australian','1995-05-23','KARMABEACHBALI','KARMABEACHBALI','KARMABEACHBALI',400,'2026-06-30','2026-06-30','2026-06'),
  ('DEMO-012','Diego','Reyes','France','diego1012@example.com','+66788384612','German','1974-01-16','KEVO75','KEVO75','KEVO75',0,'2026-03-15','2026-03-15','2026-03'),
  ('DEMO-013','Nadia','Holt','United Kingdom',null,'+44716843185','Indian','1992-10-21','SOCIALKARMA','SOCIALKARMA','SOCIALKARMA',50,'2026-06-30','2026-06-30','2026-06'),
  ('DEMO-014','Omar','Berg','United Arab Emirates','omar1014@example.com','+49708354761','Italian','1972-02-07','DIMARE','DIMARE','DIMARE',400,'2026-06-26','2026-06-26','2026-06'),
  ('DEMO-015','Grace','Mori','Thailand','grace1015@example.com','+66772023741','Indian','1966-06-20','RPM-NASAB','RPM','NASAB',0,'2026-06-29','2026-06-29','2026-06'),
  ('DEMO-016','Tomas','Bauer','Singapore','tomas1016@example.com',null,'British','1998-06-16','RPM-MERIDIAN','RPM','MERIDIAN',1200,'2026-06-19','2026-06-19','2026-06'),
  ('DEMO-017','Lara','Ferreira','Australia','lara1017@example.com','+91719343122','French','1966-12-11','RPM-MERIDIAN','RPM','MERIDIAN',3400,'2025-10-05','2025-10-05','2025-10'),
  ('DEMO-018','Yuki','Sharma','Indonesia','yuki1018@example.com','+971703629581','British','1993-05-21','DIMARE','DIMARE','DIMARE',50,'2026-06-17','2026-06-17','2026-06'),
  ('DEMO-019','Henrik','Tan','United Arab Emirates',null,null,'Spanish','1994-09-25','SOCIALKARMA','SOCIALKARMA','SOCIALKARMA',50,'2026-06-28','2026-06-28','2026-06'),
  ('DEMO-020','Arjun','Whitmore','Singapore','arjun1020@example.com',null,'Italian','1974-04-17','KEVO75','KEVO75','KEVO75',0,'2026-06-17','2026-06-17','2026-06'),
  ('DEMO-021','Priya','Rossi','India','priya1021@example.com','+971746208603','Emirati','1988-12-12','KEVO75','KEVO75','KEVO75',400,'2026-01-08','2026-01-08','2026-01'),
  ('DEMO-022','James','Okafor','Singapore','james1022@example.com','+49783760773','Emirati','1960-08-21','RPM-MERIDIAN','RPM','MERIDIAN',250,'2026-06-30','2026-06-30','2026-06'),
  ('DEMO-023','Sofia','Nguyen','Thailand','sofia1023@example.com',null,'British','1987-11-11','RPM-MERIDIAN','RPM','MERIDIAN',3400,'2026-02-18','2026-02-18','2026-02'),
  ('DEMO-024','Liam','Patel','Australia','liam1024@example.com','+66703697544','German','1969-10-15','KARMABEACHBALI','KARMABEACHBALI','KARMABEACHBALI',0,'2026-06-21','2026-06-21','2026-06'),
  ('DEMO-025','Mei','Muller','Germany','mei1025@example.com','+91770676511','Thai','1968-07-28','DIMARE','DIMARE','DIMARE',0,'2026-06-25','2026-06-25','2026-06'),
  ('DEMO-026','Noah','Santos','India',null,null,'Australian','1980-05-18','RPM-SUNCITY','RPM','SUNCITY',250,'2026-06-27','2026-06-27','2026-06'),
  ('DEMO-027','Aisha','Khan','India',null,'+971756455770','German','1992-03-18','RPM-NASAB','RPM','NASAB',3400,'2025-12-01','2025-12-01','2025-12'),
  ('DEMO-028','Lucas','Lim','United Arab Emirates',null,'+66723131984','British','1969-08-20','KCGM','KCGM','KCGM',0,'2026-06-30','2026-06-30','2026-06'),
  ('DEMO-029','Emma','Costa','India',null,null,'Thai','1966-09-02','KCGM','KCGM','KCGM',400,'2026-06-25','2026-06-25','2026-06'),
  ('DEMO-030','Ravi','Reyes','United Kingdom',null,'+91759491792','Spanish','1980-10-17','RPM-SUNCITY','RPM','SUNCITY',3400,'2026-06-30','2026-06-30','2026-06')
on conflict (account_id) do nothing;