--
-- Host: localhost    Database: nbiSuiteInstall
-- ------------------------------------------------------


--
-- Table structure for table `maintenancelocation_maintenanceitemtemplate`
--

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;

--
-- Dumping data for table `maintenancelocation_maintenanceitemtemplate`
--
-- ORDER BY:  `maintenancelocation_id`,`maintenanceitemtemplate_id`


--
-- Table structure for table `migration_versions`
--

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;

--
-- Dumping data for table `migration_versions`
--
-- ORDER BY:  `version`

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);

--
-- Table structure for table `nbi_backup_files`
--

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;

--
-- Dumping data for table `nbi_backup_files`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_backup_schedules`
--

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;

--
-- Dumping data for table `nbi_backup_schedules`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_book_entries`
--

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;

--
-- Dumping data for table `nbi_book_entries`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_configuration`
--

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;

--
-- Dumping data for table `nbi_configuration`
--
-- ORDER BY:  `id`

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<br>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','<a target=\"_blank\" href=\"https://www.it-recht-kanzlei.de/agb-starterpaket.php?partner_id=873\">IT-Recht Kanzlei</a> Schnitstelle Aktiv<br> Im Kundencenter von ITRK Inhouse-Individualshop wählen. <br>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','<a target=\"_blank\" href=\"https://www.it-recht-kanzlei.de/agb-starterpaket.php?partner_id=873\">IT-Recht Kanzlei</a> - shared secret client id',4,'RzQ2d0NMRHVNaDErZ3dxMjJiMXVEZz09',NULL,NULL,1),(104,'2021-04-28 06:33:33','nbi.portal','eapi.legal.itrk.password','<a target=\"_blank\" href=\"https://www.it-recht-kanzlei.de/agb-starterpaket.php?partner_id=873\">IT-Recht Kanzlei</a> - shared secret client secret',4,'L1NzS3RDT1EyRXdmWDlJd2xQRGYreDc0c0xlNzA0TEZuQTg2NHdKZTFNbz0=',NULL,NULL,1),(105,'2021-04-28 06:33:33','nbi.portal','eapi.legal.itrk.apihash','<a target=\"_blank\" href=\"https://www.it-recht-kanzlei.de/agb-starterpaket.php?partner_id=873\">IT-Recht Kanzlei</a> - 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 <a target=\"_blank\" href=\"https://www.nbiserv.de/de/shop/nbiservsoftware\">nbiSuite</a>. Bei einer aktiven API z.B. von <a target=\"_blank\" href=\"https://www.it-recht-kanzlei.de/agb-starterpaket.php?partner_id=873\">IT-Recht Kanzlei</a> 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 <a target=\"_blank\" href=\"https://www.nbiserv.de/de/shop/nbiservsoftware\">nbiSuite</a>.Bei einer aktiven API z.B. von <a target=\"_blank\" href=\"https://www.it-recht-kanzlei.de/agb-starterpaket.php?partner_id=873\">IT-Recht Kanzlei</a> 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 <a target=\"_blank\" href=\"https://www.nbiserv.de/de/shop/nbiservsoftware\">nbiSuite</a>.Bei einer aktiven API z.B. von <a target=\"_blank\" href=\"https://www.it-recht-kanzlei.de/agb-starterpaket.php?partner_id=873\">IT-Recht Kanzlei</a> 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 <a target=\"_blank\" href=\"https://www.nbiserv.de/de/shop/nbiservsoftware\">nbiSuite</a>.Bei einer aktiven API z.B. von <a target=\"_blank\" href=\"https://www.it-recht-kanzlei.de/agb-starterpaket.php?partner_id=873\">IT-Recht Kanzlei</a> 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,'<call-us\n                                                    style=\"position: fixed; right: 20px; bottom: 200px;\n                                                     font-family: Arial;\n                                                     z-index: 99999;\n                                                     --call-us-form-header-background:#186c77;\n                                                     --call-us-main-button-background:#05d6d6;\n                                                     --call-us-client-text-color:#d4d4d4;\n                                                     --call-us-agent-text-color:#eeeeee;\n                                                     --call-us-form-height:330px;\"\n                                                    id=\"wp-live-chat-by-3CX\"\n                                                    channel-url=\"https://nbiserv.my3cx.de:5001\"\n                                                    files-url=\"https://nbiserv.my3cx.de:5001\"\n                                                    minimized=\"true\"\n                                                    animation-style=\"none\"\n                                                    party=\"click2talk113745\"\n                                                    minimized-style=\"BubbleRight\"\n                                                    allow-call=\"false\"\n                                                    allow-video=\"false\"\n                                                    allow-soundnotifications=\"true\"\n                                                    enable-onmobile=\"true\"\n                                                    offline-enabled=\"false\"\n                                                    enable=\"true\"\n                                                    ignore-queueownership=\"false\"\n                                                    authentication=\"both\"\n                                                    operator-name=\"Support\"\n                                                    show-operator-actual-name=\"true\"\n                                                    channel=\"phone\"\n                                                    aknowledge-received=\"true\"\n                                                    gdpr-enabled=\"true\"\n                                                    gdpr-message=\"Ich stimme der Verarbeitung meiner personenbezogenen Daten und der Verwendung von Cookies zur Teilnahme an einem von nbiserv verarbeiteten Chat zum Zweck des Chats/Supports fÃ¼r die Dauer von 30 Tagen gemÃ¤ÃŸ DSGVO zu.\"\n                                                    message-userinfo-format=\"both\"\n                                                    message-dateformat=\"both\"\n                                                    start-chat-button-text=\"Chat\"\n                                                    window-title=\"nbiserv - Live Chat\"\n                                                    button-icon-type=\"Default\"\n                                                    invite-message=\"Hallo %NAME% wie kÃ¶nnen wir Ihnen heute helfen?\"\n                                            authentication-message=\"Bitte tragen Sie Ihren Namen und E-Mail Adresse ein.\"\n                                            unavailable-message=\"Aktuell ist leider kein Mitarbeiter VerfÃ¼gbar. Sie kÃ¶nnen hier aber eine Nachricht hinterlassen.\"\n                                            offline-finish-message=\"Vielen Dank fÃ¼r Ihre Nachricht, wir melden uns schnellstmÃ¶glich bei Ihnen.\"\n                                            ending-message=\"Your session is over. Please feel free to contact us again!\"\n                                            first-response-message=\"Bitte haben Sie einen Moment Geduld ein Mitarbeiter wir kontaktiert.\"\n                                            greeting-visibility=\"both\"\n                                            greeting-message=\"Hallo, wie kann ich Ihnen helfen?\"\n                                            greeting-offline-visibility=\"both\"\n                                            greeting-offline-message=\"Hallo, hier kÃ¶nnen Sie gern  eine Nachricht hinterlassen. Wir melden uns schnellstmÃ¶glich bei Ihnen. \"\n                                            chat-delay=\"2000\"\n                                            offline-name-message=\"Bitte geben Sie Ihren Namen ein.\"\n                                            offline-email-message=\"Bitte geben Sie eine gÃ¼ltige Mail Adresse ein, damit wir Sie kontaktieren kÃ¶nnen.\"\n                                            offline-form-invalid-name=\"Bitte geben Sie einen gÃ¼ltigen Namen ein.\"\n                                            offline-form-maximum-characters-reached=\"Maximum characters reached\"\n                                            offline-form-invalid-email=\"Die Mail Adresse scheint nicht korrekt zu sein. Bitte geben Sie eine gÃ¼ltige Mail Adresse ein.\"\n                                                </call-us>',0,NULL,0),(167,'2022-03-07 17:30:02','nbi.portal','site.cookie.html.code','HTML Code für Cookie Abfrage.',4,'<script>\n    window.addEventListener(\'load\', function () {\n        // obtain cookieconsent plugin\n        var cookieconsent = initCookieConsent();\n\n        // run plugin with config object\n        cookieconsent.run({\n            autorun: true,\n            current_lang: \'de\',\n            autoclear_cookies: true,\n            page_scripts: true,\n			force_consent: false,\n			revision: 1,\n            onFirstAction: function(user_preferences, cookie){\n                // callback triggered only once\n            },\n\n            onAccept: function (cookie) {\n                // ... cookieconsent accepted\n            },\n\n            onChange: function (cookie, changed_preferences) {\n                // ... cookieconsent preferences were changed\n            },\n\n            languages: {\n                de: {\n                    consent_modal: {\n                        title: \'Wir schätzen Ihre Privatsphäre\',\n                        description: \'Wir verwenden Cookies und andere Technologien, damit unsere Seite zuverlässig und sicher läuft und um Ihre Nutzererfahrung zu optimieren. Damit das funktioniert, sammeln wir Daten über unsere Nutzer. Wenn Sie auf „Akzeptieren“ klicken, sind Sie damit einverstanden. Falls Sie dem nicht zustimmen, beschränken wir uns auf die technisch notwendigen Cookies. Details und alle Optionen finden Sie in den Einstellungen. Hier können Sie Ihre Präferenzen jederzeit anpassen oder Ihre Einwilligung widerrufen. Weitere Informationen finden Sie in unserer Datenschutzerklärung.\',\n                        primary_btn: {\n                            text: \'Akzeptieren\',\n                            role: \'accept_all\'              // \'accept_selected\' or \'accept_all\'\n                        },\n                        secondary_btn: {\n                            text: \'Einstellungen\',\n                            role: \'settings\'                // \'settings\' or \'accept_necessary\'\n                        }\n                    },\n                    settings_modal: {\n                        title: \'Cookie Einstellungen\',\n                        save_settings_btn: \'speichern\',\n                        accept_all_btn: \'Alle akzeptieren\',\n                        reject_all_btn: \'optional Cookies nicht akzeptieren\',       // optional, [v.2.5.0 +]\n                        cookie_table_headers: [\n                            {col1: \'Name\'},\n                            {col2: \'Domain\'},\n                            {col3: \'Expiration\'},\n                            {col4: \'Description\'},\n                            {col5: \'Type\'}\n                        ],\n                        blocks: [\n                            {\n                                title: \'Cookie Einstellungen\',\n                                description: \'Sofern Sie bestimmten Diensten nicht erlauben möchten, anonymisierte Cookies sowie personenbezogene Daten zu sammeln, so können Sie dies hier einstellen. Klicken Sie dazu bitte einfach auf den entsprechenden Button und speichern Sie anschließend Ihre Auswahl.\'\n                            }, {\n                                title: \'technisch notwendige Cookies\',\n                                description: \'Diese Cookies helfen uns dabei, unsere Webseite für Sie technisch zugänglich zu machen. Ohne diese Cookies könnten wir Ihnen wesentliche Grundfunktionen unserer Webseite nicht anbieten.\',\n                                toggle: {\n                                    value: \'necessary\',\n                                    enabled: true,\n                                    readonly: true\n                                }\n                            }, {\n                                title: \'Optimeriung unserer Webseite\',\n                                description: \'Durch unsere Analysedienste können wir besser verstehen, wie Sie und Andere unsere Webseite nutzen. Diese Informationen werden in anonyme Statistiken überführt, die uns helfen, unsere Webseite nutzerfreundlicher zu gestalten.\',\n                                toggle: {\n                                    value: \'analytics\',\n                                    enabled: false,\n                                    readonly: false\n                                },\n                                cookie_table: [\n                                    {\n                                        col1: \'^_ga\',\n                                        col2: \'google.com\',\n                                        col3: \'2 years\',\n                                        col4: \'description ...\',\n                                        col5: \'Permanent cookie\',\n                                        is_regex: true\n                                    },\n                                    {\n                                        col1: \'_gid\',\n                                        col2: \'google.com\',\n                                        col3: \'1 day\',\n                                        col4: \'description ...\',\n                                        col5: \'Permanent cookie\'\n                                    }\n                                ]\n                            }, {\n                            }\n                        ]\n                    }\n                }\n            }\n        });\n    });\n</script> ',0,NULL,0),(168,'2022-03-07 17:30:02','nbi.portal','site.link.remote.access','Link für Fernzugriff Software.',4,'<a  href=\"https://bpl.pcvisit.com/stable_update/v1/hosted/jumplink?productid=18&func=download&productrole=guestSetup&host=nacl.pcvisit.com%2Fstable_update&companyid=5621895427&gateway=lb3.pcvisit.de\">Fernzugriff Support</a>',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.<br>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.<br>Wir arbeiten mit Hochdruck an einer Lösung.<br>Daher bitten wir Sie von Ticket/Mail und Anrufen abzusehen.<br><br>Currently it is partly unavailable.<br>We are working hard on a solution.<br>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);

--
-- Table structure for table `nbi_custom_bill_products`
--

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;

--
-- Dumping data for table `nbi_custom_bill_products`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_custom_bills`
--

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;

