X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fchatty;a=blobdiff_plain;f=db%2Fschema.sql;h=7fd9824cf3e213289c8d5858dcc24ca041ae5e73;hp=0b8a7104b91534d25e9344df343a33fbd7f166c5;hb=9a7bfdb65af033380ae3c9242b2b3815bdc2bdc5;hpb=9b343fd3d0f46473e2f5804ac09caeaed95e4283

diff --git a/db/schema.sql b/db/schema.sql
index 0b8a710..7fd9824 100644
--- 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