« Return to Thread: r11796 - mb_server/trunk/admin/sql

r11796 - mb_server/trunk/admin/sql

by root-97 :: Rate this Message:

Reply (Restricted by the Administrator) | Reply to Author | View in Thread

Author: robert
Date: 2009-06-29 20:41:43 +0000 (Mon, 29 Jun 2009)
New Revision: 11796

Modified:
   mb_server/trunk/admin/sql/CreateIndexes.sql
Log:
Change the track, position index to not be unique for now. We'll fix this after the release.


Modified: mb_server/trunk/admin/sql/CreateIndexes.sql
===================================================================
--- mb_server/trunk/admin/sql/CreateIndexes.sql 2009-06-29 18:32:56 UTC (rev 11795)
+++ mb_server/trunk/admin/sql/CreateIndexes.sql 2009-06-29 20:41:43 UTC (rev 11796)
@@ -65,7 +65,7 @@
 CREATE UNIQUE INDEX tag_idx_name ON tag (name);
 
 CREATE INDEX track_idx_recording ON track (recording);
-CREATE UNIQUE INDEX track_idx_tracklist ON track (tracklist, position);
+CREATE INDEX track_idx_tracklist ON track (tracklist, position);
 CREATE INDEX track_idx_name ON track (name);
 CREATE INDEX track_idx_artist_credit ON track (artist_credit);
 


_______________________________________________
MusicBrainz-commits mailing list
MusicBrainz-commits@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-commits

 « Return to Thread: r11796 - mb_server/trunk/admin/sql