X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=cfb4e3335a3f2ac13f5c8aa690f829a9607d580f;hb=285dd1d62d2f2e89fd3e8eed3336aa5b1970a4e2;hp=ce8be8341babe3efd8cb0da94a6915351c8eea7d;hpb=27d619d8c3100065f87bdbcc7c1496cb2e5495c9;p=dbsrgits%2FDBIx-Class.git

diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql
index ce8be83..cfb4e33 100644
--- a/t/lib/sqlite.sql
+++ b/t/lib/sqlite.sql
@@ -1,6 +1,6 @@
 -- 
 -- Created by SQL::Translator::Producer::SQLite
--- Created on Thu Jul 30 09:37:43 2009
+-- Created on Sun Nov 15 14:13:02 2009
 -- 
 
 
@@ -16,6 +16,8 @@ CREATE TABLE artist (
   charfield char(10)
 );
 
+CREATE INDEX artist_name_hookidx ON artist (name);
+
 --
 -- Table: bindtype_test
 --
@@ -281,12 +283,11 @@ CREATE INDEX self_ref_alias_idx_self_ref ON self_ref_alias (self_ref);
 CREATE TABLE track (
   trackid INTEGER PRIMARY KEY NOT NULL,
   cd integer NOT NULL,
-  position integer NOT NULL,
+  position int NOT NULL,
   title varchar(100) NOT NULL,
   last_updated_on datetime,
   last_updated_at datetime,
-  small_dt smalldatetime,
-  increment integer
+  small_dt smalldatetime
 );
 
 CREATE INDEX track_idx_cd ON track (cd);
@@ -452,6 +453,6 @@ CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd ON fourkeys_to_twokeys (t_art
 -- View: year2000cds
 --
 CREATE VIEW year2000cds AS
-    SELECT cdid, artist, title FROM cd WHERE year ='2000';
+    SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000";
 
 COMMIT;