--
-- Dumping data for table `nbi_custom_bills`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_customer_product_specials`
--

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;

--
-- Dumping data for table `nbi_customer_product_specials`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_data_center_space_types`
--

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;

--
-- Dumping data for table `nbi_data_center_space_types`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `nbi_domain_handles`
--

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;

--
-- Dumping data for table `nbi_domain_handles`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_domain_infos`
--

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;

--
-- Dumping data for table `nbi_domain_infos`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_domain_pre_registrations`
--

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;

--
-- Dumping data for table `nbi_domain_pre_registrations`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_domain_provider`
--

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;

--
-- Dumping data for table `nbi_domain_provider`
--
-- ORDER BY:  `id`

INSERT INTO `nbi_domain_provider` VALUES (1,'NIC Direct','nicdirect.service'),(2,'InternetX','internetx.service');

--
-- Table structure for table `nbi_domain_transfers`
--

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;

--
-- Dumping data for table `nbi_domain_transfers`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_domains`
--

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;

--
-- Dumping data for table `nbi_domains`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_enviatel_import`
--

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;

--
-- Dumping data for table `nbi_enviatel_import`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_enviatel_itemised_bill_items`
--

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;

--
-- Dumping data for table `nbi_enviatel_itemised_bill_items`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_enviatel_pay_scale`
--

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;

--
-- Dumping data for table `nbi_enviatel_pay_scale`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_enviatel_phone_number`
--

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;

