-- MySQL dump 10.15 Distrib 10.0.36-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: VERO -- ------------------------------------------------------ -- Server version 10.0.36-MariaDB-0ubuntu0.16.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 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 */; DROP DATABASE IF EXISTS VERO; CREATE DATABASE VERO; USE VERO; -- -- Table structure for table `BibliographicData` -- DROP TABLE IF EXISTS `BibliographicData`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `BibliographicData` ( `biblioId` int(11) NOT NULL COMMENT 'ID', `biblioUserId` int(11) NOT NULL, `biblioTitle` varchar(255) NOT NULL COMMENT 'Hauptsachtitel', `biblioFirstAuthor` varchar(255) NOT NULL COMMENT '1. Autor', `biblioOccurrence` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Vorgangsnummer', `biblioIdStatus` int(11) NOT NULL COMMENT 'Link zum Status', `biblioData` text NOT NULL COMMENT 'bibliographische Daten', PRIMARY KEY (`biblioId`), KEY `biblioTitle` (`biblioTitle`), KEY `biblioOccurance` (`biblioOccurrence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `BibliographicData` -- LOCK TABLES `BibliographicData` WRITE; /*!40000 ALTER TABLE `BibliographicData` DISABLE KEYS */; /*!40000 ALTER TABLE `BibliographicData` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Document` -- DROP TABLE IF EXISTS `Document`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Document` ( `documentId` int(11) NOT NULL AUTO_INCREMENT, `BibliographicData_biblioId` int(11) NOT NULL, `documentIdOccurance` int(11) NOT NULL, `documentType` varchar(16) DEFAULT NULL, `documentContent` mediumtext, PRIMARY KEY (`documentId`), KEY `idOccurance` (`documentIdOccurance`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Document` -- LOCK TABLES `Document` WRITE; /*!40000 ALTER TABLE `Document` DISABLE KEYS */; /*!40000 ALTER TABLE `Document` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Mail` -- DROP TABLE IF EXISTS `Mail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Mail` ( `MailId` int(11) NOT NULL, `mailOccurance` int(11) NOT NULL, `mailSent` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `mailContent` text, `BibliographicData_biblioId` int(11) NOT NULL, PRIMARY KEY (`MailId`,`BibliographicData_biblioId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Mail` -- LOCK TABLES `Mail` WRITE; /*!40000 ALTER TABLE `Mail` DISABLE KEYS */; /*!40000 ALTER TABLE `Mail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Status` -- DROP TABLE IF EXISTS `Status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Status` ( `statusID` int(11) NOT NULL AUTO_INCREMENT, `statusOccurance` int(11) NOT NULL, `statusLastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `statusCode` int(11) DEFAULT NULL, `statusValue` varchar(255) DEFAULT NULL, PRIMARY KEY (`statusID`), KEY `statusOccurance` (`statusID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Status` -- LOCK TABLES `Status` WRITE; /*!40000 ALTER TABLE `Status` DISABLE KEYS */; /*!40000 ALTER TABLE `Status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `User` -- DROP TABLE IF EXISTS `User`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `User` ( `userId` int(10) unsigned NOT NULL AUTO_INCREMENT, `userPassword` varchar(255) NOT NULL, `userTitle` varchar(32) DEFAULT NULL, `userLastName` varchar(255) NOT NULL, `userFirstName` varchar(255) NOT NULL, `userEmail` varchar(255) NOT NULL, `userStatus` smallint(6) DEFAULT NULL, `userLastActivity` timestamp NULL DEFAULT NULL, `userToken` varchar(255) DEFAULT NULL, UNIQUE KEY `userId` (`userId`), KEY `userName` (`userLastName`,`userFirstName`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `User` -- LOCK TABLES `User` WRITE; /*!40000 ALTER TABLE `User` DISABLE KEYS */; INSERT INTO `User` VALUES (25,'$2y$12$sgcOO8gmCsgKVE4i1McfyumDAc5iqXjrqFvwR1T6ywnJ4IwjgyNVe','','Woll','Christian','woll@bibb.de',0,'2025-06-27 07:58:44',''),(30,'$2y$12$/HfDgxSsGgpfsSein8NyKOszJd9RzpBXfih5/SK875ZM9QlrWoKDO','','Savi','Annemarie','annemarie.savi@bibb.de',0,'2025-06-30 11:03:16',''),(33,'$2y$10$QUM.e.vAlVOmTcp1PPANM.tUSOhFj4krlYhDU9YmQwCedD8KzQ9ua','','Zeuner','Philipp','Zeuner@bibb.de',0,'2025-11-17 13:36:53',''),(37,'$2y$12$n75hOgjLDG6hSiwdE4kIee7KRya87FmuHeaGioX5pZUh2JDFnRGIu','','Nolden','Julia','nolden@bibb.de',0,'2025-11-26 10:48:55',''),(41,'$2y$12$sRvkgrl2mxYVt9i8mTCNYeC5W5jJA3D1QEZNwi4FxD8qxBqqZpski','','Taufenbach','Kerstin','taufenbach@bibb.de',0,'2025-07-18 10:50:46',''),(44,'$2y$10$5AIL1l7TccUzNjQBiFGWJO4OeO7g640gLF537HK44dS0vitJSTFoK','','Keck','Roland','roland.keck@conlicom.de',0,'2025-11-13 06:48:11',''),(51,'$2y$10$ne.8rcknmFMIuG4MSAp78O8Ahqct28JNlOEOokcTopIUJRkANZgxy','','Offerhaus','Judith','judith.offerhaus@bibb.de',0,'2025-08-18 14:09:39',''),(52,'$2y$10$5NMmcUfzCtV9bjZ7ongMTuAaR.xqYiMkBIjJ02AyBC7kC31430Pva','','Adrian','René','rene.adrian@bibb.de',0,'2025-08-18 14:35:26',''),(53,'$2y$10$FyzmAmt7KG.Myrymltgs3O4jmmoFhsjQ5MszD3xRnOEAd8tBdEbpO','','Ganz','Kathrin','kathrin.ganz@fu-berlin.de',0,'2025-08-19 08:06:14',''),(54,'$2y$10$BX0XHkY/hbVrr7z6xji9K.Ms3pScIYxDJYhPlVxGItPD9Zj/iVvIO','','Linder','Dennis','dennis.linder@bibb.de',0,'2025-08-21 11:09:15',''),(56,'$2y$10$WUUh82pZak7cM4ltEBKBReSjEiPXQUUd/vlPt.n7NshntEFNQ.mlG','','Weiland','Jan','j.weiland@zbw.eu',0,'2025-08-22 07:38:11',''),(57,'$2y$10$RJmKOJB7MSPRbtTVitzMNuPVGfEpHIR5wmssFLvEaXEamnLTmWXDW','','Müller-Wegner','Max','max.mueller@bibb.de',0,'2025-08-22 12:40:57',''),(58,'$2y$10$Pa4hj758OEajqv4ijEyYq.j4vVjevFnvMqG0rKweUvL2izo6E2a7e','','Materna','Thomas','materna@bibb.de',0,'2025-08-22 15:35:11',''),(59,'$2y$10$WR3hxRvIb.5kWHwrDWnJhODu.bsUecYocwXBQShBEwGvIUVu6iX7q','','Winkler','Antje','winkler@bibb.de',0,'2025-11-26 15:41:52',''),(62,'$2y$10$4ElTcMUsURkwXAdbQihbjeEqx.i8lldSwqUYEBBENdvf8pDV9KDaa','','Schambeck','Arne','schambeck@bibb.de',0,'2025-09-02 09:22:53',''),(63,'$2y$10$4Ykw5q1I8wDgJyYTQ0hubepV2woRZHVvMSfGbkeJnwaE1CJz5Ci1q','','Rüsing','Karin Maria','ruesing@bibb.de',0,'2025-09-11 10:17:03',''),(64,'$2y$10$SAn1NDfETiblx3ZTOR8N7uGlqvxHTam3gq.yZarKDasN35Bh7ZaWK','','Gerhards','Lea','leg@leibniz-psychology.org',0,'2025-09-15 09:58:41',''),(65,'$2y$10$B3U3SjVEGjIHOE2jTT9qTeomTEbXHvauWagMdVYCoiox9YAel5izK','','Langenkamp','Karin','langenkamp@bibb.de',0,'2025-09-15 13:01:13',''),(66,'$2y$10$gpBc6.p8Vkq34EnczDiJBuwbcoJgIV7Eivap.Mb0lbXoPIoucYYx2','','Göckede','Benno','benno.goeckede@uni-koeln.de',0,'2025-09-19 07:46:22',''),(67,'$2y$10$pZFgYQDdBq6szhl.XwF0Mehw8HotQuvOUIWoR55RpF/JxGbFXUa6G','','Woll','Christian','christian.woll@gmx.de',0,'2025-09-29 12:58:08',''),(68,'$2y$10$/GI4JtqQOsB7561xSGAtfO2NKnvzy9uJTwc8tCknpkgX0U07WE7t.','','Thole','Christine','christiane.thole@t-online.de',0,'2025-10-01 17:30:18',''),(69,'$2y$10$31O9u2eoFaWnAy4uLryJ5OB.ZsquPRHdGYtpNTDzjEU0s2TSREkHG','','Scharlach','Matthias','post@extro-company.de',0,'2025-10-14 09:46:38',''),(70,'$2y$10$pOIP2YlmLaumO8zvNawN7OTQrY96EGbsrmfp/93utr1TcjDNMCF1a','','Holzer','Julia Teresa','julia.t.holzer@gmail.com',0,'2025-10-20 18:43:12',''),(71,'$2y$10$sGdXoi6kE1pri9gsMJ/jluniVP7Ky2ayemzNfQC.jdV.Yx3f9B8Nq','','Grotluschen','Anke','anke.grotlueschen@uni-hamburg.de',0,'2025-11-18 13:09:29',''),(72,'$2y$10$9qA2Cu79GvO1pA.ocRvaFef9176ilEGH4Opul0yEon/wrCZx9IzOu','','Wittmann','Eveline','eveline.wittmann@tum.de',0,'2025-11-19 11:13:52',''),(73,'$2y$10$dyBxPG2QaSABs60OOKaan.y99LjXD4YVnp3Z3i6fM9WEBagFw753a','','Winkler','Antje','winkler@web.de',99,'2025-11-19 20:18:38','b68d965b4cfc396013f6ec359b05549b62ba0b78f172a0020ce0f84e23b5e6bb'),(74,'$2y$10$ByaoZb3JJL9WpIQbJtdyYuDZxl9XBsou2vHWN.18ZPUuxP8XqL8xW','','Bunschoten','Michelle Celine','michelle.bunschoten@neustart.kom-bildung.de',0,'2025-11-24 08:48:01',''); /*!40000 ALTER TABLE `User` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `additionalDocuments` -- DROP TABLE IF EXISTS `additionalDocuments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `additionalDocuments` ( `documentId` int(11) NOT NULL AUTO_INCREMENT, `documentIdOccurance` int(11) NOT NULL, `documentType` varchar(16) NOT NULL, `documentContent` mediumtext, `BibliographicData_biblioId` int(11) NOT NULL, PRIMARY KEY (`documentId`), KEY `idOccurance` (`documentIdOccurance`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `additionalDocuments` -- LOCK TABLES `additionalDocuments` WRITE; /*!40000 ALTER TABLE `additionalDocuments` DISABLE KEYS */; /*!40000 ALTER TABLE `additionalDocuments` 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 2025-11-28 7:12:12