blob: ccf685acf8b2a03cbedbf1c57d9423a40ff0ef31 (
plain)
1
2
3
4
5
|
CREATE TYPE "public"."score_type" AS ENUM('fixed', 'variable');--> statement-breakpoint
ALTER TABLE "reg_eval_criteria" ADD COLUMN "variable_score_min " numeric(5, 2);--> statement-breakpoint
ALTER TABLE "reg_eval_criteria" ADD COLUMN "variable_score_max " numeric(5, 2);--> statement-breakpoint
ALTER TABLE "reg_eval_criteria" ADD COLUMN "variable_score_unit " varchar(100);--> statement-breakpoint
ALTER TABLE "reg_eval_criteria" ADD COLUMN "score_type" "score_type" DEFAULT 'fixed' NOT NULL;
|
