Public
Script
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
)`,
]);
Val Town is a social website to write and deploy JavaScript.
Build APIs and schedule functions from your browser.
Comments
Nobody has commented on this val yet: be the first!
June 3, 2024