chiark / gitweb /
Rename age to timestamp; add field for email (rfc822) messageid
authorIan Jackson <ian@liberator.relativity.greenend.org.uk>
Tue, 28 Jul 2009 17:10:17 +0000 (18:10 +0100)
committerIan Jackson <ian@liberator.relativity.greenend.org.uk>
Tue, 28 Jul 2009 17:10:17 +0000 (18:10 +0100)
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
  );