CREATE DATABASE clog;

\connect clog

CREATE TABLE posts (
    id BIGINT NOT NULL, -- PRIMARY KEY UUID
    title CHARACTER VARYING NOT NULL,
    body CHARACTER VARYING NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);

INSERT INTO posts (
    id,
    title,
    body
)
VALUES
(
    1,
    'First Post',
    '# Heading

Content

## Sub heading

More content ...'
),
(
    2,
    'Second Post',
    'Testing [a link](https://bunkergate.org)'
),
(
    3,
    'xxx',
    '**testing bold**'
);

