chiark
/
gitweb
/
~ian
/
nj-awaymsg.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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,
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,
subject TEXT NOT NULL,
text TEXT NOT NULL,
- expires TEXT
+ expires TEXT
NOT NULL
);
CREATE TABLE addresses (
);
CREATE TABLE addresses (
@@
-12,3
+12,8
@@
CREATE TABLE addresses (
textid INTEGER
);
textid INTEGER
);
+CREATE TABLE config (
+ emailaddr TEXT PRIMARY KEY NOT NULL,
+ username TEXT NOT NULL,
+ forwardfile TEXT NOT NULL
+ );