rugk/xenforo-threema-gateway

<?php
/**
 * Adds/Deletes the pending message confirm table.
 *
 * @package ThreemaGateway
 * @author rugk
 * @copyright Copyright (c) 2015-2016 rugk
 * @license MIT
 */

/**
 * Methods for creating or deleting the message confirm table.
 */
class ThreemaGateway_Installer_TfaPendingConfirmMsgs
{
    /**
     * @var string database table name
     */
    const DB_TABLE = 'xf_threemagw_tfa_pending_msgs_confirm';

    /**
     * Create a new table in the database.
     */
    public function create()
    {
        $db = XenForo_Application::get('db');
        $db->query('CREATE TABLE `' . self::DB_TABLE . '`
            (`request_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
            `threema_id` CHAR(8) NOT NULL,
            `provider_id` VARBINARY(25) NOT NULL,
            `pending_type` TINYINT(3) UNSIGNED NOT NULL,
            `user_id` INT(10) UNSIGNED NOT NULL,
            `session_id` VARBINARY(32) NOT NULL,
            `extra_data` BLOB COMMENT \'any extra data, which may be used for verifying whether a request is valid\',
            `expiry_date` INT(10) UNSIGNED NOT NULL,
            PRIMARY KEY(`request_id`),
            INDEX(`expiry_date`)
            ) COMMENT=\'Stores pending 2FA requests for confirmation messages for receiver/callback.\'');
    }

    /**
     * Deletes the table.
     */
    public function destroy()
    {
        $db = XenForo_Application::get('db');
        $db->query('DROP TABLE `' . self::DB_TABLE . '`');
    }
}