-- ----------------------------------------------------------------
-- create mc_control_audit
-- ----------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `mc_control_audit` (
`id` int(10) unsigned NOT NULL auto_increment,
`control_id` int(10) unsigned NOT NULL,
`control_name` VARCHAR(64) NULL,
`action` VARCHAR(12) NOT NULL,
`user` VARCHAR(12) NULL,
`system` VARCHAR(8) NULL,
`client` VARCHAR(3) NULL,
`field` VARCHAR(50) NULL,
`value_old` text NULL,
`value_new` text NULL,
`timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY  (`id`));