-- Seed Data: Spin the Mirchi (60+ Original Spicy Cards across 6 Categories)
-- Categories: accessories, confessions, scenarios, desires, dilemmas, teases
-- Levels: 1 (Mild/Flirty), 2 (Spicy/Sensual), 3 (Steamy/Intimate)
-- Modes: together, apart, both

INSERT INTO spin_the_mirchi_cards (code, category, title, prompt_text, apart_prompt, together_prompt, level, mode, is_spicy) VALUES
-- ── 1. PLAYFUL ACCESSORIES (12 cards) ────────────────────────────────────────
('stm_acc_01', 'accessories', 'Silk Ties & Velvet Cuffs', 'Novelty fuzzy handcuffs vs silk ties: which would you trust me to restrain your wrists with gently?', 'Send a voice note detailing who would be tied up first and why.', 'Discuss whether you prefer soft silk ties or playful cuffs while holding their wrists.', 2, 'both', 1),
('stm_acc_02', 'accessories', 'Sensory Blindfold', 'Have you ever wanted to be blindfolded while having sweet treats fed to you or soft kisses placed on your skin?', 'Describe what sensory surprise you would prepare if you had me blindfolded.', 'Close your eyes or put on a blindfold while your partner whispers where they will kiss you next.', 2, 'both', 1),
('stm_acc_03', 'accessories', 'Feather & Temperature Play', 'Between a gentle feather tickler and a melting ice cube traced along your collarbone, which excites you more?', 'Tell me which sensory tease would make you shiver faster over voice note.', 'Take an ice cube or soft feather and demonstrate the sensation on their hand or neck.', 2, 'both', 1),
('stm_acc_04', 'accessories', 'The Satin Choker', 'What is your honest, unfiltered thought on wearing a sleek satin collar or choker during our private dates?', 'Share your take on playful power-exchange accessories in our private chat.', 'Touch your partner''s neck gently and ask how they would feel wearing one.', 2, 'both', 1),
('stm_acc_05', 'accessories', 'Restrained Control', 'If I gently handcuffed your hands behind your back for 5 minutes, what is the first tease you would beg for?', 'Send an audio confession describing how helpless or excited that would feel.', 'Gently hold their hands behind their back and whisper your teasing terms.', 3, 'both', 1),
('stm_acc_06', 'accessories', 'Costume & Disguise', 'If we had to dress up in playful secret identities for one private night, what role would you pick for each of us?', 'Text a 3-sentence scenario describing our secret costumes.', 'Describe your dream playful roleplay persona right into their eyes.', 1, 'both', 1),
('stm_acc_07', 'accessories', 'Scented Massage Oil', 'Warm coconut oil vs cooling peppermint lotion: which sensory rubdown do you crave after a long week apart?', 'Send a message picking the oil and describing which muscle knot needs the most attention.', 'Gently knead their shoulder muscles and agree on your next massage night.', 1, 'both', 1),
('stm_acc_08', 'accessories', 'The Velvet Leash', 'Who holds the leash: do you crave having me gently guide you, or would you take the reins and lead me around?', 'Confess who naturally craves taking the lead when things get intense.', 'Look them in the eye and state who holds ultimate control tonight.', 3, 'both', 1),
('stm_acc_09', 'accessories', 'Tempting Lingerie Choice', 'Silk robe, lace bodysuit, or oversized boyfriend shirt: what outfit makes your heart race the fastest on me?', 'Send a picture or description of the exact look that drives you wild.', 'Pick their outfit for tomorrow morning or bedtime.', 2, 'both', 1),
('stm_acc_10', 'accessories', 'Bedpost Restraints', 'If you woke up gently secured to the four corners with soft ribbons, what would be your reaction?', 'Send a voice note describing whether you would struggle playfully or surrender.', 'Trace ribbons or your fingers along the bedposts while sharing your thoughts.', 3, 'both', 1),
('stm_acc_11', 'accessories', 'Sensory Earphones', 'Listening to slow, rhythmic binaural beats vs listening to my voice whispering fantasies: which gets you in the zone?', 'Put on headphones right now and send a 10-second breathy whisper test.', 'Place earphones on your partner and whisper a secret compliment right next to them.', 1, 'both', 1),
('stm_acc_12', 'accessories', 'The Tickle Torture Feather', 'What is your most sensitive tickle spot that renders you completely helpless with laughter?', 'Admit your most ticklish zone in chat.', 'Gently test that tickle spot for 5 playful seconds.', 1, 'both', 1),

