chiark / gitweb /
Rename age to timestamp; add field for email (rfc822) messageid
[ypp-sc-tools.db-live.git] / pctb / db-idempotent-populate
index 2cae151..66fd6f5 100755 (executable)
@@ -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
  );