From 660d6e73218229c6ac08ac2b7a19819169529fc8 Mon Sep 17 00:00:00 2001 From: Michael McVady Date: Fri, 12 Jan 2024 16:02:15 -0600 Subject: Start implementing search --- db/db.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'db/db.sql') diff --git a/db/db.sql b/db/db.sql index ab0e7fd..5866021 100644 --- a/db/db.sql +++ b/db/db.sql @@ -1,14 +1,17 @@ -CREATE DATABASE clog; +CREATE DATABASE IF NOT EXISTS clog; \connect clog CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; -CREATE TABLE posts ( +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() + updated_at TIMESTAMP NOT NULL DEFAULT NOW(), + search_vector TSVECTOR DEFAULT NULL ); + +CREATE INDEX entries_search_vector_idx ON entries USING gin(search_vector); \ No newline at end of file -- cgit v1.2.3