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; |
---|