diff options
| author | Malf Furious <m@lfurio.us> | 2018-09-20 17:31:46 -0400 |
|---|---|---|
| committer | Malf Furious <m@lfurio.us> | 2018-09-20 17:31:46 -0400 |
| commit | 952c32df9f41d46ca85c821b605a851283fa0817 (patch) | |
| tree | 44773d78d3fa368c774298df1f662b6eab80f0be /schema.sql | |
| parent | ad0fe4d7b46f9c0a43a717b1a3c11d6ac50469a3 (diff) | |
| download | scrott-952c32df9f41d46ca85c821b605a851283fa0817.tar.gz scrott-952c32df9f41d46ca85c821b605a851283fa0817.zip | |
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.
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -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) |