diff options
Diffstat (limited to 'db/migrations/0304_faulty_wrecking_crew.sql')
| -rw-r--r-- | db/migrations/0304_faulty_wrecking_crew.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/db/migrations/0304_faulty_wrecking_crew.sql b/db/migrations/0304_faulty_wrecking_crew.sql new file mode 100644 index 00000000..c5b10720 --- /dev/null +++ b/db/migrations/0304_faulty_wrecking_crew.sql @@ -0,0 +1,24 @@ +ALTER TABLE "contracts" ADD COLUMN "shippment_place" varchar(255);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "po_version" integer;--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "purchase_doc_type" varchar(10);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "purchase_org" varchar(10);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "purchase_group" varchar(10);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "exchange_rate" numeric(9, 5);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "po_confirm_status" varchar(10);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "contract_guarantee_code" varchar(2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "defect_guarantee_code" varchar(2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "guarantee_period_code" varchar(2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "advance_payment_yn" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "budget_amount" numeric(17, 2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "budget_currency" varchar(5);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "total_amount_krw" numeric(17, 2);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "electronic_contract_yn" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "electronic_approval_date" date;--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "electronic_approval_time" varchar(6);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "owner_approval_yn" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "planned_in_out_flag" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "settlement_standard" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "weight_settlement_flag" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "price_index_yn" varchar(1);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "written_contract_no" varchar(20);--> statement-breakpoint +ALTER TABLE "contracts" ADD COLUMN "contract_version" integer;
\ No newline at end of file |