nxtgauge-backend-rust/crates/db/migrations/20260814040000_waitlist_signups.up.sql

-- Email capture for the nxtgauge.com coming-soon page's "Notify Me" form
-- (apps/users/src/handlers/waitlist.rs). No user_id/FK - these are
-- anonymous pre-launch signups, not necessarily existing accounts.

BEGIN;

CREATE TABLE IF NOT EXISTS waitlist_signups (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    email VARCHAR(255) UNIQUE NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE INDEX IF NOT EXISTS idx_waitlist_signups_created_at ON waitlist_signups(created_at);

COMMIT;