protected function run1($stage)
{
$this->console->out("Adding account_id column to reports and notifications tables...");
$this->db->BeginTrans();
try {
$this->db->Execute("\n ALTER TABLE `notifications`\n ADD COLUMN `account_id` int(11) DEFAULT NULL COMMENT 'ID of Account',\n ADD INDEX `idx_account_id` (`account_id`)\n ");
$this->db->Execute("\n ALTER TABLE `reports`\n ADD COLUMN `account_id` int(11) DEFAULT NULL COMMENT 'ID of Account',\n ADD INDEX `idx_account_id` (`account_id`)\n ");
$this->db->CommitTrans();
} catch (Exception $e) {
$this->db->RollbackTrans();
throw $e;
}
}