[1390] in Moira
workaround duplicate strings
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Fri Mar 3 22:38:59 2000
Message-Id: <200003040338.WAA28501@x15-cruise-basselope.mit.edu>
To: moiradev@MIT.EDU
Date: Fri, 03 Mar 2000 22:38:55 -0500
From: Garry Zacheiss <zacheiss@MIT.EDU>
This should make queries that would add duplicate strings fail
immediately, as opposed to putting us in a state where we notice months
after the fact.
Index: dbopt.sql
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository//moira/db/dbopt.sql,v
retrieving revision 1.8
diff -c -r1.8 dbopt.sql
*** dbopt.sql 2000/01/11 19:33:15 1.8
--- dbopt.sql 2000/03/04 03:37:18
***************
*** 48,54 ****
create index i_imem_list on imembers (list_id);
create unique index i_str_sid on strings (string_id);
! create index i_str_name on strings (string);
create unique index i_nfs_nid on nfsphys (nfsphys_id);
create index i_nfs_mach on nfsphys (mach_id);
--- 48,54 ----
create index i_imem_list on imembers (list_id);
create unique index i_str_sid on strings (string_id);
! create unique index i_str_name on strings (string);
create unique index i_nfs_nid on nfsphys (nfsphys_id);
create index i_nfs_mach on nfsphys (mach_id);
