From 3b3ca0ce18ed13fca9a7f81229ba0b05957afab0 Mon Sep 17 00:00:00 2001 From: ivar Date: Sat, 4 Apr 2026 16:07:08 +0200 Subject: feat: add redirects table to meta.db schema --- internal/db/meta.go | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'internal') diff --git a/internal/db/meta.go b/internal/db/meta.go index dd05764..87d4fbf 100644 --- a/internal/db/meta.go +++ b/internal/db/meta.go @@ -39,6 +39,22 @@ func OpenMeta(path string) (*MetaDB, error) { ); CREATE INDEX IF NOT EXISTS idx_pages_path ON pages(path); CREATE INDEX IF NOT EXISTS idx_pages_date ON pages(date); + CREATE TABLE IF NOT EXISTS posts ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + slug TEXT NOT NULL UNIQUE, + title TEXT NOT NULL DEFAULT '', + date TEXT DEFAULT '', + tags TEXT DEFAULT '[]', + draft INTEGER NOT NULL DEFAULT 0, + blocks TEXT NOT NULL DEFAULT '[]', + updated_at INTEGER NOT NULL DEFAULT (cast(strftime('%s','now') * 1000000 as integer)) + ); + CREATE INDEX IF NOT EXISTS idx_posts_slug ON posts(slug); + CREATE INDEX IF NOT EXISTS idx_posts_date ON posts(date); + CREATE TABLE IF NOT EXISTS redirects ( + from_slug TEXT PRIMARY KEY, + to_slug TEXT NOT NULL + ); `) if err != nil { return nil, err -- cgit v1.3