From 8ee07502cc84bb878efaf637947d543689eb38bf Mon Sep 17 00:00:00 2001 From: Malf Furious 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 --- 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