/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.11.9-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: pyqcrm -- ------------------------------------------------------ -- Server version 10.11.9-MariaDB /*!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 */; -- -- Table structure for table `address` -- DROP TABLE IF EXISTS `address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `address` ( `addressid` int(11) NOT NULL AUTO_INCREMENT, `country` varchar(50) DEFAULT NULL, `address` varchar(50) NOT NULL, PRIMARY KEY (`addressid`), UNIQUE KEY `address_unique` (`address`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `address` -- LOCK TABLES `address` WRITE; /*!40000 ALTER TABLE `address` DISABLE KEYS */; /*!40000 ALTER TABLE `address` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assignment` -- DROP TABLE IF EXISTS `assignment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assignment` ( `contractid` int(11) NOT NULL AUTO_INCREMENT, `employeeid` int(11) NOT NULL, UNIQUE KEY `assignment_unique` (`contractid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_estonian_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assignment` -- LOCK TABLES `assignment` WRITE; /*!40000 ALTER TABLE `assignment` DISABLE KEYS */; /*!40000 ALTER TABLE `assignment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact` -- DROP TABLE IF EXISTS `contact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact` ( `id` int(11) NOT NULL, `contactpersonid` int(11) NOT NULL, `customer` tinyint(1) NOT NULL DEFAULT 1, UNIQUE KEY `contact_unique` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact` -- LOCK TABLES `contact` WRITE; /*!40000 ALTER TABLE `contact` DISABLE KEYS */; /*!40000 ALTER TABLE `contact` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactperson` -- DROP TABLE IF EXISTS `contactperson`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contactperson` ( `contactpersonid` int(11) NOT NULL AUTO_INCREMENT, `priorityid` int(11) DEFAULT NULL, `lastname` varchar(35) NOT NULL, `firstname` varchar(35) NOT NULL, `phone` varchar(50) DEFAULT NULL, `mobilephone` varchar(50) DEFAULT NULL, `position` varchar(50) DEFAULT NULL, `salutation` varchar(10) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `birthday` date DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`contactpersonid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactperson` -- LOCK TABLES `contactperson` WRITE; /*!40000 ALTER TABLE `contactperson` DISABLE KEYS */; /*!40000 ALTER TABLE `contactperson` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contract` -- DROP TABLE IF EXISTS `contract`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract` ( `contractid` int(11) NOT NULL AUTO_INCREMENT, `jobdetailid` int(11) NOT NULL, `tariffid` int(11) NOT NULL, `officeid` int(11) NOT NULL COMMENT 'Kostenstelle', `date` date NOT NULL, PRIMARY KEY (`contractid`), UNIQUE KEY `contract_unique` (`jobdetailid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contract` -- LOCK TABLES `contract` WRITE; /*!40000 ALTER TABLE `contract` DISABLE KEYS */; /*!40000 ALTER TABLE `contract` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customer` ( `customerid` int(11) NOT NULL AUTO_INCREMENT, `company` varchar(100) NOT NULL, `street` varchar(100) NOT NULL, `postcodeid` int(11) DEFAULT NULL, `phone` varchar(50) DEFAULT NULL, `mobilephone` varchar(50) DEFAULT NULL, `email` varchar(255) NOT NULL, `homepage` varchar(255) DEFAULT NULL, `director` varchar(100) DEFAULT NULL, `contactpersonid` int(11) NOT NULL, PRIMARY KEY (`customerid`), UNIQUE KEY `customer_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer` -- LOCK TABLES `customer` WRITE; /*!40000 ALTER TABLE `customer` DISABLE KEYS */; /*!40000 ALTER TABLE `customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee` -- DROP TABLE IF EXISTS `employee`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `employee` ( `employeeid` int(11) NOT NULL AUTO_INCREMENT, `lastname` varchar(35) NOT NULL, `firstname` varchar(35) NOT NULL, `gender` varchar(30) DEFAULT NULL, `maritalstatus` varchar(30) DEFAULT NULL, `nationality` varchar(50) NOT NULL, `birthday` date NOT NULL, `street` varchar(100) NOT NULL, `postcodeid` int(11) NOT NULL, `phone` varchar(50) DEFAULT NULL, `mobilephone` varchar(50) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `identificationid` int(11) NOT NULL, `jobstatusid` int(11) NOT NULL, PRIMARY KEY (`employeeid`), UNIQUE KEY `employee_unique` (`identificationid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `employee` -- LOCK TABLES `employee` WRITE; /*!40000 ALTER TABLE `employee` DISABLE KEYS */; /*!40000 ALTER TABLE `employee` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `identification` -- DROP TABLE IF EXISTS `identification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `identification` ( `identificationid` int(11) NOT NULL AUTO_INCREMENT, `number` varchar(50) NOT NULL, `expiry` date NOT NULL, `issued` date NOT NULL, `authority` varchar(50) NOT NULL, `typeid` int(11) NOT NULL, PRIMARY KEY (`identificationid`), UNIQUE KEY `identification_unique` (`number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `identification` -- LOCK TABLES `identification` WRITE; /*!40000 ALTER TABLE `identification` DISABLE KEYS */; /*!40000 ALTER TABLE `identification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `identificationtype` -- DROP TABLE IF EXISTS `identificationtype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `identificationtype` ( `typeid` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(50) NOT NULL, PRIMARY KEY (`typeid`), UNIQUE KEY `identificationtype_unique` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `identificationtype` -- LOCK TABLES `identificationtype` WRITE; /*!40000 ALTER TABLE `identificationtype` DISABLE KEYS */; /*!40000 ALTER TABLE `identificationtype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoice` -- DROP TABLE IF EXISTS `invoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoice` ( `invoiceid` int(11) NOT NULL AUTO_INCREMENT, `issued` date NOT NULL COMMENT 'Rechnungsdatum', `entry` date NOT NULL COMMENT 'Buchungsdatum', `contractid` int(11) NOT NULL, PRIMARY KEY (`invoiceid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoice` -- LOCK TABLES `invoice` WRITE; /*!40000 ALTER TABLE `invoice` DISABLE KEYS */; /*!40000 ALTER TABLE `invoice` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobdetail` -- DROP TABLE IF EXISTS `jobdetail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobdetail` ( `jobdetailid` int(11) NOT NULL AUTO_INCREMENT, `duration` decimal(10,0) NOT NULL, `objectid` int(11) NOT NULL, `period` varchar(15) NOT NULL, `personnel` int(11) NOT NULL DEFAULT 1 COMMENT 'number of employees', `price` decimal(10,0) NOT NULL, PRIMARY KEY (`jobdetailid`), UNIQUE KEY `jobdetail_unique` (`objectid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobdetail` -- LOCK TABLES `jobdetail` WRITE; /*!40000 ALTER TABLE `jobdetail` DISABLE KEYS */; /*!40000 ALTER TABLE `jobdetail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobstatus` -- DROP TABLE IF EXISTS `jobstatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobstatus` ( `jobstatusid` int(11) NOT NULL AUTO_INCREMENT, `description` varchar(30) NOT NULL, PRIMARY KEY (`jobstatusid`), UNIQUE KEY `jobstatus_unique` (`description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobstatus` -- LOCK TABLES `jobstatus` WRITE; /*!40000 ALTER TABLE `jobstatus` DISABLE KEYS */; /*!40000 ALTER TABLE `jobstatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `medicalcare` -- DROP TABLE IF EXISTS `medicalcare`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `medicalcare` ( `medicalcareid` int(11) NOT NULL AUTO_INCREMENT, `company` varchar(50) NOT NULL, PRIMARY KEY (`medicalcareid`), UNIQUE KEY `medicalcare_unique` (`company`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `medicalcare` -- LOCK TABLES `medicalcare` WRITE; /*!40000 ALTER TABLE `medicalcare` DISABLE KEYS */; /*!40000 ALTER TABLE `medicalcare` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `object` -- DROP TABLE IF EXISTS `object`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `object` ( `objectid` int(11) NOT NULL AUTO_INCREMENT, `street` varchar(100) NOT NULL, `postcodeid` int(11) NOT NULL, `contactpersonid` int(11) NOT NULL, `customerid` int(11) NOT NULL, PRIMARY KEY (`objectid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `object` -- LOCK TABLES `object` WRITE; /*!40000 ALTER TABLE `object` DISABLE KEYS */; /*!40000 ALTER TABLE `object` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `offer` -- DROP TABLE IF EXISTS `offer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `offer` ( `offerid` int(11) NOT NULL AUTO_INCREMENT, `jobdetailid` int(11) NOT NULL, `date` date NOT NULL, PRIMARY KEY (`offerid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `offer` -- LOCK TABLES `offer` WRITE; /*!40000 ALTER TABLE `offer` DISABLE KEYS */; /*!40000 ALTER TABLE `offer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `offers` -- DROP TABLE IF EXISTS `offers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `offers` ( `offerid` int(11) NOT NULL, `contractid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Kreuztabelle Angebot - Auftrag'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `offers` -- LOCK TABLES `offers` WRITE; /*!40000 ALTER TABLE `offers` DISABLE KEYS */; /*!40000 ALTER TABLE `offers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `office` -- DROP TABLE IF EXISTS `office`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `office` ( `officeid` int(11) NOT NULL AUTO_INCREMENT, `office` varchar(50) NOT NULL COMMENT 'Kostenstelle', PRIMARY KEY (`officeid`), UNIQUE KEY `office_unique` (`office`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Kostenstelle'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `office` -- LOCK TABLES `office` WRITE; /*!40000 ALTER TABLE `office` DISABLE KEYS */; /*!40000 ALTER TABLE `office` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `permissions` ( `permissionid` int(11) NOT NULL AUTO_INCREMENT, `permission` varchar(50) NOT NULL, PRIMARY KEY (`permissionid`), UNIQUE KEY `berechtigungen_unique` (`permission`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personalrole` -- DROP TABLE IF EXISTS `personalrole`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personalrole` ( `employeeid` int(11) NOT NULL, `roleid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Kreuztabelle'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personalrole` -- LOCK TABLES `personalrole` WRITE; /*!40000 ALTER TABLE `personalrole` DISABLE KEYS */; /*!40000 ALTER TABLE `personalrole` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `postcode` -- DROP TABLE IF EXISTS `postcode`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `postcode` ( `postcodeid` int(11) NOT NULL AUTO_INCREMENT, `postcode` varchar(15) NOT NULL, `addressid` int(11) NOT NULL, PRIMARY KEY (`postcodeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `postcode` -- LOCK TABLES `postcode` WRITE; /*!40000 ALTER TABLE `postcode` DISABLE KEYS */; /*!40000 ALTER TABLE `postcode` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role` -- DROP TABLE IF EXISTS `role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role` ( `roleid` int(11) NOT NULL AUTO_INCREMENT, `description` varchar(50) NOT NULL, PRIMARY KEY (`roleid`), UNIQUE KEY `role_unique` (`description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role` -- LOCK TABLES `role` WRITE; /*!40000 ALTER TABLE `role` DISABLE KEYS */; /*!40000 ALTER TABLE `role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `roles` ( `roleid` int(11) NOT NULL, `permissionid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `salestax` -- DROP TABLE IF EXISTS `salestax`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `salestax` ( `salestaxid` varchar(20) NOT NULL, `customerid` int(11) NOT NULL, PRIMARY KEY (`salestaxid`), UNIQUE KEY `salestax_unique` (`customerid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `salestax` -- LOCK TABLES `salestax` WRITE; /*!40000 ALTER TABLE `salestax` DISABLE KEYS */; /*!40000 ALTER TABLE `salestax` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `service` -- DROP TABLE IF EXISTS `service`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `service` ( `servicetypeid` int(11) NOT NULL, `servicedescid` int(11) NOT NULL, `objectid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `service` -- LOCK TABLES `service` WRITE; /*!40000 ALTER TABLE `service` DISABLE KEYS */; /*!40000 ALTER TABLE `service` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `servicedesc` -- DROP TABLE IF EXISTS `servicedesc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `servicedesc` ( `servicedescid` int(11) NOT NULL AUTO_INCREMENT, `description` varchar(1000) NOT NULL, PRIMARY KEY (`servicedescid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `servicedesc` -- LOCK TABLES `servicedesc` WRITE; /*!40000 ALTER TABLE `servicedesc` DISABLE KEYS */; /*!40000 ALTER TABLE `servicedesc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `servicetype` -- DROP TABLE IF EXISTS `servicetype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `servicetype` ( `servicetypeid` int(11) NOT NULL AUTO_INCREMENT, `description` varchar(50) NOT NULL, PRIMARY KEY (`servicetypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `servicetype` -- LOCK TABLES `servicetype` WRITE; /*!40000 ALTER TABLE `servicetype` DISABLE KEYS */; /*!40000 ALTER TABLE `servicetype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `socialsecurity` -- DROP TABLE IF EXISTS `socialsecurity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `socialsecurity` ( `employeeid` int(11) NOT NULL, `socialsecurityno` varchar(30) NOT NULL, `medicalcareid` int(11) NOT NULL, UNIQUE KEY `socialsecurity_unique` (`employeeid`), UNIQUE KEY `socialsecurity_unique_1` (`socialsecurityno`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `socialsecurity` -- LOCK TABLES `socialsecurity` WRITE; /*!40000 ALTER TABLE `socialsecurity` DISABLE KEYS */; /*!40000 ALTER TABLE `socialsecurity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tariff` -- DROP TABLE IF EXISTS `tariff`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tariff` ( `tariffid` int(11) NOT NULL AUTO_INCREMENT, `tariff` decimal(10,0) NOT NULL COMMENT 'Festgelegter Stundensatz', PRIMARY KEY (`tariffid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Stundensatz Tabelle'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tariff` -- LOCK TABLES `tariff` WRITE; /*!40000 ALTER TABLE `tariff` DISABLE KEYS */; /*!40000 ALTER TABLE `tariff` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `timetrack` -- DROP TABLE IF EXISTS `timetrack`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `timetrack` ( `employeeid` int(11) NOT NULL, `start` datetime NOT NULL, `stop` datetime NOT NULL, `vacation` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `timetrack` -- LOCK TABLES `timetrack` WRITE; /*!40000 ALTER TABLE `timetrack` DISABLE KEYS */; /*!40000 ALTER TABLE `timetrack` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'pyqcrm' -- /*!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 2024-10-29 13:20:21