X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~ian/git?a=blobdiff_plain;f=schema;h=da41a1e820cc1d441a022d0d2419aac074dc60c5;hb=dc799127a0e7b0599248dd9669652aeb4af59454;hp=aaeb0d92ba72d3052db2288334dfe3b3c4bd2ae0;hpb=42a6560ca0aa3325296f3ea72096232cdc056cb5;p=nj-awaymsg.git

diff --git a/schema b/schema
index aaeb0d9..da41a1e 100644
--- a/schema
+++ b/schema
@@ -1,10 +1,9 @@
 
 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 NOT NULL
+	text		TEXT NOT NULL
 	);
 
 CREATE TABLE addresses (