Zend Log MySQL CREATE TABLE query for Zend Framework 1 or 2

gistfile1.sql

CREATE TABLE `log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `priority` tinyint(1) NOT NULL,
  `priorityName` varchar(5) CHARACTER SET ascii NOT NULL DEFAULT 'DEBUG',
  `message` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;