m130915_101849_add_setting_pk_for_mysql

Complexity

Total Complexity

4

Size/Duplication

Total Lines	30
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	4	1
A	up()	0	21	3

<?php

class m130915_101849_add_setting_pk_for_mysql extends CDbMigration
{

	public function up()
	{
		// Bail out if we are not configured for MySQL
		if (strpos(Yii::app()->db->connectionString, 'sqlite') === 0)
		{
			echo "Not configured to use MySQL, skipping this migration ...\n";
			return true;
		}

		// Try to drop any previous defined primary key (in case someone fixed 
		// this on their own)
		try
		{
			$this->dropPrimaryKey('name', 'settings');
		}
		catch (CDbException $e)
		{
			// ignore the exception, it means the primary key doesn't exist
		}

		$this->addPrimaryKey('PRIMARY', 'settings', 'name');
	}

	public function down()
	{
		echo "m130915_101849_add_setting_pk_for_mysql does not support migration down.\n";
		return false;
	}

}