fkooman\OAuth\Client\PdoStorage::createTableQueries PHP Method

createTableQueries() public static method

public static createTableQueries ( $prefix )
    public static function createTableQueries($prefix)
    {
        $query = array();
        $query[] = sprintf('CREATE TABLE IF NOT EXISTS %s (
                client_config_id VARCHAR(255) NOT NULL,
                user_id VARCHAR(255) NOT NULL,
                scope VARCHAR(255) NOT NULL,
                issue_time INTEGER NOT NULL,
                state VARCHAR(255) NOT NULL,
                UNIQUE (client_config_id , user_id , scope),
                PRIMARY KEY (state)
            )', $prefix . 'states');
        $query[] = sprintf('CREATE TABLE IF NOT EXISTS %s (
                client_config_id VARCHAR(255) NOT NULL,
                user_id VARCHAR(255) NOT NULL,
                scope VARCHAR(255) NOT NULL,
                issue_time INTEGER NOT NULL,
                access_token VARCHAR(255) NOT NULL,
                token_type VARCHAR(255) NOT NULL,
                expires_in INTEGER DEFAULT NULL,
                UNIQUE (client_config_id , user_id , scope)
            )', $prefix . 'access_tokens');
        $query[] = sprintf('CREATE TABLE IF NOT EXISTS %s (
                client_config_id VARCHAR(255) NOT NULL,
                user_id VARCHAR(255) NOT NULL,
                scope VARCHAR(255) NOT NULL,
                issue_time INTEGER NOT NULL,
                refresh_token VARCHAR(255) DEFAULT NULL,
                UNIQUE (client_config_id , user_id , scope)
            )', $prefix . 'refresh_tokens');
        return $query;
    }