Add extra test blob type

[dbsrgits/DBIx-Class.git] / t / lib / sqlite.sql

diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql
index e53bb23..b14bd5e 100644 (file)
--- a/t/lib/sqlite.sql
+++ b/t/lib/sqlite.sql
@@ -1,6 +1,6 @@
 -- 
 -- Created by SQL::Translator::Producer::SQLite
--- Created on Sat Oct 16 16:17:01 2010
+-- Created on Mon Feb 21 12:10:04 2011
 -- 
 
 --
@@ -17,6 +17,8 @@ CREATE INDEX artist_name_hookidx ON artist (name);
 
 CREATE UNIQUE INDEX artist_name ON artist (name);
 
+CREATE UNIQUE INDEX u_nullable ON artist (charfield, rank);
+
 --
 -- Table: bindtype_test
 --
@@ -24,7 +26,8 @@ CREATE TABLE bindtype_test (
   id INTEGER PRIMARY KEY NOT NULL,
   bytea blob,
   blob blob,
-  clob clob
+  clob clob,
+  a_memo memo
 );
 
 --
@@ -296,8 +299,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);