Login   Register  
PHP Classes
elePHPant
Icontem

File: oauth.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Manuel Lemos  >  PHP OAuth API  >  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 API
Authorize and access APIs using OAuth
Author: By
Last change: Added support to store and retrieve refresh tokens in the database.
Date: 2013-04-23 05:45
Size: 694 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(12) 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 NOT NULL,
  `refresh_token` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `social_oauth_session_index` (`session`,`server`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;