'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');
filename => $xmlfile,
) or die $sqlt->error;
-eq_or_diff(\@sql,
+eq_or_diff(\@sql,
[
'BEGIN TRANSACTION',
q<DROP 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')
)>,
q<CREATE INDEX 'titleindex' ON 'Basic' ('title')>,
q<CREATE UNIQUE INDEX 'emailuniqueindex' ON 'Basic' ('email')>,