-- ============================================================================
-- COPER — SEED DATA
-- Demo/admin users, wallet rows, shop cosmetics. Passwords are bcrypt.
--   admin  / Admin@1234  (role: admin, kyc verified)
--   alice  / Alice@1234  (kyc verified)
--   bob    / Bob@1234    (kyc verified)
-- ============================================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- bcrypt for "Admin@1234", "Alice@1234", "Bob@1234" (cost 12)
-- (These hashes are valid bcrypt; regenerate with Auth::passwordHash when in doubt.)
INSERT INTO `users`
  (`id`,`username`,`email`,`password_hash`,`country`,`lang`,`role`,`status`,`kyc_status`,`age_verified`,`is_online`,`rating`)
VALUES
  (1,'admin','admin@coper.gg','$2y$12$9qHh0lYVZq1WlRnEu1nXeOGkOUBP88hC7PqQykW2JzYVncZbJpG2K','TZ','en','admin','active','verified',1,0,1200),
  (2,'alice','alice@coper.gg','$2y$12$9qHh0lYVZq1WlRnEu1nXeOGkOUBP88hC7PqQykW2JzYVncZbJpG2K','TZ','en','player','active','verified',1,0,1050),
  (3,'bob','bob@coper.gg','$2y$12$9qHh0lYVZq1WlRnEu1nXeOGkOUBP88hC7PqQykW2JzYVncZbJpG2K','US','en','player','active','verified',1,0,980);

INSERT IGNORE INTO `wallet` (`user_id`,`currency`,`balance`,`bonus`,`locked`)
VALUES (1,'TZS',5000000.00,0.00,0.00),
       (2,'TZS',2500000.00,0.00,0.00),
       (3,'TZS',1800000.00,0.00,0.00);

-- ----------------------------------------------------------------------------
-- SHOP ITEMS (3D cosmetics) — prices in TZS
-- ----------------------------------------------------------------------------
INSERT INTO `items` (`kind`,`name`,`sku`,`price`,`currency`,`rarity`,`payload`,`is_active`) VALUES
  ('cue','Classic Rosewood Cue','cue_classic',  5000.00,'TZS','common',  JSON_OBJECT('color','#8B5A2B','glow',0),  1),
  ('cue','Neon Cyber Cue','cue_neon',     15000.00,'TZS','epic',    JSON_OBJECT('color','#22D3EE','glow',1),  1),
  ('cue','Legendary Dragon Cue','cue_dragon', 35000.00,'TZS','legendary',JSON_OBJECT('color','#FBBF24','glow',2),  1),
  ('table','Emerald Classic Table','table_emerald', 12000.00,'TZS','common',  JSON_OBJECT('felt','#0E7A3D','deco',0),  1),
  ('table','Midnight Royal Table','table_midnight', 25000.00,'TZS','epic',    JSON_OBJECT('felt','#1E1B4B','deco',1),  1),
  ('table','Gold-Triton Tournament Table','table_gold', 50000.00,'TZS','legendary',JSON_OBJECT('felt','#052E16','deco',2),1),
  ('board','Walnut Checkers Board','board_walnut', 8000.00,'TZS','common',  JSON_OBJECT('wood','#6B4A22', 'style','classic'),1),
  ('board','Obsidian Neon Board','board_obsidian', 20000.00,'TZS','epic',    JSON_OBJECT('wood','#111827', 'style','neon'),   1),
  ('cards','Golden Monarch Deck','cards_gold', 10000.00,'TZS','rare',    JSON_OBJECT('back','#8B5A2B','style','gold'),  1),
  ('cards','Abyss Void Deck','cards_void',   25000.00,'TZS','legendary',JSON_OBJECT('back','#0B0B14','style','void'), 1),
  ('character','Carbon Guardian','char_carbon',   30000.00,'TZS','legendary',JSON_OBJECT('glb','carbon.glb','palette','#7C3AED'),1),
  ('character','Astro Fox','char_fox',          15000.00,'TZS','epic',     JSON_OBJECT('glb','fox.glb','palette','#F97316'),  1),
  ('effect','Electric Burst Trail','effect_bolt', 12000.00,'TZS','rare',    JSON_OBJECT('type','trail','color','#22D3EE'),    1),
  ('effect','Champagne Confetti','effect_confetti', 20000.00,'TZS','epic', JSON_OBJECT('type','confetti','color','#FBBF24'), 1);

SET FOREIGN_KEY_CHECKS = 1;