--
-- Dumping data for table `nbi_enviatel_phone_number`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_faq_entry`
--

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;

--
-- Dumping data for table `nbi_faq_entry`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_faq_group`
--

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;

--
-- Dumping data for table `nbi_faq_group`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_group`
--

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;

--
-- Dumping data for table `nbi_group`
--
-- ORDER BY:  `id`

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\";}');

--
-- Table structure for table `nbi_image`
--

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;

--
-- Dumping data for table `nbi_image`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `nbi_incoming_bills`
--

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';

--
-- Dumping data for table `nbi_incoming_bills`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_inventory_item_histories`
--

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;

--
-- Dumping data for table `nbi_inventory_item_histories`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_inventory_items`
--

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;

--
-- Dumping data for table `nbi_inventory_items`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_inventory_locations`
--

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;

--
-- Dumping data for table `nbi_inventory_locations`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_ip_whitelist`
--

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;

--
-- Dumping data for table `nbi_ip_whitelist`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_job_schedule`
--

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;

--
-- Dumping data for table `nbi_job_schedule`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_login_attempt`
--

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;

--
-- Dumping data for table `nbi_login_attempt`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_maintenance_categories`
--

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;

--
-- Dumping data for table `nbi_maintenance_categories`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_maintenance_info`
--

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;

--
-- Dumping data for table `nbi_maintenance_info`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_maintenance_item_templates`
--

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;

