-- =============================================================================
-- Twosome – database/seed_shared_cheeky_cards.sql
-- Unified Shared Card Table Seed Data for All Six Cheeky Games:
-- (game_type, text, level, mode, tags, is_spicy)
-- Strictly consensual, playful, original, flirty content.
-- =============================================================================

SET NAMES utf8mb4;

DELETE FROM cheeky_game_cards;

-- ── 1. The Flirt Bluff ────────────────────────────────────────────────────────
INSERT INTO cheeky_game_cards (game_type, text, level, mode, tags, is_spicy) VALUES
('flirt_bluff', '{"scenario":"First impression sparks","truth1":"I rehearsed our first phone call three times before dialing","truth2":"I saved your very first voice note to favorites","bluff":"I accidentally called you while sleeping on our first week"}', 1, 'both', 'first_impression,cute', 0),
('flirt_bluff', '{"scenario":"Late night confessions","truth1":"I check your profile picture when I miss your voice","truth2":"I have a secret playlist dedicated completely to you","bluff":"I once sent your picture to a group chat by mistake"}', 1, 'apart', 'confessions,apart', 0),
('flirt_bluff', '{"scenario":"Flirty compliments","truth1":"Your laugh genuinely derails my entire train of thought","truth2":"I still get butterflies whenever your caller photo pops up","bluff":"I bragged about your perfume to my coworkers"}', 2, 'both', 'flirty,sweet', 1),
('flirt_bluff', '{"scenario":"Cheeky thoughts","truth1":"I love when you tease me just before hanging up","truth2":"I planned out three reunion hugs down to the exact second","bluff":"I once wore your favorite color for five straight days"}', 2, 'both', 'cheeky,teasing', 1),
('flirt_bluff', '{"scenario":"Steamy daydreaming","truth1":"I have replayed our sweetest kiss in my mind during long commutes","truth2":"I love the exact sound of your breath when you whisper goodnight","bluff":"I wrote a secret poem about your lips in my notebook"}', 3, 'both', 'steamy,daydream', 1),
('flirt_bluff', '{"scenario":"Sensual chemistry","truth1":"The way you look at me across a crowded room gives me chills","truth2":"I secretly love when you get playfully possessive over my time","bluff":"I saved a screenshot of every single wink emoji you sent"}', 3, 'both', 'steamy,chemistry', 1);

-- ── 2. Blush Bingo ────────────────────────────────────────────────────────────
INSERT INTO cheeky_game_cards (game_type, text, level, mode, tags, is_spicy) VALUES
('blush_bingo', 'Blushed at a flirty text while on a serious work call', 1, 'apart', 'cute,texting', 0),
('blush_bingo', 'Smelled their hoodie or pillow when they were not looking', 1, 'both', 'cute,nostalgia', 0),
('blush_bingo', 'Practiced smiling in the mirror before answering video call', 1, 'apart', 'cute,video', 0),
('blush_bingo', 'Saved their photo as home screen wallpaper secretly', 1, 'both', 'sweet,phone', 0),
('blush_bingo', 'Got flustered because they winked at you unexpectedly', 2, 'both', 'blush,wink', 1),
('blush_bingo', 'Sent a voice note with a deliberate playful whisper', 2, 'apart', 'blush,whisper', 1),
('blush_bingo', 'Stared at their lips for more than three seconds while talking', 2, 'both', 'flirty,lips', 1),
('blush_bingo', 'Felt a sudden rush when they touched your lower waist', 3, 'together', 'steamy,touch', 1),
('blush_bingo', 'Had a dream about them so warm you woke up smiling', 3, 'both', 'steamy,dreams', 1),
('blush_bingo', 'Admitted an intimate fantasy you had never told anyone before', 3, 'both', 'steamy,confession', 1);

-- ── 3. Midnight Charades ──────────────────────────────────────────────────────
INSERT INTO cheeky_game_cards (game_type, text, level, mode, tags, is_spicy) VALUES
('midnight_charades', 'Pretend you are trying to be stealthy sneaking into the kitchen for midnight chocolate', 1, 'both', 'silly,acting', 0),
('midnight_charades', 'Act like you just received a good morning text that made your entire week', 1, 'both', 'cute,acting', 0),
('midnight_charades', 'Dramatically reenact our first awkward hello hug', 1, 'both', 'sweet,hug', 0),
('midnight_charades', 'Give the camera your most confident runway model slow-motion walk', 2, 'both', 'flirty,runway', 1),
('midnight_charades', 'Blow an irresistible cinematic kiss through the camera lens', 2, 'apart', 'flirty,kiss', 1),
('midnight_charades', 'Do a playful slow-motion hair flip and bite your lower lip teasingly', 2, 'both', 'cheeky,teasing', 1),
('midnight_charades', 'Slow sensual dance sway with an imaginary partner', 3, 'both', 'steamy,sway', 1),
('midnight_charades', 'Whisper something inaudible up close to the camera lens with intense eye contact', 3, 'apart', 'steamy,whisper', 1);

