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

Timestamp:

Mar 28, 2023, 2:43:59 PM (3 years ago)

Author:

eugene

Message:

cleanup logging and automatic advance

File:

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

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

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