-- Sample Players and Teams for Boxing Day 2026 Game System
-- This file contains example data for testing and demonstration
-- Customize these for your actual game night participants

-- ============================================================================
-- TEAMS
-- ============================================================================
USE ianntest_boxingday;


INSERT INTO teams (name, score, color, created_at) VALUES
('Team Red', 0, '#ef4444', NOW()),
('Team Green', 0, '#10b981', NOW()),
('Team Blue', 0, '#3b82f6', NOW()),
('Team Yellow', 0, '#f59e0b', NOW());

-- ============================================================================
-- PLAYERS
-- ============================================================================

-- Team Red Players
INSERT INTO players (name, team_id, score, created_at) VALUES
('Alice Johnson', 1, 0, NOW()),
('Bob Smith', 1, 0, NOW()),
('Charlie Brown', 1, 0, NOW());

-- Team Green Players
INSERT INTO players (name, team_id, score, created_at) VALUES
('Diana Prince', 2, 0, NOW()),
('Ethan Hunt', 2, 0, NOW()),
('Fiona Apple', 2, 0, NOW());

-- Team Blue Players
INSERT INTO players (name, team_id, score, created_at) VALUES
('George Lucas', 3, 0, NOW()),
('Hannah Montana', 3, 0, NOW()),
('Ian Malcolm', 3, 0, NOW());

-- Team Yellow Players
INSERT INTO players (name, team_id, score, created_at) VALUES
('Julia Roberts', 4, 0, NOW()),
('Kevin Hart', 4, 0, NOW()),
('Laura Croft', 4, 0, NOW());

-- ============================================================================
-- NOTES
-- ============================================================================
--
-- Team Colors:
-- - Team Red: #ef4444 (Bright Red)
-- - Team Green: #10b981 (Emerald Green)
-- - Team Blue: #3b82f6 (Sky Blue)
-- - Team Yellow: #f59e0b (Amber Yellow)
--
-- To add more players:
-- INSERT INTO players (name, team_id, score, created_at) VALUES
-- ('Player Name', team_id, 0, NOW());
--
-- To add more teams:
-- INSERT INTO teams (name, score, color, created_at) VALUES
-- ('Team Name', 0, '#hexcolor', NOW());
--
-- To reset all scores:
-- UPDATE teams SET score = 0;
-- UPDATE players SET score = 0;
--
-- To delete all sample data:
-- DELETE FROM players;
-- DELETE FROM teams;
-- ALTER TABLE players AUTO_INCREMENT = 1;
-- ALTER TABLE teams AUTO_INCREMENT = 1;
--
-- ============================================================================