X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fchatty;a=blobdiff_plain;f=db%2Fschema.sql;h=fee4063c1152baf247785b5a5c1884fc5f1ee53a;hp=70a5a24aae6db1ba2dc94c7f71edda9774135067;hb=d2a57728529b95fa1c2e3da677e64c848e7d065b;hpb=9b535163e614abc2ef39b43fa4aef90e644efa41

diff --git a/db/schema.sql b/db/schema.sql
index 70a5a24..fee4063 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -3,8 +3,8 @@ PRAGMA foreign_keys = ON;
 
 CREATE TABLE room (
 	id		INTEGER PRIMARY KEY,
-	name		TEXT,
-	created		TIMESTAMP DEFAULT NOW
+	name		TEXT UNIQUE,
+	created		TIMESTAMP DEFAULT CURRENT_TIMESTAMP
 );
 
 CREATE TABLE account (
@@ -18,7 +18,7 @@ CREATE TABLE account (
 
 CREATE TABLE message (
 	id		INTEGER PRIMARY KEY,
-	posted		TIMESTAMP DEFAULT NOW,
+	posted		TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 	author		INTEGER REFERENCES account(id),
 	room		INTEGER REFERENCES room(id),
 	content		TEXT