#
# Add SQL definition of database tables
#


CREATE TABLE pages
(
    tx_umj_sitepackage_heromodule_title                 text,
    tx_umj_sitepackage_heromodule_description           text,
    tx_umj_sitepackage_heromodule_image                 int(11) unsigned DEFAULT '0' NOT NULL,
    tx_umj_sitepackage_heromodule_disable_today_button  int(11) unsigned DEFAULT '0' NOT NULL,
    tx_umj_sitepackage_heromodule_disable_opening       int(11) unsigned DEFAULT '0' NOT NULL,
    tx_umj_sitepackage_heromodule_primary_button        varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_secondary_button      varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_primary_button_text   varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_secondary_button_text varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_sitecolor                        varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_additional_opening    varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_subtitle              varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_heute_button_kalender_link  varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_kunsthaus_button_kalender  varchar(255)     DEFAULT ''  NOT NULL,


    tx_umj_sitepackage_page_status_data_migration         varchar(255)     DEFAULT ''  NOT NULL,

    tx_umj_sitepackage_menu_overlay_teaser_type         varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_menu_overlay_teaser_link         varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_menu_overlay_teaser_title        varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_menu_overlay_teaser_text         text,
    tx_umj_sitepackage_menu_overlay_teaser_image        int(11) unsigned DEFAULT '0' NOT NULL,


    tx_umj_sitepackage_h01_text                         varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_h01_link                         varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_h01_show                         int(11) unsigned DEFAULT '0' NOT NULL,
    tx_umj_sitepackage_h01_type                         varchar(255)     DEFAULT ''  NOT NULL,

    tx_umj_sitepackage_ticketbutton_text                         varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_ticketbutton_link                         varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_show_ticketbutton                         int(11) unsigned DEFAULT '0' NOT NULL,

    tx_umj_sitepackage_pagelisting_title                varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_pagelisting_subtitle             varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_pagelisting_text                 text,
    tx_umj_sitepackage_pagelisting_image                int(11) unsigned DEFAULT '0' NOT NULL,


    tx_umj_sitepackage_kunsthaus_hero       int(11) unsigned    DEFAULT '0',
    tx_umj_sitepackage_heromodule_kunsthaus_images       int(11) unsigned    DEFAULT '0',


    tx_umj_next_prev_page_hide                          tinyint(4)       DEFAULT '0' NOT NULL

);


CREATE TABLE sys_file_metadata
(
    image_credits text
);


CREATE TABLE ms_kupferstiche_metadata
(
    image_file_name varchar(255) DEFAULT '' NOT NULL primary key,
    inventory_number varchar(255) DEFAULT '' NOT NULL,
    artist text,
    title text,
    technique varchar(255),
    size text,
    collection text,
    licenze varchar(255) DEFAULT '' NOT NULL,
    owner text
);


CREATE TABLE sys_file_reference
(
    image_credits text,

    tx_umj_sitepackage_e03_file_primary_button_text               varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_e03_file_primary_button                    varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_e03_file_popup_button                      int(11) unsigned DEFAULT '0' NOT NULL,
    tx_umj_sitepackage_heromodule_kunsthaus_title                 text,
    tx_umj_sitepackage_heromodule_kunsthaus_subtitle              text,
    tx_umj_sitepackage_heromodule_kunsthaus_description           text,
    tx_umj_sitepackage_heromodule_kunsthaus_disable_today_button  int(11) unsigned DEFAULT '0' NOT NULL,
    tx_umj_sitepackage_heromodule_kunsthaus_textcolor             varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_kunsthaus_sitecolor             varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_kunsthaus_primary_button        varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_kunsthaus_secondary_button      varchar(255)    DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_kunsthaus_primary_button_text   varchar(255)     DEFAULT ''  NOT NULL,
    tx_umj_sitepackage_heromodule_kunsthaus_secondary_button_text varchar(255)     DEFAULT ''  NOT NULL

);

CREATE TABLE tx_umjsitepackage_formlog
(
    uid         int auto_increment
        primary key,
    pid         int           not null,
    tstamp      int(20)       not null,
    form        varchar(255)   not null,
    data        text          not null,
    data_serial text          not null,
    deleted     int default 0 not null
);

