In this section, we will use the Tracking menu in Table view to start collecting the changes that occur for the author table. So we open the author table and then click on Tracking, which produces the following screen:

This panel tells us that we are about to create version 1 of the table; this is what we expected. We are offered a choice of data definition and data manipulation statements; for now we will leave all of them marked, and will click on Create version button. The next section explains how we can specify which statements are to appear in the panel shown above.

After version 1 is created, the following confirmation panel is shown:

We notice that two distinct actions took place:

Indeed, one or many versions of a table may exist, each one containing a snapshot from some point in time and the changes since this snapshot; but this is independent of the fact that tracking is active for a table and changes are being recorded.

In this panel, we see sub-panels that will be covered in the Choosing the statements to be tracked and Deactivating and activating tracking sections.

$cfg['Servers'][$i]['tracking_default_statements'] =
'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,' .
'CREATE INDEX,DROP INDEX,' .
'INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,' .
'CREATE VIEW,ALTER VIEW,DROP VIEW,' .
'CREATE DATABASE,ALTER DATABASE,DROP DATABASE';