Rename age to timestamp; add field for email (rfc822) messageid

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,
  );
  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
  );
        clientspec      TEXT                    NOT NULL,
        serverspec      TEXT                    NOT NULL
  );