[6351] | 1 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
---|
| 2 | |
---|
| 3 | CREATE TABLE `auth_codes` ( |
---|
| 4 | `code` varchar(40) NOT NULL, |
---|
| 5 | `client_id` varchar(40) NOT NULL, |
---|
| 6 | `user_id` int(11) UNSIGNED NOT NULL, |
---|
| 7 | `redirect_uri` varchar(200) NOT NULL, |
---|
| 8 | `expires` int(11) NOT NULL, |
---|
| 9 | `scope` varchar(255) DEFAULT NULL, |
---|
| 10 | PRIMARY KEY (`code`) |
---|
| 11 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
| 12 | |
---|
| 13 | CREATE TABLE `clients` ( |
---|
| 14 | `client_id` varchar(40) NOT NULL, |
---|
| 15 | `client_secret` varchar(20) NOT NULL, |
---|
| 16 | `redirect_uri` varchar(255) NOT NULL, |
---|
| 17 | PRIMARY KEY (`client_id`) |
---|
| 18 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
| 19 | |
---|
| 20 | CREATE TABLE `access_tokens` ( |
---|
| 21 | `oauth_token` varchar(40) NOT NULL, |
---|
| 22 | `client_id` varchar(40) NOT NULL, |
---|
| 23 | `user_id` int(11) UNSIGNED NOT NULL, |
---|
| 24 | `expires` int(11) NOT NULL, |
---|
| 25 | `scope` varchar(255) DEFAULT NULL, |
---|
| 26 | PRIMARY KEY (`oauth_token`) |
---|
| 27 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
| 28 | |
---|
| 29 | CREATE TABLE `refresh_tokens` ( |
---|
| 30 | `refresh_token` varchar(40) NOT NULL, |
---|
| 31 | `client_id` varchar(40) NOT NULL, |
---|
| 32 | `user_id` int(11) UNSIGNED NOT NULL, |
---|
| 33 | `expires` int(11) NOT NULL, |
---|
| 34 | `scope` varchar(255) DEFAULT NULL, |
---|
| 35 | PRIMARY KEY (`refresh_token`) |
---|
| 36 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|