From 952c32df9f41d46ca85c821b605a851283fa0817 Mon Sep 17 00:00:00 2001 From: Malf Furious Date: Thu, 20 Sep 2018 17:31:46 -0400 Subject: mysql: Remove defaults from 'text' datatypes It is an error in Mysql for columns of type 'text' to have a default value. Removing these resolves Mysql errors and MariaDB warnings. --- schema.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/schema.sql b/schema.sql index 7587578..995b52d 100644 --- a/schema.sql +++ b/schema.sql @@ -181,7 +181,7 @@ CREATE TABLE issues ( numb int(32) NOT NULL, assignee varchar(8) NOT NULL DEFAULT '', seen int(1) NOT NULL DEFAULT 0, /* has the assignee seen this yet? */ - description text NOT NULL DEFAULT '', + description text NOT NULL, due varchar(64) NOT NULL DEFAULT '', tags varchar(64) NOT NULL DEFAULT '', @@ -195,7 +195,7 @@ DROP TABLE IF EXISTS mesgs; CREATE TABLE mesgs ( guid varchar(8) NOT NULL, author varchar(8) NOT NULL, - mesg text NOT NULL DEFAULT '', + mesg text NOT NULL, attachment varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (guid) -- cgit v1.2.3