blob: db2b860f70abc6d9a8211a88dec71b0176387cf9 (
plain)
1
2
3
4
5
6
7
8
9
10
|
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;
|
