homeio

1CREATE TABLE IF NOT EXISTS "files_google_drive_tokens" (
2  "id" text PRIMARY KEY NOT NULL,
3  "email" text NOT NULL,
4  "display_name" text,
5  "access_token_ciphertext" text NOT NULL,
6  "access_token_iv" text NOT NULL,
7  "access_token_tag" text NOT NULL,
8  "refresh_token_ciphertext" text,
9  "refresh_token_iv" text,
10  "refresh_token_tag" text,
11  "expires_at" timestamp with time zone,
12  "created_at" timestamp with time zone DEFAULT now() NOT NULL,
13  "updated_at" timestamp with time zone DEFAULT now() NOT NULL
14);
15
16CREATE UNIQUE INDEX IF NOT EXISTS "files_google_drive_tokens_email_idx" ON "files_google_drive_tokens" ("email");
17CREATE INDEX IF NOT EXISTS "files_google_drive_tokens_created_at_idx" ON "files_google_drive_tokens" ("created_at");
18