an install command

install-command.php

<?php

class InstallCommand extends CConsoleCommand
{
    public function actionIndex()
    {
        $this->createDir('images.cache');
        $this->createDir('images.cache.thumbnails');
 
        $tables = Yii::app()->db->schema->getTableNames();
        foreach ($tables as $table) {
            Yii::app()->db->createCommand()->dropTable($table);
        }
         
        $this
          ->commandRunner
          ->createCommand('migrate')
          ->run(array('up', '--interactive=0'));
         
    }
 
    protected function createDir($alias)
    {
        $webroot = realpath(Yii::app()->basePath . DIRECTORY_SEPARATOR . '..');

        $path    = $webroot 
                 . DIRECTORY_SEPARATOR
                 . str_replace('.', DIRECTORY_SEPARATOR, $alias);

        if (!file_exists($path)) {
            mkdir($path);
        }
    }
 
}