Index: trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh
===================================================================
--- trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh	(revision 42399)
+++ trunk/tools/eam/rawfix.20230221/src/create.rawfix.sh	(revision 42440)
@@ -9,5 +9,5 @@
   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