From 27e88a9609277e0c76b73b1498d6262927deadf7 Mon Sep 17 00:00:00 2001 From: Michael McVady 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