X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=a004090e7bdd7754ebdda475daa7286871840b8a;hb=26283ee38f220f6c6bae720ea5a189c9c0f47f6f;hp=1c05cec414e45411048df0c7cff272697018bf6c;hpb=1f4263ebe497f0a4a7dbde8850a8d1736946740d;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index 1c05cec..a004090 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -1,4 +1,6 @@ --- Created on Thu Jul 30 09:37:43 2009 +-- +-- Created by SQL::Translator::Producer::SQLite +-- Created on Mon Sep 21 00:11:34 2009 -- @@ -14,6 +16,8 @@ CREATE TABLE artist ( charfield char(10) ); +CREATE INDEX artist_name_hookidx ON artist (name); + -- -- Table: bindtype_test -- @@ -279,7 +283,7 @@ 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,