File: upgrade-2.7-core.sqlite3.sql

package info (click to toggle)
glewlwyd 2.7.6%2Bds-3
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 18,184 kB
  • sloc: ansic: 143,367; javascript: 25,258; sql: 5,698; sh: 669; makefile: 386
file content (33 lines) | stat: -rw-r--r-- 899 bytes parent folder | download | duplicates (2)
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
-- ----------------------------------------------------- --
-- Upgrade Glewlwyd 2.6.0 2.7.0
-- Copyright 2021 Nicolas Mora <mail@babelouest.org>     --
-- License: MIT                                          --
-- ----------------------------------------------------- --

CREATE TABLE g_misc_config (
  gmc_id INTEGER PRIMARY KEY AUTOINCREMENT,
  gmc_type TEXT NOT NULL,
  gmc_name TEXT,
  gmc_value TEXT
);
CREATE INDEX i_gmc_type ON g_misc_config(gmc_type);
CREATE INDEX i_gmc_name ON g_misc_config(gmc_name);

ALTER TABLE gpo_code
Add gpoc_dpop_jkt TEXT;

ALTER TABLE gpo_device_authorization
Add gpoc_dpop_jkt TEXT;

ALTER TABLE gpo_par
Add gpop_dpop_jkt TEXT;

ALTER TABLE gpo_ciba
Add gpob_dpop_jkt TEXT;

CREATE TABLE gpo_dpop_client_nonce (
  gpodcn_id INTEGER PRIMARY KEY AUTOINCREMENT,
  gpodcn_client_id TEXT NOT NULL,
  gpodcn_nonce TEXT NOT NULL,
  gpodcn_counter INTEGER DEFAULT 0
);