Skip to content
Snippets Groups Projects
Select Git revision
  • 8e595ab39408347edef26b247985c40b0bb33bab
  • master default protected
  • 551-init-broker-service-permissions
  • dev protected
  • release-1.10 protected
  • 549-test-oai-pmh
  • 545-saving-multiple-times-breaks-pid-metadata
  • release-1.9 protected
  • 499-standalone-compute-service-2
  • 539-load-tests
  • hotfix/helm-chart
  • luca_ba_new_interface
  • 534-bug-when-adding-access-to-user-that-is-not-registered-at-dashboard-service
  • release-1.8 protected
  • 533-integrate-semantic-recommendation
  • feature/openshift
  • 518-spark-doesn-t-map-the-headers-correct
  • 485-fixity-checks
  • 530-various-schema-problems-with-subsets
  • release-1.7 protected
  • fix/auth-service
  • v1.10.1 protected
  • v1.10.0-rc13 protected
  • v1.10.0-rc12 protected
  • v1.10.0-rc11 protected
  • v1.10.0-rc10 protected
  • v1.10.0-rc9 protected
  • v1.10.0-rc8 protected
  • v1.10.0-rc7 protected
  • v1.10.0-rc6 protected
  • v1.10.0-rc5 protected
  • v1.10.0-rc4 protected
  • v1.10.0-rc3 protected
  • v1.10.0-rc2 protected
  • v1.10.0rc1 protected
  • v1.10.0rc0 protected
  • v1.10.0 protected
  • v1.9.3 protected
  • v1.9.2 protected
  • v1.9.2-rc0 protected
  • v1.9.1 protected
41 results

1_setup-schema.sql

Blame
  • 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(),