PHP Classes

File: oauth.sql

Recommend this page to a friend!
  Classes of Manuel Lemos  >  PHP OAuth Library  >  oauth.sql  >  Download  
File: oauth.sql
Role: Auxiliary data
Content type: text/plain
Description: MySQL queries to install the oauth_session table
Class: PHP OAuth Library
Authorize and access APIs using OAuth
Author: By
Last change: Increased the length of the server field to fit longer OAuth API server
names.
Date: 5 years ago
Size: 755 bytes
 

Contents

Class file image Download
DROP TABLE IF EXISTS `oauth_session`; CREATE TABLE `oauth_session` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `session` char(32) NOT NULL DEFAULT '', `state` char(32) NOT NULL DEFAULT '', `access_token` mediumtext NOT NULL, `expiry` datetime DEFAULT NULL, `type` char(12) NOT NULL DEFAULT '', `server` char(20) NOT NULL DEFAULT '', `creation` datetime NOT NULL DEFAULT '2000-01-01 00:00:00', `access_token_secret` mediumtext NOT NULL, `authorized` char(1) DEFAULT NULL, `user` int(10) unsigned DEFAULT 0 NOT NULL, `refresh_token` mediumtext NOT NULL, `access_token_response` mediumtext DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `social_oauth_session_index` (`session`,`server`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;