summaryrefslogtreecommitdiff
path: root/db/migrations/0376_keen_daimon_hellstrom.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations/0376_keen_daimon_hellstrom.sql')
-rw-r--r--db/migrations/0376_keen_daimon_hellstrom.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/db/migrations/0376_keen_daimon_hellstrom.sql b/db/migrations/0376_keen_daimon_hellstrom.sql
new file mode 100644
index 00000000..8bdd3b00
--- /dev/null
+++ b/db/migrations/0376_keen_daimon_hellstrom.sql
@@ -0,0 +1,11 @@
+CREATE TABLE "buyer_signatures" (
+ "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "buyer_signatures_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
+ "name" varchar(255) DEFAULT '삼성중공업' NOT NULL,
+ "image_url" text NOT NULL,
+ "data_url" text,
+ "mime_type" varchar(100),
+ "file_size" integer,
+ "is_active" boolean DEFAULT true,
+ "created_at" timestamp DEFAULT now() NOT NULL,
+ "updated_at" timestamp DEFAULT now() NOT NULL
+);