aboutsummaryrefslogtreecommitdiff
path: root/db/db.sql
diff options
context:
space:
mode:
authorMichael McVady <femtonaut@gmail.com>2023-07-08 13:40:45 -0500
committerMichael McVady <femtonaut@gmail.com>2023-07-08 13:40:45 -0500
commit27e88a9609277e0c76b73b1498d6262927deadf7 (patch)
tree1d263587b7a81ebc9420426f5d3a00669dc9720b /db/db.sql
parent6c95c9152b466bdb30d7226001bb790a8e8c7c5b (diff)
Update data dump
Diffstat (limited to 'db/db.sql')
-rw-r--r--db/db.sql11
1 files changed, 6 insertions, 5 deletions
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()
);