/**
* Any migration code in here is wrapped inside of a transaction.
*
* @return bool
*/
public function safeUp()
{
$ordersTable = Market_OrderRecord::model()->getTableName();
$ordersTable = craft()->db->addTablePrefix($ordersTable);
craft()->db->createCommand("\n ALTER TABLE {$ordersTable}\n ADD COLUMN returnUrl VARCHAR(255) NULL AFTER lastIp,\n ADD COLUMN cancelUrl VARCHAR(255) NULL AFTER returnUrl\n ")->execute();
return true;
}
/**
* Any migration code in here is wrapped inside of a transaction.
*
* @return bool
*/
public function safeUp()
{
$table = Market_OrderRecord::model()->getTableName();
$table = craft()->db->addTablePrefix($table);
craft()->db->createCommand("\n ALTER TABLE {$table}\n DROP COLUMN `state`,\n ADD COLUMN `statusId` INT(11) NULL AFTER `customerId`\n ")->execute();
craft()->db->createCommand()->addForeignKey('market_orders', 'statusId', 'market_orderstatuses', 'id', 'RESTRICT', 'CASCADE');
return true;
}
