root
7ff2dbb139
Build & Deploy / Build & Push Docker Image (push) Successful in 2m55s
Test / Type Check (all packages) (push) Successful in 54s
Build & Deploy / Deploy to VPS (push) Successful in 4s
Test / API Unit Tests (push) Failing after 48s
Test / Homepage Unit Tests (push) Successful in 43s
Test / Storefront Unit Tests (push) Failing after 40s
Test / Admin Unit Tests (push) Successful in 40s
Test / Dashboard Unit Tests (push) Failing after 42s
Test / API Integration Tests (push) Successful in 1m0s
10 lines
598 B
SQL
10 lines
598 B
SQL
-- Add reviewToken to reservations for secure one-time review links
|
|
ALTER TABLE "reservations" ADD COLUMN "reviewToken" TEXT;
|
|
CREATE UNIQUE INDEX "reservations_reviewToken_key" ON "reservations"("reviewToken");
|
|
|
|
-- Make renterId optional on reviews (reviews can come from non-Carplace customers via token link)
|
|
ALTER TABLE "reviews" ALTER COLUMN "renterId" DROP NOT NULL;
|
|
ALTER TABLE "reviews" DROP CONSTRAINT IF EXISTS "reviews_renterId_fkey";
|
|
ALTER TABLE "reviews" ADD CONSTRAINT "reviews_renterId_fkey"
|
|
FOREIGN KEY ("renterId") REFERENCES "renters"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|