diff options
author | Daniel Weipert <git@mail.dweipert.de> | 2024-01-02 20:42:01 +0100 |
---|---|---|
committer | Daniel Weipert <git@mail.dweipert.de> | 2024-01-05 12:33:59 +0100 |
commit | b21316248572cb27ed1f504529ad6680a473022e (patch) | |
tree | f8a2f81258cae3b1d2429fb7df5a3287954b683a /bin/db.php | |
parent | f621d95f89ded05a2e916c5ee363bfe75ea37482 (diff) |
gemini
Diffstat (limited to 'bin/db.php')
-rw-r--r-- | bin/db.php | 17 |
1 files changed, 17 insertions, 0 deletions
@@ -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, |