protected function run1($stage)
{
$this->console->out("Creating new account_user_apikeys table...");
$this->db->Execute("\n CREATE TABLE IF NOT EXISTS `account_user_apikeys` (\n `key_id` CHAR(20) NOT NULL COMMENT 'The unique identifier of the key',\n `user_id` INT(11) NOT NULL COMMENT 'scalr.account_users.id ref',\n `secret_key` VARCHAR(255) NOT NULL COMMENT 'Encrypted secret key',\n `active` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '1 - active, 0 - inactive',\n PRIMARY KEY (`key_id`),\n INDEX `idx_user_keys` (`user_id`, `active`),\n INDEX `idx_active` (`active`),\n CONSTRAINT `fk_0a036c6a9223`\n FOREIGN KEY (`user_id`)\n REFERENCES `account_users` (`id`)\n ON DELETE CASCADE\n ON UPDATE RESTRICT\n ) ENGINE = InnoDB DEFAULT CHARSET=utf8 COMMENT = 'API keys'\n ");
}