1CREATE TABLE IF NOT EXISTS ssh_keys (
2 id INTEGER PRIMARY KEY,
3 user_id INTEGER NOT NULL REFERENCES users(id),
4 label TEXT NOT NULL DEFAULT '',
5 public_key TEXT NOT NULL UNIQUE,
6 added_at INTEGER NOT NULL
7);
8
9CREATE TABLE IF NOT EXISTS webhooks (
10 id INTEGER PRIMARY KEY,
11 repo_id INTEGER NOT NULL REFERENCES repos(id),
12 url TEXT NOT NULL,
13 secret TEXT NOT NULL,
14 events TEXT NOT NULL DEFAULT 'push',
15 active INTEGER NOT NULL DEFAULT 1,
16 created_at INTEGER NOT NULL
17);
18
19CREATE TABLE IF NOT EXISTS webhook_deliveries (
20 id INTEGER PRIMARY KEY,
21 webhook_id INTEGER NOT NULL REFERENCES webhooks(id),
22 event TEXT NOT NULL,
23 payload TEXT NOT NULL,
24 response_code INTEGER,
25 response_body TEXT,
26 error TEXT,
27 delivered_at INTEGER NOT NULL
28);
29
30CREATE TABLE IF NOT EXISTS invite_tokens (
31 id INTEGER PRIMARY KEY,
32 token TEXT NOT NULL UNIQUE,
33 created_by INTEGER NOT NULL REFERENCES users(id),
34 used_by INTEGER REFERENCES users(id),
35 created_at INTEGER NOT NULL,
36 used_at INTEGER
37);