-- =============================================================================
-- Twosome – database/seed_flirt_wars.sql
-- 60 Original Cards for Flirt Wars: Card Battler
-- Deck Themes: 'smooth_talker', 'sweet_savage', 'chaos_agent', 'neutral'
-- Types: 'attack', 'counter', 'wild'
-- =============================================================================

SET NAMES utf8mb4;

DELETE FROM flirt_wars_cards;

-- ── 1. ATTACK CARDS (26 Cards) ───────────────────────────────────────────────
INSERT INTO flirt_wars_cards (code, name, type, deck_theme, blush_val, energy_cost, flavor_text, art_icon, effect_description, mode) VALUES
('wink', 'Wink', 'attack', 'smooth_talker', 8, 1, 'A single playful wink across the room.', '😉', 'Add +8 Blush to opponent.', 'both'),
('pickup_line', 'Pickup Line', 'attack', 'smooth_talker', 12, 2, 'Are you French? Because Eiffel for you.', '💬', 'Add +12 Blush to opponent.', 'both'),
('slow_burn', 'Slow Burn', 'attack', 'smooth_talker', 10, 2, 'A lingering look that simmers until morning.', '🔥', 'Add +10 Blush now, +5 next round.', 'both'),
('dramatic_sigh', 'Dramatic Sigh', 'attack', 'chaos_agent', 6, 1, 'Why do you have to be this ridiculously attractive?', '😮‍💨', 'Add +6 Blush to both players.', 'both'),
('compliment_storm', 'Compliment Storm', 'attack', 'sweet_savage', 15, 2, 'Listing 10 reasons your laugh is irresistible.', '⛈️', 'Add +15 Blush to opponent; discard 1 card.', 'both'),
('blush_attack', 'Blush Attack', 'attack', 'sweet_savage', 20, 3, 'Full-on unapologetic bold flirtation.', '💥', 'Add +20 Blush. If countered/blocked, takes +20 Blush yourself!', 'both'),
('eye_contact', 'Eye Contact', 'attack', 'smooth_talker', 9, 1, 'Holding your gaze three seconds longer than usual.', '👀', 'Add +9 Blush to opponent.', 'both'),
('cheeky_smirk', 'Cheeky Smirk', 'attack', 'smooth_talker', 11, 2, 'That knowing smile that melts all defenses.', '😏', 'Add +11 Blush to opponent.', 'both'),
('flirty_whisper', 'Flirty Whisper', 'attack', 'smooth_talker', 14, 2, 'Whispering something softly right by your ear.', '🤫', 'Add +14 Blush to opponent.', 'both'),
('lip_bite', 'Lip Bite', 'attack', 'sweet_savage', 16, 3, 'A tiny bite of the lower lip that speaks volumes.', '🫦', 'Add +16 Blush to opponent.', 'both'),
('french_accent', 'French Accent', 'attack', 'smooth_talker', 13, 2, 'Whispering mundane words like they are sweet poetry.', '🥐', 'Add +13 Blush to opponent.', 'both'),
('late_night_text', 'Late Night Text', 'attack', 'smooth_talker', 12, 2, 'That 1:17 AM "Thinking of you" ping.', '📱', 'Add +12 Blush to opponent.', 'apart'),
('accidental_touch', 'Accidental Touch', 'attack', 'smooth_talker', 10, 1, 'Brushing hands while reaching for the same cup.', '🤝', 'Add +10 Blush to opponent.', 'both'),
('scent_memory', 'Scent Memory', 'attack', 'smooth_talker', 11, 2, 'Smelling your hoodie and immediately missing you.', '🌸', 'Add +11 Blush to opponent.', 'apart'),
('puppy_dog_eyes', 'Puppy Dog Eyes', 'attack', 'smooth_talker', 8, 1, 'Nobody in history has ever said no to that face.', '🥺', 'Add +8 Blush to opponent.', 'both'),
('velvet_voice', 'Velvet Voice', 'attack', 'smooth_talker', 14, 2, 'Deep radio-host tone reading a grocery list.', '🎙️', 'Add +14 Blush to opponent.', 'both'),
('heart_flutter', 'Heart Flutter', 'attack', 'smooth_talker', 9, 1, 'A sudden warm flutter right behind the ribs.', '💓', 'Add +9 Blush to opponent.', 'both'),
('neck_peck', 'Neck Peck', 'attack', 'sweet_savage', 17, 3, 'A warm gentle kiss right below the jawline.', '💋', 'Add +17 Blush to opponent.', 'together'),
('sweet_nickname', 'Sweet Nickname', 'attack', 'smooth_talker', 7, 1, 'Using that private pet name only you two know.', '🍯', 'Add +7 Blush to opponent.', 'both'),
('reunion_anticipation', 'Reunion Anticipation', 'attack', 'smooth_talker', 13, 2, 'Counting the hours until the next airport hug.', '✈️', 'Add +13 Blush to opponent.', 'apart'),
('hair_tuck', 'Hair Tuck', 'attack', 'smooth_talker', 10, 1, 'Gently tucking a loose stray strand behind your ear.', '💇', 'Add +10 Blush to opponent.', 'both'),
('bedhead_charm', 'Bedhead Charm', 'attack', 'smooth_talker', 8, 1, 'Messy morning hair that looks criminally cute.', '🛏️', 'Add +8 Blush to opponent.', 'both'),
('magnetic_pull', 'Magnetic Pull', 'attack', 'sweet_savage', 15, 2, 'An unspoken gravity pulling you two together.', '🧲', 'Add +15 Blush to opponent.', 'both'),
('chuckle_kiss', 'Chuckle Kiss', 'attack', 'sweet_savage', 12, 2, 'Laughing so hard into a kiss that you lose breath.', '😂', 'Add +12 Blush to opponent.', 'both'),
('butterfly_swarm', 'Butterfly Swarm', 'attack', 'sweet_savage', 11, 2, 'A whole hurricane of butterflies in your stomach.', '🦋', 'Add +11 Blush to opponent.', 'both'),
('smolder_stare', 'Smolder Stare', 'attack', 'sweet_savage', 18, 3, 'Full runway-model intensity without saying a word.', '🕶️', 'Add +18 Blush to opponent.', 'both');

