219
219
$leaf->setName('add_statements');
220
220
$leaf->setText(__('Add statements:'));
221
221
$subgroup->setSubgroupHeader($leaf);
223
if ($plugin_param['export_type'] != 'table') {
224
$leaf = new BoolPropertyItem();
225
$leaf->setName('create_database');
226
$create_clause = '<code>CREATE DATABASE / USE</code>';
227
$leaf->setText(sprintf(__('Add %s statement'), $create_clause));
228
$subgroup->addProperty($leaf);
222
231
if ($plugin_param['export_type'] == 'table') {
223
232
if (PMA_Table::isView($GLOBALS['db'], $GLOBALS['table'])) {
224
233
$drop_clause = '<code>DROP VIEW</code>';
709
$create_query = 'CREATE DATABASE IF NOT EXISTS '
710
. (isset($GLOBALS['sql_backquotes'])
711
? PMA_Util::backquoteCompat($db, $compat) : $db);
712
$collation = PMA_getDbCollation($db);
714
$create_query .= ' COLLATE ' . $collation;
716
if (strpos($collation, '_')) {
717
$create_query .= ' DEFAULT CHARACTER SET '
718
. substr($collation, 0, strpos($collation, '_'))
719
. ' COLLATE ' . $collation;
721
$create_query .= ' DEFAULT CHARACTER SET ' . $collation;
724
$create_query .= ';' . $crlf;
725
if (! PMA_exportOutputHandler($create_query)) {
728
if (isset($GLOBALS['sql_backquotes'])
729
&& ((isset($GLOBALS['sql_compatibility'])
730
&& $GLOBALS['sql_compatibility'] == 'NONE')
733
$result = PMA_exportOutputHandler(
734
'USE ' . PMA_Util::backquoteCompat($db, $compat)
738
$result = PMA_exportOutputHandler('USE ' . $db . ';' . $crlf);
718
if (isset($GLOBALS['sql_create_database'])) {
719
$create_query = 'CREATE DATABASE IF NOT EXISTS '
720
. (isset($GLOBALS['sql_backquotes'])
721
? PMA_Util::backquoteCompat($db, $compat) : $db);
722
$collation = PMA_getDbCollation($db);
724
$create_query .= ' COLLATE ' . $collation;
726
if (strpos($collation, '_')) {
727
$create_query .= ' DEFAULT CHARACTER SET '
728
. substr($collation, 0, strpos($collation, '_'))
729
. ' COLLATE ' . $collation;
731
$create_query .= ' DEFAULT CHARACTER SET ' . $collation;
734
$create_query .= ';' . $crlf;
735
if (! PMA_exportOutputHandler($create_query)) {
738
if (isset($GLOBALS['sql_backquotes'])
739
&& ((isset($GLOBALS['sql_compatibility'])
740
&& $GLOBALS['sql_compatibility'] == 'NONE')
743
$result = PMA_exportOutputHandler(
744
'USE ' . PMA_Util::backquoteCompat($db, $compat)
748
$result = PMA_exportOutputHandler('USE ' . $db . ';' . $crlf);