diff options
Diffstat (limited to 'db/migrations/0176_huge_absorbing_man.sql')
| -rw-r--r-- | db/migrations/0176_huge_absorbing_man.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/db/migrations/0176_huge_absorbing_man.sql b/db/migrations/0176_huge_absorbing_man.sql new file mode 100644 index 00000000..493630af --- /dev/null +++ b/db/migrations/0176_huge_absorbing_man.sql @@ -0,0 +1,4 @@ +ALTER TABLE "vendor_attachment_responses" ADD COLUMN "created_by" integer;--> statement-breakpoint +ALTER TABLE "vendor_attachment_responses" ADD COLUMN "updated_by" integer;--> statement-breakpoint +ALTER TABLE "vendor_attachment_responses" ADD CONSTRAINT "vendor_attachment_responses_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 "vendor_attachment_responses" ADD CONSTRAINT "vendor_attachment_responses_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 |