chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.main.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
Rename age to timestamp; add field for email (rfc822) messageid
[ypp-sc-tools.main.git]
/
pctb
/
db-idempotent-populate
diff --git
a/pctb/db-idempotent-populate
b/pctb/db-idempotent-populate
index 2cae151b3a236a62386c8b554ffcf6d51a396bde..66fd6f5e380a2879948fb61ed04b6051440b7ef8 100755
(executable)
--- a/
pctb/db-idempotent-populate
+++ b/
pctb/db-idempotent-populate
@@
-94,7
+94,8
@@
dbdoall(<<END)
);
CREATE TABLE IF NOT EXISTS uploads (
islandid INTEGER PRIMARY KEY NOT NULL,
- age INTEGER NOT NULL,
+ timestamp INTEGER NOT NULL,
+ message TEXT NOT NULL,
clientspec TEXT NOT NULL,
serverspec TEXT NOT NULL
);