kuber
DTDrizzle Team
•Created by kuber on 2/10/2024 in #help
I am facing this issue- type "time(0)" does not exist. How can I fix this ?
Actually, I've tried this before but this doesn't work
still a big thanks to you
8 replies
DTDrizzle Team
•Created by kuber on 2/10/2024 in #help
I am facing this issue- type "time(0)" does not exist. How can I fix this ?
Here is the SQL statements ->
--> statement-breakpoint
DO $$ BEGIN
ALTER TABLE "booking" ADD CONSTRAINT "booking_userId_user_id_fk" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
ALTER TABLE "booking" ADD CONSTRAINT "booking_turfId_turf_id_fk" FOREIGN KEY ("turfId") REFERENCES "turf"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
ALTER TABLE "account" ADD CONSTRAINT "account_userId_user_id_fk" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
8 replies
DTDrizzle Team
•Created by kuber on 2/10/2024 in #help
I am facing this issue- type "time(0)" does not exist. How can I fix this ?
8 replies
DTDrizzle Team
•Created by kuber on 2/10/2024 in #help
I am facing this issue- type "time(0)" does not exist. How can I fix this ?
8 replies