Testing the tracking mechanism
We are now ready to verify that this tracking system really works! As the system is supposed to track ALTER TABLE
statement, we will make a slight structure change and see what happens. We go to the Structure panel for table author, select the name column, and increase its size from 30 to 40 characters (refer to Chapter 5 for the detailed steps).
We get a message, as shown in the following screenshot:
We will perform another action, this time related to data itself—changing the phone number of author John Smith to 111-2222.
To ensure that these actions were recorded by the tracking system, let us compile a report.
Tracking report
Going back to the Tracking panel (still in Table
view for author) we click on Tracking report for version 1, which produces a report as shown in the following screenshot:
In fact, the report is prefixed to the main tracking information; we could click on Close and be back to where we were previously.
We can see that under the Tracking report...