Menu
▾
▴
[GeoNetwork-commit] SF.net SVN: geonetwork:[8225] trunk/web/src/main/webapp/WEB-INF
|
From: <fxp...@us...> - 2011-09-27 09:40:34
|
Revision: 8225
http://geonetwork.svn.sourceforge.net/geonetwork/?rev=8225&view=rev
Author: fxprunayre
Date: 2011-09-27 09:40:17 +0000 (Tue, 27 Sep 2011)
Log Message:
-----------
Add harvester history table to migration step for 2.7.0
Modified Paths:
--------------
trunk/web/src/main/webapp/WEB-INF/config-db.xml
Added Paths:
-----------
trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-db2.sql
trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-default.sql
trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-mysql.sql
trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-oracle.sql
trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-postgis.sql
trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-postgres.sql
trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-sqlserver.sql
Added: trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-db2.sql
===================================================================
--- trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-db2.sql (rev 0)
+++ trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-db2.sql 2011-09-27 09:40:17 UTC (rev 8225)
@@ -0,0 +1,17 @@
+
+CREATE TABLE HarvestHistory
+ (
+ id int not null,
+ harvestDate varchar(30),
+ harvesterUuid varchar(250),
+ harvesterName varchar(128),
+ harvesterType varchar(128),
+ deleted char(1) default 'n' not null,
+ info CLOB(1G),
+ params CLOB(1G),
+
+ primary key(id)
+
+ );
+
+CREATE INDEX HarvestHistoryNDX1 ON HarvestHistory(harvestDate);
Added: trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-default.sql
===================================================================
--- trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-default.sql (rev 0)
+++ trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-default.sql 2011-09-27 09:40:17 UTC (rev 8225)
@@ -0,0 +1,17 @@
+
+CREATE TABLE HarvestHistory
+ (
+ id int not null,
+ 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(harvestDate);
Added: trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-mysql.sql
===================================================================
--- trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-mysql.sql (rev 0)
+++ trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-mysql.sql 2011-09-27 09:40:17 UTC (rev 8225)
@@ -0,0 +1,16 @@
+CREATE TABLE HarvestHistory
+ (
+ id int not null,
+ harvestDate varchar(30),
+ harvesterUuid varchar(250),
+ harvesterName varchar(128),
+ harvesterType varchar(128),
+ deleted char(1) default 'n' not null,
+ info longtext,
+ params longtext,
+
+ primary key(id)
+
+ );
+
+CREATE INDEX HarvestHistoryNDX1 ON HarvestHistory(harvestDate);
Added: trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-oracle.sql
===================================================================
--- trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-oracle.sql (rev 0)
+++ trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-oracle.sql 2011-09-27 09:40:17 UTC (rev 8225)
@@ -0,0 +1,17 @@
+
+CREATE TABLE HarvestHistory
+ (
+ id int not null,
+ harvestDate varchar(30),
+ harvesterUuid varchar(250),
+ harvesterName varchar(128),
+ harvesterType varchar(128),
+ deleted char(1) default 'n' not null,
+ info long,
+ params long,
+
+ primary key(id)
+
+ );
+
+CREATE INDEX HarvestHistoryNDX1 ON HarvestHistory(harvestDate);
Added: trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-postgis.sql
===================================================================
--- trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-postgis.sql (rev 0)
+++ trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-postgis.sql 2011-09-27 09:40:17 UTC (rev 8225)
@@ -0,0 +1,16 @@
+CREATE TABLE HarvestHistory
+ (
+ id int not null,
+ harvestDate varchar(30),
+ harvesterUuid varchar(250),
+ harvesterName varchar(128),
+ harvesterType varchar(128),
+ deleted char(1) default 'n' not null,
+ info text,
+ params text,
+
+ primary key(id)
+
+ );
+
+CREATE INDEX HarvestHistoryNDX1 ON HarvestHistory(harvestDate);
Added: trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-postgres.sql
===================================================================
--- trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-postgres.sql (rev 0)
+++ trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-postgres.sql 2011-09-27 09:40:17 UTC (rev 8225)
@@ -0,0 +1,16 @@
+CREATE TABLE HarvestHistory
+ (
+ id int not null,
+ harvestDate varchar(30),
+ harvesterUuid varchar(250),
+ harvesterName varchar(128),
+ harvesterType varchar(128),
+ deleted char(1) default 'n' not null,
+ info text,
+ params text,
+
+ primary key(id)
+
+ );
+
+CREATE INDEX HarvestHistoryNDX1 ON HarvestHistory(harvestDate);
Added: trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-sqlserver.sql
===================================================================
--- trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-sqlserver.sql (rev 0)
+++ trunk/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/270/migrate-db-sqlserver.sql 2011-09-27 09:40:17 UTC (rev 8225)
@@ -0,0 +1,16 @@
+CREATE TABLE HarvestHistory
+ (
+ id int not null,
+ harvestDate varchar(30),
+ harvesterUuid varchar(250),
+ harvesterName varchar(128),
+ harvesterType varchar(128),
+ deleted char(1) default 'n' not null,
+ info text,
+ params text,
+
+ primary key(id)
+
+ );
+
+CREATE INDEX HarvestHistoryNDX1 ON HarvestHistory(harvestDate);
Modified: trunk/web/src/main/webapp/WEB-INF/config-db.xml
===================================================================
--- trunk/web/src/main/webapp/WEB-INF/config-db.xml 2011-09-27 09:32:44 UTC (rev 8224)
+++ trunk/web/src/main/webapp/WEB-INF/config-db.xml 2011-09-27 09:40:17 UTC (rev 8225)
@@ -56,6 +56,7 @@
<file path="WEB-INF/classes/setup/sql/migrate/265" filePrefix="migrate-"/>
</version>
<version id="270">
+ <file path="WEB-INF/classes/setup/sql/migrate/270" filePrefix="migrate-db-"/>
<file path="WEB-INF/classes/setup/sql/migrate/270" filePrefix="migrate-"/>
</version>
</migrate>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|