-- Table structure for table `cw_operator_type`
--

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

--
-- Dumping data for table `cw_operator_type`
--

INSERT INTO `cw_operator_type` VALUES
(1,0,'2018-02-07 00:36:37','\0','Teammitglied','2018-02-07 00:36:37','TM','\0',0),
(2,0,'2018-02-07 00:37:01','\0','Clockwork-Administrator','2018-02-07 00:37:01','clockwork-administrator','\0',0),
(3,0,'2018-02-07 08:48:10','\0','Personalabteilung','2018-02-07 08:48:10','HR','\0',0),
(4,2,'2018-02-07 10:40:23','\0','Abteilungsleiter','2018-02-07 10:47:05','AL','\0',0),
(5,0,'2019-05-22 12:52:03','\0','Zutritt','2019-05-22 12:52:03','Zutritt','\0',0),
(6,0,'2020-02-04 15:15:18','\0','Administrator','2020-02-04 15:15:18','Admin','\0',0),
(7,0,'2020-02-04 15:19:20','\0','Chiplox','2020-02-04 15:19:20','Chiplox','\0',0),
(8,0,'2020-02-04 15:19:58','\0','Gantner','2020-02-04 15:19:58','Gantner','\0',0),
(9,0,'2020-02-04 15:20:35','\0','Keyflex','2020-02-04 15:20:35','Keyflex','\0',0),
(10,0,'2020-02-04 15:21:10','\0','Seccor','2020-02-04 15:21:10','Seccor','\0',0),
(11,0,'2023-02-09 00:07:24','\0','Datafox','2023-02-09 00:07:24','Datafox','\0',0);

--
-- Table structure for table `cw_operator_type_2_auto_started_menu`
--

