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; } }