blob: 46691ab1a347a38e3e00d460d7f76ffe68cce349 (
plain)
1
2
3
|
ALTER TABLE "items" DROP CONSTRAINT "items_item_code_unique";--> statement-breakpoint
ALTER TABLE "items" ALTER COLUMN "item_code" SET NOT NULL;--> statement-breakpoint
ALTER TABLE "items" ADD CONSTRAINT "project_item_unique" UNIQUE("project_no","item_code");
|