From 660d6e73218229c6ac08ac2b7a19819169529fc8 Mon Sep 17 00:00:00 2001
From: Michael McVady <femtonaut@gmail.com>
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

