Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 23776)
+++ trunk/dbconfig/changes.txt	(revision 23843)
@@ -998,3 +998,33 @@
 ALTER TABLE rcInterest DROP COLUMN prod_id;
 
-
+ALTER TABLE rcDSProduct DROP column prod_root;
+
+-- just re-create these two tables
+DROP TABLE rcRun;
+DROP TABLE rcDSFileset;
+
+CREATE TABLE rcDSFileset (
+    fs_id       BIGINT AUTO_INCREMENT,
+    dist_id     BIGINT,
+    prod_id     BIGINT,
+    name        VARCHAR(255),
+    state       VARCHAR(64),
+    registered  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    fault       SMALLINT DEFAULT 0,
+    PRIMARY KEY(dist_id, prod_id),
+    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;
+
Index: trunk/dbconfig/rc.md
===================================================================
--- trunk/dbconfig/rc.md	(revision 23776)
+++ trunk/dbconfig/rc.md	(revision 23843)
@@ -4,5 +4,4 @@
     dbname      STR        64
     dbhost      STR        64
-    prod_root   STR        255
 END
 
@@ -11,8 +10,7 @@
     dist_id     S64        0       # fkey(dist_id) ref distRun(dist_id)
     prod_id     S64        0       # fkey(prod_id) ref rcDSProduct(prod_id)
-    name        STR        64
-    dbname      STR        64
-    dbhost      STR        64
-    prod_root   STR        255
+    name        STR        255
+    state       STR        64
+    fault       S16        0
 END