-- ── 2. COUNTER CARDS (18 Cards) ──────────────────────────────────────────────
INSERT INTO flirt_wars_cards (code, name, type, deck_theme, blush_val, energy_cost, flavor_text, art_icon, effect_description, mode) VALUES
('block', 'Block', 'counter', 'sweet_savage', 0, 1, 'Holding up a figurative umbrella against the charm.', '🛡️', 'Cancels opponent attack completely (0 blush).', 'both'),
('reverse', 'Reverse', 'counter', 'sweet_savage', 0, 2, 'No, YOU look stunning tonight.', '🔁', 'Reflects opponent attack back onto them!', 'both'),
('deadpan', 'Deadpan', 'counter', 'smooth_talker', 0, 1, 'Maintaining total poker-faced stoicism.', '😐', 'Halves incoming attack blush (rounded up).', 'both'),
('distract', 'Distract', 'counter', 'chaos_agent', 0, 2, 'Look! A cute golden retriever puppy over there!', '🤹', 'Causes opponent attack to misfire entirely.', 'both'),
('poker_face', 'Poker Face', 'counter', 'smooth_talker', 0, 1, 'Zero facial muscles twitching. Ice cold.', '🃏', 'Nullifies up to 10 Blush of incoming attack.', 'both'),
('uno_reverse', 'Uno Reverse', 'counter', 'sweet_savage', 12, 2, 'Right back at you with interest.', '🔄', 'If attacked, opponent takes 12 Blush instead!', 'both'),
('feign_innocence', 'Feign Innocence', 'counter', 'chaos_agent', 0, 1, 'Who, little old me? I would never.', '😇', 'Reduces attack by 8 and heals 4 Blush.', 'both'),
('topic_change', 'Topic Change', 'counter', 'smooth_talker', 0, 2, 'So... how about that local weather forecast?', '🌦️', 'Cancels attack and discards opponent played card.', 'both'),
('playful_mock', 'Playful Mock', 'counter', 'sweet_savage', 5, 2, 'Nice try Romeo, did you Google that one?', '😜', 'Halves attack; opponent takes +5 Blush.', 'both'),
('shield_of_sarcasm', 'Shield of Sarcasm', 'counter', 'sweet_savage', 0, 2, 'Your smooth line bounced right off my witty retort.', '🤺', 'Cancels attack if blush damage > 10.', 'both'),
('look_away', 'Look Away', 'counter', 'smooth_talker', 0, 1, 'If I don\'t look directly at your smile, I\'m safe.', '🙈', 'Reduces incoming attack damage by 7.', 'both'),
('cool_sip', 'Cool Sip', 'counter', 'smooth_talker', 0, 1, 'Taking a very slow, deliberate sip of iced tea.', '🧃', 'Absorbs up to 12 blush damage.', 'both'),
('straight_face', 'Straight Face', 'counter', 'smooth_talker', 0, 2, 'Solid stone expression hiding internal butterflies.', '🗿', 'Reduces attack by 50% and draws 1 card.', 'both'),
('mirror_shield', 'Mirror Shield', 'counter', 'sweet_savage', 0, 2, 'Bouncing your dazzling charm right back.', '🪞', 'Reflects 50% of incoming attack blush back.', 'both'),
('cough_deflection', 'Cough Deflection', 'counter', 'chaos_agent', 0, 1, 'A theatrical cough to buy five seconds of composure.', '☕', 'Reduces attack by 6 and gains +1 energy next round.', 'both'),
('giggle_burst', 'Giggle Burst', 'counter', 'smooth_talker', 3, 1, 'Bursting out laughing completely diffuses the tension.', '🤭', 'If attack > 10, halves it and opponent takes +3.', 'both'),
('safety_bubble', 'Safety Bubble', 'counter', 'chaos_agent', 0, 2, 'Enclosing your heart in an unbreakable cute bubble.', '🫧', 'Absorbs up to 15 blush damage.', 'both'),
('iron_will', 'Iron Will', 'counter', 'sweet_savage', 0, 2, 'A fortress of supreme emotional composure.', '🏰', 'Complete block against any attack of 15+ blush.', 'both');

