Changes between Version 2 and Version 3 of HarvestingHistory

Timestamp:

Mar 27, 2011, 11:57:58 PM (13 years ago)

Author:

simonp

Comment:

--

HarvestingHistory

@@ -32 +32 @@
 Database changes: add a !HarvestHistory table with the following structure:
 
+{{{
+CREATE TABLE HarvestHistory
+  (
+    id             int,
+    harvestDate    varchar(30),
+    harvesterUuid  varchar(250),
+    harvesterName  varchar(128),
+    harvesterType  varchar(128),
+    deleted        char(1) default 'n' not null,
+    info           longvarchar,
+    params         longvarchar,
+
+    primary key(id)
+
+  );
+
+CREATE INDEX HarvestHistoryNDX1 ON HarvestHistory(id);
+CREATE INDEX HarvestHistoryNDX2 On HarvestHistory(harvesterUuid);
+CREATE INDEX HarvestHistoryNDX3 ON HarvestHistory(harvestDate);
+}}}
+
+The info field is an XML string of the results of the harvest. The params field is the parameters of the harvester. The params field is present so that a harvester that has been deleted can be restored.
+
+ 
+