From 05def1ea616242a0c44c72402657d1866afdf005 Mon Sep 17 00:00:00 2001
From: Adam Mathes <adam@trenchant.org>
Date: Sat, 28 Apr 2018 11:00:56 -0700
Subject: no nulls dammit

---
 init.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'init.sql')

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,
-- 
cgit v1.2.3

