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
|
-- ----------------------------------------------------- --
-- Upgrade Glewlwyd 2.5.0 2.6.0
-- Copyright 2021 Nicolas Mora <mail@babelouest.org> --
-- License: MIT --
-- ----------------------------------------------------- --
ALTER TABLE g_user_auth_scheme_module_instance
ADD guasmi_forbid_user_profile INTEGER DEFAULT 0;
ALTER TABLE g_user_auth_scheme_module_instance
ADD guasmi_forbid_user_reset_credential INTEGER DEFAULT 0;
CREATE TABLE g_user_middleware_module_instance (
gummi_id INTEGER PRIMARY KEY AUTOINCREMENT,
gummi_module TEXT NOT NULL,
gummi_order INTEGER NOT NULL,
gummi_name TEXT NOT NULL,
gummi_display_name TEXT DEFAULT '',
gummi_parameters TEXT,
gummi_enabled INTEGER DEFAULT 1
);
CREATE INDEX i_gpop_client_id ON gpo_par(gpop_client_id);
CREATE TABLE gpo_ciba (
gpob_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpob_plugin_name TEXT NOT NULL,
gpob_client_id TEXT NOT NULL,
gpob_x5t_s256 TEXT,
gpob_username TEXT NOT NULL,
gpob_client_notification_token TEXT,
gpob_jti_hash TEXT,
gpob_auth_req_id TEXT,
gpob_user_req_id TEXT,
gpob_binding_message TEXT,
gpob_sid TEXT,
gpob_status INTEGER DEFAULT 0, -- 0: created, 1: accepted, 2: error, 3: closed
gpob_expires_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
gpob_issued_for TEXT, -- IP address or hostname
gpob_user_agent TEXT,
gpob_enabled INTEGER DEFAULT 1
);
CREATE INDEX i_gpob_client_id ON gpo_ciba(gpob_client_id);
CREATE INDEX i_gpob_jti_hash ON gpo_ciba(gpob_jti_hash);
CREATE INDEX i_gpob_client_notification_token ON gpo_ciba(gpob_client_notification_token);
CREATE INDEX i_gpob_auth_req_id ON gpo_ciba(gpob_auth_req_id);
CREATE INDEX i_gpob_user_req_id ON gpo_ciba(gpob_user_req_id);
CREATE TABLE gpo_ciba_scope (
gpocs_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpob_id INTEGER,
gpops_scope TEXT NOT NULL,
gpobs_granted INTEGER DEFAULT 0,
FOREIGN KEY(gpob_id) REFERENCES gpo_ciba(gpob_id) ON DELETE CASCADE
);
CREATE TABLE gpo_ciba_scheme (
gpobh_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpob_id INTEGER,
gpobh_scheme_module TEXT NOT NULL,
FOREIGN KEY(gpob_id) REFERENCES gpo_ciba(gpob_id) ON DELETE CASCADE
);
ALTER TABLE gpo_code
ADD gpoc_s_hash TEXT;
ALTER TABLE gpo_code
ADD gpoc_sid TEXT;
ALTER TABLE gpo_id_token
ADD gpoc_id INTEGER;
ALTER TABLE gpo_id_token
ADD gpor_id INTEGER;
ALTER TABLE gpo_id_token
ADD gpoi_sid TEXT;
ALTER TABLE gpo_device_authorization
Add gpoda_sid TEXT;
PRAGMA foreign_keys=off;
BEGIN TRANSACTION;
ALTER TABLE gpo_id_token RENAME TO _gpo_id_token_old;
CREATE TABLE gpo_id_token (
gpoi_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpoc_id INTEGER,
gpor_id INTEGER,
gpoi_plugin_name TEXT NOT NULL,
gpoi_authorization_type INTEGER NOT NULL,
gpoi_username TEXT,
gpoi_client_id TEXT,
gpoi_issued_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
gpoi_issued_for TEXT, -- IP address or hostname
gpoi_user_agent TEXT,
gpoi_hash TEXT,
gpoi_sid TEXT,
gpoi_enabled INTEGER DEFAULT 1,
FOREIGN KEY(gpoc_id) REFERENCES gpo_code(gpoc_id) ON DELETE CASCADE,
FOREIGN KEY(gpor_id) REFERENCES gpo_refresh_token(gpor_id) ON DELETE CASCADE
);
INSERT INTO gpo_id_token SELECT * FROM _gpo_id_token_old;
DROP TABLE _gpo_id_token_old;
COMMIT;
PRAGMA foreign_keys=on;
|