CREATE TABLE `cw_operator_type_2_auto_started_menu` (
  `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,
  `menu_id` bigint(20) NOT NULL,
  `operator_type_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKs2oqprl0ewxm3l36mrmkgg8v5` (`menu_id`),
  KEY `FKeb4tudqxq3nyacm5mhu329fbp` (`operator_type_id`),
  CONSTRAINT `FKeb4tudqxq3nyacm5mhu329fbp` FOREIGN KEY (`operator_type_id`) REFERENCES `cw_operator_type` (`id`),
  CONSTRAINT `FKs2oqprl0ewxm3l36mrmkgg8v5` FOREIGN KEY (`menu_id`) REFERENCES `cw_menu` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_2_auto_started_menu`
--


--
-- Table structure for table `cw_operator_type_2_menu`
--

CREATE TABLE `cw_operator_type_2_menu` (
  `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,
  `menu_id` bigint(20) NOT NULL,
  `operator_type_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK119ieemn78opg97a4cak7pxhi` (`menu_id`),
  KEY `FKfo37wnhi2uihhew2m24q4cs0p` (`operator_type_id`),
  CONSTRAINT `FK119ieemn78opg97a4cak7pxhi` FOREIGN KEY (`menu_id`) REFERENCES `cw_menu` (`id`),
  CONSTRAINT `FKfo37wnhi2uihhew2m24q4cs0p` FOREIGN KEY (`operator_type_id`) REFERENCES `cw_operator_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=286 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_2_menu`
--

INSERT INTO `cw_operator_type_2_menu` VALUES
(1,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',1,2),
(2,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',2,2),
(3,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',3,2),
(4,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',4,2),
(5,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',5,2),
(6,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',6,2),
(7,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',7,2),
(8,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',8,2),
(9,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',9,2),
(10,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',10,2),
(11,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',11,2),
(12,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',12,2),
(13,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',13,2),
(14,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',14,2),
(15,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',15,2),
(16,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',16,2),
(17,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',17,2),
(18,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',18,2),
(19,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',19,2),
(20,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',20,2),
(21,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',21,2),
(22,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',22,2),
(23,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',23,2),
(24,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',24,2),
(25,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',25,2),
(26,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',26,2),
(27,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',27,2),
(28,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',28,2),
(29,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',29,2),
(30,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',30,2),
(31,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',31,2),
(32,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',32,2),
(33,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',33,2),
(34,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',34,2),
(35,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',35,2),
(36,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',36,2),
(37,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',37,2),
(38,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',38,2),
(40,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',40,2),
(41,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',41,2),
(42,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',42,2),
(43,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',43,2),
(44,0,'2018-02-07 00:37:01','\0','2018-02-07 00:37:01',44,2),
(45,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',45,2),
(46,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',46,2),
(47,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',47,2),
(48,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',48,2),
(49,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',49,2),
(50,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',50,2),
(51,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',51,2),
(52,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',52,2),
(53,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',53,2),
(54,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',54,2),
(55,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',55,2),
(56,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',56,2),
(57,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',57,2),
(58,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',58,2),
(59,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',59,2),
(60,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',60,2),
(61,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',61,2),
(62,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',62,2),
(63,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',63,2),
(64,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',64,2),
(65,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',65,2),
(66,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',66,2),
(67,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',67,2),
(70,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',70,2),
(71,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',71,2),
(72,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',72,2),
(73,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',73,2),
(74,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',74,2),
(75,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',75,2),
(76,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',76,2),
(77,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',77,2),
(79,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',79,2),
(80,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',80,2),
(81,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',81,2),
(82,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',82,2),
(83,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',83,2),
(84,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',84,2),
(85,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',85,2),
(86,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',86,2),
(87,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',87,2),
(88,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',88,2),
(89,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',89,2),
(90,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',90,2),
(91,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',91,2),
(92,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',92,2),
(93,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',93,2),
(94,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',94,2),
(95,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',95,2),
(96,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',96,2),
(97,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',97,2),
(98,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',98,2),
(99,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',99,2),
(100,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',100,2),
(101,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',101,2),
(102,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',102,2),
(103,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',103,2),
(104,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',104,2),
(105,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',105,2),
(106,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',106,2),
(107,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',107,2),
(108,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',108,2),
(109,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',109,2),
(110,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',110,2),
(111,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',111,2),
(112,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',112,2),
(113,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',113,2),
(114,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',114,2),
(115,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',115,2),
(116,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',116,2),
(117,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',117,2),
(118,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',118,2),
(119,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',119,2),
(120,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',120,2),
(121,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',121,2),
(122,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',122,2),
(123,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',123,2),
(124,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',124,2),
(125,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',125,2),
(126,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',126,2),
(127,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',127,2),
(128,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',128,2),
(129,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',129,2),
(130,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',130,2),
(131,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',131,2),
(132,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',132,2),
(133,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',133,2),
(134,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',134,2),
(135,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',135,2),
(136,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',136,2),
(137,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',137,2),
(138,0,'2018-02-07 00:37:02','\0','2018-02-07 00:37:02',138,2),
(139,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',4,3),
(140,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',16,3),
(141,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',1,3),
(142,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',14,3),
(143,0,'2018-02-07 10:46:22','\0','2018-02-07 10:46:22',32,3),
(144,0,'2018-02-07 10:46:22','\0','2018-02-07 10:46:22',38,3),
(145,0,'2018-02-07 10:46:22','\0','2018-02-07 10:46:22',7,3),
(146,0,'2018-02-07 10:46:22','\0','2018-02-07 10:46:22',2,3),
(147,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',30,3),
(148,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',40,3),
(149,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',23,3),
(150,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',22,3),
(151,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',21,3),
(152,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',24,3),
(153,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',28,3),
(154,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',29,3),
(155,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',3,3),
(156,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',36,3),
(157,0,'2018-02-07 10:46:23','\0','2018-02-07 10:46:23',34,3),
(158,0,'2018-02-07 10:47:05','\0','2018-02-07 10:47:05',4,4),
(159,0,'2018-02-07 10:47:05','\0','2018-02-07 10:47:05',16,4),
(160,0,'2018-02-07 10:47:05','\0','2018-02-07 10:47:05',14,4),
(161,0,'2018-02-07 10:48:57','\0','2018-02-07 10:48:57',7,4),
(162,0,'2018-02-07 10:48:57','\0','2018-02-07 10:48:57',2,4),
(163,0,'2018-02-07 10:50:47','\0','2018-02-07 10:50:47',4,1),
(164,0,'2018-02-07 10:50:47','\0','2018-02-07 10:50:47',10,1),
(165,0,'2018-02-07 10:50:47','\0','2018-02-07 10:50:47',7,1),
(166,0,'2018-02-07 10:50:47','\0','2018-02-07 10:50:47',2,1),
(167,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',139,2),
(168,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',140,2),
(169,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',141,2),
(170,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',142,2),
(171,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',143,2),
(172,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',144,2),
(173,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',145,2),
(174,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',146,2),
(175,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',147,2),
(176,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',148,2),
(177,0,'2018-05-22 11:25:30','\0','2018-05-22 11:25:30',149,2),
(178,0,'2018-08-28 10:52:26','\0','2018-08-28 10:52:26',150,2),
(179,0,'2018-08-28 10:52:26','\0','2018-08-28 10:52:26',151,2),
(180,0,'2018-08-28 10:52:26','\0','2018-08-28 10:52:26',152,2),
(181,0,'2018-08-28 10:52:26','\0','2018-08-28 10:52:26',153,2),
(182,0,'2019-02-25 18:37:28','\0','2019-02-25 18:37:28',154,2),
(183,0,'2019-02-25 18:37:28','\0','2019-02-25 18:37:28',155,2),
(184,0,'2019-05-22 12:56:06','\0','2019-05-22 12:56:06',9,5),
(185,0,'2019-05-22 12:56:22','\0','2019-05-22 12:56:22',134,5),
(186,0,'2020-02-04 10:55:45','\0','2020-02-04 10:55:45',156,2),
(187,0,'2020-02-04 10:55:45','\0','2020-02-04 10:55:45',157,2),
(188,0,'2020-02-04 10:55:45','\0','2020-02-04 10:55:45',158,2),
(189,0,'2020-02-04 10:55:45','\0','2020-02-04 10:55:45',159,2),
(190,0,'2020-02-04 10:55:45','\0','2020-02-04 10:55:45',160,2),
(191,0,'2020-02-04 10:55:45','\0','2020-02-04 10:55:45',161,2),
(192,0,'2020-02-04 10:55:45','\0','2020-02-04 10:55:45',162,2),
(193,0,'2020-02-04 15:16:51','\0','2020-02-04 15:16:51',122,6),
(194,0,'2020-02-04 15:16:51','\0','2020-02-04 15:16:51',121,6),
(195,0,'2020-02-04 15:16:51','\0','2020-02-04 15:16:51',132,6),
(196,0,'2020-02-04 15:16:51','\0','2020-02-04 15:16:51',120,6),
(197,0,'2020-02-04 15:16:51','\0','2020-02-04 15:16:51',133,6),
(198,0,'2020-02-04 15:16:51','\0','2020-02-04 15:16:51',129,6),
(199,0,'2020-02-04 15:19:20','\0','2020-02-04 15:19:20',151,7),
(200,0,'2020-02-04 15:19:20','\0','2020-02-04 15:19:20',63,7),
(201,0,'2020-02-04 15:19:20','\0','2020-02-04 15:19:20',62,7),
(202,0,'2020-02-04 15:19:20','\0','2020-02-04 15:19:20',73,7),
(203,0,'2020-02-04 15:19:20','\0','2020-02-04 15:19:20',140,7),
(204,0,'2020-02-04 15:19:20','\0','2020-02-04 15:19:20',139,7),
(205,0,'2020-02-04 15:19:58','\0','2020-02-04 15:19:58',161,8),
(206,0,'2020-02-04 15:19:58','\0','2020-02-04 15:19:58',142,8),
(207,0,'2020-02-04 15:19:58','\0','2020-02-04 15:19:58',141,8),
(208,0,'2020-02-04 15:19:58','\0','2020-02-04 15:19:58',144,8),
(209,0,'2020-02-04 15:19:58','\0','2020-02-04 15:19:58',143,8),
(210,0,'2020-02-04 15:19:58','\0','2020-02-04 15:19:58',145,8),
(211,0,'2020-02-04 15:20:35','\0','2020-02-04 15:20:35',156,9),
(212,0,'2020-02-04 15:20:35','\0','2020-02-04 15:20:35',76,9),
(213,0,'2020-02-04 15:20:35','\0','2020-02-04 15:20:35',75,9),
(214,0,'2020-02-04 15:20:35','\0','2020-02-04 15:20:35',65,9),
(215,0,'2020-02-04 15:20:35','\0','2020-02-04 15:20:35',64,9),
(216,0,'2020-02-04 15:20:35','\0','2020-02-04 15:20:35',74,9),
(217,0,'2020-02-04 15:20:35','\0','2020-02-04 15:20:35',67,9),
(218,0,'2020-02-04 15:20:35','\0','2020-02-04 15:20:35',66,9),
(219,0,'2020-02-04 15:21:10','\0','2020-02-04 15:21:10',158,10),
(220,0,'2020-02-04 15:21:10','\0','2020-02-04 15:21:10',157,10),
(221,0,'2020-02-04 15:21:10','\0','2020-02-04 15:21:10',160,10),
(222,0,'2020-02-04 15:21:10','\0','2020-02-04 15:21:10',159,10),
(223,0,'2020-02-04 15:21:10','\0','2020-02-04 15:21:10',162,10),
(224,0,'2020-02-04 15:22:44','\0','2020-02-04 15:22:44',23,5),
(225,0,'2020-02-04 15:22:44','\0','2020-02-04 15:22:44',22,5),
(226,0,'2020-02-04 15:22:44','\0','2020-02-04 15:22:44',21,5),
(227,0,'2020-02-04 15:27:40','\0','2020-02-04 15:27:40',26,5),
(228,0,'2020-02-04 15:27:40','\0','2020-02-04 15:27:40',25,5),
(229,0,'2020-02-04 15:29:15','\0','2020-02-04 15:29:15',84,5),
(230,1,'2020-02-04 15:29:15','','2023-02-09 00:09:48',83,5),
(231,0,'2020-04-04 01:50:11','\0','2020-04-04 01:50:11',163,2),
(232,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',164,2),
(233,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',165,2),
(234,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',166,2),
(235,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',167,2),
(236,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',168,2),
(237,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',169,2),
(238,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',170,2),
(239,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',171,2),
(240,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',172,2),
(241,0,'2020-07-24 19:04:14','\0','2020-07-24 19:04:14',173,2),
(242,0,'2020-07-24 19:04:15','\0','2020-07-24 19:04:15',174,2),
(243,0,'2020-07-24 19:04:15','\0','2020-07-24 19:04:15',175,2),
(245,0,'2021-04-02 17:56:32','\0','2021-04-02 17:56:32',177,2),
(246,0,'2021-04-02 17:56:32','\0','2021-04-02 17:56:32',178,2),
(247,0,'2021-04-02 17:56:32','\0','2021-04-02 17:56:32',179,2),
(248,0,'2021-12-25 22:57:21','\0','2021-12-25 22:57:21',180,2),
(249,0,'2021-12-25 22:57:21','\0','2021-12-25 22:57:21',181,2),
(250,0,'2021-12-25 22:57:21','\0','2021-12-25 22:57:21',182,2),
(251,0,'2021-12-25 22:57:21','\0','2021-12-25 22:57:21',183,2),
(252,0,'2021-12-25 22:57:21','\0','2021-12-25 22:57:21',184,2),
(253,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',185,2),
(254,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',186,2),
(255,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',187,2),
(256,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',188,2),
(257,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',189,2),
(258,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',190,2),
(259,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',191,2),
(260,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',192,2),
(261,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',193,2),
(262,0,'2022-07-02 00:46:09','\0','2022-07-02 00:46:09',194,2),
(263,0,'2022-12-22 11:13:57','\0','2022-12-22 11:13:57',195,2),
(264,0,'2023-02-08 21:52:31','\0','2023-02-08 21:52:31',196,2),
(265,0,'2023-02-08 21:52:31','\0','2023-02-08 21:52:31',197,2),
(266,0,'2023-02-08 21:52:31','\0','2023-02-08 21:52:31',198,2),
(267,0,'2023-02-08 21:52:31','\0','2023-02-08 21:52:31',199,2),
(268,0,'2023-02-08 21:52:31','\0','2023-02-08 21:52:31',200,2),
(269,0,'2023-02-08 21:52:31','\0','2023-02-08 21:52:31',201,2),
(270,0,'2023-02-08 23:48:58','\0','2023-02-08 23:48:58',134,6),
(271,0,'2023-02-09 00:07:24','\0','2023-02-09 00:07:24',190,11),
(272,0,'2023-02-09 00:07:24','\0','2023-02-09 00:07:24',187,11),
(273,0,'2023-02-09 00:07:25','\0','2023-02-09 00:07:25',186,11),
(274,0,'2023-02-09 00:07:25','\0','2023-02-09 00:07:25',183,11),
(275,0,'2023-02-09 00:07:25','\0','2023-02-09 00:07:25',189,11),
(276,0,'2023-02-09 00:07:25','\0','2023-02-09 00:07:25',188,11),
(277,0,'2023-02-16 09:48:06','\0','2023-02-16 09:48:06',7,5),
(278,0,'2024-03-07 10:00:09','\0','2024-03-07 10:00:09',202,2),
(279,0,'2024-03-07 10:00:10','\0','2024-03-07 10:00:10',203,2),
(280,0,'2024-03-07 10:00:11','\0','2024-03-07 10:00:11',204,2),
(281,0,'2024-07-14 18:32:42','\0','2024-07-14 18:32:42',205,2),
(282,0,'2024-07-14 18:32:42','\0','2024-07-14 18:32:42',206,2),
(283,0,'2024-07-14 18:32:42','\0','2024-07-14 18:32:42',207,2),
(284,0,'2024-09-10 15:30:04','\0','2024-09-10 15:30:04',208,2),
(285,0,'2025-03-19 11:56:56','\0','2025-03-19 11:56:56',209,2);

--
-- Table structure for table `cw_operator_type_2_operation_role`
--

CREATE TABLE `cw_operator_type_2_operation_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `general_validation_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `operator_role_id` bigint(20) NOT NULL,
  `operator_type_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK8lobyiss7amkw3vif3cdbd2x1` (`general_validation_id`),
  KEY `FK6w3nigeuf9j8yyrr6uejkfbb6` (`operator_role_id`),
  KEY `FK65krnm2np1fos81iryhang61q` (`operator_type_id`),
  CONSTRAINT `FK65krnm2np1fos81iryhang61q` FOREIGN KEY (`operator_type_id`) REFERENCES `cw_operator_type` (`id`),
  CONSTRAINT `FK6w3nigeuf9j8yyrr6uejkfbb6` FOREIGN KEY (`operator_role_id`) REFERENCES `cw_operator_role` (`id`),
  CONSTRAINT `FK8lobyiss7amkw3vif3cdbd2x1` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_2_operation_role`
--

INSERT INTO `cw_operator_type_2_operation_role` VALUES
(1,0,'2018-02-07 10:40:13','\0',1,'2018-02-07 10:40:13',44,3,0),
(2,0,'2018-02-07 10:42:46','\0',1,'2018-02-07 10:42:46',4,3,0),
(3,0,'2018-02-07 10:42:46','\0',1,'2018-02-07 10:42:46',6,3,0),
(4,1,'2018-02-07 10:42:46','\0',1,'2018-08-28 10:56:27',9,3,0),
(5,0,'2018-02-07 10:42:46','\0',1,'2018-02-07 10:42:46',47,3,0),
(6,0,'2018-02-07 10:42:46','\0',1,'2018-02-07 10:42:46',49,3,0),
(7,0,'2018-02-07 10:42:46','\0',1,'2018-02-07 10:42:46',94,3,0),
(8,0,'2018-02-07 10:43:27','\0',1,'2018-02-07 10:43:27',83,3,0),
(9,0,'2018-02-07 10:43:27','\0',1,'2018-02-07 10:43:27',81,3,0),
(10,0,'2018-02-07 10:48:57','\0',1,'2018-02-07 10:48:57',44,4,0),
(11,0,'2018-02-07 10:48:57','\0',1,'2018-02-07 10:48:57',4,4,0),
(12,0,'2018-02-07 10:48:57','\0',1,'2018-02-07 10:48:57',83,4,0),
(13,0,'2018-02-07 10:48:57','\0',1,'2018-02-07 10:48:57',81,4,0),
(14,0,'2018-02-07 10:50:47','\0',1,'2018-02-07 10:50:47',44,1,0),
(15,0,'2018-02-07 10:50:47','\0',1,'2018-02-07 10:50:47',45,1,0),
(16,0,'2018-02-07 10:50:47','\0',1,'2018-02-07 10:50:47',4,1,0),
(17,0,'2019-05-22 11:23:16','\0',4,'2019-05-22 11:23:16',46,1,0),
(18,0,'2019-05-22 11:23:16','\0',3,'2019-05-22 11:23:16',5,1,0),
(19,0,'2019-05-22 11:23:16','\0',4,'2019-05-22 11:23:16',48,1,0),
(20,0,'2019-05-22 11:23:16','\0',3,'2019-05-22 11:23:16',8,1,0),
(21,0,'2019-05-22 11:23:16','\0',4,'2019-05-22 11:23:16',52,1,0),
(22,0,'2019-05-22 11:23:16','\0',3,'2019-05-22 11:23:16',23,1,0),
(23,0,'2019-05-22 11:25:22','\0',4,'2019-05-22 11:25:22',50,4,0),
(24,0,'2019-05-22 11:25:22','\0',3,'2019-05-22 11:25:22',21,4,0),
(25,0,'2019-05-22 11:25:22','\0',4,'2019-05-22 11:25:22',47,4,0),
(26,0,'2019-05-22 11:25:22','\0',4,'2019-05-22 11:25:22',49,4,0),
(27,0,'2019-05-22 11:25:22','\0',3,'2019-05-22 11:25:22',6,4,0),
(28,0,'2019-05-22 11:25:22','\0',3,'2019-05-22 11:25:22',9,4,0),
(29,0,'2019-05-22 12:55:44','\0',5,'2019-05-22 12:55:44',91,5,0),
(30,0,'2023-02-08 23:49:29','\0',5,'2023-02-08 23:49:29',90,5,0);

--
-- Table structure for table `cw_operator_type_2_operation_role_2_personal_pronoun`
--

CREATE TABLE `cw_operator_type_2_operation_role_2_personal_pronoun` (
  `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,
  `operator_type2operator_role_id` bigint(20) NOT NULL,
  `personal_pronoun_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKoo60g2eai1gq3j5ws83gect9l` (`operator_type2operator_role_id`),
  KEY `FKmrhfwhoienvxbcac5i0msk8ws` (`personal_pronoun_id`),
  CONSTRAINT `FKmrhfwhoienvxbcac5i0msk8ws` FOREIGN KEY (`personal_pronoun_id`) REFERENCES `cw_personal_pronoun` (`id`),
  CONSTRAINT `FKoo60g2eai1gq3j5ws83gect9l` FOREIGN KEY (`operator_type2operator_role_id`) REFERENCES `cw_operator_type_2_operation_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_2_operation_role_2_personal_pronoun`
--

INSERT INTO `cw_operator_type_2_operation_role_2_personal_pronoun` VALUES
(1,0,'2018-02-07 10:40:14','\0','2018-02-07 10:40:14',1,15,0),
(2,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',2,15,0),
(3,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',3,15,0),
(4,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',4,15,0),
(5,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',5,15,0),
(6,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',6,15,0),
(7,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',7,15,0),
(8,0,'2018-02-07 10:43:27','\0','2018-02-07 10:43:27',8,15,0),
(9,0,'2018-02-07 10:43:27','\0','2018-02-07 10:43:27',9,15,0),
(10,0,'2018-02-07 10:48:57','\0','2018-02-07 10:48:57',10,2,0),
(11,0,'2018-02-07 10:48:57','\0','2018-02-07 10:48:57',11,2,0),
(12,0,'2018-02-07 10:48:57','\0','2018-02-07 10:48:57',12,2,0),
(13,0,'2018-02-07 10:48:57','\0','2018-02-07 10:48:57',13,2,0),
(14,0,'2018-02-07 10:50:47','\0','2018-02-07 10:50:47',14,1,0),
(15,0,'2018-02-07 10:50:47','\0','2018-02-07 10:50:47',15,2,0),
(16,0,'2018-02-07 10:50:47','\0','2018-02-07 10:50:47',16,1,0),
(17,0,'2019-05-22 11:23:16','\0','2019-05-22 11:23:16',17,1,0),
(18,0,'2019-05-22 11:23:16','\0','2019-05-22 11:23:16',18,1,0),
(19,0,'2019-05-22 11:23:16','\0','2019-05-22 11:23:16',19,1,0),
(20,0,'2019-05-22 11:23:16','\0','2019-05-22 11:23:16',20,1,0),
(21,0,'2019-05-22 11:23:16','\0','2019-05-22 11:23:16',21,1,0),
(22,0,'2019-05-22 11:23:16','\0','2019-05-22 11:23:16',22,1,0),
(23,0,'2019-05-22 11:25:22','\0','2019-05-22 11:25:22',23,2,0),
(24,0,'2019-05-22 11:25:22','\0','2019-05-22 11:25:22',24,2,0),
(25,0,'2019-05-22 11:25:22','\0','2019-05-22 11:25:22',25,3,0),
(26,0,'2019-05-22 11:25:22','\0','2019-05-22 11:25:22',26,3,0),
(27,0,'2019-05-22 11:25:22','\0','2019-05-22 11:25:22',27,3,0),
(28,0,'2019-05-22 11:25:22','\0','2019-05-22 11:25:22',28,3,0),
(29,0,'2019-05-22 12:55:44','\0','2019-05-22 12:55:44',29,15,0),
(30,0,'2023-02-08 23:49:29','\0','2023-02-08 23:49:29',30,15,0);

--
-- Table structure for table `cw_operator_type_2_report_role`
--

CREATE TABLE `cw_operator_type_2_report_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `general_validation_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `operator_role_id` bigint(20) NOT NULL,
  `operator_type_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3rdry8qfp7qikandw96egnkvb` (`general_validation_id`),
  KEY `FK7ccsft3h2qo9o920nhis6epuf` (`operator_role_id`),
  KEY `FKt7tmbvtno7vehki8l2w5563ck` (`operator_type_id`),
  CONSTRAINT `FK3rdry8qfp7qikandw96egnkvb` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FK7ccsft3h2qo9o920nhis6epuf` FOREIGN KEY (`operator_role_id`) REFERENCES `cw_operator_role` (`id`),
  CONSTRAINT `FKt7tmbvtno7vehki8l2w5563ck` FOREIGN KEY (`operator_type_id`) REFERENCES `cw_operator_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_2_report_role`
--

INSERT INTO `cw_operator_type_2_report_role` VALUES
(1,0,'2018-02-07 10:42:46','\0',1,'2018-02-07 10:42:46',128,3,0),
(2,0,'2018-02-07 10:42:46','\0',1,'2018-02-07 10:42:46',136,3,0),
(3,0,'2018-02-07 10:48:57','\0',1,'2018-02-07 10:48:57',128,4,0),
(4,0,'2018-02-07 10:48:57','\0',1,'2018-02-07 10:48:57',136,4,0),
(5,0,'2018-02-07 10:50:47','\0',1,'2018-02-07 10:50:47',128,1,0),
(6,0,'2023-02-09 00:09:48','\0',5,'2023-02-09 00:09:48',196,5,0),
(7,0,'2023-02-09 00:09:48','\0',2,'2023-02-09 00:09:48',298,5,0),
(8,0,'2023-02-09 00:09:48','\0',5,'2023-02-09 00:09:48',300,5,0),
(9,0,'2023-02-09 00:09:48','\0',5,'2023-02-09 00:09:48',299,5,0);

--
-- Table structure for table `cw_operator_type_2_report_role_2_personal_pronoun`
--

CREATE TABLE `cw_operator_type_2_report_role_2_personal_pronoun` (
  `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,
  `operator_type2operator_role_id` bigint(20) NOT NULL,
  `personal_pronoun_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK5p5oketuhllritwu74rlxhu68` (`operator_type2operator_role_id`),
  KEY `FKonnwmb2m3j7chuvpwtagn6n8h` (`personal_pronoun_id`),
  CONSTRAINT `FK5p5oketuhllritwu74rlxhu68` FOREIGN KEY (`operator_type2operator_role_id`) REFERENCES `cw_operator_type_2_report_role` (`id`),
  CONSTRAINT `FKonnwmb2m3j7chuvpwtagn6n8h` FOREIGN KEY (`personal_pronoun_id`) REFERENCES `cw_personal_pronoun` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_2_report_role_2_personal_pronoun`
--

INSERT INTO `cw_operator_type_2_report_role_2_personal_pronoun` VALUES
(1,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',1,15,0),
(2,0,'2018-02-07 10:42:46','\0','2018-02-07 10:42:46',2,15,0),
(3,0,'2018-02-07 10:48:57','\0','2018-02-07 10:48:57',3,2,0),
(4,0,'2018-02-07 10:48:57','\0','2018-02-07 10:48:57',4,2,0),
(5,0,'2018-02-07 10:50:47','\0','2018-02-07 10:50:47',5,1,0),
(6,0,'2023-02-09 00:09:48','\0','2023-02-09 00:09:48',6,15,0),
(7,0,'2023-02-09 00:09:48','\0','2023-02-09 00:09:48',7,15,0),
(8,0,'2023-02-09 00:09:48','\0','2023-02-09 00:09:48',8,15,0),
(9,0,'2023-02-09 00:09:48','\0','2023-02-09 00:09:48',9,15,0);

--
-- Table structure for table `cw_operator_type_2_script`
--

CREATE TABLE `cw_operator_type_2_script` (
  `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,
  `operator_type_id` bigint(20) NOT NULL,
  `script_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK8goymgt46ow6qjwu8csp6q8xt` (`operator_type_id`),
  KEY `FKo0d0lgtcoiwhp6yk38xlg4pbs` (`script_id`),
  CONSTRAINT `FK8goymgt46ow6qjwu8csp6q8xt` FOREIGN KEY (`operator_type_id`) REFERENCES `cw_operator_type` (`id`),
  CONSTRAINT `FKo0d0lgtcoiwhp6yk38xlg4pbs` FOREIGN KEY (`script_id`) REFERENCES `cw_script` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_2_script`
--


--
-- Table structure for table `cw_operator_type_detail`
--

CREATE TABLE `cw_operator_type_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `general_validation_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `operation_role_id` bigint(20) DEFAULT NULL,
  `operator_role_id` bigint(20) NOT NULL,
  `operator_type_id` bigint(20) DEFAULT NULL,
  `class` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK7nuufw803nnfa0wvahv95o1tt` (`general_validation_id`),
  KEY `FKsagupuxp5cvdhh3mant3n7a0s` (`operation_role_id`),
  KEY `FKfj0800cp2rgalwdba9k391fgk` (`operator_role_id`),
  KEY `FKrety3qoakyxm281m8wxjqs167` (`operator_type_id`),
  CONSTRAINT `FK7nuufw803nnfa0wvahv95o1tt` FOREIGN KEY (`general_validation_id`) REFERENCES `cw_general_validation` (`id`),
  CONSTRAINT `FKfj0800cp2rgalwdba9k391fgk` FOREIGN KEY (`operator_role_id`) REFERENCES `cw_operator_role` (`id`),
  CONSTRAINT `FKrety3qoakyxm281m8wxjqs167` FOREIGN KEY (`operator_type_id`) REFERENCES `cw_operator_type` (`id`),
  CONSTRAINT `FKsagupuxp5cvdhh3mant3n7a0s` FOREIGN KEY (`operation_role_id`) REFERENCES `cw_operator_role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_detail`
--


--
-- Table structure for table `cw_operator_type_detail_cw_personal_pronoun`
--

CREATE TABLE `cw_operator_type_detail_cw_personal_pronoun` (
  `operator_type_detail_personal_pronouns_id` bigint(20) NOT NULL,
  `personal_pronoun_id` bigint(20) DEFAULT NULL,
  KEY `FK7c6j83b16glp7g06dfuceyf7k` (`personal_pronoun_id`),
  KEY `FKqf8wbcypcaguhqbir2vuvr539` (`operator_type_detail_personal_pronouns_id`),
  CONSTRAINT `FK7c6j83b16glp7g06dfuceyf7k` FOREIGN KEY (`personal_pronoun_id`) REFERENCES `cw_personal_pronoun` (`id`),
  CONSTRAINT `FKqf8wbcypcaguhqbir2vuvr539` FOREIGN KEY (`operator_type_detail_personal_pronouns_id`) REFERENCES `cw_operator_type_detail` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_operator_type_detail_cw_personal_pronoun`
--


--
-- Table structure for table `cw_order`
--

CREATE TABLE `cw_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `article_id` bigint(20) DEFAULT NULL,
  `cost_unit_id` bigint(20) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description2` varchar(255) DEFAULT NULL,
  `description3` varchar(255) DEFAULT NULL,
  `description4` varchar(255) DEFAULT NULL,
  `description5` varchar(255) DEFAULT NULL,
  `description_de` varchar(255) DEFAULT NULL,
  `description_en` varchar(255) DEFAULT NULL,
  `duration` double NOT NULL,
  `duration_unit_id` bigint(20) DEFAULT NULL,
  `earliest_start_time` datetime DEFAULT NULL,
  `finish_time` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `latest_finish_time` datetime DEFAULT NULL,
  `long_description` longtext DEFAULT NULL,
  `machine_id` bigint(20) DEFAULT NULL,
  `mobile_client` bit(1) NOT NULL,
  `number` varchar(255) NOT NULL,
  `order_category_id` bigint(20) NOT NULL,
  `order_item_id` bigint(20) DEFAULT NULL,
  `order_state_enum` varchar(255) DEFAULT NULL,
  `project_id` bigint(20) DEFAULT NULL,
  `quantity` double NOT NULL,
  `quantity_unit_id` bigint(20) DEFAULT NULL,
  `update_counter` int(11) DEFAULT NULL,
  `workplace_id` bigint(20) DEFAULT NULL,
  `workprocess_id` bigint(20) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `vendor_id` bigint(20) DEFAULT NULL,
  `commission` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_taldrhfe155j9tplroietxovp` (`number`),
  KEY `FKm4t0shxu12dh7jve9s2201xgx` (`article_id`),
  KEY `FKax5qjo5u2r31jly8e8i8k0649` (`cost_unit_id`),
  KEY `FK4r4wf7xboikahmsl6qtd40cl6` (`duration_unit_id`),
  KEY `FK7ud6rn75mo79p831iohccrhpt` (`machine_id`),
  KEY `FK90d1ml12vou94aa09t52un2ik` (`order_category_id`),
  KEY `FKqmgqt6xxg6071j6ifsb7gdxcn` (`order_item_id`),
  KEY `FK2tup0ocbu6pce2i3ovh17vi4g` (`project_id`),
  KEY `FKi81fmb5fjgbwnkmtbqgsnsokc` (`quantity_unit_id`),
  KEY `FKkiqbokw600ua2gffc19gc8msr` (`workplace_id`),
  KEY `FK2mum4k2c0j4jl4nswax66n3tb` (`workprocess_id`),
  KEY `number_idx` (`number`),
  KEY `FKfuq8fxcqviiwmg3ay602ra636` (`customer_id`),
  KEY `FKauy9ie5dswp96n0y0y3pmjg5g` (`vendor_id`),
  CONSTRAINT `FK2mum4k2c0j4jl4nswax66n3tb` FOREIGN KEY (`workprocess_id`) REFERENCES `cw_workprocess` (`id`),
  CONSTRAINT `FK2tup0ocbu6pce2i3ovh17vi4g` FOREIGN KEY (`project_id`) REFERENCES `cw_project` (`id`),
  CONSTRAINT `FK4r4wf7xboikahmsl6qtd40cl6` FOREIGN KEY (`duration_unit_id`) REFERENCES `cw_quantity_unit` (`id`),
  CONSTRAINT `FK7ud6rn75mo79p831iohccrhpt` FOREIGN KEY (`machine_id`) REFERENCES `cw_machine` (`id`),
  CONSTRAINT `FK90d1ml12vou94aa09t52un2ik` FOREIGN KEY (`order_category_id`) REFERENCES `cw_order_category` (`id`),
  CONSTRAINT `FKauy9ie5dswp96n0y0y3pmjg5g` FOREIGN KEY (`vendor_id`) REFERENCES `cw_company` (`id`),
  CONSTRAINT `FKax5qjo5u2r31jly8e8i8k0649` FOREIGN KEY (`cost_unit_id`) REFERENCES `cw_cost_unit` (`id`),
  CONSTRAINT `FKfuq8fxcqviiwmg3ay602ra636` FOREIGN KEY (`customer_id`) REFERENCES `cw_company` (`id`),
  CONSTRAINT `FKi81fmb5fjgbwnkmtbqgsnsokc` FOREIGN KEY (`quantity_unit_id`) REFERENCES `cw_quantity_unit` (`id`),
  CONSTRAINT `FKkiqbokw600ua2gffc19gc8msr` FOREIGN KEY (`workplace_id`) REFERENCES `cw_workplace` (`id`),
  CONSTRAINT `FKm4t0shxu12dh7jve9s2201xgx` FOREIGN KEY (`article_id`) REFERENCES `cw_article` (`id`),
  CONSTRAINT `FKqmgqt6xxg6071j6ifsb7gdxcn` FOREIGN KEY (`order_item_id`) REFERENCES `cw_order_item` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_order`
--


--
-- Table structure for table `cw_order_2_additional_data`
--

CREATE TABLE `cw_order_2_additional_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `order_id` bigint(20) NOT NULL,
  `order_additional_data_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `info_value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK228u8xty15wogef1oqibcyh2m` (`order_additional_data_id`),
  KEY `query1_idx` (`order_id`,`order_additional_data_id`),
  CONSTRAINT `FK228u8xty15wogef1oqibcyh2m` FOREIGN KEY (`order_additional_data_id`) REFERENCES `cw_additional_data` (`id`),
  CONSTRAINT `FKp90cvkiatci6qny07m4s62xy7` FOREIGN KEY (`order_id`) REFERENCES `cw_order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_order_2_additional_data`
--


--
-- Table structure for table `cw_order_category`
--

CREATE TABLE `cw_order_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description_de` varchar(255) NOT NULL,
  `description_en` varchar(255) NOT NULL,
  `last_updated` datetime 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_order_category`
--


--
-- Table structure for table `cw_order_item`
--

CREATE TABLE `cw_order_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `article_id` bigint(20) DEFAULT NULL,
  `cost_unit_id` bigint(20) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `description2` varchar(255) DEFAULT NULL,
  `description3` varchar(255) DEFAULT NULL,
  `description4` varchar(255) DEFAULT NULL,
  `description5` varchar(255) DEFAULT NULL,
  `description_de` varchar(255) DEFAULT NULL,
  `description_en` varchar(255) DEFAULT NULL,
  `duration` double NOT NULL,
  `duration_unit_id` bigint(20) DEFAULT NULL,
  `earliest_start_time` datetime DEFAULT NULL,
  `finish_time` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `latest_finish_time` datetime DEFAULT NULL,
  `machine_id` bigint(20) DEFAULT NULL,
  `mobile_client` bit(1) NOT NULL,
  `number` varchar(255) NOT NULL,
  `order_id` bigint(20) DEFAULT NULL,
  `order_item_category_id` bigint(20) NOT NULL,
  `order_item_state_enum` varchar(255) DEFAULT NULL,
  `project_id` bigint(20) DEFAULT NULL,
  `quantity` double NOT NULL,
  `quantity_unit_id` bigint(20) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `workplace_id` bigint(20) DEFAULT NULL,
  `workprocess_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKka5lbatlcrjwmaey9kg5ksxsh` (`article_id`),
  KEY `FKcl2ibu2wbypwf0bbxi0fkgvkr` (`cost_unit_id`),
  KEY `FKm7kmocmrxk9ecl5pr9tgwtbd` (`duration_unit_id`),
  KEY `FK980bwlwl2mu1wi41nqgtmfnk7` (`machine_id`),
  KEY `FKml93fey7neo4cl7mhg6a5equo` (`order_item_category_id`),
  KEY `FK93kwqivblqa9o670pvewy0mwe` (`project_id`),
  KEY `FKsavstkxv0c0on63mtfc257630` (`quantity_unit_id`),
  KEY `FKlhbyrpfkkt2ddtd364xikdf7s` (`workplace_id`),
  KEY `FKkx9nrtbk8usv8qmrei0nou449` (`workprocess_id`),
  KEY `number_idx` (`number`),
  KEY `number_and_order_idx` (`number`,`order_id`),
  KEY `query1_idx` (`order_id`,`deleted`),
  CONSTRAINT `FK7y6wirrmyeixy5kwsvbydjp7e` FOREIGN KEY (`order_id`) REFERENCES `cw_order` (`id`),
  CONSTRAINT `FK93kwqivblqa9o670pvewy0mwe` FOREIGN KEY (`project_id`) REFERENCES `cw_project` (`id`),
  CONSTRAINT `FK980bwlwl2mu1wi41nqgtmfnk7` FOREIGN KEY (`machine_id`) REFERENCES `cw_machine` (`id`),
  CONSTRAINT `FKcl2ibu2wbypwf0bbxi0fkgvkr` FOREIGN KEY (`cost_unit_id`) REFERENCES `cw_cost_unit` (`id`),
  CONSTRAINT `FKka5lbatlcrjwmaey9kg5ksxsh` FOREIGN KEY (`article_id`) REFERENCES `cw_article` (`id`),
  CONSTRAINT `FKkx9nrtbk8usv8qmrei0nou449` FOREIGN KEY (`workprocess_id`) REFERENCES `cw_workprocess` (`id`),
  CONSTRAINT `FKlhbyrpfkkt2ddtd364xikdf7s` FOREIGN KEY (`workplace_id`) REFERENCES `cw_workplace` (`id`),
  CONSTRAINT `FKm7kmocmrxk9ecl5pr9tgwtbd` FOREIGN KEY (`duration_unit_id`) REFERENCES `cw_quantity_unit` (`id`),
  CONSTRAINT `FKml93fey7neo4cl7mhg6a5equo` FOREIGN KEY (`order_item_category_id`) REFERENCES `cw_order_item_category` (`id`),
  CONSTRAINT `FKsavstkxv0c0on63mtfc257630` FOREIGN KEY (`quantity_unit_id`) REFERENCES `cw_quantity_unit` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_order_item`
--


--
-- Table structure for table `cw_order_item_2_additional_data`
--

CREATE TABLE `cw_order_item_2_additional_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `order_item_id` bigint(20) NOT NULL,
  `order_item_additional_data_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `info_value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKex1ev0uflmchb1gtaelde17bm` (`order_item_additional_data_id`),
  KEY `query1_idx` (`order_item_id`,`order_item_additional_data_id`),
  CONSTRAINT `FKcyxgn0heuhexo50l96w4odc37` FOREIGN KEY (`order_item_id`) REFERENCES `cw_order_item` (`id`),
  CONSTRAINT `FKex1ev0uflmchb1gtaelde17bm` FOREIGN KEY (`order_item_additional_data_id`) REFERENCES `cw_additional_data` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_order_item_2_additional_data`
--


--
-- Table structure for table `cw_order_item_category`
--

CREATE TABLE `cw_order_item_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `description_de` varchar(255) NOT NULL,
  `description_en` varchar(255) NOT NULL,
  `last_updated` datetime 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_order_item_category`
--


--
-- Table structure for table `cw_order_item_planning`
--

CREATE TABLE `cw_order_item_planning` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `finish_time` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `start_date` datetime NOT NULL,
  `state` int(11) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKl8ryn5bx0qhbri3gsblt8tvrq` (`person_id`),
  KEY `query1_idx` (`deleted`,`state`,`finish_time`),
  CONSTRAINT `FKl8ryn5bx0qhbri3gsblt8tvrq` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_order_item_planning`
--


--
-- Table structure for table `cw_order_item_planning_detail`
--

CREATE TABLE `cw_order_item_planning_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `duration` int(11) NOT NULL,
  `finish_time` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `order_item_id` bigint(20) NOT NULL,
  `order_item_planning_id` bigint(20) NOT NULL,
  `state` int(11) NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `query1_idx` (`order_item_planning_id`,`deleted`),
  KEY `query2_idx` (`order_item_id`,`deleted`),
  CONSTRAINT `FK3q439c3oxjon1xue3qpddbth3` FOREIGN KEY (`order_item_planning_id`) REFERENCES `cw_order_item_planning` (`id`),
  CONSTRAINT `FKpoap397s06xwkhu2mw4n23pl0` FOREIGN KEY (`order_item_id`) REFERENCES `cw_order_item` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_order_item_planning_detail`
--


--
-- Table structure for table `cw_person`
--

CREATE TABLE `cw_person` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `calculated` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_of_birth` datetime DEFAULT NULL,
  `date_of_close` datetime DEFAULT NULL,
  `date_of_entry` datetime DEFAULT NULL,
  `date_of_separation` datetime DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `gender_enum` varchar(255) NOT NULL,
  `last_updated` datetime NOT NULL,
  `mobile_phone` varchar(255) DEFAULT NULL,
  `no_access_active` bit(1) DEFAULT NULL,
  `no_planning_active` bit(1) DEFAULT NULL,
  `no_ticket_system_active` bit(1) DEFAULT NULL,
  `no_time_active` bit(1) DEFAULT NULL,
  `no_visitor_active` bit(1) DEFAULT NULL,
  `no_work_active` bit(1) DEFAULT NULL,
  `number` varchar(255) NOT NULL,
  `region_id` bigint(20) DEFAULT NULL,
  `religion_id` bigint(20) DEFAULT NULL,
  `report_email` varchar(255) DEFAULT NULL,
  `start_calculation` datetime DEFAULT NULL,
  `surname` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  `citizenship_id` bigint(20) DEFAULT NULL,
  `employment_permit` datetime DEFAULT NULL,
  `family_status` varchar(255) DEFAULT NULL,
  `homepage` varchar(255) DEFAULT NULL,
  `job_function` varchar(255) DEFAULT NULL,
  `learned_occupation` varchar(255) DEFAULT NULL,
  `national_insurance_number` varchar(255) DEFAULT NULL,
  `partner_birthday` datetime DEFAULT NULL,
  `partner_name` varchar(255) DEFAULT NULL,
  `partner_national_insurance_number` varchar(255) DEFAULT NULL,
  `info_value` longtext DEFAULT NULL,
  `no_logistics_active` bit(1) DEFAULT NULL,
  `gat_master_authorisation` bit(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_fyg7aaed1xi3ol350901e41jk` (`number`),
  KEY `FKsc0imb7sjekjhx3m1op4i6y5w` (`region_id`),
  KEY `FK1n2hfhy6ioi8hkaxp5q9v935t` (`religion_id`),
  KEY `number_idx` (`number`),
  KEY `FKhls66pvt474whnanroupjjf3s` (`citizenship_id`),
  CONSTRAINT `FK1n2hfhy6ioi8hkaxp5q9v935t` FOREIGN KEY (`religion_id`) REFERENCES `cw_religion` (`id`),
  CONSTRAINT `FKhls66pvt474whnanroupjjf3s` FOREIGN KEY (`citizenship_id`) REFERENCES `cw_country` (`id`),
  CONSTRAINT `FKsc0imb7sjekjhx3m1op4i6y5w` FOREIGN KEY (`region_id`) REFERENCES `cw_region` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person`
--

INSERT INTO `cw_person` VALUES
(1,0,NULL,'2019-05-22 12:58:47',NULL,NULL,'2019-05-01 00:00:00',NULL,'\0','','Max','MALE','2019-05-22 12:58:47','','\0','\0','\0','\0','\0','\0','XX',NULL,NULL,'',NULL,'Mustermann','',0,NULL,NULL,'','','','','',NULL,'','',NULL,'\0','\0');

--
-- Table structure for table `cw_person_2_additional_data`
--

CREATE TABLE `cw_person_2_additional_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `person_id` bigint(20) NOT NULL,
  `person_additional_data_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `info_value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK49vj79ii6vjof6nrtgtxcotxv` (`person_id`),
  KEY `FKp5aedqmo4t703xoat5sxagyof` (`person_additional_data_id`),
  KEY `query1_idx` (`person_id`,`person_additional_data_id`),
  KEY `query2_idx` (`person_id`,`person_additional_data_id`,`start_date`,`end_date`),
  CONSTRAINT `FK49vj79ii6vjof6nrtgtxcotxv` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKp5aedqmo4t703xoat5sxagyof` FOREIGN KEY (`person_additional_data_id`) REFERENCES `cw_additional_data` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_additional_data`
--


--
-- Table structure for table `cw_person_2_address`
--

CREATE TABLE `cw_person_2_address` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country_id` bigint(20) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `postal` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKt6ssma4wri2mixbuxf5v886h4` (`country_id`),
  KEY `FKp1v4mij40wpn9opt33xoh9xsj` (`person_id`),
  CONSTRAINT `FKp1v4mij40wpn9opt33xoh9xsj` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKt6ssma4wri2mixbuxf5v886h4` FOREIGN KEY (`country_id`) REFERENCES `cw_country` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_address`
--


--
-- Table structure for table `cw_person_2_approved_booking_time`
--

CREATE TABLE `cw_person_2_approved_booking_time` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `approved_booking_time_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKcs6utt2gx59l5et4pjroypa29` (`approved_booking_time_id`),
  KEY `FK39pjw4x804vkpkavpxm555oa4` (`person_id`),
  CONSTRAINT `FK39pjw4x804vkpkavpxm555oa4` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKcs6utt2gx59l5et4pjroypa29` FOREIGN KEY (`approved_booking_time_id`) REFERENCES `cw_approved_booking_time` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_approved_booking_time`
--


--
-- Table structure for table `cw_person_2_approved_time_too_late_by_minutes`
--

CREATE TABLE `cw_person_2_approved_time_too_late_by_minutes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `approved_time_by_minutes_id` bigint(20) NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `person_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKov1t53hcm1r93jsle46o62d9b` (`approved_time_by_minutes_id`),
  KEY `FK82w6do896vm5bxk3e2x7kbwng` (`person_id`),
  CONSTRAINT `FK82w6do896vm5bxk3e2x7kbwng` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKov1t53hcm1r93jsle46o62d9b` FOREIGN KEY (`approved_time_by_minutes_id`) REFERENCES `cw_approved_time_by_minutes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_approved_time_too_late_by_minutes`
--


--
-- Table structure for table `cw_person_2_approved_time_too_soon_by_minutes`
--

CREATE TABLE `cw_person_2_approved_time_too_soon_by_minutes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `approved_time_by_minutes_id` bigint(20) NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `person_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKd7tjak951qnir1rmngv38u25h` (`approved_time_by_minutes_id`),
  KEY `FKhnnyxfghrvw8wun0vrckqf1o6` (`person_id`),
  CONSTRAINT `FKd7tjak951qnir1rmngv38u25h` FOREIGN KEY (`approved_time_by_minutes_id`) REFERENCES `cw_approved_time_by_minutes` (`id`),
  CONSTRAINT `FKhnnyxfghrvw8wun0vrckqf1o6` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_approved_time_too_soon_by_minutes`
--


--
-- Table structure for table `cw_person_2_balance`
--

CREATE TABLE `cw_person_2_balance` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `balance1` varchar(255) DEFAULT NULL,
  `balance10` varchar(255) DEFAULT NULL,
  `balance2` varchar(255) DEFAULT NULL,
  `balance3` varchar(255) DEFAULT NULL,
  `balance4` varchar(255) DEFAULT NULL,
  `balance5` varchar(255) DEFAULT NULL,
  `balance6` varchar(255) DEFAULT NULL,
  `balance7` varchar(255) DEFAULT NULL,
  `balance8` varchar(255) DEFAULT NULL,
  `balance9` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_of_balance` datetime DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `present` bit(1) DEFAULT NULL,
  `balance_definition_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgwxlthvh92003mf2jm3urc5ue` (`person_id`),
  KEY `FK2wkifk6khej2dj0cwryk0iwpa` (`balance_definition_id`),
  CONSTRAINT `FK2wkifk6khej2dj0cwryk0iwpa` FOREIGN KEY (`balance_definition_id`) REFERENCES `cw_balance_definition` (`id`),
  CONSTRAINT `FKgwxlthvh92003mf2jm3urc5ue` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_balance`
--


--
-- Table structure for table `cw_person_2_bank`
--

CREATE TABLE `cw_person_2_bank` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `bic` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `iban` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKbcl947erph3ns2k9mu92l644j` (`person_id`),
  CONSTRAINT `FKbcl947erph3ns2k9mu92l644j` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_bank`
--


--
-- Table structure for table `cw_person_2_calculation_group`
--

CREATE TABLE `cw_person_2_calculation_group` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `calculation_group_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKhu1i2okn71uc62c7cfagxhnd9` (`calculation_group_id`),
  KEY `FKrs87di2igq7hdicirfru52uor` (`person_id`),
  CONSTRAINT `FKhu1i2okn71uc62c7cfagxhnd9` FOREIGN KEY (`calculation_group_id`) REFERENCES `cw_calculation_group` (`id`),
  CONSTRAINT `FKrs87di2igq7hdicirfru52uor` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_calculation_group`
--


--
-- Table structure for table `cw_person_2_canteen_article_delivery`
--

CREATE TABLE `cw_person_2_canteen_article_delivery` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `class` varchar(255) NOT NULL,
  `canteen_article_id` bigint(20) DEFAULT NULL,
  `quantity` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKqfcmiua0r3dgm8g6bhk9pli2x` (`person_id`),
  KEY `FKcol60cb3olelxherc5yv5af4u` (`canteen_article_id`),
  CONSTRAINT `FKcol60cb3olelxherc5yv5af4u` FOREIGN KEY (`canteen_article_id`) REFERENCES `cw_canteen_article` (`id`),
  CONSTRAINT `FKqfcmiua0r3dgm8g6bhk9pli2x` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_canteen_article_delivery`
--


--
-- Table structure for table `cw_person_2_canteen_article_order`
--

CREATE TABLE `cw_person_2_canteen_article_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `canteen_article_id` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `quantity` double NOT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK63qk62q7ev0heuhynnsbshp28` (`canteen_article_id`),
  KEY `FK95lu7gqvsrlra3m789059nnhl` (`person_id`),
  CONSTRAINT `FK63qk62q7ev0heuhynnsbshp28` FOREIGN KEY (`canteen_article_id`) REFERENCES `cw_canteen_article` (`id`),
  CONSTRAINT `FK95lu7gqvsrlra3m789059nnhl` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_canteen_article_order`
--


--
-- Table structure for table `cw_person_2_child`
--

CREATE TABLE `cw_person_2_child` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `birthday` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `national_insurance_number` varchar(255) DEFAULT NULL,
  `person_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKkhv85dpnh2my5cmp7tcl8wo0h` (`person_id`),
  CONSTRAINT `FKkhv85dpnh2my5cmp7tcl8wo0h` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_child`
--


--
-- Table structure for table `cw_person_2_daily_time_permit`
--

CREATE TABLE `cw_person_2_daily_time_permit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `date` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK4ykmn7qfxcrg7rcs599bg0uoy` (`person_id`),
  CONSTRAINT `FK4ykmn7qfxcrg7rcs599bg0uoy` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_daily_time_permit`
--


--
-- Table structure for table `cw_person_2_date_of_close`
--

CREATE TABLE `cw_person_2_date_of_close` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `person_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKoud94yx4ns0vtfw23hs3110su` (`person_id`),
  CONSTRAINT `FKoud94yx4ns0vtfw23hs3110su` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_date_of_close`
--


--
-- Table structure for table `cw_person_2_day_setting`
--

CREATE TABLE `cw_person_2_day_setting` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `date_created` datetime NOT NULL,
  `deactivate_pause1` bit(1) DEFAULT NULL,
  `deactivate_pause2` bit(1) DEFAULT NULL,
  `deactivate_pause3` bit(1) DEFAULT NULL,
  `deactivate_pause4` bit(1) DEFAULT NULL,
  `deactivate_pause5` bit(1) DEFAULT NULL,
  `deactivate_rounding1` bit(1) DEFAULT NULL,
  `deactivate_rounding2` bit(1) DEFAULT NULL,
  `deactivate_rounding3` bit(1) DEFAULT NULL,
  `deactivate_rounding4` bit(1) DEFAULT NULL,
  `deactivate_rounding5` bit(1) DEFAULT NULL,
  `deactivate_too_late1` bit(1) DEFAULT NULL,
  `deactivate_too_late2` bit(1) DEFAULT NULL,
  `deactivate_too_late3` bit(1) DEFAULT NULL,
  `deactivate_too_late4` bit(1) DEFAULT NULL,
  `deactivate_too_late5` bit(1) DEFAULT NULL,
  `deactivate_too_soon1` bit(1) DEFAULT NULL,
  `deactivate_too_soon2` bit(1) DEFAULT NULL,
  `deactivate_too_soon3` bit(1) DEFAULT NULL,
  `deactivate_too_soon4` bit(1) DEFAULT NULL,
  `deactivate_too_soon5` bit(1) DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `update_counter` int(11) NOT NULL,
  `deactivate_all_pauses` bit(1) DEFAULT NULL,
  `deactivate_all_roundings` bit(1) DEFAULT NULL,
  `deactivate_all_too_lates` bit(1) DEFAULT NULL,
  `deactivate_all_too_soons` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK34bodfwe0qonewbhjc0sqt4ew` (`person_id`),
  CONSTRAINT `FK34bodfwe0qonewbhjc0sqt4ew` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_day_setting`
--


--
-- Table structure for table `cw_person_2_day_setting_2_additional_data`
--

CREATE TABLE `cw_person_2_day_setting_2_additional_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `day_setting_additional_data_id` bigint(20) NOT NULL,
  `info_value` longtext DEFAULT NULL,
  `person2day_setting_id` bigint(20) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKtek7qf6vtnr145wqo240qkp8p` (`day_setting_additional_data_id`),
  KEY `FKd818eba5hc3007ioql9jw9kph` (`person2day_setting_id`),
  CONSTRAINT `FKd818eba5hc3007ioql9jw9kph` FOREIGN KEY (`person2day_setting_id`) REFERENCES `cw_person_2_day_setting` (`id`),
  CONSTRAINT `FKtek7qf6vtnr145wqo240qkp8p` FOREIGN KEY (`day_setting_additional_data_id`) REFERENCES `cw_additional_data` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_day_setting_2_additional_data`
--


--
-- Table structure for table `cw_person_2_identification`
--

CREATE TABLE `cw_person_2_identification` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `identification_id` bigint(20) NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK454pbevtlqndd8qlun5ki5749` (`identification_id`),
  KEY `FKlsqkvfgi9i6rhqrxubhy2bvij` (`person_id`),
  CONSTRAINT `FK454pbevtlqndd8qlun5ki5749` FOREIGN KEY (`identification_id`) REFERENCES `cw_identification` (`id`),
  CONSTRAINT `FKlsqkvfgi9i6rhqrxubhy2bvij` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_identification`
--

INSERT INTO `cw_person_2_identification` VALUES
(1,0,'\0',NULL,1,1,NULL,'2022-11-04 00:00:00','2022-11-04 00:00:00');

--
-- Table structure for table `cw_person_2_individual_time_time_plan`
--

CREATE TABLE `cw_person_2_individual_time_time_plan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `individual_time_time_plan_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKo0afonwvywyyfwccisnglap08` (`individual_time_time_plan_id`),
  KEY `FK3ixf30kcoij7ov9o2d5n4y1d7` (`person_id`),
  CONSTRAINT `FK3ixf30kcoij7ov9o2d5n4y1d7` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKo0afonwvywyyfwccisnglap08` FOREIGN KEY (`individual_time_time_plan_id`) REFERENCES `cw_time_time_plan` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_individual_time_time_plan`
--


--
-- Table structure for table `cw_person_2_individual_time_time_type_group`
--

CREATE TABLE `cw_person_2_individual_time_time_type_group` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `individual_time_time_type_group_id` bigint(20) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgdtiyy768h0uu9g901fwjsjm3` (`individual_time_time_type_group_id`),
  KEY `FKkfasnfm061ycs4uifgw5f9cx9` (`person_id`),
  CONSTRAINT `FKgdtiyy768h0uu9g901fwjsjm3` FOREIGN KEY (`individual_time_time_type_group_id`) REFERENCES `cw_individual_time_time_type_group` (`id`),
  CONSTRAINT `FKkfasnfm061ycs4uifgw5f9cx9` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_individual_time_time_type_group`
--


--
-- Table structure for table `cw_person_2_loan_object`
--

CREATE TABLE `cw_person_2_loan_object` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `loan_object_id` bigint(20) NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `quantity` double NOT NULL,
  `start_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKh39n3ownfid2r0w2ac9e712mc` (`loan_object_id`),
  KEY `FKab31gf2w2bt27mr2fonpga22t` (`person_id`),
  CONSTRAINT `FKab31gf2w2bt27mr2fonpga22t` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKh39n3ownfid2r0w2ac9e712mc` FOREIGN KEY (`loan_object_id`) REFERENCES `cw_loan_object` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_loan_object`
--


--
-- Table structure for table `cw_person_2_person_category`
--

CREATE TABLE `cw_person_2_person_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `person_category_id` bigint(20) NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `percent_value` double NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `person_idx` (`person_id`),
  KEY `person_category_idx` (`person_category_id`),
  CONSTRAINT `FK5c5x69986k9t1qex45aprkmfr` FOREIGN KEY (`person_category_id`) REFERENCES `cw_person_category` (`id`),
  CONSTRAINT `FKlfr1fln7p0sianp8axbmpn1lk` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_person_category`
--

INSERT INTO `cw_person_2_person_category` VALUES
(1,0,1,1,NULL,'\0',NULL,0,NULL,0),
(2,0,1,2,NULL,'\0',NULL,0,NULL,0);

--
-- Table structure for table `cw_person_2_person_type`
--

CREATE TABLE `cw_person_2_person_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `person_id` bigint(20) NOT NULL,
  `person_type_id` bigint(20) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKaxtl9ajl3e5yss84kj5fq9kw1` (`person_id`),
  KEY `FKqvksmg3vrkue1mn6t9ad6dire` (`person_type_id`),
  CONSTRAINT `FKaxtl9ajl3e5yss84kj5fq9kw1` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`),
  CONSTRAINT `FKqvksmg3vrkue1mn6t9ad6dire` FOREIGN KEY (`person_type_id`) REFERENCES `cw_person_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_person_type`
--


--
-- Table structure for table `cw_person_2_phone`
--

CREATE TABLE `cw_person_2_phone` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `clockwork_mobile` bit(1) NOT NULL,
  `date_created` datetime NOT NULL,
  `deleted` bit(1) NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `extension` varchar(255) DEFAULT NULL,
  `international_code` varchar(255) DEFAULT NULL,
  `last_updated` datetime NOT NULL,
  `number` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `person_id` bigint(20) NOT NULL,
  `phone_enum` varchar(255) NOT NULL,
  `prefix` varchar(255) DEFAULT NULL,
  `send_information` bit(1) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `update_counter` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKpacshdvnwkrpqvhp2f7yu3lvs` (`person_id`),
  CONSTRAINT `FKpacshdvnwkrpqvhp2f7yu3lvs` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_phone`
--


--
-- Table structure for table `cw_person_2_picture`
--

CREATE TABLE `cw_person_2_picture` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `version` bigint(20) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `deleted` bit(1) DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `person_id` bigint(20) NOT NULL,
  `picture_blob` longblob DEFAULT NULL,
  `position` int(11) NOT NULL,
  `update_counter` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKthpjr20d0mhqmwjp8rbc29hi8` (`person_id`),
  CONSTRAINT `FKthpjr20d0mhqmwjp8rbc29hi8` FOREIGN KEY (`person_id`) REFERENCES `cw_person` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cw_person_2_picture`
--

INSERT INTO `cw_person_2_picture` VALUES
(1,9,'2021-04-06 20:13:10','\0','2021-04-07 01:26:56',1,'data:image/png;base64,[encoded data, 231632 characters]',0,0);

--
