-- Table structure for table `en_text`
--

CREATE TABLE `en_text` (
  `id` int(11) NOT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `x` double(10,3) DEFAULT NULL,
  `y` double(10,3) DEFAULT NULL,
  `z` double(10,3) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `type` int(2) DEFAULT NULL,
  `height` double(10,2) DEFAULT NULL,
  `rotation` double(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `en_text`
--

INSERT INTO `en_text` (`id`, `entity_id`, `x`, `y`, `z`, `text`, `type`, `height`, `rotation`) VALUES
(93, 9701, 3487443.285, 5375121.165, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.50, 0.14),
(94, 9702, 3487427.361, 5375194.500, 0.000, '4860CS', 1, 20.00, 1.44),
(95, 9703, 3487427.361, 5375194.500, 0.000, '4860CS', 1, 20.00, 1.44),
(96, 9956, 3496031.389, 5391725.139, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.62),
(97, 9957, 3495950.483, 5391667.414, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.62),
(98, 9958, 3495890.497, 5391625.518, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.62),
(99, 9959, 3496235.018, 5391805.367, 0.000, '4860BR', 1, 20.00, 0.64),
(100, 10189, 3486981.248, 5374358.033, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.00),
(101, 10190, 3487134.328, 5374498.464, 0.000, '4860CT', 1, 20.00, 1.02),
(102, 10191, 3487134.328, 5374498.464, 0.000, '4860CT', 1, 20.00, 1.02),
(103, 10319, 3497638.388, 5392890.644, 0.000, '4860BP', 1, 20.00, 0.64),
(104, 10663, 3487356.743, 5376273.589, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.15),
(105, 10664, 3487362.781, 5376236.984, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.15),
(106, 10665, 3487345.733, 5376240.819, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.15),
(107, 10666, 3487373.312, 5376170.338, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.15),
(108, 10667, 3487359.036, 5376159.168, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.15),
(109, 10668, 3487370.318, 5376211.931, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.00),
(110, 10669, 3487387.424, 5376081.100, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.14),
(111, 10670, 3487425.615, 5375852.840, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.14),
(112, 10671, 3487350.413, 5376211.381, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.15),
(113, 10672, 3487360.399, 5376180.843, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.16),
(114, 10673, 3487381.463, 5376127.812, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.20, 0.00),
(115, 10674, 3487435.725, 5375699.765, 0.000, 'Element in the Ortho is not visible due to overhead structures', 2, 0.50, 0.16),
(116, 10675, 3487400.614, 5376061.794, 0.000, '4860CR', 1, 20.00, 4.88),
(117, 10987, 3492324.606, 5387275.213, 0.000, '4860ZB', 1, 20.00, 0.90);

-- --------------------------------------------------------

--
-- Table structure for table `fd_drawing`
--

CREATE TABLE `fd_drawing` (
  `id` int(11) NOT NULL,
  `file_type` int(2) NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_original` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `process_id` int(11) DEFAULT NULL,
  `status_code` varchar(4) DEFAULT NULL,
  `uploaded_by` int(11) DEFAULT NULL,
  `uploaded_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_drawing`
--

INSERT INTO `fd_drawing` (`id`, `file_type`, `file_path`, `name`, `name_original`, `workorder_id`, `process_id`, `status_code`, `uploaded_by`, `uploaded_at`) VALUES
(70, 1, '/dks3/PB 1/4860CS/Data-Preparation/20240424_DKS3_4860CS.dwg', '20240424_DKS3_4860CS.dwg', 'DKS3_4860CS.dwg', 44, 2, '100', 1, '2024-04-24 11:48:33'),
(71, 1, '/dks3/PB 1/4860CS/Pre-Production/20240424_DKS3_4860CS_BaseMap_ACAD10_V0.dwg', '20240424_DKS3_4860CS_BaseMap_ACAD10_V0.dwg', 'DKS3_4860CS_BaseMap_ACAD10_V0.dwg', 44, 3, '200', 31, '2024-04-24 12:19:52'),
(72, 1, '/dks3/PB 1/4860CS/Pre-Production/20240424_DKS3_4860CS_Preproduction_Map_V1.dwg', '20240424_DKS3_4860CS_Preproduction_Map_V1.dwg', 'DKS3_4860CS_Preproduction_Map_V1.dwg', 44, 3, '200', 31, '2024-04-24 12:19:52'),
(73, 1, '/dks3/PB 1/4860CS/Pre-Production/20240424_DKS3_4860CS_Map_for_Survey_ACAD10_V1.dwg', '20240424_DKS3_4860CS_Map_for_Survey_ACAD10_V1.dwg', 'DKS3_4860CS_Map_for_Survey_ACAD10_V1.dwg', 44, 3, '200', 31, '2024-04-24 12:19:52'),
(74, 1, '/dks3/PB 1/4860BP/Data-Preparation/20240424_DKS3_4860BP.dwg', '20240424_DKS3_4860BP.dwg', 'DKS3_4860BP.dwg', 67, 2, '100', 1, '2024-04-24 13:22:31'),
(75, 1, '/dks3/PB 1/4860BR/Data-Preparation/20240424_4860BR.dwg', '20240424_4860BR.dwg', '4860BR.dwg', 73, 2, '100', 1, '2024-04-24 13:23:47'),
(76, 1, '/dks3/PB 1/4860BS/Data-Preparation/20240424_4860BS.dwg', '20240424_4860BS.dwg', '4860BS.dwg', 76, 2, '100', 1, '2024-04-24 13:27:13'),
(77, 1, '/dks3/PB 1/4860CT/Data-Preparation/20240424_4860CT.dwg', '20240424_4860CT.dwg', '4860CT.dwg', 47, 2, '100', 1, '2024-04-24 13:27:48'),
(78, 1, '/dks3/PB 1/4860CT/Pre-Production/20240426_DKS3_4860CT_BaseMap_V0_ACAD10.dwg', '20240426_DKS3_4860CT_BaseMap_V0_ACAD10.dwg', 'DKS3_4860CT_BaseMap_V0_ACAD10.dwg', 47, 3, '200', 28, '2024-04-26 08:43:49'),
(79, 1, '/dks3/PB 1/4860CT/Pre-Production/20240426_DKS3_4860CT_Pre-Production_Map_V1.dwg', '20240426_DKS3_4860CT_Pre-Production_Map_V1.dwg', 'DKS3_4860CT_Pre-Production_Map_V1.dwg', 47, 3, '200', 28, '2024-04-26 08:43:49'),
(80, 1, '/dks3/PB 1/4860CT/Pre-Production/20240426_DKS3_4860CT_Map_for_Survey_ACAD10_V1.dwg', '20240426_DKS3_4860CT_Map_for_Survey_ACAD10_V1.dwg', 'DKS3_4860CT_Map_for_Survey_ACAD10_V1.dwg', 47, 3, '200', 28, '2024-04-26 08:43:49'),
(81, 1, '/dks3/PB 1/4860BV/Data-Preparation/20240426_4860BV.dwg', '20240426_4860BV.dwg', '4860BV.dwg', 83, 2, '100', 1, '2024-04-26 11:17:45'),
(82, 1, '/dks3/PB 1/4860BW/Data-Preparation/20240426_4860BW.dwg', '20240426_4860BW.dwg', '4860BW.dwg', 86, 2, '100', 1, '2024-04-26 11:18:27'),
(83, 1, '/dks3/PB 1/4860BX/Data-Preparation/20240426_4860BX.dwg', '20240426_4860BX.dwg', '4860BX.dwg', 89, 2, '100', 1, '2024-04-26 11:19:04'),
(84, 1, '/dks3/PB 1/4860ZB/Data-Preparation/20240426_4860ZB.dwg', '20240426_4860ZB.dwg', '4860ZB.dwg', 53, 2, '100', 1, '2024-04-26 11:19:40'),
(85, 1, '/dks3/PB 1/4860BY/Data-Preparation/20240426_4860BY.dwg', '20240426_4860BY.dwg', '4860BY.dwg', 92, 2, '100', 1, '2024-04-26 11:20:16'),
(86, 1, '/dks3/PB 1/4860CR/Data-Preparation/20240426_4860CR.dwg', '20240426_4860CR.dwg', '4860CR.dwg', 40, 2, '100', 1, '2024-04-26 13:44:27'),
(87, 1, '/dks3/PB 1/4860CR/Pre-Production/20240426_DKS3_4860CR_BaseMap_ACAD10.dwg', '20240426_DKS3_4860CR_BaseMap_ACAD10.dwg', 'DKS3_4860CR_BaseMap_ACAD10.dwg', 40, 3, '200', 28, '2024-04-26 13:51:20'),
(88, 1, '/dks3/PB 1/4860CR/Pre-Production/20240426_DKS3_4860CR_Pre-production_Map_V1.dwg', '20240426_DKS3_4860CR_Pre-production_Map_V1.dwg', 'DKS3_4860CR_Pre-production_Map_V1.dwg', 40, 3, '200', 28, '2024-04-26 13:51:21'),
(89, 1, '/dks3/PB 1/4860CR/Pre-Production/20240426_DKS3_4860CR_Map_for_Survey_ACAD10_V1.dwg', '20240426_DKS3_4860CR_Map_for_Survey_ACAD10_V1.dwg', 'DKS3_4860CR_Map_for_Survey_ACAD10_V1.dwg', 40, 3, '200', 28, '2024-04-26 13:51:21'),
(90, 1, '/dks3/PB 1/4860BP/Pre-Production/20240427_DKS3_4860BP_BaseMap_ACAD13.dwg', '20240427_DKS3_4860BP_BaseMap_ACAD13.dwg', 'DKS3_4860BP_BaseMap_ACAD13.dwg', 67, 3, '200', 28, '2024-04-27 04:51:27'),
(91, 1, '/dks3/PB 1/4860BP/Pre-Production/20240427_DKS3_4860BP_Pre-production_Map_V1.dwg', '20240427_DKS3_4860BP_Pre-production_Map_V1.dwg', 'DKS3_4860BP_Pre-production_Map_V1.dwg', 67, 3, '200', 28, '2024-04-27 04:51:27'),
(92, 1, '/dks3/PB 1/4860BP/Pre-Production/20240427_DKS3_4860BP_Map_for_Survey_ACAD10_V1.dwg', '20240427_DKS3_4860BP_Map_for_Survey_ACAD10_V1.dwg', 'DKS3_4860BP_Map_for_Survey_ACAD10_V1.dwg', 67, 3, '200', 28, '2024-04-27 04:51:27'),
(93, 1, '/dks3/PB 1/4860ZB/Pre-Production/20240427_DKS3_4860ZB_BaseMap.dwg', '20240427_DKS3_4860ZB_BaseMap.dwg', 'DKS3_4860ZB_BaseMap.dwg', 53, 3, '200', 31, '2024-04-27 05:17:59'),
(94, 1, '/dks3/PB 1/4860ZB/Pre-Production/20240427_DKS3_4860ZB_Pre-production_Map_V2.dwg', '20240427_DKS3_4860ZB_Pre-production_Map_V2.dwg', 'DKS3_4860ZB_Pre-production_Map_V2.dwg', 53, 3, '200', 31, '2024-04-27 05:17:59'),
(95, 1, '/dks3/PB 1/4860ZB/Pre-Production/20240427_DKS3_4860ZB_Map_for_Survey_ACAD10_V1.dwg', '20240427_DKS3_4860ZB_Map_for_Survey_ACAD10_V1.dwg', 'DKS3_4860ZB_Map_for_Survey_ACAD10_V1.dwg', 53, 3, '200', 31, '2024-04-27 05:17:59');

-- --------------------------------------------------------

--
-- Table structure for table `fd_fieldtypelist`
--

CREATE TABLE `fd_fieldtypelist` (
  `id` int(11) NOT NULL,
  `fieldtypename` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_fieldtypelist`
--

INSERT INTO `fd_fieldtypelist` (`id`, `fieldtypename`) VALUES
(1, 'int'),
(2, 'decimal'),
(3, 'text'),
(4, 'date'),
(5, 'time'),
(6, 'list');

-- --------------------------------------------------------

--
-- Table structure for table `fd_grouplist`
--

CREATE TABLE `fd_grouplist` (
  `id` int(11) NOT NULL,
  `groupname` varchar(255) NOT NULL,
  `fieldtype` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_grouplist`
--

INSERT INTO `fd_grouplist` (`id`, `groupname`, `fieldtype`) VALUES
(19, 'Trog-Bauwerk_Material', 3),
(20, 'Trog-Bauwerk_Coverform', 3),
(21, 'Trog-Bauwerk_Conditioncover', 3),
(22, 'Trog-Bauwerk_Degreeofpollution', 3),
(23, 'Trog-Bauwerk_Seperatorexisting', 3),
(24, 'Trog-Bauwerk_Objectstatus', 3),
(25, 'Trog-Bauwerk_Active', 3),
(26, 'Bilddokument_Active', 3),
(27, 'ELA-Deckel_Possibletoopen', 3),
(28, 'ELA-Deckel_Coverform', 3),
(29, 'ELA-Deckel_Material', 3),
(30, 'ELA-Deckel_Conditioncover', 3),
(31, 'ELA-Deckel_Objectstatus', 3),
(32, 'ELA-Deckel_Active', 3),
(33, 'ELA-Bauwerk_Material', 3),
(34, 'ELA-Bauwerk_Condition', 3),
(35, 'ELA-Bauwerk_Degreeofpollution', 3),
(36, 'ELA-Bauwerk_Objectstatus', 3),
(37, 'ELA-Bauwerk_Active', 3),
(38, 'ELA-BW-Wand_Crossing', 3),
(39, 'ELA-BW-Wand_Objectstatus', 3),
(40, 'ELA-BW-Wand_Active', 3),
(41, 'Kabel freiliegend_Objectstatus', 3),
(42, 'Kabel freiliegend_Active', 3),
(43, 'Kabelschutzrohr_Objectstatus', 3),
(44, 'Kabelschutzrohr_Active', 3),
(45, 'ABW-Deckel_Coverform', 3),
(46, 'ABW-Deckel_Material', 3),
(47, 'ABW-Deckel_Conditioncover', 3),
(48, 'ABW-Deckel_Objectstatus', 3),
(49, 'ABW-Deckel_Active', 3),
(50, 'WAS-Deckel_Coverform', 3),
(51, 'WAS-Deckel_Material', 3),
(52, 'WAS-Deckel_Conditioncover', 3),
(53, 'WAS-Deckel_Objectstatus', 3),
(54, 'WAS-Deckel_Active', 3),
(55, 'Entfällt_Reason', 3),
(56, 'Entfällt_Active', 3),
(57, 'sonstiger Punkt_Active', 3),
(58, 'Unbekannter-Deckel_Coverform', 3),
(59, 'Unbekannter-Deckel_Material', 3),
(60, 'Unbekannter-Deckel_Conditioncover', 3),
(61, 'Unbekannter-Deckel_Objectstatus', 3),
(62, 'Unbekannter-Deckel_Active', 3),
(63, 'Schaden_Typeofdamage', 3),
(64, 'Schaden_Active', 3),
(65, 'Deckel-Höhenpunkt_Active', 3),
(66, 'ABW-Bauwerk_Material', 3),
(67, 'ABW-Bauwerk_Condition', 3),
(68, 'ABW-Bauwerk_Degreeofpollution', 3),
(69, 'ABW-Bauwerk_Objectstatus', 3),
(70, 'ABW-Bauwerk_Active', 3),
(71, 'WAS-Bauwerk_Material', 3),
(72, 'WAS-Bauwerk_Condition', 3),
(73, 'WAS-Bauwerk_Degreeofpollution', 3),
(74, 'WAS-Bauwerk_Objectstatus', 3),
(75, 'WAS-Bauwerk_Active', 3),
(76, 'GAS-Schieber-Deckel_Coverform', 3),
(77, 'GAS-Schieber-Deckel_Material', 3),
(78, 'GAS-Schieber-Deckel_Conditioncover', 3),
(79, 'GAS-Schieber-Deckel_Objectstatus', 3),
(80, 'GAS-Schieber-Deckel_Active', 3),
(81, 'GRENZBOLZEN_Active', 3),
(82, 'VERMES.PKT (RMK)_Active', 3),
(83, 'HOEHENFESTPUNKT_Active', 3),
(84, 'NAGEL/SONST.PKT_Active', 3);

-- --------------------------------------------------------

--
-- Table structure for table `fd_image`
--

CREATE TABLE `fd_image` (
  `id` int(11) NOT NULL,
  `object_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `name_original` varchar(255) DEFAULT NULL,
  `point_number` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `active_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_image`
--

INSERT INTO `fd_image` (`id`, `object_id`, `name`, `name_original`, `point_number`, `workorder_id`, `active_id`) VALUES
(1928, 1, 'Img_Pt7_080424_103110.jpg', 'Img_Pt7_080424_103110.jpg', 'Pt7', 44, NULL),
(1929, 1, 'Img_Pt7_080424_103120.jpg', 'Img_Pt7_080424_103120.jpg', 'Pt7', 44, NULL),
(1930, 1, 'Img_Pt7_080424_103127.jpg', 'Img_Pt7_080424_103127.jpg', 'Pt7', 44, NULL),
(1931, 1, 'Img_Pt7_080424_103203.jpg', 'Img_Pt7_080424_103203.jpg', 'Pt7', 44, NULL),
(1932, 1, 'Img_Pt7_080424_103115.jpg', 'Img_Pt7_080424_103115.jpg', 'Pt7', 44, NULL),
(1933, 1, 'Img_Pt7_080424_103155.jpg', 'Img_Pt7_080424_103155.jpg', 'Pt7', 44, NULL),
(1934, 2, 'Img_Pt10_080424_103411.jpg', 'Img_Pt10_080424_103411.jpg', 'Pt10', 44, NULL),
(1935, 2, 'Img_Pt10_080424_103421.jpg', 'Img_Pt10_080424_103421.jpg', 'Pt10', 44, NULL),
(1936, 2, 'Img_Pt10_080424_103407.jpg', 'Img_Pt10_080424_103407.jpg', 'Pt10', 44, NULL),
(1937, 2, 'Img_Pt10_080424_103516.jpg', 'Img_Pt10_080424_103516.jpg', 'Pt10', 44, NULL),
(1938, 2, 'Img_Pt10_080424_103416.jpg', 'Img_Pt10_080424_103416.jpg', 'Pt10', 44, NULL),
(1939, 2, 'Img_080424_103306.jpg', 'Img_080424_103306.jpg', 'Pt10', 44, NULL),
(1940, 3, 'Img_Pt64-K_100424_123224.jpg', 'Img_Pt64-K_100424_123224.jpg', 'Pt64', 44, NULL),
(1941, 3, 'Img_Pt64_080424_110142.jpg', 'Img_Pt64_080424_110142.jpg', 'Pt64', 44, NULL),
(1942, 4, 'Img_Pt66-K_100424_122559.jpg', 'Img_Pt66-K_100424_122559.jpg', 'Pt66', 44, NULL),
(1943, 4, 'Img_Pt66-K_100424_123432.jpg', 'Img_Pt66-K_100424_123432.jpg', 'Pt66', 44, NULL),
(1944, 5, 'Img_Pt65-K_100424_123349.jpg', 'Img_Pt65-K_100424_123349.jpg', 'Pt65', 44, NULL),
(1945, 5, 'Img_Pt65-K_100424_122651.jpg', 'Img_Pt65-K_100424_122651.jpg', 'Pt65', 44, NULL),
(1946, 6, 'Img_Pt73_080424_110612.jpg', 'Img_Pt73_080424_110612.jpg', 'Pt73', 44, NULL),
(1947, 6, 'Img_Pt73_080424_110649.jpg', 'Img_Pt73_080424_110649.jpg', 'Pt73', 44, NULL),
(1948, 8, 'Img_Pt76_080424_110751.jpg', 'Img_Pt76_080424_110751.jpg', 'Pt76', 44, NULL),
(1949, 10, 'Img_Pt89_080424_111535.jpg', 'Img_Pt89_080424_111535.jpg', 'Pt89', 44, NULL),
(1950, 10, 'Img_Pt89_080424_111521.jpg', 'Img_Pt89_080424_111521.jpg', 'Pt89', 44, NULL),
(1951, 10, 'Img_Pt89_080424_111515.jpg', 'Img_Pt89_080424_111515.jpg', 'Pt89', 44, NULL),
(1952, 10, 'Img_Pt89_080424_111609.jpg', 'Img_Pt89_080424_111609.jpg', 'Pt89', 44, NULL),
(1953, 10, 'Img_Pt89_080424_111617.jpg', 'Img_Pt89_080424_111617.jpg', 'Pt89', 44, NULL),
(1954, 10, 'Img_Pt89_080424_111528.jpg', 'Img_Pt89_080424_111528.jpg', 'Pt89', 44, NULL),
(1955, 11, 'Img_Pt91_080424_112109.jpg', 'Img_Pt91_080424_112109.jpg', 'Pt91', 44, NULL),
(1956, 13, 'Img_Pt122_080424_112646.jpg', 'Img_Pt122_080424_112646.jpg', 'Pt122', 44, NULL),
(1957, 15, 'Img_Pt146_080424_113356.jpg', 'Img_Pt146_080424_113356.jpg', 'Pt146', 44, NULL),
(1958, 15, 'Img_Pt146_080424_113402.jpg', 'Img_Pt146_080424_113402.jpg', 'Pt146', 44, NULL),
(1959, 15, 'Img_Pt146_080424_113522.jpg', 'Img_Pt146_080424_113522.jpg', 'Pt146', 44, NULL),
(1960, 15, 'Img_Pt146_080424_113514.jpg', 'Img_Pt146_080424_113514.jpg', 'Pt146', 44, NULL),
(1961, 15, 'Img_Pt146_080424_113408.jpg', 'Img_Pt146_080424_113408.jpg', 'Pt146', 44, NULL),
(1962, 15, 'Img_Pt146_080424_113413.jpg', 'Img_Pt146_080424_113413.jpg', 'Pt146', 44, NULL),
(1963, 16, 'Img_GS0001_100424_115535.jpg', 'Img_GS0001_100424_115535.jpg', 'GS0001', 44, NULL),
(1964, 17, 'Img_GS0002_100424_115915.jpg', 'Img_GS0002_100424_115915.jpg', 'GS0002', 44, NULL),
(1965, 18, 'Img_GS0003_100424_120149.jpg', 'Img_GS0003_100424_120149.jpg', 'GS0003', 44, NULL),
(1966, 19, 'Img_GS0004_100424_120243.jpg', 'Img_GS0004_100424_120243.jpg', 'GS0004', 44, NULL),
(1967, 20, 'Img_GS0005_100424_120307.jpg', 'Img_GS0005_100424_120307.jpg', 'GS0005', 44, NULL),
(1968, 21, 'Img_GS0006_100424_120757.jpg', 'Img_GS0006_100424_120757.jpg', 'GS0006', 44, NULL),
(1969, 22, 'Img_GS0007_100424_120826.jpg', 'Img_GS0007_100424_120826.jpg', 'GS0007', 44, NULL),
(1970, 23, 'Img_GS0008_100424_120852.jpg', 'Img_GS0008_100424_120852.jpg', 'GS0008', 44, NULL),
(1971, 24, 'Img_GS0009_100424_120916.jpg', 'Img_GS0009_100424_120916.jpg', 'GS0009', 44, NULL),
(1972, 25, 'Img_GS0010_100424_121013.jpg', 'Img_GS0010_100424_121013.jpg', 'GS0010', 44, NULL),
(1973, 26, 'Img_GS0011_100424_121314.jpg', 'Img_GS0011_100424_121314.jpg', 'GS0011', 44, NULL),
(1974, 28, 'Img_GS0013_100424_121723.jpg', 'Img_GS0013_100424_121723.jpg', 'GS0013', 44, NULL),
(1975, 29, 'Img_GS0014_100424_121922.jpg', 'Img_GS0014_100424_121922.jpg', 'GS0014', 44, NULL),
(1976, 30, 'Img_Pt63-K_100424_123204.jpg', 'Img_Pt63-K_100424_123204.jpg', 'Pt63-K', 44, NULL),
(1977, 34, 'Img_Pt67-K_100424_123448.jpg', 'Img_Pt67-K_100424_123448.jpg', 'Pt67-K', 44, NULL),
(1978, 1, 'Img_Pt17_080424_104303.jpg', 'Img_Pt17_080424_104303.jpg', 'Pt17', 44, NULL),
(1979, 1, 'Img_080424_103644.jpg', 'Img_080424_103644.jpg', 'Pt17', 44, NULL),
(1980, 1, 'Img_Pt15_080424_103909.jpg', 'Img_Pt15_080424_103909.jpg', 'Pt15', 44, NULL),
(1981, 1, 'Img_Pt14_080424_104020.jpg', 'Img_Pt14_080424_104020.jpg', 'Pt14', 44, NULL),
(1982, 2, 'Img_Pt16_080424_104133.jpg', 'Img_Pt16_080424_104133.jpg', 'Pt16', 44, NULL),
(1983, 3, 'Img_Pt18_080424_104106.jpg', 'Img_Pt18_080424_104106.jpg', 'Pt18', 44, NULL),
(1984, 4, 'Img_Pt20_080424_104154.jpg', 'Img_Pt20_080424_104154.jpg', 'Pt20', 44, NULL),
(1985, 1, 'Img_Pt6_080424_102942.jpg', 'Img_Pt6_080424_102942.jpg', 'Pt6', 44, NULL),
(1986, 2, 'Img_Pt34_080424_104627.jpg', 'Img_Pt34_080424_104627.jpg', 'Pt34', 44, NULL),
(1987, 4, 'Img_Pt62-K_100424_123007.jpg', 'Img_Pt62-K_100424_123007.jpg', 'Pt62', 44, NULL),
(1988, 5, 'Img_Pt72_080424_110712.jpg', 'Img_Pt72_080424_110712.jpg', 'Pt72', 44, NULL),
(1989, 7, 'Img_Pt82_080424_110850.jpg', 'Img_Pt82_080424_110850.jpg', 'Pt82', 44, NULL),
(1990, 9, 'Img_Pt88_080424_111146.jpg', 'Img_Pt88_080424_111146.jpg', 'Pt88', 44, NULL),
(1991, 11, 'Img_Pt98_080424_112101.jpg', 'Img_Pt98_080424_112101.jpg', 'Pt98', 44, NULL),
(1992, 13, 'Img_Pt104_080424_112204.jpg', 'Img_Pt104_080424_112204.jpg', 'Pt104', 44, NULL),
(1993, 14, 'Img_Pt110_080424_112331.jpg', 'Img_Pt110_080424_112331.jpg', 'Pt110', 44, NULL),
(1994, 15, 'Img_Pt120_080424_112446.jpg', 'Img_Pt120_080424_112446.jpg', 'Pt120', 44, NULL),
(1995, 16, 'Img_Pt128_080424_112813.jpg', 'Img_Pt128_080424_112813.jpg', 'Pt128', 44, NULL),
(1996, 17, 'Img_Pt134_080424_112927.jpg', 'Img_Pt134_080424_112927.jpg', 'Pt134', 44, NULL),
(1997, 19, 'Img_Pt140_080424_113152.jpg', 'Img_Pt140_080424_113152.jpg', 'Pt140', 44, NULL),
(1998, 2, 'Img_Pt22-K_100424_115254.jpg', 'Img_Pt22-K_100424_115254.jpg', 'Pt22', 44, NULL),
(1999, 4, 'Img_Pt37-K_100424_142316.jpg', 'Img_Pt37-K_100424_142316.jpg', 'Pt37', 44, NULL),
(2000, 6, 'Img_Pt45-K_100424_142159.jpg', 'Img_Pt45-K_100424_142159.jpg', 'Pt45', 44, NULL),
(2001, 7, 'Img_Pt48-K_100424_142127.jpg', 'Img_Pt48-K_100424_142127.jpg', 'Pt48', 44, NULL),
(2002, 8, 'Img_Pt51-K_100424_141954.jpg', 'Img_Pt51-K_100424_141954.jpg', 'Pt51', 44, NULL),
(2003, 9, 'Img_PT55-K_100424_141509.jpg', 'Img_PT55-K_100424_141509.jpg', 'Pt55', 44, NULL),
(2004, 10, 'Img_Pt113-K_100424_121114.jpg', 'Img_Pt113-K_100424_121114.jpg', 'Pt113', 44, NULL),
(2005, 11, 'Img_Pt141-K_100424_115635.jpg', 'Img_Pt141-K_100424_115635.jpg', 'Pt141', 44, NULL),
(2006, 35, 'Img_Pt8_250424_112727.jpg', 'Img_Pt8_250424_112727.jpg', 'Pt8', 53, NULL),
(2007, 36, 'Img_Pt9_250424_112815.jpg', 'Img_Pt9_250424_112815.jpg', 'Pt9', 53, NULL),
(2008, 37, 'Img_Pt12_040324_113004.jpg', 'Img_Pt12_040324_113004.jpg', 'Pt12', 53, NULL),
(2009, 37, 'Img_Pt12_040324_113115.jpg', 'Img_Pt12_040324_113115.jpg', 'Pt12', 53, NULL),
(2010, 37, 'Img_Pt12_040324_112746.jpg', 'Img_Pt12_040324_112746.jpg', 'Pt12', 53, NULL),
(2011, 37, 'Img_Pt12_040324_113036.jpg', 'Img_Pt12_040324_113036.jpg', 'Pt12', 53, NULL),
(2012, 37, 'Img_Pt12_040324_113021.jpg', 'Img_Pt12_040324_113021.jpg', 'Pt12', 53, NULL),
(2013, 37, 'Img_Pt12_040324_113016.jpg', 'Img_Pt12_040324_113016.jpg', 'Pt12', 53, NULL),
(2014, 38, 'Img_Pt14_040324_113638.jpg', 'Img_Pt14_040324_113638.jpg', 'Pt14', 53, NULL),
(2015, 38, 'Img_Pt14_040324_113409.jpg', 'Img_Pt14_040324_113409.jpg', 'Pt14', 53, NULL),
(2016, 38, 'Img_Pt14_040324_113615.jpg', 'Img_Pt14_040324_113615.jpg', 'Pt14', 53, NULL),
(2017, 38, 'Img_Pt14_040324_113604.jpg', 'Img_Pt14_040324_113604.jpg', 'Pt14', 53, NULL),
(2018, 38, 'Img_Pt14_040324_113621.jpg', 'Img_Pt14_040324_113621.jpg', 'Pt14', 53, NULL),
(2019, 38, 'Img_Pt14_040324_113609.jpg', 'Img_Pt14_040324_113609.jpg', 'Pt14', 53, NULL),
(2020, 2, 'Img_Pt21_060324_104618.jpg', 'Img_Pt21_060324_104618.jpg', 'Pt21', 53, NULL),
(2021, 2, 'Img_Pt21_060324_103324.jpg', 'Img_Pt21_060324_103324.jpg', 'Pt21', 53, NULL),
(2022, 2, 'Img_Pt15_060324_104105.jpg', 'Img_Pt15_060324_104105.jpg', 'Pt15', 53, NULL),
(2023, 5, 'Img_Pt16_060324_104415.jpg', 'Img_Pt16_060324_104415.jpg', 'Pt16', 53, NULL),
(2024, 6, 'Img_Pt18_060324_104357.jpg', 'Img_Pt18_060324_104357.jpg', 'Pt18', 53, NULL),
(2025, 7, 'Img_Pt20_060324_104513.jpg', 'Img_Pt20_060324_104513.jpg', 'Pt20', 53, NULL),
(2026, 8, 'Img_Pt22_060324_104335.jpg', 'Img_Pt22_060324_104335.jpg', 'Pt22', 53, NULL),
(2027, 21, 'Img_Pt28_060324_104740.jpg', 'Img_Pt28_060324_104740.jpg', 'Pt28', 53, NULL),
(2028, 22, 'Img_Pt28-K_050424_090704.jpg', 'Img_Pt28-K_050424_090704.jpg', 'Pt28-K', 53, NULL),
(2029, 21, 'Img_Pt6_250424_112528.jpg', 'Img_Pt6_250424_112528.jpg', 'Pt6', 53, NULL),
(2030, 22, 'Img_Pt30_250424_113134.jpg', 'Img_Pt30_250424_113134.jpg', 'Pt30', 53, NULL),
(2031, 1, 'Img_Pt39_250424_113539.jpg', 'Img_Pt39_250424_113539.jpg', 'Pt39', 53, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `fd_line`
--

CREATE TABLE `fd_line` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` int(2) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_line`
--

INSERT INTO `fd_line` (`id`, `name`, `type`, `workorder_id`) VALUES
(110, 'Trog-Bauwerk', 2, 44),
(111, 'Trog-Bauwerk', 2, 44),
(112, 'Trog-Bauwerk', 2, 53),
(113, 'Trog-Bauwerk', 2, 53),
(114, 'Trog-Bauwerk', 2, 53),
(115, 'Trog-Bauwerk', 2, 53);

-- --------------------------------------------------------

--
-- Table structure for table `fd_listofvalues`
--

CREATE TABLE `fd_listofvalues` (
  `id` int(11) NOT NULL,
  `grouplistid` int(11) DEFAULT NULL,
  `fieldvalue` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_listofvalues`
--

INSERT INTO `fd_listofvalues` (`id`, `grouplistid`, `fieldvalue`) VALUES
(27, 19, 'Beton'),
(28, 19, 'GFK'),
(29, 20, 'innenliegend'),
(30, 20, 'aufliegend'),
(31, 21, 'i.O.'),
(32, 21, 'AG öffnen'),
(33, 22, 'leicht'),
(34, 23, 'ja'),
(35, 23, 'nein'),
(36, 24, 'Bestand'),
(37, 24, 'Änderung am Objekt'),
(38, 24, 'Neuaufnahme'),
(39, 25, 'ja'),
(40, 25, 'nein'),
(42, 26, 'ja'),
(43, 26, 'nein'),
(44, 27, 'ja'),
(45, 27, 'nein'),
(46, 28, 'innenliegend'),
(47, 29, 'Beton'),
(48, 30, 'i.O.'),
(49, 30, 'AG defekt'),
(50, 30, 'AG öffnen'),
(51, 31, 'Bestand'),
(52, 31, 'Änderung am Objekt'),
(53, 31, 'Neuaufnahme'),
(54, 32, 'ja'),
(55, 32, 'nein'),
(56, 33, 'Beton'),
(57, 34, 'i.O.'),
(58, 35, 'leicht'),
(59, 35, 'mittel'),
(60, 35, 'stark'),
(61, 36, 'Bestand'),
(62, 36, 'Änderung am Objekt'),
(63, 36, 'Neuaufnahme'),
(64, 37, 'ja'),
(65, 37, 'nein'),
(66, 38, 'ja'),
(67, 38, 'nein'),
(69, 39, 'Bestand'),
(70, 39, 'Änderung am Objekt'),
(71, 39, 'Neuaufnahme'),
(72, 40, 'ja'),
(73, 40, 'nein'),
(74, 41, 'neu'),
(75, 41, 'Bestand'),
(76, 41, 'geändert'),
(77, 41, 'gelöscht'),
(78, 41, 'vorhanden'),
(79, 42, 'ja'),
(80, 42, 'nein'),
(81, 43, 'neu'),
(82, 43, 'geändert'),
(83, 43, 'gelöscht'),
(84, 43, 'vorhanden'),
(85, 44, 'ja'),
(86, 44, 'nein'),
(87, 45, 'innenliegend'),
(88, 45, 'aufliegend'),
(89, 46, 'Beton'),
(90, 46, 'Gußeisen'),
(91, 47, 'AG defekt'),
(92, 47, 'i.O.'),
(93, 48, 'Bestand'),
(94, 48, 'neu'),
(95, 48, 'geändert'),
(96, 48, 'gelöscht'),
(97, 48, 'vorhanden'),
(98, 49, 'ja'),
(99, 49, 'nein'),
(100, 50, 'innenliegend'),
(101, 51, 'Gußeisen'),
(102, 52, 'i.O.'),
(103, 52, 'AG defekt'),
(104, 52, 'AG freiräumen'),
(105, 52, 'AG fehlt'),
(106, 52, 'AG öffnen'),
(107, 53, 'Bestand'),
(108, 53, 'neu'),
(109, 53, 'geändert'),
(110, 53, 'gelöscht'),
(111, 53, 'vorhanden'),
(112, 54, 'ja'),
(113, 54, 'nein'),
(114, 55, 'nicht vorhanden'),
(115, 55, 'nicht sichtbar'),
(116, 56, 'ja'),
(117, 56, 'nein'),
(118, 57, 'ja'),
(119, 57, 'nein');

-- --------------------------------------------------------

--
-- Table structure for table `fd_object_list`
--

CREATE TABLE `fd_object_list` (
  `id` int(11) NOT NULL,
  `point_code` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_object_list`
--

INSERT INTO `fd_object_list` (`id`, `point_code`) VALUES
(1, 'Trog-Bauwerk'),
(2, 'ELA-Deckel'),
(3, 'ELA-Bauwerk'),
(4, 'ELA-BW-Wand '),
(5, 'Kabel freiliegend'),
(6, 'Kabelschutzrohr'),
(7, 'ABW-Deckel'),
(8, 'WAS-Deckel'),
(9, 'Unbekannter-Deckel'),
(10, 'ABW-Bauwerk'),
(11, 'WAS-Bauwerk'),
(12, 'GAS-Schieber-Deckel'),
(13, 'GRENZBOLZEN'),
(14, 'GRENZSTEIN'),
(15, 'VERMES.PKT (RMK)'),
(16, 'HOEHENFESTPUNKT'),
(17, 'NAGEL/SONST.PKT'),
(18, 'Entfällt'),
(19, 'sonstiger Punkt'),
(20, 'Schaden'),
(21, 'Deckel-Höhenpunkt'),
(22, 'Bilddokument');

-- --------------------------------------------------------

--
-- Table structure for table `fd_object_structure`
--

CREATE TABLE `fd_object_structure` (
  `id` int(11) NOT NULL,
  `objectname` varchar(64) DEFAULT NULL,
  `fieldname` varchar(64) DEFAULT NULL,
  `fieldtype` int(2) DEFAULT NULL,
  `fieldsize` int(11) DEFAULT NULL,
  `list_reference_id` int(11) DEFAULT NULL,
  `attribute_position` int(2) DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_object_structure`
--

INSERT INTO `fd_object_structure` (`id`, `objectname`, `fieldname`, `fieldtype`, `fieldsize`, `list_reference_id`, `attribute_position`, `created_user`, `created_date`) VALUES
(4073, 'Trog-Bauwerk', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4074, 'Trog-Bauwerk', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4075, 'Trog-Bauwerk', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4076, 'Trog-Bauwerk', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4077, 'Trog-Bauwerk', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4078, 'Trog-Bauwerk', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4079, 'Trog-Bauwerk', 'Material', 6, 1, 19, 6, 1, '2024-04-07 06:00:52'),
(4080, 'Trog-Bauwerk', 'Breite_gesamt', 2, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4081, 'Trog-Bauwerk', 'lichte_Breite', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4082, 'Trog-Bauwerk', 'lichte_Tiefe', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4083, 'Trog-Bauwerk', 'OK_Kabel', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4084, 'Trog-Bauwerk', 'D_Stärke', 2, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4085, 'Trog-Bauwerk', 'Wandstärke', 2, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4086, 'Trog-Bauwerk', 'Deckel_Innen_Aufliegend', 6, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4087, 'Trog-Bauwerk', 'Zustand_Deckel', 6, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4088, 'Trog-Bauwerk', 'Verschmutzungsgrad', 6, 1, 1, 15, 1, '2024-04-07 06:00:52'),
(4089, 'Trog-Bauwerk', 'Verschmutzungsart', 3, 1, 1, 16, 1, '2024-04-07 06:00:52'),
(4090, 'Trog-Bauwerk', 'Trennsteg_vorhanden', 6, 1, 1, 17, 1, '2024-04-07 06:00:52'),
(4091, 'Trog-Bauwerk', 'Objektstatus', 6, 1, 1, 18, 1, '2024-04-07 06:00:52'),
(4092, 'Trog-Bauwerk', 'Bemerkung1', 3, 1, 1, 19, 1, '2024-04-07 06:00:52'),
(4093, 'Trog-Bauwerk', 'Bemerkung2', 3, 1, 1, 20, 1, '2024-04-07 06:00:52'),
(4094, 'Trog-Bauwerk', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4095, 'Trog-Bauwerk', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4096, 'Trog-Bauwerk', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4097, 'Trog-Bauwerk', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4098, 'Trog-Bauwerk', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4099, 'Trog-Bauwerk', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4100, 'ELA-Deckel', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4101, 'ELA-Deckel', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4102, 'ELA-Deckel', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4103, 'ELA-Deckel', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4104, 'ELA-Deckel', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4105, 'ELA-Deckel', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4106, 'ELA-Deckel', 'zu_öffnen', 6, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4107, 'ELA-Deckel', 'Deckel_Innen_Aufliegend', 6, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4108, 'ELA-Deckel', 'Material', 6, 1, 29, 8, 1, '2024-04-07 06:00:52'),
(4109, 'ELA-Deckel', 'Länge', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4110, 'ELA-Deckel', 'Breite', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4111, 'ELA-Deckel', 'D_Stärke', 2, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4112, 'ELA-Deckel', 'Zustand', 6, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4113, 'ELA-Deckel', 'li_Abst_zu_Wand_in_km_Ri', 2, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4114, 'ELA-Deckel', 'li_Abst_zu_Wand_2', 2, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4115, 'ELA-Deckel', 'li_Abst_zu_Wand_3', 2, 1, 1, 15, 1, '2024-04-07 06:00:52'),
(4116, 'ELA-Deckel', 'li_Abst_zu_Wand_4', 2, 1, 1, 16, 1, '2024-04-07 06:00:52'),
(4117, 'ELA-Deckel', 'li_Länge_Einstieg', 2, 1, 1, 17, 1, '2024-04-07 06:00:52'),
(4118, 'ELA-Deckel', 'li_Breite_Einstieg', 2, 1, 1, 18, 1, '2024-04-07 06:00:52'),
(4119, 'ELA-Deckel', 'OKD_bis_UK_SD', 2, 1, 1, 19, 1, '2024-04-07 06:00:52'),
(4120, 'ELA-Deckel', 'Objektstatus', 3, 1, 1, 20, 1, '2024-04-07 06:00:52'),
(4121, 'ELA-Deckel', 'Bemerkung1', 3, 1, 1, 21, 1, '2024-04-07 06:00:52'),
(4122, 'ELA-Deckel', 'Bemerkung2', 3, 1, 1, 22, 1, '2024-04-07 06:00:52'),
(4123, 'ELA-Deckel', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4124, 'ELA-Deckel', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4125, 'ELA-Deckel', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4126, 'ELA-Deckel', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4127, 'ELA-Deckel', 'Schachtbauwerk_ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4128, 'ELA-Deckel', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4129, 'ELA-Deckel', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4130, 'ELA-Bauwerk', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4131, 'ELA-Bauwerk', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4132, 'ELA-Bauwerk', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4133, 'ELA-Bauwerk', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4134, 'ELA-Bauwerk', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4135, 'ELA-Bauwerk', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4136, 'ELA-Bauwerk', 'Material', 6, 1, 33, 6, 1, '2024-04-07 06:00:52'),
(4137, 'ELA-Bauwerk', 'lichte_Länge', 2, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4138, 'ELA-Bauwerk', 'lichte_Breite', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4139, 'ELA-Bauwerk', 'OKD_bis_Sohle', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4140, 'ELA-Bauwerk', 'OKD_bis_UK_S_Decke', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4141, 'ELA-Bauwerk', 'Deckenstärke', 2, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4142, 'ELA-Bauwerk', 'Zustand', 6, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4143, 'ELA-Bauwerk', 'Verschmutzungsgrad', 6, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4144, 'ELA-Bauwerk', 'Verschmutzungsart', 3, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4145, 'ELA-Bauwerk', 'Wandstärke', 2, 1, 1, 15, 1, '2024-04-07 06:00:52'),
(4146, 'ELA-Bauwerk', 'Objektstatus', 6, 1, 1, 16, 1, '2024-04-07 06:00:52'),
(4147, 'ELA-Bauwerk', 'Bemerkung1', 3, 1, 1, 17, 1, '2024-04-07 06:00:52'),
(4148, 'ELA-Bauwerk', 'Bemerkung2', 3, 1, 1, 18, 1, '2024-04-07 06:00:52'),
(4149, 'ELA-Bauwerk', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4150, 'ELA-Bauwerk', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4151, 'ELA-Bauwerk', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4152, 'ELA-Bauwerk', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4153, 'ELA-Bauwerk', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4154, 'ELA-Bauwerk', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4155, 'ELA-BW-Wand', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4156, 'ELA-BW-Wand', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4157, 'ELA-BW-Wand', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4158, 'ELA-BW-Wand', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4159, 'ELA-BW-Wand', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4160, 'ELA-BW-Wand', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4161, 'ELA-BW-Wand', 'Gleisquerung', 6, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4162, 'ELA-BW-Wand', '1_Aussparung_Breite', 2, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4163, 'ELA-BW-Wand', '1_Aussparung_Höhe', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4164, 'ELA-BW-Wand', '1_Ausspar_Tiefe_v_UKSD', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4165, 'ELA-BW-Wand', '_1_gesamt_Rohre', 1, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4166, 'ELA-BW-Wand', '1_freie_Rohre', 1, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4167, 'ELA-BW-Wand', '1_UKSD_bis_OKR', 2, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4168, 'ELA-BW-Wand', '1_Durchmesser_Rohr', 2, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4169, 'ELA-BW-Wand', '1_durchgänige_Rohre', 1, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4170, 'ELA-BW-Wand', '2_Aussparung_Breite', 2, 1, 1, 15, 1, '2024-04-07 06:00:52'),
(4171, 'ELA-BW-Wand', '2_Aussparung_Höhe', 2, 1, 1, 16, 1, '2024-04-07 06:00:52'),
(4172, 'ELA-BW-Wand', '2_Ausspar_Tiefe_v_USKD', 2, 1, 1, 17, 1, '2024-04-07 06:00:52'),
(4173, 'ELA-BW-Wand', '_2_gesamt_Rohre', 1, 1, 1, 18, 1, '2024-04-07 06:00:52'),
(4174, 'ELA-BW-Wand', '2_freie_Rohre', 1, 1, 1, 19, 1, '2024-04-07 06:00:52'),
(4175, 'ELA-BW-Wand', '2_UKSD_bis_OKR', 2, 1, 1, 20, 1, '2024-04-07 06:00:52'),
(4176, 'ELA-BW-Wand', '2_Durchmesser_Rohr', 2, 1, 1, 21, 1, '2024-04-07 06:00:52'),
(4177, 'ELA-BW-Wand', '2_durchgänige_Rohre', 1, 1, 1, 22, 1, '2024-04-07 06:00:52'),
(4178, 'ELA-BW-Wand', 'Objektstatus', 6, 1, 1, 23, 1, '2024-04-07 06:00:52'),
(4179, 'ELA-BW-Wand', 'Bemerkung1', 3, 1, 1, 24, 1, '2024-04-07 06:00:52'),
(4180, 'ELA-BW-Wand', 'Bemerkung2', 3, 1, 1, 25, 1, '2024-04-07 06:00:52'),
(4181, 'ELA-BW-Wand', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4182, 'ELA-BW-Wand', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4183, 'ELA-BW-Wand', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4184, 'ELA-BW-Wand', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4185, 'ELA-BW-Wand', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4186, 'ELA-BW-Wand', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4187, 'ELA-BW-Wand', 'SchachtbauwerkID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4188, 'Kabel_freiliegend', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4189, 'Kabel_freiliegend', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4190, 'Kabel_freiliegend', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4191, 'Kabel_freiliegend', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4192, 'Kabel_freiliegend', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4193, 'Kabel_freiliegend', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4194, 'Kabel_freiliegend', 'Durchmesser', 1, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4195, 'Kabel_freiliegend', 'Objektstatus', 6, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4196, 'Kabel_freiliegend', 'Bemerkung', 3, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4197, 'Kabel_freiliegend', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4198, 'Kabel_freiliegend', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4199, 'Kabel_freiliegend', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4200, 'Kabel_freiliegend', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4201, 'Kabel_freiliegend', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4202, 'Kabel_freiliegend', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4203, 'Kabelschutzrohr', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4204, 'Kabelschutzrohr', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4205, 'Kabelschutzrohr', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4206, 'Kabelschutzrohr', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4207, 'Kabelschutzrohr', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4208, 'Kabelschutzrohr', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4209, 'Kabelschutzrohr', 'Material', 3, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4210, 'Kabelschutzrohr', 'Durchmesser', 1, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4211, 'Kabelschutzrohr', 'Objektstatus', 6, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4212, 'Kabelschutzrohr', 'Bemerkung', 3, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4213, 'Kabelschutzrohr', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4214, 'Kabelschutzrohr', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4215, 'Kabelschutzrohr', 'BenutzerderAufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4216, 'Kabelschutzrohr', 'IVLName', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4217, 'Kabelschutzrohr', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4218, 'Kabelschutzrohr', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4219, 'ABW-Deckel', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4220, 'ABW-Deckel', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4221, 'ABW-Deckel', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4222, 'ABW-Deckel', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4223, 'ABW-Deckel', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4224, 'ABW-Deckel', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4225, 'ABW-Deckel', 'Deckel_Innen_Aufliegend', 6, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4226, 'ABW-Deckel', 'Material', 6, 1, 46, 7, 1, '2024-04-07 06:00:52'),
(4227, 'ABW-Deckel', 'Länge', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4228, 'ABW-Deckel', 'Breite', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4229, 'ABW-Deckel', 'D_Stärke', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4230, 'ABW-Deckel', 'Zustand_Deckel', 6, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4231, 'ABW-Deckel', 'Objektstatus', 6, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4232, 'ABW-Deckel', 'Bemerkung1', 3, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4233, 'ABW-Deckel', 'Bemerkung2', 3, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4234, 'ABW-Deckel', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4235, 'ABW-Deckel', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4236, 'ABW-Deckel', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4237, 'ABW-Deckel', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4238, 'ABW-Deckel', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4239, 'ABW-Deckel', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4240, 'WAS-Deckel', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4241, 'WAS-Deckel', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4242, 'WAS-Deckel', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4243, 'WAS-Deckel', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4244, 'WAS-Deckel', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4245, 'WAS-Deckel', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4246, 'WAS-Deckel', 'Deckel_Innen_Aufliegend', 6, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4247, 'WAS-Deckel', 'Material', 6, 1, 51, 7, 1, '2024-04-07 06:00:52'),
(4248, 'WAS-Deckel', 'Länge', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4249, 'WAS-Deckel', 'Breite', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4250, 'WAS-Deckel', 'D_Stärke', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4251, 'WAS-Deckel', 'Zustand_Deckel', 6, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4252, 'WAS-Deckel', 'Objektstatus', 6, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4253, 'WAS-Deckel', 'Bemerkung', 3, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4254, 'WAS-Deckel', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4255, 'WAS-Deckel', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4256, 'WAS-Deckel', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4257, 'WAS-Deckel', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4258, 'WAS-Deckel', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4259, 'WAS-Deckel', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4260, 'Entfällt', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4261, 'Entfällt', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4262, 'Entfällt', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4263, 'Entfällt', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4264, 'Entfällt', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4265, 'Entfällt', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4266, 'Entfällt', 'Grund_des_Löschens', 6, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4267, 'Entfällt', 'Bemerkung1', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4268, 'Entfällt', 'Bemerkung2', 3, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4269, 'Entfällt', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4270, 'Entfällt', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4271, 'sonstiger_Punkt', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4272, 'sonstiger_Punkt', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4273, 'sonstiger_Punkt', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4274, 'sonstiger_Punkt', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4275, 'sonstiger_Punkt', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4276, 'sonstiger_Punkt', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4277, 'sonstiger_Punkt', 'Bemerkung1', 3, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4278, 'sonstiger_Punkt', 'Bemerkung2', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4279, 'sonstiger_Punkt', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4280, 'sonstiger_Punkt', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4281, 'Unbekannter-Deckel', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4282, 'Unbekannter-Deckel', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4283, 'Unbekannter-Deckel', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4284, 'Unbekannter-Deckel', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4285, 'Unbekannter-Deckel', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4286, 'Unbekannter-Deckel', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4287, 'Unbekannter-Deckel', 'Deckel_Innen_Aufliegend', 6, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4288, 'Unbekannter-Deckel', 'Material', 6, 1, 59, 7, 1, '2024-04-07 06:00:52'),
(4289, 'Unbekannter-Deckel', 'Länge', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4290, 'Unbekannter-Deckel', 'Breite', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4291, 'Unbekannter-Deckel', 'D-Stärke', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4292, 'Unbekannter-Deckel', 'ZustandDeckel', 6, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4293, 'Unbekannter-Deckel', 'Objektstatus', 6, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4294, 'Unbekannter-Deckel', 'Bemerkung1', 3, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4295, 'Unbekannter-Deckel', 'Bemerkung2', 3, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4296, 'Unbekannter-Deckel', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4297, 'Unbekannter-Deckel', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4298, 'Unbekannter-Deckel', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4299, 'Unbekannter-Deckel', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4300, 'Unbekannter-Deckel', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4301, 'Unbekannter-Deckel', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4302, 'Schaden', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4303, 'Schaden', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4304, 'Schaden', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4305, 'Schaden', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4306, 'Schaden', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4307, 'Schaden', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4308, 'Schaden', 'Schadensart', 6, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4309, 'Schaden', 'Bemerkung1', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4310, 'Schaden', 'Bemerkung2', 3, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4311, 'Schaden', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4312, 'Schaden', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4313, 'Schaden', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4314, 'Schaden', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4315, 'Schaden', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4316, 'Schaden', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4317, 'Deckel-Höhenpunkt', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4318, 'Deckel-Höhenpunkt', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4319, 'Deckel-Höhenpunkt', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4320, 'Deckel-Höhenpunkt', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4321, 'Deckel-Höhenpunkt', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4322, 'Deckel-Höhenpunkt', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4323, 'Deckel-Höhenpunkt', 'Bemerkung1', 3, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4324, 'Deckel-Höhenpunkt', 'Bemerkung2', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4325, 'Deckel-Höhenpunkt', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4326, 'Deckel-Höhenpunkt', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4327, 'Deckel-Höhenpunkt', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4328, 'Deckel-Höhenpunkt', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4329, 'Deckel-Höhenpunkt', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4330, 'Deckel-Höhenpunkt', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4331, 'ABW-Bauwerk', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4332, 'ABW-Bauwerk', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4333, 'ABW-Bauwerk', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4334, 'ABW-Bauwerk', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4335, 'ABW-Bauwerk', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4336, 'ABW-Bauwerk', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4337, 'ABW-Bauwerk', 'Material', 6, 1, 66, 6, 1, '2024-04-07 06:00:52'),
(4338, 'ABW-Bauwerk', 'lichte_Länge', 2, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4339, 'ABW-Bauwerk', 'lichte_Breite', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4340, 'ABW-Bauwerk', 'Tiefe_ab_OKD', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4341, 'ABW-Bauwerk', 'D_Stärke', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4342, 'ABW-Bauwerk', 'Wandstärke', 2, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4343, 'ABW-Bauwerk', 'Zustand', 6, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4344, 'ABW-Bauwerk', 'Verschmutzungsgrad', 6, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4345, 'ABW-Bauwerk', 'Verschmutzungsart', 3, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4346, 'ABW-Bauwerk', 'Objektstatus', 6, 1, 1, 15, 1, '2024-04-07 06:00:52'),
(4347, 'ABW-Bauwerk', 'Bemerkung1', 3, 1, 1, 16, 1, '2024-04-07 06:00:52'),
(4348, 'ABW-Bauwerk', 'Bemerkung2', 3, 1, 1, 17, 1, '2024-04-07 06:00:52'),
(4349, 'ABW-Bauwerk', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4350, 'ABW-Bauwerk', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4351, 'ABW-Bauwerk', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4352, 'ABW-Bauwerk', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4353, 'ABW-Bauwerk', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4354, 'ABW-Bauwerk', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4355, 'WAS-Bauwerk', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4356, 'WAS-Bauwerk', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4357, 'WAS-Bauwerk', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4358, 'WAS-Bauwerk', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4359, 'WAS-Bauwerk', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4360, 'WAS-Bauwerk', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4361, 'WAS-Bauwerk', 'Material', 6, 1, 71, 6, 1, '2024-04-07 06:00:52'),
(4362, 'WAS-Bauwerk', 'lichte_Länge', 2, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4363, 'WAS-Bauwerk', 'lichte_Breite', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4364, 'WAS-Bauwerk', 'Tiefe_ab_OKD', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4365, 'WAS-Bauwerk', 'D_Stärke', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4366, 'WAS-Bauwerk', 'Wandstärke', 2, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4367, 'WAS-Bauwerk', 'Zustand', 6, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4368, 'WAS-Bauwerk', 'Verschmutzungsgrad', 6, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4369, 'WAS-Bauwerk', 'Verschmutzungsart', 3, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4370, 'WAS-Bauwerk', 'Objektstatus', 6, 1, 1, 15, 1, '2024-04-07 06:00:52'),
(4371, 'WAS-Bauwerk', 'Bemerkung1', 3, 1, 1, 16, 1, '2024-04-07 06:00:52'),
(4372, 'WAS-Bauwerk', 'Bemerkung2', 3, 1, 1, 17, 1, '2024-04-07 06:00:52'),
(4373, 'WAS-Bauwerk', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4374, 'WAS-Bauwerk', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4375, 'WAS-Bauwerk', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4376, 'WAS-Bauwerk', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4377, 'WAS-Bauwerk', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4378, 'WAS-Bauwerk', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4379, 'GAS-Schieber-Deckel', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4380, 'GAS-Schieber-Deckel', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4381, 'GAS-Schieber-Deckel', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4382, 'GAS-Schieber-Deckel', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4383, 'GAS-Schieber-Deckel', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4384, 'GAS-Schieber-Deckel', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4385, 'GAS-Schieber-Deckel', 'Deckel_Innen_Aufliegend', 6, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4386, 'GAS-Schieber-Deckel', 'Material', 6, 1, 77, 7, 1, '2024-04-07 06:00:52'),
(4387, 'GAS-Schieber-Deckel', 'Länge', 2, 1, 1, 8, 1, '2024-04-07 06:00:52'),
(4388, 'GAS-Schieber-Deckel', 'Breite', 2, 1, 1, 9, 1, '2024-04-07 06:00:52'),
(4389, 'GAS-Schieber-Deckel', 'D_Stärke', 2, 1, 1, 10, 1, '2024-04-07 06:00:52'),
(4390, 'GAS-Schieber-Deckel', 'Zustand_Deckel', 6, 1, 1, 11, 1, '2024-04-07 06:00:52'),
(4391, 'GAS-Schieber-Deckel', 'Objektstatus', 6, 1, 1, 12, 1, '2024-04-07 06:00:52'),
(4392, 'GAS-Schieber-Deckel', 'Bemerkung1', 3, 1, 1, 13, 1, '2024-04-07 06:00:52'),
(4393, 'GAS-Schieber-Deckel', 'Bemerkung2', 3, 1, 1, 14, 1, '2024-04-07 06:00:52'),
(4394, 'GAS-Schieber-Deckel', 'Date', 4, 1, 1, 26, 1, '2024-04-07 06:00:52'),
(4395, 'GAS-Schieber-Deckel', 'time', 5, 1, 1, 27, 1, '2024-04-07 06:00:52'),
(4396, 'GAS-Schieber-Deckel', 'Benutzer_der_Aufnahme', 3, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4397, 'GAS-Schieber-Deckel', 'IVL_Name', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4398, 'GAS-Schieber-Deckel', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4399, 'GAS-Schieber-Deckel', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4400, 'GRENZBOLZEN', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4401, 'GRENZBOLZEN', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4402, 'GRENZBOLZEN', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4403, 'GRENZBOLZEN', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4404, 'GRENZBOLZEN', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4405, 'GRENZBOLZEN', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4406, 'GRENZBOLZEN', 'Bemerkung1', 3, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4407, 'GRENZBOLZEN', 'Bemerkung2', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4408, 'GRENZBOLZEN', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4409, 'GRENZBOLZEN', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4410, 'GRENZSTEIN', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4411, 'GRENZSTEIN', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4412, 'GRENZSTEIN', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4413, 'GRENZSTEIN', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4414, 'GRENZSTEIN', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4415, 'GRENZSTEIN', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4416, 'GRENZSTEIN', 'Bemerkung1', 3, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4417, 'GRENZSTEIN', 'Bemerkung2', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4418, 'GRENZSTEIN', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4419, 'GRENZSTEIN', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4420, 'VERMES_PKT_RMK', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4421, 'VERMES_PKT_RMK', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4422, 'VERMES_PKT_RMK', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4423, 'VERMES_PKT_RMK', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4424, 'VERMES_PKT_RMK', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4425, 'VERMES_PKT_RMK', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4426, 'VERMES_PKT_RMK', 'Bemerkung1', 3, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4427, 'VERMES_PKT_RMK', 'Bemerkung2', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4428, 'VERMES_PKT_RMK', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4429, 'VERMES_PKT_RMK', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4430, 'HOEHENFESTPUNKT', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4431, 'HOEHENFESTPUNKT', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4432, 'HOEHENFESTPUNKT', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4433, 'HOEHENFESTPUNKT', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4434, 'HOEHENFESTPUNKT', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4435, 'HOEHENFESTPUNKT', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4436, 'HOEHENFESTPUNKT', 'Bemerkung1', 3, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4437, 'HOEHENFESTPUNKT', 'Bemerkung2', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4438, 'HOEHENFESTPUNKT', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4439, 'HOEHENFESTPUNKT', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4440, 'NAGEL_SONST_PKT', 'Code', 3, 1, 1, 5, 1, '2024-04-07 06:00:52'),
(4441, 'NAGEL_SONST_PKT', 'ID', 1, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4442, 'NAGEL_SONST_PKT', 'Punktnummer', 3, 1, 1, 1, 1, '2024-04-07 06:00:52'),
(4443, 'NAGEL_SONST_PKT', 'Ostwert', 2, 1, 1, 2, 1, '2024-04-07 06:00:52'),
(4444, 'NAGEL_SONST_PKT', 'Nord', 2, 1, 1, 3, 1, '2024-04-07 06:00:52'),
(4445, 'NAGEL_SONST_PKT', 'Höhe', 2, 1, 1, 4, 1, '2024-04-07 06:00:52'),
(4446, 'NAGEL_SONST_PKT', 'Bemerkung1', 3, 1, 1, 6, 1, '2024-04-07 06:00:52'),
(4447, 'NAGEL_SONST_PKT', 'Bemerkung2', 3, 1, 1, 7, 1, '2024-04-07 06:00:52'),
(4448, 'NAGEL_SONST_PKT', 'Aktiv', 6, 1, 1, 0, 1, '2024-04-07 06:00:52'),
(4449, 'NAGEL_SONST_PKT', 'DWG_objekt', 6, 1, 1, 0, 1, '2024-04-07 06:00:52');

-- --------------------------------------------------------

--
-- Table structure for table `fd_object_structure_pp`
--

CREATE TABLE `fd_object_structure_pp` (
  `id` int(11) NOT NULL,
  `objectname` varchar(100) DEFAULT NULL,
  `fieldname` varchar(100) DEFAULT NULL,
  `fieldtype` int(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_object_structure_pp`
--

INSERT INTO `fd_object_structure_pp` (`id`, `objectname`, `fieldname`, `fieldtype`) VALUES
(1, 'Kabelschacht', 'ID', 1),
(2, 'Kabelschacht', 'Elevation', 2),
(3, 'Kabelschacht', 'Action', 3),
(4, 'Kabelschutzrohr', 'ID', 1),
(5, 'Kabelschutzrohr', 'Elevation', 2),
(6, 'Kabelschutzrohr', 'Action', 3),
(7, 'Kabelschutzrohr', 'Diameter', 2),
(8, 'Leitungstrasse', 'Trassenbreite', 2),
(9, 'Leitungstrasse', 'ID', 1),
(10, 'Leitungstrasse', 'Action', 3),
(11, 'Schacht_unbekannt', 'Elevation', 2),
(12, 'Schacht_unbekannt', 'ID', 1),
(13, 'Schacht_unbekannt', 'Action', 3),
(14, 'Schaltschrank', 'Elevation', 2),
(15, 'Schaltschrank', 'ID', 1),
(16, 'Schaltschrank', 'Action', 3),
(17, 'Wasserschacht', 'Elevation', 2),
(18, 'Wasserschacht', 'ID', 1),
(19, 'Wasserschacht', 'Action', 3),
(20, 'zu_checken', 'ID', 1),
(21, 'zu_checken', 'Text', 3),
(22, 'zu_checken', 'Action', 3);

-- --------------------------------------------------------

--
-- Table structure for table `fd_point`
--

CREATE TABLE `fd_point` (
  `id` int(11) NOT NULL,
  `line_id` int(11) DEFAULT NULL,
  `x` double(10,3) DEFAULT NULL,
  `y` double(10,3) DEFAULT NULL,
  `z` double(10,3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fd_point`
--

INSERT INTO `fd_point` (`id`, `line_id`, `x`, `y`, `z`) VALUES
(401, 110, 3487452.129, 5375576.647, 467.434),
(402, 110, 3487458.231, 5375538.200, 467.662),
(403, 110, 3487469.367, 5375443.141, 468.452),
(404, 110, 3487470.560, 5375425.237, 468.634),
(405, 110, 3487471.547, 5375419.413, 468.347),
(406, 110, 3487472.929, 5375372.452, 468.801),
(407, 110, 3487472.281, 5375367.113, 469.548),
(408, 110, 3487472.110, 5375361.879, 469.589),
(409, 110, 3487472.844, 5375356.656, 469.389),
(410, 110, 3487471.020, 5375307.850, 469.931),
(411, 110, 3487463.900, 5375236.783, 470.854),
(412, 110, 3487454.777, 5375184.806, 471.120),
(413, 111, 3487376.005, 5374946.351, 473.308),
(414, 111, 3487375.219, 5374940.736, 472.987),
(415, 111, 3487353.744, 5374898.951, 473.395),
(416, 111, 3487336.636, 5374868.593, 473.673),
(417, 111, 3487336.508, 5374865.910, 473.749),
(418, 112, 3492392.524, 5387457.193, 459.562),
(419, 112, 3492407.503, 5387481.438, 459.524),
(420, 113, 3492417.117, 5387476.312, 459.671),
(421, 113, 3492415.654, 5387474.052, 459.675),
(422, 114, 3492407.630, 5387462.651, 459.782),
(423, 114, 3492406.016, 5387460.150, 460.018),
(424, 114, 3492403.246, 5387454.989, 460.003),
(425, 114, 3492398.397, 5387447.238, 460.052),
(426, 114, 3492397.145, 5387445.598, 460.021),
(427, 114, 3492395.022, 5387441.834, 460.079),
(428, 114, 3492382.363, 5387421.640, 460.077),
(429, 114, 3492360.594, 5387388.027, 460.103),
(430, 114, 3492356.826, 5387383.516, 460.083),
(431, 114, 3492355.261, 5387381.119, 459.852),
(432, 115, 3492241.169, 5387229.724, 460.239),
(433, 115, 3492237.884, 5387226.259, 460.709),
(434, 115, 3492215.807, 5387201.141, 460.678);

-- --------------------------------------------------------

--
-- Table structure for table `hi_kabelschacht`
--

CREATE TABLE `hi_kabelschacht` (
  `en_id` int(11) NOT NULL,
  `ID` int(11) NOT NULL,
  `Elevation` double(10,3) DEFAULT NULL,
  `Action` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hi_kabelschacht`
--

INSERT INTO `hi_kabelschacht` (`en_id`, `ID`, `Elevation`, `Action`) VALUES
(276, 9637, 467.149, 'IVL_Modified_Shape'),
(277, 9840, 447.135, 'Not_In_IVL'),
(278, 9841, 447.177, 'Not_In_IVL'),
(279, 9856, 454.427, 'IVL_Modified_Shape'),
(280, 9857, 454.415, 'IVL_Modified_Shape'),
(281, 9859, 454.432, 'IVL_Modified_Shape'),
(282, 9860, 454.424, 'IVL_Modified_Shape'),
(283, 9862, 454.441, 'IVL_Modified_Shape'),
(284, 9863, 454.438, 'IVL_Modified_Shape'),
(285, 9864, 454.432, 'IVL_Modified_Shape'),
(286, 9865, 454.431, 'IVL_Modified_Shape'),
(287, 9866, 454.420, 'IVL_Modified_Shape'),
(288, 9867, 454.436, 'IVL_Modified_Shape'),
(289, 9868, 454.442, 'IVL_Modified_Shape'),
(290, 9869, 449.852, 'Not_In_IVL'),
(291, 9870, 453.434, 'IVL_Modified_Shape'),
(292, 10274, 440.311, 'Not_In_IVL'),
(293, 10277, 437.213, 'Not_In_IVL'),
(294, 10278, 437.707, 'Not_In_IVL'),
(295, 10533, 463.750, 'IVL_Modified_Shape'),
(296, 10534, 464.605, 'IVL_Modified_Shape'),
(297, 10535, 464.595, 'IVL_Modified_Shape'),
(298, 10537, 464.589, 'IVL_Modified_Shape'),
(299, 10538, 464.447, 'IVL_Modified_Shape'),
(300, 10539, 464.571, 'IVL_Modified_Shape'),
(301, 10540, 464.585, 'IVL_Modified_Shape'),
(302, 10541, 464.433, 'IVL_Modified_Shape'),
(303, 10542, 464.448, 'IVL_Modified_Shape'),
(304, 10543, 464.465, 'IVL_Modified_Shape'),
(305, 10544, 464.575, 'IVL_Modified_Shape'),
(306, 10545, 464.460, 'IVL_Modified_Shape'),
(307, 10547, 464.452, 'IVL_Modified_Shape'),
(308, 10549, 464.602, 'IVL_Modified_Shape'),
(309, 10552, 464.310, 'IVL_Modified_Shape'),
(310, 10553, 464.462, 'IVL_Modified_Shape'),
(311, 10554, 464.313, 'IVL_Modified_Shape'),
(312, 10555, 464.440, 'IVL_Modified_Shape'),
(313, 10556, 463.891, 'IVL_Modified_Shape'),
(314, 10559, 464.594, 'IVL_Modified_Shape'),
(315, 10560, 464.584, 'IVL_Modified_Shape'),
(316, 10562, 464.577, 'IVL_Modified_Shape'),
(317, 10564, 464.572, 'IVL_Modified_Shape'),
(318, 10565, 464.491, 'IVL_Modified_Shape'),
(319, 10566, 464.484, 'IVL_Modified_Shape'),
(320, 10567, 464.395, 'IVL_Modified_Shape'),
(321, 10569, 464.463, 'IVL_Modified_Shape'),
(322, 10570, 464.376, 'IVL_Modified_Shape'),
(323, 10571, 464.411, 'IVL_Modified_Shape'),
(324, 10572, 464.431, 'IVL_Modified_Shape'),
(325, 10573, 464.364, 'IVL_Modified_Shape'),
(326, 10574, 464.335, 'IVL_Modified_Shape'),
(327, 10575, 464.617, 'IVL_Modified_Shape'),
(328, 10576, 464.604, 'IVL_Modified_Shape'),
(329, 10577, 464.597, 'IVL_Modified_Shape'),
(330, 10578, 464.585, 'IVL_Modified_Shape'),
(331, 10579, 464.599, 'IVL_Modified_Shape'),
(332, 10580, 464.604, 'IVL_Modified_Shape'),
(333, 10598, 464.307, 'IVL_Modified_Shape'),
(334, 10599, 464.601, 'IVL_Modified_Shape'),
(335, 10957, 460.332, 'IVL_Modified_Shape');

-- --------------------------------------------------------

--
-- Table structure for table `hi_kabelschutzrohr`
--

CREATE TABLE `hi_kabelschutzrohr` (
  `en_id` int(11) NOT NULL,
  `ID` int(11) NOT NULL,
  `Elevation` double(10,3) DEFAULT NULL,
  `Action` varchar(255) DEFAULT NULL,
  `Diameter` double(10,3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hi_layer`
--

CREATE TABLE `hi_layer` (
  `id` int(11) NOT NULL,
  `processstep_id` int(11) DEFAULT NULL,
  `layername` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hi_layer`
--

INSERT INTO `hi_layer` (`id`, `processstep_id`, `layername`) VALUES
(38, 2, '01_Beschriftung_NUMMERNBEZ'),
(39, 2, '01_NUMMERNBEZIRK'),
(40, 2, 'HI_Kabelschacht'),
(41, 2, 'HI_Kabelschacht_Verify'),
(42, 2, 'HI_Leitungstrasse'),
(43, 2, 'HI_Leitungstrasse_Verify'),
(44, 2, 'HI_Schaltschrank'),
(45, 2, 'HI_Schaltschrank_Verify'),
(46, 2, 'HI_Wasserschacht'),
(47, 2, 'HI_Wasserschacht_Verify'),
(48, 2, 'HI_Zu_Checken'),
(49, 2, 'HI_TEXT'),
(50, 2, 'IVL_Captured'),
(51, 2, 'LEITUNGSEINR_Schacht_Abw.'),
(52, 2, 'LEITUNGSEINR_Schacht_ET'),
(53, 2, 'LEITUNGSEINR_Schacht_EW'),
(54, 2, 'LEITUNGSEINR_Schacht_SO'),
(55, 2, 'LEITUNGSEINR_Schacht_TK'),
(56, 2, 'LEITUNGSEINR_Schacht_Wasse'),
(57, 2, 'Leitungstrasse'),
(58, 2, 'Leitungstrasse_Unter'),
(59, 2, 'SCHALTHAUS'),
(60, 2, 'SCHALTSCHRANK'),
(61, 2, 'V_HÖHEN'),
(62, 2, 'HI_Schacht_Unbekannt_Verify'),
(63, 2, 'IVL_OutOfScope'),
(64, 3, 'HI_Kabelschacht'),
(65, 3, 'HI_Kabelschacht_Verify'),
(66, 3, 'HI_Leitungstrasse'),
(67, 3, 'HI_Leitungstrasse_Verify'),
(68, 3, 'HI_Schaltschrank'),
(69, 3, 'HI_Schaltschrank_Verify'),
(70, 3, 'HI_Wasserschacht'),
(71, 3, 'HI_Wasserschacht_Verify'),
(72, 3, 'HI_Schacht_Unbekannt _Verify'),
(73, 3, 'HI_Zu_Checken'),
(74, 3, 'TEXT');

-- --------------------------------------------------------

--
-- Table structure for table `hi_leitungstrasse`
--

CREATE TABLE `hi_leitungstrasse` (
  `en_id` int(11) NOT NULL,
  `Trassenbreite` double(10,3) DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `Action` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hi_leitungstrasse`
--

INSERT INTO `hi_leitungstrasse` (`en_id`, `Trassenbreite`, `ID`, `Action`) VALUES
(309, 0.200, 9662, 'IVL_Modified_Shape'),
(310, 0.200, 9663, 'IVL_Modified_Shape'),
(311, 0.150, 9665, 'Not_In_IVL'),
(312, 0.150, 9667, 'Not_In_IVL'),
(313, 0.150, 9668, 'Not_In_IVL'),
(314, 0.150, 9669, 'Not_In_IVL'),
(315, 0.150, 9670, 'Not_In_IVL'),
(316, 0.150, 9671, 'Not_In_IVL'),
(317, 0.150, 9672, 'Not_In_IVL'),
(318, 0.150, 9673, 'Not_In_IVL'),
(319, 0.150, 9675, 'Not_In_IVL'),
(320, 0.150, 9676, 'Not_In_IVL'),
(321, 0.150, 9677, 'Not_In_IVL'),
(322, 0.150, 9679, 'Not_In_IVL'),
(323, 0.150, 9681, 'Not_In_IVL'),
(324, 0.150, 9683, 'Not_In_IVL'),
(325, 0.150, 9684, 'Not_In_IVL'),
(326, 0.150, 9687, 'Not_In_IVL'),
(327, 0.200, 9688, 'Not_In_IVL'),
(328, 0.150, 9690, 'Not_In_IVL'),
(329, 0.150, 9692, 'Not_In_IVL'),
(330, 0.150, 9694, 'Not_In_IVL'),
(331, 0.150, 9696, 'Not_In_IVL'),
(332, 0.150, 9698, 'Not_In_IVL'),
(333, 0.150, 9699, 'Not_In_IVL'),
(334, 0.150, 9700, 'Not_In_IVL'),
(335, 0.200, 9930, 'IVL_Modified_Shape'),
(336, 0.200, 9931, 'IVL_Modified_Shape'),
(337, 0.000, 9934, 'IVL_Modified_Shape'),
(338, 0.300, 9935, 'IVL_Modified_Shape'),
(339, 0.400, 9938, 'IVL_Modified_Shape'),
(340, 0.400, 9939, 'IVL_Modified_Shape'),
(341, 0.450, 9940, 'IVL_Modified_Shape'),
(342, 0.300, 9941, 'IVL_Modified_Shape'),
(343, 0.600, 9942, 'IVL_Modified_Shape'),
(344, 0.300, 9943, 'IVL_Modified_Shape'),
(345, 0.300, 9944, 'IVL_Modified_Shape'),
(346, 0.300, 9946, 'IVL_Modified_Shape'),
(347, 0.200, 9947, 'IVL_Modified_Shape'),
(348, 0.800, 9951, 'Not_In_IVL'),
(349, 0.200, 9952, 'IVL_Modified_Shape'),
(350, 0.300, 9954, 'IVL_Modified_Shape'),
(351, 0.200, 9955, 'IVL_Modified_Shape'),
(352, 0.150, 10176, 'Not_In_IVL'),
(353, 0.150, 10179, 'Not_In_IVL'),
(354, 0.150, 10183, 'Not_In_IVL'),
(355, 0.150, 10188, 'Not_In_IVL'),
(356, 0.200, 10300, 'IVL_Modified_Shape'),
(357, 0.200, 10301, 'IVL_Modified_Shape'),
(358, 0.200, 10302, 'IVL_Modified_Shape'),
(359, 0.400, 10303, 'IVL_Modified_Shape'),
(360, 0.200, 10304, 'IVL_Modified_Shape'),
(361, 0.200, 10305, 'IVL_Modified_Shape'),
(362, 0.200, 10306, 'IVL_Modified_Shape'),
(363, 0.400, 10307, 'IVL_Modified_Shape'),
(364, 0.600, 10308, 'IVL_Modified_Shape'),
(365, 0.600, 10309, 'IVL_Modified_Shape'),
(366, 0.500, 10310, 'IVL_Modified_Shape'),
(367, 0.300, 10313, 'IVL_Modified_Shape'),
(368, 0.600, 10314, 'IVL_Modified_Shape'),
(369, 0.200, 10315, 'Not_In_IVL'),
(370, 0.300, 10316, 'IVL_Modified_Shape'),
(371, 0.600, 10317, 'IVL_Modified_Shape'),
(372, 0.400, 10318, 'IVL_Modified_Shape'),
(373, 0.800, 10647, 'IVL_Modified_Shape'),
(374, 0.400, 10648, 'IVL_Modified_Shape'),
(375, 0.850, 10649, 'IVL_Modified_Shape'),
(376, 0.700, 10650, 'IVL_Modified_Shape'),
(377, 0.150, 10652, 'IVL_Modified_Shape'),
(378, 0.300, 10653, 'IVL_Modified_Shape'),
(379, 0.150, 10656, 'IVL_Modified_Shape'),
(380, 0.400, 10657, 'IVL_Modified_Shape'),
(381, 0.250, 10662, 'Not_In_IVL'),
(382, 0.200, 10969, 'IVL_Modified_Shape'),
(383, 0.200, 10970, 'IVL_Modified_Shape'),
(384, 0.200, 10971, 'IVL_Modified_Shape'),
(385, 0.200, 10972, 'IVL_Modified_Shape'),
(386, 0.200, 10973, 'IVL_Modified_Shape'),
(387, 0.200, 10974, 'IVL_Modified_Shape'),
(388, 0.400, 10978, 'IVL_Modified_Shape'),
(389, 0.700, 10979, 'IVL_Modified_Shape'),
(390, 0.700, 10980, 'IVL_Modified_Shape'),
(391, 0.200, 10981, 'IVL_Modified_Shape'),
(392, 0.400, 10982, 'IVL_Modified_Shape'),
(393, 0.500, 10983, 'IVL_Modified_Shape'),
(394, 0.200, 10984, 'IVL_Modified_Shape'),
(395, 0.500, 10985, 'IVL_Modified_Shape'),
(396, 0.400, 10986, 'IVL_Modified_Shape');

-- --------------------------------------------------------

--
-- Table structure for table `hi_schacht_unbekannt`
--

CREATE TABLE `hi_schacht_unbekannt` (
  `en_id` int(11) NOT NULL,
  `Elevation` double(10,3) DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `Action` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hi_schaltschrank`
--

CREATE TABLE `hi_schaltschrank` (
  `en_id` int(11) NOT NULL,
  `Elevation` double(10,3) DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `Action` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hi_schaltschrank`
--

INSERT INTO `hi_schaltschrank` (`en_id`, `Elevation`, `ID`, `Action`) VALUES
(37, 448.125, 9846, 'IVL_Modified_Shape'),
(38, 452.691, 9847, 'IVL_Modified_Shape'),
(39, 447.450, 10272, 'IVL_Modified_Location'),
(40, 441.655, 10273, 'Not_In_IVL'),
(41, 464.449, 10513, 'Not_In_IVL'),
(42, 464.038, 10514, 'Not_In_IVL'),
(43, 465.838, 10515, 'IVL_Modified_Shape'),
(44, 465.834, 10516, 'IVL_Modified_Shape'),
(45, 465.832, 10517, 'IVL_Modified_Shape'),
(46, 465.825, 10518, 'IVL_Modified_Shape'),
(47, 466.046, 10521, 'IVL_Modified_Shape'),
(48, 465.678, 10522, 'IVL_Modified_Shape'),
(49, 464.805, 10530, 'Not_In_IVL'),
(50, 464.785, 10531, 'IVL_Modified_Shape'),
(51, 461.572, 10958, 'IVL_Modified_Shape');

-- --------------------------------------------------------

--
-- Table structure for table `hi_wasserschacht`
--

CREATE TABLE `hi_wasserschacht` (
  `en_id` int(11) NOT NULL,
  `Elevation` double(10,3) DEFAULT NULL,
  `ID` int(11) DEFAULT NULL,
  `Action` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hi_wasserschacht`
--

INSERT INTO `hi_wasserschacht` (`en_id`, `Elevation`, `ID`, `Action`) VALUES
(201, 472.747, 9623, 'IVL_Modified_Shape'),
(202, 470.567, 9625, 'IVL_Modified_Shape'),
(203, 469.978, 9626, 'IVL_Modified_Shape'),
(204, 469.499, 9627, 'IVL_Modified_Shape'),
(205, 468.192, 9628, 'IVL_Modified_Shape'),
(206, 467.036, 9629, 'IVL_Modified_Shape'),
(207, 466.617, 9630, 'IVL_Modified_Shape'),
(208, 453.283, 9827, 'IVL_Modified_Shape'),
(209, 454.429, 9829, 'IVL_Modified_Shape'),
(210, 454.451, 9830, 'IVL_Modified_Shape'),
(211, 453.149, 9831, 'IVL_Modified_Shape'),
(212, 453.177, 9832, 'IVL_Modified_Shape'),
(213, 453.027, 9833, 'IVL_Modified_Shape'),
(214, 453.567, 9834, 'IVL_Modified_Shape'),
(215, 453.450, 9835, 'IVL_Modified_Shape'),
(216, 453.520, 9842, 'IVL_Modified_Shape'),
(217, 453.580, 9843, 'IVL_Modified_Shape'),
(218, 480.076, 10150, 'IVL_Modified_Shape'),
(219, 480.214, 10151, 'IVL_Modified_Shape'),
(220, 480.059, 10155, 'IVL_Modified_Shape'),
(221, 437.760, 10255, 'Not_In_IVL'),
(222, 443.962, 10256, 'IVL_Modified_Shape'),
(223, 445.321, 10257, 'IVL_Modified_Shape'),
(224, 441.293, 10265, 'Not_In_IVL'),
(225, 446.359, 10266, 'IVL_Modified_Shape'),
(226, 465.924, 10462, 'IVL_Modified_Location'),
(227, 465.536, 10463, 'IVL_Modified_Shape'),
(228, 465.490, 10464, 'IVL_Modified_Shape'),
(229, 465.270, 10465, 'IVL_Modified_Shape'),
(230, 464.614, 10466, 'IVL_Modified_Shape'),
(231, 464.240, 10467, 'IVL_Modified_Shape'),
(232, 464.000, 10468, 'IVL_Modified_Shape'),
(233, 463.968, 10469, 'IVL_Modified_Shape'),
(234, 463.815, 10470, 'IVL_Modified_Shape'),
(235, 463.965, 10471, 'IVL_Modified_Shape'),
(236, 463.266, 10472, 'IVL_Modified_Shape'),
(237, 463.849, 10475, 'IVL_Modified_Shape'),
(238, 464.054, 10476, 'IVL_Modified_Location'),
(239, 463.368, 10477, 'IVL_Modified_Shape'),
(240, 463.881, 10478, 'IVL_Modified_Shape'),
(241, 463.669, 10479, 'IVL_Modified_Shape'),
(242, 463.807, 10480, 'IVL_Modified_Location'),
(243, 463.342, 10481, 'IVL_Modified_Shape'),
(244, 463.629, 10482, 'IVL_Modified_Shape'),
(245, 463.889, 10483, 'IVL_Modified_Shape'),
(246, 463.598, 10484, 'IVL_Modified_Shape'),
(247, 463.801, 10485, 'IVL_Modified_Shape'),
(248, 464.600, 10486, 'IVL_Modified_Shape'),
(249, 464.590, 10488, 'IVL_Modified_Shape'),
(250, 464.594, 10490, 'IVL_Modified_Shape'),
(251, 464.455, 10491, 'IVL_Modified_Shape'),
(252, 464.439, 10492, 'IVL_Modified_Shape'),
(253, 464.591, 10493, 'IVL_Modified_Shape'),
(254, 464.593, 10494, 'IVL_Modified_Shape'),
(255, 464.438, 10495, 'IVL_Modified_Shape'),
(256, 464.600, 10496, 'IVL_Modified_Shape'),
(257, 464.359, 10497, 'IVL_Modified_Shape'),
(258, 464.610, 10498, 'IVL_Modified_Shape'),
(259, 463.284, 10500, 'IVL_Modified_Shape'),
(260, 464.063, 10501, 'IVL_Modified_Shape'),
(261, 463.936, 10502, 'IVL_Modified_Shape'),
(262, 462.968, 10503, 'Not_In_IVL'),
(263, 463.446, 10504, 'IVL_Modified_Shape'),
(264, 463.254, 10506, 'IVL_Modified_Shape'),
(265, 463.007, 10507, 'IVL_Modified_Shape'),
(266, 463.336, 10509, 'IVL_Modified_Shape'),
(267, 463.703, 10510, 'IVL_Modified_Shape');

-- --------------------------------------------------------

--
-- Table structure for table `hi_zu_checken`
--

CREATE TABLE `hi_zu_checken` (
  `en_id` int(11) NOT NULL,
  `ID` int(11) DEFAULT NULL,
  `Text` varchar(255) DEFAULT NULL,
  `Action` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `hi_zu_checken`
--

INSERT INTO `hi_zu_checken` (`en_id`, `ID`, `Text`, `Action`) VALUES
(1086, 9622, 'Verify the Shape', 'Not_In_IVL'),
(1087, 9624, 'Verify the Shape', 'Not Clear in Ortho'),
(1088, 9631, 'Verify the Shape', 'Not Clear in Ortho'),
(1089, 9632, 'Verify the Shape', 'Not Clear in Ortho'),
(1090, 9633, 'Verify Existence', 'Missing in Ortho'),
(1091, 9634, 'Verify Existence', 'Not_In_IVL'),
(1092, 9635, 'Verify Existence', 'Not_In_IVL'),
(1093, 9636, 'Verify Existence', 'Not_In_IVL'),
(1094, 9638, 'Element in the Ortho is not visible due to overhead structures', 'Obstructing features'),
(1095, 9656, 'Verify Existence', 'Not_In_IVL'),
(1096, 9657, 'Verify the Shape', 'Not_In_IVL'),
(1097, 9658, 'Verify Location and Shape', 'Not_In_IVL'),
(1098, 9659, 'Verify Location and Shape', 'Not_In_IVL'),
(1099, 9660, 'Verify Location and Shape', 'Not_In_IVL'),
(1100, 9661, 'Verify Existence', 'Missing in Ortho'),
(1101, 9664, 'Verify the Shape', 'Not_In_IVL'),
(1102, 9666, 'Verify the Shape', 'Not_In_IVL'),
(1103, 9674, 'Verify the Shape', 'Not_In_IVL'),
(1104, 9678, 'Verify the Shape', 'Not_In_IVL'),
(1105, 9680, 'Verify the Shape', 'Not_In_IVL'),
(1106, 9682, 'Verify the Shape', 'Not_In_IVL'),
(1107, 9685, 'Verify the Shape', 'Not_In_IVL'),
(1108, 9686, 'Verify the Shape', 'Not_In_IVL'),
(1109, 9689, 'Verify the Shape', 'Not_In_IVL'),
(1110, 9691, 'Verify Existence', 'Missing in Ortho'),
(1111, 9693, 'Verify the Shape', 'Not_In_IVL'),
(1112, 9695, 'Verify the Shape', 'Not_In_IVL'),
(1113, 9697, 'Verify the Shape', 'Not_In_IVL'),
(1114, 9803, 'Verify the Shape', 'Not_In_IVL'),
(1115, 9804, 'Verify Existence', 'Missing in Ortho'),
(1116, 9805, 'Verify Existence', 'Missing in Ortho'),
(1117, 9806, 'Verify Existence', 'Missing in Ortho'),
(1118, 9807, 'Verify Existence', 'Missing in Ortho'),
(1119, 9808, 'Verify Existence', 'Missing in Ortho'),
(1120, 9809, 'Verify Existence', 'Missing in Ortho'),
(1121, 9810, 'Verify Existence', 'Missing in Ortho'),
(1122, 9811, 'Verify Existence', 'Missing in Ortho'),
(1123, 9812, 'Verify Existence', 'Missing in Ortho'),
(1124, 9813, 'Verify the Shape', 'Not Clear in Ortho'),
(1125, 9814, 'Verify Existence', 'Missing in Ortho'),
(1126, 9815, 'Verify the Shape', 'Not Clear in Ortho'),
(1127, 9816, 'Verify the Shape', 'Not Clear in Ortho'),
(1128, 9817, 'Verify the Shape', 'Not Clear in Ortho'),
(1129, 9818, 'Verify the Shape', 'Not Clear in Ortho'),
(1130, 9819, 'Verify the Shape', 'Not Clear in Ortho'),
(1131, 9820, 'Verify the Shape', 'Not_In_IVL'),
(1132, 9821, 'Verify Existence', 'Missing in Ortho'),
(1133, 9822, 'Verify Existence', 'Missing in Ortho'),
(1134, 9823, 'Verify the Shape', 'Not Clear in Ortho'),
(1135, 9824, 'Verify the Shape', 'Not Clear in Ortho'),
(1136, 9825, 'Verify the Shape', 'Not Clear in Ortho'),
(1137, 9826, 'Verify the Shape', 'Not Clear in Ortho'),
(1138, 9828, 'Verify the Shape', 'Not Clear in Ortho'),
(1139, 9836, 'Verify Existence', 'Missing in Ortho'),
(1140, 9837, 'Element is the Ortho is not visible due to overhead structures', 'Invisible terrain'),
(1141, 9838, 'Element is the Ortho is not visible due to overhead structures', 'Invisible terrain'),
(1142, 9839, 'Element is the Ortho is not visible due to overhead structures', 'Invisible terrain'),
(1143, 9844, 'Verify Existence', 'Not Clear in Ortho'),
(1144, 9845, 'Verify Existence', 'Missing in Ortho'),
(1145, 9848, 'Verify Existence', 'Missing in Ortho'),
(1146, 9849, 'Verify Existence', 'Missing in Ortho'),
(1147, 9850, 'Verify Existence', 'Missing in Ortho'),
(1148, 9851, 'Verify Existence', 'Missing in Ortho'),
(1149, 9852, 'Verify Existence', 'Not_In_IVL'),
(1150, 9853, 'Verify Existence', 'Not_In_IVL'),
(1151, 9854, 'Verify the Shape', 'Not Clear in Ortho'),
(1152, 9855, 'Verify the Shape', 'Not Clear in Ortho'),
(1153, 9858, 'Verify Existence', 'Missing in Ortho'),
(1154, 9861, 'Verify Existence', 'Missing in Ortho'),
(1155, 9913, 'Verify the Shape', 'Not Clear in Ortho'),
(1156, 9914, 'Verify the Shape', 'Not Clear in Ortho'),
(1157, 9915, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1158, 9916, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1159, 9917, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1160, 9918, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1161, 9919, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1162, 9920, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1163, 9921, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1164, 9922, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1165, 9923, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1166, 9924, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1167, 9925, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1168, 9926, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1169, 9927, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1170, 9928, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1171, 9929, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1172, 9932, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1173, 9933, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1174, 9936, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1175, 9937, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1176, 9945, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1177, 9948, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1178, 9949, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1179, 9950, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1180, 9953, 'Verify the Shape', 'Not Clear in Ortho'),
(1181, 10152, 'Verify the Shape', 'Not Clear in Ortho'),
(1182, 10153, 'Verify the Shape', 'Not Clear in Ortho'),
(1183, 10154, 'Verify the Shape', 'Not Clear in Ortho'),
(1184, 10156, 'Verify the Shape', 'Not Clear in Ortho'),
(1185, 10157, 'Verify the Shape', 'Not Clear in Ortho'),
(1186, 10158, 'Verify the Shape', 'Not Clear in Ortho'),
(1187, 10159, 'Verify the Shape', 'Not Clear in Ortho'),
(1188, 10160, 'Verify the Shape', 'Not Clear in Ortho'),
(1189, 10161, 'Verify the Shape', 'Not Clear in Ortho'),
(1190, 10162, 'Verify the Shape', 'Not Clear in Ortho'),
(1191, 10163, 'Verify the Shape', 'Not Clear in Ortho'),
(1192, 10164, 'Verify the Shape', 'Not Clear in Ortho'),
(1193, 10165, 'Verify the Shape', 'Not Clear in Ortho'),
(1194, 10166, 'Verify the Shape', 'Not Clear in Ortho'),
(1195, 10167, 'Verify the Shape', 'Not Clear in Ortho'),
(1196, 10168, 'Verify the Shape', 'Not Clear in Ortho'),
(1197, 10169, 'Verify the Shape', 'Not Clear in Ortho'),
(1198, 10170, 'Verify the Shape', 'Not Clear in Ortho'),
(1199, 10171, 'Verify Existence', 'Missing in Ortho'),
(1200, 10172, 'Element in the Ortho is not visible due to overhead structure', 'Obstructing features'),
(1201, 10177, 'Verify Existence', 'Not_In_IVL '),
(1202, 10178, 'Verify the Shape', 'Not_In_IVL'),
(1203, 10180, 'Verify the Shape', 'Not_In_IVL'),
(1204, 10181, 'Verify Existence', 'Missing in Ortho'),
(1205, 10182, 'Verify the Shape', 'Not_In_IVL'),
(1206, 10184, 'Verify Location and Shape', 'Not_In_IVL'),
(1207, 10185, 'Verify the Shape', 'Not_In_IVL'),
(1208, 10186, 'Verify the Shape', 'Not Clear in Ortho'),
(1209, 10187, 'Verify the Shape', 'Not Clear in Ortho'),
(1210, 10258, 'Verify the Shape', 'Not Clear in Ortho'),
(1211, 10259, 'Verify the Shape', 'Not Clear in Ortho'),
(1212, 10260, 'Verify the Shape', 'Not Clear in Ortho'),
(1213, 10261, 'Verify the Shape', 'Not Clear in Ortho'),
(1214, 10262, 'Verify the Shape', 'Not Clear in Ortho'),
(1215, 10263, 'Verify the Shape', 'Not Clear in Ortho'),
(1216, 10264, 'Verify the Shape', 'Not Clear in Ortho'),
(1217, 10267, 'Verify Existence', 'Missing in Ortho'),
(1218, 10268, 'Verify Existence', 'Missing in Ortho'),
(1219, 10269, 'Verify Existence', 'Missing in Ortho'),
(1220, 10270, 'Verify Existence', 'Missing in Ortho'),
(1221, 10271, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1222, 10275, 'Verify the Shape', 'Not_In_IVL'),
(1223, 10276, 'Verify the Shape', 'Not_In_IVL'),
(1224, 10297, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1225, 10298, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1226, 10299, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1227, 10311, 'Not Clear in Ortho', 'Verify Location and Shape'),
(1228, 10312, 'Verify Existence', 'Not_In_IVL'),
(1229, 10459, 'Verify Existence', 'Not Clear in Ortho'),
(1230, 10460, 'Verify Existence', 'Not Clear in Ortho'),
(1231, 10461, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1232, 10473, 'Verify Existence', 'Missing in Ortho'),
(1233, 10474, 'Verify Existence', 'Not Clear in Ortho'),
(1234, 10487, 'Verify the Shape', 'Not Clear in Ortho'),
(1235, 10489, 'Verify the Shape', 'Not_In_IVL'),
(1236, 10499, 'Verify the Shape', 'Not Clear in Ortho'),
(1237, 10505, 'Verify the Shape', 'Not Clear in Ortho'),
(1238, 10508, 'Verify the Shape', 'Not Clear in Ortho'),
(1239, 10511, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1240, 10512, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1241, 10519, 'Verify Existence', 'Missing in Ortho'),
(1242, 10520, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1243, 10523, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1244, 10524, 'Verify Existence', 'Missing in Ortho'),
(1245, 10525, 'Verify Existence', 'Missing in Ortho'),
(1246, 10526, 'Verify Existence', 'Missing in Ortho'),
(1247, 10527, 'Verify Existence', 'Missing in Ortho'),
(1248, 10528, 'Verify the Shape', 'Not_In_IVL'),
(1249, 10529, 'Verify Existence', 'Missing in Ortho'),
(1250, 10532, 'Verify Existence', 'Not_In_IVL'),
(1251, 10536, 'Verify the Shape', 'Not Clear in Ortho'),
(1252, 10546, 'Verify Existence', 'Missing in Ortho'),
(1253, 10548, 'Element in the Ortho is not visible due to overhead structure', 'Obstructing features'),
(1254, 10550, 'Verify the Shape', 'Not Clear in Ortho'),
(1255, 10551, 'Verify the Shape', 'Not Clear in Ortho'),
(1256, 10557, 'Verify the Shape', 'Not Clear in Ortho'),
(1257, 10558, 'Verify the Shape', 'Not Clear in Ortho'),
(1258, 10561, 'Verify the Shape', 'Not Clear in Ortho'),
(1259, 10563, 'Verify the Shape', 'Not Clear in Ortho'),
(1260, 10568, 'Verify the Shape', 'Not Clear in Ortho'),
(1261, 10581, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1262, 10582, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1263, 10583, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1264, 10584, 'Element in the Ortho is not visible due to overhead structure', 'Obstructing features'),
(1265, 10585, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1266, 10586, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1267, 10587, 'Verify the Shape', 'Not Clear in Ortho'),
(1268, 10588, 'Element in the Ortho is not visible due to overhead structure', 'Obstructing features'),
(1269, 10589, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1270, 10590, 'Element in the Ortho is not visible due to overhead structure', 'Invisible terrain'),
(1271, 10591, 'Verify Existence', 'Missing in Ortho'),
(1272, 10592, 'Verify Existence', 'Missing in Ortho'),
(1273, 10593, 'Verify Existence', 'Missing in Ortho'),
(1274, 10594, 'Verify Existence', 'Missing in Ortho'),
(1275, 10595, 'Verify Existence', 'Missing in Ortho'),
(1276, 10596, 'Verify Existence', 'Missing in Ortho'),
(1277, 10597, 'Verify Existence', 'Missing in Ortho'),
(1278, 10600, 'Verify Existence', 'Missing in Ortho'),
(1279, 10601, 'Verify the Shape', 'Not_In_IVL'),
(1280, 10602, 'Verify Existence', 'Missing in Ortho'),
(1281, 10625, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1282, 10626, 'Verify the Shape', 'Not Clear in Ortho'),
(1283, 10627, 'Verify Location and Shape', 'Not_In_IVL'),
(1284, 10628, 'Verify Existence', 'Missing in Ortho'),
(1285, 10629, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1286, 10630, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1287, 10631, 'Verify the Shape', 'Not_In_IVL'),
(1288, 10632, 'Verify the Shape', 'Not_In_IVL'),
(1289, 10633, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1290, 10634, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1291, 10635, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1292, 10636, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1293, 10637, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1294, 10638, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1295, 10639, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1296, 10640, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1297, 10641, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1298, 10642, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1299, 10643, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1300, 10644, 'Only in Kable Plan', 'Found only in KabelPlan'),
(1301, 10645, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1302, 10646, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1303, 10651, 'Verify Existence', 'Missing in Ortho'),
(1304, 10654, 'Verify Existence', 'Missing in Ortho'),
(1305, 10655, 'Verify the Shape', 'Not_In_IVL'),
(1306, 10658, 'Verify Existence', 'Missing in Ortho'),
(1307, 10659, 'Verify the Shape', 'Not Clear in Ortho'),
(1308, 10660, 'Verify Existence', 'Missing in Ortho'),
(1309, 10661, 'Verify Existence', 'Missing in Ortho'),
(1310, 10953, 'Verify Existence', 'Missing in Ortho'),
(1311, 10954, 'Verify Location and Shape', 'Not Clear in Ortho'),
(1312, 10955, 'Verify Existence', 'Missing in Ortho'),
(1313, 10956, 'Verify the Shape', 'Not_In_IVL'),
(1314, 10968, 'Verify the Shape', 'Not_In_IVL'),
(1315, 10975, 'Verify Location and Shape', 'Not_In_IVL'),
(1316, 10976, 'Verify Location and Shape', 'Not_In_IVL'),
(1317, 10977, 'Verify Location and Shape', 'Not_In_IVL');

-- --------------------------------------------------------

--
-- Table structure for table `od_abw-bauwerk`
--

CREATE TABLE `od_abw-bauwerk` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `lichte_länge` decimal(10,3) DEFAULT NULL,
  `lichte_breite` decimal(10,3) DEFAULT NULL,
  `tiefe_ab_okd` decimal(10,3) DEFAULT NULL,
  `d_stärke` decimal(10,3) DEFAULT NULL,
  `wandstärke` decimal(10,3) DEFAULT NULL,
  `zustand` varchar(255) DEFAULT NULL,
  `verschmutzungsgrad` varchar(255) DEFAULT NULL,
  `verschmutzungsart` varchar(255) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_abw-deckel`
--

CREATE TABLE `od_abw-deckel` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `deckel_innen_aufliegend` varchar(255) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `länge` decimal(10,3) DEFAULT NULL,
  `breite` decimal(10,3) DEFAULT NULL,
  `d_stärke` decimal(10,3) DEFAULT NULL,
  `zustand_deckel` varchar(255) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `od_abw-deckel`
--

INSERT INTO `od_abw-deckel` (`code`, `id`, `punktnummer`, `ostwert`, `nord`, `höhe`, `deckel_innen_aufliegend`, `material`, `länge`, `breite`, `d_stärke`, `zustand_deckel`, `objektstatus`, `bemerkung1`, `bemerkung2`, `date`, `time`, `benutzer_der_aufnahme`, `ivl_name`, `aktiv`, `dwg_objekt`, `workorder_id`, `parent_id`, `created_at`, `updated_at`) VALUES
('abw-deckel', 1, 'pt6', '3487454.509', '5375573.611', '0.000', 'innenliegend', 'beton', '870.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '10:29:00', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 2, 'pt34', '3487484.396', '5375444.334', '0.000', 'innenliegend', 'beton', '650.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '10:45:59', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 3, 'pt34-k', '3487484.430', '5375444.351', '468.516', 'innenliegend', 'beton', '50.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '10:46:31', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 4, 'pt62', '3487385.855', '5374963.255', '0.000', 'innenliegend', 'beton', '680.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '10:59:12', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 5, 'pt72', '3487400.445', '5374997.859', '0.000', 'innenliegend', 'beton', '680.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:04:29', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 6, 'pt72-k', '3487400.438', '5374997.906', '472.278', 'innenliegend', 'beton', '50.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:04:44', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 7, 'pt82', '3487426.407', '5375069.206', '0.000', 'innenliegend', 'beton', '800.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:08:04', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 8, 'pt82-k', '3487426.475', '5375069.176', '471.518', 'innenliegend', 'beton', '50.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:08:13', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 9, 'pt88', '3487444.173', '5375131.553', '0.000', 'innenliegend', 'beton', '680.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:11:15', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 10, 'pt88-k', '3487444.204', '5375131.537', '470.939', 'innenliegend', 'beton', '680.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:12:01', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 11, 'pt98', '3487456.149', '5375184.921', '0.000', 'innenliegend', 'beton', '680.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:20:36', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 12, 'pt98-k', '3487456.197', '5375184.862', '470.545', 'innenliegend', 'beton', '50.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:21:16', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 13, 'pt104', '3487457.482', '5375186.161', '0.000', 'innenliegend', 'beton', '860.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:21:38', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 14, 'pt110', '3487467.475', '5375251.101', '0.000', 'innenliegend', 'beton', '680.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:23:07', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 15, 'pt120', '3487470.333', '5375285.123', '0.000', 'innenliegend', 'beton', '680.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:23:55', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 16, 'pt128', '3487473.691', '5375391.503', '0.000', 'innenliegend', 'beton', '680.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:26:59', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 17, 'pt134', '3487471.286', '5375442.333', '0.000', 'innenliegend', 'beton', '870.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:28:51', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 18, 'pt134-k', '3487471.346', '5375442.294', '467.621', 'innenliegend', 'beton', '50.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:29:44', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 19, 'pt140', '3487464.038', '5375511.297', '0.000', 'innenliegend', 'beton', '870.000', '0.000', '0.000', 'i.o.', 'bestand', '', '', '2024-04-08', '11:31:17', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 20, 'pt62-k', '3487385.885', '5374963.250', '472.704', '', '', '0.000', '0.000', '0.000', '', '', '', '', '2024-04-10', '12:29:52', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('abw-deckel', 21, 'pt28', '3492227.294', '5387229.015', '0.000', 'innenliegend', 'beton', '800.000', '0.000', '0.000', 'i.o.', '', '', '', '2024-03-06', '10:46:52', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('abw-deckel', 22, 'pt28-k', '3492227.306', '5387229.170', '460.130', 'innenliegend', 'beton', '800.000', '0.000', '0.000', 'i.o.', '', '', '', '2024-04-05', '09:06:37', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `od_deckel-höhenpunkt`
--

CREATE TABLE `od_deckel-höhenpunkt` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_ela-bauwerk`
--

CREATE TABLE `od_ela-bauwerk` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `lichte_länge` decimal(10,3) DEFAULT NULL,
  `lichte_breite` decimal(10,3) DEFAULT NULL,
  `okd_bis_sohle` decimal(10,3) DEFAULT NULL,
  `okd_bis_uk_s_decke` decimal(10,3) DEFAULT NULL,
  `deckenstärke` decimal(10,3) DEFAULT NULL,
  `zustand` varchar(255) DEFAULT NULL,
  `verschmutzungsgrad` varchar(255) DEFAULT NULL,
  `verschmutzungsart` varchar(255) DEFAULT NULL,
  `wandstärke` decimal(10,3) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `od_ela-bauwerk`
--

INSERT INTO `od_ela-bauwerk` (`code`, `id`, `punktnummer`, `ostwert`, `nord`, `höhe`, `material`, `lichte_länge`, `lichte_breite`, `okd_bis_sohle`, `okd_bis_uk_s_decke`, `deckenstärke`, `zustand`, `verschmutzungsgrad`, `verschmutzungsart`, `wandstärke`, `objektstatus`, `bemerkung1`, `bemerkung2`, `date`, `time`, `benutzer_der_aufnahme`, `ivl_name`, `aktiv`, `dwg_objekt`, `workorder_id`, `parent_id`, `created_at`, `updated_at`) VALUES
('ela-bauwerk', 1, 'pt15', '3487464.303', '5375552.774', '0.000', 'beton', '660.000', '400.000', '320.000', '200.000', '200.000', 'i.o.', 'leicht', 'dreck', '0.000', 'bestand', '', '', '2024-04-08', '10:36:52', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('ela-bauwerk', 2, 'pt15', '3492241.314', '5387231.006', '0.000', 'beton', '1450.000', '1200.000', '1750.000', '240.000', '190.000', 'i.o.', 'mittel', 'dreck, schotter', '0.000', 'bestand', '', '', '2024-03-06', '10:33:15', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `od_ela-bw-wand`
--

CREATE TABLE `od_ela-bw-wand` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `gleisquerung` varchar(255) DEFAULT NULL,
  `1_aussparung_breite` decimal(10,3) DEFAULT NULL,
  `1_aussparung_höhe` decimal(10,3) DEFAULT NULL,
  `1_ausspar_tiefe_v_uksd` decimal(10,3) DEFAULT NULL,
  `_1_gesamt_rohre` int(11) DEFAULT NULL,
  `1_freie_rohre` int(11) DEFAULT NULL,
  `1_uksd_bis_okr` decimal(10,3) DEFAULT NULL,
  `1_durchmesser_rohr` decimal(10,3) DEFAULT NULL,
  `1_durchgänige_rohre` int(11) DEFAULT NULL,
  `2_aussparung_breite` decimal(10,3) DEFAULT NULL,
  `2_aussparung_höhe` decimal(10,3) DEFAULT NULL,
  `2_ausspar_tiefe_v_uskd` decimal(10,3) DEFAULT NULL,
  `_2_gesamt_rohre` int(11) DEFAULT NULL,
  `2_freie_rohre` int(11) DEFAULT NULL,
  `2_uksd_bis_okr` decimal(10,3) DEFAULT NULL,
  `2_durchmesser_rohr` decimal(10,3) DEFAULT NULL,
  `2_durchgänige_rohre` int(11) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `schachtbauwerkid` int(11) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `od_ela-bw-wand`
--

INSERT INTO `od_ela-bw-wand` (`code`, `id`, `punktnummer`, `ostwert`, `nord`, `höhe`, `gleisquerung`, `1_aussparung_breite`, `1_aussparung_höhe`, `1_ausspar_tiefe_v_uksd`, `_1_gesamt_rohre`, `1_freie_rohre`, `1_uksd_bis_okr`, `1_durchmesser_rohr`, `1_durchgänige_rohre`, `2_aussparung_breite`, `2_aussparung_höhe`, `2_ausspar_tiefe_v_uskd`, `_2_gesamt_rohre`, `2_freie_rohre`, `2_uksd_bis_okr`, `2_durchmesser_rohr`, `2_durchgänige_rohre`, `objektstatus`, `bemerkung1`, `bemerkung2`, `date`, `time`, `benutzer_der_aufnahme`, `ivl_name`, `aktiv`, `dwg_objekt`, `schachtbauwerkid`, `workorder_id`, `parent_id`, `created_at`, `updated_at`) VALUES
('ela-bw-wand', 1, 'pt14', '3487464.004', '5375552.747', '0.000', 'nein', '0.000', '0.000', '0.000', 1, 0, '190.000', '100.000', 0, '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, 'bestand', '', '', '2024-04-08', '10:36:52', NULL, NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('ela-bw-wand', 2, 'pt16', '3487464.342', '5375552.351', '0.000', 'nein', '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, 'bestand', '', '', '2024-04-08', '10:36:52', NULL, NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('ela-bw-wand', 3, 'pt18', '3487464.081', '5375551.900', '0.000', 'nein', '0.000', '0.000', '0.000', 2, 0, '190.000', '100.000', 0, '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, 'bestand', '', '', '2024-04-08', '10:36:52', NULL, NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('ela-bw-wand', 4, 'pt20', '3487463.744', '5375552.296', '0.000', 'nein', '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, 'bestand', '', '', '2024-04-08', '10:36:52', NULL, NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('ela-bw-wand', 5, 'pt16', '3492241.847', '5387231.603', '0.000', 'nein', '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, 'bestand', '', '', '2024-03-06', '10:33:15', NULL, NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('ela-bw-wand', 6, 'pt18', '3492242.902', '5387231.733', '0.000', 'nein', '600.000', '600.000', '150.000', 0, 0, '0.000', '0.000', 0, '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, '', '', '', '2024-03-06', '10:33:15', NULL, NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('ela-bw-wand', 7, 'pt20', '3492242.891', '5387230.670', '0.000', 'nein', '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, 'bestand', '', '', '2024-03-06', '10:33:15', NULL, NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('ela-bw-wand', 8, 'pt22', '3492241.836', '5387230.540', '0.000', 'nein', '600.000', '600.000', '150.000', 0, 0, '0.000', '0.000', 0, '0.000', '0.000', '0.000', 0, 0, '0.000', '0.000', 0, '', '', '', '2024-03-06', '10:33:15', NULL, NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `od_ela-deckel`
--

CREATE TABLE `od_ela-deckel` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `zu_öffnen` varchar(255) DEFAULT NULL,
  `deckel_innen_aufliegend` varchar(255) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `länge` decimal(10,3) DEFAULT NULL,
  `breite` decimal(10,3) DEFAULT NULL,
  `d_stärke` decimal(10,3) DEFAULT NULL,
  `zustand` varchar(255) DEFAULT NULL,
  `li_abst_zu_wand_in_km_ri` decimal(10,3) DEFAULT NULL,
  `li_abst_zu_wand_2` decimal(10,3) DEFAULT NULL,
  `li_abst_zu_wand_3` decimal(10,3) DEFAULT NULL,
  `li_abst_zu_wand_4` decimal(10,3) DEFAULT NULL,
  `li_länge_einstieg` decimal(10,3) DEFAULT NULL,
  `li_breite_einstieg` decimal(10,3) DEFAULT NULL,
  `okd_bis_uk_sd` decimal(10,3) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `schachtbauwerk_id` int(11) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `od_ela-deckel`
--

INSERT INTO `od_ela-deckel` (`code`, `id`, `punktnummer`, `ostwert`, `nord`, `höhe`, `zu_öffnen`, `deckel_innen_aufliegend`, `material`, `länge`, `breite`, `d_stärke`, `zustand`, `li_abst_zu_wand_in_km_ri`, `li_abst_zu_wand_2`, `li_abst_zu_wand_3`, `li_abst_zu_wand_4`, `li_länge_einstieg`, `li_breite_einstieg`, `okd_bis_uk_sd`, `objektstatus`, `bemerkung1`, `bemerkung2`, `date`, `time`, `benutzer_der_aufnahme`, `ivl_name`, `schachtbauwerk_id`, `aktiv`, `dwg_objekt`, `workorder_id`, `parent_id`, `created_at`, `updated_at`) VALUES
('ela-deckel', 1, 'pt17', '3487464.380', '5375551.927', '0.000', 'ja', 'innenliegend', 'beton', '760.000', '500.000', '90.000', 'i.o.', '0.000', '0.000', '0.000', '0.000', '660.000', '400.000', '200.000', 'bestand', '', '', '2024-04-08', '10:36:52', NULL, NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('ela-deckel', 2, 'pt21', '3492242.358', '5387230.073', '0.000', 'ja', 'innenliegend', 'beton', '1530.000', '820.000', '50.000', 'i.o.', '20.000', '430.000', '40.000', '90.000', '1390.000', '690.000', '240.000', 'bestand', '', '', '2024-03-06', '10:33:15', NULL, NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `od_entfällt`
--

CREATE TABLE `od_entfällt` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `grund_des_löschens` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `od_entfällt`
--

INSERT INTO `od_entfällt` (`code`, `id`, `punktnummer`, `ostwert`, `nord`, `höhe`, `grund_des_löschens`, `bemerkung1`, `bemerkung2`, `aktiv`, `dwg_objekt`, `workorder_id`, `parent_id`, `created_at`, `updated_at`) VALUES
('entfällt', 1, 'pt12', '3487463.617', '5375557.568', '0.000', 'nicht sichtbar', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 2, 'pt22', '3487470.683', '5375550.538', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 3, 'pt28', '3487474.569', '5375536.680', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 4, 'pt37', '3487481.142', '5375269.103', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 5, 'pt40', '3487480.508', '5375265.973', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 6, 'pt45', '3487478.293', '5375245.583', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 7, 'pt48', '3487476.719', '5375240.436', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 8, 'pt51', '3487473.374', '5375219.715', '0.000', 'nicht vorhanden', '', 'mauer und geländer', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 9, 'pt55', '3487405.700', '5374978.306', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 10, 'pt113', '3487470.590', '5375269.921', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 11, 'pt141', '3487458.019', '5375559.253', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 12, 'pt22-k', '3487470.619', '5375550.388', '467.111', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 13, 'pt141-k', '3487457.942', '5375559.149', '466.644', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 14, 'pt113-k', '3487470.509', '5375269.728', '469.777', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 15, 'pt55-k', '3487403.767', '5374976.918', '472.679', 'nicht sichtbar', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 16, 'pt51-k', '3487473.369', '5375220.302', '470.118', 'nicht sichtbar', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 17, 'pt48-k', '3487476.274', '5375240.307', '469.570', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 18, 'pt45-k', '3487477.370', '5375246.507', '469.939', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 19, 'pt37-k', '3487480.879', '5375268.970', '469.808', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 20, 'pt40-k', '3487480.342', '5375265.847', '469.640', 'nicht vorhanden', '', '', NULL, NULL, 44, NULL, NULL, NULL),
('entfällt', 21, 'pt6', '3492407.371', '5387481.631', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 53, NULL, NULL, NULL),
('entfällt', 22, 'pt30', '3492335.962', '5387369.633', '0.000', 'nicht vorhanden', '', '', NULL, NULL, 53, NULL, NULL, NULL),
('entfällt', 23, 'pt8-k', '3492398.879', '5387467.539', '459.499', 'nicht vorhanden', '', '', NULL, NULL, 53, NULL, NULL, NULL),
('entfällt', 24, 'pt30-k', '3492335.925', '5387370.197', '459.589', 'nicht vorhanden', '', '', NULL, NULL, 53, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `od_gas-schieber-deckel`
--

CREATE TABLE `od_gas-schieber-deckel` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `deckel_innen_aufliegend` varchar(255) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `länge` decimal(10,3) DEFAULT NULL,
  `breite` decimal(10,3) DEFAULT NULL,
  `d_stärke` decimal(10,3) DEFAULT NULL,
  `zustand_deckel` varchar(255) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_grenzbolzen`
--

CREATE TABLE `od_grenzbolzen` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_grenzstein`
--

CREATE TABLE `od_grenzstein` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_hoehenfestpunkt`
--

CREATE TABLE `od_hoehenfestpunkt` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_kabelschutzrohr`
--

CREATE TABLE `od_kabelschutzrohr` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `durchmesser` int(11) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzerderaufnahme` varchar(255) DEFAULT NULL,
  `ivlname` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_kabel_freiliegend`
--

CREATE TABLE `od_kabel_freiliegend` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `durchmesser` int(11) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_nagel_sonst_pkt`
--

CREATE TABLE `od_nagel_sonst_pkt` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_schaden`
--

CREATE TABLE `od_schaden` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `schadensart` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_sonstiger_punkt`
--

CREATE TABLE `od_sonstiger_punkt` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `od_sonstiger_punkt`
--

INSERT INTO `od_sonstiger_punkt` (`code`, `id`, `punktnummer`, `ostwert`, `nord`, `höhe`, `bemerkung1`, `bemerkung2`, `aktiv`, `dwg_objekt`, `workorder_id`, `parent_id`, `created_at`, `updated_at`) VALUES
('sonstiger_punkt', 1, 'pt39', '3492245.541', '5387228.106', '0.000', 'schaltschrank', '', NULL, NULL, 53, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `od_trog-bauwerk`
--

CREATE TABLE `od_trog-bauwerk` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `breite_gesamt` decimal(10,3) DEFAULT NULL,
  `lichte_breite` decimal(10,3) DEFAULT NULL,
  `lichte_tiefe` decimal(10,3) DEFAULT NULL,
  `ok_kabel` decimal(10,3) DEFAULT NULL,
  `d_stärke` decimal(10,3) DEFAULT NULL,
  `wandstärke` decimal(10,3) DEFAULT NULL,
  `deckel_innen_aufliegend` varchar(255) DEFAULT NULL,
  `zustand_deckel` varchar(255) DEFAULT NULL,
  `verschmutzungsgrad` varchar(255) DEFAULT NULL,
  `verschmutzungsart` varchar(255) DEFAULT NULL,
  `trennsteg_vorhanden` varchar(255) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `od_trog-bauwerk`
--

INSERT INTO `od_trog-bauwerk` (`code`, `id`, `punktnummer`, `ostwert`, `nord`, `höhe`, `material`, `breite_gesamt`, `lichte_breite`, `lichte_tiefe`, `ok_kabel`, `d_stärke`, `wandstärke`, `deckel_innen_aufliegend`, `zustand_deckel`, `verschmutzungsgrad`, `verschmutzungsart`, `trennsteg_vorhanden`, `objektstatus`, `bemerkung1`, `bemerkung2`, `date`, `time`, `benutzer_der_aufnahme`, `ivl_name`, `aktiv`, `dwg_objekt`, `workorder_id`, `parent_id`, `created_at`, `updated_at`) VALUES
('trog-bauwerk', 1, 'pt7', '3487455.669', '5375572.084', '0.000', 'beton', '220.000', '110.000', '100.000', '70.000', '60.000', '50.000', 'innenliegend', 'i.o.', 'leicht', 'dreck', 'nein', 'bestand', '', '', '2024-04-08', '10:30:08', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 2, 'pt10', '3487452.598', '5375573.643', '0.000', 'beton', '300.000', '200.000', '140.000', '130.000', '60.000', '50.000', 'innenliegend', 'i.o.', 'leicht', 'dreck', 'nein', 'bestand', '', '', '2024-04-08', '10:32:24', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 3, 'pt64', '3487369.424', '5374928.943', '0.000', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:00:47', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 4, 'pt66', '3487397.754', '5374995.210', '0.000', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:02:21', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 5, 'pt65', '3487396.216', '5374991.510', '0.000', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:02:21', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 6, 'pt73', '3487410.179', '5375026.910', '0.000', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:05:34', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 7, 'pt73-k', '3487410.029', '5375026.423', '472.833', 'beton', '50.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'i.o.', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:06:18', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 8, 'pt76', '3487414.625', '5375039.015', '0.000', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:06:28', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 9, 'pt76-k', '3487412.106', '5375032.068', '472.775', 'beton', '50.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'i.o.', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:07:19', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 10, 'pt89', '3487444.940', '5375133.331', '0.000', 'beton', '220.000', '110.000', '170.000', '150.000', '50.000', '50.000', 'innenliegend', 'i.o.', 'leicht', 'dreck', 'nein', 'bestand', 'anfang beton ende gfk', '', '2024-04-08', '11:12:27', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 11, 'pt91', '3487446.353', '5375146.671', '0.000', 'gfk', '140.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:17:17', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 12, 'pt91-k', '3487446.383', '5375146.721', '471.507', 'beton', '50.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'i.o.', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:19:00', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 13, 'pt122', '3487472.674', '5375348.693', '0.000', 'gfk', '140.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:25:11', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 14, 'pt122-k', '3487472.710', '5375349.757', '469.470', 'beton', '50.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'i.o.', '', '', 'nein', 'bestand', '', '', '2024-04-08', '11:26:29', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 15, 'pt146', '3487457.057', '5375564.388', '0.000', 'beton', '220.000', '110.000', '100.000', '70.000', '60.000', '50.000', 'innenliegend', 'i.o.', 'mittel', 'dreck', 'nein', 'bestand', '', '', '2024-04-08', '11:33:04', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 16, 'gs0001', '3487452.129', '5375576.647', '467.434', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '11:54:49', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 17, 'gs0002', '3487458.231', '5375538.200', '467.662', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '11:59:02', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 18, 'gs0003', '3487469.367', '5375443.141', '468.452', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:01:37', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 19, 'gs0004', '3487470.560', '5375425.237', '468.634', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:02:31', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 20, 'gs0005', '3487471.547', '5375419.413', '468.347', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:02:55', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 21, 'gs0006', '3487472.929', '5375372.452', '468.801', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:07:44', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 22, 'gs0007', '3487472.281', '5375367.113', '469.548', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:08:14', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 23, 'gs0008', '3487472.110', '5375361.879', '469.589', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:08:41', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 24, 'gs0009', '3487472.844', '5375356.656', '469.389', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:09:04', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 25, 'gs0010', '3487471.020', '5375307.850', '469.931', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:10:01', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 26, 'gs0011', '3487463.900', '5375236.783', '470.854', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:13:04', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 27, 'gs0012', '3487454.777', '5375184.806', '471.120', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:15:12', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 28, 'gs0013', '3487446.888', '5375141.065', '470.725', 'beton', '220.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'i.o.', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:16:39', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 29, 'gs0014', '3487423.147', '5375063.698', '472.403', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:18:59', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 30, 'pt63-k', '3487376.005', '5374946.351', '473.308', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', '', '', '', '2024-04-10', '12:31:17', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 31, 'pt64-k', '3487375.219', '5374940.736', '472.987', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', '', '', '', '2024-04-10', '12:32:13', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 32, 'pt65-k', '3487353.744', '5374898.951', '473.395', 'beton', '50.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'i.o.', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:33:39', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 33, 'pt66-k', '3487336.636', '5374868.593', '473.673', 'beton', '50.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'i.o.', '', '', 'nein', 'bestand', '', '', '2024-04-10', '12:34:22', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 34, 'pt67-k', '3487336.508', '5374865.910', '473.749', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag öffnen', '', '', 'nein', '', '', '', '2024-04-10', '12:34:40', NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL),
('trog-bauwerk', 35, 'pt8', '3492398.793', '5387467.441', '0.000', 'beton', '500.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'ag freiräumen', '', '', 'nein', 'bestand', '', '', '2024-03-04', '11:19:45', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 36, 'pt9', '3492252.185', '5387257.351', '0.000', 'beton', '500.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'innenliegend', 'ag freiräumen', '', '', 'nein', 'bestand', '', '', '2024-03-04', '11:25:35', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 37, 'pt12', '3492241.175', '5387229.785', '0.000', 'gfk', '120.000', '110.000', '160.000', '140.000', '4.000', '4.000', 'aufliegend', 'ag öffnen', 'leicht', '', 'nein', 'bestand', '', '', '2024-03-04', '11:27:15', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 38, 'pt14', '3492355.253', '5387381.104', '0.000', 'gfk', '120.000', '110.000', '160.000', '140.000', '4.000', '4.000', 'aufliegend', 'ag öffnen', 'leicht', '', 'nein', 'bestand', '', '', '2024-03-04', '11:33:50', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 39, 'gs0001', '3492392.524', '5387457.193', '459.562', 'beton', '500.000', '0.000', '0.000', '0.000', '0.000', '4.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:13:52', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 40, 'gs0002', '3492407.503', '5387481.438', '459.524', 'beton', '500.000', '0.000', '0.000', '0.000', '0.000', '4.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:14:56', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 41, 'gs0003', '3492418.969', '5387480.528', '459.662', 'beton', '400.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:15:58', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 42, 'gs0004', '3492417.117', '5387476.312', '459.671', 'beton', '1000.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:17:02', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 43, 'gs0005', '3492415.654', '5387474.052', '459.675', 'beton', '1000.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:17:19', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 44, 'gs0006', '3492407.630', '5387462.651', '459.782', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:17:42', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 45, 'gs0007', '3492406.016', '5387460.150', '460.018', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:18:40', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 46, 'gs0008', '3492403.246', '5387454.989', '460.003', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:18:49', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 47, 'gs0009', '3492398.397', '5387447.238', '460.052', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:19:02', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 48, 'gs0010', '3492397.145', '5387445.598', '460.021', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:19:08', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 49, 'gs0011', '3492395.022', '5387441.834', '460.079', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:19:18', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 50, 'gs0012', '3492382.363', '5387421.640', '460.077', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:19:46', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 51, 'gs0013', '3492360.594', '5387388.027', '460.103', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:20:25', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 52, 'gs0014', '3492356.826', '5387383.516', '460.083', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:20:36', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 53, 'gs0015', '3492355.261', '5387381.119', '459.852', 'gfk', '180.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:20:56', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 54, 'gs0016', '3492241.169', '5387229.724', '460.239', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:26:28', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 55, 'gs0017', '3492237.884', '5387226.259', '460.709', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:28:13', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL),
('trog-bauwerk', 56, 'gs0018', '3492215.807', '5387201.141', '460.678', 'gfk', '120.000', '0.000', '0.000', '0.000', '0.000', '0.000', 'aufliegend', 'i.o.', '', '', 'ja', 'bestand', '', '', '2024-04-05', '09:29:00', NULL, NULL, NULL, NULL, 53, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `od_unbekannter-deckel`
--

CREATE TABLE `od_unbekannter-deckel` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `deckel_innen_aufliegend` varchar(255) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `länge` decimal(10,3) DEFAULT NULL,
  `breite` decimal(10,3) DEFAULT NULL,
  `d-stärke` decimal(10,3) DEFAULT NULL,
  `zustanddeckel` varchar(255) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_vermes_pkt_rmk`
--

CREATE TABLE `od_vermes_pkt_rmk` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_was-bauwerk`
--

CREATE TABLE `od_was-bauwerk` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `lichte_länge` decimal(10,3) DEFAULT NULL,
  `lichte_breite` decimal(10,3) DEFAULT NULL,
  `tiefe_ab_okd` decimal(10,3) DEFAULT NULL,
  `d_stärke` decimal(10,3) DEFAULT NULL,
  `wandstärke` decimal(10,3) DEFAULT NULL,
  `zustand` varchar(255) DEFAULT NULL,
  `verschmutzungsgrad` varchar(255) DEFAULT NULL,
  `verschmutzungsart` varchar(255) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung1` varchar(255) DEFAULT NULL,
  `bemerkung2` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `od_was-deckel`
--

CREATE TABLE `od_was-deckel` (
  `code` varchar(255) DEFAULT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `punktnummer` varchar(255) DEFAULT NULL,
  `ostwert` decimal(10,3) DEFAULT NULL,
  `nord` decimal(10,3) DEFAULT NULL,
  `höhe` decimal(10,3) DEFAULT NULL,
  `deckel_innen_aufliegend` varchar(255) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `länge` decimal(10,3) DEFAULT NULL,
  `breite` decimal(10,3) DEFAULT NULL,
  `d_stärke` decimal(10,3) DEFAULT NULL,
  `zustand_deckel` varchar(255) DEFAULT NULL,
  `objektstatus` varchar(255) DEFAULT NULL,
  `bemerkung` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `benutzer_der_aufnahme` varchar(255) DEFAULT NULL,
  `ivl_name` varchar(255) DEFAULT NULL,
  `aktiv` varchar(255) DEFAULT NULL,
  `dwg_objekt` varchar(255) DEFAULT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wo_company`
--

CREATE TABLE `wo_company` (
  `id` int(11) NOT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `workarea_id` int(11) DEFAULT NULL,
  `default_user_id` int(11) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_company`
--

INSERT INTO `wo_company` (`id`, `company_name`, `workarea_id`, `default_user_id`, `created_at`, `created_by`) VALUES
(1, 'Hemminger', 1, 29, '2024-03-18', 1),
(25, 'HDMS', 1, 28, '2024-03-28', 1),
(27, 'Smart Data Factory', 1, 27, '2024-04-24', 1);

-- --------------------------------------------------------

--
-- Table structure for table `wo_processstep`
--

CREATE TABLE `wo_processstep` (
  `id` int(11) NOT NULL,
  `processname` varchar(255) NOT NULL,
  `table_de` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_processstep`
--

INSERT INTO `wo_processstep` (`id`, `processname`, `table_de`) VALUES
(1, 'Data Preparation', ''),
(2, 'Pre-Production', ''),
(3, 'Survey', ''),
(4, 'Map Creation', ''),
(5, 'Model Creation', ''),
(6, 'IVL Creation', '');

-- --------------------------------------------------------

--
-- Table structure for table `wo_role`
--

CREATE TABLE `wo_role` (
  `id` int(11) NOT NULL,
  `role_name` varchar(255) NOT NULL,
  `process_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_role`
--

INSERT INTO `wo_role` (`id`, `role_name`, `process_name`) VALUES
(1, 'Admin', 'Admin'),
(2, 'Data Preparation', 'Data Preparation'),
(3, 'Pre-Production', 'Pre-Production'),
(4, 'Survey', 'Survey'),
(5, 'Map Creation', 'Map Creation'),
(6, '3D Modeling', '3D Modeling');

-- --------------------------------------------------------

--
-- Table structure for table `wo_status`
--

CREATE TABLE `wo_status` (
  `id` int(11) NOT NULL,
  `code` varchar(3) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `description_de` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_status`
--

INSERT INTO `wo_status` (`id`, `code`, `description`, `description_de`) VALUES
(1, '0', 'New Work Order', 'New Work Order'),
(2, '100', 'Assigned to Pre-production Company', 'Assigned to Pre-production Company'),
(3, '101', 'Assigned to Pre-production User', 'Assigned to Pre-production User'),
(4, '102', 'Pre-production in-progress', 'Pre-production in-progress'),
(5, '103', 'Pre-production completed', 'Pre-production completed'),
(6, '200', 'Assigned to Survey Company', 'Assigned to Survey Company'),
(7, '201', 'Assigned to Survey User', 'Assigned to Survey User'),
(8, '202', 'Survey in-progress', 'Survey in-progress'),
(9, '203', 'Survey completed', 'Survey completed'),
(10, '300', 'Assigned to Map Creation Company', 'Assigned to Map creation Company'),
(11, '301', 'Assigned to Map Creation User', 'Assigned to Map creation User'),
(12, '302', 'Map Creation in-progress', 'Map creation in-progress'),
(13, '303', 'Map Creation completed', 'Map creation completed'),
(14, '350', 'Map Creation - waiting for approval', 'Map creation - waiting for approval'),
(15, '400', 'Assigned to Model Creation Company', 'Assigned to Model creation Company'),
(16, '401', 'Assigned to Model Creation User', 'Assigned to Model creation User'),
(17, '402', 'Model Creation in-progress', 'Model creation in-progress'),
(18, '403', 'Model Creation completed', 'Model creation completed'),
(19, '410', 'Model Creation QC Checked', 'Model creation QC Checked'),
(20, '205', 'Clarification required for Survey', 'Clarification required for Survey'),
(21, '305', 'Clarification required for Map Creation', 'Clarification required for Map Creation'),
(22, '110', 'Preproduction - Assigned to QC', 'Preproduction - Assigned to QC'),
(23, '111', 'Preproduction - QC Approved', 'Preproduction - QC Approved'),
(24, '112', 'Preproduction - QC Rejected', 'Preproduction - QC Rejected'),
(25, '210', 'Survey - Assigned to QC', 'Survey - Assigned to QC'),
(26, '211', 'Survey - QC Approved', 'Survey - QC Approved'),
(27, '212', 'Survey - QC Rejected', 'Survey - QC Rejected'),
(28, '310', 'MapCreation - Assigned to QC', 'MapCreation - Assigned to QC'),
(29, '311', 'MapCreation - QC Approved', 'MapCreation - QC Approved'),
(30, '312', 'MapCreation - QC Rejected', 'MapCreation - QC Rejected');

-- --------------------------------------------------------

--
-- Table structure for table `wo_user_role`
--

CREATE TABLE `wo_user_role` (
  `id` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `roleid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_user_role`
--

INSERT INTO `wo_user_role` (`id`, `userid`, `roleid`) VALUES
(1, 1, 1),
(34, 12, 3),
(35, 12, 4),
(36, 12, 5),
(64, 25, 5),
(65, 26, 6),
(66, 24, 3),
(67, 24, 4),
(70, 23, 3),
(71, 23, 4),
(72, 23, 5),
(73, 27, 1),
(74, 27, 2),
(75, 27, 3),
(76, 27, 4),
(77, 27, 5),
(78, 27, 6),
(79, 28, 3),
(80, 28, 5),
(81, 28, 6),
(82, 29, 2),
(83, 29, 3),
(84, 29, 4),
(85, 29, 5),
(86, 29, 6),
(87, 30, 2),
(88, 30, 3),
(89, 30, 4),
(90, 30, 5),
(91, 30, 6),
(92, 31, 3),
(93, 31, 5),
(94, 31, 6),
(95, 32, 3),
(96, 32, 5),
(97, 32, 6);

-- --------------------------------------------------------

--
-- Table structure for table `wo_workarea`
--

CREATE TABLE `wo_workarea` (
  `id` int(11) NOT NULL,
  `workarea_name` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_workarea`
--

INSERT INTO `wo_workarea` (`id`, `workarea_name`) VALUES
(1, 'PB 1'),
(2, 'PB 2'),
(3, 'PB 3'),
(4, 'PB 4'),
(5, 'PB 5');

-- --------------------------------------------------------

--
-- Table structure for table `wo_workduration`
--

CREATE TABLE `wo_workduration` (
  `id` int(11) NOT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `processstep_id` int(11) DEFAULT NULL,
  `status_code` varchar(4) DEFAULT NULL,
  `duration` decimal(10,2) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_workduration`
--

INSERT INTO `wo_workduration` (`id`, `workorder_id`, `processstep_id`, `status_code`, `duration`, `updated_by`, `updated_at`) VALUES
(36, 44, 2, '103', '5.20', 31, '2024-04-24 12:18:17'),
(37, 44, 3, '203', '6.00', 29, '2024-04-24 12:22:52'),
(38, 73, 2, '103', '6.50', 31, '2024-04-24 13:36:07'),
(39, 47, 2, '103', '6.00', 28, '2024-04-26 08:42:30'),
(40, 47, 3, '203', '8.00', 29, '2024-04-26 08:44:44'),
(41, 67, 2, '103', '7.00', 28, '2024-04-26 11:27:42'),
(42, 40, 2, '103', '5.00', 28, '2024-04-26 13:50:23'),
(43, 40, 3, '203', '8.00', 29, '2024-04-26 13:52:00'),
(44, 53, 2, '103', '6.07', 31, '2024-04-27 05:07:00'),
(45, 53, 3, '203', '5.00', 29, '2024-04-27 05:55:31');

-- --------------------------------------------------------

--
-- Table structure for table `wo_workorder`
--

CREATE TABLE `wo_workorder` (
  `id` int(11) NOT NULL,
  `name` varchar(6) DEFAULT NULL,
  `processstep_id` int(2) DEFAULT NULL,
  `status_code` varchar(4) DEFAULT NULL,
  `workarea_id` int(11) DEFAULT NULL,
  `assigned_to_user_id` int(11) DEFAULT NULL,
  `planned_startdate` date DEFAULT NULL,
  `planned_enddate` date DEFAULT NULL,
  `bimmodelreference_id` varchar(6) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `flag` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_workorder`
--

INSERT INTO `wo_workorder` (`id`, `name`, `processstep_id`, `status_code`, `workarea_id`, `assigned_to_user_id`, `planned_startdate`, `planned_enddate`, `bimmodelreference_id`, `created_date`, `created_user`, `flag`) VALUES
(22, '4810AA', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(23, '4860CJ', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(24, '4860CK', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(25, '4810AB', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(26, '4860CL', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(27, '4810AC', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(28, '4860CM', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(29, '4810AD', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(30, '4860CN', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(31, '4810AE', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(32, '4860CO', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(33, '4810AF', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(34, '4810BE', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(35, '4860CP', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(36, '4810AG', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(37, '4810BF', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(38, '4860CQ', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(39, '4810BG', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(40, '4860CR', 3, '203', 1, 29, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(41, '4810AH', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(42, '4810ZA', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(43, '4810AI', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(44, '4860CS', 4, '302', 1, 31, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(45, '4821AC', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(46, '4810AJ', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(47, '4860CT', 3, '203', 1, 29, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(48, '4860BH', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(49, '4810AK', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(50, '4860ZA', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(51, '4810AL', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(52, '4860BI', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(53, '4860ZB', 4, '301', 1, 31, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(54, '4810AM', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(55, '4860BK', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(56, '4870AA', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(57, '4810AN', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(58, '4860BL', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(59, '4810AO', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(60, '4870AB', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(61, '4860BN', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(62, '4810AP', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(63, '4870AC', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(64, '4860BO', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(65, '4810AQ', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(66, '4870AD', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(67, '4860BP', 3, '200', 1, 29, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(68, '4870AE', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(69, '4860BQ', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(70, '4810AR', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(71, '4810AS', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(72, '4870AF', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(73, '4860BR', 2, '103', 1, 31, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(74, '4870AG', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(75, '4810AT', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(76, '4860BS', 2, '101', 1, 31, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(77, '4870AH', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(78, '4810AU', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(79, '4860BT', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(80, '4870AI', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(81, '4810AV', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(82, '4860BU', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(83, '4860BV', 2, '101', 1, 31, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(84, '4870AK', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(85, '4810AW', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(86, '4860BW', 2, '101', 1, 31, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(87, '4870AL', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(88, '4810AX', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(89, '4860BX', 2, '101', 1, 32, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(90, '4870AM', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(91, '4810AY', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(92, '4860BY', 2, '101', 1, 32, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(93, '4810AZ', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(94, '4870AN', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(95, '4860BZ', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(96, '4870AO', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(97, '4870AO', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(98, '4810BA', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(99, '4860CA', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(100, '4870AP', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(101, '4810BB', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(102, '4860CB', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(103, '4870AR', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(104, '4860CC', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(105, '4810BC', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(106, '4870AT', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(107, '4870AV', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(108, '4870AW', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(109, '4810BD', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(110, '4860CD', 1, '0', 1, 1, '2024-04-25', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(111, '4870AQ', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(112, '4860CE', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(113, '4870AS', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(114, '4860CG', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(115, '4870AU', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(116, '4860CH', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(117, '4870AX', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL),
(118, '4860CI', 1, '0', 1, 1, '2024-04-24', '2024-04-25', NULL, '2024-04-24', 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `wo_workorder_remarks`
--

CREATE TABLE `wo_workorder_remarks` (
  `id` int(11) NOT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `workorder_status_id` int(11) DEFAULT NULL,
  `processstep_id` int(11) DEFAULT NULL,
  `status_code` varchar(11) DEFAULT NULL,
  `remarks` varchar(1000) DEFAULT NULL,
  `assigned_by` int(11) DEFAULT NULL,
  `assigned_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wo_workorder_status`
--

CREATE TABLE `wo_workorder_status` (
  `id` int(11) NOT NULL,
  `workorder_id` int(11) DEFAULT NULL,
  `processstep_id` int(11) DEFAULT NULL,
  `status_code` varchar(4) DEFAULT NULL,
  `assigned_by_user_id` int(11) DEFAULT NULL,
  `assigned_to_user_id` int(11) DEFAULT NULL,
  `assigned_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wo_workorder_status`
--

INSERT INTO `wo_workorder_status` (`id`, `workorder_id`, `processstep_id`, `status_code`, `assigned_by_user_id`, `assigned_to_user_id`, `assigned_at`) VALUES
(177, 22, 1, '0', 1, 1, '2024-04-24 11:06:19'),
(178, 23, 1, '0', 1, 1, '2024-04-24 11:06:23'),
(179, 24, 1, '0', 1, 1, '2024-04-24 11:06:46'),
(180, 25, 1, '0', 1, 1, '2024-04-24 11:06:49'),
(181, 26, 1, '0', 1, 1, '2024-04-24 11:07:07'),
(182, 27, 1, '0', 1, 1, '2024-04-24 11:07:18'),
(183, 28, 1, '0', 1, 1, '2024-04-24 11:07:25'),
(184, 29, 1, '0', 1, 1, '2024-04-24 11:07:40'),
(185, 30, 1, '0', 1, 1, '2024-04-24 11:07:42'),
(186, 31, 1, '0', 1, 1, '2024-04-24 11:07:55'),
(187, 32, 1, '0', 1, 1, '2024-04-24 11:07:59'),
(188, 33, 1, '0', 1, 1, '2024-04-24 11:08:08'),
(189, 34, 1, '0', 1, 1, '2024-04-24 11:08:10'),
(190, 35, 1, '0', 1, 1, '2024-04-24 11:08:17'),
(191, 36, 1, '0', 1, 1, '2024-04-24 11:08:27'),
(192, 37, 1, '0', 1, 1, '2024-04-24 11:08:28'),
(193, 38, 1, '0', 1, 1, '2024-04-24 11:08:34'),
(194, 39, 1, '0', 1, 1, '2024-04-24 11:08:44'),
(195, 40, 1, '0', 1, 1, '2024-04-24 11:08:51'),
(196, 41, 1, '0', 1, 1, '2024-04-24 11:08:53'),
(197, 42, 1, '0', 1, 1, '2024-04-24 11:09:01'),
(198, 43, 1, '0', 1, 1, '2024-04-24 11:09:06'),
(199, 44, 1, '0', 1, 1, '2024-04-24 11:09:11'),
(200, 45, 1, '0', 1, 1, '2024-04-24 11:09:16'),
(201, 46, 1, '0', 1, 1, '2024-04-24 11:09:20'),
(202, 47, 1, '0', 1, 1, '2024-04-24 11:09:28'),
(203, 48, 1, '0', 1, 1, '2024-04-24 11:09:31'),
(204, 49, 1, '0', 1, 1, '2024-04-24 11:09:35'),
(205, 50, 1, '0', 1, 1, '2024-04-24 11:09:42'),
(206, 51, 1, '0', 1, 1, '2024-04-24 11:09:47'),
(207, 52, 1, '0', 1, 1, '2024-04-24 11:09:48'),
(208, 53, 1, '0', 1, 1, '2024-04-24 11:09:57'),
(209, 54, 1, '0', 1, 1, '2024-04-24 11:09:59'),
(210, 55, 1, '0', 1, 1, '2024-04-24 11:10:06'),
(211, 56, 1, '0', 1, 1, '2024-04-24 11:10:12'),
(212, 57, 1, '0', 1, 1, '2024-04-24 11:10:12'),
(213, 58, 1, '0', 1, 1, '2024-04-24 11:10:23'),
(214, 59, 1, '0', 1, 1, '2024-04-24 11:10:24'),
(215, 60, 1, '0', 1, 1, '2024-04-24 11:10:28'),
(216, 61, 1, '0', 1, 1, '2024-04-24 11:10:37'),
(217, 62, 1, '0', 1, 1, '2024-04-24 11:10:38'),
(218, 63, 1, '0', 1, 1, '2024-04-24 11:10:43'),
(219, 64, 1, '0', 1, 1, '2024-04-24 11:10:51'),
(220, 65, 1, '0', 1, 1, '2024-04-24 11:10:57'),
(221, 66, 1, '0', 1, 1, '2024-04-24 11:10:59'),
(222, 67, 1, '0', 1, 1, '2024-04-24 11:11:04'),
(223, 68, 1, '0', 1, 1, '2024-04-24 11:11:12'),
(224, 69, 1, '0', 1, 1, '2024-04-24 11:11:17'),
(225, 70, 1, '0', 1, 1, '2024-04-24 11:11:20'),
(226, 71, 1, '0', 1, 1, '2024-04-24 11:11:31'),
(227, 72, 1, '0', 1, 1, '2024-04-24 11:11:31'),
(228, 73, 1, '0', 1, 1, '2024-04-24 11:11:31'),
(229, 74, 1, '0', 1, 1, '2024-04-24 11:11:44'),
(230, 75, 1, '0', 1, 1, '2024-04-24 11:11:44'),
(231, 76, 1, '0', 1, 1, '2024-04-24 11:11:45'),
(232, 77, 1, '0', 1, 1, '2024-04-24 11:11:56'),
(233, 78, 1, '0', 1, 1, '2024-04-24 11:11:57'),
(234, 79, 1, '0', 1, 1, '2024-04-24 11:11:59'),
(235, 80, 1, '0', 1, 1, '2024-04-24 11:12:10'),
(236, 81, 1, '0', 1, 1, '2024-04-24 11:12:10'),
(237, 82, 1, '0', 1, 1, '2024-04-24 11:12:12'),
(238, 83, 1, '0', 1, 1, '2024-04-24 11:12:25'),
(239, 84, 1, '0', 1, 1, '2024-04-24 11:12:27'),
(240, 85, 1, '0', 1, 1, '2024-04-24 11:12:30'),
(241, 86, 1, '0', 1, 1, '2024-04-24 11:12:38'),
(242, 87, 1, '0', 1, 1, '2024-04-24 11:12:41'),
(243, 88, 1, '0', 1, 1, '2024-04-24 11:12:43'),
(244, 89, 1, '0', 1, 1, '2024-04-24 11:12:52'),
(245, 90, 1, '0', 1, 1, '2024-04-24 11:12:56'),
(246, 91, 1, '0', 1, 1, '2024-04-24 11:12:56'),
(247, 92, 1, '0', 1, 1, '2024-04-24 11:13:07'),
(248, 93, 1, '0', 1, 1, '2024-04-24 11:13:08'),
(249, 94, 1, '0', 1, 1, '2024-04-24 11:13:14'),
(250, 95, 1, '0', 1, 1, '2024-04-24 11:13:21'),
(251, 96, 1, '0', 1, 1, '2024-04-24 11:13:32'),
(252, 97, 1, '0', 1, 1, '2024-04-24 11:13:32'),
(253, 98, 1, '0', 1, 1, '2024-04-24 11:13:36'),
(254, 99, 1, '0', 1, 1, '2024-04-24 11:13:38'),
(255, 100, 1, '0', 1, 1, '2024-04-24 11:13:46'),
(256, 101, 1, '0', 1, 1, '2024-04-24 11:13:56'),
(257, 102, 1, '0', 1, 1, '2024-04-24 11:13:58'),
(258, 103, 1, '0', 1, 1, '2024-04-24 11:14:03'),
(259, 104, 1, '0', 1, 1, '2024-04-24 11:14:16'),
(260, 105, 1, '0', 1, 1, '2024-04-24 11:14:18'),
(261, 106, 1, '0', 1, 1, '2024-04-24 11:14:19'),
(262, 107, 1, '0', 1, 1, '2024-04-24 11:14:33'),
(263, 108, 1, '0', 1, 1, '2024-04-24 11:14:47'),
(264, 109, 1, '0', 1, 1, '2024-04-24 11:14:53'),
(265, 110, 1, '0', 1, 1, '2024-04-24 11:14:55'),
(266, 111, 1, '0', 1, 1, '2024-04-24 11:15:04'),
(267, 112, 1, '0', 1, 1, '2024-04-24 11:15:10'),
(268, 113, 1, '0', 1, 1, '2024-04-24 11:15:19'),
(269, 114, 1, '0', 1, 1, '2024-04-24 11:15:28'),
(270, 115, 1, '0', 1, 1, '2024-04-24 11:15:34'),
(271, 116, 1, '0', 1, 1, '2024-04-24 11:15:44'),
(272, 117, 1, '0', 1, 1, '2024-04-24 11:15:51'),
(273, 118, 1, '0', 1, 1, '2024-04-24 11:15:57'),
(274, 44, 2, '100', 1, 28, '2024-04-24 11:48:33'),
(275, 44, 2, '101', 28, 31, '2024-04-24 11:57:45'),
(276, 44, 2, '102', 31, 31, '2024-04-24 11:58:25'),
(277, 44, 2, '103', 31, 31, '2024-04-24 12:18:17'),
(278, 44, 3, '200', 31, 29, '2024-04-24 12:19:52'),
(279, 44, 3, '201', 29, 29, '2024-04-24 12:20:16'),
(280, 44, 3, '202', 29, 29, '2024-04-24 12:20:22'),
(281, 44, 3, '203', 29, 29, '2024-04-24 12:22:52'),
(282, 44, 4, '300', 29, 28, '2024-04-24 12:24:55'),
(283, 44, 4, '301', 28, 31, '2024-04-24 12:25:46'),
(284, 44, 4, '302', 31, 31, '2024-04-24 12:26:08'),
(285, 67, 2, '100', 1, 28, '2024-04-24 13:22:31'),
(286, 73, 2, '100', 1, 28, '2024-04-24 13:23:47'),
(287, 76, 2, '100', 1, 28, '2024-04-24 13:27:13'),
(288, 47, 2, '100', 1, 28, '2024-04-24 13:27:48'),
(289, 47, 2, '101', 28, 28, '2024-04-24 13:28:26'),
(290, 67, 2, '101', 28, 28, '2024-04-24 13:28:36'),
(291, 73, 2, '101', 28, 31, '2024-04-24 13:28:50'),
(292, 76, 2, '101', 28, 31, '2024-04-24 13:28:56'),
(293, 73, 2, '102', 31, 31, '2024-04-24 13:29:24'),
(294, 73, 2, '103', 31, 31, '2024-04-24 13:36:07'),
(295, 47, 2, '102', 28, 28, '2024-04-26 08:35:36'),
(296, 67, 2, '102', 28, 28, '2024-04-26 08:41:20'),
(297, 47, 2, '103', 28, 28, '2024-04-26 08:42:30'),
(298, 47, 3, '200', 28, 29, '2024-04-26 08:43:49'),
(299, 47, 3, '201', 29, 29, '2024-04-26 08:44:15'),
(300, 47, 3, '202', 29, 29, '2024-04-26 08:44:20'),
(301, 47, 3, '203', 29, 29, '2024-04-26 08:44:44'),
(302, 83, 2, '100', 1, 28, '2024-04-26 11:17:45'),
(303, 86, 2, '100', 1, 28, '2024-04-26 11:18:27'),
(304, 89, 2, '100', 1, 28, '2024-04-26 11:19:05'),
(305, 53, 2, '100', 1, 28, '2024-04-26 11:19:40'),
(306, 92, 2, '100', 1, 28, '2024-04-26 11:20:16'),
(307, 67, 2, '103', 28, 28, '2024-04-26 11:27:42'),
(308, 40, 2, '100', 1, 28, '2024-04-26 13:44:27'),
(309, 40, 2, '101', 28, 28, '2024-04-26 13:44:48'),
(310, 40, 2, '102', 28, 28, '2024-04-26 13:44:53'),
(311, 40, 2, '103', 28, 28, '2024-04-26 13:50:23'),
(312, 40, 3, '200', 28, 29, '2024-04-26 13:51:20'),
(313, 40, 3, '201', 29, 29, '2024-04-26 13:51:44'),
(314, 40, 3, '202', 29, 29, '2024-04-26 13:51:49'),
(315, 40, 3, '203', 29, 29, '2024-04-26 13:52:00'),
(316, 67, 3, '200', 28, 29, '2024-04-27 04:51:27'),
(317, 53, 2, '101', 28, 31, '2024-04-27 04:54:25'),
(318, 53, 2, '102', 31, 31, '2024-04-27 04:54:52'),
(319, 53, 2, '103', 31, 31, '2024-04-27 05:06:59'),
(320, 53, 3, '200', 31, 29, '2024-04-27 05:17:59'),
(321, 53, 3, '201', 29, 29, '2024-04-27 05:55:08'),
(322, 53, 3, '202', 29, 29, '2024-04-27 05:55:17'),
(323, 53, 3, '203', 29, 29, '2024-04-27 05:55:31'),
(324, 53, 4, '300', 29, 28, '2024-04-27 06:05:31'),
(325, 53, 4, '301', 28, 31, '2024-04-27 06:07:33'),
(326, 89, 2, '101', 28, 32, '2024-04-27 06:13:36'),
(327, 92, 2, '101', 28, 32, '2024-04-27 06:13:54'),
(328, 83, 2, '101', 28, 31, '2024-04-27 06:14:03'),
(329, 86, 2, '101', 28, 31, '2024-04-27 06:14:10');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `en_block`
--
ALTER TABLE `en_block`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `en_circle`
--
ALTER TABLE `en_circle`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `en_entity`
--
ALTER TABLE `en_entity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `en_line`
--
ALTER TABLE `en_line`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `en_mline`
--
ALTER TABLE `en_mline`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `en_point`
--
ALTER TABLE `en_point`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `en_text`
--
ALTER TABLE `en_text`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_drawing`
--
ALTER TABLE `fd_drawing`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_fieldtypelist`
--
ALTER TABLE `fd_fieldtypelist`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_grouplist`
--
ALTER TABLE `fd_grouplist`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_image`
--
ALTER TABLE `fd_image`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_line`
--
ALTER TABLE `fd_line`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_listofvalues`
--
ALTER TABLE `fd_listofvalues`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_object_list`
--
ALTER TABLE `fd_object_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_object_structure`
--
ALTER TABLE `fd_object_structure`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fd_point`
--
ALTER TABLE `fd_point`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hi_kabelschacht`
--
ALTER TABLE `hi_kabelschacht`
  ADD PRIMARY KEY (`en_id`);

--
-- Indexes for table `hi_kabelschutzrohr`
--
ALTER TABLE `hi_kabelschutzrohr`
  ADD PRIMARY KEY (`en_id`);

--
-- Indexes for table `hi_layer`
--
ALTER TABLE `hi_layer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hi_leitungstrasse`
--
ALTER TABLE `hi_leitungstrasse`
  ADD PRIMARY KEY (`en_id`);

--
-- Indexes for table `hi_schacht_unbekannt`
--
ALTER TABLE `hi_schacht_unbekannt`
  ADD PRIMARY KEY (`en_id`);

--
-- Indexes for table `hi_schaltschrank`
--
ALTER TABLE `hi_schaltschrank`
  ADD PRIMARY KEY (`en_id`);

--
-- Indexes for table `hi_wasserschacht`
--
ALTER TABLE `hi_wasserschacht`
  ADD PRIMARY KEY (`en_id`);

--
-- Indexes for table `hi_zu_checken`
--
ALTER TABLE `hi_zu_checken`
  ADD PRIMARY KEY (`en_id`);

--
-- Indexes for table `od_abw-bauwerk`
--
ALTER TABLE `od_abw-bauwerk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_abw-deckel`
--
ALTER TABLE `od_abw-deckel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_deckel-höhenpunkt`
--
ALTER TABLE `od_deckel-höhenpunkt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_ela-bauwerk`
--
ALTER TABLE `od_ela-bauwerk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_ela-bw-wand`
--
ALTER TABLE `od_ela-bw-wand`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_ela-deckel`
--
ALTER TABLE `od_ela-deckel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_entfällt`
--
ALTER TABLE `od_entfällt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_gas-schieber-deckel`
--
ALTER TABLE `od_gas-schieber-deckel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_grenzbolzen`
--
ALTER TABLE `od_grenzbolzen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_grenzstein`
--
ALTER TABLE `od_grenzstein`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_hoehenfestpunkt`
--
ALTER TABLE `od_hoehenfestpunkt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_kabelschutzrohr`
--
ALTER TABLE `od_kabelschutzrohr`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_kabel_freiliegend`
--
ALTER TABLE `od_kabel_freiliegend`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_nagel_sonst_pkt`
--
ALTER TABLE `od_nagel_sonst_pkt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_schaden`
--
ALTER TABLE `od_schaden`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_sonstiger_punkt`
--
ALTER TABLE `od_sonstiger_punkt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_trog-bauwerk`
--
ALTER TABLE `od_trog-bauwerk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_unbekannter-deckel`
--
ALTER TABLE `od_unbekannter-deckel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_vermes_pkt_rmk`
--
ALTER TABLE `od_vermes_pkt_rmk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_was-bauwerk`
--
ALTER TABLE `od_was-bauwerk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `od_was-deckel`
--
ALTER TABLE `od_was-deckel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wo_company`
--
ALTER TABLE `wo_company`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wo_processstep`
--
ALTER TABLE `wo_processstep`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `processname` (`processname`);

--
-- Indexes for table `wo_role`
--
ALTER TABLE `wo_role`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wo_status`
--
ALTER TABLE `wo_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wo_user_role`
--
ALTER TABLE `wo_user_role`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wo_workarea`
--
ALTER TABLE `wo_workarea`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `areaname` (`workarea_name`);

--
-- Indexes for table `wo_workduration`
--
ALTER TABLE `wo_workduration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wo_workorder`
--
ALTER TABLE `wo_workorder`
  ADD PRIMARY KEY (`id`),
  ADD KEY `processname` (`processstep_id`),
  ADD KEY `status` (`status_code`),
  ADD KEY `workarea` (`workarea_id`),
  ADD KEY `userid` (`created_user`);

--
-- Indexes for table `wo_workorder_remarks`
--
ALTER TABLE `wo_workorder_remarks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wo_workorder_status`
--
ALTER TABLE `wo_workorder_status`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `en_block`
--
ALTER TABLE `en_block`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5960;

--
-- AUTO_INCREMENT for table `en_circle`
--
ALTER TABLE `en_circle`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1214;

--
-- AUTO_INCREMENT for table `en_entity`
--
ALTER TABLE `en_entity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11045;

--
-- AUTO_INCREMENT for table `en_line`
--
ALTER TABLE `en_line`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2372;

--
-- AUTO_INCREMENT for table `en_mline`
--
ALTER TABLE `en_mline`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1385;

--
-- AUTO_INCREMENT for table `en_point`
--
ALTER TABLE `en_point`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25051;

--
-- AUTO_INCREMENT for table `en_text`
--
ALTER TABLE `en_text`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=118;

--
-- AUTO_INCREMENT for table `fd_drawing`
--
ALTER TABLE `fd_drawing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;

--
-- AUTO_INCREMENT for table `fd_fieldtypelist`
--
ALTER TABLE `fd_fieldtypelist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `fd_grouplist`
--
ALTER TABLE `fd_grouplist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT for table `fd_image`
--
ALTER TABLE `fd_image`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2032;

--
-- AUTO_INCREMENT for table `fd_line`
--
ALTER TABLE `fd_line`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;

--
-- AUTO_INCREMENT for table `fd_listofvalues`
--
ALTER TABLE `fd_listofvalues`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120;

--
-- AUTO_INCREMENT for table `fd_object_list`
--
ALTER TABLE `fd_object_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `fd_object_structure`
--
ALTER TABLE `fd_object_structure`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4450;

--
-- AUTO_INCREMENT for table `fd_point`
--
ALTER TABLE `fd_point`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=435;

--
-- AUTO_INCREMENT for table `hi_kabelschacht`
--
ALTER TABLE `hi_kabelschacht`
  MODIFY `en_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=336;

--
-- AUTO_INCREMENT for table `hi_kabelschutzrohr`
--
ALTER TABLE `hi_kabelschutzrohr`
  MODIFY `en_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hi_layer`
--
ALTER TABLE `hi_layer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;

--
-- AUTO_INCREMENT for table `hi_leitungstrasse`
--
ALTER TABLE `hi_leitungstrasse`
  MODIFY `en_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=397;

--
-- AUTO_INCREMENT for table `hi_schacht_unbekannt`
--
ALTER TABLE `hi_schacht_unbekannt`
  MODIFY `en_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hi_schaltschrank`
--
ALTER TABLE `hi_schaltschrank`
  MODIFY `en_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `hi_wasserschacht`
--
ALTER TABLE `hi_wasserschacht`
  MODIFY `en_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=268;

--
-- AUTO_INCREMENT for table `hi_zu_checken`
--
ALTER TABLE `hi_zu_checken`
  MODIFY `en_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1318;

--
-- AUTO_INCREMENT for table `od_abw-bauwerk`
--
ALTER TABLE `od_abw-bauwerk`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_abw-deckel`
--
ALTER TABLE `od_abw-deckel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `od_deckel-höhenpunkt`
--
ALTER TABLE `od_deckel-höhenpunkt`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_ela-bauwerk`
--
ALTER TABLE `od_ela-bauwerk`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `od_ela-bw-wand`
--
ALTER TABLE `od_ela-bw-wand`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `od_ela-deckel`
--
ALTER TABLE `od_ela-deckel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `od_entfällt`
--
ALTER TABLE `od_entfällt`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `od_gas-schieber-deckel`
--
ALTER TABLE `od_gas-schieber-deckel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_grenzbolzen`
--
ALTER TABLE `od_grenzbolzen`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_grenzstein`
--
ALTER TABLE `od_grenzstein`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_hoehenfestpunkt`
--
ALTER TABLE `od_hoehenfestpunkt`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_kabelschutzrohr`
--
ALTER TABLE `od_kabelschutzrohr`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_kabel_freiliegend`
--
ALTER TABLE `od_kabel_freiliegend`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_nagel_sonst_pkt`
--
ALTER TABLE `od_nagel_sonst_pkt`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_schaden`
--
ALTER TABLE `od_schaden`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_sonstiger_punkt`
--
ALTER TABLE `od_sonstiger_punkt`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `od_trog-bauwerk`
--
ALTER TABLE `od_trog-bauwerk`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `od_unbekannter-deckel`
--
ALTER TABLE `od_unbekannter-deckel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_vermes_pkt_rmk`
--
ALTER TABLE `od_vermes_pkt_rmk`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_was-bauwerk`
--
ALTER TABLE `od_was-bauwerk`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `od_was-deckel`
--
ALTER TABLE `od_was-deckel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wo_company`
--
ALTER TABLE `wo_company`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `wo_processstep`
--
ALTER TABLE `wo_processstep`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `wo_role`
--
ALTER TABLE `wo_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `wo_status`
--
ALTER TABLE `wo_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `wo_user_role`
--
ALTER TABLE `wo_user_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;

--
-- AUTO_INCREMENT for table `wo_workarea`
--
ALTER TABLE `wo_workarea`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `wo_workduration`
--
ALTER TABLE `wo_workduration`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `wo_workorder`
--
ALTER TABLE `wo_workorder`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;

--
-- AUTO_INCREMENT for table `wo_workorder_remarks`
--
ALTER TABLE `wo_workorder_remarks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `wo_workorder_status`
--
ALTER TABLE `wo_workorder_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=330;
COMMIT;

