internal/store/sql/migrations/0006_create_articles_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 / 0006_create_articles_table_up.sql

at main 18 lines 676 B view raw

 1-- Articles table
 2CREATE TABLE IF NOT EXISTS articles (
 3    id INTEGER PRIMARY KEY AUTOINCREMENT,
 4    url TEXT UNIQUE NOT NULL,
 5    title TEXT NOT NULL,
 6    author TEXT,
 7    date TEXT,
 8    markdown_path TEXT NOT NULL,
 9    html_path TEXT NOT NULL,
10    created DATETIME DEFAULT CURRENT_TIMESTAMP,
11    modified DATETIME DEFAULT CURRENT_TIMESTAMP
12);
13
14CREATE INDEX IF NOT EXISTS idx_articles_url ON articles(url);
15CREATE INDEX IF NOT EXISTS idx_articles_title ON articles(title);
16CREATE INDEX IF NOT EXISTS idx_articles_author ON articles(author);
17CREATE INDEX IF NOT EXISTS idx_articles_date ON articles(date);
18CREATE INDEX IF NOT EXISTS idx_articles_created ON articles(created);