Changeset 42531 for branches/eam_branches/ipp-20230313/tools/eam/rawfix.20230221/src/create.rawfix.sh

Timestamp:

Aug 17, 2023, 4:41:34 PM (3 years ago)

Author:

eugene

Message:

merging from trunk

Location:

branches/eam_branches/ipp-20230313/tools

Files:

• . (modified) (1 prop)
• eam/rawfix.20230221/src/create.rawfix.sh (modified) (2 diffs)

branches/eam_branches/ipp-20230313/tools/eam/rawfix.20230221/src/create.rawfix.sh

@@ -1 +1 @@
 #!/bin/csh
+
+echo "do not use without caution"
+exit 2
 
 # make the rawfix database to track rawfix operations
@@ -5 +8 @@
 set DBUSER = "dvo"
 
+# add in the iteration and the state summary
+
+mysql -h localhost -u root <<EOF
+  use $DBNAME;
+  ALTER TABLE nights MODIFY Ngood INT, MODIFY Ndead INT, MODIFY Ngone INT;
+  ALTER TABLE nights MODIFY Nsing INT, MODIFY Ndups INT, MODIFY Nsbck INT, MODIFY Nxbck INT, MODIFY Nfail INT;
+  ALTER TABLE nights MODIFY Ncul1 INT, MODIFY Ncul2 INT, MODIFY Ncul3 INT;
+EOF
+
+exit 0
+
+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
   drop database if exists $DBNAME;
   create database $DBNAME;
   use $DBNAME;
-  create table nights (night_id BIGINT AUTO_INCREMENT, dateobs char(64), state char(64), primary key (night_id));
+  create table nights (night_id BIGINT AUTO_INCREMENT, dateobs char(64), state char(64), primary key (night_id), unique (dateobs));
 EOF