/**
* @param ConfigManager $settings
* @param RequestModel $model
* @return string
*/
public static function getTableCreateQuery($settings, $model)
{
$cols = $model->getFlatColumnsDbTypes();
$uniqArr = $model->getUniques();
$uniColsStr = '';
foreach ($uniqArr as $uniKey) {
$uniColsStr = $uniColsStr . ', UNIQUE INDEX `' . $uniKey . '_UNIQUE` (`' . $uniKey . '` ASC)';
}
$colsStr = '';
foreach ($cols as $col => $type) {
$colsStr = $colsStr . '`' . $col . '` ' . $type . ',';
}
$q = self::$CREATE_TABLE_QUERY_MODEL;
$q = str_replace('<identifier>', self::getDbTableIdentifier($settings, $model), $q);
$q = str_replace('<fields>', $colsStr, $q);
$q = str_replace('<uniqueIndexes>', $uniColsStr, $q);
return $q;
}