-- ============================================================================= -- Twosome – database/seed_new_games_content.sql -- Additional static content seed for new match-engine games: -- world_countries (CC0 country data sample), emoji_charades_titles, -- draw_words (easy/medium/hard) -- All content is ORIGINAL or free-licensed (see /docs/ASSETS.md). -- ============================================================================= SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ── WORLD COUNTRIES (sample of ~60 countries, flag emoji + capitals) ── -- Source: CC0 / public domain country data (no copyrightable creative expression -- in country names, capitals, or flag emojis). Recorded in /docs/ASSETS.md. INSERT IGNORE INTO world_countries (id, name_common, name_official, capital, flag_emoji, region, subregion, cca2, cca3) VALUES (1, 'India', 'Republic of India', 'New Delhi', '🇮🇳', 'Asia', 'Southern Asia', 'IN', 'IND'), (2, 'United States', 'United States of America', 'Washington, D.C.', '🇺🇸', 'Americas', 'Northern America', 'US', 'USA'), (3, 'United Kingdom', 'United Kingdom of Great Britain and Northern Ireland', 'London', '🇬🇧', 'Europe', 'Northern Europe', 'GB', 'GBR'), (4, 'Canada', 'Canada', 'Ottawa', '🇨🇦', 'Americas', 'Northern America', 'CA', 'CAN'), (5, 'Australia', 'Commonwealth of Australia', 'Canberra', '🇦🇺', 'Oceania', 'Australia and New Zealand', 'AU', 'AUS'), (6, 'France', 'French Republic', 'Paris', '🇫🇷', 'Europe', 'Western Europe', 'FR', 'FRA'), (7, 'Germany', 'Federal Republic of Germany', 'Berlin', '🇩🇪', 'Europe', 'Western Europe', 'DE', 'DEU'), (8, 'Italy', 'Italian Republic', 'Rome', '🇮🇹', 'Europe', 'Southern Europe', 'IT', 'ITA'), (9, 'Japan', 'Japan', 'Tokyo', '🇯🇵', 'Asia', 'Eastern Asia', 'JP', 'JPN'), (10, 'Brazil', 'Federative Republic of Brazil', 'Brasília', '🇧🇷', 'Americas', 'South America', 'BR', 'BRA'), (11, 'Egypt', 'Arab Republic of Egypt', 'Cairo', '🇪🇬', 'Africa', 'Northern Africa', 'EG', 'EGY'), (12, 'South Africa', 'Republic of South Africa', 'Pretoria', '🇿🇦', 'Africa', 'Southern Africa', 'ZA', 'ZAF'), (13, 'Mexico', 'United Mexican States', 'Mexico City', '🇲🇽', 'Americas', 'Central America', 'MX', 'MEX'), (14, 'Argentina', 'Argentine Republic', 'Buenos Aires', '🇦🇷', 'Americas', 'South America', 'AR', 'ARG'), (15, 'South Korea', 'Republic of Korea', 'Seoul', '🇰🇷', 'Asia', 'Eastern Asia', 'KR', 'KOR'), (16, 'China', "People's Republic of China", 'Beijing', '🇨🇳', 'Asia', 'Eastern Asia', 'CN', 'CHN'), (17, 'Russia', 'Russian Federation', 'Moscow', '🇷🇺', 'Europe', 'Eastern Europe', 'RU', 'RUS'), (18, 'Spain', 'Kingdom of Spain', 'Madrid', '🇪🇸', 'Europe', 'Southern Europe', 'ES', 'ESP'), (19, 'Thailand', 'Kingdom of Thailand', 'Bangkok', '🇹🇭', 'Asia', 'South-Eastern Asia', 'TH', 'THA'), (20, 'Turkey', 'Republic of Türkiye', 'Ankara', '🇹🇷', 'Asia', 'Western Asia', 'TR', 'TUR'), (21, 'United Arab Emirates', 'United Arab Emirates', 'Abu Dhabi', '🇦🇪', 'Asia', 'Western Asia', 'AE', 'ARE'), (22, 'Saudi Arabia', 'Kingdom of Saudi Arabia', 'Riyadh', '🇸🇦', 'Asia', 'Western Asia', 'SA', 'SAU'), (23, 'Indonesia', 'Republic of Indonesia', 'Jakarta', '🇮🇩', 'Asia', 'South-Eastern Asia', 'ID', 'IDN'), (24, 'Malaysia', 'Malaysia', 'Kuala Lumpur', '🇲🇾', 'Asia', 'South-Eastern Asia', 'MY', 'MYS'), (25, 'Singapore', 'Republic of Singapore', 'Singapore', '🇸🇬', 'Asia', 'South-Eastern Asia', 'SG', 'SGP'), (26, 'Vietnam', 'Socialist Republic of Vietnam', 'Hanoi', '🇻🇳', 'Asia', 'South-Eastern Asia', 'VN', 'VNM'), (27, 'Philippines', 'Republic of the Philippines', 'Manila', '🇵🇭', 'Asia', 'South-Eastern Asia', 'PH', 'PHL'), (28, 'Netherlands', 'Kingdom of the Netherlands', 'Amsterdam', '🇳🇱', 'Europe', 'Western Europe', 'NL', 'NLD'), (29, 'Switzerland', 'Swiss Confederation', 'Bern', '🇨🇭', 'Europe', 'Western Europe', 'CH', 'CHE'), (30, 'Sweden', 'Kingdom of Sweden', 'Stockholm', '🇸🇪', 'Europe', 'Northern Europe', 'SE', 'SWE'), (31, 'Norway', 'Kingdom of Norway', 'Oslo', '🇳🇴', 'Europe', 'Northern Europe', 'NO', 'NOR'), (32, 'Denmark', 'Kingdom of Denmark', 'Copenhagen', '🇩🇰', 'Europe', 'Northern Europe', 'DK', 'DNK'), (33, 'Finland', 'Republic of Finland', 'Helsinki', '🇫🇮', 'Europe', 'Northern Europe', 'FI', 'FIN'), (34, 'Poland', 'Republic of Poland', 'Warsaw', '🇵🇱', 'Europe', 'Central Europe', 'PL', 'POL'), (35, 'Greece', 'Hellenic Republic', 'Athens', '🇬🇷', 'Europe', 'Southern Europe', 'GR', 'GRC'), (36, 'Portugal', 'Portuguese Republic', 'Lisbon', '🇵🇹', 'Europe', 'Southern Europe', 'PT', 'PRT'), (37, 'Ireland', 'Republic of Ireland', 'Dublin', '🇮🇪', 'Europe', 'Northern Europe', 'IE', 'IRL'), (38, 'Austria', 'Republic of Austria', 'Vienna', '🇦🇹', 'Europe', 'Central Europe', 'AT', 'AUT'), (39, 'Belgium', 'Kingdom of Belgium', 'Brussels', '🇧🇪', 'Europe', 'Western Europe', 'BE', 'BEL'), (40, 'New Zealand', 'New Zealand', 'Wellington', '🇳🇿', 'Oceania', 'Australia and New Zealand', 'NZ', 'NZL'), (41, 'Chile', 'Republic of Chile', 'Santiago', '🇨🇱', 'Americas', 'South America', 'CL', 'CHL'), (42, 'Colombia', 'Republic of Colombia', 'Bogotá', '🇨🇴', 'Americas', 'South America', 'CO', 'COL'), (43, 'Peru', 'Republic of Peru', 'Lima', '🇵🇪', 'Americas', 'South America', 'PE', 'PER'), (44, 'Nigeria', 'Federal Republic of Nigeria', 'Abuja', '🇳🇬', 'Africa', 'Western Africa', 'NG', 'NGA'), (45, 'Kenya', 'Republic of Kenya', 'Nairobi', '🇰🇪', 'Africa', 'Eastern Africa', 'KE', 'KEN'), (46, 'Morocco', 'Kingdom of Morocco', 'Rabat', '🇲🇦', 'Africa', 'Northern Africa', 'MA', 'MAR'), (47, 'Greece', 'Hellenic Republic', 'Athens', '🇬🇷', 'Europe', 'Southern Europe', 'GR', 'GRC'), (48, 'Israel', 'State of Israel', 'Jerusalem', '🇮🇱', 'Asia', 'Western Asia', 'IL', 'ISR'), (49, 'Jordan', 'Hashemite Kingdom of Jordan', 'Amman', '🇯🇴', 'Asia', 'Western Asia', 'JO', 'JOR'), (50, 'Lebanon', 'Lebanese Republic', 'Beirut', '🇱🇧', 'Asia', 'Western Asia', 'LB', 'LBN'), (51, 'Iraq', 'Republic of Iraq', 'Baghdad', '🇮🇶', 'Asia', 'Western Asia', 'IQ', 'IRQ'), (52, 'Iran', 'Islamic Republic of Iran', 'Tehran', '🇮🇷', 'Asia', 'Southern Asia', 'IR', 'IRN'), (53, 'Afghanistan', 'Islamic Republic of Afghanistan', 'Kabul', '🇦🇫', 'Asia', 'Southern Asia', 'AF', 'AFG'), (54, 'Bangladesh', "People's Republic of Bangladesh", 'Dhaka', '🇧🇩', 'Asia', 'Southern Asia', 'BD', 'BGD'), (55, 'Pakistan', 'Islamic Republic of Pakistan', 'Islamabad', '🇵🇰', 'Asia', 'Southern Asia', 'PK', 'PAK'), (56, 'Sri Lanka', 'Democratic Socialist Republic of Sri Lanka', 'Sri Jayawardenepura Kotte', '🇱🇰', 'Asia', 'Southern Asia', 'LK', 'LKA'), (57, 'Nepal', 'Federal Democratic Republic of Nepal', 'Kathmandu', '🇳🇵', 'Asia', 'Southern Asia', 'NP', 'NPL'), (58, 'Bhutan', 'Kingdom of Bhutan', 'Thimphu', '🇧🇹', 'Asia', 'Southern Asia', 'BT', 'BTN'), (59, 'Maldives', 'Republic of Maldives', 'Malé', '🇲🇻', 'Asia', 'Southern Asia', 'MV', 'MDV'), (60, 'Iceland', 'Republic of Iceland', 'Reykjavík', '🇮🇸', 'Europe', 'Northern Europe', 'IS', 'ISL'); -- ── EMOJI CHARADES TITLES (original titles + emoji descriptions) ── -- Source: Original content written for Twosome. License: MIT / Original Work. INSERT IGNORE INTO emoji_charades_titles (id, title, emojis, category, source, is_active) VALUES (1, 'Midnight in Paris', '✨🕰️🎨', 'movies', 'original', 1), (2, 'Spirited Away', '🐉🏮👧', 'movies', 'original', 1), (3, 'Spider-Man', '🕷️🕸️🧑‍🦰', 'movies', 'original', 1), (4, 'Frozen', '❄️👸🏰', 'movies', 'original', 1), (5, 'Toy Story', '🤠🚀🤖', 'movies', 'original', 1), (6, 'The Matrix', '💊🔍🌆', 'movies', 'original', 1), (7, 'Titanic', '🚢💔🌊', 'movies', 'original', 1), (8, 'Avatar', '👽🌿🌌', 'movies', 'original', 1), (9, 'Sherlock Holmes', '🕵️‍♂️🔍🎻', 'movies', 'original', 1), (10, 'Star Wars', '⚔️🚀🌌', 'movies', 'original', 1), (11, 'Pizza', '🍕🧀🍅', 'food', 'original', 1), (12, 'Sushi', '🍣🍚🐟', 'food', 'original', 1), (13, 'Chocolate Cake', '🍫🍰🎂', 'food', 'original', 1), (14, 'Ice Cream', '🍦🍧🍨', 'food', 'original', 1), (15, 'Taco', '🌮🌽🔥', 'food', 'original', 1), (16, 'Burger', '🍔🥩🍅', 'food', 'original', 1), (17, 'Coffee', '☕🫘🌅', 'food', 'original', 1), (18, 'Popcorn', '🍿🎬🧈', 'food', 'original', 1), (19, 'Rainbow', '🌈☀️🌧️', 'nature', 'original', 1), (20, 'Volcano', '🌋🔥🏔️', 'nature', 'original', 1), (21, 'Aurora Borealis', '💚🌌❄️', 'nature', 'original', 1), (22, 'Sunset', '🌅🧡🌊', 'nature', 'original', 1), (23, 'Thunderstorm', '⛈️💥🌧️', 'nature', 'original', 1), (24, 'Butterfly', '🦋🌸🪰', 'nature', 'original', 1), (25, 'Mountain', '🏔️⛰️🧗', 'nature', 'original', 1), (26, 'Ocean Wave', '🌊🌊🏄', 'nature', 'original', 1), (27, 'First Date', '🍽️💕👀', 'couples', 'original', 1), (28, 'Wedding Ring', '💍💒🤵', 'couples', 'original', 1), (29, 'Long Distance', '📱✈️❤️', 'couples', 'original', 1), (30, 'Anniversary', '🎂💌🥂', 'couples', 'original', 1), (31, 'Love Letter', '✉️❤️🖋️', 'couples', 'original', 1), (32, 'Slow Dance', '💃🕺🎶', 'couples', 'original', 1), (33, 'Morning Coffee Together', '☕👫🌅', 'couples', 'original', 1), (34, 'Stargazing', '🌟🔭🌌', 'couples', 'original', 1), (35, 'Rainy Day', '🌧️☔🍵', 'couples', 'original', 1), (36, 'Surprise Gift', '🎁🎉😮', 'couples', 'original', 1), (37, 'Dinosaur', '🦖🌋🦕', 'animals', 'original', 1), (38, 'Astronaut', '👨‍🚀🚀🌙', 'animals', 'original', 1), (39, 'Pirate Ship', '🏴‍☠️🚢⚓', 'animals', 'original', 1), (40, 'Superhero', '🦸‍♂️💪🎭', 'animals', 'original', 1), (41, 'Time Machine', '⏱️🕰️🌀', 'animals', 'original', 1), (42, 'Magic Wand', '🪄✨🎩', 'animals', 'original', 1), (43, 'Robot', '🤖⚙️🔋', 'animals', 'original', 1), (44, 'Fairy Tale', '🧚🏰📖', 'animals', 'original', 1), (45, 'Treasure Map', '🗺️💰❌', 'animals', 'original', 1), (46, 'Wedding Dance', '💃🕺💍', 'couples', 'original', 1), (47, 'Cooking Together', '👨‍🍳👩‍🍳🍳', 'couples', 'original', 1), (48, 'Picnic in Park', '🧺🌳🥪', 'couples', 'original', 1), (49, 'Beach Vacation', '🏖️🏊☀️', 'couples', 'original', 1), (50, 'Movie Night', '🍿🎬🛋️', 'couples', 'original', 1); -- ── DRAW WORDS (easy/medium/hard, original content) ── -- Source: Original content written for Twosome. License: MIT / Original Work. INSERT IGNORE INTO draw_words (id, word, difficulty, source, is_active) VALUES -- Easy (1, 'Cat', 'easy', 'original', 1), (2, 'Dog', 'easy', 'original', 1), (3, 'Sun', 'easy', 'original', 1), (4, 'Moon', 'easy', 'original', 1), (5, 'Star', 'easy', 'original', 1), (6, 'Heart', 'easy', 'original', 1), (7, 'Apple', 'easy', 'original', 1), (8, 'Ball', 'easy', 'original', 1), (9, 'Car', 'easy', 'original', 1), (10, 'Tree', 'easy', 'original', 1), (11, 'House', 'easy', 'original', 1), (12, 'Flower', 'easy', 'original', 1), (13, 'Fish', 'easy', 'original', 1), (14, 'Bird', 'easy', 'original', 1), (15, 'Cup', 'easy', 'original', 1), (16, 'Book', 'easy', 'original', 1), (17, 'Hat', 'easy', 'original', 1), (18, 'Shoe', 'easy', 'original', 1), (19, 'Key', 'easy', 'original', 1), (20, 'Ring', 'easy', 'original', 1), -- Medium (21, 'Airplane', 'medium', 'original', 1), (22, 'Rocket', 'medium', 'original', 1), (23, 'Castle', 'medium', 'original', 1), (24, 'Pizza', 'medium', 'original', 1), (25, 'Hamburger', 'medium', 'original', 1), (26, 'Camera', 'medium', 'original', 1), (27, 'Telephone', 'medium', 'original', 1), (28, 'Umbrella', 'medium', 'original', 1), (29, 'Bicycle', 'medium', 'original', 1), (30, 'Backpack', 'medium', 'original', 1), (31, 'Laptop', 'medium', 'original', 1), (32, 'Headphones', 'medium', 'original', 1), (33, 'Microphone', 'medium', 'original', 1), (34, 'Guitar', 'medium', 'original', 1), (35, 'Piano', 'medium', 'original', 1), (36, 'Violin', 'medium', 'original', 1), (37, 'Trumpet', 'medium', 'original', 1), (38, 'Helicopter', 'medium', 'original', 1), (39, 'Submarine', 'medium', 'original', 1), (40, 'Telescope', 'medium', 'original', 1), -- Hard (41, 'Volcano', 'hard', 'original', 1), (42, 'Giraffe', 'hard', 'original', 1), (43, 'Elephant', 'hard', 'original', 1), (44, 'Kangaroo', 'hard', 'original', 1), (45, 'Octopus', 'hard', 'original', 1), (46, 'Butterfly', 'hard', 'original', 1), (47, 'Peacock', 'hard', 'original', 1), (48, 'Penguin', 'hard', 'original', 1), (49, 'Lighthouse', 'hard', 'original', 1), (50, 'Windmill', 'hard', 'original', 1), (51, 'Ferris Wheel Gondola', 'hard', 'original', 1), (52, 'Clock Tower', 'hard', 'original', 1), (53, 'Suspension Bridge','hard', 'original', 1), (54, 'Skyscraper', 'hard', 'original', 1), (55, 'Hot Air Balloon', 'hard', 'original', 1), (56, 'Sailing Ship', 'hard', 'original', 1), (57, 'Cannon', 'hard', 'original', 1), (58, 'Treasure Chest', 'hard', 'original', 1), (59, 'Magic Lamp', 'hard', 'original', 1), (60, 'Hovercraft', 'hard', 'original', 1); SET FOREIGN_KEY_CHECKS = 1;