vUwxud8K

1CREATE TABLE IF NOT EXISTS `oauth_access_token` (
2  `token_id` varchar(255) DEFAULT NULL,
3  `token` blob,
4  `authentication_id` varchar(255) DEFAULT NULL,
5  `user_name` varchar(255) DEFAULT NULL,
6  `client_id` varchar(255) DEFAULT NULL,
7  `authentication` blob,
8  `refresh_token` varchar(255) DEFAULT NULL
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10
11CREATE TABLE IF NOT EXISTS `oauth_client_details` (
12  `client_id` varchar(255) NOT NULL,
13  `resource_ids` varchar(255) DEFAULT NULL,
14  `client_secret` varchar(255) DEFAULT NULL,
15  `scope` varchar(255) DEFAULT NULL,
16  `authorized_grant_types` varchar(255) DEFAULT NULL,
17  `web_server_redirect_uri` varchar(255) DEFAULT NULL,
18  `authorities` varchar(255) DEFAULT NULL,
19  `access_token_validity` int(11) DEFAULT NULL,
20  `refresh_token_validity` int(11) DEFAULT NULL,
21  `additional_information` varchar(4096) DEFAULT NULL,
22  `autoapprove` varchar(255) DEFAULT NULL,
23  PRIMARY KEY (`client_id`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25
26INSERT INTO `oauth_client_details` (`client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `autoapprove`) VALUES
27('web', NULL, 'ticketsale', 'user,full', 'password,authorization_code,refresh_token,implicit', '', 'ROLE_USER,ROLE_ADMIN', NULL, NULL, NULL, NULL);
28
29CREATE TABLE IF NOT EXISTS `oauth_code` (
30  `code` varchar(255) DEFAULT NULL,
31  `authentication` blob
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34CREATE TABLE IF NOT EXISTS `oauth_refresh_token` (
35  `token_id` varchar(255) DEFAULT NULL,
36  `token` blob,
37  `authentication` blob
38) ENGINE=InnoDB DEFAULT CHARSET=utf8;