X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F48xml-to-sqlite.t;h=c567bbc1696af35add6ec8053d9c32724d33112e;hb=ea4a3ecc5de1c8f062fef3bab51e1cc7a2c23235;hp=950234813052dba9ac346ffca65cc11de8e6349d;hpb=d8cf2279bd5e25db979d6251c5648d69fc5a298d;p=dbsrgits%2FSQL-Translator.git diff --git a/t/48xml-to-sqlite.t b/t/48xml-to-sqlite.t index 9502348..c567bbc 100644 --- a/t/48xml-to-sqlite.t +++ b/t/48xml-to-sqlite.t @@ -49,7 +49,7 @@ CREATE TABLE 'Basic' ( 'emptytagdef' varchar DEFAULT '', 'another_id' int(10) DEFAULT 2, 'timest' timestamp, - FOREIGN KEY('another_id') REFERENCES 'Another'() + FOREIGN KEY ('another_id') REFERENCES 'Another'('id') ); CREATE INDEX 'titleindex' ON 'Basic' ('title'); @@ -92,7 +92,7 @@ my @sql = $sqlt->translate( filename => $xmlfile, ) or die $sqlt->error; -eq_or_diff(\@sql, +eq_or_diff(\@sql, [ 'BEGIN TRANSACTION', q, @@ -107,7 +107,7 @@ eq_or_diff(\@sql, 'emptytagdef' varchar DEFAULT '', 'another_id' int(10) DEFAULT 2, 'timest' timestamp, - FOREIGN KEY('another_id') REFERENCES 'Another'() + FOREIGN KEY ('another_id') REFERENCES 'Another'('id') )>, q, q,