documentation-developer/docs/users/sql/install_mysql.sql at 92a1c3534b157469ac362a65ca135338e47fb0f9 · ibexa/documentation-developer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
CREATE TABLE
    ibexa_oauth2_client (
        id INT AUTO_INCREMENT NOT NULL,
        client_name VARCHAR(128) NOT NULL,
        client_identifier VARCHAR(32) NOT NULL,
        client_secret VARCHAR(128) DEFAULT NULL,
        client_active TINYINT (1) DEFAULT '0' NOT NULL,
        client_plain_pkce TINYINT (1) DEFAULT '0' NOT NULL,
        UNIQUE INDEX ibexa_oauth2_client_identifier_idx (client_identifier),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

CREATE TABLE
    ibexa_oauth2_client_redirect_uri (
        id INT AUTO_INCREMENT NOT NULL,
        client_id INT NOT NULL,
        client_redirect_uri VARCHAR(255) NOT NULL,
        INDEX ibexa_oauth2_client_redirect_uri_client_id_idx (client_id),
        INDEX ibexa_oauth2_client_redirect_uri_client_redirect_uri_idx (client_redirect_uri),
        UNIQUE INDEX ibexa_oauth2_client_redirect_uri_unique_idx (client_id, client_redirect_uri),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

CREATE TABLE
    ibexa_oauth2_client_grant (
        id INT AUTO_INCREMENT NOT NULL,
        client_id INT NOT NULL,
        client_grant VARCHAR(255) NOT NULL,
        INDEX ibexa_oauth2_client_grant_client_id_idx (client_id),
        INDEX ibexa_oauth2_client_grant_client_grant_idx (client_grant),
        UNIQUE INDEX ibexa_oauth2_client_grant_unique_idx (client_id, client_grant),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

CREATE TABLE
    ibexa_oauth2_client_token (
        id INT AUTO_INCREMENT NOT NULL,
        client_id INT NOT NULL,
        token_id INT NOT NULL,
        INDEX ibexa_oauth2_client_token_client_id_idx (client_id),
        INDEX ibexa_oauth2_client_token_token_id_idx (token_id),
        UNIQUE INDEX ibexa_oauth2_client_token_unique_idx (client_id, token_id),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

CREATE TABLE
    ibexa_oauth2_client_scope (
        id INT AUTO_INCREMENT NOT NULL,
        client_id INT NOT NULL,
        client_scope VARCHAR(255) NOT NULL,
        INDEX ibexa_oauth2_client_scope_client_id_idx (client_id),
        INDEX ibexa_oauth2_client_scope_client_scope_idx (client_scope),
        UNIQUE INDEX ibexa_oauth2_client_scope_unique_idx (client_id, client_scope),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

CREATE TABLE
    ibexa_oauth2_token_scope (
        id INT AUTO_INCREMENT NOT NULL,
        token_id INT NOT NULL,
        token_scope VARCHAR(255) NOT NULL,
        INDEX ibexa_oauth2_token_scope_token_id_idx (token_id),
        INDEX ibexa_oauth2_token_scope_scope_idx (token_scope),
        UNIQUE INDEX ibexa_oauth2_token_scope_unique_idx (token_id, token_scope),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

CREATE TABLE
    ibexa_oauth2_refresh_access_token (
        id INT AUTO_INCREMENT NOT NULL,
        access_token_id INT NOT NULL,
        refresh_token_id INT NOT NULL,
        INDEX ibexa_oauth2_refresh_access_token_access_token_id_idx (access_token_id),
        INDEX ibexa_oauth2_refresh_access_token_refresh_token_id_idx (refresh_token_id),
        UNIQUE INDEX ibexa_oauth2_refresh_access_token_unique_idx (access_token_id, refresh_token_id),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

CREATE TABLE
    ibexa_oauth2_consent (
        id INT AUTO_INCREMENT NOT NULL,
        user_identifier VARCHAR(150) NOT NULL,
        client_identifier VARCHAR(32) NOT NULL,
        created INT DEFAULT 0 NOT NULL,
        updated INT DEFAULT 0 NOT NULL,
        INDEX IDX_40497C0FD0494586 (user_identifier),
        INDEX IDX_40497C0FE77ABE2B (client_identifier),
        INDEX ibexa_oauth2_consent_consent_idx (user_identifier, client_identifier),
        UNIQUE INDEX ibexa_oauth2_consent_unique_idx (user_identifier, client_identifier),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

CREATE TABLE
    ibexa_oauth2_consent_scope (
        id INT AUTO_INCREMENT NOT NULL,
        consent_id INT NOT NULL,
        consent_scope VARCHAR(255) NOT NULL,
        INDEX ibexa_oauth2_consent_scope_consent_id_idx (consent_id),
        INDEX ibexa_oauth2_consent_scope_consent_scope_idx (consent_scope),
        UNIQUE INDEX ibexa_oauth2_consent_scope_unique_idx (consent_id, consent_scope),
        PRIMARY KEY (id)
    ) DEFAULT CHARACTER
SET
    utf8mb4 COLLATE `utf8mb4_unicode_520_ci` ENGINE = InnoDB;

ALTER TABLE ibexa_oauth2_client_redirect_uri ADD CONSTRAINT ibexa_oauth2_client_redirect_uri_fk FOREIGN KEY (client_id) REFERENCES ibexa_oauth2_client (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_client_grant ADD CONSTRAINT ibexa_oauth2_client_grant_fk FOREIGN KEY (client_id) REFERENCES ibexa_oauth2_client (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_client_token ADD CONSTRAINT ibexa_oauth2_client_token_client_fk FOREIGN KEY (client_id) REFERENCES ibexa_oauth2_client (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_client_token ADD CONSTRAINT ibexa_oauth2_client_token_token_fk FOREIGN KEY (token_id) REFERENCES ibexa_token (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_client_scope ADD CONSTRAINT ibexa_oauth2_client_scope_fk FOREIGN KEY (client_id) REFERENCES ibexa_oauth2_client (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_token_scope ADD CONSTRAINT ibexa_oauth2_token_scope_fk FOREIGN KEY (token_id) REFERENCES ibexa_token (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_refresh_access_token ADD CONSTRAINT ibexa_oauth2_refresh_access_token_access_token_fk FOREIGN KEY (access_token_id) REFERENCES ibexa_token (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_refresh_access_token ADD CONSTRAINT ibexa_oauth2_refresh_access_token_refresh_token_fk FOREIGN KEY (refresh_token_id) REFERENCES ibexa_token (id) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_consent ADD CONSTRAINT ibexa_oauth2_consent_user_fk FOREIGN KEY (user_identifier) REFERENCES ezuser (login) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_consent ADD CONSTRAINT ibexa_oauth2_consent_client_fk FOREIGN KEY (client_identifier) REFERENCES ibexa_oauth2_client (client_identifier) ON UPDATE CASCADE ON DELETE CASCADE;

ALTER TABLE ibexa_oauth2_consent_scope ADD CONSTRAINT ibexa_oauth2_consent_scope_fk FOREIGN KEY (consent_id) REFERENCES ibexa_oauth2_consent (id) ON UPDATE CASCADE ON DELETE CASCADE;