diff options
| -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) |