X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=163a4d8d7358d997f565830f928d3f157df60255;hb=8273e845426f0187b4ad6c4a1b42286fa09a648f;hp=e53bb23b9193a97b936569e4ccb9202d219c8054;hpb=84f7e8a1c6303091d753572648e37d3bd7270181;p=dbsrgits%2FDBIx-Class.git

diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql
index e53bb23..163a4d8 100644
--- a/t/lib/sqlite.sql
+++ b/t/lib/sqlite.sql
@@ -1,7 +1,7 @@
--- 
+--
 -- Created by SQL::Translator::Producer::SQLite
--- Created on Sat Oct 16 16:17:01 2010
--- 
+-- Created on Sat Jun 11 00:39:51 2011
+--
 
 --
 -- Table: artist
@@ -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
 );
 
 --
@@ -57,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 (
@@ -73,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)
 );
 
@@ -296,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);