thetool/db/schema/thetool.init.sql at ai/issue-6

Files

Frank Schubert aff469924e Fixed db migrations

2024-12-22 15:58:19 +01:00

2075 lines

102 KiB

SQL

Raw Permalink Blame History

 -- MySQL dump 10.13  Distrib 8.0.34, for Linux (x86_64)
 --
 -- Host: localhost    Database: thetool_empty
 -- ------------------------------------------------------
 -- Server version	8.0.34-0ubuntu0.22.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 */;
 /*!50503 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 */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Address` (
   `id` int NOT NULL AUTO_INCREMENT,
   `parent_id` int DEFAULT NULL,
   `customer_number` int DEFAULT NULL,
   `spin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `company` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `firstname` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `lastname` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `street` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `zip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `city` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `country` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `phone` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `fax` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `mobile` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `email` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `uid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `billing_type` enum('invoice','sepa') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `billing_delivery` enum('email','paper') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `bank_account_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `bank_account_owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `bank_account_iban` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `bank_account_bic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `allow_contact` tinyint NOT NULL DEFAULT '0',
   `allow_spin` tinyint NOT NULL DEFAULT '0',
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=5872 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Address`
 --
 LOCK TABLES `Address` WRITE;
 /*!40000 ALTER TABLE `Address` DISABLE KEYS */;
 INSERT INTO `Address` VALUES (1,NULL,NULL,NULL,'Xinon GmbH','','','Fladnitz im Raabtal 150','8322','Studenzen','Österreich','+43 3115 40800','','','office@xinon.at',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'the boss',1,1,1623788529,1634296936);
 /*!40000 ALTER TABLE `Address` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `AddressLink`
 --
 DROP TABLE IF EXISTS `AddressLink`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `AddressLink` (
   `id` int NOT NULL AUTO_INCREMENT,
   `address_id` int NOT NULL,
   `origin_address_id` int NOT NULL,
   `type` enum('billing','employee','customer','contact','techcontact') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `AddressLink`
 --
 LOCK TABLES `AddressLink` WRITE;
 /*!40000 ALTER TABLE `AddressLink` DISABLE KEYS */;
 /*!40000 ALTER TABLE `AddressLink` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Addressattribute`
 --
 DROP TABLE IF EXISTS `Addressattribute`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Addressattribute` (
   `id` int NOT NULL AUTO_INCREMENT,
   `address_id` int NOT NULL,
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `value` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Addressattribute`
 --
 LOCK TABLES `Addressattribute` WRITE;
 /*!40000 ALTER TABLE `Addressattribute` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Addressattribute` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Addresstype`
 --
 DROP TABLE IF EXISTS `Addresstype`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Addresstype` (
   `id` int NOT NULL AUTO_INCREMENT,
   `address_id` int NOT NULL,
   `type` enum('systemowner','productowner','netowner','salespartner','pipeworker','lineworker','pipeplanner','lineplanner','netoperator','support','billing','employee','customer','supplier','contact','techcontact') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `primary` tinyint(1) NOT NULL DEFAULT '0',
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Addresstype`
 --
 LOCK TABLES `Addresstype` WRITE;
 /*!40000 ALTER TABLE `Addresstype` DISABLE KEYS */;
 INSERT INTO `Addresstype` VALUES (1,1,'systemowner',1,'',1,1,1623788630,1623788630);
 /*!40000 ALTER TABLE `Addresstype` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Building`
 --
 DROP TABLE IF EXISTS `Building`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Building` (
   `id` int NOT NULL AUTO_INCREMENT,
   `adb_hausnummer_id` int DEFAULT NULL,
   `network_id` int NOT NULL,
   `pop_id` int DEFAULT NULL,
   `type_id` int NOT NULL,
   `status_id` int NOT NULL DEFAULT '1',
   `pipeworker_id` int DEFAULT NULL,
   `lineworker_id` int DEFAULT NULL,
   `networksection_id` int DEFAULT NULL,
   `pipework_enabled` int NOT NULL DEFAULT '0',
   `pipework_enabled_date` int DEFAULT NULL,
   `pipework_enabled_by` int DEFAULT NULL,
   `workflow_finished` int NOT NULL DEFAULT '0',
   `workflow_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `workflow_comment_changed` int DEFAULT NULL,
   `workflow_comment_changed_by` int DEFAULT NULL,
   `code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `oaid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `street` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `zip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `city` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `gps_lat` decimal(15,10) DEFAULT NULL,
   `gps_long` decimal(15,10) DEFAULT NULL,
   `laea` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `units` int NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Building`
 --
 LOCK TABLES `Building` WRITE;
 /*!40000 ALTER TABLE `Building` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Building` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `BuildingFile`
 --
 DROP TABLE IF EXISTS `BuildingFile`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `BuildingFile` (
   `id` int NOT NULL AUTO_INCREMENT,
   `building_id` int NOT NULL,
   `file_id` int NOT NULL,
   `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `BuildingFile`
 --
 LOCK TABLES `BuildingFile` WRITE;
 /*!40000 ALTER TABLE `BuildingFile` DISABLE KEYS */;
 /*!40000 ALTER TABLE `BuildingFile` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Buildingstatus`
 --
 DROP TABLE IF EXISTS `Buildingstatus`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Buildingstatus` (
   `id` int NOT NULL AUTO_INCREMENT,
   `code` int NOT NULL,
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Buildingstatus`
 --
 LOCK TABLES `Buildingstatus` WRITE;
 /*!40000 ALTER TABLE `Buildingstatus` DISABLE KEYS */;
 INSERT INTO `Buildingstatus` VALUES (1,10,'created',1,1,1626368257,1626368257),(2,20,'planned',1,1,1628189383,1628189383),(3,30,'assigned',1,1,1628189383,1628189383),(4,40,'passed',1,1,1628189453,1628189453),(5,50,'connected',1,1,1628189453,1628189453);
 /*!40000 ALTER TABLE `Buildingstatus` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Buildingtype`
 --
 DROP TABLE IF EXISTS `Buildingtype`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Buildingtype` (
   `id` int NOT NULL AUTO_INCREMENT,
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Buildingtype`
 --
 LOCK TABLES `Buildingtype` WRITE;
 /*!40000 ALTER TABLE `Buildingtype` DISABLE KEYS */;
 INSERT INTO `Buildingtype` VALUES (1,'Einfamilienhaus',1,1,1626210320,1626210320),(2,'Zweifamilienhaus',1,1,1626210357,1626210357),(3,'Mehrparteienhaus',1,1,1626210357,1626210357),(4,'Unternehmen',1,1,1626210357,1626210357),(5,'Senderstandort',1,1,1626210357,1626210357);
 /*!40000 ALTER TABLE `Buildingtype` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Cpeprovisioning`
 --
 DROP TABLE IF EXISTS `Cpeprovisioning`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Cpeprovisioning` (
   `id` int NOT NULL AUTO_INCREMENT,
   `termination_id` int DEFAULT NULL,
   `order_id` int DEFAULT NULL,
   `orderproduct_id` int DEFAULT NULL,
   `routerconfig_finished` tinyint NOT NULL DEFAULT '0',
   `order_journal_id` int DEFAULT NULL,
   `routertype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `shipping` tinyint NOT NULL DEFAULT '0',
   `shipping_date` int DEFAULT NULL,
   `external_finished` int DEFAULT NULL,
   `external_finished_by` int DEFAULT NULL,
   `shipped` tinyint NOT NULL DEFAULT '0',
   `shipped_by` int DEFAULT NULL,
   `cpeshippingfile_id` int DEFAULT NULL,
   `wifi_ssid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `wifi_pass` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `mac` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `vlan_public` int DEFAULT NULL,
   `vlan_nat` int DEFAULT NULL,
   `vlan_ipv6` int DEFAULT NULL,
   `ship_weight` int DEFAULT NULL COMMENT 'kg',
   `ship_length` int DEFAULT NULL COMMENT 'cm',
   `ship_width` int DEFAULT NULL COMMENT 'cm',
   `ship_height` int DEFAULT NULL COMMENT 'cm',
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `create_by` int NOT NULL,
   `create` int NOT NULL,
   `edit_by` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `orderproduct_id` (`orderproduct_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Cpeprovisioning`
 --
 LOCK TABLES `Cpeprovisioning` WRITE;
 /*!40000 ALTER TABLE `Cpeprovisioning` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Cpeprovisioning` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `CpeshippingFile`
 --
 DROP TABLE IF EXISTS `CpeshippingFile`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `CpeshippingFile` (
   `id` int NOT NULL AUTO_INCREMENT,
   `file_id` int NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `CpeshippingFile`
 --
 LOCK TABLES `CpeshippingFile` WRITE;
 /*!40000 ALTER TABLE `CpeshippingFile` DISABLE KEYS */;
 /*!40000 ALTER TABLE `CpeshippingFile` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Device`
 --
 DROP TABLE IF EXISTS `Device`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Device` (
   `id` int NOT NULL AUTO_INCREMENT,
   `devicetype_id` int NOT NULL,
   `pop_id` int DEFAULT NULL,
   `addr_street` varchar(128) DEFAULT NULL,
   `addr_number` varchar(32) DEFAULT NULL,
   `addr_extended` text,
   `addr_zip` varchar(16) DEFAULT NULL,
   `addr_city` varchar(128) DEFAULT NULL,
   `gps_lat` decimal(15,10) DEFAULT NULL,
   `gps_long` decimal(15,10) DEFAULT NULL,
   `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `mac` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `snmp_version` int DEFAULT NULL,
   `serial` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `price` decimal(10,2) NOT NULL DEFAULT '0.00',
   `power` decimal(10,1) NOT NULL DEFAULT '0.0',
   `last_config_backup` int DEFAULT NULL,
   `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Device`
 --
 LOCK TABLES `Device` WRITE;
 /*!40000 ALTER TABLE `Device` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Device` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Devicemanufactor`
 --
 DROP TABLE IF EXISTS `Devicemanufactor`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Devicemanufactor` (
   `id` int NOT NULL AUTO_INCREMENT,
   `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `config_backup` text,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Devicemanufactor`
 --
 LOCK TABLES `Devicemanufactor` WRITE;
 /*!40000 ALTER TABLE `Devicemanufactor` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Devicemanufactor` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Devicetype`
 --
 DROP TABLE IF EXISTS `Devicetype`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Devicetype` (
   `id` int NOT NULL AUTO_INCREMENT,
   `devicemanufactor_id` int NOT NULL,
   `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `olt` int DEFAULT NULL,
   `price` decimal(10,2) NOT NULL DEFAULT '0.00',
   `power` decimal(10,1) NOT NULL DEFAULT '0.0',
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Devicetype`
 --
 LOCK TABLES `Devicetype` WRITE;
 /*!40000 ALTER TABLE `Devicetype` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Devicetype` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `File`
 --
 DROP TABLE IF EXISTS `File`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `File` (
   `id` int NOT NULL AUTO_INCREMENT,
   `name` varchar(1024) NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
   `filename` varchar(1024) NOT NULL,
   `store_filename` varchar(1024) NOT NULL,
   `orig_filename` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
   `subfolder` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
   `mimetype` varchar(255) DEFAULT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `File`
 --
 LOCK TABLES `File` WRITE;
 /*!40000 ALTER TABLE `File` DISABLE KEYS */;
 /*!40000 ALTER TABLE `File` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Filestore`
 --
 DROP TABLE IF EXISTS `Filestore`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Filestore` (
   `id` int NOT NULL AUTO_INCREMENT,
   `file_id` int NOT NULL,
   `network_id` int NOT NULL,
   `name` varchar(1024) NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Filestore`
 --
 LOCK TABLES `Filestore` WRITE;
 /*!40000 ALTER TABLE `Filestore` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Filestore` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `FilestoreHistory`
 --
 DROP TABLE IF EXISTS `FilestoreHistory`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `FilestoreHistory` (
   `id` int NOT NULL AUTO_INCREMENT,
   `filestore_id` int NOT NULL,
   `file_id` int NOT NULL,
   `name` varchar(1024) NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `FilestoreHistory`
 --
 LOCK TABLES `FilestoreHistory` WRITE;
 /*!40000 ALTER TABLE `FilestoreHistory` DISABLE KEYS */;
 /*!40000 ALTER TABLE `FilestoreHistory` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Network`
 --
 DROP TABLE IF EXISTS `Network`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Network` (
   `id` int NOT NULL AUTO_INCREMENT,
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `owner_id` int NOT NULL,
   `adb_netzgebiet_id` int DEFAULT NULL,
   `sytemowner_action_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Network`
 --
 LOCK TABLES `Network` WRITE;
 /*!40000 ALTER TABLE `Network` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Network` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `NetworkAddress`
 --
 DROP TABLE IF EXISTS `NetworkAddress`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `NetworkAddress` (
   `id` int NOT NULL AUTO_INCREMENT,
   `network_id` int NOT NULL,
   `address_id` int NOT NULL,
   `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `NetworkAddress`
 --
 LOCK TABLES `NetworkAddress` WRITE;
 /*!40000 ALTER TABLE `NetworkAddress` DISABLE KEYS */;
 /*!40000 ALTER TABLE `NetworkAddress` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Networksection`
 --
 DROP TABLE IF EXISTS `Networksection`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Networksection` (
   `id` int NOT NULL AUTO_INCREMENT,
   `network_id` int NOT NULL,
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Networksection`
 --
 LOCK TABLES `Networksection` WRITE;
 /*!40000 ALTER TABLE `Networksection` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Networksection` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `News`
 --
 DROP TABLE IF EXISTS `News`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `News` (
   `id` int NOT NULL AUTO_INCREMENT,
   `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `News`
 --
 LOCK TABLES `News` WRITE;
 /*!40000 ALTER TABLE `News` DISABLE KEYS */;
 /*!40000 ALTER TABLE `News` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `OpenAccessId`
 --
 DROP TABLE IF EXISTS `OpenAccessId`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `OpenAccessId` (
   `id` int NOT NULL AUTO_INCREMENT,
   `active` tinyint NOT NULL DEFAULT '0',
   `oaid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
   `origin` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
   `origin_id` varchar(1024) DEFAULT NULL,
   `owner_id` int NOT NULL,
   `assigned` int NOT NULL DEFAULT '0',
   `adb_wohneinheit_id` int DEFAULT NULL,
   `termination_id` int DEFAULT NULL,
   `exported` int NOT NULL DEFAULT '0',
   `exported_to` varchar(1024) DEFAULT NULL,
   `export_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
   `address` text,
   `unit_string` varchar(1024) DEFAULT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `OpenAccessId`
 --
 LOCK TABLES `OpenAccessId` WRITE;
 /*!40000 ALTER TABLE `OpenAccessId` DISABLE KEYS */;
 /*!40000 ALTER TABLE `OpenAccessId` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Order`
 --
 DROP TABLE IF EXISTS `Order`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Order` (
   `id` int NOT NULL AUTO_INCREMENT,
   `waiting` tinyint NOT NULL DEFAULT '0',
   `owner_id` int DEFAULT NULL,
   `billingaddress_id` int DEFAULT NULL,
   `techcontact_id` int DEFAULT NULL,
   `upgrade` tinyint NOT NULL DEFAULT '0',
   `partner_number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `cpeprovisioning_enabled` tinyint NOT NULL DEFAULT '0',
   `order_date` int NOT NULL,
   `install_date` int DEFAULT NULL,
   `finish_date` int DEFAULT NULL COMMENT 'timestamp',
   `finish_after` int DEFAULT NULL,
   `finish_after_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `billing_type` enum('invoice','sepa') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `bank_account_bank` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `bank_account_owner` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `bank_account_iban` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `bank_account_bic` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `allow_contact` tinyint DEFAULT NULL,
   `allow_spin` tinyint DEFAULT NULL,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Order`
 --
 LOCK TABLES `Order` WRITE;
 /*!40000 ALTER TABLE `Order` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Order` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `OrderFile`
 --
 DROP TABLE IF EXISTS `OrderFile`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `OrderFile` (
   `id` int NOT NULL AUTO_INCREMENT,
   `order_id` int NOT NULL,
   `file_id` int NOT NULL,
   `name` varchar(1024) NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `OrderFile`
 --
 LOCK TABLES `OrderFile` WRITE;
 /*!40000 ALTER TABLE `OrderFile` DISABLE KEYS */;
 /*!40000 ALTER TABLE `OrderFile` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `OrderJournal`
 --
 DROP TABLE IF EXISTS `OrderJournal`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `OrderJournal` (
   `id` int NOT NULL AUTO_INCREMENT,
   `order_id` int NOT NULL,
   `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `OrderJournal`
 --
 LOCK TABLES `OrderJournal` WRITE;
 /*!40000 ALTER TABLE `OrderJournal` DISABLE KEYS */;
 /*!40000 ALTER TABLE `OrderJournal` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `OrderProduct`
 --
 DROP TABLE IF EXISTS `OrderProduct`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `OrderProduct` (
   `id` int NOT NULL AUTO_INCREMENT,
   `order_id` int NOT NULL,
   `product_id` int DEFAULT NULL,
   `termination_id` int DEFAULT NULL,
   `voicenumber` json DEFAULT NULL,
   `upgrade` tinyint NOT NULL DEFAULT '0',
   `amount` decimal(9,6) NOT NULL DEFAULT '1.000000',
   `pos` int NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `price` decimal(14,4) NOT NULL DEFAULT '0.0000',
   `price_setup` decimal(14,4) NOT NULL DEFAULT '0.0000',
   `price_nne` decimal(14,4) DEFAULT '0.0000',
   `price_nbe` decimal(14,4) DEFAULT '0.0000',
   `billing_delay` int NOT NULL DEFAULT '0' COMMENT 'in months',
   `billing_period` int NOT NULL COMMENT 'in months',
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `OrderProduct`
 --
 LOCK TABLES `OrderProduct` WRITE;
 /*!40000 ALTER TABLE `OrderProduct` DISABLE KEYS */;
 /*!40000 ALTER TABLE `OrderProduct` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Patching`
 --
 DROP TABLE IF EXISTS `Patching`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Patching` (
   `id` int NOT NULL AUTO_INCREMENT,
   `termination_id` int NOT NULL,
   `linework_port` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Port ODF',
   `device_type` enum('splitter','pon','switch') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Splitter/Shared PON-Port/Switch',
   `device_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Bezeichnung',
   `device_port` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `patched` int NOT NULL DEFAULT '0',
   `patched_by` int DEFAULT NULL,
   `patched_date` int DEFAULT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Patching`
 --
 LOCK TABLES `Patching` WRITE;
 /*!40000 ALTER TABLE `Patching` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Patching` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Pop`
 --
 DROP TABLE IF EXISTS `Pop`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Pop` (
   `id` int NOT NULL AUTO_INCREMENT,
   `network_id` int NOT NULL,
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `gps_lat` decimal(15,10) DEFAULT NULL,
   `gps_long` decimal(15,10) DEFAULT NULL,
   `location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `vlan_public` int DEFAULT NULL,
   `vlan_nat` int DEFAULT NULL,
   `vlan_ipv6` int DEFAULT NULL,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Pop`
 --
 LOCK TABLES `Pop` WRITE;
 /*!40000 ALTER TABLE `Pop` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Pop` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Preorder`
 --
 DROP TABLE IF EXISTS `Preorder`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Preorder` (
   `id` int NOT NULL AUTO_INCREMENT,
   `ucode` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `status_id` int NOT NULL DEFAULT '1',
   `preordercampaign_id` int NOT NULL,
   `adb_hausnummer_id` int DEFAULT NULL,
   `adb_wohneinheit_id` int DEFAULT NULL,
   `address_created` int DEFAULT NULL,
   `address_created_by` int DEFAULT NULL,
   `oaid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `extref` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `address_district` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `address_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `building_id` int DEFAULT NULL,
   `termination_id` int DEFAULT NULL,
   `connection_type` enum('single-dwelling','multi-dwelling','apartment-building','apartment','business') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `connection_count` tinyint NOT NULL DEFAULT '1',
   `product_id` int DEFAULT NULL,
   `setup_product_id` int DEFAULT NULL,
   `type` enum('interest','provision','order','reorder') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `order_id` int DEFAULT NULL,
   `price` decimal(14,4) DEFAULT NULL,
   `price_setup` decimal(14,4) DEFAULT NULL,
   `price_nne` decimal(14,4) DEFAULT NULL,
   `price_nbe` decimal(14,4) DEFAULT NULL,
   `billing_delay` int DEFAULT NULL COMMENT 'in months',
   `billing_period` int DEFAULT NULL COMMENT 'in months',
   `partner_id` int DEFAULT NULL,
   `accept_agb` tinyint NOT NULL DEFAULT '0',
   `accept_dsgvo` tinyint NOT NULL DEFAULT '0',
   `accept_marketing` tinyint NOT NULL DEFAULT '0',
   `accept_withdrawal` tinyint NOT NULL DEFAULT '0',
   `accept_digging` tinyint NOT NULL DEFAULT '0',
   `contact_type` enum('tenant','owner') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `company` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `uid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `firstname` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `lastname` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `street` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `housenumber` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `block` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `stiege` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `stock` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `tuer` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `unit_string` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `zip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `city` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `phone` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `email` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `shipping_address` enum('address','customer') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'customer',
   `technology` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `patchposition` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `is_additional_order` tinyint NOT NULL DEFAULT '0',
   `addon_services` json DEFAULT NULL,
   `addon_data` json DEFAULT NULL,
   `attributes` json DEFAULT NULL,
   `submit_type` enum('web','api','import') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'web',
   `submit_request` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `workorder_export_date` int DEFAULT NULL,
   `workorder_export_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `cancel_request` int DEFAULT NULL,
   `cancel_request_by` int DEFAULT NULL,
   `cancel_approved` int DEFAULT NULL,
   `cancel_approved_by` int DEFAULT NULL,
   `deleted` int NOT NULL DEFAULT '0',
   `deleted_by` int DEFAULT NULL,
   `delete_reason` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Preorder`
 --
 LOCK TABLES `Preorder` WRITE;
 /*!40000 ALTER TABLE `Preorder` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Preorder` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Preordercampaign`
 --
 DROP TABLE IF EXISTS `Preordercampaign`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Preordercampaign` (
   `id` int NOT NULL AUTO_INCREMENT,
   `network_id` int NOT NULL,
   `homes_total` int NOT NULL DEFAULT '0',
   `fulfillment` enum('thetool','thirdparty','rimo') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'thetool',
   `product_type` enum('all','setup_only') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'all',
   `oaid_origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'thetool',
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `area` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `from` int NOT NULL,
   `to` int NOT NULL,
   `required_preorder_fields` json DEFAULT NULL,
   `district_is_city` tinyint NOT NULL DEFAULT '0',
   `hausnummer_add_zusatz` tinyint NOT NULL DEFAULT '0',
   `exist_is_error` tinyint NOT NULL DEFAULT '0',
   `require_connectiontype` tinyint NOT NULL DEFAULT '1',
   `allow_unit_update` tinyint NOT NULL DEFAULT '0',
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Preordercampaign`
 --
 LOCK TABLES `Preordercampaign` WRITE;
 /*!40000 ALTER TABLE `Preordercampaign` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Preordercampaign` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `PreordercampaignApiuser`
 --
 DROP TABLE IF EXISTS `PreordercampaignApiuser`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `PreordercampaignApiuser` (
   `id` int NOT NULL AUTO_INCREMENT,
   `preordercampaign_id` int NOT NULL,
   `worker_id` int NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `PreordercampaignApiuser`
 --
 LOCK TABLES `PreordercampaignApiuser` WRITE;
 /*!40000 ALTER TABLE `PreordercampaignApiuser` DISABLE KEYS */;
 /*!40000 ALTER TABLE `PreordercampaignApiuser` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `PreordercampaignOriginhostname`
 --
 DROP TABLE IF EXISTS `PreordercampaignOriginhostname`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `PreordercampaignOriginhostname` (
   `id` int NOT NULL AUTO_INCREMENT,
   `preordercampaign_id` int NOT NULL,
   `hostname` varchar(255) NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `PreordercampaignOriginhostname`
 --
 LOCK TABLES `PreordercampaignOriginhostname` WRITE;
 /*!40000 ALTER TABLE `PreordercampaignOriginhostname` DISABLE KEYS */;
 /*!40000 ALTER TABLE `PreordercampaignOriginhostname` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `PreordercampaignSalescluster`
 --
 DROP TABLE IF EXISTS `PreordercampaignSalescluster`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `PreordercampaignSalescluster` (
   `id` int NOT NULL AUTO_INCREMENT,
   `preordercampaign_id` int NOT NULL,
   `salescluster_id` int NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `PreordercampaignSalescluster`
 --
 LOCK TABLES `PreordercampaignSalescluster` WRITE;
 /*!40000 ALTER TABLE `PreordercampaignSalescluster` DISABLE KEYS */;
 /*!40000 ALTER TABLE `PreordercampaignSalescluster` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `PreordercampaignType`
 --
 DROP TABLE IF EXISTS `PreordercampaignType`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `PreordercampaignType` (
   `id` int NOT NULL AUTO_INCREMENT,
   `preordercampaign_id` int NOT NULL,
   `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `PreordercampaignType`
 --
 LOCK TABLES `PreordercampaignType` WRITE;
 /*!40000 ALTER TABLE `PreordercampaignType` DISABLE KEYS */;
 /*!40000 ALTER TABLE `PreordercampaignType` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Preordernotification`
 --
 DROP TABLE IF EXISTS `Preordernotification`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Preordernotification` (
   `id` int NOT NULL AUTO_INCREMENT,
   `sender_email` varchar(255) NOT NULL,
   `sender_name` varchar(255) NOT NULL,
   `sender_replyto` varchar(255) NOT NULL,
   `subject` varchar(1024) NOT NULL,
   `body_text` text,
   `body_html` text,
   `tosend_date` int DEFAULT NULL,
   `send_start` int DEFAULT NULL,
   `send_finish` int DEFAULT NULL,
   `recipient_count` int DEFAULT NULL,
   `preordercampaign_id` int DEFAULT NULL,
   `preorder_filter` json DEFAULT NULL,
   `send_lock` int DEFAULT NULL,
   `note` text,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Preordernotification`
 --
 LOCK TABLES `Preordernotification` WRITE;
 /*!40000 ALTER TABLE `Preordernotification` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Preordernotification` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `PreordernotificationFile`
 --
 DROP TABLE IF EXISTS `PreordernotificationFile`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `PreordernotificationFile` (
   `id` int NOT NULL AUTO_INCREMENT,
   `preordernotification_id` int NOT NULL,
   `file_id` int NOT NULL,
   `filename` varchar(1024) NOT NULL,
   `create_by` int NOT NULL,
   `create` int NOT NULL,
   `edit_by` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `PreordernotificationFile`
 --
 LOCK TABLES `PreordernotificationFile` WRITE;
 /*!40000 ALTER TABLE `PreordernotificationFile` DISABLE KEYS */;
 /*!40000 ALTER TABLE `PreordernotificationFile` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `PreordernotificationLog`
 --
 DROP TABLE IF EXISTS `PreordernotificationLog`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `PreordernotificationLog` (
   `id` int NOT NULL AUTO_INCREMENT,
   `preordernotification_id` int NOT NULL,
   `preorder_id` int NOT NULL,
   `email` varchar(255) NOT NULL,
   `sent` int DEFAULT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `PreordernotificationLog`
 --
 LOCK TABLES `PreordernotificationLog` WRITE;
 /*!40000 ALTER TABLE `PreordernotificationLog` DISABLE KEYS */;
 /*!40000 ALTER TABLE `PreordernotificationLog` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Preorderstatus`
 --
 DROP TABLE IF EXISTS `Preorderstatus`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Preorderstatus` (
   `id` int NOT NULL AUTO_INCREMENT,
   `code` int NOT NULL,
   `name` varchar(64) NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Preorderstatus`
 --
 LOCK TABLES `Preorderstatus` WRITE;
 /*!40000 ALTER TABLE `Preorderstatus` DISABLE KEYS */;
 INSERT INTO `Preorderstatus` VALUES (1,10,'new',1,1,1670245776,1670245776),(2,110,'Underground construction planning',1,1,1670374185,1670374185),(3,120,'Underground construction planning finished',1,1,1670374185,1670374185),(4,130,'Underground construction work assigned',1,1,1670374185,1670374185),(5,140,'Conduit at property border',1,1,1670374185,1670374185),(6,200,'Conduit in building',1,1,1670374185,1670374185),(7,210,'Fiber planning',1,1,1670374185,1670374185),(8,220,'Fiber planning finished',1,1,1670374185,1670374185),(9,230,'Fiber installation work assigned',1,1,1670374185,1670374185),(10,240,'Fiber in building',1,1,1670374185,1670374185),(11,250,'ONT ready',1,1,1670374185,1670374185),(12,260,'ONT picked up or shipped',1,1,1670374185,1670374185),(13,300,'ONT installed',1,1,1670374185,1670374185),(14,500,'Finished',1,1,1670374185,1670374185),(15,899,'Cancelled',1,1,1671025613,1671025613),(16,235,'Fiber on property line',1,1,1677511323,1677511323),(17,245,'OTO installed',1,1,1677511323,1677511323);
 /*!40000 ALTER TABLE `Preorderstatus` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Product`
 --
 DROP TABLE IF EXISTS `Product`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Product` (
   `id` int NOT NULL AUTO_INCREMENT,
   `active` tinyint NOT NULL DEFAULT '1',
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `sla_id` int DEFAULT NULL,
   `external` tinyint(1) NOT NULL DEFAULT '0',
   `external_id` int DEFAULT NULL,
   `producttech_id` int DEFAULT NULL,
   `productgroup_id` int DEFAULT NULL,
   `price_nne` decimal(14,4) DEFAULT NULL,
   `price_nbe` decimal(14,4) DEFAULT NULL,
   `price` decimal(14,4) NOT NULL,
   `price_setup` decimal(14,4) NOT NULL DEFAULT '0.0000',
   `billing_delay` int NOT NULL DEFAULT '0' COMMENT 'in months',
   `billing_period` int NOT NULL COMMENT 'in months',
   `ivt_id` int DEFAULT NULL,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Product`
 --
 LOCK TABLES `Product` WRITE;
 /*!40000 ALTER TABLE `Product` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Product` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `ProductAttribute`
 --
 DROP TABLE IF EXISTS `ProductAttribute`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `ProductAttribute` (
   `id` int NOT NULL AUTO_INCREMENT,
   `product_id` int NOT NULL,
   `producttechattribute_id` int NOT NULL,
   `value` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `product_id` (`product_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `ProductAttribute`
 --
 LOCK TABLES `ProductAttribute` WRITE;
 /*!40000 ALTER TABLE `ProductAttribute` DISABLE KEYS */;
 /*!40000 ALTER TABLE `ProductAttribute` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `ProductNetwork`
 --
 DROP TABLE IF EXISTS `ProductNetwork`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `ProductNetwork` (
   `id` int NOT NULL AUTO_INCREMENT,
   `product_id` int NOT NULL,
   `network_id` int NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `ProductNetwork`
 --
 LOCK TABLES `ProductNetwork` WRITE;
 /*!40000 ALTER TABLE `ProductNetwork` DISABLE KEYS */;
 /*!40000 ALTER TABLE `ProductNetwork` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Productgroup`
 --
 DROP TABLE IF EXISTS `Productgroup`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Productgroup` (
   `id` int NOT NULL AUTO_INCREMENT,
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Productgroup`
 --
 LOCK TABLES `Productgroup` WRITE;
 /*!40000 ALTER TABLE `Productgroup` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Productgroup` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Producttech`
 --
 DROP TABLE IF EXISTS `Producttech`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Producttech` (
   `id` int NOT NULL AUTO_INCREMENT,
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `customer_type` enum('residential','business') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'residential',
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Producttech`
 --
 LOCK TABLES `Producttech` WRITE;
 /*!40000 ALTER TABLE `Producttech` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Producttech` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `ProducttechAttribute`
 --
 DROP TABLE IF EXISTS `ProducttechAttribute`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `ProducttechAttribute` (
   `id` int NOT NULL AUTO_INCREMENT,
   `producttech_id` int NOT NULL,
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `displayname` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `value` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `ProducttechAttribute`
 --
 LOCK TABLES `ProducttechAttribute` WRITE;
 /*!40000 ALTER TABLE `ProducttechAttribute` DISABLE KEYS */;
 /*!40000 ALTER TABLE `ProducttechAttribute` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `RimoWorkorder`
 --
 DROP TABLE IF EXISTS `RimoWorkorder`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `RimoWorkorder` (
   `id` int NOT NULL AUTO_INCREMENT,
   `adb_wohneinheit_id` int DEFAULT NULL,
   `termination_id` int DEFAULT NULL,
   `rimo_id` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
   `rimo_name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
   `rimo_status` varchar(64) NOT NULL DEFAULT 'Accepted',
   `create_data` text,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `RimoWorkorder`
 --
 LOCK TABLES `RimoWorkorder` WRITE;
 /*!40000 ALTER TABLE `RimoWorkorder` DISABLE KEYS */;
 /*!40000 ALTER TABLE `RimoWorkorder` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Sla`
 --
 DROP TABLE IF EXISTS `Sla`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Sla` (
   `id` int NOT NULL AUTO_INCREMENT,
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Sla`
 --
 LOCK TABLES `Sla` WRITE;
 /*!40000 ALTER TABLE `Sla` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Sla` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Termination`
 --
 DROP TABLE IF EXISTS `Termination`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Termination` (
   `id` int NOT NULL AUTO_INCREMENT,
   `adb_wohneinheit_id` int DEFAULT NULL,
   `building_id` int NOT NULL,
   `status_id` int NOT NULL,
   `linework_enabled` int NOT NULL DEFAULT '0',
   `linework_enabled_date` int DEFAULT NULL,
   `linework_enabled_by` int DEFAULT NULL,
   `linework_doku_delay` tinyint NOT NULL DEFAULT '0',
   `workflow_finished` int NOT NULL DEFAULT '0',
   `workflow_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `workflow_comment_changed` int DEFAULT NULL,
   `workflow_comment_changed_by` int DEFAULT NULL,
   `patching_enabled` tinyint NOT NULL DEFAULT '0',
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `oaid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `rimo_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `contact` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `phone` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `email` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Termination`
 --
 LOCK TABLES `Termination` WRITE;
 /*!40000 ALTER TABLE `Termination` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Termination` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `TerminationFile`
 --
 DROP TABLE IF EXISTS `TerminationFile`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `TerminationFile` (
   `id` int NOT NULL AUTO_INCREMENT,
   `termination_id` int NOT NULL,
   `file_id` int NOT NULL,
   `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `TerminationFile`
 --
 LOCK TABLES `TerminationFile` WRITE;
 /*!40000 ALTER TABLE `TerminationFile` DISABLE KEYS */;
 /*!40000 ALTER TABLE `TerminationFile` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `TerminationWorkflow`
 --
 DROP TABLE IF EXISTS `TerminationWorkflow`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `TerminationWorkflow` (
   `id` int NOT NULL AUTO_INCREMENT,
   `building_id` int DEFAULT NULL,
   `building_code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `network_id` int DEFAULT NULL,
   `network_name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `networksection_name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `buildingtype_id` int DEFAULT NULL,
   `buildingtype_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `units` int DEFAULT NULL,
   `street` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `zip` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `city` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `pop_name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `pop_gps_lat` decimal(15,10) DEFAULT NULL,
   `pop_gps_long` decimal(15,10) DEFAULT NULL,
   `building_gps_lat` decimal(15,10) DEFAULT NULL,
   `building_gps_long` decimal(15,10) DEFAULT NULL,
   `laea` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `buildingstatus_code` int DEFAULT NULL,
   `buildingstatus_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `schrank` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `rohrverband` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `rohrtype` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `rohrfarbe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `termination_id` int NOT NULL DEFAULT '0',
   `termination_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `abschlusstyp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `bb_kabel` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `bb_kabel_steps` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `bb_fasern` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `kundenkabel_typ` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `kundenkabel_fasern` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `backbone_finished` int DEFAULT NULL,
   `inhouse_cabling_supplied` int DEFAULT NULL,
   `inhouse_cabling_deployed` int DEFAULT NULL,
   `bep_deployed` int DEFAULT NULL,
   `customer_cable_injected` int DEFAULT NULL,
   `spliced_network` int DEFAULT NULL,
   `spliced_customer` int DEFAULT NULL,
   `ont_deployed` int DEFAULT NULL,
   `ont_sn` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `customer_passive_finished` int DEFAULT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `TerminationWorkflow`
 --
 LOCK TABLES `TerminationWorkflow` WRITE;
 /*!40000 ALTER TABLE `TerminationWorkflow` DISABLE KEYS */;
 /*!40000 ALTER TABLE `TerminationWorkflow` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Temporary view structure for view `TerminationWorkflow_live`
 --
 DROP TABLE IF EXISTS `TerminationWorkflow_live`;
 /*!50001 DROP VIEW IF EXISTS `TerminationWorkflow_live`*/;
 SET @saved_cs_client     = @@character_set_client;
 /*!50503 SET character_set_client = utf8mb4 */;
 /*!50001 CREATE VIEW `TerminationWorkflow_live` AS SELECT
 AS `building_id`,
 AS `building_code`,
 AS `network_id`,
 AS `network_name`,
 AS `networksection_name`,
 AS `buildingtype_id`,
 AS `buildingtype_name`,
 AS `units`,
 AS `street`,
 AS `zip`,
 AS `city`,
 AS `pop_name`,
 AS `pop_gps_lat`,
 AS `pop_gps_long`,
 AS `building_gps_lat`,
 AS `building_gps_long`,
 AS `laea`,
 AS `buildingstatus_code`,
 AS `buildingstatus_name`,
 AS `schrank`,
 AS `rohrverband`,
 AS `rohrtype`,
 AS `rohrfarbe`,
 AS `termination_id`,
 AS `terminstaion_code`,
 AS `abschlusstyp`,
 AS `bb_kabel`,
 AS `bb_kabel_steps`,
 AS `bb_fasern`,
 AS `kundenkabel_typ`,
 AS `kundenkabel_fasern`,
 AS `backbone_finished`,
 AS `inhouse_cabling_supplied`,
 AS `inhouse_cabling_deployed`,
 AS `bep_deployed`,
 AS `customer_cable_injected`,
 AS `spliced_network`,
 AS `spliced_customer`,
 AS `ont_deployed`,
 AS `ont_sn`,
 AS `customer_passive_finished`*/;
 SET character_set_client = @saved_cs_client;
 --
 -- Table structure for table `Terminationstatus`
 --
 DROP TABLE IF EXISTS `Terminationstatus`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Terminationstatus` (
   `id` int NOT NULL AUTO_INCREMENT,
   `code` int NOT NULL,
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Terminationstatus`
 --
 LOCK TABLES `Terminationstatus` WRITE;
 /*!40000 ALTER TABLE `Terminationstatus` DISABLE KEYS */;
 INSERT INTO `Terminationstatus` VALUES (1,10,'created',1,1,1626988046,1626988046),(2,20,'planned',1,1,1628189823,1628189823),(3,30,'assigned',1,1,1628189823,1628189823),(4,40,'passed',1,1,1628189823,1628189823),(5,50,'connected',1,1,1628189823,1628189823),(6,60,'active',1,1,1628189823,1628189823);
 /*!40000 ALTER TABLE `Terminationstatus` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Worker`
 --
 DROP TABLE IF EXISTS `Worker`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Worker` (
   `id` int NOT NULL AUTO_INCREMENT,
   `address_id` int DEFAULT NULL,
   `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
   `password` varchar(56) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
   `mobile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `twofactor` int NOT NULL DEFAULT '0' COMMENT '0:aus;1:mail;2:mobile',
   `twofactorcode` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `twofactortimestamp` int DEFAULT NULL,
   `apikey` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
   `sessionid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Worker`
 --
 LOCK TABLES `Worker` WRITE;
 /*!40000 ALTER TABLE `Worker` DISABLE KEYS */;
 INSERT INTO `Worker` VALUES (1,1,'admin','3beff06825720727fa99fc75c979f751510d5a87042b8ade66ccb693','Reginald Oot','admin@localhost',NULL,0,NULL,NULL,NULL,NULL,NULL,1,1,1693985051,1693985051);
 /*!40000 ALTER TABLE `Worker` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `WorkerFlag`
 --
 DROP TABLE IF EXISTS `WorkerFlag`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `WorkerFlag` (
   `id` int NOT NULL AUTO_INCREMENT,
   `worker_id` int NOT NULL,
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `WorkerFlag`
 --
 LOCK TABLES `WorkerFlag` WRITE;
 /*!40000 ALTER TABLE `WorkerFlag` DISABLE KEYS */;
 /*!40000 ALTER TABLE `WorkerFlag` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `WorkerPermission`
 --
 DROP TABLE IF EXISTS `WorkerPermission`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `WorkerPermission` (
   `id` int NOT NULL AUTO_INCREMENT,
   `worker_id` int NOT NULL,
   `admin` enum('false','true') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',
   `preorderfront` enum('false','true') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',
   `technician` enum('false','true') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT 'false',
   `preorderaddressreporting` enum('false','true') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'false',
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `WorkerPermission`
 --
 LOCK TABLES `WorkerPermission` WRITE;
 /*!40000 ALTER TABLE `WorkerPermission` DISABLE KEYS */;
 INSERT INTO `WorkerPermission` VALUES (1,1,'true','false','false','false',1693985051,1693985051);
 /*!40000 ALTER TABLE `WorkerPermission` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `WorkerToken`
 --
 DROP TABLE IF EXISTS `WorkerToken`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `WorkerToken` (
   `id` int NOT NULL AUTO_INCREMENT,
   `worker_id` int NOT NULL,
   `selector` varchar(64) NOT NULL,
   `token` varchar(64) NOT NULL,
   `token_expire` int NOT NULL,
   `create_by` int NOT NULL,
   `create` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `selector` (`selector`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `WorkerToken`
 --
 LOCK TABLES `WorkerToken` WRITE;
 /*!40000 ALTER TABLE `WorkerToken` DISABLE KEYS */;
 /*!40000 ALTER TABLE `WorkerToken` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `WorkflowExport`
 --
 DROP TABLE IF EXISTS `WorkflowExport`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `WorkflowExport` (
   `id` int NOT NULL AUTO_INCREMENT,
   `uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `progress` int NOT NULL DEFAULT '0',
   `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `create_by` int NOT NULL,
   `create` int NOT NULL,
   `edit_by` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `WorkflowExport`
 --
 LOCK TABLES `WorkflowExport` WRITE;
 /*!40000 ALTER TABLE `WorkflowExport` DISABLE KEYS */;
 /*!40000 ALTER TABLE `WorkflowExport` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Workflowitem`
 --
 DROP TABLE IF EXISTS `Workflowitem`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Workflowitem` (
   `id` int NOT NULL AUTO_INCREMENT,
   `num` int NOT NULL DEFAULT '0',
   `object_type` enum('Building','Termination') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Building',
   `active` int NOT NULL DEFAULT '1',
   `visible` int NOT NULL DEFAULT '1',
   `required` int NOT NULL DEFAULT '1',
   `width` int NOT NULL DEFAULT '1',
   `name` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `label` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `type` enum('string','int','bool','enum','text','file','gps','color','delimiter','date','empty') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'string',
   `typedata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `placeholder` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `name` (`name`(2)) USING BTREE
 ) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Workflowitem`
 --
 LOCK TABLES `Workflowitem` WRITE;
 /*!40000 ALTER TABLE `Workflowitem` DISABLE KEYS */;
 INSERT INTO `Workflowitem` VALUES (1,10,'Building',1,1,1,1,'anschlusspunkt_typ','AP Typ',NULL,'enum','Schacht;Verteiler',NULL,1,1,1629830231,1629830231),(2,20,'Building',1,1,1,1,'anschlusspunkt_name','AP Name',NULL,'string',NULL,'Anschlusspunkt',1,1,1629830231,1629830231),(3,30,'Building',1,1,0,2,'anschlusspunkt_gps','AP Koordinaten',NULL,'gps',NULL,NULL,1,1,1629830362,1629830362),(4,40,'Building',1,1,1,1,'rohrverband_name','Rohrverband',NULL,'string',NULL,NULL,1,1,1629830534,1629830534),(5,50,'Building',1,1,1,1,'rohrtype','Rohrtype',NULL,'enum','MR7/4;MR14/10;MR16/12;MR20/16;KSR32;KSR40;KSR50;Andere Type',NULL,1,1,1629830534,1629830534),(6,100,'Building',0,0,0,1,'delimiter2','',NULL,'delimiter',NULL,NULL,1,1,1629830913,1629830913),(7,110,'Building',1,1,0,1,'genehmigung_vorhanden','Bewilligungen',NULL,'bool',NULL,NULL,1,1,1629836525,1629836525),(8,120,'Building',1,1,0,1,'bautermin','Bautermin',NULL,'date',NULL,NULL,1,1,1629838615,1629838615),(9,130,'Building',1,1,0,1,'delimiter','Ist-Zustand',NULL,'delimiter',NULL,NULL,1,1,1629838832,1629838832),(10,5,'Building',1,1,0,1,'delimiter1','Planung',NULL,'delimiter',NULL,NULL,1,1,1629839182,1629839182),(11,210,'Building',1,1,0,1,'ist_anschlusspunkt_typ','AP Typ',NULL,'enum','Schacht;Verteiler',NULL,1,1,1629830231,1629830231),(12,220,'Building',1,1,0,1,'ist_anschlusspunkt_name','AP Name',NULL,'string',NULL,'Anschlusspunkt',1,1,1629830231,1629830231),(13,230,'Building',1,1,0,2,'ist_anschlusspunkt_gps','AP Koordinaten',NULL,'gps',NULL,NULL,1,1,1629830362,1629830362),(14,240,'Building',1,1,0,1,'ist_rohrverband_name','Rohrverband',NULL,'string',NULL,NULL,1,1,1629830534,1629830534),(15,250,'Building',1,1,0,1,'ist_rohrtype','Rohrtype',NULL,'enum','MR7/4;MR14/10;MR16/12;MR20/16;KSR32;KSR40;KSR50;Andere Type',NULL,1,1,1629830534,1629830534),(16,60,'Building',1,1,1,1,'rohrfarbe','Rohrfarbe',NULL,'color',NULL,NULL,1,1,1629841392,1629841392),(17,297,'Building',1,1,0,1,'ist_rohrfarbe','Rohrfarbe',NULL,'color',NULL,NULL,1,1,1629841483,1629841483),(18,298,'Building',1,1,0,1,'','',NULL,'empty',NULL,NULL,1,1,1629841483,1629841483),(19,299,'Building',1,1,1,1,'pipework_finished','<!--class: text-success-->Tiefbau abgeschlossen',NULL,'enum','im Gebäude;am Grundstück',NULL,1,1,1629841483,1629841483),(20,10,'Termination',1,1,1,1,'pop_id','POP',NULL,'enum','=Model=Pop:network_id=`term->building->network_id`:',NULL,1,1,1631041042,1631041042),(21,20,'Termination',1,1,1,1,'schrank','Schrank',NULL,'string',NULL,NULL,1,1,1631045329,1631045329),(22,30,'Termination',1,1,1,1,'baugruppe','HE/Einschub',NULL,'string',NULL,NULL,1,1,1631045413,1631045413),(23,5,'Termination',1,1,0,1,'delimiter1','Planung',NULL,'delimiter',NULL,NULL,1,1,1631045457,1631045457),(24,40,'Termination',1,1,1,1,'modul','Modul',NULL,'string',NULL,NULL,1,1,1631045536,1631045536),(25,50,'Termination',1,1,1,1,'ports','Ports',NULL,'string',NULL,NULL,1,1,1631045646,1631045646),(26,60,'Termination',1,1,1,1,'abschlusstyp','Abschlusstyp',NULL,'enum','SC/APC in FTU;SC/APC im BEP;SC/APC 19 Zoll;LC/APC 19 Zoll;E2/APC 19 Zoll',NULL,1,1,1631045716,1631045716),(27,70,'Termination',1,1,1,1,'bb_kabel','BB-Kabel',NULL,'string',NULL,NULL,1,1,1631045771,1631045771),(28,80,'Termination',1,1,1,1,'bb_fasern','BB-Fasern',NULL,'string',NULL,NULL,1,1,1631045841,1631045841),(29,90,'Termination',1,1,1,1,'kundenkabel_typ','Kundenkabel-Typ',NULL,'enum','4f-G.657-2,5mm;12f-G.657-2,5mm;12f-G.657-5,3mm;24f-G.657-5,3mm;48f-G.657-6,0mm',NULL,1,1,1631045911,1631045911),(30,100,'Termination',1,1,1,1,'kundenkabel_fasern','Fasern im KU-Kabel',NULL,'string',NULL,NULL,1,1,1631045964,1631045964),(31,1100,'Termination',1,1,1,1,'ist_kundenkabel_fasern','Fasern im KU-Kabel',NULL,'string',NULL,NULL,1,1,1631045964,1631045964),(32,1090,'Termination',1,1,1,1,'ist_kundenkabel_typ','Kundenkabel-Typ',NULL,'enum','4f-G.657-2,5mm;12f-G.657-2,5mm;12f-G.657-5,3mm;24f-G.657-5,3mm;48f-G.657-6,0mm',NULL,1,1,1631045911,1631045911),(33,1080,'Termination',1,1,1,1,'ist_bb_fasern','BB-Fasern',NULL,'string',NULL,NULL,1,1,1631045841,1631045841),(34,1070,'Termination',1,1,1,1,'ist_bb_kabel','BB-Kabel',NULL,'string',NULL,NULL,1,1,1631045771,1631045771),(35,1060,'Termination',1,1,1,1,'ist_abschlusstyp','Abschlusstyp',NULL,'enum','SC/APC in FTU;SC/APC im BEP;SC/APC 19 Zoll;LC/APC 19 Zoll;E2/APC 19 Zoll',NULL,1,1,1631045716,1631045716),(36,1050,'Termination',1,1,1,1,'ist_ports','Ports',NULL,'string',NULL,NULL,1,1,1631045646,1631045646),(37,1040,'Termination',1,1,1,1,'ist_modul','Modul',NULL,'string',NULL,NULL,1,1,1631045536,1631045536),(38,1005,'Termination',1,1,0,1,'delimiter2','Ist-Zustand',NULL,'delimiter',NULL,NULL,1,1,1631045457,1631045457),(39,1030,'Termination',1,1,1,1,'ist_baugruppe','HE/Einschub',NULL,'string',NULL,NULL,1,1,1631045413,1631045413),(40,1020,'Termination',1,1,1,1,'ist_schrank','Schank',NULL,'string',NULL,NULL,1,1,1631045329,1631045329),(41,1010,'Termination',1,1,1,1,'ist_pop_id','POP',NULL,'enum','=Model=Pop:network_id=`term->building->network_id`:',NULL,1,1,1631041042,1631041042),(42,2005,'Termination',1,1,0,1,'delimiter3','',NULL,'delimiter',NULL,NULL,1,1,1631046390,1631046390),(43,2010,'Termination',1,1,1,1,'backbone_finished','Backbone hergestellt',NULL,'bool',NULL,NULL,1,1,1631046496,1631046496),(44,2020,'Termination',1,1,0,1,'backbone_setup_date','BB-Bautermin',NULL,'date',NULL,NULL,1,1,1631046496,1631046496),(45,2030,'Termination',1,1,0,1,'customer_setup_date','KU-Bautermin',NULL,'date',NULL,NULL,1,1,1631046557,1631046557),(46,3005,'Termination',1,1,0,1,'delimiter4','',NULL,'delimiter',NULL,NULL,1,1,1631046557,1631046557),(47,3010,'Termination',1,1,1,1,'inhouse_cabling_supplied','Inhouseverkabelung bereitgestellt',NULL,'bool',NULL,NULL,1,1,1631046709,1631046709),(48,3020,'Termination',1,1,1,1,'inhouse_cabling_deployed','Inhouseverkabelung verlegt',NULL,'bool',NULL,NULL,1,1,1631046709,1631046709),(49,3030,'Termination',1,1,1,1,'bep_deployed','BEP montiert',NULL,'bool',NULL,NULL,1,1,1631046770,1631046770),(50,3040,'Termination',1,1,1,1,'customer_cable_injected','Kundenkabel eingeblasen',NULL,'bool',NULL,NULL,1,1,1631046934,1631046934),(51,3050,'Termination',1,1,1,1,'spliced_network','Spleiß Netz',NULL,'bool',NULL,NULL,1,1,1631046934,1631046934),(52,3060,'Termination',1,1,1,1,'spliced_customer','Spleiß Kunde',NULL,'bool',NULL,NULL,1,1,1631047023,1631047023),(53,4005,'Termination',1,1,0,1,'delimiter5','',NULL,'delimiter',NULL,NULL,1,1,1631047090,1631047090),(54,4010,'Termination',1,1,0,1,'ont_deployed','ONT montiert',NULL,'bool',NULL,NULL,1,1,1631047182,1631047182),(55,4020,'Termination',1,1,0,1,'ont_sn','ONT SN',NULL,'string',NULL,'Seriennummer',1,1,1631047182,1631047182),(56,4030,'Termination',1,1,1,1,'customer_passive_finished','<!--class: text-success-->Kunde passiv fertiggestellt',NULL,'bool',NULL,NULL,1,1,1631047246,1631047246),(57,72,'Termination',1,1,1,1,'bb_kabel_steps','',NULL,'enum','12=12f/Tube;24=24f/Tube',NULL,1,1,1631045771,1631045771),(58,1072,'Termination',1,1,1,1,'ist_bb_kabel_steps','',NULL,'enum','12=12f/Tube;24=24f/Tube',NULL,1,1,1631045771,1631045771),(59,2011,'Termination',1,1,1,1,'empty1','',NULL,'empty',NULL,NULL,1,1,1631206034,1631206034),(60,2012,'Termination',1,1,1,1,'empty2','',NULL,'empty',NULL,NULL,1,1,1631206073,1631206073),(61,2013,'Termination',1,1,1,1,'empty3','',NULL,'empty',NULL,NULL,1,1,1631206073,1631206073),(62,2014,'Termination',1,1,1,1,'empty4','',NULL,'empty',NULL,NULL,1,1,1631206073,1631206073),(63,2015,'Termination',1,1,1,1,'empty5','',NULL,'empty',NULL,NULL,1,1,1631206073,1631206073),(64,2016,'Termination',1,1,1,1,'empty6','',NULL,'empty',NULL,NULL,1,1,1631206073,1631206073),(65,2017,'Termination',1,1,1,1,'empty7','',NULL,'empty',NULL,NULL,1,1,1631206073,1631206073),(66,2018,'Termination',1,1,1,1,'empty8','',NULL,'empty',NULL,NULL,1,1,1631206073,1631206073),(67,3015,'Termination',1,1,1,1,'empty11','',NULL,'empty',NULL,NULL,1,1,1631219695,1631219695),(68,3025,'Termination',1,1,1,1,'empty12','',NULL,'empty',NULL,NULL,1,1,1631219721,1631219721),(69,3035,'Termination',1,1,1,1,'empty13','',NULL,'empty',NULL,NULL,1,1,1631219757,1631219757),(70,3045,'Termination',1,1,1,1,'empty14','',NULL,'empty',NULL,NULL,1,1,1631219808,1631219808),(71,3055,'Termination',1,1,1,1,'empty15','',NULL,'empty',NULL,NULL,1,1,1631219819,1631219819),(72,4025,'Termination',1,1,1,1,'empty21','',NULL,'empty',NULL,NULL,1,1,1631219876,1631219876);
 /*!40000 ALTER TABLE `Workflowitem` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `Workflowvalue`
 --
 DROP TABLE IF EXISTS `Workflowvalue`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Workflowvalue` (
   `id` int NOT NULL AUTO_INCREMENT,
   `item_id` int NOT NULL,
   `object_id` int NOT NULL,
   `value_string` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
   `value_int` int DEFAULT NULL,
   `value_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
   `changed_by` int NOT NULL,
   `changed` int NOT NULL,
   `create_by` int NOT NULL,
   `edit_by` int NOT NULL,
   `create` int NOT NULL,
   `edit` int NOT NULL,
   PRIMARY KEY (`id`),
   KEY `value_string` (`value_string`(4)),
   KEY `object_id` (`object_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `Workflowvalue`
 --
 LOCK TABLES `Workflowvalue` WRITE;
 /*!40000 ALTER TABLE `Workflowvalue` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Workflowvalue` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Table structure for table `phinxlog`
 --
 DROP TABLE IF EXISTS `phinxlog`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `phinxlog` (
   `version` bigint NOT NULL,
   `migration_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `start_time` timestamp NULL DEFAULT NULL,
   `end_time` timestamp NULL DEFAULT NULL,
   `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
   PRIMARY KEY (`version`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 --
 -- Dumping data for table `phinxlog`
 --
 LOCK TABLES `phinxlog` WRITE;
 /*!40000 ALTER TABLE `phinxlog` DISABLE KEYS */;
 /*!40000 ALTER TABLE `phinxlog` ENABLE KEYS */;
 UNLOCK TABLES;
 --
 -- Final view structure for view `TerminationWorkflow_live`
 --
 /*!50001 DROP VIEW IF EXISTS `TerminationWorkflow_live`*/;
 /*!50001 SET @saved_cs_client          = @@character_set_client */;
 /*!50001 SET @saved_cs_results         = @@character_set_results */;
 /*!50001 SET @saved_col_connection     = @@collation_connection */;
 /*!50001 SET character_set_client      = utf8mb4 */;
 /*!50001 SET character_set_results     = utf8mb4 */;
 /*!50001 SET collation_connection      = utf8mb4_unicode_ci */;
 /*!50001 CREATE ALGORITHM=UNDEFINED */
 /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
 /*!50001 VIEW `TerminationWorkflow_live` AS select `thetool_live3`.`Building`.`id` AS `building_id`,`thetool_live3`.`Building`.`code` AS `building_code`,`thetool_live3`.`Network`.`id` AS `network_id`,`thetool_live3`.`Network`.`name` AS `network_name`,`thetool_live3`.`Networksection`.`name` AS `networksection_name`,`thetool_live3`.`Building`.`type_id` AS `buildingtype_id`,`thetool_live3`.`Buildingtype`.`name` AS `buildingtype_name`,`thetool_live3`.`Building`.`units` AS `units`,`thetool_live3`.`Building`.`street` AS `street`,`thetool_live3`.`Building`.`zip` AS `zip`,`thetool_live3`.`Building`.`city` AS `city`,`thetool_live3`.`Pop`.`name` AS `pop_name`,`thetool_live3`.`Pop`.`gps_lat` AS `pop_gps_lat`,`thetool_live3`.`Pop`.`gps_long` AS `pop_gps_long`,`thetool_live3`.`Building`.`gps_lat` AS `building_gps_lat`,`thetool_live3`.`Building`.`gps_long` AS `building_gps_long`,`thetool_live3`.`Building`.`laea` AS `laea`,`thetool_live3`.`Buildingstatus`.`code` AS `buildingstatus_code`,`thetool_live3`.`Buildingstatus`.`name` AS `buildingstatus_name`,if((`ist_schrank_q`.`ist_schrank` is null),`schrank_q`.`schrank`,`ist_schrank_q`.`ist_schrank`) AS `schrank`,if((`ist_rohrverband_q`.`ist_rohrverband` is null),`rohrverband_q`.`rohrverband`,`ist_rohrverband_q`.`ist_rohrverband`) AS `rohrverband`,if((`ist_rohrtype_q`.`ist_rohrtype` is null),`rohrtype_q`.`rohrtype`,`ist_rohrtype_q`.`ist_rohrtype`) AS `rohrtype`,if((`ist_rohrfarbe_q`.`ist_rohrfarbe` is null),`rohrfarbe_q`.`rohrfarbe`,`ist_rohrfarbe_q`.`ist_rohrfarbe`) AS `rohrfarbe`,`thetool_live3`.`Termination`.`id` AS `termination_id`,`thetool_live3`.`Termination`.`code` AS `terminstaion_code`,if((`ist_abschlusstyp_q`.`ist_abschlusstyp` is null),`abschlusstyp_q`.`abschlusstyp`,`ist_abschlusstyp_q`.`ist_abschlusstyp`) AS `abschlusstyp`,if((`ist_bb_kabel_q`.`ist_bb_kabel` is null),`bb_kabel_q`.`bb_kabel`,`ist_bb_kabel_q`.`ist_bb_kabel`) AS `bb_kabel`,if((`ist_bb_kabel_steps_q`.`ist_bb_kabel_steps` is null),`bb_kabel_steps_q`.`bb_kabel_steps`,`ist_bb_kabel_steps_q`.`ist_bb_kabel_steps`) AS `bb_kabel_steps`,if((`ist_bb_fasern_q`.`ist_bb_fasern` is null),`bb_fasern_q`.`bb_fasern`,`ist_bb_fasern_q`.`ist_bb_fasern`) AS `bb_fasern`,if((`ist_kundenkabel_typ_q`.`ist_kundenkabel_typ` is null),`kundenkabel_typ_q`.`kundenkabel_typ`,`ist_kundenkabel_typ_q`.`ist_kundenkabel_typ`) AS `kundenkabel_typ`,if((`ist_kundenkabel_fasern_q`.`ist_kundenkabel_fasern` is null),`kundenkabel_fasern_q`.`kundenkabel_fasern`,`ist_kundenkabel_fasern_q`.`ist_kundenkabel_fasern`) AS `kundenkabel_fasern`,`backbone_finished_q`.`backbone_finished` AS `backbone_finished`,`inhouse_cabling_supplied_q`.`inhouse_cabling_supplied` AS `inhouse_cabling_supplied`,`inhouse_cabling_deployed_q`.`inhouse_cabling_deployed` AS `inhouse_cabling_deployed`,`bep_deployed_q`.`bep_deployed` AS `bep_deployed`,`customer_cable_injected_q`.`customer_cable_injected` AS `customer_cable_injected`,`spliced_network_q`.`spliced_network` AS `spliced_network`,`spliced_customer_q`.`spliced_customer` AS `spliced_customer`,`ont_deployed_q`.`ont_deployed` AS `ont_deployed`,`ont_sn_q`.`ont_sn` AS `ont_sn`,`customer_passive_finished_q`.`customer_passive_finished` AS `customer_passive_finished` from ((((((((((((((((((((((((((((((((((((`thetool_live3`.`Termination` left join `thetool_live3`.`Building` on((`thetool_live3`.`Termination`.`building_id` = `thetool_live3`.`Building`.`id`))) left join `thetool_live3`.`Network` on((`thetool_live3`.`Building`.`network_id` = `thetool_live3`.`Network`.`id`))) left join `thetool_live3`.`Networksection` on((`thetool_live3`.`Networksection`.`id` = `thetool_live3`.`Building`.`networksection_id`))) left join `thetool_live3`.`Buildingtype` on((`thetool_live3`.`Building`.`type_id` = `thetool_live3`.`Buildingtype`.`id`))) left join `thetool_live3`.`Pop` on((`thetool_live3`.`Building`.`pop_id` = `thetool_live3`.`Pop`.`id`))) left join `thetool_live3`.`Buildingstatus` on((`thetool_live3`.`Building`.`status_id` = `thetool_live3`.`Buildingstatus`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `schrank_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `schrank` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'schrank')) `schrank_q` on((`schrank_q`.`schrank_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_schrank_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_schrank` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_schrank_name')) `ist_schrank_q` on((`ist_schrank_q`.`ist_schrank_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `rohrverband_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `rohrverband` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'rohrverband_name')) `rohrverband_q` on((`rohrverband_q`.`rohrverband_bid` = `thetool_live3`.`Building`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_rohrverband_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_rohrverband` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_rohrverband_name')) `ist_rohrverband_q` on((`ist_rohrverband_q`.`ist_rohrverband_bid` = `thetool_live3`.`Building`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `rohrtype_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `rohrtype` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'rohrtype')) `rohrtype_q` on((`rohrtype_q`.`rohrtype_bid` = `thetool_live3`.`Building`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_rohrtype_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_rohrtype` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_rohrtype')) `ist_rohrtype_q` on((`ist_rohrtype_q`.`ist_rohrtype_bid` = `thetool_live3`.`Building`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `rohrfarbe_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `rohrfarbe` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'rohrfarbe')) `rohrfarbe_q` on((`rohrfarbe_q`.`rohrfarbe_bid` = `thetool_live3`.`Building`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_rohrfarbe_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_rohrfarbe` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_rohrfarbe')) `ist_rohrfarbe_q` on((`ist_rohrfarbe_q`.`ist_rohrfarbe_bid` = `thetool_live3`.`Building`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `abschlusstyp_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `abschlusstyp` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'abschlusstyp')) `abschlusstyp_q` on((`abschlusstyp_q`.`abschlusstyp_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_abschlusstyp_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_abschlusstyp` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_abschlusstyp')) `ist_abschlusstyp_q` on((`ist_abschlusstyp_q`.`ist_abschlusstyp_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `bb_kabel_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `bb_kabel` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'bb_kabel')) `bb_kabel_q` on((`bb_kabel_q`.`bb_kabel_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_bb_kabel_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_bb_kabel` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_bb_kabel')) `ist_bb_kabel_q` on((`ist_bb_kabel_q`.`ist_bb_kabel_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `bb_kabel_steps_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `bb_kabel_steps` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'bb_kabel_steps')) `bb_kabel_steps_q` on((`bb_kabel_steps_q`.`bb_kabel_steps_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_bb_kabel_steps_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_bb_kabel_steps` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_bb_kabel_steps')) `ist_bb_kabel_steps_q` on((`ist_bb_kabel_steps_q`.`ist_bb_kabel_steps_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `bb_fasern_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `bb_fasern` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'bb_fasern')) `bb_fasern_q` on((`bb_fasern_q`.`bb_fasern_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_bb_fasern_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_bb_fasern` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_bb_fasern')) `ist_bb_fasern_q` on((`ist_bb_fasern_q`.`ist_bb_fasern_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `kundenkabel_typ_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `kundenkabel_typ` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'kundenkabel_typ')) `kundenkabel_typ_q` on((`kundenkabel_typ_q`.`kundenkabel_typ_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_kundenkabel_typ_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_kundenkabel_typ` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_kundenkabel_typ')) `ist_kundenkabel_typ_q` on((`ist_kundenkabel_typ_q`.`ist_kundenkabel_typ_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `kundenkabel_fasern_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `kundenkabel_fasern` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'kundenkabel_fasern')) `kundenkabel_fasern_q` on((`kundenkabel_fasern_q`.`kundenkabel_fasern_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ist_kundenkabel_fasern_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ist_kundenkabel_fasern` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ist_kundenkabel_fasern')) `ist_kundenkabel_fasern_q` on((`ist_kundenkabel_fasern_q`.`ist_kundenkabel_fasern_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `backbone_finished_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `backbone_finished` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'backbone_finished')) `backbone_finished_q` on((`backbone_finished_q`.`backbone_finished_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `inhouse_cabling_supplied_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `inhouse_cabling_supplied` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'inhouse_cabling_supplied')) `inhouse_cabling_supplied_q` on((`inhouse_cabling_supplied_q`.`inhouse_cabling_supplied_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `inhouse_cabling_deployed_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `inhouse_cabling_deployed` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'inhouse_cabling_deployed')) `inhouse_cabling_deployed_q` on((`inhouse_cabling_deployed_q`.`inhouse_cabling_deployed_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `bep_deployed_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `bep_deployed` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'bep_deployed')) `bep_deployed_q` on((`bep_deployed_q`.`bep_deployed_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `customer_cable_injected_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `customer_cable_injected` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'customer_cable_injected')) `customer_cable_injected_q` on((`customer_cable_injected_q`.`customer_cable_injected_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `spliced_network_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `spliced_network` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'spliced_network')) `spliced_network_q` on((`spliced_network_q`.`spliced_network_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `spliced_customer_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `spliced_customer` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'spliced_customer')) `spliced_customer_q` on((`spliced_customer_q`.`spliced_customer_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ont_deployed_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `ont_deployed` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ont_deployed')) `ont_deployed_q` on((`ont_deployed_q`.`ont_deployed_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `ont_sn_bid`,`thetool_live3`.`Workflowvalue`.`value_string` AS `ont_sn` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'ont_sn')) `ont_sn_q` on((`ont_sn_q`.`ont_sn_bid` = `thetool_live3`.`Termination`.`id`))) left join (select `thetool_live3`.`Workflowvalue`.`object_id` AS `customer_passive_finished_bid`,`thetool_live3`.`Workflowvalue`.`value_int` AS `customer_passive_finished` from (`thetool_live3`.`Workflowvalue` left join `thetool_live3`.`Workflowitem` on((`thetool_live3`.`Workflowvalue`.`item_id` = `thetool_live3`.`Workflowitem`.`id`))) where (`thetool_live3`.`Workflowitem`.`name` = 'customer_passive_finished')) `customer_passive_finished_q` on((`customer_passive_finished_q`.`customer_passive_finished_bid` = `thetool_live3`.`Termination`.`id`))) */;
 /*!50001 SET character_set_client      = @saved_cs_client */;
 /*!50001 SET character_set_results     = @saved_cs_results */;
 /*!50001 SET collation_connection      = @saved_col_connection */;
 /*!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-09-06  9:27:03

2075 lines 102 KiB SQL Raw Permalink Blame History

2075 lines

102 KiB

SQL

Raw Permalink Blame History