Index: trunk/dbconfig/add.md
===================================================================
--- trunk/dbconfig/add.md	(revision 25816)
+++ trunk/dbconfig/add.md	(revision 25835)
@@ -3,10 +3,12 @@
     add_id          S64     0       # Primary Key AUTO_INCREMENT
     cam_id          S64     0       # Key INDEX(add_id,cam_id) fkey(cam_id) ref camRun(cam_id)
-    state           STR     64      # key
+    state           STR     64      # Key
     workdir         STR     255
     workdir_state   STR     64
     reduction       STR	    64
     label           STR	    64
+    data_group      STR     64      # Key
     dvodb	    STR	    255
+    note            STR     255
     image_only      BOOL    f
 END
Index: trunk/dbconfig/cam.md
===================================================================
--- trunk/dbconfig/cam.md	(revision 25816)
+++ trunk/dbconfig/cam.md	(revision 25835)
@@ -6,4 +6,6 @@
     workdir_state STR       64      # key
     label       STR         64      # key
+    data_group  STR         64      # key
+    dist_group  STR         64      # key
     reduction   STR         64
     expgroup    STR         64      # key
@@ -12,4 +14,5 @@
     end_stage   STR         64      # Key
     magicked    S64         0
+    note        STR         255
 END
 
Index: trunk/dbconfig/changes.1.1.56
===================================================================
--- trunk/dbconfig/changes.1.1.56	(revision 25835)
+++ trunk/dbconfig/changes.1.1.56	(revision 25835)
@@ -0,0 +1,78 @@
+ALTER TABLE chipRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE chipRun ADD COLUMN dist_group VARCHAR(64) AFTER data_group;
+ALTER TABLE chipRun ADD COLUMN note VARCHAR(255) AFTER magicked;
+ALTER TABLE chipRun ADD KEY(data_group);
+ALTER TABLE chipRun ADD KEY(dist_group);
+
+UPDATE chipRun SET data_group = label;
+UPDATE chipRun SET dist_group = label;
+
+ALTER TABLE camRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE camRun ADD COLUMN dist_group VARCHAR(64) AFTER data_group;
+ALTER TABLE camRun ADD COLUMN note VARCHAR(255) AFTER magicked;
+ALTER TABLE camRun ADD KEY(data_group);
+ALTER TABLE camRun ADD KEY(dist_group);
+
+UPDATE camRun SET data_group = label;
+UPDATE camRun SET dist_group = label;
+
+ALTER TABLE addRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE addRun ADD COLUMN note VARCHAR(255) AFTER dvodb;
+ALTER TABLE addRun ADD KEY(data_group);
+
+UPDATE addRun SET data_group = label;
+
+ALTER TABLE fakeRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE fakeRun ADD COLUMN dist_group VARCHAR(64) AFTER data_group;
+ALTER TABLE fakeRun ADD COLUMN note VARCHAR(255) AFTER epoch;
+ALTER TABLE fakeRun ADD KEY(data_group);
+ALTER TABLE fakeRun ADD KEY(dist_group);
+
+UPDATE fakeRun SET data_group = label;
+UPDATE fakeRun SET dist_group = label;
+
+ALTER TABLE warpRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE warpRun ADD COLUMN dist_group VARCHAR(64) AFTER data_group;
+ALTER TABLE warpRun ADD COLUMN note VARCHAR(255) AFTER magicked;
+ALTER TABLE warpRun ADD KEY(data_group);
+ALTER TABLE warpRun ADD KEY(dist_group);
+
+UPDATE warpRun SET data_group = label;
+UPDATE warpRun SET dist_group = label;
+
+ALTER TABLE stackRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE stackRun ADD COLUMN dist_group VARCHAR(64) AFTER data_group;
+ALTER TABLE stackRun ADD COLUMN note VARCHAR(255) AFTER filter;
+ALTER TABLE stackRun ADD KEY(data_group);
+ALTER TABLE stackRun ADD KEY(dist_group);
+
+UPDATE stackRun SET data_group = label;
+UPDATE stackRun SET dist_group = label;
+
+ALTER TABLE diffRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE diffRun ADD COLUMN dist_group VARCHAR(64) AFTER data_group;
+ALTER TABLE diffRun ADD COLUMN note VARCHAR(255) AFTER magicked;
+ALTER TABLE diffRun ADD KEY(data_group);
+ALTER TABLE diffRun ADD KEY(dist_group);
+
+UPDATE diffRun SET data_group = label;
+UPDATE diffRun SET dist_group = label;
+
+ALTER TABLE magicRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE magicRun ADD COLUMN note VARCHAR(255) AFTER fault;
+ALTER TABLE magicRun ADD KEY(data_group);
+
+UPDATE magicRun SET data_group = label;
+
+ALTER TABLE magicDSRun ADD COLUMN data_group VARCHAR(64) AFTER label;
+ALTER TABLE magicDSRun ADD COLUMN fault SMALLINT after remove;
+ALTER TABLE magicDSRun ADD COLUMN note VARCHAR(255) AFTER fault;
+ALTER TABLE magicDSRun ADD KEY(fault);
+ALTER TABLE magicDSRun ADD KEY(data_group);
+
+UPDATE magicDSRun SET data_group = label;
+UPDATE magicDSRun SET fault = 0;
+
+ALTER TABLE distRun ADD COLUMN note VARCHAR(255) after fault;
+
+ALTER TABLE distTarget CHANGE COLUMN label dist_group VARCHAR(64);
Index: trunk/dbconfig/chip.md
===================================================================
--- trunk/dbconfig/chip.md	(revision 25816)
+++ trunk/dbconfig/chip.md	(revision 25835)
@@ -6,4 +6,6 @@
     workdir_state STR       64      # Key
     label       STR         64      # Key
