CREATE TYPE "public"."work_type" AS ENUM('기장', '전장', '선실', '배관', '철의');--> statement-breakpoint
CREATE TABLE "item_shipbuilding" (
	"id" serial PRIMARY KEY NOT NULL,
	"item_id" integer NOT NULL,
	"work_type" "work_type" NOT NULL,
	"ship_types" text DEFAULT 'A-MAX' NOT NULL
);
--> statement-breakpoint
ALTER TABLE "users" ADD COLUMN "language" varchar(10) DEFAULT 'en';--> statement-breakpoint
ALTER TABLE "item_shipbuilding" ADD CONSTRAINT "item_shipbuilding_item_id_items_id_fk" FOREIGN KEY ("item_id") REFERENCES "public"."items"("id") ON DELETE cascade ON UPDATE no action;