X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~ian/git?a=blobdiff_plain;ds=sidebyside;f=schema;h=afcda2980a4158e998ee58013620a6e33a525e53;hb=8b294424211f992a399bc48919b4f868c23530b9;hp=eb2ffb8d35fb69c97e522e53c8a90ec89efc3bbc;hpb=fa1084e8d681187707259ed712f6d5d5c7b99526;p=nj-awaymsg.git

diff --git a/schema b/schema
index eb2ffb8..afcda29 100644
--- a/schema
+++ b/schema
@@ -1,10 +1,10 @@
 
 CREATE TABLE texts (
 	textid		INTEGER PRIMARY KEY NOT NULL,
-	name		TEXT NOT NULL,
+	desc		TEXT NOT NULL,
 	subject		TEXT NOT NULL,
 	text		TEXT NOT NULL,
-	expires		TEXT
+	expires		TEXT NOT NULL
 	);
 
 CREATE TABLE addresses (
@@ -12,3 +12,8 @@ CREATE TABLE addresses (
 	textid		INTEGER
 	);
 
+CREATE TABLE config (
+	emailaddr	TEXT PRIMARY KEY NOT NULL,
+	username	TEXT NOT NULL,
+	forwardfile	TEXT NOT NULL
+	);