📊 SQL Migrations Dashboard

-- ═══════════════════════════════════════════════════════════════
-- Happy Hour Heroes - Character Favorites System
-- Migration 03: character_favorites table
-- Created: 2025-02-25
-- ═══════════════════════════════════════════════════════════════

-- Create character_favorites table
CREATE TABLE IF NOT EXISTS character_favorites (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  character_id UUID NOT NULL REFERENCES hhh_characters(id) ON DELETE CASCADE,

-- Bailey Health Tables Migration
-- Run this in the Supabase SQL editor: https://supabase.com/dashboard/project/kxqrsdicrayblwpczxsy/editor

CREATE TABLE IF NOT EXISTS bailey_vet_records (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  date DATE NOT NULL,
  type TEXT NOT NULL DEFAULT 'visit' CHECK (type IN ('vaccine', 'visit', 'surgery', 'medication', 'lab_work', 'other')),
  title TEXT NOT NULL,
  description TEXT,

-- WealthOS Transactions Table Migration
-- Run this in the Supabase SQL Editor

CREATE TABLE IF NOT EXISTS wealth_transactions (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  user_id UUID REFERENCES auth.users(id),
  date DATE NOT NULL,
  amount DECIMAL(10,2) NOT NULL,
  category TEXT NOT NULL,