xiaomi/mimo-v2.5 · d1_schema · rep 1

echo "SUPABASE_URL: $SUPABASE_URL"
echo "SUPABASE_PROJECT_REF: $SUPABASE_PROJECT_REF"
echo "SUPABASE_DB_URL: $SUPABASE_DB_URL"
echo "SUPABASE_ANON_KEY: ${SUPABASE_ANON_KEY:0:20}..."
echo "SUPABASE_SERVICE_ROLE_KEY: ${SUPABASE_SERVICE_ROLE_KEY:0:20}..."
echo "SUPABASE_DB_PASSWORD: ${SUPABASE_DB_PASSWORD:0:5}..."

SUPABASE_URL: https://<ref>.supabase.co
SUPABASE_PROJECT_REF: <ref>
SUPABASE_DB_URL: <redacted:SUPABASE_DB_URL>
SUPABASE_ANON_KEY: eyJhbGciOiJIUzI1NiIs...
SUPABASE_SERVICE_ROLE_KEY: eyJhbGciOiJIUzI1NiIs...
SUPABASE_DB_PASSWORD: 1a9f7...

cat << 'SQL' > /tmp/schema.sql
-- Enable required extensions if needed
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

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

-- 2) courses
CREATE TABLE IF NOT EXISTS public.courses (
  id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
  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 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)
);

-- 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

echo "SQL file created"
cat /tmp/schema.sql

SQL file created
-- Enable required extensions if needed
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

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

-- 2) courses
CREATE TABLE IF NOT EXISTS public.courses (
  id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
  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 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)
);

-- 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);

psql "$SUPABASE_DB_URL" -f /tmp/schema.sql 2>&1

psql:/tmp/schema.sql:2: NOTICE:  extension "uuid-ossp" already exists, skipping
CREATE EXTENSION
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX

cat << 'SQL' > /tmp/grants.sql
-- Grant usage on the public schema
GRANT USAGE ON SCHEMA public TO anon, authenticated, service_role;

-- Grant permissions on the new tables
GRANT SELECT, INSERT, UPDATE, DELETE ON public.authors TO anon, authenticated, service_role;
GRANT SELECT, INSERT, UPDATE, DELETE ON public.courses TO anon, authenticated, service_role;
GRANT SELECT, INSERT, UPDATE, DELETE ON public.enrollments TO anon, authenticated, service_role;

-- Grant usage on sequences (for enrollments identity column)
GRANT USAGE ON ALL SEQUENCES IN SCHEMA public TO anon, authenticated, service_role;

-- Allow PostgREST to see these tables (add to default role grants)
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO anon;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO authenticated;
SQL

psql "$SUPABASE_DB_URL" -f /tmp/grants.sql 2>&1

GRANT
GRANT
GRANT
GRANT
GRANT
ALTER DEFAULT PRIVILEGES
ALTER DEFAULT PRIVILEGES

# Test the REST API endpoint
curl -s -w "\nHTTP_STATUS: %{http_code}\n" \
  "$SUPABASE_URL/rest/v1/courses?select=*" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY"

[]
HTTP_STATUS: 200

# Verify all three endpoints
echo "=== authors ==="
curl -s -w "\nHTTP_STATUS: %{http_code}\n" \
  "$SUPABASE_URL/rest/v1/authors?select=*" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY"

echo ""
echo "=== enrollments ==="
curl -s -w "\nHTTP_STATUS: %{http_code}\n" \
  "$SUPABASE_URL/rest/v1/enrollments?select=*" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY"

=== authors ===
[]
HTTP_STATUS: 200

=== enrollments ===
[]
HTTP_STATUS: 200

# Quick smoke test: insert an author, course, enrollment, then verify
echo "=== Insert author ==="
curl -s -X POST "$SUPABASE_URL/rest/v1/authors" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY" \
  -H "Content-Type: application/json" \
  -H "Prefer: return=representation" \
  -d '{"name":"Test Author","email":"author@test.com"}'

echo ""
echo "=== Insert course ==="
AUTHOR_ID=$(psql "$SUPABASE_DB_URL" -t -A -c "SELECT id FROM public.authors WHERE email='author@test.com';")
curl -s -X POST "$SUPABASE_URL/rest/v1/courses" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY" \
  -H "Content-Type: application/json" \
  -H "Prefer: return=representation" \
  -d "{\"author_id\":\"$AUTHOR_ID\",\"title\":\"Test Course\",\"price_cents\":1999}"

echo ""
echo "=== Insert enrollment ==="
COURSE_ID=$(psql "$SUPABASE_DB_URL" -t -A -c "SELECT id FROM public.courses LIMIT 1;")
curl -s -X POST "$SUPABASE_URL/rest/v1/enrollments" \
  -H "apikey: $SUPABASE_ANON_KEY" \
  -H "Authorization: Bearer $SUPABASE_ANON_KEY" \
  -H "Content-Type: application/json" \
  -H "Prefer: return=representation" \
  -d "{\"course_id\":\"$COURSE_ID\",\"student_email\":\"student@test.com\"}"

echo ""
echo "=== Cleanup test data ==="
psql "$SUPABASE_DB_URL" -c "DELETE FROM public.enrollments; DELETE FROM public.courses; DELETE FROM public.authors;"

=== Insert author ===
[{"id":"96393f97-1822-4264-909e-ba7b5f6f147f","name":"Test Author","email":"author@test.com"}]
=== Insert course ===
[{"id":"93f342c8-2557-4a23-b8af-35ce237073a8","author_id":"96393f97-1822-4264-909e-ba7b5f6f147f","title":"Test Course","price_cents":1999,"published":false,"created_at":"2026-07-26T03:21:10.596533+00:00"}]
=== Insert enrollment ===
[{"id":1,"course_id":"93f342c8-2557-4a23-b8af-35ce237073a8","student_email":"student@test.com","enrolled_at":"2026-07-26T03:21:11.480813+00:00"}]
=== Cleanup test data ===
DELETE 1
DELETE 1
DELETE 1