diff options
Diffstat (limited to 'db/migrations_backup/0065_redundant_sunset_bain.sql')
| -rw-r--r-- | db/migrations_backup/0065_redundant_sunset_bain.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrations_backup/0065_redundant_sunset_bain.sql b/db/migrations_backup/0065_redundant_sunset_bain.sql new file mode 100644 index 00000000..ad2d8ca7 --- /dev/null +++ b/db/migrations_backup/0065_redundant_sunset_bain.sql @@ -0,0 +1,9 @@ +CREATE TABLE "vendor_pq_review_logs" ( + "id" serial PRIMARY KEY NOT NULL, + "vendor_id" integer NOT NULL, + "reviewer_comment" text NOT NULL, + "reviewer_name" text, + "created_at" timestamp DEFAULT now() NOT NULL +); +--> statement-breakpoint +ALTER TABLE "vendor_pq_review_logs" ADD CONSTRAINT "vendor_pq_review_logs_vendor_id_vendors_id_fk" FOREIGN KEY ("vendor_id") REFERENCES "public"."vendors"("id") ON DELETE cascade ON UPDATE no action;
\ No newline at end of file |