aboutsummaryrefslogtreecommitdiffstats
path: root/init.sql
diff options
context:
space:
mode:
authorAdam Mathes <adam@trenchant.org>2017-11-19 21:24:30 -0700
committerAdam Mathes <adam@trenchant.org>2017-11-19 21:24:30 -0700
commit1a6516cffc33403b51a8f38af4a574ae94ab2999 (patch)
treec53603ec3a0daeed6f39103af0106d6b6327b331 /init.sql
parent741cd94da338e00e2eee0e12d572e04c3be46530 (diff)
downloadneko-1a6516cffc33403b51a8f38af4a574ae94ab2999.tar.gz
neko-1a6516cffc33403b51a8f38af4a574ae94ab2999.tar.bz2
neko-1a6516cffc33403b51a8f38af4a574ae94ab2999.zip
header, full to img
Diffstat (limited to 'init.sql')
-rw-r--r--init.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/init.sql b/init.sql
index d2c0de1..1e41f88 100644
--- a/init.sql
+++ b/init.sql
@@ -17,7 +17,8 @@ CREATE TABLE item (
title TEXT,
url VARCHAR(255) NOT NULL,
description TEXT,
- full_content TEXT,
+ full_content TEXT NOT NULL DEFAULT "",
+ header_image TEXT NOT NULL DEFAULT "",
publish_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
read_state BOOLEAN DEFAULT FALSE NOT NULL,
starred BOOLEAN DEFAULT FALSE NOT NULL,