mirror of
https://github.com/narrrl/narl-workspace.git
synced 2026-11-03 16:41:27 +01:00
nvrl
4002a35305
Single-user diary served as one Rust binary with the Svelte frontend embedded. - axum 0.8 + SQLite (sqlx), migrations run at startup - stateless HMAC session cookie; credentials from .env, compared in constant time - FTS5 full-text search, user input rewritten into quoted prefix terms - media uploads linked to entries by scanning bodies for /api/media/<id>, which scopes share-token media access and entry deletion - unguessable share links (192-bit token) serving a public read-only page - vim keybindings via CodeMirror plus a modal browse layer and : command line; disabled on touch devices
38 lines
1.4 KiB
SQL
38 lines
1.4 KiB
SQL
CREATE TABLE entries (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
title TEXT NOT NULL DEFAULT '',
|
|
body TEXT NOT NULL DEFAULT '',
|
|
created_at INTEGER NOT NULL,
|
|
updated_at INTEGER NOT NULL,
|
|
share_token TEXT UNIQUE
|
|
);
|
|
|
|
CREATE INDEX idx_entries_created_at ON entries (created_at DESC);
|
|
CREATE INDEX idx_entries_share_token ON entries (share_token);
|
|
|
|
CREATE TABLE media (
|
|
id TEXT PRIMARY KEY,
|
|
entry_id INTEGER REFERENCES entries (id) ON DELETE SET NULL,
|
|
filename TEXT NOT NULL,
|
|
mime TEXT NOT NULL,
|
|
size INTEGER NOT NULL,
|
|
created_at INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE INDEX idx_media_entry_id ON media (entry_id);
|
|
|
|
CREATE VIRTUAL TABLE entries_fts USING fts5 (
|
|
title, body, content = 'entries', content_rowid = 'id', tokenize = 'unicode61'
|
|
);
|
|
|
|
CREATE TRIGGER entries_ai AFTER INSERT ON entries BEGIN
|
|
INSERT INTO entries_fts (rowid, title, body) VALUES (new.id, new.title, new.body);
|
|
END;
|
|
CREATE TRIGGER entries_ad AFTER DELETE ON entries BEGIN
|
|
INSERT INTO entries_fts (entries_fts, rowid, title, body) VALUES ('delete', old.id, old.title, old.body);
|
|
END;
|
|
CREATE TRIGGER entries_au AFTER UPDATE ON entries BEGIN
|
|
INSERT INTO entries_fts (entries_fts, rowid, title, body) VALUES ('delete', old.id, old.title, old.body);
|
|
INSERT INTO entries_fts (rowid, title, body) VALUES (new.id, new.title, new.body);
|
|
END;
|