--
-- Dumping data for table `nbi_maintenance_item_templates`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_maintenance_items`
--

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;

--
-- Dumping data for table `nbi_maintenance_items`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_maintenance_locations`
--

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;

--
-- Dumping data for table `nbi_maintenance_locations`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_maintenances`
--

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;

--
-- Dumping data for table `nbi_maintenances`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_nameservers`
--

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;

--
-- Dumping data for table `nbi_nameservers`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_network_port`
--

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;

--
-- Dumping data for table `nbi_network_port`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_news_type`
--

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;

--
-- Dumping data for table `nbi_news_type`
--
-- ORDER BY:  `id`

INSERT INTO `nbi_news_type` VALUES (1,'Allgemein','newsGeneral'),(2,'Technik','newsTechnology'),(3,'Produkte','newsProducts'),(4,'Domains','newsDomains'),(5,'Wartung','newsMaintenance');

--
-- Table structure for table `nbi_notification`
--

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;

--
-- Dumping data for table `nbi_notification`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_notification_confirmation`
--

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;

--
-- Dumping data for table `nbi_notification_confirmation`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_pay_time_interval`
--

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;

--
-- Dumping data for table `nbi_pay_time_interval`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `nbi_posting_accounts`
--

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';

--
-- Dumping data for table `nbi_posting_accounts`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_prepaid_payment`
--

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;

--
-- Dumping data for table `nbi_prepaid_payment`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_product_group_has_module`
--

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;

