' . "\n";
echo ' ' . "\n";
echo '';
echo sprintf('
| %s |
|
|
%s |
',
$strName,
$strType);
$ct=0;
$delimiter = '//';
foreach ($events as $event) {
// information_schema (at least in MySQL 5.1.22) does not return
// the full CREATE EVENT statement in a way that could be useful for us
// so we rely on PMA_DBI_get_definition() which uses SHOW CREATE EVENT
$definition = 'DROP EVENT ' . PMA_backquote($event['EVENT_NAME']) . $delimiter . "\n"
. PMA_DBI_get_definition($db, 'EVENT', $event['EVENT_NAME'])
. "\n";
$sqlDrop = 'DROP EVENT ' . PMA_backquote($event['EVENT_NAME']);
echo sprintf('
| %s |
%s |
%s |
%s |
',
($ct%2 == 0) ? 'even' : 'odd',
$event['EVENT_NAME'],
! empty($definition) ? PMA_linkOrButton('db_sql.php?' . $url_query . '&sql_query=' . urlencode($definition) . '&show_query=1&delimiter=' . urlencode($delimiter), $titles['Structure']) : ' ',
'' . $titles['Drop'] . '',
$event['EVENT_TYPE']);
$ct++;
}
echo '
';
echo '' . "\n";
echo '' . "\n";
}
?>