X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=2ce5dadf4b27cb5334bac513ade8041a384b60f3;hb=78060df8cb43cafd81304f386d7111510a4b8f9d;hp=fd50c362dc40fd21dbea55c0ccfcbb3183dec6d8;hpb=89034887963b728f979ec9185350061a827db7af;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index fd50c36..2ce5dad 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -1,6 +1,6 @@ -- -- Created by SQL::Translator::Producer::SQLite --- Created on Sun Jul 23 00:23:30 2006 +-- Created on Tue Aug 8 01:53:20 2006 -- BEGIN TRANSACTION; @@ -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);