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