From 952c32df9f41d46ca85c821b605a851283fa0817 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
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(-)

(limited to 'schema.sql')

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