--
-- Dumping data for table `nbi_product_group_has_module`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_product_mail_gateway`
--

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;

--
-- Dumping data for table `nbi_product_mail_gateway`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_product_nbi_suite`
--

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;

--
-- Dumping data for table `nbi_product_nbi_suite`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_project`
--

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;

--
-- Dumping data for table `nbi_project`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_project_task`
--

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;

--
-- Dumping data for table `nbi_project_task`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_public_newsletter`
--

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;

--
-- Dumping data for table `nbi_public_newsletter`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_public_newsletter_messages`
--

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;

--
-- Dumping data for table `nbi_public_newsletter_messages`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_purchase`
--

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;

--
-- Dumping data for table `nbi_purchase`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_server_types`
--

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';

--
-- Dumping data for table `nbi_server_types`
--
-- ORDER BY:  `id`

INSERT INTO `nbi_server_types` VALUES (1,'Dediziert',1),(2,'Virtuell',1),(3,'Master',1);

--
-- Table structure for table `nbi_servers_virtualizations`
--

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;

--
-- Dumping data for table `nbi_servers_virtualizations`
--
-- ORDER BY:  `server_id`,`virtualization_id`


--
-- Table structure for table `nbi_syslog`
--

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;

--
-- Dumping data for table `nbi_syslog`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_syslog_item`
--

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;

--
-- Dumping data for table `nbi_syslog_item`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_ticket`
--

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;

--
-- Dumping data for table `nbi_ticket`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_ticket_category`
--

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;

--
-- Dumping data for table `nbi_ticket_category`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `nbi_ticket_comment`
--

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;

--
-- Dumping data for table `nbi_ticket_comment`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_ticket_filter`
--

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;

--
-- Dumping data for table `nbi_ticket_filter`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `nbi_ticket_info`
--

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;

--
-- Dumping data for table `nbi_ticket_info`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_ticket_mail`
--

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;

--
-- Dumping data for table `nbi_ticket_mail`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_ticket_mail_connection`
--

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;

--
-- Dumping data for table `nbi_ticket_mail_connection`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `nbi_ticket_scheduled_answer`
--

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;

--
-- Dumping data for table `nbi_ticket_scheduled_answer`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_time_recording`
--

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;

--
-- Dumping data for table `nbi_time_recording`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_traffic_history`
--

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;

--
-- Dumping data for table `nbi_traffic_history`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_user`
--

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;

--
-- Dumping data for table `nbi_user`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `nbi_user_user_group`
--

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;

--
-- Dumping data for table `nbi_user_user_group`
--
-- ORDER BY:  `user_id`,`group_id`

INSERT INTO `nbi_user_user_group` VALUES (1,1);

--
-- Table structure for table `nbi_vendor_products`
--

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';

--
-- Dumping data for table `nbi_vendor_products`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_vendors`
--

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';

