Changeset 42445 for trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh

Timestamp:

Apr 7, 2023, 4:50:38 PM (3 years ago)

Author:

eugene

Message:

rework to use a stage/iteration tracked by the rawfix database

File:

• trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh (modified) (1 diff)

trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh

@@ -4 +4 @@
 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