Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23389)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23390)
@@ -167,4 +167,5 @@
     fault SMALLINT NOT NULL,
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    magicked TINYINT,
     PRIMARY KEY(exp_id),
     KEY(exp_name),
@@ -263,4 +264,5 @@
     tess_id VARCHAR(64),
     end_stage VARCHAR(64),
+    magicked TINYINT,
     PRIMARY KEY(chip_id),
     KEY(chip_id), KEY(exp_id),
@@ -826,4 +828,5 @@
     end_stage VARCHAR(64),
     registered DATETIME,
+    magicked TINYINT,
     PRIMARY KEY(warp_id),
     KEY(warp_id),
@@ -963,4 +966,5 @@
         tess_id VARCHAR(64),
         exp_id  BIGINT,
+        magicked TINYINT,
         PRIMARY KEY(diff_id),
         KEY(diff_id),
@@ -1095,4 +1099,5 @@
         stage_id BIGINT,
         cam_id BIGINT,
+        label VARCHAR(64),
         outroot VARCHAR(255),
         recoveryroot VARCHAR(255),
@@ -1102,4 +1107,6 @@
         KEY(magic_ds_id),
         KEY(state),
+        KEY(magic_id),
+        KEY(label),
         FOREIGN KEY (magic_id)  REFERENCES  magicRun(magic_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1225,3 +1232,107 @@
         KEY(job_id),
         FOREIGN KEY (req_id)  REFERENCES  pstampRequest(req_id)
-) ENGINE=innodb DEFAULT CHARSET=latin1
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE distTarget (
+    target_id   BIGINT AUTO_INCREMENT, 
+    obs_mode    VARCHAR(64),
+    stage       VARCHAR(64),
+    clean       TINYINT,
+    state       VARCHAR(64),
+    comment     VARCHAR(255),
+    PRIMARY KEY(target_id)
+)  ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE distRun (
+    dist_id     BIGINT AUTO_INCREMENT,
+    target_id   BIGINT,
+    stage       VARCHAR(64),
+    stage_id    BIGINT,
+    chip_id     BIGINT,
+    label       VARCHAR(64),
+    outroot     VARCHAR(255),
+    clean       TINYINT,
+    state       VARCHAR(64),
+    time_stamp  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    fault       SMALLINT,
+    PRIMARY KEY(dist_id),
+    KEY(state),
+    KEY(label),
+    FOREIGN KEY(target_id) REFERENCES distTarget(target_id)
+)  ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE distComponent (
+    dist_id     BIGINT, 
+    component   VARCHAR(64),
+    bytes       INT,
+    md5sum      VARCHAR(32),
+    state       VARCHAR(64),
+    name        VARCHAR(255),
+    fault       SMALLINT,
+    PRIMARY KEY(dist_id, component),
+    KEY(state),
+    FOREIGN KEY(dist_id) REFERENCES distRun(dist_id)
+)  ENGINE=innodb DEFAULT CHARSET=latin1;
+
+
+CREATE TABLE rcDSProduct (
+    prod_id     BIGINT AUTO_INCREMENT,
+    name        VARCHAR(64),
+    dbname      VARCHAR(64),
+    dbhost      VARCHAR(64),
+    prod_root   VARCHAR(255),
+    PRIMARY KEY(prod_id)
+)  ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE rcDestination (
+    dest_id     BIGINT AUTO_INCREMENT,
+    prod_id     BIGINT,
+    name        VARCHAR(64),
+    status_uri  VARCHAR(255),
+    comment     VARCHAR(255),
+    last_fileset VARCHAR(255),
+    state       VARCHAR(64),
+    PRIMARY KEY(dest_id),
+    FOREIGN KEY(prod_id) REFERENCES rcDSProduct(prod_id)
+)  ENGINE=innodb DEFAULT CHARSET=latin1;
+
+
+CREATE TABLE rcInterest (
+    int_id      BIGINT AUTO_INCREMENT,
+    dest_id     BIGINT,
+    target_id   BIGINT,
+    prod_id     BIGINT,
+    state       VARCHAR(64),
+    PRIMARY KEY(int_id),
+    FOREIGN KEY(dest_id) REFERENCES rcDestination(dest_id),
+    FOREIGN KEY(target_id) REFERENCES distTarget(target_id),
+    FOREIGN KEY(prod_id) REFERENCES rcDSProduct(prod_id)
+)  ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE rcDSFileset (
+    fs_id       BIGINT AUTO_INCREMENT,
+    dist_id     BIGINT,
+    prod_id     BIGINT,
+    name        VARCHAR(64),
+    state       VARCHAR(64),
+    registered  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY(fs_id),
+    FOREIGN KEY(dist_id) REFERENCES distRun(dist_id),
+    FOREIGN KEY(prod_id) REFERENCES rcDSProduct(prod_id)
+)  ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE rcRun (
+    rc_id       BIGINT AUTO_INCREMENT,
+    fs_id       BIGINT,
+    dest_id     BIGINT,
+    state       VARCHAR(64),
+    registered  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY(rc_id),
+    FOREIGN KEY(fs_id) REFERENCES rcDSFileset(fs_id),
+    FOREIGN KEY(dest_id) REFERENCES rcDestination(dest_id)
+)  ENGINE=innodb DEFAULT CHARSET=latin1;
+
+
+
+-- This comment line is here to avoid empty query error. 
+-- Another way to avoid that problem is to omit the semicolon above but I think that is untidy.
Index: trunk/ippTools/share/pxadmin_drop_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 23389)
+++ trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 23390)
@@ -54,4 +54,5 @@
 DROP TABLE IF EXISTS calRun;
 DROP TABLE IF EXISTS flatcorrRun;
+DROP TABLE IF EXISTS flatcorrExp;
 DROP TABLE IF EXISTS flatcorrChipLink;
 DROP TABLE IF EXISTS flatcorrCamLink;
@@ -60,3 +61,12 @@
 DROP TABLE IF EXISTS pstampRequest;
 DROP TABLE IF EXISTS pstampJob;
+DROP TABLE IF EXISTS distRun;
+DROP TABLE IF EXISTS distTarget;
+DROP TABLE IF EXISTS distComponent;
+DROP TABLE IF EXISTS rcDSProduct;
+DROP TABLE IF EXISTS rcDestination;
+DROP TABLE IF EXISTS rcInterest;
+DROP TABLE IF EXISTS rcDSFileset;
+DROP TABLE IF EXISTS rcRun;
+
 SET FOREIGN_KEY_CHECKS=1