public function testDiff()
{
$sql = "\nCREATE TABLE `album`\n(\n `id` INTEGER NOT NULL AUTO_INCREMENT,\n `id_artist` INTEGER default 0 NOT NULL,\n `name` VARCHAR(255) default '',\n `type` VARCHAR(16) default 'empty' NOT NULL,\n PRIMARY KEY (`id`),\n KEY `id_artist`(`id_artist`),\n CONSTRAINT `album_FK_1`\n FOREIGN KEY (`id_artist`)\n REFERENCES `artist` (`id`)\n ON UPDATE CASCADE\n ON DELETE CASCADE\n)Type=innoDB;\n ";
$i = new dbInfo();
$i->getTableInfoFromCreate($sql);
$this->assertEqual($i->getDiffWith($i), '');
}