Exporting a version
As the complete SQL code at the time of creation for a specific version has been stored along with all of the tracked statements that occurred since that moment, we might want to reuse them in their executable form. At the bottom of the Tracking report panel, an Export as dialog is available, offering three variants for exporting. If we choose SQL dump (file download) menu option, then all of the statements stored for this version are transferred in a file that we can save to our workstation. For the author
table, this would produce a file containing the following lines:
# Tracking report for table `author` # 2011-10-14 14:24:12 DROP TABLE IF EXISTS `author`; CREATE TABLE `author` ( `id` int(11) NOT NULL, `name` varchar(30) NOT NULL, `phone` varchar(30) CHARACTER SET latin1 DEFAULT NULL, `country_code` char(2) NOT NULL, `total_page_count` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `author` CHANGE `name` `name` VARCHAR...