1
2
3
4
5
6
7

CREATE TABLE `log_components` (
  `action_id` int(10) unsigned NOT NULL,
  `component` varchar(245) CHARACTER SET ascii NOT NULL,
  `old_value` varbinary(255) NOT NULL,
  `new_value` varbinary(255) NOT NULL,
  PRIMARY KEY (`action_id`,`component`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `log_components` ( `action_id` int(10) unsigned NOT NULL, `component` varchar(245) CHARACTER SET ascii NOT NULL, `old_value` varbinary(255) NOT NULL, `new_value` varbinary(255) NOT NULL, PRIMARY KEY (`action_id`,`component`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1