From a5ec88cc0c003b52afa18af3a97242fe891501b8 Mon Sep 17 00:00:00 2001
From: Ian Jackson <ian@liberator.relativity.greenend.org.uk>
Date: Tue, 28 Jul 2009 18:10:17 +0100
Subject: [PATCH] Rename age to timestamp; add field for email (rfc822)
 messageid

---
 pctb/db-idempotent-populate | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

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
  );
-- 
2.30.2