1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { sqlite } from "https://esm.town/v/std/sqlite?v=4";
export async function createEmailLogsTable() {
await sqlite.execute(
`
CREATE TABLE IF NOT EXISTS email_logs (
id INTEGER PRIMARY KEY,
subscriber_id INTEGER NOT NULL,
newsletter_id INTEGER NOT NULL,
sent_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (subscriber_id) REFERENCES subscribers (id) ON DELETE CASCADE,
FOREIGN KEY (newsletter_id) REFERENCES newsletters (id) ON DELETE CASCADE
);
`,
);
}
await createEmailLogsTable();