diff options
| -rw-r--r-- | internal/db/meta.go | 16 |
1 files changed, 16 insertions, 0 deletions
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 |