Databases Reference
In-Depth Information
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.
Choosing the statements to be tracked
$cfg['Servers'][$i]['tracking_default_statements'] contains a string that
consists of comma-separated statements. These are the ones that are offered in the
panel where we can choose which statements we want to track. The default list
of statements is defined as follows; please note the presence of dot characters that
permit the concatenation of strings in PHP:
$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';
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:
 
Search WWH ::




Custom Search