moonshotai/kimi-k3 · d1_schema · rep 3

env | grep -i supabase | sed 's/\(KEY=\).\{8\}.*/\1<redacted>/; s/\(PASSWORD=\).*/\1<redacted>/; s|\(DB_URL=postgresql://[^:<redacted>@]*@|\1<redacted>@|'

SUPABASE_DB_PASSWORD=<redacted>
SUPABASE_DB_URL=postgresql://postgres.<ref>:<redacted>@aws-0-us-east-1.pooler.supabase.com:5432/postgres
SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_SERVICE_ROLE_KEY=<redacted>
SUPABASE_PROJECT_REF=<ref>
SUPABASE_ANON_KEY=<redacted>

which psql || (apt-get update -qq && apt-get install -y -qq postgresql-client >/dev/null 2>&1; which psql); psql --version 2>/dev/null

/usr/bin/psql
psql (PostgreSQL) 18.4 (Debian 18.4-1.pgdg12+1)

cat > /tmp/schema.sql <<'EOF'
CREATE EXTENSION IF NOT EXISTS pgcrypto;

CREATE TABLE IF NOT EXISTS public.authors (
    id    uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    name  text NOT NULL,
    email text NOT NULL UNIQUE
);

CREATE TABLE IF NOT EXISTS public.courses (
    id          uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    author_id   uuid NOT NULL REFERENCES public.authors(id),
    title       text NOT NULL,
    price_cents integer NOT NULL CHECK (price_cents >= 0),
    published   boolean NOT NULL DEFAULT false,
    created_at  timestamptz NOT NULL DEFAULT now()
);

CREATE TABLE IF NOT EXISTS public.enrollments (
    id            bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    course_id     uuid NOT NULL REFERENCES public.courses(id) ON DELETE CASCADE,
    student_email text NOT NULL,
    enrolled_at   timestamptz NOT NULL DEFAULT now(),
    UNIQUE (course_id, student_email)
);

CREATE INDEX IF NOT EXISTS courses_author_id_idx ON public.courses (author_id);
CREATE INDEX IF NOT EXISTS enrollments_student_email_idx ON public.enrollments (student_email);

-- Make sure PostgREST picks up the new schema
NOTIFY pgrst, 'reload schema';
EOF
psql "$SUPABASE_DB_URL" -v ON_ERROR_STOP=1 -f /tmp/schema.sql

CREATE EXTENSION
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
NOTIFY

psql:/tmp/schema.sql:1: NOTICE:  extension "pgcrypto" already exists, skipping

for t in authors courses enrollments; do
  echo "--- /rest/v1/$t ---"
  curl -sS -w '\nHTTP %{http_code}\n' "$SUPABASE_URL/rest/v1/$t?select=*" \
    -H "apikey: $SUPABASE_ANON_KEY" \
    -H "Authorization: Bearer $SUPABASE_ANON_KEY"
done

--- /rest/v1/authors ---
[]
HTTP 200
--- /rest/v1/courses ---
[]
HTTP 200
--- /rest/v1/enrollments ---
[]
HTTP 200

psql "$SUPABASE_DB_URL" -v ON_ERROR_STOP=1 -c "
SELECT conrelid::regclass AS table_name, conname, pg_get_constraintdef(oid) AS def
FROM pg_constraint
WHERE connamespace = 'public'::regnamespace
  AND conrelid IN ('public.authors'::regclass, 'public.courses'::regclass, 'public.enrollments'::regclass)
ORDER BY conrelid::regclass::text, conname;
" -c "
SELECT indexname, indexdef FROM pg_indexes
WHERE schemaname='public' AND tablename IN ('courses','enrollments') ORDER BY indexname;
"

 table_name  |                 conname                 |                               def                                
-------------+-----------------------------------------+------------------------------------------------------------------
 authors     | authors_email_key                       | UNIQUE (email)
 authors     | authors_pkey                            | PRIMARY KEY (id)
 courses     | courses_author_id_fkey                  | FOREIGN KEY (author_id) REFERENCES authors(id)
 courses     | courses_pkey                            | PRIMARY KEY (id)
 courses     | courses_price_cents_check               | CHECK ((price_cents >= 0))
 enrollments | enrollments_course_id_fkey              | FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE
 enrollments | enrollments_course_id_student_email_key | UNIQUE (course_id, student_email)
 enrollments | enrollments_pkey                        | PRIMARY KEY (id)
(8 rows)

                indexname                |                                                         indexdef                                                         
-----------------------------------------+--------------------------------------------------------------------------------------------------------------------------
 courses_author_id_idx                   | CREATE INDEX courses_author_id_idx ON public.courses USING btree (author_id)
 courses_pkey                            | CREATE UNIQUE INDEX courses_pkey ON public.courses USING btree (id)
 enrollments_course_id_student_email_key | CREATE UNIQUE INDEX enrollments_course_id_student_email_key ON public.enrollments USING btree (course_id, student_email)
 enrollments_pkey                        | CREATE UNIQUE INDEX enrollments_pkey ON public.enrollments USING btree (id)
 enrollments_student_email_idx           | CREATE INDEX enrollments_student_email_idx ON public.enrollments USING btree (student_email)
(5 rows)