summaryrefslogtreecommitdiff
path: root/db/migrations/0092_wandering_chamber.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations/0092_wandering_chamber.sql')
-rw-r--r--db/migrations/0092_wandering_chamber.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/db/migrations/0092_wandering_chamber.sql b/db/migrations/0092_wandering_chamber.sql
new file mode 100644
index 00000000..830cf78c
--- /dev/null
+++ b/db/migrations/0092_wandering_chamber.sql
@@ -0,0 +1,8 @@
+ALTER TABLE "items" ADD COLUMN "parent_item_code" varchar(18);--> statement-breakpoint
+ALTER TABLE "items" ADD COLUMN "item_level" integer;--> statement-breakpoint
+ALTER TABLE "items" ADD COLUMN "delete_flag" varchar(1);--> statement-breakpoint
+ALTER TABLE "items" ADD COLUMN "unit_of_measure" varchar(3);--> statement-breakpoint
+ALTER TABLE "items" ADD COLUMN "steel_type" varchar(2);--> statement-breakpoint
+ALTER TABLE "items" ADD COLUMN "grade_material" varchar(50);--> statement-breakpoint
+ALTER TABLE "items" ADD COLUMN "change_date" varchar(8);--> statement-breakpoint
+ALTER TABLE "items" ADD COLUMN "base_unit_of_measure" varchar(3); \ No newline at end of file