X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=741375deaa316db61dc33c9d1089756d97c51abb;hb=2373739375a4e798158a5d483d9b9264fa9c0c71;hp=ba1ffae6d7ea70477fd83cfa00a88ae1eedef4b8;hpb=6f546d659c5f4207286d0be33f15ce237b9968b9;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index ba1ffae..741375d 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -1,7 +1,8 @@ -- -- Created by SQL::Translator::Producer::SQLite --- Created on Tue Mar 16 16:49:23 2010 +-- Created on Mon Mar 22 11:08:33 2010 -- +; -- -- Table: artist @@ -168,6 +169,14 @@ CREATE TABLE serialized ( ); -- +-- Table: timestamp_primary_key_test +-- +CREATE TABLE timestamp_primary_key_test ( + id timestamp NOT NULL DEFAULT current_timestamp, + PRIMARY KEY (id) +); + +-- -- Table: treelike -- CREATE TABLE treelike ( @@ -447,4 +456,4 @@ CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd ON fourkeys_to_twokeys (t_art -- View: year2000cds -- CREATE VIEW year2000cds AS - SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000"; + SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000" \ No newline at end of file