12 lines
558 B
SQL
12 lines
558 B
SQL
CREATE TABLE IF NOT EXISTS directory_settings (
|
|
id TINYINT PRIMARY KEY,
|
|
config_id CHAR(64) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
|
|
enabled BOOLEAN NOT NULL,
|
|
issuer VARCHAR(512) NOT NULL,
|
|
encrypted_config MEDIUMTEXT NOT NULL,
|
|
updated_by CHAR(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
|
|
updated_at VARCHAR(24) NOT NULL
|
|
);
|
|
ALTER TABLE app_users ADD COLUMN IF NOT EXISTS directory_display_name VARCHAR(80) NULL;
|
|
ALTER TABLE app_users ADD COLUMN IF NOT EXISTS directory_config_id CHAR(64) CHARACTER SET ascii COLLATE ascii_bin NULL;
|