#!/bin/bash

    mysql -unetroot -pnetroot -e "

    create database if not exists artixcs_struct character set 'utf8';

    use artixcs_struct;

    BEGIN;
    CREATE TABLE IF NOT EXISTS logging_event_ext
    (
    timestmp         BIGINT NOT NULL,
    formatted_message  TEXT NOT NULL,
    logger_name       VARCHAR(254) NOT NULL,
    level_string      VARCHAR(254) NOT NULL,
    thread_name       VARCHAR(254),
    reference_flag    SMALLINT,
    arg0              VARCHAR(254),
    arg1              VARCHAR(254),
    arg2              VARCHAR(254),
    arg3              VARCHAR(254),
    caller_filename   VARCHAR(254) NOT NULL,
    caller_class      VARCHAR(254) NOT NULL,
    caller_method     VARCHAR(254) NOT NULL,
    caller_line       CHAR(4) NOT NULL,
    CODE              VARCHAR(254),
    TYPE              VARCHAR(254),
    event_id          BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    INDEX \`timeindex\` (\`timestmp\`), INDEX \`codeindex\` (\`code\`)
    );

    COMMIT;"