diff options
author | Michael McVady <femtonaut@gmail.com> | 2023-07-08 13:40:45 -0500 |
---|---|---|
committer | Michael McVady <femtonaut@gmail.com> | 2023-07-08 13:40:45 -0500 |
commit | 27e88a9609277e0c76b73b1498d6262927deadf7 (patch) | |
tree | 1d263587b7a81ebc9420426f5d3a00669dc9720b /db/db.sql | |
parent | 6c95c9152b466bdb30d7226001bb790a8e8c7c5b (diff) |
Update data dump
Diffstat (limited to 'db/db.sql')
-rw-r--r-- | db/db.sql | 11 |
1 files changed, 6 insertions, 5 deletions
@@ -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() ); |