internal/store/sql/migrations/0010_create_documents_table_up.sql at main · desertthunder.dev/noteleaf

cli + tui to publish to leaflet (wip) & manage tasks, notes & watch/read lists 🍃

charm leaflet readability golang

noteleaf / internal / store / sql / migrations / 0010_create_documents_table_up.sql

at main 10 lines 350 B view raw

 1CREATE TABLE IF NOT EXISTS documents (
 2    id INTEGER PRIMARY KEY AUTOINCREMENT,
 3    title TEXT NOT NULL,
 4    body TEXT NOT NULL,
 5    created_at DATETIME NOT NULL,
 6    doc_kind INTEGER NOT NULL
 7);
 8
 9CREATE INDEX IF NOT EXISTS idx_documents_doc_kind ON documents(doc_kind);
10CREATE INDEX IF NOT EXISTS idx_documents_created_at ON documents(created_at);