deepseek/deepseek-v4-pro · d1_schema · rep 3

echo "URL: $SUPABASE_URL" && echo "REF: $SUPABASE_PROJECT_REF" && echo "DB URL present: $( [ -n "$SUPABASE_DB_URL" ] && echo yes || echo no )"

URL: https://<ref>.supabase.co
REF: <ref>
DB URL present: yes

psql "$SUPABASE_DB_URL" <<'SQL'
-- 1) authors
CREATE TABLE IF NOT EXISTS public.authors (
    id      uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    name    text NOT NULL,
    email   text NOT NULL UNIQUE
);

-- 2) courses
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()
);

-- 3) enrollments
CREATE TABLE IF NOT EXISTS public.enrollments (
    id            bigint GENERATED BY DEFAULT 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)
);

-- Indexes
CREATE INDEX IF NOT EXISTS idx_courses_author_id ON public.courses(author_id);
CREATE INDEX IF NOT EXISTS idx_enrollments_student_email ON public.enrollments(student_email);
SQL

CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX

curl -s -o /dev/null -w "%{http_code}" "$SUPABASE_URL/rest/v1/courses" -H "apikey: $SUPABASE_ANON_KEY" -H "Authorization: Bearer $SUPABASE_ANON_KEY"

200

for t in authors courses enrollments; do echo -n "$t: "; curl -s -o /dev/null -w "%{http_code}" "$SUPABASE_URL/rest/v1/$t" -H "apikey: $SUPABASE_ANON_KEY" -H "Authorization: Bearer $SUPABASE_ANON_KEY"; echo; done

authors: 200
courses: 200
enrollments: 200