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
|
-- ----------------------------------------------------- --
-- Upgrade Glewlwyd 2.0.x or 2.1.x to 2.2.0
-- Copyright 2020 Nicolas Mora <mail@babelouest.org> --
-- License: MIT --
-- ----------------------------------------------------- --
ALTER TABLE g_user_module_instance
ADD gumi_enabled INTEGER DEFAULT 1;
ALTER TABLE g_user_auth_scheme_module_instance
ADD guasmi_enabled INTEGER DEFAULT 1;
ALTER TABLE g_client_module_instance
ADD gcmi_enabled INTEGER DEFAULT 1;
ALTER TABLE g_plugin_module_instance
ADD gpmi_enabled INTEGER DEFAULT 1;
ALTER TABLE gpg_code
ADD gpgc_code_challenge TEXT;
CREATE INDEX i_gpgc_code_challenge ON gpg_code(gpgc_code_challenge);
ALTER TABLE gpg_access_token
ADD gpga_token_hash TEXT NOT NULL DEFAULT '';
ALTER TABLE gpg_access_token
ADD gpga_enabled INTEGER DEFAULT 1;
CREATE INDEX i_gpga_token_hash ON gpg_access_token(gpga_token_hash);
ALTER TABLE gpo_code
ADD gpoc_code_challenge TEXT;
CREATE INDEX i_gpoc_code_challenge ON gpo_code(gpoc_code_challenge);
ALTER TABLE gpo_access_token
ADD gpoa_token_hash TEXT NOT NULL DEFAULT '';
ALTER TABLE gpo_access_token
ADD gpoa_enabled INTEGER DEFAULT 1;
CREATE INDEX i_gpoa_token_hash ON gpo_access_token(gpoa_token_hash);
ALTER TABLE gpo_id_token
ADD gpoi_enabled INTEGER DEFAULT 1;
CREATE INDEX i_gpoi_hash ON gpo_id_token(gpoi_hash);
-- store meta information on client registration
CREATE TABLE gpo_client_registration (
gpocr_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpocr_plugin_name TEXT NOT NULL,
gpocr_cient_id TEXT NOT NULL,
gpocr_created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
gpoa_id INTEGER,
gpocr_issued_for TEXT, -- IP address or hostname
gpocr_user_agent TEXT,
FOREIGN KEY(gpoa_id) REFERENCES gpo_access_token(gpoa_id) ON DELETE CASCADE
);
CREATE TABLE gs_oauth2_registration (
gsor_id INTEGER PRIMARY KEY AUTOINCREMENT,
gsor_mod_name TEXT NOT NULL,
gsor_provider TEXT NOT NULL,
gsor_created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
gsor_username TEXT NOT NULL,
gsor_userinfo_sub TEXT
);
CREATE INDEX i_gsor_username ON gs_oauth2_registration(gsor_username);
CREATE TABLE gs_oauth2_session (
gsos_id INTEGER PRIMARY KEY AUTOINCREMENT,
gsor_id INTEGER,
gsos_created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
gsos_expires_at TIMESTAMP,
gsos_state TEXT NOT NULL,
gsos_session_export TEXT,
gsos_status INTEGER DEFAULT 0, -- 0: registration, 1: authentication, 2: verified, 3: cancelled
FOREIGN KEY(gsor_id) REFERENCES gs_oauth2_registration(gsor_id) ON DELETE CASCADE
);
-- store meta information about client request on token endpoint
CREATE TABLE gpo_client_token_request (
gpoctr_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpoctr_plugin_name TEXT NOT NULL,
gpoctr_cient_id TEXT NOT NULL,
gpoctr_created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
gpoctr_issued_for TEXT, -- IP address or hostname
gpoctr_jti_hash TEXT
);
|
