From 27e88a9609277e0c76b73b1498d6262927deadf7 Mon Sep 17 00:00:00 2001
From: Michael McVady <femtonaut@gmail.com>
Date: Sat, 8 Jul 2023 13:40:45 -0500
Subject: Update data dump

---
 db/db.sql | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

(limited to 'db/db.sql')

diff --git a/db/db.sql b/db/db.sql
index 421176f..ab0e7fd 100644
--- a/db/db.sql
+++ b/db/db.sql
@@ -5,9 +5,10 @@ CREATE DATABASE clog;
 CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
 
 CREATE TABLE posts (
-    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
-    title CHARACTER VARYING NOT NULL,
-    body CHARACTER VARYING NOT NULL,
-    created_at TIMESTAMP NOT NULL DEFAULT NOW(),
-    updated_at TIMESTAMP NOT NULL DEFAULT NOW()
+	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()
 );
-- 
cgit v1.2.3