--
-- Dumping data for table `nbi_vendors`
--
-- ORDER BY:  `id`


--
-- Table structure for table `nbi_virtualization`
--

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;

--
-- Dumping data for table `nbi_virtualization`
--
-- ORDER BY:  `id`

INSERT INTO `nbi_virtualization` VALUES (1,'Bare-Metal'),(2,'LXC'),(3,'KVM');

--
-- Table structure for table `nbi_vlans`
--

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';

--
-- Dumping data for table `nbi_vlans`
--
-- ORDER BY:  `id`

INSERT INTO `nbi_vlans` VALUES (1,'Default vLAN -  nicht verwenden','2022-05-02 14:22:43'),(2,'Transfernetz','2022-05-02 14:22:43');

--
-- Table structure for table `nbi_voucher`
--

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;

--
-- Dumping data for table `nbi_voucher`
--
-- ORDER BY:  `id`


--
-- Table structure for table `network_port_vlan`
--

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;

--
-- Dumping data for table `network_port_vlan`
--
-- ORDER BY:  `network_port_id`,`vlan_id`


--
-- Table structure for table `tbl_bill_products`
--

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;

--
-- Dumping data for table `tbl_bill_products`
--
-- ORDER BY:  `ID`


--
-- Table structure for table `tbl_bills`
--

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;

--
-- Dumping data for table `tbl_bills`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_blackhold`
--

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;

--
-- Dumping data for table `tbl_blackhold`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_country`
--

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;

--
-- Dumping data for table `tbl_country`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `tbl_customer`
--

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;

--
-- Dumping data for table `tbl_customer`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_customer_product_in_use`
--

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;

--
-- Dumping data for table `tbl_customer_product_in_use`
--
-- ORDER BY:  `ID`


--
-- Table structure for table `tbl_history`
--

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;

--
-- Dumping data for table `tbl_history`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_history_type`
--

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;

--
-- Dumping data for table `tbl_history_type`
--
-- ORDER BY:  `id`

INSERT INTO `tbl_history_type` VALUES (1,'Gutschein'),(2,'Rechnung'),(3,'Produkt'),(11,'Sperrung'),(21,'Kundendaten'),(31,'System');

--
-- Table structure for table `tbl_manage_ip_address`
--

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;

--
-- Dumping data for table `tbl_manage_ip_address`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_manage_ip_range`
--

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;

--
-- Dumping data for table `tbl_manage_ip_range`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_manage_os`
--

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;

--
-- Dumping data for table `tbl_manage_os`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `tbl_manage_server`
--

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;

--
-- Dumping data for table `tbl_manage_server`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_modul_group`
--

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;

--
-- Dumping data for table `tbl_modul_group`
--
-- ORDER BY:  `id`

INSERT INTO `tbl_modul_group` VALUES (7,'Vertragsdetails',0);

--
-- Table structure for table `tbl_module`
--

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;

--
-- Dumping data for table `tbl_module`
--
-- ORDER BY:  `id`

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 / &Uuml;berweisung','',0,0,NULL,0,NULL,1,1,NULL),(789,7,'per SEPA-Lastschrift','',NULL,0,NULL,0,NULL,1,1,NULL);

--
-- Table structure for table `tbl_news`
--

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;

--
-- Dumping data for table `tbl_news`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_product`
--

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;

--
-- Dumping data for table `tbl_product`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `tbl_product_group`
--

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;

--
-- Dumping data for table `tbl_product_group`
--
-- ORDER BY:  `id`

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);

--
-- Table structure for table `tbl_product_has_tbl_module`
--

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;

--
-- Dumping data for table `tbl_product_has_tbl_module`
--
-- ORDER BY:  `id`


--
-- Table structure for table `tbl_schedule`
--

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;

--
-- Dumping data for table `tbl_schedule`
--
-- ORDER BY:  `id`



