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
import { sqlite } from "https://esm.town/v/std/sqlite?v=6";
await sqlite.batch([
`CREATE TABLE IF NOT EXISTS smallweb_user (
id INTEGER NOT NULL PRIMARY KEY,
name VARCHAR(50) UNIQUE NOT NULL,
email TEXT NOT NULL,
public_id TEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
UNIQUE (email, public_id)
)`,
`DROP TABLE public_key`,
`CREATE TABLE IF NOT EXISTS smallweb_public_key (
id INTEGER NOT NULL PRIMARY KEY,
user_id INTEGER NOT NULL,
public_key VARCHAR(2048) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
UNIQUE (user_id, public_key),
CONSTRAINT user_id_fk
FOREIGN KEY (user_id)
REFERENCES user (id)
ON DELETE CASCADE
ON UPDATE CASCADE
)`,
]);