-- MySQL dump 10.13  Distrib 5.7.42, for Linux (x86_64)
--
-- Host: localhost    Database: jtl_jtladmin
-- ------------------------------------------------------
-- Server version	5.7.42-0ubuntu0.18.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `admin_session`
--

DROP TABLE IF EXISTS `admin_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_session` (
  `sessionid` varchar(33) DEFAULT NULL,
  `user` varchar(30) DEFAULT NULL,
  `zeit` datetime DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_session`
--

LOCK TABLES `admin_session` WRITE;
/*!40000 ALTER TABLE `admin_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `critical_info_list`
--

DROP TABLE IF EXISTS `critical_info_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `critical_info_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email_count` int(11) DEFAULT NULL,
  `with_contacts` tinyint(4) DEFAULT '0',
  `file_name` varchar(255) DEFAULT NULL,
  `kAdminlogin` int(11) DEFAULT NULL,
  `created` datetime DEFAULT CURRENT_TIMESTAMP,
  `deleted` datetime DEFAULT NULL,
  `deleted_from` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `critical_info_mailing`
--

DROP TABLE IF EXISTS `critical_info_mailing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `critical_info_mailing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `text_html` text NOT NULL,
  `text_plain` text NOT NULL,
  `created` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `critical_info_mailing_sent`
--

DROP TABLE IF EXISTS `critical_info_mailing_sent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `critical_info_mailing_sent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `critical_info_mailing_id` int(11) DEFAULT NULL,
  `created` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `critical_info_mailing_sent_critical_info_mailing_id_email_index` (`critical_info_mailing_id`,`email`),
  KEY `critical_info_mailing_sent_email_index` (`email`),
  CONSTRAINT `table_name_critical_info_mailing_id_fk` FOREIGN KEY (`critical_info_mailing_id`) REFERENCES `critical_info_mailing` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45838 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tadminbereiche`
--

DROP TABLE IF EXISTS `tadminbereiche`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminbereiche` (
  `kAdminLoginGruppe` int(11) NOT NULL,
  `nBenutzerVerwaltung` int(11) NOT NULL,
  `nHomepageVerwaltung` int(11) NOT NULL,
  `nServerVerwaltung` int(11) NOT NULL,
  `nHostingVerwaltung` int(11) NOT NULL,
  `nNewsletterVerwaltung` int(11) NOT NULL,
  `nAlteVerwaltung` int(11) NOT NULL,
  `nRechnungsVerwaltung` int(11) NOT NULL,
  `nCmsVerwaltung` int(11) NOT NULL,
  `nTestshopVerwaltung` int(11) NOT NULL,
  `nVorlagenVerwaltung` int(11) NOT NULL,
  `nDownloadVerwaltung` int(11) NOT NULL,
  `nTesting` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tadminbereiche`
--

LOCK TABLES `tadminbereiche` WRITE;
/*!40000 ALTER TABLE `tadminbereiche` DISABLE KEYS */;
INSERT INTO `tadminbereiche` VALUES (1,1,1,1,1,1,1,1,1,1,1,1,0),(2,0,0,1,1,0,0,0,0,1,0,0,0),(3,1,1,1,1,1,1,1,1,1,1,1,1);
/*!40000 ALTER TABLE `tadminbereiche` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tadminlogin`
--

DROP TABLE IF EXISTS `tadminlogin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminlogin` (
  `kAdminlogin` int(11) NOT NULL AUTO_INCREMENT,
  `kAdminLoginGruppe` int(11) NOT NULL,
  `cName` varchar(75) DEFAULT NULL,
  `cPass` varchar(50) DEFAULT NULL,
  `cRealname` varchar(250) NOT NULL,
  `nCertNumber` varchar(10) NOT NULL,
  `cPhoneIP` varchar(255) DEFAULT ' ',
  `cIdentifier` varchar(255) DEFAULT NULL,
  `cSecurityToken` varchar(255) DEFAULT NULL,
  `nAktiv` tinyint(4) NOT NULL DEFAULT '1',
  `cMail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kAdminlogin`)
) ENGINE=MyISAM AUTO_INCREMENT=10198 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tadminlogingruppe`
--

DROP TABLE IF EXISTS `tadminlogingruppe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminlogingruppe` (
  `kAdminLoginGruppe` int(11) NOT NULL AUTO_INCREMENT,
  `cGruppenName` varchar(250) NOT NULL,
  PRIMARY KEY (`kAdminLoginGruppe`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tadminlogingruppe`
--

LOCK TABLES `tadminlogingruppe` WRITE;
/*!40000 ALTER TABLE `tadminlogingruppe` DISABLE KEYS */;
INSERT INTO `tadminlogingruppe` VALUES (1,'Administratoren'),(2,'Benutzer'),(3,'Entwicklung FFN'),(4,'Buchhaltung'),(5,'Sales / PM'),(6,'Hosting-Team'),(7,'QA');
/*!40000 ALTER TABLE `tadminlogingruppe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tadminmenu`
--

DROP TABLE IF EXISTS `tadminmenu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminmenu` (
  `kAdminmenu` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kAdminmenueGruppe` int(10) unsigned DEFAULT NULL,
  `cModulId` varchar(255) DEFAULT NULL,
  `cLinkname` varchar(255) DEFAULT NULL,
  `cURL` varchar(255) DEFAULT NULL,
  `cRecht` varchar(255) NOT NULL,
  `bMenuepunkt` enum('1','0') NOT NULL DEFAULT '1',
  `nSort` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`kAdminmenu`),
  KEY `cRecht` (`cRecht`)
) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tadminmenu`
--

LOCK TABLES `tadminmenu` WRITE;
/*!40000 ALTER TABLE `tadminmenu` DISABLE KEYS */;
INSERT INTO `tadminmenu` VALUES (1,1000000,NULL,'Startseite','index.php','STARTPAGE_VIEW','1',103),(2,2,NULL,'Serverliste','server.php','SERVER_ADD','1',102),(3,2,NULL,'FTP-Backupstatus','ftpstatus.php','HOSTING_BACKUP_STATUS','0',200),(4,1,NULL,'Kunden','kundenverwaltung.php','KUNDEN_VIEW','1',102),(5,11,NULL,'JTL-Shop/MS','lizenzen.php','LIZENZEN_VIEW','1',1190),(6,9,NULL,'ToDo-Liste','premiumservices.php','LIZENZEN_JOBS','1',11600),(7,2,NULL,'Hostings','hostings.php','HOSTINGS_VIEW','0',201),(8,2,NULL,'Hosting-Updates','hostingupdate.php','HOSTING_UPDATE','1',202),(9,5,NULL,'Debug Reports','debugreport.php','DEBUG_VIEW','1',1070),(10,6,NULL,'Upload Wawi & Shop','download.php','DOWNLOADS_VIEW','1',1080),(11,1,NULL,'Repricer Logs','repricer.php','REPRICER_VIEW','1',110),(12,11,NULL,'Testshops','testshop.php','TESTSHOP_VIEW','1',1120),(13,6,NULL,'Systemmails','vorlage.php','VORLAGEN_VIEW','1',620),(14,7,NULL,'Rechnungen','rechnungen.php','RECHNUNGEN_VIEW','1',700),(15,6,NULL,'Newsletter (alt)','newsletter.php','NEWSLETTER_VIEW','1',640),(16,2,NULL,'ToDo','todo.php','HOSTING_TODO','0',203),(18,13,NULL,'Servicepartner (SP)','sp_overview.php','SERVICEPARTNER_VIEW','1',601),(90,11,NULL,'JTL-Support','stats_support.php','SUPPORT_TARIFF_VIEW','1',1130),(22,7,NULL,'Rechnung VW','rechnungvw.php','RECHNUNGEN_MANAGE','1',795),(23,5,NULL,'Benutzer','benutzer.php','BENUTZER_VIEW','1',501),(24,5,NULL,'Gruppen','gruppen.php','GROUPS_VIEW','1',502),(94,6,NULL,'Empfehlungen','empf_listenpos.php','EMPFEHLUNGSLISTEN_STATISTIK_VIEW','1',600),(93,14,NULL,'Seller (SEL)','exs_seller.php','EXS_SELLER_VIEW','1',103),(28,1,NULL,'Shoplizenz-Umzug','licence_helper.php','LICENSE_OWNER_UPDATE','1',104),(29,6,NULL,'Blacklist (alt)','blacklist.php','NEWSLETTER_BLACKLIST','1',645),(30,5,NULL,'Rechte','manage_rights.php','MANAGE_RIGHTS','1',503),(31,8,NULL,'eazyAuction-Details','eadetails.php','EADETAILS','0',801),(32,1,'','Search Server','jtlsearch.php','JTLSEARCH_VIEW','1',107),(33,1,NULL,'Repricer Server','jtlrepricer.php','JTLREPRICER_VIEW','1',108),(34,11,NULL,'Follow Up','customercare.php','CUSTOMERCARE_VIEW','1',11500),(35,14,NULL,'Fremdlizenzen (alt)','manage_fremdlizenz.php','MANAGE_FREMDLIZENZ','1',50400),(36,14,NULL,'Pluginzertifizierung (alt)','cert.php','CERT_VIEW','1',6999),(37,7,NULL,'Mahnungen','mahnungsliste.php','MAHNUNGSLISTE_VIEW','1',710),(38,13,NULL,'SP-Zertifizierungen','zertifizierungen.php','ZERTIFIZIERUNGEN_VIEW','1',604),(39,13,'','SP-Referenz History','sprefhistory.php','SPREFHISTORY_VIEW','0',606),(91,6,NULL,'Upload Hilfsmittel','hilfsmittelverwaltung.php','HILFSMITTELVERWALTUNG','1',650),(41,11,NULL,'JTL-WMS','wmslizenzen.php','WMS_LIZENZEN_VIEW','1',1180),(42,1,NULL,'Bankprüfung','bankpruefung.php','BANKPRUEFUNG_VIEW','0',1060),(89,13,NULL,'SP-Standorte','sp_locations.php','SPLOCATIONS_VIEW','1',609),(44,1,'Dubletten','Dubletten','dubletten.php','DUBLETTEN_VIEW','1',103),(45,2,NULL,'Kündigungsgrund','hostkuendgrund.php','HOSTING_KUENDGRUND','1',207),(98,14,NULL,'Lizenzmigration','exs_licencemigration.php','EXS_LICENCEMIGRATION','1',109),(47,1,NULL,'eBay-Benutzer','eauserdelete.php','EBAY_USER_DELETE','1',106),(49,9,NULL,'Neuer Supportcase','supportcase.php?step=new','SUPPORTCASE_NEW','1',4),(50,9,NULL,'Alle','supportcase.php?list=all','SUPPORTCASE_VIEW_ADMIN','0',3),(51,9,NULL,'erledigt','supportcase.php?list=closed','SUPPORTCASE_VIEW_CLOSED','0',2),(52,9,NULL,'Supportcases <span id=\"sc_open\"></span>','supportcase.php?list=all','SUPPORTCASE_VIEW_OPEN','1',1),(53,7,NULL,'Provisionsmeldungen','spprovision.php','SPPROVISION_VIEW','0',703),(65,6,NULL,'Upload POS & Connector','applicationversion.php','DOWNLOADS_VIEW','1',1080),(55,9,NULL,'Feedback <span id=\"sc_feedback\"></span>','supportcase.php?list=feedback','SUPPORTCASE_VIEW_OPEN','1',2),(56,2,NULL,'Inaktive Domains','inaktive_domains.php','INAKTIVE_DOMAINS','1',110),(57,2,NULL,'Hosting-Liste','jtlhosting.php','HOSTINGS_VIEW','1',200),(59,1,NULL,'Amazon-Testzeitraum','amazonResetTestzeit.php','AMAZON_RESET_TESTZEIT','1',105),(60,9,NULL,'Vertriebcases','vertriebcase.php','VERTRIEBCASE_LISTE','1',1001),(61,9,NULL,'Neuer Vertriebscase','vertriebcase_neu.php','VERTRIEBCASE_NEW','1',1003),(62,9,NULL,'Offene Vertriebcases <span id=\"vc_open\"></span>','vertriebcase.php?filter_status=offen','VERTRIEBCASE_LISTE','1',1002),(92,11,NULL,'JTL-POS','poslizenzen.php','POS_LIZENZEN_VIEW','1',1170),(64,7,NULL,'Provisionsgutschriften','gutschriften.php','GUTSCHRIFTEN_VIEW','1',715),(66,13,NULL,'SP-Zertifikate','zertifikate.php','ZERTIFIZIERUNGEN_VIEW','1',603),(67,13,NULL,'Projektbörse','projektboerse.php','AUFTRAGSBOERSE_VIEW','1',630),(88,13,NULL,'SP-Referenzen','sp_references.php','SPREFHISTORY_VIEW','1',607),(69,7,NULL,'Freischaltcodes','codes.php','FREISCHALTCODES_VIEW','1',750),(70,11,NULL,'JTL-Wawi','wawilizenzen.php','LIZENZEN_VIEW','1',1195),(71,11,NULL,'JTL-Connector','connectorlizenzen.php','LIZENZEN_VIEW','1',1185),(72,13,NULL,'Lösungsanbieter (TP | HOS)','technologiepartner.php','TECHNOLOGIEPARTNER_VIEW','1',640),(87,13,NULL,'SP-Bewertungen','sp_ratings.php','SPBEWERTUNG_VIEW','1',608),(86,13,NULL,'SP-Statistiken','sp_stats.php','SPSTATISTIK_VIEW','1',602),(75,13,NULL,'Pilotkunden (PLT)','pilot.php','PILOTVERWALTUNG','1',1500),(76,2,NULL,'Inh. Wechsel','hostingownerch.php','HOSTINGS_VIEW','1',201),(77,2,NULL,'Daily ToDos','todosoverview.php','HOSTINGS_VIEW','1',101),(78,2,NULL,'Wawi Cloud Server','wawicloud_server.php','HOSTINGS_VIEW','1',102),(79,9,NULL,'Ticketbewertung','ticketrating.php','TICKETRATING_VIEW','1',1400),(80,14,NULL,'Erweiterungen (alt)','extension.php','EXTENSION_VIEW','1',6040),(81,2,NULL,'Test SQL-Hosting','testsql.php','TESTSHOP_VIEW','1',111),(130,7,NULL,'Rechnungsdokumentfreigabe','rechnungsdokumentfreigabe.php','RECHNUNGSDOKUMENTFREIGABE_VIEW','1',851),(85,1,NULL,'Repricer/Search','repricer_search_ea_chowner.php','HOSTINGS_VIEW','1',109),(95,14,NULL,'Lizenzen','exs_licenses.php','EXS_LICENSES_VIEW','1',108),(96,14,NULL,'Produkte','exs_products.php','EXS_PRODUCTS_VIEW','1',105),(97,14,NULL,'Verkäufe','exs_sales.php','EXS_SALES_VIEW','1',107),(99,6,NULL,'Platzierungen','bundles.php','BUNDLES_VIEW','1',610),(100,1,NULL,'Programme','programme_stats.php','PROGRAMME_STATS_VIEW','1',101),(101,14,NULL,'Erstattungen','exs_refunds.php','EXS_REFUNDS_VIEW','1',120),(102,11,NULL,'Monatliche Buchungen','monatliche_buchungen.php','MONATLICHE_BUCHUNGEN','1',1102),(103,11,NULL,'Direktleistungen','direktleistungen.php','Direktleistungen','1',110),(104,7,NULL,'PayPal Report','exs_paypal_report.php','EXS_PAYPAL_REPORT','1',790),(105,6,NULL,'Textbausteine','texteuebersicht.php','TEXTEUEBERSICHT','1',630),(106,13,NULL,'Partnereinladungen','sp_invites.php','PARTNER_EINLADUNG','1',610),(107,11,NULL,'JTL-Track & Trace','trackandtracestats.php','LIZENZEN_VIEW','1',1196),(108,14,NULL,'Seller-Profile (PIM)','https://pim.jtl-software.com/de/sellers','EXS_PRODUCTS_VIEW','1',104),(109,14,NULL,'Produktkatalog (PIM)','https://pim.jtl-software.com/de/products','EXS_PRODUCTS_VIEW','1',106),(110,6,NULL,'Produkttyp (ExS)','https://pim.jtl-software.com/de/product-families','EXS_PRODUCTS_VIEW','1',631),(111,6,NULL,'Produktkategorie (ExS)','https://pim.jtl-software.com/de/categories','EXS_PRODUCTS_VIEW','1',632),(112,6,NULL,'Attributkatalog (ExS)','https://pim.jtl-software.com/de/attributes','EXS_PRODUCTS_VIEW','1',633),(113,14,NULL,'WH Eventtypes','wh_events.php','EXS_WEBHOOK_EVENTTYPE_MANAGEMENT','1',125),(114,14,NULL,'WH Listeners','wh_listeners.php','EXS_WEBHOOK_LISTENER_MANAGEMENT','1',126),(115,6,NULL,'Mailings/Verteiler','critical_info_list.php','CRITICAL_INFO_LIST','1',639),(116,7,NULL,'Rechnungskorrekturen','rechnungskorrekturen.php','RECHNUNGSKORREKTUREN','1',705),(117,13,NULL,'Drittanbieter Calls','3rdparty_buchungen.php','3RD_PARTY_CALLS','1',2000),(118,6,NULL,'Portfolio','portfolio_angebot_uebersicht.php','PORTFOLIOVERWALTUNG','1',3000),(119,1,NULL,'Rollen & Rechte (KC)','acl.php','ACL_VIEW','1',111),(120,1,NULL,'OAuth-Clients','oauth.php','OAUTH_VIEW','1',112),(121,14,NULL,'ExS Transactions (Live)','exs_transactions.php','EXS_TRANSACTIONS_VIEW','1',128),(122,14,NULL,'ExS Bestellungen (Live)','exs_orders.php','EXS_ORDERS_VIEW','1',129),(123,14,NULL,'WH Listener-Events','wh_listener_events.php','WEBHOOK_LISTENER_EVENTS_VIEW','1',127),(124,5,NULL,'Rechte > Benutzer','rechte_benutzer_uebersicht.php','RECHTE_BENUTZER_UEBERSICHT_VIEW','1',1060),(125,13,NULL,'Seller Networks (FFD/MER)','sellernetworks_stats.php','SELLERNETWORKS_VIEW','1',640),(126,5,NULL,'Crons','cron_verwaltung.php','CRON_VERWALTUNG','1',1100),(127,7,NULL,'Rechnungsvergleich','rechnungsvergleich.php','RECHNUNGSVERGLEICH','1',850),(129,11,NULL,'SCX-License Importer','scx_license_importer.php','SCX_LICENSES_IMPORT','1',1197),(128,6,NULL,'Rechtsgrundlagen','rgl_rechtsgrundlagen.php','RECHTSGRUNDLAGEN_VIEW','1',115),(131,11,NULL,'JTL-eazyAuction','stats_eazyauction.php','EAZYAUCTION_STATS_VIEW','1',1181);
/*!40000 ALTER TABLE `tadminmenu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tadminmenugruppe`
--

DROP TABLE IF EXISTS `tadminmenugruppe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminmenugruppe` (
  `kAdminmenueGruppe` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kAdminmenueOberGruppe` int(10) unsigned DEFAULT '0',
  `cName` varchar(255) DEFAULT NULL,
  `nSort` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kAdminmenueGruppe`),
  KEY `kAdminmenueOberGruppe` (`kAdminmenueOberGruppe`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tadminmenugruppe`
--

LOCK TABLES `tadminmenugruppe` WRITE;
/*!40000 ALTER TABLE `tadminmenugruppe` DISABLE KEYS */;
INSERT INTO `tadminmenugruppe` VALUES (1,0,'Kontoverwaltung',0),(2,0,'Hosting',28),(3,0,'Benutzer',1000),(13,0,'Partnerprogramme',20),(5,0,'Systemverwaltung',150),(6,0,'Vermarktung & Distribution',15),(7,0,'Buchhaltung',70),(8,0,'Detailansichten',1100),(9,0,'Kundenbetreuung',90),(10,0,'Vertriebcase',100),(11,0,'Verkäufe & Testphasen',10),(14,0,'ExS & Seller',25);
/*!40000 ALTER TABLE `tadminmenugruppe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tadminrecht`
--

DROP TABLE IF EXISTS `tadminrecht`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminrecht` (
  `cRecht` varchar(255) NOT NULL,
  `cBeschreibung` varchar(255) NOT NULL,
  `kAdminrechtemodul` int(10) unsigned NOT NULL DEFAULT '0',
  `nSort` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cRecht`),
  UNIQUE KEY `cRecht` (`cRecht`),
  KEY `kAdminrechtemodul` (`kAdminrechtemodul`,`cRecht`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tadminrecht`
--

LOCK TABLES `tadminrecht` WRITE;
/*!40000 ALTER TABLE `tadminrecht` DISABLE KEYS */;
INSERT INTO `tadminrecht` VALUES ('STARTPAGE_VIEW','Startseite - Wiedervorlagen ansehen (r) ?',13,0),('SERVER_ADD','Serverliste verwalten (r/w!) ?',6,16),('HOSTING_BACKUP_STATUS','FTP-Backupstatus setzen (w)',6,18),('KUNDEN_VIEW','Kunden verwalten (r/w)',1,20),('LIZENZEN_VIEW','Statistiken JTL-Shop ansehen (r)',2,40),('LIZENZEN_JOBS','Follow Up verwalten [deprecated]',2,81),('HOSTINGS_VIEW','Hostingaufträge verwalten (r/w)',6,11),('HOSTING_UPDATE','Hostingupdates verwalten (w!)',6,11),('DEBUG_VIEW','Debug Reports ansehen (r)',9,50),('DOWNLOADS_VIEW','Wawi-/Shop-Versionen verwalten (r/w!)',3,0),('REPRICER_VIEW','Logs Repricer einsehen (r) [deprecated]',12,0),('TESTSHOP_VIEW','Testshops verwalten (r/w)',2,30),('VORLAGEN_VIEW','Systemmails verwalten (r/w!)',3,0),('RECHNUNGEN_VIEW','Rechnungen ansehen (r)',7,10),('NEWSLETTER_VIEW','Newsletter versenden (r/w) [deprecated]',12,0),('HOSTING_TODO','Hostingpositionen hinzufügen (w)',6,11),('JTLPOS_PAYMENT_PROVIDER_MANAGEMENT','JTL-POS Zahlungsanbieter freischalten (w) ?',11,80),('SERVICEPARTNER_VIEW','SP - Servicepartner verwalten (r/w)',4,0),('NEWS_VIEW','News [deprecated]',12,0),('DUK_VIEW','Wussten Sie schon [deprecated]',12,0),('RECHNUNGEN_MANAGE','Rechnungen verwalten (r/w)',7,11),('BENUTZER_VIEW','Admin-Benutzer ansehen (r)',9,10),('GROUPS_VIEW','Admin-Gruppen verwalten (r/w)',9,21),('EXS_WEBHOOK_EVENTTYPE_MANAGEMENT','Webhooks - Event Types verwalten (r/w)',5,60),('SUPPORT_TARIFF_ACTIVATION','Support Tarife verwalten (r/w) ?',11,30),('LICENSE_OWNER_UPDATE','Shoplizenzen umziehen (r/w)',1,30),('BENUTZER_RECHTE','Admin-Benutzerrechte vergeben (w!)',9,11),('NEWSLETTER_BLACKLIST','Mailing-Blacklist verwalten (r/w) [deprecated]',12,0),('MANAGE_RIGHTS','Admin-Rechte definieren (r/w)',9,30),('EADETAILS','EA Tarife ansehen (r) ?',11,20),('SQLDETAILS','SQL-Hostings administrieren (r/w!)',6,30),('SHOPHOSTINGDETAILS','Shophostings verwalten (r/w!) ?',6,20),('JTLSEARCH_VIEW','Dienste - Server JTL-Search verwalten (r/w)',1,43),('HOSTINGFTPINFO','FTP-Zugangsdaten ansehen (r)',6,17),('SEARCHDETAILS','Search-Details nachladen (r)',11,31),('SQLDATAVIEW','SQL-Hostings ansehen (r)',6,30),('SETCUSTOMERVORLAGE','Startseite - Wiedervorlagen verwalten (r/w)',13,0),('JTLREPRICER_VIEW','Server Repricer verwalten (r/w) [deprecated]',12,0),('CUSTOMERCARE_VIEW','Follow Up Mailings verwalten (r/w)',2,80),('MANAGE_FREMDLIZENZ','Fremdlizenzen [deprecated]',12,0),('CERT_VIEW','Plugins zertifizieren (r/w) [deprecated]',12,0),('MAHNUNGSLISTE_VIEW','Mahnungen ansehen (r)',7,30),('ZERTIFIZIERUNGEN_VIEW','SP - Zertifizierungen ansehen (r)',4,0),('ZERTIFIZIERUNGEN_NEW','SP - Zertifizierungen anlegen (w)',4,0),('ZERTIFIZIERUNGEN_EDIT','SP - Zertifizierungen bearbeiten (w)',4,0),('ZERTIFIZIERUNGEN_DELETE','SP - Zertifizierungen löschen (w)',4,0),('SPREFHISTORY_VIEW','SP - Referenzen ansehen (r)',4,0),('SPSTATISTIK_VIEW','SP - Statistiken ansehen (r)',4,0),('WMS_LIZENZEN_VIEW','Statistiken JTL-WMS ansehen (r)',2,40),('BANKPRUEFUNG_VIEW','Bankkonten/SEPA ansehen (r)',11,20),('SPBEWERTUNG_VIEW','SP - Bewertungen verwalten (r/w)',4,0),('DUBLETTEN_VIEW','Dubletten verwalten (r/w)',1,21),('HOSTING_KUENDGRUND','Kündigungsgründe verwalten (r/w)',6,60),('SUPPORT_TARIFF_VIEW','Statistiken JTL-Support ansehen (r)',2,40),('EBAY_USER_DELETE','Dienste - Benutzer eBay löschen (w!)',1,41),('SUPPORTCASE_NEW','Supportcase anlegen (w) [deprecated]',8,21),('SUPPORTCASE_VIEW_ADMIN','Supportcases ansehen (r) [deprecated]',8,20),('SUPPORTCASE_VIEW_CLOSED','Supportcases geschlossen (r) [deprecated]',8,20),('SUPPORTCASE_VIEW_OPEN','Supportcases offen (r) [deprecated]',8,20),('SPPROVISION_VIEW','Provisionsmeldungen ansehen (r) ?',7,40),('GEK_DOMAINS','Domainkündigungen abwicklen (w)',6,22),('INAKTIVE_DOMAINS','Inaktive Domains verwalten (r/w)',6,21),('STAMMTISCH','Stammtisch [deprecated] ?',12,0),('HOSTING_SPERRUNG','Hostings sperren (w!)',6,14),('HOSTING_ADMIN','Hostings administrieren (r/w!)',6,10),('AMAZON_RESET_TESTZEIT','Dienste - Testphasen Amazon verwalten (w) ?',1,40),('VERTRIEBCASE_NEW','Vertriebcases anlegen (w) [deprecated]',8,12),('VERTRIEBCASE_LISTE','Vertriebscases ansehen (r) [deprecated]',8,11),('GUTSCHRIFTEN_VIEW','Gutschriften ansehen (r) ?',7,31),('HOSTING_PLESK','Auf Plesk-Daten zugreifen (r)',6,13),('KUNDENCENTER_LOGIN','JTL-Kundencenter einloggen (r/w!)',14,30),('HOSTING_KUENDIGUNG','Hostingkündigungen abwickeln (w!)',6,15),('AUFTRAGSBOERSE_VIEW','SP - Projektbörse verwalten (r/w)',4,0),('SPBESCHWERDE_VIEW','SP - Beschwerden ansehen (r)',4,0),('FREISCHALTCODES_VIEW','Freischaltcodes ansehen (r) [deprecated]',12,0),('TECHNOLOGIEPARTNER_VIEW','TP/HOS - Lösungsanbieter verwalten (r/w)',4,20),('EVENT_VIEW','Veranstaltungen [deprecated]',12,0),('SPSCHULUNG_VIEW','SP - Schulungen ansehen (r) [deprecated] ?',4,0),('PILOTVERWALTUNG','PLT - Pilotkunden verwalten (r/w)',4,50),('TICKETRATING_VIEW','Ticketbewertungen ansehen (r)',8,10),('EXTENSION_VIEW','Erweiterungen freischalten (r/w) [deprecated]',12,0),('LICENCE_CHANGE','Lizenztyp V2 anpassen (w)',14,50),('EA_EDIT_SELLER_ID','EA SellerId bearbeiten (w!)',11,20),('DELETE_CUSTOMER','JTL-Kundenkonto löschen (w!)',14,32),('HILFSMITTELVERWALTUNG','Hilfsmittel verwalten (r/w)',3,0),('POS_LIZENZEN_VIEW','Statistiken JTL-POS ansehen (r)',2,40),('EXS_SELLER_VIEW','Seller (SEL) verwalten (r/w)',5,10),('EXS_LICENSES_VIEW','Lizenzen verwalten (r/w)',5,40),('EMPFEHLUNGSLISTEN_STATISTIK_VIEW','Empfehlungslisten ansehen (r)',3,20),('EXS_LICENCEMIGRATION','Lizenzen von SEL migrieren (r/w)',5,41),('EXS_PRODUCTS_VIEW','Erweiterungen/Produkte ansehen (r)',5,20),('EXS_SALES_VIEW','Verkäufe in Typo3 ansehen (r)',5,30),('EXS_SELLERREQUEST_VIEW','ExS Seller-Anträge [deprecated]',12,0),('BUNDLES_VIEW','Platzierungen/Bundles verwalten (r/w)',3,10),('PROGRAMME_STATS_VIEW','Programme ansehen (r)',1,10),('EXS_REFUNDS_VIEW','Erstattungen ansehen (r)',5,41),('PARTNER_EINLADUNG','SP/SB - Partnereinladungen verwalten (r/w)',4,10),('MONATLICHE_BUCHUNGEN','Monatliche Buchungen verwalten (r/w)',2,20),('DIREKTLEISTUNGEN','Direktleistungen verwalten (r/w)',2,10),('EXS_PAYPAL_REPORT','PayPal Reports ansehen (r)',7,40),('TEXTEUEBERSICHT','Textbausteine ansehen (r)',3,0),('EXS_LICENSES_CREATE','Lizenzen anlegen (w)',5,40),('EXS_WEBHOOK_LISTENER_MANAGEMENT','Webhooks - Event Listener verwalten (r/w) ?',5,60),('CRITICAL_INFO_LIST','Mailings/Verteiler verwalten (r/w)',3,0),('RECHNUNGSKORREKTUREN','Rechnungskorrekturen durchführen (w)',7,13),('3RD_PARTY_CALLS','3P - Drittanbieter Calls ansehen (r)',4,50),('EXS_LICENSES_DEACTIVATE','Lizenzen deaktivieren (w!)',5,40),('EXS_LICENSES_EXTEND','Lizenzen verlängern (w)',5,40),('EXS_LICENSES_CONVERT','Lizenzen umwandeln (w)',5,40),('ACL_VIEW','Dienste - Webportal-Rechte verwalten (r/w)',1,50),('DELETE_MAILTEMPLATES','Mailvorlagen löschen (w) ?',1,90),('DELETE_SYSCRITICAL_ACCOUNTS','Systemkritische Konten löschen (w!)',14,40),('LOGIN_SYSCRITICAL_ACCOUNTS','Systemkritische Konten einloggen (w)',14,40),('PROGRAMMS_SYSCRITICAL_ACCOUNTS','Systemkritische Konten setzen (w)',14,40),('CAN_MERGE_ACCOUNTS','JTL-Kundenkonten mergen (w!)',14,31),('PORTFOLIOVERWALTUNG','Portfolio/Übersetzungen verwalten (r/w!)',3,0),('CAN_EDIT_COMPANYDATA','Firmenprofil ändern (w)',11,10),('CAN_EDIT_FINANCIALDATA','Finanzen verwalten (r/w)',11,10),('CAN_EDIT_SUPPORTSERVICES','Support verwalten (r/w)',11,30),('OAUTH_VIEW','Dienste - OAuth Clients verwalten (r/w)',1,60),('CAN_EDIT_TAXDATA','Steuerdaten verwalten (r/w)',11,10),('CAN_EDIT_BITRIXSETTINGS','Bitrix-Abgleich deaktivieren (w)',14,20),('CAN_EDIT_SUPERVISEDBY','Betreuer/Auffälligkeiten verwalten (w)',11,70),('CAN_EDIT_PARTNERRELATIONS','Partnerschaft setzen (w)',11,40),('CAN_EDIT_EAZYAUCTIONDATA','EA-Tarife verwalten (w!)',11,20),('DELETEUSERTICKETRATING','Ticketbewertungen verwalten (w)',8,11),('EXS_TRANSACTIONS_VIEW','Transactions ansehen (r)',5,70),('EXS_ORDERS_VIEW','Bestellungen Orders API ansehen (r)',5,31),('WEBHOOK_LISTENER_EVENTS_VIEW','Webhooks - Event Listener ansehen (r)',5,60),('CAN_EDIT_LEGALINFORMATION','Kundenindividuellen Rechtsgrundlage erstellen (w!)',11,40),('RECHTE_BENUTZER_UEBERSICHT_VIEW','Rechte-Benutzer-Verteilung ansehen (r)',9,40),('PILOT_WRITE','PLT - Pilotprogramme verwalten (w)',4,50),('KUNDENVW_GENUTZTE_PRODUKTE_UPDATE_BUTTON','Kundensuche - Stats-Tabellen aktualisieren (w!)',13,20),('SELLERNETWORKS_VIEW','FFN - Seller Network ansehen (r)',4,20),('BELEG_SCHNELLSUCHE','Beleg-Schnellsuche anzeigen (r)',13,40),('CRON_VERWALTUNG','Cronverwaltung ansehen (r)',9,60),('RECHNUNGSVERGLEICH','Rechnungen vergleichen (r)',7,12),('RECHTSGRUNDLAGEN','Rechtsgrundlagen verwalten (w)',3,0),('SCX_LICENSES_DELETE','EA Lizenzen löschen (w!)',11,20),('SCX_LICENSES_IMPORT','EA-Lizenzen importieren (w)',2,60),('LICENSE_V2_LOCK','Lizenzen V2 sperren (w!)',14,50),('RECHTSGRUNDLAGEN_VIEW','Rechtsgrundlagen ansehen (r)',3,0),('RECHNUNGSDOKUMENTFREIGABE_VIEW','Rechnungsdokumentfreigabe ansehen (r)',7,20),('RECHNUNGSDOKUMENTFREIGABE_WRITE','Rechnungsdokumente freigeben (w)',7,21),('EAZYAUCTION_STATS_VIEW','Statistiken JTL-eazyAuction ansehen (r)',2,40),('ACCOUNT_STAGING_SHOW','Staging-Verwaltung ansehen (r)',14,10),('ACCOUNT_STAGING_EDIT','Staging-Inhalte ändern (w)',14,12),('ACCOUNT_STAGING_CREATE','Staging-Inhalte erstellen (w)',14,11);
/*!40000 ALTER TABLE `tadminrecht` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tadminrecht_funktionen`
--

DROP TABLE IF EXISTS `tadminrecht_funktionen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminrecht_funktionen` (
  `cRecht` varchar(255) NOT NULL,
  `cFunktionsrecht` varchar(255) NOT NULL,
  `cFunktionsBeschreibung` varchar(255) NOT NULL,
  UNIQUE KEY `cFunktionsrecht` (`cFunktionsrecht`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tadminrecht_funktionen`
--

LOCK TABLES `tadminrecht_funktionen` WRITE;
/*!40000 ALTER TABLE `tadminrecht_funktionen` DISABLE KEYS */;
INSERT INTO `tadminrecht_funktionen` VALUES ('HOSTINGS_VIEW','FUNC_HOSTING_ADD','Hosting hinzufügen'),('HOSTINGS_VIEW','FUNC_HOSTING_QUIT','Hosting kündigen'),('HOSTINGS_VIEW','FUNC_HOSTING_UPDATE','Hosting aktualisieren'),('HOSTINGS_VIEW','FUNC_HOSTING_VIEWDETAILS','Erweiterte Ansicht');
/*!40000 ALTER TABLE `tadminrecht_funktionen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tadminrechtemodul`
--

DROP TABLE IF EXISTS `tadminrechtemodul`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminrechtemodul` (
  `kAdminrechtemodul` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) NOT NULL,
  `nSort` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kAdminrechtemodul`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tadminrechtemodul`
--

LOCK TABLES `tadminrechtemodul` WRITE;
/*!40000 ALTER TABLE `tadminrechtemodul` DISABLE KEYS */;
INSERT INTO `tadminrechtemodul` VALUES (1,'Kontoverwaltung',1),(2,'Verkäufe & Testphasen',10),(3,'Vermarktung & Distribution',20),(4,'Partnerprogramme',30),(5,'ExS & Seller',40),(6,'Hosting',50),(7,'Buchhaltung',70),(8,'Kundenbetreuung',80),(9,'Systemverwaltung',90),(10,'Sonderfunktionen',100),(11,'Kontoverwaltung - Kundendetails',3),(12,'Archiv',120),(13,'Suchen & Finden',0),(14,'Kontoverwaltung - Sonderfunktionen',2);
/*!40000 ALTER TABLE `tadminrechtemodul` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tadminuserrecht`
--

DROP TABLE IF EXISTS `tadminuserrecht`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminuserrecht` (
  `kAdminuserrecht` int(11) NOT NULL AUTO_INCREMENT,
  `cRecht` varchar(255) NOT NULL,
  `kAdminlogin` int(11) NOT NULL,
  PRIMARY KEY (`kAdminuserrecht`)
) ENGINE=MyISAM AUTO_INCREMENT=69507 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tadminuserrecht_funktionen`
--

DROP TABLE IF EXISTS `tadminuserrecht_funktionen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminuserrecht_funktionen` (
  `kAdminlogin` int(11) NOT NULL,
  `cRecht` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tadminuserrecht_funktionen`
--

LOCK TABLES `tadminuserrecht_funktionen` WRITE;
/*!40000 ALTER TABLE `tadminuserrecht_funktionen` DISABLE KEYS */;
/*!40000 ALTER TABLE `tadminuserrecht_funktionen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tadminuserrecht_history`
--

DROP TABLE IF EXISTS `tadminuserrecht_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tadminuserrecht_history` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) unsigned NOT NULL COMMENT 'kAdminlogin vom Benutzer, dessen Rechte editiert werden',
  `editor_id` int(11) unsigned NOT NULL COMMENT 'kAdminlogin vom eingeloggten Benutzer',
  `old_value` text NOT NULL,
  `new_value` text NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_id_created_at` (`admin_id`,`created_at`),
  KEY `admin_id_editor_id_created_at` (`admin_id`,`editor_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tapikey`
--

DROP TABLE IF EXISTS `tapikey`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tapikey` (
  `cApiKey` varchar(255) DEFAULT NULL,
  `cDomain` varchar(255) DEFAULT NULL,
  `nZugriffe` int(10) unsigned DEFAULT NULL,
  `dLetzterZugriff` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tbackupserver`
--

DROP TABLE IF EXISTS `tbackupserver`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbackupserver` (
  `kBackupServer` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kServer` int(11) NOT NULL,
  `nAktiv` tinyint(3) unsigned NOT NULL,
  `nZeitGebraucht` int(10) unsigned NOT NULL,
  `dAktualisiert` datetime NOT NULL,
  PRIMARY KEY (`kBackupServer`),
  KEY `nServerId` (`nAktiv`)
) ENGINE=MyISAM AUTO_INCREMENT=349 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `tbackupstatus`
--

DROP TABLE IF EXISTS `tbackupstatus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbackupstatus` (
  `kBackupStatus` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kBackupServer` int(10) unsigned NOT NULL,
  `cDatei` varchar(255) NOT NULL,
  `nStatus` tinyint(3) unsigned NOT NULL,
  `nGroesse` int(10) unsigned NOT NULL,
  `nZeit` int(10) unsigned NOT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kBackupStatus`),
  KEY `kBackupServer` (`kBackupServer`)
) ENGINE=MyISAM AUTO_INCREMENT=192761 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tcalls`
--

DROP TABLE IF EXISTS `tcalls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tcalls` (
  `kCall` int(10) NOT NULL AUTO_INCREMENT,
  `cHost` varchar(255) NOT NULL,
  `nCalls` int(10) NOT NULL,
  `dLast` int(10) NOT NULL,
  PRIMARY KEY (`kCall`)
) ENGINE=MyISAM AUTO_INCREMENT=68601 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tdemoshop`
--

DROP TABLE IF EXISTS `tdemoshop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tdemoshop` (
  `kDemoshop` int(10) unsigned NOT NULL DEFAULT '0',
  `cKundenname` varchar(255) DEFAULT NULL,
  `cMainURL` varchar(255) DEFAULT NULL,
  `cDomains` varchar(255) DEFAULT NULL,
  `cB2B` char(1) DEFAULT NULL,
  `cDBName` varchar(255) DEFAULT NULL,
  `cKommentar` varchar(255) DEFAULT NULL,
  `cErstelltAm` datetime DEFAULT NULL,
  PRIMARY KEY (`kDemoshop`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tdemoshop`
--

LOCK TABLES `tdemoshop` WRITE;
/*!40000 ALTER TABLE `tdemoshop` DISABLE KEYS */;
/*!40000 ALTER TABLE `tdemoshop` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tjtl2update`
--

DROP TABLE IF EXISTS `tjtl2update`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tjtl2update` (
  `nVersion` int(10) unsigned DEFAULT NULL,
  `cReferrer` varchar(255) DEFAULT NULL,
  `nZeile` int(10) unsigned DEFAULT NULL,
  `cFehler` varchar(255) DEFAULT NULL,
  `dDatum` datetime DEFAULT NULL,
  KEY `dDatum` (`dDatum`),
  KEY `nVersion` (`nVersion`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tjtl2updatemail`
--

DROP TABLE IF EXISTS `tjtl2updatemail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tjtl2updatemail` (
  `nVersion` int(10) unsigned NOT NULL DEFAULT '0',
  `nZeile` int(10) unsigned DEFAULT NULL,
  `cFehler` varchar(255) DEFAULT NULL,
  `dDatum` datetime DEFAULT NULL,
  KEY `nVersion` (`nVersion`),
  KEY `nZeile` (`nZeile`),
  KEY `dDatum` (`dDatum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `tjtlsession`
--

DROP TABLE IF EXISTS `tjtlsession`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tjtlsession` (
  `cSessionId` varchar(255) NOT NULL DEFAULT '',
  `nSessionExpires` int(10) unsigned NOT NULL DEFAULT '0',
  `cSessionData` text,
  PRIMARY KEY (`cSessionId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tkunde`
--

DROP TABLE IF EXISTS `tkunde`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tkunde` (
  `kKunde` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cAnrede` varchar(255) NOT NULL DEFAULT '',
  `cVorname` varchar(255) DEFAULT NULL,
  `cNachname` varchar(255) DEFAULT NULL,
  `cFirma` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) NOT NULL DEFAULT '',
  `cDomain` varchar(255) DEFAULT NULL,
  `cPasswort` varchar(255) NOT NULL DEFAULT '',
  `cKundentyp` varchar(255) NOT NULL DEFAULT '',
  `cAktiv` char(1) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kKunde`)
) ENGINE=MyISAM AUTO_INCREMENT=1868 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tlizenz`
--

DROP TABLE IF EXISTS `tlizenz`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tlizenz` (
  `kLizenz` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kKunde` int(10) unsigned DEFAULT NULL,
  `kSoftware` int(10) unsigned DEFAULT NULL,
  `cAPIKey` varchar(255) DEFAULT NULL,
  `cDomain` varchar(255) NOT NULL DEFAULT '',
  `nDownloads` int(10) unsigned NOT NULL DEFAULT '0',
  `dGueltigBis` date DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kLizenz`)
) ENGINE=MyISAM AUTO_INCREMENT=2613 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tlizenzbestellung`
--

DROP TABLE IF EXISTS `tlizenzbestellung`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tlizenzbestellung` (
  `kLizenzbestellung` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cAnrede` varchar(10) DEFAULT NULL,
  `cVorname` varchar(255) DEFAULT NULL,
  `cNachname` varchar(255) DEFAULT NULL,
  `cFirma` varchar(255) DEFAULT NULL,
  `cStrasse` varchar(255) DEFAULT NULL,
  `cPLZ` varchar(25) DEFAULT NULL,
  `cOrt` varchar(255) DEFAULT NULL,
  `cLand` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) DEFAULT NULL,
  `cTel` varchar(50) DEFAULT NULL,
  `cFax` varchar(50) DEFAULT NULL,
  `cUstID` varchar(50) DEFAULT NULL,
  `cDomain` varchar(255) DEFAULT NULL,
  `cResellerID` varchar(50) DEFAULT NULL,
  `cStatus` varchar(30) NOT NULL DEFAULT 'Neu',
  `dBestelltAm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cAPIKey` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`kLizenzbestellung`)
) ENGINE=MyISAM AUTO_INCREMENT=1190 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tmail`
--

DROP TABLE IF EXISTS `tmail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmail` (
  `cMailadresse` varchar(200) DEFAULT NULL,
  `cPasswort` varchar(20) DEFAULT NULL,
  `cKunde` varchar(100) NOT NULL DEFAULT '',
  `cAktiv` char(1) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `tmodulkey`
--

DROP TABLE IF EXISTS `tmodulkey`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmodulkey` (
  `kModulKey` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cModul` varchar(255) NOT NULL DEFAULT '',
  `cKey` varchar(12) DEFAULT NULL,
  `cFirma` varchar(255) DEFAULT NULL,
  `nAnzahlFreischaltungen` int(10) unsigned DEFAULT '0',
  `dGueltigAb` date DEFAULT NULL,
  PRIMARY KEY (`kModulKey`)
) ENGINE=MyISAM AUTO_INCREMENT=639 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `tmodulkeyfreischaltung`
--

DROP TABLE IF EXISTS `tmodulkeyfreischaltung`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmodulkeyfreischaltung` (
  `kModulKey` int(10) unsigned DEFAULT NULL,
  `cIP` varchar(255) DEFAULT NULL,
  `dDatum` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tmodulkeyfreischaltung_fehler`
--

DROP TABLE IF EXISTS `tmodulkeyfreischaltung_fehler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmodulkeyfreischaltung_fehler` (
  `cIP` varchar(255) DEFAULT NULL,
  `cFirma` varchar(255) NOT NULL DEFAULT '',
  `cKey` varchar(12) NOT NULL DEFAULT '',
  `dDatum` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tnewsletter`
--

DROP TABLE IF EXISTS `tnewsletter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tnewsletter` (
  `kNewsletter` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cMail` varchar(255) DEFAULT NULL,
  `dEingetragen` datetime DEFAULT NULL,
  PRIMARY KEY (`kNewsletter`)
) ENGINE=MyISAM AUTO_INCREMENT=4330 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tnewsletter_doubleopt`
--

DROP TABLE IF EXISTS `tnewsletter_doubleopt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tnewsletter_doubleopt` (
  `kNewsletterDoubleOpt` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cMail` varchar(255) DEFAULT NULL,
  `cCode` varchar(255) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kNewsletterDoubleOpt`)
) ENGINE=MyISAM AUTO_INCREMENT=2992 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tposinteressent`
--

DROP TABLE IF EXISTS `tposinteressent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tposinteressent` (
  `kPosInteressent` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cAnrede` varchar(10) DEFAULT NULL,
  `cVorname` varchar(255) DEFAULT NULL,
  `cNachname` varchar(255) DEFAULT NULL,
  `cFirma` varchar(255) NOT NULL DEFAULT '',
  `cMail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kPosInteressent`)
) ENGINE=MyISAM AUTO_INCREMENT=1221 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `traidstatus`
--

DROP TABLE IF EXISTS `traidstatus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `traidstatus` (
  `kRaidStatus` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kRaidServer` int(10) unsigned NOT NULL,
  `cRaid` varchar(255) NOT NULL,
  `nStatus` tinyint(3) unsigned NOT NULL,
  `nUsed` int(10) unsigned DEFAULT NULL,
  `nSize` int(10) unsigned DEFAULT NULL,
  `dErstellt` datetime NOT NULL,
  PRIMARY KEY (`kRaidStatus`),
  KEY `kRaidServer` (`kRaidServer`)
) ENGINE=MyISAM AUTO_INCREMENT=579844 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `treseller`
--

DROP TABLE IF EXISTS `treseller`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `treseller` (
  `kReseller` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cAnrede` varchar(10) DEFAULT NULL,
  `cVorname` varchar(255) DEFAULT NULL,
  `cNachname` varchar(255) DEFAULT NULL,
  `cFirma` varchar(255) DEFAULT NULL,
  `cStrasse` varchar(255) DEFAULT NULL,
  `cPLZ` varchar(25) DEFAULT NULL,
  `cOrt` varchar(255) DEFAULT NULL,
  `cLand` varchar(255) DEFAULT NULL,
  `cMail` varchar(255) DEFAULT NULL,
  `cTel` varchar(50) DEFAULT NULL,
  `cFax` varchar(50) DEFAULT NULL,
  `cWWW` varchar(255) DEFAULT NULL,
  `cResellerID` varchar(255) NOT NULL DEFAULT '',
  `dErstellt` datetime DEFAULT NULL,
  `cStatus` varchar(20) NOT NULL DEFAULT 'Neu',
  PRIMARY KEY (`kReseller`)
) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tserver`
--

DROP TABLE IF EXISTS `tserver`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tserver` (
  `kServer` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) NOT NULL,
  `cBackupServer` varchar(255) DEFAULT NULL,
  `nRaid` tinyint(3) unsigned NOT NULL,
  `nBackup` tinyint(3) unsigned NOT NULL,
  `eServerTyp` enum('shop','shop3','shop4','sql','dev','-','int','sqlhost','premium') NOT NULL DEFAULT '-',
  `nSort` int(10) unsigned NOT NULL,
  PRIMARY KEY (`kServer`),
  KEY `cName` (`cName`)
) ENGINE=MyISAM AUTO_INCREMENT=361 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tserverinfo`
--

DROP TABLE IF EXISTS `tserverinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tserverinfo` (
  `kServerinfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kServer` int(10) unsigned NOT NULL,
  `cInfo` text NOT NULL,
  `dUpdated` datetime NOT NULL,
  PRIMARY KEY (`kServerinfo`),
  KEY `kServer` (`kServer`,`dUpdated`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tserverinfoload`
--

DROP TABLE IF EXISTS `tserverinfoload`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tserverinfoload` (
  `kServerinfoload` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kServerinfo` int(10) unsigned NOT NULL,
  `nLoad` tinyint(4) NOT NULL,
  `dDate` datetime NOT NULL,
  PRIMARY KEY (`kServerinfoload`),
  KEY `kServerinfo` (`kServerinfo`,`dDate`)
) ENGINE=MyISAM AUTO_INCREMENT=67034 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tservermonitoring`
--

DROP TABLE IF EXISTS `tservermonitoring`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tservermonitoring` (
  `kServerMonitoring` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kServer` int(10) unsigned DEFAULT NULL,
  `eService` enum('search','repricer') DEFAULT NULL,
  `nStatus` tinyint(1) unsigned NOT NULL,
  `cError` text,
  `dCreated` datetime NOT NULL,
  PRIMARY KEY (`kServerMonitoring`),
  KEY `eService` (`eService`,`dCreated`)
) ENGINE=MyISAM AUTO_INCREMENT=541624 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tservermonitoringmail`
--

DROP TABLE IF EXISTS `tservermonitoringmail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tservermonitoringmail` (
  `kServerMonitoringMail` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kServerMonitoring` int(10) unsigned NOT NULL,
  `dCreated` datetime NOT NULL,
  PRIMARY KEY (`kServerMonitoringMail`),
  KEY `kServerMonitoring` (`kServerMonitoring`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tservermonitoringmail`
--

LOCK TABLES `tservermonitoringmail` WRITE;
/*!40000 ALTER TABLE `tservermonitoringmail` DISABLE KEYS */;
/*!40000 ALTER TABLE `tservermonitoringmail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tshop`
--

DROP TABLE IF EXISTS `tshop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tshop` (
  `kShop` int(10) unsigned NOT NULL DEFAULT '0',
  `cKundenname` varchar(255) DEFAULT NULL,
  `cMainURL` varchar(255) DEFAULT NULL,
  `cDomains` varchar(255) DEFAULT NULL,
  `cB2B` char(1) DEFAULT NULL,
  `cDBName` varchar(255) DEFAULT NULL,
  `cKommentar` varchar(255) DEFAULT NULL,
  `cErstelltAm` datetime DEFAULT NULL,
  PRIMARY KEY (`kShop`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tshop`
--

LOCK TABLES `tshop` WRITE;
/*!40000 ALTER TABLE `tshop` DISABLE KEYS */;
/*!40000 ALTER TABLE `tshop` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tshopsinbetrieb`
--

DROP TABLE IF EXISTS `tshopsinbetrieb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tshopsinbetrieb` (
  `kShopsInBetrieb` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cShopName` varchar(255) DEFAULT NULL,
  `cShopBeschreibung` varchar(255) DEFAULT NULL,
  `cShopURL` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kShopsInBetrieb`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `tsoftware`
--

DROP TABLE IF EXISTS `tsoftware`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tsoftware` (
  `kSoftware` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cName` varchar(255) NOT NULL DEFAULT '',
  `nTageGueltig` int(10) unsigned DEFAULT NULL,
  `cDownload` varchar(255) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kSoftware`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tsoftware`
--

LOCK TABLES `tsoftware` WRITE;
/*!40000 ALTER TABLE `tsoftware` DISABLE KEYS */;
INSERT INTO `tsoftware` VALUES (1,'JTL Shop 2.19 mit SEO',365,'JTL-Shop2.zip','2007-11-20 13:48:03'),(2,'JTL Shop 2.19 ohne SEO',365,'JTL-Shop2_no_seo.zip','2007-11-20 13:48:03'),(3,'Multishopfähigkeit',1000,NULL,'2007-11-20 13:48:40');
/*!40000 ALTER TABLE `tsoftware` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tsoftwareupdate`
--

DROP TABLE IF EXISTS `tsoftwareupdate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tsoftwareupdate` (
  `kSoftwareupdate` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kSoftware` int(10) unsigned DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `cDownload` varchar(255) DEFAULT NULL,
  `dErstellt` datetime DEFAULT NULL,
  PRIMARY KEY (`kSoftwareupdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tsoftwareupdate`
--

LOCK TABLES `tsoftwareupdate` WRITE;
/*!40000 ALTER TABLE `tsoftwareupdate` DISABLE KEYS */;
/*!40000 ALTER TABLE `tsoftwareupdate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tusertracking`
--

DROP TABLE IF EXISTS `tusertracking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tusertracking` (
  `kUsertracking` int(11) NOT NULL AUTO_INCREMENT,
  `kAdminlogin` int(11) NOT NULL,
  `cFile` varchar(255) NOT NULL,
  `dEingetragen` datetime NOT NULL,
  PRIMARY KEY (`kUsertracking`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tusertracking`
--

LOCK TABLES `tusertracking` WRITE;
/*!40000 ALTER TABLE `tusertracking` DISABLE KEYS */;
/*!40000 ALTER TABLE `tusertracking` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tusertrackingitems`
--

DROP TABLE IF EXISTS `tusertrackingitems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tusertrackingitems` (
  `kUsertrackingItems` int(11) NOT NULL AUTO_INCREMENT,
  `kUsertracking` int(11) NOT NULL,
  `cItemName` varchar(255) NOT NULL,
  `cItemValue` longtext NOT NULL,
  PRIMARY KEY (`kUsertrackingItems`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tusertrackingitems`
--

LOCK TABLES `tusertrackingitems` WRITE;
/*!40000 ALTER TABLE `tusertrackingitems` DISABLE KEYS */;
/*!40000 ALTER TABLE `tusertrackingitems` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tversion`
--

DROP TABLE IF EXISTS `tversion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tversion` (
  `cVersion` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tversion`
--

LOCK TABLES `tversion` WRITE;
/*!40000 ALTER TABLE `tversion` DISABLE KEYS */;
INSERT INTO `tversion` VALUES ('099612');
/*!40000 ALTER TABLE `tversion` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-12-28  2:47:13
