14 lines
375 B
SQL
14 lines
375 B
SQL
CREATE TABLE IF NOT EXISTS posts (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
title TEXT NOT NULL,
|
|
slug TEXT NOT NULL UNIQUE,
|
|
excerpt TEXT DEFAULT '',
|
|
content TEXT NOT NULL,
|
|
published INTEGER NOT NULL DEFAULT 1,
|
|
created_at TEXT NOT NULL,
|
|
updated_at TEXT NOT NULL
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_posts_published_updated_at
|
|
ON posts (published, updated_at DESC);
|