-- MariaDB dump 10.19 Distrib 10.5.19-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: nbiSuiteInstall
-- ------------------------------------------------------
-- Server version 10.5.19-MariaDB-0+deb11u2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `maintenancelocation_maintenanceitemtemplate`
--
DROP TABLE IF EXISTS `maintenancelocation_maintenanceitemtemplate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maintenancelocation_maintenanceitemtemplate` (
`maintenancelocation_id` bigint(20) NOT NULL,
`maintenanceitemtemplate_id` bigint(20) NOT NULL,
PRIMARY KEY (`maintenancelocation_id`,`maintenanceitemtemplate_id`),
KEY `IDX_950BC83742415178` (`maintenancelocation_id`),
KEY `IDX_950BC837F1D83C64` (`maintenanceitemtemplate_id`),
CONSTRAINT `FK_950BC83742415178` FOREIGN KEY (`maintenancelocation_id`) REFERENCES `nbi_maintenance_locations` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_950BC837F1D83C64` FOREIGN KEY (`maintenanceitemtemplate_id`) REFERENCES `nbi_maintenance_item_templates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `maintenancelocation_maintenanceitemtemplate`
--
-- ORDER BY: `maintenancelocation_id`,`maintenanceitemtemplate_id`
LOCK TABLES `maintenancelocation_maintenanceitemtemplate` WRITE;
/*!40000 ALTER TABLE `maintenancelocation_maintenanceitemtemplate` DISABLE KEYS */;
/*!40000 ALTER TABLE `maintenancelocation_maintenanceitemtemplate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migration_versions`
--
DROP TABLE IF EXISTS `migration_versions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migration_versions` (
`version` varchar(191) NOT NULL,
`executed_at` datetime DEFAULT NULL,
`execution_time` int(11) DEFAULT NULL,
PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migration_versions`
--
-- ORDER BY: `version`
LOCK TABLES `migration_versions` WRITE;
/*!40000 ALTER TABLE `migration_versions` DISABLE KEYS */;
INSERT INTO `migration_versions` VALUES ('DoctrineMigrations\\Version20190323123436','2019-05-11 18:07:10',NULL),('DoctrineMigrations\\Version20190511101427','2019-05-11 18:07:11',NULL),('DoctrineMigrations\\Version20190511120154','2019-05-11 18:07:12',NULL),('DoctrineMigrations\\Version20190511145247','2019-05-11 18:07:12',NULL),('DoctrineMigrations\\Version20190530110909','2019-05-30 11:36:51',NULL),('DoctrineMigrations\\Version20190810183750','2019-08-10 18:42:56',NULL),('DoctrineMigrations\\Version20191003124600','2019-10-03 11:03:33',NULL),('DoctrineMigrations\\Version20191003152100','2019-10-03 14:58:56',NULL),('DoctrineMigrations\\Version20191003165456','2019-10-03 14:59:02',NULL),('DoctrineMigrations\\Version20191003182500','2019-10-05 08:53:08',NULL),('DoctrineMigrations\\Version20191102105500','2019-11-02 10:00:17',NULL),('DoctrineMigrations\\Version20191102120735','2019-11-02 12:14:12',NULL),('DoctrineMigrations\\Version20191102202307','2019-11-02 20:26:18',NULL),('DoctrineMigrations\\Version20200118074536','2020-01-18 08:30:28',NULL),('DoctrineMigrations\\Version20200118090030','2020-01-18 09:06:07',NULL),('DoctrineMigrations\\Version20200118113422','2020-01-18 11:38:39',NULL),('DoctrineMigrations\\Version20200118155654','2020-01-18 16:05:37',NULL),('DoctrineMigrations\\Version20200118183402','2020-01-18 18:39:03',NULL),('DoctrineMigrations\\Version20200211185314','2020-02-11 18:56:22',NULL),('DoctrineMigrations\\Version20200215074139','2020-02-15 07:47:18',NULL),('DoctrineMigrations\\Version20200215101400','2020-02-15 10:58:14',NULL),('DoctrineMigrations\\Version20200215142748','2020-02-15 14:34:45',NULL),('DoctrineMigrations\\Version20200222072146','2020-02-22 07:32:50',NULL),('DoctrineMigrations\\Version20200306075408','2020-03-06 07:57:28',NULL),('DoctrineMigrations\\Version20200306105035','2020-03-06 10:59:12',NULL),('DoctrineMigrations\\Version20200406113524','2020-04-06 11:47:45',NULL),('DoctrineMigrations\\Version20200418104228','2020-04-18 10:47:42',NULL),('DoctrineMigrations\\Version20200513095439','2020-05-13 10:07:39',NULL),('DoctrineMigrations\\Version20200514054401','2020-05-14 05:48:09',NULL),('DoctrineMigrations\\Version20200515103347','2020-05-15 10:36:11',NULL),('DoctrineMigrations\\Version20200515114352','2020-05-18 12:58:06',NULL),('DoctrineMigrations\\Version20200518124458','2020-05-18 12:58:10',NULL),('DoctrineMigrations\\Version20200518161913','2020-05-18 16:27:04',NULL),('DoctrineMigrations\\Version20200521071839','2020-05-21 07:24:31',NULL),('DoctrineMigrations\\Version20200521112253','2020-05-21 13:38:56',NULL),('DoctrineMigrations\\Version20200523110327','2020-05-23 11:05:58',NULL),('DoctrineMigrations\\Version20200525110655','2020-05-25 11:11:52',NULL),('DoctrineMigrations\\Version20200526112255','2020-05-26 11:30:30',NULL),('DoctrineMigrations\\Version20200526123533','2020-05-26 12:41:04',NULL),('DoctrineMigrations\\Version20200526130216','2020-05-26 13:09:17',NULL),('DoctrineMigrations\\Version20200625140406','2020-06-29 18:03:30',NULL),('DoctrineMigrations\\Version20200628075247','2020-06-29 18:03:30',NULL),('DoctrineMigrations\\Version20200628082031','2020-06-29 18:03:30',NULL),('DoctrineMigrations\\Version20200629111152','2020-06-29 18:03:30',NULL),('DoctrineMigrations\\Version20200718080231','2020-07-18 12:59:55',NULL),('DoctrineMigrations\\Version20200718111856','2020-07-18 12:59:57',NULL),('DoctrineMigrations\\Version20200718170300','2020-07-18 16:44:13',NULL),('DoctrineMigrations\\Version20200818153515','2020-08-19 03:44:21',NULL),('DoctrineMigrations\\Version20200905182338','2020-09-06 06:11:34',NULL),('DoctrineMigrations\\Version20201003095955','2020-10-04 04:41:54',NULL),('DoctrineMigrations\\Version20201003100758','2020-10-04 04:41:54',NULL),('DoctrineMigrations\\Version20201003141958','2020-10-04 04:41:58',NULL),('DoctrineMigrations\\Version20201016113833','2020-10-17 06:02:33',NULL),('DoctrineMigrations\\Version20201019125230','2020-10-20 03:19:14',NULL),('DoctrineMigrations\\Version20201109062851','2020-11-10 05:37:32',NULL),('DoctrineMigrations\\Version20201121075926','2020-11-22 07:02:24',2134),('DoctrineMigrations\\Version20201121161647','2020-11-22 07:02:27',10),('DoctrineMigrations\\Version20201121191847','2020-11-22 07:02:27',1),('DoctrineMigrations\\Version20201123045846','2020-11-23 06:56:44',386),('DoctrineMigrations\\Version20201214104219','2020-12-15 07:45:53',206),('DoctrineMigrations\\Version20201218112948','2020-12-19 05:07:09',2761),('DoctrineMigrations\\Version20201219080215','2020-12-21 05:48:13',12),('DoctrineMigrations\\Version20201219083929','2020-12-21 05:48:14',2081),('DoctrineMigrations\\Version20201219113346','2020-12-21 05:48:16',1),('DoctrineMigrations\\Version20201219152649','2020-12-21 05:48:16',1423),('DoctrineMigrations\\Version20201229090526','2020-12-30 06:19:25',251),('DoctrineMigrations\\Version20210116074929','2021-01-17 07:12:03',11498),('DoctrineMigrations\\Version20210205094017','2021-02-06 05:35:44',228),('DoctrineMigrations\\Version20210205133628','2021-02-06 05:35:44',14),('DoctrineMigrations\\Version20210213095921','2021-02-14 07:59:05',203),('DoctrineMigrations\\Version20210222131611','2021-02-23 06:54:04',11),('DoctrineMigrations\\Version20210223151256','2021-02-24 05:41:01',47),('DoctrineMigrations\\Version20210306083307','2021-03-07 05:12:12',4565),('DoctrineMigrations\\Version20210306091844','2021-03-07 05:12:18',5312),('DoctrineMigrations\\Version20210306133936','2021-03-07 05:12:25',1),('DoctrineMigrations\\Version20210306142704','2021-03-07 05:12:26',34123),('DoctrineMigrations\\Version20210306153314','2021-03-07 05:13:00',10737),('DoctrineMigrations\\Version20210408054626','2021-04-09 16:50:13',419),('DoctrineMigrations\\Version20210409145421','2021-04-10 07:36:30',540),('DoctrineMigrations\\Version20210413053310','2021-04-13 13:47:24',181),('DoctrineMigrations\\Version20210417090336','2021-04-18 06:30:46',11),('DoctrineMigrations\\Version20210426125734','2021-04-27 08:38:32',336),('DoctrineMigrations\\Version20210427081433','2021-04-28 06:33:33',60),('DoctrineMigrations\\Version20210505060620','2021-05-06 07:59:44',11),('DoctrineMigrations\\Version20210511065449','2021-05-12 07:14:55',11),('DoctrineMigrations\\Version20210511101012','2021-05-12 07:14:55',1),('DoctrineMigrations\\Version20210522053557','2021-05-30 07:40:59',50),('DoctrineMigrations\\Version20210611100836','2021-06-15 06:25:05',111),('DoctrineMigrations\\Version20210619102901','2021-06-20 07:41:09',15),('DoctrineMigrations\\Version20210619135908','2021-06-20 07:41:10',275),('DoctrineMigrations\\Version20210619142344','2021-06-20 07:41:11',247),('DoctrineMigrations\\Version20210619143500','2021-06-20 07:41:11',0),('DoctrineMigrations\\Version20210619151711','2021-06-20 07:41:11',477),('DoctrineMigrations\\Version20210619153851','2021-06-20 07:41:11',7),('DoctrineMigrations\\Version20210619155505','2021-06-20 07:41:11',22),('DoctrineMigrations\\Version20210619163737','2021-06-20 07:41:12',18),('DoctrineMigrations\\Version20210621080338','2021-06-22 06:04:03',376),('DoctrineMigrations\\Version20210624094258','2021-06-25 05:54:08',12),('DoctrineMigrations\\Version20210713150105','2021-07-14 06:38:04',13),('DoctrineMigrations\\Version20210727103621','2021-07-28 07:51:17',95),('DoctrineMigrations\\Version20210727124838','2021-07-28 07:51:17',139),('DoctrineMigrations\\Version20210728051118','2021-07-28 08:38:21',14),('DoctrineMigrations\\Version20210728122754','2021-07-29 06:25:03',11),('DoctrineMigrations\\Version20210814145718','2021-11-10 11:06:52',16110),('DoctrineMigrations\\Version20210911064116','2021-11-10 11:07:08',12),('DoctrineMigrations\\Version20210912082544','2021-11-10 11:07:08',23),('DoctrineMigrations\\Version20210916143848','2021-11-10 11:07:08',14),('DoctrineMigrations\\Version20210918070738','2021-11-10 11:07:08',4791),('DoctrineMigrations\\Version20210918091202','2021-11-10 11:07:13',4823),('DoctrineMigrations\\Version20210918102108','2021-11-10 11:07:18',13555),('DoctrineMigrations\\Version20210918103716','2021-11-10 11:07:32',18),('DoctrineMigrations\\Version20210918105914','2021-11-10 11:07:32',1),('DoctrineMigrations\\Version20210918120948','2021-11-10 11:07:32',79),('DoctrineMigrations\\Version20210918135230','2021-11-10 11:07:32',17026),('DoctrineMigrations\\Version20210921093515','2021-11-10 11:07:49',341),('DoctrineMigrations\\Version20210922150820','2021-11-10 11:07:50',577),('DoctrineMigrations\\Version20210924111346','2021-11-10 11:07:50',331),('DoctrineMigrations\\Version20211001063556','2021-11-10 11:07:51',635),('DoctrineMigrations\\Version20211008145839','2021-11-10 11:07:52',1),('DoctrineMigrations\\Version20211013161613','2021-11-10 11:07:52',496),('DoctrineMigrations\\Version20211023095927','2021-11-10 11:07:53',318),('DoctrineMigrations\\Version20211028090624','2021-11-10 11:07:53',841),('DoctrineMigrations\\Version20211102091621','2021-11-10 11:07:54',200),('DoctrineMigrations\\Version20211110103635','2021-12-01 16:57:12',6415),('DoctrineMigrations\\Version20211113090356','2021-12-01 16:57:23',105832),('DoctrineMigrations\\Version20211113112456','2021-12-01 16:59:10',156254),('DoctrineMigrations\\Version20211113132047','2021-12-01 17:01:47',3921),('DoctrineMigrations\\Version20211113141253','2021-12-01 17:01:52',3149),('DoctrineMigrations\\Version20211122160050','2021-12-01 17:01:55',4788),('DoctrineMigrations\\Version20211122170351','2021-12-01 17:02:00',1),('DoctrineMigrations\\Version20211213085051','2021-12-21 06:44:56',1860),('DoctrineMigrations\\Version20211218104808','2021-12-21 06:44:58',13467),('DoctrineMigrations\\Version20211218133442','2021-12-21 06:45:11',0),('DoctrineMigrations\\Version20211218153935','2021-12-21 06:45:12',2208),('DoctrineMigrations\\Version20211218154415','2021-12-21 06:45:14',3839),('DoctrineMigrations\\Version20211230125751','2022-01-05 17:34:01',41138),('DoctrineMigrations\\Version20211230131428','2022-01-05 17:34:47',23059),('DoctrineMigrations\\Version20220103095354','2022-01-05 17:35:11',3123),('DoctrineMigrations\\Version20220105154655','2022-01-05 17:35:15',808),('DoctrineMigrations\\Version20220110102429','2022-01-10 17:22:34',71153),('DoctrineMigrations\\Version20220111152028','2022-01-14 17:02:12',13),('DoctrineMigrations\\Version20220120125758','2022-01-23 12:23:33',717),('DoctrineMigrations\\Version20220123124205','2022-01-24 06:01:46',1420),('DoctrineMigrations\\Version20220123143413','2022-01-24 06:01:48',82),('DoctrineMigrations\\Version20220128160557','2022-02-01 11:06:32',115623),('DoctrineMigrations\\Version20220209070812','2022-02-10 05:30:05',7636),('DoctrineMigrations\\Version20220211073827','2022-02-11 09:24:41',14),('DoctrineMigrations\\Version20220211085456','2022-02-12 12:48:39',11954),('DoctrineMigrations\\Version20220211090729','2022-02-12 12:48:53',3981),('DoctrineMigrations\\Version20220211161431','2022-02-12 12:48:58',35897),('DoctrineMigrations\\Version20220212075709','2022-02-12 12:49:35',11439),('DoctrineMigrations\\Version20220212082311','2022-02-12 12:49:47',51410),('DoctrineMigrations\\Version20220212085042','2022-02-12 12:50:39',43306),('DoctrineMigrations\\Version20220212090233','2022-02-12 12:51:22',877),('DoctrineMigrations\\Version20220212123232','2022-02-12 14:09:03',2600),('DoctrineMigrations\\Version20220212125636','2022-02-12 14:09:06',44),('DoctrineMigrations\\Version20220212131605','2022-02-12 17:21:12',10),('DoctrineMigrations\\Version20220212132103','2022-02-12 17:21:13',1),('DoctrineMigrations\\Version20220214130920','2022-02-15 13:24:41',3814),('DoctrineMigrations\\Version20220225161729','2022-03-07 17:29:09',1554),('DoctrineMigrations\\Version20220225164710','2022-03-07 17:29:11',45077),('DoctrineMigrations\\Version20220228070747','2022-03-07 17:29:56',2750),('DoctrineMigrations\\Version20220307131402','2022-03-07 17:30:02',2),('DoctrineMigrations\\Version20220326095112','2022-03-26 19:34:28',11261),('DoctrineMigrations\\Version20220326095844','2022-03-26 19:34:39',12891),('DoctrineMigrations\\Version20220423080206','2022-04-24 05:40:45',2579),('DoctrineMigrations\\Version20220423081051','2022-04-24 05:40:48',3472),('DoctrineMigrations\\Version20220423145719','2022-04-25 04:41:22',2449),('DoctrineMigrations\\Version20220425141508','2022-04-25 14:28:23',2803),('DoctrineMigrations\\Version20220503070147','2022-05-03 14:53:08',1140),('DoctrineMigrations\\Version20220503084520','2022-05-03 14:53:09',1629),('DoctrineMigrations\\Version20220509081552','2022-05-16 16:01:01',21),('DoctrineMigrations\\Version20220514072216','2022-05-16 15:35:04',6169),('DoctrineMigrations\\Version20220514091428','2022-05-16 17:26:44',704),('DoctrineMigrations\\Version20220514104233','2022-05-16 17:26:45',2459),('DoctrineMigrations\\Version20220514105324','2022-05-16 15:35:04',6169),('DoctrineMigrations\\Version20220514121159','2022-05-16 17:26:48',8226),('DoctrineMigrations\\Version20220514130049','2022-05-16 15:35:04',6169),('DoctrineMigrations\\Version20220514152252','2022-05-16 17:26:56',0),('DoctrineMigrations\\Version20220514160758','2022-05-16 17:26:57',4351),('DoctrineMigrations\\Version20220516051939','2022-05-16 15:35:04',6169),('DoctrineMigrations\\Version20220523061331','2022-05-25 03:51:27',18),('DoctrineMigrations\\Version20220523133539','2022-05-25 03:51:27',1),('DoctrineMigrations\\Version20220524141545','2022-05-25 03:51:27',272),('DoctrineMigrations\\Version20220716064843','2022-07-16 16:47:57',1723),('DoctrineMigrations\\Version20220716090014','2022-07-16 16:47:59',295),('DoctrineMigrations\\Version20220716102715','2022-07-16 16:47:59',448),('DoctrineMigrations\\Version20220813054922','2022-09-17 16:35:25',8186),('DoctrineMigrations\\Version20220813082347','2022-09-17 16:35:34',819),('DoctrineMigrations\\Version20220813120157','2022-09-17 16:35:35',319),('DoctrineMigrations\\Version20220813122621','2022-09-17 16:35:35',111),('DoctrineMigrations\\Version20220822163035','2022-09-17 16:35:35',842),('DoctrineMigrations\\Version20220825134929','2022-09-17 16:35:36',228),('DoctrineMigrations\\Version20220917081443','2022-09-17 16:35:37',256),('DoctrineMigrations\\Version20221014154037','2023-01-16 08:16:06',5738),('DoctrineMigrations\\Version20221017141330','2023-01-16 08:16:11',438),('DoctrineMigrations\\Version20221018132336','2023-01-16 08:16:12',177),('DoctrineMigrations\\Version20221025134052','2023-01-16 08:16:12',1827),('DoctrineMigrations\\Version20221028092445','2023-01-16 08:16:14',418),('DoctrineMigrations\\Version20221028113347','2023-01-16 08:16:15',4286),('DoctrineMigrations\\Version20221107150857','2023-01-16 08:16:20',86),('DoctrineMigrations\\Version20221115081359','2023-01-16 08:16:20',2858),('DoctrineMigrations\\Version20221118092200','2023-01-16 08:16:23',331),('DoctrineMigrations\\Version20221122075618','2023-01-16 08:16:23',233),('DoctrineMigrations\\Version20221124171418','2023-01-16 08:16:24',2739),('DoctrineMigrations\\Version20221130073308','2023-01-16 08:16:27',211),('DoctrineMigrations\\Version20221205143109','2023-01-16 08:16:27',104),('DoctrineMigrations\\Version20221218071922','2023-01-16 08:16:27',5679),('DoctrineMigrations\\Version20221218120722','2023-01-16 08:16:33',3561),('DoctrineMigrations\\Version20221218172628','2023-01-16 08:16:37',3939),('DoctrineMigrations\\Version20230114082850','2023-01-16 08:36:56',22),('DoctrineMigrations\\Version20230114104624','2023-01-16 08:36:57',706),('DoctrineMigrations\\Version20230114125112','2023-01-16 08:36:58',1589),('DoctrineMigrations\\Version20230205145530','2023-04-22 08:41:42',9446),('DoctrineMigrations\\Version20230207164314','2023-04-22 08:41:52',971),('DoctrineMigrations\\Version20230311071111','2023-04-22 08:41:53',124),('DoctrineMigrations\\Version20230311172121','2023-04-22 08:41:53',686),('DoctrineMigrations\\Version20230417071016','2023-04-22 08:41:54',376);
/*!40000 ALTER TABLE `migration_versions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_backup_files`
--
DROP TABLE IF EXISTS `nbi_backup_files`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_backup_files` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`server_id` bigint(20) NOT NULL,
`created` datetime NOT NULL,
`backup_datetime` datetime NOT NULL,
`file_name` varchar(255) NOT NULL,
`file_size` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_97730FFA1844E6B7` (`server_id`),
CONSTRAINT `FK_97730FFA1844E6B7` FOREIGN KEY (`server_id`) REFERENCES `tbl_manage_server` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_backup_files`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_backup_files` WRITE;
/*!40000 ALTER TABLE `nbi_backup_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_backup_files` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_backup_schedules`
--
DROP TABLE IF EXISTS `nbi_backup_schedules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_backup_schedules` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`server_id` bigint(20) NOT NULL,
`week_day` smallint(6) NOT NULL COMMENT 'Tag des Backups 1 (Montag) bis 7 (Sonntag)',
`hour` smallint(6) NOT NULL COMMENT 'Stunde zu der das backup erzeugt wird (0 - 23)',
`minute` smallint(6) NOT NULL COMMENT 'Minute zu der das backup erzeugt wird (0 - 59)',
`active` tinyint(1) NOT NULL DEFAULT 1,
`last_run` datetime DEFAULT NULL COMMENT 'Zeitpunkt zu dem das Backup das letzet mal gelaufen ist.',
`backup_type` smallint(6) NOT NULL DEFAULT 1 COMMENT '1 - full stop / neustart',
PRIMARY KEY (`id`),
KEY `IDX_3408EBC91844E6B7` (`server_id`),
CONSTRAINT `FK_3408EBC91844E6B7` FOREIGN KEY (`server_id`) REFERENCES `tbl_manage_server` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_backup_schedules`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_backup_schedules` WRITE;
/*!40000 ALTER TABLE `nbi_backup_schedules` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_backup_schedules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_book_entries`
--
DROP TABLE IF EXISTS `nbi_book_entries`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_book_entries` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_bill_id` bigint(20) DEFAULT NULL,
`book_date` date NOT NULL,
`customer_name` varchar(255) NOT NULL,
`reason_of_payment` longtext NOT NULL,
`amount` double NOT NULL,
`csv_hash` varchar(255) NOT NULL,
`nbi_incoming_bill_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`booking_user` varchar(255) DEFAULT NULL COMMENT 'Benutzer der die Buchung durchgeführt hat',
`booking_timestamp` datetime DEFAULT NULL COMMENT 'Zeitpunk zu dem die Buchung durchgeführt wurde',
`booked` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_D6BC0B1A7102B9E5` (`csv_hash`),
KEY `IDX_D6BC0B1A41DF1A81` (`tbl_bill_id`),
KEY `IDX_D6BC0B1A46AAE999` (`nbi_incoming_bill_id`),
CONSTRAINT `FK_D6BC0B1A41DF1A81` FOREIGN KEY (`tbl_bill_id`) REFERENCES `tbl_bills` (`id`),
CONSTRAINT `FK_D6BC0B1A46AAE999` FOREIGN KEY (`nbi_incoming_bill_id`) REFERENCES `nbi_incoming_bills` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_book_entries`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_book_entries` WRITE;
/*!40000 ALTER TABLE `nbi_book_entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_book_entries` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_configuration`
--
DROP TABLE IF EXISTS `nbi_configuration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_configuration` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`context` varchar(180) NOT NULL,
`name` varchar(180) NOT NULL,
`description` longtext DEFAULT NULL,
`value_type` int(11) NOT NULL,
`value_string` longtext DEFAULT NULL,
`value_numeric` double DEFAULT NULL,
`value_datetime` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
`crypted` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nbi_configuration_context_name` (`context`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_configuration`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_configuration` WRITE;
/*!40000 ALTER TABLE `nbi_configuration` DISABLE KEYS */;
INSERT INTO `nbi_configuration` VALUES (3,'2019-05-11 20:07:10','nbi.portal','bookkeeping.dir.base','Order der Buchhaltung',4,'Sk5IV0wxaHYyanpiK0xBWDlDTE1jcU5RQXBpaTRFdklvZ2RUQzNSdXU4M3JXNHFwS1dLdlJGcVhFUUVoblZzSg==',NULL,NULL,1),(4,'2019-05-11 20:07:10','nbi.portal','bookkeeping.dir.scan','Order fuer Scans vom Dell',4,'Sk5IV0wxaHYyanpiK0xBWDlDTE1jcU5RQXBpaTRFdklvZ2RUQzNSdXU4M3hRMkhwTTBmQTNHZFRrRVI3UGNnU04xcFFwZ2xLc01OVmRVQTRzbkowbkE9PQ==',NULL,NULL,1),(5,'2019-05-11 20:07:10','nbi.portal','bookkeeping.dir.customer','Order fuer Kunden Rechungen und Dokumente',4,'Sk5IV0wxaHYyanpiK0xBWDlDTE1jcU5RQXBpaTRFdklvZ2RUQzNSdXU4MHJ0VXF3V2dmd3FQU1cvZVhPWElOdFpkbGkwcFJhWHpWK1QzVndGQXVHaFE9PQ==',NULL,NULL,1),(6,'2019-05-11 20:07:10','nbi.portal','bookkeeping.email','Absender Adresse der Buchhaltung',4,'support@demo.nbiserv.de',NULL,NULL,0),(7,'2019-05-11 20:07:10','nbi.portal','bookkeeping.fines','Mahngebuehren',3,NULL,5,NULL,0),(8,'2019-05-11 20:07:10','nbi.portal','bookkeeping.paypal.percentage','% Aufschlag für PayPal',3,NULL,6,NULL,0),(9,'2019-05-11 20:07:10','nbi.portal','bookkeeping.paypal.fee','PayPal Gebühren',3,NULL,0.47,NULL,0),(10,'2019-05-11 20:07:10','nbi.portal','bookkeeping.print.fee','Preis fuer Rechnung per Post',3,NULL,5,NULL,0),(12,'2019-05-11 20:07:10','nbi.portal','system.email','E-Mail Adresse für System E-Mails',4,'support@demo.nbiserv.de',NULL,NULL,0),(13,'2019-05-11 20:07:10','nbi.portal','notification.email','Mail Adresse fuer wichtige Meldungen',4,'support@demo.nbiserv.de',NULL,NULL,0),(14,'2019-05-11 20:07:10','nbi.portal','liveconfig.user','ToDo - anedern LC User',4,NULL,NULL,NULL,1),(15,'2019-05-11 20:07:10','nbi.portal','liveconfig.password','LiveConfig Passwort',4,NULL,NULL,NULL,1),(16,'2019-05-11 20:07:10','nbi.portal','liveconfig.url','LiveConfig URL',4,'https://www.nbiserv.de:8443/liveconfig/soap',NULL,NULL,0),(17,'2019-05-11 20:07:10','nbi.portal','liveconfig.dir.localScripts','ToDo - anpassen auf s4f order - LiveConfig Scripte',4,'eTVvay9oUlVjdlhxR1hLY0x6NEZBU1RleHliKzF3WGNUWDBja1ZRTWF1cExnSlBYblZkQ1c2M1pPRDhGd3Q1RQ==',NULL,NULL,1),(18,'2019-05-11 20:07:10','nbi.portal','internetx.user','internetX Personal DNS User',4,NULL,NULL,NULL,1),(19,'2019-05-11 20:07:10','nbi.portal','internetx.password','internetX Personal DNS Passwort',4,NULL,NULL,NULL,1),(20,'2019-05-11 20:07:10','nbi.portal','internetx.context','InternetX Kundennummer',4,NULL,NULL,NULL,1),(21,'2019-05-11 20:07:10','nbi.portal','internetx.email.hostmaster','InternetX Mail Adresse',4,'support@demo.nbiserv.de',NULL,NULL,0),(22,'2019-05-11 20:07:10','nbi.portal','internetx.url','InternnetX API URL',4,'https://gateway.autodns.com',NULL,NULL,0),(23,'2019-05-11 20:07:10','nbi.portal','nicdirect.user','nicdirect User',4,NULL,NULL,NULL,1),(24,'2019-05-11 20:07:10','nbi.portal','nicdirect.password','nicdirect Passwort',4,NULL,NULL,NULL,1),(25,'2019-05-11 20:07:10','nbi.portal','nicdirect.url','nicdirect API URL',4,'https://backend.antagus.de/bdom',NULL,NULL,0),(26,'2019-05-11 20:07:10','nbi.portal','ticketsystem.attachment.dir','Ablage von Tickets',4,'/var/www/web9/htdocs/nbiSuite/TicketSystem/',NULL,NULL,0),(27,'2019-05-11 20:07:11','nbi.portal','ticketsystem.email.emergency.to','E-Mail Adresse an die eine Info bei einem Nofall Ticket geschickt wird',4,'support@demo.nbiserv.de',NULL,NULL,0),(28,'2019-05-11 20:07:11','nbi.portal','server.reset.url','IP vom Resetserver',4,NULL,NULL,NULL,0),(29,'2019-05-11 20:07:11','nbi.portal','server.reset.user','SSH User Resetserver',4,NULL,NULL,NULL,1),(30,'2019-05-11 20:07:11','nbi.portal','server.reset.password','SSH Passwort',4,'RDJzRnVocGxWQU9LS1I5U1RlaFFEUT09',NULL,NULL,1),(31,'2019-05-11 20:07:11','nbi.portal','server.reset.script','Pfad zum Script',4,NULL,NULL,NULL,1),(32,'2019-05-11 20:07:11','nbi.portal','server.statistic.url','URL fuer Statistiken',4,NULL,NULL,NULL,0),(33,'2019-05-11 20:07:11','nbi.portal','switch.password','Passwort Switch Login',4,NULL,NULL,NULL,1),(34,'2019-05-11 20:07:11','nbi.portal','switch.dhcp.global','Globaler DHCP Server',4,'46.182.16.33',NULL,NULL,0),(35,'2019-05-11 20:07:11','nbi.portal','router.password','Router Passwort',4,NULL,NULL,NULL,1),(36,'2019-05-11 20:07:11','nbi.portal','router.ip','IP vom Router',4,NULL,NULL,NULL,0),(37,'2019-05-11 20:07:11','nbi.portal','router.port','Port vom Router',2,NULL,22,NULL,0),(38,'2019-05-11 20:07:11','nbi.portal','liveconfig.license.user','LiveConfig Lizenz API User',4,NULL,NULL,NULL,1),(39,'2019-05-11 20:07:11','nbi.portal','liveconfig.license.password','LiveConfig Lizenz API Passwort',4,NULL,NULL,NULL,1),(40,'2019-05-11 20:07:11','nbi.portal','liveconfig.license.url','LiveConfig Lizenz API URL',4,'https://www.liveconfig.com/api/license/v1',NULL,NULL,0),(41,'2019-05-11 20:07:11','nbi.portal','mailer.noreply','Absender E-Mail Adresse L',4,'support@demo.nbiserv.de',NULL,NULL,0),(42,'2019-10-03 13:03:33','nbi.portal','account.balance','Kontostand',4,NULL,NULL,NULL,1),(43,'2019-10-03 16:58:56','nbi.portal','config-files.dir','Verzeichnis für Konfigurationsdateien (Monitoring, DHCP etc.) ',4,'Sk5IV0wxaHYyanpiK0xBWDlDTE1jbDBYNjVjclVvN1dZSi9qeS92VklobjhjR01VbVA5MG1hU2ZEUWI2L01wZA==',NULL,NULL,1),(44,'2019-10-05 10:53:08','nbi.portal','server.kvm.cost.base','Grundkosten KVM Bestellung',3,NULL,25,NULL,0),(45,'2019-10-05 10:53:08','nbi.portal','server.kvm.cost.hour','Stündliche Kosten KVM Bestellung',3,NULL,5,NULL,0),(48,'2020-01-18 09:30:28','nbi.portal','enviatel.traffic-api.url','Telefon Download Link fuer CSV',4,'https://portal.enviatel.de/vertrieb2/reseller/evn/{knr}/{year}/{month}',NULL,NULL,0),(49,'2020-01-18 09:30:28','nbi.portal','enviatel.traffic-api.customerNumber','Telefon Kundennummer fuer Download Link fuer CSV',4,NULL,NULL,NULL,1),(50,'2020-01-18 09:30:28','nbi.portal','enviatel.traffic-api.user','Telefon User fuer Download Link fuer CSV',4,NULL,NULL,NULL,1),(51,'2020-01-18 09:30:28','nbi.portal','enviatel.traffic-api.password','Telefon Passwort fuer Download Link fuer CSV',4,NULL,NULL,NULL,1),(52,'2020-01-18 09:30:28','nbi.portal','enviatel.traffic-api.rootDirectory','Speicher Ort fuer zip Archiv',4,'/var/www/web9/htdocs/nbiSoft/TicketSystem/',NULL,NULL,1),(53,'2020-01-18 09:30:28','nbi.portal','enviatel.selfcare-api.url','API URL fuer Funktion um im Kundencenter VoIP Einstellungen zu aendern.',4,'https://api.enviatel.de/rest/v1/selfcare/',NULL,NULL,0),(54,'2020-01-18 09:30:28','nbi.portal','enviatel.selfcare-api.username','API Username fuer Funktion um im Kundencenter VoIP Einstellungen zu aendern.',4,NULL,NULL,NULL,1),(55,'2020-01-18 09:30:28','nbi.portal','enviatel.selfcare-api.password','API Passwort fuer Funktion um im Kundencenter VoIP Einstellungen zu aendern.',4,NULL,NULL,NULL,1),(56,'2020-01-18 19:39:03','nbi.portal','router.user','User fuer Router Zugriff',4,NULL,NULL,NULL,1),(57,'2020-03-06 11:59:12','nbi.portal','router.auto-config.suspendUntil','Automatische Konfiguration des Routers aussetzen bis...',5,NULL,NULL,'2999-01-01 12:23:00',0),(60,'2020-07-18 18:44:13','nbi.portal','liveconfig.active','LiveConfig Funktionalität ist aktiviert / deaktivier (Webserver / Cluster)',1,NULL,0,NULL,0),(61,'2020-08-19 05:44:21','nbi.portal','app.version','Applikations Version (commit hash)',4,' - Alpha - nbiSuite - Achtung nicht fuer den Produktiven Einsatz geeigent! v0.0.1-BETA',NULL,NULL,0),(62,'2020-10-04 06:41:54','nbi.portal','ticketsystem.default.disableEmails','Standard Wert ob E-Mail Versand an Tickets deaktiviert ist',1,NULL,0,NULL,0),(63,'2020-11-22 07:02:27','nbi.portal','bookkeeping.last.import','Letzter Import der Umsätze',5,NULL,NULL,'2020-10-29 15:55:00',0),(64,'2020-11-22 07:02:27','nbi.portal','bookkeeping.debt-collector.type','Inkasso Anbieter - ETI',4,NULL,NULL,NULL,0),(65,'2020-11-22 07:02:27','nbi.portal','bookkeeping.debt-collector.eti.user','ETI User',4,NULL,NULL,NULL,1),(66,'2020-11-22 07:02:27','nbi.portal','bookkeeping.debt-collector.eti.password','ETI Passwort',4,NULL,NULL,NULL,1),(67,'2020-11-22 07:02:27','nbi.portal','bookkeeping.debt-collector.eti.api','ETI API',4,'https://www.eurotreuhandinkasso-service.de/',NULL,NULL,0),(68,'2020-12-15 07:45:53','nbi.portal','bookkeeping.debt-collector.eti.test','ETI im Testbetrieb 1 = JA / 0 = NEIN',3,NULL,1,NULL,0),(69,'2020-12-21 05:48:13','nbi.portal','messenger.matrix.activate','Matrix Messenger aktivieren',1,NULL,0,NULL,0),(70,'2020-12-21 05:48:13','nbi.portal','messenger.matrix.user','Matrix User User',4,NULL,NULL,NULL,1),(71,'2020-12-21 05:48:13','nbi.portal','messenger.matrix.password','Matrix User Passwort',4,NULL,NULL,NULL,1),(73,'2020-12-21 05:48:13','nbi.portal','messenger.matrix.server','Matrix Server',4,'https://matrix.nbimail.de/',NULL,NULL,0),(74,'2020-12-21 05:48:17','nbi.portal','bookkeeping.pay.for.service.fee','Kosten für 15min',3,NULL,25,NULL,0),(75,'2020-12-21 05:48:17','nbi.portal','bookkeeping.pay.for.service.activate','Default ob Kunden für Service zahlen',1,NULL,0,NULL,0),(76,'2021-01-17 07:12:04','nbi.portal','company.name.line2','Firmenname Zeile 2',4,'Demo - nbiserv',NULL,NULL,0),(77,'2021-01-17 07:12:04','nbi.portal','company.name.line1','Firmenname Zeile 1',4,'Demo - Martin Prager',NULL,NULL,0),(78,'2021-01-17 07:12:05','nbi.portal','company.street','Straße',4,'Demo - Bethenhausen',NULL,NULL,0),(79,'2021-01-17 07:12:08','nbi.portal','company.street.number','Hausnummer',4,'Demo - 5',NULL,NULL,0),(80,'2021-01-17 07:12:10','nbi.portal','company.postcode','Postleitzahl',4,'Demo - 07554',NULL,NULL,0),(81,'2021-01-17 07:12:12','nbi.portal','company.location','Ort',4,'Demo - Bethenhausen',NULL,NULL,0),(82,'2021-01-17 07:12:12','nbi.portal','company.phone.number','generelle Telefonnummer',4,'Demo - +49-36695-240050',NULL,NULL,0),(83,'2021-01-17 07:12:13','nbi.portal','company.registration.number','Handelsregister Nummer',4,NULL,NULL,NULL,0),(84,'2021-01-17 07:12:13','nbi.portal','company.dreg','Nummer bei der Bundesnetzagentur (DREG)',4,'Demo - 10/351',NULL,NULL,0),(85,'2021-01-17 07:12:13','nbi.portal','bookkeeping.creditor.id','Gläubiger ID',4,'Demo - DE90ZZZ00000131433',NULL,NULL,0),(86,'2021-01-17 07:12:13','nbi.portal','bookkeeping.vat.number','Umsatzsteuer ID',4,'Demo - DE232105933',NULL,NULL,0),(87,'2021-01-17 07:12:14','nbi.portal','bookkeeping.phone.number','Telefonnummer der Buchhaltung',4,'Demo - +49-36695-240050',NULL,NULL,0),(88,'2021-01-17 07:12:14','nbi.portal','bookkeeping.bank.account.name','Name Kontoinhaber',4,'Demo - nbiserv',NULL,NULL,0),(89,'2021-01-17 07:12:14','nbi.portal','bookkeeping.bank.account.iban','IBAN',4,'Demo - DE61 8305 0000 0000 0659 19',NULL,NULL,0),(90,'2021-01-17 07:12:14','nbi.portal','bookkeeping.bank.account.bic','BIC',4,'Demo - HELADEF1GER',NULL,NULL,0),(91,'2021-02-23 06:54:04','nbi.portal','switch.management.vlan','Globales Management vLAN',3,NULL,9,NULL,0),(92,'2021-02-24 05:41:01','nbi.portal','system.global.dns','DNS bzw. Nameserver',4,'192.168.0.1 46.182.16.32',NULL,NULL,0),(93,'2021-02-24 05:41:01','nbi.portal','mailer.from.domain','From Domain @DOMAIN',4,'@nbimail.de',NULL,NULL,0),(94,'2021-02-24 05:41:01','nbi.portal','mailer.server','Mailserver',4,'mail.mailserver.de',NULL,NULL,0),(95,'2021-02-24 05:41:01','nbi.portal','mailer.user','Mail Username',4,'email@user.de',NULL,NULL,0),(96,'2021-02-24 05:41:01','nbi.portal','mailer.password','Mail Passwort',4,NULL,NULL,NULL,1),(97,'2021-03-07 05:12:25','nbi.portal','mailer.signature.default','Default E-Mail Signatur',4,'nbiSuit Default Signatur
www.nbiserv.de',NULL,NULL,0),(98,'2021-04-18 06:30:46','nbi.portal','bookkeeping.bill.number.prefix','Rechnungs Prefix',4,'nbi-R-',NULL,NULL,0),(99,'2021-04-18 06:30:46','nbi.portal','bookkeeping.bank.ci','Gläubiger-Identifikationsnumme',4,'DE',NULL,NULL,0),(100,'2021-04-18 06:30:46','nbi.portal','bookkeeping.bank.name','Bankname',4,'Sparkasse-Gera-Greiz',NULL,NULL,0),(101,'2021-04-18 06:30:46','nbi.portal','ticketsystem.prefix','Ticket Prefix',4,'nbi-',NULL,NULL,0),(102,'2021-04-28 06:33:33','nbi.portal','eapi.legal.itrk.active','IT-Recht Kanzlei Schnitstelle Aktiv
Im Kundencenter von ITRK Inhouse-Individualshop wählen.
Link: https://Ihre.Domain/eapi/itrk/push',1,NULL,0,NULL,0),(103,'2021-04-28 06:33:33','nbi.portal','eapi.legal.itrk.user','IT-Recht Kanzlei - shared secret client id',4,'RzQ2d0NMRHVNaDErZ3dxMjJiMXVEZz09',NULL,NULL,1),(104,'2021-04-28 06:33:33','nbi.portal','eapi.legal.itrk.password','IT-Recht Kanzlei - shared secret client secret',4,'L1NzS3RDT1EyRXdmWDlJd2xQRGYreDc0c0xlNzA0TEZuQTg2NHdKZTFNbz0=',NULL,NULL,1),(105,'2021-04-28 06:33:33','nbi.portal','eapi.legal.itrk.apihash','IT-Recht Kanzlei - eigener API Hash (Solle mind. 32 Zeichen sein, nur Zahlen und Buchstaben) für den Update Aufruf',4,NULL,NULL,NULL,0),(106,'2021-04-28 06:33:33','nbi.portal','legal.imprint','Impressum (wird bei aktiver API überschrieben)',4,'Hier entsteht eine neue Seite mit nbiSuite. Bei einer aktiven API z.B. von IT-Recht Kanzlei wird dieser Teil überschrieben.',NULL,NULL,0),(107,'2021-04-28 06:33:33','nbi.portal','legal.imprint.additional','Impressum',4,'Hier können Sie zusätzliche Angaben hinterlegen, diese werden nicht durch die API überschrieben und am Ende angehängt.',NULL,NULL,0),(108,'2021-04-28 06:33:33','nbi.portal','legal.rightofwithdrawal','Widerrufsbelehrung (wird bei aktiver API überschrieben)',4,'Hier entsteht eine neue Seite mit nbiSuite.Bei einer aktiven API z.B. von IT-Recht Kanzlei wird dieser Teil überschrieben.',NULL,NULL,0),(109,'2021-04-28 06:33:33','nbi.portal','legal.rightofwithdrawal.additional','Widerrufsbelehrung',4,'Hier können Sie zusätzliche Angaben hinterlegen, diese werden nicht durch die API überschrieben und am Ende angehängt.',NULL,NULL,0),(110,'2021-04-28 06:33:33','nbi.portal','legal.dataprotection','Datenschutzerklärung (wird bei aktiver API überschrieben)',4,'Hier entsteht eine neue Seite mit nbiSuite.Bei einer aktiven API z.B. von IT-Recht Kanzlei wird dieser Teil überschrieben.',NULL,NULL,0),(111,'2021-04-28 06:33:33','nbi.portal','legal.dataprotection.additional','Datenschutzerklärung',4,'Hier können Sie zusätzliche Angaben hinterlegen, diese werden nicht durch die API überschrieben und am Ende angehängt.-',NULL,NULL,0),(112,'2021-04-28 06:33:33','nbi.portal','legal.termsofservice','AGB (wird bei aktiver API überschrieben)i',4,'Hier entsteht eine neue Seite mit nbiSuite.Bei einer aktiven API z.B. von IT-Recht Kanzlei wird dieser Teil überschrieben.',NULL,NULL,0),(113,'2021-04-28 06:33:33','nbi.portal','legal.termsofservice.additional','AGB',4,'Hier können Sie zusätzliche Angaben hinterlegen, diese werden nicht durch die API überschrieben und am Ende angehängt.',NULL,NULL,0),(114,'2021-06-20 07:41:09','nbi.portal','messenger.matrix.notification.channel','Matrix Raum in den wichtige Nachrichten (Dashboard Critical) z.B. Notfall Ticket gesendet wird.',4,NULL,NULL,NULL,1),(115,'2021-06-25 05:54:08','nbi.portal','bookkeeping.pay.for.ticket.high.fee','Kosten für ein High Ticket in Euro ohne MwSt. - 0=kostenlos',3,NULL,1,NULL,0),(116,'2021-06-25 05:54:08','nbi.portal','bookkeeping.pay.for.ticket.emergency.fee','Kosten für ein Notfall Ticket in Euro ohne MwSt. - 0=kostenlos',3,NULL,15,NULL,0),(117,'2021-06-25 05:54:08','nbi.portal','bookkeeping.pay.for.ticket.high.text','Text der im Info Feld angezeigt wird.',4,'Bei Hoch Tickets garantieren wir eine Reaktion innerhalb 12 Stunden. Sie erteile damit auch pauschal die Freigabe für 1 x 15min Remote Hands, ohne Rücksprache, sofern erforderlich.',NULL,NULL,0),(118,'2021-06-25 05:54:08','nbi.portal','bookkeeping.pay.for.ticket.emergency.text','Text der im Info Feld angezeigt wird.',4,'Bei Notfall Tickets garantieren wir eine Reaktion innerhalb 2 Stunden. Sie erteile damit auch pauschal die Freigabe für 4 x 15min Remote Hands, ohne Rücksprache, sofern erforderlich.',NULL,NULL,0),(119,'2021-07-14 06:38:04','nbi.portal','bookkeeping.pay.for.ticket.high.text.en','Englischer Text der im Info Feld angezeigt wird.',4,'For high tickets, we guarantee a response within 12 hours. In doing so, you also give a blanket approval for 1 x 15min remote hands, without consultation, if necessary.',NULL,NULL,0),(120,'2021-07-14 06:38:04','nbi.portal','bookkeeping.pay.for.ticket.emergency.text.en','Englischer Text der im Info Feld angezeigt wird.',4,'In the case of emergency tickets, we guarantee a response within 1 hour. You are also giving general approval for 4 x 15min remote hands, without consultation, if necessary..',NULL,NULL,0),(121,'2021-11-10 11:07:52','nbi.portal','server.domain','Default domain der Server.',4,'nbiserv.com',NULL,NULL,0),(122,'2021-11-10 11:07:52','nbi.portal','server.prefix','Default server prefix.',4,'nbi',NULL,NULL,0),(123,'2021-12-21 06:44:56','nbi.portal','foreman.user','Foreman API Username',4,'APIUser',NULL,NULL,1),(124,'2021-12-21 06:44:56','nbi.portal','foreman.password','Foreman API Passwort',4,'Passwort',NULL,NULL,1),(125,'2021-12-21 06:44:56','nbi.portal','foreman.site','Foreman Webseite',4,'foreman.nbiserv.de',NULL,NULL,0),(126,'2021-12-21 06:44:56','nbi.portal','foreman.domain.id','Foreman ID der Default Domain',3,NULL,2,NULL,0),(127,'2021-12-21 06:44:56','nbi.portal','foreman.architecture.id','Foreman ID der Default Architecture',3,NULL,1,NULL,0),(128,'2021-12-21 06:44:56','nbi.portal','foreman.organization.id','Foreman ID der Default Organization',3,NULL,4,NULL,0),(129,'2021-12-21 06:44:56','nbi.portal','foreman.location.id','Foreman ID der Default Location',3,NULL,3,NULL,0),(130,'2021-12-21 06:44:56','nbi.portal','pbs.master.storage.id','Name des Storage auf dem Master',4,'Backup',NULL,NULL,0),(131,'2021-12-21 06:44:56','nbi.portal','pbs.server','Servernamen des Backupservers',4,'pbs1.nbiserv.de',NULL,NULL,0),(132,'2021-12-21 06:44:56','nbi.portal','pbs.datastore','Datastore auf dem Backupserver',4,'zfsbackup',NULL,NULL,0),(133,'2021-12-21 06:44:56','nbi.portal','pbs.username','Username für den Backupserver',4,'Username',NULL,NULL,1),(134,'2021-12-21 06:44:56','nbi.portal','pbs.password','Passwort für den Backupserver',4,'Passwort',NULL,NULL,1),(135,'2021-12-21 06:44:56','nbi.portal','pbs.finger.print','Fingerprint des Backupservers',4,'xx:xx:c9:a8:xx:3f:f0:xx:c6:ea:2c:xx:1a:da:65:00:6d:fb:a5:af:03:ba:db:1a:98:63:xx:46:a1:79:74:fc',NULL,NULL,1),(136,'2021-12-21 06:45:11','nbi.portal','mailer.signature.default.sender.name','Default Name über der Signatur',4,'Ihr nbiserv Team',NULL,NULL,0),(137,'2022-01-10 17:23:44','nbi.portal','server.icinga','Icinga Server',4,'',NULL,NULL,0),(138,'2022-01-10 17:23:44','nbi.portal','server.pxe','PXE / DHCP Server',4,'',NULL,NULL,0),(139,'2022-01-10 17:23:44','nbi.portal','server.ns.rdns.0','DNS 0 für rDNS Zone',4,'',NULL,NULL,0),(140,'2022-01-10 17:23:44','nbi.portal','server.ns.rdns.1','DNS 1 für rDNS Zone',4,'',NULL,NULL,0),(141,'2022-01-10 17:23:44','nbi.portal','server.ns.rdns.2','DNS 2 für rDNS Zone',4,'',NULL,NULL,0),(142,'2022-01-10 17:23:44','nbi.portal','server.ns.rdns.3','DNS 3 für rDNS Zone',4,'',NULL,NULL,0),(143,'2022-01-10 17:23:45','nbi.portal','server.ns.rdns.4','DNS 4 für rDNS Zone',4,'',NULL,NULL,0),(144,'2022-01-10 17:23:45','nbi.portal','server.ns.dns.0','DNS 0 für DNS Zone der Server Domain',4,'',NULL,NULL,0),(145,'2022-01-14 17:02:12','nbi.portal','server.ns.dns.2','DNS 2 für DNS Zone der Server Domain',4,'',NULL,NULL,0),(146,'2022-01-14 17:02:12','nbi.portal','server.ns.dns.1','DNS 1 für DNS Zone der Server Domain',4,'',NULL,NULL,0),(147,'2022-01-14 17:02:12','nbi.portal','bookkeeping.import.software.activate.aqbanking','Umsätze aus Aqbankig hohlen.',1,NULL,0,NULL,0),(148,'2022-01-14 17:02:12','nbi.portal','bookkeeping.import.software.activate.sfirm','Umsätze aus SFirm hohlen.',1,NULL,0,NULL,0),(149,'2022-01-14 17:02:12','nbi.portal','bookkeeping.import.software.activate.starmoney','Umsätze StarMoney hohlen.',1,NULL,0,NULL,0),(150,'2022-02-10 05:30:05','nbi.portal','feature.enviatel.activate','API zu Enviatel Aktiv.',1,NULL,0,NULL,0),(151,'2022-02-10 05:30:05','nbi.portal','feature.liveconfig.licence.activate','API zu LiveConfig fuer Lizenz Bestellungen',1,NULL,0,NULL,0),(152,'2022-02-10 05:30:05','nbi.portal','feature.liveconfig.activate','API zu LiveConfig Cluster fuer Webhosting, Cloudhosting',1,NULL,0,NULL,0),(153,'2022-02-10 05:30:05','nbi.portal','feature.internetx.activate','API InternetX.',1,NULL,0,NULL,0),(154,'2022-02-10 05:30:05','nbi.portal','feature.nicdirect.activate','API zu NicDirect',1,NULL,0,NULL,0),(155,'2022-02-10 05:30:05','nbi.portal','feature.eti.activate','API zu Euro Treuhand Inkasso',1,NULL,0,NULL,0),(156,'2022-02-10 05:30:05','nbi.portal','server.ssh.private.key','SSH Private Key fuer Kommunikation',4,NULL,NULL,NULL,1),(157,'2022-02-10 05:30:05','nbi.portal','server.ssh.public.key','SSH Public Key fuer Kommunikation',4,'from=\"93.240.120.143/32,46.182.16.0/23,10.0.0.0/21,192.168.0.0/21,2a02:2970:1000::/64\" ssh-rsa AAAAB3NzaC1yc2EAAAABJQAABAEAoj5b7w867ztB5Ds4b5raUgyzhHisNF50FMTOw7aQsrQL9E5CQVztMhdF5rLtx838HoNQDp15iaz2u5Bwd6NtLUHmrkXLApZWtXHT6lwRi+lYS4CXMEiJW0JtxkvQtCk+G1yE7XDcOvOp0iDUizbbIDV3MkMVZcfAUjCjOI9Kqjm4cEzWbb5qCarXa13XN1ftc4FNvemtzeuGxC8ejhJOvI+e59ru0kj7ma8Aaa543XWpKGxXv7s9Otbusm2Wmu3Ktv8yCla6joC+L/hdBVnxHpBkswSiyhnXxmLbXgsVbtX+IQne63ssEFyfGpOjYGAbKZaRMsE4k2h9m00Qm4bt1n21zCzBTF40AuWCcURKD3bGzHlKFL7puU/Wy6IGU+oe1k5weICohC1YXP66s9UGSY9lYe9L3dY3F7p1W1Mu2wm8IY9Rm+hz9lySmTwKT09yh3ZIZej0n+AtY8W4O6CZfH3YUAZHXyyvr8ejJjDkkyjYA+sEouKZOMdrHyJnQOGFXcpv6wABfQ/NNCPAvPyqPTqDLnaGjU8VcLWg6rGXTn2GI4SRgsu3/MYgu+KMh2nWqjqwaNtn+cDRFrWf76Jmw3g+6z7Vmcsh0S8GWlcO2tI7bzYw47Q7IuKhb8mGJ0+98E3WG2+Kl4GrowJax0Gz0vqkkrx5dUsvEYnKzgWmTueVn0VWlF3Axe9yu4sMkzTAGSmvkUDnZ5PdxBId5GOwW0OTTM9nRW2EfxD6Rej94ZMTMNtc10eyk5nONAc6Q0m81L3c3KiGMUbdzCYgrdyXMUPch12d86t3kf+5Edq7ht3Idb0qekvEOkFxBqIpqU9M1E5CR1Lw9YmY1pPHK2Dqfv8KKqKUGHVYegUfOhXDIG/AZFDeGN8j45mOedIK4czqsiWhS2utuHM/nBbSaSFpHTgaTrwK3A1AiQli+4U91mIR/nTUmXpyprHscnSVmPgLqIzudLEbzSJwr0BHL/p0pnv/pRmqeE2Pvz7B3MI2B5JWG9UYSGyI6z9eDMq4h1skb1QDXxXta97VKWAPw0+ANTVmNWkBEjrhva4DgLKWlu9sKAMFQK9FdWoPNrzXNaps5Tp4zKVQXl6q7kqmSOkYLQ7+i0JGP/l6F765MfmyRoZRvJQbHBEecmzAP0euQ23mkYXjJzeeKqvIHuGSNZ3BJyVsSjwxoENpuPkFZ/5H0WfyyM+U/HIJ5zkbYjXKi24rWm/Gw6knCcbgHnaSlIoVgIQFSc0T/tbPAu7U+MvcAPuhkSx/oeNDu3QGHUQccuZJ4j0josLLZ19VXRha0pdMYeT8QdMe4Dhy42Tsew83YqT06fva4udKr2cDVHFNBU1qzefRM49xQ3apjxU3fsdsqQ== Support@nbiserv.de',NULL,NULL,0),(158,'2022-02-10 05:30:05','nbi.portal','server.ssh.allow.ips','SSH erlaubte IP Adressen',4,'root@192.168.* root@10.0.* root@2a02:2970:1000:* root@46.182.16.* root@46.182.17.* root@46.182.18.* root@46.182.19.* root@31.185.110.* root@31.185.111.*',NULL,NULL,0),(159,'2022-02-11 09:24:41','nbi.portal','pmg.server','Servernamen des Proxmox Mail Gateways',4,'pmg1.nbiserv.de',NULL,NULL,0),(160,'2022-02-11 09:24:41','nbi.portal','pmg.username','Username für den API Zugriff zum Proxmox Mail Gaterway',4,'Username',NULL,NULL,1),(161,'2022-02-11 09:24:41','nbi.portal','pmg.password','Passwort für den Proxmox Mail Gateway',4,'Passwort',NULL,NULL,1),(162,'2022-03-07 17:30:02','nbi.portal','site.security.access.api.internal.activate','IP Schutz für /api Aktiviert.',1,NULL,0,NULL,0),(163,'2022-03-07 17:30:02','nbi.portal','site.security.access.admin.activate','IP Schutz für /admin Aktivert.',1,NULL,0,NULL,0),(164,'2022-03-07 17:30:02','nbi.portal','site.security.access.api.internal.networks','IP Netze die Zugriff auf /api haben.',4,'127.0.0.1 ::1, 10.0.0.0/24 172.17.0.0/12 46.182.16.0/23 2a02:2970:1000::/64 31.185.104.129/27 46.182.23.129/27',0,NULL,0),(165,'2022-03-07 17:30:02','nbi.portal','site.security.access.admin.networks','IP Netze die Zugriff auf /admin haben.',4,'127.0.0.1 ::1 192.168.0.0/21 10.0.0.0/22 172.17.0.0/12 46.182.16.0/23 2a02:2970:1000::/64',0,NULL,0),(166,'2022-03-07 17:30:02','nbi.portal','site.3cx.chat.html.code','3cx generierter HTML Code.',4,'',0,NULL,0),(167,'2022-03-07 17:30:02','nbi.portal','site.cookie.html.code','HTML Code für Cookie Abfrage.',4,' ',0,NULL,0),(168,'2022-03-07 17:30:02','nbi.portal','site.link.remote.access','Link für Fernzugriff Software.',4,'Fernzugriff Support',0,NULL,0),(169,'2022-05-03 14:53:08','nbi.portal','feature.dhcp.activate','DHCP Files werden erzeugt',1,NULL,0,NULL,0),(170,'2022-05-03 14:53:09','nbi.portal','feature.traffic.switch.activate','Traffic wird von Switch Ports ausgelesen',1,NULL,0,NULL,0),(171,'2022-05-16 16:01:01','nbi.portal','feature.bookkeeping.paypal.activate','Akzeptiere Paypal Zahlungen',1,NULL,0,NULL,0),(172,'2022-05-16 16:01:01','nbi.portal','feature.bookkeeping.bank.transfer.activate','Akzeptiere Überweisungen Zahlungen',1,NULL,0,NULL,0),(173,'2022-05-16 16:01:01','nbi.portal','feature.bookkeeping.bank.direct.debit.activate','Akzeptiere Lastschrift Zahlungen',1,NULL,0,NULL,0),(174,'2022-05-16 16:01:01','nbi.portal','feature.bookkeeping.btcps.activate','Akzeptiere Zahlungen via BTC PayServer',1,NULL,0,NULL,0),(175,'2022-05-16 16:01:01','nbi.portal','bookkeeping.paypal.email.address','E-Mail Adresse für PayPal Zahlungen',4,'paypal@nbiserv.de',NULL,NULL,0),(176,'2022-05-16 16:01:01','nbi.portal','bookkeeping.btcps.app.button.url','BTC PayServer URL App Button URL',4,'https://url/apps/HASH/pos',NULL,NULL,0),(177,'2022-05-16 17:26:45','nbi.portal','bookkeeping.btcps.allowed.ips','BTC PayServer URL App Button URL',4,'46.182.16.36,46.182.17.42',NULL,NULL,0),(178,'2022-05-16 17:26:56','nbi.portal','company.country','Land',4,'Germany',NULL,NULL,0),(179,'2022-05-16 17:26:57','nbi.portal','nbisuite.api.key','API Key für nbiServ',4,'DemoKey',NULL,NULL,1),(180,'2022-07-16 16:47:59','nbi.portal','ticketsystem.default.gui.openInNewTab','Standard Wert Tickets in neuem Tab geöffnet werden.',1,NULL,1,NULL,0),(181,'2022-09-17 14:35:34','nbi.portal','site.external.status.url','URL zur Status-Seite',4,'https://www.nbiserv-status.de',NULL,NULL,0),(182,'2022-09-17 14:35:34','nbi.portal','site.external.status.text.okay','Text Status-Seite alles okay',4,'Derzeit sind keine Probleme bekannt.
No problems found.',NULL,NULL,0),(183,'2022-09-17 14:35:34','nbi.portal','site.external.status.text.failed','Text Status-Seite Probleme erkannt',4,'Aktuell kommt es teilweise zur nicht Erreichbarkeit.
Wir arbeiten mit Hochdruck an einer Lösung.
Daher bitten wir Sie von Ticket/Mail und Anrufen abzusehen.
Currently it is partly unavailable.
We are working hard on a solution.
We therefore ask you to refrain from ticket/mail and calls.',NULL,NULL,0),(184,'2022-09-17 14:35:35','nbi.portal','bookkeeping.dir.vendor','Order fuer Lieferranten Rechungen und Dokumente',4,'eTVvay9oUlVjdlhxR1hLY0x6NEZBYXVOUlRrYVZFMENrNm5PdHhwa0J2eXEvMzk5VmhoN3lwOXB1bG5kUnRscDdRK1FLN2t4Y0V3UWljU1NNTi9xUWdtbzZwRHk0SU4rTk96VFNqYStXYzM1NTRLT2hHM3ZiN3VqckVJSmRZRGY',NULL,NULL,1),(185,'2022-09-17 14:35:35','nbi.portal','feature.bookkeeping.tax.consultant.activate','Steuerberater Feature aktiv',1,NULL,0,NULL,0),(186,'2022-09-17 14:35:35','nbi.portal','bookkeeping.tax.consultant.bookkeeping.done.email','E-Mail Adresse des Steuerberaters zur Benachrichtigung das alle Buchungen bearbeitet wurden.',4,'',NULL,NULL,1),(187,'2022-09-17 14:35:35','nbi.portal','bookkeeping.tax.consultant.bookkeeping.done.email.send','Sende Mail an Steuerberater wenn alle Buchungen bearbeitet sind, damit er weis das er Buchhaltung machen kann.',1,NULL,0,NULL,0),(188,'2022-09-17 14:35:36','nbi.portal','bookkeeping.tax.consultant.bookkeeping.done.email.last.send','Zeitstempel wann die letzte Mail gesendet wurde',5,NULL,NULL,NULL,1),(189,'2022-09-17 14:35:36','nbi.portal','bookkeeping.tax.consultant.bookkeeping.done.email.time.interval','Aller wie vielen Monate soll die Mail gesendet werden. 1 jeden Monat - 2 aller 3 Monate - 3 aller 6 Monate - 4 aller 12 Monate',3,NULL,0,NULL,0),(190,'2022-09-17 14:35:36','nbi.portal','bookkeeping.tax.consultant.vendor.id','Lieferanten / Vendor ID des Steuerberaters im System',3,NULL,0,NULL,0),(191,'2023-01-16 07:16:11','nbi.portal','internetx.pricelist.user','internetX AutoDNS DNS - Preisliste API User',4,'#',NULL,NULL,1),(192,'2023-01-16 07:16:11','nbi.portal','internetx.pricelist.password','internetX AutoDNS DNS - Preisliste API Passwort',4,'#',NULL,NULL,1),(193,'2023-01-16 07:16:12','nbi.portal','internetx.pricelist.url','internetX AutoDNS API URL abfrage Preisliste',4,'https://api.autodns.com',NULL,NULL,0),(194,'2023-01-16 07:16:12','nbi.portal','nicdirect.url.to.pricelist','URL zur Preisliste',4,'http://www.antagus.de/preisliste/preisliste.csv',NULL,NULL,0),(195,'2023-01-16 07:16:12','nbi.portal','bookkeeping.calculation.domains.activate','Soll eine automatische Domainpreiskalkulation gemacht werden',1,NULL,0,NULL,0),(196,'2023-01-16 07:16:12','nbi.portal','bookkeeping.calculation.domains.minimum.profit.in.percent','Mindest Gewinn in Prozent der erzielt werden soll',3,NULL,10,NULL,0),(197,'2023-01-16 07:16:13','nbi.portal','bookkeeping.calculation.domains.minimum.profit.in.euro','Mindest Gewinn in Euro zu züglich den Prozent',3,NULL,1,NULL,0),(198,'2023-01-16 07:16:13','nbi.portal','bookkeeping.calculation.domains.maximum.possible.discount.for.customers','Wieviel Prozente soll für eventuelle Rabatte auf den Brutto Preis kakluliert werden.',3,NULL,20,NULL,0),(199,'2023-01-16 07:16:14','nbi.portal','bookkeeping.vat.default','Standard Mehrwertsteuer',3,NULL,19,NULL,0),(200,'2023-01-16 07:16:20','nbi.portal','domain.hostmaster.email.address','Domain Hostmaster Mail Adresse',4,'hostmaster@nbiserv.de',NULL,NULL,0),(201,'2023-01-16 07:36:56','nbi.portal','bookkeeping.calculation.domains.minimum.change.provider','Mindest Differenz in Euro, für einen Wechsel des Default Domainproviders für eine Domain',3,NULL,1,NULL,0);
/*!40000 ALTER TABLE `nbi_configuration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_custom_bill_products`
--
DROP TABLE IF EXISTS `nbi_custom_bill_products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_custom_bill_products` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`nbi_custom_bills_id` bigint(20) NOT NULL,
`netto` double NOT NULL,
`brutto` double NOT NULL,
`title` varchar(255) NOT NULL,
`comment` longtext DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_5765045A8BBB49BC` (`nbi_custom_bills_id`),
CONSTRAINT `FK_5765045A8BBB49BC` FOREIGN KEY (`nbi_custom_bills_id`) REFERENCES `nbi_custom_bills` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_custom_bill_products`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_custom_bill_products` WRITE;
/*!40000 ALTER TABLE `nbi_custom_bill_products` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_custom_bill_products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_custom_bills`
--
DROP TABLE IF EXISTS `nbi_custom_bills`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_custom_bills` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_customer_id` bigint(20) NOT NULL,
`type` int(11) NOT NULL,
`comment` longtext DEFAULT NULL,
`tax` tinyint(1) DEFAULT NULL,
`created` datetime NOT NULL,
`nbi_book_entry_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_891E35F0ACA1C2BF` (`nbi_book_entry_id`),
KEY `IDX_891E35F014F4236B` (`tbl_customer_id`),
CONSTRAINT `FK_891E35F014F4236B` FOREIGN KEY (`tbl_customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_891E35F0ACA1C2BF` FOREIGN KEY (`nbi_book_entry_id`) REFERENCES `nbi_book_entries` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_custom_bills`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_custom_bills` WRITE;
/*!40000 ALTER TABLE `nbi_custom_bills` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_custom_bills` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_customer_product_specials`
--
DROP TABLE IF EXISTS `nbi_customer_product_specials`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_customer_product_specials` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`product_id` bigint(20) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`discount` double NOT NULL COMMENT 'Rabatt in Prozent.',
`immediate_rollout` tinyint(1) NOT NULL COMMENT 'Sofortige Auslieferung.',
`product_in_use_id` bigint(20) DEFAULT NULL,
`valid_until` date DEFAULT NULL COMMENT '(DC2Type:date_immutable)',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_8DAA971C4584665A9395C3F318F0A375` (`product_id`,`customer_id`,`product_in_use_id`),
KEY `IDX_8DAA971C4584665A` (`product_id`),
KEY `IDX_8DAA971C9395C3F3` (`customer_id`),
KEY `IDX_8DAA971C18F0A375` (`product_in_use_id`),
CONSTRAINT `FK_8DAA971C18F0A375` FOREIGN KEY (`product_in_use_id`) REFERENCES `tbl_customer_product_in_use` (`ID`),
CONSTRAINT `FK_8DAA971C4584665A` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_8DAA971C9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_customer_product_specials`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_customer_product_specials` WRITE;
/*!40000 ALTER TABLE `nbi_customer_product_specials` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_customer_product_specials` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_data_center_space_types`
--
DROP TABLE IF EXISTS `nbi_data_center_space_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_data_center_space_types` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT 'Name des Typs z.B. 1xHE',
`description` longtext DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_9FEAD66A5E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_data_center_space_types`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_data_center_space_types` WRITE;
/*!40000 ALTER TABLE `nbi_data_center_space_types` DISABLE KEYS */;
INSERT INTO `nbi_data_center_space_types` VALUES (1,'MidiTower',NULL),(2,'1 x HE',NULL),(3,'2 x HE',NULL),(4,'Rack',NULL),(5,'3 x HE',NULL),(6,'4 x HE',NULL),(18,'16 x HE',NULL),(98,'virtuell','Kein physikalischer Standort'),(99,'Standort beim Kunden',NULL);
/*!40000 ALTER TABLE `nbi_data_center_space_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_domain_handles`
--
DROP TABLE IF EXISTS `nbi_domain_handles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_domain_handles` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`customer_id` bigint(20) DEFAULT NULL,
`country_id` bigint(20) DEFAULT NULL,
`handle_id_nic_direct` varchar(255) DEFAULT NULL,
`comment` longtext DEFAULT NULL,
`external_customer_ident` varchar(255) DEFAULT NULL,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`company` varchar(255) DEFAULT NULL,
`street` varchar(255) NOT NULL,
`post_code` varchar(255) NOT NULL,
`location` varchar(255) NOT NULL,
`phone_number` varchar(255) NOT NULL,
`fax_number` varchar(255) DEFAULT NULL,
`email_adress` varchar(255) NOT NULL,
`handle_id_internetx` varchar(255) DEFAULT NULL,
`street_number` varchar(255) NOT NULL,
`default_tech_zone` tinyint(1) NOT NULL COMMENT 'true - Default Domainhandle für TechC und ZoneC',
PRIMARY KEY (`id`),
KEY `IDX_D7F3332F9395C3F3` (`customer_id`),
KEY `IDX_D7F3332FF92F3E70` (`country_id`),
CONSTRAINT `FK_D7F3332F9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_D7F3332FF92F3E70` FOREIGN KEY (`country_id`) REFERENCES `tbl_country` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_domain_handles`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_domain_handles` WRITE;
/*!40000 ALTER TABLE `nbi_domain_handles` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_domain_handles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_domain_infos`
--
DROP TABLE IF EXISTS `nbi_domain_infos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_domain_infos` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`product_id` bigint(20) NOT NULL,
`domain_provider_id` bigint(20) NOT NULL,
`created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`last_update` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`price_create` double NOT NULL,
`price_renew` double NOT NULL,
`price_transfer` double DEFAULT NULL,
`price_restore` double DEFAULT NULL,
`price_owner_change` double DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_55D53AF24584665A` (`product_id`),
KEY `IDX_55D53AF2C749FA9` (`domain_provider_id`),
CONSTRAINT `FK_55D53AF24584665A` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_55D53AF2C749FA9` FOREIGN KEY (`domain_provider_id`) REFERENCES `nbi_domain_provider` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_domain_infos`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_domain_infos` WRITE;
/*!40000 ALTER TABLE `nbi_domain_infos` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_domain_infos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_domain_pre_registrations`
--
DROP TABLE IF EXISTS `nbi_domain_pre_registrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_domain_pre_registrations` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`customer_id` bigint(20) DEFAULT NULL,
`nameserver1_id` bigint(20) DEFAULT NULL,
`nameserver2_id` bigint(20) DEFAULT NULL,
`nameserver3_id` bigint(20) DEFAULT NULL,
`nameserver4_id` bigint(20) DEFAULT NULL,
`ownerc_id` bigint(20) DEFAULT NULL,
`adminc_id` bigint(20) DEFAULT NULL,
`techc_id` bigint(20) DEFAULT NULL,
`zonec_id` bigint(20) DEFAULT NULL,
`product_id` bigint(20) DEFAULT NULL,
`name` varchar(255) NOT NULL COMMENT 'Name der Domain z.B. nbiserv.de',
`renew_date` date NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_4E863C5C5E237E06` (`name`),
KEY `IDX_4E863C5C9395C3F3` (`customer_id`),
KEY `IDX_4E863C5CB21DD005` (`nameserver1_id`),
KEY `IDX_4E863C5CA0A87FEB` (`nameserver2_id`),
KEY `IDX_4E863C5C1814188E` (`nameserver3_id`),
KEY `IDX_4E863C5C85C32037` (`nameserver4_id`),
KEY `IDX_4E863C5C73779C63` (`ownerc_id`),
KEY `IDX_4E863C5CAABBD15C` (`adminc_id`),
KEY `IDX_4E863C5C30726F6` (`techc_id`),
KEY `IDX_4E863C5CF6F3BCE5` (`zonec_id`),
KEY `IDX_4E863C5C4584665A` (`product_id`),
CONSTRAINT `FK_4E863C5C1814188E` FOREIGN KEY (`nameserver3_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_4E863C5C30726F6` FOREIGN KEY (`techc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_4E863C5C4584665A` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_4E863C5C73779C63` FOREIGN KEY (`ownerc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_4E863C5C85C32037` FOREIGN KEY (`nameserver4_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_4E863C5C9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_4E863C5CA0A87FEB` FOREIGN KEY (`nameserver2_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_4E863C5CAABBD15C` FOREIGN KEY (`adminc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_4E863C5CB21DD005` FOREIGN KEY (`nameserver1_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_4E863C5CF6F3BCE5` FOREIGN KEY (`zonec_id`) REFERENCES `nbi_domain_handles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_domain_pre_registrations`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_domain_pre_registrations` WRITE;
/*!40000 ALTER TABLE `nbi_domain_pre_registrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_domain_pre_registrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_domain_provider`
--
DROP TABLE IF EXISTS `nbi_domain_provider`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_domain_provider` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT 'Name des DomainProviders z.B. NIC Direct',
`service_name` varchar(255) NOT NULL COMMENT 'Name des Service',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_domain_provider`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_domain_provider` WRITE;
/*!40000 ALTER TABLE `nbi_domain_provider` DISABLE KEYS */;
INSERT INTO `nbi_domain_provider` VALUES (1,'NIC Direct','nicdirect.service'),(2,'InternetX','internetx.service');
/*!40000 ALTER TABLE `nbi_domain_provider` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_domain_transfers`
--
DROP TABLE IF EXISTS `nbi_domain_transfers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_domain_transfers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain_id` bigint(20) NOT NULL,
`created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`start` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
`step` int(11) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_3FAD03D8115F0EE5` (`domain_id`),
CONSTRAINT `FK_3FAD03D8115F0EE5` FOREIGN KEY (`domain_id`) REFERENCES `nbi_domains` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_domain_transfers`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_domain_transfers` WRITE;
/*!40000 ALTER TABLE `nbi_domain_transfers` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_domain_transfers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_domains`
--
DROP TABLE IF EXISTS `nbi_domains`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_domains` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`customer_id` bigint(20) DEFAULT NULL,
`ownerc_id` bigint(20) DEFAULT NULL,
`adminc_id` bigint(20) DEFAULT NULL,
`techc_id` bigint(20) DEFAULT NULL,
`zonec_id` bigint(20) DEFAULT NULL,
`name` varchar(255) NOT NULL COMMENT 'Name der Domain z.B. nbiserv.de',
`domainProvider_id` bigint(20) DEFAULT NULL,
`nameserver1_id` bigint(20) DEFAULT NULL,
`nameserver2_id` bigint(20) DEFAULT NULL,
`nameserver3_id` bigint(20) DEFAULT NULL,
`nameserver4_id` bigint(20) DEFAULT NULL,
`auth_code` varchar(255) DEFAULT NULL COMMENT 'AuthCode der Domain für Umzug',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_D1E66EE95E237E06` (`name`),
KEY `IDX_D1E66EE99395C3F3` (`customer_id`),
KEY `IDX_D1E66EE973779C63` (`ownerc_id`),
KEY `IDX_D1E66EE9AABBD15C` (`adminc_id`),
KEY `IDX_D1E66EE930726F6` (`techc_id`),
KEY `IDX_D1E66EE9F6F3BCE5` (`zonec_id`),
KEY `IDX_D1E66EE97E06CB40` (`domainProvider_id`),
KEY `IDX_D1E66EE9B21DD005` (`nameserver1_id`),
KEY `IDX_D1E66EE9A0A87FEB` (`nameserver2_id`),
KEY `IDX_D1E66EE91814188E` (`nameserver3_id`),
KEY `IDX_D1E66EE985C32037` (`nameserver4_id`),
CONSTRAINT `FK_D1E66EE91814188E` FOREIGN KEY (`nameserver3_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_D1E66EE930726F6` FOREIGN KEY (`techc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_D1E66EE973779C63` FOREIGN KEY (`ownerc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_D1E66EE97E06CB40` FOREIGN KEY (`domainProvider_id`) REFERENCES `nbi_domain_provider` (`id`),
CONSTRAINT `FK_D1E66EE985C32037` FOREIGN KEY (`nameserver4_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_D1E66EE99395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_D1E66EE9A0A87FEB` FOREIGN KEY (`nameserver2_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_D1E66EE9AABBD15C` FOREIGN KEY (`adminc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_D1E66EE9B21DD005` FOREIGN KEY (`nameserver1_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_D1E66EE9F6F3BCE5` FOREIGN KEY (`zonec_id`) REFERENCES `nbi_domain_handles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_domains`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_domains` WRITE;
/*!40000 ALTER TABLE `nbi_domains` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_domains` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_enviatel_import`
--
DROP TABLE IF EXISTS `nbi_enviatel_import`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_enviatel_import` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`customer_number` varchar(255) NOT NULL COMMENT 'Kundennummer',
`debitor_number` varchar(255) NOT NULL COMMENT 'Debitorennummer',
`pay_scale` varchar(255) NOT NULL COMMENT 'Tarif',
`pay_scale_zone` varchar(255) NOT NULL COMMENT 'Tarifzone',
`pay_scale_time` varchar(255) NOT NULL COMMENT 'Tarifzeit',
`calling_number_international_area_code` varchar(255) NOT NULL COMMENT 'Anrufende Telefonnummer Ländervorwahl',
`calling_number_area_code` varchar(255) NOT NULL COMMENT 'Anrufende Telefonnummer Vorwahl',
`calling_number` varchar(255) NOT NULL COMMENT 'Anrufende Telefonnummer',
`calling_number_complete` varchar(255) NOT NULL COMMENT 'Anrufende Telefonnummer komplett',
`calling_start` datetime NOT NULL COMMENT 'Begin des Anrufes',
`calling_duration` varchar(255) NOT NULL COMMENT 'Dauer des Anrufes',
`called_number_international_area_code` varchar(255) NOT NULL COMMENT 'Angerufene Telefonnummer Ländervorwahl',
`called_number_area_code` varchar(255) NOT NULL COMMENT 'Angerufene Telefonnummer Vorwahl',
`called_number` varchar(255) NOT NULL COMMENT 'Angerufene Telefonnummer',
`called_number_complete` varchar(255) NOT NULL COMMENT 'Angerufene Telefonnummer komplett',
`netto_amount` double NOT NULL COMMENT 'Nettobetrag',
`provider` varchar(255) NOT NULL COMMENT 'Provider',
`created` datetime NOT NULL,
`hash` varchar(255) NOT NULL COMMENT 'SHA-512 Hash der CSV Zeile',
`processed` tinyint(1) NOT NULL COMMENT 'Eintrag wurde vollständig verarbeitet',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_C4AA57FD1B862B8` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_enviatel_import`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_enviatel_import` WRITE;
/*!40000 ALTER TABLE `nbi_enviatel_import` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_enviatel_import` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_enviatel_itemised_bill_items`
--
DROP TABLE IF EXISTS `nbi_enviatel_itemised_bill_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_enviatel_itemised_bill_items` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_customer_product_in_use_id` bigint(20) NOT NULL,
`nbi_enviatel_import_id` bigint(20) DEFAULT NULL,
`nbi_enviatel_pay_scale_id` bigint(20) DEFAULT NULL,
`netto_amount` double NOT NULL COMMENT 'Nettobetrag',
`units` int(11) NOT NULL COMMENT 'Einheiten',
`created` datetime NOT NULL,
`pay_scale_description` varchar(255) NOT NULL COMMENT 'Beschreibung des Tarifs',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_F670C9B57C950A73` (`nbi_enviatel_import_id`),
KEY `IDX_F670C9B51191864` (`tbl_customer_product_in_use_id`),
KEY `IDX_F670C9B5230C1EA0` (`nbi_enviatel_pay_scale_id`),
CONSTRAINT `FK_F670C9B51191864` FOREIGN KEY (`tbl_customer_product_in_use_id`) REFERENCES `tbl_customer_product_in_use` (`ID`),
CONSTRAINT `FK_F670C9B5230C1EA0` FOREIGN KEY (`nbi_enviatel_pay_scale_id`) REFERENCES `nbi_enviatel_pay_scale` (`id`),
CONSTRAINT `FK_F670C9B57C950A73` FOREIGN KEY (`nbi_enviatel_import_id`) REFERENCES `nbi_enviatel_import` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_enviatel_itemised_bill_items`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_enviatel_itemised_bill_items` WRITE;
/*!40000 ALTER TABLE `nbi_enviatel_itemised_bill_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_enviatel_itemised_bill_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_enviatel_pay_scale`
--
DROP TABLE IF EXISTS `nbi_enviatel_pay_scale`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_enviatel_pay_scale` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`csv_descriptor` varchar(255) NOT NULL COMMENT 'Tarifbezeichner in der CSV Datei',
`description` varchar(255) NOT NULL COMMENT 'Tarifbezeichner auf Rechnung',
`netto_amount` double NOT NULL COMMENT 'Nettobetrag',
`free_on_flat` tinyint(1) NOT NULL COMMENT 'Keine Kosten, wenn Kunde eine Flat hat.',
`timing_in_seconds` int(11) NOT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_6E90E3B7E610D0FD` (`csv_descriptor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_enviatel_pay_scale`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_enviatel_pay_scale` WRITE;
/*!40000 ALTER TABLE `nbi_enviatel_pay_scale` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_enviatel_pay_scale` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_enviatel_phone_number`
--
DROP TABLE IF EXISTS `nbi_enviatel_phone_number`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_enviatel_phone_number` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_customer_id` bigint(20) NOT NULL,
`created` datetime NOT NULL,
`country_code` varchar(255) NOT NULL DEFAULT '49' COMMENT 'Ländervorwwahl des Enviatel Kunden',
`local_area_code` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Lokale Vorwwahl des Enviatel Kunden',
`base_number` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Nummer des Enviatel Kunden (ohne Vorwahl)',
`cfu` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Sofortige Rufumleitung (CFU)',
`cfu_number` varchar(255) NOT NULL DEFAULT '' COMMENT 'Sofortige Rufumleitung (CFU) Umleitungsziel',
`cfbu` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Rufweiterschaltung im Fehlerfall (CFBU)',
`cfbu_number` varchar(255) NOT NULL DEFAULT '' COMMENT 'Rufweiterschaltung im Fehlerfall (CFBU) Umleitungsziel',
`cfb` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Rufumleitung nur falls besetzt (CFB)',
`cfb_number` varchar(255) NOT NULL DEFAULT '' COMMENT 'Rufumleitung nur falls besetzt (CFB) Umleitungsziel',
`cfnr` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Rufumleitung nach festgelegter Zeitspanne (CFNR)',
`cfnr_number` varchar(255) NOT NULL DEFAULT '' COMMENT 'Rufumleitung nach festgelegter Zeitspanne (CFNR) Umleitungsziel',
`cfnr_timespan` smallint(6) NOT NULL DEFAULT 5 COMMENT 'Rufumleitung nach festgelegter Zeitspanne (CFNR) festgelegte Zeitspanne (sek)',
`cw` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Anklopfen (CW)',
`colr` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Angerufenen (COLR)',
`clir` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Rufnummernunterdrückung für ausgehende Rufe (CLIR)',
`acr` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Abweisen von Rufen mitRufnummernunterdrückung (ACR)',
`dnd` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Nicht stören: Anrufe auf Ansage umleiten (DND)',
PRIMARY KEY (`id`),
UNIQUE KEY `phone_number_unique` (`country_code`,`local_area_code`,`base_number`),
KEY `IDX_B36C11C614F4236B` (`tbl_customer_id`),
CONSTRAINT `FK_B36C11C614F4236B` FOREIGN KEY (`tbl_customer_id`) REFERENCES `tbl_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_enviatel_phone_number`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_enviatel_phone_number` WRITE;
/*!40000 ALTER TABLE `nbi_enviatel_phone_number` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_enviatel_phone_number` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_faq_entry`
--
DROP TABLE IF EXISTS `nbi_faq_entry`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_faq_entry` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`group_id` bigint(20) NOT NULL,
`created` datetime NOT NULL,
`creator` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`content` longtext NOT NULL,
`visibility` smallint(6) NOT NULL,
`slug` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug_idx` (`slug`),
KEY `IDX_35724458FE54D947` (`group_id`),
CONSTRAINT `FK_35724458FE54D947` FOREIGN KEY (`group_id`) REFERENCES `nbi_faq_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_faq_entry`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_faq_entry` WRITE;
/*!40000 ALTER TABLE `nbi_faq_entry` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_faq_entry` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_faq_group`
--
DROP TABLE IF EXISTS `nbi_faq_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_faq_group` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`description` varchar(2000) DEFAULT NULL,
`visibility` smallint(6) NOT NULL,
`parentGroup_id` bigint(20) DEFAULT NULL,
`slug` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug_idx` (`slug`),
KEY `IDX_73939DED1222E2A` (`parentGroup_id`),
CONSTRAINT `FK_73939DED1222E2A` FOREIGN KEY (`parentGroup_id`) REFERENCES `nbi_faq_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_faq_group`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_faq_group` WRITE;
/*!40000 ALTER TABLE `nbi_faq_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_faq_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_group`
--
DROP TABLE IF EXISTS `nbi_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(180) NOT NULL,
`roles` longtext NOT NULL COMMENT '(DC2Type:array)',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_A872E9925E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_group`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_group` WRITE;
/*!40000 ALTER TABLE `nbi_group` DISABLE KEYS */;
INSERT INTO `nbi_group` VALUES (1,'Admin','a:8:{i:0;s:12:\"ROLE_BACKEND\";i:1;s:10:\"ROLE_ADMIN\";i:2;s:9:\"ROLE_TECH\";i:3;s:13:\"ROLE_TECH_MOD\";i:4;s:9:\"ROLE_FIBU\";i:5;s:13:\"ROLE_FIBU_MOD\";i:6;s:22:\"ROLE_ALLOWED_TO_SWITCH\";i:7;s:15:\"ROLE_FAQ_EDITOR\";}'),(2,'FiBu','a:5:{i:0;s:12:\"ROLE_BACKEND\";i:1;s:9:\"ROLE_TECH\";i:2;s:9:\"ROLE_FIBU\";i:3;s:13:\"ROLE_FIBU_MOD\";i:4;s:22:\"ROLE_ALLOWED_TO_SWITCH\";}'),(3,'Techniker','a:5:{i:0;s:12:\"ROLE_BACKEND\";i:1;s:9:\"ROLE_TECH\";i:2;s:13:\"ROLE_TECH_MOD\";i:3;s:22:\"ROLE_ALLOWED_TO_SWITCH\";i:4;s:15:\"ROLE_FAQ_EDITOR\";}'),(4,'Kunde','a:1:{i:0;s:13:\"ROLE_CUSTOMER\";}'),(5,'Praktikant','a:2:{i:0;s:12:\"ROLE_BACKEND\";i:1;s:15:\"ROLE_FAQ_EDITOR\";}');
/*!40000 ALTER TABLE `nbi_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_image`
--
DROP TABLE IF EXISTS `nbi_image`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_image` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`virtualization_id` bigint(20) NOT NULL,
`operating_system_id` bigint(20) NOT NULL,
`name` varchar(255) NOT NULL,
`additional_software` longtext DEFAULT NULL COMMENT '(DC2Type:array)',
`admin_software_user` varchar(255) DEFAULT NULL COMMENT 'Admin User der Verwaltungssoftware',
`admin_software_url` varchar(255) DEFAULT NULL COMMENT 'Default Link zum Login',
`ordering` int(11) DEFAULT 999 COMMENT 'Reihenfolge in der es angezeigt wird',
`os_user` varchar(255) DEFAULT 'root' COMMENT 'Betriebssystem User',
`estimated_installation_time` bigint(20) DEFAULT NULL COMMENT 'ca. Zeit fuer die Installation',
`product_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_8FA908C7D7A703` (`virtualization_id`),
KEY `IDX_8FA908A391D4AD` (`operating_system_id`),
KEY `IDX_8FA9084584665A` (`product_id`),
CONSTRAINT `FK_8FA9084584665A` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_8FA908A391D4AD` FOREIGN KEY (`operating_system_id`) REFERENCES `tbl_manage_os` (`id`),
CONSTRAINT `FK_8FA908C7D7A703` FOREIGN KEY (`virtualization_id`) REFERENCES `nbi_virtualization` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_image`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_image` WRITE;
/*!40000 ALTER TABLE `nbi_image` DISABLE KEYS */;
INSERT INTO `nbi_image` VALUES (1,2,10021,'debian-11-standard','a:1:{i:0;s:7:\"Minimal\";}',NULL,NULL,2,'root',NULL,NULL),(11,2,10021,'debian-11-standard','a:0:{}',NULL,NULL,1,'root',NULL,NULL),(16,3,10031,'netboot','a:2:{i:0;s:4:\"BETA\";i:1;s:3:\"VNC\";}',NULL,NULL,900,'keine Angabe',NULL,NULL),(20,2,10035,'https://dl.nbisuite.de/iso/windows/Win2k19Eva.iso','a:3:{i:0;s:4:\"BETA\";i:1;s:3:\"VNC\";i:2;s:7:\"Minimal\";}',NULL,NULL,2,'Administrator',NULL,NULL),(21,2,10036,'https://dl.nbisuite.de/iso/windows/Win2k22Eva.iso','a:3:{i:0;s:4:\"BETA\";i:1;s:3:\"VNC\";i:2;s:7:\"Minimal\";}',NULL,NULL,1,'Administrator',NULL,NULL),(22,3,10037,'https://dl.nbisuite.de/iso/windows/Win10.iso','a:3:{i:0;s:4:\"BETA\";i:1;s:3:\"VNC\";i:2;s:7:\"Minimal\";}',NULL,NULL,1,'Administrator',NULL,NULL),(23,3,10038,'https://dl.nbisuite.de/iso/windows/Win11.iso','a:3:{i:0;s:4:\"BETA\";i:1;s:3:\"VNC\";i:2;s:7:\"Minimal\";}',NULL,NULL,2,'Administrator',NULL,NULL);
/*!40000 ALTER TABLE `nbi_image` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_incoming_bills`
--
DROP TABLE IF EXISTS `nbi_incoming_bills`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_incoming_bills` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`nbi_vendor_product_id` bigint(20) NOT NULL,
`bill_number` varchar(255) NOT NULL COMMENT 'Rechnungsnummer',
`booking_user` varchar(255) NOT NULL COMMENT 'Benutzer der die Buchung durchgeführt hat',
`booking_date` date NOT NULL COMMENT 'Datum der Buchung',
`comment` varchar(255) NOT NULL COMMENT 'Kommentar',
`booking_type` smallint(6) NOT NULL COMMENT '1 - Bank, 2 - PayPal, 3 - Bargeschaefte',
`back_booking` smallint(6) NOT NULL COMMENT '0 - Normale Buchung, 1 - Rückbuchung, 2 - Gutschrift',
`amount` double NOT NULL,
`created` datetime NOT NULL,
`order_number` int(11) DEFAULT NULL COMMENT 'Sortierreihenfolge der Buchung dient auch zur Ermittlung der Datei',
`vat_percent` double DEFAULT NULL,
`bill_document_path` varchar(1024) DEFAULT NULL COMMENT 'Ermittelte Datei',
PRIMARY KEY (`id`),
KEY `IDX_C556418D5A8EBF2` (`nbi_vendor_product_id`),
CONSTRAINT `FK_C556418D5A8EBF2` FOREIGN KEY (`nbi_vendor_product_id`) REFERENCES `nbi_vendor_products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Eingangsrechnungen';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_incoming_bills`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_incoming_bills` WRITE;
/*!40000 ALTER TABLE `nbi_incoming_bills` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_incoming_bills` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_inventory_item_histories`
--
DROP TABLE IF EXISTS `nbi_inventory_item_histories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_inventory_item_histories` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`editor_id` int(11) NOT NULL,
`item_id` bigint(20) NOT NULL,
`created` datetime NOT NULL,
`comment` longtext NOT NULL COMMENT 'Beschreibung für den Grund warum das Teil geändert wurde.',
`locationFrom_id` bigint(20) NOT NULL,
`locationTo_id` bigint(20) NOT NULL,
`incomingBillFrom_id` bigint(20) DEFAULT NULL,
`incomingBillTo_id` bigint(20) DEFAULT NULL,
`billFrom_id` bigint(20) DEFAULT NULL,
`billTo_id` bigint(20) DEFAULT NULL,
`activeReminderFrom` tinyint(1) NOT NULL,
`activeReminderTo` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_32F218165328F16` (`locationFrom_id`),
KEY `IDX_32F218162CD5A03A` (`locationTo_id`),
KEY `IDX_32F218166995AC4C` (`editor_id`),
KEY `IDX_32F21816126F525E` (`item_id`),
KEY `FK_32F21816864B91B6` (`incomingBillFrom_id`),
KEY `FK_32F21816BDFEE854` (`incomingBillTo_id`),
KEY `FK_32F2181659C14902` (`billFrom_id`),
KEY `FK_32F218165FCE7DD0` (`billTo_id`),
CONSTRAINT `FK_32F21816126F525E` FOREIGN KEY (`item_id`) REFERENCES `nbi_inventory_items` (`id`),
CONSTRAINT `FK_32F218162CD5A03A` FOREIGN KEY (`locationTo_id`) REFERENCES `nbi_inventory_locations` (`id`),
CONSTRAINT `FK_32F218165328F16` FOREIGN KEY (`locationFrom_id`) REFERENCES `nbi_inventory_locations` (`id`),
CONSTRAINT `FK_32F2181659C14902` FOREIGN KEY (`billFrom_id`) REFERENCES `tbl_bills` (`id`),
CONSTRAINT `FK_32F218165FCE7DD0` FOREIGN KEY (`billTo_id`) REFERENCES `tbl_bills` (`id`),
CONSTRAINT `FK_32F218166995AC4C` FOREIGN KEY (`editor_id`) REFERENCES `nbi_user` (`id`),
CONSTRAINT `FK_32F21816864B91B6` FOREIGN KEY (`incomingBillFrom_id`) REFERENCES `nbi_incoming_bills` (`id`),
CONSTRAINT `FK_32F21816BDFEE854` FOREIGN KEY (`incomingBillTo_id`) REFERENCES `nbi_incoming_bills` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_inventory_item_histories`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_inventory_item_histories` WRITE;
/*!40000 ALTER TABLE `nbi_inventory_item_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_inventory_item_histories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_inventory_items`
--
DROP TABLE IF EXISTS `nbi_inventory_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_inventory_items` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`location_id` bigint(20) NOT NULL,
`bill_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`name` varchar(255) NOT NULL COMMENT 'Name des Inventar Stücks.',
`description` longtext DEFAULT NULL COMMENT 'Beschreibung zum Inventar Stück.',
`autoTrashDate` date DEFAULT NULL,
`incomingBill_id` bigint(20) DEFAULT NULL,
`last_update` datetime NOT NULL,
`activeReminder` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_7957DB3164D218E` (`location_id`),
KEY `IDX_7957DB31FD463D2D` (`incomingBill_id`),
KEY `IDX_7957DB311A8C12F5` (`bill_id`),
CONSTRAINT `FK_7957DB311A8C12F5` FOREIGN KEY (`bill_id`) REFERENCES `tbl_bills` (`id`),
CONSTRAINT `FK_7957DB3164D218E` FOREIGN KEY (`location_id`) REFERENCES `nbi_inventory_locations` (`id`),
CONSTRAINT `FK_7957DB31FD463D2D` FOREIGN KEY (`incomingBill_id`) REFERENCES `nbi_incoming_bills` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_inventory_items`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_inventory_items` WRITE;
/*!40000 ALTER TABLE `nbi_inventory_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_inventory_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_inventory_locations`
--
DROP TABLE IF EXISTS `nbi_inventory_locations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_inventory_locations` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`server_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`name` varchar(255) NOT NULL COMMENT 'Name des Inventar Ortes.',
`description` longtext DEFAULT NULL COMMENT 'Beschreibung zum Inventar Orte.',
`initialLocation` tinyint(1) NOT NULL,
`parentLocation_id` bigint(20) DEFAULT NULL,
`maintenanceLocation_id` bigint(20) DEFAULT NULL,
`externalId` varchar(255) DEFAULT NULL COMMENT 'Externer Identifikator des Steuerberaters.',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_CE8F8B5A5E237E06` (`name`),
UNIQUE KEY `UNIQ_CE8F8B5A1844E6B7` (`server_id`),
UNIQUE KEY `UNIQ_CE8F8B5AC4DDDEAF` (`maintenanceLocation_id`),
UNIQUE KEY `UNIQ_CE8F8B5AA770AC6E` (`externalId`),
KEY `IDX_CE8F8B5AA4D9DA71` (`parentLocation_id`),
CONSTRAINT `FK_CE8F8B5A1844E6B7` FOREIGN KEY (`server_id`) REFERENCES `tbl_manage_server` (`id`),
CONSTRAINT `FK_CE8F8B5AA4D9DA71` FOREIGN KEY (`parentLocation_id`) REFERENCES `nbi_inventory_locations` (`id`),
CONSTRAINT `FK_CE8F8B5AC4DDDEAF` FOREIGN KEY (`maintenanceLocation_id`) REFERENCES `nbi_maintenance_locations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_inventory_locations`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_inventory_locations` WRITE;
/*!40000 ALTER TABLE `nbi_inventory_locations` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_inventory_locations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ip_whitelist`
--
DROP TABLE IF EXISTS `nbi_ip_whitelist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ip_whitelist` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ip` varchar(128) NOT NULL,
`created` datetime NOT NULL,
`creator` varchar(64) NOT NULL,
`reason` longtext NOT NULL,
`until` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ip_whitelist`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ip_whitelist` WRITE;
/*!40000 ALTER TABLE `nbi_ip_whitelist` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_ip_whitelist` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_job_schedule`
--
DROP TABLE IF EXISTS `nbi_job_schedule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_job_schedule` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`server_id` bigint(20) NOT NULL,
`child_server_id` bigint(20) NOT NULL,
`operating_system_id` bigint(20) DEFAULT NULL,
`type` varchar(255) NOT NULL,
`created` datetime NOT NULL,
`last_update` datetime NOT NULL,
`executed` datetime DEFAULT NULL,
`status` varchar(1) NOT NULL,
`parameter` longtext DEFAULT NULL,
`result` longtext DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_551B24C91844E6B7` (`server_id`),
KEY `IDX_551B24C9C975863B` (`child_server_id`),
KEY `IDX_551B24C9A391D4AD` (`operating_system_id`),
CONSTRAINT `FK_551B24C91844E6B7` FOREIGN KEY (`server_id`) REFERENCES `tbl_manage_server` (`id`),
CONSTRAINT `FK_551B24C9A391D4AD` FOREIGN KEY (`operating_system_id`) REFERENCES `tbl_manage_os` (`id`),
CONSTRAINT `FK_551B24C9C975863B` FOREIGN KEY (`child_server_id`) REFERENCES `tbl_manage_server` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_job_schedule`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_job_schedule` WRITE;
/*!40000 ALTER TABLE `nbi_job_schedule` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_job_schedule` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_login_attempt`
--
DROP TABLE IF EXISTS `nbi_login_attempt`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_login_attempt` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ip` varchar(255) NOT NULL,
`count` int(11) NOT NULL,
`blocked_until` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_login_attempt`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_login_attempt` WRITE;
/*!40000 ALTER TABLE `nbi_login_attempt` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_login_attempt` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_maintenance_categories`
--
DROP TABLE IF EXISTS `nbi_maintenance_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_maintenance_categories` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_maintenance_categories`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_maintenance_categories` WRITE;
/*!40000 ALTER TABLE `nbi_maintenance_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_maintenance_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_maintenance_info`
--
DROP TABLE IF EXISTS `nbi_maintenance_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_maintenance_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`subject` varchar(255) NOT NULL,
`message` longtext NOT NULL,
`last_update` datetime NOT NULL,
`start` datetime NOT NULL,
`end` datetime DEFAULT NULL,
`mail_send_time` datetime DEFAULT NULL COMMENT 'Zeitpunkt zu dem der Mailversand gestartet wurde.',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_maintenance_info`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_maintenance_info` WRITE;
/*!40000 ALTER TABLE `nbi_maintenance_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_maintenance_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_maintenance_item_templates`
--
DROP TABLE IF EXISTS `nbi_maintenance_item_templates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_maintenance_item_templates` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` longtext DEFAULT NULL,
`created` datetime NOT NULL,
`type` smallint(6) NOT NULL,
`unit` varchar(255) DEFAULT NULL,
`validation` varchar(255) DEFAULT NULL,
`active` tinyint(1) NOT NULL,
`category_id` bigint(20) DEFAULT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_AFB2762912469DE2` (`category_id`),
CONSTRAINT `FK_AFB2762912469DE2` FOREIGN KEY (`category_id`) REFERENCES `nbi_maintenance_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_maintenance_item_templates`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_maintenance_item_templates` WRITE;
/*!40000 ALTER TABLE `nbi_maintenance_item_templates` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_maintenance_item_templates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_maintenance_items`
--
DROP TABLE IF EXISTS `nbi_maintenance_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_maintenance_items` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`template_id` bigint(20) DEFAULT NULL,
`maintenance_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`value` varchar(1024) DEFAULT NULL,
`comment` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_795A2D795DA0FB8` (`template_id`),
KEY `IDX_795A2D79F6C202BC` (`maintenance_id`),
CONSTRAINT `FK_795A2D795DA0FB8` FOREIGN KEY (`template_id`) REFERENCES `nbi_maintenance_item_templates` (`id`),
CONSTRAINT `FK_795A2D79F6C202BC` FOREIGN KEY (`maintenance_id`) REFERENCES `nbi_maintenances` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_maintenance_items`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_maintenance_items` WRITE;
/*!40000 ALTER TABLE `nbi_maintenance_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_maintenance_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_maintenance_locations`
--
DROP TABLE IF EXISTS `nbi_maintenance_locations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_maintenance_locations` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_maintenance_locations`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_maintenance_locations` WRITE;
/*!40000 ALTER TABLE `nbi_maintenance_locations` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_maintenance_locations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_maintenances`
--
DROP TABLE IF EXISTS `nbi_maintenances`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_maintenances` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`location_id` bigint(20) DEFAULT NULL,
`creator` varchar(255) NOT NULL,
`confirmed` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_AA93816664D218E` (`location_id`),
CONSTRAINT `FK_AA93816664D218E` FOREIGN KEY (`location_id`) REFERENCES `nbi_maintenance_locations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_maintenances`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_maintenances` WRITE;
/*!40000 ALTER TABLE `nbi_maintenances` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_maintenances` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_nameservers`
--
DROP TABLE IF EXISTS `nbi_nameservers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_nameservers` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`customer_id` bigint(20) DEFAULT NULL,
`name` varchar(255) NOT NULL COMMENT 'Name des Nameservers',
`ipv4` varchar(255) NOT NULL COMMENT 'IPv4 Adresse des Nameservers',
`ipv6` varchar(255) DEFAULT NULL COMMENT 'IPv6 Adresse des Nameservers',
`global_ns` tinyint(1) NOT NULL COMMENT 'Globaler Nameserver kann von allen Kunden genutzt werden.',
PRIMARY KEY (`id`),
KEY `IDX_9E230EB9395C3F3` (`customer_id`),
CONSTRAINT `FK_9E230EB9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_nameservers`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_nameservers` WRITE;
/*!40000 ALTER TABLE `nbi_nameservers` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_nameservers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_network_port`
--
DROP TABLE IF EXISTS `nbi_network_port`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_network_port` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`server_id` bigint(20) NOT NULL,
`parent_port_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`number` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`mac_count_max` smallint(6) NOT NULL,
`speed_mbit` smallint(6) NOT NULL,
`security` tinyint(1) NOT NULL,
`auto_negotiation` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 / true -> AutoNegotiation on',
`poe_type` smallint(6) NOT NULL DEFAULT 0 COMMENT '0 - disabled see NetworkPort::POE_*',
`incoming_mbps_warn` int(11) NOT NULL DEFAULT 10 COMMENT 'incoming mbps > then warn',
`outgoing_mbps_warn` int(11) NOT NULL DEFAULT 10 COMMENT 'outgoing mbps > then warn',
`incoming_mbps_crit` int(11) NOT NULL DEFAULT 20 COMMENT 'incoming mbps > then error',
`outgoing_mbps_crit` int(11) NOT NULL DEFAULT 20 COMMENT 'outgoing mbps > then error',
`min_mbps_warn` int(11) NOT NULL DEFAULT 1 COMMENT 'minimum expected MBps for this port',
`active` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'port is up or down',
`stand_by_trunk_port` tinyint(1) NOT NULL COMMENT 'Port für Netzwerk RING - Trunk alle vLANS',
`check_cable_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Soll der Kabelstatus am Port geprüft werden',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_50A80EF24A15EDA` (`parent_port_id`),
KEY `IDX_50A80EF21844E6B7` (`server_id`),
CONSTRAINT `FK_50A80EF21844E6B7` FOREIGN KEY (`server_id`) REFERENCES `tbl_manage_server` (`id`),
CONSTRAINT `FK_50A80EF24A15EDA` FOREIGN KEY (`parent_port_id`) REFERENCES `nbi_network_port` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_network_port`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_network_port` WRITE;
/*!40000 ALTER TABLE `nbi_network_port` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_network_port` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_news_type`
--
DROP TABLE IF EXISTS `nbi_news_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_news_type` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`customer_field` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_news_type`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_news_type` WRITE;
/*!40000 ALTER TABLE `nbi_news_type` DISABLE KEYS */;
INSERT INTO `nbi_news_type` VALUES (1,'Allgemein','newsGeneral'),(2,'Technik','newsTechnology'),(3,'Produkte','newsProducts'),(4,'Domains','newsDomains'),(5,'Wartung','newsMaintenance');
/*!40000 ALTER TABLE `nbi_news_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_notification`
--
DROP TABLE IF EXISTS `nbi_notification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_notification` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL COMMENT 'Titel der Benachrichtigung.',
`description` longtext NOT NULL COMMENT 'Text der Benachrichtigung.',
`created` datetime NOT NULL,
`severity` varchar(255) NOT NULL COMMENT 'Wichtigkeit der Benachrichtigung. (info, warning, danger)',
`repeat_count` int(11) NOT NULL COMMENT 'Anzahl der Wiederholungen.',
`repeat_current` int(11) NOT NULL COMMENT 'Bereits getätigte der Wiederholungen.',
`repeat_intervall` int(11) NOT NULL COMMENT 'Abstand der Wiederholungen in Sekunden.',
`repeat_next` datetime DEFAULT NULL COMMENT 'Zeitpunkt der nächsten Wiederholung.',
`confirmation_type` smallint(6) NOT NULL COMMENT '0 - alle müssen bestätigen, 1 - nur einer muss bestätigen',
`recipient_email` varchar(255) DEFAULT NULL COMMENT 'E-Mail Adresse die benachrichtigt werden soll.',
`creator` varchar(255) NOT NULL COMMENT 'Ersteller der Benachrichtigung.',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_notification`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_notification` WRITE;
/*!40000 ALTER TABLE `nbi_notification` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_notification` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_notification_confirmation`
--
DROP TABLE IF EXISTS `nbi_notification_confirmation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_notification_confirmation` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`nbi_notification_id` bigint(20) NOT NULL,
`nbi_user_id` int(11) NOT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_3DC94068ABCF04F8` (`nbi_notification_id`),
KEY `IDX_3DC94068FAF302E1` (`nbi_user_id`),
CONSTRAINT `FK_3DC94068ABCF04F8` FOREIGN KEY (`nbi_notification_id`) REFERENCES `nbi_notification` (`id`),
CONSTRAINT `FK_3DC94068FAF302E1` FOREIGN KEY (`nbi_user_id`) REFERENCES `nbi_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_notification_confirmation`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_notification_confirmation` WRITE;
/*!40000 ALTER TABLE `nbi_notification_confirmation` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_notification_confirmation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_pay_time_interval`
--
DROP TABLE IF EXISTS `nbi_pay_time_interval`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_pay_time_interval` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`translation_key` varchar(255) NOT NULL COMMENT 'Übersetzungsschlüssel.',
`factor` int(11) DEFAULT NULL COMMENT 'Faktor (multiplikator) auf monatsbasis 0 entsprich keine Berechnung null entsprich einmalige Berechnung',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4214 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_pay_time_interval`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_pay_time_interval` WRITE;
/*!40000 ALTER TABLE `nbi_pay_time_interval` DISABLE KEYS */;
INSERT INTO `nbi_pay_time_interval` VALUES (1,'paytimeinterval.month',1),(2,'paytimeinterval.threeMonth',3),(3,'paytimeinterval.sixMonth',6),(4,'paytimeinterval.year',12),(5,'paytimeinterval.twoYear',24),(8,'paytimeinterval.once',NULL),(10,'paytimeinterval.noPayment',0);
/*!40000 ALTER TABLE `nbi_pay_time_interval` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_posting_accounts`
--
DROP TABLE IF EXISTS `nbi_posting_accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_posting_accounts` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT 'Bezeichnung',
`bookkeeping_ident` varchar(255) NOT NULL COMMENT 'Buchhaltungsidentifier',
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Buchhaltungskonten';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_posting_accounts`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_posting_accounts` WRITE;
/*!40000 ALTER TABLE `nbi_posting_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_posting_accounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_prepaid_payment`
--
DROP TABLE IF EXISTS `nbi_prepaid_payment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_prepaid_payment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`bill_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`netto_price` double NOT NULL,
`productInUse_id` bigint(20) NOT NULL,
`booking_date` date DEFAULT NULL,
`brutto_price` double NOT NULL,
`discount` double NOT NULL DEFAULT 0 COMMENT 'Rabatt in Prozent.',
`parent_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_68A8D3955A21D392` (`productInUse_id`),
KEY `IDX_68A8D3951A8C12F5` (`bill_id`),
KEY `IDX_68A8D395727ACA70` (`parent_id`),
CONSTRAINT `FK_68A8D3951A8C12F5` FOREIGN KEY (`bill_id`) REFERENCES `tbl_bills` (`id`),
CONSTRAINT `FK_68A8D3955A21D392` FOREIGN KEY (`productInUse_id`) REFERENCES `tbl_customer_product_in_use` (`ID`),
CONSTRAINT `FK_68A8D395727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `nbi_prepaid_payment` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_prepaid_payment`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_prepaid_payment` WRITE;
/*!40000 ALTER TABLE `nbi_prepaid_payment` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_prepaid_payment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_product_group_has_module`
--
DROP TABLE IF EXISTS `nbi_product_group_has_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_product_group_has_module` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_product_group_id` bigint(20) NOT NULL,
`tbl_module_id` bigint(20) NOT NULL,
`is_optional` tinyint(1) NOT NULL,
`group_modules` varchar(32) DEFAULT NULL,
`iter_step` int(11) DEFAULT NULL,
`iter_min` int(11) DEFAULT NULL,
`iter_max` int(11) DEFAULT NULL,
`iter_unit` varchar(20) DEFAULT NULL,
`order_number` int(11) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_322DCF7E3F3A31A2` (`tbl_product_group_id`),
KEY `IDX_322DCF7EEA4ADA02` (`tbl_module_id`),
CONSTRAINT `FK_322DCF7E3F3A31A2` FOREIGN KEY (`tbl_product_group_id`) REFERENCES `tbl_product_group` (`id`),
CONSTRAINT `FK_322DCF7EEA4ADA02` FOREIGN KEY (`tbl_module_id`) REFERENCES `tbl_module` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_product_group_has_module`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_product_group_has_module` WRITE;
/*!40000 ALTER TABLE `nbi_product_group_has_module` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_product_group_has_module` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_product_mail_gateway`
--
DROP TABLE IF EXISTS `nbi_product_mail_gateway`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_product_mail_gateway` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`domain` varchar(255) NOT NULL,
`host` varchar(255) NOT NULL,
`port` int(11) NOT NULL,
`use_mx` tinyint(1) NOT NULL,
`used_to_send` tinyint(1) NOT NULL,
`trusted_network` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_product_mail_gateway`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_product_mail_gateway` WRITE;
/*!40000 ALTER TABLE `nbi_product_mail_gateway` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_product_mail_gateway` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_product_nbi_suite`
--
DROP TABLE IF EXISTS `nbi_product_nbi_suite`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_product_nbi_suite` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`product_in_use_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`last_update` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`count_customer` int(11) NOT NULL,
`count_staff` int(11) NOT NULL,
`api_key` varchar(255) NOT NULL,
`user` varchar(255) NOT NULL,
`password` varchar(1024) NOT NULL,
`domain` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_B477A63318F0A375` (`product_in_use_id`),
CONSTRAINT `FK_B477A63318F0A375` FOREIGN KEY (`product_in_use_id`) REFERENCES `tbl_customer_product_in_use` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_product_nbi_suite`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_product_nbi_suite` WRITE;
/*!40000 ALTER TABLE `nbi_product_nbi_suite` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_product_nbi_suite` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_project`
--
DROP TABLE IF EXISTS `nbi_project`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_project` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` longtext NOT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`project_start` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`project_end` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
`budget_type` smallint(6) NOT NULL,
`budget` double DEFAULT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_722E019A9395C3F3` (`customer_id`),
CONSTRAINT `FK_722E019A9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_project`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_project` WRITE;
/*!40000 ALTER TABLE `nbi_project` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_project` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_project_task`
--
DROP TABLE IF EXISTS `nbi_project_task`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_project_task` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`name` varchar(255) NOT NULL,
`budget_type` smallint(6) NOT NULL,
`budget` double DEFAULT NULL,
`description` longtext NOT NULL,
`order` int(11) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
KEY `IDX_38B8374166D1F9C` (`project_id`),
CONSTRAINT `FK_38B8374166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `nbi_project` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_project_task`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_project_task` WRITE;
/*!40000 ALTER TABLE `nbi_project_task` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_project_task` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_public_newsletter`
--
DROP TABLE IF EXISTS `nbi_public_newsletter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_public_newsletter` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`email` varchar(255) NOT NULL,
`active` tinyint(1) NOT NULL,
`token` varchar(255) NOT NULL,
`ip` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email_unique` (`email`),
UNIQUE KEY `token_unique` (`token`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_public_newsletter`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_public_newsletter` WRITE;
/*!40000 ALTER TABLE `nbi_public_newsletter` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_public_newsletter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_public_newsletter_messages`
--
DROP TABLE IF EXISTS `nbi_public_newsletter_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_public_newsletter_messages` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`subject` varchar(255) NOT NULL,
`message` longtext NOT NULL,
`active` tinyint(1) NOT NULL,
`last_send` datetime DEFAULT NULL,
`count_send` int(11) NOT NULL,
`type_id` bigint(20) NOT NULL,
`dont_send_after` datetime DEFAULT NULL COMMENT 'Wann soll die News das letzte mal gesendet werden.',
PRIMARY KEY (`id`),
KEY `IDX_FE8DFD42C54C8C93` (`type_id`),
CONSTRAINT `FK_FE8DFD42C54C8C93` FOREIGN KEY (`type_id`) REFERENCES `nbi_news_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_public_newsletter_messages`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_public_newsletter_messages` WRITE;
/*!40000 ALTER TABLE `nbi_public_newsletter_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_public_newsletter_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_purchase`
--
DROP TABLE IF EXISTS `nbi_purchase`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_purchase` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`product_id` bigint(20) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`ip` varchar(255) NOT NULL,
`status` int(11) NOT NULL,
`product_name` longtext NOT NULL,
`product_price` double NOT NULL,
`found_us` varchar(255) DEFAULT NULL,
`promoted_by` varchar(255) DEFAULT NULL,
`comment` varchar(2000) DEFAULT NULL,
`payTimeInterval_id` bigint(20) DEFAULT NULL,
`paramter` longtext DEFAULT NULL,
`info` varchar(255) DEFAULT NULL,
`payed_months` int(11) DEFAULT NULL,
`prepaid` tinyint(1) NOT NULL COMMENT 'Flag ob Prepaid Abrechnung oder normale Rechnungslegung.',
`next_reminder` date DEFAULT NULL COMMENT 'Bei Prepaid und warte auf Bezahlung Datum der nächsten Erinnerungsmail.',
`last_rollout_try` datetime DEFAULT NULL COMMENT 'Zeitpunk letzter ausroll Versuch.',
PRIMARY KEY (`id`),
KEY `IDX_3622F9CF3A2C209A` (`payTimeInterval_id`),
KEY `IDX_3622F9CF4584665A` (`product_id`),
KEY `IDX_3622F9CF9395C3F3` (`customer_id`),
CONSTRAINT `FK_3622F9CF3A2C209A` FOREIGN KEY (`payTimeInterval_id`) REFERENCES `nbi_pay_time_interval` (`id`),
CONSTRAINT `FK_3622F9CF4584665A` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_3622F9CF9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_purchase`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_purchase` WRITE;
/*!40000 ALTER TABLE `nbi_purchase` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_purchase` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_server_types`
--
DROP TABLE IF EXISTS `nbi_server_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_server_types` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT 'Name',
`active` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Aktiv',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Typ des Servers dediziert oder virtuell';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_server_types`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_server_types` WRITE;
/*!40000 ALTER TABLE `nbi_server_types` DISABLE KEYS */;
INSERT INTO `nbi_server_types` VALUES (1,'Dediziert',1),(2,'Virtuell',1),(3,'Master',1);
/*!40000 ALTER TABLE `nbi_server_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_servers_virtualizations`
--
DROP TABLE IF EXISTS `nbi_servers_virtualizations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_servers_virtualizations` (
`server_id` bigint(20) NOT NULL,
`virtualization_id` bigint(20) NOT NULL,
PRIMARY KEY (`server_id`,`virtualization_id`),
KEY `IDX_85FF71CF1844E6B7` (`server_id`),
KEY `IDX_85FF71CFC7D7A703` (`virtualization_id`),
CONSTRAINT `FK_85FF71CF1844E6B7` FOREIGN KEY (`server_id`) REFERENCES `tbl_manage_server` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_85FF71CFC7D7A703` FOREIGN KEY (`virtualization_id`) REFERENCES `nbi_virtualization` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_servers_virtualizations`
--
-- ORDER BY: `server_id`,`virtualization_id`
LOCK TABLES `nbi_servers_virtualizations` WRITE;
/*!40000 ALTER TABLE `nbi_servers_virtualizations` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_servers_virtualizations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_syslog`
--
DROP TABLE IF EXISTS `nbi_syslog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_syslog` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
`description` longtext NOT NULL,
`created` datetime NOT NULL,
`level` smallint(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_syslog`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_syslog` WRITE;
/*!40000 ALTER TABLE `nbi_syslog` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_syslog` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_syslog_item`
--
DROP TABLE IF EXISTS `nbi_syslog_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_syslog_item` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`nbi_syslog_id` bigint(20) NOT NULL,
`created` datetime NOT NULL,
`type` varchar(255) NOT NULL,
`level` smallint(6) NOT NULL,
`description` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_1D41718CA09A54BB` (`nbi_syslog_id`),
CONSTRAINT `FK_1D41718CA09A54BB` FOREIGN KEY (`nbi_syslog_id`) REFERENCES `nbi_syslog` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_syslog_item`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_syslog_item` WRITE;
/*!40000 ALTER TABLE `nbi_syslog_item` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_syslog_item` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ticket`
--
DROP TABLE IF EXISTS `nbi_ticket`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ticket` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`owner_id` int(11) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`category_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`status` int(11) NOT NULL,
`priority` int(11) NOT NULL,
`reminder` datetime DEFAULT NULL,
`subject` varchar(255) NOT NULL,
`lastUpdate` datetime NOT NULL,
`trustworthy` tinyint(1) NOT NULL,
`vendor_id` bigint(20) DEFAULT NULL,
`disable_emails` tinyint(1) NOT NULL,
`pay_for_service` tinyint(1) NOT NULL DEFAULT 0,
`carbon_copy` varchar(1024) DEFAULT NULL,
`project_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_626ADB597E3C61F9` (`owner_id`),
KEY `IDX_626ADB599395C3F3` (`customer_id`),
KEY `IDX_626ADB5912469DE2` (`category_id`),
KEY `IDX_626ADB59F603EE73` (`vendor_id`),
KEY `IDX_626ADB59166D1F9C` (`project_id`),
CONSTRAINT `FK_626ADB5912469DE2` FOREIGN KEY (`category_id`) REFERENCES `nbi_ticket_category` (`id`),
CONSTRAINT `FK_626ADB59166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `nbi_project` (`id`),
CONSTRAINT `FK_626ADB597E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `nbi_user` (`id`),
CONSTRAINT `FK_626ADB599395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_626ADB59F603EE73` FOREIGN KEY (`vendor_id`) REFERENCES `nbi_vendors` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ticket`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ticket` WRITE;
/*!40000 ALTER TABLE `nbi_ticket` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_ticket` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ticket_category`
--
DROP TABLE IF EXISTS `nbi_ticket_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ticket_category` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`defaultConnection_id` bigint(20) DEFAULT NULL,
`support` tinyint(1) NOT NULL,
`vip_customer` tinyint(1) NOT NULL,
`customer` tinyint(1) NOT NULL,
`public` tinyint(1) NOT NULL,
`colorBackground` varchar(255) DEFAULT NULL,
`color` varchar(255) DEFAULT NULL,
`special_usage` int(11) NOT NULL DEFAULT 0,
`delete_ticket_after_days` int(11) NOT NULL DEFAULT 0 COMMENT 'Nach wieviele Tagen Tickets geloescht werden sollen 0=NIE.',
PRIMARY KEY (`id`),
KEY `IDX_C7F07C3CC623F3F7` (`defaultConnection_id`),
CONSTRAINT `FK_C7F07C3CC623F3F7` FOREIGN KEY (`defaultConnection_id`) REFERENCES `nbi_ticket_mail_connection` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ticket_category`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ticket_category` WRITE;
/*!40000 ALTER TABLE `nbi_ticket_category` DISABLE KEYS */;
INSERT INTO `nbi_ticket_category` VALUES (1,'Support','Support Test',1,1,1,1,1,NULL,NULL,0,0),(2,'FiBu','Buchhaltung',NULL,1,1,1,0,'#FA5858',NULL,0,0),(3,'Support','Support Anfragen',NULL,1,1,1,0,'#00a700',NULL,0,0),(4,'Abuse','Abuse',NULL,1,0,0,0,'#cceeff','#000000',1,0),(5,'SPAM','SPAM',NULL,1,0,0,0,'#ffff00',NULL,0,0),(6,'Hostmaster','Hostmaster',NULL,1,0,0,0,'#01DFD7',NULL,0,0),(7,'OnlineShops','Online Shops',NULL,1,0,0,0,'#2E2EFE',NULL,0,0),(8,'Info','Info',NULL,1,0,0,0,'#7fffd4',NULL,0,0),(101,'PCVisit','Mails für PCVist Abrechnung',NULL,1,0,0,0,'#000000','#852cb5',2,0),(102,'PGP Verschlüssel','Verschlüsselte Mails',NULL,1,0,0,0,'#ea0bd7','#000000',0,0);
/*!40000 ALTER TABLE `nbi_ticket_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ticket_comment`
--
DROP TABLE IF EXISTS `nbi_ticket_comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ticket_comment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`text` longtext NOT NULL,
`staffMember_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_490C0452700047D2` (`ticket_id`),
KEY `IDX_490C0452FBF8B493` (`staffMember_id`),
CONSTRAINT `FK_490C0452700047D2` FOREIGN KEY (`ticket_id`) REFERENCES `nbi_ticket` (`id`),
CONSTRAINT `FK_490C0452FBF8B493` FOREIGN KEY (`staffMember_id`) REFERENCES `nbi_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ticket_comment`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ticket_comment` WRITE;
/*!40000 ALTER TABLE `nbi_ticket_comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_ticket_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ticket_filter`
--
DROP TABLE IF EXISTS `nbi_ticket_filter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ticket_filter` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`owner_id` int(11) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`category_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`status` int(11) NOT NULL,
`priority` int(11) NOT NULL,
`order` int(11) NOT NULL,
`regexEmail` varchar(255) DEFAULT NULL,
`regexSubject` varchar(255) DEFAULT NULL,
`regexContent` varchar(255) DEFAULT NULL,
`trustworthy` tinyint(1) NOT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
KEY `IDX_AEEA8727E3C61F9` (`owner_id`),
KEY `IDX_AEEA8729395C3F3` (`customer_id`),
KEY `IDX_AEEA87212469DE2` (`category_id`),
CONSTRAINT `FK_AEEA87212469DE2` FOREIGN KEY (`category_id`) REFERENCES `nbi_ticket_category` (`id`),
CONSTRAINT `FK_AEEA8727E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `nbi_user` (`id`),
CONSTRAINT `FK_AEEA8729395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ticket_filter`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ticket_filter` WRITE;
/*!40000 ALTER TABLE `nbi_ticket_filter` DISABLE KEYS */;
INSERT INTO `nbi_ticket_filter` VALUES (3,NULL,NULL,6,'2018-04-28 00:00:00',404,100,1,'/renew@antagus.de/i',NULL,NULL,1,1),(4,NULL,NULL,6,'2018-04-28 00:00:00',404,100,999,'/info@tld-global.de/i',NULL,NULL,1,1),(6,NULL,NULL,6,'2018-04-28 00:00:00',404,100,1,'/info@6660.antagus.de/i',NULL,NULL,1,1),(9,NULL,NULL,7,'2018-04-28 00:00:00',412,100,999,'/@amazon.de/i',NULL,NULL,1,1),(10,NULL,NULL,6,'2018-04-28 00:00:00',412,100,1,'/domains@antagus.de/i','/Balance-Notify/i',NULL,1,1),(27,NULL,NULL,8,'2018-04-28 00:00:00',402,100,1,'/service@paypal.de/i',NULL,'/Ihr\\sBericht\\sist\\sda/i',1,1),(30,NULL,NULL,2,'2018-04-28 00:00:00',101,100,1,'/buchhaltung@liveconfig.com/i',NULL,NULL,1,1),(36,NULL,NULL,8,'2018-04-28 00:00:00',412,100,1,'/analytics-noreply@google.com/i',NULL,NULL,1,1),(38,NULL,NULL,5,'2018-04-28 00:00:00',402,100,1,'/team@cert.at/i',NULL,NULL,0,1),(41,NULL,NULL,8,'2018-04-28 00:00:00',423,100,1,'/webcheck@teag.de/i',NULL,NULL,1,1),(46,NULL,NULL,6,'2018-04-28 00:00:00',404,100,1,'/domains@antagus.de/i','/Kostenpflichtige\\sDomainverlaengerungen/',NULL,1,1),(59,NULL,NULL,8,'2018-04-28 00:00:00',404,100,1,'/noreply@news.internetx.com/i',NULL,NULL,1,1),(64,NULL,NULL,2,'2018-04-28 00:00:00',101,100,1,'/billing@ripe.net/i',NULL,NULL,1,1),(69,NULL,NULL,8,'2018-04-28 00:00:00',412,100,1,'/system-support@blocklist.de/i',NULL,NULL,1,1),(77,NULL,NULL,2,'2018-04-28 00:00:00',101,100,800,'/@marketplace.amazon.de/i','/Rechnungsanforderung/i',NULL,1,1),(81,NULL,NULL,2,'2018-04-28 00:00:00',101,100,1,'/buchhaltung@antagus.de/i',NULL,NULL,1,1),(82,NULL,NULL,5,'2018-04-28 00:00:00',402,100,9999,NULL,'/SPAM-Verdacht/i',NULL,0,1);
/*!40000 ALTER TABLE `nbi_ticket_filter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ticket_info`
--
DROP TABLE IF EXISTS `nbi_ticket_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ticket_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`category_id` bigint(20) DEFAULT NULL,
`user_id` int(11) NOT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`status` int(11) DEFAULT NULL,
`priority` int(11) DEFAULT NULL,
`mailDomain` varchar(255) DEFAULT NULL,
`active` tinyint(1) NOT NULL,
`delay` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_407195BD12469DE2` (`category_id`),
KEY `IDX_407195BDA76ED395` (`user_id`),
KEY `IDX_407195BD9395C3F3` (`customer_id`),
CONSTRAINT `FK_407195BD12469DE2` FOREIGN KEY (`category_id`) REFERENCES `nbi_ticket_category` (`id`),
CONSTRAINT `FK_407195BD9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_407195BDA76ED395` FOREIGN KEY (`user_id`) REFERENCES `nbi_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ticket_info`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ticket_info` WRITE;
/*!40000 ALTER TABLE `nbi_ticket_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_ticket_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ticket_mail`
--
DROP TABLE IF EXISTS `nbi_ticket_mail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ticket_mail` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`content` longtext DEFAULT NULL,
`senderMail` varchar(1024) NOT NULL,
`receiverMail` varchar(1024) NOT NULL,
`direction` int(11) NOT NULL,
`editor_id` int(11) DEFAULT NULL,
`contentHtml` longtext DEFAULT NULL,
`carbonCopy` varchar(1024) DEFAULT NULL,
`mail_timestamp` datetime NOT NULL COMMENT 'Zeitstempel zu dem die Mail gesendet wurde(DC2Type:datetime_immutable)',
PRIMARY KEY (`id`),
KEY `IDX_DADE08A2700047D2` (`ticket_id`),
KEY `IDX_DADE08A26995AC4C` (`editor_id`),
CONSTRAINT `FK_DADE08A26995AC4C` FOREIGN KEY (`editor_id`) REFERENCES `nbi_user` (`id`),
CONSTRAINT `FK_DADE08A2700047D2` FOREIGN KEY (`ticket_id`) REFERENCES `nbi_ticket` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ticket_mail`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ticket_mail` WRITE;
/*!40000 ALTER TABLE `nbi_ticket_mail` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_ticket_mail` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ticket_mail_connection`
--
DROP TABLE IF EXISTS `nbi_ticket_mail_connection`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ticket_mail_connection` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`category_id` bigint(20) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`host` varchar(255) NOT NULL,
`port` int(11) NOT NULL,
`active` tinyint(1) NOT NULL,
`protocol` varchar(255) NOT NULL,
`signature` longtext DEFAULT NULL,
`cert_file` longtext DEFAULT NULL,
`cert_password` varchar(1024) DEFAULT NULL,
`cert_key_file` longtext DEFAULT NULL,
`pgp_cert_private_file` longtext DEFAULT NULL,
`pgp_cert_public_file` longtext DEFAULT NULL,
`pgp_cert_password` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_BB62301C12469DE2` (`category_id`),
CONSTRAINT `FK_BB62301C12469DE2` FOREIGN KEY (`category_id`) REFERENCES `nbi_ticket_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ticket_mail_connection`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ticket_mail_connection` WRITE;
/*!40000 ALTER TABLE `nbi_ticket_mail_connection` DISABLE KEYS */;
INSERT INTO `nbi_ticket_mail_connection` VALUES (1,1,'Demo Test','Demo Mail Adresse','support@demo.nbiserv.de','support@demo.nbiserv.de','CHANGE-ME','localhost',995,0,'/pop3/SSL/novalidate-cert',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `nbi_ticket_mail_connection` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_ticket_scheduled_answer`
--
DROP TABLE IF EXISTS `nbi_ticket_scheduled_answer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_ticket_scheduled_answer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) NOT NULL,
`owner_id` int(11) NOT NULL,
`category_id` bigint(20) NOT NULL,
`created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`send` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`executed` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
`content` longtext DEFAULT NULL,
`receiverMail` varchar(1024) NOT NULL,
`carbonCopy` varchar(1024) DEFAULT NULL,
`status` int(11) NOT NULL,
`priority` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_72BEBE80700047D2` (`ticket_id`),
KEY `IDX_72BEBE807E3C61F9` (`owner_id`),
KEY `IDX_72BEBE8012469DE2` (`category_id`),
CONSTRAINT `FK_72BEBE8012469DE2` FOREIGN KEY (`category_id`) REFERENCES `nbi_ticket_category` (`id`),
CONSTRAINT `FK_72BEBE80700047D2` FOREIGN KEY (`ticket_id`) REFERENCES `nbi_ticket` (`id`),
CONSTRAINT `FK_72BEBE807E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `nbi_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_ticket_scheduled_answer`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_ticket_scheduled_answer` WRITE;
/*!40000 ALTER TABLE `nbi_ticket_scheduled_answer` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_ticket_scheduled_answer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_time_recording`
--
DROP TABLE IF EXISTS `nbi_time_recording`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_time_recording` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ticket_id` bigint(20) DEFAULT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`project_task_id` bigint(20) DEFAULT NULL,
`product_in_use_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL,
`start` datetime NOT NULL,
`end` datetime DEFAULT NULL,
`pay_for_service` tinyint(1) NOT NULL,
`comment` longtext NOT NULL,
`start_billing` datetime DEFAULT NULL,
`end_billing` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_F8912FE7700047D2` (`ticket_id`),
KEY `IDX_F8912FE79395C3F3` (`customer_id`),
KEY `IDX_F8912FE7A76ED395` (`user_id`),
KEY `IDX_F8912FE718F0A375` (`product_in_use_id`),
KEY `IDX_F8912FE71BA80DE3` (`project_task_id`),
CONSTRAINT `FK_F8912FE718F0A375` FOREIGN KEY (`product_in_use_id`) REFERENCES `tbl_customer_product_in_use` (`ID`),
CONSTRAINT `FK_F8912FE71BA80DE3` FOREIGN KEY (`project_task_id`) REFERENCES `nbi_project_task` (`id`),
CONSTRAINT `FK_F8912FE7700047D2` FOREIGN KEY (`ticket_id`) REFERENCES `nbi_ticket` (`id`),
CONSTRAINT `FK_F8912FE79395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_F8912FE7A76ED395` FOREIGN KEY (`user_id`) REFERENCES `nbi_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_time_recording`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_time_recording` WRITE;
/*!40000 ALTER TABLE `nbi_time_recording` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_time_recording` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_traffic_history`
--
DROP TABLE IF EXISTS `nbi_traffic_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_traffic_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`server_id` bigint(20) NOT NULL,
`created` datetime NOT NULL,
`incoming` double NOT NULL,
`outgoing` double NOT NULL,
`timestamp` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `server_timestamp` (`server_id`,`timestamp`),
KEY `IDX_C68018701844E6B7` (`server_id`),
CONSTRAINT `FK_C68018701844E6B7` FOREIGN KEY (`server_id`) REFERENCES `tbl_manage_server` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_traffic_history`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_traffic_history` WRITE;
/*!40000 ALTER TABLE `nbi_traffic_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_traffic_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_user`
--
DROP TABLE IF EXISTS `nbi_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(180) NOT NULL,
`username_canonical` varchar(180) NOT NULL,
`email` varchar(180) NOT NULL,
`email_canonical` varchar(180) NOT NULL,
`enabled` tinyint(1) NOT NULL,
`salt` varchar(255) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`last_login` datetime DEFAULT NULL,
`confirmation_token` varchar(180) DEFAULT NULL,
`password_requested_at` datetime DEFAULT NULL,
`roles` longtext NOT NULL COMMENT '(DC2Type:array)',
`last_news` datetime NOT NULL,
`customer_id` bigint(20) DEFAULT NULL,
`realname` varchar(255) DEFAULT NULL,
`color` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_85053FF192FC23A8` (`username_canonical`),
UNIQUE KEY `UNIQ_85053FF1A0D96FBF` (`email_canonical`),
UNIQUE KEY `UNIQ_85053FF19395C3F3` (`customer_id`),
UNIQUE KEY `UNIQ_85053FF1C05FB297` (`confirmation_token`),
CONSTRAINT `FK_85053FF19395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `tbl_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_user`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_user` WRITE;
/*!40000 ALTER TABLE `nbi_user` DISABLE KEYS */;
INSERT INTO `nbi_user` VALUES (1,'nbiservDemo2k','nbiservdemo2k','admin@demo.nbiserv.de','admin@demo.nbiserv.de',1,NULL,'$argon2id$v=19$m=65536,t=4,p=1$WyZVGZtxN+sKyRtW2nwhAw$bCpZrvrvxXFxOeY9Hh+ukpZkdhE5azdltaJdEkgxGLg','2022-04-29 23:12:04',NULL,NULL,'a:0:{}','2020-06-17 16:47:32',NULL,NULL,'#804000'),(2,'SuperAdmin','superadmin','sa@nbiserv.de','sa@nbiserv.de',1,NULL,'$argon2id$v=19$m=65536,t=4,p=1$WyZVGZtxN+sKyRtW2nwhAw$bCpZrvrvxXFxOeY9Hh+ukpZkdhE5azdltaJdEkgxGLg',NULL,NULL,NULL,'a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}','2020-06-18 09:38:28',NULL,NULL,NULL);
/*!40000 ALTER TABLE `nbi_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_user_user_group`
--
DROP TABLE IF EXISTS `nbi_user_user_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_user_user_group` (
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`user_id`,`group_id`),
KEY `IDX_6CB0E00DA76ED395` (`user_id`),
KEY `IDX_6CB0E00DFE54D947` (`group_id`),
CONSTRAINT `FK_6CB0E00DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `nbi_user` (`id`),
CONSTRAINT `FK_6CB0E00DFE54D947` FOREIGN KEY (`group_id`) REFERENCES `nbi_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_user_user_group`
--
-- ORDER BY: `user_id`,`group_id`
LOCK TABLES `nbi_user_user_group` WRITE;
/*!40000 ALTER TABLE `nbi_user_user_group` DISABLE KEYS */;
INSERT INTO `nbi_user_user_group` VALUES (1,1);
/*!40000 ALTER TABLE `nbi_user_user_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_vendor_products`
--
DROP TABLE IF EXISTS `nbi_vendor_products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_vendor_products` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`nbi_vendor_id` bigint(20) NOT NULL,
`nbi_posting_account_id` bigint(20) NOT NULL,
`name` varchar(255) NOT NULL COMMENT 'Name des Produktes',
`regex` varchar(255) NOT NULL COMMENT 'Regulärer-Ausdruck zur Erkennung des Produktes',
`regex_bill_number` varchar(255) NOT NULL COMMENT 'Regulärer-Ausdruck zur Erkennung der Rechnungsnummer',
`created` datetime NOT NULL,
`login_user` varchar(255) DEFAULT NULL COMMENT 'User für Login zum Produkt',
`login_password` varchar(255) DEFAULT NULL COMMENT 'Passwort für Login zum Produkt',
`website` varchar(255) DEFAULT NULL COMMENT 'Webseite zum Produkt',
`license` longtext DEFAULT NULL COMMENT 'Lizenz des Produkt',
`contact` longtext DEFAULT NULL COMMENT 'Kontakt zum Produkt',
`regex_invoice` varchar(255) DEFAULT NULL COMMENT 'Regulärer-Ausdruck zur Erkennung des Rechnungsdokuments',
PRIMARY KEY (`id`),
KEY `IDX_2A7CC8D74C84ED5E` (`nbi_vendor_id`),
KEY `IDX_2A7CC8D773B83CAC` (`nbi_posting_account_id`),
CONSTRAINT `FK_2A7CC8D74C84ED5E` FOREIGN KEY (`nbi_vendor_id`) REFERENCES `nbi_vendors` (`id`),
CONSTRAINT `FK_2A7CC8D773B83CAC` FOREIGN KEY (`nbi_posting_account_id`) REFERENCES `nbi_posting_accounts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Lieferanten Produkte';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_vendor_products`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_vendor_products` WRITE;
/*!40000 ALTER TABLE `nbi_vendor_products` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_vendor_products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_vendors`
--
DROP TABLE IF EXISTS `nbi_vendors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_vendors` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT 'Name',
`regex` varchar(255) NOT NULL COMMENT 'Regulärer-Ausdruck zur Erkennung des Lieferanten',
`mwst` double NOT NULL COMMENT 'Mehrwertsteuer des Lieferanten standard 19%',
`created` datetime NOT NULL,
`ticket_default_text` longtext DEFAULT NULL,
`ticket_email` varchar(255) DEFAULT NULL,
`escalation_time` int(11) NOT NULL DEFAULT 10080 COMMENT 'Zeit in Minutzen wann Eskaliert wird Standard 7 Tage',
`escalation_text` longtext DEFAULT NULL COMMENT 'Standard Text der bei der Escalation gesendet wird.',
`escalation_mail_address` longtext DEFAULT NULL COMMENT 'Mail Adressen mit ; getrennt die angeschrieben werden.',
`escalation_phone_numbers` longtext DEFAULT NULL COMMENT 'Nummer mit ; getrennt die angerufen werden.',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Lieferanten';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_vendors`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_vendors` WRITE;
/*!40000 ALTER TABLE `nbi_vendors` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_vendors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_virtualization`
--
DROP TABLE IF EXISTS `nbi_virtualization`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_virtualization` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_virtualization`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_virtualization` WRITE;
/*!40000 ALTER TABLE `nbi_virtualization` DISABLE KEYS */;
INSERT INTO `nbi_virtualization` VALUES (1,'Bare-Metal'),(2,'LXC'),(3,'KVM');
/*!40000 ALTER TABLE `nbi_virtualization` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_vlans`
--
DROP TABLE IF EXISTS `nbi_vlans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_vlans` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT 'Name',
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='virtuelle LAN''s';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_vlans`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_vlans` WRITE;
/*!40000 ALTER TABLE `nbi_vlans` DISABLE KEYS */;
INSERT INTO `nbi_vlans` VALUES (1,'Default vLAN - nicht verwenden','2022-05-02 14:22:43'),(2,'Transfernetz','2022-05-02 14:22:43');
/*!40000 ALTER TABLE `nbi_vlans` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nbi_voucher`
--
DROP TABLE IF EXISTS `nbi_voucher`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nbi_voucher` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`product_id` bigint(20) DEFAULT NULL,
`product_group_id` bigint(20) DEFAULT NULL,
`period_of_validity_id` bigint(20) DEFAULT NULL,
`created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
`last_redeemtion` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
`code` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`valid_until` date NOT NULL COMMENT '(DC2Type:date_immutable)',
`discount` int(11) NOT NULL COMMENT 'Rabatt in Prozent.',
`max_redeemtion` int(11) NOT NULL COMMENT 'Maximale Anzahl Einlösungen.',
`count_redeemtion` int(11) NOT NULL COMMENT 'Aktuelle Anzahl Einlösungen.',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_4E0F74AC77153098` (`code`),
KEY `IDX_4E0F74AC4584665A` (`product_id`),
KEY `IDX_4E0F74AC35E4B3D0` (`product_group_id`),
KEY `IDX_4E0F74AC48652CE2` (`period_of_validity_id`),
CONSTRAINT `FK_4E0F74AC35E4B3D0` FOREIGN KEY (`product_group_id`) REFERENCES `tbl_product_group` (`id`),
CONSTRAINT `FK_4E0F74AC4584665A` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_4E0F74AC48652CE2` FOREIGN KEY (`period_of_validity_id`) REFERENCES `nbi_pay_time_interval` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nbi_voucher`
--
-- ORDER BY: `id`
LOCK TABLES `nbi_voucher` WRITE;
/*!40000 ALTER TABLE `nbi_voucher` DISABLE KEYS */;
/*!40000 ALTER TABLE `nbi_voucher` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `network_port_vlan`
--
DROP TABLE IF EXISTS `network_port_vlan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `network_port_vlan` (
`network_port_id` bigint(20) NOT NULL,
`vlan_id` bigint(20) NOT NULL,
PRIMARY KEY (`network_port_id`,`vlan_id`),
KEY `IDX_10B608F7D25AFDF6` (`network_port_id`),
KEY `IDX_10B608F78B4937A1` (`vlan_id`),
CONSTRAINT `FK_10B608F78B4937A1` FOREIGN KEY (`vlan_id`) REFERENCES `nbi_vlans` (`id`) ON DELETE CASCADE,
CONSTRAINT `FK_10B608F7D25AFDF6` FOREIGN KEY (`network_port_id`) REFERENCES `nbi_network_port` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `network_port_vlan`
--
-- ORDER BY: `network_port_id`,`vlan_id`
LOCK TABLES `network_port_vlan` WRITE;
/*!40000 ALTER TABLE `network_port_vlan` DISABLE KEYS */;
/*!40000 ALTER TABLE `network_port_vlan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_bill_products`
--
DROP TABLE IF EXISTS `tbl_bill_products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_bill_products` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_customer_product_in_use_ID` bigint(20) DEFAULT NULL,
`tbl_bills_ID` bigint(20) NOT NULL,
`comment` longtext NOT NULL,
`netto_price` double NOT NULL,
`product_name` varchar(1024) NOT NULL,
`startDate` date DEFAULT NULL,
`endDate` date DEFAULT NULL,
`parent_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `IDX_27D4F190AFF31C0E` (`tbl_customer_product_in_use_ID`),
KEY `IDX_27D4F190D365D5E3` (`tbl_bills_ID`),
KEY `IDX_27D4F190727ACA70` (`parent_id`),
CONSTRAINT `FK_27D4F190727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `tbl_bill_products` (`ID`),
CONSTRAINT `FK_27D4F190AFF31C0E` FOREIGN KEY (`tbl_customer_product_in_use_ID`) REFERENCES `tbl_customer_product_in_use` (`ID`),
CONSTRAINT `FK_27D4F190D365D5E3` FOREIGN KEY (`tbl_bills_ID`) REFERENCES `tbl_bills` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_bill_products`
--
-- ORDER BY: `ID`
LOCK TABLES `tbl_bill_products` WRITE;
/*!40000 ALTER TABLE `tbl_bill_products` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_bill_products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_bills`
--
DROP TABLE IF EXISTS `tbl_bills`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_bills` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`bill_amount` double NOT NULL COMMENT 'Netto Betrag',
`bill_date` date NOT NULL,
`bill_paid` date DEFAULT NULL,
`tbl_customer_ID` bigint(20) NOT NULL,
`time_to_pay` date DEFAULT NULL,
`reminder_1` date DEFAULT NULL,
`reminder_2` date DEFAULT NULL,
`reminder_3` date DEFAULT NULL,
`reminder_4` date DEFAULT NULL,
`part_payment` double NOT NULL COMMENT 'Teilzahlung',
`debt_collection` date DEFAULT NULL,
`tax_on_bill` smallint(6) NOT NULL DEFAULT 1 COMMENT '0 keine MWst 1 mit MwSt',
`chargeback` smallint(6) NOT NULL DEFAULT 0 COMMENT 'Tücklastschrift NEIN /JA 0/1',
`tbl_module_id_pay_meth` bigint(20) DEFAULT NULL,
`cancellation` date DEFAULT NULL,
`credit_before` double NOT NULL DEFAULT 0,
`sepa_date` date DEFAULT NULL COMMENT 'Zeitpunkt zu dem SEPA Lastschrift durchgeführt wurde',
`vat_percent` double DEFAULT NULL,
`x_invoice_order_number` varchar(255) DEFAULT NULL COMMENT 'xRechnung Bestellnummer BT-13',
`x_invoice_project_number` varchar(255) DEFAULT NULL COMMENT 'xRechnung Project BT-11',
`x_invoice_contract_number_external` varchar(255) DEFAULT NULL COMMENT 'xRechnung Vertragsnummer BT-12',
`bill_number` varchar(255) DEFAULT NULL COMMENT 'Rechnungsnummer mit zu dem Zeitpunk aktuellen Prefix',
PRIMARY KEY (`id`),
KEY `IDX_8C1317CF14F4236B` (`tbl_customer_ID`),
KEY `IDX_8C1317CF3DF86BD7` (`tbl_module_id_pay_meth`),
CONSTRAINT `FK_8C1317CF14F4236B` FOREIGN KEY (`tbl_customer_ID`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_8C1317CF3DF86BD7` FOREIGN KEY (`tbl_module_id_pay_meth`) REFERENCES `tbl_module` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_bills`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_bills` WRITE;
/*!40000 ALTER TABLE `tbl_bills` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_bills` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_blackhold`
--
DROP TABLE IF EXISTS `tbl_blackhold`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_blackhold` (
`ip` varchar(100) NOT NULL,
`created` timestamp NOT NULL DEFAULT current_timestamp(),
`reason` mediumtext NOT NULL,
`free_date` datetime DEFAULT NULL,
`subnetmask` varchar(100) NOT NULL DEFAULT '255.255.255.255',
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`creator` varchar(64) NOT NULL,
`blocked_since` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ip` (`ip`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_blackhold`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_blackhold` WRITE;
/*!40000 ALTER TABLE `tbl_blackhold` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_blackhold` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_country`
--
DROP TABLE IF EXISTS `tbl_country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_country` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`code` varchar(2) NOT NULL,
`name_de` varchar(255) NOT NULL,
`name_en` varchar(255) NOT NULL,
`mwst` double NOT NULL,
`homeland` tinyint(1) NOT NULL,
`europe` tinyint(1) NOT NULL,
`ust_id_regex` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_country`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_country` WRITE;
/*!40000 ALTER TABLE `tbl_country` DISABLE KEYS */;
INSERT INTO `tbl_country` VALUES (1,'AD','Andorra','Andorra',0,0,0,NULL),(2,'AE','Vereinigte Arabische Emirate','United Arab Emirates',0,0,0,NULL),(3,'AF','Afghanistan','Afghanistan',0,0,0,NULL),(4,'AG','Antigua und Barbuda','Antigua and Barbuda',0,0,0,NULL),(5,'AI','Anguilla','Anguilla',0,0,0,NULL),(6,'AL','Albanien','Albania',0,0,0,NULL),(7,'AM','Armenien','Armenia',0,0,0,NULL),(8,'AN','Niederländische Antillen','Netherlands Antilles',0,0,0,NULL),(9,'AO','Angola','Angola',0,0,0,NULL),(10,'AQ','Antarktis','Antarctica',0,0,0,NULL),(11,'AR','Argentinien','Argentina',0,0,0,NULL),(12,'AS','Amerikanisch-Samoa','American Samoa',0,0,0,NULL),(13,'AT','Österreich','Austria',19,0,1,'^ATU\\d{8}$'),(14,'AU','Australien','Australia',0,0,0,NULL),(15,'AW','Aruba','Aruba',0,0,0,NULL),(16,'AX','Åland','Aland Islands',0,0,0,NULL),(17,'AZ','Aserbaidschan','Azerbaijan',0,0,0,NULL),(18,'BA','Bosnien und Herzegowina','Bosnia and Herzegovina',0,0,0,NULL),(19,'BB','Barbados','Barbados',0,0,0,NULL),(20,'BD','Bangladesch','Bangladesh',0,0,0,NULL),(21,'BE','Belgien','Belgium',19,0,1,'^BE\\d{10}$'),(22,'BF','Burkina Faso','Burkina Faso',0,0,0,NULL),(23,'BG','Bulgarien','Bulgaria',19,0,1,'^BG\\d{9,10}$'),(24,'BH','Bahrain','Bahrain',0,0,0,NULL),(25,'BI','Burundi','Burundi',0,0,0,NULL),(26,'BJ','Benin','Benin',0,0,0,NULL),(27,'BM','Bermuda','Bermuda',0,0,0,NULL),(28,'BN','Brunei Darussalam','Brunei',0,0,0,NULL),(29,'BO','Bolivien','Bolivia',0,0,0,NULL),(30,'BR','Brasilien','Brazil',0,0,0,NULL),(31,'BS','Bahamas','Bahamas',0,0,0,NULL),(32,'BT','Bhutan','Bhutan',0,0,0,NULL),(33,'BV','Bouvetinsel','Bouvet Island',0,0,0,NULL),(34,'BW','Botswana','Botswana',0,0,0,NULL),(35,'BY','Belarus (Weißrussland)','Belarus',0,0,0,NULL),(36,'BZ','Belize','Belize',0,0,0,NULL),(37,'CA','Kanada','Canada',0,0,0,NULL),(38,'CC','Kokosinseln (Keelinginseln)','Cocos (Keeling) Islands',0,0,0,NULL),(39,'CD','Kongo','Congo (Kinshasa)',0,0,0,NULL),(40,'CF','Zentralafrikanische Republik','Central African Republic',0,0,0,NULL),(41,'CG','Republik Kongo','Congo (Brazzaville)',0,0,0,NULL),(42,'CH','Schweiz','Switzerland',0,0,0,NULL),(43,'CI','Elfenbeinküste','Ivory Coast',0,0,0,NULL),(44,'CK','Cookinseln','Cook Islands',0,0,0,NULL),(45,'CL','Chile','Chile',0,0,0,NULL),(46,'CM','Kamerun','Cameroon',0,0,0,NULL),(47,'CN','China, Volksrepublik','China',0,0,0,NULL),(48,'CO','Kolumbien','Colombia',0,0,0,NULL),(49,'CR','Costa Rica','Costa Rica',0,0,0,NULL),(50,'CS','Serbien und Montenegro','Serbia And Montenegro',0,0,0,NULL),(51,'CU','Kuba','Cuba',0,0,0,NULL),(52,'CV','Kap Verde','Cape Verde',0,0,0,NULL),(53,'CX','Weihnachtsinsel','Christmas Island',0,0,0,NULL),(54,'CY','Zypern','Cyprus',19,0,1,'^CY\\d{8}[A-Z]$'),(55,'CZ','Tschechische Republik','Czech Republic',19,0,1,'^CZ\\d{8,10}$'),(56,'DE','Deutschland','Germany',19,1,1,'^DE\\d{9}$'),(57,'DJ','Dschibuti','Djibouti',0,0,0,NULL),(58,'DK','Dänemark','Denmark',19,0,1,'^DK\\d{8}$'),(59,'DM','Dominica','Dominica',0,0,0,NULL),(60,'DO','Dominikanische Republik','Dominican Republic',0,0,0,NULL),(61,'DZ','Algerien','Algeria',0,0,0,NULL),(62,'EC','Ecuador','Ecuador',0,0,0,NULL),(63,'EE','Estland (Reval)','Estonia',19,0,1,'^EE\\d{9}$'),(64,'EG','Ägypten','Egypt',0,0,0,NULL),(65,'EH','Westsahara','Western Sahara',0,0,0,NULL),(66,'ER','Eritrea','Eritrea',0,0,0,NULL),(67,'ES','Spanien','Spain',19,0,1,'^ES[\\dA-Z]\\d{7}[\\dA-Z]$'),(68,'ET','Äthiopien','Ethiopia',0,0,0,NULL),(69,'FI','Finnland','Finland',19,0,1,'^FI\\d{8}$'),(70,'FJ','Fidschi','Fiji',0,0,0,NULL),(71,'FK','Falklandinseln (Malwinen)','Falkland Islands',0,0,0,NULL),(72,'FM','Mikronesien','Micronesia',0,0,0,NULL),(73,'FO','Färöer','Faroe Islands',0,0,0,NULL),(74,'FR','Frankreich','France',19,0,1,'^FR[\\dA-Z]{2}\\d{9}$'),(75,'GA','Gabun','Gabon',0,0,0,NULL),(76,'GB','Großbritannien und Nordirland','United Kingdom',19,0,1,'^GB(\\d{9}|\\d{12}|(GD|GH)\\d{3})$'),(77,'GD','Grenada','Grenada',0,0,0,NULL),(78,'GE','Georgien','Georgia',0,0,0,NULL),(79,'GF','Französisch-Guayana','French Guiana',0,0,0,NULL),(80,'GG','Guernsey (Kanalinsel)','Guernsey',0,0,0,NULL),(81,'GH','Ghana','Ghana',0,0,0,NULL),(82,'GI','Gibraltar','Gibraltar',0,0,0,NULL),(83,'GL','Grönland','Greenland',0,0,0,NULL),(84,'GM','Gambia','Gambia',0,0,0,NULL),(85,'GN','Guinea','Guinea',0,0,0,NULL),(86,'GP','Guadeloupe','Guadeloupe',0,0,0,NULL),(87,'GQ','Äquatorialguinea','Equatorial Guinea',0,0,0,NULL),(88,'GR','Griechenland','Greece',19,0,1,'^EL\\d{9}$'),(89,'GS','Südgeorgien und die Südl. Sandwichinseln','South Georgia and the South Sandwich Islands',0,0,0,NULL),(90,'GT','Guatemala','Guatemala',0,0,0,NULL),(91,'GU','Guam','Guam',0,0,0,NULL),(92,'GW','Guinea-Bissau','Guinea-Bissau',0,0,0,NULL),(93,'GY','Guyana','Guyana',0,0,0,NULL),(94,'HK','Hongkong','Hong Kong S.A.R., China',0,0,0,NULL),(95,'HM','Heard- und McDonald-Inseln','Heard Island and McDonald Islands',0,0,0,NULL),(96,'HN','Honduras','Honduras',0,0,0,NULL),(97,'HR','Kroatien','Croatia',19,0,1,'^HR\\d{11}$'),(98,'HT','Haiti','Haiti',0,0,0,NULL),(99,'HU','Ungarn','Hungary',19,0,1,'^HU\\d{8}$'),(100,'ID','Indonesien','Indonesia',0,0,0,NULL),(101,'IE','Irland','Ireland',19,0,1,'^IE(\\d[\\dA-Z]\\d{5}[A-Z]|\\d{7}[A-W][A-I])$'),(102,'IL','Israel','Israel',0,0,0,NULL),(103,'IM','Insel Man','Isle of Man',0,0,0,NULL),(104,'IN','Indien','India',0,0,0,NULL),(105,'IO','Britisches Territorium im Indischen Ozean','British Indian Ocean Territory',0,0,0,NULL),(106,'IQ','Irak','Iraq',0,0,0,NULL),(107,'IR','Iran','Iran',0,0,0,NULL),(108,'IS','Island','Iceland',0,0,0,NULL),(109,'IT','Italien','Italy',19,0,1,'^IT\\d{11}$'),(110,'JE','Jersey (Kanalinsel)','Jersey',0,0,0,NULL),(111,'JM','Jamaika','Jamaica',0,0,0,NULL),(112,'JO','Jordanien','Jordan',0,0,0,NULL),(113,'JP','Japan','Japan',0,0,0,NULL),(114,'KE','Kenia','Kenya',0,0,0,NULL),(115,'KG','Kirgisistan','Kyrgyzstan',0,0,0,NULL),(116,'KH','Kambodscha','Cambodia',0,0,0,NULL),(117,'KI','Kiribati','Kiribati',0,0,0,NULL),(118,'KM','Komoren','Comoros',0,0,0,NULL),(119,'KN','St. Kitts und Nevis','Saint Kitts and Nevis',0,0,0,NULL),(120,'KP','Nordkorea','North Korea',0,0,0,NULL),(121,'KR','Südkorea','South Korea',0,0,0,NULL),(122,'KW','Kuwait','Kuwait',0,0,0,NULL),(123,'KY','Kaimaninseln','Cayman Islands',0,0,0,NULL),(124,'KZ','Kasachstan','Kazakhstan',0,0,0,NULL),(125,'LA','Laos','Laos',0,0,0,NULL),(126,'LB','Libanon','Lebanon',0,0,0,NULL),(127,'LC','St. Lucia','Saint Lucia',0,0,0,NULL),(128,'LI','Liechtenstein','Liechtenstein',0,0,0,NULL),(129,'LK','Sri Lanka','Sri Lanka',0,0,0,NULL),(130,'LR','Liberia','Liberia',0,0,0,NULL),(131,'LS','Lesotho','Lesotho',0,0,0,NULL),(132,'LT','Litauen','Lithuania',19,0,1,'^LT(\\d{9}|\\d{12})$'),(133,'LU','Luxemburg','Luxembourg',19,0,1,'^LU\\d{8}$'),(134,'LV','Lettland','Latvia',19,0,1,'^LV\\d{11}$'),(135,'LY','Libyen','Libya',0,0,0,NULL),(136,'MA','Marokko','Morocco',0,0,0,NULL),(137,'MC','Monaco','Monaco',0,0,0,NULL),(138,'MD','Moldawien','Moldova',0,0,0,NULL),(139,'MG','Madagaskar','Madagascar',0,0,0,NULL),(140,'MH','Marshallinseln','Marshall Islands',0,0,0,NULL),(141,'MK','Mazedonien','Macedonia',0,0,0,NULL),(142,'ML','Mali','Mali',0,0,0,NULL),(143,'MM','Myanmar (Burma)','Myanmar',0,0,0,NULL),(144,'MN','Mongolei','Mongolia',0,0,0,NULL),(145,'MO','Macao','Macao S.A.R., China',0,0,0,NULL),(146,'MP','Nördliche Marianen','Northern Mariana Islands',0,0,0,NULL),(147,'MQ','Martinique','Martinique',0,0,0,NULL),(148,'MR','Mauretanien','Mauritania',0,0,0,NULL),(149,'MS','Montserrat','Montserrat',0,0,0,NULL),(150,'MT','Malta','Malta',19,0,1,'^MT\\d{8}$'),(151,'MU','Mauritius','Mauritius',0,0,0,NULL),(152,'MV','Malediven','Maldives',0,0,0,NULL),(153,'MW','Malawi','Malawi',0,0,0,NULL),(154,'MX','Mexiko','Mexico',0,0,0,NULL),(155,'MY','Malaysia','Malaysia',0,0,0,NULL),(156,'MZ','Mosambik','Mozambique',0,0,0,NULL),(157,'NA','Namibia','Namibia',0,0,0,NULL),(158,'NC','Neukaledonien','New Caledonia',0,0,0,NULL),(159,'NE','Niger','Niger',0,0,0,NULL),(160,'NF','Norfolkinsel','Norfolk Island',0,0,0,NULL),(161,'NG','Nigeria','Nigeria',0,0,0,NULL),(162,'NI','Nicaragua','Nicaragua',0,0,0,NULL),(163,'NL','Niederlande','Netherlands',19,0,1,'^NL\\d{9}B\\d{2}$'),(164,'NO','Norwegen','Norway',0,0,0,NULL),(165,'NP','Nepal','Nepal',0,0,0,NULL),(166,'NR','Nauru','Nauru',0,0,0,NULL),(167,'NU','Niue','Niue',0,0,0,NULL),(168,'NZ','Neuseeland','New Zealand',0,0,0,NULL),(169,'OM','Oman','Oman',0,0,0,NULL),(170,'PA','Panama','Panama',0,0,0,NULL),(171,'PE','Peru','Peru',0,0,0,NULL),(172,'PF','Französisch-Polynesien','French Polynesia',0,0,0,NULL),(173,'PG','Papua-Neuguinea','Papua New Guinea',0,0,0,NULL),(174,'PH','Philippinen','Philippines',0,0,0,NULL),(175,'PK','Pakistan','Pakistan',0,0,0,NULL),(176,'PL','Polen','Poland',19,0,1,'^PL\\d{10}$'),(177,'PM','St. Pierre und Miquelon','Saint Pierre and Miquelon',0,0,0,NULL),(178,'PN','Pitcairninseln','Pitcairn',0,0,0,NULL),(179,'PR','Puerto Rico','Puerto Rico',0,0,0,NULL),(180,'PS','Palästinensische Autonomiegebiete','Palestinian Territory',0,0,0,NULL),(181,'PT','Portugal','Portugal',19,0,1,'^PT\\d{9}$'),(182,'PW','Palau','Palau',0,0,0,NULL),(183,'PY','Paraguay','Paraguay',0,0,0,NULL),(184,'QA','Katar','Qatar',0,0,0,NULL),(185,'RE','Réunion','Reunion',0,0,0,NULL),(186,'RO','Rumänien','Romania',19,0,1,'^RO[1-9]\\d{1,9}$'),(187,'RU','Russische Föderation','Russia',0,0,0,NULL),(188,'RW','Ruanda','Rwanda',0,0,0,NULL),(189,'SA','Saudi-Arabien','Saudi Arabia',0,0,0,NULL),(190,'SB','Salomonen','Solomon Islands',0,0,0,NULL),(191,'SC','Seychellen','Seychelles',0,0,0,NULL),(192,'SD','Sudan','Sudan',0,0,0,NULL),(193,'SE','Schweden','Sweden',19,0,1,'^SE\\d{10}01$'),(194,'SG','Singapur','Singapore',0,0,0,NULL),(195,'SH','St. Helena','Saint Helena',0,0,0,NULL),(196,'SI','Slowenien','Slovenia',19,0,1,'^SI\\d{8}$'),(197,'SJ','Svalbard und Jan Mayen','Svalbard and Jan Mayen',0,0,0,NULL),(198,'SK','Slowakei','Slovakia',19,0,1,'^SK\\d{10}$'),(199,'SL','Sierra Leone','Sierra Leone',0,0,0,NULL),(200,'SM','San Marino','San Marino',0,0,0,NULL),(201,'SN','Senegal','Senegal',0,0,0,NULL),(202,'SO','Somalia','Somalia',0,0,0,NULL),(203,'SR','Suriname','Suriname',0,0,0,NULL),(204,'ST','São Tomé und Príncipe','Sao Tome and Principe',0,0,0,NULL),(205,'SV','El Salvador','El Salvador',0,0,0,NULL),(206,'SY','Syrien','Syria',0,0,0,NULL),(207,'SZ','Swasiland','Swaziland',0,0,0,NULL),(208,'TC','Turks- und Caicosinseln','Turks and Caicos Islands',0,0,0,NULL),(209,'TD','Tschad','Chad',0,0,0,NULL),(210,'TF','Französische Süd- und Antarktisgebiete','French Southern Territories',0,0,0,NULL),(211,'TG','Togo','Togo',0,0,0,NULL),(212,'TH','Thailand','Thailand',0,0,0,NULL),(213,'TJ','Tadschikistan','Tajikistan',0,0,0,NULL),(214,'TK','Tokelau','Tokelau',0,0,0,NULL),(215,'TL','Timor-Leste','East Timor',0,0,0,NULL),(216,'TM','Turkmenistan','Turkmenistan',0,0,0,NULL),(217,'TN','Tunesien','Tunisia',0,0,0,NULL),(218,'TO','Tonga','Tonga',0,0,0,NULL),(219,'TR','Türkei','Turkey',0,0,0,NULL),(220,'TT','Trinidad und Tobago','Trinidad and Tobago',0,0,0,NULL),(221,'TV','Tuvalu','Tuvalu',0,0,0,NULL),(222,'TW','Taiwan','Taiwan',0,0,0,NULL),(223,'TZ','Tansania','Tanzania',0,0,0,NULL),(224,'UA','Ukraine','Ukraine',0,0,0,NULL),(225,'UG','Uganda','Uganda',0,0,0,NULL),(226,'UM','Amerikanisch-Ozeanien','United States Minor Outlying Islands',0,0,0,NULL),(227,'US','Vereinigte Staaten von Amerika','United States',0,0,0,NULL),(228,'UY','Uruguay','Uruguay',0,0,0,NULL),(229,'UZ','Usbekistan','Uzbekistan',0,0,0,NULL),(230,'VA','Vatikanstadt','Vatican',0,0,0,NULL),(231,'VC','St. Vincent und die Grenadinen','Saint Vincent and the Grenadines',0,0,0,NULL),(232,'VE','Venezuela','Venezuela',0,0,0,NULL),(233,'VG','Britische Jungferninseln','British Virgin Islands',0,0,0,NULL),(234,'VI','Amerikanische Jungferninseln','U.S. Virgin Islands',0,0,0,NULL),(235,'VN','Vietnam','Vietnam',0,0,0,NULL),(236,'VU','Vanuatu','Vanuatu',0,0,0,NULL),(237,'WF','Wallis und Futuna','Wallis and Futuna',0,0,0,NULL),(238,'WS','Samoa','Samoa',0,0,0,NULL),(239,'YE','Jemen','Yemen',0,0,0,NULL),(240,'YT','Mayotte','Mayotte',0,0,0,NULL),(241,'ZA','Südafrika','South Africa',0,0,0,NULL),(242,'ZM','Sambia','Zambia',0,0,0,NULL),(243,'ZW','Simbabwe','Zimbabwe',0,0,0,NULL);
/*!40000 ALTER TABLE `tbl_country` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_customer`
--
DROP TABLE IF EXISTS `tbl_customer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_customer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`customer_number` varchar(255) NOT NULL,
`first_name` mediumtext NOT NULL,
`last_name` mediumtext NOT NULL,
`company` longtext DEFAULT NULL,
`titel` mediumtext NOT NULL,
`street` mediumtext NOT NULL,
`post_code` mediumtext NOT NULL,
`location` mediumtext NOT NULL,
`phone_number` mediumtext NOT NULL,
`fax_number` mediumtext NOT NULL,
`handy_number` mediumtext NOT NULL,
`birth_day` date NOT NULL DEFAULT '1970-01-01',
`email_adress` varchar(255) NOT NULL,
`kto_nr` mediumtext DEFAULT NULL,
`blz` mediumtext DEFAULT NULL,
`kto_inhaber` varchar(1024) DEFAULT NULL,
`phone_number_private` mediumtext NOT NULL,
`phone_pw_active` tinyint(1) NOT NULL,
`phone_pw` varchar(255) DEFAULT NULL,
`email_adress_news` varchar(255) DEFAULT NULL,
`tbl_module_id_pay_meth` bigint(20) DEFAULT 583,
`news_general` tinyint(1) NOT NULL DEFAULT 1,
`news_technology` tinyint(1) NOT NULL DEFAULT 1,
`news_products` tinyint(1) NOT NULL DEFAULT 1,
`news_domains` tinyint(1) NOT NULL DEFAULT 1,
`lock1` int(11) NOT NULL,
`email_address_monitoring` varchar(1024) NOT NULL,
`comment` mediumtext DEFAULT NULL,
`time_to_pay` smallint(6) NOT NULL DEFAULT 7,
`ust_id` varchar(50) DEFAULT NULL,
`print_bill` tinyint(1) NOT NULL DEFAULT 0,
`ovzmanager_reseller` tinyint(1) NOT NULL,
`credit` double NOT NULL,
`created` date NOT NULL,
`reminder_stop` date DEFAULT NULL,
`nic_handle` varchar(50) NOT NULL,
`sepa_create` date DEFAULT NULL,
`sepa_last` date DEFAULT NULL,
`monitoring_password` varchar(1024) DEFAULT NULL,
`pay_day` smallint(6) NOT NULL DEFAULT 23,
`last_shown` datetime NOT NULL,
`email_adress_bills` varchar(255) DEFAULT NULL,
`file_number_adebio` varchar(100) DEFAULT NULL,
`tbl_country_id` bigint(20) NOT NULL DEFAULT 56,
`envitatel_customer` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Kunde wird für Enviatel Abrechnung heran gezogen',
`enviatel_pay_scale` smallint(6) NOT NULL DEFAULT 0 COMMENT '0 - Usageabrechnung, 1 - Flatrate',
`enviatel_usage_warning` double NOT NULL DEFAULT 5 COMMENT 'Warnung, wenn dieser Wert überschritten wird',
`envitatel_itemised_bill` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Einzelverbindungsnachweis',
`envitatel_free_user` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Kunde bekommt für Enviatel keine Rechnungen',
`last_pay_date_change` datetime DEFAULT NULL,
`last_blackhold_deletion` datetime DEFAULT NULL,
`lc_contact_id` varchar(255) DEFAULT NULL COMMENT 'LiveConfig Kontakt ID',
`lc_customer_id` varchar(255) DEFAULT NULL COMMENT 'LiveConfig Kunden ID',
`ovzm_id` varchar(255) DEFAULT NULL COMMENT 'oVZManager API Kunden Id',
`domain_reseller` tinyint(1) NOT NULL,
`defaultDomainHandle_id` bigint(20) DEFAULT NULL,
`street_number` varchar(255) DEFAULT NULL,
`debit_class` smallint(6) NOT NULL DEFAULT 0 COMMENT '0 - WHITE, 1 - GREEN, 2 - YELLOW, 3 - RED',
`last_debit_request` datetime DEFAULT NULL,
`credit_prepaid` double NOT NULL DEFAULT 0,
`salt` varchar(255) NOT NULL COMMENT 'Salt für verschiedene Zwecke.',
`default_pay_type` int(11) NOT NULL COMMENT '0 - Prepaid, 1 - Rechnung',
`send_bill_by_mail` tinyint(1) NOT NULL COMMENT 'DSGVO: 0 - nur Info senden mit link zu CC, 1 - Rechnungsmail wie bisher',
`send_ticket_by_mail` tinyint(1) NOT NULL COMMENT 'DSGVO: 0 - nur Info senden mit link zu CC, 1 - Ticketmail wie bisher',
`nameserver1_id` bigint(20) DEFAULT NULL,
`nameserver2_id` bigint(20) DEFAULT NULL,
`nameserver3_id` bigint(20) DEFAULT NULL,
`nameserver4_id` bigint(20) DEFAULT NULL,
`ownerc_id` bigint(20) DEFAULT NULL,
`adminc_id` bigint(20) DEFAULT NULL,
`techc_id` bigint(20) DEFAULT NULL,
`zonec_id` bigint(20) DEFAULT NULL,
`telegram_ident` varchar(255) DEFAULT NULL,
`news_maintenance` tinyint(1) NOT NULL,
`sendReminderMailToAllAddress` tinyint(1) NOT NULL COMMENT 'Sende Zahlungserinnerung ab der 1. Mahnung an alle bekannten Adressen des Kunden',
`matrix_room` varchar(255) DEFAULT NULL,
`pay_for_service` tinyint(1) NOT NULL DEFAULT 0,
`pay_for_service_fee` double DEFAULT 0,
`x_invoice_xml_active` tinyint(1) NOT NULL COMMENT 'xml Rechnung',
`x_invoice_receiver_email` varchar(255) DEFAULT NULL,
`x_invoice_ident_number` varchar(255) DEFAULT NULL,
`time_recording_export` tinyint(1) NOT NULL COMMENT 'Time Recordings im Detail an die Rechnung anhängen',
`pgp_cert_public_file` longtext DEFAULT NULL,
`pgp_email_identifier` longtext DEFAULT NULL,
`anonymizeData` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_D60A68242755C305` (`customer_number`),
UNIQUE KEY `uniq_tbl_customer_email_adress` (`email_adress`),
KEY `IDX_D60A68243DF86BD7` (`tbl_module_id_pay_meth`),
KEY `IDX_D60A6824906C74E1` (`tbl_country_id`),
KEY `IDX_D60A6824F3AEE743` (`defaultDomainHandle_id`),
KEY `IDX_D60A6824B21DD005` (`nameserver1_id`),
KEY `IDX_D60A6824A0A87FEB` (`nameserver2_id`),
KEY `IDX_D60A68241814188E` (`nameserver3_id`),
KEY `IDX_D60A682485C32037` (`nameserver4_id`),
KEY `IDX_D60A682473779C63` (`ownerc_id`),
KEY `IDX_D60A6824AABBD15C` (`adminc_id`),
KEY `IDX_D60A682430726F6` (`techc_id`),
KEY `IDX_D60A6824F6F3BCE5` (`zonec_id`),
CONSTRAINT `FK_D60A68241814188E` FOREIGN KEY (`nameserver3_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_D60A682430726F6` FOREIGN KEY (`techc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_D60A68243DF86BD7` FOREIGN KEY (`tbl_module_id_pay_meth`) REFERENCES `tbl_module` (`id`),
CONSTRAINT `FK_D60A682473779C63` FOREIGN KEY (`ownerc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_D60A682485C32037` FOREIGN KEY (`nameserver4_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_D60A6824906C74E1` FOREIGN KEY (`tbl_country_id`) REFERENCES `tbl_country` (`id`),
CONSTRAINT `FK_D60A6824A0A87FEB` FOREIGN KEY (`nameserver2_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_D60A6824AABBD15C` FOREIGN KEY (`adminc_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_D60A6824B21DD005` FOREIGN KEY (`nameserver1_id`) REFERENCES `nbi_nameservers` (`id`),
CONSTRAINT `FK_D60A6824F3AEE743` FOREIGN KEY (`defaultDomainHandle_id`) REFERENCES `nbi_domain_handles` (`id`),
CONSTRAINT `FK_D60A6824F6F3BCE5` FOREIGN KEY (`zonec_id`) REFERENCES `nbi_domain_handles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_customer`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_customer` WRITE;
/*!40000 ALTER TABLE `tbl_customer` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_customer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_customer_product_in_use`
--
DROP TABLE IF EXISTS `tbl_customer_product_in_use`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_customer_product_in_use` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_customer_id` bigint(20) NOT NULL,
`product_name` text NOT NULL,
`pay_time_interval` bigint(20) NOT NULL,
`next_bill` date NOT NULL,
`canceled_date` date DEFAULT NULL,
`netto_price` double NOT NULL,
`comment` text NOT NULL,
`internal_comment` longtext DEFAULT NULL,
`product_type` smallint(6) NOT NULL COMMENT '1=Domain',
`product_assignment` varchar(1024) DEFAULT NULL,
`create_date` timestamp NOT NULL DEFAULT current_timestamp(),
`domain_handle` int(11) NOT NULL COMMENT 'Handle falls Abweicht',
`domain_id` bigint(20) DEFAULT NULL,
`product_id` bigint(20) DEFAULT NULL,
`parentProductInUse_id` bigint(20) DEFAULT NULL,
`ovzm_id` varchar(255) DEFAULT NULL COMMENT 'oVZManager API vServer Id',
`prepaid` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Flag ob Prepaid Abrechnung oder normale Rechnungslegung.',
`purchase_id` bigint(20) DEFAULT NULL,
`prepaidPayment_id` bigint(20) DEFAULT NULL,
`prepaid_auto_renew` tinyint(1) NOT NULL COMMENT 'Flag ob Prepaid automatisch verlängert werden soll.',
`server_id` bigint(20) DEFAULT NULL,
`lc_license_api_id` varchar(255) DEFAULT NULL COMMENT 'LiveConfig License API ID (hexadezimal)',
`customer_comment` longtext DEFAULT NULL,
`ipRange_id` bigint(20) DEFAULT NULL,
`ip_address_id` bigint(20) DEFAULT NULL,
`x_invoice_order_number` varchar(255) DEFAULT NULL COMMENT 'xRechnung Bestellnummer BT-13',
`x_invoice_project_number` varchar(255) DEFAULT NULL COMMENT 'xRechnung Project BT-11',
`x_invoice_contract_number_external` varchar(255) DEFAULT NULL COMMENT 'xRechnung Vertragsnummer BT-12',
`mail_gateway_id` bigint(20) DEFAULT NULL,
`cancellation` datetime DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
`cancellation_reason` longtext DEFAULT NULL,
`invoice_calculation_type` smallint(6) NOT NULL COMMENT 'Rechnungstyp 0 -> standard, 1 -> preis wird zum Hauptprodukt hinzugerechnet, 2 -> inklusive',
`cost_factor` int(11) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `UNIQ_CA431C53115F0EE5` (`domain_id`),
UNIQUE KEY `UNIQ_CA431C531844E6B7` (`server_id`),
UNIQUE KEY `UNIQ_CA431C53880DE997` (`ipRange_id`),
UNIQUE KEY `UNIQ_CA431C535F23F921` (`ip_address_id`),
UNIQUE KEY `UNIQ_CA431C5383BC64FC` (`mail_gateway_id`),
KEY `IDX_CA431C5314F4236B` (`tbl_customer_id`),
KEY `FK_CA431C534584665A` (`product_id`),
KEY `IDX_CA431C531040C488` (`parentProductInUse_id`),
KEY `IDX_CA431C53558FBEB9` (`purchase_id`),
KEY `FK_CA431C5340CC997C` (`prepaidPayment_id`),
KEY `IDX_CA431C5389F47BF5` (`pay_time_interval`),
CONSTRAINT `FK_CA431C531040C488` FOREIGN KEY (`parentProductInUse_id`) REFERENCES `tbl_customer_product_in_use` (`ID`),
CONSTRAINT `FK_CA431C53115F0EE5` FOREIGN KEY (`domain_id`) REFERENCES `nbi_domains` (`id`),
CONSTRAINT `FK_CA431C5314F4236B` FOREIGN KEY (`tbl_customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_CA431C531844E6B7` FOREIGN KEY (`server_id`) REFERENCES `tbl_manage_server` (`id`),
CONSTRAINT `FK_CA431C5340CC997C` FOREIGN KEY (`prepaidPayment_id`) REFERENCES `nbi_prepaid_payment` (`id`),
CONSTRAINT `FK_CA431C534584665A` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_CA431C53558FBEB9` FOREIGN KEY (`purchase_id`) REFERENCES `nbi_purchase` (`id`),
CONSTRAINT `FK_CA431C535F23F921` FOREIGN KEY (`ip_address_id`) REFERENCES `tbl_manage_ip_address` (`id`),
CONSTRAINT `FK_CA431C5383BC64FC` FOREIGN KEY (`mail_gateway_id`) REFERENCES `nbi_product_mail_gateway` (`id`),
CONSTRAINT `FK_CA431C53880DE997` FOREIGN KEY (`ipRange_id`) REFERENCES `tbl_manage_ip_range` (`id`),
CONSTRAINT `FK_CA431C5389F47BF5` FOREIGN KEY (`pay_time_interval`) REFERENCES `nbi_pay_time_interval` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_customer_product_in_use`
--
-- ORDER BY: `ID`
LOCK TABLES `tbl_customer_product_in_use` WRITE;
/*!40000 ALTER TABLE `tbl_customer_product_in_use` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_customer_product_in_use` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_history`
--
DROP TABLE IF EXISTS `tbl_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_customer_id` bigint(20) NOT NULL,
`created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`type` bigint(20) DEFAULT NULL,
`info` mediumtext NOT NULL,
`ip` varchar(255) NOT NULL,
`username` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_7CE9783F14F4236B` (`tbl_customer_id`),
KEY `IDX_7CE9783F8CDE5729` (`type`),
CONSTRAINT `FK_7CE9783F14F4236B` FOREIGN KEY (`tbl_customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_7CE9783F8CDE5729` FOREIGN KEY (`type`) REFERENCES `tbl_history_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_history`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_history` WRITE;
/*!40000 ALTER TABLE `tbl_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_history_type`
--
DROP TABLE IF EXISTS `tbl_history_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_history_type` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`description` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_history_type`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_history_type` WRITE;
/*!40000 ALTER TABLE `tbl_history_type` DISABLE KEYS */;
INSERT INTO `tbl_history_type` VALUES (1,'Gutschein'),(2,'Rechnung'),(3,'Produkt'),(11,'Sperrung'),(21,'Kundendaten'),(31,'System');
/*!40000 ALTER TABLE `tbl_history_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_manage_ip_address`
--
DROP TABLE IF EXISTS `tbl_manage_ip_address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_manage_ip_address` (
`ip` varchar(255) NOT NULL,
`rdns` varchar(255) DEFAULT NULL,
`tbl_manage_server_id` bigint(20) DEFAULT NULL,
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`watch_http` tinyint(1) NOT NULL,
`watch_ping` tinyint(1) NOT NULL,
`watch_ftp` tinyint(1) NOT NULL,
`watch_smtp` tinyint(1) NOT NULL,
`watch_ssh` tinyint(1) NOT NULL,
`watch_imap` tinyint(1) NOT NULL,
`watch_pop` tinyint(1) NOT NULL,
`tbl_customer_id` bigint(20) DEFAULT NULL,
`tbl_manage_ip_range_id` bigint(20) DEFAULT NULL,
`watch_nrpe_user` tinyint(1) NOT NULL,
`watch_nrpe_load` tinyint(1) NOT NULL,
`watch_nrpe_hdd_1` tinyint(1) NOT NULL,
`watch_nrpe_hdd_sw_raid` tinyint(1) NOT NULL,
`watch_nrpe_time` tinyint(1) NOT NULL,
`server_name` varchar(100) DEFAULT NULL,
`watch_ts3` tinyint(1) NOT NULL,
`watch_nrpe_mailq` tinyint(1) NOT NULL,
`external` tinyint(1) NOT NULL,
`watch_nrpe_proc1` tinyint(1) NOT NULL COMMENT 'fail2ban',
`watch_nrpe_proc2` tinyint(1) NOT NULL COMMENT 'liveconfig',
`watch_nrpe_proc3` tinyint(1) NOT NULL COMMENT 'mysql',
`mac` varchar(20) DEFAULT NULL,
`watch_nrpe_proc4` tinyint(1) NOT NULL COMMENT 'bms-queue',
`watch_nrpe_proc5` tinyint(1) NOT NULL COMMENT 'apache2',
`watch_nrpe_proc6` tinyint(1) NOT NULL COMMENT 'lclogparse',
`watch_nrpe_proc7` tinyint(1) NOT NULL COMMENT 'nginx',
`watch_nrpe_hdd_2` tinyint(1) NOT NULL COMMENT 'backupe fuse',
`custom_server_name` varchar(255) DEFAULT NULL,
`firewall` tinyint(1) NOT NULL,
`watch_nrpe_proc8` tinyint(1) NOT NULL COMMENT 'Bind / named',
`watch_nrpe_swap` tinyint(1) NOT NULL,
`info_on_block` tinyint(1) NOT NULL,
`watch_nrpe_apt` tinyint(1) NOT NULL,
`watch_nrpe_proc9` tinyint(1) NOT NULL COMMENT 'oscam',
`watch_nrpe_hdd_zpool` tinyint(1) NOT NULL,
`watch_nrpe_proc10` tinyint(1) NOT NULL COMMENT 'DHCP-Server',
`watch_nrpe_proc11` tinyint(1) NOT NULL COMMENT 'FastNetMon',
`watch_nrpe_proc12` tinyint(1) NOT NULL COMMENT 'Redis Cache',
`watch_nrpe_proc13` tinyint(1) NOT NULL COMMENT 'Java',
`watch_nrpe_proc14` tinyint(1) NOT NULL COMMENT '3CXCallFlow',
`watch_nrpe_proc15` tinyint(1) NOT NULL COMMENT '3CXPhoneSystem',
`watch_nrpe_proc16` tinyint(1) NOT NULL COMMENT 'Spamassassin',
`check_snmp` tinyint(1) NOT NULL COMMENT 'IP wird bei MRTG ausgewertet',
`watch_wpversion` tinyint(1) NOT NULL COMMENT 'Prüft ob Wordpress aktuell ist',
`watch_domain_valid_ssl` tinyint(1) NOT NULL COMMENT 'Ist die Domain SSL geschützt',
`watch_domain_time` tinyint(1) NOT NULL COMMENT 'Prüfen der aufruf Zeit der Domain',
`watch_sip` tinyint(1) NOT NULL COMMENT 'Soll sip_number geprüft werden',
`sip_number` varchar(25) DEFAULT NULL COMMENT 'Nummer die bei check_sip angerufen wird',
`pay_for_checks` tinyint(1) NOT NULL COMMENT 'Fuer diesen Check wird bezahlt',
`domain_time_warn` double NOT NULL DEFAULT 0.5 COMMENT 'Maximal Domain aufruf Zeit bis zur Warnung',
`domain_time_crit` double NOT NULL DEFAULT 1 COMMENT 'Maximal Domain aufruf Zeit bis zur Critical Meldung',
`sip_time_out` int(11) NOT NULL DEFAULT 10 COMMENT 'Zeit wielange ein Anruf zustande kommen muss',
`watch_domain_content` tinyint(1) NOT NULL COMMENT 'Soll http content geprüft werden',
`domain_content` varchar(255) DEFAULT NULL COMMENT 'Content gegen den geprüft wird.',
`watch_blacklist` tinyint(1) NOT NULL COMMENT 'Prüft ob die IP in einer Blockliste ist',
`watch_spf` tinyint(1) NOT NULL COMMENT 'Prüft ob dein SPF Eintrag vorhanden ist',
`watch_dnssec` tinyint(1) NOT NULL COMMENT 'Prüft ob ein DNSSEC Eintrag vorhanden ist',
`additional_url` varchar(255) DEFAULT NULL COMMENT 'Zusätzliche URL gegen die geprüft wird (muss Domain enthalten!).',
`additional_url_content` varchar(255) DEFAULT NULL COMMENT 'Inhalt der zusätzliche URL gegen den geprüft wird.',
`watch_additional_url` tinyint(1) NOT NULL COMMENT 'Soll zusätzliche URL geprüft werden.',
`watch_ncversion` tinyint(1) NOT NULL COMMENT 'Prüft ob Nextcloud aktuell ist',
`watch_nrpe_proc17` tinyint(1) NOT NULL COMMENT 'ClamAV',
`watch_traceroute` tinyint(1) NOT NULL COMMENT 'Prüfen Traceroute zur IP',
`traceroute_min_hops` int(11) NOT NULL DEFAULT 3 COMMENT 'Minimale Hops bis zum Ziele',
`traceroute_max_hops` int(11) NOT NULL DEFAULT 15 COMMENT 'Maximal Hops bis zum Ziel',
`watch_nrpe_traceroute` tinyint(1) NOT NULL COMMENT 'Prüfe Traceroute vom Server zum Icinga',
`watch_nrpe_proc18` tinyint(1) NOT NULL COMMENT 'CheckDiskInodes',
`watch_nrpe_proc19` tinyint(1) NOT NULL COMMENT 'CronD',
`watch_nrpe_log_mail_scp` tinyint(1) NOT NULL COMMENT 'Prüft mail.log nach Fehlern',
`watch_nrpe_log_syslog_oom` tinyint(1) NOT NULL COMMENT 'Prüft syslog auf Out of Memory',
`watch_google_page_speed` tinyint(1) NOT NULL COMMENT 'Domain bei google Pagespeed pruefen',
`google_page_speed_url` varchar(255) DEFAULT NULL COMMENT 'URL die geprüft werden soll',
`google_page_speed_warn` int(11) NOT NULL DEFAULT 89 COMMENT 'Wert ab dem eine Warnung kommt.',
`google_page_speed_crit` int(11) NOT NULL DEFAULT 49 COMMENT 'Wert ab dem es kritisch ist.',
`watch_dig` tinyint(1) NOT NULL COMMENT 'Pruefen ob DNS Domain kennt',
`dig_url` varchar(255) DEFAULT 'www.nbiserv.de' COMMENT 'URL die geprüft werden soll',
`watch_nrpe_proc20` tinyint(1) NOT NULL COMMENT 'Amavis',
`watch_nrpe_log_syslog` tinyint(1) NOT NULL COMMENT 'Prüft syslog auf Fehler',
`disable_monitoring_until` datetime DEFAULT NULL COMMENT 'Deaktiviert das monitoring bis zum definierten Zeitpunkt.(DC2Type:datetime_immutable)',
PRIMARY KEY (`id`),
UNIQUE KEY `ip` (`ip`),
KEY `IDX_D641B7EA7293D1A1` (`tbl_manage_server_id`),
KEY `IDX_D641B7EA14F4236B` (`tbl_customer_id`),
KEY `IDX_D641B7EAF03967B9` (`tbl_manage_ip_range_id`),
CONSTRAINT `FK_D641B7EA14F4236B` FOREIGN KEY (`tbl_customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_D641B7EA7293D1A1` FOREIGN KEY (`tbl_manage_server_id`) REFERENCES `tbl_manage_server` (`id`),
CONSTRAINT `FK_D641B7EAF03967B9` FOREIGN KEY (`tbl_manage_ip_range_id`) REFERENCES `tbl_manage_ip_range` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_manage_ip_address`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_manage_ip_address` WRITE;
/*!40000 ALTER TABLE `tbl_manage_ip_address` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_manage_ip_address` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_manage_ip_range`
--
DROP TABLE IF EXISTS `tbl_manage_ip_range`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_manage_ip_range` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`start_ip` varchar(255) NOT NULL,
`end_ip` varchar(255) NOT NULL,
`vlan_id` bigint(20) NOT NULL,
`Prefix` varchar(10) NOT NULL,
`IP_Typ` varchar(10) NOT NULL,
`Typ` varchar(20) NOT NULL,
`tbl_customer_id` bigint(20) NOT NULL,
`netmask` varchar(1024) DEFAULT NULL,
`gateway` varchar(1024) DEFAULT NULL,
`broadcast` varchar(1024) DEFAULT NULL,
`network` varchar(1024) DEFAULT NULL,
`info` longtext DEFAULT NULL,
`type` int(11) NOT NULL DEFAULT 1 COMMENT '1 free, 2 internal, 4 customer',
PRIMARY KEY (`id`),
KEY `IDX_898447B514F4236B` (`tbl_customer_id`),
KEY `IDX_898447B58B4937A1` (`vlan_id`),
CONSTRAINT `FK_898447B514F4236B` FOREIGN KEY (`tbl_customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_898447B58B4937A1` FOREIGN KEY (`vlan_id`) REFERENCES `nbi_vlans` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_manage_ip_range`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_manage_ip_range` WRITE;
/*!40000 ALTER TABLE `tbl_manage_ip_range` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_manage_ip_range` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_manage_os`
--
DROP TABLE IF EXISTS `tbl_manage_os`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_manage_os` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OS` varchar(100) NOT NULL,
`active` tinyint(1) NOT NULL,
`ordering` int(11) DEFAULT NULL COMMENT 'Reihenfolge in der es angezeigt wird',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10039 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_manage_os`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_manage_os` WRITE;
/*!40000 ALTER TABLE `tbl_manage_os` DISABLE KEYS */;
INSERT INTO `tbl_manage_os` VALUES (10021,'Debian - 11',1,NULL),(10030,'Proxmox 7',1,NULL),(10031,'manuell / Netboot.xyz - use VNC for Install',1,NULL),(10035,'EoL - Windows Server 2019 Evaluierungsversion',0,300),(10036,'Windows Server 2022 Evaluierungsversion',0,NULL),(10037,'Windows 10 Pro',0,NULL),(10038,'Windows 11 Pro',0,NULL);
/*!40000 ALTER TABLE `tbl_manage_os` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_manage_server`
--
DROP TABLE IF EXISTS `tbl_manage_server`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_manage_server` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` mediumtext NOT NULL,
`adminsoftware` varchar(255) DEFAULT NULL,
`adminsoftware_user` varchar(255) DEFAULT NULL,
`adminsoftware_password` varchar(255) DEFAULT NULL,
`switch_id` int(11) NOT NULL,
`switch_port` int(11) NOT NULL,
`mac_address` mediumtext NOT NULL,
`comment` longtext DEFAULT NULL,
`free_date` date DEFAULT NULL,
`use_date` date NOT NULL,
`OS_User` varchar(255) DEFAULT NULL,
`OS_Passwort` varchar(255) DEFAULT NULL,
`tbl_customer_id` bigint(20) DEFAULT NULL,
`is_customer_hardware` date DEFAULT NULL,
`ip_address` mediumtext NOT NULL,
`vlan` int(11) NOT NULL,
`tbl_order_ID` bigint(20) DEFAULT NULL,
`including_traffic` int(11) NOT NULL,
`pay_over_traffic` tinyint(1) NOT NULL,
`over_traffic` int(11) NOT NULL,
`traffic_total` double NOT NULL,
`housing` tinyint(1) NOT NULL,
`number_of_mac` smallint(6) NOT NULL,
`serial_number` varchar(255) DEFAULT NULL,
`switch_speed` varchar(255) NOT NULL,
`custom_server_name` varchar(255) DEFAULT NULL,
`hdd` varchar(255) DEFAULT NULL COMMENT 'Festplatten Info',
`cpu` varchar(255) DEFAULT NULL COMMENT 'Prozessor Info',
`ram` varchar(255) DEFAULT NULL COMMENT 'Arbeitsspeicher Info',
`resetter_ident` varchar(255) DEFAULT NULL COMMENT 'Resetter Identifikation',
`last_reset` datetime DEFAULT NULL COMMENT 'Zeitpunkt zu dem der letzte Reset durchgeführt wurde.',
`power_meassure` int(11) NOT NULL COMMENT 'Stromverbrauch in Watt.',
`last_power_meassure` datetime DEFAULT NULL COMMENT 'Zeitpunkt zu dem die letzte Strom Messung durchgeführt wurde.',
`min_netto_price` double NOT NULL COMMENT 'Mindest Nettopreis, wenn Strom teurer dann Strom Preis verwenden.',
`trunk_port` tinyint(1) NOT NULL COMMENT 'Der Switch Port wird als trunk Port konfiguriert (alle VLAN''s liegen am Port an).',
`dataCenterSpaceType_id` bigint(20) NOT NULL,
`switch_interface` int(11) NOT NULL,
`switch_config_disabled` tinyint(1) NOT NULL COMMENT 'Für den Server wird der Switch nicht automatisch konfiguriert.',
`paid_over_traffic` int(11) NOT NULL,
`paid_over_traffic_date` date DEFAULT NULL,
`hdd_type` smallint(6) NOT NULL DEFAULT 1 COMMENT 'HDD Typ, SSD NVME',
`type_id` bigint(20) NOT NULL DEFAULT 1,
`max_vserver` int(11) DEFAULT NULL COMMENT 'Maximal anzahl der vserver (nur bei typ Master)',
`cores` int(11) NOT NULL DEFAULT 1 COMMENT 'Anzahl Prozessor Kerne',
`mem` int(11) NOT NULL DEFAULT 1024 COMMENT 'RAM in MB',
`disk_space` bigint(20) NOT NULL DEFAULT 10240 COMMENT 'disk space in MB',
`last_activity` datetime DEFAULT NULL COMMENT 'Zeitpunkt zu dem die letzte Aktion durchgeführt wurde.',
`speed_default` int(11) NOT NULL DEFAULT 0 COMMENT 'in mbit 0 -> auto / unlimited',
`speed_limited` int(11) NOT NULL DEFAULT 10 COMMENT 'in mbit Limitierung wenn Traffic Limit erreicht',
`speed_current` int(11) NOT NULL DEFAULT 0 COMMENT 'in mbit 0 -> aktueller speed',
`master_server_id` bigint(20) DEFAULT NULL,
`backup_count` smallint(6) DEFAULT NULL COMMENT 'Anzahl der Backups',
`email_address_backup` varchar(255) DEFAULT NULL COMMENT 'default monitoring email des kunden, nicht vorhanden default email des kunden',
`api_key` varchar(255) DEFAULT NULL,
`image_id` bigint(20) DEFAULT NULL,
`drain` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'entferne alle vserver vom master system',
`swap` int(11) NOT NULL DEFAULT 1024 COMMENT 'SWAP in MB für vServer',
`balloon` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Balloon bei vServer - default aktiviert',
`vserver_id` int(11) DEFAULT NULL COMMENT 'ID des vServers',
`start_up_order` int(11) NOT NULL DEFAULT 0 COMMENT 'Reihnfolge in der die vServer gestartet werden',
`vnc` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'VNC bei vServer aktiv 0=Nein 1=Ja',
`ipv4_count` smallint(6) NOT NULL COMMENT 'Anzahl möglicher IPv4',
`ipv6_count` smallint(6) NOT NULL COMMENT 'Anzahl möglicher IPv6',
`backup_storage` varchar(255) NOT NULL DEFAULT '/var/lib/vz/dump/' COMMENT 'Backuppfad - default:/var/lib/vz/dump/',
`email_Address_Backup_Type` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Type der Mail z.B. 0=keine Mail 1=bei Fehlern 2=Immer',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_4E72C4073594E377` (`resetter_ident`),
KEY `IDX_4E72C40714F4236B` (`tbl_customer_id`),
KEY `IDX_4E72C407604E430` (`dataCenterSpaceType_id`),
KEY `IDX_4E72C407C54C8C93` (`type_id`),
KEY `IDX_4E72C4076BDB45FA` (`master_server_id`),
KEY `IDX_4E72C4073DA5256D` (`image_id`),
CONSTRAINT `FK_4E72C40714F4236B` FOREIGN KEY (`tbl_customer_id`) REFERENCES `tbl_customer` (`id`),
CONSTRAINT `FK_4E72C4073DA5256D` FOREIGN KEY (`image_id`) REFERENCES `nbi_image` (`id`),
CONSTRAINT `FK_4E72C407604E430` FOREIGN KEY (`dataCenterSpaceType_id`) REFERENCES `nbi_data_center_space_types` (`id`),
CONSTRAINT `FK_4E72C4076BDB45FA` FOREIGN KEY (`master_server_id`) REFERENCES `tbl_manage_server` (`id`),
CONSTRAINT `FK_4E72C407C54C8C93` FOREIGN KEY (`type_id`) REFERENCES `nbi_server_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_manage_server`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_manage_server` WRITE;
/*!40000 ALTER TABLE `tbl_manage_server` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_manage_server` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_modul_group`
--
DROP TABLE IF EXISTS `tbl_modul_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_modul_group` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`presentation_order` int(11) NOT NULL COMMENT 'Reihenfolge in der die Gruppen angezeigt werden.',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_modul_group`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_modul_group` WRITE;
/*!40000 ALTER TABLE `tbl_modul_group` DISABLE KEYS */;
INSERT INTO `tbl_modul_group` VALUES (7,'Vertragsdetails',0);
/*!40000 ALTER TABLE `tbl_modul_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_module`
--
DROP TABLE IF EXISTS `tbl_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_module` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_modul_group_id` bigint(20) DEFAULT NULL,
`name` varchar(64) NOT NULL,
`description` varchar(200) DEFAULT NULL,
`price` double DEFAULT NULL,
`show_in_preview` tinyint(1) NOT NULL,
`price_interval` varchar(50) DEFAULT NULL,
`special_field` int(11) NOT NULL,
`special_field_data` varchar(2000) DEFAULT NULL,
`pay_time_interval` bigint(20) NOT NULL,
`module_type` int(11) NOT NULL,
`product_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_81824F9789F47BF5` (`pay_time_interval`),
KEY `IDX_81824F97DB30782` (`tbl_modul_group_id`),
KEY `IDX_81824F974584665A` (`product_id`),
CONSTRAINT `FK_81824F974584665A` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_81824F9789F47BF5` FOREIGN KEY (`pay_time_interval`) REFERENCES `nbi_pay_time_interval` (`id`),
CONSTRAINT `FK_81824F97DB30782` FOREIGN KEY (`tbl_modul_group_id`) REFERENCES `tbl_modul_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=790 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_module`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_module` WRITE;
/*!40000 ALTER TABLE `tbl_module` DISABLE KEYS */;
INSERT INTO `tbl_module` VALUES (582,7,'PayPal +0,47Euro +6% auf Bruttorechnungsbetrag','',0,0,NULL,0,NULL,1,1,NULL),(583,7,'per Rechnung / Überweisung','',0,0,NULL,0,NULL,1,1,NULL),(789,7,'per SEPA-Lastschrift','',NULL,0,NULL,0,NULL,1,1,NULL);
/*!40000 ALTER TABLE `tbl_module` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_news`
--
DROP TABLE IF EXISTS `tbl_news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`headline` varchar(200) NOT NULL,
`content` varchar(2000) NOT NULL,
`newsdate` date NOT NULL,
`view_public` tinyint(1) NOT NULL,
`view_internal` tinyint(1) NOT NULL,
`type_id` bigint(20) NOT NULL,
`created` datetime NOT NULL,
`mail_send_time` datetime DEFAULT NULL COMMENT 'Zeitpunkt zu dem der Mailversand gestartet wurde.',
`send_automatically_on_news_day` tinyint(1) NOT NULL COMMENT 'Ob die News automatich per Mail gesendet werden soll.',
PRIMARY KEY (`id`),
KEY `IDX_A8F3CCB8C54C8C93` (`type_id`),
CONSTRAINT `FK_A8F3CCB8C54C8C93` FOREIGN KEY (`type_id`) REFERENCES `nbi_news_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_news`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_news` WRITE;
/*!40000 ALTER TABLE `tbl_news` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_product`
--
DROP TABLE IF EXISTS `tbl_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_product` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`tbl_product_group_id` bigint(20) DEFAULT NULL,
`name` varchar(64) NOT NULL,
`description` varchar(2000) DEFAULT NULL,
`price` double NOT NULL,
`is_active` tinyint(1) NOT NULL,
`price_interval` varchar(50) DEFAULT NULL,
`defaultDomainProvider_id` bigint(20) DEFAULT NULL,
`price_netto` double NOT NULL,
`pay_time_interval_min` bigint(20) NOT NULL,
`pay_time_interval_show` bigint(20) NOT NULL,
`repurchase_price` double DEFAULT NULL COMMENT 'Feld für Einkaufspreis / später eventuell Statistik',
`selling_price_calculation` varchar(255) DEFAULT NULL COMMENT 'Feld für Kalkulation Verkaufspreis',
`immediate_rollout` tinyint(1) NOT NULL COMMENT 'Sofortige Auslieferung.',
`ovzm_id` varchar(255) DEFAULT NULL COMMENT 'oVZManager API Package Id',
`presentation_order` int(11) NOT NULL COMMENT 'Reihenfolge in der die Produkte angezeigt werden.',
`dataCenterSpaceType_id` bigint(20) DEFAULT NULL,
`liveconfig_edition` int(11) DEFAULT NULL COMMENT 'LiveConfig Edition 0=Basic, 1=Standard, 2=Business',
`pay_time_interval_max` bigint(20) NOT NULL,
`offer_message_template` longtext DEFAULT NULL,
`offer_disclaimer` longtext DEFAULT NULL,
`cores` int(11) NOT NULL DEFAULT 1 COMMENT 'Anzahl Prozessor Kerne',
`mem` int(11) NOT NULL DEFAULT 1024 COMMENT 'RAM in MB',
`hdd_type` smallint(6) NOT NULL DEFAULT 1 COMMENT 'HDD Typ, SSD NVME',
`disk_space` bigint(20) NOT NULL DEFAULT 10240 COMMENT 'disk space in MB',
`backup_count` smallint(6) DEFAULT NULL COMMENT 'Anzahl der Backups',
`ipv4_count` smallint(6) NOT NULL COMMENT 'Anzahl möglicher IPv4',
`ipv6_count` smallint(6) NOT NULL COMMENT 'Anzahl möglicher IPv6',
`can_not_be_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Produkt darf nicht gelöscht werden, da es System relevant ist.',
PRIMARY KEY (`id`),
KEY `IDX_88190CD976994459` (`defaultDomainProvider_id`),
KEY `IDX_88190CD93F3A31A2` (`tbl_product_group_id`),
KEY `FK_88190CD9E1B87A33` (`pay_time_interval_min`),
KEY `FK_88190CD9B4DA9A4` (`pay_time_interval_show`),
KEY `IDX_88190CD9604E430` (`dataCenterSpaceType_id`),
KEY `IDX_88190CD9DDB5456A` (`pay_time_interval_max`),
CONSTRAINT `FK_88190CD93F3A31A2` FOREIGN KEY (`tbl_product_group_id`) REFERENCES `tbl_product_group` (`id`),
CONSTRAINT `FK_88190CD9604E430` FOREIGN KEY (`dataCenterSpaceType_id`) REFERENCES `nbi_data_center_space_types` (`id`),
CONSTRAINT `FK_88190CD976994459` FOREIGN KEY (`defaultDomainProvider_id`) REFERENCES `nbi_domain_provider` (`id`),
CONSTRAINT `FK_88190CD9DDB5456A` FOREIGN KEY (`pay_time_interval_max`) REFERENCES `nbi_pay_time_interval` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=322 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_product`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_product` WRITE;
/*!40000 ALTER TABLE `tbl_product` DISABLE KEYS */;
INSERT INTO `tbl_product` VALUES (1,11,'special vServer','change me',1024,1,'Monat',NULL,1024,1,1,NULL,NULL,1,NULL,1024,98,NULL,1,NULL,NULL,1,1024,1,10240,1,1,1,0),(2,12,'special Server','change me',1024,1,'Monat',NULL,1024,1,1,NULL,NULL,1,NULL,1024,1,NULL,1,NULL,NULL,1,1024,1,10240,1,1,1,0),(3,55,'special Housing','change me',1024,1,'Monat',NULL,1024,1,1,NULL,NULL,1,NULL,1024,1,NULL,1,NULL,NULL,1,1024,1,10240,1,1,1,0),(4,10,'special Webhosting','change me',1024,1,'Monat',NULL,1024,1,1,NULL,NULL,1,NULL,1024,1,NULL,1,NULL,NULL,1,1024,1,10240,1,1,1,0),(5,20,'Mail Gateway 1 Domain','SAM Gateway fuer eine Domain',1.19,1,'Monat',NULL,1,1,1,NULL,'Aktueller Preis ca. 2,49Euro',0,NULL,1024,NULL,NULL,1,NULL,NULL,1,1024,1,10240,1,1,1,0),(8,3,'Managed','System Product - Produkt für Managed Option',1024,0,NULL,NULL,22.689,1,1,NULL,NULL,0,NULL,0,NULL,NULL,4,'SSH User mit Root Zugriff.\nUser:\nPasswort:\nServer-IP:\ninstallierte Software: z.B. LiveConfig\nVerwendung des Servers: z.B Webserver / Mailserver','Ich bin berechtigt die Zugangsdaten weiter zu geben. Mir ist bewusst das ein nbiserv Techniker sich anmelden wird um den Umfang für ein Angebot ab zu schätzen.',1,1024,1,10240,NULL,0,0,1),(12,51,'1 Mbit Flat','System Product - Produkt für Traffic per Mbit',1024,0,NULL,NULL,2.5,1,1,NULL,NULL,0,NULL,0,NULL,NULL,1,NULL,NULL,1,1024,1,10240,NULL,0,0,1),(320,2,'15min RH','change me',29,1,'Einmalig',NULL,24.369,8,8,NULL,NULL,0,NULL,1024,NULL,NULL,1,NULL,NULL,1,1024,1,10240,1,1,1,0),(321,17,'special - Monitorring','change me',1024,1,'Monat',NULL,1024,1,1,NULL,NULL,1,NULL,1024,1,NULL,1,NULL,NULL,1,1024,1,10240,1,1,1,0);
/*!40000 ALTER TABLE `tbl_product` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_product_group`
--
DROP TABLE IF EXISTS `tbl_product_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_product_group` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`description` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_product_group`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_product_group` WRITE;
/*!40000 ALTER TABLE `tbl_product_group` DISABLE KEYS */;
INSERT INTO `tbl_product_group` VALUES (1,'IP Netze',NULL),(2,'HourlyRates','Stundensätze und Gebühren'),(3,'ServiceContract','Service Verträge '),(4,'3cx','3CX'),(5,'ssl','SSL Zertifikate'),(6,'pcvisit','pcvisit'),(7,'LiveConfig',NULL),(8,'Dienstleistungen','RH Neuinstall etc.'),(9,'Domains','Webfakt Artikelgruppe 101'),(10,'Webhosting','Webfakt Artikelgruppe 102'),(11,'vServer','vServer'),(12,'Server','Ded. Server'),(13,'Software','Plesk Confixx NbI-HS'),(14,'Reseller','Reseller'),(15,'Hardware / Resourcen','Hardware Sachen...'),(16,'Setup','Setup kosten'),(17,'Monitoring','Überwachung'),(18,'NbiservSoftware','nbiserv Software'),(20,'Mail Gateway','E-Mail SPAM Gateway'),(44,'Tages Server','Tages Server'),(45,'VPN','VPN IPT'),(48,'Exchange Hosting','Webfakt Artikelgruppe 108'),(50,'Zertifikate','Webfakt Artikelgruppe 109'),(51,'Aktionen','Webfakt Artikelgruppe 105'),(53,'Artikelgruppe 700','Webfakt Artikelgruppe 700'),(54,'VS-WIN','Webfakt Artikelgruppe 1001'),(55,'Housing','Webfakt Artikelgruppe 1100'),(56,'Prepaid','Webfakt Artikelgruppe 1200'),(57,'Cloud','Webfakt Artikelgruppe 1300'),(58,'RaspberryPi',NULL),(59,'VoIP',NULL);
/*!40000 ALTER TABLE `tbl_product_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_product_has_tbl_module`
--
DROP TABLE IF EXISTS `tbl_product_has_tbl_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_product_has_tbl_module` (
`tbl_product_id` bigint(20) NOT NULL,
`tbl_module_id` bigint(20) NOT NULL,
`is_optional` tinyint(1) NOT NULL DEFAULT 0,
`group_modules` varchar(32) DEFAULT NULL,
`iter_step` int(11) DEFAULT NULL,
`iter_min` int(11) DEFAULT NULL,
`iter_max` int(11) DEFAULT NULL,
`iter_unit` varchar(20) DEFAULT NULL,
`order_number` int(11) DEFAULT 0,
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_7279CC6C2CC72CCB` (`tbl_product_id`),
KEY `IDX_7279CC6CEA4ADA02` (`tbl_module_id`),
CONSTRAINT `FK_7279CC6C2CC72CCB` FOREIGN KEY (`tbl_product_id`) REFERENCES `tbl_product` (`id`),
CONSTRAINT `FK_7279CC6CEA4ADA02` FOREIGN KEY (`tbl_module_id`) REFERENCES `tbl_module` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_product_has_tbl_module`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_product_has_tbl_module` WRITE;
/*!40000 ALTER TABLE `tbl_product_has_tbl_module` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_product_has_tbl_module` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_schedule`
--
DROP TABLE IF EXISTS `tbl_schedule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_schedule` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
`created` datetime NOT NULL,
`executed` datetime DEFAULT NULL,
`status` varchar(1) NOT NULL,
`parameter` longtext DEFAULT NULL,
`result` longtext DEFAULT NULL,
`confirmation_code` varchar(255) DEFAULT NULL,
`start_time` datetime NOT NULL DEFAULT '1990-01-01 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_schedule`
--
-- ORDER BY: `id`
LOCK TABLES `tbl_schedule` WRITE;
/*!40000 ALTER TABLE `tbl_schedule` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_schedule` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-08-07 6:41:55