root/apps/php/trunk/OpenAuth-php/database-structure.txt
| Revision 753, 0.7 kB (checked in by nadya, 3 years ago) |
|---|
| Line | |
|---|---|
| 1 | CREATE DATABASE `oauth` DEFAULT CHARACTER SET utf8; |
| 2 | |
| 3 | CREATE 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 | |
| 16 | CREATE 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.
