Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25816)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25835)
@@ -261,10 +261,13 @@
     workdir_state VARCHAR(64),
     label VARCHAR(64),
+    data_group VARCHAR(64),
+    dist_group VARCHAR(64),
     reduction VARCHAR(64),
-     expgroup VARCHAR(64),
+    expgroup VARCHAR(64),
     dvodb VARCHAR(255),
     tess_id VARCHAR(64),
     end_stage VARCHAR(64),
     magicked BIGINT,
+    note VARCHAR(255),
     PRIMARY KEY(chip_id),
     KEY(chip_id), KEY(exp_id),
@@ -272,4 +275,6 @@
     KEY(workdir_state),
     KEY(label),
+    KEY(data_group),
+    KEY(dist_group),
     KEY(expgroup),
     KEY(end_stage),
@@ -367,4 +372,6 @@
     workdir_state VARCHAR(64),
     label VARCHAR(64),
+    data_group VARCHAR(64),
+    dist_group VARCHAR(64),
     reduction VARCHAR(64),
     expgroup VARCHAR(64),
@@ -373,4 +380,5 @@
     end_stage VARCHAR(64),
     magicked BIGINT,
+    note VARCHAR(255),
     PRIMARY KEY(cam_id),
     KEY(cam_id),
@@ -379,4 +387,6 @@
     KEY(workdir_state),
     KEY(label),
+    KEY(data_group),
+    KEY(dist_group),
     KEY(expgroup),
     KEY(end_stage),
@@ -466,5 +476,7 @@
     reduction VARCHAR(64),
     label VARCHAR(64),
+    data_group VARCHAR(64),
     dvodb VARCHAR(255),
+    note  VARCHAR(255),
     image_only TINYINT,
     PRIMARY KEY(add_id),
@@ -474,4 +486,5 @@
     KEY(workdir_state),
     KEY(label),
+    KEY(data_group),
     INDEX(add_id, cam_id),
     FOREIGN KEY(cam_id) REFERENCES camRun(cam_id)
@@ -498,4 +511,6 @@
     workdir VARCHAR(255),
     label VARCHAR(64),
+    data_group VARCHAR(64),
+    dist_group VARCHAR(64),
     reduction VARCHAR(64),
     expgroup VARCHAR(64),
@@ -504,8 +519,11 @@
     end_stage VARCHAR(64),
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    note VARCHAR(255),
     PRIMARY KEY(fake_id),
     KEY(cam_id),
     KEY(state),
     KEY(label),
+    KEY(data_group),
+    KEY(dist_group),
     KEY(expgroup),
     KEY(end_stage),
@@ -834,4 +852,6 @@
     workdir_state VARCHAR(64),
     label VARCHAR(64),
+    data_group VARCHAR(64),
+    dist_group VARCHAR(64),
     dvodb VARCHAR(255),
     tess_id VARCHAR(64),
@@ -840,4 +860,5 @@
     registered DATETIME,
     magicked BIGINT,
+    note VARCHAR(255),
     PRIMARY KEY(warp_id),
     KEY(warp_id),
@@ -847,4 +868,6 @@
     KEY(workdir_state),
     KEY(label),
+    KEY(data_group),
+    KEY(dist_group),
     KEY(end_stage),
     INDEX(warp_id, fake_id),
@@ -910,4 +933,6 @@
         workdir VARCHAR(255),
         label VARCHAR(64),
+        data_group VARCHAR(64),
+        dist_group VARCHAR(64),
         reduction VARCHAR(64),
         dvodb VARCHAR(255),
@@ -916,4 +941,5 @@
         tess_id VARCHAR(64),
         filter VARCHAR(64),
+        note VARCHAR(255),
         PRIMARY KEY(stack_id),
         KEY(stack_id),
@@ -921,5 +947,7 @@
         KEY(skycell_id),
         KEY(tess_id),
-        KEY(label)
+        KEY(label),
+        KEY(data_group),
+        KEY(dist_group)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -973,4 +1001,6 @@
         workdir VARCHAR(255),
         label VARCHAR(64),
+        data_group VARCHAR(64),
+        dist_group VARCHAR(64),
         reduction VARCHAR(64),
         dvodb VARCHAR(255),
@@ -980,9 +1010,12 @@
         exposure TINYINT DEFAULT 0,
         magicked BIGINT,
+        note VARCHAR(255),
         PRIMARY KEY(diff_id),
         KEY(diff_id),
         KEY(state),
         KEY(tess_id),
-        KEY(label)
+        KEY(label),
+        KEY(data_group),
+        KEY(dist_group)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -1055,7 +1088,9 @@
         workdir_state VARCHAR(255),
         label VARCHAR(64),
+        data_group VARCHAR(64),
         dvodb VARCHAR(255),
         registered DATETIME,
         fault SMALLINT,
+        note VARCHAR(255),
         PRIMARY KEY(magic_id),
         KEY(magic_id),
@@ -1063,4 +1098,5 @@
         KEY(workdir_state),
         KEY(label),
+        KEY(data_group),
         KEY(fault),
         FOREIGN KEY(exp_id)  REFERENCES rawExp(exp_id),
@@ -1118,8 +1154,11 @@
         cam_id BIGINT,
         label VARCHAR(64),
+        data_group VARCHAR(64),
         outroot VARCHAR(255),
         recoveryroot VARCHAR(255),
         re_place TINYINT,
         remove TINYINT,
+        fault SMALLINT,
+        note VARCHAR(255),
         PRIMARY KEY(magic_ds_id),
         KEY(magic_ds_id),
@@ -1127,4 +1166,5 @@
         KEY(magic_id),
         KEY(label),
+        KEY(fault),
         FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id),
         FOREIGN KEY(inv_magic_id) REFERENCES magicRun(magic_id)
@@ -1303,4 +1343,5 @@
     time_stamp  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     fault       SMALLINT,
+    note        VARCHAR(255),
     PRIMARY KEY(dist_id),
     KEY(state),