path: root/db/migrations_backup/0039_elite_zemo.sql

ALTER TABLE "tag_classes" ADD COLUMN "tag_type_code" varchar(50) NOT NULL;--> statement-breakpoint
ALTER TABLE "tag_classes" ADD CONSTRAINT "tag_classes_tag_type_code_tag_subfields_tag_type_code_fk" FOREIGN KEY ("tag_type_code") REFERENCES "public"."tag_subfields"("tag_type_code") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "tag_subfields" ADD CONSTRAINT "tag_subfields_tag_type_code_unique" UNIQUE("tag_type_code");