Version20130802151400.php

<?php

namespace DoctrineMigrations;

use Doctrine\DBAL\Migrations\AbstractMigration,
	Doctrine\DBAL\Schema\Schema;

/**
 * Add comments and collection_method to metricdata
 */
class Version201308021451400 extends AbstractMigration
{
	public function up(Schema $schema)
	{
		$sql =<<<EOF
ALTER TABLE `metricdata`
	ADD `comments` VARCHAR(255) NULL  AFTER `value`,
	ADD `collection_method` VARCHAR(255) NULL AFTER `comments`;
EOF;
		$this->addSql($sql);

	}

	public function down(Schema $schema)
	{
		$sql =<<<EOF
ALTER TABLE `metricdata`
	DROP `comments`,
	DROP `collection_method`;
EOF;
		$this->addSql($sql);

	}
}