-- ── 3. WILD CARDS (16 Cards) ────────────────────────────────────────────────
INSERT INTO flirt_wars_cards (code, name, type, deck_theme, blush_val, energy_cost, flavor_text, art_icon, effect_description, mode) VALUES
('double_or_nothing', 'Double or Nothing', 'wild', 'chaos_agent', 0, 2, 'High stakes romantic gambling.', '🎰', 'If opponent attacked, double their blush! If not, +10 to you.', 'both'),
('truth_bomb', 'Truth Bomb', 'wild', 'chaos_agent', 10, 2, 'Answer truthfully or blush furiously.', '💣', 'Opponent answers flirty question for -10 Blush; skip adds +10!', 'both'),
('dare', 'Dare', 'wild', 'chaos_agent', 10, 2, 'A bold spontaneous romantic challenge.', '🎯', 'Perform a quick flirty dare to add +10 Blush to opponent!', 'both'),
('steamy_confession', 'Steamy Confession', 'wild', 'chaos_agent', 8, 1, 'Admitting a secret romantic daydream.', '💌', 'Both players take +8 Blush; both draw 1 card.', 'both'),
('cupid_arrow', 'Cupid Arrow', 'wild', 'sweet_savage', 14, 3, 'Direct strike right through the defensive armor.', '💘', 'Add +14 Blush to opponent; ignores Block!', 'both'),
('sweet_reversal', 'Sweet Reversal', 'wild', 'chaos_agent', 0, 2, 'Sharing the warmth evenly between both hearts.', '⚖️', 'Trades 10 Blush between both players.', 'both'),
('potion_of_charm', 'Potion of Charm', 'wild', 'chaos_agent', 0, 2, 'Brewed with equal parts honey and mischief.', '🧪', 'Next attack card deals double blush damage!', 'both'),
('compliment_shield', 'Compliment Shield', 'wild', 'smooth_talker', 0, 1, 'Toll bridge payable only in sweet words.', '💐', 'Opponent must send a compliment to attack next round.', 'both'),
('blush_surge', 'Blush Surge', 'wild', 'chaos_agent', 5, 1, 'A tidal wave of romantic energy for both sides.', '🌊', 'Both draw 2 cards and gain +5 Blush.', 'both'),
('secret_admirer', 'Secret Admirer', 'wild', 'smooth_talker', 0, 1, 'Having inside intel on what flirts are coming.', '🕵️', 'Reveals opponent\'s next card before resolution.', 'both'),
('energy_drain', 'Energy Drain', 'wild', 'sweet_savage', 0, 2, 'Leaving them completely speechless and flustered.', '🔋', 'Opponent has -1 energy next round.', 'both'),
('wild_card_shuffle', 'Wild Card Shuffle', 'wild', 'chaos_agent', 0, 2, 'Shuffling the emotional deck entirely.', '🃏', 'Both players discard hands and draw 5 fresh cards.', 'both'),
('midnight_pact', 'Midnight Pact', 'wild', 'chaos_agent', 0, 3, 'A shared vow to fall in love at the same pace.', '🤝', 'Equalizes both blush meters if within 15 points.', 'both'),
('heart_echo', 'Heart Echo', 'wild', 'chaos_agent', 0, 2, 'Echoing back whatever energy was just put out.', '📢', 'Copies the effect of the opponent\'s played card.', 'both'),
('flirt_frenzy', 'Flirt Frenzy', 'wild', 'sweet_savage', 7, 3, 'Unleashing the entire arsenal of charming thoughts.', '🎆', 'Add +7 Blush for each card in your hand.', 'both'),
('grand_finale', 'Grand Finale', 'wild', 'sweet_savage', 25, 3, 'Going all-in for the ultimate heart-melting knockout.', '👑', 'Add +25 Blush to opponent; self-takes +10 Blush.', 'both');