broad-announce/migrations/seed.sql

-- seed.sql
-- M1 minimum seed: one company, one individual, one FCM token.
-- Idempotent (uses ON CONFLICT DO NOTHING). Safe to re-run.

INSERT INTO companies (id, name) VALUES
    ('acme-001', 'Acme Corp')
ON CONFLICT (id) DO NOTHING;

INSERT INTO individuals (id, company_id, full_name, email, locale) VALUES
    ('ind-acme-001', 'acme-001', 'Alice Operator', 'alice@acme.example', 'en')
ON CONFLICT (id) DO NOTHING;

INSERT INTO fcm_tokens (individual_id, token, device_id, locale, app_version) VALUES
    ('ind-acme-001', 'fake-fcm-token-acme-alice-001', 'pixel-7-alice', 'en', '1.0.0')
ON CONFLICT (token) DO NOTHING;