X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=b364cb46b29fb53cd1217d5fe713e7d4227efe98;hb=6ffb5be522e752ea1ad2a99d36648535fe30a43b;hp=fcdae19f900416d35507a9f78c5910436fe48f8d;hpb=4f6386b03a5e179c64240c8ab7b3bbec8a2004e1;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index fcdae19..b364cb4 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 17 02:53:11 2008 +-- Created on Sat Jan 24 19:42:15 2009 -- BEGIN TRANSACTION; @@ -38,6 +38,29 @@ CREATE TABLE cd_artwork ( CREATE INDEX cd_artwork_idx_cd_id_cd_artwor ON cd_artwork (cd_id); -- +-- Table: artwork_to_artist +-- +CREATE TABLE artwork_to_artist ( + artwork_cd_id integer NOT NULL, + artist_id integer NOT NULL, + PRIMARY KEY (artwork_cd_id, artist_id) +); + +CREATE INDEX artwork_to_artist_idx_artist_id_artwork_to_arti ON artwork_to_artist (artist_id); +CREATE INDEX artwork_to_artist_idx_artwork_cd_id_artwork_to_ ON artwork_to_artist (artwork_cd_id); + +-- +-- Table: bindtype_test +-- +CREATE TABLE bindtype_test ( + id INTEGER PRIMARY KEY NOT NULL, + bytea blob, + blob blob, + clob clob +); + + +-- -- Table: bookmark -- CREATE TABLE bookmark ( @@ -400,5 +423,12 @@ CREATE TABLE typed_object ( value varchar(100) NOT NULL ); +-- +-- Table: encoded +-- +CREATE TABLE encoded ( + id INTEGER PRIMARY KEY NOT NULL, + encoded varchar(100) NOT NULL +); COMMIT;