· 8 years ago · May 26, 2018, 11:32 PM
1CREATE TABLE IF NOT EXISTS `pma__tracking` (
2 `db_name` varchar(64) NOT NULL,
3 `table_name` varchar(64) NOT NULL,
4 `version` int(10) unsigned NOT NULL,
5 `date_created` datetime NOT NULL,
6 `date_updated` datetime NOT NULL,
7 `schema_snapshot` text NOT NULL,
8 `schema_sql` text,
9 `data_sql` longtext,
10 `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') default NULL,
11 `tracking_active` int(1) unsigned NOT NULL default '1',
12 PRIMARY KEY (`db_name`,`table_name`,`version`)
13)
14 COMMENT='Database changes tracking for phpMyAdmin'
15 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;