1. Go to supabase.com/dashboard
2. Click "New Project"
3. Fill in:
   • Name: ciaf-lcm-dev (or your preference)
   • Database Password: Strong password (save it!)
   • Region: Choose closest to you
   • Plan: Free (sufficient for development)
4. Wait ~2 minutes for project provisioning

1. In your project dashboard, click Settings → API
2. Copy these values (you'll need them):
   • Project URL: https://xxxxx.supabase.co
   • Anon/Public Key: eyJhbGc...
   • Service Role Key: eyJhbGc... ⚠️ Keep this secret!

In SQL Editor in Supabase dashboard, run each migration file in order:

This creates a complete sample evidence trail to verify everything works.

1. In SQL Editor, create new query
2. Copy all contents from supabase/demo_lifecycle.sql
3. Click Run

1. Go to http://localhost:3000
2. Click Sign Up
3. Enter email and password
4. Check your email for verification link
5. After signing in, add the user to an organization using SQL:

-- First, create a principal for the user
INSERT INTO principals (principal_type, external_id, email, display_name, is_active, is_verified)
VALUES ('user', '<your-supabase-auth-user-id>', 'your@email.com', 'Your Name', true, true);

-- Then add to an organization
INSERT INTO organization_members (organization_id, principal_id, role, is_active)
SELECT 
  (SELECT id FROM organizations WHERE name = 'Demo Organization' LIMIT 1),
  (SELECT id FROM principals WHERE email = 'your@email.com'),
  'owner',
  true;