X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=20b8e5aa351378afdc08e8925ac96eee44140ef6;hb=22d6d8e1a55e0bf7f9d64545afa97c582a6f754e;hp=f10949321bca9d1a9c78f3a6f272ee0c8fdbef28;hpb=eb0bc670a8a144695c757cddab22920abaede088;p=dbsrgits%2FDBIx-Class.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index f109493..20b8e5a 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -1,6 +1,6 @@ -- -- Created by SQL::Translator::Producer::SQLite --- Created on Sat Jun 27 14:02:39 2009 +-- Created on Thu Jul 30 09:37:43 2009 -- @@ -63,7 +63,8 @@ CREATE TABLE event ( created_on timestamp NOT NULL, varchar_date varchar(20), varchar_datetime varchar(20), - skip_inflation datetime + skip_inflation datetime, + ts_without_tz datetime ); -- @@ -107,6 +108,14 @@ CREATE TABLE link ( ); -- +-- Table: money_test +-- +CREATE TABLE money_test ( + id INTEGER PRIMARY KEY NOT NULL, + amount money +); + +-- -- Table: noprimarykey -- CREATE TABLE noprimarykey ( @@ -225,7 +234,7 @@ CREATE INDEX artist_undirected_map_idx_id2 ON artist_undirected_map (id2); -- CREATE TABLE bookmark ( id INTEGER PRIMARY KEY NOT NULL, - link integer NOT NULL + link integer ); CREATE INDEX bookmark_idx_link ON bookmark (link); @@ -275,7 +284,8 @@ CREATE TABLE track ( position integer NOT NULL, title varchar(100) NOT NULL, last_updated_on datetime, - last_updated_at datetime + last_updated_at datetime, + small_dt smalldatetime ); CREATE INDEX track_idx_cd ON track (cd);