Skip to content

Instantly share code, notes, and snippets.

@SeanG918
SeanG918 / 0002_seed_roster_v2.sql
Created May 14, 2026 10:06
Mohawk seed roster v2 - single block for Supabase
-- Mohawk Tribe Directory - Roster Seed (v2, single-block for Supabase)
-- Run AFTER 0001_initial_schema.sql
-- Everything runs inside one DO block so Supabase can't split it.
do $$
declare
fid uuid;
begin
-- ALHADEFF
@SeanG918
SeanG918 / 0002_seed_roster.sql
Created May 14, 2026 10:02
Mohawk seed roster
-- =============================================================================
-- Mohawk Tribe Directory — Roster Seed
-- Run AFTER 0001_initial_schema.sql
-- Pastes into Supabase SQL editor.
-- Seeds: families + daughters (no auth.users dependency).
-- Profiles (dads) are created when each dad accepts their magic-link invite.
-- =============================================================================
-- Temporary mapping table to track family UUIDs by last name key.
-- Drop it after seeding if you want.