aboutsummaryrefslogtreecommitdiff
path: root/db/db.sql
diff options
context:
space:
mode:
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()
);