/** * 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; }