Developer Area

root/apps/php/trunk/OpenAuth-php/database-structure.txt

Revision 753, 0.7 kB (checked in by nadya, 4 years ago)

OpenAuth Sample Code added

Line 
1CREATE DATABASE `oauth` DEFAULT CHARACTER SET utf8;
2
3CREATE TABLE `access` (
4  `id` int(10) unsigned NOT NULL auto_increment,
5  `endpoint` int(10) unsigned default '0',
6  `client_id` varchar(50) default NULL,
7  `client_level` varchar(15) default NULL,
8  `client_duration` varchar(15) default NULL,
9  `client_secret` varchar(50) default NULL,
10  `email` varchar(100) default NULL,
11  `access_token` varchar(255) default NULL,
12  `refresh_token` varchar(255) default NULL,
13  PRIMARY KEY  (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 COMMENT='OpenAuth Access Tokens';
15
16CREATE TABLE `endpoints` (
17  `id` int(10) unsigned NOT NULL auto_increment,
18  `endpoint` varchar(255) NOT NULL,
19  PRIMARY KEY  (`id`)
20) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;
Note: See TracBrowser for help on using the browser.
Telnic
Search This Site
Partners
Neustar
ICANN
Main site | WHOIS | Sell .tel | FAQ | Archived Site | About Telnic | Contact Us