Changeset 26015 for trunk/dbconfig

Timestamp:

Nov 3, 2009, 1:02:08 PM (17 years ago)

Author:

bills

Message:

Spread building of distribution bundles over a number of hosts (currently 5)

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• dist.md (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -1424 +1424 @@
 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();

trunk/dbconfig/dist.md

@@ -17 +17 @@
     label       STR         64      # Key
     outroot     STR         255
+    outdir      STR         255
     clean       BOOL        f
     no_magic    BOOL        f
@@ -31 +32 @@
     md5sum      STR         32
     state       STR         64      # Key
+    outdir      STR         255
     name        STR         255
     fault       S16         0