CREATE TABLE tx_ms_sendCRMRequest_log
(
    uid               int auto_increment
        primary key,
    crdate            int(21)      not null,
    tstamp            int(21)      not null,
    data_argument     text         not null,
    function_argument varchar(255) not null,
    curl_return       text         not null
);

create table tx_msinclude_jonneumskarte_bestell_optin
(
    id             int auto_increment
        primary key,
    request        mediumtext    null,
    optin_key      varchar(250)  null,
    optin_finished int           null,
    create_date    timestamp     null,
    send_to_crm    int default 0 null
);

#
# Table structure for table 'tx_msmpay24_domain_model_transaction'
#
CREATE TABLE tx_msmpay24_domain_model_transaction
(

    uid              int(11)                         NOT NULL auto_increment,
    pid              int(11)             DEFAULT '0' NOT NULL,

    nr               varchar(255)        DEFAULT ''  NOT NULL,
    customer_id      varchar(255)        DEFAULT ''  NOT NULL,
    success          varchar(255)        DEFAULT ''  NOT NULL,
    order_nr         varchar(255)        DEFAULT ''  NOT NULL,
    payment_type     varchar(255)        DEFAULT ''  NOT NULL,
    mpay_id          varchar(255)        DEFAULT ''  NOT NULL,
    mpay_status      varchar(255)        DEFAULT ''  NOT NULL,
    order_id         int(11) unsigned    DEFAULT '0',

    tstamp           int(11) unsigned    DEFAULT '0' NOT NULL,
    crdate           int(11) unsigned    DEFAULT '0' NOT NULL,
    cruser_id        int(11) unsigned    DEFAULT '0' NOT NULL,
    deleted          tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden           tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime        int(11) unsigned    DEFAULT '0' NOT NULL,
    endtime          int(11) unsigned    DEFAULT '0' NOT NULL,

    t3ver_oid        int(11)             DEFAULT '0' NOT NULL,
    t3ver_id         int(11)             DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)             DEFAULT '0' NOT NULL,
    t3ver_label      varchar(255)        DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)          DEFAULT '0' NOT NULL,
    t3ver_stage      int(11)             DEFAULT '0' NOT NULL,
    t3ver_count      int(11)             DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)             DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)             DEFAULT '0' NOT NULL,

    t3_origuid       int(11)             DEFAULT '0' NOT NULL,
    sys_language_uid int(11)             DEFAULT '0' NOT NULL,
    l10n_parent      int(11)             DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumblob,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid, t3ver_wsid),
    KEY language (l10n_parent, sys_language_uid)

);

#
# Table structure for table 'tx_msmpay24_domain_model_order'
#
CREATE TABLE tx_msmpay24_domain_model_order
(

    uid              int(11)                         NOT NULL auto_increment,
    pid              int(11)             DEFAULT '0' NOT NULL,

    first_name       varchar(255)        DEFAULT ''  NOT NULL,
    last_name        varchar(255)        DEFAULT ''  NOT NULL,
    payment          varchar(255)        DEFAULT ''  NOT NULL,
    data             text                            NOT NULL,

    tstamp           int(11) unsigned    DEFAULT '0' NOT NULL,
    crdate           int(11) unsigned    DEFAULT '0' NOT NULL,
    cruser_id        int(11) unsigned    DEFAULT '0' NOT NULL,
    deleted          tinyint(4) unsigned DEFAULT '0' NOT NULL,
    hidden           tinyint(4) unsigned DEFAULT '0' NOT NULL,
    starttime        int(11) unsigned    DEFAULT '0' NOT NULL,
    endtime          int(11) unsigned    DEFAULT '0' NOT NULL,

    t3ver_oid        int(11)             DEFAULT '0' NOT NULL,
    t3ver_id         int(11)             DEFAULT '0' NOT NULL,
    t3ver_wsid       int(11)             DEFAULT '0' NOT NULL,
    t3ver_label      varchar(255)        DEFAULT ''  NOT NULL,
    t3ver_state      tinyint(4)          DEFAULT '0' NOT NULL,
    t3ver_stage      int(11)             DEFAULT '0' NOT NULL,
    t3ver_count      int(11)             DEFAULT '0' NOT NULL,
    t3ver_tstamp     int(11)             DEFAULT '0' NOT NULL,
    t3ver_move_id    int(11)             DEFAULT '0' NOT NULL,

    t3_origuid       int(11)             DEFAULT '0' NOT NULL,
    sys_language_uid int(11)             DEFAULT '0' NOT NULL,
    l10n_parent      int(11)             DEFAULT '0' NOT NULL,
    l10n_diffsource  mediumblob,

    PRIMARY KEY (uid),
    KEY parent (pid),
    KEY t3ver_oid (t3ver_oid, t3ver_wsid),
    KEY language (l10n_parent, sys_language_uid)

);