-- ── 2. MIDNIGHT CONFESSIONS (12 cards) ───────────────────────────────────────
('stm_cnf_01', 'confessions', 'Recording Intimacy Thoughts', 'Have you ever been curious or tempted to record an intimate video or spicy voice memo together? What excited or stopped you?', 'Confess whether you have ever saved a private audio note just for your ears.', 'Talk openly about your thoughts on digital privacy, boundaries, and private voice notes.', 2, 'both', 1),
('stm_cnf_02', 'confessions', 'Unspoken Bedroom Fantasy', 'What is one private bedroom scenario you have daydreamed about with me that you have never dared to say out loud?', 'Type your unsaid fantasy in our private encrypted chat or share on voice note.', 'Whisper the fantasy directly into their ear so softly no one else could ever hear.', 3, 'both', 1),
('stm_cnf_03', 'confessions', 'The Sneaky Touch Urge', 'Have you ever had an overwhelming urge to touch or kiss me intimately while we were in a public or semi-public place?', 'Confess the exact moment and location you felt that irresistible urge.', 'Look at them and tell them which public moment made you crave them most.', 2, 'both', 1),
('stm_cnf_04', 'confessions', 'Late Night Replay', 'What is the steamiest memory of us that you replay in your mind when you are falling asleep alone?', 'Describe the memory using 4 vivid keywords.', 'Remind your partner of that exact night and what made it unforgettable.', 2, 'both', 1),
('stm_cnf_05', 'confessions', 'Secret Kink Curiosity', 'What is a spicy curiosity or kink you have read or heard about that you secretly wonder if we would enjoy?', 'Share your curiosity without judgment; Twosome is your safe space.', 'Hold hands and explore whether this curiosity is on your couple bucket list.', 3, 'both', 1),
('stm_cnf_06', 'confessions', 'Power Dynamic Craving', 'Do you ever crave having me take complete assertive control, or do you prefer being in the driver''s seat?', 'Confess your true craving regarding dominance and surrender.', 'Demonstrate your preferred dynamic with a confident or yielding touch.', 2, 'both', 1),
('stm_cnf_07', 'confessions', 'First Spicy Thought', 'When was the exact day or moment our relationship crossed over in your mind from innocent sweet to undeniably hot?', 'Describe the moment and what sparked that sizzling chemistry.', 'Tell them the story while looking directly into their eyes.', 1, 'both', 1),
('stm_cnf_08', 'confessions', 'Jealous Spark', 'Has seeing someone else look at me with admiration ever secretly turned you on or stoked your desire?', 'Admit whether a hint of possessiveness excites you.', 'Put your arm around them and claim them with a possessive smile.', 2, 'both', 1),
('stm_cnf_09', 'confessions', 'Whisper in the Dark', 'What is something dirty or sensual you want to hear me whisper when the lights are completely out?', 'Send a voice note detailing the exact phrase you want to hear.', 'Lean close into their neck and whisper the words you crave.', 3, 'both', 1),
('stm_cnf_10', 'confessions', 'Morning vs Midnight Heat', 'Do you crave passionate midnight encounters when the world is asleep, or lazy, breathless morning connections?', 'Cast your vote and explain why that time of day stirs you more.', 'Share which time slot you are reserving for your next reunion.', 1, 'both', 1),
('stm_cnf_11', 'confessions', 'Seductive Outfit Confession', 'What specific item in my wardrobe has secretly driven you crazy the most without me realizing it?', 'Send a description of the outfit and the day they wore it.', 'Point out the outfit in their closet or describe the memory.', 1, 'both', 1),
('stm_cnf_12', 'confessions', 'Uncontrollable Butterflies', 'What physical touch from me gives you instant goosebumps down your spine?', 'Describe the exact touch and path on your skin.', 'Guide their hand to that spot and show them.', 2, 'both', 1),

