diff options
Diffstat (limited to 'db/migrations/0175_slippery_morph.sql')
| -rw-r--r-- | db/migrations/0175_slippery_morph.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/db/migrations/0175_slippery_morph.sql b/db/migrations/0175_slippery_morph.sql new file mode 100644 index 00000000..8143708b --- /dev/null +++ b/db/migrations/0175_slippery_morph.sql @@ -0,0 +1,4 @@ +ALTER TABLE "reg_eval_criteria" ADD COLUMN "created_by" integer NOT NULL;--> statement-breakpoint +ALTER TABLE "reg_eval_criteria" ADD COLUMN "updated_by" integer NOT NULL;--> statement-breakpoint +ALTER TABLE "reg_eval_criteria" ADD CONSTRAINT "reg_eval_criteria_created_by_users_id_fk" FOREIGN KEY ("created_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint +ALTER TABLE "reg_eval_criteria" ADD CONSTRAINT "reg_eval_criteria_updated_by_users_id_fk" FOREIGN KEY ("updated_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;
\ No newline at end of file |