ogrechkoandClaude Sonnet 5
130c5382cd
Multi-page public site (Next.js), Node/Express backend with Postgres, and Vite admin/account app, restructured from a single-page layout into dedicated service, promotions, cases, about, FAQ, and blog pages for SEO. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_013otXCiTZsxdZ4SJKZ9wUky
14 lines
427 B
SQL
14 lines
427 B
SQL
CREATE TABLE IF NOT EXISTS blog_posts (
|
|
id SERIAL PRIMARY KEY,
|
|
slug TEXT UNIQUE NOT NULL,
|
|
title TEXT NOT NULL,
|
|
excerpt TEXT DEFAULT '',
|
|
content TEXT NOT NULL DEFAULT '',
|
|
published BOOLEAN NOT NULL DEFAULT false,
|
|
published_at TIMESTAMPTZ,
|
|
created_at TIMESTAMPTZ DEFAULT now(),
|
|
updated_at TIMESTAMPTZ DEFAULT now()
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_blog_posts_published ON blog_posts(published, published_at);
|