How to change Migration Table name and use defined prefix.

You are viewing revision #2 of this wiki article.
This version may not be up to date with the latest version.
You may want to view the differences to the latest version.

next (#3) »

To accomplish the task of changing Migration table's name, by default tbl_migration, you need to add the following in your ./protected/config/console.php.

// Command Map
  'commandMap'=>array(
    'migrate'=>array(
    'class'=>'system.cli.commands.MigrateCommand','
    'migrationPath'=>'application.migrations',
    'migrationTable'=>'{{migration_history}}',
    'connectionID'=>'db',
    'templateFile'=>'application.migrations.template',
    ),
  ),

The {{ }} makes Yii to use the prefix defined in the 'db' component defined in the same file. This piece of code must be contained by the first array, do not put it under 'components' array.

'components'=>array(
  'db'=>array(
	'connectionString' => 'mysql:host=localhost;dbname=directar',
	'emulatePrepare' => true,
	'username' => 'root',
	'password' => '010101',
	'charset' => 'utf8',
    'tablePrefix' => 'directar_'
	),
  ....
  ),