} // PACK_KEYS: MyISAM or ISAM // DELAY_KEY_WRITE, CHECKSUM, : MyISAM only // AUTO_INCREMENT: MyISAM and InnoDB since 5.0.3, PBXT // Here should be version check for InnoDB, however it is supported // in >5.0.4, >4.1.12 and >4.0.11, so I decided not to // check for version $response->addHTML(PMA_getTableOptionDiv($comment, $tbl_collation, $tbl_storage_engine, $is_myisam_or_aria, $is_isam, $create_options['pack_keys'], $auto_increment, empty($create_options['delay_key_write']) ? '0' : '1', isset($create_options['transactional']) && $create_options['transactional'] == '0' ? '0' : '1', isset($create_options['page_checksum']) ? $create_options['page_checksum'] : '', $is_innodb, $is_pbxt, $is_aria, empty($create_options['checksum']) ? '0' : '1')); /** * Copy table */ $response->addHTML(PMA_getHtmlForCopytable()); /** * Table maintenance */ $response->addHTML(PMA_getHtmlForTableMaintenance($is_myisam_or_aria, $is_innodb, $is_berkeleydb, $url_params)); if (!(isset($db_is_system_schema) && $db_is_system_schema)) { $truncate_table_url_params = array(); $drop_table_url_params = array(); if (!$tbl_is_view && !(isset($db_is_system_schema) && $db_is_system_schema)) { $this_sql_query = 'TRUNCATE TABLE ' . PMA\libraries\Util::backquote($GLOBALS['table']); $truncate_table_url_params = array_merge($url_params, array('sql_query' => $this_sql_query, 'goto' => 'tbl_structure.php', 'reload' => '1', 'message_to_show' => sprintf(__('Table %s has been emptied.'), htmlspecialchars($table)))); } if (!(isset($db_is_system_schema) && $db_is_system_schema)) { $this_sql_query = 'DROP TABLE ' . PMA\libraries\Util::backquote($GLOBALS['table']); $drop_table_url_params = array_merge($url_params, array('sql_query' => $this_sql_query, 'goto' => 'db_operations.php', 'reload' => '1', 'purge' => '1', 'message_to_show' => sprintf($tbl_is_view ? __('View %s has been dropped.') : __('Table %s has been dropped.'), htmlspecialchars($table)), 'table' => $GLOBALS['table'])); } $response->addHTML(PMA_getHtmlForDeleteDataOrTable($truncate_table_url_params, $drop_table_url_params)); } if (Partition::havePartitioning()) { $partition_names = Partition::getPartitionNames($db, $table);
); /** * Copy table */ $response->addHTML(PMA_getHtmlForCopytable()); $response->addHTML('<br class="clearfloat"/>'); /** * Table maintenance */ $response->addHTML( PMA_getHtmlForTableMaintenance( $is_myisam_or_aria, $is_innodb, $is_berkeleydb, $url_params ) ); if (! (isset($db_is_information_schema) && $db_is_information_schema)) { $truncate_table_url_params = array(); $drop_table_url_params = array(); if (! $tbl_is_view && ! (isset($db_is_information_schema) && $db_is_information_schema) ) { $this_sql_query = 'TRUNCATE TABLE ' . PMA_Util::backquote($GLOBALS['table']); $truncate_table_url_params = array_merge( $url_params,
} // PACK_KEYS: MyISAM or ISAM // DELAY_KEY_WRITE, CHECKSUM, : MyISAM only // AUTO_INCREMENT: MyISAM and InnoDB since 5.0.3, PBXT // Here should be version check for InnoDB, however it is supported // in >5.0.4, >4.1.12 and >4.0.11, so I decided not to // check for version $response->addHTML(PMA_getTableOptionDiv($pma_table, $comment, $tbl_collation, $tbl_storage_engine, $create_options['pack_keys'], $auto_increment, empty($create_options['delay_key_write']) ? '0' : '1', isset($create_options['transactional']) && $create_options['transactional'] == '0' ? '0' : '1', isset($create_options['page_checksum']) ? $create_options['page_checksum'] : '', empty($create_options['checksum']) ? '0' : '1')); /** * Copy table */ $response->addHTML(PMA_getHtmlForCopytable()); /** * Table maintenance */ $response->addHTML(PMA_getHtmlForTableMaintenance($pma_table, $url_params)); if (!(isset($db_is_system_schema) && $db_is_system_schema)) { $truncate_table_url_params = array(); $drop_table_url_params = array(); if (!$tbl_is_view && !(isset($db_is_system_schema) && $db_is_system_schema)) { $this_sql_query = 'TRUNCATE TABLE ' . PMA\libraries\Util::backquote($GLOBALS['table']); $truncate_table_url_params = array_merge($url_params, array('sql_query' => $this_sql_query, 'goto' => 'tbl_structure.php', 'reload' => '1', 'message_to_show' => sprintf(__('Table %s has been emptied.'), htmlspecialchars($table)))); } if (!(isset($db_is_system_schema) && $db_is_system_schema)) { $this_sql_query = 'DROP TABLE ' . PMA\libraries\Util::backquote($GLOBALS['table']); $drop_table_url_params = array_merge($url_params, array('sql_query' => $this_sql_query, 'goto' => 'db_operations.php', 'reload' => '1', 'purge' => '1', 'message_to_show' => sprintf($tbl_is_view ? __('View %s has been dropped.') : __('Table %s has been dropped.'), htmlspecialchars($table)), 'table' => $GLOBALS['table'])); } $response->addHTML(PMA_getHtmlForDeleteDataOrTable($truncate_table_url_params, $drop_table_url_params)); } if (Partition::havePartitioning()) { $partition_names = Partition::getPartitionNames($db, $table);
((isset($create_options['transactional']) && $create_options['transactional'] == '0') ? '0' : '1'), ((isset($create_options['page_checksum'])) ? $create_options['page_checksum'] : ''), (empty($create_options['checksum']) ? '0' : '1') ) ); /** * Copy table */ $response->addHTML(PMA_getHtmlForCopytable()); /** * Table maintenance */ $response->addHTML( PMA_getHtmlForTableMaintenance($pma_table, $url_params) ); if (! (isset($db_is_system_schema) && $db_is_system_schema)) { $truncate_table_url_params = array(); $drop_table_url_params = array(); if (! $tbl_is_view && ! (isset($db_is_system_schema) && $db_is_system_schema) ) { $this_sql_query = 'TRUNCATE TABLE ' . PMA\libraries\Util::backquote($GLOBALS['table']); $truncate_table_url_params = array_merge( $url_params, array( 'sql_query' => $this_sql_query,