CREATE TABLE `tx_ms_formular_crm_log` (
     `uid` int(11) NOT NULL AUTO_INCREMENT,
     `tstamp` int(20) DEFAULT NULL,
     `crdate` int(20) DEFAULT NULL,
     `formName` varchar(255) DEFAULT NULL,
     `data` text,
     `serial_data` text,
     `status` varchar(32) DEFAULT NULL,
     PRIMARY KEY (`uid`)
);

CREATE TABLE tx_msprinthome_domain_model_vorlage (

     uid int(11) NOT NULL auto_increment,
     pid int(11) DEFAULT '0' NOT NULL,

     name varchar(255) DEFAULT '' NOT NULL,
     template_relation int(11) unsigned DEFAULT '0' NOT NULL,


     tstamp int(11) unsigned DEFAULT '0' NOT NULL,
     crdate int(11) unsigned DEFAULT '0' NOT NULL,
     cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
     deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
     hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
     starttime int(11) unsigned DEFAULT '0' NOT NULL,
     endtime int(11) unsigned DEFAULT '0' NOT NULL,
     sorting int(11) unsigned DEFAULT '0' NOT NULL,

     t3ver_oid int(11) DEFAULT '0' NOT NULL,
     t3ver_id int(11) DEFAULT '0' NOT NULL,
     t3ver_wsid int(11) DEFAULT '0' NOT NULL,
     t3ver_label varchar(255) DEFAULT '' NOT NULL,
     t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
     t3ver_stage int(11) DEFAULT '0' NOT NULL,
     t3ver_count int(11) DEFAULT '0' NOT NULL,
     t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
     t3ver_move_id int(11) DEFAULT '0' NOT NULL,

     t3_origuid int(11) DEFAULT '0' NOT NULL,
     sys_language_uid int(11) DEFAULT '0' NOT NULL,
     l10n_parent int(11) DEFAULT '0' NOT NULL,
     l10n_diffsource mediumblob,

     PRIMARY KEY (uid),
     KEY parent (pid),
     KEY t3ver_oid (t3ver_oid,t3ver_wsid),
     KEY language (l10n_parent,sys_language_uid)

);



CREATE TABLE tx_umjsitepackage_domain_model_duobleoptin (

     uid int(11) NOT NULL auto_increment,
     pid int(11) DEFAULT '0' NOT NULL,

     data   text             DEFAULT '',
     form_key varchar(128) not null,

     confirm_token varchar(128) not null,
     delete_token varchar(128) not null,
     confirm_ip varchar(39) null,

     tstamp int default '0' not null,
     crdate int default '0' not null,
     cruser_id int default '0' not null,
     ip varchar(50) DEFAULT '' NOT NULL,
     optin smallint(6) default '0' not null,
     optin_tstamp int default '0' not null,


     PRIMARY KEY (uid)
);


