X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=741375deaa316db61dc33c9d1089756d97c51abb;hb=d815b6a502529d2ba0804d86d25e648d1a0f7631;hp=7478cb7c2bbdc94e5c28762fa507177d46a3dc4f;hpb=68888c09820ea25810c03cdc7748ee374a7772b2;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql index 7478cb7..741375d 100644 --- a/t/lib/sqlite.sql +++ b/t/lib/sqlite.sql @@ -1,6 +1,6 @@ -- -- Created by SQL::Translator::Producer::SQLite --- Created on Sun Mar 7 11:14:14 2010 +-- Created on Mon Mar 22 11:08:33 2010 -- ; @@ -47,7 +47,7 @@ CREATE TABLE encoded ( -- CREATE TABLE event ( id INTEGER PRIMARY KEY NOT NULL, - starts_at datetime NOT NULL, + starts_at date NOT NULL, created_on timestamp NOT NULL, varchar_date varchar(20), varchar_datetime varchar(20), @@ -169,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 (