X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=b3f0f0fe71829654edfa8dcaac3408252bb58417;hb=a1cb5921a914f087163914b010ca0c4e72a57dcc;hp=1db9557fc694fa7cc49ec4ee6e8aed9d28c027c6;hpb=72dacbc5825c4fd88d907af540b1b23a3356dcb3;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index 1db9557..b3f0f0f 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -1,6 +1,6 @@ -- -- Created by SQL::Translator::Producer::SQLite --- Created on Mon Nov 10 23:52:55 2008 +-- Created on Sun Nov 16 10:43:11 2008 -- BEGIN TRANSACTION; @@ -58,11 +58,13 @@ CREATE TABLE cd ( artist integer NOT NULL, title varchar(100) NOT NULL, year varchar(100) NOT NULL, - genreid integer + genreid integer, + single_track integer ); CREATE INDEX cd_idx_artist_cd ON cd (artist); CREATE INDEX cd_idx_genreid_cd ON cd (genreid); +CREATE INDEX cd_idx_single_track_cd ON cd (single_track); CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title); --