Translation update done using Pootle.
[phpmyadmin-themes.git] / tbl_tracking.php
blobf43bbcf7584838c24d95e27012485d170786d064
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
5 * @version $Id$
6 * @package phpMyAdmin
7 */
9 // Run common work
10 require_once './libraries/common.inc.php';
11 require_once './libraries/Table.class.php';
13 define('TABLE_MAY_BE_ABSENT', true);
14 require './libraries/tbl_common.php';
15 $url_query .= '&amp;goto=tbl_tracking.php&amp;back=tbl_tracking.php';
16 $url_params['goto'] = 'tbl_tracking.php';;
17 $url_params['back'] = 'tbl_tracking.php';
19 // Get relation settings
20 require_once './libraries/relation.lib.php';
22 // Init vars for tracking report
23 if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
24 $data = PMA_Tracker::getTrackedData($_REQUEST['db'], $_REQUEST['table'], $_REQUEST['version']);
26 $selection_schema = false;
27 $selection_data = false;
28 $selection_both = false;
30 if (! isset($_REQUEST['logtype'])) {
31 $_REQUEST['logtype'] = 'schema_and_data';
33 if ($_REQUEST['logtype'] == 'schema') {
34 $selection_schema = true;
35 } elseif($_REQUEST['logtype'] == 'data') {
36 $selection_data = true;
37 } else {
38 $selection_both = true;
40 if (! isset($_REQUEST['date_from'])) {
41 $_REQUEST['date_from'] = $data['date_from'];
43 if (! isset($_REQUEST['date_to'])) {
44 $_REQUEST['date_to'] = $data['date_to'];
46 if (! isset($_REQUEST['users'])) {
47 $_REQUEST['users'] = '*';
49 $filter_ts_from = strtotime($_REQUEST['date_from']);
50 $filter_ts_to = strtotime($_REQUEST['date_to']);
51 $filter_users = array_map('trim', explode(',', $_REQUEST['users']));
54 // Prepare export
55 if (isset($_REQUEST['report_export'])) {
57 /**
58 * Filters tracking entries
60 * @param array the entries to filter
61 * @param string "from" date
62 * @param string "to" date
63 * @param string users
65 * @return array filtered entries
68 function PMA_filter_tracking($data, $filter_ts_from, $filter_ts_to, $filter_users) {
69 $tmp_entries = array();
70 $id = 0;
71 foreach( $data as $entry ) {
72 $timestamp = strtotime($entry['date']);
74 if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&
75 ( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {
76 $tmp_entries[] = array( 'id' => $id,
77 'timestamp' => $timestamp,
78 'username' => $entry['username'],
79 'statement' => $entry['statement']
82 $id++;
84 return($tmp_entries);
87 $entries = array();
88 // Filtering data definition statements
89 if ($_REQUEST['logtype'] == 'schema' || $_REQUEST['logtype'] == 'schema_and_data') {
90 $entries = array_merge($entries, PMA_filter_tracking($data['ddlog'], $filter_ts_from, $filter_ts_to, $filter_users));
93 // Filtering data manipulation statements
94 if ($_REQUEST['logtype'] == 'data' || $_REQUEST['logtype'] == 'schema_and_data') {
95 $entries = array_merge($entries, PMA_filter_tracking($data['dmlog'], $filter_ts_from, $filter_ts_to, $filter_users));
98 // Sort it
99 foreach ($entries as $key => $row) {
100 $ids[$key] = $row['id'];
101 $timestamps[$key] = $row['timestamp'];
102 $usernames[$key] = $row['username'];
103 $statements[$key] = $row['statement'];
106 array_multisort($timestamps, SORT_ASC, $ids, SORT_ASC, $usernames, SORT_ASC, $statements, SORT_ASC, $entries);
110 // Export as file download
111 if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'sqldumpfile') {
112 @ini_set('url_rewriter.tags','');
114 $dump = "# " . sprintf($strTrackingReportForTable, htmlspecialchars($_REQUEST['table'])) . "\n" .
115 "# " . date('Y-m-d H:i:s') . "\n";
116 foreach($entries as $entry) {
117 $dump .= $entry['statement'];
119 $filename = 'log_' . htmlspecialchars($_REQUEST['table']) . '.sql';
120 header('Content-Type: text/x-sql');
121 header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
122 header('Content-Disposition: attachment; filename="' . $filename . '"');
123 if (PMA_USR_BROWSER_AGENT == 'IE') {
124 header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
125 header('Pragma: public');
126 } else {
127 header('Pragma: no-cache');
128 header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
131 echo $dump;
132 exit();
137 * Gets tables informations
141 * Displays top menu links
143 require_once './libraries/tbl_links.inc.php';
144 echo '<br />';
147 * Actions
150 // Create tracking version
151 if (isset($_REQUEST['submit_create_version'])) {
152 $tracking_set = '';
154 if ($_REQUEST['alter_table'] == true) {
155 $tracking_set .= 'ALTER TABLE,';
157 if ($_REQUEST['rename_table'] == true) {
158 $tracking_set .= 'RENAME TABLE,';
160 if ($_REQUEST['create_table'] == true) {
161 $tracking_set .= 'CREATE TABLE,';
163 if ($_REQUEST['drop_table'] == true) {
164 $tracking_set .= 'DROP TABLE,';
166 if ($_REQUEST['create_index'] == true) {
167 $tracking_set .= 'CREATE INDEX,';
169 if ($_REQUEST['drop_index'] == true) {
170 $tracking_set .= 'DROP INDEX,';
172 if ($_REQUEST['insert'] == true) {
173 $tracking_set .= 'INSERT,';
175 if ($_REQUEST['update'] == true) {
176 $tracking_set .= 'UPDATE,';
178 if ($_REQUEST['delete'] == true) {
179 $tracking_set .= 'DELETE,';
181 if ($_REQUEST['truncate'] == true) {
182 $tracking_set .= 'TRUNCATE,';
184 $tracking_set = rtrim($tracking_set, ',');
186 if (PMA_Tracker::createVersion($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'], $tracking_set )) {
187 $msg = PMA_Message::success(sprintf($strTrackingVersionCreated, $_REQUEST['version'], $GLOBALS['db'], $GLOBALS['table']));
188 $msg->display();
192 // Deactivate tracking
193 if (isset($_REQUEST['submit_deactivate_now'])) {
194 if (PMA_Tracker::deactivateTracking($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'])) {
195 $msg = PMA_Message::success(sprintf($strTrackingVersionDeactivated, $GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version']));
196 $msg->display();
200 // Activate tracking
201 if (isset($_REQUEST['submit_activate_now'])) {
202 if (PMA_Tracker::activateTracking($GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version'])) {
203 $msg = PMA_Message::success(sprintf($strTrackingVersionActivated, $GLOBALS['db'], $GLOBALS['table'], $_REQUEST['version']));
204 $msg->display();
208 // Export as SQL execution
209 if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'execution') {
210 foreach($entries as $entry) {
211 $sql_result = PMA_DBI_query( "/*NOTRACK*/\n" . $entry['statement'] );
213 $msg = PMA_Message::success($strTrackingSQLExecuted);
214 $msg->display();
217 // Export as SQL dump
218 if (isset($_REQUEST['report_export']) && $_REQUEST['export_type'] == 'sqldump')
220 $new_query = "# " . $strTrackingYouCanExecute . "\n" .
221 "# " . $strTrackingCommentOut . "\n" .
222 "\n" .
223 "CREATE database IF NOT EXISTS pma_temp_db; \n" .
224 "USE pma_temp_db; \n" .
225 "\n";
227 foreach($entries as $entry) {
228 $new_query .= $entry['statement'];
230 $msg = PMA_Message::success($strTrackingSQLExported);
231 $msg->display();
233 $db_temp = $db;
234 $table_temp = $table;
236 $db = $table = '';
237 $GLOBALS['js_include'][] = 'functions.js';
238 require_once './libraries/sql_query_form.lib.php';
240 PMA_sqlQueryForm($new_query, 'sql');
242 $db = $db_temp;
243 $table = $table_temp;
247 * Schema snapshot
249 if (isset($_REQUEST['snapshot'])) {
251 <h3><?php echo $strTrackingStructureSnapshot;?> [<a href="tbl_tracking.php?<?php echo $url_query;?>"><?php echo $strTrackingReportClose;?></a>]</h3>
252 <?php
253 $data = PMA_Tracker::getTrackedData($_REQUEST['db'], $_REQUEST['table'], $_REQUEST['version']);
255 // Get first DROP TABLE and CREATE TABLE statements
256 $drop_create_statements = $data['ddlog'][0]['statement'];
258 if (strstr($data['ddlog'][0]['statement'], 'DROP TABLE')) {
259 $drop_create_statements .= $data['ddlog'][1]['statement'];
261 // Print SQL code
262 PMA_showMessage(sprintf($strTrackingVersionSnapshotSQL, $_REQUEST['version']), $drop_create_statements);
264 // Unserialize snapshot
265 $temp = unserialize($data['schema_snapshot']);
266 $columns = $temp['COLUMNS'];
267 $indexes = $temp['INDEXES'];
269 <h3><?php echo $strStructure;?></h3>
270 <table id="tablestructure" class="data">
271 <thead>
272 <tr>
273 <th><?php echo $strField; ?></th>
274 <th><?php echo $strType; ?></th>
275 <th><?php echo $strCollation; ?></th>
276 <th><?php echo $strNull; ?></th>
277 <th><?php echo $strDefault; ?></th>
278 <th><?php echo $strExtra; ?></th>
279 <th><?php echo $strComment; ?></th>
280 </tr>
281 </thead>
282 <tbody>
283 <?php
284 $style = 'odd';
285 foreach($columns as $field_index => $field) {
287 <tr class="<?php echo $style; ?>">
288 <?php
289 if ($field['Key'] == 'PRI') {
290 echo '<td><b><u>' . $field['Field'] . '</u></b></td>' . "\n";
291 } else {
292 echo '<td><b>' . $field['Field'] . '</b></td>' . "\n";
295 <td><?php echo $field['Type'];?></td>
296 <td><?php echo $field['Collation'];?></td>
297 <td><?php echo $field['Null'];?></td>
298 <td><?php echo $field['Default'];?></td>
299 <td><?php echo $field['Extra'];?></td>
300 <td><?php echo $field['Comment'];?></td>
301 </tr>
302 <?php
303 if ($style == 'even') {
304 $style = 'odd';
305 } else {
306 $style = 'even';
310 </tbody>
311 </table>
313 <?php
314 if (count($indexes) > 0) {
316 <h3><?php echo $strIndexes;?></h3>
317 <table id="tablestructure_indexes" class="data">
318 <thead>
319 <tr>
320 <th><?php echo $strKeyname;?></th>
321 <th><?php echo $strType;?></th>
322 <th><?php echo $strUnique;?></th>
323 <th><?php echo $strPacked;?></th>
324 <th><?php echo $strField;?></th>
325 <th><?php echo $strCardinality;?></th>
326 <th><?php echo $strCollation;?></th>
327 <th><?php echo $strNull;?></th>
328 <th><?php echo $strComment;?></th>
329 </tr>
330 <tbody>
331 <?php
332 $style = 'odd';
333 foreach ($indexes as $indexes_index => $index) {
334 if ($index['Non_unique'] == 0) {
335 $str_unique = $strYes;
336 } else {
337 $str_unique = $strNo;
339 if ($index['Packed'] != '') {
340 $str_packed = $strYes;
341 } else {
342 $str_packed = $strNo;
345 <tr class="<?php echo $style; ?>">
346 <td><b><?php echo $index['Key_name'];?></b></td>
347 <td><?php echo $index['Index_type'];?></td>
348 <td><?php echo $str_unique;?></td>
349 <td><?php echo $str_packed;?></td>
350 <td><?php echo $index['Column_name'];?></td>
351 <td><?php echo $index['Cardinality'];?></td>
352 <td><?php echo $index['Collation'];?></td>
353 <td><?php echo $index['Null'];?></td>
354 <td><?php echo $index['Comment'];?></td>
355 </tr>
356 <?php
357 if ($style == 'even') {
358 $style = 'odd';
359 } else {
360 $style = 'even';
364 </tbody>
365 </table>
366 <?php
367 } // endif
369 <br /><hr /><br />
370 <?php
372 // end of snapshot report
375 * Tracking report
377 if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
379 <h3><?php echo $strTrackingReport;?> [<a href="tbl_tracking.php?<?php echo $url_query;?>"><?php echo $strTrackingReportClose;?></a>]</h3>
381 <small><?php echo $strTrackingStatements . ' ' . $data['tracking']; ?></small><br/>
382 <br/>
384 <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>&amp;report=true&amp;version=<?php echo $_REQUEST['version'];?>">
385 <?php
387 $str1 = '<select name="logtype">' .
388 '<option value="schema"' . ($selection_schema ? ' selected="selected"' : '') . '>' . $strStrucOnly . '</option>' .
389 '<option value="data"' . ($selection_data ? ' selected="selected"' : ''). '>' . $strDataOnly . '</option>' .
390 '<option value="schema_and_data"' . ($selection_both ? ' selected="selected"' : '') . '>' . $strStrucData . '</option>' .
391 '</select>';
392 $str2 = '<input type="text" name="date_from" value="' . $_REQUEST['date_from'] . '" size="19" />';
393 $str3 = '<input type="text" name="date_to" value="' . $_REQUEST['date_to'] . '" size="19" />';
394 $str4 = '<input type="text" name="users" value="' . $_REQUEST['users'] . '" />';
395 $str5 = '<input type="submit" name="list_report" value="' . $strGo . '" />';
397 printf($strTrackingShowLogDateUsers, $str1, $str2, $str3, $str4, $str5);
401 * First, list tracked data definition statements
403 $i = 1;
404 if ($selection_schema || $selection_both ) {
406 <table id="ddl_versions" class="data" width="100%">
407 <thead>
408 <tr>
409 <th width="18">#</th>
410 <th width="100"><?php echo $strTrackingDate;?></th>
411 <th width="60"><?php echo $strTrackingUsername;?></th>
412 <th><?php echo $strTrackingDataDefinitionStatement;?></th>
413 </tr>
414 </thead>
415 <tbody>
416 <?php
417 $style = 'odd';
418 foreach ($data['ddlog'] as $entry) {
419 $parsed_sql = PMA_SQP_parse($entry['statement']);
420 $statement = PMA_formatSql($parsed_sql);
421 $timestamp = strtotime($entry['date']);
423 if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&
424 ( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {
426 <tr class="<?php echo $style; ?>">
427 <td><small><?php echo $i;?></small></td>
428 <td><small><?php echo $entry['date'];?></small></td>
429 <td><small><?php echo $entry['username']; ?></small></td>
430 <td><?php echo $statement; ?></td>
431 </tr>
432 <?php
433 if ($style == 'even') {
434 $style = 'odd';
435 } else {
436 $style = 'even';
438 $i++;
442 </tbody>
443 </table>
444 <?php
446 } //endif
449 * Secondly, list tracked data manipulation statements
452 if (($selection_data || $selection_both) && count($data['dmlog']) > 0) {
454 <table id="dml_versions" class="data" width="100%">
455 <thead>
456 <tr>
457 <th width="18">#</th>
458 <th width="100"><?php echo $strTrackingDate;?></th>
459 <th width="60"><?php echo $strTrackingUsername;?></th>
460 <th><?php echo $strTrackingDataManipulationStatement;?></th>
461 </tr>
462 </thead>
463 <tbody>
464 <?php
465 $style = 'odd';
466 foreach ($data['dmlog'] as $entry) {
467 $parsed_sql = PMA_SQP_parse($entry['statement']);
468 $statement = PMA_formatSql($parsed_sql);
469 $timestamp = strtotime($entry['date']);
471 if ($timestamp >= $filter_ts_from && $timestamp <= $filter_ts_to &&
472 ( in_array('*', $filter_users) || in_array($entry['username'], $filter_users) ) ) {
474 <tr class="<?php echo $style; ?>">
475 <td><small><?php echo $i; ?></small></td>
476 <td><small><?php echo $entry['date']; ?></small></td>
477 <td><small><?php echo $entry['username']; ?></small></td>
478 <td><?php echo $statement; ?></td>
479 </tr>
480 <?php
481 if ($style == 'even') {
482 $style = 'odd';
483 } else {
484 $style = 'even';
486 $i++;
490 </tbody>
491 </table>
492 <?php
495 </form>
496 <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>&amp;report=true&amp;version=<?php echo $_REQUEST['version'];?>">
497 <?php
498 printf($strTrackingShowLogDateUsers, $str1, $str2, $str3, $str4, $str5);
500 $str_export1 = '<select name="export_type">' .
501 '<option value="sqldumpfile">' . $strTrackingSQLDumpFile . '</option>' .
502 '<option value="sqldump">' . $strTrackingSQLDump . '</option>' .
503 '<option value="execution" onclick="alert(\'' . $strTrackingSQLExecutionAlert .'\')">' . $strTrackingSQLExecution . '</option>' .
504 '</select>';
506 $str_export2 = '<input type="submit" name="report_export" value="' . $strGo .'" />';
508 </form>
509 <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>&amp;report=true&amp;version=<?php echo $_REQUEST['version'];?>">
510 <input type="hidden" name="logtype" value="<?php echo $_REQUEST['logtype'];?>" />
511 <input type="hidden" name="date_from" value="<?php echo $_REQUEST['date_from'];?>" />
512 <input type="hidden" name="date_to" value="<?php echo $_REQUEST['date_to'];?>" />
513 <input type="hidden" name="users" value="<?php echo $_REQUEST['users'];?>" />
514 <?php
515 echo "<br/>" . sprintf($strTrackingExportAs, $str_export1) . $str_export2 . "<br/>";
517 </form>
518 <?php
519 echo "<br/><br/><hr/><br/>\n";
520 } // end of report
524 * List selectable tables
527 $sql_query = " SELECT DISTINCT db_name, table_name FROM " .
528 PMA_backquote($GLOBALS['cfg']['Server']['pmadb']) . "." .
529 PMA_backquote($GLOBALS['cfg']['Server']['tracking']) .
530 " WHERE " . PMA_backquote('db_name') . " = '" . PMA_sqlAddslashes($GLOBALS['db']) . "' " .
531 " ORDER BY ". PMA_backquote('db_name') . ", " . PMA_backquote('table_name');
533 $sql_result = PMA_query_as_controluser($sql_query);
535 if (PMA_DBI_num_rows($sql_result) > 0) {
537 <form method="post" action="tbl_tracking.php?<?php echo $url_query;?>">
538 <select name="table">
539 <?php
540 while ($entries = PMA_DBI_fetch_array($sql_result)) {
541 if (PMA_Tracker::isTracked($entries['db_name'], $entries['table_name'])) {
542 $status = ' (' . $strTrackingStatusActive . ')';
543 } else {
544 $status = ' (' . $strTrackingStatusNotActive . ')';
546 if ($entries['table_name'] == $_REQUEST['table']) {
547 $s = ' selected="selected"';
548 } else {
549 $s = '';
551 echo '<option value="' . htmlspecialchars($entries['table_name']) . '"' . $s . '>' . htmlspecialchars($entries['db_name']) . ' . ' . htmlspecialchars($entries['table_name']) . $status . '</option>' . "\n";
554 </select>
555 <input type="submit" name="show_versions_submit" value="<?php echo $strTrackingShowVersions;?>" />
556 </form>
557 <?php
560 <br />
561 <?php
564 * List versions of current table
567 $sql_query = " SELECT * FROM " .
568 PMA_backquote($GLOBALS['cfg']['Server']['pmadb']) . "." .
569 PMA_backquote($GLOBALS['cfg']['Server']['tracking']) .
570 " WHERE " . PMA_backquote('db_name') . " = '" . PMA_sqlAddslashes($_REQUEST['db']) . "' ".
571 " AND " . PMA_backquote('table_name') . " = '" . PMA_sqlAddslashes($_REQUEST['table']) ."' ".
572 " ORDER BY ". PMA_backquote('version') . " DESC ";
574 $sql_result = PMA_query_as_controluser($sql_query);
576 $last_version = 0;
577 $maxversion = PMA_DBI_fetch_array($sql_result);
578 $last_version = $maxversion['version'];
580 if ($last_version > 0) {
582 <table id="versions" class="data">
583 <thead>
584 <tr>
585 <th><?php echo $strDatabase;?></th>
586 <th><?php echo $strTable;?></th>
587 <th><?php echo $strTrackingThVersion;?></th>
588 <th><?php echo $strTrackingThCreated;?></th>
589 <th><?php echo $strTrackingThUpdated;?></th>
590 <th><?php echo $strStatus;?></th>
591 <th><?php echo $strShow;?></th>
592 </tr>
593 </thead>
594 <tbody>
595 <?php
596 $style = 'odd';
597 PMA_DBI_data_seek($sql_result, 0);
598 while($version = PMA_DBI_fetch_array($sql_result)) {
599 if ($version['tracking_active'] == 1) {
600 $version_status = $strTrackingStatusActive;
601 } else {
602 $version_status = $strTrackingStatusNotActive;
604 if (($version['version'] == $last_version) && ($version_status == $strTrackingStatusNotActive)) {
605 $tracking_active = false;
607 if (($version['version'] == $last_version) && ($version_status == $strTrackingStatusActive)) {
608 $tracking_active = true;
611 <tr class="<?php echo $style;?>">
612 <td><?php echo htmlspecialchars($version['db_name']);?></td>
613 <td><?php echo htmlspecialchars($version['table_name']);?></td>
614 <td><?php echo $version['version'];?></td>
615 <td><?php echo $version['date_created'];?></td>
616 <td><?php echo $version['date_updated'];?></td>
617 <td><?php echo $version_status;?></td>
618 <td> <a href="tbl_tracking.php?<?php echo $url_query;?>&amp;report=true&amp;version=<?php echo $version['version'];?>"><?php echo $strTrackingReport;?></a> | <a href="tbl_tracking.php?<?php echo $url_query;?>&amp;snapshot=true&amp;version=<?php echo $version['version'];?>"><?php echo $strTrackingStructureSnapshot;?></a></td>
619 </tr>
620 <?php
621 if ($style == 'even') {
622 $style = 'odd';
623 } else {
624 $style = 'even';
628 </tbody>
629 </table>
630 <?php if ($tracking_active == true) {?>
631 <div id="div_deactivate_tracking">
632 <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>">
633 <fieldset>
634 <legend><?php printf($strTrackingDeactivateTrackingFor, $GLOBALS['db'], $GLOBALS['table']); ?></legend>
635 <input type="hidden" name="version" value="<?php echo $last_version; ?>" />
636 <input type="submit" name="submit_deactivate_now" value="<?php echo $strTrackingDeactivateNow; ?>" />
637 </fieldset>
638 </form>
639 </div>
640 <?php
643 <?php if ($tracking_active == false) {?>
644 <div id="div_activate_tracking">
645 <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>">
646 <fieldset>
647 <legend><?php printf($strTrackingActivateTrackingFor, $GLOBALS['db'], $GLOBALS['table']); ?></legend>
648 <input type="hidden" name="version" value="<?php echo $last_version; ?>" />
649 <input type="submit" name="submit_activate_now" value="<?php echo $strTrackingActivateNow; ?>" />
650 </fieldset>
651 </form>
652 </div>
653 <?php
658 <div id="div_create_version">
659 <form method="post" action="tbl_tracking.php?<?php echo $url_query; ?>">
660 <?php echo PMA_generate_common_hidden_inputs($GLOBALS['db'], $GLOBALS['table']); ?>
661 <fieldset>
662 <legend><?php printf($strTrackingCreateVersionOf, ($last_version + 1), $GLOBALS['db'], $GLOBALS['table']); ?></legend>
664 <input type="hidden" name="version" value="<?php echo ($last_version + 1); ?>" />
666 <p><?php echo $strTrackingTrackDDStatements;?></p>
667 <input type="checkbox" name="alter_table" value="true" checked="checked" /> ALTER TABLE<br/>
668 <input type="checkbox" name="rename_table" value="true" checked="checked" /> RENAME TABLE<br/>
669 <input type="checkbox" name="create_table" value="true" checked="checked" /> CREATE TABLE<br/>
670 <input type="checkbox" name="drop_table" value="true" checked="checked" /> DROP TABLE<br/>
671 <br/>
672 <input type="checkbox" name="create_index" value="true" checked="checked" /> CREATE INDEX<br/>
673 <input type="checkbox" name="drop_index" value="true" checked="checked" /> DROP INDEX<br/>
674 <p><?php echo $strTrackingTrackDMStatements;?></p>
675 <input type="checkbox" name="insert" value="true" checked="checked" /> INSERT<br/>
676 <input type="checkbox" name="update" value="true" checked="checked" /> UPDATE<br/>
677 <input type="checkbox" name="delete" value="true" checked="checked" /> DELETE<br/>
678 <input type="checkbox" name="truncate" value="true" checked="checked" /> TRUNCATE<br/>
680 </fieldset>
681 <fieldset class="tblFooters">
682 <input type="submit" name="submit_create_version" value="<?php echo $strTrackingCreateVersion; ?>" />
683 </fieldset>
684 </form>
685 </div>
687 <br class="clearfloat"/>
689 <?php
691 * Displays the footer
693 require_once './libraries/footer.inc.php';