Repository navigation
Expand file tree
/
Copy pathschema.sql
More file actions
42 lines (39 loc) · 1.51 KB
/
Copy pathschema.sql
File metadata and controls
42 lines (39 loc) · 1.51 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
-- host storage on D1. Never a provider key in plain text.
CREATE TABLE IF NOT EXISTS keys (
hash TEXT PRIMARY KEY, -- SHA-256 of the host key
id TEXT NOT NULL, -- first 12 characters of the hash, shown and used to revoke
login TEXT NOT NULL, -- GitHub login
name TEXT NOT NULL,
hint TEXT NOT NULL DEFAULT '',
created TEXT,
last_used TEXT
);
CREATE INDEX IF NOT EXISTS keys_login ON keys (login);
-- Hosting-provider keys connected in the cabinet, encrypted with PROVIDER_KEYS_SECRET (src/vault.js).
CREATE TABLE IF NOT EXISTS provider_keys (
login TEXT NOT NULL,
provider TEXT NOT NULL,
sealed TEXT NOT NULL, -- base64(iv || AES-GCM ciphertext)
hint TEXT NOT NULL, -- last 4 characters
created TEXT NOT NULL,
PRIMARY KEY (login, provider)
);
-- Pod hosts (fleetd) host started, one row each. The fleetd token is sealed like a provider key.
CREATE TABLE IF NOT EXISTS hosts (
n INTEGER PRIMARY KEY AUTOINCREMENT,
login TEXT NOT NULL,
ref TEXT NOT NULL, -- host_<provider>_<provider id>
provider TEXT NOT NULL,
url TEXT NOT NULL,
sealed_token TEXT NOT NULL,
created TEXT NOT NULL,
removed TEXT
);
CREATE INDEX IF NOT EXISTS hosts_login ON hosts (login, created);
CREATE INDEX IF NOT EXISTS hosts_ref ON hosts (login, ref);
-- The hosting provider a person starts hosts on by default (the picker in the cabinet). Never a key.
CREATE TABLE IF NOT EXISTS prefs (
login TEXT PRIMARY KEY,
default_provider TEXT NOT NULL,
updated TEXT NOT NULL
);