Leonardo Devai
199d778cb8
published_at is now the first-publish time (null for drafts, kept across edits
and unpublish/republish), slugs collide to -2/-3 and regenerate on retitle,
every error is {"error"} with 400/401/403/404/405/409 pinned, timestamps are
RFC 3339 UTC. GUIDELINES pins the contract; each backend passes the same 59-check
end-to-end script.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01128fhuZbgivaSJvtMf4s1G
25 lines
1.1 KiB
SQL
25 lines
1.1 KiB
SQL
-- Applied on every startup, so every statement is idempotent.
|
|
|
|
CREATE TABLE IF NOT EXISTS users (
|
|
id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
|
|
email text NOT NULL UNIQUE,
|
|
password_hash text NOT NULL,
|
|
created_at timestamptz NOT NULL DEFAULT now()
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS posts (
|
|
id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
|
|
title text NOT NULL,
|
|
slug text NOT NULL UNIQUE,
|
|
body text NOT NULL DEFAULT '',
|
|
published boolean NOT NULL DEFAULT false,
|
|
author_id bigint NOT NULL REFERENCES users (id) ON DELETE CASCADE,
|
|
created_at timestamptz NOT NULL DEFAULT now(),
|
|
updated_at timestamptz NOT NULL DEFAULT now()
|
|
);
|
|
|
|
-- When the post was first published, null while a draft. ADD COLUMN IF NOT
|
|
-- EXISTS also upgrades databases created before the column existed.
|
|
ALTER TABLE posts ADD COLUMN IF NOT EXISTS published_at timestamptz;
|
|
|
|
CREATE INDEX IF NOT EXISTS posts_published_at_idx ON posts (published, published_at DESC);
|