Author: chathuri
Date: Wed Jun 12 19:50:54 2013
New Revision: 1492400
URL: http://svn.apache.org/r1492400
Log:
updating registry migration tool
Modified:
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql
Modified:
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql
URL:
http://svn.apache.org/viewvc/airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql?rev=1492400&r1=1492399&r2=1492400&view=diff
==============================================================================
---
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql
(original)
+++
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_derby.sql
Wed Jun 12 19:50:54 2013
@@ -59,6 +59,14 @@ create table GFac_Job_Data
FOREIGN KEY (workflow_instanceID) REFERENCES
Workflow_Data(workflow_instanceID)
);
+create table GFac_Job_Status
+(
+ local_Job_ID varchar(255),
+ status_update_time TIMESTAMP DEFAULT '0000-00-00 00:00:00',
+ status varchar(255),
+ FOREIGN KEY (local_Job_ID) REFERENCES GFac_Job_Data(local_Job_ID)
+);
+
INSERT INTO GFac_Job_Data(experiment_ID, workflow_instanceID, node_id,
application_descriptor_ID, host_descriptor_ID, service_descriptor_ID,
job_data, local_Job_ID, submitted_time, statusUpdateTime, status, metadata)
SELECT null, workflow_instanceID, node_id, null, invoked_host,
null, null, local_Job_ID, null, null, 'UNKNOWN', null FROM Gram_Data;
\ No newline at end of file
Modified:
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql
URL:
http://svn.apache.org/viewvc/airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql?rev=1492400&r1=1492399&r2=1492400&view=diff
==============================================================================
---
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql
(original)
+++
airavata/trunk/tools/registry-tool/src/main/resources/db-scripts/0.8/migrate_mysql.sql
Wed Jun 12 19:50:54 2013
@@ -59,6 +59,14 @@ create table GFac_Job_Data
FOREIGN KEY (workflow_instanceID) REFERENCES
Workflow_Data(workflow_instanceID)
);
+create table GFac_Job_Status
+(
+ local_Job_ID varchar(255),
+ status_update_time TIMESTAMP DEFAULT '0000-00-00 00:00:00',
+ status varchar(255),
+ FOREIGN KEY (local_Job_ID) REFERENCES GFac_Job_Data(local_Job_ID)
+);
+
INSERT INTO GFac_Job_Data(experiment_ID, workflow_instanceID, node_id,
application_descriptor_ID, host_descriptor_ID, service_descriptor_ID,
job_data, local_Job_ID, submitted_time, status_update_time, status, metadata)
SELECT null, workflow_instanceID, node_id, null, invoked_host,
null, null, local_Job_ID, null, null, 'UNKNOWN', null FROM Gram_Data;
\ No newline at end of file
