-- Table structure for table `cw_qualification`
--

CREATE TABLE `cw_qualification` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_qualification`
--


--
-- Table structure for table `cw_quantity_unit`
--

CREATE TABLE `cw_quantity_unit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_quantity_unit`
--


--
-- Table structure for table `cw_region`
--

CREATE TABLE `cw_region` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_region`
--

INSERT INTO `cw_region` VALUES
(1,3,'2019-02-25 20:43:57','\0','Österreich','2020-09-13 14:35:02','A'),
(2,0,'2020-09-13 14:52:48','\0','Baden-Würtemberg','2020-09-13 14:52:48','D-BW'),
(3,0,'2020-09-13 14:52:48','\0','Bayern','2020-09-13 14:52:48','D-BY'),
(4,0,'2020-09-13 14:52:48','\0','Berlin','2020-09-13 14:52:48','D-BE'),
(5,0,'2020-09-13 14:52:48','\0','Brandenburg','2020-09-13 14:52:48','D-BB'),
(6,0,'2020-09-13 14:52:48','\0','Bremen','2020-09-13 14:52:48','D-HB'),
(7,0,'2020-09-13 14:52:48','\0','Hamburg','2020-09-13 14:52:48','D-HH'),
(8,0,'2020-09-13 14:52:48','\0','Hessen','2020-09-13 14:52:48','D-HE'),
(9,0,'2020-09-13 14:52:48','\0','Mecklenburg Vorpommern','2020-09-13 14:52:48','D-MV'),
(10,0,'2020-09-13 14:52:48','\0','Niedersachsen','2020-09-13 14:52:48','D-NI'),
(11,0,'2020-09-13 14:52:48','\0','Nordrhein-Westfalen','2020-09-13 14:52:48','D-NW'),
(12,0,'2020-09-13 14:52:48','\0','Reinland-Pfalz','2020-09-13 14:52:48','D-RP'),
(13,0,'2020-09-13 14:52:48','\0','Saarland','2020-09-13 14:52:48','D-SL'),
(14,0,'2020-09-13 14:52:48','\0','Sachsen','2020-09-13 14:52:48','D-SN'),
(15,0,'2020-09-13 14:52:48','\0','Sachsen-Anhalt','2020-09-13 14:52:48','D-ST'),
(16,0,'2020-09-13 14:52:48','\0','Schleswig-Holstein','2020-09-13 14:52:48','D-SH'),
(17,0,'2020-09-13 14:52:48','\0','Thüringen','2020-09-13 14:52:48','D-TH'),
(18,0,'2020-09-13 14:52:48','\0','Aargau','2020-09-13 14:52:48','CH-AG'),
(19,0,'2020-09-13 14:52:48','\0','Appenzell-Außerrhoden','2020-09-13 14:52:48','CH-AR'),
(20,0,'2020-09-13 14:52:48','\0','Appenzell-Innerrohden','2020-09-13 14:52:48','CH-AI'),
(21,0,'2020-09-13 14:52:48','\0','Basel-Landschaft','2020-09-13 14:52:48','CH-BL'),
(22,0,'2020-09-13 14:52:48','\0','Basel-Stadt','2020-09-13 14:52:48','CH-BS'),
(24,0,'2020-09-13 14:52:49','\0','Freiburg','2020-09-13 14:52:49','CH-FR'),
(25,0,'2020-09-13 14:52:49','\0','Genf','2020-09-13 14:52:49','CH-GE'),
(26,0,'2020-09-13 14:52:49','\0','Glarus','2020-09-13 14:52:49','CH-GL'),
(27,0,'2020-09-13 14:52:49','\0','Graubünden','2020-09-13 14:52:49','CH-GR'),
(28,0,'2020-09-13 14:52:49','\0','Jura','2020-09-13 14:52:49','CH-JU'),
(29,0,'2020-09-13 14:52:49','\0','Luzern','2020-09-13 14:52:49','CH-LU'),
(30,0,'2020-09-13 14:52:49','\0','Neuenburg','2020-09-13 14:52:49','CH-NE'),
(31,0,'2020-09-13 14:52:49','\0','Nidwalden','2020-09-13 14:52:49','CH-NW'),
(32,0,'2020-09-13 14:52:49','\0','Obwalden','2020-09-13 14:52:49','CH-OW'),
(33,0,'2020-09-13 14:52:49','\0','Schaffhausen','2020-09-13 14:52:49','CH-SH'),
(34,0,'2020-09-13 14:52:49','\0','Schwyz','2020-09-13 14:52:49','CH-SZ'),
(35,0,'2020-09-13 14:52:49','\0','Solothurn','2020-09-13 14:52:49','CH-SO'),
(36,0,'2020-09-13 14:52:49','\0','St. Gallen','2020-09-13 14:52:49','CH-SG'),
(37,0,'2020-09-13 14:52:49','\0','Tessin','2020-09-13 14:52:49','CH-TI'),
(38,0,'2020-09-13 14:52:49','\0','Thurgau','2020-09-13 14:52:49','CH-TG'),
(39,0,'2020-09-13 14:52:49','\0','Uri','2020-09-13 14:52:49','CH-UR'),
(40,0,'2020-09-13 14:52:49','\0','Waadt','2020-09-13 14:52:49','CH-VD'),
(41,0,'2020-09-13 14:52:49','\0','Wallis','2020-09-13 14:52:49','CH-VS'),
(42,0,'2020-09-13 14:52:49','\0','Zug','2020-09-13 14:52:49','CH-ZG'),
(43,0,'2020-09-13 14:52:49','\0','Zürich','2020-09-13 14:52:49','CH-ZH'),
(44,0,'2020-09-13 14:52:49','\0','Fürstentum Liechtenstein','2020-09-13 14:52:49','FL'),
(45,0,'2020-09-13 14:52:49','\0','Trentino-Südtirol','2020-09-13 14:52:49','I-T_ST'),
(47,0,'2020-09-16 06:07:05','\0','Bern','2020-09-16 06:07:05','CH-BE');

--
-- Table structure for table `cw_relay_plan`
--

CREATE TABLE `cw_relay_plan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_relay_plan`
--


--
-- Table structure for table `cw_religion`
--

