Select Git revision
1_setup-schema.sql
1_setup-schema.sql 34.43 KiB
BEGIN;
CREATE TABLE IF NOT EXISTS `mdb_users`
(
id VARCHAR(36) NOT NULL DEFAULT UUID(),
keycloak_id VARCHAR(36) NOT NULL,
username VARCHAR(255) NOT NULL,
firstname VARCHAR(255),
lastname VARCHAR(255),
orcid VARCHAR(255),
affiliation VARCHAR(255),
is_internal BOOLEAN NOT NULL DEFAULT FALSE,
mariadb_password VARCHAR(255) NOT NULL,
theme VARCHAR(255) NOT NULL DEFAULT ('light'),
language VARCHAR(3) NOT NULL DEFAULT ('en'),
PRIMARY KEY (`id`),
UNIQUE (`keycloak_id`),
UNIQUE (`username`)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_images`
(
id VARCHAR(36) NOT NULL DEFAULT UUID(),
registry VARCHAR(255) NOT NULL DEFAULT 'docker.io',
name VARCHAR(255) NOT NULL,
version VARCHAR(255) NOT NULL,
DEFAULT_port INT NOT NULL,
dialect VARCHAR(255) NOT NULL,
driver_class VARCHAR(255) NOT NULL,
jdbc_method VARCHAR(255) NOT NULL,
is_DEFAULT BOOLEAN NOT NULL DEFAULT FALSE,
created TIMESTAMP NOT NULL DEFAULT NOW(),
last_modified TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE (`name`, `version`),
UNIQUE (`is_DEFAULT`)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_containers`
(
id VARCHAR(36) NOT NULL DEFAULT UUID(),
internal_name VARCHAR(255) NOT NULL,
name VARCHAR(255) NOT NULL,
host VARCHAR(255) NOT NULL,
port INT NOT NULL DEFAULT 3306,
ui_host VARCHAR(255) NOT NULL DEFAULT host,
ui_port INT NOT NULL DEFAULT port,
ui_additional_flags TEXT,
image_id VARCHAR(36) NOT NULL,
created TIMESTAMP NOT NULL DEFAULT NOW(),
last_modified TIMESTAMP,
privileged_username VARCHAR(255) NOT NULL,
privileged_password VARCHAR(255) NOT NULL,
quota INT,
PRIMARY KEY (`id`),
FOREIGN KEY (`image_id`) REFERENCES mdb_images (`id`)
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_licenses`
(
identifier VARCHAR(255) NOT NULL,
uri TEXT NOT NULL,
description TEXT NOT NULL,
PRIMARY KEY (`identifier`),
UNIQUE (uri(200))
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_databases`
(
id VARCHAR(36) NOT NULL DEFAULT UUID(),