CREATE TABLE `pers_personaldaten` (
    `unique_id` char(36) NOT NULL,
    `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
    `crm_id` char(36) NOT NULL,
    `date_entered` datetime NOT NULL,
    `finished_site` int(11) NOT NULL DEFAULT '0',
    `abteilung` varchar(255) NOT NULL DEFAULT '',
    `bereich` varchar(255) NOT NULL DEFAULT '',
    `vorgesetzter` varchar(255) DEFAULT NULL,
    `ansprechpartner` varchar(255) DEFAULT NULL,
    `stellenbezeichnung` varchar(255) NOT NULL DEFAULT '',
    `dienstort` varchar(255) NOT NULL DEFAULT '',
    `anrede` varchar(10) NOT NULL DEFAULT '',
    `vorname` varchar(100) NOT NULL DEFAULT '',
    `nachname` varchar(100) NOT NULL DEFAULT '',
    `email` varchar(100) NOT NULL DEFAULT '',
    `eu_buerger` tinyint(1) DEFAULT NULL,
    `wochenstunden` varchar(100) NOT NULL DEFAULT '',
    `wochenstunden_proz` varchar(100) NOT NULL DEFAULT '',
    `aufstockung` varchar(100) NOT NULL DEFAULT '',
    `aufstockung_von` date DEFAULT NULL,
    `aufstockung_bis` date DEFAULT NULL,
    `eintritt` date DEFAULT NULL,
    `befristet` date DEFAULT NULL,
    `befristet_text` varchar(255) NOT NULL DEFAULT '',
    `arbeit_mo` tinyint(1) NOT NULL DEFAULT '0',
    `arbeit_di` tinyint(1) NOT NULL DEFAULT '0',
    `arbeit_mi` tinyint(1) NOT NULL DEFAULT '0',
    `arbeit_do` tinyint(1) NOT NULL DEFAULT '0',
    `arbeit_fr` tinyint(1) NOT NULL DEFAULT '0',
    `arbeit_sa` tinyint(1) NOT NULL DEFAULT '0',
    `arbeit_so` tinyint(1) NOT NULL DEFAULT '0',
    `haupt_kostenstelle` varchar(100) NOT NULL DEFAULT '',
    `haupt_kostenstelle_proz` varchar(100) NOT NULL DEFAULT '',
    `haupt_kostentraeger` varchar(100) NOT NULL DEFAULT '',
    `haupt_kostentraeger_proz` varchar(100) NOT NULL DEFAULT '',
    `zus_kostenstelle` text NOT NULL,
    `zus_kostenstelle_proz` text NOT NULL,
    `zus_kostentraeger` text NOT NULL,
    `zus_kostentraeger_proz` text NOT NULL,
    `einstufung` varchar(255) NOT NULL DEFAULT '',
    `bruttolohn` varchar(255) NOT NULL DEFAULT '',
    `datum_vorrueckung` varchar(255) NOT NULL DEFAULT '',
    `dienstgeber` text NOT NULL,
    `taetigkeit` text NOT NULL,
    `dienstgeber_von` varchar(255) NOT NULL DEFAULT '',
    `dienstgeber_bis` varchar(255) NOT NULL DEFAULT '',
    `dienstgeber_jahre` varchar(255) NOT NULL DEFAULT '',
    `dienstgeber_monate` varchar(255) NOT NULL DEFAULT '',
    `dienstgeber_tage` varchar(255) NOT NULL DEFAULT '',
    `anrechnungszeiten_jahre` varchar(255) NOT NULL DEFAULT '',
    `anrechnungszeiten_monate` varchar(255) NOT NULL DEFAULT '',
    `anrechnungszeiten_tage` varchar(255) NOT NULL DEFAULT '',
    `titel` varchar(100) NOT NULL DEFAULT '',
    `titel_pre` varchar(100) NOT NULL DEFAULT '',
    `titel_post` varchar(100) NOT NULL DEFAULT '',
    `familienstand` varchar(100) NOT NULL DEFAULT '',
    `sozialversicherungsnummer` varchar(100) NOT NULL DEFAULT '',
    `staatsbuergerschaft` varchar(100) NOT NULL DEFAULT '',
    `geburtsdatum` varchar(100) DEFAULT NULL,
    `geburtsort` varchar(100) NOT NULL DEFAULT '',
    `religion` varchar(100) NOT NULL DEFAULT '',
    `strasse` varchar(100) NOT NULL DEFAULT '',
    `hausnummer` varchar(100) NOT NULL DEFAULT '',
    `plz` varchar(100) NOT NULL DEFAULT '',
    `ort` varchar(100) NOT NULL DEFAULT '',
    `telefon_privat` varchar(100) NOT NULL DEFAULT '',
    `telefon_mobile` varchar(100) NOT NULL DEFAULT '',
    `aufenthaltsbewilligung` varchar(100) NOT NULL DEFAULT '',
    `upload_aufenthaltsbewilligung` varchar(255) NOT NULL DEFAULT '',
    `arbeitsbewilligung` tinyint(1) NOT NULL DEFAULT '0',
    `upload_arbeitsbewilligung` varchar(255) NOT NULL DEFAULT '',
    `kontaktperson_notfaelle` text NOT NULL,
    `kontaktperson_notfaelle_telefon` text NOT NULL,
    `partner_vorname` varchar(100) NOT NULL DEFAULT '',
    `partner_nachname` varchar(100) NOT NULL DEFAULT '',
    `partner_geburtsdatum` varchar(100) NOT NULL DEFAULT '',
    `partner_geburtsort` varchar(100) NOT NULL DEFAULT '',
    `partner_sozialversicherungsnummer` varchar(100) NOT NULL DEFAULT '',
    `kind_vorname` text NOT NULL,
    `kind_nachname` text,
    `kind_geburtsdatum` text NOT NULL,
    `kind_geburtsort` text NOT NULL,
    `kind_adresse` text NOT NULL,
    `kind_sozialversicherungsnummer` text NOT NULL,
    `invaliditaet` tinyint(1) NOT NULL DEFAULT '0',
    `invaliditaet_info` text NOT NULL,
    `alleinverdiener` tinyint(1) NOT NULL DEFAULT '0',
    `pendlerpauschale` tinyint(1) NOT NULL DEFAULT '0',
    `nebenbeschaeftigung` tinyint(1) NOT NULL DEFAULT '0',
    `foerderbar` tinyint(1) NOT NULL DEFAULT '0',
    `foerderbar_institution` text NOT NULL,
    `foerderbar_kontaktperson` text NOT NULL,
    `umj_anstellung` tinyint(1) NOT NULL DEFAULT '0',
    `umj_anstellung_wann` text NOT NULL,
    `umj_anstellung_beschaeftigungsgrad` text NOT NULL,
    `iban` varchar(100) NOT NULL DEFAULT '',
    `bic` varchar(100) NOT NULL DEFAULT '',
    `kontoinhaber` varchar(255) NOT NULL DEFAULT '',
    `upload_personaldatenblatt` text NOT NULL,
    `upload_geburtsurkunde` text NOT NULL,
    `upload_lebenslauf` text NOT NULL,
    `upload_meldezettel` text NOT NULL,
    `upload_strafregisterauszug` text NOT NULL,
    `upload_lichtbildausweis` text NOT NULL,
    `upload_datenschutzerklaerung` text NOT NULL,
    `upload_passbild` text NOT NULL,
    `upload_ausbildungsnachweise` text NOT NULL,
    `upload_sponsionsurkunden` text NOT NULL,
    `upload_dienstzeugnisse` text NOT NULL,
    `upload_gebietskrankenkassa` text NOT NULL,
    `upload_kompetenzen` text NOT NULL,
    `upload_alleinverdiener` text NOT NULL,
    `upload_pendlerpauschale` text NOT NULL,
    `upload_nebenbeschaeftigung` text NOT NULL,
    `upload_invaliditaet` text NOT NULL,
    `upload_foerderungsunterlagen` text NOT NULL,
    `ort_datum` text NOT NULL,
    `unterschrift` text NOT NULL,
    `data_folder` varchar(255) NOT NULL DEFAULT '',
    `data_predefined` tinyint(1) NOT NULL DEFAULT '0',
    `data_approved` tinyint(1) NOT NULL DEFAULT '0',
    `upload_datenschutzerklaerung_e` text,
    `position` varchar(255) DEFAULT NULL,
    `positionkey` varchar(255) DEFAULT NULL,
    `status` varchar(20) DEFAULT 'offen',
    `status_changed_by` varchar(255) DEFAULT NULL,
    `urgenz` mediumtext,
    `upload_fragebogen` text NOT NULL,
    `upload_studienbestaetigung` text NOT NULL,
    `einstufung2` varchar(255) DEFAULT NULL,
    `einstufung3` varchar(255) DEFAULT NULL,
    `bearbeiter` varchar(255) DEFAULT NULL,
    `handysignatur` varchar(50) DEFAULT NULL,
    `handysignatur_nein_begrundung` text DEFAULT NULL,
    PRIMARY KEY (`transaction_id`)
);

CREATE TABLE `dsgvo_log` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `bean_id` varchar(36) NOT NULL,
    `date_entered` datetime NOT NULL,
    `ip` varchar(20) NOT NULL,
    `source` varchar(50) NOT NULL,
    `action` varchar(50) NOT NULL,
    `crm_submitted` tinyint(4) NOT NULL DEFAULT '0',
    `change_data` text,
    `s` varchar(50) DEFAULT NULL,
    `module` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id`)
);

