X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2Fsqlite.sql;h=9d4921041b2f86717c2eb4985cd75164ea1d265e;hb=86bb5a27da;hp=b14bd5edd980244cc032ebdf7c300706a1d33425;hpb=f3a9ea3d41f4d32346bc5ea7ce83a7dcfe45b118;p=dbsrgits%2FDBIx-Class.git

diff --git a/t/lib/sqlite.sql b/t/lib/sqlite.sql
index b14bd5e..9d49210 100644
--- a/t/lib/sqlite.sql
+++ b/t/lib/sqlite.sql
@@ -1,6 +1,6 @@
 -- 
 -- Created by SQL::Translator::Producer::SQLite
--- Created on Mon Feb 21 12:10:04 2011
+-- Created on Fri Mar  2 18:22:33 2012
 -- 
 
 --
@@ -60,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 (
@@ -76,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)
 );
 
@@ -135,6 +127,8 @@ CREATE TABLE owners (
   name varchar(100) NOT NULL
 );
 
+CREATE UNIQUE INDEX owners_name ON owners (name);
+
 --
 -- Table: producer
 --