/**
  * Any migration code in here is wrapped inside of a transaction.
  *
  * @return bool
  */
 public function safeUp()
 {
     $table = Market_OrderHistoryRecord::model()->getTableName();
     $fullTable = craft()->db->addTablePrefix($table);
     $customersTable = Market_CustomerRecord::model()->getTableName();
     $fullCustomersTable = craft()->db->addTablePrefix($customersTable);
     craft()->db->createCommand("ALTER TABLE {$fullTable} ADD COLUMN `customerId` INT NOT NULL AFTER `userId`;")->execute();
     craft()->db->createCommand("\n            UPDATE {$fullTable} oh, {$fullCustomersTable} c\n            SET oh.customerId = c.id\n            WHERE oh.userId = c.userId\n        ")->execute();
     craft()->db->createCommand()->addForeignKey($table, 'customerId', $customersTable, 'id', 'CASCADE', 'CASCADE');
     craft()->db->createCommand()->dropForeignKey($table, 'userId');
     craft()->db->createCommand()->dropColumn($table, 'userId');
     return true;
 }
 /**
  * @param int $id
  *
  * @throws \CDbException
  */
 public function deleteById($id)
 {
     Market_OrderHistoryRecord::model()->deleteByPk($id);
 }