diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 8 |
1 files changed, 4 insertions, 4 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,7 +178,7 @@ 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, @@ -194,7 +194,7 @@ CREATE TABLE issues ( DROP TABLE IF EXISTS mesgs; CREATE TABLE mesgs ( guid varchar(8) NOT NULL, - author varchar(8) NOT NULL, + author varchar(8) NOT NULL DEFAULT '', mesg text NOT NULL, attachment varchar(64) NOT NULL DEFAULT '', |