X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F48xml-to-sqlite.t;h=9b8734eeff7a90ce92bf7482721b8dc8c4138806;hb=1c680eb9aac43c469260f89be06027951722402e;hp=fd05ad452878c77fa0942bad903b0645d4897eca;hpb=08d91aada45b94a16f3660b5cc10384df5616ff9;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/48xml-to-sqlite.t b/t/48xml-to-sqlite.t
index fd05ad4..9b8734e 100644
--- a/t/48xml-to-sqlite.t
+++ b/t/48xml-to-sqlite.t
@@ -5,6 +5,7 @@ use FindBin qw/$Bin/;
 use Test::More;
 use Test::SQL::Translator;
 use Test::Exception;
+use Test::Differences;
 use Data::Dumper;
 use SQL::Translator;
 use SQL::Translator::Schema::Constants;
@@ -34,13 +35,10 @@ my $sql = $sqlt->translate(
 
 # print ">>$sql<<\n";
 
-is($sql, << "SQL");
+eq_or_diff($sql, << "SQL");
 BEGIN TRANSACTION;
 
 
---
--- Table: Basic
---
 DROP TABLE Basic;
 CREATE TABLE Basic (
   id INTEGER PRIMARY KEY NOT NULL,
@@ -51,11 +49,18 @@ CREATE TABLE Basic (
   explicitemptystring varchar DEFAULT '',
   -- Hello emptytagdef
   emptytagdef varchar DEFAULT '',
+  another_id int(10) DEFAULT '2',
   timest timestamp
 );
 
-CREATE INDEX titleindex_Basic on Basic (title);
-CREATE UNIQUE INDEX emailuniqueindex_Basic on Basic (email);
+CREATE INDEX titleindex_Basic ON Basic (title);
+CREATE UNIQUE INDEX emailuniqueindex_Basic ON Basic (email);
+
+DROP TABLE Another;
+CREATE TABLE Another (
+  id INTEGER PRIMARY KEY NOT NULL
+);
+
 
 COMMIT;
 SQL