Index: trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh
===================================================================
--- trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh	(revision 42440)
+++ trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh	(revision 42445)
@@ -4,4 +4,15 @@
 set DBNAME = "rawfix"
 set DBUSER = "dvo"
+
+# add in the iteration and the state summary
+
+mysql -h localhost -u root <<EOF
+  use $DBNAME;
+  ALTER TABLE nights ADD COLUMN iter SMALLINT, ADD COLUMN Ngood SMALLINT, ADD COLUMN Ndead SMALLINT, ADD COLUMN Ngone SMALLINT;
+  ALTER TABLE nights ADD COLUMN Nsing SMALLINT, ADD COLUMN Ndups SMALLINT, ADD COLUMN Nsbck SMALLINT, ADD COLUMN Nxbck SMALLINT;
+  ALTER TABLE nights ADD COLUMN Ncul1 SMALLINT, ADD COLUMN Ncul2 SMALLINT, ADD COLUMN Ncul3 SMALLINT;
+EOF
+
+exit 0
 
 mysql -h localhost -u root <<EOF