From: Ian Jackson <ian@liberator.relativity.greenend.org.uk>
Date: Tue, 28 Jul 2009 17:10:17 +0000 (+0100)
Subject: Rename age to timestamp; add field for email (rfc822) messageid
X-Git-Tag: 3.0~28
X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.db-live.git;a=commitdiff_plain;h=a5ec88cc0c003b52afa18af3a97242fe891501b8

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

diff --git a/pctb/db-idempotent-populate b/pctb/db-idempotent-populate
index 2cae151..66fd6f5 100755
--- 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
  );