diff -r 99c15cfe420b -r b435f8055cb4 Command/CreateFullTextIndexesCommand.php --- a/Command/CreateFullTextIndexesCommand.php Fri Oct 28 14:57:11 2011 +0200 +++ b/Command/CreateFullTextIndexesCommand.php Fri Nov 04 11:56:59 2011 +0100 @@ -43,37 +43,10 @@ $simulate = true; } - $sql_code = ""; - $fields = $this->getContainer()->getParameter('wiki_tag.fields'); - $def_columns = array(); - foreach ( $fields as $name => $field_def) - { - if(isset($field_def['type'])) - { - $type = $field_def['type']; - } - if(!isset($type) || is_null($type) || strlen($type) == 0) - { - $type = "text"; - } - - if($type === 'text') - { - $def_column = "$name(4096)"; - } - else - { - $def_column = $name; - } - $def_columns[] = $def_column; - - $sql_code .= "ALTER IGNORE TABLE wikitag_document DROP INDEX ${name}_document_fulltext_idx;\n"; - $sql_code .= "ALTER TABLE wikitag_document ADD FULLTEXT INDEX ${name}_document_fulltext_idx ($def_column);\n"; - } + + $schema_utils = $this->getContainer()->get("wikitag.shema_utils"); - $sql_code .= "ALTER IGNORE TABLE wikitag_document DROP INDEX all_document_fulltext_idx;\n"; - $sql_code .= "ALTER TABLE wikitag_document ADD FULLTEXT INDEX all_document_fulltext_idx (".join(",", $def_columns).");\n"; - + $sql_code = implode(";".PHP_EOL, $schema_utils->createFullTextIndexes()); if($simulate) {