-- ── 3. SENSUAL SCENARIOS (12 cards) ──────────────────────────────────────────
('stm_scn_01', 'scenarios', 'The 10-Minute Whisper Rule', 'For the next 10 minutes, neither of us is permitted to speak above a breathy, sensual whisper.', 'Conduct the rest of this game on call or voice notes using only whispers.', 'Switch to soft whispers immediately and lean in close.', 1, 'both', 1),
('stm_scn_02', 'scenarios', 'The Power Switch', 'Tonight, one partner sets all rules and the other must ask permission before every kiss or touch. Who takes the crown?', 'Agree on who gets absolute authority for the rest of tonight''s match.', 'The ruler sits back while the other partner asks permission for a kiss.', 2, 'both', 1),
('stm_scn_03', 'scenarios', 'Sensory Blackout', 'Pitch black room, zero sight, only touch, breath, and sound. How long would you last before losing your composure?', 'Describe how you envision our first sensory blackout night.', 'Turn off all room lights or close eyes completely for 30 seconds of quiet connection.', 2, 'both', 1),
('stm_scn_04', 'scenarios', 'The Hallway Encounter', 'Imagine greeting each other at the hotel doorway after months apart: describe the first 60 seconds without saying a word.', 'Send a step-by-step text describing the intense reunion greeting.', 'Act out the dramatic hallway embrace right now.', 2, 'both', 1),
('stm_scn_05', 'scenarios', 'Candlelit Countdown', 'Set a burning candle: we take turns taking 3 slow steps closer until there is zero space between our bodies.', 'Describe the slow walk toward each other over voice note.', 'Stand 6 feet apart and take slow synchronized steps until chest-to-chest.', 1, 'both', 1),
('stm_scn_06', 'scenarios', 'The Tease & Deny Game', 'One partner is only allowed to touch with feather-light brush strokes; zero firm grips allowed for 5 minutes.', 'Describe how agonizingly sweet that teasing touch would be.', 'Deliver 60 seconds of feather-light brush strokes along their arm.', 2, 'both', 1),
('stm_scn_07', 'scenarios', 'Secret Bedroom Safe Word', 'Pick an exotic, funny fruit (like "Pineapple" or "Dragonfruit") as our official safe word for playful games.', 'Agree on our funny safe word and test it in chat.', 'Agree on our safe word and seal it with a high five.', 1, 'both', 0),
('stm_scn_08', 'scenarios', 'The Slow Seduction Playlist', 'If you had to pick one track that sets the ultimate bedroom tempo for us, what song plays first?', 'Send a link or title of the song to listen together.', 'Play the track on your phone speaker and listen in silence.', 1, 'both', 0),
('stm_scn_09', 'scenarios', 'The Pinned Hands Tease', 'Imagine being gently held down by both wrists while having your neck kissed slowly. Are you smiling or gasping?', 'Send a 5-second reaction audio to this scenario.', 'Gently pin their wrists to the couch or bed and hold eye contact.', 3, 'both', 1),
('stm_scn_10', 'scenarios', 'The Forbidden Laugh', 'Try to deliver your dirtiest, most smoldering gaze without cracking a smile for 20 seconds.', 'Send a video of your serious sultry stare.', 'Lock eyes and see who breaks into giggles first.', 1, 'both', 0),
('stm_scn_11', 'scenarios', 'The Secret Command', 'Give your partner one sensual command that they must fulfill before midnight tonight.', 'Text the secret command with sweet anticipation.', 'Whisper the command into their ear.', 2, 'both', 1),
('stm_scn_12', 'scenarios', 'Sensory Ice Melt', 'Hold an ice cube in your mouth until it warms, then kiss your partner''s collarbone or wrist.', 'Describe how the chill and heat contrast would feel.', 'Execute the ice kiss on their wrist or cheek.', 3, 'together', 1),

