/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.5.29-MariaDB, for debian-linux-gnueabihf (armv8l) -- -- Host: 127.0.0.1 Database: -- ------------------------------------------------------ -- Server version 10.5.29-MariaDB-0+deb11u1 /*!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 utf8mb4 */; /*!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 */; -- -- Current Database: `daten` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `daten` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */; USE `daten`; -- -- Table structure for table `ListArt` -- DROP TABLE IF EXISTS `ListArt`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ListArt` ( `reihe` int(11) NOT NULL AUTO_INCREMENT, `R_Art` int(11) DEFAULT NULL, `Name` char(20) DEFAULT NULL, `Lohn` int(11) DEFAULT NULL, `Zahl01` int(11) DEFAULT NULL, `Zahl02` int(11) DEFAULT NULL, PRIMARY KEY (`reihe`), KEY `IR_Art` (`R_Art`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ListArt` -- LOCK TABLES `ListArt` WRITE; /*!40000 ALTER TABLE `ListArt` DISABLE KEYS */; INSERT INTO `ListArt` VALUES (1,32,NULL,NULL,NULL,NULL),(2,312,NULL,NULL,NULL,NULL),(3,123,NULL,NULL,NULL,NULL),(4,1,NULL,NULL,NULL,NULL),(5,2312,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `ListArt` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `aKontakte` -- DROP TABLE IF EXISTS `aKontakte`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `aKontakte` ( `reihe` int(11) NOT NULL AUTO_INCREMENT, `Vorname` varchar(250) DEFAULT NULL, `Nachname` varchar(250) DEFAULT NULL, `Geburtstag` varchar(250) DEFAULT NULL, `Geburtstag_N` varchar(250) DEFAULT NULL, `Geburtstag_S` varchar(250) DEFAULT NULL, `EMail_1` varchar(250) DEFAULT NULL, `EMail_2` varchar(250) DEFAULT NULL, `EMail_3` varchar(250) DEFAULT NULL, `Nr_Privat` varchar(250) DEFAULT NULL, `Nr_Mobil` varchar(250) DEFAULT NULL, `Nr_Geschaeftlich` varchar(250) DEFAULT NULL, `Addr_Privat` varchar(250) DEFAULT NULL, `Addr_Geschaeftlich` varchar(250) DEFAULT NULL, `WWW` varchar(250) DEFAULT NULL, `Notizen` text DEFAULT NULL, PRIMARY KEY (`reihe`) ) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `aKontakte` -- LOCK TABLES `aKontakte` WRITE; /*!40000 ALTER TABLE `aKontakte` DISABLE KEYS */; INSERT INTO `aKontakte` VALUES (1,'Adem',' Hikmet Özen','01.01.4501','Outlook','Outlook','','','',' +49 162 4906284','','03081021575','','Feurigstraße 68\r\n\r\n10 827 Bfferlin','',''),(2,'Ec',' Sperren','01.01.4501','Outlook','Outlook','','','','','','0185021021','','','','\r\nBLZ: 216 900 20\r\nKNr.:008278342\r\nKartenfolge: 1\r\nLaufzeitende Karte:2014'),(3,'ADAC','','01.01.4501','Outlook','Outlook','service@adac.de','','','+49 (0180) 51 01 112','','','','','http://www.adac.de','Mitglieds-Nr : 099273402'),(4,'Huck-Coburg','','01.01.4501','Outlook','Outlook','','','','0800 2 153 153','','','','Hopfenstr. 29\r\nKiel 24 088\r\nDeutschland','','Rechtschutz ,425/073309-N-01\r\nFord SL-JM 641 , 625/229985-E ,\r\nKawa SL-SM 5\r\n625/229984-D\r\nKM 11-09 65.000'),(5,'Dirk',' Peters','31.08.1966','Outlook','Outlook','dryx66@gmx.de','','','0202-25329278','+491788238778','','Meckelstr. 76\r\n42287 Wuppertal \r\nDeutschland','','',''),(6,'Julia',' Peters','15.10.1997','Outlook','Outlook','juliapeters35@gmail.com','','','046431856205','+4915150773917','','Bredegatter Str. 15a\r\n24972 Steinbergkirche','','','<>\r\n '),(7,'Nene','','01.01.4501','Outlook','Outlook','','','','030 6235223','+49 179 2005105','','','Hobrechtstr. 12\r\n12047 Berlin','',''),(8,'Martin',' Zimme','01.01.4501','Outlook','Outlook','martin.zimme@gmx.de','','','','+49 1523 7738129','','Adlerweg 14\r\n16515 Oranienburg','','',''),(9,'Volker',' Zahn','01.01.4501','Outlook','Outlook','dentis@gmx.de','','','0621 4370772','01721876219','','Ottenhöferstrasse 2\r\n68239 Manheim','Talstrasse 37\r\n69190 Walldorf','',''),(10,'YASAR',' YASAR','01.01.4501','Outlook','Outlook','','','','','+491726569686','0308518471','','KopierCenter - Berlin Schöneberg \r\nRheinstraße 49\r\n12161 Berlin','http://www.kopiercenter-berlin.de',''),(11,'AXEL',' KRÜGER','01.01.4501','Outlook','Outlook','Krueger.Axel@t-online.de','','','','+4915158069966','','','','','\r\n* kopf !\r\n82\r\n* kopf ! '),(12,'MICHAEL',' KLANE','01.01.4501','Outlook','Outlook','','','','+4933334859185','01723815202','','','Peetzig 43\r\n16278 Angermünde','',''),(13,'Karim',' Ernst','21.12.1992','Outlook','Outlook','','','','','015771868821','','Briegerstr. 4\r\n12 249 Berlin','','','<>'),(14,'Imke',' Peters','26.08.1969','Outlook','Outlook','imke_peters@web.de','','','','015128846267','+494642182422','','Dorfstr. 7\r\n24 395 Stangheck \r\nDeutschland','','<>'),(15,'Maria',' Kanter','04.08.1994','Outlook','Outlook','maria_kanter@web.de','','','046371717','+491741687808','0461 - 22 8 22','Maria Peters\r\n\r\nWippendorf 23\r\n24402 Esgrus','Fachtierärztliches Zentrum für Kleintiere\r\nLilienthalstr. 19\r\n24941 Flensburg\r\n\r\nTel. 0461 - 22 8 22\r\nFax 0461 - 18 07 29\r\ninfo@tieraerztliches-zentrum.de \r\nDeutschland','',''),(16,'Felice',' Peters','23.02.1993','Outlook','Outlook','felicepeters93@web.de','','','','017620382324','','Gooskamp 6\r\nBosau 23715','','','<>'),(17,'Hizir',' Özen','21.04.1978','Outlook','Outlook','hizir.oezen@yahoo.de','','','','+4916094492626','','14 Goltzstraße\r\n10 781 Berlin \r\nDeutschland','','','<>'),(18,'Hülmüs',' Esgünoglu','27.05.1974','Outlook','Outlook','huelmues@web.de','','','030 315 075 80','+491771706666','','','Krummestr. 50\r\n10 627 Berlin','','<>'),(19,'Hava',' Özen','20.10.1962','Outlook','Outlook','hava.ozen@yahoo.de','','','','+4915777019351','','','Wartburgstr. 51\r\nBerlin 10823\r\nDeutschland','','<>'),(20,'Osman',' Özen','15.07.1972','Outlook','Outlook','','','','03088675765','+491744077666','','','Xantener Str.2\r\nBerlin 10 707\r\nDeutschland','','<>'),(21,'Menderes',' Özen','15.05.1965','Outlook','Outlook','me@yaca.de','','','+49 (46 43) 18 22 17','+49 175 74 24 910','+49 (46 43) 18 93 94','PP strasaf 12\r\n12345 ort - pri schleswig\r\nDeutschland','Koblenzer Str.26\r\n10715 Berlin \r\nDeutschland','http://www.yaca.de','\r\n \r\nPapa 1.6.34\r\nMama 25.4.38\r\nAdem 1.1.60\r\nHava 20.10.62\r\nOsman 15.7.72\r\nHülmüs 27.5.74\r\nHizir 21.4.78\r\n\r\ngmai\r\nyacade2015@gmail.com Pass : yaca2010 \r\n\r\n\r\nMozilla\r\ndown@yaca.de\r\nyacadown2010\r\n\r\n1und1\r\nkunr:P8099886\r\nPass:!Yaca2010xxxxxx\r\n\r\nAgenda xxxxxx\r\nhttps://agenda-personal-portal.de/login\r\n\r\n\r\n\r\nfastriders yaca2010\r\nBiketeile AyjGl\r\nCdCom 18904196\r\npay 93xxxx\r\nEbay 97xxxx65\r\nPersona xxxx9710\r\nCigarworld yaca2010\r\nKKart\r\nYaCa2010\r\n%FeMaJuxxxxxx\r\n\r\n\r\nklarmobil.de : yaca01757424910 Pass:Yaca2010\r\nme@yaca.de Yaca2010\r\nyacaMe2010\r\nKu.Nr.: 1051615490\r\n040 34 8585 300 \r\n\r\n\r\nPin : 3944\r\nPuk : 21011214\r\n\r\nPin2 : 9537\r\nPuk2 : 35989582\r\n\r\nMicro :down@yaca.de PassPass\r\n\r\nKoblenzer Str.26\r\n10715 Berlin\r\nDeutschland\r\n\r\nidNr. : 67 042 985 394\r\n\r\nBankverbindung\r\nComdirekt\r\nBankleitzahl\r\n20041133\r\nIBAN\r\nDE02 2004 1133 0412 7544 00\r\nBIC\r\nCOBADEHD001'),(22,'Stefan',' Kobis','28.12.1960','Outlook','Outlook','sk.61@web.de','','','','0177 2828557','','','Tucholskystraße 11\r\n10 117 Berlin','','<>'),(23,'THOMAS',' RÜSCHKAMP','01.01.4501','Outlook','Outlook','th.rueschkamp@web.de','','','','+49 15170356522','','Thomas Rüschkamp\r\nhttps://www.google.de/maps/place/Jedlina-Zdr%C3%B3j/data=!4m2!3m1!1s0x470e50432290da41:0x15aa73637f5a0b3?sa=X&ved=2ahUKEwig4aPW6YL7AhVqmIsKHS6ZCMMQ8gF6BAhoEAE','','',''),(24,'Alexander',' Hoffmann','01.01.4501','Outlook','Outlook','ahofmann@aho-management.com','','','03329698483','01709275003','030 88 703 342','','Luisenstrasse 46\r\nStahnsdorf 14532\r\nDeutschland','http://aho-management.com',''),(25,'Christian',' Heckert','24.06.2003','Outlook','Outlook','chr.heckert@freenet.de','','','+49 (04643) 189900','+491606001858','+49 (04643) 1856057','','Dorfstr.6\r\n24395 Stangheck \r\nDeutschland','http://www.wunsch-garten.de','<>'),(26,'Farid',' Ernst','19.04.1996','Outlook','Outlook','farid96@web.de','','','','01713052896','','c/o Lorbiecki Edelweißstr. 1\r\n\r\n13158 Berlin','','',''),(27,'uestebay','','01.01.4501','Outlook','Outlook','service@copy-press.de','','','','','+491634944691','','Koloniestraße 13\r\n13357 Berlin','http://www.copy-press.com',''),(28,'Claudia',' Ernst','10.04.1965','Outlook','Outlook','dackelbeen1@web.de','','','030 85732258','015158128156','','Koblenzerstr.26\r\nBerlin 10715 \r\nDeutschland','Koblenzer Str.26\r\n10715 Berlin \r\nDeutschland','','<>'),(29,'Seb',' Ernst','04.02.1971','Outlook','Outlook','sebuno319@gmail.com','','','03078712000','01772434613','','','','',''),(30,'Solid & Earth',' Dirk','01.01.4501','Outlook','Outlook','dirk@solid-earth.de','','','030 4411329','+491726600201','','','','http://solid-earth.de','Wörther Straße 29\r\n10405 Berlin\r\ntel 030 44 03 77 - 0\r\nfax 030 44 03 77 - 22\r\nmail w29@solid-earth.de \r\n\r\nKastanienallee 91\r\n10435 Berlin\r\ntel 030 44 02 44 02\r\nfax 030 44 04 74 74\r\nmail k91@solid-earth.de '),(31,'Solid & Earth',' Patrick','01.01.4501','Outlook','Outlook','','','','','+491633332212','','','','',''),(32,'Bedi',' özen','17.08.2001','Outlook','Outlook','','','','','+4917685950430','','Blasewitzer Ring 1\r\n\r\n13593 Berlin','','',''),(33,'wolf','','01.01.4501','Outlook','Outlook','jaeschke@rothenmoor33b.de','','','','01723120376','','','','',''),(34,'Klarmobile','','01.01.4501','Outlook','Outlook','Benutzername: yaca01757424910 Pass:me','','','','','','','','',''),(35,'Heiko',' Bieniek','01.01.4501','Outlook','Outlook','','','','','+491737444492','','','','',''),(36,'Frank',' Meier zu Ummeln','01.01.4501','Outlook','Outlook','frank@mzu.de','','','','015233616274','','Fichtestraße 122G\r\n14656 Brieselang \r\nDeutschland','Warener Str. 11\r\n17194 Klocksin \r\nDeutschland','',''),(37,'Mehmet','ringdamm Mehmet Copy-Shop Mike /','01.01.4501','Outlook','Outlook','','','','','+4915771441784','','','','http://copyshop64.de',''),(38,'Copy_Clara_Tucho','','01.01.4501','Outlook','Outlook','info@allesclara.de','','','','','28 28 557','','Tucholskystraße 11\r\n10117 Berlin','allesclara.de',''),(39,'Zahnarzt','','01.01.4501','Outlook','Outlook','','','','','','0308535113','','','',''),(40,'Baki',' Esgünoglu','01.01.4501','Outlook','Outlook','','','','','+491604685655','','','','',''),(41,'Frederic Klane','','01.01.4501','Outlook','Outlook','','','','030 20095414','+4915735257900','','','Strausberger Platz 17\r\n10243 Berlin \r\nDeutschland','',''),(42,'CopyTake16',' Mario','01.01.4501','Outlook','Outlook','','','','','','030 313 85 65','','Knesebeckstr. 16\r\n10623 Berlin / Charlottenburg \r\nDeutschland','http://copytake16.de','Copyon\r\n13-12'),(43,'Finn',' Wischer','01.01.4501','Outlook','Outlook','','','','','015253471605','','','Gazellenkamp 92\r\n22529 Hamburg','',''),(44,'Monika','','01.01.4501','Outlook','Outlook','','','','','015226634075','','','','',''),(45,'Thorsten',' Meinz','01.01.4501','Outlook','Outlook','','','','','017623744366','','','','',''),(46,'Ayhan',' Esgünoglu','01.01.4501','Outlook','Outlook','','','','','+49 177 3712322','','','','',''),(47,'Carlo','','01.01.4501','Outlook','Outlook','','','','','01723224252','','','','',''),(48,'Sabine',' Ernst','01.01.4501','Outlook','Outlook','','','','','015253424446','','','','',''),(49,'Biene',' / Pitt','01.01.4501','Outlook','Outlook','','','','','+49302616041','0304136053','','','',''),(50,'Blaazenko',' Jankovic','01.01.4501','Outlook','Outlook','','','','','015771383492','','','','',''),(51,'Carla','','01.01.4501','Outlook','Outlook','abc@dd.Da','','','','+4917684627403','','','','',''),(52,'ABG','','23.06.2016','Outlook','Outlook','a-mail@yaca.de','email2@yaca.de','email3@yaca.de','privat nummmer','','12345676543','Private Addresse\r\nprivat stra\r\n10777 berlin \r\nDeutschland','AA-Dresse\r\nkoblen.str.\r\n10715 berlin \r\nDeutschland','http://web-site','jhjj LatestProfile\''),(53,'Second',' Hand Motorradteile','01.01.4501','Outlook','Outlook','krueger.falk@t-online.de','','','','','+49 30 7869856','','Manfred-von-Richthofen-Str. 30\r\n12101 Berlin \r\nDeutschland','http://krueger-falk.de/',''),(54,'A-Vorname','','23.06.2016','Outlook','Outlook','a-mail@yaca.de','email2@yaca.de','email3@yaca.de','','','12345676543','Private Addresse\r\nprivat stra\r\n10777 berlin \r\nDeutschland','AA-Dresse\r\nkoblen.str.\r\n10715 berlin \r\nDeutschland','http://web-site',' LatestProfile\'\r\nYfvgsadfgf\r\nDsfdsfasdfdcasd dsadvc'),(55,'AABBXXAA','','23.06.2016','Outlook','Outlook','a-mail@yaca.de','email2@yaca.de','email3@yaca.de',', ','','12345676543','Private Addresse\r\nprivat stra\r\n10777 berlin \r\nDeutschland','AA-Dresse\r\nkoblen.str.\r\n10715 berlin \r\nDeutschland','http://web-site',' LatestProfile\''),(56,'Zeynel',' Esgünoglu','01.01.4501','Outlook','Outlook','','','','','0176 81176013','','Briese Straße 38\r\n12053 Berlin','','',''),(57,'Sören',' Peters','01.01.4501','Outlook','Outlook','soerenpeters@gmx.net','','','056916288579','01722130125','','Wetterburger Straße 111A\r\n34454 Bad Arolsen \r\nDeutschland','','',''),(58,'Milan','','01.01.4501','Outlook','Outlook','noir@citenoir.com','','','','+4915902819604','','','','',''),(59,'Jens',' ferchland','01.01.4501','Outlook','Outlook','','','','','+4915771948747','','','','',''),(60,'heike',' schultz','01.01.4501','Outlook','Outlook','','','','','+491745704400','','','','',''),(61,'Solid & Earth','arth W91','01.01.4501','Outlook','Outlook','','','','','','i0304403770','','','',''),(62,'Tobi','','01.01.4501','Outlook','Outlook','','','','04637 1717','0162 8802309','','Wippendorf 23\r\n24402 Esgrus','','',''),(63,'Birgit',' Wahl-Peters','01.01.4501','Outlook','Outlook','wahl-trans@gmx.de','','','+49 202 25329278','+49 179 8489920','','','Meckelstr. 76\r\n42287 Wuppertal','',''),(64,'Andreas',' Kronawitter','01.01.4501','Outlook','Outlook','andykro@web.de','','','','+49 176 55201813','','','','',''),(65,'Robert','','01.01.4501','Outlook','Outlook','','','','','+49 177 8386547','','','','',''),(66,'Frederic',' Notfal Marion Thiessen','01.01.4501','Outlook','Outlook','','','','0302492238','+4917644582238','','','Strausberger Platz 17\r\n10243 Berlin \r\nDeutschland','',''),(67,'Ingo',' Suhr','01.01.4501','Outlook','Outlook','','','','','+49 176 63454369','','Straße251 8\r\n\r\n13088 Berlin','','',''),(68,'Ronald',' Kopierer','01.01.4501','Outlook','Outlook','','','','','+49 178 4207426','','','','',''),(69,'Konstantin','','01.01.4501','Outlook','Outlook','','','','','0176 85018777','','','','',''),(70,'Manuel',' Unfall','01.01.4501','Outlook','Outlook','','','','','+49 175 8658400','','','','',''),(71,'Ben','','15.01.2019','Outlook','Outlook','','','','','+49 1520 6379343','','','','',''),(72,'Copy',' Clara Lotti','01.01.4501','Outlook','Outlook','print@allesclara.de','','','','','+49 30 44737272','','','',''),(73,'AA_ANTON',' Lars','10.01.2010','Outlook','Outlook','AA_EMAIL_1@aa.1','AA_EMAIL_2@aa.de','AA_EMAIL_3@aa.de','AA_NR_PRIVQT','AA_NR_MOBIL','AA_Nr_GESCHÄF','AA_STR_PRIVAT 17\r\n10464 Berlin\r\nDetschland','AA_STR_GESCHÄFT 17\r\n10664 AAABerlin\r\nDetschland','AA_WW_ADDRESSE','AA_AAAAAAAAAa_Notize\r\n'); /*!40000 ALTER TABLE `aKontakte` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kontakte` -- DROP TABLE IF EXISTS `kontakte`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kontakte` ( `reihe` int(11) NOT NULL, `Body` varchar(255) DEFAULT NULL, `Categories` varchar(50) DEFAULT NULL, `BusinessAddressCity` varchar(50) DEFAULT NULL, `BusinessAddressCountry` varchar(50) DEFAULT NULL, `BusinessAddressPostalCode` varchar(50) DEFAULT NULL, `BusinessAddressState` varchar(50) DEFAULT NULL, `BusinessAddressStreet` varchar(50) DEFAULT NULL, `BusinessFaxNumber` varchar(50) DEFAULT NULL, `BusinessHomePage` varchar(50) DEFAULT NULL, `BusinessTelephoneNumber` varchar(50) DEFAULT NULL, `Email1Address` varchar(50) DEFAULT NULL, `Email2Address` varchar(50) DEFAULT NULL, `FirstName` varchar(50) DEFAULT NULL, `HomeAddressCity` varchar(50) DEFAULT NULL, `HomeAddressCountry` varchar(50) DEFAULT NULL, `HomeAddressPostalCode` varchar(50) DEFAULT NULL, `HomeAddressState` varchar(50) DEFAULT NULL, `HomeAddressStreet` varchar(50) DEFAULT NULL, `HomeFaxNumber` varchar(50) DEFAULT NULL, `HomeTelephoneNumber` varchar(50) DEFAULT NULL, `LastName` varchar(50) DEFAULT NULL, `MiddleName` varchar(50) DEFAULT NULL, `MobileTelephoneNumber` varchar(50) DEFAULT NULL, `NickName` varchar(50) DEFAULT NULL, `EntryID` varchar(50) DEFAULT NULL, `LastModificationTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `Birthday` datetime DEFAULT NULL, `R_user` int(11) DEFAULT NULL, `Ordner` varchar(50) DEFAULT NULL, `Ordner2` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kontakte` -- LOCK TABLES `kontakte` WRITE; /*!40000 ALTER TABLE `kontakte` DISABLE KEYS */; INSERT INTO `kontakte` VALUES (0,NULL,'r4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-08-27 18:33:34',NULL,NULL,NULL,NULL),(0,NULL,'23423',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-08-27 18:33:35',NULL,NULL,NULL,NULL),(0,NULL,'4123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-08-27 18:33:35',NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `kontakte` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kunden` -- DROP TABLE IF EXISTS `kunden`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `kunden` ( `reihe` int(11) NOT NULL AUTO_INCREMENT, `R_Artikel` int(11) DEFAULT NULL, `R_Kopien` int(11) DEFAULT NULL, `Aktive` char(5) DEFAULT NULL, `name` char(40) DEFAULT NULL, `Nr` char(15) DEFAULT NULL, `Abrech_Art` smallint(6) DEFAULT NULL, `Str` char(40) DEFAULT NULL, `PLZ` char(20) DEFAULT NULL, `Ort` char(40) DEFAULT NULL, `Bemerkung` char(200) DEFAULT NULL, `Vor` char(10) DEFAULT NULL, `Tel` char(10) DEFAULT NULL, `Fax` char(10) DEFAULT NULL, `Anrede` char(20) DEFAULT NULL, `Ansprech` char(40) DEFAULT NULL, `Guthaben` int(11) DEFAULT NULL, `Abrech_Tag` int(11) DEFAULT NULL, `Abrech_Datum` int(11) DEFAULT NULL, `PA_1` char(10) DEFAULT NULL, `Trans` char(120) DEFAULT NULL, `Art` int(11) DEFAULT NULL, `Rabat` int(11) DEFAULT NULL, `vorname` varchar(50) DEFAULT NULL, `zeit` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `online_state` int(11) DEFAULT NULL, `online_in` int(11) DEFAULT NULL, `R_Kopien_G` int(11) DEFAULT NULL, `Datum` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`reihe`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kunden` -- LOCK TABLES `kunden` WRITE; /*!40000 ALTER TABLE `kunden` DISABLE KEYS */; INSERT INTO `kunden` VALUES (1,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:18:01','2025-08-27 18:18:01',NULL,178,NULL,'0000-00-00 00:00:00'),(2,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.4630','2025-08-27 18:18:01',NULL,186,NULL,'0000-00-00 00:00:00'),(3,323,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-08-27 18:18:03',NULL,NULL,NULL,'0000-00-00 00:00:00'),(4,232,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-08-27 18:18:03',NULL,NULL,NULL,'0000-00-00 00:00:00'),(5,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-08-27 18:18:04',NULL,NULL,NULL,'0000-00-00 00:00:00'),(6,32,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-08-27 18:18:04',NULL,NULL,NULL,'0000-00-00 00:00:00'),(7,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-08-27 18:18:04',NULL,NULL,NULL,'0000-00-00 00:00:00'),(8,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:21:02','2025-08-27 18:21:02',NULL,200,NULL,'0000-00-00 00:00:00'),(9,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.4091','2025-08-27 18:21:02',NULL,194,NULL,'0000-00-00 00:00:00'),(10,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:24:01','2025-08-27 18:24:01',NULL,222,NULL,'0000-00-00 00:00:00'),(11,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.5502','2025-08-27 18:24:02',NULL,209,NULL,'0000-00-00 00:00:00'),(12,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:27:01','2025-08-27 18:27:01',NULL,204,NULL,'0000-00-00 00:00:00'),(13,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.5156','2025-08-27 18:27:02',NULL,200,NULL,'0000-00-00 00:00:00'),(14,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:30:01','2025-08-27 18:30:01',NULL,218,NULL,'0000-00-00 00:00:00'),(15,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.3962','2025-08-27 18:30:01',NULL,217,NULL,'0000-00-00 00:00:00'),(16,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:33:02','2025-08-27 18:33:02',NULL,230,NULL,'0000-00-00 00:00:00'),(17,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.5304','2025-08-27 18:33:02',NULL,208,NULL,'0000-00-00 00:00:00'),(18,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:36:01','2025-08-27 18:36:01',NULL,221,NULL,'0000-00-00 00:00:00'),(19,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.5133','2025-08-27 18:36:02',NULL,210,NULL,'0000-00-00 00:00:00'),(20,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:39:01','2025-08-27 18:39:01',NULL,215,NULL,'0000-00-00 00:00:00'),(21,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.5579','2025-08-27 18:39:01',NULL,226,NULL,'0000-00-00 00:00:00'),(22,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:42:01','2025-08-27 18:42:01',NULL,241,NULL,'0000-00-00 00:00:00'),(23,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.4726','2025-08-27 18:42:01',NULL,218,NULL,'0000-00-00 00:00:00'),(24,NULL,NULL,NULL,'77.183.17.66',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'08.27 20:45:02','2025-08-27 18:45:02',NULL,227,NULL,'0000-00-00 00:00:00'),(25,NULL,NULL,NULL,'TIME 208',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.6004','2025-08-27 18:45:02',NULL,221,NULL,'0000-00-00 00:00:00'); /*!40000 ALTER TABLE `kunden` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mails` -- DROP TABLE IF EXISTS `mails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mails` ( `reihe` int(11) NOT NULL AUTO_INCREMENT, `puser` char(60) DEFAULT NULL, `von` char(60) DEFAULT NULL, `nach` char(60) DEFAULT NULL, `datei` char(60) DEFAULT NULL, `betreff` char(120) DEFAULT NULL, `Idatum` timestamp NOT NULL DEFAULT current_timestamp(), `datum` datetime DEFAULT NULL, `grosse` int(11) DEFAULT NULL, `uid` int(11) DEFAULT NULL, `art` int(11) DEFAULT NULL, `plainmsg` text DEFAULT NULL, `htmlmsg` text DEFAULT NULL, PRIMARY KEY (`reihe`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mails` -- LOCK TABLES `mails` WRITE; /*!40000 ALTER TABLE `mails` DISABLE KEYS */; INSERT INTO `mails` VALUES (1,'ww',NULL,NULL,NULL,NULL,'2025-08-27 18:18:08',NULL,NULL,NULL,NULL,NULL,NULL),(2,'ww',NULL,NULL,NULL,NULL,'2025-08-27 18:18:09',NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `mails` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `mysql` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */; USE `mysql`; -- -- Table structure for table `general_log` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE IF NOT EXISTS `general_log` ( `event_time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6), `user_host` mediumtext NOT NULL, `thread_id` bigint(21) unsigned NOT NULL, `server_id` int(10) unsigned NOT NULL, `command_type` varchar(64) NOT NULL, `argument` mediumtext NOT NULL ) ENGINE=CSV DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='General log'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `slow_log` -- /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE IF NOT EXISTS `slow_log` ( `start_time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6), `user_host` mediumtext NOT NULL, `query_time` time(6) NOT NULL, `lock_time` time(6) NOT NULL, `rows_sent` bigint(20) unsigned NOT NULL, `rows_examined` bigint(20) unsigned NOT NULL, `db` varchar(512) NOT NULL, `last_insert_id` int(11) NOT NULL, `insert_id` int(11) NOT NULL, `server_id` int(10) unsigned NOT NULL, `sql_text` mediumtext NOT NULL, `thread_id` bigint(21) unsigned NOT NULL, `rows_affected` int(11) NOT NULL ) ENGINE=CSV DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='Slow log'; /*!40101 SET character_set_client = @saved_cs_client */;