diff options
| author | Malf Furious <m@lfurio.us> | 2018-09-20 18:43:19 -0400 |
|---|---|---|
| committer | Malf Furious <m@lfurio.us> | 2018-09-20 18:43:19 -0400 |
| commit | 60bb93fa1ebd6f6d4ca9e6fb68456c968f69c36c (patch) | |
| tree | 9fb89ac3b45d0524b521dbe4785237d2a9a0a005 | |
| parent | ad0fe4d7b46f9c0a43a717b1a3c11d6ac50469a3 (diff) | |
| parent | 86f7cbade863dc89934c5a44bc6683cc3826f8a9 (diff) | |
| download | scrott-60bb93fa1ebd6f6d4ca9e6fb68456c968f69c36c.tar.gz scrott-60bb93fa1ebd6f6d4ca9e6fb68456c968f69c36c.zip | |
Merge branch 'bug/schema-defaults' into dev
Diffstat (limited to '')
| -rw-r--r-- | schema.sql | 14 |
1 files changed, 7 insertions, 7 deletions
@@ -94,7 +94,7 @@ CREATE TABLE objects ( guid varchar(8) NOT NULL, owner varchar(8) NOT NULL DEFAULT '', parent varchar(8) NOT NULL DEFAULT '', - name varchar(64) NOT NULL, + name varchar(64) NOT NULL DEFAULT '', created datetime NOT NULL, updated datetime NOT NULL, @@ -131,7 +131,7 @@ CREATE TABLE users ( salt varchar(64) NOT NULL, /* random SHA256 output, used as salt for auth */ alias varchar(64) NOT NULL DEFAULT '', email varchar(64) NOT NULL DEFAULT '', - emailVer varchar(8) NOT NULL, + emailVer varchar(8) NOT NULL DEFAULT '', admin int(1) NOT NULL DEFAULT 0, reg int(1) NOT NULL DEFAULT 0, /* if false, user doesn't have valid credentials */ emailConf int(1) NOT NULL DEFAULT 0, @@ -178,12 +178,12 @@ CREATE TABLE stages ( DROP TABLE IF EXISTS issues; CREATE TABLE issues ( guid varchar(8) NOT NULL, - numb int(32) NOT NULL, + numb int(32) NOT NULL DEFAULT 0, 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 '', + tags text NOT NULL, PRIMARY KEY (guid) ); @@ -194,8 +194,8 @@ CREATE TABLE issues ( DROP TABLE IF EXISTS mesgs; CREATE TABLE mesgs ( guid varchar(8) NOT NULL, - author varchar(8) NOT NULL, - mesg text NOT NULL DEFAULT '', + author varchar(8) NOT NULL DEFAULT '', + mesg text NOT NULL, attachment varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (guid) |