-- ── 4. SECRET DESIRES (12 cards) ─────────────────────────────────────────────
('stm_des_01', 'desires', 'The Wall Pin Fantasy', 'Where outside the bedroom do you most crave being pushed against the wall for a breathless kiss?', 'Name the location (kitchen counter, elevator, hallway, car) and explain why.', 'Gently back them against the nearest wall and lock eyes.', 2, 'both', 1),
('stm_des_02', 'desires', 'The Melt-Down Touch', 'What is that one specific spot on your body where even the lightest brush makes your whole body shiver?', 'Pinpoint the spot: nape of neck, lower back, inner wrist, behind the ear.', 'Take their finger and guide it directly to that exact spot.', 2, 'both', 1),
('stm_des_03', 'desires', 'The Morning Whisper', 'What would you love to wake up to hearing murmured against your neck at 7:00 AM?', 'Send a 7-second voice clip whispering your dream morning greeting.', 'Murmur that dream greeting against their ear.', 1, 'both', 1),
('stm_des_04', 'desires', 'Role Reversal Night', 'If you usually let your partner take initiative, do you crave flipping the script and taking aggressive lead?', 'Admit if you secretly desire taking complete charge on our next reunion.', 'Take their hands firmly and state what you will do next time.', 2, 'both', 1),
('stm_des_05', 'desires', 'The Secluded Spot', 'Have you ever fantasized about an adventurous, secluded outdoor make-out session (e.g. starlit rooftop, hidden beach cove)?', 'Describe your dream starlit or secluded romantic hideaway.', 'Discuss which secluded spot you will explore on your next trip.', 2, 'both', 1),
('stm_des_06', 'desires', 'The Restraint Fantasy', 'Would you rather be completely tied down with zero say, or hold the keys and call every single shot?', 'Confess your true leaning between helpless surrender vs playful dominance.', 'Tell them who holds the keys tonight.', 3, 'both', 1),
('stm_des_07', 'desires', 'The Lingering Scent', 'Would you rather sleep with my unwashed t-shirt that smells like my cologne/perfume, or a recorded voice note on loop?', 'Pick your favorite comfort token when distance feels hard.', 'Breathe in their scent or spray their favorite perfume on a pillow.', 1, 'both', 0),
('stm_des_08', 'desires', 'Spicy Bucket List Item', 'What is the number one adventurous adventure you want us to check off our intimacy bucket list before next year?', 'Confess your top bucket list item.', 'Write it down together in your private notes.', 3, 'both', 1),
('stm_des_09', 'desires', 'The Slow Undressing Gaze', 'Do you crave having clothes peeled off slowly with unbroken eye contact, or urgent, breathless passion?', 'Cast your vote: slow cinematic smolder vs frantic midnight heat.', 'Demonstrate the tempo you prefer with slow hand movements.', 2, 'both', 1),
('stm_des_10', 'desires', 'The Ear Nibble Preference', 'Gentle breath on the earlobe vs soft nibble: what triggers the biggest shockwave through you?', 'Admit which sensation creates the fastest butterflies.', 'Deliver the gentle breath or soft nibble on their earlobe.', 2, 'both', 1),
('stm_des_11', 'desires', 'The Midnight Craving', 'When you crave me most, is it emotional closeness, playful banter, or heated physical passion?', 'Rank the three in order of your strongest midnight cravings.', 'Share your ranking with full honesty.', 1, 'both', 0),
('stm_des_12', 'desires', 'The Secret Nickname', 'What provocative or possessive nickname do you secretly want me to use behind closed doors?', 'Confess the spicy nickname in chat.', 'Whisper the nickname directly to them.', 2, 'both', 1),

