Index: trunk/dbconfig/add.md
===================================================================
--- trunk/dbconfig/add.md	(revision 25795)
+++ trunk/dbconfig/add.md	(revision 25816)
@@ -1,2 +1,3 @@
+# XXX rename these 'addstarRun', etc... (add_id -> addstar_id)
 addRun METADATA
     add_id          S64     0       # Primary Key AUTO_INCREMENT
@@ -5,7 +6,8 @@
     workdir         STR     255
     workdir_state   STR     64
+    reduction       STR	    64
     label           STR	    64
     dvodb	    STR	    255
-    magicked        S64     0
+    image_only      BOOL    f
 END
 
@@ -13,7 +15,4 @@
     add_id          S64     0       # Primary Key AUTO_INCREMENT
     dtime_addstar   F32     0.0
-
-    n_stars         S32     0
-    
     path_base	    STR	    255
     fault           S16     0       # Key NOT NULL
Index: trunk/dbconfig/changes.txt
===================================================================
--- trunk/dbconfig/changes.txt	(revision 25795)
+++ trunk/dbconfig/changes.txt	(revision 25816)
@@ -1300,4 +1300,21 @@
 
 ALTER TABLE pstampJob ADD COLUMN options BIGINT;
+
+ALTER TABLE addRun ADD COLUMN reduction VARCHAR(64) AFTER workdir_state;
+ALTER TABLE addRun DROP COLUMN magicked;
+ALTER TABLE addRun ADD COLUMN image_only tinyint after dvodb;
+ALTER TABLE addProcessedExp DROP COLUMN n_stars;
+
+CREATE TABLE flatcorrAddstarLink (
+        corr_id BIGINT,
+        cam_id BIGINT,
+        add_id BIGINT,
+        include TINYINT,
+        PRIMARY KEY(corr_id, cam_id, add_id),
+        FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
+        FOREIGN KEY (cam_id)  REFERENCES  camRun(cam_id),
+        FOREIGN KEY (add_id)  REFERENCES  addRun(add_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 ALTER TABLE pstampJob ADD COLUMN dep_id BIGINT;
 CREATE TABLE pstampDependent (
@@ -1311,3 +1328,2 @@
         PRIMARY KEY(dep_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
-
Index: trunk/dbconfig/flatcorr.md
===================================================================
--- trunk/dbconfig/flatcorr.md	(revision 25795)
+++ trunk/dbconfig/flatcorr.md	(revision 25816)
@@ -33,2 +33,10 @@
 END
 
+# table of exposures sent to addstar
+flatcorrAddstarLink METADATA
+    corr_id     S64         0       # Primary Key fkey(corr_id) ref flatcorrRun(corr_id)
+    cam_id      S64         0       # Primary Key fkey(chip_id) ref chipRun(chip_id)
+    add_id      S64         0       # Primary Key fkey(chip_id) ref chipRun(chip_id)
+    include     BOOL        t
+END
+