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
|
-- ----------------------------------------------------- --
-- Upgrade Glewlwyd 2.4.0 2.5.0
-- Copyright 2020 Nicolas Mora <mail@babelouest.org> --
-- License: MIT --
-- ----------------------------------------------------- --
ALTER TABLE g_user_module_instance
ADD gumi_multiple_passwords INTEGER DEFAULT 0;
ALTER TABLE gpo_code
ADD gpoc_resource TEXT;
ALTER TABLE gpo_refresh_token
ADD gpor_resource TEXT;
ALTER TABLE gpo_access_token
ADD gpoa_resource TEXT;
ALTER TABLE gpo_device_authorization
ADD gpoda_resource TEXT;
CREATE TABLE gpo_dpop (
gpod_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpod_plugin_name INTEGER NOT NULL,
gpod_client_id INTEGER NOT NULL,
gpod_jti_hash INTEGER NOT NULL,
gpod_jkt INTEGER NOT NULL,
gpod_htm INTEGER NOT NULL,
gpod_htu INTEGER NOT NULL,
gpod_iat TIMESTAMP NOT NULL,
gpod_last_seen TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX i_gpod_jti_hash ON gpo_dpop(gpod_jti_hash);
CREATE TABLE g_user_password (
guw_id INTEGER PRIMARY KEY AUTOINCREMENT,
gu_id INTEGER,
guw_password TEXT,
FOREIGN KEY(gu_id) REFERENCES g_user(gu_id) ON DELETE CASCADE
);
INSERT INTO g_user_password (gu_id, guw_password)
SELECT gu_id, gu_password FROM g_user;
-- SQLite3 doesn't support DROP COLUMN, using a backup table to remove this column is dangerous because of all the foreign keys.
-- So instead I'll set the old gu_password to NULL
UPDATE g_user SET gu_password=NULL;
ALTER TABLE gpo_code
ADD gpoc_authorization_details TEXT DEFAULT NULL;
ALTER TABLE gpo_refresh_token
ADD gpor_authorization_details TEXT DEFAULT NULL;
ALTER TABLE gpo_refresh_token
ADD gpor_dpop_jkt TEXT;
ALTER TABLE gpo_access_token
ADD gpoa_authorization_details TEXT DEFAULT NULL;
ALTER TABLE gpo_device_authorization
ADD gpoda_authorization_details TEXT DEFAULT NULL;
CREATE TABLE gpo_rar (
gporar_id INTEGER PRIMARY KEY AUTOINCREMENT,
gporar_plugin_name TEXT NOT NULL,
gporar_client_id TEXT NOT NULL,
gporar_type TEXT NOT NULL,
gporar_username TEXT,
gporar_consent INTEGER DEFAULT 0,
gporar_enabled INTEGER DEFAULT 1
);
CREATE INDEX i_gporar_client_id ON gpo_rar(gporar_client_id);
CREATE INDEX i_gporar_type ON gpo_rar(gporar_type);
CREATE INDEX i_gporar_username ON gpo_rar(gporar_username);
CREATE TABLE gpo_par (
gpop_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpop_plugin_name TEXT NOT NULL,
gpop_response_type TEXT NOT NULL,
gpop_state TEXT,
gpop_username TEXT,
gpop_client_id TEXT NOT NULL,
gpop_redirect_uri TEXT NOT NULL,
gpop_request_uri_hash TEXT NOT NULL,
gpop_nonce TEXT,
gpop_code_challenge TEXT,
gpop_resource TEXT,
gpop_claims_request TEXT DEFAULT NULL,
gpop_authorization_details TEXT DEFAULT NULL,
gpop_additional_parameters TEXT DEFAULT NULL,
gpop_status INTEGER DEFAULT 0, -- 0 created, 1 validated, 2 completed
gpop_expires_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
gpop_issued_for TEXT, -- IP address or hostname
gpop_user_agent TEXT
);
CREATE INDEX i_gpop_request_uri_hash ON gpo_par(gpop_request_uri_hash);
CREATE INDEX i_gpop_code_challenge ON gpo_par(gpop_code_challenge);
CREATE TABLE gpo_par_scope (
gpops_id INTEGER PRIMARY KEY AUTOINCREMENT,
gpop_id INTEGER,
gpops_scope TEXT NOT NULL,
FOREIGN KEY(gpop_id) REFERENCES gpo_par(gpop_id) ON DELETE CASCADE
);
|
