add register template; improved message feedback

[chaz/chatty] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 0b8a7104b91534d25e9344df343a33fbd7f166c5..7fd9824cf3e213289c8d5858dcc24ca041ae5e73 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -2,14 +2,15 @@
 PRAGMA foreign_keys = ON;
 
 CREATE TABLE account (
-       id                              INTEGER PRIMARY KEY,
-       username        TEXT,
-       password        TEXT,
+       id              INTEGER PRIMARY KEY,
+       email           TEXT,
+       username        TEXT UNIQUE,
+       password        TEXT NOT NULL,
        status          TEXT DEFAULT 'active'
 );
 
 CREATE TABLE message (
-       id                              INTEGER PRIMARY KEY,
+       id              INTEGER PRIMARY KEY,
        posted          TIMESTAMP,
        author          INTEGER REFERENCES account(id),
        content         TEXT