-- V5 Team Pack: Full names + short codes, player names optional
-- Import in phpMyAdmin after database.sql. Logos can be added later from dashboard.

INSERT INTO teams (team_name, short_name, logo, team_color, contact_number) VALUES
('Sinharaja Warriors Cricket Club','SWCC','','#0b5cff',''),
('Colombo Royal Challengers','CRC','','#e3007a',''),
('Kandy Mountain Lions','KML','','#ffb703',''),
('Galle Southern Kings','GSK','','#00f5ff',''),
('Jaffna Northern Stars','JNS','','#7c3aed',''),
('Negombo Beach Riders','NBR','','#21d976',''),
('Matara Ocean Titans','MOT','','#118ab2',''),
('Kurunegala Golden Eagles','KGE','','#ffd166',''),
('Anuradhapura Heritage XI','AHXI','','#38bdf8',''),
('Badulla Hill Country Heroes','BHCH','','#f59e0b',''),
('Royal College Old Boys XI','RCOB','','#0047ff',''),
('Ananda College Cricket Club','ACCC','','#ff384c',''),
('Nalanda College Lions XI','NCL','','#101820',''),
('St Josephs Blue Stars','SJBS','','#1d4ed8',''),
('St Peters Saints XI','SPSX','','#0057ff',''),
('Trinity College Kandy XI','TCK','','#8b5a00',''),
('Lions XI Korea','LIONS','','#ffcc4d',''),
('Eagles XI Korea','EAGLES','','#00a6ff',''),
('Warriors XI Korea','WARR','','#ff008c',''),
('Thunder XI Korea','THUN','','#00c853',''),
('Titans XI Korea','TITAN','','#f7ff6a',''),
('Panthers XI Korea','PANT','','#111827',''),
('Kings XI Korea','KINGS','','#ff7a00',''),
('Legends XI Korea','LEGND','','#dbeafe','')
ON DUPLICATE KEY UPDATE
  short_name=VALUES(short_name),
  team_color=VALUES(team_color);