-- ── 5. BOLD DILEMMAS (12 cards) ──────────────────────────────────────────────
('stm_dlm_01', 'dilemmas', 'Handcuffs vs Blindfold', 'Would you rather be handcuffed for 10 minutes with zero control, or blindfolded for 15 minutes not knowing where kisses land?', 'Vote and explain your reasoning in detail over voice note.', 'Test your chosen dilemma right now for 30 seconds.', 3, 'both', 1),
('stm_dlm_02', 'dilemmas', 'Spicy Voice Note vs Midnight Silhouette', 'Would you rather receive a 60-second breathless audio fantasy, or a sultry clothed shadow-silhouette photo?', 'Pick which sensory tease tortures you more sweetly.', 'Deliver the audio note or strike the silhouette pose.', 2, 'apart', 1),
('stm_dlm_03', 'dilemmas', 'Begging vs Commanding', 'Would you rather have me beg you sweetly for a kiss, or have me order you to come take it?', 'Confess which dynamic makes your pulse race faster.', 'Demonstrate both and let your partner choose which worked better.', 2, 'both', 1),
('stm_dlm_04', 'dilemmas', 'Slow Seduction vs Spontaneous Ambush', 'Would you rather have a 2-hour candlelit buildup with slow massages, or an unexpected breathless reunion against the front door?', 'State which fantasy wins your vote tonight.', 'Tell them how you plan to greet them at the door.', 2, 'both', 1),
('stm_dlm_05', 'dilemmas', 'Whisper Everything vs Complete Silence', 'Would you rather have me narrate every single touch in dirty detail, or complete unbroken breathless silence with only heavy breathing?', 'Pick which auditory experience stirs your imagination more.', 'Try 30 seconds of your preferred style right now.', 3, 'both', 1),
('stm_dlm_06', 'dilemmas', 'Ice Cube vs Warm Candle Wax', 'Temperature play dilemma: would you rather have a melting ice cube traced on your stomach, or soothing warm massage oil dripped on your back?', 'Pick cold chill vs soothing warmth.', 'Apply an ice cube or warm hands to test the feeling.', 2, 'both', 1),
('stm_dlm_07', 'dilemmas', 'Caught in Public vs Private Isolation', 'Would you rather steal a sneaky make-out session in an elevator, or have an entire weekend trapped in an off-grid cabin?', 'Vote for the thrill of discovery vs uninterrupted intimacy.', 'Plan the logistics for your favorite option.', 1, 'both', 1),
('stm_dlm_08', 'dilemmas', 'Lingerie Surprise vs Naked Vulnerability', 'Would you rather have your partner wear an elaborate sexy outfit, or have zero accessories and total raw vulnerability?', 'Share which visual aesthetic captivates you more.', 'Share your compliment on their natural beauty.', 2, 'both', 1),
('stm_dlm_09', 'dilemmas', 'Feather Tickle vs Hair Pull', 'Would you rather have feather-light tickling along your spine, or a gentle, firm grip on your hair tilting your head back for a kiss?', 'Confess which physical contrast drives you wilder.', 'Demonstrate the hair tilt or spine trace gently.', 3, 'both', 1),
('stm_dlm_10', 'dilemmas', 'The Midnight Video Call vs The Next Morning Note', 'On a lonely night apart, would you rather stay up on call until 2 AM whispering fantasies, or wake up to an unexpected 3-paragraph spicy text?', 'Cast your vote for sleep deprivation vs morning anticipation.', 'Send that spicy text or make the call tonight.', 1, 'both', 1),
('stm_dlm_11', 'dilemmas', 'Power Exchange: 1 Day Ruler', 'If one of us gets absolute veto power over all couple decisions for 24 hours, do you want that power, or do you want to be pampered/ordered around?', 'Confess if being commanded for a day sounds relieving or terrifying.', 'Declare what your first order as monarch would be.', 1, 'both', 0),
('stm_dlm_12', 'dilemmas', 'The Fast Reunion vs The Lingering Tease', 'When we reunite after distance: immediate passionate connection in the first 10 minutes, or a torturous 4-hour delay where touching is forbidden until dinner ends?', 'Choose immediate gratification vs sweet agony of anticipation.', 'Decide the rules for your upcoming reunion.', 2, 'both', 1),

