X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=86c6c24f7e2f9b330c8182c908443e2e6349ae7f;hb=da69d72e86d9b5ad2ab509dcc199c5a2c7d76311;hp=91782638003979b3ce588ef6b1482693474c3377;hpb=e29e2b27d08d645f8a50d7ffafef28c67688207e;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index 9178263..86c6c24 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -1,6 +1,6 @@ -- -- Created by SQL::Translator::Producer::SQLite --- Created on Sun Oct 17 01:51:06 2010 +-- Created on Sat Jun 11 00:39:51 2011 -- -- @@ -26,7 +26,8 @@ CREATE TABLE bindtype_test ( id INTEGER PRIMARY KEY NOT NULL, bytea blob, blob blob, - clob clob + clob clob, + a_memo memo ); -- @@ -59,14 +60,6 @@ CREATE TABLE event ( ); -- --- Table: file_columns --- -CREATE TABLE file_columns ( - id INTEGER PRIMARY KEY NOT NULL, - file varchar(255) NOT NULL -); - --- -- Table: fourkeys -- CREATE TABLE fourkeys ( @@ -75,7 +68,7 @@ CREATE TABLE fourkeys ( hello integer NOT NULL, goodbye integer NOT NULL, sensors character(10) NOT NULL, - read_count integer, + read_count int, PRIMARY KEY (foo, bar, hello, goodbye) ); @@ -298,8 +291,7 @@ CREATE TABLE track ( position int NOT NULL, title varchar(100) NOT NULL, last_updated_on datetime, - last_updated_at datetime, - small_dt smalldatetime + last_updated_at datetime ); CREATE INDEX track_idx_cd ON track (cd);