--
-- Created by SQL::Translator::Producer::SQLite
--- Created on Thu Jun 3 11:52:50 2010
+-- Created on Sat Oct 16 16:17:01 2010
--
--
CREATE INDEX artist_name_hookidx ON artist (name);
+CREATE UNIQUE INDEX artist_name ON artist (name);
+
--
-- Table: bindtype_test
--
CREATE INDEX tags_idx_cd ON tags (cd);
+CREATE UNIQUE INDEX tagid_cd ON tags (tagid, cd);
+
+CREATE UNIQUE INDEX tagid_cd_tag ON tags (tagid, cd, tag);
+
+CREATE UNIQUE INDEX tags_tagid_tag ON tags (tagid, tag);
+
+CREATE UNIQUE INDEX tags_tagid_tag_cd ON tags (tagid, tag, cd);
+
--
-- Table: cd_to_producer
--