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

--
-- Dumping data for table `cw_door_state_visualisation`
--


--
-- Table structure for table `cw_door_state_visualisation_detail`
--

CREATE TABLE `cw_door_state_visualisation_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `color1_id` bigint(20) NOT NULL,
  `color2_id` bigint(20) NOT NULL,
  `description1` varchar(255) NOT NULL,
  `description2` varchar(255) NOT NULL,
  `door_state_visualisation_id` bigint(20) NOT NULL,
  `priority` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKpl0x5ophq0lwov9cmsmu0mill` (`color1_id`),
  KEY `FKr84iveo9w9w137xok5pbhnv95` (`color2_id`),
  KEY `FKlsc8psvjbi75ggit4bfognrcr` (`door_state_visualisation_id`),
  CONSTRAINT `FKlsc8psvjbi75ggit4bfognrcr` FOREIGN KEY (`door_state_visualisation_id`) REFERENCES `cw_door_state_visualisation` (`id`),
  CONSTRAINT `FKpl0x5ophq0lwov9cmsmu0mill` FOREIGN KEY (`color1_id`) REFERENCES `cw_color` (`id`),
  CONSTRAINT `FKr84iveo9w9w137xok5pbhnv95` FOREIGN KEY (`color2_id`) REFERENCES `cw_color` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_door_state_visualisation_detail`
--


--
-- Table structure for table `cw_door_state_visualisation_detail_cw_door_state`
--

CREATE TABLE `cw_door_state_visualisation_detail_cw_door_state` (
  `door_state_visualisation_detail_additional_infos_id` bigint(20) NOT NULL,
  `door_state_id` bigint(20) DEFAULT NULL,
  `door_state_visualisation_detail_door_states_id` bigint(20) NOT NULL,
  `door_state_visualisation_detail_negated_additional_infos_id` bigint(20) NOT NULL,
  `door_state_visualisation_detail_negated_door_states_id` bigint(20) NOT NULL,
  KEY `FKcnf8mmrtuk76g8e4765c34ntj` (`door_state_id`),
  KEY `FKm94rmndxccfmi1ti34hq6lemy` (`door_state_visualisation_detail_additional_infos_id`),
  KEY `FK4b3a2cuwgraj8m079qmh5ktt8` (`door_state_visualisation_detail_door_states_id`),
  KEY `FKcf79mv5d2uglncbgwxbkp7tq3` (`door_state_visualisation_detail_negated_additional_infos_id`),
  KEY `FK32joq4wk36yt1ykfpr6amd1ym` (`door_state_visualisation_detail_negated_door_states_id`),
  CONSTRAINT `FK32joq4wk36yt1ykfpr6amd1ym` FOREIGN KEY (`door_state_visualisation_detail_negated_door_states_id`) REFERENCES `cw_door_state_visualisation_detail` (`id`),
  CONSTRAINT `FK4b3a2cuwgraj8m079qmh5ktt8` FOREIGN KEY (`door_state_visualisation_detail_door_states_id`) REFERENCES `cw_door_state_visualisation_detail` (`id`),
  CONSTRAINT `FKcf79mv5d2uglncbgwxbkp7tq3` FOREIGN KEY (`door_state_visualisation_detail_negated_additional_infos_id`) REFERENCES `cw_door_state_visualisation_detail` (`id`),
  CONSTRAINT `FKcnf8mmrtuk76g8e4765c34ntj` FOREIGN KEY (`door_state_id`) REFERENCES `cw_door_state` (`id`),
  CONSTRAINT `FKm94rmndxccfmi1ti34hq6lemy` FOREIGN KEY (`door_state_visualisation_detail_additional_infos_id`) REFERENCES `cw_door_state_visualisation_detail` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_door_state_visualisation_detail_cw_door_state`
--


--
-- Table structure for table `cw_dsdef_2_det_2_additional_info`
--

CREATE TABLE `cw_dsdef_2_det_2_additional_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `additional_info_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `door_state_definition2detail_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKmfeek73hg6d2px2vutdwpvwl5` (`additional_info_id`),
  KEY `FKk3e0c1kk7igkedqr87qljocav` (`door_state_definition2detail_id`),
  CONSTRAINT `FKk3e0c1kk7igkedqr87qljocav` FOREIGN KEY (`door_state_definition2detail_id`) REFERENCES `cw_door_state_def_2_detail` (`id`),
  CONSTRAINT `FKmfeek73hg6d2px2vutdwpvwl5` FOREIGN KEY (`additional_info_id`) REFERENCES `cw_door_state` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_dsdef_2_det_2_additional_info`
--


--
-- Table structure for table `cw_dsdef_2_det_2_door_state`
--

CREATE TABLE `cw_dsdef_2_det_2_door_state` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `door_state_id` bigint(20) NOT NULL,
  `door_state_definition2detail_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKdj6nanutfrfssneabasqoeba8` (`door_state_id`),
  KEY `FKofn37y41f405r9q3ihivy3mhl` (`door_state_definition2detail_id`),
  CONSTRAINT `FKdj6nanutfrfssneabasqoeba8` FOREIGN KEY (`door_state_id`) REFERENCES `cw_door_state` (`id`),
  CONSTRAINT `FKofn37y41f405r9q3ihivy3mhl` FOREIGN KEY (`door_state_definition2detail_id`) REFERENCES `cw_door_state_def_2_detail` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_dsdef_2_det_2_door_state`
--


--
-- Table structure for table `cw_dsdef_2_det_2_neg_additional_info`
--

CREATE TABLE `cw_dsdef_2_det_2_neg_additional_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `door_state_definition2detail_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `negated_additional_info_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK2m87n783lnetlstg7fulynoe3` (`door_state_definition2detail_id`),
  KEY `FKtpm08qqn25oqgtcgtt439eje8` (`negated_additional_info_id`),
  CONSTRAINT `FK2m87n783lnetlstg7fulynoe3` FOREIGN KEY (`door_state_definition2detail_id`) REFERENCES `cw_door_state_def_2_detail` (`id`),
  CONSTRAINT `FKtpm08qqn25oqgtcgtt439eje8` FOREIGN KEY (`negated_additional_info_id`) REFERENCES `cw_door_state` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_dsdef_2_det_2_neg_additional_info`
--


--
-- Table structure for table `cw_dsdef_2_det_2_neg_door_state`
--

CREATE TABLE `cw_dsdef_2_det_2_neg_door_state` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `door_state_definition2detail_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `negated_door_state_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKaoe8taa4g92ylt508mb2buwf2` (`door_state_definition2detail_id`),
  KEY `FK6jvqbmgd5bv7djgkd8nw2rd5` (`negated_door_state_id`),
  CONSTRAINT `FK6jvqbmgd5bv7djgkd8nw2rd5` FOREIGN KEY (`negated_door_state_id`) REFERENCES `cw_door_state` (`id`),
  CONSTRAINT `FKaoe8taa4g92ylt508mb2buwf2` FOREIGN KEY (`door_state_definition2detail_id`) REFERENCES `cw_door_state_def_2_detail` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_dsdef_2_det_2_neg_door_state`
--


--
-- Table structure for table `cw_email`
--

CREATE TABLE `cw_email` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `blind_carbon_copy` varchar(255) DEFAULT NULL,
  `body` longtext NOT NULL,
  `carbon_copy` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_sent` datetime DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `mailing_date` datetime NOT NULL,
  `recipient` varchar(1000) DEFAULT NULL,
  `sender` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `counter` int(11) NOT NULL,
  `mime_message_from` varchar(255) DEFAULT NULL,
  `baseemail_id` bigint(20) DEFAULT NULL,
  `smtp_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKbyejvrtp6w74rmmxe1foq893f` (`user_id`),
  KEY `FKbcqjnhon1kroft9xx8jgviytn` (`baseemail_id`),
  KEY `FK60na1hoqwj0wk2t0rhm69qjyr` (`smtp_id`),
  CONSTRAINT `FK60na1hoqwj0wk2t0rhm69qjyr` FOREIGN KEY (`smtp_id`) REFERENCES `cw_smtp` (`id`),
  CONSTRAINT `FKbcqjnhon1kroft9xx8jgviytn` FOREIGN KEY (`baseemail_id`) REFERENCES `cw_email` (`id`),
  CONSTRAINT `FKbyejvrtp6w74rmmxe1foq893f` FOREIGN KEY (`user_id`) REFERENCES `cw_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_email`
--


--
-- Table structure for table `cw_email_2_body`
--

