1 files changed, 17 insertions, 0 deletions
diff --git a/bin/db.php b/bin/db.php
index 84cb85c..8047b42 100644
--- a/bin/db.php
+++ b/bin/db.php
@@ -196,6 +196,23 @@ DB::query(<<<SQL
 SQL);
 
 DB::query(<<<SQL
+  create table if not exists "users_gemini" (
+    "id" bigserial primary key,
+
+    "certificate" character varying(255) not null,
+
+    "user_id" bigint not null,
+    constraint "relation_user"
+      foreign key ("user_id") references users("id") on delete cascade,
+
+    "created_at" timestamp(0) not null default current_timestamp,
+    "updated_at" timestamp(0) not null default current_timestamp,
+
+    unique ("certificate")
+  );
+SQL);
+
+DB::query(<<<SQL
   create table if not exists "user_settings" (
     "id" bigserial primary key,