Scalr\Upgrade\Updates\Update20150217125922::run1 PHP Method

run1() protected method

protected run1 ( $stage )
    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        ");
    }