CREATE TABLE `cw_email_2_body` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `body` longtext NOT NULL,
  `e_mail_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK2028pke4417iyrbxkp9v2uw6f` (`e_mail_id`),
  CONSTRAINT `FK2028pke4417iyrbxkp9v2uw6f` FOREIGN KEY (`e_mail_id`) REFERENCES `cw_email` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_email_2_body`
--


--
-- Table structure for table `cw_email_attachment`
--

CREATE TABLE `cw_email_attachment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `attachment_blob` longblob DEFAULT NULL,
  `e_mail_id` bigint(20) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `mime_type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK1iiutx0pl0xcqmmrjqvxmdk7d` (`e_mail_id`),
  CONSTRAINT `FK1iiutx0pl0xcqmmrjqvxmdk7d` FOREIGN KEY (`e_mail_id`) REFERENCES `cw_email` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_email_attachment`
--


--
-- Table structure for table `cw_email_attachment_2_blob`
--

CREATE TABLE `cw_email_attachment_2_blob` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `attachment_blob` longblob DEFAULT NULL,
  `e_mail_attachment_id` bigint(20) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKd6nmsmyoa4oy8rkdnrggvhjwt` (`e_mail_attachment_id`),
  CONSTRAINT `FKd6nmsmyoa4oy8rkdnrggvhjwt` FOREIGN KEY (`e_mail_attachment_id`) REFERENCES `cw_email_attachment` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_email_attachment_2_blob`
--


--
-- Table structure for table `cw_email_type`
--

CREATE TABLE `cw_email_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `additional_blind_carbon_copy` varchar(255) DEFAULT NULL,
  `additional_carbon_copy` varchar(255) DEFAULT NULL,
  `additional_recipient` varchar(255) DEFAULT NULL,
  `blind_carbon_copy` varchar(255) DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `carbon_copy` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `if_default_is_empty_blind_carbon_copy` varchar(255) DEFAULT NULL,
  `if_default_is_empty_body` longtext DEFAULT NULL,
  `if_default_is_empty_carbon_copy` varchar(255) DEFAULT NULL,
  `if_default_is_empty_recipient` varchar(255) DEFAULT NULL,
  `if_default_is_empty_sender` varchar(255) DEFAULT NULL,
  `if_default_is_empty_subject` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) NOT NULL,
  `recipient` varchar(255) DEFAULT NULL,
  `sender` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `additional_cause_person_blind_carbon_copy` bit(1) NOT NULL,
  `additional_cause_person_carbon_copy` bit(1) NOT NULL,
  `additional_cause_person_recipient` bit(1) NOT NULL,
  `additional_cause_user_blind_carbon_copy` bit(1) NOT NULL,
  `additional_cause_user_carbon_copy` bit(1) NOT NULL,
  `additional_cause_user_recipient` bit(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_email_type`
--


--
-- Table structure for table `cw_employee_function`
--

CREATE TABLE `cw_employee_function` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `function_value` 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_employee_function`
--


--
-- Table structure for table `cw_event`
--

CREATE TABLE `cw_event` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `data` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `entry` bit(1) NOT NULL,
  `event_type_id` bigint(20) DEFAULT NULL,
  `identification_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) DEFAULT NULL,
  `terminal_id` bigint(20) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `device_id` bigint(20) DEFAULT NULL,
  `synchronisation_area_id` bigint(20) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK426w81ocq4ekb8rkxnrmax1ca` (`event_type_id`),
  KEY `FKbtqt4f1ioumalexi3tqk41p0e` (`identification_id`),
  KEY `FKopakq3av1u1gbdw62fqlukcj1` (`person_id`),
  KEY `FKt2b79qdm2xki38xhxv8nnc32i` (`terminal_id`),
  KEY `FKgi6ero4fjlbpcs2q0ll4co8jj` (`device_id`),
  KEY `FKhlwsi7wd9cn1jiuiuum9rjv1c` (`synchronisation_area_id`),
  CONSTRAINT `FK426w81ocq4ekb8rkxnrmax1ca` FOREIGN KEY (`event_type_id`) REFERENCES `cw_event_type` (`id`),
  CONSTRAINT `FKbtqt4f1ioumalexi3tqk41p0e` FOREIGN KEY (`identification_id`) REFERENCES `cw_identification` (`id`),
  CONSTRAINT `FKgi6ero4fjlbpcs2q0ll4co8jj` FOREIGN KEY (`device_id`) REFERENCES `cw_device` (`id`),
  CONSTRAINT `FKhlwsi7wd9cn1jiuiuum9rjv1c` FOREIGN KEY (`synchronisation_area_id`) REFERENCES `cw_synchronisation_area` (`id`),
  CONSTRAINT `FKopakq3av1u1gbdw62fqlukcj1` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKt2b79qdm2xki38xhxv8nnc32i` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_event`
--


--
-- Table structure for table `cw_event_base_data`
--

CREATE TABLE `cw_event_base_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `communication_data_blob` longblob DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `done` bit(1) NOT NULL,
  `entry` bit(1) DEFAULT NULL,
  `event_type_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `pin_code` varchar(255) DEFAULT NULL,
  `terminal_id` bigint(20) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `input` int(11) DEFAULT NULL,
  `input_state` int(11) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `short_match` varchar(255) DEFAULT NULL,
  `counter` int(11) DEFAULT NULL,
  `device_id` bigint(20) DEFAULT NULL,
  `online_booking` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKc4uvhjvqcjs0a7avph5kgmbm7` (`event_type_id`),
  KEY `query1_idx` (`terminal_id`),
  KEY `query2_idx` (`terminal_id`,`done`),
  KEY `query3_idx` (`terminal_id`,`date`,`done`),
  KEY `query4_idx` (`terminal_id`,`short_match`),
  KEY `query5_idx` (`done`,`deleted`,`date_created`,`counter`),
  KEY `query6_idx` (`device_id`,`short_match`),
  CONSTRAINT `FK7fhgl737k4e9pfy0os61moy8s` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKc4uvhjvqcjs0a7avph5kgmbm7` FOREIGN KEY (`event_type_id`) REFERENCES `cw_event_type` (`id`),
  CONSTRAINT `FKdwk0l5fy59aqwhxkbhlcmvpq8` FOREIGN KEY (`device_id`) REFERENCES `cw_device` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_event_base_data`
--


--
-- Table structure for table `cw_event_to_action`
--

CREATE TABLE `cw_event_to_action` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `x` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_event_to_action`
--


--
-- Table structure for table `cw_event_type`
--

CREATE TABLE `cw_event_type` (
  `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,
  `event_type_enum` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=291 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_event_type`
--

INSERT INTO `cw_event_type` VALUES
(1,0,'2018-02-07 00:36:48','\0','gültiger Zutritt','VALID_ACCESS','2018-02-07 00:36:48',0),
(2,0,'2018-02-07 00:36:49','\0','ungültiger Zutritt','INVALID_ACCESS','2018-02-07 00:36:49',0),
(3,0,'2018-02-07 00:36:49','\0','ausserhalb der berechtigten Zeitzone','OUTSIDE_OF_AUTHORITY','2018-02-07 00:36:49',0),
(4,0,'2018-02-07 00:36:49','\0','falsche Authentifizierung','WRONG_AUTHENTIFICATION','2018-02-07 00:36:49',0),
(5,0,'2018-02-07 00:36:49','\0','GENERATE AES-KEY','GENERATE_AES_KEY','2018-02-07 00:36:49',0),
(6,0,'2019-02-25 18:36:50','\0','falscher PIN-Code','WRONG_PIN_CODE','2019-02-25 18:36:50',0),
(7,0,'2019-02-25 18:36:50','\0','Office aktivtiviert','ACTIVATE_OFFICE','2019-02-25 18:36:50',0),
(8,0,'2019-02-25 18:36:50','\0','Office mit Ende aktivtiviert','ACTIVATE_OFFICE_WITH_END','2019-02-25 18:36:50',0),
(9,0,'2019-02-25 18:36:50','\0','Office deaktivtiviert','DEACTIVATE_OFFICE','2019-02-25 18:36:50',0),
(10,0,'2019-02-25 18:36:51','\0','Generell-Offen aktivtiviert','ACTIVATE_GENERALLY_OPEN','2019-02-25 18:36:51',0),
(11,0,'2019-02-25 18:36:51','\0','Generell-Offen deaktivtiviert','DEACTIVATE_GENERALLY_OPEN','2019-02-25 18:36:51',0),
(12,0,'2019-02-25 18:36:51','\0','Alarmanlage aktivtiviert','ACTIVATE_ALARMSSYTEM','2019-02-25 18:36:51',0),
(13,0,'2019-02-25 18:36:51','\0','Alarmanlage deaktivtiviert','DEACTIVATE_ALARMSYSTEM','2019-02-25 18:36:51',0),
(14,0,'2019-02-25 18:36:51','\0','Kontroller startet','STARTUP','2019-02-25 18:36:51',0),
(15,0,'2019-02-25 18:36:52','\0','Eingang','INPUT_STATE','2019-02-25 18:36:52',0),
(16,0,'2019-02-25 18:36:52','\0','ungültiger Zutritt, weil Anti-Pass-Back','INVALID_ACCESS_BECAUSE_ANTI_PASS_BACK','2019-02-25 18:36:52',0),
(17,0,'2019-02-25 18:36:52','\0','ungültiger Zutritt, weil Alarmsystem ist aktiv','INVALID_ACCESS_BECAUSE_ALARMSYSTEM_IS_ACTIVE','2019-02-25 18:36:52',0),
(18,0,'2019-02-25 18:36:53','\0','Alarmsystem kann nicht aktiviert werden, weil Alarmsystem ist bereits aktiv','INVALID_ACTIVATE_ALARMSSYTEM_BECAUSE_ALARMSYSTEM_IS_ACTIVE','2019-02-25 18:36:53',0),
(19,0,'2019-02-25 18:36:53','\0','Alarmsystem kann nicht deaktiviert werden, weil Alarmsystem ist bereits deaktiviert','INVALID_DEACTIVATE_ALARMSSYTEM_BECAUSE_ALARMSYSTEM_IS_DEACTIVE','2019-02-25 18:36:53',0),
(20,0,'2021-04-02 17:54:43','\0','gültiger Zutritt','GAT_1','2021-04-02 17:54:43',0),
(21,0,'2021-04-02 17:54:44','\0','Firmenidentifikation falsch','GAT_2','2021-04-02 17:54:44',0),
(22,0,'2021-04-02 17:54:44','\0','Datenträgeridentifikation falsch','GAT_3','2021-04-02 17:54:44',0),
(23,0,'2021-04-02 17:54:44','\0','Datenträgernummer oder Datenträgerversion ungültig','GAT_4','2021-04-02 17:54:44',0),
(24,0,'2021-04-02 17:54:45','\0','PIN-Code falsch','GAT_5','2021-04-02 17:54:45',0),
(25,0,'2021-04-02 17:54:45','\0','Zutrittszeit außerhalb des Zeitplans','GAT_6','2021-04-02 17:54:45',0),
(26,0,'2021-04-02 17:54:45','\0','Zutritt ohne Berechtigung','GAT_7','2021-04-02 17:54:45',0),
(27,0,'2021-04-02 17:54:46','\0','Sommer-Winterzeitumschaltung','GAT_8','2021-04-02 17:54:46',0),
(28,0,'2021-04-02 17:54:46','\0','Statusänderung allg.Überwachung 1','GAT_9','2021-04-02 17:54:46',0),
(29,0,'2021-04-02 17:54:46','\0','Statusänderung allg.Überwachung 2','GAT_A','2021-04-02 17:54:46',0),
(30,0,'2021-04-02 17:54:47','\0','Entriegelung über Taster','GAT_B','2021-04-02 17:54:47',0),
(31,0,'2021-04-02 17:54:47','\0','1. Person für 2-Personen Zutritt','GAT_C','2021-04-02 17:54:47',0),
(32,0,'2021-04-02 17:54:47','\0','Zutrittsversuch abgewiesen, da ein 2-Personen-Zutritt ohne Meister versucht wurde','GAT_D','2021-04-02 17:54:47',0),
(33,0,'2021-04-02 17:54:48','\0','Zutrittsversuch abgewiesen da Zutrittswiederholsperre aktiv ist','GAT_E','2021-04-02 17:54:48',0),
(34,0,'2021-04-02 17:54:48','\0','Türe wurde nach Türe-zu-lange-offen-Alarm wieder geschlossen','GAT_F','2021-04-02 17:54:48',0),
(35,0,'2021-04-02 17:54:48','\0','Zutritt ohne Türöffnung','GAT_G','2021-04-02 17:54:48',0),
(36,0,'2021-04-02 17:54:49','\0','Zutritt mit Überfalls PIN-Code','GAT_H','2021-04-02 17:54:49',0),
(37,0,'2021-04-02 17:54:49','\0','Power-Up','GAT_I','2021-04-02 17:54:49',0),
(38,0,'2021-04-02 17:54:49','\0','Anti-Pass Sperre','GAT_J','2021-04-02 17:54:49',0),
(39,0,'2021-04-02 17:54:50','\0','Berechtigungszeitraum der Person nicht gültig','GAT_K','2021-04-02 17:54:50',0),
(40,0,'2021-04-02 17:54:50','\0','Peripheriegerätefehler','GAT_L','2021-04-02 17:54:50',0),
(41,0,'2021-04-02 17:54:50','\0','Tür-zu-lange-offen-Alarm','GAT_M','2021-04-02 17:54:50',0),
(42,0,'2021-04-02 17:54:51','\0','Steuerung über Kommando','GAT_N','2021-04-02 17:54:51',0),
(43,0,'2021-04-02 17:54:51','\0','Schaltrelais am Terminal betätigt','GAT_O','2021-04-02 17:54:51',0),
(44,0,'2021-04-02 17:54:51','\0','Auswahl eines Schließfachs ohne Berechtigung, Zusatzdaten enthalten die gewählte Schließfachnummer','GAT_P','2021-04-02 17:54:51',0),
(45,0,'2021-04-02 17:54:52','\0','Schließen nach Bürofunktion','GAT_Q','2021-04-02 17:54:52',0),
(46,0,'2021-04-02 17:54:52','\0','falscher Fingerabdruck','GAT_R','2021-04-02 17:54:52',0),
(47,0,'2021-04-02 17:54:52','\0','Sabotage','GAT_S','2021-04-02 17:54:52',0),
(48,0,'2021-04-02 17:54:53','\0','Unknown booking','GAT_999','2021-04-02 17:54:53',0),
(49,0,'2021-04-02 17:54:53','\0','Unlocked by identification','GAT_1000','2021-04-02 17:54:53',0),
(50,0,'2021-04-02 17:54:53','\0','Unlocked by host','GAT_1001','2021-04-02 17:54:53',0),
(51,0,'2021-04-02 17:54:54','\0','Unlocked by button 1','GAT_1002','2021-04-02 17:54:54',0),
(52,0,'2021-04-02 17:54:54','\0','Unlocked by button 2','GAT_1003','2021-04-02 17:54:54',0),
(53,0,'2021-04-02 17:54:54','\0','Locker unlocked','GAT_1004','2021-04-02 17:54:54',0),
(54,0,'2021-04-02 17:54:55','\0','Autonom mode','GAT_1010','2021-04-02 17:54:55',0),
(55,0,'2021-04-02 17:54:55','\0','Permanent unlocked by time plan','GAT_1011','2021-04-02 17:54:55',0),
(56,0,'2021-04-02 17:54:56','\0','Permanent unlocked by host','GAT_1012','2021-04-02 17:54:56',0),
(57,0,'2021-04-02 17:54:56','\0','Permanent unlocked by button 1','GAT_1013','2021-04-02 17:54:56',0),
(58,0,'2021-04-02 17:54:56','\0','Permanent unlocked by button 2','GAT_1014','2021-04-02 17:54:56',0),
(59,0,'2021-04-02 17:54:57','\0','Permanent locked by host','GAT_1020','2021-04-02 17:54:57',0),
(60,0,'2021-04-02 17:54:57','\0','Permanent locked by button','GAT_1021','2021-04-02 17:54:57',0),
(61,0,'2021-04-02 17:54:57','\0','Permanent locked by alarm system','GAT_1022','2021-04-02 17:54:57',0),
(62,0,'2021-04-02 17:54:58','\0','General open suppressed','GAT_1023','2021-04-02 17:54:58',0),
(63,0,'2021-04-02 17:54:58','\0','Alarm system turned on','GAT_1030','2021-04-02 17:54:58',0),
(64,0,'2021-04-02 17:54:58','\0','Alarm system turned off','GAT_1031','2021-04-02 17:54:58',0),
(65,0,'2021-04-02 17:54:59','\0','Door closed after door too long open alarm','GAT_1040','2021-04-02 17:54:59',0),
(66,0,'2021-04-02 17:54:59','\0','Door locked after office function','GAT_1041','2021-04-02 17:54:59',0),
(67,0,'2021-04-02 17:54:59','\0','User defined input 1triggered -RFU','GAT_1050','2021-04-02 17:54:59',0),
(68,0,'2021-04-02 17:55:00','\0','User defined input 2triggered -RFU','GAT_1051','2021-04-02 17:55:00',0),
(69,0,'2021-04-02 17:55:00','\0','Access/Exit after ident(Door opened, was open or no contact)','GAT_1100','2021-04-02 17:55:00',0),
(70,0,'2021-04-02 17:55:00','\0','Access/Exit afterhost/button(Door opened, was open or no contact)','GAT_1101','2021-04-02 17:55:00',0),
(71,0,'2021-04-02 17:55:01','\0','Arrive','GAT_1110','2021-04-02 17:55:01',0),
(72,0,'2021-04-02 17:55:01','\0','Leave','GAT_1111','2021-04-02 17:55:01',0),
(73,0,'2021-04-02 17:55:01','\0','Leave with reason 1','GAT_1112','2021-04-02 17:55:01',0),
(74,0,'2021-04-02 17:55:02','\0','Leave with reason 2','GAT_1113','2021-04-02 17:55:02',0),
(75,0,'2021-04-02 17:55:02','\0','Leave with reason 3','GAT_1114','2021-04-02 17:55:02',0),
(76,0,'2021-04-02 17:55:02','\0','Unknown card','GAT_1200','2021-04-02 17:55:02',0),
(77,0,'2021-04-02 17:55:03','\0','Invalid card type','GAT_1201','2021-04-02 17:55:03',0),
(78,0,'2021-04-02 17:55:03','\0','Invalid card time period','GAT_1202','2021-04-02 17:55:03',0),
(79,0,'2021-04-02 17:55:03','\0','Invalid company id','GAT_1203','2021-04-02 17:55:03',0),
(80,0,'2021-04-02 17:55:04','\0','Unknown finger print','GAT_1204','2021-04-02 17:55:04',0),
(81,0,'2021-04-02 17:55:04','\0','Unknown personal no .','GAT_1205','2021-04-02 17:55:04',0),
(82,0,'2021-04-02 17:55:04','\0','Invalid identificationmedia','GAT_1206','2021-04-02 17:55:04',0),
(83,0,'2021-04-02 17:55:05','\0','Invalid card version','GAT_1207','2021-04-02 17:55:05',0),
(84,0,'2021-04-02 17:55:05','\0','Unknown person','GAT_1210','2021-04-02 17:55:05',0),
(85,0,'2021-04-02 17:55:05','\0','Invalid person time period','GAT_1211','2021-04-02 17:55:05',0),
(86,0,'2021-04-02 17:55:06','\0','No access right data','GAT_1212','2021-04-02 17:55:06',0),
(87,0,'2021-04-02 17:55:06','\0','Invalid access right time period','GAT_1213','2021-04-02 17:55:06',0),
(88,0,'2021-04-02 17:55:06','\0','Alarm system turn denied','GAT_1214','2021-04-02 17:55:06',0),
(89,0,'2021-04-02 17:55:07','\0','No second person access right','GAT_1215','2021-04-02 17:55:07',0),
(90,0,'2021-04-02 17:55:07','\0','Person on balck list','GAT_1216','2021-04-02 17:55:07',0),
(91,0,'2021-04-02 17:55:07','\0','No special days loaded','GAT_1217','2021-04-02 17:55:07',0),
(92,0,'2021-04-02 17:55:08','\0','No verification data','GAT_1220','2021-04-02 17:55:08',0),
(93,0,'2021-04-02 17:55:08','\0','Verification timeout','GAT_1221','2021-04-02 17:55:08',0),
(94,0,'2021-04-02 17:55:08','\0','Invalid pin code','GAT_1222','2021-04-02 17:55:08',0),
(95,0,'2021-04-02 17:55:09','\0','Invalid finger print','GAT_1223','2021-04-02 17:55:09',0),
(96,0,'2021-04-02 17:55:09','\0','Invalid locker number','GAT_1224','2021-04-02 17:55:09',0),
(97,0,'2021-04-02 17:55:09','\0','Anti pass back barrier','GAT_1230','2021-04-02 17:55:09',0),
(98,0,'2021-04-02 17:55:10','\0','Double bookingbarrier','GAT_1231','2021-04-02 17:55:10',0),
(99,0,'2021-04-02 17:55:10','\0','Pool management barrier','GAT_1232','2021-04-02 17:55:10',0),
(100,0,'2021-04-02 17:55:11','\0','Manipulation barrier','GAT_1233','2021-04-02 17:55:11',0),
(101,0,'2021-04-02 17:55:11','\0','Alarm system on barrier','GAT_1234','2021-04-02 17:55:11',0),
(102,0,'2021-04-02 17:55:11','\0','Anti pass back barrier ignored','GAT_1235','2021-04-02 17:55:11',0),
(103,0,'2021-04-02 17:55:12','\0','Double booking barrier ignored','GAT_1236','2021-04-02 17:55:12',0),
(104,0,'2021-04-02 17:55:12','\0','Pool management barrier ignored','GAT_1237','2021-04-02 17:55:12',0),
(105,0,'2021-04-02 17:55:12','\0','CardNET data successfully written','GAT_1300','2021-04-02 17:55:12',0),
(106,0,'2021-04-02 17:55:13','\0','CardNET data erased','GAT_1301','2021-04-02 17:55:13',0),
(107,0,'2021-04-02 17:55:13','\0','CardNET data write error','GAT_1310','2021-04-02 17:55:13',0),
(108,0,'2021-04-02 17:55:13','\0','CardNET data read error','GAT_1311','2021-04-02 17:55:13',0),
(109,0,'2021-04-02 17:55:14','\0','CardNET data CRC error','GAT_1312','2021-04-02 17:55:14',0),
(110,0,'2021-04-02 17:55:14','\0','CardNET authorization error','GAT_1313','2021-04-02 17:55:14',0),
(111,0,'2021-04-02 17:55:14','\0','CardNET data undersized','GAT_1314','2021-04-02 17:55:14',0),
(112,0,'2021-04-02 17:55:15','\0','CardNET battery warning','GAT_1320','2021-04-02 17:55:15',0),
(113,0,'2021-04-02 17:55:15','\0','Card data write error','GAT_1330','2021-04-02 17:55:15',0),
(114,0,'2021-04-02 17:55:15','\0','Card data read error','GAT_1331','2021-04-02 17:55:15',0),
(115,0,'2021-04-02 17:55:16','\0','Card data CRC error','GAT_1332','2021-04-02 17:55:16',0),
(116,0,'2021-04-02 17:55:16','\0','Card authorization error','GAT_1333','2021-04-02 17:55:16',0),
(117,0,'2021-04-02 17:55:16','\0','Card data certificate error','GAT_1334','2021-04-02 17:55:16',0),
(118,0,'2021-04-02 17:55:17','\0','WiNET data successfully loaded','GAT_1400','2021-04-02 17:55:17',0),
(119,0,'2021-04-02 17:55:17','\0','Power up','GAT_2000','2021-04-02 17:55:17',0),
(120,0,'2021-04-02 17:55:17','\0','Date/Time changed','GAT_2010','2021-04-02 17:55:17',0),
(121,0,'2021-04-02 17:55:18','\0','Date/Time invalid','GAT_2011','2021-04-02 17:55:18',0),
(122,0,'2021-04-02 17:55:18','\0','SNTP server not available','GAT_2012','2021-04-02 17:55:18',0),
(123,0,'2021-04-02 17:55:18','\0','No SD-Card?','GAT_2020','2021-04-02 17:55:18',0),
(124,0,'2021-04-02 17:55:19','\0','SD-Card error','GAT_2021','2021-04-02 17:55:19',0),
(125,0,'2021-04-02 17:55:19','\0','Out of memory(FLASH)','GAT_2022','2021-04-02 17:55:19',0),
(126,0,'2021-04-02 17:55:19','\0','Firmware update successful','GAT_2030','2021-04-02 17:55:19',0),
(127,0,'2021-04-02 17:55:20','\0','Firmware update failed','GAT_2031','2021-04-02 17:55:20',0),
(128,0,'2021-04-02 17:55:20','\0','Factory reset','GAT_2040','2021-04-02 17:55:20',0),
(129,0,'2021-04-02 17:55:20','\0','Configuration invalid','GAT_2041','2021-04-02 17:55:20',0),
(130,0,'2021-04-02 17:55:21','\0','Configuration imported','GAT_2042','2021-04-02 17:55:21',0),
(131,0,'2021-04-02 17:55:21','\0','Configuration exported','GAT_2043','2021-04-02 17:55:21',0),
(132,0,'2021-04-02 17:55:21','\0','Database invalid','GAT_2050','2021-04-02 17:55:21',0),
(133,0,'2021-04-02 17:55:22','\0','Database erased','GAT_2051','2021-04-02 17:55:22',0),
(134,0,'2021-04-02 17:55:22','\0','Database import successful','GAT_2052','2021-04-02 17:55:22',0),
(135,0,'2021-04-02 17:55:22','\0','Database import failed','GAT_2053','2021-04-02 17:55:22',0),
(136,0,'2021-04-02 17:55:23','\0','Database exported','GAT_2054','2021-04-02 17:55:23',0),
(137,0,'2021-04-02 17:55:23','\0','Manipulation alarm','GAT_2100','2021-04-02 17:55:23',0),
(138,0,'2021-04-02 17:55:23','\0','Break-in alarm','GAT_2101','2021-04-02 17:55:23',0),
(139,0,'2021-04-02 17:55:24','\0','Threatening alarm','GAT_2102','2021-04-02 17:55:24',0),
(140,0,'2021-04-02 17:55:24','\0','Door too long open alarm','GAT_2103','2021-04-02 17:55:24',0),
(141,0,'2021-04-02 17:55:24','\0','Quit manipulation alarm','GAT_2110','2021-04-02 17:55:24',0),
(142,0,'2021-04-02 17:55:25','\0','Quit break- in alarm','GAT_2111','2021-04-02 17:55:25',0),
(143,0,'2021-04-02 17:55:25','\0','Quit threatening alarm','GAT_2112','2021-04-02 17:55:25',0),
(144,0,'2021-04-02 17:55:25','\0','Quit door too long open alarm','GAT_2113','2021-04-02 17:55:25',0),
(145,0,'2021-04-02 17:55:26','\0','Special data carrier used','GAT_2120','2021-04-02 17:55:26',0),
(146,0,'2021-04-02 17:55:26','\0','Battery warning 1(< 1000)','GAT_2130','2021-04-02 17:55:26',0),
(147,0,'2021-04-02 17:55:26','\0','Battery warning 2(< 100)','GAT_2131','2021-04-02 17:55:26',0),
(148,0,'2021-04-02 17:55:27','\0','Battery changed','GAT_2132','2021-04-02 17:55:27',0),
(149,0,'2021-04-02 17:55:27','\0','Reader connected','GAT_2300','2021-04-02 17:55:27',0),
(150,0,'2021-04-02 17:55:27','\0','Access point connected','GAT_2301','2021-04-02 17:55:27',0),
(151,0,'2021-04-02 17:55:28','\0','IO Expander connected','GAT_2302','2021-04-02 17:55:28',0),
(152,0,'2021-04-02 17:55:28','\0','Reader disconnected','GAT_2310','2021-04-02 17:55:28',0),
(153,0,'2021-04-02 17:55:28','\0','Access point disconnected','GAT_2311','2021-04-02 17:55:28',0),
(154,0,'2021-04-02 17:55:29','\0','IO Expander disconnected','GAT_2312','2021-04-02 17:55:29',0),
(155,0,'2021-04-02 17:55:29','\0','Fingerprint unit error','GAT_2313','2021-04-02 17:55:29',0),
(156,0,'2021-04-02 17:55:29','\0','Fingerprint unit error resolved','GAT_2314','2021-04-02 17:55:29',0),
(157,0,'2021-04-02 17:55:30','\0','Fingerprint unit out of memory','GAT_2315','2021-04-02 17:55:30',0),
(158,0,'2021-04-02 17:55:30','\0','Power turned off','GAT_2320','2021-04-02 17:55:30',0),
(159,0,'2021-04-02 17:55:30','\0','Power turned on','GAT_2321','2021-04-02 17:55:30',0),
(160,0,'2021-04-02 17:55:31','\0','Short detected','GAT_2322','2021-04-02 17:55:31',0),
(161,0,'2021-04-02 17:55:31','\0','Sub device factory reset','GAT_2323','2021-04-02 17:55:31',0),
(162,0,'2021-04-02 17:55:32','\0','Sub device date/time set','GAT_2324','2021-04-02 17:55:32',0),
(163,0,'2021-04-02 17:55:32','\0','Sub device power up','GAT_2325','2021-04-02 17:55:32',0),
(164,0,'2021-04-02 17:55:32','\0','Reader firmware update successful','GAT_2330','2021-04-02 17:55:32',0),
(165,0,'2021-04-02 17:55:33','\0','Reader firmware update failed','GAT_2331','2021-04-02 17:55:33',0),
(166,0,'2021-04-02 17:55:33','\0','Mode changed','GAT_2340','2021-04-02 17:55:33',0),
(167,0,'2021-04-02 17:55:33','\0','User card list changed','GAT_2341','2021-04-02 17:55:33',0),
(168,0,'2021-04-02 17:55:34','\0','Black list changed','GAT_2342','2021-04-02 17:55:34',0),
(169,0,'2021-04-02 17:55:34','\0','Used data carrier added with programming card','GAT_2343','2021-04-02 17:55:34',0),
(170,0,'2021-04-02 17:55:34','\0','Used data carrier deleted with deleting card','GAT_2344','2021-04-02 17:55:34',0),
(171,0,'2021-04-02 17:55:35','\0','All user data carrier deleted with deleting card','GAT_2345','2021-04-02 17:55:35',0),
(172,0,'2021-04-02 17:55:35','\0','Start pairing','GAT_2350','2021-04-02 17:55:35',0),
(173,0,'2021-04-02 17:55:35','\0','Pairing failed','GAT_2351','2021-04-02 17:55:35',0),
(174,0,'2021-04-02 17:55:36','\0','Invalid pairing data','GAT_2352','2021-04-02 17:55:36',0),
(175,0,'2021-04-02 17:55:36','\0','Wireless lock connected','GAT_2353','2021-04-02 17:55:36',0),
(176,0,'2021-04-02 17:55:36','\0','Wireless lock disconnected','GAT_2354','2021-04-02 17:55:36',0),
(177,0,'2021-04-02 17:55:37','\0','WiNET Panic started','GAT_2400','2021-04-02 17:55:37',0),
(178,0,'2021-04-02 17:55:37','\0','WiNET Panic resolved','GAT_2401','2021-04-02 17:55:37',0),
(179,0,'2021-04-02 17:55:37','\0','WiNET Card used','GAT_2402','2021-04-02 17:55:37',0),
(180,0,'2021-12-25 22:55:24','\0','Software: Anwesenheitsstatus auf unbekannt','SW_SET_PRESENCE_STATE_TO_UNKNOWN','2021-12-25 22:55:24',0),
(181,0,'2021-12-25 22:55:25','\0','Software: Anwesenheitsstatus auf Eintritt','SW_SET_PRESENCE_STATE_TO_ENTRY','2021-12-25 22:55:25',0),
(182,0,'2021-12-25 22:55:25','\0','Software: Anwesenheitsstatus auf Austritt','SW_SET_PRESENCE_STATE_TO_EXIT','2021-12-25 22:55:25',0),
(183,0,'2022-11-05 13:43:09','\0','Modul erkannt, alles OK.','DATAFOX_0','2022-11-05 13:43:09',0),
(184,0,'2022-11-05 13:43:10','\0','Modul in der Liste nicht definiert, aber im Bus gefunden.','DATAFOX_3','2022-11-05 13:43:10',0),
(185,0,'2022-11-05 13:43:10','\0','Modul in der Liste, aber nicht im Bus gefunden.','DATAFOX_4','2022-11-05 13:43:10',0),
(186,0,'2022-11-05 13:43:11','\0','Falsches Verschlüsselungspasswort.','DATAFOX_5','2022-11-05 13:43:11',0),
(187,0,'2022-11-05 13:43:11','\0','Login-Passwort falsch.','DATAFOX_6','2022-11-05 13:43:11',0),
(188,0,'2022-11-05 13:43:11','\0','Lesertyp (Mifare, Legic, Unique, etc.) falsch.','DATAFOX_7','2022-11-05 13:43:11',0),
(189,0,'2022-11-05 13:43:12','\0','Fehler beim Konfigurieren des Moduls.','DATAFOX_8','2022-11-05 13:43:12',0),
(190,0,'2022-11-05 13:43:12','\0','Modul weder im Bus noch in der Liste gefunden.','DATAFOX_9','2022-11-05 13:43:12',0),
(191,0,'2022-11-05 13:43:13','\0','Der Kommunikationsschlüssel für das PHG-Crypt-Protokoll wurde geändert.','DATAFOX_10','2022-11-05 13:43:13',0),
(192,0,'2022-11-05 13:43:13','\0','Der Kommunikationsschlüssel für das PHG-Crypt-Protokoll wurde nicht geändert.','DATAFOX_11','2022-11-05 13:43:13',0),
(193,0,'2022-11-05 13:43:13','\0','Batteriezustand der Funkschließzylinder in Phase 0 (voll)','DATAFOX_12','2022-11-05 13:43:13',0),
(194,0,'2022-11-05 13:43:14','\0','Batteriezustand der Funkschließzylinder in Phase 1','DATAFOX_13','2022-11-05 13:43:14',0),
(195,0,'2022-11-05 13:43:14','\0','Batteriezustand der Funkschließzylinder in Phase 2','DATAFOX_14','2022-11-05 13:43:14',0),
(196,0,'2022-11-05 13:43:15','\0','Batteriezustand der Funkschließzylinder in Phase 3 (leer)','DATAFOX_15','2022-11-05 13:43:15',0),
(197,0,'2022-11-05 13:43:15','\0','Funkschließzylinder in Batteriewechselmodus gesetzt','DATAFOX_16','2022-11-05 13:43:15',0),
(198,0,'2022-11-05 13:43:16','\0','Modul hat ein Update erhalten gilt für EVO Agera (ehem. EVO-Plus-Leser)','DATAFOX_17','2022-11-05 13:43:16',0),
(199,0,'2022-11-05 13:43:16','\0','Modul hat ein Neustart nach Update durchgeführt','DATAFOX_18','2022-11-05 13:43:16',0),
(200,0,'2022-11-05 13:43:16','\0','Ausweis korrekt, Zutritt gestattet.','DATAFOX_20','2022-11-05 13:43:16',0),
(201,0,'2022-11-05 13:43:17','\0','Ausweis nicht in der Liste Identification.','DATAFOX_21','2022-11-05 13:43:17',0),
(202,0,'2022-11-05 13:43:17','\0','ActiveGeneral passt nicht / gesperrter Ausweis','DATAFOX_22','2022-11-05 13:43:17',0),
(203,0,'2022-11-05 13:43:18','\0','Gültigkeitszeitraum passt nicht. Zeitraum in der Identification abgelaufen oder noch nicht begonnen.','DATAFOX_23','2022-11-05 13:43:18',0),
(204,0,'2022-11-05 13:43:18','\0','Keinen passenden Raum gefunden. In der Reader angegebene Raum fehlt in Location oder die Gruppe darf nicht in diesen Raum.','DATAFOX_24','2022-11-05 13:43:18',0),
(205,0,'2022-11-05 13:43:18','\0','Keinen passenden Zeitbereich gefunden. Das in der Location angegebene Zeitmodell existiert nicht oder ist = 0.','DATAFOX_25','2022-11-05 13:43:18',0),
(206,0,'2022-11-05 13:43:19','\0','Warte auf eine Pin-Eingabe.','DATAFOX_26','2022-11-05 13:43:19',0),
(207,0,'2022-11-05 13:43:19','\0','Pin falsch.','DATAFOX_27','2022-11-05 13:43:19',0),
(208,0,'2022-11-05 13:43:20','\0','Bedrohungscode wurde eingegeben.','DATAFOX_28','2022-11-05 13:43:20',0),
(209,0,'2022-11-05 13:43:20','\0','Die PIN ist korrekt, Zutritt gestattet.','DATAFOX_29','2022-11-05 13:43:20',0),
(210,0,'2022-11-05 13:43:20','\0','Die Master-PIN wurde eingegeben, Zutritt gestattet.','DATAFOX_30','2022-11-05 13:43:20',0),
(211,0,'2022-11-05 13:43:21','\0','PIN-Timeout wurde erreicht.','DATAFOX_31','2022-11-05 13:43:21',0),
(212,0,'2022-11-05 13:43:21','\0','Master-Ausweis korrekt, Zutritt gestattet.','DATAFOX_32','2022-11-05 13:43:21',0),
(213,0,'2022-11-05 13:43:22','\0','NUR-PIN-Eingabe ist korrekt, Zutritt gestattet.','DATAFOX_33','2022-11-05 13:43:22',0),
(214,0,'2022-11-05 13:43:22','\0','Online-TP.','DATAFOX_34','2022-11-05 13:43:22',0),
(215,0,'2022-11-05 13:43:23','\0','Online-PIN.','DATAFOX_35','2022-11-05 13:43:23',0),
(216,0,'2022-11-05 13:43:23','\0','Schließung durchgeführt','DATAFOX_36','2022-11-05 13:43:23',0),
(217,0,'2022-11-05 13:43:23','\0','Freier Zutritt am Leser','DATAFOX_37','2022-11-05 13:43:23',0),
(218,0,'2022-11-05 13:43:24','\0','Zutritt am Leser gesperrt / Leser blockiert /dauerhaft zu','DATAFOX_38','2022-11-05 13:43:24',0),
(219,0,'2022-11-05 13:43:24','\0','Online-Ergebnis des Servers: Kein Zutritt gewährt','DATAFOX_39','2022-11-05 13:43:24',0),
(220,0,'2022-11-05 13:43:25','\0','Digitaler Ausgang 1 ist Low (Aus).','DATAFOX_40','2022-11-05 13:43:25',0),
(221,0,'2022-11-05 13:43:25','\0','Digitaler Ausgang 1 auf HIGH.(An).','DATAFOX_41','2022-11-05 13:43:25',0),
(222,0,'2022-11-05 13:43:25','\0','Digitaler Ausgang 1 für die Dauer ELAPSE auf HIGH.','DATAFOX_42','2022-11-05 13:43:25',0),
(223,0,'2022-11-05 13:43:26','\0','Digitaler Ausgang 2 ist Low (Aus).','DATAFOX_43','2022-11-05 13:43:26',0),
(224,0,'2022-11-05 13:43:26','\0','Digitaler Ausgang 2 auf HIGH.(An).','DATAFOX_44','2022-11-05 13:43:26',0),
(225,0,'2022-11-05 13:43:27','\0','Digitaler Ausgang 2 für die Dauer ELAPSE auf HIGH.','DATAFOX_45','2022-11-05 13:43:27',0),
(226,0,'2022-11-05 13:43:27','\0','Digitaler Ausgang 3 ist Low (Aus).','DATAFOX_46','2022-11-05 13:43:27',0),
(227,0,'2022-11-05 13:43:28','\0','Digitaler Ausgang 3 auf HIGH.(An).','DATAFOX_47','2022-11-05 13:43:28',0),
(228,0,'2022-11-05 13:43:28','\0','Digitaler Ausgang 3 für die Dauer ELAPSE auf HIGH.','DATAFOX_48','2022-11-05 13:43:28',0),
(229,0,'2022-11-05 13:43:28','\0','Digitaler Ausgang 4 ist Low (Aus).','DATAFOX_49','2022-11-05 13:43:28',0),
(230,0,'2022-11-05 13:43:29','\0','Digitaler Ausgang 4 auf HIGH.(An).','DATAFOX_50','2022-11-05 13:43:29',0),
(231,0,'2022-11-05 13:43:29','\0','Digitaler Ausgang 4 für die Dauer ELAPSE auf HIGH','DATAFOX_51','2022-11-05 13:43:29',0),
(232,0,'2022-11-05 13:43:30','\0','Online: Ausweis korrekt, Zutritt gestattet.','DATAFOX_10020','2022-11-05 13:43:30',0),
(233,0,'2022-11-05 13:43:30','\0','Online: Ausweis nicht in der Liste Identification.','DATAFOX_10021','2022-11-05 13:43:30',0),
(234,0,'2022-11-05 13:43:31','\0','Online: ActiveGeneral passt nicht / gesperrter Ausweis.','DATAFOX_10022','2022-11-05 13:43:31',0),
(235,0,'2022-11-05 13:43:31','\0','Online: Gültigkeitszeitraum passt nicht. Zeitraum in der Identification abgelaufen oder noch nicht begonnen.','DATAFOX_10023','2022-11-05 13:43:31',0),
(236,0,'2022-11-05 13:43:31','\0','Online: AntiPassBack - Zutritt verweigert.','DATAFOX_20001','2022-11-05 13:43:31',0),
(237,0,'2024-11-24 13:31:15','\0','Alarm Eingang 1','DATAFOX_80','2024-11-24 13:31:15',0),
(238,0,'2024-11-24 13:31:15','\0','Alarm Eingang 2','DATAFOX_81','2024-11-24 13:31:15',0),
(239,0,'2024-11-24 13:31:15','\0','Alarm Eingang 3','DATAFOX_82','2024-11-24 13:31:15',0),
(240,0,'2024-11-24 13:31:15','\0','Alarm Eingang 4','DATAFOX_83','2024-11-24 13:31:15',0),
(241,0,'2024-11-24 13:31:15','\0','Alarm Eingang 5','DATAFOX_84','2024-11-24 13:31:15',0),
(242,0,'2024-11-24 13:31:15','\0','Alarm Eingang 6','DATAFOX_85','2024-11-24 13:31:15',0),
(243,0,'2024-11-24 13:31:15','\0','Alarm Eingang 7','DATAFOX_220','2024-11-24 13:31:15',0),
(244,0,'2024-11-24 13:31:15','\0','Alarm Eingang 8','DATAFOX_221','2024-11-24 13:31:15',0),
(245,0,'2024-11-24 13:31:15','\0','Alarm Eingang 9','DATAFOX_222','2024-11-24 13:31:15',0),
(246,0,'2024-11-24 13:31:15','\0','Alarm Eingang 10','DATAFOX_223','2024-11-24 13:31:15',0),
(247,0,'2024-11-24 13:31:15','\0','Alarm Eingang 11','DATAFOX_224','2024-11-24 13:31:15',0),
(248,0,'2024-11-24 13:31:15','\0','Alarm Eingang 12','DATAFOX_225','2024-11-24 13:31:15',0),
(249,0,'2024-11-24 13:31:15','\0','Alarm Eingang 13','DATAFOX_226','2024-11-24 13:31:15',0),
(250,0,'2024-11-24 13:31:16','\0','Alarm Eingang 14','DATAFOX_227','2024-11-24 13:31:16',0),
(251,0,'2024-11-24 13:31:16','\0','Alarm Eingang 15','DATAFOX_228','2024-11-24 13:31:16',0),
(252,0,'2024-11-24 13:31:16','\0','Alarm Eingang 16','DATAFOX_229','2024-11-24 13:31:16',0),
(253,0,'2024-11-24 13:31:16','\0','Alarm Eingang 17','DATAFOX_230','2024-11-24 13:31:16',0),
(254,0,'2024-11-24 13:31:16','\0','Alarm Eingang 18','DATAFOX_231','2024-11-24 13:31:16',0),
(255,0,'2024-11-24 13:31:16','\0','Alarm Eingang 19','DATAFOX_232','2024-11-24 13:31:16',0),
(256,0,'2024-11-24 13:31:16','\0','Alarm Eingang 20','DATAFOX_233','2024-11-24 13:31:16',0),
(257,0,'2024-11-24 13:31:16','\0','Alarm Eingang 21','DATAFOX_234','2024-11-24 13:31:16',0),
(258,0,'2024-11-24 13:31:16','\0','Alarm Eingang 22','DATAFOX_235','2024-11-24 13:31:16',0),
(259,0,'2024-11-24 13:31:16','\0','Alarm Eingang 23','DATAFOX_236','2024-11-24 13:31:16',0),
(260,0,'2024-11-24 13:31:16','\0','Alarm Eingang 24','DATAFOX_237','2024-11-24 13:31:16',0),
(261,0,'2024-11-24 13:31:16','\0','Alarm Eingang 25','DATAFOX_238','2024-11-24 13:31:16',0),
(262,0,'2024-11-24 13:31:16','\0','Alarm Eingang 26','DATAFOX_239','2024-11-24 13:31:16',0),
(263,0,'2024-11-24 13:31:16','\0','Alarm Eingang 27','DATAFOX_240','2024-11-24 13:31:16',0),
(264,0,'2024-11-24 13:31:16','\0','Alarm Eingang 28','DATAFOX_241','2024-11-24 13:31:16',0),
(265,0,'2024-11-24 13:31:16','\0','Alarm Eingang 29','DATAFOX_242','2024-11-24 13:31:16',0),
(266,0,'2024-11-24 13:31:16','\0','Alarm Eingang 30','DATAFOX_243','2024-11-24 13:31:16',0),
(267,0,'2024-11-24 13:31:16','\0','Alarm Eingang 31','DATAFOX_244','2024-11-24 13:31:16',0),
(268,0,'2024-11-24 13:31:17','\0','Alarm Eingang 32','DATAFOX_245','2024-11-24 13:31:17',0),
(269,0,'2024-11-24 13:31:17','\0','Anti-passback HARD (Kein doppelter Zutritt!)','DATAFOX_250','2024-11-24 13:31:17',0),
(270,0,'2024-11-24 13:31:17','\0','Anti-passback SOFT (nur für angegeben Zeit)','DATAFOX_251','2024-11-24 13:31:17',0),
(271,0,'2024-11-24 13:31:17','\0','Nach einer EMA-Buchung an einem entsprechend konfigurierten PIN-Leser wird auf die Identifizierung (Transponder + ggf. Pin) gewartet.','DATAFOX_258','2024-11-24 13:31:17',0),
(272,0,'2024-11-24 13:31:17','\0','Nach einer EMA-Buchung wurde nicht innerhalb von fünf Sekunden ein Ausweis vor den Leser gehalten, um die Buchung zu legitimieren.','DATAFOX_259','2024-11-24 13:31:17',0),
(273,0,'2024-11-24 13:31:17','\0','Der vorgehaltene Ausweis zur Legitimation der EMA-Buchung ist nicht zugelassen.','DATAFOX_260','2024-11-24 13:31:17',0),
(274,0,'2024-11-24 13:31:17','\0','Der eingegebene EMA-Bereich ist nicht richtig konfiguriert worden.','DATAFOX_261','2024-11-24 13:31:17',0),
(275,0,'2024-11-24 13:31:17','\0','Während einer Scharf- oder Unscharfschaltung eines EMA-Bereiches ist für diesen Bereich keine weitere EMA-Aktion möglich.','DATAFOX_262','2024-11-24 13:31:17',0),
(276,0,'2024-11-24 13:31:17','\0','Die EMA zur Scharfschaltung bereit.','DATAFOX_263','2024-11-24 13:31:17',0),
(277,0,'2024-11-24 13:31:17','\0','Die EMA nicht zur Scharfschaltung bereit.','DATAFOX_264','2024-11-24 13:31:17',0),
(278,0,'2024-11-24 13:31:17','\0','Per Steuersignal (Relais) wird einem EMA-Bereich mitgeteilt, dass er scharf schalten soll.','DATAFOX_265','2024-11-24 13:31:17',0),
(279,0,'2024-11-24 13:31:17','\0','Per Steuersignal (Relais) wird einem EMA-Bereich mitgeteilt, dass er unscharf schalten soll.','DATAFOX_266','2024-11-24 13:31:17',0),
(280,0,'2024-11-24 13:31:17','\0','Der scharf zu schaltende EMA-Bereich ist bereits scharf geschaltet.','DATAFOX_267','2024-11-24 13:31:17',0),
(281,0,'2024-11-24 13:31:17','\0','Der unscharf zu schaltende EMA-Bereich ist bereits unscharf geschaltet.','DATAFOX_268','2024-11-24 13:31:17',0),
(282,0,'2024-11-24 13:31:17','\0','Der EMA-Bereich ist jetzt scharf.','DATAFOX_269','2024-11-24 13:31:17',0),
(283,0,'2024-11-24 13:31:17','\0','Der EMA-Bereich ist jetzt unscharf.','DATAFOX_270','2024-11-24 13:31:17',0),
(284,0,'2024-11-24 13:31:17','\0','Der EMA-Bereich konnte innerhalb von fünf Sekunden nicht scharf geschaltet werden.','DATAFOX_271','2024-11-24 13:31:17',0),
(285,0,'2024-11-24 13:31:17','\0','Der EMA-Bereich konnte innerhalb von fünf Sekunden nicht unscharf geschaltet werden.','DATAFOX_272','2024-11-24 13:31:17',0),
(286,0,'2024-11-24 13:31:18','\0','Die Zutrittsbuchung wird wegen eines scharf geschalteten EMA-Bereiches abgewiesen.','DATAFOX_273','2024-11-24 13:31:18',0),
(287,0,'2024-11-24 13:31:18','\0','Bei der Identifizierung wird zusätzlich eine PIN benötigt.','DATAFOX_274','2024-11-24 13:31:18',0),
(288,0,'2024-11-24 13:31:18','\0','Die eingegebene PIN passt nicht zu der hinterlegten.','DATAFOX_275','2024-11-24 13:31:18',0),
(289,0,'2024-11-24 13:31:18','\0','Die eingegebene PIN passt zu der hinterlegten.','DATAFOX_276','2024-11-24 13:31:18',0),
(290,0,'2024-11-24 13:31:18','\0','Timeout bei der Pin-Eingabe','DATAFOX_277','2024-11-24 13:31:18',0);

--
-- Table structure for table `cw_event_type_2_terminal_type`
--

CREATE TABLE `cw_event_type_2_terminal_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `event_type_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `terminal_type_id` bigint(20) NOT NULL,
  `type` varchar(255) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK1ma7gwvfxwhyrta6287twgo2v` (`event_type_id`),
  KEY `FK7qttcf09sjox678hksgkojnip` (`terminal_type_id`),
  CONSTRAINT `FK1ma7gwvfxwhyrta6287twgo2v` FOREIGN KEY (`event_type_id`) REFERENCES `cw_event_type` (`id`),
  CONSTRAINT `FK7qttcf09sjox678hksgkojnip` FOREIGN KEY (`terminal_type_id`) REFERENCES `cw_terminal_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_event_type_2_terminal_type`
--

INSERT INTO `cw_event_type_2_terminal_type` VALUES
(1,0,'2018-02-07 00:36:50','\0',1,'2018-02-07 00:36:50',1,'1',0),
(2,0,'2018-02-07 00:36:51','\0',2,'2018-02-07 00:36:51',1,'6',0),
(3,0,'2018-02-07 00:36:52','\0',3,'2018-02-07 00:36:52',1,'8',0),
(4,0,'2019-02-25 18:36:54','\0',1,'2019-02-25 18:36:54',1,'VALID_ACCESS',0),
(5,0,'2019-02-25 18:36:54','\0',2,'2019-02-25 18:36:54',1,'INVALID_ACCESS',0),
(6,0,'2019-02-25 18:36:55','\0',3,'2019-02-25 18:36:55',1,'OUTSIDE_OF_AUTHORITY',0),
(7,0,'2019-02-25 18:36:56','\0',4,'2019-02-25 18:36:56',1,'WRONG_AUTHENTIFICATION',0),
(8,0,'2019-02-25 18:36:57','\0',5,'2019-02-25 18:36:57',1,'GENERATE_AES_KEY',0),
(9,0,'2019-02-25 18:36:57','\0',6,'2019-02-25 18:36:57',1,'WRONG_PIN_CODE',0),
(10,0,'2019-02-25 18:36:58','\0',7,'2019-02-25 18:36:58',1,'ACTIVATE_OFFICE',0),
(11,0,'2019-02-25 18:36:59','\0',8,'2019-02-25 18:36:59',1,'ACTIVATE_OFFICE_WITH_END',0),
(12,0,'2019-02-25 18:37:00','\0',9,'2019-02-25 18:37:00',1,'DEACTIVATE_OFFICE',0),
(13,0,'2019-02-25 18:37:00','\0',10,'2019-02-25 18:37:00',1,'ACTIVATE_GENERALLY_OPEN',0),
(14,0,'2019-02-25 18:37:01','\0',11,'2019-02-25 18:37:01',1,'DEACTIVATE_GENERALLY_OPEN',0),
(15,0,'2019-02-25 18:37:02','\0',12,'2019-02-25 18:37:02',1,'ACTIVATE_ALARMSSYTEM',0),
(16,0,'2019-02-25 18:37:03','\0',13,'2019-02-25 18:37:03',1,'DEACTIVATE_ALARMSYSTEM',0),
(17,0,'2019-02-25 18:37:03','\0',14,'2019-02-25 18:37:03',1,'STARTUP',0),
(18,0,'2019-02-25 18:37:04','\0',15,'2019-02-25 18:37:04',1,'INPUT_STATE',0),
(19,0,'2019-02-25 18:37:05','\0',16,'2019-02-25 18:37:05',1,'INVALID_ACCESS_BECAUSE_ANTI_PASS_BACK',0),
(20,0,'2019-02-25 18:37:05','\0',17,'2019-02-25 18:37:05',1,'INVALID_ACCESS_BECAUSE_ALARMSYSTEM_IS_ACTIVE',0),
(21,0,'2019-02-25 18:37:06','\0',18,'2019-02-25 18:37:06',1,'INVALID_ACTIVATE_ALARMSSYTEM_BECAUSE_ALARMSYSTEM_IS_ACTIVE',0),
(22,0,'2019-02-25 18:37:07','\0',19,'2019-02-25 18:37:07',1,'INVALID_DEACTIVATE_ALARMSSYTEM_BECAUSE_ALARMSYSTEM_IS_DEACTIVE',0),
(23,0,'2019-02-25 18:37:08','\0',1,'2019-02-25 18:37:08',35,'VALID_ACCESS',0),
(24,0,'2019-02-25 18:37:08','\0',2,'2019-02-25 18:37:08',35,'INVALID_ACCESS',0),
(25,0,'2019-02-25 18:37:09','\0',3,'2019-02-25 18:37:09',35,'OUTSIDE_OF_AUTHORITY',0),
(26,0,'2019-02-25 18:37:10','\0',4,'2019-02-25 18:37:10',35,'WRONG_AUTHENTIFICATION',0),
(27,0,'2019-02-25 18:37:11','\0',5,'2019-02-25 18:37:11',35,'GENERATE_AES_KEY',0),
(28,0,'2019-02-25 18:37:11','\0',6,'2019-02-25 18:37:11',35,'WRONG_PIN_CODE',0),
(29,0,'2019-02-25 18:37:12','\0',7,'2019-02-25 18:37:12',35,'ACTIVATE_OFFICE',0),
(30,0,'2019-02-25 18:37:13','\0',8,'2019-02-25 18:37:13',35,'ACTIVATE_OFFICE_WITH_END',0),
(31,0,'2019-02-25 18:37:14','\0',9,'2019-02-25 18:37:14',35,'DEACTIVATE_OFFICE',0),
(32,0,'2019-02-25 18:37:14','\0',10,'2019-02-25 18:37:14',35,'ACTIVATE_GENERALLY_OPEN',0),
(33,0,'2019-02-25 18:37:15','\0',11,'2019-02-25 18:37:15',35,'DEACTIVATE_GENERALLY_OPEN',0),
(34,0,'2019-02-25 18:37:16','\0',12,'2019-02-25 18:37:16',35,'ACTIVATE_ALARMSSYTEM',0),
(35,0,'2019-02-25 18:37:16','\0',13,'2019-02-25 18:37:16',35,'DEACTIVATE_ALARMSYSTEM',0),
(36,0,'2019-02-25 18:37:17','\0',14,'2019-02-25 18:37:17',35,'STARTUP',0),
(37,0,'2019-02-25 18:37:18','\0',15,'2019-02-25 18:37:18',35,'INPUT_STATE',0),
(38,0,'2019-02-25 18:37:19','\0',16,'2019-02-25 18:37:19',35,'INVALID_ACCESS_BECAUSE_ANTI_PASS_BACK',0),
(39,0,'2019-02-25 18:37:19','\0',17,'2019-02-25 18:37:19',35,'INVALID_ACCESS_BECAUSE_ALARMSYSTEM_IS_ACTIVE',0),
(40,0,'2019-02-25 18:37:20','\0',18,'2019-02-25 18:37:20',35,'INVALID_ACTIVATE_ALARMSSYTEM_BECAUSE_ALARMSYSTEM_IS_ACTIVE',0),
(41,0,'2019-02-25 18:37:21','\0',19,'2019-02-25 18:37:21',35,'INVALID_DEACTIVATE_ALARMSSYTEM_BECAUSE_ALARMSYSTEM_IS_DEACTIVE',0);

--
-- Table structure for table `cw_expense`
--

CREATE TABLE `cw_expense` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `input_date` bit(1) NOT NULL,
  `input_picture` bit(1) NOT NULL,
  `input_price` bit(1) NOT NULL,
  `input_quantity` bit(1) NOT NULL,
  `input_quantity_unit` bit(1) NOT NULL,
  `input_time` bit(1) NOT NULL,
  `input_upload` bit(1) NOT NULL,
  `last_updated` datetime DEFAULT NULL,
  `mobile_client` bit(1) NOT NULL,
  `name` varchar(255) NOT NULL,
  `update_counter` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_expense`
--


--
-- Table structure for table `cw_expense_2_detail`
--

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

--
-- Dumping data for table `cw_expense_2_detail`
--


--
-- Table structure for table `cw_expense_2_detail_2_individual_field`
--

CREATE TABLE `cw_expense_2_detail_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,
  `expense2detail_id` bigint(20) NOT 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,
  `mandatory_field` bit(1) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKfurp5kt3206bs1dq9x62ul9xu` (`expense2detail_id`),
  CONSTRAINT `FKfurp5kt3206bs1dq9x62ul9xu` FOREIGN KEY (`expense2detail_id`) REFERENCES `cw_expense_2_detail` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_expense_2_detail_2_individual_field`
--


--
-- Table structure for table `cw_expense_2_individual_field`
--

CREATE TABLE `cw_expense_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,
  `expense_id` bigint(20) NOT 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,
  `mandatory_field` bit(1) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK359dbirttpg0ofsilut6rw2ad` (`expense_id`),
  CONSTRAINT `FK359dbirttpg0ofsilut6rw2ad` FOREIGN KEY (`expense_id`) REFERENCES `cw_expense` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_expense_2_individual_field`
--


--
-- Table structure for table `cw_expense_booking`
--

CREATE TABLE `cw_expense_booking` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `content_type` varchar(255) DEFAULT NULL,
  `date` datetime NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `date_value` datetime DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `expense_id` bigint(20) NOT NULL,
  `last_updated` datetime DEFAULT NULL,
  `person_id` bigint(20) NOT NULL,
  `price_value` double DEFAULT NULL,
  `quantity_unit_id` bigint(20) DEFAULT NULL,
  `quantity_value` double DEFAULT NULL,
  `timestamp` bigint(20) NOT NULL,
  `timezone_offset` int(11) NOT NULL,
  `update_counter` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK88warwl7a1cb5bvmhe9uom1r3` (`expense_id`),
  KEY `FK28bljalcnsu1pg9htoqxpv50k` (`person_id`),
  KEY `FK6gggra3mo42kqeilf79u13p6k` (`quantity_unit_id`),
  CONSTRAINT `FK28bljalcnsu1pg9htoqxpv50k` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FK6gggra3mo42kqeilf79u13p6k` FOREIGN KEY (`quantity_unit_id`) REFERENCES `cw_quantity_unit` (`id`),
  CONSTRAINT `FK88warwl7a1cb5bvmhe9uom1r3` FOREIGN KEY (`expense_id`) REFERENCES `cw_expense` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_expense_booking`
--


--
-- Table structure for table `cw_expense_booking_2_blob`
--

CREATE TABLE `cw_expense_booking_2_blob` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `expense_booking_id` bigint(20) NOT NULL,
  `picture_blob` longblob DEFAULT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKchq1dpiufn1vshfl3ok834l5h` (`expense_booking_id`),
  CONSTRAINT `FKchq1dpiufn1vshfl3ok834l5h` FOREIGN KEY (`expense_booking_id`) REFERENCES `cw_expense_booking` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_expense_booking_2_blob`
--


--
-- Table structure for table `cw_expense_booking_2_detail`
--

CREATE TABLE `cw_expense_booking_2_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `expense2detail_id` bigint(20) NOT NULL,
  `expense_booking_id` bigint(20) NOT NULL,
  `last_updated` datetime DEFAULT NULL,
  `update_counter` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKfuj85xcmjhox6vcdesqgm7wbg` (`expense2detail_id`),
  KEY `FKqjn2d2gbg72tgnd6tgmwt1674` (`expense_booking_id`),
  CONSTRAINT `FKfuj85xcmjhox6vcdesqgm7wbg` FOREIGN KEY (`expense2detail_id`) REFERENCES `cw_expense_2_detail` (`id`),
  CONSTRAINT `FKqjn2d2gbg72tgnd6tgmwt1674` FOREIGN KEY (`expense_booking_id`) REFERENCES `cw_expense_booking` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_expense_booking_2_detail`
--


--
-- Table structure for table `cw_expense_booking_2_detail_2_individual_field`
--

CREATE TABLE `cw_expense_booking_2_detail_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,
  `expense2detail2individual_field_id` bigint(20) NOT NULL,
  `expense_booking2detail_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKlivc7mn5vop8abu3jdvj2qgi0` (`expense2detail2individual_field_id`),
  KEY `FK4fghrkdnnc8qp47pwr9m5cu7g` (`expense_booking2detail_id`),
  CONSTRAINT `FK4fghrkdnnc8qp47pwr9m5cu7g` FOREIGN KEY (`expense_booking2detail_id`) REFERENCES `cw_expense_booking_2_detail` (`id`),
  CONSTRAINT `FKlivc7mn5vop8abu3jdvj2qgi0` FOREIGN KEY (`expense2detail2individual_field_id`) REFERENCES `cw_expense_2_detail_2_individual_field` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_expense_booking_2_detail_2_individual_field`
--


--
-- Table structure for table `cw_expense_booking_2_individual_field`
--

CREATE TABLE `cw_expense_booking_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,
  `expense2individual_field_id` bigint(20) NOT NULL,
  `expense_booking_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK58g4hg6vx1mq0fglgs7s2arb7` (`expense2individual_field_id`),
  KEY `FKkwwhc39kwreddxmfihmivwf19` (`expense_booking_id`),
  CONSTRAINT `FK58g4hg6vx1mq0fglgs7s2arb7` FOREIGN KEY (`expense2individual_field_id`) REFERENCES `cw_expense_2_individual_field` (`id`),
  CONSTRAINT `FKkwwhc39kwreddxmfihmivwf19` FOREIGN KEY (`expense_booking_id`) REFERENCES `cw_expense_booking` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_expense_booking_2_individual_field`
--


--
-- Table structure for table `cw_foxpro_transfer`
--

CREATE TABLE `cw_foxpro_transfer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `foxpro_id` bigint(20) NOT NULL,
  `foxpro_table` varchar(255) NOT NULL,
  `web_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_foxpro_transfer`
--


--
-- Table structure for table `cw_from_foxpro_spooler`
--

CREATE TABLE `cw_from_foxpro_spooler` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `param1` varchar(255) DEFAULT NULL,
  `param10` varchar(255) DEFAULT NULL,
  `param101` longtext DEFAULT NULL,
  `param11` varchar(255) DEFAULT NULL,
  `param12` varchar(255) DEFAULT NULL,
  `param13` varchar(255) DEFAULT NULL,
  `param14` varchar(255) DEFAULT NULL,
  `param15` varchar(255) DEFAULT NULL,
  `param16` varchar(255) DEFAULT NULL,
  `param17` varchar(255) DEFAULT NULL,
  `param18` varchar(255) DEFAULT NULL,
  `param19` varchar(255) DEFAULT NULL,
  `param2` varchar(255) DEFAULT NULL,
  `param20` varchar(255) DEFAULT NULL,
  `param3` varchar(255) DEFAULT NULL,
  `param4` varchar(255) DEFAULT NULL,
  `param5` varchar(255) DEFAULT NULL,
  `param6` varchar(255) DEFAULT NULL,
  `param7` varchar(255) DEFAULT NULL,
  `param8` varchar(255) DEFAULT NULL,
  `param9` varchar(255) DEFAULT NULL,
  `counter` int(11) NOT NULL,
  `param21` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_from_foxpro_spooler`
--


--
-- Table structure for table `cw_from_to_date`
--

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

--
-- Dumping data for table `cw_from_to_date`
--


--
-- Table structure for table `cw_front_end_list`
--

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

--
-- Dumping data for table `cw_front_end_list`
--

INSERT INTO `cw_front_end_list` VALUES
(1,0,NULL,'2025-03-19 11:56:09','\0','at.clockwork.time.timeType.domain.TimeTimeType','2025-03-19 11:56:09','TimeTimeType','${obj.number}, ${obj.description_de} ${obj.shortName ? (\"(\"+obj.shortName+\")\") : \"\"}',0),
(2,0,NULL,'2025-03-19 11:56:09','\0','at.clockwork.time.timeModel.domain.TimeTimeModel','2025-03-19 11:56:09','TimeTimeModel','${obj.name}, ${obj.description_de} ${obj.shortName ? (\"(\"+obj.shortName+\")\") : \"\"}',0),
(3,0,NULL,'2025-03-19 11:56:09','\0','at.clockwork.time.timePlan.domain.TimeTimePlan','2025-03-19 11:56:09','TimeTimePlan','${obj.name}, ${obj.description_de} ${obj.shortName ? (\"(\"+obj.shortName+\")\") : \"\"}',0);

--
-- Table structure for table `cw_front_end_list_2_field`
--

CREATE TABLE `cw_front_end_list_2_field` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `alternative_order` int(11) DEFAULT NULL,
  `alternative_pad_left_size` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `field_name` varchar(255) NOT NULL,
  `front_end_list_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `order_value` int(11) DEFAULT NULL,
  `pad_left_size` int(11) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK4tr3caqcvw8d1cjcinnkoprj5` (`front_end_list_id`),
  CONSTRAINT `FK4tr3caqcvw8d1cjcinnkoprj5` FOREIGN KEY (`front_end_list_id`) REFERENCES `cw_front_end_list` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_front_end_list_2_field`
--

INSERT INTO `cw_front_end_list_2_field` VALUES
(1,0,0,0,'2025-03-19 11:56:09','\0','number',1,'2025-03-19 11:56:09',1,3,0),
(2,0,0,0,'2025-03-19 11:56:09','\0','name',2,'2025-03-19 11:56:09',1,5,0),
(3,0,0,0,'2025-03-19 11:56:09','\0','name',3,'2025-03-19 11:56:09',1,5,0);

--
-- Table structure for table `cw_gantner_2_door_access_schedule`
--

CREATE TABLE `cw_gantner_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 `FKqu83nk1k5p7ihnnpvugwkpk9h` (`door_access_schedule_id`),
  KEY `FK5vnnooggnjm28vvy02diramhj` (`terminal_id`),
  CONSTRAINT `FK5vnnooggnjm28vvy02diramhj` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKqu83nk1k5p7ihnnpvugwkpk9h` FOREIGN KEY (`door_access_schedule_id`) REFERENCES `cw_gantner_door_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gantner_2_door_access_schedule`
--


--
-- Table structure for table `cw_gantner_additional_person_authorisation_type`
--

CREATE TABLE `cw_gantner_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_gantner_additional_person_authorisation_type`
--

INSERT INTO `cw_gantner_additional_person_authorisation_type` VALUES
(3);

--
-- Table structure for table `cw_gantner_door_access_schedule`
--

CREATE TABLE `cw_gantner_door_access_schedule` (
  `id` bigint(20) NOT NULL,
  `friday_gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `monday_gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `saturday_gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day1gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day2gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day3gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day4gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day5gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `sunday_gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `thursday_gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `tuesday_gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `wednesday_gantner_door_day_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKt4py9l1siaapewqdpab9bb2tp` (`friday_gantner_door_day_access_schedule_id`),
  KEY `FK9rfv48elml4ahtq18njtap76b` (`monday_gantner_door_day_access_schedule_id`),
  KEY `FKaadcnes5kn4lnwd7ys81fk0pm` (`saturday_gantner_door_day_access_schedule_id`),
  KEY `FK9unoevoeqcilrg8g8kdxrn1aw` (`special_day1gantner_door_day_access_schedule_id`),
  KEY `FKihicdi342d328sbuum7151xat` (`special_day2gantner_door_day_access_schedule_id`),
  KEY `FKmxho08bt0ncc0poxahvj9wx2w` (`special_day3gantner_door_day_access_schedule_id`),
  KEY `FKcf42s8ocbokndxfs27ocdsigq` (`special_day4gantner_door_day_access_schedule_id`),
  KEY `FK9bbboy6v84alyfuu6dg3xlopp` (`special_day5gantner_door_day_access_schedule_id`),
  KEY `FKb29aj8neimpru4soh4u56bpnh` (`sunday_gantner_door_day_access_schedule_id`),
  KEY `FKh07af1vx1ti0xbsghocou343k` (`thursday_gantner_door_day_access_schedule_id`),
  KEY `FKowosfxwm6in0wcc61k3um21qt` (`tuesday_gantner_door_day_access_schedule_id`),
  KEY `FKrjx8a1c8ihcvxbo0x2t8r4ko7` (`wednesday_gantner_door_day_access_schedule_id`),
  CONSTRAINT `FK9bbboy6v84alyfuu6dg3xlopp` FOREIGN KEY (`special_day5gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FK9rfv48elml4ahtq18njtap76b` FOREIGN KEY (`monday_gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FK9unoevoeqcilrg8g8kdxrn1aw` FOREIGN KEY (`special_day1gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKaadcnes5kn4lnwd7ys81fk0pm` FOREIGN KEY (`saturday_gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKb29aj8neimpru4soh4u56bpnh` FOREIGN KEY (`sunday_gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKcf42s8ocbokndxfs27ocdsigq` FOREIGN KEY (`special_day4gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKh07af1vx1ti0xbsghocou343k` FOREIGN KEY (`thursday_gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKihicdi342d328sbuum7151xat` FOREIGN KEY (`special_day2gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKmxho08bt0ncc0poxahvj9wx2w` FOREIGN KEY (`special_day3gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKowosfxwm6in0wcc61k3um21qt` FOREIGN KEY (`tuesday_gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKrjx8a1c8ihcvxbo0x2t8r4ko7` FOREIGN KEY (`wednesday_gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`),
  CONSTRAINT `FKt4py9l1siaapewqdpab9bb2tp` FOREIGN KEY (`friday_gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gantner_door_access_schedule`
--


--
-- Table structure for table `cw_gantner_door_day_access_schedule`
--

CREATE TABLE `cw_gantner_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_gantner_door_day_access_schedule`
--


--
-- Table structure for table `cw_gantner_door_day_access_schedule_2_detail`
--

CREATE TABLE `cw_gantner_door_day_access_schedule_2_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `active_from_first_access` bit(1) DEFAULT NULL,
  `check_only_company_identification` bit(1) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_time` int(11) NOT NULL,
  `gantner_door_day_access_schedule_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `office` bit(1) DEFAULT NULL,
  `special_authority` bit(1) DEFAULT NULL,
  `special_relay_plan` bit(1) DEFAULT NULL,
  `start_time` int(11) NOT NULL,
  `suppress_open_without_identification_alarm` bit(1) DEFAULT NULL,
  `suppress_too_long_open_alarm` bit(1) DEFAULT NULL,
  `unlock_value` bit(1) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `general_open_mode_enum` varchar(255) NOT NULL,
  `relay_plan_enum` varchar(255) NOT NULL,
  `suppress_alarm_mode_enum` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKc018ek1clkgle24r43n3jdvya` (`gantner_door_day_access_schedule_id`),
  CONSTRAINT `FKc018ek1clkgle24r43n3jdvya` FOREIGN KEY (`gantner_door_day_access_schedule_id`) REFERENCES `cw_gantner_door_day_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gantner_door_day_access_schedule_2_detail`
--


--
-- Table structure for table `cw_gantner_person_access_authorisation`
--

CREATE TABLE `cw_gantner_person_access_authorisation` (
  `id` bigint(20) NOT NULL,
  `person_access_schedule_id` bigint(20) DEFAULT NULL,
  `additional_person_authorisation_type_id` bigint(20) DEFAULT NULL,
  `master_authorisation` bit(1) NOT NULL,
  `relay_plan_id` bigint(20) DEFAULT NULL,
  `special_relay_plan_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgm6q9oto38u7chasrrojpqtu7` (`person_access_schedule_id`),
  KEY `FK5c8mrpkd5thiqplroxgxfq2` (`additional_person_authorisation_type_id`),
  KEY `FKtg0485ever2j1m4dveoh525it` (`relay_plan_id`),
  KEY `FKry04ahvteuiyykghtrj2rubn` (`special_relay_plan_id`),
  CONSTRAINT `FK5c8mrpkd5thiqplroxgxfq2` FOREIGN KEY (`additional_person_authorisation_type_id`) REFERENCES `cw_gantner_additional_person_authorisation_type` (`id`),
  CONSTRAINT `FKgm6q9oto38u7chasrrojpqtu7` FOREIGN KEY (`person_access_schedule_id`) REFERENCES `cw_gantner_person_access_schedule` (`id`),
  CONSTRAINT `FKry04ahvteuiyykghtrj2rubn` FOREIGN KEY (`special_relay_plan_id`) REFERENCES `cw_gantner_relay_plan` (`id`),
  CONSTRAINT `FKtg0485ever2j1m4dveoh525it` FOREIGN KEY (`relay_plan_id`) REFERENCES `cw_gantner_relay_plan` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gantner_person_access_authorisation`
--


--
-- Table structure for table `cw_gantner_person_access_schedule`
--

CREATE TABLE `cw_gantner_person_access_schedule` (
  `id` bigint(20) NOT NULL,
  `friday_gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `monday_gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `saturday_gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day1gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day2gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day3gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day4gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `special_day5gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `sunday_gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `thursday_gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `tuesday_gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  `wednesday_gantner_person_day_access_schedule_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK496p0buwcjladjy8fqyt6agfh` (`friday_gantner_person_day_access_schedule_id`),
  KEY `FKsgtcjrdg68rxbnftw0jiaiylt` (`monday_gantner_person_day_access_schedule_id`),
  KEY `FKlpxexnff2dclf1v6a1bhbx5qq` (`saturday_gantner_person_day_access_schedule_id`),
  KEY `FK94a19cpuk5pb52yn6yi81tpf6` (`special_day1gantner_person_day_access_schedule_id`),
  KEY `FKf31qqkq6toarpabnvvil2jwuq` (`special_day2gantner_person_day_access_schedule_id`),
  KEY `FKgeprpeea3l36x3l9l0413ngod` (`special_day3gantner_person_day_access_schedule_id`),
  KEY `FKsh2pgrteliqybha7f72s335er` (`special_day4gantner_person_day_access_schedule_id`),
  KEY `FKqhhgbenq84s0wp71ccvkxesax` (`special_day5gantner_person_day_access_schedule_id`),
  KEY `FKlxnmsp13tqeeb46lg1d1nheie` (`sunday_gantner_person_day_access_schedule_id`),
  KEY `FKtbe158it1nci08pssllq750ho` (`thursday_gantner_person_day_access_schedule_id`),
  KEY `FKbcsolqx6d2rgfwy2mgkn2l3qr` (`tuesday_gantner_person_day_access_schedule_id`),
  KEY `FKt1sam1u6isim2fg3t6reqx1h1` (`wednesday_gantner_person_day_access_schedule_id`),
  CONSTRAINT `FK496p0buwcjladjy8fqyt6agfh` FOREIGN KEY (`friday_gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FK94a19cpuk5pb52yn6yi81tpf6` FOREIGN KEY (`special_day1gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKbcsolqx6d2rgfwy2mgkn2l3qr` FOREIGN KEY (`tuesday_gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKf31qqkq6toarpabnvvil2jwuq` FOREIGN KEY (`special_day2gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKgeprpeea3l36x3l9l0413ngod` FOREIGN KEY (`special_day3gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKlpxexnff2dclf1v6a1bhbx5qq` FOREIGN KEY (`saturday_gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKlxnmsp13tqeeb46lg1d1nheie` FOREIGN KEY (`sunday_gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKqhhgbenq84s0wp71ccvkxesax` FOREIGN KEY (`special_day5gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKsgtcjrdg68rxbnftw0jiaiylt` FOREIGN KEY (`monday_gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKsh2pgrteliqybha7f72s335er` FOREIGN KEY (`special_day4gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKt1sam1u6isim2fg3t6reqx1h1` FOREIGN KEY (`wednesday_gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`),
  CONSTRAINT `FKtbe158it1nci08pssllq750ho` FOREIGN KEY (`thursday_gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gantner_person_access_schedule`
--

INSERT INTO `cw_gantner_person_access_schedule` VALUES
(2,2,2,2,2,2,2,2,2,2,2,2,2),
(8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `cw_gantner_person_category_access_authorisation`
--

CREATE TABLE `cw_gantner_person_category_access_authorisation` (
  `id` bigint(20) NOT NULL,
  `person_access_schedule_id` bigint(20) DEFAULT NULL,
  `additional_person_authorisation_type_id` bigint(20) DEFAULT NULL,
  `master_authorisation` bit(1) NOT NULL,
  `relay_plan_id` bigint(20) DEFAULT NULL,
  `special_relay_plan_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKk160d9gsocewx7f29alj0wg24` (`person_access_schedule_id`),
  KEY `FKhgbadiwvxqgho4sd3ucnobi8v` (`additional_person_authorisation_type_id`),
  KEY `FKd8jhp1m6u1bs5sbqgibgay2yx` (`relay_plan_id`),
  KEY `FKpqw6i3fyvb7beh2lwx0yn0okn` (`special_relay_plan_id`),
  CONSTRAINT `FKd8jhp1m6u1bs5sbqgibgay2yx` FOREIGN KEY (`relay_plan_id`) REFERENCES `cw_gantner_relay_plan` (`id`),
  CONSTRAINT `FKhgbadiwvxqgho4sd3ucnobi8v` FOREIGN KEY (`additional_person_authorisation_type_id`) REFERENCES `cw_gantner_additional_person_authorisation_type` (`id`),
  CONSTRAINT `FKk160d9gsocewx7f29alj0wg24` FOREIGN KEY (`person_access_schedule_id`) REFERENCES `cw_gantner_person_access_schedule` (`id`),
  CONSTRAINT `FKpqw6i3fyvb7beh2lwx0yn0okn` FOREIGN KEY (`special_relay_plan_id`) REFERENCES `cw_gantner_relay_plan` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gantner_person_category_access_authorisation`
--


--
-- Table structure for table `cw_gantner_person_day_access_schedule`
--

CREATE TABLE `cw_gantner_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_gantner_person_day_access_schedule`
--

INSERT INTO `cw_gantner_person_day_access_schedule` VALUES
(2),
(8);

--
-- Table structure for table `cw_gantner_person_day_access_schedule_2_detail`
--

CREATE TABLE `cw_gantner_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,
  `gantner_person_day_access_schedule_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `only_exit` bit(1) DEFAULT NULL,
  `special_relay_plan` bit(1) DEFAULT NULL,
  `start_time` int(11) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `use_pin_code` bit(1) DEFAULT NULL,
  `identification_enum` varchar(255) NOT NULL,
  `relay_plan_enum` varchar(255) NOT NULL,
  `verification_enum` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK7fw62nyvn0nitphqvog9jh8hj` (`gantner_person_day_access_schedule_id`),
  KEY `query1_idx` (`gantner_person_day_access_schedule_id`,`deleted`),
  CONSTRAINT `FK7fw62nyvn0nitphqvog9jh8hj` FOREIGN KEY (`gantner_person_day_access_schedule_id`) REFERENCES `cw_gantner_person_day_access_schedule` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gantner_person_day_access_schedule_2_detail`
--

INSERT INTO `cw_gantner_person_day_access_schedule_2_detail` VALUES
(1,1,'2023-02-08 23:52:24','\0',1439,2,'2024-11-24 13:28:32','\0','\0',0,0,'\0','CARD','NORMAL_RELAY_PLAN','NO');

--
-- Table structure for table `cw_gantner_relay_plan`
--

CREATE TABLE `cw_gantner_relay_plan` (
  `id` bigint(20) NOT NULL,
  `relay_1` bit(1) NOT NULL,
  `relay_10` bit(1) NOT NULL,
  `relay_11` bit(1) NOT NULL,
  `relay_12` bit(1) NOT NULL,
  `relay_13` bit(1) NOT NULL,
  `relay_14` bit(1) NOT NULL,
  `relay_15` bit(1) NOT NULL,
  `relay_16` bit(1) NOT NULL,
  `relay_17` bit(1) NOT NULL,
  `relay_18` bit(1) NOT NULL,
  `relay_19` bit(1) NOT NULL,
  `relay_2` bit(1) NOT NULL,
  `relay_20` bit(1) NOT NULL,
  `relay_21` bit(1) NOT NULL,
  `relay_22` bit(1) NOT NULL,
  `relay_23` bit(1) NOT NULL,
  `relay_24` bit(1) NOT NULL,
  `relay_25` bit(1) NOT NULL,
  `relay_26` bit(1) NOT NULL,
  `relay_27` bit(1) NOT NULL,
  `relay_28` bit(1) NOT NULL,
  `relay_29` bit(1) NOT NULL,
  `relay_3` bit(1) NOT NULL,
  `relay_30` bit(1) NOT NULL,
  `relay_31` bit(1) NOT NULL,
  `relay_32` bit(1) NOT NULL,
  `relay_4` bit(1) NOT NULL,
  `relay_5` bit(1) NOT NULL,
  `relay_6` bit(1) NOT NULL,
  `relay_7` bit(1) NOT NULL,
  `relay_8` bit(1) NOT NULL,
  `relay_9` bit(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gantner_relay_plan`
--


--
-- Table structure for table `cw_general_domain_class_spooler`
--

CREATE TABLE `cw_general_domain_class_spooler` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `domain_class` varchar(255) NOT NULL,
  `domain_class_id` bigint(20) NOT NULL,
  `spooler_action_type` varchar(255) NOT NULL,
  `counter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_domain_class_spooler`
--


--
-- Table structure for table `cw_general_validation`
--

CREATE TABLE `cw_general_validation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `all_absences` bit(1) DEFAULT NULL,
  `all_areas` bit(1) DEFAULT NULL,
  `all_companies` bit(1) DEFAULT NULL,
  `all_cost_units` bit(1) DEFAULT NULL,
  `all_machines` bit(1) DEFAULT NULL,
  `all_order_items` bit(1) DEFAULT NULL,
  `all_orders` bit(1) DEFAULT NULL,
  `all_projects` bit(1) DEFAULT NULL,
  `all_terminals` bit(1) DEFAULT NULL,
  `all_time_time_models` bit(1) DEFAULT NULL,
  `all_time_time_plans` bit(1) DEFAULT NULL,
  `all_time_time_types` bit(1) DEFAULT NULL,
  `all_users` bit(1) DEFAULT NULL,
  `all_workflow_types` bit(1) DEFAULT NULL,
  `all_workplaces` bit(1) DEFAULT NULL,
  `all_workprocesses` bit(1) 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) DEFAULT NULL,
  `no_absence` bit(1) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `priority_for_system_configurations` int(11) DEFAULT NULL,
  `all_ressources` bit(1) DEFAULT NULL,
  `all_work_combinations` bit(1) DEFAULT NULL,
  `all_chiplox_door_access_schedules` bit(1) DEFAULT NULL,
  `all_chiplox_person_access_schedules` bit(1) DEFAULT NULL,
  `all_datafox_door_access_schedules` bit(1) DEFAULT NULL,
  `all_datafox_person_access_schedules` bit(1) DEFAULT NULL,
  `all_event_types` bit(1) DEFAULT NULL,
  `all_gantner_door_access_schedules` bit(1) DEFAULT NULL,
  `all_gantner_person_access_schedules` bit(1) DEFAULT NULL,
  `all_keyflex_door_access_schedules` bit(1) DEFAULT NULL,
  `all_keyflex_person_access_schedules` bit(1) DEFAULT NULL,
  `all_seccor_door_access_schedules` bit(1) DEFAULT NULL,
  `all_seccor_person_access_schedules` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation`
--

INSERT INTO `cw_general_validation` VALUES
(1,0,'','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','2018-02-07 08:48:42','\0','alles','2018-02-07 08:48:42','all','',0,0,'\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0'),
(2,0,'\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','2019-05-22 11:19:53','\0','direkt','2019-05-22 11:19:53','direkt','',0,0,'\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0'),
(3,0,'','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','2019-05-22 11:20:12','\0','Buchungen','2019-05-22 11:20:12','Buchungen','',0,0,'\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0'),
(4,0,'','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','2019-05-22 11:20:32','\0','Abwesenheit','2019-05-22 11:20:32','Abwesenheit','\0',0,0,'\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0','\0'),
(5,1,'\0','\0','\0','\0','\0','\0','\0','\0','','\0','\0','\0','\0','\0','\0','\0','2019-05-22 12:52:39','\0','Terminal','2024-03-07 09:48:40','Terminal','\0',0,0,'\0','\0','','','','','\0','','','','','','');

--
-- Table structure for table `cw_general_validation_2_absence_category_bl`
--

CREATE TABLE `cw_general_validation_2_absence_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `absence_category_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKo35srjtccueyypebi40ceiaqs` (`absence_category_id`),
  KEY `FK72cyq377d6hd2bj42pyc07fty` (`general_validation_id`),
  CONSTRAINT `FK72cyq377d6hd2bj42pyc07fty` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKo35srjtccueyypebi40ceiaqs` FOREIGN KEY (`absence_category_id`) REFERENCES `cw_absence_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_absence_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_absence_category_wl`
--

CREATE TABLE `cw_general_validation_2_absence_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `absence_category_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKsydsdieugej8kibxj594fui16` (`absence_category_id`),
  KEY `FKkvo6t0qj1h5kpyuk2teghwiop` (`general_validation_id`),
  CONSTRAINT `FKkvo6t0qj1h5kpyuk2teghwiop` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKsydsdieugej8kibxj594fui16` FOREIGN KEY (`absence_category_id`) REFERENCES `cw_absence_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_absence_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_absence_wl`
--

CREATE TABLE `cw_general_validation_2_absence_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `absence_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK9j418tpsry6q8t3wb180h9jcf` (`absence_id`),
  KEY `FK2rshq3chxq1yaj3e4l6xu43kx` (`general_validation_id`),
  CONSTRAINT `FK2rshq3chxq1yaj3e4l6xu43kx` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FK9j418tpsry6q8t3wb180h9jcf` FOREIGN KEY (`absence_id`) REFERENCES `cw_absence` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_absence_wl`
--


--
-- Table structure for table `cw_general_validation_2_chiplox_door_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_chiplox_door_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `chiplox_door_access_schedule_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKo1bhjg5y8jib0vhl9pv4sk7vn` (`chiplox_door_access_schedule_id`),
  KEY `FK818vfmwgyu9q0lpwhjsfkxilu` (`general_validation_id`),
  CONSTRAINT `FK818vfmwgyu9q0lpwhjsfkxilu` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKo1bhjg5y8jib0vhl9pv4sk7vn` FOREIGN KEY (`chiplox_door_access_schedule_id`) REFERENCES `cw_chiplox_door_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_chiplox_door_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_chiplox_person_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_chiplox_person_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `chiplox_person_access_schedule_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKs07804xife7s9ro65kyhnxxrd` (`chiplox_person_access_schedule_id`),
  KEY `FK8uro5w5auxkvpb73woyljxrh5` (`general_validation_id`),
  CONSTRAINT `FK8uro5w5auxkvpb73woyljxrh5` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKs07804xife7s9ro65kyhnxxrd` FOREIGN KEY (`chiplox_person_access_schedule_id`) REFERENCES `cw_chiplox_person_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_chiplox_person_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_company_category_bl`
--

CREATE TABLE `cw_general_validation_2_company_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `company_category_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKqy5tsh7mpe9myf81j0dxwey3v` (`company_category_id`),
  KEY `FKb0p4gt8t68ny52npts0atpkt` (`general_validation_id`),
  CONSTRAINT `FKb0p4gt8t68ny52npts0atpkt` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKqy5tsh7mpe9myf81j0dxwey3v` FOREIGN KEY (`company_category_id`) REFERENCES `cw_company_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_company_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_company_category_wl`
--

CREATE TABLE `cw_general_validation_2_company_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `company_category_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3la84r1fxfwoje758dv249kim` (`company_category_id`),
  KEY `FKw88bdh25j3e0e393naboa1rw` (`general_validation_id`),
  CONSTRAINT `FK3la84r1fxfwoje758dv249kim` FOREIGN KEY (`company_category_id`) REFERENCES `cw_company_category` (`id`),
  CONSTRAINT `FKw88bdh25j3e0e393naboa1rw` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_company_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_company_wl`
--

CREATE TABLE `cw_general_validation_2_company_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `company_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKm6rfxenou6p5a9hfcq8eyoiic` (`company_id`),
  KEY `FKqdx0aox1uphevytrx2ny1apc7` (`general_validation_id`),
  CONSTRAINT `FKm6rfxenou6p5a9hfcq8eyoiic` FOREIGN KEY (`company_id`) REFERENCES `cw_company` (`id`),
  CONSTRAINT `FKqdx0aox1uphevytrx2ny1apc7` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_company_wl`
--


--
-- Table structure for table `cw_general_validation_2_cost_unit_category_bl`
--

CREATE TABLE `cw_general_validation_2_cost_unit_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `cost_unit_category_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKt2hk8du5876d5iphyw413342g` (`cost_unit_category_id`),
  KEY `FK2mf1nkwfbdc4jiwkeexoci551` (`general_validation_id`),
  CONSTRAINT `FK2mf1nkwfbdc4jiwkeexoci551` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKt2hk8du5876d5iphyw413342g` FOREIGN KEY (`cost_unit_category_id`) REFERENCES `cw_cost_unit_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_cost_unit_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_cost_unit_category_wl`
--

CREATE TABLE `cw_general_validation_2_cost_unit_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `cost_unit_category_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKrsx2qh87q9kfbkpimxoc6e2g0` (`cost_unit_category_id`),
  KEY `FKj6c02npivjne724wt0ernrywu` (`general_validation_id`),
  CONSTRAINT `FKj6c02npivjne724wt0ernrywu` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKrsx2qh87q9kfbkpimxoc6e2g0` FOREIGN KEY (`cost_unit_category_id`) REFERENCES `cw_cost_unit_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_cost_unit_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_cost_unit_wl`
--

CREATE TABLE `cw_general_validation_2_cost_unit_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `cost_unit_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKpsjsoumhdse02ifbbpoh31afe` (`cost_unit_id`),
  KEY `FK6i1ofgieecdl4nr5hh3amji0w` (`general_validation_id`),
  CONSTRAINT `FK6i1ofgieecdl4nr5hh3amji0w` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKpsjsoumhdse02ifbbpoh31afe` FOREIGN KEY (`cost_unit_id`) REFERENCES `cw_cost_unit` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_cost_unit_wl`
--


--
-- Table structure for table `cw_general_validation_2_datafox_door_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_datafox_door_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `datafox_door_access_schedule_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK66uky3o6pwy0sbi1tpes97fh9` (`datafox_door_access_schedule_id`),
  KEY `FKlwlfmucxy8rp72qq78x8p0hbr` (`general_validation_id`),
  CONSTRAINT `FK66uky3o6pwy0sbi1tpes97fh9` FOREIGN KEY (`datafox_door_access_schedule_id`) REFERENCES `cw_datafox_door_access_schedule` (`id`),
  CONSTRAINT `FKlwlfmucxy8rp72qq78x8p0hbr` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_datafox_door_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_datafox_person_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_datafox_person_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `datafox_person_access_schedule_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKi3p8yk15ewb9nocb3wmmecjei` (`datafox_person_access_schedule_id`),
  KEY `FK8jp78qw9rqij2p788rj2mri35` (`general_validation_id`),
  CONSTRAINT `FK8jp78qw9rqij2p788rj2mri35` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKi3p8yk15ewb9nocb3wmmecjei` FOREIGN KEY (`datafox_person_access_schedule_id`) REFERENCES `cw_datafox_person_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_datafox_person_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_event_type_wl`
--

CREATE TABLE `cw_general_validation_2_event_type_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `event_type_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKmbcr7itoexlbe9r6dli6a275a` (`event_type_id`),
  KEY `FKipo8177o4gqg3c3viw3i7jren` (`general_validation_id`),
  CONSTRAINT `FKipo8177o4gqg3c3viw3i7jren` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKmbcr7itoexlbe9r6dli6a275a` FOREIGN KEY (`event_type_id`) REFERENCES `cw_event_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_event_type_wl`
--


--
-- Table structure for table `cw_general_validation_2_gantner_door_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_gantner_door_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `gantner_door_access_schedule_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKm01vl1kwaeno6vtj6lr9isyp0` (`gantner_door_access_schedule_id`),
  KEY `FK9b57pwwkeivb5c4kmnvy3jba9` (`general_validation_id`),
  CONSTRAINT `FK9b57pwwkeivb5c4kmnvy3jba9` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKm01vl1kwaeno6vtj6lr9isyp0` FOREIGN KEY (`gantner_door_access_schedule_id`) REFERENCES `cw_gantner_door_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_gantner_door_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_gantner_person_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_gantner_person_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `gantner_person_access_schedule_id` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK5i8bj9egv9rmryaca3yjo5f5f` (`gantner_person_access_schedule_id`),
  KEY `FKgd3mqnbo3mahgo1nkmfaxynrv` (`general_validation_id`),
  CONSTRAINT `FK5i8bj9egv9rmryaca3yjo5f5f` FOREIGN KEY (`gantner_person_access_schedule_id`) REFERENCES `cw_gantner_person_access_schedule` (`id`),
  CONSTRAINT `FKgd3mqnbo3mahgo1nkmfaxynrv` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_gantner_person_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_keyflex_door_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_keyflex_door_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `keyflex_door_access_schedule_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjat0dnusyd1o19f0chwtbo5st` (`general_validation_id`),
  KEY `FKhfno6a066ayifjaw4wthmnf2w` (`keyflex_door_access_schedule_id`),
  CONSTRAINT `FKhfno6a066ayifjaw4wthmnf2w` FOREIGN KEY (`keyflex_door_access_schedule_id`) REFERENCES `cw_keyflex_door_access_schedule` (`id`),
  CONSTRAINT `FKjat0dnusyd1o19f0chwtbo5st` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_keyflex_door_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_keyflex_person_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_keyflex_person_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `keyflex_person_access_schedule_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKqiahnakd7tsnjbirf1g4aut1e` (`general_validation_id`),
  KEY `FKh3vxo05h78wj0kue28e431abd` (`keyflex_person_access_schedule_id`),
  CONSTRAINT `FKh3vxo05h78wj0kue28e431abd` FOREIGN KEY (`keyflex_person_access_schedule_id`) REFERENCES `cw_keyflex_person_access_schedule` (`id`),
  CONSTRAINT `FKqiahnakd7tsnjbirf1g4aut1e` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_keyflex_person_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_machine_category_bl`
--

CREATE TABLE `cw_general_validation_2_machine_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `machine_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKcid6ivb3tq491yv4jp9h8yw66` (`general_validation_id`),
  KEY `FKjv221rca25g5sjwhx4cna9saf` (`machine_category_id`),
  CONSTRAINT `FKcid6ivb3tq491yv4jp9h8yw66` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKjv221rca25g5sjwhx4cna9saf` FOREIGN KEY (`machine_category_id`) REFERENCES `cw_machine_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_machine_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_machine_category_wl`
--

CREATE TABLE `cw_general_validation_2_machine_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `machine_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKxb7kvqs9wrj0kyjcxsrtqaue` (`general_validation_id`),
  KEY `FKquf3l88ofkxd6mrhayu3g2sxk` (`machine_category_id`),
  CONSTRAINT `FKquf3l88ofkxd6mrhayu3g2sxk` FOREIGN KEY (`machine_category_id`) REFERENCES `cw_machine_category` (`id`),
  CONSTRAINT `FKxb7kvqs9wrj0kyjcxsrtqaue` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_machine_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_machine_wl`
--

CREATE TABLE `cw_general_validation_2_machine_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `machine_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKk3a6r1agsnc6fb37ifetp0mee` (`general_validation_id`),
  KEY `FK7l5w4pba6y6ksailm29guo759` (`machine_id`),
  CONSTRAINT `FK7l5w4pba6y6ksailm29guo759` FOREIGN KEY (`machine_id`) REFERENCES `cw_machine` (`id`),
  CONSTRAINT `FKk3a6r1agsnc6fb37ifetp0mee` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_machine_wl`
--


--
-- Table structure for table `cw_general_validation_2_order_category_bl`
--

CREATE TABLE `cw_general_validation_2_order_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `order_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKbp6cinvffvrcc4p1k8rgyy75q` (`general_validation_id`),
  KEY `FKr74x0exyqowyf8mbpvpwij9h8` (`order_category_id`),
  CONSTRAINT `FKbp6cinvffvrcc4p1k8rgyy75q` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKr74x0exyqowyf8mbpvpwij9h8` FOREIGN KEY (`order_category_id`) REFERENCES `cw_order_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_order_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_order_category_wl`
--

CREATE TABLE `cw_general_validation_2_order_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `order_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3s3tkm5xt6km1do4t745oed3f` (`general_validation_id`),
  KEY `FKsdggro49tncluxrsgkxaqv7sr` (`order_category_id`),
  CONSTRAINT `FK3s3tkm5xt6km1do4t745oed3f` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKsdggro49tncluxrsgkxaqv7sr` FOREIGN KEY (`order_category_id`) REFERENCES `cw_order_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_order_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_order_item_category_bl`
--

CREATE TABLE `cw_general_validation_2_order_item_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `order_item_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgccr46yfwv3glcou4sendpuh` (`general_validation_id`),
  KEY `FKta5n6voob5prx5755hkhte765` (`order_item_category_id`),
  CONSTRAINT `FKgccr46yfwv3glcou4sendpuh` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKta5n6voob5prx5755hkhte765` FOREIGN KEY (`order_item_category_id`) REFERENCES `cw_order_item_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_order_item_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_order_item_category_wl`
--

CREATE TABLE `cw_general_validation_2_order_item_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `order_item_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKr98854d05ytrlmb8r4g5dq0ga` (`general_validation_id`),
  KEY `FK593weok20ve3uai8b33p2txod` (`order_item_category_id`),
  CONSTRAINT `FK593weok20ve3uai8b33p2txod` FOREIGN KEY (`order_item_category_id`) REFERENCES `cw_order_item_category` (`id`),
  CONSTRAINT `FKr98854d05ytrlmb8r4g5dq0ga` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_order_item_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_order_item_wl`
--

CREATE TABLE `cw_general_validation_2_order_item_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `order_item_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK70ms7oonkhmwajvtg6l5ejean` (`general_validation_id`),
  KEY `FK43g6vnve9yym0nr4pn5xi6bm1` (`order_item_id`),
  CONSTRAINT `FK43g6vnve9yym0nr4pn5xi6bm1` FOREIGN KEY (`order_item_id`) REFERENCES `cw_order_item` (`id`),
  CONSTRAINT `FK70ms7oonkhmwajvtg6l5ejean` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_order_item_wl`
--


--
-- Table structure for table `cw_general_validation_2_order_wl`
--

CREATE TABLE `cw_general_validation_2_order_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKag60cjb1vu5em7uc8ao9p3qwm` (`general_validation_id`),
  KEY `FK2th8ummvbl5of7kcwskvuyo3x` (`order_id`),
  CONSTRAINT `FK2th8ummvbl5of7kcwskvuyo3x` FOREIGN KEY (`order_id`) REFERENCES `cw_order` (`id`),
  CONSTRAINT `FKag60cjb1vu5em7uc8ao9p3qwm` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_order_wl`
--


--
-- Table structure for table `cw_general_validation_2_project_category_bl`
--

CREATE TABLE `cw_general_validation_2_project_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `project_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK6395tg13bp7kdl9k3lkydnald` (`general_validation_id`),
  KEY `FK178y281023l01dnmoewptpa3g` (`project_category_id`),
  CONSTRAINT `FK178y281023l01dnmoewptpa3g` FOREIGN KEY (`project_category_id`) REFERENCES `cw_project_category` (`id`),
  CONSTRAINT `FK6395tg13bp7kdl9k3lkydnald` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_project_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_project_category_wl`
--

CREATE TABLE `cw_general_validation_2_project_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `project_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKquydjs7mc0l2s7fe9v9poxntr` (`general_validation_id`),
  KEY `FK6oxftilsla38nkyxl2oxgbmvd` (`project_category_id`),
  CONSTRAINT `FK6oxftilsla38nkyxl2oxgbmvd` FOREIGN KEY (`project_category_id`) REFERENCES `cw_project_category` (`id`),
  CONSTRAINT `FKquydjs7mc0l2s7fe9v9poxntr` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_project_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_project_wl`
--

CREATE TABLE `cw_general_validation_2_project_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `project_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKs1abguyw7l9b4y0kph20j6v6x` (`general_validation_id`),
  KEY `FK4l3862nfqh49bh4sgexc5ee03` (`project_id`),
  CONSTRAINT `FK4l3862nfqh49bh4sgexc5ee03` FOREIGN KEY (`project_id`) REFERENCES `cw_project` (`id`),
  CONSTRAINT `FKs1abguyw7l9b4y0kph20j6v6x` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_project_wl`
--


--
-- Table structure for table `cw_general_validation_2_ressource_category_bl`
--

CREATE TABLE `cw_general_validation_2_ressource_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `ressource_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKtn2p93gehib2go92rjs8joncp` (`general_validation_id`),
  KEY `FK503il457je70jchel0njeeorv` (`ressource_category_id`),
  CONSTRAINT `FK503il457je70jchel0njeeorv` FOREIGN KEY (`ressource_category_id`) REFERENCES `cw_ressource_category` (`id`),
  CONSTRAINT `FKtn2p93gehib2go92rjs8joncp` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_ressource_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_ressource_category_wl`
--

CREATE TABLE `cw_general_validation_2_ressource_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `ressource_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjaxs9go3y33tol3vl85k9fgo8` (`general_validation_id`),
  KEY `FKldwls44yuvqer0qouwm9nfv6f` (`ressource_category_id`),
  CONSTRAINT `FKjaxs9go3y33tol3vl85k9fgo8` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKldwls44yuvqer0qouwm9nfv6f` FOREIGN KEY (`ressource_category_id`) REFERENCES `cw_ressource_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_ressource_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_ressource_wl`
--

CREATE TABLE `cw_general_validation_2_ressource_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `ressource_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKoj0s6ijsdb7bfj3k4n1qs13on` (`general_validation_id`),
  KEY `FKimgiuitocuo396mtb1hxdicsm` (`ressource_id`),
  CONSTRAINT `FKimgiuitocuo396mtb1hxdicsm` FOREIGN KEY (`ressource_id`) REFERENCES `cw_ressource` (`id`),
  CONSTRAINT `FKoj0s6ijsdb7bfj3k4n1qs13on` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_ressource_wl`
--


--
-- Table structure for table `cw_general_validation_2_seccor_door_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_seccor_door_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `seccor_door_access_schedule_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKam14qb207n7y3od76tsomsy5a` (`general_validation_id`),
  KEY `FKb7aomwkbg42p1xh7g9f0wohb3` (`seccor_door_access_schedule_id`),
  CONSTRAINT `FKam14qb207n7y3od76tsomsy5a` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKb7aomwkbg42p1xh7g9f0wohb3` FOREIGN KEY (`seccor_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_general_validation_2_seccor_door_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_seccor_person_access_schedule_wl`
--

CREATE TABLE `cw_general_validation_2_seccor_person_access_schedule_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `seccor_person_access_schedule_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKfcixag5tdod17xeh6a7ehv2hn` (`general_validation_id`),
  KEY `FKjyxqq6o1v9qax7rb9avxao3es` (`seccor_person_access_schedule_id`),
  CONSTRAINT `FKfcixag5tdod17xeh6a7ehv2hn` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKjyxqq6o1v9qax7rb9avxao3es` FOREIGN KEY (`seccor_person_access_schedule_id`) REFERENCES `cw_seccor_person_access_schedule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_seccor_person_access_schedule_wl`
--


--
-- Table structure for table `cw_general_validation_2_terminal_category_bl`
--

CREATE TABLE `cw_general_validation_2_terminal_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `terminal_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKi9imgmsof8h6x4f5dy6nlebfk` (`general_validation_id`),
  KEY `FKexfr06dbx1n4sr13pg4a6ioas` (`terminal_category_id`),
  CONSTRAINT `FKexfr06dbx1n4sr13pg4a6ioas` FOREIGN KEY (`terminal_category_id`) REFERENCES `cw_terminal_category` (`id`),
  CONSTRAINT `FKi9imgmsof8h6x4f5dy6nlebfk` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_terminal_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_terminal_category_wl`
--

CREATE TABLE `cw_general_validation_2_terminal_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `terminal_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKtgvj4xb9oe9nvd6q0xbtqd22v` (`general_validation_id`),
  KEY `FKgv8dnui9s1sb5ipr7r9siee4x` (`terminal_category_id`),
  CONSTRAINT `FKgv8dnui9s1sb5ipr7r9siee4x` FOREIGN KEY (`terminal_category_id`) REFERENCES `cw_terminal_category` (`id`),
  CONSTRAINT `FKtgvj4xb9oe9nvd6q0xbtqd22v` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_terminal_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_terminal_wl`
--

CREATE TABLE `cw_general_validation_2_terminal_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK5jnk51l3mko01pteo1d8cf9pt` (`general_validation_id`),
  KEY `FK1huwl375pko4fwnv0u9n32ljt` (`terminal_id`),
  CONSTRAINT `FK1huwl375pko4fwnv0u9n32ljt` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FK5jnk51l3mko01pteo1d8cf9pt` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_terminal_wl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_model_category_bl`
--

CREATE TABLE `cw_general_validation_2_time_time_model_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_model_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKj3xdjxk0l9hstrsg6ic4u4djg` (`general_validation_id`),
  KEY `FKds0ms3het00q4sprbroy671vp` (`time_time_model_category_id`),
  CONSTRAINT `FKds0ms3het00q4sprbroy671vp` FOREIGN KEY (`time_time_model_category_id`) REFERENCES `cw_time_time_model_category` (`id`),
  CONSTRAINT `FKj3xdjxk0l9hstrsg6ic4u4djg` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_model_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_model_category_wl`
--

CREATE TABLE `cw_general_validation_2_time_time_model_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_model_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKktm85kxkavtut5ub2ggac57lt` (`general_validation_id`),
  KEY `FK17bpxnjaufduna0upc7htkxyd` (`time_time_model_category_id`),
  CONSTRAINT `FK17bpxnjaufduna0upc7htkxyd` FOREIGN KEY (`time_time_model_category_id`) REFERENCES `cw_time_time_model_category` (`id`),
  CONSTRAINT `FKktm85kxkavtut5ub2ggac57lt` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_model_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_model_wl`
--

CREATE TABLE `cw_general_validation_2_time_time_model_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_model_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKfj2verw6gv5wd565ototkdehc` (`general_validation_id`),
  KEY `FK5x2smpsea8mh76l7s3k31aviv` (`time_time_model_id`),
  CONSTRAINT `FK5x2smpsea8mh76l7s3k31aviv` FOREIGN KEY (`time_time_model_id`) REFERENCES `cw_time_time_model` (`id`),
  CONSTRAINT `FKfj2verw6gv5wd565ototkdehc` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_model_wl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_plan_category_bl`
--

CREATE TABLE `cw_general_validation_2_time_time_plan_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_plan_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK7twqtgssm4o0tmd8mlklb5yv0` (`general_validation_id`),
  KEY `FKrqqujm1pergwdnfishdake50p` (`time_time_plan_category_id`),
  CONSTRAINT `FK7twqtgssm4o0tmd8mlklb5yv0` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKrqqujm1pergwdnfishdake50p` FOREIGN KEY (`time_time_plan_category_id`) REFERENCES `cw_time_time_plan_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_plan_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_plan_category_wl`
--

CREATE TABLE `cw_general_validation_2_time_time_plan_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_plan_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKffq4oytcoxkbkbhaasxo9s06f` (`general_validation_id`),
  KEY `FK5t9iv8rmu3lvqe4gninv2qcp9` (`time_time_plan_category_id`),
  CONSTRAINT `FK5t9iv8rmu3lvqe4gninv2qcp9` FOREIGN KEY (`time_time_plan_category_id`) REFERENCES `cw_time_time_plan_category` (`id`),
  CONSTRAINT `FKffq4oytcoxkbkbhaasxo9s06f` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_plan_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_plan_wl`
--

CREATE TABLE `cw_general_validation_2_time_time_plan_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_plan_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKnwd6v6rwp3hu3byv6niseeqjg` (`general_validation_id`),
  KEY `FKbtp8lajulob6rfoeu8rvdc3qt` (`time_time_plan_id`),
  CONSTRAINT `FKbtp8lajulob6rfoeu8rvdc3qt` FOREIGN KEY (`time_time_plan_id`) REFERENCES `cw_time_time_plan` (`id`),
  CONSTRAINT `FKnwd6v6rwp3hu3byv6niseeqjg` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_plan_wl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_type_category_bl`
--

CREATE TABLE `cw_general_validation_2_time_time_type_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_type_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKb4o2qtdofcnaw69qta1vdnjkg` (`general_validation_id`),
  KEY `FKewei1uuht9e85kx72djerhml2` (`time_time_type_category_id`),
  CONSTRAINT `FKb4o2qtdofcnaw69qta1vdnjkg` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKewei1uuht9e85kx72djerhml2` FOREIGN KEY (`time_time_type_category_id`) REFERENCES `cw_time_time_type_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_type_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_type_category_wl`
--

CREATE TABLE `cw_general_validation_2_time_time_type_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_type_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK4q4ocbmvasgojblikbp7o3vp0` (`general_validation_id`),
  KEY `FKicyio9pk51vny73rrbkpxmbru` (`time_time_type_category_id`),
  CONSTRAINT `FK4q4ocbmvasgojblikbp7o3vp0` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKicyio9pk51vny73rrbkpxmbru` FOREIGN KEY (`time_time_type_category_id`) REFERENCES `cw_time_time_type_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_type_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_time_time_type_wl`
--

CREATE TABLE `cw_general_validation_2_time_time_type_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `time_time_type_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKivaghcj3sakdv3awpg4ici26y` (`general_validation_id`),
  KEY `FKmkspg3myyvff7ctq7v3g293kh` (`time_time_type_id`),
  CONSTRAINT `FKivaghcj3sakdv3awpg4ici26y` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKmkspg3myyvff7ctq7v3g293kh` FOREIGN KEY (`time_time_type_id`) REFERENCES `cw_time_time_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_time_time_type_wl`
--


--
-- Table structure for table `cw_general_validation_2_user_category_bl`
--

CREATE TABLE `cw_general_validation_2_user_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `user_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKse8ndfv8cmf7fa9qvkhv2wyv0` (`general_validation_id`),
  KEY `FKpdqgsos4hakuw5scyrp53g54a` (`user_category_id`),
  CONSTRAINT `FKpdqgsos4hakuw5scyrp53g54a` FOREIGN KEY (`user_category_id`) REFERENCES `cw_user_category` (`id`),
  CONSTRAINT `FKse8ndfv8cmf7fa9qvkhv2wyv0` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_user_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_user_category_wl`
--

CREATE TABLE `cw_general_validation_2_user_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `user_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKc5w1waijl6dar79i4pt4c8w79` (`general_validation_id`),
  KEY `FK350kkwr7fivgnkto9ad5cusn0` (`user_category_id`),
  CONSTRAINT `FK350kkwr7fivgnkto9ad5cusn0` FOREIGN KEY (`user_category_id`) REFERENCES `cw_user_category` (`id`),
  CONSTRAINT `FKc5w1waijl6dar79i4pt4c8w79` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_user_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_user_wl`
--

CREATE TABLE `cw_general_validation_2_user_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK71honk3qusqj8q6l9vs1qvu3` (`general_validation_id`),
  KEY `FKq0em7bvca6mx0q47obv6345cm` (`user_id`),
  CONSTRAINT `FK71honk3qusqj8q6l9vs1qvu3` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKq0em7bvca6mx0q47obv6345cm` FOREIGN KEY (`user_id`) REFERENCES `cw_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_user_wl`
--


--
-- Table structure for table `cw_general_validation_2_work_combination_category_bl`
--

CREATE TABLE `cw_general_validation_2_work_combination_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `work_combination_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKqjg1xgwdv1p3wn74t1fvrid3t` (`general_validation_id`),
  KEY `FKh7bilnrafw6sy6krkrvshbo24` (`work_combination_category_id`),
  CONSTRAINT `FKh7bilnrafw6sy6krkrvshbo24` FOREIGN KEY (`work_combination_category_id`) REFERENCES `cw_work_combination_category` (`id`),
  CONSTRAINT `FKqjg1xgwdv1p3wn74t1fvrid3t` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_work_combination_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_work_combination_category_wl`
--

CREATE TABLE `cw_general_validation_2_work_combination_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `work_combination_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKiemn4w6ha3h2vvua7v4bhmgsd` (`general_validation_id`),
  KEY `FKg9qn9wkpe0vqsj9264q8l92g1` (`work_combination_category_id`),
  CONSTRAINT `FKg9qn9wkpe0vqsj9264q8l92g1` FOREIGN KEY (`work_combination_category_id`) REFERENCES `cw_work_combination_category` (`id`),
  CONSTRAINT `FKiemn4w6ha3h2vvua7v4bhmgsd` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_work_combination_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_work_combination_wl`
--

CREATE TABLE `cw_general_validation_2_work_combination_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `work_combination_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKlryxfldb9038awwvw6q1iu3jx` (`general_validation_id`),
  KEY `FK9fen7tj012p8obvl1dqo8h3fg` (`work_combination_id`),
  CONSTRAINT `FK9fen7tj012p8obvl1dqo8h3fg` FOREIGN KEY (`work_combination_id`) REFERENCES `cw_work_combination` (`id`),
  CONSTRAINT `FKlryxfldb9038awwvw6q1iu3jx` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_work_combination_wl`
--


--
-- Table structure for table `cw_general_validation_2_workflow_type_category_bl`
--

CREATE TABLE `cw_general_validation_2_workflow_type_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workflow_type_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKi1vtvu57j403pumuscjwe1tuj` (`general_validation_id`),
  KEY `FKic6dh4gubl8hf4ucoy0xf8d27` (`workflow_type_category_id`),
  CONSTRAINT `FKi1vtvu57j403pumuscjwe1tuj` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKic6dh4gubl8hf4ucoy0xf8d27` FOREIGN KEY (`workflow_type_category_id`) REFERENCES `cw_workflow_type_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workflow_type_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_workflow_type_category_wl`
--

CREATE TABLE `cw_general_validation_2_workflow_type_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workflow_type_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgttf81kkoskjoj1cglhmg6p1m` (`general_validation_id`),
  KEY `FKecyd5l2yej9sjni0mrre5wymi` (`workflow_type_category_id`),
  CONSTRAINT `FKecyd5l2yej9sjni0mrre5wymi` FOREIGN KEY (`workflow_type_category_id`) REFERENCES `cw_workflow_type_category` (`id`),
  CONSTRAINT `FKgttf81kkoskjoj1cglhmg6p1m` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workflow_type_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_workflow_type_wl`
--

CREATE TABLE `cw_general_validation_2_workflow_type_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workflow_type_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK28aensfr1x8cx4jc9td5gy90c` (`general_validation_id`),
  KEY `FKcsq4blntxo00x3woe3sg778mj` (`workflow_type_id`),
  CONSTRAINT `FK28aensfr1x8cx4jc9td5gy90c` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKcsq4blntxo00x3woe3sg778mj` FOREIGN KEY (`workflow_type_id`) REFERENCES `cw_workflow_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workflow_type_wl`
--


--
-- Table structure for table `cw_general_validation_2_workplace_category_bl`
--

CREATE TABLE `cw_general_validation_2_workplace_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workplace_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK4epeg5ftvbn8edc96roenk8yv` (`general_validation_id`),
  KEY `FKr6kng98tmhuodafabcb88a1xd` (`workplace_category_id`),
  CONSTRAINT `FK4epeg5ftvbn8edc96roenk8yv` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKr6kng98tmhuodafabcb88a1xd` FOREIGN KEY (`workplace_category_id`) REFERENCES `cw_workplace_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workplace_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_workplace_category_wl`
--

CREATE TABLE `cw_general_validation_2_workplace_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workplace_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKdbaogb0jn2umyy5ki75vfu5ve` (`general_validation_id`),
  KEY `FK7ev72hvifqbl2h60g3fkmqngw` (`workplace_category_id`),
  CONSTRAINT `FK7ev72hvifqbl2h60g3fkmqngw` FOREIGN KEY (`workplace_category_id`) REFERENCES `cw_workplace_category` (`id`),
  CONSTRAINT `FKdbaogb0jn2umyy5ki75vfu5ve` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workplace_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_workplace_wl`
--

CREATE TABLE `cw_general_validation_2_workplace_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workplace_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKto1lor11djgn368qw0kkp8jr4` (`general_validation_id`),
  KEY `FKidni345awl6r3na71vb18viv4` (`workplace_id`),
  CONSTRAINT `FKidni345awl6r3na71vb18viv4` FOREIGN KEY (`workplace_id`) REFERENCES `cw_workplace` (`id`),
  CONSTRAINT `FKto1lor11djgn368qw0kkp8jr4` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workplace_wl`
--


--
-- Table structure for table `cw_general_validation_2_workprocess_category_bl`
--

CREATE TABLE `cw_general_validation_2_workprocess_category_bl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workprocess_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKpvs4vjs2fcarj61a1lg3fkce4` (`general_validation_id`),
  KEY `FKfa32h2oknw86v2pmk1mtqucj3` (`workprocess_category_id`),
  CONSTRAINT `FKfa32h2oknw86v2pmk1mtqucj3` FOREIGN KEY (`workprocess_category_id`) REFERENCES `cw_workprocess_category` (`id`),
  CONSTRAINT `FKpvs4vjs2fcarj61a1lg3fkce4` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workprocess_category_bl`
--


--
-- Table structure for table `cw_general_validation_2_workprocess_category_wl`
--

CREATE TABLE `cw_general_validation_2_workprocess_category_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workprocess_category_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK30lx6ubpga56t50vucbrfp104` (`general_validation_id`),
  KEY `FKi0h7hupx9r8jetjnn2d3bi2r8` (`workprocess_category_id`),
  CONSTRAINT `FK30lx6ubpga56t50vucbrfp104` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKi0h7hupx9r8jetjnn2d3bi2r8` FOREIGN KEY (`workprocess_category_id`) REFERENCES `cw_workprocess_category` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workprocess_category_wl`
--


--
-- Table structure for table `cw_general_validation_2_workprocess_wl`
--

CREATE TABLE `cw_general_validation_2_workprocess_wl` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `general_validation_id` bigint(20) NOT NULL,
  `workprocess_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK9p2u5guwqk1nrq5867rfaerbn` (`general_validation_id`),
  KEY `FKillxv4j65rewjo0qlivxr9p2h` (`workprocess_id`),
  CONSTRAINT `FK9p2u5guwqk1nrq5867rfaerbn` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKillxv4j65rewjo0qlivxr9p2h` FOREIGN KEY (`workprocess_id`) REFERENCES `cw_workprocess` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_2_workprocess_wl`
--


--
-- Table structure for table `cw_general_validation_cw_area`
--

CREATE TABLE `cw_general_validation_cw_area` (
  `general_validation_whitelist_areas_id` bigint(20) NOT NULL,
  `area_id` bigint(20) DEFAULT NULL,
  KEY `FK4dxfadx3f96ork49anrelyfao` (`area_id`),
  KEY `FK3j5e5s0voln7fefuiip4t7b9e` (`general_validation_whitelist_areas_id`),
  CONSTRAINT `FK3j5e5s0voln7fefuiip4t7b9e` FOREIGN KEY (`general_validation_whitelist_areas_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FK4dxfadx3f96ork49anrelyfao` FOREIGN KEY (`area_id`) REFERENCES `cw_area` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_cw_area`
--


--
-- Table structure for table `cw_general_validation_cw_area_category`
--

CREATE TABLE `cw_general_validation_cw_area_category` (
  `general_validation_blacklist_area_categories_id` bigint(20) NOT NULL,
  `area_category_id` bigint(20) DEFAULT NULL,
  `general_validation_whitelist_area_categories_id` bigint(20) NOT NULL,
  KEY `FKaqsreg7ddo20pptulp82r5php` (`area_category_id`),
  KEY `FKob4tem9anj3owbemivo9tqhls` (`general_validation_blacklist_area_categories_id`),
  KEY `FKfbn6tj0wx47e6tbxahuovydw1` (`general_validation_whitelist_area_categories_id`),
  CONSTRAINT `FKaqsreg7ddo20pptulp82r5php` FOREIGN KEY (`area_category_id`) REFERENCES `cw_area_category` (`id`),
  CONSTRAINT `FKfbn6tj0wx47e6tbxahuovydw1` FOREIGN KEY (`general_validation_whitelist_area_categories_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKob4tem9anj3owbemivo9tqhls` FOREIGN KEY (`general_validation_blacklist_area_categories_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_general_validation_cw_area_category`
--


--
-- Table structure for table `cw_gps_address`
--

CREATE TABLE `cw_gps_address` (
  `id` bigint(20) NOT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `latLng_idx` (`latitude`,`longitude`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gps_address`
--


--
-- Table structure for table `cw_gps_booking`
--

CREATE TABLE `cw_gps_booking` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `gps_address_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `terminal_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `valid_gps_position` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKaro9984wj326iin6yyc0t6vrp` (`gps_address_id`),
  KEY `query1_idx` (`date`),
  KEY `query2_idx` (`terminal_id`),
  KEY `query3_idx` (`terminal_id`,`date`),
  KEY `query4_idx` (`date`,`valid_gps_position`),
  KEY `query5_idx` (`terminal_id`,`valid_gps_position`),
  KEY `query6_idx` (`terminal_id`,`date`,`valid_gps_position`),
  CONSTRAINT `FKaro9984wj326iin6yyc0t6vrp` FOREIGN KEY (`gps_address_id`) REFERENCES `cw_gps_address` (`id`),
  CONSTRAINT `FKbs1dj4pmy5m76lwvxeqlm2i3a` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_gps_booking`
--


--
-- Table structure for table `cw_group_definition`
--

CREATE TABLE `cw_group_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=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_group_definition`
--

INSERT INTO `cw_group_definition` VALUES
(1,2,'\0','Gruppierung Personalzeit','Gruppierung Zeit','Abteilung'),
(2,0,'\0','keine Gruppierung','kG',''),
(3,0,'\0','Gruppierung Zutrittskontrolle','Gruppierung Zutritt','Abteilung'),
(4,0,'\0','Gruppierung Abteilung','Gruppierung Abteilung','Abteilung');

--
-- Table structure for table `cw_group_definition_detail`
--

CREATE TABLE `cw_group_definition_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `deleted` bit(1) NOT NULL,
  `group_definition_id` bigint(20) NOT NULL,
  `group_expression` varchar(255) NOT NULL,
  `position` int(11) NOT NULL,
  `show_group_footer` bit(1) DEFAULT NULL,
  `show_group_header` bit(1) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `start_new_page` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKmq7cnrm4kffukrwkcxwow0fd9` (`group_definition_id`),
  CONSTRAINT `FKmq7cnrm4kffukrwkcxwow0fd9` FOREIGN KEY (`group_definition_id`) REFERENCES `cw_group_definition` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_group_definition_detail`
--

INSERT INTO `cw_group_definition_detail` VALUES
(1,2,'\0',1,'person..personCategories..personCategoryType=$firstTimePersonCategory..description',1,'','','Group1','\0'),
(2,1,'\0',3,'person..personCategories..personCategoryType=$firstAccessPersonCategory..description',1,'','','Group1','\0'),
(3,1,'\0',4,'person..personCategories..personCategoryType=department..name',1,'','','Group1','\0');

--
-- Table structure for table `cw_hook_script`
--

CREATE TABLE `cw_hook_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,
  `hook_type_enum` 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_hook_script`
--


--
-- Table structure for table `cw_host`
--

CREATE TABLE `cw_host` (
  `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,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_host`
--

INSERT INTO `cw_host` VALUES
(1,0,'2018-02-07 11:13:54','\0','Kunde','2018-02-07 11:13:54','Kunde',0,'');

--
-- Table structure for table `cw_identification`
--

CREATE TABLE `cw_identification` (
  `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,
  `number` varchar(255) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `number_idx` (`number`,`deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_identification`
--

INSERT INTO `cw_identification` VALUES
(1,0,'2021-04-07 01:22:18','\0','2021-04-07 01:22:18','MifareClassic',0);

--
-- Table structure for table `cw_identification_2_identification_code`
--

CREATE TABLE `cw_identification_2_identification_code` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `identification_id` bigint(20) NOT NULL,
  `identification_code_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKkoc7sl482bjd2rxavk84pj9aa` (`identification_id`),
  KEY `FKegwmi3heumkq1f2wkxh163y6l` (`identification_code_id`),
  CONSTRAINT `FKegwmi3heumkq1f2wkxh163y6l` FOREIGN KEY (`identification_code_id`) REFERENCES `cw_identification_code` (`id`),
  CONSTRAINT `FKkoc7sl482bjd2rxavk84pj9aa` FOREIGN KEY (`identification_id`) REFERENCES `cw_identification` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_identification_2_identification_code`
--

INSERT INTO `cw_identification_2_identification_code` VALUES
(1,0,1,1);

--
-- Table structure for table `cw_identification_code`
--

CREATE TABLE `cw_identification_code` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `code` varchar(255) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `identification_type_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKss94523r85gdcyjn2snpcmaoc` (`identification_type_id`),
  CONSTRAINT `FKss94523r85gdcyjn2snpcmaoc` FOREIGN KEY (`identification_type_id`) REFERENCES `cw_identification_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_identification_code`
--

INSERT INTO `cw_identification_code` VALUES
(1,0,'12345678','2021-04-07 01:22:18','\0',3,'2021-04-07 01:22:18',0);

--
-- Table structure for table `cw_identification_type`
--

CREATE TABLE `cw_identification_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `cwid` int(11) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_identification_type`
--

INSERT INTO `cw_identification_type` VALUES
(1,0,1,'2018-02-07 00:36:40','\0','Proxy 24','2018-02-07 00:36:40',0),
(2,0,2,'2018-02-07 00:36:40','\0','Proxy 40','2018-02-07 00:36:40',0),
(3,2,3,'2018-02-07 00:36:40','\0','Mifare Classic unique','2019-06-10 23:55:11',0),
(4,0,4,'2018-02-07 00:36:40','\0','Legic unique','2018-02-07 00:36:40',0),
(5,1,5,'2018-02-07 00:36:40','\0','Legic Gantner-Segment','2019-02-25 18:36:37',0),
(6,0,6,'2018-02-07 00:36:41','\0','Bluetooth Low Energy','2018-02-07 00:36:41',0),
(7,0,7,'2018-02-07 00:36:41','\0','PIN','2018-02-07 00:36:41',0),
(8,0,8,'2019-02-25 18:36:36','\0','Mifare Desfire unique','2019-02-25 18:36:36',0),
(9,0,9,'2019-02-25 18:36:37','\0','Legic Clockwork-Segment','2019-02-25 18:36:37',0),
(10,0,10,'2020-02-04 10:54:41','\0','Seccor','2020-02-04 10:54:41',0),
(11,0,11,'2020-02-04 10:54:42','\0','Keyflex_Seccor','2020-02-04 10:54:42',0),
(12,0,12,'2020-02-04 10:54:42','\0','Hitag 1','2020-02-04 10:54:42',0),
(13,0,13,'2020-02-04 10:54:42','\0','Hitag 2','2020-02-04 10:54:42',0),
(14,0,14,'2020-02-04 10:54:42','\0','Hitag S','2020-02-04 10:54:42',0),
(15,0,15,'2020-02-04 10:54:43','\0','I-Code','2020-02-04 10:54:43',0);

--
-- Table structure for table `cw_import_article`
--

CREATE TABLE `cw_import_article` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_article`
--


--
-- Table structure for table `cw_import_booking_file`
--

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

--
-- Dumping data for table `cw_import_booking_file`
--


--
-- Table structure for table `cw_import_booking_file_2_field`
--

CREATE TABLE `cw_import_booking_file_2_field` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `end_position` int(11) DEFAULT NULL,
  `import_booking_field_enum` varchar(255) NOT NULL,
  `import_booking_file_id` bigint(20) NOT NULL,
  `last_updated` datetime DEFAULT NULL,
  `left_trim_blank` bit(1) NOT NULL,
  `left_trim_zero` bit(1) NOT NULL,
  `position` int(11) NOT NULL,
  `right_trim_blank` bit(1) NOT NULL,
  `right_trim_zero` bit(1) NOT NULL,
  `script_code` longtext DEFAULT NULL,
  `separated_position` int(11) DEFAULT NULL,
  `start_position` int(11) DEFAULT NULL,
  `update_counter` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKh46w5rrymw28m38y289d616g7` (`import_booking_file_id`),
  CONSTRAINT `FKh46w5rrymw28m38y289d616g7` FOREIGN KEY (`import_booking_file_id`) REFERENCES `cw_import_booking_file` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_booking_file_2_field`
--


--
-- Table structure for table `cw_import_cost_unit`
--

CREATE TABLE `cw_import_cost_unit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_cost_unit`
--


--
-- Table structure for table `cw_import_machine`
--

CREATE TABLE `cw_import_machine` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_machine`
--


--
-- Table structure for table `cw_import_order`
--

CREATE TABLE `cw_import_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_order`
--


--
-- Table structure for table `cw_import_person`
--

CREATE TABLE `cw_import_person` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_person`
--


--
-- Table structure for table `cw_import_project`
--

CREATE TABLE `cw_import_project` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_project`
--


--
-- Table structure for table `cw_import_user`
--

CREATE TABLE `cw_import_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_user`
--


--
-- Table structure for table `cw_import_workplace`
--

CREATE TABLE `cw_import_workplace` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_workplace`
--


--
-- Table structure for table `cw_import_workprocess`
--

CREATE TABLE `cw_import_workprocess` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `xml_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_import_workprocess`
--


--
-- Table structure for table `cw_index`
--

CREATE TABLE `cw_index` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `cw_id` int(11) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `done` bit(1) NOT NULL,
  `executed` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `mssqlcreate_index` varchar(255) DEFAULT NULL,
  `mssqldrop_index` varchar(255) DEFAULT NULL,
  `mysqlcreate_index` varchar(255) DEFAULT NULL,
  `mysqldrop_index` varchar(255) DEFAULT NULL,
  `result` longtext DEFAULT NULL,
  `drop_value` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_index`
--

INSERT INTO `cw_index` VALUES
(1,1,1,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index number_idx on cw_absence (number)','drop index number_idx on cw_absence','create index number_idx on cw_absence (number)','drop index number_idx on cw_absence','OK','\0'),
(2,1,2,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query1_idx on cw_absence_planning (person_id, date, deleted, denied)','drop index query1_idx on cw_absence_planning','create index query1_idx on cw_absence_planning (person_id, date, deleted, denied)','drop index query1_idx on cw_absence_planning','OK','\0'),
(3,1,60,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query2_idx on cw_absence_planning (person_id)','drop index query2_idx on cw_absence_planning','create index query2_idx on cw_absence_planning (person_id)','drop index query2_idx on cw_absence_planning','OK','\0'),
(4,1,61,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query2_idx on cw_absence_planning_request (person_id, deleted, accepted, denied)','drop index query2_idx on cw_absence_planning_request','create index query2_idx on cw_absence_planning_request (person_id, deleted, accepted, denied)','drop index query2_idx on cw_absence_planning_request','OK','\0'),
(5,1,62,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query3_idx on cw_absence_planning_request (person_id, date_from, deleted, accepted, forwarded, denied)','drop index query3_idx on cw_absence_planning_request','create index query3_idx on cw_absence_planning_request (person_id, date_from, deleted, accepted, forwarded, denied)','drop index query3_idx on cw_absence_planning_request','OK','\0'),
(6,1,73,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index number_idx on cw_article (number)','drop index number_idx on cw_article','create index number_idx on cw_article (number)','drop index number_idx on cw_article','OK','\0'),
(7,1,4,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query1_idx on cw_booking (person_id, date)','drop index query1_idx on cw_booking','create index query1_idx on cw_booking (person_id, date)','drop index query1_idx on cw_booking','OK','\0'),
(8,1,5,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query2_idx on cw_booking (person_id, date, deleted)','drop index query2_idx on cw_booking','create index query2_idx on cw_booking (person_id, date, deleted)','drop index query2_idx on cw_booking','OK','\0'),
(9,1,6,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query3_idx on cw_booking (date, deleted)','drop index query3_idx on cw_booking','create index query3_idx on cw_booking (date, deleted)','drop index query3_idx on cw_booking','OK','\0'),
(10,1,7,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query4_idx on cw_booking (person_id, deleted)','drop index query4_idx on cw_booking','create index query4_idx on cw_booking (person_id, deleted)','drop index query4_idx on cw_booking','OK','\0'),
(11,1,8,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query5_idx on cw_booking (extern_id)','drop index query5_idx on cw_booking','create index query5_idx on cw_booking (extern_id)','drop index query5_idx on cw_booking','OK','\0'),
(12,1,43,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query6_idx on cw_booking (person_id, gps_booking_id, deleted)','drop index query6_idx on cw_booking','create index query6_idx on cw_booking (person_id, gps_booking_id, deleted)','drop index query6_idx on cw_booking','OK','\0'),
(13,1,44,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query7_idx on cw_booking (gps_booking_id, date, deleted)','drop index query7_idx on cw_booking','create index query7_idx on cw_booking (gps_booking_id, date, deleted)','drop index query7_idx on cw_booking','OK','\0'),
(14,1,47,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query8_idx on cw_booking (gps_booking_id)','drop index query8_idx on cw_booking','create index query8_idx on cw_booking (gps_booking_id)','drop index query8_idx on cw_booking','OK','\0'),
(15,1,49,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query9_idx on cw_booking (terminal_id, date, gps_booking_id, deleted)','drop index query9_idx on cw_booking','create index query9_idx on cw_booking (terminal_id, date, gps_booking_id, deleted)','drop index query9_idx on cw_booking','OK','\0'),
(16,1,59,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query10_idx on cw_booking (person_id, date, deleted, booking_type)','drop index query10_idx on cw_booking','create index query10_idx on cw_booking (person_id, date, deleted, booking_type)','drop index query10_idx on cw_booking','OK','\0'),
(17,1,9,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query1_idx on cw_clockwork_foxpro_spooler (domain_class)','drop index query1_idx on cw_clockwork_foxpro_spooler','create index query1_idx on cw_clockwork_foxpro_spooler (domain_class)','drop index query1_idx on cw_clockwork_foxpro_spooler','OK','\0'),
(18,1,41,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query2_idx on cw_clockwork_foxpro_spooler (domain_class, domain_class_id)','drop index query2_idx on cw_clockwork_foxpro_spooler','create index query2_idx on cw_clockwork_foxpro_spooler (domain_class, domain_class_id)','drop index query2_idx on cw_clockwork_foxpro_spooler','OK','\0'),
(19,1,63,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query3_idx on cw_booking_request (person_id, date, deleted, accepted, denied)','drop index query3_idx on cw_booking_request','create index query3_idx on cw_booking_request (person_id, date, deleted, accepted, denied)','drop index query3_idx on cw_booking_request','OK','\0'),
(20,1,64,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query4_idx on cw_booking_request (person_id, date, deleted, accepted, denied, forwarded)','drop index query4_idx on cw_booking_request','create index query4_idx on cw_booking_request (person_id, date, deleted, accepted, denied, forwarded)','drop index query4_idx on cw_booking_request','OK','\0'),
(21,1,12,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index number_idx on cw_cost_unit (number)','drop index number_idx on cw_cost_unit','create index number_idx on cw_cost_unit (number)','drop index number_idx on cw_cost_unit','OK','\0'),
(22,1,42,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query1_idx on cw_event_base_data (terminal_id)','drop index query1_idx on cw_event_base_data','create index query1_idx on cw_event_base_data (terminal_id)','drop index query1_idx on cw_event_base_data','OK','\0'),
(23,1,69,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query2_idx on cw_event_base_data (terminal_id, done)','drop index query2_idx on cw_event_base_data','create index query2_idx on cw_event_base_data (terminal_id, done)','drop index query2_idx on cw_event_base_data','OK','\0'),
(24,1,72,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query3_idx on cw_event_base_data (terminal_id, date, done)','drop index query3_idx on cw_event_base_data','create index query3_idx on cw_event_base_data (terminal_id, date, done)','drop index query3_idx on cw_event_base_data','OK','\0'),
(25,1,55,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index latLng_idx on cw_gps_address (latitude, longitude)','drop index latLng_idx on cw_gps_address','create index latLng_idx on cw_gps_address (latitude, longitude)','drop index latLng_idx on cw_gps_address','OK','\0'),
(26,1,45,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query1_idx on cw_gps_booking (date)','drop index query1_idx on cw_gps_booking','create index query1_idx on cw_gps_booking (date)','drop index query1_idx on cw_gps_booking','OK','\0'),
(27,1,46,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query2_idx on cw_gps_booking (terminal_id)','drop index query2_idx on cw_gps_booking','create index query2_idx on cw_gps_booking (terminal_id)','drop index query2_idx on cw_gps_booking','OK','\0'),
(28,1,48,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query3_idx on cw_gps_booking (terminal_id, date)','drop index query3_idx on cw_gps_booking','create index query3_idx on cw_gps_booking (terminal_id, date)','drop index query3_idx on cw_gps_booking','OK','\0'),
(29,1,50,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query4_idx on cw_gps_booking (date, valid_gps_position)','drop index query4_idx on cw_gps_booking','create index query4_idx on cw_gps_booking (date, valid_gps_position)','drop index query4_idx on cw_gps_booking','OK','\0'),
(30,1,51,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query5_idx on cw_gps_booking (terminal_id, valid_gps_position)','drop index query5_idx on cw_gps_booking','create index query5_idx on cw_gps_booking (terminal_id, valid_gps_position)','drop index query5_idx on cw_gps_booking','OK','\0'),
(31,1,52,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query6_idx on cw_gps_booking (terminal_id, date, valid_gps_position)','drop index query6_idx on cw_gps_booking','create index query6_idx on cw_gps_booking (terminal_id, date, valid_gps_position)','drop index query6_idx on cw_gps_booking','OK','\0'),
(32,1,13,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query1_idx on cw_log_communication (terminal_id)','drop index query1_idx on cw_log_communication','create index query1_idx on cw_log_communication (terminal_id)','drop index query1_idx on cw_log_communication','OK','\0'),
(33,1,56,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query2_idx on cw_log_communication (device_id)','drop index query2_idx on cw_log_communication','create index query2_idx on cw_log_communication (device_id)','drop index query2_idx on cw_log_communication','OK','\0'),
(34,1,57,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query3_idx on cw_log_communication (terminal_id, timestamp_start)','drop index query3_idx on cw_log_communication','create index query3_idx on cw_log_communication (terminal_id, timestamp_start)','drop index query3_idx on cw_log_communication','OK','\0'),
(35,1,58,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query4_idx on cw_log_communication (timestamp_start)','drop index query4_idx on cw_log_communication','create index query4_idx on cw_log_communication (timestamp_start)','drop index query4_idx on cw_log_communication','OK','\0'),
(36,1,15,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index query5_idx on cw_log_communication (terminal_id, device_id)','drop index query5_idx on cw_log_communication','create index query5_idx on cw_log_communication (terminal_id, device_id)','drop index query5_idx on cw_log_communication','OK','\0'),
(37,1,16,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index number_idx on cw_order (number)','drop index number_idx on cw_order','create index number_idx on cw_order (number)','drop index number_idx on cw_order','OK','\0'),
(38,1,18,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:09','2018-02-07 00:36:09','create index number_idx on cw_order_item (number)','drop index number_idx on cw_order_item','create index number_idx on cw_order_item (number)','drop index number_idx on cw_order_item','OK','\0'),
(39,1,19,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index number_and_order_idx on cw_order_item (number, order_id)','drop index number_and_order_idx on cw_order_item','create index number_and_order_idx on cw_order_item (number, order_id)','drop index number_and_order_idx on cw_order_item','OK','\0'),
(40,1,20,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_order_item (order_id, deleted)','drop index query1_idx on cw_order_item','create index query1_idx on cw_order_item (order_id, deleted)','drop index query1_idx on cw_order_item','OK','\0'),
(41,1,21,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_order_item_planning (deleted, state, finish_time)','drop index query1_idx on cw_order_item_planning','create index query1_idx on cw_order_item_planning (deleted, state, finish_time)','drop index query1_idx on cw_order_item_planning','OK','\0'),
(42,1,22,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_order_item_planning_detail (order_item_planning_id, deleted)','drop index query1_idx on cw_order_item_planning_detail','create index query1_idx on cw_order_item_planning_detail (order_item_planning_id, deleted)','drop index query1_idx on cw_order_item_planning_detail','OK','\0'),
(43,1,23,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query2_idx on cw_order_item_planning_detail (order_item_id, deleted)','drop index query2_idx on cw_order_item_planning_detail','create index query2_idx on cw_order_item_planning_detail (order_item_id, deleted)','drop index query2_idx on cw_order_item_planning_detail','OK','\0'),
(44,1,24,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index number_idx on cw_person (number)','drop index number_idx on cw_person','create index number_idx on cw_person (number)','drop index number_idx on cw_person','OK','\0'),
(45,1,25,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index person_idx on cw_person_2_person_category (person_id)','drop index person_idx on cw_person_2_person_category','create index person_idx on cw_person_2_person_category (person_id)','drop index person_idx on cw_person_2_person_category','OK','\0'),
(46,1,26,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index person_category_idx on cw_person_2_person_category (person_category_id)','drop index person_category_idx on cw_person_2_person_category','create index person_category_idx on cw_person_2_person_category (person_category_id)','drop index person_category_idx on cw_person_2_person_category','OK','\0'),
(47,1,53,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index person_idx on cw_person_2_qualification (person_id)','drop index person_idx on cw_person_2_qualification','create index person_idx on cw_person_2_qualification (person_id)','drop index person_idx on cw_person_2_qualification','OK','\0'),
(48,1,54,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index qualification_idx on cw_person_2_qualification (qualification_id)','drop index qualification_idx on cw_person_2_qualification','create index qualification_idx on cw_person_2_qualification (qualification_id)','drop index qualification_idx on cw_person_2_qualification','OK','\0'),
(49,1,27,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index address_idx on cw_terminal (address)','drop index address_idx on cw_terminal','create index address_idx on cw_terminal (address)','drop index address_idx on cw_terminal','OK','\0'),
(50,1,82,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index number_idx on cw_terminal (number)','drop index number_idx on cw_terminal','create index number_idx on cw_terminal (number)','drop index number_idx on cw_terminal','OK','\0'),
(51,1,28,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_terminal_communication (terminal_id)','drop index query1_idx on cw_terminal_communication','create index query1_idx on cw_terminal_communication (terminal_id)','drop index query1_idx on cw_terminal_communication','OK','\0'),
(52,1,29,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query2_idx on cw_terminal_communication (deleted, done, terminal_id)','drop index query2_idx on cw_terminal_communication','create index query2_idx on cw_terminal_communication (deleted, done, terminal_id)','drop index query2_idx on cw_terminal_communication','OK','\0'),
(53,1,70,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index time_time_model_idx on cw_time_model_2_detail (time_time_model_id)','drop index time_time_model_idx on cw_time_model_2_detail','create index time_time_model_idx on cw_time_model_2_detail (time_time_model_id)','drop index time_time_model_idx on cw_time_model_2_detail','OK','\0'),
(54,1,71,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index time_time_plan_idx on cw_time_plan_2_detail (time_time_plan_id)','drop index time_time_plan_idx on cw_time_plan_2_detail','create index time_time_plan_idx on cw_time_plan_2_detail (time_time_plan_id)','drop index time_time_plan_idx on cw_time_plan_2_detail','OK','\0'),
(55,1,30,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index number_idx on cw_time_time_type (number)','drop index number_idx on cw_time_time_type','create index number_idx on cw_time_time_type (number)','drop index number_idx on cw_time_time_type','OK','\0'),
(56,3,31,'2018-02-07 00:36:09','\0','','2025-03-19 11:55:36','2025-03-19 11:55:36','create index query1_idx on cw_time_time_type_data (person_id, time_time_type_id)','drop index query1_idx on cw_time_time_type_data','create index query1_idx on cw_time_time_type_data (person_id, time_time_type_id)','drop index query1_idx on cw_time_time_type_data','OK',''),
(57,4,32,'2018-02-07 00:36:09','\0','','2025-03-24 00:42:06','2025-03-24 00:42:06','create index query2_idx on cw_time_time_type_data (person_id, date)','drop index query2_idx on cw_time_time_type_data','create index query2_idx on cw_time_time_type_data (person_id, date)','drop index query2_idx on cw_time_time_type_data','OK',''),
(58,1,67,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_time_time_type_data_credit (person_id, time_time_type_id, date, deleted)','drop index query1_idx on cw_time_time_type_data_credit','create index query1_idx on cw_time_time_type_data_credit (person_id, time_time_type_id, date, deleted)','drop index query1_idx on cw_time_time_type_data_credit','OK','\0'),
(59,1,68,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_time_time_type_data_initial (person_id, time_time_type_id, date, deleted)','drop index query1_idx on cw_time_time_type_data_initial','create index query1_idx on cw_time_time_type_data_initial (person_id, time_time_type_id, date, deleted)','drop index query1_idx on cw_time_time_type_data_initial','OK','\0'),
(60,1,65,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_calculation_day_info (person_id, date)','drop index query1_idx on cw_calculation_day_info','create index query1_idx on cw_calculation_day_info (person_id, date)','drop index query1_idx on cw_calculation_day_info','OK','\0'),
(61,1,35,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index user_idx on cw_user_operator_role (user_id)','drop index user_idx on cw_user_operator_role','create index user_idx on cw_user_operator_role (user_id)','drop index user_idx on cw_user_operator_role','OK','\0'),
(62,2,36,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2022-07-02 00:43:32','create index query1_idx on cw_work_combination (work_combination_type_id, description, description2, description3)','drop index query1_idx on cw_work_combination','create index query1_idx on cw_work_combination (work_combination_type_id, description, description2, description3)','drop index query1_idx on cw_work_combination','OK','\0'),
(63,1,37,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index number_idx on cw_workprocess (number)','drop index number_idx on cw_workprocess','create index number_idx on cw_workprocess (number)','drop index number_idx on cw_workprocess','OK','\0'),
(64,1,38,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index number_idx on cw_work_time_type (number)','drop index number_idx on cw_work_time_type','create index number_idx on cw_work_time_type (number)','drop index number_idx on cw_work_time_type','OK','\0'),
(65,1,39,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_work_time_type_data (person_id, work_time_type_id, date)','drop index query1_idx on cw_work_time_type_data','create index query1_idx on cw_work_time_type_data (person_id, work_time_type_id, date)','drop index query1_idx on cw_work_time_type_data','OK','\0'),
(66,1,74,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_additional_data (name, additional_data_format_enum, deleted, class)','drop index query1_idx on cw_additional_data','create index query1_idx on cw_additional_data (name, additional_data_format_enum, deleted, class)','drop index query1_idx on cw_additional_data','OK','\0'),
(67,1,75,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_project_2_additional_data (project_id, project_additional_data_id)','drop index query1_idx on cw_project_2_additional_data','create index query1_idx on cw_project_2_additional_data (project_id, project_additional_data_id)','drop index query1_idx on cw_project_2_additional_data','OK','\0'),
(68,1,76,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_order_2_additional_data (order_id, order_additional_data_id)','drop index query1_idx on cw_order_2_additional_data','create index query1_idx on cw_order_2_additional_data (order_id, order_additional_data_id)','drop index query1_idx on cw_order_2_additional_data','OK','\0'),
(69,1,77,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_order_item_2_additional_data (order_item_id, order_item_additional_data_id)','drop index query1_idx on cw_order_item_2_additional_data','create index query1_idx on cw_order_item_2_additional_data (order_item_id, order_item_additional_data_id)','drop index query1_idx on cw_order_item_2_additional_data','OK','\0'),
(70,1,78,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_cost_unit_2_additional_data (cost_unit_id, cost_unit_additional_data_id)','drop index query1_idx on cw_cost_unit_2_additional_data','create index query1_idx on cw_cost_unit_2_additional_data (cost_unit_id, cost_unit_additional_data_id)','drop index query1_idx on cw_cost_unit_2_additional_data','OK','\0'),
(71,1,79,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_machine_2_additional_data (machine_id, machine_additional_data_id)','drop index query1_idx on cw_machine_2_additional_data','create index query1_idx on cw_machine_2_additional_data (machine_id, machine_additional_data_id)','drop index query1_idx on cw_machine_2_additional_data','OK','\0'),
(72,1,80,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_workplace_2_additional_data (workplace_id, workplace_additional_data_id)','drop index query1_idx on cw_workplace_2_additional_data','create index query1_idx on cw_workplace_2_additional_data (workplace_id, workplace_additional_data_id)','drop index query1_idx on cw_workplace_2_additional_data','OK','\0'),
(73,1,81,'2018-02-07 00:36:09','\0','','2018-02-07 00:36:10','2018-02-07 00:36:10','create index query1_idx on cw_workprocess_2_additional_data (workprocess_id, workprocess_additional_data_id)','drop index query1_idx on cw_workprocess_2_additional_data','create index query1_idx on cw_workprocess_2_additional_data (workprocess_id, workprocess_additional_data_id)','drop index query1_idx on cw_workprocess_2_additional_data','OK','\0'),
(74,1,83,'2018-05-22 11:22:41','\0','','2018-05-22 11:22:41','2018-05-22 11:22:41','create index person_date_idx on cw_person_2_time_time_model (person_id, date, deleted)','drop index person_date_idx on cw_person_2_time_time_model','create index person_date_idx on cw_person_2_time_time_model (person_id, date, deleted)','drop index person_date_idx on cw_person_2_time_time_model','OK','\0'),
(75,1,84,'2018-05-22 11:22:41','\0','','2018-05-22 11:22:41','2018-05-22 11:22:41','create index person_date_idx on cw_person_2_work_component (person_id, start_date, deleted)','drop index person_date_idx on cw_person_2_work_component','create index person_date_idx on cw_person_2_work_component (person_id, start_date, deleted)','drop index person_date_idx on cw_person_2_work_component','OK','\0'),
(76,1,85,'2018-08-28 10:51:53','\0','','2018-08-28 10:51:53','2018-08-28 10:51:53','create index query1_idx on cw_calculated_time_info (person_id, date)','drop index query1_idx on cw_calculated_time_info','create index query1_idx on cw_calculated_time_info (person_id, date)','drop index query1_idx on cw_calculated_time_info','OK','\0'),
(77,1,86,'2018-08-28 10:51:53','\0','','2018-08-28 10:51:53','2018-08-28 10:51:53','create index query2_idx on cw_calculated_time_info (person_id, date, absence_id)','drop index query2_idx on cw_calculated_time_info','create index query2_idx on cw_calculated_time_info (person_id, date, absence_id)','drop index query2_idx on cw_calculated_time_info','OK','\0'),
(78,1,87,'2019-02-25 18:36:26','\0','','2019-02-25 18:36:26','2019-02-25 18:36:26','create index query4_idx on cw_event_base_data (terminal_id, short_match)','drop index query4_idx on cw_event_base_data','create index query4_idx on cw_event_base_data (terminal_id, short_match)','drop index query4_idx on cw_event_base_data','OK','\0'),
(79,1,88,'2020-02-04 10:54:28','\0','','2020-02-04 10:54:28','2020-02-04 10:54:28','create index query5_idx on cw_event_base_data (done, deleted, date_created, counter)','drop index query5_idx on cw_event_base_data','create index query5_idx on cw_event_base_data (done, deleted, date_created, counter)','drop index query5_idx on cw_event_base_data','OK','\0'),
(80,1,93,'2020-02-04 10:54:28','\0','','2020-02-04 10:54:28','2020-02-04 10:54:28','create index person_idx on cw_person_2_plan_time_reference (person_id, start_date, end_date, deleted)','drop index person_idx on cw_person_2_plan_time_reference','create index person_idx on cw_person_2_plan_time_reference (person_id, start_date, end_date, deleted)','drop index person_idx on cw_person_2_plan_time_reference','OK','\0'),
(81,1,91,'2020-02-04 10:54:28','\0','','2020-02-04 10:54:28','2020-02-04 10:54:28','create index person_date_idx on cw_person_2_time_time_plan (person_id, start_date, end_date, deleted)','drop index person_date_idx on cw_person_2_time_time_plan','create index person_date_idx on cw_person_2_time_time_plan (person_id, start_date, end_date, deleted)','drop index person_date_idx on cw_person_2_time_time_plan','OK','\0'),
(82,1,89,'2020-02-04 10:54:28','\0','','2020-02-04 10:54:28','2020-02-04 10:54:28','create index public_holiday_idx on cw_public_holiday (date, deleted)','drop index public_holiday_idx on cw_public_holiday','create index public_holiday_idx on cw_public_holiday (date, deleted)','drop index public_holiday_idx on cw_public_holiday','OK','\0'),
(83,1,90,'2020-02-04 10:54:28','\0','','2020-02-04 10:54:28','2020-02-04 10:54:28','create index public_holiday_2_detail_idx on cw_public_holiday_2_detail (region_id, religion_id, day_enum, public_holiday_id)','drop index public_holiday_2_detail_idx on cw_public_holiday_2_detail','create index public_holiday_2_detail_idx on cw_public_holiday_2_detail (region_id, religion_id, day_enum, public_holiday_id)','drop index public_holiday_2_detail_idx on cw_public_holiday_2_detail','OK','\0'),
(84,1,94,'2020-02-04 10:54:28','\0','','2020-02-04 10:54:28','2020-02-04 10:54:28','create index time_time_model2_idx on cw_time_model_2_detail (class, time_time_model_id, day_enum, deleted)','drop index time_time_model2_idx on cw_time_model_2_detail','create index time_time_model2_idx on cw_time_model_2_detail (class, time_time_model_id, day_enum, deleted)','drop index time_time_model2_idx on cw_time_model_2_detail','OK','\0'),
(85,1,92,'2020-02-04 10:54:28','\0','','2020-02-04 10:54:28','2020-02-04 10:54:28','create index time_time_plan2_idx on cw_time_plan_2_detail (class, time_time_plan_id, start_date, end_date, deleted)','drop index time_time_plan2_idx on cw_time_plan_2_detail','create index time_time_plan2_idx on cw_time_plan_2_detail (class, time_time_plan_id, start_date, end_date, deleted)','drop index time_time_plan2_idx on cw_time_plan_2_detail','OK','\0'),
(86,1,97,'2021-04-02 17:54:00','\0','','2021-04-02 17:54:00','2021-04-02 17:54:00','create index query6_idx on cw_event_base_data (device_id, short_match)','drop index query6_idx on cw_event_base_data','create index query6_idx on cw_event_base_data (device_id, short_match)','drop index query6_idx on cw_event_base_data','OK','\0'),
(87,1,95,'2021-04-02 17:54:00','\0','','2021-04-02 17:54:00','2021-04-02 17:54:00','create index query1_idx on cw_terminal_data_loaded (terminal_id)','drop index query1_idx on cw_terminal_data_loaded','create index query1_idx on cw_terminal_data_loaded (terminal_id)','drop index query1_idx on cw_terminal_data_loaded','OK','\0'),
(88,1,96,'2021-04-02 17:54:00','\0','','2021-04-02 17:54:00','2021-04-02 17:54:00','create index query2_idx on cw_terminal_data_loaded (terminal_id, command, command_key)','drop index query2_idx on cw_terminal_data_loaded','create index query2_idx on cw_terminal_data_loaded (terminal_id, command, command_key)','drop index query2_idx on cw_terminal_data_loaded','OK','\0'),
(89,1,107,'2021-12-25 22:54:43','\0','','2021-12-25 22:54:44','2021-12-25 22:54:44','create index query1_idx on cw_gantner_person_day_access_schedule_2_detail (gantner_person_day_access_schedule_id, deleted)','drop index query1_idx on cw_gantner_person_day_access_schedule_2_detail','create index query1_idx on cw_gantner_person_day_access_schedule_2_detail (gantner_person_day_access_schedule_id, deleted)','drop index query1_idx on cw_gantner_person_day_access_schedule_2_detail','OK','\0'),
(90,1,101,'2021-12-25 22:54:43','\0','','2021-12-25 22:54:44','2021-12-25 22:54:44','create index query6_idx on cw_log_communication (terminal_id, timestamp_start, timestamp_end, communication_information_type)','drop index query6_idx on cw_log_communication','create index query6_idx on cw_log_communication (terminal_id, timestamp_start, timestamp_end, communication_information_type)','drop index query6_idx on cw_log_communication','OK','\0'),
(91,1,102,'2021-12-25 22:54:43','\0','','2021-12-25 22:54:44','2021-12-25 22:54:44','create index query7_idx on cw_log_communication (device_id, timestamp_start, timestamp_end, communication_information_type)','drop index query7_idx on cw_log_communication','create index query7_idx on cw_log_communication (device_id, timestamp_start, timestamp_end, communication_information_type)','drop index query7_idx on cw_log_communication','OK','\0'),
(92,1,98,'2021-12-25 22:54:43','\0','','2021-12-25 22:54:44','2021-12-25 22:54:44','create index query1_idx on cw_person_access_authorisation (person_id, terminal_id, deleted)','drop index query1_idx on cw_person_access_authorisation','create index query1_idx on cw_person_access_authorisation (person_id, terminal_id, deleted)','drop index query1_idx on cw_person_access_authorisation','OK','\0'),
(93,1,99,'2021-12-25 22:54:43','\0','','2021-12-25 22:54:44','2021-12-25 22:54:44','create index query1_idx on cw_person_category_access_authorisation (person_category_id, terminal_id, deleted)','drop index query1_idx on cw_person_category_access_authorisation','create index query1_idx on cw_person_category_access_authorisation (person_category_id, terminal_id, deleted)','drop index query1_idx on cw_person_category_access_authorisation','OK','\0'),
(94,1,100,'2021-12-25 22:54:43','\0','','2021-12-25 22:54:44','2021-12-25 22:54:44','create index query1_idx on cw_no_person_category_access_authorisation (person_id, terminal_id, deleted)','drop index query1_idx on cw_no_person_category_access_authorisation','create index query1_idx on cw_no_person_category_access_authorisation (person_id, terminal_id, deleted)','drop index query1_idx on cw_no_person_category_access_authorisation','OK','\0'),
(95,1,104,'2021-12-25 22:54:43','\0','','2021-12-25 22:54:44','2021-12-25 22:54:44','create index query1_idx on cw_time_period (person_id, start_date, end_date, generated, deleted)','drop index query1_idx on cw_time_period','create index query1_idx on cw_time_period (person_id, start_date, end_date, generated, deleted)','drop index query1_idx on cw_time_period','OK','\0'),
(96,1,103,'2021-12-25 22:54:44','\0','','2021-12-25 22:54:44','2021-12-25 22:54:44','create index query1_idx on cw_work_period (person_id, start_date, end_date, generated, deleted)','drop index query1_idx on cw_work_period','create index query1_idx on cw_work_period (person_id, start_date, end_date, generated, deleted)','drop index query1_idx on cw_work_period','OK','\0'),
(97,1,108,'2022-07-02 00:43:31','\0','','2022-07-02 00:43:32','2022-07-02 00:43:32','create index query1_idx on cw_changed_balance_spooler (terminal_id)','drop index query1_idx on cw_changed_balance_spooler','create index query1_idx on cw_changed_balance_spooler (terminal_id)','drop index query1_idx on cw_changed_balance_spooler','OK','\0'),
(98,1,109,'2022-07-02 00:43:31','\0','','2022-07-02 00:43:32','2022-07-02 00:43:32','create index query2_idx on cw_changed_balance_spooler (terminal_id, person_id)','drop index query2_idx on cw_changed_balance_spooler','create index query2_idx on cw_changed_balance_spooler (terminal_id, person_id)','drop index query2_idx on cw_changed_balance_spooler','OK','\0'),
(99,1,110,'2022-07-02 00:43:32','\0','','2022-07-02 00:43:32','2022-07-02 00:43:32','create index query2_idx on cw_additional_data (name, deleted, class)','drop index query2_idx on cw_additional_data','create index query2_idx on cw_additional_data (name, deleted, class)','drop index query2_idx on cw_additional_data','OK','\0'),
(100,1,111,'2022-07-02 00:43:32','\0','','2022-07-02 00:43:32','2022-07-02 00:43:32','create index query1_idx on cw_person_2_additional_data (person_id, person_additional_data_id)','drop index query1_idx on cw_person_2_additional_data','create index query1_idx on cw_person_2_additional_data (person_id, person_additional_data_id)','drop index query1_idx on cw_person_2_additional_data','OK','\0'),
(101,1,112,'2022-07-02 00:43:32','\0','','2022-07-02 00:43:32','2022-07-02 00:43:32','create index query2_idx on cw_person_2_additional_data (person_id, person_additional_data_id, start_date, end_date)','drop index query2_idx on cw_person_2_additional_data','create index query2_idx on cw_person_2_additional_data (person_id, person_additional_data_id, start_date, end_date)','drop index query2_idx on cw_person_2_additional_data','OK','\0'),
(102,1,116,'2024-03-07 09:48:40','\0','','2024-03-07 09:48:41','2024-03-07 09:48:41','create index number_idx on cw_identification (number, deleted)','drop index number_idx on cw_identification','create index number_idx on cw_identification (number, deleted)','drop index number_idx on cw_identification','OK','\0'),
(103,1,114,'2024-03-07 09:48:40','\0','','2024-03-07 09:48:41','2024-03-07 09:48:41','create index query8_idx on cw_log_communication (terminal_id, extern_id)','drop index query8_idx on cw_log_communication','create index query8_idx on cw_log_communication (terminal_id, extern_id)','drop index query8_idx on cw_log_communication','OK','\0'),
(104,1,113,'2024-03-07 09:48:40','\0','','2024-03-07 09:48:41','2024-03-07 09:48:41','create index query1_idx on cw_person_date_time_model_2_detail (person_id, date, deleted)','drop index query1_idx on cw_person_date_time_model_2_detail','create index query1_idx on cw_person_date_time_model_2_detail (person_id, date, deleted)','drop index query1_idx on cw_person_date_time_model_2_detail','OK','\0'),
(105,1,115,'2024-03-07 09:48:41','\0','','2024-03-07 09:48:41','2024-03-07 09:48:41','create index query1_idx on cw_market_data (coin_id, timestamp)','drop index query1_idx on cw_market_data','create index query1_idx on cw_market_data (coin_id, timestamp)','drop index query1_idx on cw_market_data','OK','\0'),
(106,1,117,'2024-07-14 18:31:24','\0','','2024-07-14 18:31:25','2024-07-14 18:31:25','create index query1_idx on cw_domain_class (full_name)','drop index query1_idx on cw_domain_class','create index query1_idx on cw_domain_class (full_name)','drop index query1_idx on cw_domain_class','OK','\0'),
(107,1,118,'2024-07-14 18:31:24','\0','','2024-07-14 18:31:25','2024-07-14 18:31:25','create index query2_idx on cw_domain_class_2_field (my_domain_class_id, field_name)','drop index query2_idx on cw_domain_class_2_field','create index query2_idx on cw_domain_class_2_field (my_domain_class_id, field_name)','drop index query2_idx on cw_domain_class_2_field','OK','\0'),
(108,1,120,'2025-03-19 11:55:35','\0','','2025-03-19 11:55:36','2025-03-19 11:55:36','create index query1_idx on cw_absence_planning_detail (absence_planning_id, deleted)','drop index query1_idx on cw_absence_planning_detail','create index query1_idx on cw_absence_planning_detail (absence_planning_id, deleted)','drop index query1_idx on cw_absence_planning_detail','OK','\0'),
(109,1,119,'2025-03-19 11:55:36','\0','','2025-03-19 11:55:36','2025-03-19 11:55:36','create index query3_idx on cw_time_time_type_data (person_id, time_time_type_id, date)','drop index query3_idx on cw_time_time_type_data','create index query3_idx on cw_time_time_type_data (person_id, time_time_type_id, date)','drop index query3_idx on cw_time_time_type_data','OK','\0');

--
-- Table structure for table `cw_individual_time_time_type_group`
--

CREATE TABLE `cw_individual_time_time_type_group` (
  `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 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_individual_time_time_type_group`
--


--
-- Table structure for table `cw_individual_time_time_type_group_2_detail`
--

CREATE TABLE `cw_individual_time_time_type_group_2_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `close_enum` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `individual_close_day` int(11) DEFAULT NULL,
  `individual_close_month` int(11) DEFAULT NULL,
  `individual_time_time_type_group_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `time_time_type_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjww24bh2mi2qfwkbfhs9gm05g` (`individual_time_time_type_group_id`),
  KEY `FKdn9bo2ylw5bs2xoiy932i7bxj` (`time_time_type_id`),
  CONSTRAINT `FKdn9bo2ylw5bs2xoiy932i7bxj` FOREIGN KEY (`time_time_type_id`) REFERENCES `cw_time_time_type` (`id`),
  CONSTRAINT `FKjww24bh2mi2qfwkbfhs9gm05g` FOREIGN KEY (`individual_time_time_type_group_id`) REFERENCES `cw_individual_time_time_type_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_individual_time_time_type_group_2_detail`
--


--
-- Table structure for table `cw_information`
--

CREATE TABLE `cw_information` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `acknowledged` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `email_prepared` datetime DEFAULT NULL,
  `information_type_id` bigint(20) NOT NULL,
  `last_updated` datetime NOT NULL,
  `message_to_clockwork_mobile_prepared` datetime DEFAULT NULL,
  `message_to_terminal_prepared` datetime DEFAULT NULL,
  `sms_prepared` datetime DEFAULT NULL,
  `class` varchar(255) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `person_id` bigint(20) DEFAULT NULL,
  `gps_booking_id` bigint(20) DEFAULT NULL,
  `terminal_id` bigint(20) DEFAULT NULL,
  `door_state_definition2detail_id` bigint(20) DEFAULT NULL,
  `door_state_event_id` bigint(20) DEFAULT NULL,
  `first_timestamp` bigint(20) DEFAULT NULL,
  `last_timestamp` bigint(20) DEFAULT NULL,
  `reversion` bit(1) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKg4j7s7ocowk287auh20fun4nl` (`information_type_id`),
  KEY `FK8m2unufes3rn1btov2mn5qtei` (`person_id`),
  KEY `FK55liahb2dxlqet9vf150fp636` (`gps_booking_id`),
  KEY `FKcnl9orn60qh456eap6us3cyuq` (`terminal_id`),
  KEY `FK6ch2v44t6puvby8dd0a7isdsa` (`door_state_definition2detail_id`),
  KEY `FK63ptt7wntv1263heitpi4qrc0` (`door_state_event_id`),
  CONSTRAINT `FK55liahb2dxlqet9vf150fp636` FOREIGN KEY (`gps_booking_id`) REFERENCES `cw_gps_booking` (`id`),
  CONSTRAINT `FK63ptt7wntv1263heitpi4qrc0` FOREIGN KEY (`door_state_event_id`) REFERENCES `cw_door_state_event` (`id`),
  CONSTRAINT `FK6ch2v44t6puvby8dd0a7isdsa` FOREIGN KEY (`door_state_definition2detail_id`) REFERENCES `cw_door_state_def_2_detail` (`id`),
  CONSTRAINT `FK8m2unufes3rn1btov2mn5qtei` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKcnl9orn60qh456eap6us3cyuq` FOREIGN KEY (`terminal_id`) REFERENCES `cw_terminal` (`id`),
  CONSTRAINT `FKg4j7s7ocowk287auh20fun4nl` FOREIGN KEY (`information_type_id`) REFERENCES `cw_information_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_information`
--

INSERT INTO `cw_information` VALUES
(1,1,NULL,'2024-07-14 18:31:24','',NULL,1,'2024-07-27 23:59:53',NULL,NULL,NULL,'at.clockwork.system.domain.SystemInformation',NULL,'2024-07-14 18:31:23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ToolsService found in EveryDay (id: 3) (class at.clockwork.common.domain.Script.code)'),
(2,0,NULL,'2024-09-10 15:28:24','\0',NULL,1,'2024-09-10 15:28:24',NULL,NULL,NULL,'at.clockwork.system.domain.SystemInformation',NULL,'2024-09-10 15:28:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ToolsService found in EveryDay (id: 3) (class at.clockwork.common.domain.Script.code)');

--
-- Table structure for table `cw_information_type`
--

CREATE TABLE `cw_information_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `acknowledge` bit(1) NOT NULL,
  `acknowledge_text` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description` varchar(255) NOT NULL,
  `email_object_text` varchar(255) DEFAULT NULL,
  `email_subject_text` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `message_clockwork_mobile` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `sendemail` bit(1) NOT NULL,
  `send_message_to_clockwork_mobile` bit(1) NOT NULL,
  `send_message_to_terminal` bit(1) NOT NULL,
  `sendsms` bit(1) NOT NULL,
  `sms_text` varchar(255) DEFAULT NULL,
  `terminal_text` varchar(255) DEFAULT NULL,
  `class` varchar(255) NOT NULL,
  `door_state_definition_id` bigint(20) DEFAULT NULL,
  `hit_after_duration` bigint(20) DEFAULT NULL,
  `hit_every_first_time` bit(1) DEFAULT NULL,
  `hit_every_time` bit(1) DEFAULT NULL,
  `pause_after_hit` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK2wx1kdvh8o74clrkv73g920yr` (`door_state_definition_id`),
  CONSTRAINT `FK2wx1kdvh8o74clrkv73g920yr` FOREIGN KEY (`door_state_definition_id`) REFERENCES `cw_door_state_definition` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_information_type`
--

INSERT INTO `cw_information_type` VALUES
(1,0,'','Administratormeldung','2024-07-14 18:31:19','\0','InformationType für Administratoren','x','x','2024-07-14 18:31:19','x','AdministratorInformationType','\0','\0','\0','\0','x','x','at.clockwork.common.domain.InformationType',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `cw_information_type_cw_door_state`
--