CREATE TABLE `vk_format_type_list` (
    `uid` int(11) NOT NULL auto_increment,
    `list_type` varchar(255) NOT NULL,
    `identifier` varchar(255) NOT NULL,
    `name_de` varchar(255) NOT NULL,
    `name_en` varchar(255) NOT NULL,
    `old_typo3_index` varchar(255) NOT NULL,
    PRIMARY KEY (`uid`)
);

CREATE TABLE `fe_users` (
    `house_no` varchar(20) DEFAULT NULL,
    `zip` varchar(20) DEFAULT NULL
);

CREATE TABLE `tx_umjsitepackage_adressen` (
    `gemziff` int(11) NOT NULL,
    `polgem` varchar(255) NOT NULL,
    `ortkennz` bigint(20) NOT NULL,
    `ort` varchar(255) NOT NULL,
    `strakennz` bigint(20) NOT NULL,
    `strasse` varchar(255) NOT NULL,
    `plz` int(10) NOT NULL,
    `gemcode` int(10) NOT NULL,
    INDEX `idx_strasse` (`strasse`)
);

CREATE TABLE `tx_msevent_scheduled_appsynctask` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `target` varchar(50) NOT NULL DEFAULT '0',
    `title` varchar(185) DEFAULT NULL,
    `house` int(11) DEFAULT NULL,
    `type` varchar(250) DEFAULT NULL,
    `language` varchar(50) DEFAULT NULL,
    `slug` varchar(190) DEFAULT NULL,
    `from_time` int(11) DEFAULT NULL,
    `to_time` int(11) DEFAULT NULL,
    `absolut_url` text,
    `description` text,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `allow_access_api_jahresticket` int(11) DEFAULT '0',
    `allow_access_api_club_joanneum` int(11) DEFAULT '0',
    `format` varchar(50) DEFAULT NULL,
    `house_name` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  /*  UNIQUE KEY `slug` (`slug`) */
);

