Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 25929)
+++ trunk/dbconfig/changes.txt	(revision 26015)
@@ -1424,5 +1424,14 @@
 ALTER TABLE publishClient ADD COLUMN active TINYINT DEFAULT 0 AFTER client_id;
 
-
-
--- UPDATE dbversion set schema_version = '1.1.57',  updated= CURRENT_TIMESTAMP();
+# add outdir to allow spreading files over multiple hosts
+ALTER TABLE distRun ADD COLUMN outdir VARCHAR(255) AFTER outroot;
+ALTER TABLE distComponent ADD COLUMN outdir VARCHAR(255) AFTER state;
+
+# populate the existing runs (except for bills' test runs)
+UPDATE distRun SET outdir = CONCAT_WS('.', outroot, dist_id) WHERE outroot not like '%@HOST@%';
+UPDATE distRun join distComponent using(dist_id) SET distComponent.outdir = CONCAT_WS('.', distRun.outroot, dist_id);
+
+UPDATE dbversion set schema_version = '1.1.57',  updated= CURRENT_TIMESTAMP();
+
+-- Vesion 1.1.58
+-- UPDATE dbversion set schema_version = '1.1.58',  updated= CURRENT_TIMESTAMP();
Index: trunk/dbconfig/dist.md
===================================================================
--- trunk/dbconfig/dist.md	(revision 25929)
+++ trunk/dbconfig/dist.md	(revision 26015)
@@ -17,4 +17,5 @@
     label       STR         64      # Key
     outroot     STR         255
+    outdir      STR         255
     clean       BOOL        f
     no_magic    BOOL        f
@@ -31,4 +32,5 @@
     md5sum      STR         32
     state       STR         64      # Key
+    outdir      STR         255
     name        STR         255
     fault       S16         0