-- ── 4. Teasing Wheel ──────────────────────────────────────────────────────────
INSERT INTO cheeky_game_cards (game_type, text, level, mode, tags, is_spicy) VALUES
('teasing_wheel', '{"title":"Sugar Sweet Voice Note","description":"Send a 10-second voice note singing or humming their favorite chorus","icon":"🎵"}', 1, 'both', 'sweet,audio', 0),
('teasing_wheel', '{"title":"Compliment Shower","description":"Compliment three specific non-physical traits you adore about them","icon":"💖"}', 1, 'both', 'sweet,compliment', 0),
('teasing_wheel', '{"title":"Dream Reunion Date","description":"Describe your perfect reunion morning together in three sentences","icon":"🌅"}', 1, 'apart', 'romance,date', 0),
('teasing_wheel', '{"title":"Slow Gaze Duel","description":"Maintain unbroken flirty eye contact through camera or in person for 20 seconds","icon":"👀"}', 2, 'both', 'flirty,gaze', 1),
('teasing_wheel', '{"title":"Cheeky Nickname","description":"Call them by a secret sultry nickname for the next 3 rounds","icon":"🤫"}', 2, 'both', 'flirty,nickname', 1),
('teasing_wheel', '{"title":"Scent Memory","description":"Describe the exact smell of their perfume/skin and what memory it brings back","icon":"✨"}', 2, 'both', 'cheeky,memory', 1),
('teasing_wheel', '{"title":"Feather-Light Touch","description":"Gently trace their collarbone or palm with your fingertip for 15 seconds (or describe the exact sensation if apart)","icon":"🕊️"}', 3, 'both', 'steamy,touch', 1),
('teasing_wheel', '{"title":"Midnight Whisper Dare","description":"Whisper your most honest secret romantic craving into their ear or audio note","icon":"🔥"}', 3, 'both', 'steamy,whisper', 1);

-- ── 5. Two Choices, One Bed ───────────────────────────────────────────────────
INSERT INTO cheeky_game_cards (game_type, text, level, mode, tags, is_spicy) VALUES
('two_choices_one_bed', '{"option_a":"Lazy Sunday morning breakfast in bed","option_b":"Midnight road trip stargazing under blankets"}', 1, 'both', 'cozy,lifestyle', 0),
('two_choices_one_bed', '{"option_a":"One long warm hug after a exhausting day","option_b":"Holding hands in silence watching our favorite show"}', 1, 'both', 'cozy,sweet', 0),
('two_choices_one_bed', '{"option_a":"Forehead kisses every morning forever","option_b":"Neck kisses when nobody else is looking"}', 2, 'both', 'flirty,kiss', 1),
('two_choices_one_bed', '{"option_a":"Playfully whispering secrets under dim room lights","option_b":"Play wrestling for the cozy side of the duvet"}', 2, 'both', 'flirty,bed', 1),
('two_choices_one_bed', '{"option_a":"Sharing an intimate warm bubble bath with candles","option_b":"Swaying slowly in candlelight with no music"}', 3, 'both', 'steamy,candlelight', 1),
('two_choices_one_bed', '{"option_a":"Waking them up with teasing trailing kisses","option_b":"Falling asleep tangled together with zero personal space"}', 3, 'both', 'steamy,intimate', 1);

-- ── 6. The Whisper Code ───────────────────────────────────────────────────────
INSERT INTO cheeky_game_cards (game_type, text, level, mode, tags, is_spicy) VALUES
('whisper_code', '{"phrase":"your smile is sweet delight","decoys":["your smile is bright tonight","your style is deep and light","your eyes are warm and bright"]}', 1, 'both', 'rhyme,sweet', 0),
('whisper_code', '{"phrase":"counting down until we meet","decoys":["running down the quiet street","listening to our heartbeat","thinking of you when I sleep"]}', 1, 'apart', 'rhyme,apart', 0),
('whisper_code', '{"phrase":"you look breathtaking in moonlight","decoys":["you look wonderful tonight","you hold my fingers really tight","you kiss with passionate delight"]}', 2, 'both', 'rhyme,moonlight', 1),
('whisper_code', '{"phrase":"stole my heart without warning","decoys":["kissed my lips this early morning","kept me laughing late at night","danced with me until daylight"]}', 2, 'both', 'rhyme,flirty', 1),
('whisper_code', '{"phrase":"whisper softly against my neck","decoys":["keep my feelings all in check","kiss my lips with sweet respect","touch my cheek when we connect"]}', 3, 'both', 'rhyme,steamy', 1),
('whisper_code', '{"phrase":"crave your touch more each hour","decoys":["love your gentle quiet power","watch you bloom just like a flower","kiss you in a midnight shower"]}', 3, 'both', 'rhyme,steamy', 1);