From 8ee07502cc84bb878efaf637947d543689eb38bf Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Sat, 27 Oct 2018 17:09:09 -0400
Subject: Fix bug in database schema

These text fields need a default of NULL aparently.

Signed-off-by: Malf Furious <m@lfurio.us>
---
 srvs/mysql.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'srvs/mysql.sql')

diff --git a/srvs/mysql.sql b/srvs/mysql.sql
index 72167d4..de5ce85 100644
--- a/srvs/mysql.sql
+++ b/srvs/mysql.sql
@@ -200,7 +200,7 @@ CREATE TABLE issues (
     closer      varchar(8)          NOT NULL    DEFAULT '',     /* user */
     closed      varchar(64)         NOT NULL    DEFAULT '',     /* timestamp */
     due         varchar(64)         NOT NULL    DEFAULT '',     /* timestamp */
-    tags        text                NOT NULL,
+    tags        text            DEFAULT NULL,
 
     PRIMARY KEY (guid)
 );
@@ -212,7 +212,7 @@ DROP TABLE IF EXISTS mesgs;
 CREATE TABLE mesgs (
     guid        varchar(8)          NOT NULL,
     author      varchar(8)          NOT NULL    DEFAULT '',
-    mesg        text                NOT NULL,
+    mesg        text            DEFAULT NULL,
     attachment  varchar(64)         NOT NULL    DEFAULT '',
 
     PRIMARY KEY (guid)
-- 
cgit v1.2.3