+    data_group  STR         64      # Key
+    dist_group  STR         64      # Key
     reduction   STR         64      # Reduction class
     expgroup    STR         64      # Key
@@ -12,4 +14,5 @@
     end_stage   STR         64      # Key
     magicked    S64         0
+    note        STR         255
 END
 
Index: trunk/dbconfig/config.md
===================================================================
--- trunk/dbconfig/config.md	(revision 25816)
+++ trunk/dbconfig/config.md	(revision 25835)
@@ -2,4 +2,4 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.55
+    pkg_version     STR     1.1.56
 END
Index: trunk/dbconfig/diff.md
===================================================================
--- trunk/dbconfig/diff.md	(revision 25816)
+++ trunk/dbconfig/diff.md	(revision 25835)
@@ -6,4 +6,6 @@
     workdir     STR         255
     label       STR         64      # Key
+    data_group  STR         64
+    dist_group  STR         64
     reduction   STR         64      # Reduction class
     dvodb       STR         255
@@ -13,4 +15,5 @@
     exposure	BOOL	    f
     magicked    S64         0
+    note        STR         255
 END
 
Index: trunk/dbconfig/dist.md
===================================================================
--- trunk/dbconfig/dist.md	(revision 25816)
+++ trunk/dbconfig/dist.md	(revision 25835)
@@ -1,5 +1,5 @@
 distTarget METADATA
     target_id   S64        0       # Primary Key
-    label       STR        64
+    dist_group  STR        64
     filter      STR        64
     stage       STR        64
@@ -22,4 +22,5 @@
     time_stamp  UTC         0001-01-01T00:00:00Z
     fault       S16         0
+    note        STR         255
 END
 
Index: trunk/dbconfig/fake.md
===================================================================
--- trunk/dbconfig/fake.md	(revision 25816)
+++ trunk/dbconfig/fake.md	(revision 25835)
@@ -5,4 +5,6 @@
     workdir     STR         255 
     label       STR         64      # Key
+    data_group  STR         64      # Key
+    dist_group  STR         64      # Key
     reduction   STR         64      # Reduction class
     expgroup    STR         64      # Key
@@ -11,4 +13,5 @@
     end_stage   STR         64      # Key
     epoch       UTC         0001-01-01T00:00:00Z
+    note        STR         255
 END
 
Index: trunk/dbconfig/magic.md
===================================================================
--- trunk/dbconfig/magic.md	(revision 25816)
+++ trunk/dbconfig/magic.md	(revision 25835)
@@ -11,7 +11,9 @@
     workdir_state STR       255     # Key
     label       STR         64      # key
+    data_group  STR         64
     dvodb       STR         255
     registered  TAI         NULL
     fault       S16         0       # Key
+    note        STR         255
 END
 
@@ -53,8 +55,11 @@
     cam_id      S64         0
     label       STR         64      # key
+    data_group  STR         64      # key
     outroot     STR         255
     recoveryroot    STR     255
     re_place    BOOL        f
     remove      BOOL        f
+    fault       S16         0       # Key
+    note        STR         255
 END
 
Index: trunk/dbconfig/stack.md
===================================================================
--- trunk/dbconfig/stack.md	(revision 25816)
+++ trunk/dbconfig/stack.md	(revision 25835)
@@ -6,4 +6,6 @@
     workdir     STR         255
     label       STR         64      # Key
+    data_group  STR         64      # Key
+    dist_group  STR         64      # Key
     reduction   STR         64      # Reduction class
     dvodb       STR         255
@@ -12,4 +14,5 @@
     tess_id     STR         64      # Key
     filter      STR         64
+    note        STR         255
 END
 
Index: trunk/dbconfig/warp.md
===================================================================
--- trunk/dbconfig/warp.md	(revision 25816)
+++ trunk/dbconfig/warp.md	(revision 25835)
@@ -17,4 +17,6 @@
     workdir_state STR       64      # Key
     label       STR         64      # key
+    data_group  STR         64
+    dist_group  STR         64
     dvodb       STR         255
     tess_id     STR         64
@@ -23,4 +25,5 @@
     registered  TAI         NULL
     magicked    S64         0
+    note        STR         255
 END
 
