/*M!999999\- enable the sandbox mode */ 
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `licenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `data` mediumtext NOT NULL,
  `returnCode` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=824 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `plugin_knmHB_general_text` (
  `text_id` int(11) NOT NULL,
  `active` tinyint(3) unsigned NOT NULL,
  `updated` datetime NOT NULL,
  `updated_state` varchar(255) NOT NULL,
  PRIMARY KEY (`text_id`),
  CONSTRAINT `plugin_knmHB_general_text_ibfk_1` FOREIGN KEY (`text_id`) REFERENCES `plugin_knmHB_legaltext` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `plugin_knmHB_group_text` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL,
  `text_id` int(11) NOT NULL,
  `active` tinyint(3) unsigned NOT NULL,
  `updated` datetime NOT NULL,
  `updated_state` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_id` (`group_id`,`text_id`),
  KEY `text_id` (`text_id`),
  CONSTRAINT `plugin_knmHB_group_text_ibfk_1` FOREIGN KEY (`text_id`) REFERENCES `plugin_knmHB_legaltext` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `plugin_knmHB_group_text_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `plugin_knmHB_legaltext_group_settings` (`kKundengruppe`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4429 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `plugin_knmHB_legaltext` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `did` varchar(255) NOT NULL,
  `mode` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `helper_name` varchar(255) NOT NULL,
  `type` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='verknuepfung zwischen text und gruppe';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `plugin_knmHB_legaltext_group_settings` (
  `kKundengruppe` int(10) unsigned NOT NULL,
  `token` varchar(255) NOT NULL,
  PRIMARY KEY (`kKundengruppe`),
  CONSTRAINT `plugin_knmHB_legaltext_group_settings_ibfk_1` FOREIGN KEY (`kKundengruppe`) REFERENCES `tkundengruppe` (`kKundengruppe`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='Einstellungen des Plugins';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadmin2facodes` (
  `kAdminlogin` int(11) NOT NULL DEFAULT 0,
  `cEmergencyCode` varchar(64) NOT NULL DEFAULT '',
  UNIQUE KEY `cEmergencyCode` (`cEmergencyCode`),
  KEY `kAdminlogin` (`kAdminlogin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadminfavs` (
  `kAdminfav` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kAdminlogin` int(10) unsigned NOT NULL,
  `cTitel` varchar(255) NOT NULL,
  `cUrl` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kAdminfav`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadminlogin` (
  `kAdminlogin` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cLogin` varchar(255) DEFAULT NULL,
  `cPass` varchar(255) DEFAULT NULL,
  `cName` varchar(255) NOT NULL,
  `cMail` varchar(255) NOT NULL,
  `kAdminlogingruppe` int(10) unsigned NOT NULL,
  `nLoginVersuch` int(10) unsigned NOT NULL,
  `dLetzterLogin` datetime DEFAULT NULL,
  `dGueltigBis` datetime DEFAULT NULL,
  `bAktiv` tinyint(1) NOT NULL DEFAULT 1,
  `cResetPasswordHash` varchar(255) DEFAULT NULL,
  `b2FAauth` tinyint(1) DEFAULT 0,
  `c2FAauthSecret` varchar(100) DEFAULT '',
  `locked_at` datetime DEFAULT NULL,
  `language` varchar(35) DEFAULT 'de-DE',
  PRIMARY KEY (`kAdminlogin`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadminloginattribut` (
  `kAttribut` int(11) NOT NULL AUTO_INCREMENT,
  `kAdminlogin` int(11) NOT NULL,
  `cName` varchar(45) NOT NULL,
  `cAttribValue` varchar(512) NOT NULL DEFAULT '',
  `cAttribText` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kAttribut`),
  UNIQUE KEY `cName_UNIQUE` (`kAdminlogin`,`cName`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadminlogingruppe` (
  `kAdminlogingruppe` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cGruppe` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  PRIMARY KEY (`kAdminlogingruppe`),
  UNIQUE KEY `cGruppe` (`cGruppe`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadminrecht` (
  `cRecht` varchar(255) NOT NULL,
  `cBeschreibung` varchar(255) NOT NULL,
  PRIMARY KEY (`cRecht`),
  KEY `kAdminrechtemodul` (`cRecht`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadminrechtegruppe` (
  `cRecht` varchar(255) NOT NULL,
  `kAdminlogingruppe` int(10) unsigned NOT NULL,
  UNIQUE KEY `kAdminrecht` (`cRecht`,`kAdminlogingruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadminsession` (
  `cSessionId` varchar(128) NOT NULL DEFAULT '',
  `nSessionExpires` int(10) unsigned NOT NULL DEFAULT 0,
  `cSessionData` mediumtext DEFAULT NULL,
  PRIMARY KEY (`cSessionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tadminwidgets` (
  `kWidget` int(10) NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL,
  `cTitle` varchar(255) NOT NULL,
  `cClass` varchar(255) NOT NULL,
  `eContainer` enum('left','center','right') NOT NULL,
  `cDescription` varchar(255) NOT NULL,
  `nPos` int(10) NOT NULL,
  `bExpanded` tinyint(1) NOT NULL DEFAULT 1,
  `bActive` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`kWidget`),
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tanondatajournal` (
  `kAnondatajournal` int(11) NOT NULL AUTO_INCREMENT,
  `cIssuer` varchar(255) DEFAULT '',
  `iIssuerId` int(11) DEFAULT NULL COMMENT 'id of the issuer (e.g Kkunde, kPlugin)',
  `cAction` varchar(255) DEFAULT '',
  `cDetail` mediumtext DEFAULT '',
  `cMessage` mediumtext DEFAULT '',
  `dEventTime` datetime DEFAULT NULL,
  PRIMARY KEY (`kAnondatajournal`),
  KEY `kIssuer` (`iIssuerId`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikel` (
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kHersteller` int(10) unsigned NOT NULL DEFAULT 0,
  `kLieferstatus` int(10) unsigned NOT NULL DEFAULT 0,
  `kSteuerklasse` int(10) unsigned NOT NULL DEFAULT 0,
  `kEinheit` int(10) unsigned NOT NULL DEFAULT 0,
  `kVersandklasse` int(10) unsigned NOT NULL DEFAULT 0,
  `kEigenschaftKombi` int(11) NOT NULL,
  `kVaterArtikel` bigint(20) NOT NULL,
  `kStueckliste` int(10) unsigned NOT NULL,
  `kWarengruppe` int(10) unsigned NOT NULL,
  `kVPEEinheit` int(10) unsigned DEFAULT NULL,
  `kMassEinheit` int(10) unsigned DEFAULT NULL,
  `kGrundPreisEinheit` int(10) unsigned DEFAULT NULL,
  `cSeo` varchar(255) NOT NULL DEFAULT '',
  `cArtNr` varchar(255) DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cBeschreibung` mediumtext DEFAULT NULL,
  `cAnmerkung` mediumtext DEFAULT NULL,
  `fLagerbestand` double DEFAULT 0,
  `fStandardpreisNetto` double DEFAULT NULL,
  `fMwSt` float(5,2) DEFAULT NULL,
  `fMindestbestellmenge` double unsigned DEFAULT NULL,
  `fLieferantenlagerbestand` double unsigned NOT NULL,
  `fLieferzeit` double unsigned NOT NULL,
  `cBarcode` varchar(20) DEFAULT NULL,
  `cTopArtikel` char(1) DEFAULT NULL,
  `fGewicht` double NOT NULL DEFAULT 0,
  `fArtikelgewicht` double NOT NULL DEFAULT 0,
  `fMassMenge` double DEFAULT NULL,
  `fGrundpreisMenge` double DEFAULT NULL,
  `fBreite` double unsigned DEFAULT NULL,
  `fHoehe` double unsigned DEFAULT NULL,
  `fLaenge` double unsigned DEFAULT NULL,
  `cNeu` char(1) DEFAULT NULL,
  `cKurzBeschreibung` mediumtext DEFAULT NULL,
  `fUVP` float(10,2) DEFAULT NULL,
  `cLagerBeachten` char(1) NOT NULL DEFAULT '',
  `cLagerKleinerNull` char(1) DEFAULT NULL,
  `cLagerVariation` char(1) DEFAULT NULL,
  `cTeilbar` char(1) NOT NULL DEFAULT '',
  `fPackeinheit` double(10,4) DEFAULT 1.0000,
  `fAbnahmeintervall` double unsigned NOT NULL,
  `fZulauf` double unsigned DEFAULT NULL,
  `cVPE` char(1) DEFAULT NULL,
  `fVPEWert` double(10,4) DEFAULT NULL,
  `cVPEEinheit` varchar(32) DEFAULT NULL,
  `cSuchbegriffe` varchar(255) DEFAULT NULL,
  `nSort` int(11) NOT NULL DEFAULT 0,
  `dErscheinungsdatum` date DEFAULT NULL,
  `dErstellt` date DEFAULT NULL,
  `dLetzteAktualisierung` datetime DEFAULT NULL,
  `dZulaufDatum` date DEFAULT NULL,
  `dMHD` date DEFAULT NULL,
  `cSerie` varchar(255) DEFAULT NULL,
  `cISBN` varchar(255) DEFAULT NULL,
  `cASIN` varchar(255) DEFAULT NULL,
  `cHAN` varchar(255) DEFAULT NULL,
  `cUNNummer` varchar(255) DEFAULT NULL,
  `cGefahrnr` varchar(255) DEFAULT NULL,
  `cTaric` varchar(255) DEFAULT NULL,
  `cUPC` varchar(255) DEFAULT NULL,
  `cHerkunftsland` varchar(255) DEFAULT NULL,
  `cEPID` varchar(255) DEFAULT NULL,
  `nIstVater` tinyint(4) NOT NULL DEFAULT 0,
  `nLiefertageWennAusverkauft` int(11) DEFAULT NULL,
  `nAutomatischeLiefertageberechnung` int(11) DEFAULT NULL,
  `nBearbeitungszeit` int(11) DEFAULT NULL,
  PRIMARY KEY (`kArtikel`),
  UNIQUE KEY `kVaterArtikel_UQ` (`kArtikel`,`nIstVater`,`kVaterArtikel`),
  KEY `cSeo` (`cSeo`),
  KEY `cArtNr` (`cArtNr`),
  KEY `cName` (`cName`),
  KEY `cSuchbegriffe` (`cSuchbegriffe`),
  KEY `cBarcode` (`cBarcode`),
  KEY `kHersteller` (`kHersteller`),
  KEY `dErstellt` (`dErstellt`),
  KEY `dErscheinungsdatum` (`dErscheinungsdatum`),
  KEY `kEigenschaftKombi` (`kEigenschaftKombi`),
  KEY `kVaterArtikel` (`kVaterArtikel`),
  KEY `idx_tartikel_kStueckliste` (`kStueckliste`),
  KEY `kVaterArtikel_UQ2` (`nIstVater`,`kVaterArtikel`,`kArtikel`),
  FULLTEXT KEY `idx_tartikel_fulltext` (`cName`,`cSeo`,`cSuchbegriffe`,`cArtNr`,`cKurzBeschreibung`,`cBeschreibung`,`cBarcode`,`cISBN`,`cHAN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelabnahme` (
  `kArtikel` int(10) unsigned NOT NULL,
  `kKundengruppe` int(11) NOT NULL DEFAULT 0,
  `fMindestabnahme` double DEFAULT 0,
  `fIntervall` double DEFAULT 0,
  PRIMARY KEY (`kArtikel`,`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelattribut` (
  `kArtikelAttribut` int(10) unsigned NOT NULL DEFAULT 0,
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kArtikelAttribut`),
  KEY `kArtikel` (`kArtikel`),
  KEY `cName` (`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikeldownload` (
  `kArtikel` int(10) unsigned NOT NULL,
  `kDownload` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kArtikel`,`kDownload`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelext` (
  `kArtikel` int(10) unsigned NOT NULL,
  `fDurchschnittsBewertung` double unsigned NOT NULL,
  PRIMARY KEY (`kArtikel`),
  KEY `fDurchschnittsBewertung` (`fDurchschnittsBewertung`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelkategorierabatt` (
  `kArtikel` int(10) unsigned NOT NULL,
  `kKundengruppe` int(10) unsigned NOT NULL,
  `kKategorie` int(10) unsigned NOT NULL,
  `fRabatt` double unsigned NOT NULL,
  PRIMARY KEY (`kArtikel`,`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelkonfiggruppe` (
  `kArtikel` int(10) unsigned NOT NULL,
  `kKonfiggruppe` int(10) unsigned NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  UNIQUE KEY `kArtikel` (`kArtikel`,`kKonfiggruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelmerkmal` (
  `kMerkmal` int(11) DEFAULT NULL,
  `kMerkmalWert` int(11) DEFAULT NULL,
  `kArtikel` int(11) DEFAULT NULL,
  UNIQUE KEY `kArtikelMerkmalWert_UQ` (`kArtikel`,`kMerkmalWert`,`kMerkmal`),
  KEY `kMerkmal` (`kMerkmal`),
  KEY `kMerkmalWert` (`kMerkmalWert`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelpict` (
  `kArtikelPict` int(10) unsigned NOT NULL DEFAULT 0,
  `kMainArtikelBild` int(10) unsigned NOT NULL DEFAULT 0,
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kBild` int(10) unsigned NOT NULL DEFAULT 0,
  `cPfad` varchar(255) DEFAULT NULL,
  `nNr` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`kArtikelPict`),
  KEY `kArtikel` (`kArtikel`),
  KEY `cPfad` (`cPfad`),
  KEY `kArtikelNr` (`kArtikel`,`nNr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelpicthistory` (
  `kArtikel` int(10) unsigned NOT NULL,
  `cPfad` varchar(255) NOT NULL,
  `nNr` tinyint(3) unsigned NOT NULL DEFAULT 1,
  UNIQUE KEY `UNIQUE` (`kArtikel`,`nNr`,`cPfad`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelsichtbarkeit` (
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kArtikel`,`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelsonderpreis` (
  `kArtikelSonderpreis` int(11) NOT NULL DEFAULT 0,
  `kArtikel` int(11) DEFAULT NULL,
  `cAktiv` char(1) NOT NULL DEFAULT 'N',
  `dStart` date DEFAULT NULL,
  `nAnzahl` double DEFAULT NULL,
  `nIstAnzahl` tinyint(3) unsigned DEFAULT 0,
  `nIstDatum` tinyint(3) unsigned DEFAULT 0,
  `dEnde` date DEFAULT NULL,
  PRIMARY KEY (`kArtikelSonderpreis`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelsprache` (
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cSeo` varchar(255) NOT NULL DEFAULT '',
  `cName` varchar(255) DEFAULT NULL,
  `cBeschreibung` mediumtext DEFAULT NULL,
  `cKurzBeschreibung` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kArtikel`,`kSprache`),
  KEY `cSeo` (`cSeo`),
  KEY `cName` (`cName`),
  FULLTEXT KEY `idx_tartikelsprache_fulltext` (`cName`,`cSeo`,`cKurzBeschreibung`,`cBeschreibung`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tartikelwarenlager` (
  `kArtikel` int(10) unsigned NOT NULL,
  `kWarenlager` int(10) unsigned NOT NULL,
  `fBestand` double unsigned NOT NULL,
  `fZulauf` double unsigned NOT NULL,
  `dZulaufDatum` datetime DEFAULT NULL,
  PRIMARY KEY (`kArtikel`,`kWarenlager`),
  KEY `dZulaufDatum` (`dZulaufDatum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tattribut` (
  `kAttribut` int(10) unsigned NOT NULL DEFAULT 0,
  `kArtikel` int(10) unsigned DEFAULT NULL,
  `nSort` int(10) unsigned NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cStringWert` varchar(255) NOT NULL DEFAULT '',
  `cTextWert` mediumtext NOT NULL,
  PRIMARY KEY (`kAttribut`),
  KEY `kArtikel` (`kArtikel`),
  KEY `cName` (`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tattributsprache` (
  `kAttribut` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cStringWert` varchar(255) NOT NULL DEFAULT '',
  `cTextWert` mediumtext NOT NULL,
  PRIMARY KEY (`kAttribut`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tauswahlassistentfrage` (
  `kAuswahlAssistentFrage` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kAuswahlAssistentGruppe` int(10) unsigned NOT NULL,
  `kMerkmal` int(10) unsigned NOT NULL,
  `cFrage` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kAuswahlAssistentFrage`),
  KEY `kAuswahlAssistentGruppe` (`kAuswahlAssistentGruppe`,`nAktiv`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tauswahlassistentgruppe` (
  `kAuswahlAssistentGruppe` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext DEFAULT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kAuswahlAssistentGruppe`),
  KEY `kSprache` (`kSprache`,`nAktiv`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tauswahlassistentort` (
  `kAuswahlAssistentOrt` int(11) NOT NULL AUTO_INCREMENT,
  `kAuswahlAssistentGruppe` int(11) NOT NULL,
  `cKey` varchar(255) NOT NULL,
  `kKey` int(11) NOT NULL,
  PRIMARY KEY (`kAuswahlAssistentOrt`),
  KEY `cKey` (`cKey`,`kKey`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbestellattribut` (
  `kBestellattribut` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBestellung` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cValue` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kBestellattribut`),
  UNIQUE KEY `idx_kBestellung_cName_uq` (`kBestellung`,`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbestellid` (
  `cId` varchar(50) NOT NULL,
  `kBestellung` int(10) unsigned DEFAULT NULL,
  `dDatum` datetime DEFAULT NULL,
  PRIMARY KEY (`cId`),
  KEY `kBestellung` (`kBestellung`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbestellstatus` (
  `kBestellung` int(10) unsigned NOT NULL,
  `cUID` varchar(40) DEFAULT NULL,
  `dDatum` datetime DEFAULT NULL,
  `failedAttempts` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kBestellung`),
  KEY `cUID` (`cUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbestellung` (
  `kBestellung` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kWarenkorb` int(10) unsigned NOT NULL DEFAULT 0,
  `kKunde` int(10) unsigned NOT NULL DEFAULT 0,
  `kLieferadresse` int(10) unsigned NOT NULL DEFAULT 0,
  `kRechnungsadresse` int(10) unsigned NOT NULL,
  `kZahlungsart` int(10) unsigned NOT NULL DEFAULT 0,
  `kVersandart` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `kWaehrung` int(10) unsigned NOT NULL DEFAULT 0,
  `fGuthaben` double(12,4) NOT NULL DEFAULT 0.0000,
  `fGesamtsumme` double NOT NULL DEFAULT 0,
  `cSession` varchar(128) NOT NULL DEFAULT '',
  `cVersandartName` varchar(255) NOT NULL DEFAULT '',
  `cZahlungsartName` varchar(255) NOT NULL DEFAULT '',
  `cBestellNr` varchar(20) NOT NULL DEFAULT '',
  `cVersandInfo` varchar(255) DEFAULT NULL,
  `nLongestMinDelivery` int(11) NOT NULL DEFAULT 0,
  `nLongestMaxDelivery` int(11) NOT NULL DEFAULT 0,
  `dVersandDatum` date DEFAULT NULL,
  `dBezahltDatum` date DEFAULT NULL,
  `dBewertungErinnerung` datetime DEFAULT NULL,
  `cTracking` varchar(255) DEFAULT NULL,
  `cKommentar` mediumtext DEFAULT NULL,
  `cLogistiker` varchar(255) NOT NULL DEFAULT '',
  `cTrackingURL` varchar(255) NOT NULL DEFAULT '',
  `cIP` varchar(255) NOT NULL,
  `cAbgeholt` char(1) DEFAULT 'N',
  `cStatus` char(2) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  `fWaehrungsFaktor` float NOT NULL DEFAULT 1,
  `cPUIZahlungsdaten` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kBestellung`),
  KEY `cIP` (`cIP`),
  KEY `kKunde` (`kKunde`),
  KEY `kWaehrung` (`kWaehrung`),
  KEY `kSprache` (`kSprache`),
  KEY `kZahlungsart` (`kZahlungsart`),
  KEY `kLieferadresse` (`kLieferadresse`),
  KEY `kWarenkorb` (`kWarenkorb`),
  KEY `dBewertungErinnerung` (`dBewertungErinnerung`),
  KEY `kVersandart` (`kVersandart`),
  KEY `idx_dErstellt_WK` (`dErstellt`,`cStatus`,`kWarenkorb`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbestseller` (
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `fAnzahl` double(10,4) DEFAULT NULL,
  `isBestseller` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kArtikel`),
  KEY `kArtikel` (`kArtikel`,`fAnzahl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbesucher` (
  `kBesucher` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cIP` varchar(255) DEFAULT NULL,
  `cSessID` varchar(128) DEFAULT NULL,
  `cID` varchar(255) NOT NULL,
  `kKunde` int(10) unsigned NOT NULL,
  `kBestellung` int(10) unsigned NOT NULL,
  `cReferer` varchar(255) NOT NULL,
  `cUserAgent` varchar(512) DEFAULT NULL,
  `cEinstiegsseite` varchar(255) DEFAULT NULL,
  `cBrowser` varchar(255) DEFAULT NULL,
  `cAusstiegsseite` varchar(255) DEFAULT NULL,
  `kBesucherBot` int(10) unsigned NOT NULL DEFAULT 0,
  `dLetzteAktivitaet` datetime DEFAULT NULL,
  `dZeit` datetime DEFAULT NULL,
  PRIMARY KEY (`kBesucher`),
  KEY `cIP` (`cIP`),
  KEY `kKunde` (`kKunde`),
  KEY `kBestellung` (`kBestellung`),
  KEY `cReferer` (`cReferer`),
  KEY `cBrowser` (`cBrowser`),
  KEY `cEinstiegsseite` (`cEinstiegsseite`),
  KEY `idx_kBot_dZeit` (`kBesucherBot`,`dZeit`)
) ENGINE=InnoDB AUTO_INCREMENT=146762 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbesucherarchiv` (
  `kBesucher` int(10) unsigned NOT NULL,
  `cIP` varchar(255) DEFAULT NULL,
  `kKunde` int(10) unsigned NOT NULL,
  `kBestellung` int(10) unsigned NOT NULL,
  `cReferer` varchar(255) NOT NULL,
  `cEinstiegsseite` varchar(255) DEFAULT NULL,
  `cBrowser` varchar(255) DEFAULT NULL,
  `cAusstiegsseite` varchar(255) DEFAULT NULL,
  `nBesuchsdauer` int(11) DEFAULT NULL,
  `kBesucherBot` int(10) unsigned NOT NULL DEFAULT 0,
  `dZeit` datetime DEFAULT NULL,
  PRIMARY KEY (`kBesucher`),
  KEY `cIP` (`cIP`),
  KEY `kKunde` (`kKunde`),
  KEY `kBestellung` (`kBestellung`),
  KEY `cReferer` (`cReferer`),
  KEY `cBrowser` (`cBrowser`),
  KEY `cEinstiegsseite` (`cEinstiegsseite`),
  KEY `dZeit` (`dZeit`),
  KEY `idx_kBot_dZeit` (`kBesucherBot`,`dZeit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbesucherbot` (
  `kBesucherBot` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) DEFAULT NULL,
  `cUserAgent` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  `cLink` varchar(255) DEFAULT NULL,
  `dZeit` datetime DEFAULT NULL,
  PRIMARY KEY (`kBesucherBot`),
  KEY `cName` (`cName`)
) ENGINE=InnoDB AUTO_INCREMENT=500 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbesucherzaehler` (
  `nZaehler` int(10) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbesuchteseiten` (
  `kArtikel` int(10) unsigned DEFAULT NULL,
  `kKategorie` int(10) unsigned DEFAULT NULL,
  `kLink` int(10) unsigned DEFAULT NULL,
  `kTag` int(10) unsigned NOT NULL DEFAULT 0,
  `kSuchanfrage` int(10) unsigned NOT NULL DEFAULT 0,
  `kHersteller` int(10) unsigned NOT NULL DEFAULT 0,
  `kNews` int(10) unsigned NOT NULL,
  `kNewsMonatsUebersicht` int(10) unsigned NOT NULL,
  `kNewsKategorie` int(10) unsigned NOT NULL,
  `nBesuche` int(10) unsigned DEFAULT NULL,
  KEY `kArtikel` (`kArtikel`),
  KEY `kKategorie` (`kKategorie`),
  KEY `kLink` (`kLink`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbewertung` (
  `kBewertung` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kKunde` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) NOT NULL,
  `cTitel` varchar(255) NOT NULL,
  `cText` mediumtext NOT NULL,
  `nHilfreich` int(10) unsigned NOT NULL,
  `nNichtHilfreich` int(10) unsigned NOT NULL,
  `nSterne` int(4) NOT NULL DEFAULT 0,
  `nAktiv` int(4) NOT NULL DEFAULT 0,
  `dDatum` date NOT NULL,
  `cAntwort` mediumtext DEFAULT NULL,
  `dAntwortDatum` date DEFAULT NULL,
  PRIMARY KEY (`kBewertung`),
  KEY `kKunde` (`kKunde`),
  KEY `kArtikel` (`kArtikel`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbewertungguthabenbonus` (
  `kBewertungGuthabenBonus` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBewertung` int(10) unsigned NOT NULL,
  `kKunde` int(10) unsigned NOT NULL,
  `fGuthabenBonus` double(10,2) unsigned NOT NULL,
  `dDatum` datetime NOT NULL,
  PRIMARY KEY (`kBewertungGuthabenBonus`),
  KEY `kBewertung` (`kBewertung`,`kKunde`,`dDatum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbewertunghilfreich` (
  `kBewertungHilfreich` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBewertung` int(10) unsigned NOT NULL DEFAULT 0,
  `kKunde` int(10) unsigned NOT NULL DEFAULT 0,
  `nBewertung` int(4) unsigned NOT NULL,
  PRIMARY KEY (`kBewertungHilfreich`),
  KEY `kBewertung` (`kBewertung`,`kKunde`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbild` (
  `kBild` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cPfad` varchar(255) NOT NULL,
  PRIMARY KEY (`kBild`)
) ENGINE=InnoDB AUTO_INCREMENT=5451 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tboxen` (
  `kBox` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBoxvorlage` int(10) unsigned NOT NULL,
  `kCustomID` int(10) unsigned NOT NULL,
  `kContainer` int(10) unsigned NOT NULL,
  `cTitel` varchar(255) NOT NULL,
  `ePosition` enum('left','right','top','bottom') NOT NULL,
  PRIMARY KEY (`kBox`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tboxenanzeige` (
  `nSeite` int(10) unsigned NOT NULL,
  `ePosition` enum('left','top','bottom','right') NOT NULL,
  `bAnzeigen` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`nSeite`,`ePosition`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tboxensichtbar` (
  `kBox` int(10) unsigned NOT NULL,
  `kSeite` int(10) unsigned NOT NULL,
  `nSort` int(10) NOT NULL DEFAULT 0,
  `bAktiv` tinyint(1) NOT NULL DEFAULT 1,
  `cFilter` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`kSeite`,`kBox`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tboxsprache` (
  `kBoxSprache` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBox` int(10) unsigned NOT NULL,
  `cISO` varchar(5) NOT NULL,
  `cTitel` varchar(255) NOT NULL,
  `cInhalt` mediumtext NOT NULL,
  PRIMARY KEY (`kBoxSprache`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tboxvorlage` (
  `kBoxvorlage` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kCustomID` int(10) unsigned DEFAULT 0,
  `eTyp` enum('tpl','text','link','plugin','catbox','extension') DEFAULT NULL,
  `cName` varchar(255) NOT NULL,
  `cVerfuegbar` mediumtext NOT NULL,
  `cTemplate` varchar(255) NOT NULL,
  PRIMARY KEY (`kBoxvorlage`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbranding` (
  `kBranding` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cBildKategorie` varchar(255) NOT NULL,
  PRIMARY KEY (`kBranding`),
  KEY `cBildKategorie` (`cBildKategorie`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbrandingeinstellung` (
  `kBrandingEinstellung` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBranding` int(10) unsigned NOT NULL,
  `cPosition` varchar(255) NOT NULL,
  `cBrandingBild` varchar(255) NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `dTransparenz` double NOT NULL,
  `dGroesse` double NOT NULL,
  `dRandabstand` double NOT NULL,
  PRIMARY KEY (`kBrandingEinstellung`),
  KEY `kBranding` (`kBranding`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbrocken` (
  `kBrocken` int(10) NOT NULL,
  `cBrocken` mediumtext NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kBrocken`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tcheckbox` (
  `kCheckBox` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kLink` int(10) unsigned DEFAULT NULL,
  `kCheckBoxFunktion` int(10) unsigned DEFAULT NULL,
  `cName` varchar(255) NOT NULL,
  `cKundengruppe` varchar(255) NOT NULL,
  `cAnzeigeOrt` varchar(255) NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `nPflicht` tinyint(3) unsigned NOT NULL,
  `nLogging` tinyint(3) unsigned NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kCheckBox`),
  KEY `cAnzeigeOrt` (`cAnzeigeOrt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tcheckboxfunktion` (
  `kCheckBoxFunktion` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned DEFAULT NULL,
  `cName` varchar(255) NOT NULL,
  `cID` varchar(255) NOT NULL,
  PRIMARY KEY (`kCheckBoxFunktion`),
  KEY `kPlugin` (`kPlugin`),
  KEY `cID` (`cID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tcheckboxlogging` (
  `kCheckBoxLogging` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kCheckBox` int(10) unsigned NOT NULL,
  `kBesucher` int(10) unsigned NOT NULL,
  `kBestellung` int(10) unsigned NOT NULL,
  `bChecked` tinyint(1) NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kCheckBoxLogging`),
  KEY `kCheckBox` (`kCheckBox`),
  KEY `dErstellt` (`dErstellt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tcheckboxsprache` (
  `kCheckBoxSprache` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kCheckBox` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cText` mediumtext NOT NULL,
  `cBeschreibung` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kCheckBoxSprache`),
  KEY `kCheckBox` (`kCheckBox`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tconsent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemID` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `pluginID` int(11) NOT NULL DEFAULT 0,
  `active` tinyint(4) NOT NULL DEFAULT 1,
  `templateID` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tconsentlocalization` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `consentID` int(11) NOT NULL,
  `languageID` int(11) NOT NULL,
  `privacyPolicy` varchar(255) NOT NULL,
  `description` mediumtext NOT NULL,
  `purpose` mediumtext NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_consent_id` (`consentID`),
  CONSTRAINT `fk_consent_id` FOREIGN KEY (`consentID`) REFERENCES `tconsent` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tcontentauthor` (
  `kContentAuthor` int(11) NOT NULL AUTO_INCREMENT,
  `cRealm` varchar(45) NOT NULL,
  `kAdminlogin` int(11) NOT NULL,
  `kContentId` int(11) NOT NULL,
  PRIMARY KEY (`kContentAuthor`),
  UNIQUE KEY `cRealm_UNIQUE` (`cRealm`,`kContentId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tcron` (
  `cronID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `foreignKeyID` int(10) unsigned DEFAULT NULL,
  `foreignKey` varchar(255) DEFAULT NULL,
  `tableName` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `jobType` varchar(255) NOT NULL,
  `frequency` int(10) unsigned NOT NULL DEFAULT 0,
  `startDate` datetime DEFAULT NULL,
  `startTime` time DEFAULT NULL,
  `lastStart` datetime DEFAULT NULL,
  `nextStart` datetime DEFAULT NULL,
  `lastFinish` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`cronID`),
  KEY `dStart` (`startDate`,`lastStart`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tdownload` (
  `kDownload` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cID` varchar(255) NOT NULL,
  `cPfad` varchar(255) NOT NULL,
  `cPfadVorschau` varchar(255) DEFAULT NULL,
  `nAnzahl` int(10) unsigned DEFAULT NULL,
  `nTage` int(10) unsigned DEFAULT NULL,
  `nSort` int(10) unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kDownload`),
  KEY `cID` (`cID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tdownloadhistory` (
  `kDownloadHistory` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kDownload` int(10) unsigned NOT NULL,
  `kKunde` int(10) unsigned NOT NULL,
  `kBestellung` int(10) unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kDownloadHistory`),
  KEY `kKunde` (`kKunde`,`kBestellung`),
  KEY `idx_download` (`kDownload`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tdownloadsprache` (
  `kDownload` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kDownload`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaft` (
  `kEigenschaft` int(10) unsigned NOT NULL DEFAULT 0,
  `kArtikel` int(10) unsigned DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cWaehlbar` char(1) DEFAULT NULL,
  `cTyp` varchar(255) NOT NULL DEFAULT '',
  `nSort` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kEigenschaft`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftkombiwert` (
  `kEigenschaftKombi` int(11) NOT NULL,
  `kEigenschaft` int(11) NOT NULL,
  `kEigenschaftWert` int(11) NOT NULL,
  PRIMARY KEY (`kEigenschaftKombi`,`kEigenschaft`,`kEigenschaftWert`),
  UNIQUE KEY `idx_eigenschaftwert_uq` (`kEigenschaft`,`kEigenschaftWert`,`kEigenschaftKombi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftsichtbarkeit` (
  `kEigenschaft` int(10) unsigned NOT NULL DEFAULT 0,
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kEigenschaft`,`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftsprache` (
  `kEigenschaft` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kEigenschaft`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftwert` (
  `kEigenschaftWert` int(10) unsigned NOT NULL DEFAULT 0,
  `kEigenschaft` int(10) unsigned DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `fAufpreisNetto` double(10,4) NOT NULL DEFAULT 0.0000,
  `fGewichtDiff` double(10,4) DEFAULT NULL,
  `cArtNr` varchar(255) DEFAULT NULL,
  `nSort` int(10) unsigned DEFAULT 0,
  `fLagerbestand` double DEFAULT NULL,
  `fPackeinheit` double(10,4) DEFAULT 1.0000,
  PRIMARY KEY (`kEigenschaftWert`),
  KEY `kEigenschaft` (`kEigenschaft`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftwertabhaengigkeit` (
  `kEigenschaftWert` int(10) unsigned DEFAULT NULL,
  `kEigenschaftWertZiel` int(10) unsigned DEFAULT NULL,
  KEY `kEigenschaftWert` (`kEigenschaftWert`),
  KEY `kEigenschaftWertZiel` (`kEigenschaftWertZiel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftwertaufpreis` (
  `kEigenschaftWert` int(10) unsigned NOT NULL DEFAULT 0,
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `fAufpreisNetto` double DEFAULT NULL,
  PRIMARY KEY (`kEigenschaftWert`,`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftwertpict` (
  `kEigenschaftWertPict` int(10) unsigned NOT NULL DEFAULT 0,
  `kEigenschaftWert` int(10) unsigned NOT NULL DEFAULT 0,
  `cPfad` varchar(255) DEFAULT NULL,
  `cType` char(1) DEFAULT NULL,
  PRIMARY KEY (`kEigenschaftWertPict`),
  KEY `kEigenschaftWert` (`kEigenschaftWert`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftwertsichtbarkeit` (
  `kEigenschaftWert` int(10) unsigned NOT NULL DEFAULT 0,
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kEigenschaftWert`,`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teigenschaftwertsprache` (
  `kEigenschaftWert` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kEigenschaftWert`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teinheit` (
  `kEinheit` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`kEinheit`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teinstellungen` (
  `kEinstellungenSektion` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` mediumtext DEFAULT NULL,
  `cModulId` varchar(255) DEFAULT NULL,
  KEY `kEinstellungenSektion` (`kEinstellungenSektion`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teinstellungen_default` (
  `kEinstellungenSektion` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` varchar(255) DEFAULT NULL,
  `cModulId` varchar(255) DEFAULT NULL,
  UNIQUE KEY `sectionName` (`kEinstellungenSektion`,`cName`),
  KEY `kEinstellungenSektion` (`kEinstellungenSektion`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teinstellungenconf` (
  `kEinstellungenConf` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kEinstellungenSektion` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cBeschreibung` varchar(255) NOT NULL DEFAULT '',
  `cWertName` varchar(255) DEFAULT NULL,
  `cInputTyp` varchar(255) DEFAULT NULL,
  `cModulId` varchar(255) DEFAULT NULL,
  `nSort` int(11) DEFAULT NULL,
  `nStandardAnzeigen` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `nModul` tinyint(3) unsigned DEFAULT 0,
  `cConf` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`kEinstellungenConf`),
  KEY `kEinstellungenSektion` (`kEinstellungenSektion`),
  KEY `cModulId` (`cModulId`)
) ENGINE=InnoDB AUTO_INCREMENT=1807 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teinstellungenconfwerte` (
  `kEinstellungenConf` int(10) unsigned DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` varchar(255) DEFAULT NULL,
  `nSort` int(11) DEFAULT NULL,
  KEY `kEinstellungenConf` (`kEinstellungenConf`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teinstellungenlog` (
  `kEinstellungenLog` int(11) NOT NULL AUTO_INCREMENT,
  `kAdminlogin` int(11) NOT NULL,
  `cAdminname` varchar(255) NOT NULL DEFAULT '',
  `cIP` varchar(40) DEFAULT NULL,
  `cEinstellungenName` varchar(255) NOT NULL,
  `cEinstellungenWertAlt` varchar(255) NOT NULL,
  `cEinstellungenWertNeu` varchar(255) NOT NULL,
  `dDatum` datetime NOT NULL,
  PRIMARY KEY (`kEinstellungenLog`),
  KEY `cEinstellungenName` (`cEinstellungenName`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teinstellungensektion` (
  `kEinstellungenSektion` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `kAdminmenueGruppe` int(10) NOT NULL DEFAULT 0,
  `nSort` tinyint(3) NOT NULL DEFAULT 0,
  `cRecht` varchar(255) NOT NULL,
  PRIMARY KEY (`kEinstellungenSektion`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailblacklist` (
  `cEmail` varchar(255) NOT NULL,
  PRIMARY KEY (`cEmail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailblacklistblock` (
  `cEmail` varchar(255) NOT NULL,
  `dLetzterBlock` datetime NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailhistory` (
  `kEmailhistory` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kEmailvorlage` int(10) unsigned NOT NULL,
  `cSubject` varchar(255) DEFAULT NULL,
  `cFromName` varchar(255) DEFAULT NULL,
  `cFromEmail` varchar(255) NOT NULL,
  `cToName` varchar(255) DEFAULT NULL,
  `cToEmail` varchar(255) NOT NULL,
  `dSent` datetime NOT NULL,
  PRIMARY KEY (`kEmailhistory`),
  KEY `kEmailvorlage` (`kEmailvorlage`),
  KEY `dSent` (`dSent`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailvorlage` (
  `kEmailvorlage` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) DEFAULT NULL COMMENT 'is displayed in the backend',
  `cBeschreibung` mediumtext DEFAULT NULL,
  `cMailTyp` varchar(255) NOT NULL DEFAULT 'text/html',
  `cModulId` varchar(255) DEFAULT NULL COMMENT 'constant in includes/defines_inc.php',
  `cDateiname` varchar(255) NOT NULL DEFAULT '' COMMENT 'base file name in admin/mailtemplates/[ger|eng]/',
  `cAktiv` char(1) DEFAULT NULL,
  `nAKZ` tinyint(3) unsigned NOT NULL,
  `nAGB` tinyint(3) unsigned NOT NULL,
  `nWRB` tinyint(3) unsigned NOT NULL,
  `nFehlerhaft` tinyint(4) NOT NULL DEFAULT 0,
  `nWRBForm` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `nDSE` tinyint(3) NOT NULL DEFAULT 0 COMMENT 'append privatcy statement',
  `kPlugin` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kEmailvorlage`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailvorlage2platzhalter` (
  `kEmailvorlage` int(10) unsigned DEFAULT NULL,
  `kEmailvorlagePlatzhalter` int(10) unsigned DEFAULT NULL,
  KEY `kEmailvorlage` (`kEmailvorlage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailvorlageeinstellungen` (
  `kEmailvorlage` int(10) unsigned NOT NULL,
  `cKey` varchar(255) NOT NULL,
  `cValue` varchar(255) NOT NULL,
  KEY `kEmailvorlage` (`kEmailvorlage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailvorlageplatzhalter` (
  `kEmailvorlagePlatzhalter` int(10) unsigned NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cSmartyObjekt` varchar(255) DEFAULT NULL,
  `cBeschreibung` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kEmailvorlagePlatzhalter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailvorlageplatzhaltervariable` (
  `kEmailvorlagePlatzhaltervariable` int(10) unsigned NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kEmailvorlagePlatzhaltervariable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailvorlagesprache` (
  `kEmailvorlage` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cBetreff` varchar(255) DEFAULT NULL,
  `cContentHtml` mediumtext NOT NULL,
  `cContentText` mediumtext NOT NULL,
  `cPDFS` varchar(255) DEFAULT NULL,
  `cPDFNames` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kEmailvorlage`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `temailvorlagespracheoriginal` (
  `kEmailvorlage` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cBetreff` varchar(255) DEFAULT NULL,
  `cContentHtml` mediumtext NOT NULL,
  `cContentText` mediumtext NOT NULL,
  `cPDFS` varchar(255) DEFAULT NULL,
  `cPDFNames` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kEmailvorlage`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `texportformat` (
  `kExportformat` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKundengruppe` int(10) unsigned DEFAULT NULL,
  `kSprache` int(10) unsigned DEFAULT NULL,
  `kWaehrung` int(10) unsigned DEFAULT NULL,
  `kKampagne` int(10) unsigned DEFAULT 0,
  `kPlugin` int(10) unsigned NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cDateiname` varchar(255) DEFAULT NULL,
  `cKopfzeile` mediumtext DEFAULT NULL,
  `cContent` mediumtext DEFAULT NULL,
  `cFusszeile` mediumtext NOT NULL,
  `cKodierung` varchar(255) NOT NULL DEFAULT 'ASCII',
  `nSpecial` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `nVarKombiOption` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `nSplitgroesse` int(10) unsigned DEFAULT 0,
  `dZuletztErstellt` datetime DEFAULT NULL,
  `nUseCache` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `nFehlerhaft` tinyint(1) DEFAULT 0,
  `async` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`kExportformat`),
  KEY `nSpecial` (`nSpecial`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `texportformateinstellungen` (
  `kExportformat` int(10) unsigned DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `texportformatqueuebearbeitet` (
  `kJobQueue` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kExportformat` int(10) unsigned NOT NULL,
  `nLimitN` int(10) unsigned NOT NULL,
  `nLimitM` int(10) unsigned NOT NULL,
  `nInArbeit` tinyint(3) unsigned NOT NULL,
  `dStartZeit` datetime NOT NULL,
  `dZuletztGelaufen` datetime NOT NULL,
  PRIMARY KEY (`kJobQueue`),
  KEY `kExportformat` (`kExportformat`),
  KEY `dZuletztGelaufen` (`dZuletztGelaufen`)
) ENGINE=InnoDB AUTO_INCREMENT=2890 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `texportqueue` (
  `kExportqueue` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kExportformat` int(10) unsigned DEFAULT NULL,
  `nLimit_n` int(10) unsigned DEFAULT NULL,
  `nLimit_m` int(10) unsigned DEFAULT NULL,
  `nLastArticleID` int(10) unsigned NOT NULL DEFAULT 0,
  `dErstellt` datetime DEFAULT NULL,
  `dZuBearbeiten` datetime DEFAULT NULL,
  PRIMARY KEY (`kExportqueue`),
  KEY `kExportformat` (`kExportformat`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `textensionpoint` (
  `kExtensionPoint` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `nSeite` int(10) unsigned NOT NULL DEFAULT 0,
  `cKey` varchar(255) DEFAULT NULL,
  `cValue` varchar(255) NOT NULL,
  `cClass` varchar(255) NOT NULL,
  `kInitial` int(255) NOT NULL,
  PRIMARY KEY (`kExtensionPoint`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tfirma` (
  `cName` varchar(255) DEFAULT NULL,
  `cUnternehmer` varchar(50) DEFAULT NULL,
  `cStrasse` varchar(50) DEFAULT NULL,
  `cHausnummer` varchar(32) DEFAULT NULL,
  `cPLZ` varchar(10) DEFAULT NULL,
  `cOrt` varchar(50) DEFAULT NULL,
  `cLand` varchar(50) DEFAULT NULL,
  `cTel` varchar(30) DEFAULT NULL,
  `cFax` varchar(30) DEFAULT NULL,
  `cEMail` varchar(50) DEFAULT NULL,
  `cWWW` varchar(50) DEFAULT NULL,
  `cKontoinhaber` varchar(255) NOT NULL DEFAULT '',
  `cBLZ` varchar(20) DEFAULT NULL,
  `cKontoNr` varchar(20) DEFAULT NULL,
  `cBank` varchar(50) DEFAULT NULL,
  `cUSTID` varchar(25) DEFAULT NULL,
  `cSteuerNr` varchar(25) DEFAULT NULL,
  `cIBAN` varchar(50) NOT NULL DEFAULT '',
  `cBIC` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tfloodprotect` (
  `kFloodProtect` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cIP` varchar(255) DEFAULT NULL COMMENT 'the user ip',
  `cTyp` varchar(255) DEFAULT NULL COMMENT 'defines where the protection was used',
  `dErstellt` datetime DEFAULT NULL COMMENT 'the request date',
  `reference` int(11) DEFAULT NULL,
  PRIMARY KEY (`kFloodProtect`),
  KEY `cIP` (`cTyp`,`cIP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tfsession` (
  `cIP` varchar(32) DEFAULT NULL,
  `cAgent` varchar(255) DEFAULT NULL,
  `kWaehrung` int(10) unsigned DEFAULT NULL,
  `nUserSortierung` tinyint(4) DEFAULT NULL,
  `nUserArtikelzahl` int(10) unsigned DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tglobalemetaangaben` (
  `kGlobaleMetaAngaben` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kEinstellungenSektion` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cWertName` varchar(255) NOT NULL,
  PRIMARY KEY (`kGlobaleMetaAngaben`),
  KEY `kSprache` (`kSprache`,`kEinstellungenSektion`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tglobals` (
  `dLetzteAenderung` datetime DEFAULT NULL,
  `consentVersion` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tgratisgeschenk` (
  `kGratisGeschenk` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kArtikel` int(10) unsigned NOT NULL,
  `kWarenkorb` int(10) unsigned NOT NULL,
  `nAnzahl` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kGratisGeschenk`),
  KEY `kWarenkorb` (`kWarenkorb`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tgutschein` (
  `kGutschein` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned DEFAULT NULL,
  `fWert` double(10,2) DEFAULT NULL,
  `cGrund` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kGutschein`),
  KEY `kKunde` (`kKunde`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `thersteller` (
  `kHersteller` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cSeo` varchar(255) NOT NULL,
  `cHomepage` varchar(255) DEFAULT NULL,
  `nSortNr` tinyint(3) unsigned DEFAULT NULL,
  `cBildpfad` varchar(255) NOT NULL,
  `nAktiv` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`kHersteller`),
  KEY `cSeo` (`cSeo`),
  KEY `cName` (`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `therstellersprache` (
  `kHersteller` int(11) NOT NULL,
  `kSprache` int(11) NOT NULL,
  `cMetaTitle` mediumtext NOT NULL,
  `cMetaKeywords` mediumtext NOT NULL,
  `cMetaDescription` mediumtext NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  PRIMARY KEY (`kHersteller`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `timagemap` (
  `kImageMap` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKampagne` int(10) unsigned NOT NULL DEFAULT 0,
  `cTitel` varchar(255) NOT NULL,
  `cBildPfad` varchar(255) NOT NULL,
  `vDatum` datetime DEFAULT NULL,
  `bDatum` datetime DEFAULT NULL,
  PRIMARY KEY (`kImageMap`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `timagemaparea` (
  `kImageMapArea` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kImageMap` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `cTitel` varchar(255) NOT NULL,
  `cUrl` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  `cCoords` varchar(255) NOT NULL,
  `cStyle` varchar(255) NOT NULL,
  PRIMARY KEY (`kImageMapArea`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tjobqueue` (
  `jobQueueID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cronID` int(10) unsigned NOT NULL,
  `foreignKeyID` int(10) unsigned DEFAULT NULL,
  `jobType` varchar(255) NOT NULL,
  `tableName` varchar(255) DEFAULT NULL,
  `foreignKey` varchar(255) DEFAULT NULL,
  `tasksExecuted` int(10) unsigned NOT NULL DEFAULT 0,
  `taskLimit` int(10) unsigned NOT NULL DEFAULT 0,
  `lastProductID` int(10) unsigned NOT NULL DEFAULT 0,
  `isRunning` int(10) unsigned NOT NULL DEFAULT 0,
  `startTime` datetime DEFAULT NULL,
  `lastStart` datetime DEFAULT NULL,
  `lastFinish` datetime DEFAULT NULL,
  PRIMARY KEY (`jobQueueID`),
  KEY `dStartZeit` (`startTime`)
) ENGINE=InnoDB AUTO_INCREMENT=2902 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tjtllog` (
  `kLog` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nLevel` int(10) unsigned NOT NULL,
  `cLog` longtext NOT NULL,
  `cKey` varchar(255) DEFAULT NULL,
  `kKey` int(10) unsigned DEFAULT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kLog`),
  KEY `cKey` (`cKey`,`kKey`)
) ENGINE=InnoDB AUTO_INCREMENT=1669 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci COMMENT='Globaler JTL Log';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkampagne` (
  `kKampagne` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) NOT NULL,
  `cParameter` varchar(255) NOT NULL,
  `cWert` varchar(255) NOT NULL,
  `nDynamisch` int(10) unsigned NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  `nInternal` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kKampagne`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkampagnedef` (
  `kKampagneDef` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cKey` varchar(255) NOT NULL,
  PRIMARY KEY (`kKampagneDef`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkampagnevorgang` (
  `kKampagneVorgang` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKampagne` int(10) unsigned NOT NULL,
  `kKampagneDef` int(10) unsigned NOT NULL,
  `kKey` int(10) unsigned NOT NULL,
  `fWert` double unsigned NOT NULL,
  `cParamWert` varchar(255) NOT NULL,
  `cCustomData` varchar(255) DEFAULT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kKampagneVorgang`),
  KEY `cParamWert` (`cParamWert`),
  KEY `dErstellt` (`dErstellt`),
  KEY `kKampagne` (`kKampagne`,`kKampagneDef`,`kKey`)
) ENGINE=InnoDB AUTO_INCREMENT=891 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategorie` (
  `kKategorie` int(10) unsigned NOT NULL DEFAULT 0,
  `cSeo` varchar(255) NOT NULL DEFAULT '',
  `cName` varchar(255) DEFAULT NULL,
  `cBeschreibung` mediumtext DEFAULT NULL,
  `kOberKategorie` int(10) unsigned DEFAULT NULL,
  `nSort` int(10) unsigned DEFAULT 0,
  `dLetzteAktualisierung` date DEFAULT NULL,
  `lft` int(11) NOT NULL DEFAULT 0,
  `rght` int(11) NOT NULL DEFAULT 0,
  `nLevel` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kKategorie`),
  KEY `cSeo` (`cSeo`),
  KEY `kOberKategorie` (`kOberKategorie`),
  KEY `idx_tkategorie_nLevel` (`nLevel`),
  KEY `idx_tkategorie_lft_rght` (`lft`,`rght`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategorieartikel` (
  `kKategorieArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kArtikel` int(10) unsigned DEFAULT NULL,
  `kKategorie` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`kKategorieArtikel`),
  UNIQUE KEY `kKategorieArtikel_UQ` (`kArtikel`,`kKategorie`),
  KEY `kKategorie` (`kKategorie`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategorieattribut` (
  `kKategorieAttribut` int(10) unsigned NOT NULL DEFAULT 0,
  `kKategorie` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` mediumtext DEFAULT NULL,
  `nSort` int(11) NOT NULL DEFAULT 0,
  `bIstFunktionsAttribut` int(10) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`kKategorieAttribut`),
  KEY `kKategorie` (`kKategorie`),
  KEY `cName` (`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategorieattributsprache` (
  `kAttribut` int(11) NOT NULL,
  `kSprache` int(11) NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cWert` mediumtext NOT NULL,
  UNIQUE KEY `kKategorieAttribut_UNIQUE` (`kAttribut`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategoriekundengruppe` (
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `kKategorie` int(10) unsigned NOT NULL DEFAULT 0,
  `fRabatt` double DEFAULT NULL,
  PRIMARY KEY (`kKundengruppe`,`kKategorie`),
  KEY `kKategorie` (`kKategorie`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategoriemapping` (
  `kKategorie` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  PRIMARY KEY (`kKategorie`,`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci COMMENT='Mapping der Kategorien fuer die Shopinfo.xml';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategoriepict` (
  `kKategoriePict` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKategorie` int(10) unsigned DEFAULT NULL,
  `cPfad` varchar(255) DEFAULT NULL,
  `cType` char(1) DEFAULT NULL,
  PRIMARY KEY (`kKategoriePict`),
  KEY `kKategorie` (`kKategorie`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategoriesichtbarkeit` (
  `kKategorie` int(10) unsigned NOT NULL DEFAULT 0,
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kKategorie`,`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkategoriesprache` (
  `kKategorie` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cSeo` varchar(255) NOT NULL DEFAULT '',
  `cName` varchar(255) DEFAULT NULL,
  `cBeschreibung` mediumtext DEFAULT NULL,
  `cMetaDescription` varchar(255) DEFAULT NULL,
  `cMetaKeywords` varchar(255) DEFAULT NULL,
  `cTitleTag` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kKategorie`,`kSprache`),
  KEY `cSeo` (`cSeo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkonfiggruppe` (
  `kKonfiggruppe` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cBildPfad` varchar(255) NOT NULL DEFAULT '',
  `nMin` int(10) NOT NULL DEFAULT 0,
  `nMax` int(10) NOT NULL DEFAULT 0,
  `nTyp` int(10) NOT NULL DEFAULT 0,
  `cKommentar` varchar(255) NOT NULL,
  PRIMARY KEY (`kKonfiggruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkonfiggruppesprache` (
  `kKonfiggruppe` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  UNIQUE KEY `kKonfigGruppe` (`kKonfiggruppe`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkonfigitem` (
  `kKonfigitem` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKonfiggruppe` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `nPosTyp` int(10) NOT NULL DEFAULT 0,
  `bSelektiert` tinyint(1) NOT NULL DEFAULT 0,
  `bEmpfohlen` tinyint(1) NOT NULL DEFAULT 0,
  `bName` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Name vom Artikel beziehen',
  `bPreis` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Preis vom Artikel beziehen',
  `bRabatt` tinyint(1) NOT NULL COMMENT 'Rabatt anzeigen',
  `bZuschlag` tinyint(1) NOT NULL COMMENT 'Zuschlag anzeigen',
  `bIgnoreMultiplier` tinyint(1) NOT NULL DEFAULT 0,
  `fMin` float unsigned NOT NULL COMMENT 'Min. Anzahl',
  `fMax` float unsigned NOT NULL COMMENT 'Max. Anzahl',
  `fInitial` float unsigned NOT NULL COMMENT 'Initialer Anzeigewert',
  `nSort` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kKonfigitem`),
  KEY `kKonfigGruppeSort` (`kKonfiggruppe`,`nSort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkonfigitempreis` (
  `kKonfigitem` int(10) unsigned NOT NULL,
  `kKundengruppe` int(10) unsigned NOT NULL,
  `kSteuerklasse` int(10) unsigned NOT NULL,
  `fPreis` double NOT NULL,
  `nTyp` tinyint(1) NOT NULL DEFAULT 0,
  UNIQUE KEY `kKonfigGruppeItem` (`kKonfigitem`,`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkonfigitemsprache` (
  `kKonfigitem` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  UNIQUE KEY `tKonfigGruppeItem` (`kKonfigitem`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkontaktbetreff` (
  `kKontaktBetreff` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) DEFAULT NULL,
  `cKundengruppen` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) DEFAULT NULL,
  `nSort` tinyint(3) unsigned DEFAULT 0,
  PRIMARY KEY (`kKontaktBetreff`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkontaktbetreffsprache` (
  `kKontaktBetreff` int(10) unsigned NOT NULL DEFAULT 0,
  `cISOSprache` varchar(5) NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kKontaktBetreff`,`cISOSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkontakthistory` (
  `kKontaktHistory` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKontaktBetreff` int(10) unsigned DEFAULT NULL,
  `kSprache` int(10) unsigned DEFAULT NULL,
  `cAnrede` varchar(30) NOT NULL DEFAULT '',
  `cVorname` varchar(255) NOT NULL DEFAULT '',
  `cNachname` varchar(255) NOT NULL DEFAULT '',
  `cFirma` varchar(255) DEFAULT NULL,
  `cTel` varchar(255) DEFAULT NULL,
  `cMobil` varchar(255) DEFAULT NULL,
  `cFax` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) NOT NULL DEFAULT '',
  `cNachricht` longtext DEFAULT NULL,
  `cIP` varchar(255) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kKontaktHistory`),
  KEY `cIP` (`cIP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkunde` (
  `kKunde` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cKundenNr` varchar(40) DEFAULT NULL,
  `cPasswort` varchar(254) DEFAULT NULL,
  `cAnrede` varchar(30) NOT NULL DEFAULT '',
  `cTitel` varchar(64) DEFAULT NULL,
  `cVorname` varchar(255) NOT NULL DEFAULT '',
  `cNachname` varchar(255) NOT NULL DEFAULT '',
  `cFirma` varchar(255) DEFAULT NULL,
  `cZusatz` varchar(255) DEFAULT NULL,
  `cStrasse` varchar(255) NOT NULL DEFAULT '',
  `cHausnummer` varchar(32) NOT NULL,
  `cAdressZusatz` varchar(255) DEFAULT NULL,
  `cPLZ` varchar(20) NOT NULL DEFAULT '',
  `cOrt` varchar(255) NOT NULL DEFAULT '',
  `cBundesland` varchar(255) NOT NULL DEFAULT '',
  `cLand` varchar(4) NOT NULL,
  `cTel` varchar(255) DEFAULT NULL,
  `cMobil` varchar(255) DEFAULT NULL,
  `cFax` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) NOT NULL DEFAULT '',
  `cUSTID` varchar(30) DEFAULT NULL,
  `cWWW` varchar(255) DEFAULT NULL,
  `cSperre` varchar(2) NOT NULL DEFAULT 'N',
  `fGuthaben` double(10,2) NOT NULL DEFAULT 0.00,
  `cNewsletter` char(1) NOT NULL DEFAULT '',
  `dGeburtstag` date DEFAULT NULL,
  `fRabatt` double(5,2) NOT NULL DEFAULT 0.00,
  `cHerkunft` varchar(255) NOT NULL DEFAULT '',
  `dErstellt` date DEFAULT NULL,
  `dVeraendert` datetime NOT NULL,
  `cAktiv` char(1) NOT NULL DEFAULT 'Y',
  `cAbgeholt` char(1) NOT NULL DEFAULT 'N',
  `nRegistriert` tinyint(3) unsigned NOT NULL,
  `nLoginversuche` int(10) NOT NULL DEFAULT 0,
  `dLastLogin` datetime DEFAULT NULL,
  PRIMARY KEY (`kKunde`),
  KEY `kKundengruppe` (`kKundengruppe`),
  KEY `kSprache` (`kSprache`),
  KEY `cMail` (`cMail`),
  KEY `cAbgeholt` (`cAbgeholt`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundenattribut` (
  `kKundenAttribut` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned DEFAULT NULL,
  `kKundenfeld` int(10) unsigned NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kKundenAttribut`),
  UNIQUE KEY `kKundenfeld` (`kKunde`,`kKundenfeld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundendatenhistory` (
  `kKundendatenHistory` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned NOT NULL,
  `cJsonAlt` mediumtext NOT NULL,
  `cJsonNeu` mediumtext NOT NULL,
  `cQuelle` varchar(255) NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kKundendatenHistory`),
  KEY `kKunde` (`kKunde`),
  KEY `dErstellt` (`dErstellt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundenfeld` (
  `kKundenfeld` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cWawi` varchar(255) NOT NULL,
  `cTyp` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  `nPflicht` tinyint(3) unsigned NOT NULL,
  `nEditierbar` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kKundenfeld`),
  KEY `kSprache` (`kSprache`,`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundenfeldwert` (
  `kKundenfeldWert` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKundenfeld` int(10) unsigned NOT NULL,
  `cWert` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kKundenfeldWert`),
  KEY `kKundenfeld` (`kKundenfeld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundengruppe` (
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `fRabatt` double DEFAULT NULL,
  `cStandard` char(1) DEFAULT 'N',
  `cShopLogin` char(1) NOT NULL DEFAULT 'N',
  `nNettoPreise` tinyint(3) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundengruppenattribut` (
  `kKundengruppenAttribut` int(10) unsigned NOT NULL DEFAULT 0,
  `kKundengruppe` int(10) unsigned DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cWert` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kKundengruppenAttribut`),
  KEY `kKundengruppe` (`kKundengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundengruppensprache` (
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kKundengruppe`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundenherkunft` (
  `kKundenherkunft` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nSort` tinyint(3) unsigned DEFAULT NULL,
  `cHerkunft` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kKundenherkunft`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkundenkontodaten` (
  `kKundenKontodaten` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned NOT NULL,
  `cBLZ` varchar(255) NOT NULL,
  `nKonto` varchar(255) NOT NULL,
  `cInhaber` varchar(255) NOT NULL,
  `cBankName` varchar(255) NOT NULL,
  `cIBAN` varchar(255) NOT NULL,
  `cBIC` varchar(255) NOT NULL,
  PRIMARY KEY (`kKundenKontodaten`),
  KEY `kKunde` (`kKunde`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkupon` (
  `kKupon` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKundengruppe` int(10) NOT NULL DEFAULT 0,
  `kSteuerklasse` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `fWert` double(10,2) DEFAULT NULL,
  `cWertTyp` varchar(255) NOT NULL DEFAULT 'festpreis',
  `dGueltigAb` datetime DEFAULT NULL,
  `dGueltigBis` datetime DEFAULT NULL,
  `fMindestbestellwert` double(10,2) DEFAULT NULL,
  `cCode` varchar(32) DEFAULT NULL,
  `nVerwendungen` int(10) unsigned NOT NULL DEFAULT 0,
  `nVerwendungenBisher` int(10) unsigned NOT NULL DEFAULT 0,
  `nVerwendungenProKunde` int(10) unsigned NOT NULL DEFAULT 0,
  `cArtikel` mediumtext NOT NULL,
  `cHersteller` mediumtext NOT NULL,
  `cKategorien` mediumtext NOT NULL,
  `cKunden` mediumtext NOT NULL,
  `cKuponTyp` varchar(255) NOT NULL DEFAULT '',
  `cLieferlaender` varchar(255) NOT NULL DEFAULT '',
  `cZusatzgebuehren` char(1) NOT NULL DEFAULT '',
  `cAktiv` char(1) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  `nGanzenWKRabattieren` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kKupon`),
  KEY `cCode` (`cCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkuponbestellung` (
  `kKupon` int(10) NOT NULL,
  `kBestellung` int(10) NOT NULL,
  `kKunde` int(11) DEFAULT NULL,
  `cBestellNr` varchar(20) DEFAULT NULL,
  `fGesamtsummeBrutto` double NOT NULL DEFAULT 0,
  `fKuponwertBrutto` double NOT NULL DEFAULT 0,
  `cKuponTyp` varchar(255) NOT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kKupon`,`kBestellung`),
  KEY `cKuponTyp` (`cKuponTyp`,`dErstellt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkuponflag` (
  `kKuponFlag` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cEmailHash` varchar(255) NOT NULL,
  `cKuponTyp` varchar(255) NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kKuponFlag`),
  KEY `cEmailHash_cKuponTyp` (`cEmailHash`,`cKuponTyp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkuponkunde` (
  `kKuponKunde` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKupon` int(10) unsigned DEFAULT NULL,
  `cMail` varchar(255) DEFAULT NULL,
  `nVerwendungen` int(10) unsigned DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kKuponKunde`),
  UNIQUE KEY `kKupon_cMail` (`kKupon`,`cMail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tkuponsprache` (
  `kKupon` int(10) unsigned NOT NULL DEFAULT 0,
  `cISOSprache` varchar(5) NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kKupon`,`cISOSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tland` (
  `cISO` varchar(5) NOT NULL,
  `cDeutsch` varchar(255) DEFAULT NULL,
  `cEnglisch` varchar(255) DEFAULT NULL,
  `nEU` tinyint(3) unsigned DEFAULT NULL,
  `cKontinent` varchar(255) DEFAULT NULL,
  `bPermitRegistration` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `bRequireStateDefinition` tinyint(1) unsigned NOT NULL DEFAULT 0,
  UNIQUE KEY `UC_cISO` (`cISO`),
  KEY `cISO` (`cISO`),
  KEY `cDeutsch` (`cDeutsch`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlastjob` (
  `kJob` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cType` enum('RPT','STD') NOT NULL DEFAULT 'STD',
  `nJob` int(11) NOT NULL,
  `cJobName` varchar(128) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  `nCounter` int(10) NOT NULL DEFAULT 0,
  `nFinished` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kJob`),
  UNIQUE KEY `idx_uq_nJob` (`nJob`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlieferadresse` (
  `kLieferadresse` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned NOT NULL DEFAULT 0,
  `cAnrede` varchar(20) NOT NULL DEFAULT '',
  `cVorname` varchar(255) NOT NULL DEFAULT '',
  `cNachname` varchar(255) NOT NULL DEFAULT '',
  `cTitel` varchar(64) DEFAULT NULL,
  `cFirma` varchar(255) DEFAULT NULL,
  `cZusatz` varchar(255) DEFAULT NULL,
  `cStrasse` varchar(255) NOT NULL DEFAULT '',
  `cHausnummer` varchar(32) NOT NULL,
  `cAdressZusatz` varchar(255) DEFAULT NULL,
  `cPLZ` varchar(20) NOT NULL DEFAULT '',
  `cOrt` varchar(255) NOT NULL DEFAULT '',
  `cBundesland` varchar(255) NOT NULL DEFAULT '',
  `cLand` varchar(255) NOT NULL DEFAULT '',
  `cTel` varchar(255) DEFAULT NULL,
  `cMobil` varchar(255) DEFAULT NULL,
  `cFax` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kLieferadresse`),
  KEY `kKunde` (`kKunde`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlieferadressevorlage` (
  `kLieferadresse` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned NOT NULL DEFAULT 0,
  `cAnrede` varchar(20) NOT NULL DEFAULT '',
  `cVorname` varchar(255) NOT NULL DEFAULT '',
  `cNachname` varchar(255) NOT NULL DEFAULT '',
  `cTitel` varchar(64) DEFAULT NULL,
  `cFirma` varchar(255) DEFAULT NULL,
  `cZusatz` varchar(255) DEFAULT NULL,
  `cStrasse` varchar(255) NOT NULL DEFAULT '',
  `cHausnummer` varchar(32) NOT NULL DEFAULT '',
  `cAdressZusatz` varchar(255) DEFAULT NULL,
  `cPLZ` varchar(20) NOT NULL DEFAULT '',
  `cOrt` varchar(255) NOT NULL DEFAULT '',
  `cBundesland` varchar(255) NOT NULL DEFAULT '',
  `cLand` varchar(255) NOT NULL DEFAULT '',
  `cTel` varchar(255) DEFAULT NULL,
  `cMobil` varchar(255) DEFAULT NULL,
  `cFax` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) DEFAULT NULL,
  `nIstStandardLieferadresse` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kLieferadresse`),
  KEY `idx_kKunde` (`kKunde`,`nIstStandardLieferadresse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci COMMENT='Beinhaltet veränderbare und löschbare Lieferadressenvorlagen.';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlieferschein` (
  `kLieferschein` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kInetBestellung` int(10) unsigned NOT NULL,
  `cLieferscheinNr` varchar(255) NOT NULL,
  `cHinweis` varchar(255) NOT NULL,
  `nFulfillment` tinyint(3) unsigned NOT NULL,
  `nStatus` tinyint(3) unsigned NOT NULL,
  `dErstellt` int(10) unsigned NOT NULL,
  `bEmailVerschickt` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kLieferschein`)
) ENGINE=InnoDB AUTO_INCREMENT=25657 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlieferscheinpos` (
  `kLieferscheinPos` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kLieferschein` int(10) unsigned NOT NULL,
  `kBestellPos` int(10) unsigned NOT NULL,
  `kWarenlager` int(10) unsigned NOT NULL DEFAULT 0,
  `fAnzahl` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kLieferscheinPos`)
) ENGINE=InnoDB AUTO_INCREMENT=38355 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlieferscheinposinfo` (
  `kLieferscheinPosInfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kLieferscheinPos` int(10) unsigned NOT NULL,
  `cSeriennummer` varchar(255) NOT NULL,
  `cChargeNr` varchar(255) NOT NULL,
  `dMHD` datetime DEFAULT NULL,
  PRIMARY KEY (`kLieferscheinPosInfo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlieferstatus` (
  `kLieferstatus` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kLieferstatus`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlink` (
  `kLink` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kVaterLink` int(10) unsigned NOT NULL DEFAULT 0,
  `kPlugin` int(10) unsigned DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `nLinkart` tinyint(3) unsigned DEFAULT NULL,
  `cNoFollow` varchar(255) DEFAULT 'N',
  `cKundengruppen` varchar(255) DEFAULT NULL,
  `cSichtbarNachLogin` char(1) NOT NULL DEFAULT 'N',
  `cDruckButton` varchar(1) NOT NULL DEFAULT 'N',
  `nSort` int(11) DEFAULT NULL,
  `bSSL` tinyint(1) DEFAULT 0,
  `bIsFluid` tinyint(1) DEFAULT 0,
  `cIdentifier` varchar(255) DEFAULT '',
  `bIsActive` tinyint(1) NOT NULL DEFAULT 1,
  `reference` int(10) unsigned NOT NULL DEFAULT 0,
  `bIsSystem` tinyint(1) NOT NULL DEFAULT 0,
  `target` varchar(20) NOT NULL DEFAULT '_self',
  PRIMARY KEY (`kLink`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlinkgroupassociations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `linkID` int(10) unsigned NOT NULL,
  `linkGroupID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_tlinkgroupassociations_1_idx` (`linkID`),
  KEY `fk_tlinkGroupID` (`linkGroupID`),
  CONSTRAINT `fk_tlinkGroupID` FOREIGN KEY (`linkGroupID`) REFERENCES `tlinkgruppe` (`kLinkgruppe`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_tlinkID` FOREIGN KEY (`linkID`) REFERENCES `tlink` (`kLink`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlinkgruppe` (
  `kLinkgruppe` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) DEFAULT NULL,
  `cTemplatename` varchar(255) DEFAULT NULL,
  `bIsSystem` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kLinkgruppe`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlinkgruppesprache` (
  `kLinkgruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `cISOSprache` varchar(5) NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kLinkgruppe`,`cISOSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tlinksprache` (
  `kLink` int(10) NOT NULL DEFAULT 0,
  `cSeo` varchar(255) NOT NULL DEFAULT '',
  `cISOSprache` varchar(5) NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cTitle` varchar(255) DEFAULT NULL,
  `cContent` longtext DEFAULT NULL,
  `cMetaTitle` varchar(255) NOT NULL DEFAULT '',
  `cMetaKeywords` varchar(255) NOT NULL DEFAULT '',
  `cMetaDescription` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`kLink`,`cISOSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmasseinheit` (
  `kMassEinheit` int(10) unsigned NOT NULL,
  `cCode` varchar(255) NOT NULL,
  PRIMARY KEY (`kMassEinheit`),
  KEY `cCode` (`cCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmasseinheitsprache` (
  `kMassEinheitSprache` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kMassEinheit` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  PRIMARY KEY (`kMassEinheitSprache`),
  KEY `kMassEinheit` (`kMassEinheit`,`kSprache`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmediendatei` (
  `kMedienDatei` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL,
  `cPfad` mediumtext NOT NULL,
  `cURL` mediumtext NOT NULL,
  `cKategorie` varchar(255) NOT NULL,
  `cTyp` varchar(255) NOT NULL,
  `nSort` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kMedienDatei`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmediendateiattribut` (
  `kMedienDateiAttribut` int(10) unsigned NOT NULL,
  `kMedienDatei` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cWert` mediumtext NOT NULL,
  PRIMARY KEY (`kMedienDateiAttribut`),
  KEY `kMedienDatei` (`kMedienDatei`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmediendateisprache` (
  `kMedienDatei` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  PRIMARY KEY (`kMedienDatei`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmerkmal` (
  `kMerkmal` int(11) NOT NULL,
  `nSort` int(11) DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cBildpfad` varchar(255) NOT NULL,
  `cTyp` varchar(255) NOT NULL,
  `nMehrfachauswahl` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kMerkmal`),
  KEY `nSort` (`nSort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmerkmalsprache` (
  `kMerkmal` int(11) NOT NULL DEFAULT 0,
  `kSprache` int(11) NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kMerkmal`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmerkmalwert` (
  `kMerkmalWert` int(11) NOT NULL,
  `kMerkmal` int(11) DEFAULT NULL,
  `nSort` int(11) DEFAULT NULL,
  `cBildpfad` varchar(255) NOT NULL,
  PRIMARY KEY (`kMerkmalWert`),
  KEY `kMerkmal` (`kMerkmal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmerkmalwertbild` (
  `kMerkmalWert` int(10) unsigned NOT NULL,
  `cBildpfad` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmerkmalwertsprache` (
  `kMerkmalWert` int(11) NOT NULL DEFAULT 0,
  `kSprache` int(11) NOT NULL DEFAULT 0,
  `cWert` varchar(255) DEFAULT NULL,
  `cSeo` varchar(255) NOT NULL,
  `cMetaTitle` varchar(255) NOT NULL,
  `cMetaKeywords` varchar(255) NOT NULL,
  `cMetaDescription` mediumtext NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  PRIMARY KEY (`kMerkmalWert`,`kSprache`),
  KEY `cSeo` (`cSeo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmigration` (
  `kMigration` bigint(14) NOT NULL,
  `nVersion` int(3) NOT NULL,
  `dExecuted` datetime NOT NULL,
  PRIMARY KEY (`kMigration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmigrationlog` (
  `kMigrationlog` int(10) NOT NULL AUTO_INCREMENT,
  `kMigration` bigint(20) NOT NULL,
  `cDir` enum('up','down') NOT NULL,
  `cState` varchar(6) NOT NULL,
  `cLog` mediumtext NOT NULL,
  `dCreated` datetime NOT NULL,
  PRIMARY KEY (`kMigrationlog`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmodul` (
  `cModulId` varchar(255) NOT NULL DEFAULT '',
  `cName` varchar(255) DEFAULT NULL,
  `cAutor` varchar(255) DEFAULT NULL,
  `cTyp` varchar(255) DEFAULT NULL,
  `cURL` varchar(255) NOT NULL DEFAULT '',
  `cDokumentationURL` varchar(255) NOT NULL DEFAULT '',
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`cModulId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnews` (
  `kNews` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cKundengruppe` varchar(255) NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  `dGueltigVon` datetime NOT NULL,
  `cPreviewImage` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`kNews`),
  KEY `kSprache` (`nAktiv`,`dGueltigVon`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewskategorie` (
  `kNewsKategorie` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kParent` int(10) NOT NULL DEFAULT 0,
  `nSort` tinyint(3) unsigned NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `dLetzteAktualisierung` datetime NOT NULL,
  `cPreviewImage` varchar(255) DEFAULT NULL,
  `lft` int(11) NOT NULL DEFAULT 0,
  `rght` int(11) NOT NULL DEFAULT 0,
  `lvl` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kNewsKategorie`),
  KEY `kSprache` (`nAktiv`),
  KEY `kParent` (`kParent`),
  KEY `lft_rght` (`lft`,`rght`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewskategorienews` (
  `kNewsKategorieNews` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kNews` int(10) unsigned NOT NULL,
  `kNewsKategorie` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kNewsKategorieNews`),
  KEY `kNews` (`kNews`),
  KEY `kNewsKategorie` (`kNewsKategorie`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewskategoriesprache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kNewsKategorie` int(10) unsigned NOT NULL,
  `languageID` int(11) NOT NULL,
  `languageCode` varchar(5) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `metaTitle` varchar(255) NOT NULL DEFAULT '',
  `metaDescription` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `fk_newscatID` (`kNewsKategorie`),
  CONSTRAINT `fk_newscatID` FOREIGN KEY (`kNewsKategorie`) REFERENCES `tnewskategorie` (`kNewsKategorie`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewskommentar` (
  `kNewsKommentar` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kNews` int(10) unsigned NOT NULL,
  `kKunde` int(10) unsigned NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cEmail` varchar(255) NOT NULL,
  `cKommentar` mediumtext NOT NULL,
  `parentCommentID` int(10) unsigned NOT NULL DEFAULT 0,
  `isAdmin` int(10) unsigned NOT NULL DEFAULT 0,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kNewsKommentar`),
  KEY `kNews` (`kNews`,`nAktiv`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewsletter` (
  `kNewsletter` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `kKampagne` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBetreff` varchar(255) NOT NULL,
  `cArt` varchar(255) NOT NULL,
  `cArtikel` varchar(255) NOT NULL,
  `cHersteller` varchar(255) DEFAULT NULL,
  `cKategorie` varchar(255) DEFAULT NULL,
  `cKundengruppe` varchar(255) NOT NULL,
  `cInhaltHTML` mediumtext NOT NULL,
  `cInhaltText` mediumtext NOT NULL,
  `dStartZeit` datetime NOT NULL,
  `dLastSendings` datetime DEFAULT NULL COMMENT 'finish time of last sending of this NL',
  PRIMARY KEY (`kNewsletter`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewsletterempfaenger` (
  `kNewsletterEmpfaenger` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `kKunde` int(10) unsigned DEFAULT 0,
  `nAktiv` int(10) unsigned NOT NULL DEFAULT 0,
  `cAnrede` varchar(255) DEFAULT NULL,
  `cVorname` varchar(255) DEFAULT NULL,
  `cNachname` varchar(255) DEFAULT NULL,
  `cEmail` varchar(255) NOT NULL,
  `cOptCode` varchar(255) NOT NULL,
  `cLoeschCode` varchar(255) NOT NULL,
  `dEingetragen` datetime NOT NULL,
  `dLetzterNewsletter` datetime DEFAULT NULL,
  PRIMARY KEY (`kNewsletterEmpfaenger`),
  KEY `kSprache` (`kSprache`),
  KEY `kKunde` (`kKunde`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewsletterempfaengerblacklist` (
  `cMail` varchar(255) NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`cMail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewsletterempfaengerhistory` (
  `kNewsletterEmpfaengerHistory` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `kKunde` int(10) unsigned NOT NULL,
  `cAnrede` varchar(255) NOT NULL,
  `cVorname` varchar(255) NOT NULL,
  `cNachname` varchar(255) NOT NULL,
  `cEmail` varchar(255) NOT NULL,
  `cOptCode` varchar(255) NOT NULL,
  `cLoeschCode` varchar(255) NOT NULL,
  `cAktion` varchar(255) NOT NULL,
  `cEmailBodyHtml` mediumtext DEFAULT NULL,
  `cRegIp` varchar(255) DEFAULT NULL,
  `cOptIp` varchar(255) DEFAULT NULL,
  `dAusgetragen` datetime DEFAULT NULL,
  `dEingetragen` datetime DEFAULT NULL,
  `dOptCode` datetime DEFAULT NULL,
  PRIMARY KEY (`kNewsletterEmpfaengerHistory`),
  KEY `cOptCode` (`cOptCode`,`cAktion`),
  KEY `idx_cEmail_cAktion` (`cEmail`,`cAktion`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewsletterhistory` (
  `kNewsletterHistory` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nAnzahl` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL,
  `cBetreff` varchar(255) NOT NULL,
  `cHTMLStatic` mediumtext NOT NULL,
  `cKundengruppe` varchar(255) NOT NULL,
  `cKundengruppeKey` varchar(255) NOT NULL,
  `dStart` datetime NOT NULL,
  PRIMARY KEY (`kNewsletterHistory`),
  KEY `kSprache` (`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewslettertrack` (
  `kNewsletterTrack` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKampagne` int(10) unsigned NOT NULL,
  `kNewsletter` int(10) unsigned NOT NULL,
  `kNewsletterEmpfaenger` int(10) unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kNewsletterTrack`),
  KEY `kKampagne` (`kKampagne`,`kNewsletter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewslettervorlage` (
  `kNewsletterVorlage` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kNewslettervorlageStd` int(10) unsigned DEFAULT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `kKampagne` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBetreff` varchar(255) NOT NULL,
  `cArt` varchar(255) NOT NULL,
  `cArtikel` varchar(255) NOT NULL,
  `cHersteller` varchar(255) DEFAULT NULL,
  `cKategorie` varchar(255) DEFAULT NULL,
  `cKundengruppe` varchar(255) NOT NULL,
  `cInhaltHTML` mediumtext NOT NULL,
  `cInhaltText` mediumtext NOT NULL,
  `dStartZeit` datetime NOT NULL,
  PRIMARY KEY (`kNewsletterVorlage`),
  KEY `kSprache` (`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewslettervorlagestd` (
  `kNewslettervorlageStd` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBild` varchar(255) NOT NULL,
  `cInhaltHTML` mediumtext NOT NULL,
  `cInhaltText` mediumtext NOT NULL,
  PRIMARY KEY (`kNewslettervorlageStd`),
  KEY `kSprache` (`kSprache`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewslettervorlagestdvar` (
  `kNewslettervorlageStdVar` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kNewslettervorlageStd` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cTyp` varchar(255) NOT NULL,
  PRIMARY KEY (`kNewslettervorlageStdVar`),
  KEY `kNewslettervorlageStd` (`kNewslettervorlageStd`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewslettervorlagestdvarinhalt` (
  `kNewslettervorlageStdVarInhalt` int(11) NOT NULL AUTO_INCREMENT,
  `kNewslettervorlageStdVar` int(11) NOT NULL,
  `kNewslettervorlage` int(11) DEFAULT NULL,
  `cInhalt` mediumtext NOT NULL,
  `cLinkURL` varchar(255) DEFAULT NULL,
  `cAltTag` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kNewslettervorlageStdVarInhalt`)
) ENGINE=InnoDB AUTO_INCREMENT=329 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewsmonatspraefix` (
  `kSprache` int(10) unsigned NOT NULL,
  `cPraefix` varchar(255) NOT NULL,
  KEY `kSprache` (`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewsmonatsuebersicht` (
  `kNewsMonatsUebersicht` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `nMonat` int(10) unsigned NOT NULL,
  `nJahr` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kNewsMonatsUebersicht`),
  KEY `kSprache` (`kSprache`,`nMonat`,`nJahr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnewssprache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kNews` int(10) unsigned NOT NULL,
  `languageID` int(11) NOT NULL,
  `languageCode` varchar(5) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `preview` longtext DEFAULT NULL,
  `metaTitle` varchar(255) NOT NULL DEFAULT '',
  `metaKeywords` varchar(255) NOT NULL DEFAULT '',
  `metaDescription` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `fk_newsID` (`kNews`),
  CONSTRAINT `fk_newsID` FOREIGN KEY (`kNews`) REFERENCES `tnews` (`kNews`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnotificationsignore` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `notification_hash` varchar(40) NOT NULL,
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_notificationignore_hash_uq` (`user_id`,`notification_hash`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tnummern` (
  `nNummer` int(10) unsigned DEFAULT NULL,
  `nArt` tinyint(3) unsigned NOT NULL,
  `dAktualisiert` datetime DEFAULT NULL,
  PRIMARY KEY (`nArt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `topcblueprint` (
  `kBlueprint` int(11) NOT NULL AUTO_INCREMENT,
  `kPlugin` int(11) NOT NULL DEFAULT 0,
  `cName` varchar(255) NOT NULL,
  `cJson` longtext DEFAULT NULL,
  `bActive` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`kBlueprint`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `topcpage` (
  `kPage` int(11) NOT NULL AUTO_INCREMENT,
  `cPageId` mediumtext NOT NULL,
  `dPublishFrom` datetime DEFAULT NULL,
  `dPublishTo` datetime DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cPageUrl` varchar(255) NOT NULL,
  `cAreasJson` longtext NOT NULL,
  `dLastModified` datetime DEFAULT NULL,
  `cLockedBy` varchar(255) NOT NULL,
  `dLockedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`kPage`),
  UNIQUE KEY `cPageId` (`cPageId`(255),`dPublishFrom`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `topcportlet` (
  `kPortlet` int(11) NOT NULL AUTO_INCREMENT,
  `kPlugin` int(11) NOT NULL,
  `cTitle` varchar(255) NOT NULL,
  `cClass` varchar(255) NOT NULL,
  `cGroup` varchar(255) NOT NULL,
  `bActive` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`kPortlet`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `toptin` (
  `kOptin` int(10) NOT NULL AUTO_INCREMENT COMMENT 'internal table key',
  `kOptinCode` varchar(255) NOT NULL DEFAULT '' COMMENT 'main opt-in code',
  `kOptinClass` varchar(1024) DEFAULT '' COMMENT 'the class name of this optin',
  `cMail` varchar(256) NOT NULL DEFAULT '' COMMENT 'customer mail address',
  `cRefData` varchar(1024) DEFAULT NULL COMMENT 'additional reference data (e.g. text output in emails)',
  `dCreated` datetime DEFAULT NULL COMMENT 'opt-in created',
  `dActivated` datetime DEFAULT NULL COMMENT 'time of activation',
  PRIMARY KEY (`kOptin`),
  UNIQUE KEY `kOptinCode` (`kOptinCode`),
  KEY `idx_cMail` (`cMail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `toptinhistory` (
  `kOptinHistory` int(10) NOT NULL AUTO_INCREMENT COMMENT 'internal table key',
  `kOptinCode` varchar(255) DEFAULT NULL COMMENT 'main OptInCode, derived from table toptin',
  `kOptinClass` varchar(1024) DEFAULT '' COMMENT 'the class name of this optin',
  `cMail` varchar(256) NOT NULL DEFAULT '' COMMENT 'customer mail address',
  `cRefData` varchar(1024) DEFAULT NULL COMMENT 'additional reference data (e.g. text output in emails)',
  `dCreated` datetime DEFAULT NULL COMMENT 'time of opt-in creation',
  `dActivated` datetime DEFAULT NULL COMMENT 'time of opt-in activation',
  `dDeActivated` datetime DEFAULT NULL COMMENT 'time of de-activation (moved to this place)',
  PRIMARY KEY (`kOptinHistory`),
  KEY `kOptinCode` (`kOptinCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpasswordreset` (
  `kKunde` int(11) NOT NULL,
  `cKey` varchar(255) DEFAULT NULL,
  `dExpires` datetime DEFAULT NULL,
  PRIMARY KEY (`kKunde`),
  UNIQUE KEY `cKey` (`cKey`),
  KEY `tpasswordreset_cKey` (`cKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplugin` (
  `kPlugin` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  `cAutor` varchar(255) NOT NULL,
  `cURL` varchar(255) NOT NULL,
  `cVerzeichnis` varchar(255) NOT NULL,
  `cPluginID` varchar(255) NOT NULL,
  `cStoreID` varchar(255) DEFAULT NULL,
  `cFehler` varchar(255) NOT NULL,
  `cLizenz` varchar(255) DEFAULT NULL,
  `cLizenzKlasse` varchar(255) DEFAULT NULL,
  `cLizenzKlasseName` varchar(255) DEFAULT NULL,
  `nStatus` tinyint(3) unsigned NOT NULL,
  `nVersion` varchar(255) NOT NULL,
  `nXMLVersion` int(10) unsigned NOT NULL,
  `nPrio` int(10) unsigned NOT NULL,
  `dZuletztAktualisiert` datetime NOT NULL,
  `dInstalliert` datetime NOT NULL,
  `dErstellt` date NOT NULL,
  `cIcon` varchar(255) DEFAULT NULL,
  `bBootstrap` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `bExtension` tinyint(1) NOT NULL DEFAULT 0,
  `exsID` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kPlugin`),
  KEY `nStatus` (`nStatus`,`nPrio`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplugin_resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `position` varchar(45) DEFAULT NULL,
  `kPlugin` int(11) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `conditional` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginadminmenu` (
  `kPluginAdminMenu` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cDateiname` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  `nConf` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kPluginAdminMenu`),
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplugincustomtabelle` (
  `kPluginCustomTabelle` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL,
  `cTabelle` varchar(255) NOT NULL,
  PRIMARY KEY (`kPluginCustomTabelle`),
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplugineinstellungen` (
  `kPlugin` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cWert` mediumtext DEFAULT NULL,
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplugineinstellungenconf` (
  `kPluginEinstellungenConf` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL,
  `kPluginAdminMenu` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  `cWertName` varchar(255) NOT NULL,
  `cInputTyp` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  `cConf` varchar(255) NOT NULL,
  `cSourceFile` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kPluginEinstellungenConf`),
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB AUTO_INCREMENT=1683 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplugineinstellungenconfwerte` (
  `kPluginEinstellungenConf` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cWert` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  KEY `kPluginEinstellungenConf` (`kPluginEinstellungenConf`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginemailvorlageeinstellungen` (
  `kEmailvorlage` int(10) unsigned NOT NULL,
  `cKey` varchar(255) NOT NULL,
  `cValue` varchar(255) NOT NULL,
  KEY `kEmailvorlage` (`kEmailvorlage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginhook` (
  `kPluginHook` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL,
  `nHook` int(10) unsigned NOT NULL,
  `cDateiname` varchar(255) NOT NULL,
  `nPriority` int(10) DEFAULT 5,
  PRIMARY KEY (`kPluginHook`),
  KEY `nHook` (`nHook`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginlinkdatei` (
  `kLink` int(10) unsigned NOT NULL,
  `kPlugin` int(10) unsigned NOT NULL,
  `cDatei` varchar(255) NOT NULL,
  `cTemplate` varchar(255) DEFAULT NULL,
  `cFullscreenTemplate` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kLink`),
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginmigration` (
  `kMigration` bigint(14) NOT NULL,
  `nVersion` varchar(255) NOT NULL,
  `pluginID` varchar(255) NOT NULL,
  `dExecuted` datetime NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plgn_migid` (`kMigration`,`pluginID`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginsprachvariable` (
  `kPluginSprachvariable` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'text',
  PRIMARY KEY (`kPluginSprachvariable`),
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB AUTO_INCREMENT=289 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginsprachvariablecustomsprache` (
  `kPlugin` int(10) unsigned NOT NULL,
  `cSprachvariable` varchar(255) NOT NULL,
  `cISO` varchar(5) NOT NULL,
  `cName` mediumtext NOT NULL,
  `kPluginSprachvariable` int(10) NOT NULL,
  PRIMARY KEY (`kPlugin`,`cSprachvariable`,`cISO`,`kPluginSprachvariable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginsprachvariablesprache` (
  `kPluginSprachvariable` int(10) unsigned NOT NULL,
  `cISO` varchar(5) NOT NULL,
  `cName` mediumtext NOT NULL,
  PRIMARY KEY (`kPluginSprachvariable`,`cISO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginsqlfehler` (
  `kPluginSQLFehler` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPluginHook` int(10) unsigned NOT NULL,
  `cSQLFehler` varchar(255) NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kPluginSQLFehler`),
  KEY `kPluginHook` (`kPluginHook`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplugintemplate` (
  `kPluginTemplate` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL,
  `cTemplate` varchar(255) NOT NULL,
  PRIMARY KEY (`kPluginTemplate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginuninstall` (
  `kPluginUninstall` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL,
  `cDateiname` varchar(255) NOT NULL,
  PRIMARY KEY (`kPluginUninstall`),
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpluginzahlungsartklasse` (
  `cModulId` varchar(255) NOT NULL,
  `kPlugin` int(10) unsigned NOT NULL,
  `cClassPfad` varchar(255) NOT NULL,
  `cClassName` varchar(255) NOT NULL,
  `cTemplatePfad` varchar(255) DEFAULT NULL,
  `cZusatzschrittTemplate` varchar(255) NOT NULL,
  PRIMARY KEY (`cModulId`),
  KEY `kPlugin` (`kPlugin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplz` (
  `kPLZ` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cPLZ` varchar(32) DEFAULT NULL,
  `cOrt` varchar(255) DEFAULT NULL,
  `cLandISO` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`kPLZ`),
  UNIQUE KEY `PLZ_ORT_UNIQUE` (`cLandISO`,`cPLZ`,`cOrt`),
  KEY `cPLZ` (`cPLZ`)
) ENGINE=InnoDB AUTO_INCREMENT=21451 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tplz_backup` (
  `kPLZ` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cPLZ` varchar(32) DEFAULT NULL,
  `cOrt` varchar(255) DEFAULT NULL,
  `cLandISO` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`kPLZ`),
  KEY `cPLZ` (`cPLZ`),
  KEY `PLZ_ORT_UNIQUE` (`cLandISO`,`cPLZ`,`cOrt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpreis` (
  `kPreis` int(11) NOT NULL AUTO_INCREMENT,
  `kArtikel` int(11) NOT NULL,
  `kKundengruppe` int(11) NOT NULL,
  `kKunde` int(11) DEFAULT NULL,
  `noDiscount` int(11) DEFAULT 0,
  PRIMARY KEY (`kPreis`),
  UNIQUE KEY `kArtikel` (`kArtikel`,`kKundengruppe`,`kKunde`),
  KEY `idx_tpreis_kKunde` (`kKunde`)
) ENGINE=InnoDB AUTO_INCREMENT=25621 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpreisdetail` (
  `kPreisDetail` int(11) NOT NULL AUTO_INCREMENT,
  `kPreis` int(11) NOT NULL,
  `nAnzahlAb` int(11) NOT NULL,
  `fVKNetto` double NOT NULL,
  PRIMARY KEY (`kPreisDetail`),
  UNIQUE KEY `kPreis_nAnzahlAb` (`kPreis`,`nAnzahlAb`),
  KEY `kPreis` (`kPreis`),
  KEY `kPreis_2` (`kPreis`,`nAnzahlAb`,`fVKNetto`)
) ENGINE=InnoDB AUTO_INCREMENT=25621 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpreisspannenfilter` (
  `kPreisspannenfilter` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nVon` float unsigned NOT NULL,
  `nBis` float unsigned NOT NULL,
  PRIMARY KEY (`kPreisspannenfilter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tpreisverlauf` (
  `kPreisverlauf` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kArtikel` int(10) unsigned DEFAULT NULL,
  `kKundengruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `fVKNetto` double DEFAULT NULL,
  `dDate` date DEFAULT NULL,
  PRIMARY KEY (`kPreisverlauf`),
  UNIQUE KEY `kArtikel` (`kArtikel`,`kKundengruppe`,`dDate`),
  KEY `dDate` (`dDate`)
) ENGINE=InnoDB AUTO_INCREMENT=24948 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tproduktanfragehistory` (
  `kProduktanfrageHistory` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kArtikel` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned DEFAULT NULL,
  `cAnrede` varchar(30) NOT NULL DEFAULT '',
  `cVorname` varchar(255) NOT NULL DEFAULT '',
  `cNachname` varchar(255) NOT NULL DEFAULT '',
  `cFirma` varchar(255) DEFAULT NULL,
  `cTel` varchar(255) DEFAULT NULL,
  `cMobil` varchar(255) DEFAULT NULL,
  `cFax` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) NOT NULL DEFAULT '',
  `cNachricht` longtext DEFAULT NULL,
  `cIP` varchar(255) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kProduktanfrageHistory`),
  KEY `cIP` (`cIP`),
  KEY `kArtikel` (`kArtikel`),
  KEY `kSprache` (`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tprofiler` (
  `runID` int(11) NOT NULL AUTO_INCREMENT,
  `url` mediumtext DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT current_timestamp(),
  `ptype` enum('plugin','sql') DEFAULT NULL,
  `total_count` int(11) DEFAULT NULL,
  `total_time` float DEFAULT NULL,
  PRIMARY KEY (`runID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tprofiler_runs` (
  `execID` int(11) NOT NULL AUTO_INCREMENT,
  `runID` int(11) DEFAULT NULL,
  `filename` varchar(255) DEFAULT '',
  `runtime` float DEFAULT 0,
  `hookID` int(11) DEFAULT NULL,
  `runcount` int(11) DEFAULT 1,
  `data` mediumtext DEFAULT NULL,
  `statement` mediumtext DEFAULT NULL,
  `tablename` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`execID`),
  KEY `runID_idx` (`runID`),
  CONSTRAINT `fk_run_id` FOREIGN KEY (`runID`) REFERENCES `tprofiler` (`runID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `trechnungsadresse` (
  `kRechnungsadresse` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned NOT NULL,
  `cAnrede` varchar(255) NOT NULL,
  `cTitel` varchar(255) NOT NULL,
  `cVorname` varchar(255) NOT NULL,
  `cNachname` varchar(255) NOT NULL,
  `cFirma` varchar(255) NOT NULL,
  `cZusatz` varchar(255) DEFAULT NULL,
  `cStrasse` varchar(255) NOT NULL,
  `cHausnummer` varchar(32) NOT NULL,
  `cAdressZusatz` varchar(255) NOT NULL,
  `cPLZ` varchar(255) NOT NULL,
  `cOrt` varchar(255) NOT NULL,
  `cBundesland` varchar(255) NOT NULL,
  `cLand` varchar(255) NOT NULL,
  `cTel` varchar(255) NOT NULL,
  `cMobil` varchar(255) NOT NULL,
  `cFax` varchar(255) NOT NULL,
  `cUSTID` varchar(255) NOT NULL,
  `cWWW` varchar(255) NOT NULL,
  `cMail` varchar(255) NOT NULL,
  PRIMARY KEY (`kRechnungsadresse`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tredirect` (
  `kRedirect` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cFromUrl` varchar(255) NOT NULL,
  `cToUrl` varchar(255) NOT NULL,
  `nCount` int(10) unsigned DEFAULT NULL,
  `cAvailable` char(1) DEFAULT 'u',
  `paramHandling` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kRedirect`),
  KEY `idxFromTo` (`cFromUrl`,`cToUrl`),
  KEY `idxCount` (`cToUrl`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tredirectreferer` (
  `kRedirectReferer` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kRedirect` int(10) unsigned NOT NULL,
  `kBesucherBot` int(10) unsigned NOT NULL,
  `cRefererUrl` varchar(255) NOT NULL,
  `cIP` varchar(15) NOT NULL,
  `dDate` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kRedirectReferer`),
  KEY `dDate` (`dDate`),
  KEY `kRedirect` (`kRedirect`)
) ENGINE=InnoDB AUTO_INCREMENT=12776 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `trevisions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `reference_primary` int(11) NOT NULL,
  `reference_secondary` int(11) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `author` mediumtext NOT NULL,
  `custom_table` mediumtext NOT NULL,
  `custom_primary_key` mediumtext NOT NULL,
  `timestamp` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `trma` (
  `kRMA` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned DEFAULT 0,
  `kRMAStatus` int(10) unsigned NOT NULL,
  `cRMANumber` varchar(255) DEFAULT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kRMA`),
  KEY `kKunde` (`kKunde`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `trmaartikel` (
  `kRMA` int(10) unsigned NOT NULL,
  `kBestellung` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL,
  `fAnzahl` float unsigned NOT NULL,
  `cGrund` varchar(255) NOT NULL,
  `cKommentar` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kRMA`,`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `trmagrund` (
  `kRMAGrund` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `nSort` tinyint(3) unsigned DEFAULT 0,
  `cGrund` varchar(255) NOT NULL,
  `cKommentar` varchar(255) NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kRMAGrund`),
  KEY `kSprache` (`kSprache`,`nAktiv`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `trmastatus` (
  `kRMAStatus` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cStatus` varchar(255) NOT NULL,
  `eFunktion` enum('start','keine','ende') NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kRMAStatus`),
  KEY `kSprache` (`kSprache`,`nAktiv`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tseo` (
  `cSeo` varchar(255) NOT NULL,
  `cKey` varchar(255) NOT NULL,
  `kKey` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`cSeo`),
  UNIQUE KEY `cKey` (`cKey`,`kKey`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsession` (
  `cSessionId` varchar(128) NOT NULL DEFAULT '',
  `nSessionExpires` int(10) unsigned NOT NULL DEFAULT 0,
  `cSessionData` mediumtext DEFAULT NULL,
  PRIMARY KEY (`cSessionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsitemapreport` (
  `kSitemapReport` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nTotalURL` int(10) unsigned NOT NULL,
  `fVerarbeitungszeit` double unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kSitemapReport`),
  KEY `dErstellt` (`dErstellt`)
) ENGINE=InnoDB AUTO_INCREMENT=1471 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsitemapreportfile` (
  `kSitemapReportFile` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSitemapReport` int(10) unsigned NOT NULL,
  `cDatei` varchar(255) NOT NULL,
  `nAnzahlURL` int(10) unsigned NOT NULL,
  `fGroesse` double unsigned NOT NULL,
  PRIMARY KEY (`kSitemapReportFile`),
  KEY `kSitemapReport` (`kSitemapReport`)
) ENGINE=InnoDB AUTO_INCREMENT=1471 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsitemaptracker` (
  `kSitemapTracker` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cSitemap` varchar(255) NOT NULL,
  `kBesucherBot` int(10) unsigned NOT NULL,
  `cIP` varchar(255) NOT NULL,
  `cUserAgent` varchar(255) NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kSitemapTracker`)
) ENGINE=InnoDB AUTO_INCREMENT=2873 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tslide` (
  `kSlide` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSlider` int(10) unsigned NOT NULL,
  `cTitel` varchar(255) NOT NULL,
  `cBild` varchar(255) NOT NULL,
  `cText` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  `cThumbnail` varchar(255) NOT NULL,
  `cLink` varchar(255) NOT NULL,
  PRIMARY KEY (`kSlide`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tslider` (
  `kSlider` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `kKundengruppe` int(10) unsigned NOT NULL,
  `nSeitenTyp` int(10) unsigned NOT NULL,
  `cTheme` varchar(45) NOT NULL,
  `bAktiv` tinyint(1) NOT NULL,
  `nPauseTime` int(10) unsigned NOT NULL,
  `nAnimationSpeed` int(10) unsigned NOT NULL,
  `bPauseOnHover` tinyint(1) NOT NULL,
  `bThumbnail` tinyint(1) NOT NULL,
  `cEffects` varchar(255) NOT NULL,
  `bControlNav` tinyint(1) NOT NULL,
  `bDirectionNav` tinyint(1) NOT NULL,
  `bRandomStart` tinyint(1) NOT NULL,
  `bUseKB` tinyint(1) NOT NULL,
  PRIMARY KEY (`kSlider`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsonderpreise` (
  `kArtikelSonderpreis` int(11) NOT NULL DEFAULT 0,
  `kKundengruppe` int(11) NOT NULL DEFAULT 0,
  `fNettoPreis` double DEFAULT NULL,
  PRIMARY KEY (`kArtikelSonderpreis`,`kKundengruppe`),
  KEY `fNettoPreis` (`fNettoPreis`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tspezialcontentsprache` (
  `nSpezialContent` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `cISOSprache` varchar(5) NOT NULL,
  `cTyp` varchar(255) NOT NULL DEFAULT '',
  `cContent` longtext DEFAULT NULL,
  PRIMARY KEY (`nSpezialContent`,`cISOSprache`,`cTyp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tspezialseite` (
  `kSpezialseite` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kPlugin` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) NOT NULL,
  `cDateiname` varchar(255) DEFAULT NULL,
  `nLinkart` int(10) unsigned NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kSpezialseite`),
  KEY `nLinkart` (`nLinkart`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsprache` (
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cNameEnglisch` varchar(255) DEFAULT NULL,
  `cNameDeutsch` varchar(255) DEFAULT NULL,
  `cStandard` char(1) DEFAULT 'N',
  `cISO` varchar(5) NOT NULL,
  `cShopStandard` char(1) DEFAULT 'N',
  `active` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`kSprache`),
  KEY `activeISO` (`active`,`cISO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsprachiso` (
  `kSprachISO` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cISO` varchar(5) NOT NULL,
  PRIMARY KEY (`kSprachISO`),
  UNIQUE KEY `kSprachISOcISO` (`kSprachISO`,`cISO`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsprachlog` (
  `kSprachISO` int(10) NOT NULL,
  `cSektion` varchar(255) NOT NULL,
  `cName` varchar(255) NOT NULL,
  PRIMARY KEY (`kSprachISO`,`cSektion`,`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsprachsektion` (
  `kSprachsektion` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kSprachsektion`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsprachwerte` (
  `kSprachISO` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprachsektion` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) NOT NULL,
  `cWert` mediumtext NOT NULL,
  `cStandard` mediumtext NOT NULL,
  `bSystem` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kSprachISO`,`kSprachsektion`,`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tstaat` (
  `kStaat` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cLandIso` varchar(2) NOT NULL COMMENT 'should be value of ISO 3166-1',
  `cName` varchar(255) NOT NULL COMMENT 'full name of the state or province',
  `cCode` varchar(10) NOT NULL COMMENT 'should be value of ISO 3166-2',
  PRIMARY KEY (`kStaat`),
  KEY `cLandIso` (`cLandIso`),
  KEY `cName` (`cName`),
  KEY `cCode` (`cCode`)
) ENGINE=InnoDB AUTO_INCREMENT=998 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tstatusemail` (
  `cEmail` varchar(255) NOT NULL,
  `cInhalt` varchar(255) NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `nInterval` int(11) NOT NULL,
  `dLastSent` datetime DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsteuerklasse` (
  `kSteuerklasse` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cStandard` char(1) DEFAULT NULL,
  PRIMARY KEY (`kSteuerklasse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsteuersatz` (
  `kSteuersatz` int(10) unsigned NOT NULL DEFAULT 0,
  `kSteuerzone` int(10) unsigned DEFAULT NULL,
  `kSteuerklasse` int(10) unsigned DEFAULT NULL,
  `fSteuersatz` double(6,2) DEFAULT NULL,
  `nPrio` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`kSteuersatz`),
  KEY `kSteuerzone` (`kSteuerzone`),
  KEY `kSteuerklasse` (`kSteuerklasse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsteuerzone` (
  `kSteuerzone` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kSteuerzone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsteuerzoneland` (
  `kSteuerzone` int(10) unsigned NOT NULL DEFAULT 0,
  `cISO` varchar(5) NOT NULL,
  PRIMARY KEY (`kSteuerzone`,`cISO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tstoreauth` (
  `owner` int(11) NOT NULL,
  `auth_code` varchar(64) NOT NULL,
  `access_token` mediumtext DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `verified` varchar(128) NOT NULL,
  PRIMARY KEY (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tstueckliste` (
  `kStueckliste` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL,
  `fAnzahl` double NOT NULL,
  KEY `kArtikel` (`kArtikel`),
  KEY `kStueckliste` (`kStueckliste`),
  KEY `kStuecklisteArtikel` (`kStueckliste`,`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchanfrage` (
  `kSuchanfrage` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) NOT NULL,
  `cSuche` varchar(255) DEFAULT NULL,
  `cSeo` varchar(255) NOT NULL,
  `nAktiv` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `nAnzahlTreffer` int(10) unsigned DEFAULT NULL,
  `nAnzahlGesuche` int(10) unsigned DEFAULT NULL,
  `dZuletztGesucht` datetime DEFAULT NULL,
  PRIMARY KEY (`kSuchanfrage`),
  KEY `nAnzahlTreffer` (`nAnzahlTreffer`),
  KEY `cSeo` (`cSeo`),
  KEY `kSprache` (`kSprache`,`cSuche`),
  KEY `cSuche` (`cSuche`),
  KEY `dZuletztGesucht` (`dZuletztGesucht`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchanfrageblacklist` (
  `kSuchanfrageBlacklist` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cSuche` varchar(255) NOT NULL,
  PRIMARY KEY (`kSuchanfrageBlacklist`),
  KEY `cSuche` (`cSuche`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchanfrageerfolglos` (
  `kSuchanfrageErfolglos` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) NOT NULL,
  `cSuche` varchar(255) NOT NULL DEFAULT '',
  `nAnzahlGesuche` int(10) unsigned DEFAULT NULL,
  `dZuletztGesucht` datetime DEFAULT NULL,
  PRIMARY KEY (`kSuchanfrageErfolglos`),
  KEY `kSprache` (`kSprache`,`cSuche`),
  KEY `cSuche` (`cSuche`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchanfragemapping` (
  `kSuchanfrageMapping` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cSuche` varchar(255) NOT NULL,
  `cSucheNeu` varchar(255) NOT NULL,
  `nAnzahlGesuche` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`kSuchanfrageMapping`),
  KEY `kSprache` (`kSprache`,`cSuche`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchanfragencache` (
  `kSuchanfrageCache` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cIP` varchar(255) NOT NULL,
  `cSuche` varchar(255) NOT NULL,
  `dZeit` datetime NOT NULL,
  PRIMARY KEY (`kSuchanfrageCache`),
  KEY `dZeit` (`dZeit`),
  KEY `cIP` (`kSprache`,`cIP`,`cSuche`)
) ENGINE=InnoDB AUTO_INCREMENT=1049 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchcache` (
  `kSuchCache` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `cSuche` varchar(255) NOT NULL,
  `dErstellt` datetime NOT NULL,
  `dGueltigBis` datetime DEFAULT NULL,
  PRIMARY KEY (`kSuchCache`),
  KEY `cSuche` (`cSuche`,`kSprache`),
  KEY `dGueltigBis` (`dGueltigBis`)
) ENGINE=InnoDB AUTO_INCREMENT=1359 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchcachetreffer` (
  `kSuchCache` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL,
  `nSort` int(11) NOT NULL DEFAULT 0,
  KEY `kSuchCache` (`kSuchCache`),
  KEY `kArtikel` (`kArtikel`,`nSort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchspecialoverlay` (
  `kSuchspecialOverlay` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cSuchspecial` varchar(255) NOT NULL,
  PRIMARY KEY (`kSuchspecialOverlay`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsuchspecialoverlaysprache` (
  `kSuchspecialOverlay` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cTemplate` varchar(255) NOT NULL,
  `cBildPfad` varchar(255) NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `nPrio` tinyint(3) unsigned NOT NULL,
  `nMargin` int(10) unsigned DEFAULT 0,
  `nTransparenz` tinyint(3) unsigned DEFAULT 0,
  `nGroesse` int(10) unsigned DEFAULT 0,
  `nPosition` tinyint(3) unsigned DEFAULT 0,
  PRIMARY KEY (`kSuchspecialOverlay`,`kSprache`,`cTemplate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tsynclogin` (
  `kSynclogin` int(11) NOT NULL DEFAULT 1,
  `cMail` varchar(255) DEFAULT '',
  `cName` varchar(255) NOT NULL,
  `cPass` varchar(255) NOT NULL,
  PRIMARY KEY (`kSynclogin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ttemplate` (
  `cTemplate` varchar(255) DEFAULT NULL,
  `eTyp` enum('standard','mobil','admin','test') NOT NULL,
  `parent` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `version` varchar(20) NOT NULL,
  `preview` varchar(255) DEFAULT NULL,
  `exsID` varchar(255) DEFAULT NULL,
  `bootstrap` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `framework` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ttemplateeinstellungen` (
  `cTemplate` varchar(255) NOT NULL,
  `cSektion` varchar(255) NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cWert` mediumtext DEFAULT NULL,
  KEY `kTemplateEinstellungenSektion` (`cTemplate`,`cSektion`,`cName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ttext` (
  `kText` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(11) NOT NULL,
  `kKundengruppe` int(11) NOT NULL,
  `cAGBContentText` mediumtext DEFAULT NULL,
  `cAGBContentHtml` mediumtext DEFAULT NULL,
  `cWRBContentText` mediumtext DEFAULT NULL,
  `cWRBContentHtml` mediumtext DEFAULT NULL,
  `nStandard` tinyint(4) NOT NULL DEFAULT 0,
  `cWRBFormContentHtml` mediumtext DEFAULT NULL,
  `cWRBFormContentText` mediumtext DEFAULT NULL,
  `cDSEContentText` mediumtext DEFAULT '',
  `cDSEContentHtml` mediumtext DEFAULT '',
  PRIMARY KEY (`kText`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ttrennzeichen` (
  `kTrennzeichen` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `nEinheit` tinyint(3) unsigned NOT NULL,
  `nDezimalstellen` tinyint(3) unsigned DEFAULT 0,
  `cDezimalZeichen` varchar(255) DEFAULT ',',
  `cTausenderZeichen` varchar(255) DEFAULT '.',
  PRIMARY KEY (`kTrennzeichen`),
  UNIQUE KEY `unique_lang_unit` (`kSprache`,`nEinheit`),
  KEY `kSprache` (`kSprache`,`nEinheit`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ttrustedeshopsprodukt` (
  `kTrustedShopsProdukt` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSprache` int(10) unsigned NOT NULL,
  `kTrustedShopsZertifikat` int(10) unsigned NOT NULL,
  `nID` int(10) unsigned NOT NULL,
  `nWert` int(10) unsigned NOT NULL,
  `cWaehrung` varchar(255) NOT NULL,
  `cProduktID` varchar(255) NOT NULL,
  `fNetto` double unsigned NOT NULL,
  `fBrutto` double unsigned NOT NULL,
  `dDatum` datetime NOT NULL,
  PRIMARY KEY (`kTrustedShopsProdukt`),
  KEY `cProduktID` (`cProduktID`),
  KEY `kSprache` (`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ttrustedshopskundenbewertung` (
  `kTrustedshopsKundenbewertung` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nStatus` tinyint(3) unsigned NOT NULL,
  `cTSID` varchar(255) NOT NULL,
  `cISOSprache` varchar(5) NOT NULL,
  `dAktualisiert` datetime NOT NULL,
  PRIMARY KEY (`kTrustedshopsKundenbewertung`),
  KEY `cISOSprache` (`cISOSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ttrustedshopsstatistik` (
  `kStatistik` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cTSID` varchar(255) DEFAULT NULL,
  `nAnzahl` int(10) unsigned DEFAULT NULL,
  `dMaximum` decimal(9,2) unsigned DEFAULT NULL,
  `dDurchschnitt` decimal(9,2) unsigned DEFAULT NULL,
  `dUpdated` datetime DEFAULT NULL,
  PRIMARY KEY (`kStatistik`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ttrustedshopszertifikat` (
  `kTrustedShopsZertifikat` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cTSID` varchar(255) NOT NULL,
  `cWSUser` varchar(255) DEFAULT NULL,
  `cWSPasswort` varchar(255) DEFAULT NULL,
  `cISOSprache` varchar(5) NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `eType` enum('CLASSIC','EXCELLENCE') NOT NULL DEFAULT 'CLASSIC',
  `dErstellt` datetime NOT NULL,
  `dChecked` datetime NOT NULL,
  PRIMARY KEY (`kTrustedShopsZertifikat`),
  KEY `cISOSprache` (`cISOSprache`),
  KEY `nAktiv` (`nAktiv`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tuploaddatei` (
  `kUpload` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kCustomID` int(10) unsigned NOT NULL,
  `nTyp` tinyint(1) NOT NULL DEFAULT 0,
  `cName` varchar(255) NOT NULL,
  `cPfad` varchar(255) NOT NULL,
  `nBytes` int(10) unsigned NOT NULL DEFAULT 0,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kUpload`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tuploadqueue` (
  `kUploadqueue` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBestellung` int(10) unsigned NOT NULL DEFAULT 10,
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 10,
  PRIMARY KEY (`kUploadqueue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tuploadschema` (
  `kUploadSchema` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kCustomID` int(10) unsigned NOT NULL,
  `nTyp` tinyint(1) NOT NULL DEFAULT 0,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL,
  `cDateiTyp` varchar(255) NOT NULL DEFAULT '.*',
  `nPflicht` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kUploadSchema`),
  KEY `kCustomID` (`kCustomID`,`nTyp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tuploadschemasprache` (
  `kArtikelUpload` int(11) NOT NULL,
  `kSprache` int(11) NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tverfuegbarkeitsbenachrichtigung` (
  `kVerfuegbarkeitsbenachrichtigung` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kArtikel` int(10) unsigned DEFAULT NULL,
  `kSprache` int(10) unsigned DEFAULT NULL,
  `cVorname` varchar(255) DEFAULT NULL,
  `cNachname` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) DEFAULT NULL,
  `cIP` varchar(255) DEFAULT NULL,
  `cAbgeholt` varchar(2) DEFAULT 'N',
  `nStatus` tinyint(3) unsigned DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  `dBenachrichtigtAm` datetime DEFAULT NULL,
  PRIMARY KEY (`kVerfuegbarkeitsbenachrichtigung`),
  UNIQUE KEY `idx_cMail_kArtikel` (`cMail`,`kArtikel`),
  KEY `kArtikel` (`kArtikel`),
  KEY `cMail` (`cMail`),
  KEY `cIP` (`cIP`),
  KEY `cAbgeholt` (`cAbgeholt`),
  KEY `dBenachrichtigtAm` (`dBenachrichtigtAm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tvergleichsliste` (
  `kVergleichsliste` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cIP` varchar(255) NOT NULL,
  `dDate` datetime NOT NULL,
  PRIMARY KEY (`kVergleichsliste`),
  KEY `cIP` (`cIP`),
  KEY `dDate` (`dDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tvergleichslistepos` (
  `kVergleichslistePos` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kVergleichsliste` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL,
  `cArtikelName` varchar(255) NOT NULL,
  PRIMARY KEY (`kVergleichslistePos`),
  KEY `kVergleichsliste` (`kVergleichsliste`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tverpackung` (
  `kVerpackung` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSteuerklasse` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cKundengruppe` varchar(255) NOT NULL,
  `fBrutto` double(10,2) NOT NULL,
  `fMindestbestellwert` double(10,2) unsigned NOT NULL,
  `fKostenfrei` double(10,2) unsigned NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`kVerpackung`),
  KEY `fMindestbestellwert` (`fMindestbestellwert`),
  KEY `fKostenfrei` (`fKostenfrei`),
  KEY `kSteuerklasse` (`kSteuerklasse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tverpackungsprache` (
  `kVerpackungSprache` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kVerpackung` int(10) unsigned NOT NULL,
  `cISOSprache` varchar(5) NOT NULL,
  `cName` varchar(255) NOT NULL,
  `cBeschreibung` varchar(255) NOT NULL,
  PRIMARY KEY (`kVerpackungSprache`),
  KEY `kVerpackung` (`kVerpackung`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversand` (
  `kVersand` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kLieferschein` int(10) unsigned NOT NULL,
  `cLogistik` varchar(255) NOT NULL,
  `cLogistikURL` varchar(255) NOT NULL,
  `cIdentCode` varchar(255) NOT NULL,
  `cHinweis` varchar(255) NOT NULL,
  `dErstellt` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kVersand`)
) ENGINE=InnoDB AUTO_INCREMENT=25660 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandart` (
  `kVersandart` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kVersandberechnung` int(10) unsigned DEFAULT NULL,
  `cVersandklassen` varchar(8192) DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cLaender` mediumtext DEFAULT NULL,
  `cAnzeigen` varchar(255) DEFAULT NULL,
  `cKundengruppen` varchar(255) NOT NULL,
  `cBild` varchar(255) NOT NULL,
  `eSteuer` enum('netto','brutto') NOT NULL,
  `nSort` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `nMinLiefertage` tinyint(4) DEFAULT 2,
  `nMaxLiefertage` tinyint(4) DEFAULT 3,
  `fPreis` double(10,2) NOT NULL DEFAULT 0.00,
  `fVersandkostenfreiAbX` double(10,2) NOT NULL DEFAULT 0.00,
  `fDeckelung` double(10,2) NOT NULL DEFAULT 0.00,
  `cNurAbhaengigeVersandart` char(1) NOT NULL DEFAULT 'N',
  `cSendConfirmationMail` char(1) NOT NULL DEFAULT 'Y',
  `cIgnoreShippingProposal` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`kVersandart`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandartsprache` (
  `kVersandart` int(10) unsigned NOT NULL DEFAULT 0,
  `cISOSprache` varchar(5) NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cLieferdauer` varchar(255) DEFAULT NULL,
  `cHinweistext` mediumtext DEFAULT NULL,
  `cHinweistextShop` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kVersandart`,`cISOSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandartstaffel` (
  `kVersandartStaffel` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kVersandart` int(10) unsigned DEFAULT NULL,
  `fBis` double DEFAULT NULL,
  `fPreis` double DEFAULT NULL,
  PRIMARY KEY (`kVersandartStaffel`),
  KEY `kVersandart` (`kVersandart`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandartzahlungsart` (
  `kVersandartZahlungsart` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kVersandart` int(10) unsigned DEFAULT NULL,
  `kZahlungsart` int(10) unsigned NOT NULL DEFAULT 0,
  `fAufpreis` double(10,2) DEFAULT NULL,
  `cAufpreisTyp` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`kVersandartZahlungsart`),
  KEY `kVersandart` (`kVersandart`),
  KEY `kZahlungsart` (`kZahlungsart`)
) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandberechnung` (
  `kVersandberechnung` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) DEFAULT NULL,
  `cModulId` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kVersandberechnung`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandklasse` (
  `kVersandklasse` int(10) unsigned NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kVersandklasse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandzuschlag` (
  `kVersandzuschlag` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kVersandart` int(10) unsigned DEFAULT NULL,
  `cISO` varchar(5) NOT NULL,
  `cName` varchar(255) NOT NULL DEFAULT '',
  `fZuschlag` double(10,4) DEFAULT NULL,
  PRIMARY KEY (`kVersandzuschlag`),
  KEY `kVersandart` (`kVersandart`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandzuschlagplz` (
  `kVersandzuschlagPlz` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kVersandzuschlag` int(10) unsigned DEFAULT NULL,
  `cPLZ` varchar(40) DEFAULT NULL,
  `cPLZAb` varchar(40) DEFAULT NULL,
  `cPLZBis` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`kVersandzuschlagPlz`),
  KEY `kVersandzuschlag` (`kVersandzuschlag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversandzuschlagsprache` (
  `kVersandzuschlag` int(10) unsigned NOT NULL DEFAULT 0,
  `cISOSprache` varchar(5) NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kVersandzuschlag`,`cISOSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tversion` (
  `nVersion` varchar(20) NOT NULL,
  `nZeileVon` int(10) unsigned NOT NULL,
  `nZeileBis` int(10) unsigned NOT NULL,
  `nInArbeit` tinyint(4) NOT NULL,
  `nFehler` tinyint(3) unsigned NOT NULL,
  `nTyp` int(4) unsigned NOT NULL,
  `cFehlerSQL` varchar(255) NOT NULL,
  `dAktualisiert` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twaehrung` (
  `kWaehrung` int(10) unsigned NOT NULL DEFAULT 0,
  `cISO` varchar(5) NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cNameHTML` varchar(255) DEFAULT NULL,
  `fFaktor` double DEFAULT NULL,
  `cStandard` char(1) DEFAULT 'N',
  `cVorBetrag` char(1) DEFAULT 'N',
  `cTrennzeichenCent` char(1) NOT NULL DEFAULT ',',
  `cTrennzeichenTausend` char(1) NOT NULL DEFAULT '.',
  PRIMARY KEY (`kWaehrung`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarengruppe` (
  `kWarengruppe` int(10) unsigned NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kWarengruppe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarenkorb` (
  `kWarenkorb` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned NOT NULL DEFAULT 0,
  `kLieferadresse` int(10) unsigned NOT NULL DEFAULT 0,
  `kZahlungsInfo` int(10) unsigned DEFAULT 0,
  PRIMARY KEY (`kWarenkorb`),
  KEY `kKunde` (`kKunde`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarenkorbpers` (
  `kWarenkorbPers` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kWarenkorbPers`),
  KEY `kKunde` (`kKunde`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarenkorbperspos` (
  `kWarenkorbPersPos` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kWarenkorbPers` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL,
  `cArtikelName` varchar(255) NOT NULL,
  `fAnzahl` double(10,2) NOT NULL,
  `dHinzugefuegt` datetime NOT NULL,
  `cUnique` varchar(255) NOT NULL,
  `cResponsibility` varchar(255) NOT NULL DEFAULT 'core',
  `kKonfigitem` int(10) unsigned NOT NULL,
  `nPosTyp` tinyint(3) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`kWarenkorbPersPos`),
  KEY `kWarenkorbPers` (`kWarenkorbPers`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarenkorbpersposeigenschaft` (
  `kWarenkorbPersPosEigenschaft` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kWarenkorbPersPos` int(10) unsigned NOT NULL,
  `kEigenschaft` int(10) unsigned NOT NULL,
  `kEigenschaftWert` int(10) unsigned NOT NULL,
  `cFreifeldWert` varchar(255) NOT NULL,
  `cEigenschaftName` varchar(255) NOT NULL,
  `cEigenschaftWertName` varchar(255) NOT NULL,
  PRIMARY KEY (`kWarenkorbPersPosEigenschaft`),
  KEY `kWarenkorbPersPos` (`kWarenkorbPersPos`),
  KEY `kEigenschaft` (`kEigenschaft`),
  KEY `kEigenschaftWert` (`kEigenschaftWert`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarenkorbpos` (
  `kWarenkorbPos` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kWarenkorb` int(10) unsigned NOT NULL DEFAULT 0,
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kVersandklasse` int(10) unsigned NOT NULL DEFAULT 1,
  `cName` varchar(255) DEFAULT NULL,
  `cLieferstatus` varchar(255) NOT NULL DEFAULT '',
  `cArtNr` varchar(255) NOT NULL DEFAULT '',
  `cEinheit` varchar(255) NOT NULL DEFAULT '',
  `fPreisEinzelNetto` double NOT NULL DEFAULT 0,
  `fPreis` double NOT NULL DEFAULT 0,
  `fMwSt` float(5,2) DEFAULT NULL,
  `nAnzahl` double(10,4) unsigned NOT NULL DEFAULT 0.0000,
  `nPosTyp` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `cHinweis` varchar(255) NOT NULL,
  `cUnique` varchar(255) NOT NULL,
  `cResponsibility` varchar(255) NOT NULL DEFAULT 'core',
  `kKonfigitem` int(10) unsigned NOT NULL DEFAULT 0,
  `kBestellpos` int(10) unsigned NOT NULL DEFAULT 0,
  `fLagerbestandVorAbschluss` double DEFAULT NULL,
  `nLongestMinDelivery` int(11) NOT NULL DEFAULT 0,
  `nLongestMaxDelivery` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`kWarenkorbPos`),
  KEY `kWarenkorb` (`kWarenkorb`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarenkorbposeigenschaft` (
  `kWarenkorbPosEigenschaft` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kWarenkorbPos` int(10) unsigned NOT NULL DEFAULT 0,
  `kEigenschaft` int(10) unsigned NOT NULL DEFAULT 0,
  `kEigenschaftWert` int(10) unsigned NOT NULL DEFAULT 0,
  `cEigenschaftName` varchar(255) NOT NULL DEFAULT '',
  `cEigenschaftWertName` varchar(255) NOT NULL DEFAULT '',
  `cFreifeldWert` varchar(255) NOT NULL DEFAULT '',
  `fAufpreis` double DEFAULT 0,
  PRIMARY KEY (`kWarenkorbPosEigenschaft`),
  KEY `kWarenkorbPos` (`kWarenkorbPos`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarenlager` (
  `kWarenlager` int(10) unsigned NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cKuerzel` varchar(255) DEFAULT NULL,
  `cLagerTyp` varchar(255) DEFAULT NULL,
  `cBeschreibung` varchar(255) DEFAULT NULL,
  `cStrasse` varchar(255) DEFAULT NULL,
  `cPLZ` varchar(255) DEFAULT NULL,
  `cOrt` varchar(255) DEFAULT NULL,
  `cLand` varchar(255) DEFAULT NULL,
  `nFulfillment` tinyint(3) unsigned DEFAULT NULL,
  `nAktiv` tinyint(3) unsigned DEFAULT 0,
  PRIMARY KEY (`kWarenlager`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twarenlagersprache` (
  `kWarenlager` int(10) unsigned NOT NULL,
  `kSprache` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  PRIMARY KEY (`kWarenlager`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twunschliste` (
  `kWunschliste` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned NOT NULL,
  `cName` varchar(255) NOT NULL,
  `nStandard` tinyint(1) unsigned NOT NULL,
  `nOeffentlich` tinyint(1) unsigned NOT NULL,
  `cURLID` varchar(255) NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kWunschliste`),
  KEY `kKunde` (`kKunde`),
  KEY `cURLID` (`cURLID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twunschlistepos` (
  `kWunschlistePos` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kWunschliste` int(10) unsigned NOT NULL,
  `kArtikel` int(10) unsigned NOT NULL,
  `cArtikelName` varchar(255) NOT NULL,
  `fAnzahl` float unsigned NOT NULL,
  `cKommentar` varchar(255) NOT NULL,
  `dHinzugefuegt` datetime NOT NULL,
  PRIMARY KEY (`kWunschlistePos`),
  KEY `kWunschliste` (`kWunschliste`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twunschlisteposeigenschaft` (
  `kWunschlistePosEigenschaft` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kWunschlistePos` int(10) unsigned NOT NULL,
  `kEigenschaft` int(10) unsigned NOT NULL,
  `kEigenschaftWert` int(10) unsigned NOT NULL,
  `cFreifeldWert` varchar(255) NOT NULL,
  `cEigenschaftName` varchar(255) NOT NULL,
  `cEigenschaftWertName` varchar(255) NOT NULL,
  PRIMARY KEY (`kWunschlistePosEigenschaft`),
  KEY `kWunschlistePos` (`kWunschlistePos`),
  KEY `kEigenschaft` (`kEigenschaft`),
  KEY `kEigenschaftWert` (`kEigenschaftWert`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `twunschlisteversand` (
  `kWunschlisteVersand` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kWunschliste` int(10) unsigned NOT NULL,
  `nAnzahlEmpfaenger` int(10) unsigned NOT NULL,
  `nAnzahlArtikel` int(10) unsigned NOT NULL,
  `dZeit` datetime NOT NULL,
  PRIMARY KEY (`kWunschlisteVersand`),
  KEY `kWunschliste` (`kWunschliste`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `txsell` (
  `kXSell` int(10) unsigned NOT NULL DEFAULT 0,
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kXSellArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kXSellGruppe` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kXSell`),
  KEY `kArtikel` (`kArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `txsellgruppe` (
  `kXSellGruppe` int(10) unsigned NOT NULL DEFAULT 0,
  `kSprache` int(10) unsigned NOT NULL DEFAULT 0,
  `cName` varchar(255) DEFAULT NULL,
  `cBeschreibung` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kXSellGruppe`,`kSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `txsellkauf` (
  `kArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `kXSellArtikel` int(10) unsigned NOT NULL DEFAULT 0,
  `nAnzahl` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`kArtikel`,`kXSellArtikel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tzahlungbackground` (
  `cSID` varchar(255) NOT NULL,
  `cKey` varchar(255) NOT NULL,
  `kKey` int(10) unsigned NOT NULL,
  `cCustomData` varchar(255) DEFAULT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`cSID`),
  KEY `cKey` (`cKey`,`kKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tzahlungsart` (
  `kZahlungsart` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) DEFAULT NULL,
  `cModulId` varchar(255) DEFAULT NULL,
  `cKundengruppen` varchar(255) DEFAULT NULL,
  `cZusatzschrittTemplate` varchar(255) NOT NULL DEFAULT '',
  `cPluginTemplate` varchar(255) DEFAULT NULL,
  `cBild` varchar(255) NOT NULL,
  `nSort` tinyint(4) NOT NULL DEFAULT 0,
  `nMailSenden` tinyint(4) unsigned NOT NULL,
  `nActive` tinyint(1) NOT NULL DEFAULT 1,
  `cAnbieter` varchar(255) NOT NULL,
  `cTSCode` varchar(255) NOT NULL,
  `nWaehrendBestellung` tinyint(3) unsigned NOT NULL,
  `nCURL` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `nSOAP` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `nSOCKETS` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `nNutzbar` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`kZahlungsart`)
) ENGINE=InnoDB AUTO_INCREMENT=322 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tzahlungsartsprache` (
  `kZahlungsart` int(10) unsigned NOT NULL DEFAULT 0,
  `cISOSprache` varchar(5) NOT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cGebuehrname` varchar(255) NOT NULL DEFAULT '',
  `cHinweisText` mediumtext NOT NULL,
  `cHinweisTextShop` mediumtext DEFAULT NULL,
  PRIMARY KEY (`kZahlungsart`,`cISOSprache`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tzahlungseingang` (
  `kZahlungseingang` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBestellung` int(10) unsigned DEFAULT NULL,
  `cZahlungsanbieter` varchar(255) NOT NULL DEFAULT '',
  `fBetrag` double DEFAULT NULL,
  `fZahlungsgebuehr` double DEFAULT NULL,
  `cISO` varchar(5) NOT NULL,
  `cEmpfaenger` varchar(255) DEFAULT NULL,
  `cZahler` varchar(255) DEFAULT NULL,
  `dZeit` datetime DEFAULT NULL,
  `cHinweis` varchar(255) NOT NULL,
  `cAbgeholt` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`kZahlungseingang`),
  KEY `kBestellung` (`kBestellung`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tzahlungsession` (
  `kBestellung` int(10) unsigned NOT NULL DEFAULT 0,
  `cSID` varchar(128) NOT NULL DEFAULT '',
  `cZahlungsID` varchar(50) DEFAULT NULL,
  `cNotifyID` varchar(255) NOT NULL,
  `nBezahlt` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `dNotify` datetime DEFAULT NULL,
  `dZeitBezahlt` datetime NOT NULL,
  `dZeit` datetime DEFAULT NULL,
  KEY `kBestellung` (`kBestellung`),
  KEY `cSID` (`cSID`),
  KEY `cZahlungsID` (`cZahlungsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tzahlungsid` (
  `kBestellung` int(10) unsigned DEFAULT NULL,
  `kZahlungsart` int(10) unsigned DEFAULT NULL,
  `cId` varchar(128) NOT NULL DEFAULT '',
  `txn_id` varchar(255) NOT NULL DEFAULT '',
  `dDatum` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Zeitpunkt, an dem der Zahlungsvorgang gestartet wird',
  KEY `cId` (`cId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tzahlungsinfo` (
  `kZahlungsInfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBestellung` int(10) unsigned NOT NULL DEFAULT 0,
  `kKunde` int(10) unsigned NOT NULL DEFAULT 0,
  `cBankName` varchar(255) DEFAULT NULL,
  `cBLZ` varchar(255) DEFAULT NULL,
  `cKontoNr` varchar(255) DEFAULT NULL,
  `cIBAN` varchar(255) DEFAULT NULL,
  `cBIC` varchar(255) DEFAULT NULL,
  `cKartenNr` varchar(255) DEFAULT NULL,
  `cGueltigkeit` varchar(255) DEFAULT NULL,
  `cCVV` varchar(255) DEFAULT NULL,
  `cKartenTyp` varchar(255) DEFAULT NULL,
  `cInhaber` varchar(255) DEFAULT NULL,
  `cVerwendungszweck` varchar(255) DEFAULT NULL,
  `cAbgeholt` varchar(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`kZahlungsInfo`),
  KEY `kBestellung` (`kBestellung`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tzahlungslog` (
  `kZahlunglog` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cModulId` varchar(255) NOT NULL,
  `cLog` mediumtext NOT NULL,
  `cLogData` mediumtext NOT NULL,
  `nLevel` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Error, 2=Notice, 3=Debug',
  `dDatum` datetime NOT NULL,
  PRIMARY KEY (`kZahlunglog`),
  KEY `idx_tzahlungslog_module` (`cModulId`,`nLevel`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_jtl_google_shopping_attribut` (
  `kAttribut` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `kVaterAttribut` int(11) unsigned NOT NULL DEFAULT 0,
  `kStandardVaterAttribut` int(11) unsigned DEFAULT NULL,
  `cGoogleName` varchar(255) NOT NULL,
  `cStandardGoogleName` varchar(255) DEFAULT NULL,
  `cWertName` varchar(255) DEFAULT NULL,
  `cStandardWertName` varchar(255) DEFAULT NULL,
  `eWertHerkunft` enum('ArtikelEigenschaft','FunktionsAttribut','Attribut','Merkmal','WertName','VaterAttribut') NOT NULL DEFAULT 'ArtikelEigenschaft',
  `eStandardWertHerkunft` enum('ArtikelEigenschaft','FunktionsAttribut','Attribut','Merkmal','WertName','VaterAttribut') DEFAULT NULL,
  `bStandard` tinyint(1) NOT NULL DEFAULT 0,
  `bAktiv` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`kAttribut`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_jtl_google_shopping_mapping` (
  `kMapping` int(11) NOT NULL AUTO_INCREMENT,
  `cVon` varchar(255) NOT NULL,
  `cZu` varchar(255) NOT NULL,
  `cType` varchar(255) NOT NULL,
  PRIMARY KEY (`kMapping`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_jtlgpsr_setting` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_key_uq` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_ws5_googletracking_offline_conversions` (
  `kBestellung` int(10) NOT NULL,
  `gclid` varchar(255) NOT NULL,
  `cValue` double DEFAULT NULL,
  `cCurrency` varchar(32) DEFAULT NULL,
  `dDatum` datetime DEFAULT NULL,
  PRIMARY KEY (`kBestellung`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_ws5_googletracking_plugin_settings` (
  `id` varchar(50) NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `settingType` varchar(50) DEFAULT NULL,
  `defaultValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `childOf` varchar(50) DEFAULT NULL,
  `isHidden` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_ws5_mollie_kunde` (
  `kKunde` int(11) NOT NULL,
  `customerId` varchar(32) NOT NULL,
  PRIMARY KEY (`kKunde`),
  UNIQUE KEY `customerId` (`customerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_ws5_mollie_orders` (
  `kId` int(11) NOT NULL AUTO_INCREMENT,
  `kBestellung` int(11) DEFAULT NULL,
  `cOrderId` varchar(32) NOT NULL,
  `cTransactionId` varchar(32) NOT NULL,
  `cThirdId` varchar(255) NOT NULL,
  `cStatus` varchar(32) NOT NULL,
  `cHash` varchar(40) NOT NULL,
  `fAmount` float DEFAULT NULL,
  `cMethod` varchar(32) DEFAULT NULL,
  `bTest` tinyint(1) NOT NULL,
  `bSynced` tinyint(1) NOT NULL DEFAULT 0,
  `dModified` datetime NOT NULL,
  `dCreated` datetime NOT NULL,
  `fAmountRefunded` float DEFAULT NULL,
  `cCurrency` varchar(3) DEFAULT NULL,
  `cLocale` varchar(5) DEFAULT NULL,
  `cBestellNr` varchar(128) DEFAULT NULL,
  `dReminder` datetime DEFAULT NULL,
  PRIMARY KEY (`kId`),
  UNIQUE KEY `kBestellung` (`kBestellung`,`cOrderId`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_ws5_mollie_plugin_settings` (
  `id` varchar(50) NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  `settingType` varchar(50) DEFAULT NULL,
  `defaultValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `childOf` varchar(50) DEFAULT NULL,
  `isHidden` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_ws5_mollie_queue` (
  `kId` int(11) NOT NULL AUTO_INCREMENT,
  `cType` varchar(32) NOT NULL,
  `cData` text DEFAULT '',
  `cResult` text DEFAULT NULL,
  `cError` text DEFAULT NULL,
  `dDone` datetime DEFAULT NULL,
  `dCreated` datetime NOT NULL,
  `dModified` datetime DEFAULT NULL,
  `bLock` datetime DEFAULT NULL,
  PRIMARY KEY (`kId`),
  KEY `idx_composite_with_order` (`dDone`,`bLock`,`cType`,`dCreated` DESC)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `xplugin_ws5_mollie_shipments` (
  `kLieferschein` int(11) NOT NULL,
  `kBestellung` int(11) NOT NULL,
  `cOrderId` varchar(32) NOT NULL,
  `cShipmentId` varchar(32) NOT NULL,
  `cCarrier` varchar(255) DEFAULT '',
  `cCode` varchar(255) DEFAULT '',
  `cUrl` varchar(512) DEFAULT '',
  `dCreated` datetime NOT NULL,
  `dModified` datetime DEFAULT NULL,
  PRIMARY KEY (`kLieferschein`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
