X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits%2FDBIx-Class.git;a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=6c4202a32f9d826e61b31612de01a86c3f66c655;hp=3932c2b3aaa2e2b017ba8542fae10a5abc9d74ff;hb=6882de2b334aac0a278b1984e82ddaca2ddff2b4;hpb=5d77957881710b33a6f3cd8c36014e6a92838763

diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql
index 3932c2b..6c4202a 100644
--- a/t/lib/sqlite.sql
+++ b/t/lib/sqlite.sql
@@ -1,6 +1,6 @@
 -- 
 -- Created by SQL::Translator::Producer::SQLite
--- Created on Sun Feb 22 00:15:06 2009
+-- Created on Sun Apr 19 11:49:48 2009
 -- 
 
 
@@ -232,9 +232,11 @@ CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_tw
 CREATE TABLE genre (
   genreid INTEGER PRIMARY KEY NOT NULL,
   name varchar(100) NOT NULL,
-  demographicid INTEGER NOT NULL
+  demographicid integer NOT NULL
 );
 
+CREATE INDEX genre_idx_demographicid_genre ON genre (demographicid);
+
 CREATE UNIQUE INDEX genre_name_genre ON genre (name);
 
 --