database editing etc. works

[nj-awaymsg.git] / schema

diff --git a/schema b/schema
index aaeb0d92ba72d3052db2288334dfe3b3c4bd2ae0..da41a1e820cc1d441a022d0d2419aac074dc60c5 100644 (file)
--- 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 (