wip

[nj-awaymsg.git] / schema

diff --git a/schema b/schema
index eb2ffb8d35fb69c97e522e53c8a90ec89efc3bbc..afcda2980a4158e998ee58013620a6e33a525e53 100644 (file)
--- 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
+       );