aboutsummaryrefslogtreecommitdiffstats
path: root/init.sql
diff options
context:
space:
mode:
authorAdam Mathes <adam@trenchant.org>2018-04-28 11:00:56 -0700
committerAdam Mathes <adam@trenchant.org>2018-04-28 11:00:56 -0700
commit05def1ea616242a0c44c72402657d1866afdf005 (patch)
tree40b85af24b2535ecd3e4c86c2fe37a7b31c7e2de /init.sql
parentc6eedc0cb623cd1e265ab02f0addfa865008b94e (diff)
downloadneko-05def1ea616242a0c44c72402657d1866afdf005.tar.gz
neko-05def1ea616242a0c44c72402657d1866afdf005.tar.bz2
neko-05def1ea616242a0c44c72402657d1866afdf005.zip
no nulls dammit
Diffstat (limited to 'init.sql')
-rw-r--r--init.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/init.sql b/init.sql
index 3149032..dbbc310 100644
--- a/init.sql
+++ b/init.sql
@@ -15,9 +15,9 @@ CREATE TABLE feed (
CREATE TABLE item (
id INT NOT NULL AUTO_INCREMENT,
feed_id INT NOT NULL,
- title TEXT,
+ title TEXT NOT NULL DEFAULT "",
url VARCHAR(255) NOT NULL,
- description TEXT,
+ description TEXT NOT NULL DEFAULT "",
full_content TEXT NOT NULL DEFAULT "",
header_image TEXT NOT NULL DEFAULT "",
publish_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,