edit create

[nj-awaymsg.git] / schema

diff --git a/schema b/schema
index eb2ffb8d35fb69c97e522e53c8a90ec89efc3bbc..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
+       text            TEXT NOT NULL
        );
 
 CREATE TABLE addresses (
@@ -12,3 +11,8 @@ CREATE TABLE addresses (
        textid          INTEGER
        );
 
+CREATE TABLE config (
+       emailaddr       TEXT PRIMARY KEY NOT NULL,
+       username        TEXT NOT NULL,
+       forwardfile     TEXT NOT NULL
+       );