CREATE TABLE tx_shopware_domain_model_products (
    name varchar(255) DEFAULT '' NOT NULL,
    name_shopware varchar(255) DEFAULT '' NOT NULL,
    identifier varchar(255) DEFAULT '' NOT NULL,
    description text,
    link text,
    image int(11) unsigned DEFAULT '0' NOT NULL,
    api_data LONGTEXT,
);


CREATE TABLE tx_msevent_domain_model_event_subscription (
    uid int(11) NOT NULL AUTO_INCREMENT,
    datum VARCHAR(255) NOT NULL,
    veranstaltungstitel VARCHAR(255) NOT NULL,
    first_name VARCHAR(255) NOT NULL,
    last_name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    company VARCHAR(255) DEFAULT NULL ,
    auswahl VARCHAR(255) DEFAULT NULL ,
    begleitung_textbox INT(11) DEFAULT NULL ,
    begleitung_names TEXT DEFAULT NULL ,
    agb TINYINT(1) DEFAULT 0 NOT NULL ,
    marketing TINYINT(1) DEFAULT 0 NOT NULL ,
    formularIdentifier VARCHAR(255) NOT NULL ,
    tstamp INT(11) UNSIGNED NOT NULL ,
    optin_tstamp INT(11) UNSIGNED NOT NULL ,
    optin TINYINT(1) DEFAULT 1 NOT NULL,
    PRIMARY KEY (`uid`)
);