-- =============================================================================
-- seed_brain_games.sql – Seeds for brain/word games
-- =============================================================================
-- trivia_questions: 310 original questions across 6 categories
-- emoji_charades_titles: 100+ original title seeds
-- draw_guess_words: easy/medium/hard word pools
--
-- All questions, titles and words are original works created for Twosome.
-- License: MIT / Original Work
-- See /docs/ASSETS.md
-- =============================================================================

-- ---------------------------------------------------------------------------
-- Table: trivia_questions
-- ---------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS trivia_questions (
    id         INT AUTO_INCREMENT PRIMARY KEY,
    category   ENUM('movies','food','science','india','general','couples') NOT NULL,
    difficulty ENUM('easy','medium','hard') NOT NULL,
    question   TEXT NOT NULL,
    options    JSON NOT NULL,   -- array of 4 strings
    answer_idx TINYINT NOT NULL -- 0-3
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------------
-- CATEGORY: movies (55 questions)
-- ---------------------------------------------------------------------------
INSERT INTO trivia_questions (category, difficulty, question, options, answer_idx) VALUES
-- EASY
('movies','easy','Which animated film features a clownfish searching for his son?',
 '["Finding Nemo","The Lion King","Moana","Shrek"]',0),
('movies','easy','In which movie does a boy befriend a gentle giant alien?',
 '["E.T.","Alien","Close Encounters","Men in Black"]',0),
('movies','easy','Which Disney princess has a pet chameleon named Pascal?',
 '["Rapunzel","Aurora","Ariel","Belle"]',0),
('movies','easy','What color is the pill Neo swallows to see the truth in The Matrix?',
 '["Red","Blue","Green","Yellow"]',0),
('movies','easy','Which movie features a character who can see dead people?',
 '["The Sixth Sense","Ghost","Casper","Poltergeist"]',0),
('movies','easy','In Toy Story, what is the cowboy doll named?',
 '["Woody","Buzz","Rex","Hamm"]',0),
('movies','easy','Which animated movie is set in the fictional underwater city of Atlantis?',
 '["Atlantis: The Lost Empire","Finding Dory","The Little Mermaid","Shark Tale"]',0),
('movies','easy','Who voiced Donkey in the Shrek films?',
 '["Eddie Murphy","Chris Rock","Will Smith","Mike Myers"]',0),
('movies','easy','In which film does a young boy accidentally trigger a full home security system against robbers?',
 '["Home Alone","Blank Check","Spy Kids","Problem Child"]',0),
('movies','easy','Which movie features a magic school bus that flies and shrinks?',
 '["Honey, I Shrunk the Kids","Magic School Bus Movie","Escape to Witch Mountain","Bedknobs and Broomsticks"]',0),
-- MEDIUM
('movies','medium','Which director made both Pulp Fiction and Kill Bill?',
 '["Quentin Tarantino","Martin Scorsese","David Fincher","Christopher Nolan"]',0),
('movies','medium','In which film does a character use the phrase "Here is looking at you, kid"?',
 '["Casablanca","The Godfather","Citizen Kane","It Happened One Night"]',0),
('movies','medium','Which film features a spinning top used to test whether a character is dreaming?',
 '["Inception","The Matrix","Shutter Island","Eternal Sunshine"]',0),
('movies','medium','What is the name of the fictional country in the Marvel Cinematic Universe ruled by Wakanda?',
 '["Wakanda","Latveria","Sokovia","Genosha"]',0),
('movies','medium','In Back to the Future, what speed must the DeLorean reach to travel in time?',
 '["88 mph","100 mph","75 mph","60 mph"]',0),
('movies','medium','Which film features a character building a clock tower to power a time machine?',
 '["Back to the Future","Clockwork Orange","Hugo","The Time Machine"]',0),
('movies','medium','Which actress played Katniss Everdeen in The Hunger Games series?',
 '["Jennifer Lawrence","Emma Stone","Scarlett Johansson","Shailene Woodley"]',0),
('movies','medium','In which animated movie is the villain a woman obsessed with fur coats?',
 '["101 Dalmatians","The Aristocats","Lady and the Tramp","Bambi"]',0),
('movies','medium','What is the name of the artificial intelligence in the movie 2001: A Space Odyssey?',
 '["HAL 9000","GLaDOS","Skynet","R2D2"]',0),
('movies','medium','Which city serves as the setting for the movie La La Land?',
 '["Los Angeles","New York","Chicago","San Francisco"]',0),
('movies','medium','What type of creature is Smaug in The Hobbit?',
 '["Dragon","Griffin","Wyvern","Basilisk"]',0),
('movies','medium','Which movie shows a father searching for his son through memory loss scenes?',
 '["Finding Nemo","Memento","Still Alice","Eternal Sunshine"]',0),
('movies','medium','In Titanic, what is the name of Jack Dawson artist friend who appears at the beginning?',
 '["Fabrizio","Tommy","Cal","Spicer"]',0),
('movies','medium','Which animated Pixar film features a restaurant critic who is the villain?',
 '["Ratatouille","The Incredibles","Up","Brave"]',0),
('movies','medium','In the movie Gravity, who plays the stranded astronaut Dr. Ryan Stone?',
 '["Sandra Bullock","Cate Blanchett","Natalie Portman","Charlize Theron"]',0),
-- HARD
('movies','hard','What is the name of the fictional language spoken by the Na'vi in Avatar?',
 '["Na'vi","Klingon","Elvish","Dothraki"]',0),
('movies','hard','Which Italian director is known for the Spaghetti Western genre, famous for The Good, the Bad and the Ugly?',
 '["Sergio Leone","Federico Fellini","Roberto Rossellini","Luchino Visconti"]',0),
('movies','hard','In which year was the first Academy Award ceremony held?',
 '["1929","1935","1920","1945"]',0),
('movies','hard','Which film pioneered the use of computer-generated imagery for a main character with the "liquid metal" T-1000?',
 '["Terminator 2","Jurassic Park","The Abyss","Tron"]',0),
('movies','hard','What is the name of the fictional element in the Marvel universe used to make Captain America shield?',
 '["Vibranium","Adamantium","Unobtainium","Kryptonite"]',0),
('movies','hard','Which actor played the role of Alan Turing in The Imitation Game?',
 '["Benedict Cumberbatch","Colin Firth","Eddie Redmayne","Andrew Garfield"]',0),
('movies','hard','In Alfred Hitchcock Rear Window, what does the protagonist do for a living?',
 '["Photographer","Journalist","Detective","Architect"]',0),
('movies','hard','Which 1984 film features a group of suburban children befriending an alien who can move objects with his mind?',
 '["Mac and Me","D.A.R.Y.L.","Flight of the Navigator","Explorers"]',0),
('movies','hard','What word completes the famous line from Jerry Maguire: "You complete ___"?',
 '["me","us","my life","everything"]',0),
('movies','hard','Which Japanese animation studio produced the films Spirited Away and My Neighbor Totoro?',
 '["Studio Ghibli","Toei Animation","Sunrise","Madhouse"]',0),
('movies','hard','Who directed the 2019 film Parasite which won the Academy Award for Best Picture?',
 '["Bong Joon-ho","Park Chan-wook","Lee Chang-dong","Kim Jee-woon"]',0),
('movies','hard','What is the name of the fictional town in the movie Groundhog Day?',
 '["Punxsutawney","Woodstock","Springfield","Pleasantville"]',0),
('movies','hard','In the film Whiplash, what instrument does the main character play?',
 '["Drums","Trumpet","Piano","Bass"]',0),
('movies','hard','Which film features a chess game between a knight and Death to delay the protagonist death?',
 '["The Seventh Seal","Ingmar Bergman","Wild Strawberries","Persona"]',0),
('movies','hard','What is the name of the monster in the 1954 original Japanese film that inspired later giant monster movies?',
 '["Gojira","Rodan","Mothra","Ghidorah"]',0);

-- ---------------------------------------------------------------------------
-- CATEGORY: food (55 questions)
-- ---------------------------------------------------------------------------
INSERT INTO trivia_questions (category, difficulty, question, options, answer_idx) VALUES
-- EASY
('food','easy','What is the main ingredient in guacamole?',
 '["Avocado","Tomato","Lime","Onion"]',0),
('food','easy','Which fruit is known as the "king of fruits" in Southeast Asia?',
 '["Durian","Mango","Jackfruit","Rambutan"]',0),
('food','easy','What type of pasta is shaped like small bow-ties?',
 '["Farfalle","Fusilli","Penne","Rigatoni"]',0),
('food','easy','Which spice gives curry its bright yellow color?',
 '["Turmeric","Saffron","Mustard","Paprika"]',0),
('food','easy','What is the primary ingredient in a classic Caesar salad dressing?',
 '["Anchovy","Parmesan","Egg","Lemon"]',0),
('food','easy','Which country invented pizza?',
 '["Italy","Greece","Turkey","France"]',0),
('food','easy','What nut is used to make marzipan?',
 '["Almond","Walnut","Cashew","Pistachio"]',0),
('food','easy','Which vegetable is used to make coleslaw?',
 '["Cabbage","Kale","Spinach","Lettuce"]',0),
('food','easy','What is the Japanese word for raw fish dish served over rice?',
 '["Sushi","Sashimi","Tempura","Ramen"]',0),
('food','easy','What is the sweet liquid produced by bees called?',
 '["Honey","Nectar","Syrup","Molasses"]',0),
-- MEDIUM
('food','medium','Which French cooking technique involves cooking food in a vacuum-sealed bag in temperature-controlled water?',
 '["Sous vide","Confit","Braise","Beurre blanc"]',0),
('food','medium','What is the name of the Italian dessert made with mascarpone, espresso and ladyfinger biscuits?',
 '["Tiramisu","Panna cotta","Cannoli","Zabaione"]',0),
('food','medium','Which region of France is famous for producing Champagne?',
 '["Champagne-Ardenne","Burgundy","Bordeaux","Alsace"]',0),
('food','medium','What is the Scoville scale used to measure?',
 '["Chili heat","Sweetness of sugar","Acidity of citrus","Bitterness of coffee"]',0),
('food','medium','Which grain is used to make traditional Japanese miso soup base?',
 '["Soybeans","Rice","Barley","Wheat"]',0),
('food','medium','What is the name of the crispy Indian flatbread cooked in a tandoor oven?',
 '["Naan","Chapati","Paratha","Bhatura"]',0),
('food','medium','Which country is the world largest producer of coffee?',
 '["Brazil","Ethiopia","Colombia","Vietnam"]',0),
('food','medium','What is the main flavoring agent in a traditional béarnaise sauce?',
 '["Tarragon","Basil","Thyme","Rosemary"]',0),
('food','medium','Which type of rice is used in a traditional risotto?',
 '["Arborio","Jasmine","Basmati","Long grain"]',0),
('food','medium','What does the word "umami" describe in culinary terms?',
 '["Savory taste","Sweet aftertaste","Spicy heat","Sour tang"]',0),
('food','medium','Which nut is inside a Ferrero Rocher chocolate?',
 '["Hazelnut","Almond","Walnut","Pistachio"]',0),
('food','medium','What is the Spanish tapas dish of potatoes in spicy sauce called?',
 '["Patatas bravas","Tortilla española","Croquetas","Pan con tomate"]',0),
('food','medium','What is the process of aging wine called?',
 '["Maturation","Fermentation","Pasteurization","Distillation"]',0),
('food','medium','Which herb is essential in a traditional pesto alla genovese?',
 '["Basil","Parsley","Oregano","Mint"]',0),
('food','medium','In which country was the Croissant originally invented?',
 '["Austria","France","Germany","Switzerland"]',0),
-- HARD
('food','hard','What is the name of the Japanese technique of presenting food with emphasis on visual appeal and balance?',
 '["Moritsuke","Kaiseki","Omakase","Bento"]',0),
('food','hard','Which enzyme in pineapple prevents gelatin from setting?',
 '["Bromelain","Papain","Ficin","Actinidin"]',0),
('food','hard','What is the name of the Moroccan slow-cooked stew made in a conical clay pot?',
 '["Tagine","Couscous","Harira","Bastilla"]',0),
('food','hard','Which French term describes cooking that extracts fat from meat to preserve it in the same fat?',
 '["Confit","Braise","Fricassee","Rillettes"]',0),
('food','hard','What is the primary flavor compound that gives vanilla its distinctive taste?',
 '["Vanillin","Linalool","Coumarin","Eugenol"]',0),
('food','hard','Which country produces Idiazabal cheese, traditionally smoked with cherry wood?',
 '["Spain","France","Italy","Portugal"]',0),
('food','hard','What is the name of the Japanese premium beef known for its extreme marbling?',
 '["Wagyu","Kobe","Angus","Matsusaka"]',0),
('food','hard','Which Indian state is the origin of Hyderabadi biryani?',
 '["Telangana","Andhra Pradesh","Karnataka","Maharashtra"]',0),
('food','hard','What is the name of the Peruvian dish of raw fish cured in citrus juice?',
 '["Ceviche","Anticucho","Lomo saltado","Aji de gallina"]',0),
('food','hard','Which element, found in trace amounts in salt, was added as a dietary supplement in the 20th century?',
 '["Iodine","Fluorine","Chlorine","Bromine"]',0),
('food','hard','What is the name of the traditional Ethiopian fermented flatbread made from teff flour?',
 '["Injera","Ugali","Fufu","Teff bread"]',0),
('food','hard','What term describes wine produced from grapes harvested after they freeze on the vine?',
 '["Ice wine","Late harvest","Eiswein","Noble rot"]',0),
('food','hard','Which city in France is considered the gastronomic capital of the country?',
 '["Lyon","Paris","Bordeaux","Strasbourg"]',0),
('food','hard','In molecular gastronomy, what technique uses sodium alginate and calcium chloride to create liquid-filled spheres?',
 '["Spherification","Gelification","Emulsification","Carbonation"]',0),
('food','hard','What is the name of the traditional Chinese fermented black beans used for flavoring?',
 '["Douchi","Miso","Doubanjiang","Tianmianjiang"]',0);

-- ---------------------------------------------------------------------------
-- CATEGORY: science (55 questions)
-- ---------------------------------------------------------------------------
INSERT INTO trivia_questions (category, difficulty, question, options, answer_idx) VALUES
-- EASY
('science','easy','What planet is known as the Red Planet?',
 '["Mars","Jupiter","Saturn","Venus"]',0),
('science','easy','What is the chemical symbol for water?',
 '["H2O","CO2","NaCl","O2"]',0),
('science','easy','Which organ pumps blood through the human body?',
 '["Heart","Liver","Kidney","Lung"]',0),
('science','easy','What is the closest star to Earth?',
 '["The Sun","Proxima Centauri","Alpha Centauri","Betelgeuse"]',0),
('science','easy','How many bones does an adult human body have?',
 '["206","208","196","212"]',0),
('science','easy','What force keeps planets in orbit around the sun?',
 '["Gravity","Magnetism","Nuclear force","Friction"]',0),
('science','easy','What is the hardest natural substance on Earth?',
 '["Diamond","Quartz","Corundum","Topaz"]',0),
('science','easy','Which gas do plants absorb during photosynthesis?',
 '["Carbon dioxide","Oxygen","Nitrogen","Hydrogen"]',0),
('science','easy','What is the speed of light approximately?',
 '["300,000 km/s","150,000 km/s","450,000 km/s","30,000 km/s"]',0),
('science','easy','Which scientist proposed the theory of general relativity?',
 '["Albert Einstein","Isaac Newton","Niels Bohr","Max Planck"]',0),
-- MEDIUM
('science','medium','What is the process by which plants convert sunlight into food called?',
 '["Photosynthesis","Respiration","Transpiration","Osmosis"]',0),
('science','medium','What is the name of the force that opposes motion between two surfaces in contact?',
 '["Friction","Tension","Normal force","Applied force"]',0),
('science','medium','What is the atomic number of Carbon?',
 '["6","12","8","14"]',0),
('science','medium','Which layer of the atmosphere contains the ozone layer?',
 '["Stratosphere","Troposphere","Mesosphere","Thermosphere"]',0),
('science','medium','What is the pH value of pure water?',
 '["7","6","8","5"]',0),
('science','medium','Which protein carries oxygen in red blood cells?',
 '["Hemoglobin","Albumin","Fibrinogen","Myoglobin"]',0),
('science','medium','What is the powerhouse of the cell?',
 '["Mitochondria","Nucleus","Ribosome","Golgi apparatus"]',0),
('science','medium','What is the name of the phenomenon where light bends when passing through different media?',
 '["Refraction","Reflection","Diffraction","Absorption"]',0),
('science','medium','Which element has the chemical symbol Fe?',
 '["Iron","Fluorine","Francium","Fermium"]',0),
('science','medium','What type of wave is sound?',
 '["Longitudinal","Transverse","Electromagnetic","Surface"]',0),
('science','medium','What is the SI unit of electrical resistance?',
 '["Ohm","Volt","Ampere","Watt"]',0),
('science','medium','Which organ in the body produces insulin?',
 '["Pancreas","Liver","Kidney","Spleen"]',0),
('science','medium','What is the name of the quantum phenomenon where particles can appear on both sides of a barrier?',
 '["Quantum tunneling","Superposition","Entanglement","Wave-particle duality"]',0),
('science','medium','What is the half-life of Carbon-14 approximately?',
 '["5,730 years","1,000 years","10,000 years","50,000 years"]',0),
('science','medium','Which type of rock is formed from cooled lava?',
 '["Igneous","Sedimentary","Metamorphic","Composite"]',0),
-- HARD
('science','hard','What is the name of the mathematical constant equal to the ratio of a circle circumference to its diameter?',
 '["Pi","Euler number","Golden ratio","Planck constant"]',0),
('science','hard','Which subatomic particle has a positive charge?',
 '["Proton","Electron","Neutron","Photon"]',0),
('science','hard','What is the name of the principle that states you cannot know both the position and momentum of a particle simultaneously?',
 '["Heisenberg uncertainty principle","Pauli exclusion principle","Copenhagen interpretation","Bell theorem"]',0),
('science','hard','What is the term for a star that has collapsed to extreme density, bending spacetime into a singularity?',
 '["Black hole","Neutron star","White dwarf","Pulsar"]',0),
('science','hard','Which DNA nitrogenous base pairs with Adenine in RNA?',
 '["Uracil","Thymine","Cytosine","Guanine"]',0),
('science','hard','What is the name of the force carrier particle for the strong nuclear force?',
 '["Gluon","W boson","Z boson","Photon"]',0),
('science','hard','What is the Chandrasekhar limit related to?',
 '["Maximum mass of a white dwarf","Minimum mass of a neutron star","Critical temperature of superconductors","Maximum speed of a comet"]',0),
('science','hard','Which scientist first isolated and named the element Radium?',
 '["Marie Curie","Ernest Rutherford","Henri Becquerel","Wilhelm Röntgen"]',0),
('science','hard','What is the name of the organelle responsible for protein synthesis?',
 '["Ribosome","Endoplasmic reticulum","Golgi apparatus","Lysosome"]',0),
('science','hard','What does CRISPR stand for in gene editing?',
 '["Clustered Regularly Interspaced Short Palindromic Repeats","Chromosomal Recombination In Specific Protein Regions","Controlled RNA Interference System for Precision Recoding","Cell RNA Integrated Splicing and Protein Regulation"]',0),
('science','hard','What is the name of the effect where time passes slower in stronger gravitational fields?',
 '["Gravitational time dilation","Special relativity","Doppler shift","Frame dragging"]',0),
('science','hard','Which enzyme unwinds the DNA double helix during replication?',
 '["Helicase","Polymerase","Ligase","Primase"]',0),
('science','hard','What is the name of the periodic table element with atomic number 92?',
 '["Uranium","Plutonium","Thorium","Neptunium"]',0),
('science','hard','What phenomenon causes the color of the sky to appear blue during daytime?',
 '["Rayleigh scattering","Mie scattering","Tyndall effect","Diffraction"]',0),
('science','hard','What is the name of the theoretical boundary around a black hole beyond which nothing can escape?',
 '["Event horizon","Schwarzschild radius","Photon sphere","Accretion disk"]',0);

-- ---------------------------------------------------------------------------
-- CATEGORY: india (55 questions)
-- ---------------------------------------------------------------------------
INSERT INTO trivia_questions (category, difficulty, question, options, answer_idx) VALUES
-- EASY
('india','easy','What is the capital city of India?',
 '["New Delhi","Mumbai","Kolkata","Chennai"]',0),
('india','easy','Which river is considered the most sacred river in India?',
 '["Ganges","Yamuna","Brahmaputra","Saraswati"]',0),
('india','easy','What is the national animal of India?',
 '["Bengal Tiger","Indian Elephant","Lion","Leopard"]',0),
('india','easy','Which festival is known as the festival of lights in India?',
 '["Diwali","Holi","Eid","Navratri"]',0),
('india','easy','What is the national sport of India?',
 '["Field Hockey","Cricket","Kabaddi","Football"]',0),
('india','easy','In which city is the Taj Mahal located?',
 '["Agra","Delhi","Jaipur","Lucknow"]',0),
('india','easy','What is the currency of India?',
 '["Rupee","Taka","Rial","Dinar"]',0),
('india','easy','Which ocean borders India to the south?',
 '["Indian Ocean","Arabian Sea","Bay of Bengal","Pacific Ocean"]',0),
('india','easy','Who was the first Prime Minister of independent India?',
 '["Jawaharlal Nehru","Mahatma Gandhi","Sardar Patel","B.R. Ambedkar"]',0),
('india','easy','What is the national flower of India?',
 '["Lotus","Rose","Jasmine","Sunflower"]',0),
-- MEDIUM
('india','medium','Which Indian mathematician is known for developing the concept of zero?',
 '["Aryabhata","Brahmagupta","Ramanujan","Bhaskaracharya"]',0),
('india','medium','What is the largest state in India by area?',
 '["Rajasthan","Madhya Pradesh","Uttar Pradesh","Maharashtra"]',0),
('india','medium','Which classical dance form originated in Kerala?',
 '["Kathakali","Bharatanatyam","Odissi","Kuchipudi"]',0),
('india','medium','In which year did India gain independence from British rule?',
 '["1947","1950","1945","1949"]',0),
('india','medium','What is the name of the ancient Indian board game that chess is said to have evolved from?',
 '["Chaturanga","Pachisi","Shatranj","Ashtapada"]',0),
('india','medium','Which Indian state is the largest producer of tea?',
 '["Assam","West Bengal","Tamil Nadu","Kerala"]',0),
('india','medium','What is the official language of the Indian state of Tamil Nadu?',
 '["Tamil","Telugu","Kannada","Malayalam"]',0),
('india','medium','Who wrote the Indian national anthem Jana Gana Mana?',
 '["Rabindranath Tagore","Bankim Chandra Chatterjee","Subramanya Bharati","Allama Iqbal"]',0),
('india','medium','Which mountain range forms the northern boundary of the Indian subcontinent?',
 '["The Himalayas","The Vindhyas","The Aravalli","The Sahyadri"]',0),
('india','medium','What is the name of the UNESCO World Heritage Site ancient city in Gujarat known for its step well?',
 '["Rani ki Vav","Fatehpur Sikri","Hampi","Lothal"]',0),
('india','medium','Which Indian scientist was known as the father of India nuclear program?',
 '["Homi J. Bhabha","A.P.J. Abdul Kalam","C.V. Raman","Vikram Sarabhai"]',0),
('india','medium','What is the name of the traditional Indian wrestling form?',
 '["Kushti","Kalaripayattu","Silambam","Gatka"]',0),
('india','medium','Which Indian city is known as the Silicon Valley of India?',
 '["Bengaluru","Hyderabad","Pune","Chennai"]',0),
('india','medium','What is the name of the annual festival where the deity Jagannath travels in a huge chariot procession in Odisha?',
 '["Rath Yatra","Durga Puja","Onam","Bihu"]',0),
('india','medium','Which Mughal emperor built the Red Fort in Delhi?',
 '["Shah Jahan","Aurangzeb","Akbar","Jahangir"]',0),
-- HARD
('india','hard','What is the name of the ancient Indian treatise on statecraft written by Chanakya?',
 '["Arthashastra","Manusmriti","Ramayana","Mahabharata"]',0),
('india','hard','Which Indian mathematician proved a formula for the sum of an arithmetic series attributed to him at age 8?',
 '["Carl Friedrich Gauss","Srinivasa Ramanujan","Brahmagupta","Aryabhata"]',0),
('india','hard','What is the name of the ancient port city excavated in Gujarat that is one of the oldest known planned cities?',
 '["Lothal","Dholavira","Mohenjo-daro","Harappa"]',0),
('india','hard','Which Indian classical musician is credited with popularizing the sitar globally?',
 '["Ravi Shankar","Bismillah Khan","Zakir Hussain","Ali Akbar Khan"]',0),
('india','hard','What is the name of India first indigenously developed light combat aircraft?',
 '["Tejas","Kaveri","Arjun","Agni"]',0),
('india','hard','In which Indian state is the Hornbill Festival celebrated, showcasing tribal culture?',
 '["Nagaland","Manipur","Meghalaya","Arunachal Pradesh"]',0),
('india','hard','Which Indian economist and philosopher won the Nobel Prize in Economics in 1998?',
 '["Amartya Sen","Manmohan Singh","Jagdish Bhagwati","Kaushik Basu"]',0),
('india','hard','What is the name of the traditional boat race held annually in Kerala?',
 '["Nehru Trophy Boat Race","Onam Boat Race","Vallamkali","Champakulam Race"]',0),
('india','hard','Which dynasty built the Brihadeeswarar Temple in Thanjavur, known for its massive stone tower?',
 '["Chola","Pallava","Chalukya","Rashtrakuta"]',0),
('india','hard','What was the original name of the city now known as Kolkata before it was renamed?',
 '["Calcutta","Bombay","Madras","Bangalore"]',0),
('india','hard','Which Indian scientist was awarded the Nobel Prize in Physics in 1930 for discovering the Raman Effect?',
 '["C.V. Raman","Satyendra Nath Bose","Meghnad Saha","Homi Bhabha"]',0),
('india','hard','What is the name of the ancient astronomical observatory built by Raja Jai Singh II in Jaipur?',
 '["Jantar Mantar","Brihat Samhita","Surya Yantra","Udaipur Observatory"]',0),
('india','hard','Which Indian mathematician independently discovered the sum of infinite series before European mathematicians?',
 '["Madhava of Sangamagrama","Brahmagupta","Bhaskara","Aryabhata"]',0),
('india','hard','What is the name of the ancient Indian text that contains the oldest known description of surgical instruments?',
 '["Sushruta Samhita","Charaka Samhita","Ashtanga Hridayam","Vagbhata"]',0),
('india','hard','Which Indian freedom fighter is known as the Nightingale of India?',
 '["Sarojini Naidu","Annie Besant","Vijaya Lakshmi Pandit","Kamala Nehru"]',0);

-- ---------------------------------------------------------------------------
-- CATEGORY: general (55 questions)
-- ---------------------------------------------------------------------------
INSERT INTO trivia_questions (category, difficulty, question, options, answer_idx) VALUES
-- EASY
('general','easy','How many continents are there on Earth?',
 '["7","6","8","5"]',0),
('general','easy','Which is the tallest mountain in the world?',
 '["Mount Everest","K2","Kangchenjunga","Lhotse"]',0),
('general','easy','What is the largest ocean on Earth?',
 '["Pacific","Atlantic","Indian","Arctic"]',0),
('general','easy','How many sides does a hexagon have?',
 '["6","5","7","8"]',0),
('general','easy','Which country has the largest population in the world?',
 '["India","China","USA","Indonesia"]',0),
('general','easy','What is the longest river in the world?',
 '["Nile","Amazon","Yangtze","Mississippi"]',0),
('general','easy','How many days are in a leap year?',
 '["366","365","367","364"]',0),
('general','easy','Which language has the most native speakers worldwide?',
 '["Mandarin Chinese","English","Spanish","Hindi"]',0),
('general','easy','What is the chemical symbol for gold?',
 '["Au","Ag","Go","Gd"]',0),
('general','easy','Which planet in our solar system has the most moons?',
 '["Saturn","Jupiter","Uranus","Neptune"]',0),
-- MEDIUM
('general','medium','What is the name of the international organization that maintains global peace and security?',
 '["United Nations","World Trade Organization","NATO","European Union"]',0),
('general','medium','Which country is home to the Great Barrier Reef?',
 '["Australia","Philippines","Indonesia","Brazil"]',0),
('general','medium','What is the name of the phenomenon where ocean temperatures rise unusually in the Pacific causing weather changes?',
 '["El Niño","La Niña","Monsoon","Trade winds"]',0),
('general','medium','How many chambers does the human heart have?',
 '["4","2","3","6"]',0),
('general','medium','Which is the smallest country in the world by area?',
 '["Vatican City","Monaco","San Marino","Liechtenstein"]',0),
('general','medium','What is the name of the currency used in Japan?',
 '["Yen","Won","Yuan","Baht"]',0),
('general','medium','How many strings does a standard guitar have?',
 '["6","4","5","7"]',0),
('general','medium','Which is the largest desert in the world?',
 '["Antarctic Desert","Sahara","Arabian","Gobi"]',0),
('general','medium','What is the name of the ancient wonder located in Alexandria, Egypt?',
 '["Lighthouse of Alexandria","Library of Alexandria","Colossus of Rhodes","Hanging Gardens"]',0),
('general','medium','Which element is the most abundant in Earth crust?',
 '["Oxygen","Silicon","Aluminum","Iron"]',0),
('general','medium','How many players are in a standard basketball team on the court?',
 '["5","6","7","4"]',0),
('general','medium','What is the name of the traditional Japanese art of paper folding?',
 '["Origami","Ikebana","Bonsai","Calligraphy"]',0),
('general','medium','Which ancient civilization built Machu Picchu?',
 '["Inca","Maya","Aztec","Olmec"]',0),
('general','medium','How many keys does a standard piano have?',
 '["88","76","92","72"]',0),
('general','medium','What is the name of the process by which water changes directly from solid to gas?',
 '["Sublimation","Evaporation","Condensation","Melting"]',0),
-- HARD
('general','hard','What is the name of the mathematical concept where the sum of a series equals the series itself divided by 1-r?',
 '["Geometric series","Arithmetic series","Harmonic series","Fibonacci sequence"]',0),
('general','hard','Which ancient city was the capital of the Aztec Empire?',
 '["Tenochtitlan","Teotihuacan","Chichen Itza","Palenque"]',0),
('general','hard','What is the name of the international agreement signed in 1987 to reduce substances depleting the ozone layer?',
 '["Montreal Protocol","Kyoto Protocol","Paris Agreement","Basel Convention"]',0),
('general','hard','In chess, which move allows a king and a rook to exchange positions under specific conditions?',
 '["Castling","En passant","Fork","Pin"]',0),
('general','hard','What is the name of the ship that explored Antartica in the late 1700s under Captain James Cook?',
 '["HMS Resolution","HMS Endeavour","HMS Beagle","HMS Victory"]',0),
('general','hard','Which philosopher wrote Critique of Pure Reason?',
 '["Immanuel Kant","René Descartes","John Locke","Baruch Spinoza"]',0),
('general','hard','What is the name of the international date line approximately located at 180 degrees longitude?',
 '["International Date Line","Prime Meridian","Antimeridian","Greenwich Meridian"]',0),
('general','hard','What is the sum of all interior angles of a pentagon?',
 '["540 degrees","360 degrees","720 degrees","480 degrees"]',0),
('general','hard','Which country hosted the first modern Olympic Games in 1896?',
 '["Greece","France","England","Germany"]',0),
('general','hard','What is the name of the logical fallacy where a conclusion is assumed within the premise?',
 '["Circular reasoning","Ad hominem","Strawman","False dichotomy"]',0),
('general','hard','What is the Fibonacci sequence number that follows 13?',
 '["21","20","18","24"]',0),
('general','hard','Which composer wrote The Four Seasons set of violin concertos?',
 '["Antonio Vivaldi","Johann Sebastian Bach","Wolfgang Amadeus Mozart","Ludwig van Beethoven"]',0),
('general','hard','What is the name of the fastest land animal on Earth?',
 '["Cheetah","Pronghorn antelope","Springbok","Quarterhorse"]',0),
('general','hard','Which two elements make up the compound table salt?',
 '["Sodium and Chlorine","Sodium and Oxygen","Potassium and Chlorine","Calcium and Oxygen"]',0),
('general','hard','What is the name of the unit of information equivalent to one billion bytes?',
 '["Gigabyte","Megabyte","Terabyte","Kilobyte"]',0);

-- ---------------------------------------------------------------------------
-- CATEGORY: couples (45 questions – relatedly original prompts)
-- ---------------------------------------------------------------------------
INSERT INTO trivia_questions (category, difficulty, question, options, answer_idx) VALUES
-- EASY
('couples','easy','What does "PDA" stand for in relationship context?',
 '["Public Display of Affection","Private Date Activity","Partner Defined Arrangement","Permanent Deep Attachment"]',0),
('couples','easy','Which psychologist proposed the concept of "love languages"?',
 '["Gary Chapman","Sigmund Freud","Carl Rogers","John Gottman"]',0),
('couples','easy','What is the traditional gift for a 25th wedding anniversary?',
 '["Silver","Gold","Diamond","Pearl"]',0),
('couples','easy','On which date is Valentine Day celebrated globally?',
 '["February 14","February 7","February 21","March 14"]',0),
('couples','easy','Which of the following is NOT one of the five love languages?',
 '["Financial security","Quality time","Physical touch","Acts of service"]',0),
('couples','easy','What color of roses typically symbolizes love and romance?',
 '["Red","Pink","Yellow","White"]',0),
('couples','easy','Which Italian city is considered the setting for Shakespeare most famous love story?',
 '["Verona","Venice","Florence","Rome"]',0),
('couples','easy','What is the term for the feeling of excitement and nervousness when near someone you like?',
 '["Butterflies","Infatuation","Euphoria","Adrenaline"]',0),
('couples','easy','In the popular phrase, "absence makes the heart grow ___"?',
 '["Fonder","Stronger","Sadder","Wiser"]',0),
('couples','easy','What is the name of the traditional first dance at a wedding reception?',
 '["First dance","Wedding waltz","Bridal shuffle","Reception tango"]',0),
-- MEDIUM
('couples','medium','According to John Gottman research, what are the four communication behaviors most predictive of relationship failure?',
 '["The Four Horsemen: criticism, contempt, defensiveness, stonewalling","Lying, cheating, neglect, jealousy","Arguing, blaming, ignoring, withdrawing","Shouting, silence, avoidance, denial"]',0),
('couples','medium','What is the psychological term for the tendency to idealize a romantic partner early in a relationship?',
 '["Limerence","Attachment","Projection","Transference"]',0),
('couples','medium','In relationship science, what does "secure attachment" typically lead to?',
 '["Healthier long-term relationships","More passionate short relationships","Greater independence","Less emotional connection"]',0),
('couples','medium','Which neurotransmitter is primarily associated with the feeling of pleasure and reward during romantic attraction?',
 '["Dopamine","Serotonin","Oxytocin","Adrenaline"]',0),
('couples','medium','What is the term for a couple who live together without being married?',
 '["Cohabiting","Common-law","Civil union","Domestic partnership"]',0),
('couples','medium','According to Sternberg triangular theory of love, which combination creates consummate love?',
 '["Intimacy, passion, and commitment","Passion and commitment only","Intimacy and passion only","Commitment only"]',0),
('couples','medium','What hormone is released during hugging and physical closeness, often called the "bonding hormone"?',
 '["Oxytocin","Cortisol","Endorphin","Melatonin"]',0),
('couples','medium','Which activity has research shown to be most effective for maintaining a strong romantic bond over time?',
 '["Novel shared experiences","Watching TV together","Gift giving","Regular date nights at the same restaurant"]',0),
('couples','medium','What percentage of communication is typically attributed to non-verbal cues according to research?',
 '["Over 50%","About 7%","About 30%","Exactly 50%"]',0),
('couples','medium','What is the term for the phenomenon where couples begin to mirror each other behavior, speech and gestures over time?',
 '["Behavioral synchrony","Attachment mirroring","Social contagion","Couple convergence"]',0),
-- HARD
('couples','hard','What is the name of Helen Fisher anthropological concept dividing romantic love into lust, attraction and attachment?',
 '["Three-stage model of love","Triangular theory","Wheel theory","Color wheel theory"]',0),
('couples','hard','Which country has the highest marriage rate per capita in the world according to recent data?',
 '["Egypt","United States","India","China"]',0),
('couples','hard','What is the psychological concept of "bids for connection" in couples research by John Gottman?',
 '["Attempts to get a partner attention or support","Financial requests between partners","Emotional blackmail patterns","Romantic gestures"]',0),
('couples','hard','According to the Couples Satisfaction Index developed by Mark Funk, what is the strongest predictor of relationship satisfaction?',
 '["Perceived responsiveness from partner","Frequency of romantic dates","Financial compatibility","Shared interests"]',0),
('couples','hard','What is the name of the longitudinal study at Harvard that tracked adult development for over 80 years and found close relationships to be the key to happiness?',
 '["Harvard Study of Adult Development","Terman Life-Cycle Study","Grant Study","Framingham Heart Study"]',0),
('couples','hard','In positive psychology, what is the concept that describes building a relationship on each partner strengths rather than fixing weaknesses?',
 '["Strength-based relationship","Flourishing partnership","Growth mindset coupling","Positive regard"]',0),
('couples','hard','What term describes when partners create their own unique relationship norms and rituals distinct from societal expectations?',
 '["Relationship culture","Couple identity","Dyadic norms","Bilateral customization"]',0),
('couples','hard','Which researcher introduced the concept of "positive sentiment override" explaining why happy couples interpret neutral actions charitably?',
 '["John Gottman","Sue Johnson","Robert Sternberg","Helen Fisher"]',0),
('couples','hard','What is the name of the therapy model based on adult attachment theory for couples, abbreviated EFT?',
 '["Emotionally Focused Therapy","Exposure and Family Therapy","Emotional Freedom Technique","Empirical Family Therapy"]',0),
('couples','hard','According to research, what is the most common reason couples seek therapy?',
 '["Communication problems","Financial issues","Infidelity","Parenting conflicts"]',0),
('couples','hard','Which concept in relationship research describes the ratio of positive to negative interactions that predicts relationship success?',
 '["Gottman ratio (5:1)","Pareto principle (80:20)","Golden ratio (1:1.618)","Equal reciprocity (1:1)"]',0),
('couples','hard','What is the name of the phenomenon where people rate potential partners more favorably after becoming emotionally invested?',
 '["Sunk cost fallacy","Escalation of commitment","Confirmation bias","Halo effect"]',0),
('couples','hard','What is the average age at which people in India get married today, according to 2021 NFHS data for women?',
 '["22.4 years","18.7 years","25.1 years","20.0 years"]',0),
('couples','hard','Which sociologist coined the term "pure relationship" to describe modern relationships maintained only as long as they satisfy both partners?',
 '["Anthony Giddens","Zygmunt Bauman","Ulrich Beck","Arlie Hochschild"]',0),
('couples','hard','What is the psychological term for excessively monitoring a partner actions and communications out of insecurity?',
 '["Hypervigilance","Attachment anxiety","Codependency","Obsessive love disorder"]',0);

-- ---------------------------------------------------------------------------
-- Table: emoji_charades_titles
-- ---------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS emoji_charades_titles (
    id         INT AUTO_INCREMENT PRIMARY KEY,
    title      VARCHAR(200) NOT NULL,
    category   ENUM('movie','song','book','place','animal','activity','food','show') NOT NULL,
    difficulty ENUM('easy','medium','hard') NOT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

INSERT INTO emoji_charades_titles (title, category, difficulty) VALUES
-- MOVIES – easy
('The Lion King','movie','easy'),
('Frozen','movie','easy'),
('Spider-Man','movie','easy'),
('Titanic','movie','easy'),
('The Jungle Book','movie','easy'),
('Finding Nemo','movie','easy'),
('Beauty and the Beast','movie','easy'),
('Moana','movie','easy'),
('Cars','movie','easy'),
('Toy Story','movie','easy'),
-- MOVIES – medium
('Interstellar','movie','medium'),
('The Dark Knight','movie','medium'),
('Inception','movie','medium'),
('Harry Potter','movie','medium'),
('La La Land','movie','medium'),
('The Avengers','movie','medium'),
('Jurassic Park','movie','medium'),
('The Greatest Showman','movie','medium'),
('Bohemian Rhapsody','movie','medium'),
('Coco','movie','medium'),
-- MOVIES – hard
('2001 A Space Odyssey','movie','hard'),
('The Seventh Seal','movie','hard'),
('Parasite','movie','hard'),
('Mulholland Drive','movie','hard'),
('Apocalypse Now','movie','hard'),
-- SONGS – easy
('Twinkle Twinkle Little Star','song','easy'),
('Happy Birthday','song','easy'),
('Let It Go','song','easy'),
('Baby Shark','song','easy'),
('Old MacDonald Had a Farm','song','easy'),
-- SONGS – medium
('Bohemian Rhapsody','song','medium'),
('Shape of You','song','medium'),
('Rolling in the Deep','song','medium'),
('Counting Stars','song','medium'),
('Blinding Lights','song','medium'),
('Dancing Queen','song','medium'),
('Yellow','song','medium'),
-- SONGS – hard
('Hotel California','song','hard'),
('A Day in the Life','song','hard'),
('Stairway to Heaven','song','hard'),
-- BOOKS – easy
('Harry Potter','book','easy'),
('The Lion the Witch and the Wardrobe','book','easy'),
('Charlotte Web','book','easy'),
('The Very Hungry Caterpillar','book','easy'),
('Matilda','book','easy'),
-- BOOKS – medium
('Pride and Prejudice','book','medium'),
('The Alchemist','book','medium'),
('To Kill a Mockingbird','book','medium'),
('The Great Gatsby','book','medium'),
('One Hundred Years of Solitude','book','medium'),
-- PLACES – easy
('Eiffel Tower','place','easy'),
('Taj Mahal','place','easy'),
('Mount Everest','place','easy'),
('Niagara Falls','place','easy'),
('Great Wall of China','place','easy'),
('Statue of Liberty','place','easy'),
-- PLACES – medium
('Machu Picchu','place','medium'),
('Angkor Wat','place','medium'),
('Colosseum','place','medium'),
('Golden Gate Bridge','place','medium'),
-- ANIMALS – easy
('Elephant','animal','easy'),
('Penguin','animal','easy'),
('Giraffe','animal','easy'),
('Dolphin','animal','easy'),
('Butterfly','animal','easy'),
('Flamingo','animal','easy'),
-- ACTIVITIES – easy
('Swimming','activity','easy'),
('Cycling','activity','easy'),
('Cooking','activity','easy'),
('Painting','activity','easy'),
('Dancing','activity','easy'),
('Gardening','activity','easy'),
-- ACTIVITIES – medium
('Rock climbing','activity','medium'),
('Scuba diving','activity','medium'),
('Stargazing','activity','medium'),
('Baking bread','activity','medium'),
-- FOOD – easy
('Pizza','food','easy'),
('Sushi','food','easy'),
('Ice cream','food','easy'),
('Tacos','food','easy'),
('Birthday cake','food','easy'),
-- SHOWS – medium
('Breaking Bad','show','medium'),
('Game of Thrones','show','medium'),
('Friends','show','medium'),
('Stranger Things','show','medium'),
('The Office','show','medium'),
('Brooklyn Nine-Nine','show','medium');

-- ---------------------------------------------------------------------------
-- Table: draw_guess_words
-- ---------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS draw_guess_words (
    id         INT AUTO_INCREMENT PRIMARY KEY,
    word       VARCHAR(100) NOT NULL,
    difficulty ENUM('easy','medium','hard') NOT NULL,
    category   VARCHAR(50) DEFAULT 'general'
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

INSERT INTO draw_guess_words (word, difficulty, category) VALUES
-- EASY words
('Cat','easy','animal'),('Dog','easy','animal'),('Fish','easy','animal'),
('Bird','easy','animal'),('Sun','easy','nature'),('Moon','easy','nature'),
('Star','easy','nature'),('Tree','easy','nature'),('House','easy','objects'),
('Car','easy','objects'),('Boat','easy','objects'),('Bike','easy','objects'),
('Ball','easy','objects'),('Book','easy','objects'),('Cup','easy','objects'),
('Hat','easy','clothing'),('Shoe','easy','clothing'),('Dress','easy','clothing'),
('Pizza','easy','food'),('Apple','easy','food'),('Cake','easy','food'),
('Ice cream','easy','food'),('Banana','easy','food'),('Heart','easy','symbols'),
('Rainbow','easy','nature'),('Cloud','easy','nature'),('Rain','easy','nature'),
('Snow','easy','nature'),('Fire','easy','nature'),('Flower','easy','nature'),
('Butterfly','easy','animal'),('Elephant','easy','animal'),('Lion','easy','animal'),
('Horse','easy','animal'),('Duck','easy','animal'),('Frog','easy','animal'),
('Spider','easy','animal'),('Turtle','easy','animal'),('Penguin','easy','animal'),
('Umbrella','easy','objects'),('Balloon','easy','objects'),('Kite','easy','objects'),
('Clock','easy','objects'),('Key','easy','objects'),('Door','easy','objects'),
('Window','easy','objects'),('Chair','easy','objects'),('Table','easy','objects'),
('Bed','easy','objects'),('Lamp','easy','objects'),
-- MEDIUM words
('Lighthouse','medium','places'),('Castle','medium','places'),
('Bridge','medium','places'),('Mountain','medium','nature'),
('Volcano','medium','nature'),('Desert','medium','nature'),
('Waterfall','medium','nature'),('Jungle','medium','nature'),
('Submarine','medium','objects'),('Telescope','medium','objects'),
('Microscope','medium','objects'),('Compass','medium','objects'),
('Scissors','medium','objects'),('Hammer','medium','objects'),
('Trumpet','medium','music'),('Guitar','medium','music'),
('Drum','medium','music'),('Piano','medium','music'),
('Sushi','medium','food'),('Burger','medium','food'),
('Noodles','medium','food'),('Tacos','medium','food'),
('Cupcake','medium','food'),('Pancakes','medium','food'),
('Astronaut','medium','people'),('Chef','medium','people'),
('Doctor','medium','people'),('Knight','medium','people'),
('Pirate','medium','people'),('Wizard','medium','people'),
('Dragon','medium','fantasy'),('Unicorn','medium','fantasy'),
('Mermaid','medium','fantasy'),('Phoenix','medium','fantasy'),
('Tornado','medium','nature'),('Lightning','medium','nature'),
('Glacier','medium','nature'),('Canyon','medium','nature'),
('Parachute','medium','objects'),('Helicopter','medium','objects'),
('Skateboard','medium','objects'),('Surfboard','medium','objects'),
('Roller coaster','medium','places'),('Ferris wheel','medium','places'),
('Library','medium','places'),('Museum','medium','places'),
('Treehouse','medium','places'),('Hammock','medium','objects'),
('Campfire','medium','nature'),('Igloo','medium','places'),
-- HARD words
('Democracy','hard','concepts'),('Photosynthesis','hard','science'),
('Gravity','hard','science'),('Evolution','hard','science'),
('Constellation','hard','nature'),('Archaeology','hard','science'),
('Architecture','hard','art'),('Choreography','hard','art'),
('Philosophy','hard','concepts'),('Economics','hard','concepts'),
('Quantum','hard','science'),('Symmetry','hard','math'),
('Perspective','hard','art'),('Illusion','hard','concepts'),
('Nostalgia','hard','concepts'),('Serenity','hard','concepts'),
('Perseverance','hard','concepts'),('Imagination','hard','concepts'),
('Procrastination','hard','concepts'),('Overwhelmed','hard','concepts'),
('Accordion','hard','music'),('Theremin','hard','music'),
('Didgeridoo','hard','music'),('Harpsichord','hard','music'),
('Bioluminescence','hard','science'),('Metamorphosis','hard','science'),
('Hibernation','hard','science'),('Echolocation','hard','science'),
('Circumnavigation','hard','concepts'),('Gerrymandering','hard','concepts'),
('Bureaucracy','hard','concepts'),('Renaissance','hard','history'),
('Industrial Revolution','hard','history'),('Impressionism','hard','art'),
('Surrealism','hard','art'),('Existentialism','hard','concepts'),
('Cryptocurrency','hard','technology'),('Artificial intelligence','hard','technology'),
('Augmented reality','hard','technology'),('Biotechnology','hard','technology');