function _setupSQLStatements()
{
switch ($this->oDBH->dbsyntax) {
case 'mysql':
$engine = $this->oDBH->getOption('default_table_type');
$this->aSQLStatements['table_copy_all'] = "INSERT IGNORE INTO %s SELECT * FROM %s";
//$this->aSQLStatements['table_copy_cols'] = "INSERT IGNORE INTO (%s %s) VALUES (SELECT %s FROM %s)";
$this->aSQLStatements['table_update_col'] = "UPDATE IGNORE %s SET %s = %s.%s";
$this->aSQLStatements['table_copy'] = "CREATE TABLE %s ENGINE={$engine} (SELECT * FROM %s)";
$this->aSQLStatements['table_copy_temp'] = "CREATE TEMPORARY TABLE %s ENGINE={$engine} (SELECT * FROM %s)";
$this->aSQLStatements['table_rename'] = "RENAME TABLE %s TO %s";
$this->aSQLStatements['table_select'] = 'SELECT %s FROM %s';
$this->aSQLStatements['table_insert'] = 'INSERT INTO %s (%s) VALUES %s';
break;
case 'pgsql':
$this->aSQLStatements['table_copy_all'] = 'INSERT INTO "%s" SELECT * FROM "%s"';
$this->aSQLStatements['table_update_col'] = 'UPDATE "%s" SET %s = "%s".%s';
$this->aSQLStatements['table_copy'] = 'CREATE TABLE "%1$s" (LIKE "%2$s" INCLUDING DEFAULTS); INSERT INTO "%1$s" SELECT * FROM "%2$s"';
$this->aSQLStatements['table_copy_temp'] = 'CREATE TABLE "%1$s" (LIKE "%2$s" INCLUDING DEFAULTS); INSERT INTO "%1$s" SELECT * FROM "%2$s"';
$this->aSQLStatements['table_rename'] = 'ALTER TABLE "%s" RENAME TO "%s"';
$this->aSQLStatements['table_select'] = 'SELECT %s FROM "%s"';
$this->aSQLStatements['table_insert'] = 'INSERT INTO "%s" (%s) VALUES %s';
break;
default:
'';
break;
}
}
