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