CREATE DATABASE IF NOT EXISTS clog;

\connect clog

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

CREATE TABLE IF NOT EXISTS entries (
	id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
	-- draft BOOLEAN NOT NULL DEFAULT TRUE,
	title CHARACTER VARYING NOT NULL,
	body CHARACTER VARYING NOT NULL,
	created_at TIMESTAMP NOT NULL DEFAULT NOW(),
	updated_at TIMESTAMP NOT NULL DEFAULT NOW(),
	search_vector TSVECTOR DEFAULT NULL
);

CREATE INDEX entries_search_vector_idx ON entries USING gin(search_vector);