diff options
Diffstat (limited to 'db/migrations/0052_uneven_falcon.sql')
| -rw-r--r-- | db/migrations/0052_uneven_falcon.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/db/migrations/0052_uneven_falcon.sql b/db/migrations/0052_uneven_falcon.sql new file mode 100644 index 00000000..eb2b1ba3 --- /dev/null +++ b/db/migrations/0052_uneven_falcon.sql @@ -0,0 +1,3 @@ +DROP VIEW "public"."pr_items_view";--> statement-breakpoint +ALTER TABLE "pr_items" ADD COLUMN "gross_weight" numeric(12, 2) DEFAULT 1;--> statement-breakpoint +CREATE VIEW "public"."pr_items_view" AS (select "pr_items"."id", "pr_items"."procurement_rfqs_id", "pr_items"."rfq_item", "pr_items"."pr_item", "pr_items"."item_id", "pr_items"."material_code", "pr_items"."material_category", "pr_items"."acc", "pr_items"."material_description", "pr_items"."size", "pr_items"."delivery_date", "pr_items"."quantity", "pr_items"."uom", "pr_items"."gross_weight", "pr_items"."gw_uom", "pr_items"."spec_no", "pr_items"."spec_url", "pr_items"."tracking_no", "pr_items"."major_yn", "pr_items"."project_def", "pr_items"."prject_sc", "pr_items"."prject_kl", "pr_items"."prject_lc", "pr_items"."prject_dl", "pr_items"."remark", "procurement_rfqs"."rfq_code", "items"."item_code", "items"."item_name" from "pr_items" left join "procurement_rfqs" on "pr_items"."procurement_rfqs_id" = "procurement_rfqs"."id" left join "items" on "pr_items"."item_id" = "items"."id");
\ No newline at end of file |