CREATE TABLE `cw_religion` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_religion`
--

INSERT INTO `cw_religion` VALUES
(1,0,'2018-02-07 11:37:08','\0','römisch katholisch','2018-02-07 11:37:08','rk'),
(2,0,'2018-02-07 11:37:14','\0','evangelisch','2018-02-07 11:37:14','ev'),
(3,0,'2018-02-07 11:37:19','\0','unbekannt','2018-02-07 11:37:19','u');

--
-- Table structure for table `cw_report_role_2_group_definition`
--

CREATE TABLE `cw_report_role_2_group_definition` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `group_definition_id` bigint(20) NOT NULL,
  `report_role_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgdqvdsvyr53r6l0jmdqoow6qr` (`group_definition_id`),
  KEY `FKto8gmnvww136pt8517bafx3l8` (`report_role_id`),
  CONSTRAINT `FKgdqvdsvyr53r6l0jmdqoow6qr` FOREIGN KEY (`group_definition_id`) REFERENCES `cw_group_definition` (`id`),
  CONSTRAINT `FKto8gmnvww136pt8517bafx3l8` FOREIGN KEY (`report_role_id`) REFERENCES `cw_operator_role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_report_role_2_group_definition`
--


--
-- Table structure for table `cw_report_role_2_sort_definition`
--

CREATE TABLE `cw_report_role_2_sort_definition` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `report_role_id` bigint(20) NOT NULL,
  `sort_definition_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKnvvvj4puc44utfg9ish4bqtp7` (`report_role_id`),
  KEY `FKdls1vlmdsmdg516s20xd2vrqp` (`sort_definition_id`),
  CONSTRAINT `FKdls1vlmdsmdg516s20xd2vrqp` FOREIGN KEY (`sort_definition_id`) REFERENCES `cw_sort_definition` (`id`),
  CONSTRAINT `FKnvvvj4puc44utfg9ish4bqtp7` FOREIGN KEY (`report_role_id`) REFERENCES `cw_operator_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_report_role_2_sort_definition`
--

INSERT INTO `cw_report_role_2_sort_definition` VALUES
(1,0,128,1),
(2,0,128,2),
(3,0,136,1),
(4,0,136,2),
(5,0,196,10),
(6,0,298,10);

--
-- Table structure for table `cw_report_role_2_time_time_type_definition`
--

CREATE TABLE `cw_report_role_2_time_time_type_definition` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `report_role_id` bigint(20) NOT NULL,
  `time_time_type_definition_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKqdglhs9on4bdot74bch4aycs0` (`report_role_id`),
  KEY `FKbk5g7oy73ts838cx1rwws6fvo` (`time_time_type_definition_id`),
  CONSTRAINT `FKbk5g7oy73ts838cx1rwws6fvo` FOREIGN KEY (`time_time_type_definition_id`) REFERENCES `cw_time_time_type_definition` (`id`),
  CONSTRAINT `FKqdglhs9on4bdot74bch4aycs0` FOREIGN KEY (`report_role_id`) REFERENCES `cw_operator_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_report_role_2_time_time_type_definition`
--

INSERT INTO `cw_report_role_2_time_time_type_definition` VALUES
(1,0,128,2),
(2,0,136,2);

--
-- Table structure for table `cw_requestmap`
--

CREATE TABLE `cw_requestmap` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `config_attribute` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_3wmhfveydokoo5v3jqpe5my5n` (`url`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_requestmap`
--

INSERT INTO `cw_requestmap` VALUES
(1,4,'ROLE_GWT','/gwtRESTfulSec*/**'),
(2,1,'permitAll','/'),
(3,4,'ROLE_GWT','/index'),
(4,4,'ROLE_GWT','/index.gsp'),
(5,4,'ROLE_GWT','/index2'),
(6,4,'ROLE_GWT','/index2.gsp'),
(7,0,'permitAll','/favicon.ico'),
(8,4,'ROLE_GWT','/**/favicon.ico'),
(9,4,'ROLE_GWT','/assets/**'),
(10,4,'ROLE_GWT','/**/js/**'),
(11,4,'ROLE_GWT','/**/css/**'),
(12,0,'permitAll','/**/images/**'),
(13,0,'permitAll','/login'),
(14,0,'permitAll','/login.*'),
(15,0,'permitAll','/login/*'),
(16,0,'permitAll','/logout'),
(17,0,'permitAll','/logout.*'),
(18,0,'permitAll','/logout/*'),
(19,0,'permitAll','/error'),
(20,0,'permitAll','/error.*'),
(21,0,'permitAll','/error/*'),
(22,0,'permitAll','/services/**'),
(23,4,'ROLE_GWT','/gwtAuthentification/**'),
(24,0,'permitAll','/gwtWithoutAuthentification/**'),
(25,0,'permitAll','/gwtRESTfulUserAndPassword/**'),
(26,0,'permitAll','/**/cw_js/**'),
(27,0,'permitAll','/**/cw_css/**'),
(28,0,'permitAll','/**/cw_firmware/**'),
(29,0,'permitAll','/cw_firmware/**'),
(30,4,'ROLE_GWT','/**/cw_fonts/**'),
(31,4,'ROLE_GWT','/**/cw_images/**'),
(32,4,'ROLE_GWT','/**/cw_jquery-ui/**'),
(33,4,'ROLE_GWT','/**/cw_reports/**'),
(34,1,'permitAll','/**/cw_temp/**'),
(35,4,'ROLE_GWT','/gwt/**'),
(36,4,'ROLE_GWT','/gwt*/**'),
(37,0,'permitAll','/gwtTerminalTmcBooking/**'),
(38,0,'permitAll','/gwtRESTful/**'),
(39,0,'permitAll','/gwtRESTfulBooking/**'),
(40,0,'permitAll','/gwtRESTfulGetBalances/**'),
(41,0,'permitAll','/gwtRESTfulGetPresenceAbsenceList/**'),
(42,0,'permitAll','/cw_js/clockworkgwtterminaltmcbooking/**'),
(43,0,'permitAll','/supertraxLiteBatch/**'),
(44,0,'permitAll','/supertraxLiteKeepAlive/**'),
(45,0,'permitAll','/supertrax4LiteOnline/**'),
(46,0,'permitAll','/supertrax7LiteOnline/**'),
(47,0,'permitAll','/supertrax10LiteOnline/**'),
(48,0,'permitAll','/x1LiteOnline/**'),
(49,0,'permitAll','/clockworkHardwareV1Batch/**'),
(50,0,'permitAll','/clockworkHardwareV1KeepAlive/**'),
(51,0,'permitAll','/clockworkHardwareV1Online/**'),
(52,0,'permitAll','/datafox/**'),
(53,0,'permitAll','/gwtViewPersonVisualisation/**'),
(54,0,'permitAll','/gwtViewPresenceAbsence/**'),
(55,0,'permitAll','/gwtRESTfulViewPresenceAbsence/**'),
(56,0,'permitAll','/gwtRESTfulViewPersonVisualisation/**'),
(57,0,'permitAll','/cw_js/clockworkgwttimeviewpresenceabsence/**'),
(58,0,'permitAll','/bookingViaKeyboard1/**'),
(59,0,'permitAll','/gwtRESTfulBookInTerminalSimulation/**'),
(60,0,'permitAll','/gwtRESTfulBaseData/**'),
(61,0,'permitAll','/clockwork.appcache'),
(62,0,'permitAll','/**/clockwork.appcache'),
(63,0,'permitAll','/static/myapp.appcache'),
(64,0,'permitAll','/checkAuthentification'),
(65,0,'permitAll','/requestHeader'),
(66,0,'permitAll','/clockworkMobileBookingOnlineV4/**'),
(67,0,'permitAll','/clockworkMobileBookingOfflineV4/**'),
(68,0,'permitAll','/clockworkMobileInitDeviceV4/**'),
(69,0,'permitAll','/clockworkMobileSetPasswordV4/**'),
(70,0,'permitAll','/clockworkMobileSynchronizeConfigurationV4/**'),
(71,0,'permitAll','/mobile'),
(72,0,'permitAll','/clockworkMobileInitDeviceV3/**'),
(73,0,'permitAll','/clockworkMobileSetPasswordV3/**'),
(74,0,'permitAll','/clockworkMobileSynchronizeConfigurationV3/**'),
(75,0,'permitAll','/clockworkMobileBookingOnlineV3/**'),
(76,0,'permitAll','/clockworkMobileBookingOfflineV3/**'),
(77,0,'permitAll','/clockworkMobileExpenseBookingOnlineV4/**'),
(78,0,'permitAll','/clockworkMobileExpenseBookingOfflineV4/**'),
(79,0,'permitAll','/clockworkMobileBookingV4/**'),
(80,0,'permitAll','/demo/**'),
(81,0,'permitAll','/clockworkHardwareV1ChangedInputState/**'),
(82,0,'permitAll','/clockworkMobileTimeDurationOnlineV4/**'),
(83,0,'permitAll','/clockworkMobileTimeDurationOfflineV4/**'),
(84,0,'permitAll','/clockworkMobileCameraBookingOnlineV4/**'),
(85,0,'permitAll','/clockworkMobileCameraBookingOfflineV4/**'),
(86,0,'permitAll','/validateIfLoggedIn/**'),
(87,0,'permitAll','/reactRESTfulNotSec/**'),
(88,0,'permitAll','/clockworkMobile/**'),
(89,1,'permitAll','/reactMobile'),
(90,4,'ROLE_GWT','/reactRESTfulSec*/**'),
(91,0,'permitAll','/cw_react/**'),
(92,0,'permitAll','/**/cw_react/**'),
(93,0,'permitAll','/datafoxLevel1/**'),
(94,5,'ROLE_GWT','/webSocketEndpoint'),
(95,5,'ROLE_GWT','/webSocketEndpoint/**'),
(96,5,'ROLE_GWT','/**/webSocketEndpoint/**'),
(97,0,'permitAll','/unsecClockworkMobile/**'),
(98,0,'permitAll','/jwtMandatory'),
(99,0,'permitAll','/api/login'),
(100,0,'permitAll','/api/logout'),
(101,0,'permitAll','/api/validate'),
(102,0,'permitAll','/oauth/access_token'),
(103,4,'ROLE_GWT','/secClockwork*/**'),
(104,0,'permitAll','/clockworkTerminalWebSocketEndpoint'),
(105,0,'permitAll','/clockworkTerminalWebSocketEndpoint/**'),
(106,0,'permitAll','/**/clockworkTerminalWebSocketEndpoint/**'),
(107,0,'permitAll','/isLoggedIn/**'),
(108,0,'permitAll','/isReachable/**'),
(109,4,'ROLE_GWT','/clockworkMobileWebSocketEndpoint'),
(110,4,'ROLE_GWT','/clockworkMobileWebSocketEndpoint/**'),
(111,4,'ROLE_GWT','/**/clockworkMobileWebSocketEndpoint/**'),
(112,4,'ROLE_GWT','/secFMS*/**'),
(113,0,'permitAll','/unsecFMS*/**'),
(114,0,'permitAll','/gwtRESTfulGetBookings/**'),
(115,2,'ROLE_GWT','/**/cw_report_output/**'),
(116,0,'permitAll','/unsec*/**'),
(117,0,'permitAll','/supertrax4V2LiteOnline/**'),
(118,0,'permitAll','/gantnerGT7TimeAttendanceWebSocketEndpoint'),
(119,0,'permitAll','/gantnerGT7TimeAttendanceWebSocketEndpoint/**'),
(120,0,'permitAll','/**/gantnerGT7TimeAttendanceWebSocketEndpoint/**'),
(121,0,'permitAll','/gantnerGT7TimeAttendance/**'),
(122,0,'permitAll','/services'),
(123,0,'ROLE_GWT','/services/communication**'),
(124,0,'ROLE_GWT','/services/customer**'),
(125,0,'permitAll','/services/foxpro**'),
(126,0,'permitAll','/services/seccor**'),
(127,0,'permitAll','/**/cw_lib/**'),
(128,0,'permitAll','/registerFoxpro/**'),
(129,0,'permitAll','/datafoxConfiguration/**'),
(130,0,'permitAll','/datafoxLogLevel1/**');

--
-- Table structure for table `cw_ressource`
--

CREATE TABLE `cw_ressource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `number` varchar(255) NOT NULL,
  `ressource_category_id` bigint(20) NOT NULL,
  `max_reservation_time` int(11) NOT NULL,
  `min_reservation_time` int(11) NOT NULL,
  `multiple_occupancy` bit(1) NOT NULL,
  `slot_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjwlguumqrv6gns2lk81bcbohd` (`ressource_category_id`),
  CONSTRAINT `FKjwlguumqrv6gns2lk81bcbohd` FOREIGN KEY (`ressource_category_id`) REFERENCES `cw_ressource_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_ressource`
--


--
-- Table structure for table `cw_ressource_category`
--

CREATE TABLE `cw_ressource_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_ressource_category`
--


--
-- Table structure for table `cw_role`
--

CREATE TABLE `cw_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `authority` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_nxgqoxswbkbfqm31mpsybq9qq` (`authority`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_role`
--

INSERT INTO `cw_role` VALUES
(1,0,'ROLE_GWT','Gwt-Client-Side'),
(2,0,'ROLE_ADMIN','Administrator'),
(3,0,'ROLE_MAINTENANCE','Verwaltung'),
(4,0,'ROLE_BOOKING','Buchung'),
(5,0,'ROLE_BOOKING_ADVANCED','Buchung (erweitert)'),
(6,0,'ROLE_ABSENCEPLANNING','Abwesenheitsplanung'),
(7,0,'ROLE_PRESENCEPLANNING','Anwesenheitsplanung'),
(8,0,'ROLE_WORKPLANNING','Arbeitsplanung'),
(9,0,'ROLE_TIMEREPORT','Pesonalzeit-Bericht'),
(10,0,'ROLE_WORKREPORT','Betriebsdaten-Bericht'),
(11,0,'ROLE_VIEWPRESENCEABSENCE','Anwesenheitsübersicht'),
(12,0,'ROLE_CURRENTHOURSOFWORK','aktuelle Arbeitszeit'),
(13,0,'ROLE_SHOWREQUESTSINMAINMENU','zeige Requests im Hauptmenü'),
(14,0,'ROLE_TRANSFERUSEROPERATORROLE','Übertragen der Berechtigungstypen'),
(15,0,'ROLE_VIEWINFORMATION','zeige Informationen'),
(16,0,'ROLE_VIEWPERSONTIMEOVERVIEW','zeige Personenübersicht'),
(17,0,'ROLE_PERSONCATEGORYPLANNING','plane Gruppen'),
(18,0,'ROLE_VIEWGOOGLEMAPS','zeige GoogleMaps-Daten'),
(19,0,'ROLE_JAVA_SCRIPT','Java Script');

--
-- Table structure for table `cw_sale_order`
--

CREATE TABLE `cw_sale_order` (
  `id` bigint(20) NOT NULL,
  `discount_in_percent` double NOT NULL,
  `discount_total` double NOT NULL,
  `invoice_contact_id` bigint(20) DEFAULT NULL,
  `invoice_to_enum` varchar(255) NOT NULL,
  `start_periodical_invoice` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKa9rygh0e5hqays2uju017qnl3` (`invoice_contact_id`),
  CONSTRAINT `FKa9rygh0e5hqays2uju017qnl3` FOREIGN KEY (`invoice_contact_id`) REFERENCES `cw_company_2_contact` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sale_order`
--


--
-- Table structure for table `cw_sale_order_item`
--

CREATE TABLE `cw_sale_order_item` (
  `id` bigint(20) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `discount_per_unit` double NOT NULL,
  `discount_per_unit_in_percent` double NOT NULL,
  `discount_total` double NOT NULL,
  `price_per_unit` double NOT NULL,
  `start_periodical_invoice` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sale_order_item`
--


--
-- Table structure for table `cw_script`
--

CREATE TABLE `cw_script` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `code` longtext DEFAULT NULL,
  `code2` longtext DEFAULT NULL,
  `code3` longtext DEFAULT NULL,
  `code4` longtext DEFAULT NULL,
  `code5` longtext DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  `trigger_id` bigint(20) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `file_upload1` bit(1) DEFAULT NULL,
  `file_upload2` bit(1) DEFAULT NULL,
  `file_upload3` bit(1) DEFAULT NULL,
  `file_upload4` bit(1) DEFAULT NULL,
  `file_upload5` bit(1) DEFAULT NULL,
  `logged_in_user_as_parameter` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3fe6fvxbqjr0yo1pet4kqjbfh` (`trigger_id`),
  CONSTRAINT `FK3fe6fvxbqjr0yo1pet4kqjbfh` FOREIGN KEY (`trigger_id`) REFERENCES `cw_trigger` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_script`
--

INSERT INTO `cw_script` VALUES
(1,25,'\nimport at.clockwork.time.domain.*\nimport at.clockwork.transfer.gwtTransfer.client.enumeration.TimeModelDayEnum\n\nimport java.io.*\nimport java.nio.charset.*\nimport java.text.SimpleDateFormat\n\nclass ImportPublicHolidaysService {\n\n	static transactional = false //TODO = true\n\n	List regionList = [\n\n		[name: \"A\", description:\"Österreich\", geo:3058]\n\n		,[name: \"D-BW\", description:\"Baden-Würtemberg\", geo:3060]\n		,[name: \"D-BY\", description:\"Bayern\", geo:3061]\n		,[name: \"D-BE\", description:\"Berlin\", geo:3062]\n		,[name: \"D-BB\", description:\"Brandenburg\", geo:3063]\n		,[name: \"D-HB\", description:\"Bremen\", geo:3064]\n		,[name: \"D-HH\", description:\"Hamburg\", geo:3065]\n		,[name: \"D-HE\", description:\"Hessen\", geo:3066]\n		,[name: \"D-MV\", description:\"Mecklenburg Vorpommern\", geo:3067]\n		,[name: \"D-NI\", description:\"Niedersachsen\", geo:3068]\n		,[name: \"D-NW\", description:\"Nordrhein-Westfalen\", geo:3069]\n		,[name: \"D-RP\", description:\"Reinland-Pfalz\", geo:3070]\n		,[name: \"D-SL\", description:\"Saarland\", geo:3071]\n		,[name: \"D-SN\", description:\"Sachsen\", geo:3072]\n		,[name: \"D-ST\", description:\"Sachsen-Anhalt\", geo:3073]\n		,[name: \"D-SH\", description:\"Schleswig-Holstein\", geo:3074]\n		,[name: \"D-TH\", description:\"Thüringen\", geo:3075]\n\n		,[name: \"CH-AG\", description:\"Aargau\", geo:1]\n		,[name: \"CH-AR\", description:\"Appenzell-Außerrhoden\", geo:245]\n		,[name: \"CH-AI\", description:\"Appenzell-Innerrohden\", geo:266]\n		,[name: \"CH-BL\", description:\"Basel-Landschaft\", geo:273]\n		,[name: \"CH-BS\", description:\"Basel-Stadt\", geo:365]\n		,[name: \"CH-BE\", description:\"Bern\", geo:369]\n		,[name: \"CH-FR\", description:\"Freiburg\", geo:796]\n		,[name: \"CH-GE\", description:\"Genf\", geo:1026]\n		,[name: \"CH-GL\", description:\"Glarus\", geo:1072]\n		,[name: \"CH-GR\", description:\"Graubünden\", geo:1102]\n		,[name: \"CH-JU\", description:\"Jura\", geo:1323]\n		,[name: \"CH-LU\", description:\"Luzern\", geo:1410]\n		,[name: \"CH-NE\", description:\"Neuenburg\", geo:1523]\n		,[name: \"CH-NW\", description:\"Nidwalden\", geo:1592]\n		,[name: \"CH-OW\", description:\"Obwalden\", geo:1604]\n		,[name: \"CH-SH\", description:\"Schaffhausen\", geo:1612]\n		,[name: \"CH-SZ\", description:\"Schwyz\", geo:1653]\n		,[name: \"CH-SO\", description:\"Solothurn\", geo:1690]\n		,[name: \"CH-SG\", description:\"St. Gallen\", geo:1827]\n		,[name: \"CH-TI\", description:\"Tessin\", geo:1932]\n		,[name: \"CH-TG\", description:\"Thurgau\", geo:2173]\n		,[name: \"CH-UR\", description:\"Uri\", geo:2262]\n		,[name: \"CH-VD\", description:\"Waadt\", geo:2283]\n		,[name: \"CH-VS\", description:\"Wallis\", geo:2685]\n		,[name: \"CH-ZG\", description:\"Zug\", geo:2860]\n		,[name: \"CH-ZH\", description:\"Zürich\", geo:2872]\n		\n		,[name: \"FL\", description:\"Fürstentum Liechtenstein\", geo:3057]\n\n       	,[name: \"I-T_ST\", description:\"Trentino-Südtirol\", geo:3434]\n       	\n	]\n	\n	int startYear = 2020\n	int endYear = 2034\n	String dateFormat = \"dd.MM.yyyy\"\n	SimpleDateFormat simpleDateFormat = new SimpleDateFormat(dateFormat)\n							\n	def run() {\n\n		if (false) {\n			regionList.each { Map regionMap ->\n				if (!Region.findWhere(name:regionMap.name, deleted:false)) {\n					new Region(name:regionMap.name, description:regionMap.description).save()\n				}\n			}\n		}\n		\n		Region.findAllWhere(deleted:false).each { Region region ->\n\n			Map data = regionList.find { it.name == region.name }\n			if (data) {\n				for (int year : startYear .. endYear) {\n					getData(region, data.geo, year)\n				}\n			}\n		\n		}\n\n	}\n	\n	\n	void getData(Region region, int geo, int year) {\n	\n		List allowedItemList = [\"1\", \"2\"]\n		\n		println \"\"\"\nDaten: ${region.name}, geo=$geo, year=$year\n=====================================\"\"\"\n		\n		String url = \"https://www.feiertagskalender.ch/index.php?geo=$geo&jahr=$year\"\n		String data = getDataFromUrl(url)\n		\n		String startBodySearch = \"<tbody>\"\n		String endBodySearch = \"</tbody>\"\n		String startRowSearch = \"<tr class\"\n		String endRowSearch = \"</tr>\"\n		String startDateSearch = \"<td><span class=\\\"dark\\\">\"\n		String endDateSearch = \"</span></td>\"\n		String startNameSearch = \"\\\">\"\n		String endNameSearch = \"</a>\"\n		String startKennzeichenSearch = \"\\\">\"\n		String endKennzeichenSearch = \"</span>\"\n		\n		int startBody = data.indexOf(startBodySearch)\n		int endBody = data.indexOf(endBodySearch, startBody)\n		if (startBody > 0 && endBody > 0 && endBody > startBody) {\n		\n			String body = data[startBody .. endBody+endBodySearch.size()]\n			while (body.size() > 0) {\n				\n				int startRow = body.indexOf(startRowSearch)\n				int endRow = body.indexOf(endRowSearch, startRow)\n				if (startRow > 0 && endRow > 0 && endRow > startRow) {\n					\n					String tr = body[startRow .. endRow+endRowSearch.size()]\n					\n					if (tr && tr.size() > 0) {\n					\n						int startDate = tr.indexOf(startDateSearch)\n						int endDate = tr.indexOf(endDateSearch, startDate)\n						if (startDate > 0 && endDate > 0 && endDate > startDate) {\n						\n							String dateString = tr[startDate+startDateSearch.size() .. endDate-1].trim()\n							Date date = simpleDateFormat.parse(dateString)\n							\n							tr = tr[endDate+endDateSearch.size()..-1]\n							\n							int startDummy = tr.indexOf(\"<td\")\n							int endDummy = tr.indexOf(\"</td\", startDummy)\n							if (startDummy > 0 && endDummy > 0 && endDummy > startDummy) {\n								tr = tr[endDummy+2..-1]\n							}\n							\n							int startName = tr.indexOf(startNameSearch)\n							int endName = tr.indexOf(endNameSearch, startName)\n							if (startName > 0 && endName > 0 && endName > startName) {\n							\n								String name = tr[startName+startNameSearch.size() .. endName-1].trim()\n								tr = tr[endName+endNameSearch.size()..-1]\n								\n								startDummy = tr.indexOf(\"<td\")\n								endDummy = tr.indexOf(\"</td\", startDummy)\n								if (startDummy > 0 && endDummy > 0 && endDummy > startDummy) {\n									tr = tr[endDummy+2..-1]\n								}\n								\n								int startKennzeichen = tr.indexOf(startKennzeichenSearch)\n								int endKennzeichen = tr.indexOf(endKennzeichenSearch, startKennzeichen)\n								\n								if (startKennzeichen > 0 && endKennzeichen > 0 && endKennzeichen > startKennzeichen) {\n								\n									String kennzeichen = tr[startKennzeichen+startKennzeichenSearch.size() .. endKennzeichen-1].trim()\n									if (allowedItemList.any{it == kennzeichen}) {\n										\n										println \"date=$date, kennzeichen=$kennzeichen, name=$name\"\n										\n										PublicHoliday publicHoliday = PublicHoliday.findWhere(date:date, deleted:false)\n										if (!publicHoliday) {\n											publicHoliday = new PublicHoliday(date:date)\n										}\n										publicHoliday.description = name\n										publicHoliday.save()\n\n										Religion.findAllWhere(deleted:false).each { Religion religion ->\n										\n											PublicHoliday2Detail publicHoliday2Detail = PublicHoliday2Detail.findWhere(publicHoliday:publicHoliday, region:region, religion:religion)\n											if (!publicHoliday2Detail) {\n												publicHoliday2Detail = new PublicHoliday2Detail(publicHoliday:publicHoliday, region:region, religion:religion)\n												publicHoliday2Detail.dayEnum = TimeModelDayEnum.HOLIDAY_1\n												publicHoliday2Detail.save()\n											}\n											\n										}\n										\n									}\n									tr = tr[endKennzeichen+endKennzeichenSearch.size()..-1]\n								\n								}\n							\n							}\n						\n						}\n				\n				\n					}\n					\n					\n					body = body[endRow+endRowSearch.size()..-1]\n				\n				} else {\n\n					body = \"\"\n					\n				}\n			\n			}\n		\n		}\n	\n	}\n	\n	\n	String getDataFromUrl(String url) {\n	\n		URL oracle = new URL(url);\n		URLConnection yc = oracle.openConnection();\n		\n//		BufferedReader bin = new BufferedReader(new InputStreamReader(yc.getInputStream()));\n		BufferedReader bin = new BufferedReader(new InputStreamReader(yc.getInputStream(), \"UTF-8\"));\n		\n		String inputLine;\n		String result = \"\"\n		while ((inputLine = bin.readLine()) != null) {\n			result += inputLine\n		}\n		bin.close();\n		return result\n	\n	}\n	\n}','','','','','2018-02-07 00:36:37','\0','Feiertage 2021-2034 importieren','2025-03-24 00:43:59','Feiertage 2020-2034',NULL,0,'\0','\0','\0','\0','\0','\0'),
(2,23,'\nimport at.clockwork.time.domain.*\n\nclass ImportPublicHolidaysService {\n\n	static transactional = false //TODO = true\n\n	def run() {\n\n		println \"ImportPublicHolidaysService.run() - start\"\n\n		PublicHoliday2Detail.executeUpdate(\"delete from PublicHoliday2Detail where publicHoliday in (from PublicHoliday where deleted = true)\")\n		PublicHoliday2Detail.executeUpdate(\"delete from PublicHoliday2Detail where region in (from Region where deleted = true)\")\n		PublicHoliday2Detail.executeUpdate(\"delete from PublicHoliday2Detail where religion in (from Religion where deleted = true)\")\n\n		PublicHoliday.executeUpdate(\"delete from PublicHoliday where id not in (select publicHoliday.id from PublicHoliday2Detail)\")\n\n		Region.executeUpdate(\"delete from Region where id not in (select region.id from PublicHoliday2Detail)\")\n\n		println \"ImportPublicHolidaysService.run() - end\"\n\n	}\n	\n}','','','','','2020-09-15 17:16:05','\0','Feiertage bereinigen','2020-09-16 06:03:15','Feiertage clear',NULL,0,'\0','\0','\0','\0','\0','\0'),
(3,0,'import at.clockwork.time.domain.*\nimport at.clockwork.time.timeModel.domain.*\n\nimport at.clockwork.security.domain.*\n\nimport at.clockwork.transfer.gwtTransfer.client.enumeration.*\n\nimport at.clockwork.utility.ToolsService\n\nimport at.clockwork.singleton.SystemConfigurations\nimport at.clockwork.singleton.GrailsApplicationHolder\n\nimport grails.util.Holders\n\nclass TimeTimeModelService {\n\n	static transactional = false\n\n	def securityService = Holders.grailsApplication.mainContext.getBean \'securityService\'\n\n	def timeModel2DetailWriteService = Holders.grailsApplication.mainContext.getBean \'timeModel2DetailWriteService\'\n\n	def systemConfigurations = SystemConfigurations.getInstance()\n	def grailsApplicationHolder = GrailsApplicationHolder.getInstance()\n\n	final static int LOG_INFO = 1\n	final static int LOG_DEBUG = 2\n	int logLevel = LOG_DEBUG\n\n	def run() {\n		\n		log \"Tagesmodelle EVERY_DAY - Start\"\n	\n		try {\n\n			def grailsApplication = grailsApplicationHolder.getGrailsApplication()\n\n			for (domainClass in grailsApplication.domainClasses.findAll { it.clazz.simpleName.startsWith(\"TimeModel2\") }) {\n\n				Class clazz = domainClass.clazz\n				for (def domainObject in  clazz.findAllWhere( deleted : false, dayEnum : TimeModelDayEnum.NORMAL )) {\n					println \"  $domainObject / ${domainObject.getClass()}: ${domainObject.properties}\"\n\n					Map findMap = [:]\n					domainObject.properties.each { prop ->\n\n//						println \"  $prop / ${prop?.getClass()}\"\n						for ( propMap in prop ) {\n//							println \"   key=${prop.key} value=${prop.value}\"\n\n							switch( propMap.key ) {\n\n								case \"id\":\n								case \"version\":\n								case \"dateCreated\":\n								case \"lastUpdated\":\n								case \"updateCounter\":\n								case \"dayEnum\":\n									break\n\n								default:\n									def fieldProps = domainClass.properties.find { it.getName() == propMap.key }\n									if ( fieldProps?.persistent == true ) {\n										findMap[ propMap.key ] = propMap.value\n									}\n									break\n\n							}\n\n						}\n					}\n\n					List list = clazz.findAllWhere( findMap )\n					if ( list.size() == 3 && \n						list.any { it.dayEnum == TimeModelDayEnum.NORMAL } &&\n						list.any { it.dayEnum == TimeModelDayEnum.HOLIDAY_1 } &&\n						list.any { it.dayEnum == TimeModelDayEnum.HOLIDAY_2 }\n					) {\n						list[0].dayEnum = TimeModelDayEnum.EVERY_DAY\n						timeModel2DetailWriteService.save( list[0] )\n\n						list[1].deleted = true\n						timeModel2DetailWriteService.save( list[1] )\n\n						list[2].deleted = true\n						timeModel2DetailWriteService.save( list[2] )\n						\n					}\n\n\n				}\n\n			}\n\n\n		} catch(e) {\n			println e.getMessage()\n			println e.getStackTrace()\n		}\n		\n		log \"Tagesmodelle EVERY_DAY - Ende\"\n\n	}\n\n	void log(String text, level = LOG_INFO) {\n\n		switch(logLevel) {\n			case LOG_DEBUG:\n				println text\n			break\n\n			case LOG_INFO:\n			default:\n				if (level == LOG_INFO)\n					println text\n			break\n		}\n\n	}\n\n}\n','','','','','2024-03-12 12:19:23','\0','Tagesmodelle -> EveryDay','2024-03-12 12:19:23','EveryDay',NULL,0,'\0','\0','\0','\0','\0','\0');

--
-- Table structure for table `cw_script_2_individual_field`
--

CREATE TABLE `cw_script_2_individual_field` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `format` varchar(255) NOT NULL,
  `individual_field_data_type_enum` varchar(255) NOT NULL,
  `initial_code1` varchar(8000) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `position` int(11) NOT NULL,
  `script_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKr7sly4updmpc19jiu1gy7dnqh` (`script_id`),
  CONSTRAINT `FKr7sly4updmpc19jiu1gy7dnqh` FOREIGN KEY (`script_id`) REFERENCES `cw_script` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_script_2_individual_field`
--


--
-- Table structure for table `cw_seccor_2_door_access_schedule`
--

CREATE TABLE `cw_seccor_2_door_access_schedule` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `door_access_schedule_id` bigint(20) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `terminal_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKfb2395vuvhmupn4mcdyk6mv91` (`door_access_schedule_id`),
  KEY `FK2h0qq6qd7o7l2olh9rckeq759` (`terminal_id`),
  CONSTRAINT `FK2h0qq6qd7o7l2olh9rckeq759` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKfb2395vuvhmupn4mcdyk6mv91` FOREIGN KEY (`door_access_schedule_id`) REFERENCES `cw_seccor_door_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_2_door_access_schedule`
--


--
-- Table structure for table `cw_seccor_additional_person_authorisation_type`
--

CREATE TABLE `cw_seccor_additional_person_authorisation_type` (
  `id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_additional_person_authorisation_type`
--

INSERT INTO `cw_seccor_additional_person_authorisation_type` VALUES
(5),
(6),
(7),
(8),
(9),
(10),
(11);

--
-- Table structure for table `cw_seccor_door_access_schedule`
--

CREATE TABLE `cw_seccor_door_access_schedule` (
  `id` bigint(20) NOT NULL,
  `friday_seccor_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `monday_seccor_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `saturday_seccor_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `seccor_door_access_schedule_enum` varchar(255) NOT NULL,
  `sunday_seccor_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `thursday_seccor_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `tuesday_seccor_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `wednesday_seccor_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKk7k026y2ye7ef6di8bkpjwrx4` (`friday_seccor_door_day_access_schedule_id`),
  KEY `FKet6dyglu5lqw0th3gfe3jfiu7` (`monday_seccor_door_day_access_schedule_id`),
  KEY `FKvw9npteva3tvcjh5edky1had` (`saturday_seccor_door_day_access_schedule_id`),
  KEY `FKa7ml3tbp4xfx0t5w0kvt9o161` (`sunday_seccor_door_day_access_schedule_id`),
  KEY `FKi3n4itkiughg1hdsehktger14` (`thursday_seccor_door_day_access_schedule_id`),
  KEY `FKid7lbfs2nil0s8ahj2gveg5ts` (`tuesday_seccor_door_day_access_schedule_id`),
  KEY `FKnvn7104v8e8qo12nhmr55q462` (`wednesday_seccor_door_day_access_schedule_id`),
  CONSTRAINT `FKa7ml3tbp4xfx0t5w0kvt9o161` FOREIGN KEY (`sunday_seccor_door_day_access_schedule_id`) REFERENCES `cw_seccor_door_day_access_schedule` (`id`),
  CONSTRAINT `FKet6dyglu5lqw0th3gfe3jfiu7` FOREIGN KEY (`monday_seccor_door_day_access_schedule_id`) REFERENCES `cw_seccor_door_day_access_schedule` (`id`),
  CONSTRAINT `FKi3n4itkiughg1hdsehktger14` FOREIGN KEY (`thursday_seccor_door_day_access_schedule_id`) REFERENCES `cw_seccor_door_day_access_schedule` (`id`),
  CONSTRAINT `FKid7lbfs2nil0s8ahj2gveg5ts` FOREIGN KEY (`tuesday_seccor_door_day_access_schedule_id`) REFERENCES `cw_seccor_door_day_access_schedule` (`id`),
  CONSTRAINT `FKk7k026y2ye7ef6di8bkpjwrx4` FOREIGN KEY (`friday_seccor_door_day_access_schedule_id`) REFERENCES `cw_seccor_door_day_access_schedule` (`id`),
  CONSTRAINT `FKnvn7104v8e8qo12nhmr55q462` FOREIGN KEY (`wednesday_seccor_door_day_access_schedule_id`) REFERENCES `cw_seccor_door_day_access_schedule` (`id`),
  CONSTRAINT `FKvw9npteva3tvcjh5edky1had` FOREIGN KEY (`saturday_seccor_door_day_access_schedule_id`) REFERENCES `cw_seccor_door_day_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_door_access_schedule`
--


--
-- Table structure for table `cw_seccor_door_day_access_schedule`
--

CREATE TABLE `cw_seccor_door_day_access_schedule` (
  `id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_door_day_access_schedule`
--


--
-- Table structure for table `cw_seccor_door_day_access_schedule_2_detail`
--

CREATE TABLE `cw_seccor_door_day_access_schedule_2_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_time` int(11) NOT NULL,
  `last_updated` datetime NOT NULL,
  `seccor_door_day_access_schedule_id` bigint(20) NOT NULL,
  `start_time` int(11) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK82gd0vmlu2s6cgtqk6p0f6q6b` (`seccor_door_day_access_schedule_id`),
  CONSTRAINT `FK82gd0vmlu2s6cgtqk6p0f6q6b` FOREIGN KEY (`seccor_door_day_access_schedule_id`) REFERENCES `cw_seccor_door_day_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_door_day_access_schedule_2_detail`
--


--
-- Table structure for table `cw_seccor_person_access_authorisation`
--

CREATE TABLE `cw_seccor_person_access_authorisation` (
  `id` bigint(20) NOT NULL,
  `additional_person_authorisation_type_id` bigint(20) DEFAULT NULL,
  `person_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKslpllsvycrletgaa6p1pt84f1` (`additional_person_authorisation_type_id`),
  KEY `FK4uotgq4suyarh1cs3mh8manvx` (`person_access_schedule_id`),
  CONSTRAINT `FK4uotgq4suyarh1cs3mh8manvx` FOREIGN KEY (`person_access_schedule_id`) REFERENCES `cw_seccor_person_access_schedule` (`id`),
  CONSTRAINT `FKslpllsvycrletgaa6p1pt84f1` FOREIGN KEY (`additional_person_authorisation_type_id`) REFERENCES `cw_seccor_additional_person_authorisation_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_person_access_authorisation`
--


--
-- Table structure for table `cw_seccor_person_access_schedule`
--

CREATE TABLE `cw_seccor_person_access_schedule` (
  `id` bigint(20) NOT NULL,
  `friday_seccor_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `monday_seccor_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `saturday_seccor_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `seccor_person_access_schedule_enum` varchar(255) NOT NULL,
  `sunday_seccor_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `thursday_seccor_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `tuesday_seccor_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `wednesday_seccor_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKg6lvyjfy2r3b48ofh03ylduvk` (`friday_seccor_person_day_access_schedule_id`),
  KEY `FK3f2qd88vqthkjwb60fe8msvji` (`monday_seccor_person_day_access_schedule_id`),
  KEY `FK7eic2jp30smjpi1ocwich7x05` (`saturday_seccor_person_day_access_schedule_id`),
  KEY `FKpcfc0cajeujg96cpiueye5snw` (`sunday_seccor_person_day_access_schedule_id`),
  KEY `FKe0pygt86gwqn9d2j7d6km7n14` (`thursday_seccor_person_day_access_schedule_id`),
  KEY `FKcr1jd9615h6ttfmna4gujl91o` (`tuesday_seccor_person_day_access_schedule_id`),
  KEY `FKiii0s9f0mkxahl2rc51l87pdw` (`wednesday_seccor_person_day_access_schedule_id`),
  CONSTRAINT `FK3f2qd88vqthkjwb60fe8msvji` FOREIGN KEY (`monday_seccor_person_day_access_schedule_id`) REFERENCES `cw_seccor_person_day_access_schedule` (`id`),
  CONSTRAINT `FK7eic2jp30smjpi1ocwich7x05` FOREIGN KEY (`saturday_seccor_person_day_access_schedule_id`) REFERENCES `cw_seccor_person_day_access_schedule` (`id`),
  CONSTRAINT `FKcr1jd9615h6ttfmna4gujl91o` FOREIGN KEY (`tuesday_seccor_person_day_access_schedule_id`) REFERENCES `cw_seccor_person_day_access_schedule` (`id`),
  CONSTRAINT `FKe0pygt86gwqn9d2j7d6km7n14` FOREIGN KEY (`thursday_seccor_person_day_access_schedule_id`) REFERENCES `cw_seccor_person_day_access_schedule` (`id`),
  CONSTRAINT `FKg6lvyjfy2r3b48ofh03ylduvk` FOREIGN KEY (`friday_seccor_person_day_access_schedule_id`) REFERENCES `cw_seccor_person_day_access_schedule` (`id`),
  CONSTRAINT `FKiii0s9f0mkxahl2rc51l87pdw` FOREIGN KEY (`wednesday_seccor_person_day_access_schedule_id`) REFERENCES `cw_seccor_person_day_access_schedule` (`id`),
  CONSTRAINT `FKpcfc0cajeujg96cpiueye5snw` FOREIGN KEY (`sunday_seccor_person_day_access_schedule_id`) REFERENCES `cw_seccor_person_day_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_person_access_schedule`
--

INSERT INTO `cw_seccor_person_access_schedule` VALUES
(5,NULL,NULL,NULL,'GENERAL_ACCESS',NULL,NULL,NULL,NULL),
(10,NULL,NULL,NULL,'NO_ACCESS',NULL,NULL,NULL,NULL);

--
-- Table structure for table `cw_seccor_person_category_access_authorisation`
--

CREATE TABLE `cw_seccor_person_category_access_authorisation` (
  `id` bigint(20) NOT NULL,
  `additional_person_authorisation_type_id` bigint(20) DEFAULT NULL,
  `person_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgpn62l1qc5fyeoriuihqc3ylk` (`additional_person_authorisation_type_id`),
  KEY `FK5skjy2nhimjv3lrpqiqo4sx93` (`person_access_schedule_id`),
  CONSTRAINT `FK5skjy2nhimjv3lrpqiqo4sx93` FOREIGN KEY (`person_access_schedule_id`) REFERENCES `cw_seccor_person_access_schedule` (`id`),
  CONSTRAINT `FKgpn62l1qc5fyeoriuihqc3ylk` FOREIGN KEY (`additional_person_authorisation_type_id`) REFERENCES `cw_seccor_additional_person_authorisation_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_person_category_access_authorisation`
--


--
-- Table structure for table `cw_seccor_person_day_access_schedule`
--

CREATE TABLE `cw_seccor_person_day_access_schedule` (
  `id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_person_day_access_schedule`
--

INSERT INTO `cw_seccor_person_day_access_schedule` VALUES
(5);

--
-- Table structure for table `cw_seccor_person_day_access_schedule_2_detail`
--

CREATE TABLE `cw_seccor_person_day_access_schedule_2_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_time` int(11) NOT NULL,
  `last_updated` datetime NOT NULL,
  `seccor_person_day_access_schedule_id` bigint(20) NOT NULL,
  `start_time` int(11) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKqlv7dl1nee83ytqc3qkcpsi9j` (`seccor_person_day_access_schedule_id`),
  CONSTRAINT `FKqlv7dl1nee83ytqc3qkcpsi9j` FOREIGN KEY (`seccor_person_day_access_schedule_id`) REFERENCES `cw_seccor_person_day_access_schedule` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_seccor_person_day_access_schedule_2_detail`
--

INSERT INTO `cw_seccor_person_day_access_schedule_2_detail` VALUES
(1,0,'2023-02-08 23:57:19','\0',1439,'2023-02-08 23:57:19',5,0,0);

--
-- Table structure for table `cw_smtp`
--

CREATE TABLE `cw_smtp` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `auth` bit(1) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `from_email_address` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `port` int(11) NOT NULL,
  `priority` int(11) NOT NULL,
  `smtp_domain` varchar(255) DEFAULT NULL,
  `smtp_domain_enum` varchar(255) NOT NULL,
  `start_tls_enable` bit(1) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `user_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_smtp`
--

INSERT INTO `cw_smtp` VALUES
(1,0,'\0','2024-03-07 09:48:35','\0','all Domains','','','2024-03-07 09:48:35','all','',0,0,'','ALL_DOMAINS','\0',0,'');

--
-- Table structure for table `cw_sorex_person_access_authorisation`
--

CREATE TABLE `cw_sorex_person_access_authorisation` (
  `id` bigint(20) NOT NULL,
  `person_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKtlnxwirr6hmj9eska9dv9ivr5` (`person_access_schedule_id`),
  CONSTRAINT `FKtlnxwirr6hmj9eska9dv9ivr5` FOREIGN KEY (`person_access_schedule_id`) REFERENCES `cw_sorex_person_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sorex_person_access_authorisation`
--


--
-- Table structure for table `cw_sorex_person_access_schedule`
--

CREATE TABLE `cw_sorex_person_access_schedule` (
  `id` bigint(20) NOT NULL,
  `friday_sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `monday_sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `saturday_sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `sorex_person_access_schedule_enum` varchar(255) NOT NULL,
  `special_day1sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day2sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day3sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day4sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day5sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `sunday_sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `thursday_sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `tuesday_sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `wednesday_sorex_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKai1honbcwnnj4mr7une0tn5bc` (`friday_sorex_person_day_access_schedule_id`),
  KEY `FKeijst9yawkxouh821rc889903` (`monday_sorex_person_day_access_schedule_id`),
  KEY `FKfrlf6ku4s51w2a7991ufgxjby` (`saturday_sorex_person_day_access_schedule_id`),
  KEY `FKrw387ceyolmhwik4oht4t5qhl` (`special_day1sorex_person_day_access_schedule_id`),
  KEY `FK3gjbeh7mk140p4hlhcxmg1egm` (`special_day2sorex_person_day_access_schedule_id`),
  KEY `FKd4c66facbv2esw3i2dtvfmn4h` (`special_day3sorex_person_day_access_schedule_id`),
  KEY `FK50oeoi9fd4w6pq82gtyydpwn9` (`special_day4sorex_person_day_access_schedule_id`),
  KEY `FKl8j9svbks4qmo83w7ty17v5gy` (`special_day5sorex_person_day_access_schedule_id`),
  KEY `FKh3vsv6jhr75tmcqmxmdis91tv` (`sunday_sorex_person_day_access_schedule_id`),
  KEY `FK6n1edufq7ddymkpws8mn4jncq` (`thursday_sorex_person_day_access_schedule_id`),
  KEY `FK2n5ao6wd9nc700d0k38hc3bq8` (`tuesday_sorex_person_day_access_schedule_id`),
  KEY `FKnetbsy0y7ovbn1nav6jqr1m5a` (`wednesday_sorex_person_day_access_schedule_id`),
  CONSTRAINT `FK2n5ao6wd9nc700d0k38hc3bq8` FOREIGN KEY (`tuesday_sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FK3gjbeh7mk140p4hlhcxmg1egm` FOREIGN KEY (`special_day2sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FK50oeoi9fd4w6pq82gtyydpwn9` FOREIGN KEY (`special_day4sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FK6n1edufq7ddymkpws8mn4jncq` FOREIGN KEY (`thursday_sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FKai1honbcwnnj4mr7une0tn5bc` FOREIGN KEY (`friday_sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FKd4c66facbv2esw3i2dtvfmn4h` FOREIGN KEY (`special_day3sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FKeijst9yawkxouh821rc889903` FOREIGN KEY (`monday_sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FKfrlf6ku4s51w2a7991ufgxjby` FOREIGN KEY (`saturday_sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FKh3vsv6jhr75tmcqmxmdis91tv` FOREIGN KEY (`sunday_sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FKl8j9svbks4qmo83w7ty17v5gy` FOREIGN KEY (`special_day5sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FKnetbsy0y7ovbn1nav6jqr1m5a` FOREIGN KEY (`wednesday_sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`),
  CONSTRAINT `FKrw387ceyolmhwik4oht4t5qhl` FOREIGN KEY (`special_day1sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sorex_person_access_schedule`
--


--
-- Table structure for table `cw_sorex_person_category_access_authorisation`
--

CREATE TABLE `cw_sorex_person_category_access_authorisation` (
  `id` bigint(20) NOT NULL,
  `person_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK702wxb7pau235oxqvqd6umddq` (`person_access_schedule_id`),
  CONSTRAINT `FK702wxb7pau235oxqvqd6umddq` FOREIGN KEY (`person_access_schedule_id`) REFERENCES `cw_sorex_person_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sorex_person_category_access_authorisation`
--


--
-- Table structure for table `cw_sorex_person_day_access_schedule`
--

CREATE TABLE `cw_sorex_person_day_access_schedule` (
  `id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sorex_person_day_access_schedule`
--


--
-- Table structure for table `cw_sorex_person_day_access_schedule_2_detail`
--

CREATE TABLE `cw_sorex_person_day_access_schedule_2_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_time` int(11) NOT NULL,
  `last_updated` datetime NOT NULL,
  `sorex_person_day_access_schedule_id` bigint(20) NOT NULL,
  `start_time` int(11) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKiddmkrjql1fqjvqqpjmmrv4po` (`sorex_person_day_access_schedule_id`),
  CONSTRAINT `FKiddmkrjql1fqjvqqpjmmrv4po` FOREIGN KEY (`sorex_person_day_access_schedule_id`) REFERENCES `cw_sorex_person_day_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sorex_person_day_access_schedule_2_detail`
--


--
-- Table structure for table `cw_sort_definition`
--

CREATE TABLE `cw_sort_definition` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description_en` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sort_definition`
--

INSERT INTO `cw_sort_definition` VALUES
(1,1,'\0','Name, Personalnr','Name, PNr','Name, Personalnr'),
(2,1,'\0','Personalnr, Name','PNr, Name','Personalnr, Name'),
(3,2,'\0','Gruppe, Name, Personalnr','Gruppe, Name, PNr','Abteilung, Name, Personalnr'),
(4,2,'\0','Gruppe, Personalnr, Name','Gruppe, PNr, Name','Abteilung, Personalnr, Name'),
(5,1,'\0','Eintritt','Eintritt','Eintritt'),
(6,1,'\0','Geburtstag','Geburtstag','Geburtstag'),
(7,1,'\0','Eintritt MM/TT','Eintritt MM/TT','Eintritt MM/TT'),
(8,1,'\0','Geburtstag MM/TT','Geburtstag MM/TT','Geburtstag MM/TT'),
(9,1,'\0','Buchungsdatum','Buchungsdatum','Buchungsdatum'),
(10,1,'\0','Ereignisdatum','Ereignisdatum',NULL),
(11,0,'\0','Gruppe, Ereignisdatum','Gruppe, Ereignisdatum','');

--
-- Table structure for table `cw_sort_definition_detail`
--

CREATE TABLE `cw_sort_definition_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `deleted` bit(1) NOT NULL,
  `position` int(11) NOT NULL,
  `sort_definition_id` bigint(20) NOT NULL,
  `sort_expression` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKmsbyxcc0s1di7on0sc8keiea2` (`sort_definition_id`),
  CONSTRAINT `FKmsbyxcc0s1di7on0sc8keiea2` FOREIGN KEY (`sort_definition_id`) REFERENCES `cw_sort_definition` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_sort_definition_detail`
--

INSERT INTO `cw_sort_definition_detail` VALUES
(1,0,'\0',10,1,'person..surname'),
(2,0,'\0',20,1,'person..firstname'),
(3,0,'\0',30,1,'person..number'),
(4,0,'\0',10,2,'person..number'),
(5,0,'\0',20,2,'person..surname'),
(6,0,'\0',30,2,'person..firstname'),
(7,1,'\0',10,3,'person..personCategories..personCategoryType=$firstTimePersonCategory..description'),
(8,0,'\0',20,3,'person..surname'),
(9,0,'\0',30,3,'person..firstname'),
(10,0,'\0',40,3,'person..number'),
(11,1,'\0',10,4,'person..personCategories..personCategoryType=$firstTimePersonCategory..description'),
(12,0,'\0',20,4,'person..number'),
(13,0,'\0',30,4,'person..surname'),
(14,0,'\0',40,4,'person..firstname'),
(15,0,'\0',10,5,'person..dateOfEntry'),
(16,0,'\0',10,6,'person..dateOfBirth'),
(17,0,'\0',10,7,'class TService { static transactional = false; int run(def a, def b, Map rM) { (a.person.dateOfEntry?.getMonth()?:0)*100+(a.person.dateOfEntry?.getDate()?:0) <=> (b.person.dateOfEntry?.getMonth()?:0)*100+(b.person.dateOfEntry?.getDate()?:0) } }'),
(18,0,'\0',10,8,'class TService { static transactional = false; int run(def a, def b, Map rM) { (a.person.dateOfBirth?.getMonth()?:0)*100+(a.person.dateOfBirth?.getDate()?:0) <=> (b.person.dateOfBirth?.getMonth()?:0)*100+(b.person.dateOfBirth?.getDate()?:0) } }'),
(19,0,'\0',10,9,'booking..date'),
(20,0,'\0',10,10,'class TService { static transactional = false; int run(def a, def b, Map rM) { a.date <=> b.date } }'),
(21,0,'\0',20,11,'class TService { static transactional = false; int run(def a, def b, Map rM) { a.date <=> b.date } }'),
(22,0,'\0',10,11,'person..personCategories..personCategoryType=$firstAccessPersonCategory..description');

--
-- Table structure for table `cw_state_event`
--

CREATE TABLE `cw_state_event` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `data` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `kartennummer` varchar(255) DEFAULT NULL,
  `kartenversion` int(11) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKhb7hcm9t5gwhenoo25tok05og` (`terminal_id`),
  CONSTRAINT `FKhb7hcm9t5gwhenoo25tok05og` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_state_event`
--


--
-- Table structure for table `cw_state_event_cw_door_state`
--

CREATE TABLE `cw_state_event_cw_door_state` (
  `state_event_door_states_id` bigint(20) NOT NULL,
  `door_state_id` bigint(20) DEFAULT NULL,
  KEY `FK4iohomv7htoei325qtdbpb05p` (`door_state_id`),
  KEY `FKpivr3dccu41px44qwvkjtiqmq` (`state_event_door_states_id`),
  CONSTRAINT `FK4iohomv7htoei325qtdbpb05p` FOREIGN KEY (`door_state_id`) REFERENCES `cw_door_state` (`id`),
  CONSTRAINT `FKpivr3dccu41px44qwvkjtiqmq` FOREIGN KEY (`state_event_door_states_id`) REFERENCES `cw_state_event` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_state_event_cw_door_state`
--


--
-- Table structure for table `cw_synchronisation_area`
--

CREATE TABLE `cw_synchronisation_area` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `reset_type_enum` varchar(255) DEFAULT NULL,
  `trigger_going_booking` bit(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_synchronisation_area`
--


--
-- Table structure for table `cw_system_configuration`
--

CREATE TABLE `cw_system_configuration` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `boolean_value` bit(1) DEFAULT NULL,
  `cwid` int(11) NOT NULL,
  `date_created` datetime NOT NULL,
  `date_value` datetime DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `int_value` int(11) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `str_value` varchar(255) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `rewritable_in_general_validation` bit(1) DEFAULT NULL,
  `class` varchar(255) NOT NULL,
  `general_validation_id` bigint(20) DEFAULT NULL,
  `double_value` double DEFAULT NULL,
  `pw_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKbdy332eask1ua5ss41o7t3rs8` (`general_validation_id`),
  CONSTRAINT `FKbdy332eask1ua5ss41o7t3rs8` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=667 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_system_configuration`
--

INSERT INTO `cw_system_configuration` VALUES
(1,0,'\0',1,'2018-02-07 00:36:35',NULL,'\0','PZE-Startdatum (d)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(2,1,'\0',2,'2018-02-07 00:36:35',NULL,'\0','PZE-Berechnung: Veränderung des Bis-Datums im Vergleich zu heute (i)',-1,'2018-02-07 17:21:06','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(3,0,'',4,'2018-02-07 00:36:35',NULL,'\0','PZE-Berechnung: Feiertagszeit zur Sollzeit rechnen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(4,0,'\0',5,'2018-02-07 00:36:35',NULL,'\0','PZE-Berechnung: Feiertagszeit zur hinterlegten Zeitart rechnen (i)',30,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(5,0,'',6,'2018-02-07 00:36:35',NULL,'\0','automatische Berechnung in der Planung (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(6,0,'\0',11,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 1',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(7,0,'\0',12,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 2',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(8,0,'\0',13,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 3',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(9,0,'\0',14,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 4',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(10,0,'\0',15,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 5',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(11,0,'\0',16,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 6',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(12,0,'\0',17,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 7',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(13,0,'\0',18,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 8',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(14,0,'\0',19,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 9',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(15,0,'\0',20,'2018-02-07 00:36:35',NULL,'\0','Kundeneinstellung 10',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(16,0,'\0',30,'2018-02-07 00:36:35',NULL,'\0','Tomcat Timout (i)',1800,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(17,0,'\0',31,'2018-02-07 00:36:35',NULL,'\0','clockWORK-Foxpro: ODBC-Kennung (c)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(18,0,'\0',32,'2018-02-07 00:36:35',NULL,'\0','clockWORK-Url (c)',NULL,'2018-02-07 00:36:35','http://localhost:8080/clockwork',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(19,0,'\0',33,'2018-02-07 00:36:35',NULL,'\0','Foxpro zeitbuch.dbf verwenden (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(20,0,'\0',34,'2018-02-07 00:36:35',NULL,'\0','Proxy-Hostname (c)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(21,0,'\0',35,'2018-02-07 00:36:35',NULL,'\0','Proxy-Port (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(22,1,'\0',36,'2018-02-07 00:36:35',NULL,'\0','Std.-ReplyTo-EMail-Address (c)',NULL,'2024-03-07 09:48:59','planung@clockwork.at',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(23,0,'\0',37,'2018-02-07 00:36:35',NULL,'\0','clockork Windowspfad (c)',NULL,'2018-02-07 00:36:35','c:\\clockw\\cw_zt',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(24,0,'\0',41,'2018-02-07 00:36:35',NULL,'\0','Zyklus: Events auslesen [ms] (i)',60000,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(25,0,'\0',42,'2018-02-07 00:36:35',NULL,'\0','Zyklus: Zustände abfragen [ms] (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(26,0,'\0',43,'2018-02-07 00:36:35',NULL,'\0','Zyklus: Daten aktualisieren [ms] (i)',60000,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(27,0,'\0',44,'2018-02-07 00:36:35',NULL,'\0','Foxpro zeitbuch.dbf für ViewPresenceAbsence NICHT verwenden (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(28,0,'\0',45,'2018-02-07 00:36:35',NULL,'\0','Zyklus: Custom Coding [ms] (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(29,0,'\0',53,'2018-02-07 00:36:35',NULL,'\0','execute synchronized clockwork-data-old (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(30,0,'\0',54,'2018-02-07 00:36:35',NULL,'\0','Sortierung in der Abwesenheitsplanung (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(31,0,'\0',61,'2018-02-07 00:36:35',NULL,'\0','TimeTimeTypeDefinition für Fehlzeitanfrage (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(32,1,'\0',62,'2018-02-07 00:36:35',NULL,'\0','TimeTimeTypeDefinition für Buchungsmaske (i)',1,'2018-02-07 17:21:34','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(33,0,'\0',63,'2018-02-07 00:36:35',NULL,'\0','TimeTimeTypeDefinition für Abwesenheitsplanung (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(34,1,'\0',64,'2018-02-07 00:36:35',NULL,'\0','TimeTimeTypeDefinition für Fehlzeiten der PersonTimeOverview (i)',4,'2018-02-07 17:21:47','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(35,0,'\0',66,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung: id für neue Abwesenheit (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(36,0,'\0',67,'2018-02-07 00:36:35',NULL,'\0','TimeTimeTypeDefinition für Planung (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(37,0,'\0',68,'2018-02-07 00:36:35',NULL,'\0','TimeTimeTypeDefinition für Werte ansehen (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(38,0,'\0',71,'2018-02-07 00:36:35',NULL,'\0','url for geocoding (c)',NULL,'2018-02-07 00:36:35','http://maps.googleapis.com',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(39,0,'\0',72,'2018-02-07 00:36:35',NULL,'\0','path for geocoding (c)',NULL,'2018-02-07 00:36:35','/maps/api/geocode/json',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(40,0,'\0',81,'2018-02-07 00:36:35',NULL,'\0','Kommen/Gehen alternierend (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(41,0,'\0',82,'2018-02-07 00:36:35',NULL,'\0','Kommen/Gehen alternierend: FG 1 (c)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(42,1,'\0',101,'2018-02-07 00:36:35',NULL,'\0','Projekte in Buchungen und Planung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(43,1,'\0',102,'2018-02-07 00:36:35',NULL,'\0','Aufträge in Buchungen und Planung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(44,1,'\0',103,'2018-02-07 00:36:35',NULL,'\0','Positionen (Auftrag) in Buchungen und Planung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(45,1,'\0',104,'2018-02-07 00:36:35',NULL,'\0','Kostenstellen in Buchungen und Planung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(46,1,'\0',105,'2018-02-07 00:36:35',NULL,'\0','Maschinen in Buchungen und Planung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(47,1,'\0',106,'2018-02-07 00:36:35',NULL,'\0','Arbeitsplätze in Buchungen und Planung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(48,1,'\0',107,'2018-02-07 00:36:35',NULL,'\0','Arbeitsgänge in Buchungen und Planung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(49,1,'\0',111,'2018-02-07 00:36:35',NULL,'\0','Projekte in Schichtplanung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(50,1,'\0',112,'2018-02-07 00:36:35',NULL,'\0','Aufträge in Schichtplanung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(51,1,'\0',113,'2018-02-07 00:36:35',NULL,'\0','Positionen (Auftrag) in Schichtplanung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(52,1,'\0',114,'2018-02-07 00:36:35',NULL,'\0','Kostenstellen in Schichtplanung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(53,1,'\0',115,'2018-02-07 00:36:35',NULL,'\0','Maschinen in Schichtplanung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(54,1,'\0',116,'2018-02-07 00:36:35',NULL,'\0','Arbeitsplätze in Schichtplanung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(55,1,'\0',117,'2018-02-07 00:36:35',NULL,'\0','Arbeitsgänge in Schichtplanung anzeigen (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(56,0,'\0',121,'2018-02-07 00:36:35',NULL,'\0','AutoComplete bei Projekte (i: 0=NO_RELOAD, 1=RELOAD_FROM_GENERAL_VALIDATION, 2=RELOAD_FROM_IDS, 3=RELOAD_FROM_DATABASE',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(57,0,'\0',122,'2018-02-07 00:36:35',NULL,'\0','AutoComplete bei Aufträge (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(58,0,'\0',123,'2018-02-07 00:36:35',NULL,'\0','AutoComplete bei Positionen (Auftrag) (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(59,0,'\0',124,'2018-02-07 00:36:35',NULL,'\0','AutoComplete bei Kostenstellen (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(60,0,'\0',125,'2018-02-07 00:36:35',NULL,'\0','AutoComplete bei Maschinen (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(61,0,'\0',126,'2018-02-07 00:36:35',NULL,'\0','AutoComplete bei Arbeitsplätze (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(62,0,'\0',127,'2018-02-07 00:36:35',NULL,'\0','AutoComplete bei Arbeitsgänge (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(63,0,'',131,'2018-02-07 00:36:35',NULL,'\0','Projekte an Web-Client uebertragen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(64,0,'',132,'2018-02-07 00:36:35',NULL,'\0','Aufträge an Web-Client uebertragen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(65,0,'',133,'2018-02-07 00:36:35',NULL,'\0','Positionen (Auftrag) an Web-Client uebertragen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(66,0,'',134,'2018-02-07 00:36:35',NULL,'\0','Kostenstellen an Web-Client uebertragen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(67,0,'',135,'2018-02-07 00:36:35',NULL,'\0','Maschinen an Web-Client uebertragen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(68,0,'',136,'2018-02-07 00:36:35',NULL,'\0','Arbeitsplätze an Web-Client uebertragen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(69,0,'',137,'2018-02-07 00:36:35',NULL,'\0','Arbeitsgänge an Web-Client uebertragen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(70,0,'',141,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung am Montag (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(71,0,'',142,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung am Dienstag (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(72,0,'',143,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung am Mittwoch (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(73,0,'',144,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung am Donnerstag (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(74,0,'',145,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung am Freitag (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(75,0,'\0',146,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung am Samstag (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(76,0,'\0',147,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung am Sonntag (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(77,0,'\0',148,'2018-02-07 00:36:35',NULL,'\0','Abwesenheitsplanung am Feiertag (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(78,0,'',150,'2018-02-07 00:36:35',NULL,'\0','Kommentar wird in der Buchungsmaske angezeigt (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(79,0,'\0',151,'2018-02-07 00:36:35',NULL,'\0','Kommentar ist bei bewilligungspflichtigen Buchungen notwendig (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(80,0,'\0',152,'2018-02-07 00:36:35',NULL,'\0','Zeitbuchung: Anzahl Tage ohne Workflow (i)',0,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(81,0,'\0',153,'2018-02-07 00:36:35',NULL,'\0','Anzahl Tage für Buchungen (i)',10,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(86,0,'',171,'2018-02-07 00:36:35',NULL,'\0','booking/absenceplanning: showPersonDateOfEntry (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(87,0,'',172,'2018-02-07 00:36:35',NULL,'\0','booking: showPersonDateOfClose (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(88,0,'',173,'2018-02-07 00:36:35',NULL,'\0','booking: showPersonCalculated (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(89,1,'\0',174,'2018-02-07 00:36:35',NULL,'\0','booking: show terminalInfo: 0=none, 1=number, 2=desc, 3=number+desc (i)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(90,0,'\0',175,'2018-02-07 00:36:35',NULL,'\0','booking: show Workflow column (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(91,1,'\0',176,'2018-02-07 00:36:35',NULL,'\0','booking: show calculated too soon / too late columns (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(92,1,'\0',177,'2018-02-07 00:36:35',NULL,'\0','booking: show virtualTimeTimeModel column (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(93,2,'\0',181,'2018-02-07 00:36:35',NULL,'\0','validation-time: show validation-error, if no booking and no absence-planning exists today (b)',NULL,'2024-07-14 18:32:04',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(94,1,'\0',182,'2018-02-07 00:36:35',NULL,'\0','validation-time: days across working hours (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(95,0,'\0',191,'2018-02-07 00:36:35',NULL,'\0','TimeSpezification bei Zeitbuchung erfassen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(96,0,'\0',192,'2018-02-07 00:36:35',NULL,'\0','TimeSpezification bei Auftragsbuchung erfassen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(97,0,'\0',193,'2018-02-07 00:36:35',NULL,'\0','TimeSpezification bei Auftragszeit erfassen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(98,0,'\0',194,'2018-02-07 00:36:35',NULL,'\0','TimeSpezification in Zeitbuchungen/Auftragsbuchungen anzeigen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(99,0,'\0',195,'2018-02-07 00:36:35',NULL,'\0','TimeSpezification in Auftragszeiten anzeigen (b)',NULL,'2018-02-07 00:36:35',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(100,0,'\0',201,'2018-02-07 00:36:36',NULL,'\0','clockwork Mobile Url (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(101,0,'\0',202,'2018-02-07 00:36:36',NULL,'\0','Lizenznumber (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(102,0,'\0',203,'2018-02-07 00:36:36',NULL,'\0','clockwork Mobile Url V3 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(103,0,'\0',210,'2018-02-07 00:36:36',NULL,'\0','direct booking: automatic saving (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(104,0,'\0',211,'2018-02-07 00:36:36',NULL,'\0','direct booking: alternative coming and going (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(105,0,'\0',212,'2018-02-07 00:36:36',NULL,'\0','direct booking: alternative coming and going: first booking of day is a coming-booking (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(106,0,'\0',213,'2018-02-07 00:36:36',NULL,'\0','direct booking: show right direct bookings in menu (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(107,1,'\0',214,'2018-02-07 00:36:36',NULL,'\0','direct booking: absenceId (i)',0,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(108,0,'\0',231,'2018-02-07 00:36:36',NULL,'\0','visual presence/absence: absent, if no coming-booking today (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(109,0,'\0',251,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: keepAlivePeriod (i)',30,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(110,0,'\0',252,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: numberOfBeepsInOK (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(111,0,'\0',253,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: numberOfShowingScreenInOK (i)',2,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(112,0,'\0',254,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: numberOfShowingScreenInBalances (i)',10,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(113,0,'\0',255,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: numberOfShowingScreenInTables (i)',10,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(114,0,'\0',256,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: numberOfBeepsInError (i)',2,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(115,0,'\0',257,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: numberOfShowingScreenInError (i)',5,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(116,0,'\0',258,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: alternateBookingType (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(117,0,'\0',259,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: firstBookingOfDayMustBeAComing (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(118,0,'\0',260,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: nextBookingAfterMinutesMustBeAComing (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(119,0,'\0',261,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: allowDoubleBookingTypeByRepeatedBookingWithinSeconds (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(120,0,'\0',262,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: show balances at every booking (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(121,0,'\0',263,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: add new identification (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(122,0,'\0',264,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: automaticBookingType (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(123,0,'\0',265,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: numberOfSecondsIgnoringNextBooking (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(124,0,'\0',266,'2018-02-07 00:36:36',NULL,'\0','Supertrax Lite: show personnumber (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(125,0,'\0',300,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: General Validation (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(126,0,'\0',301,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Kommen (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(127,0,'\0',302,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Gehen (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(128,0,'\0',311,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Pausenbeginn (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(129,0,'\0',312,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Pausenende (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(130,0,'\0',313,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Pausenfehlzeit (absence.id) (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(131,0,'\0',303,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Kommen mit Fehlgrund (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(132,0,'\0',304,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Gehen mit Fehlgrund (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(133,0,'\0',305,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Salden (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(134,0,'\0',306,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Anwesenheitsliste (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(135,0,'\0',307,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Abwesenheitsliste (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(136,0,'\0',308,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: An-/Abwesenheitsliste (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(137,0,'\0',321,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Projekte (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(138,0,'\0',322,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Aufträge (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(139,0,'\0',323,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Positionen (Auftrag) (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(140,0,'\0',324,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Kostenstellen (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(141,0,'\0',325,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Maschinen (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(142,0,'\0',326,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Arbeitsplätze (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(143,0,'\0',327,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Arbeitsgänge (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(144,0,'\0',351,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Datenträger einlernen (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(145,0,'\0',352,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Sonstiges (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(146,0,'\0',391,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Summe der anwesenden Personen anzeigen (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(147,0,'\0',392,'2018-02-07 00:36:36',NULL,'\0','Booking via Terminal: Info über Kommen-/Gehen-Rhytmus (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(148,0,'\0',401,'2018-02-07 00:36:36',NULL,'\0','Saldo per (c)',NULL,'2018-02-07 00:36:36','Saldo per',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(149,1,'\0',402,'2018-02-07 00:36:36',NULL,'\0','Saldo 1 (c)',0,'2018-02-07 17:19:30','Guthaben',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(150,1,'\0',403,'2018-02-07 00:36:36',NULL,'\0','Saldo 2 (c)',0,'2018-02-07 17:19:36','Urlaub',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(151,1,'\0',404,'2018-02-07 00:36:36',NULL,'\0','Saldo 3 (c)',0,'2018-02-07 17:19:40','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(152,1,'\0',405,'2018-02-07 00:36:36',NULL,'\0','Saldo 4 (c)',0,'2018-02-07 17:19:42','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(153,1,'\0',406,'2018-02-07 00:36:36',NULL,'\0','Saldo 5 (c)',0,'2018-02-07 17:19:45','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(154,1,'\0',407,'2018-02-07 00:36:36',NULL,'\0','Saldo 6 (c)',0,'2018-02-07 17:19:47','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(155,1,'\0',408,'2018-02-07 00:36:36',NULL,'\0','Saldo 7 (c)',0,'2018-02-07 17:19:50','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(156,1,'\0',409,'2018-02-07 00:36:36',NULL,'\0','Saldo 8 (c)',0,'2018-02-07 17:19:52','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(157,1,'\0',410,'2018-02-07 00:36:36',NULL,'\0','Saldo 9 (c)',0,'2018-02-07 17:19:55','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(158,1,'\0',411,'2018-02-07 00:36:36',NULL,'\0','Saldo 10 (c)',0,'2018-02-07 17:19:58','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(159,1,'\0',422,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 1 (c)',0,'2018-02-07 17:20:05','S9',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(160,1,'\0',423,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 2 (c)',0,'2018-02-07 17:20:09','S40',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(161,0,'\0',424,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 3 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(162,0,'\0',425,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 4 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(163,0,'\0',426,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 5 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(164,0,'\0',427,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 6 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(165,0,'\0',428,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 7 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(166,0,'\0',429,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 8 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(167,0,'\0',430,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 9 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(168,0,'\0',431,'2018-02-07 00:36:36',NULL,'\0','Saldo-Berechnung 10 (c)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(169,0,'\0',442,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 1 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(170,0,'\0',443,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 2 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(171,0,'\0',444,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 3 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(172,0,'\0',445,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 4 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(173,0,'\0',446,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 5 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(174,0,'\0',447,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 6 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(175,0,'\0',448,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 7 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(176,0,'\0',449,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 8 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(177,0,'\0',450,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 9 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(178,0,'\0',451,'2018-02-07 00:36:36',NULL,'\0','Saldo-Format 10 (c)',NULL,'2018-02-07 00:36:36','HHMM',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(179,0,'\0',501,'2018-02-07 00:36:36',NULL,'\0','Report: delete Ident GoingAndComing-Bookings (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(180,0,'',511,'2018-02-07 00:36:36',NULL,'\0','Report: export to PDF (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(181,0,'',512,'2018-02-07 00:36:36',NULL,'\0','Report: export to EXCEL (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(182,0,'',513,'2018-02-07 00:36:36',NULL,'\0','Report: export to HTML (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(183,1,'\0',601,'2018-02-07 00:36:36',NULL,'\0','View Presence / Absence: Anzahl Spalten (i)',5,'2018-05-22 11:22:40',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(184,1,'\0',602,'2018-02-07 00:36:36',NULL,'\0','View Presence / Absence: Refresh-Zyklus (i)',30,'2018-05-22 11:22:40',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(185,1,'',603,'2018-02-07 00:36:36',NULL,'\0','View Presence / Absence: Detailansicht (b)',NULL,'2018-05-22 11:22:40',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(186,1,'\0',604,'2018-02-07 00:36:36',NULL,'\0','View Presence / Absence: Anzahl Tage in Vergangenheit',5,'2018-05-22 11:22:40',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(187,1,'',611,'2018-02-07 00:36:36',NULL,'\0','View Presence / Absence: show column \'last bookingtime\' (b)',NULL,'2018-05-22 11:22:40',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(188,1,'',612,'2018-02-07 00:36:36',NULL,'\0','View Presence / Absence: show column \'absence\' (b)',NULL,'2018-05-22 11:22:40',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(189,0,'',621,'2018-02-07 00:36:36',NULL,'\0','View Presence / Absence: enable button \'select personCategory\' (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(190,0,'',622,'2018-02-07 00:36:36',NULL,'\0','View Presence / Absence: enable button \'show presence time\' (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(191,1,'\0',641,'2018-02-07 00:36:36',NULL,'\0','View Absenceplanning / ShiftPlanning: absence-color (c)',NULL,'2024-03-07 09:48:59','black',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(192,0,'\0',651,'2018-02-07 00:36:36',NULL,'\0','View DoorState: Anzahl Spalten (i)',1,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(193,0,'\0',652,'2018-02-07 00:36:36',NULL,'\0','View DoorState: Refresh-Zyklus (i)',30,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(194,1,'\0',661,'2018-02-07 00:36:36',NULL,'\0','Communication-Scheduler: Refresh-Zyklus (i)',30,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(195,0,'\0',671,'2018-02-07 00:36:36',NULL,'\0','gwt View Presence / Absence: Refresh-Zyklus [s] (i)',5,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(196,0,'\0',672,'2018-02-07 00:36:36',NULL,'\0','gwt Terminalbooking: reset presence/absence-state after x [min] (i)',60,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(197,2,'\0',702,'2018-02-07 00:36:36',NULL,'\0','default-schema in access-authorisation (i)',1,'2023-02-09 00:06:11','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,''),
(198,1,'',703,'2018-02-07 00:36:36',NULL,'\0','select automatically all data in access-authorisation (b)',0,'2019-05-22 12:53:24','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(199,0,'',799,'2018-02-07 00:36:36',NULL,'\0','initialize terminals (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(200,0,'\0',901,'2018-02-07 00:36:36',NULL,'\0','import persons: using mandator (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(201,0,'\0',902,'2018-02-07 00:36:36',NULL,'\0','import persons: using department (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(202,0,'\0',903,'2018-02-07 00:36:36',NULL,'\0','import persons: using costUnit (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(203,0,'\0',904,'2018-02-07 00:36:36',NULL,'\0','import persons: using foxpro-terminalgroup (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(204,0,'\0',905,'2018-02-07 00:36:36',NULL,'\0','import persons: using mandator in teammember (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(205,0,'\0',906,'2018-02-07 00:36:36',NULL,'\0','import persons: using department in teammember (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(206,0,'\0',907,'2018-02-07 00:36:36',NULL,'\0','import persons: using costUnit in teammember (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(207,0,'\0',911,'2018-02-07 00:36:36',NULL,'\0','export persons: pct-mandator-id (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(208,0,'\0',912,'2018-02-07 00:36:36',NULL,'\0','export persons: pct-department-id (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(209,0,'\0',913,'2018-02-07 00:36:36',NULL,'\0','export persons: pct-costUnit-id (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(210,16,'',921,'2018-02-07 00:36:36',NULL,'\0','export bookings: export changed bookings (not only new bookings) (b)',NULL,'2025-03-24 00:42:28',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(211,0,'\0',1001,'2018-02-07 00:36:36',NULL,'\0','modified field-color (c)',NULL,'2018-02-07 00:36:36','lightcoral',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(212,0,'\0',1011,'2018-02-07 00:36:36',NULL,'\0','absencePlanning: workflow-color: added (c)',NULL,'2018-02-07 00:36:36','lightgreen',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(213,0,'\0',1012,'2018-02-07 00:36:36',NULL,'\0','absencePlanning: workflow-color: deleted (c)',NULL,'2018-02-07 00:36:36','lightcoral',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(214,0,'\0',1013,'2018-02-07 00:36:36',NULL,'\0','absencePlanning: workflow-color: changed (c)',NULL,'2018-02-07 00:36:36','orange',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(215,0,'\0',1021,'2018-02-07 00:36:36',NULL,'\0','booking: workflow-color: added (c)',NULL,'2018-02-07 00:36:36','lightgreen',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(216,0,'\0',1022,'2018-02-07 00:36:36',NULL,'\0','booking: workflow-color: deleted (c)',NULL,'2018-02-07 00:36:36','lightcoral',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(217,0,'\0',1023,'2018-02-07 00:36:36',NULL,'\0','booking: workflow-color: changed (c)',NULL,'2018-02-07 00:36:36','orange',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(218,0,'\0',1101,'2018-02-07 00:36:36',NULL,'\0','personPlanning and absencePlanning together allowed (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(219,0,'\0',1102,'2018-02-07 00:36:36',NULL,'\0','personPlanning and holiday together allowed (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(220,0,'\0',1111,'2018-02-07 00:36:36',NULL,'\0','planning: numberOfDays (i)',5,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(221,0,'\0',1112,'2018-02-07 00:36:36',NULL,'\0','planning: startTime (i)',0,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(222,0,'\0',1113,'2018-02-07 00:36:36',NULL,'\0','planning: startTime (i)',1440,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(223,0,'\0',1114,'2018-02-07 00:36:36',NULL,'\0','planning: minutesPerInterval (i)',30,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(224,0,'\0',1115,'2018-02-07 00:36:36',NULL,'\0','planning: pixelsPerInterval (i)',20,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(225,0,'',1201,'2018-02-07 00:36:36',NULL,'\0','Kantinenbuchungen am Montag (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(226,0,'',1202,'2018-02-07 00:36:36',NULL,'\0','Kantinenbuchungen am Dienstag (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(227,0,'',1203,'2018-02-07 00:36:36',NULL,'\0','Kantinenbuchungen am Mittwoch (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(228,0,'',1204,'2018-02-07 00:36:36',NULL,'\0','Kantinenbuchungen am Donnerstag (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(229,0,'',1205,'2018-02-07 00:36:36',NULL,'\0','Kantinenbuchungen am Freitag (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(230,0,'\0',1206,'2018-02-07 00:36:36',NULL,'\0','Kantinenbuchungen am Samstag (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(231,0,'\0',1207,'2018-02-07 00:36:36',NULL,'\0','Kantinenbuchungen am Sonntag (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(232,0,'\0',1211,'2018-02-07 00:36:36',NULL,'\0','max. Anzahl von Kantinenbuchungen pro Tag (i)',99,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(233,0,'\0',1212,'2018-02-07 00:36:36',NULL,'\0','max. Anzahl pro Artikel pro Tag (i)',1,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(234,0,'\0',1213,'2018-02-07 00:36:36',NULL,'\0','minimale Minuten vor Abholungsdatum (i)',720,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(235,0,'\0',1301,'2018-02-07 00:36:36',NULL,'\0','View Absence Overview: = bei Fehlgründen anzeigen, deren Zeit gleich der Sollzeit ist (b)',NULL,'2018-02-07 00:36:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(236,0,'\0',1401,'2018-02-07 00:36:37',NULL,'\0','Communication-Scheduler während Delete-Log-Communication beenden (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(237,0,'\0',2001,'2018-02-07 00:36:37',NULL,'\0','debug: log userIds (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(238,0,'\0',2002,'2018-02-07 00:36:37',NULL,'\0','debug: calculating (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(239,0,'\0',2003,'2018-02-07 00:36:37',NULL,'\0','debug: smtp (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(240,0,'\0',2004,'2018-02-07 00:36:37',NULL,'\0','debug: filter (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(241,0,'\0',2005,'2018-02-07 00:36:37',NULL,'\0','debug: controller (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(242,0,'',2006,'2018-02-07 00:36:37',NULL,'\0','debug: controller (online-terminals) (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(243,0,'\0',2007,'2018-02-07 00:36:37',NULL,'\0','debug: changedUserOperatorRole-controller (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(244,0,'\0',3001,'2018-02-07 00:36:37',NULL,'\0','smtp: host (c)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(245,0,'\0',3002,'2018-02-07 00:36:37',NULL,'\0','smtp: port (i)',0,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(246,0,'\0',3003,'2018-02-07 00:36:37',NULL,'\0','smtp: auth (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(247,0,'\0',3004,'2018-02-07 00:36:37',NULL,'\0','smtp: user (c)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(248,1,'\0',3005,'2018-02-07 00:36:37',NULL,'\0','smtp: password (pw)',NULL,'2024-03-07 09:48:59','',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(249,0,'\0',11001,'2018-02-07 00:36:37',NULL,'\0','terminalcommunication-warning (c)',NULL,'2018-02-07 00:36:37','orange',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(250,0,'\0',11002,'2018-02-07 00:36:37',NULL,'\0','terminalcommunication-error (c)',NULL,'2018-02-07 00:36:37','orangered',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(251,0,'\0',11003,'2018-02-07 00:36:37',NULL,'\0','terminalcommunication-fatalerror (c)',NULL,'2018-02-07 00:36:37','red',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(252,0,'\0',90001,'2018-02-07 00:36:37',NULL,'\0','Benutzerpasswort uebertragen (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(253,0,'\0',99002,'2018-02-07 00:36:37',NULL,'\0','view presence/absence: show open workflows (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(254,0,'\0',99003,'2018-02-07 00:36:37',NULL,'\0','planning: displaying for migrare (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(255,0,'\0',99004,'2018-02-07 00:36:37',NULL,'\0','use clockwork/home menu (b)',NULL,'2018-02-07 00:36:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(256,0,'',605,'2018-05-22 11:22:49',NULL,'\0','View Presence / Absence: zeige Uebersicht-Radiobutton (b)',NULL,'2018-05-22 11:22:49',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(257,0,'',606,'2018-05-22 11:22:49',NULL,'\0','View Presence / Absence: zeige Detail-Radiobutton (b)',NULL,'2018-05-22 11:22:49',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(258,0,'',607,'2018-05-22 11:22:49',NULL,'\0','View Presence / Absence: zeige Listbox fuer An- und Abwesenheiten (b)',NULL,'2018-05-22 11:22:49',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(259,0,'\0',662,'2018-05-22 11:22:49',NULL,'\0','Task-Scheduler: Refresh-Zyklus (i)',30,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(260,0,'\0',908,'2018-05-22 11:22:49',NULL,'\0','import persons: using timeplan (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(261,0,'',2008,'2018-05-22 11:22:49',NULL,'\0','debug: true=save calculating, false=verify the result (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(262,0,'\0',2009,'2018-05-22 11:22:49',NULL,'\0','debug: calculating absence overview (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(263,0,'\0',2010,'2018-05-22 11:22:49',NULL,'\0','debug: calculating pause overview (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(264,0,'\0',2011,'2018-05-22 11:22:49',NULL,'\0','debug: calculating absence detail (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(265,0,'\0',2012,'2018-05-22 11:22:49',NULL,'\0','debug: calculating pause detail (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(266,0,'\0',15001,'2018-05-22 11:22:49',NULL,'\0','Menü Personalzeit (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(267,0,'\0',15002,'2018-05-22 11:22:49',NULL,'\0','Menü Betriebsdatenerfassung (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(268,0,'\0',15003,'2018-05-22 11:22:49',NULL,'\0','Menü Salden (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(269,0,'\0',15004,'2018-05-22 11:22:49',NULL,'\0','Menü Synchronisierung (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(270,0,'\0',15005,'2018-05-22 11:22:49',NULL,'\0','Menü Konfiguration (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(271,0,'\0',15006,'2018-05-22 11:22:49',NULL,'\0','Menü Historie (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(272,0,'\0',15101,'2018-05-22 11:22:49',NULL,'\0','Verwendung von Projekten (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(273,0,'\0',15102,'2018-05-22 11:22:49',NULL,'\0','Verwendung von Aufträgen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(274,0,'\0',15103,'2018-05-22 11:22:49',NULL,'\0','Verwendung von Positionen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(275,0,'\0',15104,'2018-05-22 11:22:49',NULL,'\0','Verwendung von Kostenstellen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(276,0,'\0',15105,'2018-05-22 11:22:49',NULL,'\0','Verwendung von Maschinen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(277,0,'\0',15106,'2018-05-22 11:22:49',NULL,'\0','Verwendung von Arbeitsplatz (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(278,0,'\0',15107,'2018-05-22 11:22:49',NULL,'\0','Verwendung von Arbeitsgängen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(279,0,'\0',15111,'2018-05-22 11:22:49',NULL,'\0','Vorselektion von Projekten (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(280,0,'\0',15112,'2018-05-22 11:22:49',NULL,'\0','Vorselektion von Aufträgen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(281,0,'\0',15113,'2018-05-22 11:22:49',NULL,'\0','Vorselektion von Positionen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(282,0,'\0',15114,'2018-05-22 11:22:49',NULL,'\0','Vorselektion von Kostenstellen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(283,0,'\0',15115,'2018-05-22 11:22:49',NULL,'\0','Vorselektion von Maschinen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(284,0,'\0',15116,'2018-05-22 11:22:49',NULL,'\0','Vorselektion von Arbeitsplatz (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(285,0,'\0',15117,'2018-05-22 11:22:49',NULL,'\0','Vorselektion von Arbeitsgängen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(286,0,'\0',15121,'2018-05-22 11:22:49',NULL,'\0','Nummernanzeige von Projekten (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(287,0,'\0',15122,'2018-05-22 11:22:49',NULL,'\0','Nummernanzeige von Aufträgen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(288,0,'\0',15123,'2018-05-22 11:22:49',NULL,'\0','Nummernanzeige von Positionen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(289,0,'\0',15124,'2018-05-22 11:22:49',NULL,'\0','Nummernanzeige von Kostenstellen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(290,0,'\0',15125,'2018-05-22 11:22:49',NULL,'\0','Nummernanzeige von Maschinen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(291,0,'\0',15126,'2018-05-22 11:22:49',NULL,'\0','Nummernanzeige von Arbeitsplatz (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(292,0,'\0',15127,'2018-05-22 11:22:49',NULL,'\0','Nummernanzeige von Arbeitsgängen (b)',NULL,'2018-05-22 11:22:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(293,1,'\0',15401,'2018-05-22 11:22:49',NULL,'\0','Saldo per - de (c)',NULL,'2024-03-07 09:48:59','Saldo per',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(294,1,'\0',15402,'2018-05-22 11:22:49',NULL,'\0','Saldo 1 - de (c)',NULL,'2024-03-07 09:48:59','Saldo 1',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(295,1,'\0',15403,'2018-05-22 11:22:49',NULL,'\0','Saldo 2 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(296,1,'\0',15404,'2018-05-22 11:22:49',NULL,'\0','Saldo 3 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(297,1,'\0',15405,'2018-05-22 11:22:49',NULL,'\0','Saldo 4 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(298,1,'\0',15406,'2018-05-22 11:22:49',NULL,'\0','Saldo 5 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(299,1,'\0',15407,'2018-05-22 11:22:49',NULL,'\0','Saldo 6 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(300,1,'\0',15408,'2018-05-22 11:22:49',NULL,'\0','Saldo 7 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(301,1,'\0',15409,'2018-05-22 11:22:49',NULL,'\0','Saldo 8 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(302,1,'\0',15410,'2018-05-22 11:22:49',NULL,'\0','Saldo 9 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(303,1,'\0',15411,'2018-05-22 11:22:49',NULL,'\0','Saldo 10 - de (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(304,0,'\0',601,'2018-05-22 11:25:43',NULL,'\0','View Presence / Absence: Anzahl Spalten (i)',5,'2018-05-22 11:25:43',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(305,0,'\0',602,'2018-05-22 11:25:43',NULL,'\0','View Presence / Absence: Refresh-Zyklus (i)',30,'2018-05-22 11:25:43',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(306,0,'',603,'2018-05-22 11:25:44',NULL,'\0','View Presence / Absence: Detailansicht (b)',NULL,'2018-05-22 11:25:44',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(307,0,'\0',604,'2018-05-22 11:25:44',NULL,'\0','View Presence / Absence: Anzahl Tage in Vergangenheit',5,'2018-05-22 11:25:44',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(308,0,'',611,'2018-05-22 11:25:44',NULL,'\0','View Presence / Absence: show column \'last bookingtime\' (b)',NULL,'2018-05-22 11:25:44',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(309,0,'',612,'2018-05-22 11:25:45',NULL,'\0','View Presence / Absence: show column \'absence\' (b)',NULL,'2018-05-22 11:25:45',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(310,0,'',605,'2018-05-22 11:25:45',NULL,'\0','View Presence / Absence: zeige Uebersicht-Radiobutton (b)',NULL,'2018-05-22 11:25:45',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(311,0,'',606,'2018-05-22 11:25:45',NULL,'\0','View Presence / Absence: zeige Detail-Radiobutton (b)',NULL,'2018-05-22 11:25:45',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(312,0,'',607,'2018-05-22 11:25:45',NULL,'\0','View Presence / Absence: zeige Listbox fuer An- und Abwesenheiten (b)',NULL,'2018-05-22 11:25:45',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(313,0,'\0',204,'2018-08-28 10:52:01',NULL,'\0','clockwork Mobile Url V4 (c)',NULL,'2018-08-28 10:52:01',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(314,0,'\0',931,'2018-08-28 10:52:02',NULL,'\0','import users: default user-template (c)',NULL,'2018-08-28 10:52:02','template',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(315,0,'\0',932,'2018-08-28 10:52:02',NULL,'\0','import users: default password (c)',NULL,'2018-08-28 10:52:02','test',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(316,0,'',934,'2018-08-28 10:52:02',NULL,'\0','import users: default passwordExpired (b)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(317,1,'\0',1302,'2018-08-28 10:52:02',NULL,'\0','View Absence Overview: Abwesenheiten in der Zukunft berechnen 0=nein, 1=Soll von nähester Berechnung, 2=Neuberechnung',0,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(318,0,'\0',1303,'2018-08-28 10:52:02',NULL,'\0','View Absence Overview: default: past / future (b)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(319,0,'\0',1304,'2018-08-28 10:52:02',NULL,'\0','View Absence Overview: default: accepted / not accepted (b)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(320,0,'\0',1305,'2018-08-28 10:52:02',NULL,'\0','View Absence Overview: default: 0=count / 1=sum (i)',0,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(321,0,'\0',15000,'2018-08-28 10:52:02',NULL,'\0','Verwendung der OperationRoles (b)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(322,0,'\0',15007,'2018-08-28 10:52:02',NULL,'\0','Menü Spesenabrechnung (b)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(323,0,'\0',15131,'2018-08-28 10:52:02',NULL,'\0','Eingabetyp von Projekten 1=Liste, 2=manuelle Eingabe (i)',1,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(324,0,'\0',15132,'2018-08-28 10:52:02',NULL,'\0','Eingabetyp von Aufträgen (i)',1,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(325,0,'\0',15133,'2018-08-28 10:52:02',NULL,'\0','Eingabetyp von Positionen (i)',1,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(326,0,'\0',15134,'2018-08-28 10:52:02',NULL,'\0','Eingabetyp von Kostenstellen (i)',1,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(327,0,'\0',15135,'2018-08-28 10:52:02',NULL,'\0','Eingabetyp von Maschinen (i)',1,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(328,0,'\0',15136,'2018-08-28 10:52:02',NULL,'\0','Eingabetyp von Arbeitsplatz (i)',1,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(329,0,'\0',15137,'2018-08-28 10:52:02',NULL,'\0','Eingabetyp von Arbeitsgängen (i)',1,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(330,0,'\0',15421,'2018-08-28 10:52:02',NULL,'\0','Saldo per - en (c)',NULL,'2018-08-28 10:52:02','Saldo per',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(331,0,'\0',15422,'2018-08-28 10:52:02',NULL,'\0','Saldo 1 - en (c)',NULL,'2018-08-28 10:52:02','balance 1',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(332,0,'\0',15423,'2018-08-28 10:52:02',NULL,'\0','Saldo 2 - en (c)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(333,0,'\0',15424,'2018-08-28 10:52:02',NULL,'\0','Saldo 3 - en (c)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(334,0,'\0',15426,'2018-08-28 10:52:02',NULL,'\0','Saldo 5 - en (c)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(335,0,'\0',15427,'2018-08-28 10:52:02',NULL,'\0','Saldo 6 - en (c)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(336,0,'\0',15428,'2018-08-28 10:52:02',NULL,'\0','Saldo 7 - en (c)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(337,0,'\0',15429,'2018-08-28 10:52:02',NULL,'\0','Saldo 8 - en (c)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(338,0,'\0',15430,'2018-08-28 10:52:02',NULL,'\0','Saldo 9 - en (c)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(339,0,'\0',15431,'2018-08-28 10:52:02',NULL,'\0','Saldo 10 - en (c)',NULL,'2018-08-28 10:52:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(340,0,'\0',241,'2019-02-25 18:36:34',NULL,'\0','report: additional date (i)',0,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(341,0,'\0',521,'2019-02-25 18:36:34',NULL,'\0','Anzeige bei Projekte (i: 1=Nr u. Bez, 2=Nr, 3=Bez)',3,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(342,0,'\0',522,'2019-02-25 18:36:34',NULL,'\0','Anzeige bei Aufträge (i: 1=Nr u. Bez, 2=Nr, 3=Bez)',3,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(343,0,'\0',523,'2019-02-25 18:36:34',NULL,'\0','Anzeige bei Positionen (Auftrag) (i: 1=Nr u. Bez, 2=Nr, 3=Bez)',3,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(344,0,'\0',524,'2019-02-25 18:36:34',NULL,'\0','Anzeige bei Kostenstellen (i: 1=Nr u. Bez, 2=Nr, 3=Bez)',3,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(345,0,'\0',525,'2019-02-25 18:36:34',NULL,'\0','Anzeige bei Maschinen (i: 1=Nr u. Bez, 2=Nr, 3=Bez)',3,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(346,0,'\0',526,'2019-02-25 18:36:34',NULL,'\0','Anzeige bei Arbeitsplätze (i: 1=Nr u. Bez, 2=Nr, 3=Bez)',3,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(347,0,'\0',527,'2019-02-25 18:36:34',NULL,'\0','Anzeige bei Arbeitsgänge (i: 1=Nr u. Bez, 2=Nr, 3=Bez)',3,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(348,0,'\0',1501,'2019-02-25 18:36:34',NULL,'\0','Vorspann Projekt (i)',15,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(350,0,'\0',1503,'2019-02-25 18:36:34',NULL,'\0','Vorspann Positionen (Auftrag) (i)',51,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(351,0,'\0',1504,'2019-02-25 18:36:34',NULL,'\0','Vorspann Kostenstelle (i)',3,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(352,0,'\0',1505,'2019-02-25 18:36:34',NULL,'\0','Vorspann Maschine (i)',5,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(353,0,'\0',1506,'2019-02-25 18:36:34',NULL,'\0','Vorspann Arbeitsplatz (i)',4,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(354,0,'\0',1507,'2019-02-25 18:36:34',NULL,'\0','Vorspann Arbeitsgange (i)',6,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(355,0,'\0',1508,'2019-02-25 18:36:34',NULL,'\0','Vorspann Menge (i)',10,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(356,0,'\0',1511,'2019-02-25 18:36:34',NULL,'\0','Vorspann Buchungscode (i)',9,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(357,0,'\0',1512,'2019-02-25 18:36:34',NULL,'\0','Vorspann Person (i)',12,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(358,0,'\0',1513,'2019-02-25 18:36:34',NULL,'\0','Vorspann Artikel (i)',2,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(359,0,'\0',3006,'2019-02-25 18:36:34',NULL,'\0','smtp: starttls.enable (b)',NULL,'2019-02-25 18:36:34',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(360,0,'\0',7,'2019-05-22 11:16:56',NULL,'\0','automatisches Anlegen von TimePeriods in der Berechnung (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(361,0,'\0',551,'2019-05-22 11:16:56',NULL,'\0','Projekte in WorkTimeManual anzeigen (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(362,0,'\0',552,'2019-05-22 11:16:56',NULL,'\0','Aufträge in WorkTimeManual anzeigen (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(363,0,'\0',553,'2019-05-22 11:16:56',NULL,'\0','Positionen (Auftrag) in WorkTimeManual anzeigen (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(364,0,'\0',554,'2019-05-22 11:16:56',NULL,'\0','Kostenstellen in WorkTimeManual anzeigen (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(365,0,'\0',555,'2019-05-22 11:16:56',NULL,'\0','Maschinen in WorkTimeManual anzeigen (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(366,0,'\0',556,'2019-05-22 11:16:56',NULL,'\0','Arbeitsplätze in WorkTimeManual anzeigen (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(367,0,'\0',557,'2019-05-22 11:16:56',NULL,'\0','Arbeitsgänge in WorkTimeManual anzeigen (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(368,1,'\0',613,'2019-05-22 11:16:56',NULL,'\0','View Presence / Absence: show column \'booking.comment\' (b)',NULL,'2024-03-07 09:48:59',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(369,0,'\0',1502,'2019-05-22 11:16:56',NULL,'\0','Vorspann Auftrag (i)',1,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(370,0,'\0',15008,'2019-05-22 11:16:56',NULL,'\0','Menü Zeitdauer (b)',NULL,'2019-05-22 11:16:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(371,0,'\0',613,'2019-05-22 11:18:08',NULL,'\0','View Presence / booking.comment: show column \'booking.comment\' (b)',NULL,'2019-05-22 11:18:08',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(372,0,'\0',601,'2019-05-22 11:19:53',NULL,'\0','View Presence / Absence: Anzahl Spalten (i)',5,'2019-05-22 11:19:53',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(373,0,'\0',602,'2019-05-22 11:19:53',NULL,'\0','View Presence / Absence: Refresh-Zyklus (i)',30,'2019-05-22 11:19:53',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(374,0,'',603,'2019-05-22 11:19:54',NULL,'\0','View Presence / Absence: Detailansicht (b)',NULL,'2019-05-22 11:19:54',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(375,0,'\0',604,'2019-05-22 11:19:54',NULL,'\0','View Presence / Absence: Anzahl Tage in Vergangenheit',5,'2019-05-22 11:19:54',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(376,0,'',611,'2019-05-22 11:19:54',NULL,'\0','View Presence / Absence: show column \'last bookingtime\' (b)',NULL,'2019-05-22 11:19:54',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(377,0,'',612,'2019-05-22 11:19:54',NULL,'\0','View Presence / Absence: show column \'absence\' (b)',NULL,'2019-05-22 11:19:54',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(378,0,'',605,'2019-05-22 11:19:54',NULL,'\0','View Presence / Absence: zeige Uebersicht-Radiobutton (b)',NULL,'2019-05-22 11:19:54',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(379,0,'',606,'2019-05-22 11:19:54',NULL,'\0','View Presence / Absence: zeige Detail-Radiobutton (b)',NULL,'2019-05-22 11:19:54',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(380,0,'',607,'2019-05-22 11:19:54',NULL,'\0','View Presence / Absence: zeige Listbox fuer An- und Abwesenheiten (b)',NULL,'2019-05-22 11:19:54',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(381,0,'\0',613,'2019-05-22 11:19:54',NULL,'\0','View Presence / booking.comment: show column \'booking.comment\' (b)',NULL,'2019-05-22 11:19:54',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(382,0,'\0',601,'2019-05-22 11:20:12',NULL,'\0','View Presence / Absence: Anzahl Spalten (i)',5,'2019-05-22 11:20:12',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(383,0,'\0',602,'2019-05-22 11:20:12',NULL,'\0','View Presence / Absence: Refresh-Zyklus (i)',30,'2019-05-22 11:20:12',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(384,0,'',603,'2019-05-22 11:20:12',NULL,'\0','View Presence / Absence: Detailansicht (b)',NULL,'2019-05-22 11:20:12',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(385,0,'\0',604,'2019-05-22 11:20:12',NULL,'\0','View Presence / Absence: Anzahl Tage in Vergangenheit',5,'2019-05-22 11:20:12',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(386,0,'',611,'2019-05-22 11:20:12',NULL,'\0','View Presence / Absence: show column \'last bookingtime\' (b)',NULL,'2019-05-22 11:20:12',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(387,0,'',612,'2019-05-22 11:20:12',NULL,'\0','View Presence / Absence: show column \'absence\' (b)',NULL,'2019-05-22 11:20:12',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(388,0,'',605,'2019-05-22 11:20:12',NULL,'\0','View Presence / Absence: zeige Uebersicht-Radiobutton (b)',NULL,'2019-05-22 11:20:12',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(389,0,'',606,'2019-05-22 11:20:13',NULL,'\0','View Presence / Absence: zeige Detail-Radiobutton (b)',NULL,'2019-05-22 11:20:13',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(390,0,'',607,'2019-05-22 11:20:13',NULL,'\0','View Presence / Absence: zeige Listbox fuer An- und Abwesenheiten (b)',NULL,'2019-05-22 11:20:13',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(391,0,'\0',613,'2019-05-22 11:20:13',NULL,'\0','View Presence / booking.comment: show column \'booking.comment\' (b)',NULL,'2019-05-22 11:20:13',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(392,0,'\0',601,'2019-05-22 11:20:32',NULL,'\0','View Presence / Absence: Anzahl Spalten (i)',5,'2019-05-22 11:20:32',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(393,0,'\0',602,'2019-05-22 11:20:32',NULL,'\0','View Presence / Absence: Refresh-Zyklus (i)',30,'2019-05-22 11:20:32',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(394,0,'',603,'2019-05-22 11:20:32',NULL,'\0','View Presence / Absence: Detailansicht (b)',NULL,'2019-05-22 11:20:32',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(395,0,'\0',604,'2019-05-22 11:20:32',NULL,'\0','View Presence / Absence: Anzahl Tage in Vergangenheit',5,'2019-05-22 11:20:32',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(396,0,'',611,'2019-05-22 11:20:32',NULL,'\0','View Presence / Absence: show column \'last bookingtime\' (b)',NULL,'2019-05-22 11:20:32',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(397,0,'',612,'2019-05-22 11:20:33',NULL,'\0','View Presence / Absence: show column \'absence\' (b)',NULL,'2019-05-22 11:20:33',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(398,0,'',605,'2019-05-22 11:20:33',NULL,'\0','View Presence / Absence: zeige Uebersicht-Radiobutton (b)',NULL,'2019-05-22 11:20:33',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(399,0,'',606,'2019-05-22 11:20:33',NULL,'\0','View Presence / Absence: zeige Detail-Radiobutton (b)',NULL,'2019-05-22 11:20:33',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(400,0,'',607,'2019-05-22 11:20:33',NULL,'\0','View Presence / Absence: zeige Listbox fuer An- und Abwesenheiten (b)',NULL,'2019-05-22 11:20:33',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(401,0,'\0',613,'2019-05-22 11:20:33',NULL,'\0','View Presence / booking.comment: show column \'booking.comment\' (b)',NULL,'2019-05-22 11:20:33',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(402,0,'\0',601,'2019-05-22 12:52:39',NULL,'\0','View Presence / Absence: Anzahl Spalten (i)',5,'2019-05-22 12:52:39',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(403,0,'\0',602,'2019-05-22 12:52:39',NULL,'\0','View Presence / Absence: Refresh-Zyklus (i)',30,'2019-05-22 12:52:39',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(404,0,'',603,'2019-05-22 12:52:40',NULL,'\0','View Presence / Absence: Detailansicht (b)',NULL,'2019-05-22 12:52:40',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(405,0,'\0',604,'2019-05-22 12:52:40',NULL,'\0','View Presence / Absence: Anzahl Tage in Vergangenheit',5,'2019-05-22 12:52:40',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(406,0,'',611,'2019-05-22 12:52:40',NULL,'\0','View Presence / Absence: show column \'last bookingtime\' (b)',NULL,'2019-05-22 12:52:40',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(407,0,'',612,'2019-05-22 12:52:40',NULL,'\0','View Presence / Absence: show column \'absence\' (b)',NULL,'2019-05-22 12:52:40',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(408,0,'',605,'2019-05-22 12:52:40',NULL,'\0','View Presence / Absence: zeige Uebersicht-Radiobutton (b)',NULL,'2019-05-22 12:52:40',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(409,0,'',606,'2019-05-22 12:52:40',NULL,'\0','View Presence / Absence: zeige Detail-Radiobutton (b)',NULL,'2019-05-22 12:52:40',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(410,0,'',607,'2019-05-22 12:52:40',NULL,'\0','View Presence / Absence: zeige Listbox fuer An- und Abwesenheiten (b)',NULL,'2019-05-22 12:52:40',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(411,0,'\0',613,'2019-05-22 12:52:40',NULL,'\0','View Presence / booking.comment: show column \'booking.comment\' (b)',NULL,'2019-05-22 12:52:40',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(412,0,'\0',15141,'2019-05-27 10:55:36',NULL,'\0','Vorspann von Projekten (Barcode) (i)',2,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(413,0,'\0',15142,'2019-05-27 10:55:36',NULL,'\0','Vorspann von Aufträgen (Barcode) (i)',2,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(414,0,'\0',15143,'2019-05-27 10:55:36',NULL,'\0','Vorspann von Positionen (Barcode) (i)',2,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(415,0,'\0',15144,'2019-05-27 10:55:36',NULL,'\0','Vorspann von Kostenstellen (Barcode) (i)',2,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(416,0,'\0',15145,'2019-05-27 10:55:36',NULL,'\0','Vorspann von Maschinen (Barcode) (i)',2,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(417,0,'\0',15146,'2019-05-27 10:55:36',NULL,'\0','Vorspann von Arbeitsplatz (Barcode) (i)',2,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(418,0,'\0',15147,'2019-05-27 10:55:36',NULL,'\0','Vorspann von Arbeitsgängen (Barcode) (i)',2,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(419,0,'\0',15151,'2019-05-27 10:55:36',NULL,'\0','Checksumme von Projekten (Barcode) (i)',1,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(420,0,'\0',15152,'2019-05-27 10:55:36',NULL,'\0','Checksumme von Aufträgen (Barcode) (i)',1,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(421,0,'\0',15153,'2019-05-27 10:55:36',NULL,'\0','Checksumme von Positionen (Barcode) (i)',1,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(422,0,'\0',15154,'2019-05-27 10:55:36',NULL,'\0','Checksumme von Kostenstellen (Barcode) (i)',1,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(423,0,'\0',15155,'2019-05-27 10:55:36',NULL,'\0','Checksumme von Maschinen (Barcode) (i)',1,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(424,0,'\0',15156,'2019-05-27 10:55:36',NULL,'\0','Checksumme von Arbeitsplatz (Barcode) (i)',1,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(425,0,'\0',15157,'2019-05-27 10:55:36',NULL,'\0','Checksumme von Arbeitsgängen (Barcode) (i)',1,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(426,0,'\0',15301,'2019-05-27 10:55:36',NULL,'\0','Barcode Watchdog [sec] (i)',15,'2019-05-27 10:55:36',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(427,0,'\0',91,'2020-02-04 10:54:37',NULL,'\0','url for main-logo (c)',NULL,'2020-02-04 10:54:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(428,0,'\0',92,'2020-02-04 10:54:37',NULL,'\0','logo-width in pixel (i)',0,'2020-02-04 10:54:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(429,0,'\0',93,'2020-02-04 10:54:37',NULL,'\0','logo-height in pixel (i)',0,'2020-02-04 10:54:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(430,0,'\0',94,'2020-02-04 10:54:37',NULL,'\0','login-Body-Background-Style for login-form (c)',NULL,'2020-02-04 10:54:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(431,0,'\0',271,'2020-02-04 10:54:37',NULL,'\0','X1-Anzeige: 1=Name, 2=Name+1 Saldo, 3=2Salden (i)',1,'2020-02-04 10:54:37',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(432,0,'\0',272,'2020-02-04 10:54:37',NULL,'\0','X1-Anzeige: Saldo 1 (c)',NULL,'2020-02-04 10:54:37','S1',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(433,0,'\0',273,'2020-02-04 10:54:38',NULL,'\0','X1-Anzeige: Saldo 2 (c)',NULL,'2020-02-04 10:54:38','S2',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(434,0,'',642,'2020-02-04 10:54:38',NULL,'\0','ShiftPlanning: show timeTimeModel (b)',NULL,'2020-02-04 10:54:38',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(435,1,'\0',643,'2020-02-04 10:54:38',NULL,'\0','ShiftPlanning: show virtualTimeTimeModel (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(436,1,'\0',644,'2020-02-04 10:54:38',NULL,'\0','ShiftPlanning: show planTime (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(437,1,'\0',645,'2020-02-04 10:54:38',NULL,'\0','ShiftPlanning: show virtualPlanTime (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(438,1,'\0',681,'2020-02-04 10:54:38',NULL,'\0','View AbsencePlanning / ShiftPlanning: header pre Value 1 (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(439,1,'\0',682,'2020-02-04 10:54:38',NULL,'\0','View AbsencePlanning / ShiftPlanning: header pre Value 2 (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(440,1,'\0',683,'2020-02-04 10:54:38',NULL,'\0','View AbsencePlanning / ShiftPlanning: header pre Value 3 (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(441,1,'\0',684,'2020-02-04 10:54:38',NULL,'\0','View AbsencePlanning / ShiftPlanning: header after Value 1 (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(442,1,'\0',685,'2020-02-04 10:54:38',NULL,'\0','View AbsencePlanning / ShiftPlanning: header after Value 2 (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(443,1,'\0',686,'2020-02-04 10:54:38',NULL,'\0','View AbsencePlanning / ShiftPlanning: header after Value 3 (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(444,0,'\0',15302,'2020-02-04 10:54:38',NULL,'\0','ending with components (b)',NULL,'2020-02-04 10:54:38',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(445,0,'\0',15303,'2020-02-04 10:54:38',NULL,'\0','Erfassung der Menge (b)',NULL,'2020-02-04 10:54:38',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(446,0,'\0',15304,'2020-02-04 10:54:38',NULL,'\0','Standard-Menge (i)',0,'2020-02-04 10:54:38',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(447,0,'\0',99005,'2020-02-04 10:54:38',NULL,'\0','seccor: request read-events (i)',100,'2020-02-04 10:54:38',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(448,0,'\0',99006,'2020-02-26 05:04:14',NULL,'\0','planning: 0=WorkPeriodSheetUI, 1=TimePeriodSheetUI (i)',NULL,'2020-02-26 05:04:14',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(449,0,'\0',99007,'2020-04-04 01:49:00',NULL,'\0','forward datafox (c)',NULL,'2020-04-04 01:49:00',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(450,0,'\0',46,'2020-07-24 19:02:49',NULL,'\0','Clockwork-Web-Socket-Server-Url (c)',NULL,'2020-07-24 19:02:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(451,0,'\0',47,'2020-07-24 19:02:49',NULL,'\0','Clockwork-HTTP-Server-Url (Token) (c)',NULL,'2020-07-24 19:02:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(452,0,'\0',48,'2020-07-24 19:02:49',NULL,'\0','Clockwork-Web-Socket-Client-ID (c)',NULL,'2020-07-24 19:02:49',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(453,0,'\0',798,'2021-04-02 17:54:11',NULL,'\0','terminalcommands into terminal2sequence (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(454,0,'',1601,'2021-04-02 17:54:11',NULL,'\0','INSERT_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(455,0,'',1602,'2021-04-02 17:54:11',NULL,'\0','UPDATE_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(456,0,'',1603,'2021-04-02 17:54:11',NULL,'\0','DELETE_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(457,0,'',1604,'2021-04-02 17:54:11',NULL,'\0','ACCEPT_ADD_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(458,0,'',1605,'2021-04-02 17:54:11',NULL,'\0','ACCEPT_UPDATE_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(459,0,'',1606,'2021-04-02 17:54:11',NULL,'\0','ACCEPT_DELETE_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(460,0,'',1607,'2021-04-02 17:54:11',NULL,'\0','DENY_ADD_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(461,0,'',1608,'2021-04-02 17:54:11',NULL,'\0','DENY_UPDATE_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(462,0,'',1609,'2021-04-02 17:54:11',NULL,'\0','DENY_DELETE_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(463,0,'',1610,'2021-04-02 17:54:11',NULL,'\0','FORWARD_ADD_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(464,0,'',1611,'2021-04-02 17:54:11',NULL,'\0','FORWARD_UPDATE_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(465,0,'',1612,'2021-04-02 17:54:11',NULL,'\0','FORWARD_DELETE_BOOKING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(466,0,'',1621,'2021-04-02 17:54:11',NULL,'\0','INSERT_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(467,0,'',1622,'2021-04-02 17:54:11',NULL,'\0','UPDATE_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(468,0,'',1623,'2021-04-02 17:54:11',NULL,'\0','DELETE_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(469,0,'',1624,'2021-04-02 17:54:11',NULL,'\0','ACCEPT_ADD_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(470,0,'',1625,'2021-04-02 17:54:11',NULL,'\0','ACCEPT_UPDATE_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(471,0,'',1626,'2021-04-02 17:54:11',NULL,'\0','ACCEPT_DELETE_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(472,0,'',1627,'2021-04-02 17:54:11',NULL,'\0','DENY_ADD_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(473,0,'',1628,'2021-04-02 17:54:11',NULL,'\0','DENY_UPDATE_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(474,0,'',1629,'2021-04-02 17:54:11',NULL,'\0','DENY_DELETE_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:11',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(475,0,'',1630,'2021-04-02 17:54:12',NULL,'\0','FORWARD_ADD_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(476,0,'',1631,'2021-04-02 17:54:12',NULL,'\0','FORWARD_UPDATE_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(477,0,'',1632,'2021-04-02 17:54:12',NULL,'\0','FORWARD_DELETE_ABSENCEPLANNING_WORKFLOW-Email sofort senden (b)',NULL,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(478,0,'\0',15501,'2021-04-02 17:54:12',NULL,'\0','WebAppTerminal minimum number (i)',1001,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(479,0,'\0',15502,'2021-04-02 17:54:12',NULL,'\0','WebAppTerminal bookingCodeId (i)',7,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(480,0,'\0',15503,'2021-04-02 17:54:12',NULL,'\0','WebAppTerminal WebAppId (i)',1,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(481,0,'\0',100001,'2021-04-02 17:54:12',NULL,'\0','FMS Database-Url (c)',NULL,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(482,0,'\0',100002,'2021-04-02 17:54:12',NULL,'\0','FMS Database-DriverClassName (c)',NULL,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(483,0,'\0',100003,'2021-04-02 17:54:12',NULL,'\0','FMS Database-User (c)',NULL,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(484,0,'\0',100004,'2021-04-02 17:54:12',NULL,'\0','FMS Database-Password (c)',NULL,'2021-04-02 17:54:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(485,0,'\0',95,'2021-04-06 13:16:38',NULL,'\0','url for personCard-logo (c)',NULL,'2021-04-06 13:16:38',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(486,0,'\0',8,'2021-12-25 22:54:57',NULL,'\0','PZE-Berechnung: individuelle Arbeitskalender unterstuetzen (b)',NULL,'2021-12-25 22:54:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(487,0,'\0',178,'2021-12-25 22:54:57',NULL,'\0','booking: show homeoffice (b)',NULL,'2021-12-25 22:54:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(488,1,'\0',183,'2021-12-25 22:54:57',NULL,'\0','validation-work: validate work-bookings (b)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(489,0,'\0',242,'2021-12-25 22:54:57',NULL,'\0','report: custom-graphic-directory (c)',NULL,'2021-12-25 22:54:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(490,0,'\0',243,'2021-12-25 22:54:57',NULL,'\0','report: custom-sub-report-directory (c)',NULL,'2021-12-25 22:54:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(491,1,'\0',614,'2021-12-25 22:54:58',NULL,'\0','View Presence / Absence: show column \'booking.homeoffice\' (b)',NULL,'2024-03-07 09:48:59',NULL,0,'','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(492,0,'\0',797,'2021-12-25 22:54:58',NULL,'\0','Gantner: Kommandos 2, 7, 6, 85 (b)',NULL,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(493,0,'\0',1031,'2021-12-25 22:54:58',NULL,'\0','view presence/absence: undefined: added (c)',NULL,'2021-12-25 22:54:58','white',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(494,0,'\0',1032,'2021-12-25 22:54:58',NULL,'\0','view presence/absence: present (c)',NULL,'2021-12-25 22:54:58','lightgreen',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(495,0,'\0',1033,'2021-12-25 22:54:58',NULL,'\0','view presence/absence: absent (c)',NULL,'2021-12-25 22:54:58','lightcoral',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(496,0,'\0',1034,'2021-12-25 22:54:58',NULL,'\0','view presence/absence: present at homeoffice (c)',NULL,'2021-12-25 22:54:58','darkgreen',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(497,0,'\0',1702,'2021-12-25 22:54:58',NULL,'\0','Gantner GT7: numberOfShowingScreenInOK (i)',3000,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(498,0,'\0',1703,'2021-12-25 22:54:58',NULL,'\0','Gantner GT7: numberOfShowingScreenInBalances (i)',5000,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(499,0,'\0',1704,'2021-12-25 22:54:58',NULL,'\0','Gantner GT7: numberOfShowingScreenInError (i)',5000,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(500,0,'\0',1709,'2021-12-25 22:54:58',NULL,'\0','Gantner GT7: show balances at every booking (b)',NULL,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(501,0,'\0',1781,'2021-12-25 22:54:58',NULL,'\0','Gantner ACE: charsetName UTF-8 / old=UTF_16LE (c)',NULL,'2021-12-25 22:54:58','UTF-8',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(502,0,'\0',1805,'2021-12-25 22:54:58',NULL,'\0','Datafox: alternateBookingType (b)',NULL,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(503,0,'\0',2101,'2021-12-25 22:54:58',NULL,'\0','Login: register-form (b)',NULL,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(504,0,'\0',2102,'2021-12-25 22:54:58',NULL,'\0','Login: max. registering per Ip-address and day (i)',100,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(505,1,'\0',3007,'2021-12-25 22:54:58',NULL,'\0','smtp: from-email-address (c)',NULL,'2024-03-07 09:48:59',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(506,0,'\0',3101,'2021-12-25 22:54:58',NULL,'\0','logistics: Länge vom Zufallspasswort (i)',10,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(507,0,'\0',3111,'2021-12-25 22:54:58',NULL,'\0','logistics: Standard-Empfänger-OperatorType-Name (c)',NULL,'2021-12-25 22:54:58','LogisticsReceiver',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(508,0,'\0',3112,'2021-12-25 22:54:58',NULL,'\0','logistics: Standard-Lieferant-OperatorType-Name (c)',NULL,'2021-12-25 22:54:58','LogisticsVendor',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(509,0,'\0',3113,'2021-12-25 22:54:58',NULL,'\0','logistics: Standard-Spediteur-OperatorType-Name (c)',NULL,'2021-12-25 22:54:58','LogisticsCarrier',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(510,0,'\0',3121,'2021-12-25 22:54:58',NULL,'\0','logistics: Standard-Empfänger-Nummer (c)',NULL,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(511,0,'\0',3122,'2021-12-25 22:54:58',NULL,'\0','logistics: Standard-Lieferant-Nummer (c)',NULL,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(512,0,'\0',3123,'2021-12-25 22:54:58',NULL,'\0','logistics: Standard-Spediteur-Nummer (c)',NULL,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(513,0,'\0',200001,'2021-12-25 22:54:58',NULL,'\0','Debug (b)',NULL,'2021-12-25 22:54:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(514,0,'\0',614,'2021-12-25 22:57:44',NULL,'\0','View Presence / booking.homeoffice: show column \'booking.homeoffice\' (b)',NULL,'2021-12-25 22:57:44',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',1,0,NULL),
(515,0,'\0',614,'2021-12-25 22:57:44',NULL,'\0','View Presence / booking.homeoffice: show column \'booking.homeoffice\' (b)',NULL,'2021-12-25 22:57:44',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',2,0,NULL),
(516,0,'\0',614,'2021-12-25 22:57:44',NULL,'\0','View Presence / booking.homeoffice: show column \'booking.homeoffice\' (b)',NULL,'2021-12-25 22:57:44',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',3,0,NULL),
(517,0,'\0',614,'2021-12-25 22:57:44',NULL,'\0','View Presence / booking.homeoffice: show column \'booking.homeoffice\' (b)',NULL,'2021-12-25 22:57:44',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',4,0,NULL),
(518,0,'\0',614,'2021-12-25 22:57:44',NULL,'\0','View Presence / booking.homeoffice: show column \'booking.homeoffice\' (b)',NULL,'2021-12-25 22:57:44',NULL,0,'\0','at.clockwork.common.generalValidation.domain.GeneralValidation2SystemConfiguration',5,0,NULL),
(519,0,'\0',9,'2022-07-02 00:43:46',NULL,'\0','PZE-Berechnung: Stundenplan (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(520,0,'\0',170,'2022-07-02 00:43:46',NULL,'\0','booking: show calculated rounding columns (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(521,0,'\0',179,'2022-07-02 00:43:46',NULL,'\0','booking: show timeTimeModel column (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(522,0,'\0',180,'2022-07-02 00:43:46',NULL,'\0','booking: show calculated pause columns (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(523,0,'\0',184,'2022-07-02 00:43:46',NULL,'\0','validation-time: accept only coming after going with absence (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(524,0,'\0',615,'2022-07-02 00:43:46',NULL,'\0','View Presence / Absence: show work-components (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(525,0,'',646,'2022-07-02 00:43:46',NULL,'\0','ShiftPlanning: show only person2TimeTimeModel (in Kombi mit 642) (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(526,0,'\0',647,'2022-07-02 00:43:46',NULL,'\0','ShiftPlanning: show button workComponents (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(527,0,'\0',648,'2022-07-02 00:43:46',NULL,'\0','ShiftPlanning: enable shiftRotationPlanPosition (b)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(528,0,'\0',711,'2022-07-02 00:43:46',NULL,'\0','KeyFlex: no eventBaseData before yyyy-MM-dd HH:mm:ss (c)',NULL,'2022-07-02 00:43:46',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(529,0,'\0',3131,'2022-07-02 00:43:47',NULL,'\0','logistics: startTimePerDay (c)',NULL,'2022-07-02 00:43:47','6:00',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(530,0,'\0',3132,'2022-07-02 00:43:47',NULL,'\0','logistics: endTimePerDay (c)',NULL,'2022-07-02 00:43:47','18:00',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(531,0,'\0',3133,'2022-07-02 00:43:47',NULL,'\0','logistics: slotTime (c)',NULL,'2022-07-02 00:43:47','0:15',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(532,0,'\0',3134,'2022-07-02 00:43:47',NULL,'\0','logistics: timeslots (i)',2,'2022-07-02 00:43:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(533,0,'\0',3141,'2022-07-02 00:43:47',NULL,'\0','logistics: Betreff bei E-Mails (c)',NULL,'2022-07-02 00:43:47','Logistik-Plattform',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(534,0,'\0',3151,'2022-07-02 00:43:47',NULL,'\0','logistics: Button Baustellen-Logistik-Plan (c)',NULL,'2022-07-02 00:43:47','Baustellen-Logistik-Plan',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(535,0,'\0',3152,'2022-07-02 00:43:47',NULL,'\0','logistics: Button Anfahrtsplan (c)',NULL,'2022-07-02 00:43:47','Anfahrtsplan',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(536,0,'\0',4001,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.ChangedColumn',NULL,'2022-07-02 00:43:47','2em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(537,0,'\0',4002,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.CustomPersonWorkflowColumn',NULL,'2022-07-02 00:43:47','2em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(538,0,'\0',4003,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.CalculatedTooSoonColumn',NULL,'2022-07-02 00:43:47','3em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(539,0,'\0',4004,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.CalculatedTooLateColumn',NULL,'2022-07-02 00:43:47','3em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(540,0,'\0',4005,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.CalculatedRoundingColumn',NULL,'2022-07-02 00:43:47','3em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(541,0,'\0',4006,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.CalculatedPauseColumn',NULL,'2022-07-02 00:43:47','3em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(542,0,'\0',4007,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.PlannedTimeTimeModelColumn',NULL,'2022-07-02 00:43:47','8em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(543,0,'\0',4008,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.VirtualTimeTimeModelColumn',NULL,'2022-07-02 00:43:47','8em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(544,0,'\0',4009,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.DateColumn',NULL,'2022-07-02 00:43:47','6em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(545,0,'\0',4010,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.WeekDayColumn',NULL,'2022-07-02 00:43:47','4em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(546,0,'\0',4011,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.TimeTimeModelColumn',NULL,'2022-07-02 00:43:47','4em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(547,0,'\0',4012,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.AbsencePlanningColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(548,0,'\0',4013,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.TimeColumn',NULL,'2022-07-02 00:43:47','4em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(549,0,'\0',4014,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.BookingTypeColumn',NULL,'2022-07-02 00:43:47','6em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(550,0,'\0',4015,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.HomeofficeColumn',NULL,'2022-07-02 00:43:47','3em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(551,0,'\0',4016,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.AbsenceColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(552,0,'\0',4017,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.ProjectColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(553,0,'\0',4018,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.OrderColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(554,0,'\0',4019,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.OrderItemColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(555,0,'\0',4020,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.CostUnitColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(556,0,'\0',4021,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.MachineColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(557,0,'\0',4022,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.WorkplaceColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(558,0,'\0',4023,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.WorkprocessColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(559,0,'\0',4024,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.CommentColumn',NULL,'2022-07-02 00:43:47','10em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(560,0,'\0',4025,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingsTable.TimeTimeTypeColumn',NULL,'2022-07-02 00:43:47','3em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(561,0,'\0',4101,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.SelectedColumn',NULL,'2022-07-02 00:43:47','2em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(562,0,'\0',4102,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.PersonColumn',NULL,'2022-07-02 00:43:47','20em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(563,0,'\0',4103,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.StartDateColumn',NULL,'2022-07-02 00:43:47','5em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(564,0,'\0',4104,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.EndDateColumn',NULL,'2022-07-02 00:43:47','5em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(565,0,'\0',4105,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.AbsenceColumn',NULL,'2022-07-02 00:43:47','10em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(566,0,'\0',4106,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.CommentColumn',NULL,'2022-07-02 00:43:47','not used',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(567,0,'\0',4107,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.DetailColumn',NULL,'2022-07-02 00:43:47','5em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(568,0,'\0',4108,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.ForwardColumn',NULL,'2022-07-02 00:43:47','8em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(569,0,'\0',4109,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.AcceptColumn',NULL,'2022-07-02 00:43:47','6em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(570,0,'\0',4110,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.DenyColumn',NULL,'2022-07-02 00:43:47','6em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(571,0,'\0',4111,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: absencePlanningWorkflowsTable.CancelColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(572,0,'\0',4201,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: customPersonWorkflowsTable.PersonColumn',NULL,'2022-07-02 00:43:47','20em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(573,0,'\0',4202,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: customPersonWorkflowsTable.DateColumn',NULL,'2022-07-02 00:43:47','5em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(574,0,'\0',4203,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: customPersonWorkflowsTable.CommentColumn',NULL,'2022-07-02 00:43:47','not used',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(575,0,'\0',4301,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.SelectedColumn',NULL,'2022-07-02 00:43:47','2em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(576,0,'\0',4302,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.PersonColumn',NULL,'2022-07-02 00:43:47','20em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(577,0,'\0',4303,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.BookingColumn',NULL,'2022-07-02 00:43:47','20em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(578,0,'\0',4304,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.CommentColumn',NULL,'2022-07-02 00:43:47','not used',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(579,0,'\0',4305,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.DetailColumn',NULL,'2022-07-02 00:43:47','5em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(580,0,'\0',4306,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.ForwardColumn',NULL,'2022-07-02 00:43:47','8em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(581,0,'\0',4307,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.AcceptColumn',NULL,'2022-07-02 00:43:47','6em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(582,0,'\0',4308,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.DenyColumn',NULL,'2022-07-02 00:43:47','6em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(583,0,'\0',4309,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: bookingWorkflowsTable.CancelColumn',NULL,'2022-07-02 00:43:47','7em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(584,0,'\0',4401,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: validateTimeAttendancesTable.PersonColumn',NULL,'2022-07-02 00:43:47','20em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(585,1,'\0',4402,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: validateTimeAttendancesTable.TimestampColumn',NULL,'2025-03-19 11:55:32','12em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(586,0,'\0',4403,'2022-07-02 00:43:47',NULL,'\0','col-width: bookings: validateTimeAttendancesTable.CommentColumn',NULL,'2022-07-02 00:43:47','60em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(587,0,'\0',99008,'2022-07-02 00:43:47',NULL,'\0','url fuer Gantner api/login (c)',NULL,'2022-07-02 00:43:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(588,0,'\0',710,'2022-11-05 13:41:14',NULL,'\0','TerminalActions: Refresh-Zyklus (i)',5,'2022-11-05 13:41:14',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(589,0,'\0',801,'2022-11-05 13:41:14',NULL,'\0','fast insert: next day after going (b)',NULL,'2022-11-05 13:41:14',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(590,0,'\0',1891,'2022-11-05 13:41:14',NULL,'\0','Datafox: Servicestring (c)',NULL,'2022-11-05 13:41:14',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(591,0,'\0',1892,'2022-11-05 13:41:14',NULL,'\0','Datafox: Service-Flag 1/2 (http.flags=2 bei http) (i)',2,'2022-11-05 13:41:14',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(592,0,'\0',1893,'2022-11-05 13:41:14',NULL,'\0','Datafox: Service-IP (c)',NULL,'2022-11-05 13:41:14',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(593,0,'\0',1894,'2022-11-05 13:41:14',NULL,'\0','Datafox: Service-Port (i)',8000,'2022-11-05 13:41:14',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(594,0,'\0',3153,'2022-11-05 13:41:14',NULL,'\0','logistics: Link Baustellen-Logistik-Plan (c)',NULL,'2022-11-05 13:41:14','https://gamma.clockwork.at/pdfs/KUNDE_BaustellenLogistikPlan.pdf',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(595,0,'\0',3154,'2022-11-05 13:41:14',NULL,'\0','logistics: Link Anfahrtsplan (c)',NULL,'2022-11-05 13:41:14','https://gamma.clockwork.at/pdfs/KUNDE_Anfahrtsplan.pdf',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(596,0,'\0',4026,'2022-11-05 13:41:14',NULL,'\0','col-width: bookings: bookingsTable.TerminalColumn',NULL,'2022-11-05 13:41:14','3em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(597,0,'\0',21,'2022-12-22 11:10:47',NULL,'\0','jede Anfang-Buchung startet die Kommen-Zeit (b)',NULL,'2022-12-22 11:10:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(598,0,'\0',22,'2022-12-22 11:10:47',NULL,'\0','jede Ende-Buchung beendet die Kommen-Zeit (b)',NULL,'2022-12-22 11:10:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(599,0,'\0',23,'2022-12-22 11:10:47',NULL,'\0','Mehrmaschinenbedienung (b)',NULL,'2022-12-22 11:10:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(600,0,'\0',24,'2022-12-22 11:10:47',NULL,'\0','keine Standardberechnung bei Mehrmaschinenbedienung (b)',NULL,'2022-12-22 11:10:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(601,0,'\0',108,'2022-12-22 11:10:47',NULL,'\0','Menge in Buchungen und Planung anzeigen (b)',NULL,'2022-12-22 11:10:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(602,0,'\0',109,'2022-12-22 11:10:47',NULL,'\0','Artikel in Buchungen und Planung anzeigen (b)',NULL,'2022-12-22 11:10:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(603,0,'',244,'2022-12-22 11:10:47',NULL,'\0','report: show comment in personTimeReport (b)',NULL,'2022-12-22 11:10:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(604,0,'\0',4027,'2022-12-22 11:10:47',NULL,'\0','col-width: bookings: bookingsTable.QuantityColumn',NULL,'2022-12-22 11:10:47','3em',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(605,0,'\0',4500,'2022-12-22 11:10:48',NULL,'\0','1: add missing component with following standard (i)',0,'2022-12-22 11:10:48',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(606,0,'\0',4501,'2022-12-22 11:10:48',NULL,'\0','Projekt-Nummer (str)',NULL,'2022-12-22 11:10:48',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(607,0,'\0',4502,'2022-12-22 11:10:48',NULL,'\0','Auftrag-Nummer (str)',NULL,'2022-12-22 11:10:48',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(608,0,'\0',4503,'2022-12-22 11:10:48',NULL,'\0','AuftragPositions-Nummer (str)',NULL,'2022-12-22 11:10:48',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(609,0,'\0',4504,'2022-12-22 11:10:48',NULL,'\0','Kostenstellen-Nummer (str)',NULL,'2022-12-22 11:10:48',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(610,0,'\0',4505,'2022-12-22 11:10:48',NULL,'\0','Maschinen-Nummer (str)',NULL,'2022-12-22 11:10:48',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(611,0,'\0',4506,'2022-12-22 11:10:48',NULL,'\0','Arbeitsplatz-Nummer (str)',NULL,'2022-12-22 11:10:48',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(612,0,'\0',4507,'2022-12-22 11:10:48',NULL,'\0','Arbeitsgang-Nummer (str)',NULL,'2022-12-22 11:10:48',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(613,0,'\0',99999,'2023-01-18 00:39:47',NULL,'\0','individueller kundenspezifischer Testmodus (b)',NULL,'2023-01-18 00:39:47',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(614,0,'',25,'2024-03-07 09:48:57',NULL,'\0','aktuelle Arbeitszeit: Berechnung starten (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(615,0,'\0',69,'2024-03-07 09:48:57',NULL,'\0','Aliquoting: default TimeTimeType-Number (c)',NULL,'2024-03-07 09:48:57','40',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(616,0,'\0',221,'2024-03-07 09:48:57',NULL,'\0','bookingRequestsLimit (i)',100,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(617,0,'\0',222,'2024-03-07 09:48:57',NULL,'\0','absencePlanningRequestsLimit (i)',100,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(618,0,'',245,'2024-03-07 09:48:57',NULL,'\0','report: weekend rest injury: based on CalculatedTimeInfo (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(619,0,'\0',246,'2024-03-07 09:48:57',NULL,'\0','report: weekend rest injury: minimum hours',36,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(620,0,'',247,'2024-03-07 09:48:57',NULL,'\0','report: night rest injury: based on CalculatedTimeInfo (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(621,0,'\0',248,'2024-03-07 09:48:57',NULL,'\0','report: night rest injury: minimum hours',11,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(622,0,'\0',704,'2024-03-07 09:48:57',NULL,'\0','extended person access authorisation (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(623,0,'',802,'2024-03-07 09:48:57',NULL,'\0','fast insert: copy last day to next day (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(624,0,'\0',851,'2024-03-07 09:48:57',NULL,'\0','UpdatePersonDateIndividualTimeTimeModel: too soon (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(625,0,'\0',852,'2024-03-07 09:48:57',NULL,'\0','UpdatePersonDateIndividualTimeTimeModel: too late (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(626,0,'\0',853,'2024-03-07 09:48:57',NULL,'\0','UpdatePersonDateIndividualTimeTimeModel: pause (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(627,0,'\0',854,'2024-03-07 09:48:57',NULL,'\0','UpdatePersonDateIndividualTimeTimeModel: round (b)',NULL,'2024-03-07 09:48:57',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(628,0,'\0',1881,'2024-03-07 09:48:58',NULL,'\0','Datafox Active Connection: Host / IP (c)',NULL,'2024-03-07 09:48:58','0.0.0.0',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(629,0,'\0',1882,'2024-03-07 09:48:58',NULL,'\0','Datafox Active Connection: Port (i)',8000,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(630,0,'\0',1883,'2024-03-07 09:48:58',NULL,'\0','Datafox Active Connection: deviceID (i)',0,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(631,0,'\0',1884,'2024-03-07 09:48:58',NULL,'\0','Datafox Active Connection: timeout (i)',1000,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(632,0,'\0',1885,'2024-03-07 09:48:58',NULL,'\0','Datafox Active Connection: aliveTO (i)',1000,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(633,0,'\0',1886,'2024-03-07 09:48:58',NULL,'\0','Datafox Active Connection: maxConnections (i)',20,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(634,0,'\0',1887,'2024-03-07 09:48:58',NULL,'\0','Datafox Active Connection: infoFlags (i)',0,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(635,0,'\0',1888,'2024-03-07 09:48:58',NULL,'\0','Datafox Active Connection: reserved (i)',0,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(636,0,'\0',1899,'2024-03-07 09:48:58',NULL,'\0','Datafox: log in protocol (b)',NULL,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(637,0,'',2201,'2024-03-07 09:48:58',NULL,'\0','/services/communication**: basic-auth (b)',NULL,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(638,0,'',2202,'2024-03-07 09:48:58',NULL,'\0','/services/customer**: basic-auth (b)',NULL,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(639,0,'\0',2203,'2024-03-07 09:48:58',NULL,'\0','/services/foxpro**: basic-auth (b)',NULL,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(640,0,'\0',2204,'2024-03-07 09:48:58',NULL,'\0','/services/seccor**: basic-auth (b)',NULL,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(641,0,'\0',2301,'2024-03-07 09:48:58',NULL,'\0','bookingRequestResponse: accept (0=no, 1=offer, 2=mandatory field) (i)',0,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(642,0,'\0',2302,'2024-03-07 09:48:58',NULL,'\0','bookingRequestResponse: deny (0=no, 1=offer, 2=mandatory field) (i)',0,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(643,0,'\0',2311,'2024-03-07 09:48:58',NULL,'\0','absencePlanningRequestResponse: accept (0=no, 1=offer, 2=mandatory field) (i)',0,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(644,0,'\0',2312,'2024-03-07 09:48:58',NULL,'\0','absencePlanningRequestResponse: deny (0=no, 1=offer, 2=mandatory field) (i)',0,'2024-03-07 09:48:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(645,1,'\0',2013,'2024-03-12 12:00:11',NULL,'\0','debug: stop calculating at error while verifying - 2008 (b)',NULL,'2024-06-08 09:37:58',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(646,0,'\0',2014,'2024-03-12 12:00:11',NULL,'\0','debug: filename at verifying (c)',NULL,'2024-03-12 12:00:11','/opt/tomcat9/webapps/clockwork/cw_temp/verifyResult.txt',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(647,0,'\0',10,'2024-05-03 23:11:08',NULL,'\0','PZE-Berechnung: individuelle Arbeitskalender auch bei Person2TimeTimeModel (b)',NULL,'2024-05-03 23:11:08',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(648,0,'\0',796,'2024-05-03 23:11:09',NULL,'\0','KeyFlex: identical Max2- and Max3-plans (b)',NULL,'2024-05-03 23:11:09',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(649,0,'\0',502,'2024-06-08 09:37:55',NULL,'\0','Report timeReport: show changed booking -> * (b)',NULL,'2024-06-08 09:37:55',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(650,0,'\0',1898,'2024-06-08 09:37:55',NULL,'\0','Datafox: Uhrzeit: max. Differenz [s] (i)',30,'2024-06-08 09:37:55',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(651,0,'\0',2015,'2024-06-08 09:37:55',NULL,'\0','debug: no verified timeTimeTypes (c)',NULL,'2024-06-08 09:37:55','8,39,dv999,pv999,tv999,iv999,i999',0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(652,0,'',185,'2024-07-14 18:32:04',NULL,'\0','validation-time: show validation-error, if no booking and no absence-planning exists any day (b)',NULL,'2024-07-14 18:32:04',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(653,0,'\0',267,'2024-07-14 18:32:05',NULL,'\0','Supertrax Lite: show current hours of work (b)',NULL,'2024-07-14 18:32:05',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(654,0,'\0',15425,'2024-07-14 18:32:12',NULL,'\0','Saldo 4 - en (c)',NULL,'2024-07-14 18:32:12',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(655,0,'\0',26,'2024-07-27 23:58:56',NULL,'\0','calculating: missing going- is filled with last coming-booking (b)',NULL,'2024-07-27 23:58:56',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(656,0,'\0',5001,'2024-07-27 23:59:02',NULL,'\0','use data protection (b)',NULL,'2024-07-27 23:59:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(657,0,'',5002,'2024-07-27 23:59:02',NULL,'\0','data protection: show personnumber (b)',NULL,'2024-07-27 23:59:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(658,0,'',5003,'2024-07-27 23:59:02',NULL,'\0','data protection: show name (b)',NULL,'2024-07-27 23:59:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(659,0,'',5004,'2024-07-27 23:59:02',NULL,'\0','data protection: show entry date (b)',NULL,'2024-07-27 23:59:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(660,0,'',5005,'2024-07-27 23:59:02',NULL,'\0','data protection: show balances (b)',NULL,'2024-07-27 23:59:02',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(661,1,'\0',400,'2024-09-10 15:28:26',NULL,'\0','Balance-Id in WebApp (i)',1,'2024-09-10 15:28:29',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(662,0,'\0',99009,'2024-11-24 13:30:28',NULL,'\0','datafox: EMA for all persons (b)',NULL,'2024-11-24 13:30:28',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(663,0,'\0',249,'2025-03-19 11:56:15',NULL,'\0','report: reports without images (b)',NULL,'2025-03-19 11:56:15',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(664,0,'\0',2016,'2025-03-19 11:56:24',NULL,'\0','debug: logging during calculating (b)',NULL,'2025-03-19 11:56:24',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(665,0,'\0',2017,'2025-03-19 11:56:24',NULL,'\0','debug: automatic logging of all values when executing calculationProgram (b)',NULL,'2025-03-19 11:56:24',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL),
(666,0,'\0',2018,'2025-03-19 11:56:24',NULL,'\0','debug: logging of executing calculationProgram (b)',NULL,'2025-03-19 11:56:24',NULL,0,'\0','at.clockwork.system.domain.SystemConfiguration',NULL,0,NULL);

--
-- Table structure for table `cw_terminal`
--

CREATE TABLE `cw_terminal` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `address` int(11) NOT NULL,
  `cycle_read_events` int(11) DEFAULT NULL,
  `cycle_request_state` int(11) DEFAULT NULL,
  `cycle_update_data` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `delay_before_writing` int(11) NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `device_id` bigint(20) DEFAULT NULL,
  `individual_cycle_read_events` bit(1) NOT NULL,
  `individual_cycle_request_state` bit(1) NOT NULL,
  `individual_cycle_update_data` bit(1) NOT NULL,
  `input1name` varchar(255) DEFAULT NULL,
  `input2name` varchar(255) DEFAULT NULL,
  `input3name` varchar(255) DEFAULT NULL,
  `input4name` varchar(255) DEFAULT NULL,
  `is_input1` bit(1) DEFAULT NULL,
  `is_input2` bit(1) DEFAULT NULL,
  `is_input3` bit(1) DEFAULT NULL,
  `is_input4` bit(1) DEFAULT NULL,
  `is_used` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `log_communication_information_type_error` bit(1) DEFAULT NULL,
  `log_communication_information_type_fatal_error` bit(1) DEFAULT NULL,
  `log_communication_information_type_info` bit(1) DEFAULT NULL,
  `log_communication_information_type_ok` bit(1) DEFAULT NULL,
  `log_communication_information_type_repeat` bit(1) DEFAULT NULL,
  `log_communication_information_type_warning` bit(1) DEFAULT NULL,
  `number` varchar(255) NOT NULL,
  `read_events` bit(1) DEFAULT NULL,
  `request_state` bit(1) DEFAULT NULL,
  `snr` varchar(255) DEFAULT NULL,
  `terminal_category_id` bigint(20) DEFAULT NULL,
  `terminal_type_id` bigint(20) DEFAULT NULL,
  `uart_id` bigint(20) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `update_data` bit(1) DEFAULT NULL,
  `booking_code_id` bigint(20) DEFAULT NULL,
  `terminal_absence_id` bigint(20) DEFAULT NULL,
  `terminal_text_id` bigint(20) DEFAULT NULL,
  `short_name` varchar(255) DEFAULT NULL,
  `anonymous` bit(1) DEFAULT NULL,
  `balance_definition_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK85re2ot61m9pqqjl7mpak657m` (`device_id`),
  KEY `FKfe5fapnltyrat4wbx9sh0cmeo` (`terminal_category_id`),
  KEY `FKnon5f12fnr1mtwjy80q4cgm5s` (`terminal_type_id`),
  KEY `FKr612sbv38b8pscqkqqltydspu` (`uart_id`),
  KEY `address_idx` (`address`),
  KEY `number_idx` (`number`),
  KEY `FK2xe5q3iihqtuxpgdj8sgjp4yw` (`booking_code_id`),
  KEY `FKssn8k3287x935twx6f864vld7` (`terminal_absence_id`),
  KEY `FKfg2ahw5a9rcvq5n59hjtav7ra` (`terminal_text_id`),
  KEY `FKmy4y47ef0317phqqfysswonw5` (`balance_definition_id`),
  CONSTRAINT `FK2xe5q3iihqtuxpgdj8sgjp4yw` FOREIGN KEY (`booking_code_id`) REFERENCES `cw_booking_code` (`id`),
  CONSTRAINT `FK85re2ot61m9pqqjl7mpak657m` FOREIGN KEY (`device_id`) REFERENCES `cw_device` (`id`),
  CONSTRAINT `FKfe5fapnltyrat4wbx9sh0cmeo` FOREIGN KEY (`terminal_category_id`) REFERENCES `cw_terminal_category` (`id`),
  CONSTRAINT `FKfg2ahw5a9rcvq5n59hjtav7ra` FOREIGN KEY (`terminal_text_id`) REFERENCES `cw_terminal_text` (`id`),
  CONSTRAINT `FKmy4y47ef0317phqqfysswonw5` FOREIGN KEY (`balance_definition_id`) REFERENCES `cw_balance_definition` (`id`),
  CONSTRAINT `FKnon5f12fnr1mtwjy80q4cgm5s` FOREIGN KEY (`terminal_type_id`) REFERENCES `cw_terminal_type` (`id`),
  CONSTRAINT `FKr612sbv38b8pscqkqqltydspu` FOREIGN KEY (`uart_id`) REFERENCES `cw_uart` (`id`),
  CONSTRAINT `FKssn8k3287x935twx6f864vld7` FOREIGN KEY (`terminal_absence_id`) REFERENCES `cw_terminal_absence` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal`
--

INSERT INTO `cw_terminal` VALUES
(1,3,99001,0,0,50000,'2018-02-07 11:17:53',0,'\0','Gantner ST 370 Terminal',1,'\0','\0','','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','','','','','','','GAT ST 370','\0','\0','0',1,14,NULL,0,'',NULL,NULL,NULL,NULL,'\0',1),
(2,5,9101,0,0,0,'2019-05-22 12:44:40',0,'\0','Datafox Zeit',2,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','9101','\0','\0','9101',1,33,NULL,0,'\0',NULL,4,NULL,'','\0',1),
(3,1,99003,0,0,0,'2019-05-22 12:45:51',0,'\0','TMC',3,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','TMC','\0','\0','99003',1,32,NULL,0,'\0',NULL,NULL,NULL,NULL,'\0',1),
(4,1,1,0,0,0,'2019-05-22 12:48:36',250,'\0','Chiplox',5,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','MAC-Adresse','\0','\0','',1,35,NULL,0,'\0',NULL,NULL,NULL,NULL,'\0',1),
(5,2,256,0,0,0,'2021-12-25 23:40:00',250,'\0','KF-Max3',NULL,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','','','','','','','256','','\0','',1,21,1,0,'',NULL,NULL,NULL,'KF-Max3','\0',1),
(6,1,257,0,0,0,'2021-12-25 23:46:52',250,'\0','KF-Max2',NULL,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','','','','','','','257','','\0','',1,19,1,0,'',NULL,NULL,NULL,'KF-Max2','\0',1),
(7,1,258,0,0,0,'2021-12-25 23:48:37',0,'\0','TimeFlex',NULL,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','','','','','','','258','','','',1,28,1,0,'',8,NULL,NULL,'TimeFlex','\0',1),
(8,4,9102,0,0,0,'2022-11-05 14:21:17',250,'\0','Datafox Zeit Buchungscode',2,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','9102','\0','\0','9102',1,33,NULL,0,'\0',9,4,NULL,'','\0',1),
(9,2,101,0,0,0,'2023-01-18 02:59:35',250,'\0','TMC Supertrax7',6,'\0','\0','\0','','','','','\0','\0','\0','\0','','2024-09-10 15:28:29','','','','','','','101','','','',1,39,NULL,0,'',4,3,4,'TMC Supertrax7','\0',1),
(10,4,9201,0,0,0,'2023-02-08 23:42:04',250,'\0','Datafox Zutritt PHG',2,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','9201','\0','\0','9201',1,54,NULL,0,'',NULL,NULL,NULL,'','\0',1),
(11,3,9211,0,0,0,'2023-02-08 23:45:13',250,'\0','Datafox Zutritt UuZ',2,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','9211','\0','\0','9211',1,54,NULL,0,'',NULL,NULL,NULL,'','\0',1),
(12,2,0,0,0,0,'2023-02-08 23:47:03',250,'\0','Datafox Zutritt UuZ',2,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','9211-2','\0','\0','9211-2',1,54,NULL,0,'',NULL,NULL,NULL,'','\0',1),
(13,2,0,0,0,0,'2023-02-08 23:48:18',250,'\0','Datafox Zutritt PHG',2,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','9201-2','\0','\0','9201-2',1,54,NULL,0,'',NULL,NULL,NULL,'','\0',1),
(14,1,9103,0,0,0,'2024-06-08 10:06:02',250,'\0','Datafox Zeit Buchungscode offline',2,'\0','\0','\0','','','','','\0','\0','\0','\0','\0','2024-09-10 15:28:29','\0','\0','\0','\0','\0','\0','9103','\0','\0','9103',1,33,NULL,0,'\0',9,4,NULL,'','\0',1);

--
-- Table structure for table `cw_terminal_2_by_update_data_dependent_terminal`
--

CREATE TABLE `cw_terminal_2_by_update_data_dependent_terminal` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `by_update_data_dependent_terminal_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKrptlg71rln6s5k6xooiisimu0` (`by_update_data_dependent_terminal_id`),
  KEY `FK1nxdb2p2lf8r97bb05uothlh5` (`terminal_id`),
  CONSTRAINT `FK1nxdb2p2lf8r97bb05uothlh5` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKrptlg71rln6s5k6xooiisimu0` FOREIGN KEY (`by_update_data_dependent_terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_2_by_update_data_dependent_terminal`
--


--
-- Table structure for table `cw_terminal_2_door_access_schedule`
--

CREATE TABLE `cw_terminal_2_door_access_schedule` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `door_access_schedule_id` bigint(20) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `terminal_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKs1640n1ro3faii0re3g3in37l` (`door_access_schedule_id`),
  KEY `FKmate8sky13fpbyqc05chaat9f` (`terminal_id`),
  CONSTRAINT `FKmate8sky13fpbyqc05chaat9f` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKs1640n1ro3faii0re3g3in37l` FOREIGN KEY (`door_access_schedule_id`) REFERENCES `cw_door_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_2_door_access_schedule`
--


--
-- Table structure for table `cw_terminal_2_door_state_definition`
--

CREATE TABLE `cw_terminal_2_door_state_definition` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `door_state_definition_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKs6h3hui8stxwiv4t8vqrf6edf` (`door_state_definition_id`),
  KEY `FK80db8fr1g5axf8ha0mqfjv3k9` (`terminal_id`),
  CONSTRAINT `FK80db8fr1g5axf8ha0mqfjv3k9` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKs6h3hui8stxwiv4t8vqrf6edf` FOREIGN KEY (`door_state_definition_id`) REFERENCES `cw_door_state_definition` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_2_door_state_definition`
--


--
-- Table structure for table `cw_terminal_2_identification_type`
--

CREATE TABLE `cw_terminal_2_identification_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `identification_type_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `type_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjgnh6gsrp0xoubbd35lhuduwq` (`identification_type_id`),
  KEY `FKf7qvikytw1du0401iy3aimedt` (`terminal_id`),
  CONSTRAINT `FKf7qvikytw1du0401iy3aimedt` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKjgnh6gsrp0xoubbd35lhuduwq` FOREIGN KEY (`identification_type_id`) REFERENCES `cw_identification_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_2_identification_type`
--

INSERT INTO `cw_terminal_2_identification_type` VALUES
(1,0,'2018-02-07 11:19:10','\0',5,'2018-02-07 11:19:10',1,0,''),
(2,0,'2019-05-22 12:45:08','\0',3,'2019-05-22 12:45:08',2,0,''),
(3,0,'2019-05-22 12:45:51','\0',3,'2019-05-22 12:45:51',3,0,''),
(4,0,'2021-12-25 23:45:15','\0',2,'2021-12-25 23:45:15',5,0,''),
(5,0,'2021-12-25 23:46:52','\0',2,'2021-12-25 23:46:52',6,0,''),
(6,0,'2021-12-25 23:48:37','\0',2,'2021-12-25 23:48:37',7,0,''),
(7,0,'2022-11-05 14:21:17','\0',3,'2022-11-05 14:21:17',8,0,''),
(8,0,'2023-01-18 02:59:35','\0',2,'2023-01-18 02:59:35',9,0,''),
(9,0,'2023-02-08 23:42:04','\0',3,'2023-02-08 23:42:04',10,0,''),
(10,0,'2023-02-08 23:42:04','\0',8,'2023-02-08 23:42:04',10,0,''),
(11,0,'2023-02-08 23:42:34','\0',8,'2023-02-08 23:42:34',2,0,''),
(12,0,'2023-02-08 23:42:43','\0',8,'2023-02-08 23:42:43',8,0,''),
(13,0,'2023-02-08 23:45:13','\0',3,'2023-02-08 23:45:13',11,0,''),
(14,0,'2023-02-08 23:45:13','\0',8,'2023-02-08 23:45:13',11,0,''),
(15,0,'2023-02-08 23:47:03','\0',3,'2023-02-08 23:47:03',12,0,''),
(16,0,'2023-02-08 23:47:03','\0',8,'2023-02-08 23:47:03',12,0,''),
(17,0,'2023-02-08 23:48:18','\0',3,'2023-02-08 23:48:18',13,0,''),
(18,0,'2023-02-08 23:48:18','\0',8,'2023-02-08 23:48:18',13,0,''),
(19,0,'2024-06-08 10:06:02','\0',3,'2024-06-08 10:06:02',14,0,''),
(20,0,'2024-06-08 10:06:02','\0',8,'2024-06-08 10:06:02',14,0,'');

--
-- Table structure for table `cw_terminal_2_other_time_attendance`
--

CREATE TABLE `cw_terminal_2_other_time_attendance` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKkvryfj2neirr1skju2kkyi01o` (`terminal_id`),
  CONSTRAINT `FKkvryfj2neirr1skju2kkyi01o` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_2_other_time_attendance`
--


--
-- Table structure for table `cw_terminal_2_room_anti_pass_back`
--

CREATE TABLE `cw_terminal_2_room_anti_pass_back` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `room_anti_pass_bac_terminal_id` bigint(20) NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKqntxevj4ub03jsv13l6v53ngc` (`room_anti_pass_bac_terminal_id`),
  KEY `FKefki6dppk05fwqb8tcane1jqt` (`terminal_id`),
  CONSTRAINT `FKefki6dppk05fwqb8tcane1jqt` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKqntxevj4ub03jsv13l6v53ngc` FOREIGN KEY (`room_anti_pass_bac_terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_2_room_anti_pass_back`
--


--
-- Table structure for table `cw_terminal_2_sequence`
--

CREATE TABLE `cw_terminal_2_sequence` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `position` int(11) NOT NULL,
  `sequence` varchar(255) DEFAULT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKnhegmfvl85w8dpbnlemfxp1o4` (`terminal_id`),
  CONSTRAINT `FKnhegmfvl85w8dpbnlemfxp1o4` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_2_sequence`
--


--
-- Table structure for table `cw_terminal_2_synchronisation_area`
--

CREATE TABLE `cw_terminal_2_synchronisation_area` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `synchronisation_area_id` bigint(20) NOT NULL,
  `synchronise_me` bit(1) DEFAULT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `reverse_direction` bit(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKwj9wuo8fp4dx10c6gmmpam4s` (`synchronisation_area_id`),
  KEY `FKg1d1ljmb5xd5t9yr8yfx2efnj` (`terminal_id`),
  CONSTRAINT `FKg1d1ljmb5xd5t9yr8yfx2efnj` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKwj9wuo8fp4dx10c6gmmpam4s` FOREIGN KEY (`synchronisation_area_id`) REFERENCES `cw_synchronisation_area` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_2_synchronisation_area`
--


--
-- Table structure for table `cw_terminal_absence`
--

CREATE TABLE `cw_terminal_absence` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_absence`
--

INSERT INTO `cw_terminal_absence` VALUES
(1,1,'2022-07-02 00:53:21','\0','Trax+G/Prox+F','2022-07-02 01:04:51','TMC Trax+G/Prox+F',0),
(2,0,'2022-07-02 01:04:17','\0','TMC X1','2022-07-02 01:04:17','TMC X1',0),
(3,0,'2022-07-02 01:12:13','\0','SuperTrax 4/7','2022-07-02 01:12:13','TMC SuperTrax 4/7',0),
(4,0,'2024-03-12 12:20:13','\0','Datafox','2024-03-12 12:20:13','Datafox',0);

--
-- Table structure for table `cw_terminal_absence_2_detail`
--

CREATE TABLE `cw_terminal_absence_2_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `absence_id` bigint(20) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `position` int(11) NOT NULL,
  `terminal_absence_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK54vx4ftcvykf98uqo8ym7b340` (`absence_id`),
  KEY `FKesy1f5i6uo4c8wgjqwggkor1y` (`terminal_absence_id`),
  CONSTRAINT `FK54vx4ftcvykf98uqo8ym7b340` FOREIGN KEY (`absence_id`) REFERENCES `cw_absence` (`id`),
  CONSTRAINT `FKesy1f5i6uo4c8wgjqwggkor1y` FOREIGN KEY (`terminal_absence_id`) REFERENCES `cw_terminal_absence` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_absence_2_detail`
--

INSERT INTO `cw_terminal_absence_2_detail` VALUES
(1,1,NULL,'2022-07-02 00:54:19','\0','Arzt','2024-09-10 15:31:22',1,1,0),
(2,1,NULL,'2022-07-02 00:54:19','','Geht Arzt','2024-09-10 15:31:22',2,1,0),
(3,1,NULL,'2022-07-02 00:54:19','\0','DG','2024-09-10 15:31:22',2,1,0),
(4,1,NULL,'2022-07-02 00:54:19','','Geht DG','2024-09-10 15:31:22',4,1,0),
(5,1,NULL,'2022-07-02 01:04:17','\0','Arzt','2022-07-02 01:04:41',1,2,0),
(6,1,NULL,'2022-07-02 01:04:17','\0','Dienstgang','2022-07-02 01:04:41',2,2,0),
(7,1,NULL,'2022-07-02 01:04:17','','Kommt DG','2022-07-02 01:04:41',3,2,0),
(8,1,NULL,'2022-07-02 01:04:17','','Geht DG','2022-07-02 01:04:41',4,2,0),
(9,1,NULL,'2022-07-02 01:12:13','\0','Arzt','2024-09-10 15:31:03',1,3,0),
(10,1,NULL,'2022-07-02 01:12:13','','Geht Arzt','2024-09-10 15:31:04',2,3,0),
(11,1,NULL,'2022-07-02 01:12:13','\0','DG','2024-09-10 15:31:04',2,3,0),
(12,1,NULL,'2022-07-02 01:12:13','','Geht DG','2024-09-10 15:31:04',4,3,0),
(13,0,NULL,'2024-03-12 12:20:13','\0','Arzt','2024-03-12 12:20:13',1,4,0),
(14,0,NULL,'2024-03-12 12:20:13','\0','Dienstgang','2024-03-12 12:20:13',2,4,0);

--
-- Table structure for table `cw_terminal_addition`
--

CREATE TABLE `cw_terminal_addition` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK9inqbukv3drft3582xa1nsk9h` (`terminal_id`),
  CONSTRAINT `FK9inqbukv3drft3582xa1nsk9h` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_addition`
--


--
-- Table structure for table `cw_terminal_addition_key_flex`
--

CREATE TABLE `cw_terminal_addition_key_flex` (
  `id` bigint(20) NOT NULL,
  `last_booking_information_blob` longblob DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_addition_key_flex`
--


--
-- Table structure for table `cw_terminal_calendar`
--

CREATE TABLE `cw_terminal_calendar` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `update_counter` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_calendar`
--

INSERT INTO `cw_terminal_calendar` VALUES
(1,0,'2023-02-16 10:27:30','\0','Standardkalender','2023-02-16 10:27:30',0,'Kalender','at.clockwork.access.datafox.domain.DatafoxCalendar');

--
-- Table structure for table `cw_terminal_calendar_2_date`
--

CREATE TABLE `cw_terminal_calendar_2_date` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `class` varchar(255) NOT NULL,
  `gantner_calendar_id` bigint(20) DEFAULT NULL,
  `gantner_calendar_day_enum` varchar(255) DEFAULT NULL,
  `keyflex_calendar_id` bigint(20) DEFAULT NULL,
  `keyflex_calendar_day_enum` varchar(255) DEFAULT NULL,
  `chiplox_calendar_id` bigint(20) DEFAULT NULL,
  `chiplox_calendar_day_enum` varchar(255) DEFAULT NULL,
  `datafox_calendar_id` bigint(20) DEFAULT NULL,
  `datafox_calendar_day_enum` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK36vtkqhk9rodiwkifx0sbbk04` (`gantner_calendar_id`),
  KEY `FKjoqyae7joxgmh65eqx8hjsyg8` (`keyflex_calendar_id`),
  KEY `FK4xl3f5m2xgcs6r4782ewaf0uh` (`chiplox_calendar_id`),
  KEY `FKnt4n71u4iju7rothedgiq4jd3` (`datafox_calendar_id`),
  CONSTRAINT `FK36vtkqhk9rodiwkifx0sbbk04` FOREIGN KEY (`gantner_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`),
  CONSTRAINT `FK4xl3f5m2xgcs6r4782ewaf0uh` FOREIGN KEY (`chiplox_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`),
  CONSTRAINT `FKjoqyae7joxgmh65eqx8hjsyg8` FOREIGN KEY (`keyflex_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`),
  CONSTRAINT `FKnt4n71u4iju7rothedgiq4jd3` FOREIGN KEY (`datafox_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_calendar_2_date`
--


--
-- Table structure for table `cw_terminal_calendar_detail`
--

CREATE TABLE `cw_terminal_calendar_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `april` varchar(255) NOT NULL,
  `august` varchar(255) NOT NULL,
  `date_created` datetime NOT NULL,
  `december` varchar(255) NOT NULL,
  `deleted` bit(1) NOT NULL,
  `february` varchar(255) NOT NULL,
  `january` varchar(255) NOT NULL,
  `july` varchar(255) NOT NULL,
  `june` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `march` varchar(255) NOT NULL,
  `may` varchar(255) NOT NULL,
  `november` varchar(255) NOT NULL,
  `october` varchar(255) NOT NULL,
  `september` varchar(255) NOT NULL,
  `terminal_calendar_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKiolfo4nq4ytsps0x2vbvj722y` (`terminal_calendar_id`),
  CONSTRAINT `FKiolfo4nq4ytsps0x2vbvj722y` FOREIGN KEY (`terminal_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_calendar_detail`
--


--
-- Table structure for table `cw_terminal_category`
--

CREATE TABLE `cw_terminal_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description_de` varchar(255) DEFAULT NULL,
  `description_en` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_category`
--

INSERT INTO `cw_terminal_category` VALUES
(1,0,'2018-02-07 11:16:18','\0','Std','Standard','2018-02-07 11:16:18',0);

--
-- Table structure for table `cw_terminal_chiplox`
--

CREATE TABLE `cw_terminal_chiplox` (
  `id` bigint(20) NOT NULL,
  `unlocking_time` int(11) NOT NULL,
  `chiplox_calendar_id` bigint(20) DEFAULT NULL,
  `activate_alarmsystem_pincode` varchar(255) DEFAULT NULL,
  `activate_alarmsystem_pincode_waiting_period` int(11) DEFAULT NULL,
  `activate_generally_open_pincode` varchar(255) DEFAULT NULL,
  `activate_generally_open_pincode_waiting_period` int(11) DEFAULT NULL,
  `activate_office_pincode` varchar(255) DEFAULT NULL,
  `activate_office_pincode_waiting_period` int(11) DEFAULT NULL,
  `activate_office_with_end_pincode` varchar(255) DEFAULT NULL,
  `activate_office_with_end_pincode_waiting_period` int(11) DEFAULT NULL,
  `deactivate_alarmsystem_pincode` varchar(255) DEFAULT NULL,
  `deactivate_alarmsystem_pincode_waiting_period` int(11) DEFAULT NULL,
  `deactivate_generally_open_pincode` varchar(255) DEFAULT NULL,
  `deactivate_generally_open_pincode_waiting_period` int(11) DEFAULT NULL,
  `deactivate_office_pincode` varchar(255) DEFAULT NULL,
  `deactivate_office_pincode_waiting_period` int(11) DEFAULT NULL,
  `activate_function1pincode` varchar(255) DEFAULT NULL,
  `activate_function1pincode_time` int(11) DEFAULT NULL,
  `activate_function1pincode_waiting_period` int(11) DEFAULT NULL,
  `activate_function1with_end_pincode` varchar(255) DEFAULT NULL,
  `activate_function1with_end_pincode_waiting_period` int(11) DEFAULT NULL,
  `activate_function2pincode` varchar(255) DEFAULT NULL,
  `activate_function2pincode_time` int(11) DEFAULT NULL,
  `activate_function2pincode_waiting_period` int(11) DEFAULT NULL,
  `activate_function2with_end_pincode` varchar(255) DEFAULT NULL,
  `activate_function2with_end_pincode_waiting_period` int(11) DEFAULT NULL,
  `activate_generally_close_pincode` varchar(255) NOT NULL,
  `activate_generally_close_pincode_waiting_period` int(11) NOT NULL,
  `activate_generally_close_with_end_pincode` varchar(255) NOT NULL,
  `activate_generally_close_with_end_pincode_waiting_period` int(11) NOT NULL,
  `deactivate_function1pincode` varchar(255) DEFAULT NULL,
  `deactivate_function1pincode_waiting_period` int(11) DEFAULT NULL,
  `deactivate_function2pincode` varchar(255) DEFAULT NULL,
  `deactivate_function2pincode_waiting_period` int(11) DEFAULT NULL,
  `deactivate_generally_close_pincode` varchar(255) NOT NULL,
  `deactivate_generally_close_pincode_waiting_period` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKshogq9uxk56fj1q21uax5elto` (`chiplox_calendar_id`),
  CONSTRAINT `FKdxcg0f5dvua3hrl1etlwwve5f` FOREIGN KEY (`chiplox_calendar_id`) REFERENCES `cw_chiplox_calendar` (`id`),
  CONSTRAINT `FKshogq9uxk56fj1q21uax5elto` FOREIGN KEY (`chiplox_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_chiplox`
--

INSERT INTO `cw_terminal_chiplox` VALUES
(4,5000,NULL,'',0,'',0,'',0,'',0,'',0,'',0,'',0,NULL,0,0,NULL,0,NULL,0,0,NULL,0,'',0,'',0,NULL,0,NULL,0,'',0);

--
-- Table structure for table `cw_terminal_chiplox_2_antenna`
--

CREATE TABLE `cw_terminal_chiplox_2_antenna` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `address` int(11) NOT NULL,
  `antenna_direction_enum` varchar(255) DEFAULT NULL,
  `code_regex` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `identification_type_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `tty_device` varchar(255) DEFAULT NULL,
  `uart_id` bigint(20) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `antenna_model_enum` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKd1sjhmqug2nfcfem5fdemurwk` (`identification_type_id`),
  KEY `FKkxs298sadrnvk6y9ne9vyfheu` (`terminal_id`),
  KEY `FKqbn6agyxvh38kwilb7c3df4kh` (`uart_id`),
  CONSTRAINT `FKd1sjhmqug2nfcfem5fdemurwk` FOREIGN KEY (`identification_type_id`) REFERENCES `cw_identification_type` (`id`),
  CONSTRAINT `FKkxs298sadrnvk6y9ne9vyfheu` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal_chiplox` (`id`),
  CONSTRAINT `FKqbn6agyxvh38kwilb7c3df4kh` FOREIGN KEY (`uart_id`) REFERENCES `cw_uart` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_chiplox_2_antenna`
--


--
-- Table structure for table `cw_terminal_chiplox_2_function`
--

CREATE TABLE `cw_terminal_chiplox_2_function` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `chiplox_action_enum` varchar(255) NOT NULL,
  `chiplox_function_enum` varchar(255) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK69x8sr53u2sb83gqnx1x0svur` (`terminal_id`),
  CONSTRAINT `FK69x8sr53u2sb83gqnx1x0svur` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal_chiplox` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_chiplox_2_function`
--


--
-- Table structure for table `cw_terminal_chiplox_2_input_condition`
--

CREATE TABLE `cw_terminal_chiplox_2_input_condition` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `chiplox_action_enum` varchar(255) NOT NULL,
  `chiplox_input_condition_enum` varchar(255) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKn5qwmedqntde41sdtrd04589h` (`terminal_id`),
  CONSTRAINT `FKn5qwmedqntde41sdtrd04589h` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal_chiplox` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_chiplox_2_input_condition`
--


--
-- Table structure for table `cw_terminal_clockwork`
--

CREATE TABLE `cw_terminal_clockwork` (
  `id` bigint(20) NOT NULL,
  `terminal_calendar_id` bigint(20) DEFAULT NULL,
  `unlocking_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKhkronvgsombsec7nf68nxe4pv` (`terminal_calendar_id`),
  CONSTRAINT `FKhkronvgsombsec7nf68nxe4pv` FOREIGN KEY (`terminal_calendar_id`) REFERENCES `cw_chiplox_calendar` (`id`),
  CONSTRAINT `FKkbr9xisvucm4gjstnxorc7924` FOREIGN KEY (`terminal_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_clockwork`
--


--
-- Table structure for table `cw_terminal_communication`
--

CREATE TABLE `cw_terminal_communication` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `done` bit(1) NOT NULL,
  `input` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `output` varchar(255) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `terminal_id` bigint(20) DEFAULT NULL,
  `terminal_action_detail` longtext DEFAULT NULL,
  `terminal_command_cw_id` int(11) NOT NULL,
  `info_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `query1_idx` (`terminal_id`),
  KEY `query2_idx` (`deleted`,`done`,`terminal_id`),
  CONSTRAINT `FKanmpe5cqcirv3nayn5gnkdp0t` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_communication`
--


--
-- Table structure for table `cw_terminal_data_loaded`
--

CREATE TABLE `cw_terminal_data_loaded` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `command` varchar(255) NOT NULL,
  `command_key` varchar(255) DEFAULT NULL,
  `data` longtext DEFAULT NULL,
  `terminal_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `query1_idx` (`terminal_id`),
  KEY `query2_idx` (`terminal_id`,`command`,`command_key`),
  CONSTRAINT `FKk7dej5mt4h95a14tahq50l1k1` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_data_loaded`
--


--
-- Table structure for table `cw_terminal_datafox`
--

CREATE TABLE `cw_terminal_datafox` (
  `id` bigint(20) NOT NULL,
  `cost_unit_list_name` varchar(255) DEFAULT NULL,
  `firmware_level` int(11) NOT NULL,
  `machine_list_name` varchar(255) DEFAULT NULL,
  `order_item_list_name` varchar(255) DEFAULT NULL,
  `order_list_name` varchar(255) DEFAULT NULL,
  `person_list_name` varchar(255) DEFAULT NULL,
  `project_list_name` varchar(255) DEFAULT NULL,
  `transfer_cost_units` bit(1) NOT NULL,
  `transfer_machines` bit(1) NOT NULL,
  `transfer_order_items` bit(1) NOT NULL,
  `transfer_orders` bit(1) NOT NULL,
  `transfer_persons` bit(1) NOT NULL,
  `transfer_projects` bit(1) NOT NULL,
  `transfer_workplaces` bit(1) NOT NULL,
  `transfer_workprocesses` bit(1) NOT NULL,
  `workplace_list_name` varchar(255) DEFAULT NULL,
  `workprocess_list_name` varchar(255) DEFAULT NULL,
  `datafox_calendar_id` bigint(20) DEFAULT NULL,
  `absence_list_name` varchar(255) DEFAULT NULL,
  `action1` bit(1) DEFAULT NULL,
  `anti_pass_back` bit(1) DEFAULT NULL,
  `base_terminal_id` bigint(20) DEFAULT NULL,
  `check_authorisation` bit(1) NOT NULL,
  `identification_list_name` varchar(255) DEFAULT NULL,
  `transfer_absences` bit(1) NOT NULL,
  `transfer_identifications` bit(1) NOT NULL,
  `changed_door_state_script_id` bigint(20) DEFAULT NULL,
  `datafox_type_enum` varchar(255) DEFAULT NULL,
  `door_module` int(11) DEFAULT NULL,
  `web_socket` bit(1) DEFAULT NULL,
  `booking_response_with_balance` bit(1) DEFAULT NULL,
  `global_variable1` varchar(255) DEFAULT NULL,
  `global_variable2` varchar(255) DEFAULT NULL,
  `global_variable3` varchar(255) DEFAULT NULL,
  `global_variable4` varchar(255) DEFAULT NULL,
  `global_variable5` varchar(255) DEFAULT NULL,
  `global_variable6` varchar(255) DEFAULT NULL,
  `global_variable7` varchar(255) DEFAULT NULL,
  `global_variable8` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKkg5c5tdn78gkinq23h21i0d81` (`datafox_calendar_id`),
  KEY `FKsk3iwuvk0e0vy7dhbw4hek6c3` (`base_terminal_id`),
  KEY `FK3kmaky0wcjo7vg3ud9rm6edn4` (`changed_door_state_script_id`),
  CONSTRAINT `FK3kmaky0wcjo7vg3ud9rm6edn4` FOREIGN KEY (`changed_door_state_script_id`) REFERENCES `cw_script` (`id`),
  CONSTRAINT `FKkg5c5tdn78gkinq23h21i0d81` FOREIGN KEY (`datafox_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`),
  CONSTRAINT `FKsk3iwuvk0e0vy7dhbw4hek6c3` FOREIGN KEY (`base_terminal_id`) REFERENCES `cw_terminal_datafox` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_datafox`
--

INSERT INTO `cw_terminal_datafox` VALUES
(2,'',0,'','','','','','\0','\0','\0','\0','\0','\0','\0','\0','','',NULL,'','','\0',NULL,'\0','','','\0',NULL,NULL,0,'\0','\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(8,'',0,'','','','','','\0','\0','\0','\0','\0','\0','\0','\0','','',NULL,'','','\0',NULL,'\0','','','\0',NULL,NULL,0,'\0','\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(10,'',1,'','','','','','\0','\0','\0','\0','\0','\0','\0','\0','','',1,'','','\0',NULL,'\0','','\0','\0',NULL,NULL,0,'\0','\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(11,'',1,'','','','','','\0','\0','\0','\0','\0','\0','\0','\0','','',1,'','','\0',NULL,'\0','','\0','\0',NULL,NULL,0,'\0','\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(12,'',1,'','','','','','\0','\0','\0','\0','\0','\0','\0','\0','','',1,'','','\0',11,'\0','','\0','\0',NULL,NULL,0,'\0','\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(13,'',1,'','','','','','\0','\0','\0','\0','\0','\0','\0','\0','','',1,'','','\0',10,'\0','','\0','\0',NULL,NULL,0,'\0','\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(14,'',0,'','','','','','\0','\0','\0','\0','','\0','\0','\0','','',NULL,'','','\0',NULL,'\0','','','',NULL,NULL,0,'\0','\0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `cw_terminal_datafox_2_action`
--

CREATE TABLE `cw_terminal_datafox_2_action` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `port_out` int(11) NOT NULL,
  `relais_action_enum` varchar(255) NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `time` int(11) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `output_enum` varchar(255) NOT NULL,
  `base_terminal_id` bigint(20) DEFAULT NULL,
  `base_terminal2reader_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKkdv8uy5kb3f03ji8sjokuch7a` (`terminal_id`),
  KEY `FKbt5s8w4gweyd8gc80ki37rh7c` (`base_terminal_id`),
  KEY `FK6b3mr7yx2rxgycdl9tql8n8nv` (`base_terminal2reader_id`),
  CONSTRAINT `FK6b3mr7yx2rxgycdl9tql8n8nv` FOREIGN KEY (`base_terminal2reader_id`) REFERENCES `cw_terminal_datafox_2_reader` (`id`),
  CONSTRAINT `FKbt5s8w4gweyd8gc80ki37rh7c` FOREIGN KEY (`base_terminal_id`) REFERENCES `cw_terminal_datafox` (`id`),
  CONSTRAINT `FKkdv8uy5kb3f03ji8sjokuch7a` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal_datafox` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_datafox_2_action`
--

INSERT INTO `cw_terminal_datafox_2_action` VALUES
(1,0,'2023-02-08 23:44:11','\0','2023-02-08 23:44:11',1,'ENTRY',10,5,0,'BASE_RELAIS_1',NULL,NULL),
(2,1,'2023-02-08 23:45:13','\0','2023-02-08 23:45:55',-101,'ENTRY',11,5,0,'UuZ',NULL,NULL),
(3,0,'2023-02-08 23:47:03','\0','2023-02-08 23:47:03',-101,'ENTRY',12,5,0,'UuZ',NULL,NULL),
(4,0,'2023-02-08 23:48:18','\0','2023-02-08 23:48:18',3,'ENTRY',13,5,0,'BASE_RELAIS_2',NULL,NULL);

--
-- Table structure for table `cw_terminal_datafox_2_list_table`
--

CREATE TABLE `cw_terminal_datafox_2_list_table` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `content` longtext DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `list_table_name` varchar(255) DEFAULT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK1vn7o7e12emp51xub9u48u656` (`terminal_id`),
  CONSTRAINT `FK1vn7o7e12emp51xub9u48u656` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal_datafox` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_datafox_2_list_table`
--

INSERT INTO `cw_terminal_datafox_2_list_table` VALUES
(1,0,'C	KOMMEN\nG	GEHEN\n','2024-06-08 10:03:50','\0','2024-06-08 10:03:50','bookingTypes',2,0),
(2,0,'C	KOMMEN\nG	GEHEN\n','2024-06-08 10:04:07','\0','2024-06-08 10:04:07','bookingTypes',8,0),
(3,0,'C	KOMMEN\nG	GEHEN\n','2024-06-08 10:06:02','\0','2024-06-08 10:06:02','bookingTypes',14,0);

--
-- Table structure for table `cw_terminal_datafox_2_reader`
--

CREATE TABLE `cw_terminal_datafox_2_reader` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `door_type_enum` varchar(255) NOT NULL,
  `identification_type_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `reader_address` int(11) NOT NULL,
  `reader_enum` varchar(255) NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `module_or_bus` int(11) NOT NULL,
  `pin_code` bit(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjpiejmfnwg75c1n96tj2963vf` (`identification_type_id`),
  KEY `FKpds1xwl021aaacujsmqo13ld6` (`terminal_id`),
  CONSTRAINT `FKjpiejmfnwg75c1n96tj2963vf` FOREIGN KEY (`identification_type_id`) REFERENCES `cw_identification_type` (`id`),
  CONSTRAINT `FKpds1xwl021aaacujsmqo13ld6` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal_datafox` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_datafox_2_reader`
--

INSERT INTO `cw_terminal_datafox_2_reader` VALUES
(1,0,'2023-02-08 23:43:29','\0','ENTRY',NULL,'2023-02-08 23:43:29',1,'PHG',10,0,1,'\0'),
(2,0,'2023-02-08 23:45:13','\0','ENTRY',NULL,'2023-02-08 23:45:13',1,'UuZ',11,0,1,'\0'),
(3,0,'2023-02-08 23:47:03','\0','ENTRY',NULL,'2023-02-08 23:47:03',1,'UuZ',12,0,1,'\0'),
(4,0,'2023-02-08 23:48:18','\0','ENTRY',NULL,'2023-02-08 23:48:18',1,'PHG',13,0,1,'\0');

--
-- Table structure for table `cw_terminal_gantner`
--

CREATE TABLE `cw_terminal_gantner` (
  `id` bigint(20) NOT NULL,
  `number_of_absences` int(11) DEFAULT NULL,
  `number_of_bookings` int(11) DEFAULT NULL,
  `number_of_cost_units` int(11) DEFAULT NULL,
  `number_of_orders` int(11) DEFAULT NULL,
  `number_of_persons` int(11) DEFAULT NULL,
  `number_of_text` int(11) DEFAULT NULL,
  `number_of_workplaces` int(11) DEFAULT NULL,
  `number_of_workprocesses` int(11) DEFAULT NULL,
  `sequence1` longtext DEFAULT NULL,
  `gantner_calendar_id` bigint(20) DEFAULT NULL,
  `normal_relay_plan_id` bigint(20) DEFAULT NULL,
  `special_relay_plan_id` bigint(20) DEFAULT NULL,
  `command2` varchar(255) DEFAULT NULL,
  `command6` varchar(255) DEFAULT NULL,
  `command7` varchar(255) DEFAULT NULL,
  `command85` varchar(255) DEFAULT NULL,
  `identification_format_enum` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKclg7wqm9fdl3yqibhpf7j93bo` (`gantner_calendar_id`),
  KEY `FK74ek7dnkd65qsee4xn88q9mpf` (`normal_relay_plan_id`),
  KEY `FK6qvfb9ku1fis2iqd635sgss9w` (`special_relay_plan_id`),
  CONSTRAINT `FK6qvfb9ku1fis2iqd635sgss9w` FOREIGN KEY (`special_relay_plan_id`) REFERENCES `cw_gantner_relay_plan` (`id`),
  CONSTRAINT `FK74ek7dnkd65qsee4xn88q9mpf` FOREIGN KEY (`normal_relay_plan_id`) REFERENCES `cw_gantner_relay_plan` (`id`),
  CONSTRAINT `FKclg7wqm9fdl3yqibhpf7j93bo` FOREIGN KEY (`gantner_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_gantner`
--


--
-- Table structure for table `cw_terminal_info`
--

CREATE TABLE `cw_terminal_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date` datetime DEFAULT NULL,
  `firmware_version` varchar(255) DEFAULT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `terminal_info_enum` varchar(255) NOT NULL,
  `terminal_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKe4ww7p4dejwbof51hebm2eukd` (`terminal_id`),
  CONSTRAINT `FKe4ww7p4dejwbof51hebm2eukd` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_terminal_info`
--


--
-- Table structure for table `cw_terminal_key_flex`
--

CREATE TABLE `cw_terminal_key_flex` (
  `id` bigint(20) NOT NULL,
  `activate_relay2` bit(1) NOT NULL,
  `activate_relay3` bit(1) NOT NULL,
  `activate_relay4` bit(1) NOT NULL,
  `activate_relay5` bit(1) NOT NULL,
  `activate_relay6` bit(1) NOT NULL,
  `base_year` int(11) NOT NULL,
  `check_alternate_booking_type` bit(1) NOT NULL,
  `deactivate_antenna_if_input_set` bit(1) NOT NULL,
  `duration_of_beep` int(11) NOT NULL,
  `enable_door_control` bit(1) NOT NULL,
  `enable_too_long_open_alarm` bit(1) NOT NULL,
  `enable_unlocking_button` bit(1) NOT NULL,
  `individual_control_data` varchar(255) NOT NULL,
  `individual_control_data2` varchar(255) NOT NULL,
  `input1checks_if_alarm_system_is_ready_to_turn_sharply` bit(1) NOT NULL,
  `log_invalid_booking` bit(1) NOT NULL,
  `number_of_impulse` int(11) NOT NULL,
  `number_of_persons` int(11) NOT NULL,
  `number_of_relays` int(11) NOT NULL,
  `parallel_circuit` varchar(255) NOT NULL,
  `save_each_door_state_change` bit(1) NOT NULL,
  `save_illegal_entry` bit(1) NOT NULL,
  `set_relay2parallel_to_relay1` bit(1) NOT NULL,
  `show_present_and_absent_persons` bit(1) NOT NULL,
  `show_present_persons` bit(1) NOT NULL,
  `show_state_of_input_at_booking` bit(1) NOT NULL,
  `time_of_parallel_circuit_in_seconds` int(11) NOT NULL,
  `time_of_setting_transistor` int(11) NOT NULL,
  `unlocking_time` int(11) NOT NULL,
  `keyflex_calendar_id` bigint(20) DEFAULT NULL,
  `max_access_schedules` int(11) NOT NULL,
  `max_public_holidays` int(11) NOT NULL,
  `max_times_per_access_schedule` int(11) NOT NULL,
  `check_only_pointer_at_reading_bookings` bit(1) DEFAULT NULL,
  `door_type_enum` varchar(255) DEFAULT NULL,
  `base_terminal_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKnxjkpbft9r0t1ai4g7m553gyq` (`keyflex_calendar_id`),
  KEY `FKj7cujbfgcbuneu2ku0a3ehi2d` (`base_terminal_id`),
  CONSTRAINT `FKj7cujbfgcbuneu2ku0a3ehi2d` FOREIGN KEY (`base_terminal_id`) REFERENCES `cw_terminal_key_flex` (`id`),
  CONSTRAINT `FKnxjkpbft9r0t1ai4g7m553gyq` FOREIGN KEY (`keyflex_calendar_id`) REFERENCES `cw_terminal_calendar` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
