BEGIN;

CREATE TABLE IF NOT EXISTS `mdb_users`
(
    id               character varying(36)  NOT NULL,
    username         character varying(255) NOT NULL,
    firstname        character varying(255),
    lastname         character varying(255),
    email            character varying(255) NOT NULL,
    orcid            character varying(255),
    affiliation      character varying(255),
    mariadb_password character varying(255) NOT NULL,
    theme            character varying(255) NOT NULL default ('light'),
    language         character varying(3)   NOT NULL default ('en'),
    PRIMARY KEY (id),
    UNIQUE (username),
    UNIQUE (email)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_images`
(
    id            bigint                 NOT NULL AUTO_INCREMENT,
    registry      character varying(255) NOT NULL DEFAULT 'docker.io',
    name          character varying(255) NOT NULL,
    version       character varying(255) NOT NULL,
    default_port  integer                NOT NULL,
    dialect       character varying(255) NOT NULL,
    driver_class  character varying(255) NOT NULL,
    jdbc_method   character varying(255) NOT NULL,
    created       timestamp              NOT NULL DEFAULT NOW(),
    last_modified timestamp,
    PRIMARY KEY (id),
    UNIQUE (name, version)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_images_date`
(
    id              bigint                 NOT NULL AUTO_INCREMENT,
    iid             bigint                 NOT NULL,
    database_format character varying(255) NOT NULL,
    unix_format     character varying(255) NOT NULL,
    example         character varying(255) NOT NULL,
    has_time        boolean                NOT NULL,
    created_at      timestamp              NOT NULL DEFAULT NOW(),
    PRIMARY KEY (id),
    FOREIGN KEY (iid) REFERENCES mdb_images (id),
    UNIQUE (database_format, unix_format, example)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_containers`
(
    id                  bigint                 NOT NULL AUTO_INCREMENT,
    internal_name       character varying(255) NOT NULL,
    name                character varying(255) NOT NULL,
    host                character varying(255) NOT NULL,
    port                integer                NOT NULL default 3306,
    ui_host             character varying(255) NOT NULL default host,
    ui_port             integer                NOT NULL default port,
    ui_additional_flags text,
    sidecar_host        character varying(255),
    sidecar_port        integer,
    image_id            bigint                 NOT NULL,
    created             timestamp              NOT NULL DEFAULT NOW(),
    last_modified       timestamp,
    privileged_username character varying(255) NOT NULL,
    privileged_password character varying(255) NOT NULL,
    quota               integer                NOT NULL DEFAULT 50,
    PRIMARY KEY (id),
    FOREIGN KEY (image_id) REFERENCES mdb_images (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_data`
(
    ID           bigint NOT NULL AUTO_INCREMENT,
    PROVENANCE   text,
    FileEncoding text,
    FileType     character varying(100),
    Version      text,
    Seperator    text,
    PRIMARY KEY (ID)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_licenses`
(
    identifier  character varying(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             bigint                 NOT NULL AUTO_INCREMENT,
    cid            bigint                 NOT NULL,
    name           character varying(255) NOT NULL,
    internal_name  character varying(255) NOT NULL,
    exchange_name  character varying(255) NOT NULL,
    description    text,
    engine         character varying(20),
    is_public      boolean                NOT NULL DEFAULT TRUE,
    image          longblob,
    created_by     character varying(36),
    owned_by       character varying(36),
    contact_person character varying(36),
    created        timestamp              NOT NULL DEFAULT NOW(),
    last_modified  timestamp,
    PRIMARY KEY (id),
    FOREIGN KEY (cid) REFERENCES mdb_containers (id) /* currently we only support one-to-one */,
    FOREIGN KEY (created_by) REFERENCES mdb_users (id),
    FOREIGN KEY (owned_by) REFERENCES mdb_users (id),
    FOREIGN KEY (contact_person) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_databases_subjects`
(
    dbid     BIGINT                 NOT NULL,
    subjects character varying(255) NOT NULL,
    PRIMARY KEY (dbid, subjects)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_tables`
(
    ID              bigint                NOT NULL AUTO_INCREMENT,
    tDBID           bigint                NOT NULL,
    tName           VARCHAR(64)           NOT NULL,
    internal_name   VARCHAR(64)           NOT NULL,
    queue_name      VARCHAR(255)          NOT NULL,
    routing_key     VARCHAR(255),
    tDescription    VARCHAR(2048),
    num_rows        BIGINT,
    data_length     BIGINT,
    max_data_length BIGINT,
    avg_row_length  BIGINT,
    `separator`     CHAR(1),
    quote           CHAR(1),
    element_null    VARCHAR(50),
    skip_lines      BIGINT,
    element_true    VARCHAR(50),
    element_false   VARCHAR(50),
    Version         TEXT,
    created         timestamp             NOT NULL DEFAULT NOW(),
    versioned       boolean               not null default true,
    created_by      character varying(36) NOT NULL,
    owned_by        character varying(36) NOT NULL,
    last_modified   timestamp,
    PRIMARY KEY (ID),
    UNIQUE (tDBID, internal_name),
    FOREIGN KEY (tDBID) REFERENCES mdb_databases (id),
    FOREIGN KEY (created_by) REFERENCES mdb_users (id),
    FOREIGN KEY (owned_by) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_columns`
(
    ID               BIGINT      NOT NULL AUTO_INCREMENT,
    tID              BIGINT      NOT NULL,
    dfID             BIGINT,
    cName            VARCHAR(64),
    internal_name    VARCHAR(64) NOT NULL,
    Datatype         ENUM ('CHAR','VARCHAR','BINARY','VARBINARY','TINYBLOB','TINYTEXT','TEXT','BLOB','MEDIUMTEXT','MEDIUMBLOB','LONGTEXT','LONGBLOB','ENUM','SET','BIT','TINYINT','BOOL','SMALLINT','MEDIUMINT','INT','BIGINT','FLOAT','DOUBLE','DECIMAL','DATE','DATETIME','TIMESTAMP','TIME','YEAR'),
    length           BIGINT      NULL,
    ordinal_position INTEGER     NOT NULL,
    index_length     BIGINT      NULL,
    description      VARCHAR(2048),
    size             BIGINT,
    d                BIGINT,
    auto_generated   BOOLEAN              DEFAULT false,
    is_null_allowed  BOOLEAN     NOT NULL DEFAULT true,
    val_min          NUMERIC     NULL,
    val_max          NUMERIC     NULL,
    mean             NUMERIC     NULL,
    median           NUMERIC     NULL,
    std_dev          Numeric     NULL,
    created          timestamp   NOT NULL DEFAULT NOW(),
    last_modified    timestamp,
    FOREIGN KEY (tID) REFERENCES mdb_tables (ID) ON DELETE CASCADE,
    PRIMARY KEY (ID)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_columns_enums`
(
    id        bigint                 NOT NULL AUTO_INCREMENT,
    column_id bigint                 NOT NULL,
    value     CHARACTER VARYING(255) NOT NULL,
    FOREIGN KEY (column_id) REFERENCES mdb_columns (ID) ON DELETE CASCADE,
    PRIMARY KEY (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_columns_sets`
(
    id        bigint                 NOT NULL AUTO_INCREMENT,
    column_id bigint                 NOT NULL,
    value     CHARACTER VARYING(255) NOT NULL,
    FOREIGN KEY (column_id) REFERENCES mdb_columns (ID) ON DELETE CASCADE,
    PRIMARY KEY (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_columns_nom`
(
    tID           bigint,
    cID           bigint,
    maxlength     INTEGER,
    last_modified timestamp,
    created       timestamp NOT NULL DEFAULT NOW(),
    FOREIGN KEY (tID, cID) REFERENCES mdb_columns (tID, ID),
    PRIMARY KEY (tID, cID)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_columns_cat`
(
    tID           bigint,
    cID           bigint,
    num_cat       INTEGER,
    --    cat_array     TEXT[],
    last_modified timestamp,
    created       timestamp NOT NULL DEFAULT NOW(),
    FOREIGN KEY (tID, cID) REFERENCES mdb_columns (tID, ID),
    PRIMARY KEY (tID, cID)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_constraints_foreign_key`
(
    fkid      BIGINT       NOT NULL AUTO_INCREMENT,
    tid       BIGINT       NOT NULL,
    rtid      BIGINT       NOT NULL,
    name      VARCHAR(255) NOT NULL,
    on_update VARCHAR(50)  NULL,
    on_delete VARCHAR(50)  NULL,
    position  INT          NULL,
    PRIMARY KEY (fkid),
    FOREIGN KEY (tid) REFERENCES mdb_tables (id) ON DELETE CASCADE,
    FOREIGN KEY (rtid) REFERENCES mdb_tables (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_constraints_primary_key`
(
    pkid BIGINT NOT NULL AUTO_INCREMENT,
    tID  BIGINT NOT NULL,
    cid  BIGINT NOT NULL,
    PRIMARY KEY (pkid),
    FOREIGN KEY (tID) REFERENCES mdb_tables (id) ON DELETE CASCADE,
    FOREIGN KEY (cid) REFERENCES mdb_columns (id) ON DELETE CASCADE
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_constraints_foreign_key_reference`
(
    id   BIGINT NOT NULL AUTO_INCREMENT,
    fkid BIGINT NOT NULL,
    cid  BIGINT NOT NULL,
    rcid BIGINT NOT NULL,
    PRIMARY KEY (id),
    UNIQUE (fkid, cid, rcid),
    FOREIGN KEY (fkid) REFERENCES mdb_constraints_foreign_key (fkid) ON UPDATE CASCADE,
    FOREIGN KEY (cid) REFERENCES mdb_columns (id),
    FOREIGN KEY (rcid) REFERENCES mdb_columns (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_constraints_unique`
(
    uid      BIGINT       NOT NULL AUTO_INCREMENT,
    name     VARCHAR(255) NOT NULL,
    tid      BIGINT       NOT NULL,
    position INT          NULL,
    PRIMARY KEY (uid),
    FOREIGN KEY (tid) REFERENCES mdb_tables (id) ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS `mdb_constraints_unique_columns`
(
    id  BIGINT NOT NULL AUTO_INCREMENT,
    uid BIGINT NOT NULL,
    cid BIGINT NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (uid) REFERENCES mdb_constraints_unique (uid),
    FOREIGN KEY (cid) REFERENCES mdb_columns (id) ON DELETE CASCADE
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_constraints_checks`
(
    id     BIGINT       NOT NULL AUTO_INCREMENT,
    tid    BIGINT       NOT NULL,
    checks VARCHAR(255) NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (tid) REFERENCES mdb_tables (id) ON DELETE CASCADE
) WITH SYSTEM VERSIONING;


CREATE TABLE IF NOT EXISTS `mdb_concepts`
(
    id          bigint       NOT NULL AUTO_INCREMENT,
    uri         text         not null,
    name        VARCHAR(255) null,
    description TEXT         null,
    created     timestamp    NOT NULL DEFAULT NOW(),
    PRIMARY KEY (id),
    UNIQUE (uri(200))
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_units`
(
    id          bigint       NOT NULL AUTO_INCREMENT,
    uri         text         not null,
    name        VARCHAR(255) null,
    description TEXT         null,
    created     timestamp    NOT NULL DEFAULT NOW(),
    PRIMARY KEY (id),
    UNIQUE (uri(200))
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_columns_concepts`
(
    id      bigint    NOT NULL,
    cID     bigint    NOT NULL,
    created timestamp NOT NULL DEFAULT NOW(),
    PRIMARY KEY (id, cid),
    FOREIGN KEY (cID) REFERENCES mdb_columns (ID)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_columns_units`
(
    id      bigint    NOT NULL,
    cID     bigint    NOT NULL,
    created timestamp NOT NULL DEFAULT NOW(),
    PRIMARY KEY (id, cID),
    FOREIGN KEY (cID) REFERENCES mdb_columns (ID)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_view`
(
    id            bigint                NOT NULL AUTO_INCREMENT,
    vdbid         bigint                NOT NULL,
    vName         VARCHAR(64)           NOT NULL,
    internal_name VARCHAR(64)           NOT NULL,
    Query         TEXT                  NOT NULL,
    query_hash    VARCHAR(255)          NOT NULL,
    Public        BOOLEAN               NOT NULL,
    InitialView   BOOLEAN               NOT NULL,
    created       timestamp             NOT NULL DEFAULT NOW(),
    last_modified timestamp,
    created_by    character varying(36) NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (vdbid) REFERENCES mdb_databases (id),
    FOREIGN KEY (created_by) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_banner_messages`
(
    id            bigint                            NOT NULL AUTO_INCREMENT,
    type          ENUM ('ERROR', 'WARNING', 'INFO') NOT NULL default 'INFO',
    message       TEXT                              NOT NULL,
    link          TEXT                              NULL,
    link_text     VARCHAR(255)                      NULL,
    display_start timestamp                         NULL,
    display_end   timestamp                         NULL,
    PRIMARY KEY (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_ontologies`
(
    id              bigint     NOT NULL AUTO_INCREMENT,
    prefix          VARCHAR(8) NOT NULL,
    uri             TEXT       NOT NULL,
    uri_pattern     TEXT,
    sparql_endpoint TEXT       NULL,
    rdf_path        TEXT       NULL,
    last_modified   timestamp,
    created         timestamp  NOT NULL DEFAULT NOW(),
    UNIQUE (prefix),
    UNIQUE (uri(200)),
    PRIMARY KEY (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_view_columns`
(
    id               BIGINT      NOT NULL AUTO_INCREMENT,
    view_id          BIGINT      NOT NULL,
    dfID             BIGINT,
    name             VARCHAR(64),
    internal_name    VARCHAR(64) NOT NULL,
    column_type      ENUM ('CHAR','VARCHAR','BINARY','VARBINARY','TINYBLOB','TINYTEXT','TEXT','BLOB','MEDIUMTEXT','MEDIUMBLOB','LONGTEXT','LONGBLOB','ENUM','SET','BIT','TINYINT','BOOL','SMALLINT','MEDIUMINT','INT','BIGINT','FLOAT','DOUBLE','DECIMAL','DATE','DATETIME','TIMESTAMP','TIME','YEAR'),
    ordinal_position INTEGER     NOT NULL,
    size             BIGINT,
    d                BIGINT,
    auto_generated   BOOLEAN              DEFAULT false,
    is_null_allowed  BOOLEAN     NOT NULL DEFAULT true,
    PRIMARY KEY (id),
    FOREIGN KEY (view_id) REFERENCES mdb_view (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_identifiers`
(
    id                BIGINT                                       NOT NULL AUTO_INCREMENT,
    dbid              BIGINT                                       NOT NULL,
    qid               BIGINT,
    vid               BIGINT,
    tid               BIGINT,
    publisher         VARCHAR(255)                                 NOT NULL,
    language          VARCHAR(2),
    publication_year  INTEGER                                      NOT NULL,
    publication_month INTEGER,
    publication_day   INTEGER,
    identifier_type   ENUM ('DATABASE', 'SUBSET', 'VIEW', 'TABLE') NOT NULL,
    status            ENUM ('DRAFT', 'PUBLISHED')                  NOT NULL DEFAULT ('PUBLISHED'),
    query             TEXT,
    query_normalized  TEXT,
    query_hash        VARCHAR(255),
    execution         TIMESTAMP,
    result_hash       VARCHAR(255),
    result_number     BIGINT,
    doi               VARCHAR(255),
    created           TIMESTAMP                                    NOT NULL DEFAULT NOW(),
    created_by        VARCHAR(36)                                  NOT NULL,
    last_modified     TIMESTAMP,
    PRIMARY KEY (id), /* must be a single id from persistent identifier concept */
    FOREIGN KEY (dbid) REFERENCES mdb_databases (id),
    FOREIGN KEY (created_by) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_identifier_licenses`
(
    pid        bigint       NOT NULL,
    license_id VARCHAR(255) NOT NULL,
    PRIMARY KEY (pid, license_id),
    FOREIGN KEY (pid) REFERENCES mdb_identifiers (id),
    FOREIGN KEY (license_id) REFERENCES mdb_licenses (identifier)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_identifier_titles`
(
    id         bigint NOT NULL AUTO_INCREMENT,
    pid        bigint NOT NULL,
    title      text   NOT NULL,
    title_type ENUM ('ALTERNATIVE_TITLE', 'SUBTITLE', 'TRANSLATED_TITLE', 'OTHER'),
    language   VARCHAR(2),
    PRIMARY KEY (id),
    FOREIGN KEY (pid) REFERENCES mdb_identifiers (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_identifier_funders`
(
    id                     bigint       NOT NULL AUTO_INCREMENT,
    pid                    bigint       NOT NULL,
    funder_name            VARCHAR(255) NOT NULL,
    funder_identifier      TEXT,
    funder_identifier_type ENUM ('CROSSREF_FUNDER_ID', 'GRID', 'ISNI', 'ROR', 'OTHER'),
    scheme_uri             text,
    award_number           VARCHAR(255),
    award_title            text,
    language               VARCHAR(255),
    PRIMARY KEY (id),
    FOREIGN KEY (pid) REFERENCES mdb_identifiers (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_identifier_descriptions`
(
    id               bigint NOT NULL AUTO_INCREMENT,
    pid              bigint NOT NULL,
    description      text   NOT NULL,
    description_type ENUM ('ABSTRACT', 'METHODS', 'SERIES_INFORMATION', 'TABLE_OF_CONTENTS', 'TECHNICAL_INFO', 'OTHER'),
    language         VARCHAR(2),
    PRIMARY KEY (id),
    FOREIGN KEY (pid) REFERENCES mdb_identifiers (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_related_identifiers`
(
    id       bigint       NOT NULL AUTO_INCREMENT,
    pid      bigint       NOT NULL,
    value    varchar(255) NOT NULL,
    type     varchar(255) NOT NULL,
    relation varchar(255) NOT NULL,
    PRIMARY KEY (id), /* must be a single id from persistent identifier concept */
    FOREIGN KEY (pid) REFERENCES mdb_identifiers (id),
    UNIQUE (pid, value)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_identifier_creators`
(
    id                                bigint       NOT NULL AUTO_INCREMENT,
    pid                               bigint       NOT NULL,
    given_names                       text,
    family_name                       text,
    creator_name                      VARCHAR(255) NOT NULL,
    name_type                         ENUM ('PERSONAL', 'ORGANIZATIONAL') default 'PERSONAL',
    name_identifier                   text,
    name_identifier_scheme            ENUM ('ROR', 'GRID', 'ISNI', 'ORCID'),
    name_identifier_scheme_uri        text,
    affiliation                       VARCHAR(255),
    affiliation_identifier            text,
    affiliation_identifier_scheme     ENUM ('ROR', 'GRID', 'ISNI'),
    affiliation_identifier_scheme_uri text,
    PRIMARY KEY (id),
    FOREIGN KEY (pid) REFERENCES mdb_identifiers (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_update`
(
    uUserID character varying(255) NOT NULL,
    uDBID   bigint                 NOT NULL,
    created timestamp              NOT NULL DEFAULT NOW(),
    PRIMARY KEY (uUserID, uDBID),
    FOREIGN KEY (uDBID) REFERENCES mdb_databases (id)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_access`
(
    aUserID  character varying(255) NOT NULL,
    aDBID    bigint REFERENCES mdb_databases (id),
    attime   TIMESTAMP,
    download BOOLEAN,
    created  timestamp              NOT NULL DEFAULT NOW(),
    PRIMARY KEY (aUserID, aDBID)
) WITH SYSTEM VERSIONING;

CREATE TABLE IF NOT EXISTS `mdb_have_access`
(
    user_id     character varying(36)                   NOT NULL,
    database_id bigint REFERENCES mdb_databases (id),
    access_type ENUM ('READ', 'WRITE_OWN', 'WRITE_ALL') NOT NULL,
    created     timestamp                               NOT NULL DEFAULT NOW(),
    PRIMARY KEY (user_id, database_id),
    FOREIGN KEY (user_id) REFERENCES mdb_users (id)
) WITH SYSTEM VERSIONING;

COMMIT;
BEGIN;

INSERT INTO `mdb_licenses` (identifier, uri, description)
VALUES ('CC0-1.0', 'https://creativecommons.org/publicdomain/zero/1.0/legalcode',
        'CC0 waives copyright interest in a work you''ve created and dedicates it to the world-wide public domain. Use CC0 to opt out of copyright entirely and ensure your work has the widest reach.'),
       ('CC-BY-4.0', 'https://creativecommons.org/licenses/by/4.0/legalcode',
        'The Creative Commons Attribution license allows re-distribution and re-use of a licensed work on the condition that the creator is appropriately credited.');

INSERT INTO `mdb_images` (name, registry, version, default_port, dialect, driver_class, jdbc_method)
VALUES ('mariadb', 'docker.io', '11.1.3', 3306, 'org.hibernate.dialect.MariaDBDialect', 'org.mariadb.jdbc.Driver',
        'mariadb');

INSERT INTO `mdb_images_date` (iid, database_format, unix_format, example, has_time)
VALUES (1, '%Y-%c-%d %H:%i:%S.%f', 'yyyy-MM-dd HH:mm:ss.SSSSSS', '2022-01-30 13:44:25.499', true),
       (1, '%Y-%c-%d %H:%i:%S', 'yyyy-MM-dd HH:mm:ss', '2022-01-30 13:44:25', true),
       (1, '%Y-%c-%d', 'yyyy-MM-dd', '2022-01-30', false),
       (1, '%H:%i:%S', 'HH:mm:ss', '13:44:25', true),
       (1, '%d.%c.%Y', 'dd.MM.yyyy', '30.01.2022', false);

INSERT INTO `mdb_ontologies` (prefix, uri, uri_pattern, sparql_endpoint, rdf_path)
VALUES ('om', 'http://www.ontology-of-units-of-measure.org/resource/om-2/',
        'http://www.ontology-of-units-of-measure.org/resource/om-2/.*', null, 'rdf/om-2.0.rdf'),
       ('wd', 'http://www.wikidata.org/', 'http://www.wikidata.org/entity/.*', 'https://query.wikidata.org/sparql',
        null),
       ('mo', 'http://purl.org/ontology/mo/', 'http://purl.org/ontology/mo/.*', null, null),
       ('dc', 'http://purl.org/dc/elements/1.1/', null, null, null),
       ('xsd', 'http://www.w3.org/2001/XMLSchema#', null, null, null),
       ('tl', 'http://purl.org/NET/c4dm/timeline.owl#', null, null, null),
       ('foaf', 'http://xmlns.com/foaf/0.1/', null, null, null),
       ('schema', 'http://schema.org/', null, null, null),
       ('rdf', 'http://www.w3.org/1999/02/22-rdf-syntax-ns#', null, null, null),
       ('rdfs', 'http://www.w3.org/2000/01/rdf-schema#', null, null, null),
       ('owl', 'http://www.w3.org/2002/07/owl#', null, null, null),
       ('prov', 'http://www.w3.org/ns/prov#', null, null, null),
       ('db', 'http://dbpedia.org', 'http://dbpedia.org/ontology/.*', 'http://dbpedia.org/sparql', null);
COMMIT;