source: sandbox/2.4.1-3/prototype/rest/oauth/mysql_create_tables.sql @ 6351

Revision 6351, 1.1 KB checked in by gustavo, 8 years ago (diff)

Ticket #2768 - Melhorias na inserção de destinatários na criacao de mensagem

  • Property svn:executable set to *
Line 
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3CREATE 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
13CREATE 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
20CREATE 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
29CREATE 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;
Note: See TracBrowser for help on using the repository browser.