diff options
| author | Malf Furious <m@lfurio.us> | 2018-10-27 17:09:09 -0400 |
|---|---|---|
| committer | Malf Furious <m@lfurio.us> | 2018-10-27 17:09:09 -0400 |
| commit | 8ee07502cc84bb878efaf637947d543689eb38bf (patch) | |
| tree | a2e3124bc88c78c1c27ea4d9a22fc77c7168ef57 /srvs | |
| parent | a9c7821e812d30edd670ee786795fc076c725230 (diff) | |
| download | scrott-8ee07502cc84bb878efaf637947d543689eb38bf.tar.gz scrott-8ee07502cc84bb878efaf637947d543689eb38bf.zip | |
Fix bug in database schema
These text fields need a default of NULL aparently.
Signed-off-by: Malf Furious <m@lfurio.us>
Diffstat (limited to 'srvs')
| -rw-r--r-- | srvs/mysql.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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) |