Database Migration

When creating a migration:

1. Ask for migration description:

   • Prompt user for migration name in snake_case
   • Examples: "add_job_bookmarks", "update_profiles_schema", "add_email_templates"

2. Generate timestamped filename:

   • Format: YYYYMMDDHHMMSS_description.sql
   • Use current date/time
   • Example: 20260204120000_add_job_bookmarks.sql

3. Create file in packages/database/supabase/migrations/ with this template:

-- ====================================================================
-- [Migration Title]
-- Version: 1.0
-- Description: [Brief description of what this migration does]
-- ====================================================================

BEGIN;

-- ====================================================================
-- SECTION 1: [e.g., Create Tables]
-- ====================================================================

-- Add your DDL here


-- ====================================================================
-- SECTION 2: [e.g., Create Indexes]
-- ====================================================================

-- Add indexes for performance


-- ====================================================================
-- SECTION 3: [e.g., Row Level Security Policies]
-- ====================================================================

-- Enable RLS
-- ALTER TABLE [table_name] ENABLE ROW LEVEL SECURITY;

-- Add RLS policies


-- ====================================================================
-- SECTION 4: [e.g., Triggers/Functions]
-- ====================================================================

-- Add triggers or functions if needed


COMMIT;