zfApX863

1-- --------------------------------------------------------
2-- Host:                         173.194.231.107
3-- Server version:               5.6.31 - (Google)
4-- Server OS:                    Linux
5-- HeidiSQL Version:             9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for ss_oauth
16CREATE DATABASE IF NOT EXISTS `ss_oauth` /*!40100 DEFAULT CHARACTER SET utf8 */;
17USE `ss_oauth`;
18
19-- Dumping structure for table ss_oauth.oauths
20CREATE TABLE IF NOT EXISTS `oauths` (
21  `type` varchar(50) DEFAULT NULL,
22  `data` text
23) ENGINE=InnoDB DEFAULT CHARSET=utf8;
24
25-- Data exporting was unselected.
26-- Dumping structure for table ss_oauth.oauth_access_tokens
27CREATE TABLE IF NOT EXISTS `oauth_access_tokens` (
28  `access_token` varchar(40) NOT NULL,
29  `client_id` varchar(80) NOT NULL,
30  `user_id` varchar(80) DEFAULT NULL,
31  `expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
32  `scope` varchar(4000) DEFAULT NULL,
33  PRIMARY KEY (`access_token`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8;
35
36-- Data exporting was unselected.
37-- Dumping structure for table ss_oauth.oauth_authorization_codes
38CREATE TABLE IF NOT EXISTS `oauth_authorization_codes` (
39  `authorization_code` varchar(40) NOT NULL,
40  `client_id` varchar(80) NOT NULL,
41  `user_id` varchar(80) DEFAULT NULL,
42  `redirect_uri` varchar(2000) DEFAULT NULL,
43  `expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
44  `scope` varchar(4000) DEFAULT NULL,
45  `id_token` varchar(1000) DEFAULT NULL,
46  `store_id` bigint(20) DEFAULT NULL,
47  PRIMARY KEY (`authorization_code`)
48) ENGINE=InnoDB DEFAULT CHARSET=utf8;
49
50-- Data exporting was unselected.
51-- Dumping structure for table ss_oauth.oauth_clients
52CREATE TABLE IF NOT EXISTS `oauth_clients` (
53  `app_name` varchar(150) NOT NULL,
54  `client_id` varchar(80) NOT NULL,
55  `client_secret` varchar(80) DEFAULT NULL,
56  `redirect_uri` varchar(2000) DEFAULT NULL,
57  `grant_types` varchar(80) DEFAULT NULL,
58  `scope` varchar(4000) DEFAULT NULL,
59  `user_id` varchar(80) DEFAULT NULL,
60  `store_id` bigint(20) DEFAULT NULL COMMENT 'store owner of the oauth client',
61  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
62  PRIMARY KEY (`client_id`)
63) ENGINE=InnoDB DEFAULT CHARSET=utf8;
64
65-- Data exporting was unselected.
66-- Dumping structure for table ss_oauth.oauth_jwt
67CREATE TABLE IF NOT EXISTS `oauth_jwt` (
68  `client_id` varchar(80) NOT NULL,
69  `subject` varchar(80) DEFAULT NULL,
70  `public_key` varchar(2000) NOT NULL
71) ENGINE=InnoDB DEFAULT CHARSET=utf8;
72
73-- Data exporting was unselected.
74-- Dumping structure for table ss_oauth.oauth_public_keys
75CREATE TABLE IF NOT EXISTS `oauth_public_keys` (
76  `client_id` varchar(80) DEFAULT NULL,
77  `public_key` varchar(2000) DEFAULT NULL,
78  `private_key` varchar(2000) DEFAULT NULL,
79  `encryption_algorithm` varchar(100) DEFAULT 'RS256'
80) ENGINE=InnoDB DEFAULT CHARSET=utf8;
81
82-- Data exporting was unselected.
83-- Dumping structure for table ss_oauth.oauth_refresh_tokens
84CREATE TABLE IF NOT EXISTS `oauth_refresh_tokens` (
85  `refresh_token` varchar(40) NOT NULL,
86  `client_id` varchar(80) NOT NULL,
87  `user_id` varchar(80) DEFAULT NULL,
88  `expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
89  `scope` varchar(4000) DEFAULT NULL,
90  `store_id` bigint(20) DEFAULT NULL,
91  PRIMARY KEY (`refresh_token`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8;
93
94-- Data exporting was unselected.
95-- Dumping structure for table ss_oauth.oauth_scopes
96CREATE TABLE IF NOT EXISTS `oauth_scopes` (
97  `scope` varchar(80) NOT NULL,
98  `is_default` tinyint(1) DEFAULT NULL,
99  PRIMARY KEY (`scope`)
100) ENGINE=InnoDB DEFAULT CHARSET=utf8;
101
102-- Data exporting was unselected.
103-- Dumping structure for table ss_oauth.oauth_users
104CREATE TABLE IF NOT EXISTS `oauth_users` (
105  `username` varchar(80) DEFAULT NULL,
106  `password` varchar(80) DEFAULT NULL,
107  `first_name` varchar(80) DEFAULT NULL,
108  `last_name` varchar(80) DEFAULT NULL,
109  `email` varchar(80) DEFAULT NULL,
110  `email_verified` tinyint(1) DEFAULT NULL,
111  `scope` varchar(4000) DEFAULT NULL
112) ENGINE=InnoDB DEFAULT CHARSET=utf8;
113
114-- Data exporting was unselected.
115/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
116/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
117/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;