Changes between Version 1 and Version 2 of refactoring_harvesters

Timestamp:

Mar 28, 2011, 1:35:27 AM (13 years ago)

Author:

mcoudert

Comment:

--

refactoring_harvesters

@@ -38 +38 @@
 For now, we did a new interface based on ExtJs only for the OAI PMH harvester and we only move this harvester to the new model, there is some work to move all harvesters and to get them working into the trunk. 
 
+{{{
+
+CREATE TABLE HarvestingTask
+  (
+        id int,
+        uuid         varchar(250)   not null,
+        name     varchar(32)    not null,
+        harvestingType     varchar(32)    not null,
+        validationMode     varchar(32)    not null,
+        isrecurrent     char(1)        default 'n' not null,
+        recurrentPeriod     int,
+        lastRun   varchar(24),
+        backup     varchar(32),
+        status     varchar(32)    not null,
+        isSynchronization   char(1)        default 'n' not null,
+        isIncremental  char(1)        default 'n' not null,
+        categoryid int not null,
+        
+        primary key(id),
+        
+        foreign key(categoryid) references Categories(id),
+        
+        unique(uuid)
+  );
+
+CREATE TABLE HarvestingTaskResult
+  (
+        harvestingTaskResultId int,
+        dateResult   varchar(24)    not null,
+        total int,
+        added int,
+        updated int,
+        unchanged int,
+        locallyRemoved int,
+        unknownSchema int,
+        unretrievable int,
+        badFormat int,
+        doesNotValidate int,
+        ignored int,
+        errors text,
+        harvestingTaskId int,
+        
+        primary key(harvestingTaskResultId),
+        foreign key(harvestingTaskId) references HarvestingTask(id)
+        
+  );
+  
+
+CREATE TABLE HarvestingTaskConfiguration
+  (
+        configurationId int,
+        attr   varchar(24)    not null,
+        val    varchar(250)    not null,
+        harvestingTaskId int,
+        
+        primary key(configurationId),
+        foreign key(harvestingTaskId) references HarvestingTask(id)
+        
+  );
+
+And also a foreign key in the Metadata table : 
+    foreign key(harvestingTask) references HarvestingTask(id),
+
+}}}
+
 === Backwards Compatibility Issues ===