Index: branches/eam_branches/ipp-20140206/dbconfig/changes.txt
===================================================================
--- branches/eam_branches/ipp-20140206/dbconfig/changes.txt	(revision 36494)
+++ branches/eam_branches/ipp-20140206/dbconfig/changes.txt	(revision 36536)
@@ -2392,5 +2392,5 @@
     state   VARCHAR(16),
     label   VARCHAR(654),
-    registered TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+    registered TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
     fault   SMALLINT,
     PRIMARY KEY(seq_id, projection_cell),
@@ -2412,5 +2412,5 @@
 -- unique keys for the release tables
 
-alter table relStack  add unique key (rel_id, tess_id, skycell_id, filter, stack_type, mjd_obs)
+alter table relStack  add unique key (rel_id, tess_id, skycell_id, filter, stack_type, mjd_obs);
 alter table relExp add UNIQUE KEY(rel_id, exp_id);
 alter table ippRelease add unique key (surveyID, release_name);
@@ -2494,2 +2494,30 @@
 UPDATE dbversion set schema_version = '1.1.78', updated= CURRENT_TIMESTAMP();
 
+--
+
+CREATE TABLE remoteRun (
+    remote_id BIGINT NOT NULL AUTO_INCREMENT,
+    state     VARCHAR(64) NOT NULL,
+    stage     VARCHAR(64) NOT NULL,
+    label     VARCHAR(64) NOT NULL,
+    path_base VARCHAR(255) NOT NULL,
+    job_id    BIGINT,
+    last_poll TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    fault     SMALLINT NOT NULL,
+    PRIMARY KEY (remote_id),
+    KEY (state),
+    KEY (stage),
+    KEY (label),
+    KEY (job_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;    
+
+CREATE TABLE remoteComponent (
+    remote_id BIGINT,
+    stage_id  BIGINT,
+    KEY (stage_id),
+    FOREIGN KEY (remote_id) REFERENCES remoteRun(remote_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;    
+
+UPDATE dbversion set schema_version = '1.1.79', updated= CURRENT_TIMESTAMP();
+
+