summaryrefslogtreecommitdiff
path: root/db/migrations_backup/0011_tense_madame_web.sql
blob: 49414174119021bedca52d3f33afe61bf7b87946 (plain)
1
2
3
ALTER TABLE "rfq_items" ALTER COLUMN "quantity" SET DEFAULT 1;--> statement-breakpoint
ALTER TABLE "rfqs" ALTER COLUMN "due_date" SET NOT NULL;--> statement-breakpoint
ALTER TABLE "rfqs" ADD CONSTRAINT "rfqs_created_by_users_id_fk" FOREIGN KEY ("created_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;