X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=2ce5dadf4b27cb5334bac513ade8041a384b60f3;hb=78060df8cb43cafd81304f386d7111510a4b8f9d;hp=228e448fb180bc26c4039ff06d75a0177f26cc80;hpb=89d794d486e3c73b489817059e9c3983deebde7f;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index 228e448..2ce5dad 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -210,6 +210,50 @@ CREATE TABLE onekey ( cd integer NOT NULL ); +-- +-- Table: typed_object +-- +CREATE TABLE typed_object ( + objectid INTEGER PRIMARY KEY NOT NULL, + type VARCHAR(100) NOT NULL, + value VARCHAR(100) +); + +-- +-- Table: collection +-- +CREATE TABLE collection ( + collectionid INTEGER PRIMARY KEY NOT NULL, + name VARCHAR(100) +); + +-- +-- Table: collection_object +-- +CREATE TABLE collection_object ( + collection INTEGER NOT NULL, + object INTEGER NOT NULL +); + +-- +-- Table: owners +-- +CREATE TABLE owners ( + ownerid INTEGER PRIMARY KEY NOT NULL, + name varchar(100) +); + +-- +-- Table: books +-- +CREATE TABLE books ( + id INTEGER PRIMARY KEY NOT NULL, + owner INTEGER, + source varchar(100), + title varchar(100) +); + + CREATE UNIQUE INDEX tktlnameunique_twokeytreelike on twokeytreelike (name); CREATE UNIQUE INDEX cd_artist_title_cd on cd (artist, title); CREATE UNIQUE INDEX track_cd_position_track on track (cd, position);