X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=b3cef530478422bbabdf44fcde79078c6c6d8be3;hb=370f2ba2727791641c350a20e4fd09469503dbae;hp=6cd3abe6a47e385a3ef551c41e6d1c2487452ba7;hpb=80021def6067388536cbd7c7a9b8dcc08e82bc7b;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index 6cd3abe..b3cef53 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -1,15 +1,17 @@ -- -- Created by SQL::Translator::Producer::SQLite --- Created on Tue Mar 21 12:11:03 2006 +-- Created on Tue Aug 8 01:53:20 2006 -- BEGIN TRANSACTION; -- --- Table: employees_positioned +-- Table: employee -- -CREATE TABLE employees_positioned ( +CREATE TABLE employee ( employee_id INTEGER PRIMARY KEY NOT NULL, position integer NOT NULL, + group_id integer, + group_id_2 integer, name varchar(100) ); @@ -22,15 +24,6 @@ CREATE TABLE serialized ( ); -- --- Table: cd_to_producer --- -CREATE TABLE cd_to_producer ( - cd integer NOT NULL, - producer integer NOT NULL, - PRIMARY KEY (cd, producer) -); - --- -- Table: liner_notes -- CREATE TABLE liner_notes ( @@ -39,12 +32,12 @@ CREATE TABLE liner_notes ( ); -- --- Table: employees_adjacencylist +-- Table: cd_to_producer -- -CREATE TABLE employees_adjacencylist ( - employee_id INTEGER PRIMARY KEY NOT NULL, - parent_id integer, - name varchar(100) +CREATE TABLE cd_to_producer ( + cd integer NOT NULL, + producer integer NOT NULL, + PRIMARY KEY (cd, producer) ); -- @@ -56,13 +49,29 @@ CREATE TABLE artist ( ); -- --- Table: employees_positioned_adjacencylist +-- Table: twokeytreelike -- -CREATE TABLE employees_positioned_adjacencylist ( - employee_id INTEGER PRIMARY KEY NOT NULL, - parent_id integer, - position integer NOT NULL, - name varchar(100) +CREATE TABLE twokeytreelike ( + id1 integer NOT NULL, + id2 integer NOT NULL, + parent1 integer NOT NULL, + parent2 integer NOT NULL, + name varchar(100) NOT NULL, + PRIMARY KEY (id1, id2) +); + +-- +-- Table: fourkeys_to_twokeys +-- +CREATE TABLE fourkeys_to_twokeys ( + f_foo integer NOT NULL, + f_bar integer NOT NULL, + f_hello integer NOT NULL, + f_goodbye integer NOT NULL, + t_artist integer NOT NULL, + t_cd integer NOT NULL, + autopilot character NOT NULL, + PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd) ); -- @@ -81,7 +90,24 @@ CREATE TABLE cd ( cdid INTEGER PRIMARY KEY NOT NULL, artist integer NOT NULL, title varchar(100) NOT NULL, - year varchar(100) NOT NULL + year varchar(100) NOT NULL, + genreid integer +); + +-- +-- Table: genre +-- +CREATE TABLE genre ( + genreid INTEGER PRIMARY KEY NOT NULL, + name varchar(100) NOT NULL +); + +-- +-- Table: bookmark +-- +CREATE TABLE bookmark ( + id INTEGER PRIMARY KEY NOT NULL, + link integer NOT NULL ); -- @@ -91,19 +117,36 @@ CREATE TABLE track ( trackid INTEGER PRIMARY KEY NOT NULL, cd integer NOT NULL, position integer NOT NULL, - title varchar(100) NOT NULL + title varchar(100) NOT NULL, + last_updated_on datetime NULL ); -- --- Table: treelike +-- Table: self_ref -- -CREATE TABLE treelike ( +CREATE TABLE self_ref ( id INTEGER PRIMARY KEY NOT NULL, - parent integer NOT NULL, name varchar(100) NOT NULL ); -- +-- Table: link +-- +CREATE TABLE link ( + id INTEGER PRIMARY KEY NOT NULL, + url varchar(100), + title varchar(100) +); + +-- +-- Table: file_columns +-- +CREATE TABLE file_columns ( + id INTEGER PRIMARY KEY NOT NULL, + file varchar(255) +); + +-- -- Table: tags -- CREATE TABLE tags ( @@ -113,14 +156,24 @@ CREATE TABLE tags ( ); -- --- Table: self_ref +-- Table: treelike -- -CREATE TABLE self_ref ( +CREATE TABLE treelike ( id INTEGER PRIMARY KEY NOT NULL, + parent integer NULL, name varchar(100) NOT NULL ); -- +-- Table: event +-- +CREATE TABLE event ( + id INTEGER PRIMARY KEY NOT NULL, + starts_at datetime NOT NULL, + created_on timestamp NOT NULL +); + +-- -- Table: twokeys -- CREATE TABLE twokeys ( @@ -130,6 +183,15 @@ CREATE TABLE twokeys ( ); -- +-- Table: noprimarykey +-- +CREATE TABLE noprimarykey ( + foo integer NOT NULL, + bar integer NOT NULL, + baz integer NOT NULL +); + +-- -- Table: fourkeys -- CREATE TABLE fourkeys ( @@ -137,6 +199,7 @@ CREATE TABLE fourkeys ( bar integer NOT NULL, hello integer NOT NULL, goodbye integer NOT NULL, + sensors character NOT NULL, PRIMARY KEY (foo, bar, hello, goodbye) ); @@ -150,6 +213,14 @@ CREATE TABLE artist_undirected_map ( ); -- +-- Table: producer +-- +CREATE TABLE producer ( + producerid INTEGER PRIMARY KEY NOT NULL, + name varchar(100) NOT NULL +); + +-- -- Table: onekey -- CREATE TABLE onekey ( @@ -159,11 +230,53 @@ CREATE TABLE onekey ( ); -- --- Table: producer +-- Table: typed_object -- -CREATE TABLE producer ( - producerid INTEGER PRIMARY KEY NOT NULL, - name varchar(100) NOT NULL +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); +CREATE UNIQUE INDEX track_cd_title_track on track (cd, title); +CREATE UNIQUE INDEX foo_bar_noprimarykey on noprimarykey (foo, bar); +CREATE UNIQUE INDEX prod_name_producer on producer (name); COMMIT;