use Test::More;
use Test::SQL::Translator;
use Test::Exception;
+use Test::Differences;
use Data::Dumper;
use SQL::Translator;
use SQL::Translator::Schema::Constants;
# 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,
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