-- ── 6. SPICY TEASES & CHALLENGES (12 cards) ──────────────────────────────────
('stm_tes_01', 'teases', 'The 20-Second Sultry Command', 'Look into the camera or your partner''s eyes and issue one clear, intoxicating command for our next reunion.', 'Send a 10-second commanding audio clip.', 'Hold direct eye contact and state your command with absolute confidence.', 2, 'both', 1),
('stm_tes_02', 'teases', 'The Collarbone Breath', 'Deliver slow, warm exhalations against your partner''s collarbone for 15 seconds without speaking.', 'Record a 10-second audio clip of slow, heavy breathing right next to the mic.', 'Rest your chin on their shoulder and exhale warm breaths against their collarbone.', 2, 'both', 1),
('stm_tes_03', 'teases', 'Three Seductive Words', 'Whisper three words that describe what you want to do to your partner next time you are alone.', 'Send the three words in a voice note.', 'Whisper the three words directly into their ear.', 2, 'both', 1),
('stm_tes_04', 'teases', 'Smolder & Seduce', 'Lock eyes and deliver an intense, smoldering gaze for 15 unbroken seconds without smiling or blinking.', 'Look directly into the front camera lens and hold the smolder.', 'Lock eyes across the room and hold the intense connection.', 1, 'both', 0),
('stm_tes_05', 'teases', 'The Scent Inhale', 'Breathe in your partner''s neck deeply for 10 seconds, then declare what feeling it evokes.', 'Describe the memory of their signature scent.', 'Lean into their neck and take a deep, slow breath.', 1, 'both', 0),
('stm_tes_06', 'teases', 'The Trace of Anticipation', 'Slowly trace one finger from your partner''s palm all the way up their arm to their shoulder.', 'Trace your own arm on video to demonstrate the path.', 'Trace your finger slowly up their bare arm with delicate pressure.', 2, 'both', 1),
('stm_tes_07', 'teases', 'The Lip Bite Challenge', 'Give your partner your most teasing lip bite and sultry smile.', 'Send a quick 4-second clip flashing your signature look.', 'Hold their gaze and flash the tease across the table.', 1, 'both', 0),
('stm_tes_08', 'teases', 'The French Accent Whispers', 'Describe a romantic midnight date using an exaggerated French or British accent.', 'Send a 10-second dramatic voice memo.', 'Whisper the accent right into their ear while holding their hand.', 1, 'both', 0),
('stm_tes_09', 'teases', 'The Butterfly Kiss', 'Flutter your eyelashes against their cheek or collarbone until they giggle from the tickle.', 'Send a fluttering eyelash selfie.', 'Flutter your eyelashes gently against their cheek.', 1, 'both', 0),
('stm_tes_10', 'teases', 'The Restrained Kiss Tease', 'Lean within half an inch of their lips, hover there for 10 seconds breathing their air, then pull away without kissing.', 'Blow a kiss right at the camera lens from half an inch away.', 'Hover your lips a breath away from theirs for 10 agonizing seconds, then pull back.', 3, 'both', 1),
('stm_tes_11', 'teases', 'The Hip Sway Tease', 'Stand up and deliver a 10-second slow, sensual hip sway to an imaginary rhythm.', 'Send a 10-second clothed sway clip or perform on call.', 'Step back and sway with confident smile while locking eyes.', 2, 'both', 1),
('stm_tes_12', 'teases', 'The Secret Compliment', 'Name the single most attractive physical feature on their body and describe why it drives you crazy.', 'Send a heartfelt audio note praising their feature.', 'Place your hand on or near that feature and share your praise.', 2, 'both', 1);