-- Table structure for table `revisions`
--

CREATE TABLE `revisions` (
  `id` int NOT NULL,
  `canonicalId` int NOT NULL,
  `creatorId` int DEFAULT NULL,
  `num` int NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `revisions`
--

INSERT INTO `revisions` (`id`, `canonicalId`, `creatorId`, `num`, `notes`) VALUES
(1, 2, 1, 1, NULL),
(2, 2, 1, 2, 'Applied “Draft 1”'),
(3, 7, 1, 1, NULL),
(4, 2, 1, 3, 'Applied “Draft 1”'),
(5, 7, 1, 2, NULL),
(6, 2, 1, 4, 'Applied “Draft 1”'),
(7, 7, 1, 3, NULL),
(8, 2, 1, 5, 'Applied “Draft 1”'),
(9, 2, 1, 6, 'Applied “Draft 1”'),
(10, 7, 1, 4, NULL),
(11, 2, 1, 7, 'Applied “Draft 1”'),
(12, 7, 1, 5, NULL),
(13, 2, 1, 8, 'Applied “Draft 1”'),
(14, 7, 1, 6, NULL),
(15, 2, 1, 9, 'Applied “Draft 1”'),
(16, 7, 1, 7, NULL),
(17, 2, 1, 10, 'Applied “Draft 1”'),
(18, 7, 1, 8, NULL),
(19, 2, 1, 11, 'Applied “Draft 1”'),
(20, 7, 1, 9, NULL),
(21, 81, 1, 1, NULL),
(22, 81, 1, 2, NULL),
(23, 81, 1, 3, 'Applied “Draft 1”'),
(24, 81, 1, 4, 'Applied “Draft 1”'),
(25, 81, 1, 5, ''),
(26, 81, 1, 6, NULL),
(27, 81, 1, 7, NULL),
(28, 81, 1, 8, ''),
(29, 81, 1, 9, ''),
(30, 2, 1, 12, ''),
(31, 99, 1, 1, ''),
(32, 102, 1, 1, ''),
(33, 105, 1, 1, ''),
(34, 108, 1, 1, ''),
(35, 111, 1, 1, ''),
(36, 114, 1, 1, ''),
(37, 2, 1, 13, 'Applied “Draft 1”'),
(38, 7, 1, 10, NULL),
(39, 114, 1, 2, 'Applied “Draft 1”'),
(40, 111, 1, 2, 'Applied “Draft 1”'),
(41, 108, 1, 2, 'Applied “Draft 1”'),
(42, 105, 1, 2, 'Applied “Draft 1”'),
(43, 102, 1, 2, 'Applied “Draft 1”'),
(44, 99, 1, 2, 'Applied “Draft 1”'),
(45, 111, 1, 3, 'Applied “Draft 1”'),
(46, 108, 1, 3, 'Applied “Draft 1”'),
(47, 105, 1, 3, ''),
(48, 139, 1, 1, NULL),
(49, 139, 1, 2, 'Applied “Draft 1”'),
(50, 139, 1, 3, 'Applied “Draft 1”'),
(51, 139, 1, 4, 'Applied “Draft 1”'),
(52, 139, 1, 5, NULL),
(53, 139, 1, 6, ''),
(54, 149, 1, 1, NULL),
(55, 156, 1, 1, ''),
(56, 159, 1, 1, ''),
(57, 161, 1, 1, ''),
(58, 163, 1, 1, ''),
(59, 156, 1, 2, 'Applied “Draft 1”'),
(60, 161, 1, 2, 'Applied “Draft 1”'),
(61, 159, 1, 2, 'Applied “Draft 1”'),
(62, 163, 1, 2, 'Applied “Draft 1”'),
(63, 159, 1, 3, 'Applied “Draft 1”'),
(64, 163, 1, 3, ''),
(65, 156, 1, 3, 'Applied “Draft 1”'),
(66, 161, 1, 3, ''),
(67, 2, 1, 14, 'Applied “Draft 1”'),
(68, 2, 1, 15, 'Applied “Draft 1”'),
(69, 2, 1, 16, 'Applied “Draft 1”'),
(70, 189, 1, 1, NULL),
(71, 2, 1, 17, 'Applied “Draft 1”'),
(72, 2, 1, 18, 'Applied “Draft 1”'),
(73, 2, 1, 19, ''),
(74, 2, 1, 20, 'Applied “Draft 1”'),
(75, 2, 1, 21, 'Applied “Draft 1”'),
(76, 2, 1, 22, ''),
(77, 202, 1, 1, NULL),
(78, 202, 1, 2, 'Applied “Draft 1”'),
(79, 202, 1, 3, NULL),
(80, 202, 1, 4, ''),
(81, 114, 1, 3, 'Applied “Draft 1”'),
(82, 202, 1, 5, 'Applied “Draft 1”'),
(83, 202, 1, 6, 'Applied “Draft 1”'),
(84, 156, 1, 4, ''),
(85, 149, 1, 2, 'Applied “Draft 1”'),
(86, 149, 1, 3, 'Applied “Draft 1”'),
(87, 149, 1, 4, 'Applied “Draft 1”'),
(88, 149, 1, 5, 'Applied “Draft 1”'),
(89, 156, 1, 5, 'Applied “Draft 1”'),
(90, 156, 1, 6, 'Applied “Draft 1”'),
(91, 156, 1, 7, 'Applied “Draft 1”'),
(92, 156, 1, 8, 'Applied “Draft 1”'),
(93, 161, 1, 4, 'Applied “Draft 1”'),
(94, 161, 1, 5, 'Applied “Draft 1”'),
(95, 161, 1, 6, 'Applied “Draft 1”'),
(96, 161, 1, 7, 'Applied “Draft 1”'),
(97, 161, 1, 8, 'Applied “Draft 1”'),
(98, 161, 1, 9, 'Applied “Draft 1”'),
(99, 161, 1, 10, 'Applied “Draft 1”'),
(100, 161, 1, 11, 'Applied “Draft 1”'),
(101, 161, 1, 12, 'Applied “Draft 1”'),
(102, 202, 1, 7, 'Applied “Draft 1”'),
(103, 261, 1, 1, NULL),
(104, 262, 1, 1, NULL),
(105, 202, 1, 8, 'Applied “Draft 1”'),
(106, 202, 1, 9, 'Applied “Draft 1”'),
(107, 270, 1, 1, NULL),
(108, 270, 1, 2, 'Applied “Draft 1”'),
(109, 275, 1, 1, NULL),
(110, 270, 1, 3, 'Applied “Draft 1”'),
(111, 281, 1, 1, NULL),
(112, 270, 1, 4, 'Applied “Draft 1”'),
(113, 291, 1, 1, NULL),
(114, 270, 1, 5, ''),
(115, 270, 1, 6, 'Applied “Draft 1”'),
(116, 270, 1, 7, 'Applied “Draft 1”'),
(117, 139, 1, 7, NULL),
(118, 139, 1, 8, NULL),
(119, 302, 1, 1, NULL),
(120, 302, 1, 2, 'Applied “Draft 1”'),
(121, 306, 1, 1, ''),
(122, 302, 1, 3, NULL),
(123, 302, 1, 4, NULL),
(124, 302, 1, 5, NULL),
(125, 302, 1, 6, 'Applied “Draft 1”'),
(126, 313, 1, 1, ''),
(127, 302, 1, 7, 'Applied “Draft 1”'),
(128, 302, 1, 8, 'Applied “Draft 1”'),
(129, 302, 1, 9, 'Applied “Draft 1”'),
(130, 302, 1, 10, 'Applied “Draft 1”'),
(131, 302, 1, 11, 'Applied “Draft 1”'),
(132, 302, 1, 12, 'Applied “Draft 1”'),
(133, 337, 1, 1, ''),
(134, 337, 1, 2, 'Applied “Draft 1”'),
(135, 341, 1, 1, ''),
(136, 343, 1, 1, ''),
(137, 345, 1, 1, ''),
(138, 302, 1, 13, 'Applied “Draft 1”'),
(139, 348, 1, 1, ''),
(140, 351, 1, 1, ''),
(141, 353, 1, 1, ''),
(142, 355, 1, 1, ''),
(143, 357, 1, 1, ''),
(144, 302, 1, 14, 'Applied “Draft 1”'),
(145, 343, 1, 2, 'Applied “Draft 1”'),
(146, 270, 1, 8, 'Applied “Draft 1”'),
(147, 366, 1, 1, NULL),
(148, 270, 1, 9, 'Applied “Draft 1”'),
(149, 373, 1, 1, NULL),
(150, 270, 1, 10, 'Applied “Draft 1”'),
(151, 380, 1, 1, NULL),
(152, 381, 1, 1, NULL),
(153, 382, 1, 1, NULL),
(154, 387, 1, 1, NULL),
(155, 387, 1, 2, 'Applied “Draft 1”'),
(156, 387, 1, 3, 'Applied “Draft 1”'),
(157, 387, 1, 4, ''),
(158, 387, 1, 5, 'Applied “Draft 1”'),
(159, 387, 1, 6, 'Applied “Draft 1”'),
(160, 401, 1, 1, NULL),
(161, 387, 1, 7, 'Applied “Draft 1”'),
(162, 417, 1, 1, NULL),
(163, 387, 1, 8, 'Applied “Draft 1”'),
(164, 417, 1, 2, NULL),
(165, 387, 1, 9, 'Applied “Draft 1”'),
(166, 417, 1, 3, NULL),
(167, 387, 1, 10, 'Applied “Draft 1”'),
(168, 417, 1, 4, NULL),
(169, 387, 1, 11, 'Applied “Draft 1”'),
(170, 417, 1, 5, NULL),
(171, 387, 1, 12, 'Applied “Draft 1”'),
(172, 417, 1, 6, NULL),
(173, 387, 1, 13, 'Applied “Draft 1”'),
(174, 417, 1, 7, NULL),
(175, 387, 1, 14, 'Applied “Draft 1”'),
(176, 417, 1, 8, NULL),
(177, 387, 1, 15, 'Applied “Draft 1”'),
(178, 417, 1, 9, NULL),
(179, 387, 1, 16, 'Applied “Draft 1”'),
(180, 417, 1, 10, NULL),
(181, 387, 1, 17, 'Applied “Draft 1”'),
(182, 458, 1, 1, NULL),
(183, 387, 1, 18, 'Applied “Draft 1”'),
(184, 464, 1, 1, NULL),
(185, 465, 1, 1, NULL),
(186, 387, 1, 19, 'Applied “Draft 1”'),
(187, 475, 1, 1, NULL),
(188, 476, 1, 1, NULL),
(189, 477, 1, 1, NULL),
(190, 478, 1, 1, NULL),
(191, 479, 1, 1, NULL),
(192, 202, 1, 10, 'Applied “Draft 1”'),
(193, 261, 1, 2, NULL),
(194, 149, 1, 6, NULL),
(195, 302, 1, 15, NULL),
(196, 387, 1, 20, NULL),
(197, 302, 1, 16, NULL),
(198, 387, 1, 21, 'Applied “Draft 1”'),
(199, 417, 1, 11, NULL),
(200, 458, 1, 2, NULL),
(201, 464, 1, 2, NULL),
(202, 465, 1, 2, NULL),
(203, 475, 1, 2, NULL),
(204, 476, 1, 2, NULL),
(205, 477, 1, 2, NULL),
(206, 478, 1, 2, NULL),
(207, 479, 1, 2, NULL),
(208, 516, 1, 1, NULL),
(209, 516, 1, 2, 'Applied “Draft 1”'),
(210, 516, 1, 3, 'Applied “Draft 1”'),
(211, 99, 1, 3, ''),
(212, 105, 1, 4, ''),
(213, 524, 1, 1, ''),
(214, 526, 1, 1, ''),
(215, 528, 1, 1, ''),
(216, 524, 1, 2, 'Applied “Draft 1”'),
(217, 99, 1, 4, 'Applied “Draft 1”'),
(218, 538, 1, 1, NULL),
(219, 539, 1, 1, NULL),
(220, 540, 1, 1, NULL),
(221, 102, 1, 3, ''),
(222, 102, 1, 4, 'Applied “Draft 1”'),
(223, 524, 1, 3, 'Applied “Draft 1”'),
(224, 524, 1, 4, 'Applied “Draft 1”'),
(225, 99, 1, 5, 'Applied “Draft 1”'),
(226, 538, 1, 2, NULL),
(227, 99, 1, 6, ''),
(228, 526, 1, 2, 'Applied “Draft 1”'),
(229, 528, 1, 2, 'Applied “Draft 1”'),
(230, 99, 1, 7, 'Applied “Draft 1”'),
(231, 538, 1, 3, NULL),
(232, 99, 1, 8, 'Applied “Draft 1”'),
(233, 538, 1, 4, NULL),
(234, 99, 1, 9, 'Applied “Draft 1”'),
(235, 539, 1, 2, NULL),
(236, 99, 1, 10, 'Applied “Draft 1”'),
(237, 538, 1, 5, NULL),
(238, 539, 1, 3, NULL),
(239, 578, 1, 1, NULL),
(240, 99, 1, 11, 'Applied “Draft 1”'),
(241, 587, 1, 1, NULL),
(242, 99, 1, 12, 'Applied “Draft 1”'),
(243, 538, 1, 6, NULL),
(244, 99, 1, 13, 'Applied “Draft 1”'),
(245, 539, 1, 4, NULL),
(246, 578, 1, 2, NULL),
(247, 102, 1, 5, 'Applied “Draft 1”'),
(248, 603, 1, 1, NULL),
(249, 516, 1, 4, 'Applied “Draft 1”'),
(250, 608, 1, 1, NULL),
(251, 516, 1, 5, 'Applied “Draft 1”'),
(252, 608, 1, 2, NULL),
(253, 516, 1, 6, 'Applied “Draft 1”'),
(254, 608, 1, 3, NULL),
(255, 516, 1, 7, ''),
(256, 524, 1, 5, NULL),
(257, 526, 1, 3, NULL),
(258, 528, 1, 3, NULL),
(259, 524, 1, 6, NULL),
(260, 524, 1, 7, 'Applied “Draft 1”'),
(261, 524, 1, 8, 'Applied “Draft 1”'),
(262, 524, 1, 9, ''),
(263, 524, 1, 10, 'Applied “Draft 1”'),
(264, 633, 1, 1, NULL),
(265, 524, 1, 11, 'Applied “Draft 1”'),
(266, 633, 1, 2, NULL),
(267, 640, 1, 1, NULL),
(268, 641, 1, 1, NULL),
(269, 524, 1, 12, ''),
(270, 524, 1, 13, 'Applied “Draft 1”'),
(271, 524, 1, 14, 'Applied “Draft 1”'),
(272, 524, 1, 15, 'Applied “Draft 1”'),
(273, 524, 1, 16, ''),
(274, 524, 1, 17, 'Applied “Draft 1”'),
(275, 102, 1, 6, 'Applied “Draft 1”'),
(276, 603, 1, 2, NULL),
(277, 524, 1, 18, 'Applied “Draft 1”'),
(278, 672, 1, 1, NULL),
(279, 524, 1, 19, 'Applied “Draft 1”'),
(280, 682, 1, 1, NULL),
(281, 99, 1, 14, 'Applied “Draft 1”'),
(282, 538, 1, 7, NULL),
(283, 99, 1, 15, 'Applied “Draft 1”'),
(284, 538, 1, 8, NULL),
(285, 526, 1, 4, NULL),
(286, 528, 1, 4, NULL),
(287, 524, 1, 20, 'Applied “Draft 1”'),
(288, 524, 1, 21, 'Applied “Draft 1”'),
(289, 524, 1, 22, 'Applied “Draft 1”'),
(290, 108, 1, 4, 'Applied “Draft 1”'),
(291, 114, 1, 4, ''),
(292, 111, 1, 4, 'Applied “Draft 1”'),
(293, 105, 1, 5, ''),
(294, 105, 1, 6, 'Applied “Draft 1”'),
(295, 712, 1, 1, NULL),
(296, 105, 1, 7, 'Applied “Draft 1”'),
(297, 105, 1, 8, ''),
(298, 111, 1, 5, 'Applied “Draft 1”'),
(299, 726, 1, 1, NULL),
(300, 727, 1, 1, NULL),
(301, 728, 1, 1, NULL),
(302, 111, 1, 6, 'Applied “Draft 1”'),
(303, 726, 1, 2, NULL),
(304, 105, 1, 9, ''),
(305, 739, 1, 1, ''),
(306, 741, 1, 1, NULL),
(307, 743, 1, 1, NULL),
(308, 745, 1, 1, NULL),
(309, 747, 1, 1, NULL),
(310, 749, 1, 1, NULL),
(311, 751, 1, 1, NULL),
(312, 111, 1, 7, 'Applied “Draft 1”'),
(313, 105, 1, 10, 'Applied “Draft 1”'),
(314, 739, 1, 2, 'Applied “Draft 1”'),
(315, 741, 1, 2, NULL),
(316, 743, 1, 2, NULL),
(317, 745, 1, 2, NULL),
(318, 747, 1, 2, NULL),
(319, 751, 1, 2, NULL),
(320, 114, 1, 5, NULL),
(321, 108, 1, 5, 'Applied “Draft 1”'),
(322, 791, 1, 1, NULL),
(323, 792, 1, 1, NULL),
(324, 793, 1, 1, NULL),
(325, 794, 1, 1, NULL),
(326, 795, 1, 1, NULL),
(327, 99, 1, 16, 'Applied “Draft 1”'),
(328, 538, 1, 9, NULL),
(329, 539, 1, 5, NULL),
(330, 578, 1, 3, NULL),
(331, 102, 1, 7, 'Applied “Draft 1”'),
(332, 2, 1, 23, 'Applied “Draft 1”'),
(333, 102, 1, 8, 'Applied “Draft 1”'),
(334, 824, 1, 1, NULL),
(335, 825, 1, 1, NULL),
(336, 826, 1, 1, NULL),
(337, 827, 1, 1, NULL),
(338, 102, 1, 9, 'Applied “Draft 1”'),
(339, 139, 1, 9, 'Applied “Draft 1”'),
(340, 2, 1, 24, 'Applied “Draft 1”'),
(341, 2, 1, 25, ''),
(342, 2, 1, 26, 'Applied “Draft 1”'),
(343, 139, 1, 10, 'Applied “Draft 1”'),
(344, 516, 1, 8, 'Applied “Draft 1”'),
(345, 139, 1, 11, 'Applied “Draft 1”'),
(346, 102, 1, 10, 'Applied “Draft 1”'),
(347, 603, 1, 3, NULL),
(348, 516, 1, 9, ''),
(349, 516, 1, 10, 'Applied “Draft 1”'),
(350, 608, 1, 4, NULL),
(351, 516, 1, 11, 'Applied “Draft 1”'),
(352, 516, 1, 12, 'Applied “Draft 1”'),
(353, 867, 1, 1, ''),
(354, 870, 1, 1, NULL),
(355, 871, 1, 1, NULL),
(356, 872, 1, 1, NULL),
(357, 867, 1, 2, 'Applied “Draft 1”'),
(358, 867, 1, 3, ''),
(359, 867, 1, 4, 'Applied “Draft 1”'),
(360, 880, 1, 1, ''),
(361, 880, 1, 2, 'Applied “Draft 1”'),
(362, 880, 1, 3, 'Applied “Draft 1”'),
(363, 893, 1, 1, NULL),
(364, 894, 1, 1, NULL),
(365, 895, 1, 1, NULL),
(366, 880, 1, 4, 'Applied “Draft 1”'),
(367, 880, 1, 5, 'Applied “Draft 1”'),
(368, 904, 1, 1, ''),
(369, 907, 1, 1, NULL),
(370, 908, 1, 1, NULL),
(371, 909, 1, 1, NULL),
(372, 904, 1, 2, 'Applied “Draft 1”'),
(373, 867, 1, 5, 'Applied “Draft 1”'),
(374, 880, 1, 6, 'Applied “Draft 1”'),
(375, 516, 1, 13, 'Applied “Draft 1”'),
(376, 922, 1, 1, NULL),
(377, 880, 1, 7, ''),
(378, 867, 1, 6, ''),
(379, 516, 1, 14, 'Applied “Draft 1”'),
(380, 930, 1, 1, NULL),
(381, 516, 1, 15, 'Applied “Draft 1”'),
(382, 935, 1, 1, NULL),
(383, 904, 1, 3, 'Applied “Draft 1”'),
(384, 904, 1, 4, 'Applied “Draft 1”'),
(385, 880, 1, 8, 'Applied “Draft 1”'),
(386, 867, 1, 7, 'Applied “Draft 1”'),
(387, 2, 1, 27, 'Applied “Draft 1”'),
(388, 202, 1, 11, 'Applied “Draft 1”'),
(389, 261, 1, 3, NULL),
(390, 202, 1, 12, 'Applied “Draft 1”'),
(391, 202, 1, 13, 'Applied “Draft 1”'),
(392, 202, 1, 14, 'Applied “Draft 1”'),
(393, 261, 1, 4, NULL),
(394, 262, 1, 2, NULL),
(395, 270, 1, 11, 'Applied “Draft 1”'),
(396, 275, 1, 2, NULL),
(397, 270, 1, 12, 'Applied “Draft 1”'),
(398, 281, 1, 2, NULL),
(399, 291, 1, 2, NULL),
(400, 373, 1, 2, NULL),
(401, 380, 1, 2, NULL),
(402, 381, 1, 2, NULL),
(403, 382, 1, 2, NULL),
(404, 270, 1, 13, 'Applied “Draft 1”'),
(405, 373, 1, 3, NULL),
(406, 978, 1, 1, ''),
(407, 270, 1, 14, 'Applied “Draft 1”'),
(408, 373, 1, 4, NULL),
(409, 380, 1, 3, NULL),
(410, 381, 1, 3, NULL),
(411, 382, 1, 3, NULL),
(412, 202, 1, 15, 'Applied “Draft 1”'),
(413, 262, 1, 3, NULL),
(414, 387, 1, 22, 'Applied “Draft 1”'),
(415, 270, 1, 15, 'Applied “Draft 1”'),
(416, 382, 1, 4, NULL),
(417, 978, 1, 2, 'Applied “Draft 1”'),
(418, 978, 1, 3, 'Applied “Draft 1”'),
(419, 978, 1, 4, ''),
(420, 978, 1, 5, ''),
(421, 1012, 1, 1, NULL),
(422, 1012, 1, 2, 'Applied “Draft 1”'),
(423, 1012, 1, 3, 'Applied “Draft 1”'),
(424, 1012, 1, 4, 'Applied “Draft 1”'),
(425, 302, 1, 17, 'Applied “Draft 1”'),
(426, 313, 1, 2, 'Applied “Draft 1”'),
(427, 337, 1, 3, 'Applied “Draft 1”'),
(428, 341, 1, 2, 'Applied “Draft 1”'),
(429, 978, 1, 6, ''),
(430, 978, 1, 7, 'Applied “Draft 1”'),
(431, 343, 1, 3, 'Applied “Draft 1”'),
(432, 348, 1, 2, 'Applied “Draft 1”'),
(433, 351, 1, 2, 'Applied “Draft 1”'),
(434, 353, 1, 2, 'Applied “Draft 1”'),
(435, 355, 1, 2, 'Applied “Draft 1”'),
(436, 357, 1, 2, 'Applied “Draft 1”'),
(437, 978, 1, 8, 'Applied “Draft 1”'),
(438, 978, 1, 9, 'Applied “Draft 1”'),
(439, 978, 1, 10, 'Applied “Draft 1”'),
(440, 978, 1, 11, 'Applied “Draft 1”'),
(441, 978, 1, 12, 'Applied “Draft 1”'),
(442, 978, 1, 13, 'Applied “Draft 1”'),
(443, 978, 1, 14, 'Applied “Draft 1”'),
(444, 978, 1, 15, 'Applied “Draft 1”'),
(445, 1065, 1, 1, NULL),
(446, 978, 1, 16, 'Applied “Draft 1”'),
(447, 1065, 1, 2, NULL),
(448, 978, 1, 17, 'Applied “Draft 1”'),
(449, 978, 1, 18, 'Applied “Draft 1”'),
(450, 978, 1, 19, 'Applied “Draft 1”'),
(451, 1099, 1, 1, ''),
(452, 1100, 1, 1, NULL),
(453, 1104, 1, 1, ''),
(454, 1105, 1, 1, NULL),
(455, 1108, 1, 1, ''),
(456, 1109, 1, 1, NULL),
(457, 1112, 1, 1, ''),
(458, 1113, 1, 1, NULL),
(459, 978, 1, 20, 'Applied “Draft 1”'),
(460, 1108, 1, 2, ''),
(461, 526, 1, 5, NULL),
(462, 528, 1, 5, NULL),
(463, 978, 1, 21, 'Applied “Draft 1”'),
(464, 1123, 1, 1, ''),
(465, 1124, 1, 1, NULL),
(466, 1128, 1, 1, ''),
(467, 1129, 1, 1, NULL),
(468, 1132, 1, 1, ''),
(469, 1133, 1, 1, NULL),
(470, 1134, 1, 1, NULL),
(471, 1138, 1, 1, ''),
(472, 1139, 1, 1, NULL),
(473, 1140, 1, 1, NULL),
(474, 149, 1, 7, NULL),
(475, 1200, 1, 1, ''),
(476, 1203, 1, 1, ''),
(477, 149, 1, 8, ''),
(478, 1209, 1, 1, ''),
(479, 1209, 1, 2, 'Applied “Draft 1”'),
(480, 1209, 1, 3, 'Applied “Draft 1”'),
(481, 1203, 1, 2, 'Applied “Draft 1”'),
(482, 1203, 1, 3, 'Applied “Draft 1”'),
(483, 1209, 1, 4, ''),
(484, 1225, 1, 1, ''),
(485, 1229, 1, 1, ''),
(486, 1229, 1, 2, 'Applied “Draft 1”'),
(487, 1238, 1, 1, ''),
(488, 1238, 1, 2, ''),
(489, 1246, 1, 1, ''),
(490, 1252, 1, 1, ''),
(491, 1255, 1, 1, ''),
(492, 1259, 1, 1, ''),
(493, 1259, 1, 2, 'Applied “Draft 1”'),
(494, 1255, 1, 2, 'Applied “Draft 1”'),
(495, 1252, 1, 2, 'Applied “Draft 1”'),
(496, 1200, 1, 2, 'Applied “Draft 1”'),
(497, 1246, 1, 2, 'Applied “Draft 1”'),
(498, 1238, 1, 3, 'Applied “Draft 1”'),
(499, 1225, 1, 2, 'Applied “Draft 1”'),
(500, 1277, 1, 1, NULL),
(501, 1277, 1, 2, 'Applied “Draft 1”'),
(502, 270, 1, 16, ''),
(503, 387, 1, 23, ''),
(504, 1104, 1, 2, ''),
(505, 1104, 1, 3, 'Applied “Draft 1”'),
(506, 2, 1, 28, 'Applied “Draft 1”'),
(507, 2, 1, 29, 'Applied “Draft 1”'),
(508, 2, 1, 30, 'Applied “Draft 1”'),
(509, 1433, 1, 1, ''),
(510, 1433, 1, 2, 'Applied “Draft 1”'),
(511, 1433, 1, 3, 'Applied “Draft 1”'),
(512, 2, 1, 31, NULL),
(513, 7, 1, 11, NULL),
(514, 270, 1, 17, NULL),
(515, 275, 1, 3, NULL),
(516, 281, 1, 3, NULL),
(517, 291, 1, 3, NULL),
(518, 373, 1, 5, NULL),
(519, 380, 1, 4, NULL),
(520, 381, 1, 4, NULL),
(521, 382, 1, 5, NULL),
(522, 270, 1, 18, NULL),
(523, 387, 1, 24, NULL),
(524, 417, 1, 12, NULL),
(525, 458, 1, 3, NULL),
(526, 464, 1, 3, NULL),
(527, 465, 1, 3, NULL),
(528, 475, 1, 3, NULL),
(529, 476, 1, 3, NULL),
(530, 477, 1, 3, NULL),
(531, 478, 1, 3, NULL),
(532, 479, 1, 3, NULL),
(533, 387, 1, 25, NULL),
(534, 1277, 1, 3, NULL),
(535, 1012, 1, 5, NULL),
(536, 202, 1, 16, NULL),
(537, 261, 1, 5, NULL),
(538, 262, 1, 4, NULL),
(539, 302, 1, 18, NULL),
(540, 149, 1, 9, NULL),
(541, 139, 1, 12, NULL),
(542, 270, 1, 19, 'Applied “Draft 1”');

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

--
-- Table structure for table `searchindex`
--

CREATE TABLE `searchindex` (
  `elementId` int NOT NULL,
  `attribute` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fieldId` int NOT NULL,
  `siteId` int NOT NULL,
  `keywords` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `searchindex`
--

INSERT INTO `searchindex` (`elementId`, `attribute`, `fieldId`, `siteId`, `keywords`) VALUES
(1, 'email', 0, 1, ' web front experts gmail com '),
(1, 'firstname', 0, 1, ''),
(1, 'fullname', 0, 1, ''),
(1, 'lastname', 0, 1, ''),
(1, 'slug', 0, 1, ''),
(1, 'username', 0, 1, ' administrator '),
(2, 'field', 6, 1, ' we are committed to fostering a vibrant and inclusive company culture our mission is to create an environment where our employees thrive feel valued and actively contribute to the success of our organization all while making a positive impact on the communities we serve with our core value of mutual respect we communicate effectively while focusing on goals and results with integrity we are uncompromisingly committed to the health and safety of our employees and recognize the impact of work life balance and believe that a happy and fulfilled workforce is more productive '),
(2, 'slug', 0, 1, ' home '),
(2, 'title', 0, 1, ' home '),
(7, 'field', 11, 1, ' safran defense space inc leads with innovation integrity and equality as a proud u s company we recruit top level talent fuel the economy and make our troops and allies more resilient pioneering future technology with ethics at our core we ensure sustainability and equal opportunities for all '),
(7, 'slug', 0, 1, ' temp qedkagyabawkuhnazpdviswuqexpyzyalgko '),
(7, 'title', 0, 1, ''),
(16, 'alt', 0, 1, ''),
(16, 'extension', 0, 1, ' webm '),
(16, 'filename', 0, 1, ' hero home webm '),
(16, 'kind', 0, 1, ' video '),
(16, 'slug', 0, 1, ''),
(16, 'title', 0, 1, ' hero home '),
(17, 'alt', 0, 1, ''),
(17, 'extension', 0, 1, ' mp4 '),
(17, 'filename', 0, 1, ' hero home optimized mp4 '),
(17, 'kind', 0, 1, ' video '),
(17, 'slug', 0, 1, ''),
(17, 'title', 0, 1, ' hero home optimized '),
(23, 'alt', 0, 1, ''),
(23, 'extension', 0, 1, ' js '),
(23, 'filename', 0, 1, ' header js '),
(23, 'kind', 0, 1, ' javascript '),
(23, 'slug', 0, 1, ''),
(23, 'title', 0, 1, ' header '),
(24, 'alt', 0, 1, ''),
(24, 'extension', 0, 1, ' webm '),
(24, 'filename', 0, 1, ' hero home webm '),
(24, 'kind', 0, 1, ' video '),
(24, 'slug', 0, 1, ''),
(24, 'title', 0, 1, ' hero home '),
(25, 'alt', 0, 1, ''),
(25, 'extension', 0, 1, ' mp4 '),
(25, 'filename', 0, 1, ' hero home optimized mp4 '),
(25, 'kind', 0, 1, ' video '),
(25, 'slug', 0, 1, ''),
(25, 'title', 0, 1, ' hero home optimized '),
(26, 'alt', 0, 1, ''),
(26, 'extension', 0, 1, ' svg '),
(26, 'filename', 0, 1, ' safran dsi horizontal logo svg '),
(26, 'kind', 0, 1, ' image '),
(26, 'slug', 0, 1, ''),
(26, 'title', 0, 1, ' safran dsi horizontal logo '),
(27, 'alt', 0, 1, ''),
(27, 'extension', 0, 1, ' webp '),
(27, 'filename', 0, 1, ' aerosystems featured img webp '),
(27, 'kind', 0, 1, ' image '),
(27, 'slug', 0, 1, ''),
(27, 'title', 0, 1, ' aerosystems featured img '),
(28, 'alt', 0, 1, ''),
(28, 'extension', 0, 1, ' webp '),
(28, 'filename', 0, 1, ' testing and ground evaluation featured img webp '),
(28, 'kind', 0, 1, ' image '),
(28, 'slug', 0, 1, ''),
(28, 'title', 0, 1, ' testing and ground evaluation featured img '),
(29, 'alt', 0, 1, ''),
(29, 'extension', 0, 1, ' webp '),
(29, 'filename', 0, 1, ' safran dsi employee matt jordan webp '),
(29, 'kind', 0, 1, ' image '),
(29, 'slug', 0, 1, ''),
(29, 'title', 0, 1, ' safran dsi employee matt jordan '),
(30, 'alt', 0, 1, ''),
(30, 'extension', 0, 1, ' webp '),
(30, 'filename', 0, 1, ' hero join our mission webp '),
(30, 'kind', 0, 1, ' image '),
(30, 'slug', 0, 1, ''),
(30, 'title', 0, 1, ' hero join our mission '),
(31, 'alt', 0, 1, ''),
(31, 'extension', 0, 1, ' webp '),
(31, 'filename', 0, 1, ' sunset satelite webp '),
(31, 'kind', 0, 1, ' image '),
(31, 'slug', 0, 1, ''),
(31, 'title', 0, 1, ' sunset satelite '),
(32, 'alt', 0, 1, ''),
(32, 'extension', 0, 1, ' webp '),
(32, 'filename', 0, 1, ' safran dsi employee matt zylak webp '),
(32, 'kind', 0, 1, ' image '),
(32, 'slug', 0, 1, ''),
(32, 'title', 0, 1, ' safran dsi employee matt zylak '),
(33, 'alt', 0, 1, ''),
(33, 'extension', 0, 1, ' webp '),
(33, 'filename', 0, 1, ' safran dsi employee eric wilker webp '),
(33, 'kind', 0, 1, ' image '),
(33, 'slug', 0, 1, ''),
(33, 'title', 0, 1, ' safran dsi employee eric wilker '),
(34, 'alt', 0, 1, ''),
(34, 'extension', 0, 1, ' webp '),
(34, 'filename', 0, 1, ' contract with bell textron webp '),
(34, 'kind', 0, 1, ' image '),
(34, 'slug', 0, 1, ''),
(34, 'title', 0, 1, ' contract with bell textron '),
(35, 'alt', 0, 1, ''),
(35, 'extension', 0, 1, ' webp '),
(35, 'filename', 0, 1, ' safran satellite webp '),
(35, 'kind', 0, 1, ' image '),
(35, 'slug', 0, 1, ''),
(35, 'title', 0, 1, ' safran satellite '),
(36, 'alt', 0, 1, ''),
(36, 'extension', 0, 1, ' webp '),
(36, 'filename', 0, 1, ' hero leadership webp '),
(36, 'kind', 0, 1, ' image '),
(36, 'slug', 0, 1, ''),
(36, 'title', 0, 1, ' hero leadership '),
(37, 'alt', 0, 1, ''),
(37, 'extension', 0, 1, ' webp '),
(37, 'filename', 0, 1, ' safran dsi employee julien apollon webp '),
(37, 'kind', 0, 1, ' image '),
(37, 'slug', 0, 1, ''),
(37, 'title', 0, 1, ' safran dsi employee julien apollon '),
(38, 'alt', 0, 1, ''),
(38, 'extension', 0, 1, ' webp '),
(38, 'filename', 0, 1, ' hero join our mission 1920x460 webp '),
(38, 'kind', 0, 1, ' image '),
(38, 'slug', 0, 1, ''),
(38, 'title', 0, 1, ' hero join our mission 1920x460 '),
(39, 'alt', 0, 1, ''),
(39, 'extension', 0, 1, ' webp '),
(39, 'filename', 0, 1, ' power and propulsion featured img webp '),
(39, 'kind', 0, 1, ' image '),
(39, 'slug', 0, 1, ''),
(39, 'title', 0, 1, ' power and propulsion featured img '),
(40, 'alt', 0, 1, ''),
(40, 'extension', 0, 1, ' svg '),
(40, 'filename', 0, 1, ' safran dsi vertical white logo svg '),
(40, 'kind', 0, 1, ' image '),
(40, 'slug', 0, 1, ''),
(40, 'title', 0, 1, ' safran dsi vertical white logo '),
(41, 'alt', 0, 1, ''),
(41, 'extension', 0, 1, ' webp '),
(41, 'filename', 0, 1, ' safran dsi employee charles jones webp '),
(41, 'kind', 0, 1, ' image '),
(41, 'slug', 0, 1, ''),
(41, 'title', 0, 1, ' safran dsi employee charles jones '),
(42, 'alt', 0, 1, ''),
(42, 'extension', 0, 1, ' webp '),
(42, 'filename', 0, 1, ' careers at safran dsi mobile webp '),
(42, 'kind', 0, 1, ' image '),
(42, 'slug', 0, 1, ''),
(42, 'title', 0, 1, ' careers at safran dsi mobile '),
(43, 'alt', 0, 1, ''),
(43, 'extension', 0, 1, ' webp '),
(43, 'filename', 0, 1, ' careers at safran dsi desktop webp '),
(43, 'kind', 0, 1, ' image '),
(43, 'slug', 0, 1, ''),
(43, 'title', 0, 1, ' careers at safran dsi desktop '),
(44, 'alt', 0, 1, ''),
(44, 'extension', 0, 1, ' webp '),
(44, 'filename', 0, 1, ' communication systems featured img webp '),
(44, 'kind', 0, 1, ' image '),
(44, 'slug', 0, 1, ''),
(44, 'title', 0, 1, ' communication systems featured img '),
(45, 'alt', 0, 1, ''),
(45, 'extension', 0, 1, ' webp '),
(45, 'filename', 0, 1, ' safran dsi employee ben loveless webp '),
(45, 'kind', 0, 1, ' image '),
(45, 'slug', 0, 1, ''),
(45, 'title', 0, 1, ' safran dsi employee ben loveless '),
(46, 'alt', 0, 1, ''),
(46, 'extension', 0, 1, ' webp '),
(46, 'filename', 0, 1, ' safran dsi solutions bg webp '),
(46, 'kind', 0, 1, ' image '),
(46, 'slug', 0, 1, ''),
(46, 'title', 0, 1, ' safran dsi solutions bg '),
(47, 'alt', 0, 1, ''),
(47, 'extension', 0, 1, ' webp '),
(47, 'filename', 0, 1, ' power and propulsion thumbnail webp '),
(47, 'kind', 0, 1, ' image '),
(47, 'slug', 0, 1, ''),
(47, 'title', 0, 1, ' power and propulsion thumbnail '),
(48, 'alt', 0, 1, ''),
(48, 'extension', 0, 1, ' webp '),
(48, 'filename', 0, 1, ' navigation and geospatial intelligence featured img webp '),
(48, 'kind', 0, 1, ' image '),
(48, 'slug', 0, 1, ''),
(48, 'title', 0, 1, ' navigation and geospatial intelligence featured img '),
(49, 'alt', 0, 1, ''),
(49, 'extension', 0, 1, ' webp '),
(49, 'filename', 0, 1, ' safran dsi employee joseph bogosian webp '),
(49, 'kind', 0, 1, ' image '),
(49, 'slug', 0, 1, ''),
(49, 'title', 0, 1, ' safran dsi employee joseph bogosian '),
(50, 'alt', 0, 1, ''),
(50, 'extension', 0, 1, ' webp '),
(50, 'filename', 0, 1, ' safran textured surface webp '),
(50, 'kind', 0, 1, ' image '),
(50, 'slug', 0, 1, ''),
(50, 'title', 0, 1, ' safran textured surface '),
(51, 'alt', 0, 1, ''),
(51, 'extension', 0, 1, ' webp '),
(51, 'filename', 0, 1, ' safran dsi employee barbara giliberti webp '),
(51, 'kind', 0, 1, ' image '),
(51, 'slug', 0, 1, ''),
(51, 'title', 0, 1, ' safran dsi employee barbara giliberti '),
(52, 'alt', 0, 1, ''),
(52, 'extension', 0, 1, ' webp '),
(52, 'filename', 0, 1, ' eo ir and laser systems featured img webp '),
(52, 'kind', 0, 1, ' image '),
(52, 'slug', 0, 1, ''),
(52, 'title', 0, 1, ' eo ir and laser systems featured img '),
(53, 'alt', 0, 1, ''),
(53, 'extension', 0, 1, ' webp '),
(53, 'filename', 0, 1, ' safran dsi employee edward fortunato webp '),
(53, 'kind', 0, 1, ' image '),
(53, 'slug', 0, 1, ''),
(53, 'title', 0, 1, ' safran dsi employee edward fortunato '),
(54, 'alt', 0, 1, ''),
(54, 'extension', 0, 1, ' webm '),
(54, 'filename', 0, 1, ' hero home webm '),
(54, 'kind', 0, 1, ' video '),
(54, 'slug', 0, 1, ''),
(54, 'title', 0, 1, ' hero home '),
(55, 'alt', 0, 1, ''),
(55, 'extension', 0, 1, ' mp4 '),
(55, 'filename', 0, 1, ' hero home optimized mp4 '),
(55, 'kind', 0, 1, ' video '),
(55, 'slug', 0, 1, ''),
(55, 'title', 0, 1, ' hero home optimized '),
(80, 'slug', 0, 1, ' temp qwupomuowilhvnhkyojwfpezqnkkkukwgkbu '),
(80, 'title', 0, 1, ''),
(81, 'slug', 0, 1, ' solution '),
(81, 'title', 0, 1, ' our solutions '),
(87, 'alt', 0, 1, ''),
(87, 'extension', 0, 1, ' webp '),
(87, 'filename', 0, 1, ' hero our solutions webp '),
(87, 'kind', 0, 1, ' image '),
(87, 'slug', 0, 1, ''),
(87, 'title', 0, 1, ' hero our solutions '),
(99, 'field', 4, 1, ' engineered systems that drive motion and supply energy '),
(99, 'field', 6, 1, ' safran dsi delivers advanced power and propulsion solutions for modern defense platforms providing unmatched reliability efficiency and adaptability to ensure mission success we design our solutions to enable seamless integration faster upgrades and improved interoperability with both legacy and next generation platforms reducing lifecycle costs and increasing readiness our capabilities include high performance helicopter engines for platforms like the h 60 black hawk and ch 53k scalable electric and power systems supporting hybrid electric propulsion and reliable auxiliary power units apus with modular designs for easy maintenance and enhanced mission endurance '),
(99, 'field', 19, 1, ''),
(99, 'field', 20, 1, ''),
(99, 'slug', 0, 1, ' power and propulsion '),
(99, 'title', 0, 1, ' power and propulsion '),
(100, 'alt', 0, 1, ''),
(100, 'extension', 0, 1, ' webp '),
(100, 'filename', 0, 1, ' power and propulsion featured img webp '),
(100, 'kind', 0, 1, ' image '),
(100, 'slug', 0, 1, ''),
(100, 'title', 0, 1, ' power and propulsion featured img '),
(102, 'field', 4, 1, ' advanced technologies and solutions to support critical space missions '),
(102, 'field', 6, 1, ' at safran dsi we are global leaders in aerospace defense and security dedicated to delivering high tech solutions that power and protect industries worldwide innovation and sustainability drive everything we do from cutting edge propulsion systems and aircraft equipment to state of the art avionics and interiors that enhance performance and passenger comfort our expertise extends to defense technologies where we provide advanced navigation optronics and security solutions we also play a key role in space propulsion and drone systems pushing the boundaries of exploration and autonomy discover how our solutions can enhance safety efficiency and technological excellence across air land and space explore our solutions today '),
(102, 'field', 19, 1, ''),
(102, 'field', 20, 1, ''),
(102, 'slug', 0, 1, ' space solutions '),
(102, 'title', 0, 1, ' space solutions '),
(103, 'alt', 0, 1, ''),
(103, 'extension', 0, 1, ' webp '),
(103, 'filename', 0, 1, ' communication systems featured img webp '),
(103, 'kind', 0, 1, ' image '),
(103, 'slug', 0, 1, ''),
(103, 'title', 0, 1, ' communication systems featured img '),
(105, 'field', 4, 1, ' end to end testing solutions and performance analysis ensuring real time mission readiness '),
(105, 'field', 6, 1, ' safran dsi provides advanced solutions for real time data acquisition transmission and analysis to support critical defense and aerospace programs our expertise includes end to end flight test instrumentation and telemetry mission data management systems and ground based monitoring and control '),
(105, 'field', 19, 1, ''),
(105, 'field', 20, 1, ''),
(105, 'slug', 0, 1, ' testing amp ground evaluation '),
(105, 'title', 0, 1, ' testing ground evaluation '),
(106, 'alt', 0, 1, ''),
(106, 'extension', 0, 1, ' webp '),
(106, 'filename', 0, 1, ' testing and ground evaluation featured img webp '),
(106, 'kind', 0, 1, ' image '),
(106, 'slug', 0, 1, ''),
(106, 'title', 0, 1, ' testing and ground evaluation featured img '),
(108, 'field', 4, 1, ' advanced positioning navigation and geospatial technologies '),
(108, 'field', 6, 1, ' safran dsi provides secure precise and resilient navigation solutions for defense and aerospace operations our capabilities include gps gnss denied navigation inertial navigation systems ins and alternative pnt technologies that ensure mission critical positioning and timing even in contested or degraded environments leveraging advanced geospatial ai safran dsi enhances situational awareness and operational effectiveness by processing and analyzing complex geospatial data in real time our ai driven solutions enable adaptive navigation threat detection and predictive analysis to support dynamic mission requirements '),
(108, 'field', 19, 1, ''),
(108, 'field', 20, 1, ''),
(108, 'slug', 0, 1, ' navigation amp geospatial intelligence '),
(108, 'title', 0, 1, ' navigation geospatial intelligence '),
(109, 'alt', 0, 1, ''),
(109, 'extension', 0, 1, ' webp '),
(109, 'filename', 0, 1, ' navigation and geospatial intelligence featured img webp '),
(109, 'kind', 0, 1, ' image '),
(109, 'slug', 0, 1, ''),
(109, 'title', 0, 1, ' navigation and geospatial intelligence featured img '),
(111, 'field', 4, 1, ' eo ir and laser solutions for dismounted soldier airborne naval space and land vehicle operations '),
(111, 'field', 6, 1, ' safran dsi delivers advanced electro optical and infrared systems designed to enhance situational awareness targeting accuracy and operational effectiveness in the most demanding environments leveraging cutting edge technology and decades of expertise safran dsi provides a comprehensive range of solutions including high performance cameras sighting systems laser designators and targeting pods provides for land sea air and space operations '),
(111, 'field', 19, 1, ''),
(111, 'field', 20, 1, ''),
(111, 'slug', 0, 1, ' eo ir amp laser systems '),
(111, 'title', 0, 1, ' eo ir laser systems '),
(112, 'alt', 0, 1, ''),
(112, 'extension', 0, 1, ' webp '),
(112, 'filename', 0, 1, ' eo ir and laser systems featured img webp '),
(112, 'kind', 0, 1, ' image '),
(112, 'slug', 0, 1, ''),
(112, 'title', 0, 1, ' eo ir and laser systems featured img '),
(114, 'field', 4, 1, ' lorem ipsum dolor sit amet consectetur adipiscing elit cras imperdiet aliquet nisl eget mollis massa semper at '),
(114, 'field', 6, 1, ' lorem ipsum dolor sit amet consectetur adipiscing elit cras imperdiet aliquet nisl eget mollis massa semper at lorem ipsum dolor sit amet consectetur adipiscing elit cras imperdiet aliquet nisl eget mollis massa semper at lorem ipsum dolor sit amet consectetur adipiscing elit cras imperdiet aliquet nisl eget mollis massa semper at '),
(114, 'field', 19, 1, ''),
(114, 'field', 20, 1, ''),
(114, 'slug', 0, 1, ' communications systems '),
(114, 'title', 0, 1, ' communications systems '),
(115, 'alt', 0, 1, ''),
(115, 'extension', 0, 1, ' webp '),
(115, 'filename', 0, 1, ' communications systems featured img webp '),
(115, 'kind', 0, 1, ' image '),
(115, 'slug', 0, 1, ''),
(115, 'title', 0, 1, ' communications systems featured img '),
(139, 'field', 6, 1, ' at safran dsi we are global leaders in aerospace defense and security dedicated to delivering high tech solutions that power and protect industries worldwide innovation and sustainability drive everything we do from cutting edge propulsion systems and aircraft equipment to state of the art avionics and interiors that enhance performance and passenger comfort our expertise extends to defense technologies where we provide advanced navigation optronics and security solutions we also play a key role in space propulsion and drone systems pushing the boundaries of exploration and autonomy discover how our solutions can enhance safety efficiency and technological excellence across air land and space explore our solutions today '),
(139, 'field', 20, 1, ' solutions '),
(139, 'slug', 0, 1, ' solutions '),
(139, 'title', 0, 1, ' solutions '),
(149, 'slug', 0, 1, ' news '),
(149, 'title', 0, 1, ' news press releases '),
(152, 'slug', 0, 1, ' temp wcklbfhjrjufqsfgvnoonsvcfhdwqqbodbjv '),
(152, 'title', 0, 1, ''),
(154, 'slug', 0, 1, ' temp glawwjrrvvpxhnfmwolhlwavtbtthakgylxu '),
(154, 'title', 0, 1, ''),
(155, 'slug', 0, 1, ' temp iycglngoethytxxgjylzyugceqgdemocvrjt '),
(155, 'title', 0, 1, ''),
(156, 'slug', 0, 1, ' safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(156, 'title', 0, 1, ' safran dsi wins preventive maintenance contract search '),
(157, 'alt', 0, 1, ''),
(157, 'extension', 0, 1, ' webp '),
(157, 'filename', 0, 1, ' safran satellite webp '),
(157, 'kind', 0, 1, ' image '),
(157, 'slug', 0, 1, ''),
(157, 'title', 0, 1, ' safran satellite '),
(159, 'slug', 0, 1, ' 2 safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(159, 'title', 0, 1, ' 2 safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(161, 'slug', 0, 1, ' 3 safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(161, 'title', 0, 1, ' 3 safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(163, 'slug', 0, 1, ' 4 safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(163, 'title', 0, 1, ' 4 safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(173, 'slug', 0, 1, ' news '),
(173, 'title', 0, 1, ' news '),
(174, 'slug', 0, 1, ' press release '),
(174, 'title', 0, 1, ' press release '),
(189, 'slug', 0, 1, ' view jobs '),
(189, 'title', 0, 1, ' view jobs '),
(202, 'field', 6, 1, ' safran proudly holds a distinguished legacy in the united states spanning nearly five decades weve led the charge in pioneering cutting edge technologies bolstering national security and enhancing performance across varied industries key businesses including optronics space solutions testing telemetry and assured pnt epitomize our commitment to innovation and excellence this dedication has solidified our position as the preferred partner to federal state and local governments as well as armed forces and other essential stakeholders in the us market '),
(202, 'field', 19, 1, ' careers at safran dsi '),
(202, 'field', 20, 1, ' who we are what we do work at safran dsi '),
(202, 'slug', 0, 1, ' join our mission '),
(202, 'title', 0, 1, ' join our mission '),
(207, 'alt', 0, 1, ''),
(207, 'extension', 0, 1, ' webp '),
(207, 'filename', 0, 1, ' hero join our mission webp '),
(207, 'kind', 0, 1, ' image '),
(207, 'slug', 0, 1, ''),
(207, 'title', 0, 1, ' hero join our mission '),
(237, 'alt', 0, 1, ''),
(237, 'extension', 0, 1, ' webp '),
(237, 'filename', 0, 1, ' hero contract with bell textron webp '),
(237, 'kind', 0, 1, ' image '),
(237, 'slug', 0, 1, ''),
(237, 'title', 0, 1, ' hero contract with bell textron '),
(250, 'alt', 0, 1, ''),
(250, 'extension', 0, 1, ' pdf '),
(250, 'filename', 0, 1, ' blank pdf '),
(250, 'kind', 0, 1, ' pdf '),
(250, 'slug', 0, 1, ''),
(250, 'title', 0, 1, ' blank '),
(258, 'alt', 0, 1, ''),
(258, 'extension', 0, 1, ' webp '),
(258, 'filename', 0, 1, ' safran dsi work benefits webp '),
(258, 'kind', 0, 1, ' image '),
(258, 'slug', 0, 1, ''),
(258, 'title', 0, 1, ' safran dsi work benefits '),
(260, 'alt', 0, 1, ''),
(260, 'extension', 0, 1, ' webp '),
(260, 'filename', 0, 1, ' safran dsi careers where we work webp '),
(260, 'kind', 0, 1, ' image '),
(260, 'slug', 0, 1, ''),
(260, 'title', 0, 1, ' safran dsi careers where we work '),
(261, 'field', 11, 1, ' we offer a wide variety of resources and services to ensure you and your family are covered when you need it '),
(261, 'slug', 0, 1, ' benefits '),
(261, 'title', 0, 1, ' benefits '),
(262, 'field', 11, 1, ' we have offices located across the us to best serve our industry partners and employees '),
(262, 'slug', 0, 1, ' where we work '),
(262, 'title', 0, 1, ' where we work '),
(270, 'field', 6, 1, ' safran offers you a comprehensive benefit program that includes medical dental and vision plan options as well as virtual health options pre tax spending account options and life disability coverage youll also have access to a healthcare navigation partner to help you make the most of your benefits a competitive 6% 401 k match and an employer stock purchasing option with matching contributions our robust employee assistance program eap corporate discounts and supplemental insurance options provide additional support designed to offer a competitive package that prioritizes employee well being '),
(270, 'field', 19, 1, ''),
(270, 'field', 20, 1, ''),
(270, 'slug', 0, 1, ' benefits '),
(270, 'title', 0, 1, ' benefits '),
(274, 'alt', 0, 1, ''),
(274, 'extension', 0, 1, ' svg '),
(274, 'filename', 0, 1, ' safran dsi health and wellness benefit svg '),
(274, 'kind', 0, 1, ' image '),
(274, 'slug', 0, 1, ''),
(274, 'title', 0, 1, ' safran dsi health and wellness benefit '),
(275, 'field', 11, 1, ' ensuring our employees stay healthy is a top priority for us medical dental and vision insurance flexible spending and health savings accounts critical illness and accident insurance free access to betterhelp virtual therapy and neuroflow emotional wellbeing health insurance discounts for employees making efforts to improve their health safran fit earn up to $300 in amazon gift cards for completing wellness challenges access to telehealth services and an employee assistance program '),
(275, 'slug', 0, 1, ' health wellness '),
(275, 'title', 0, 1, ' health wellness '),
(280, 'alt', 0, 1, ''),
(280, 'extension', 0, 1, ' svg '),
(280, 'filename', 0, 1, ' safran dsi community and personal development benefit svg '),
(280, 'kind', 0, 1, ' image '),
(280, 'slug', 0, 1, ''),
(280, 'title', 0, 1, ' safran dsi community and personal development benefit '),
(281, 'field', 11, 1, ' we encourage our full time employees to continue their development professional development reimbursement tuition reimbursement of up to $5 250 per year 9 volunteer hours per year veteran outreach efforts stem community engagement morale and culture team '),
(281, 'slug', 0, 1, ' community personal development '),
(281, 'title', 0, 1, ' community personal development '),
(286, 'alt', 0, 1, ''),
(286, 'extension', 0, 1, ' svg '),
(286, 'filename', 0, 1, ' safran dsi work life balance benefit svg '),
(286, 'kind', 0, 1, ' image '),
(286, 'slug', 0, 1, ''),
(286, 'title', 0, 1, ' safran dsi work life balance benefit '),
(287, 'alt', 0, 1, ''),
(287, 'extension', 0, 1, ' svg '),
(287, 'filename', 0, 1, ' safran dsi financial wellness benefit svg '),
(287, 'kind', 0, 1, ' image '),
(287, 'slug', 0, 1, ''),
(287, 'title', 0, 1, ' safran dsi financial wellness benefit '),
(288, 'alt', 0, 1, ''),
(288, 'extension', 0, 1, ' svg '),
(288, 'filename', 0, 1, ' safran dsi employee recognition benefit svg '),
(288, 'kind', 0, 1, ' image '),
(288, 'slug', 0, 1, ''),
(288, 'title', 0, 1, ' safran dsi employee recognition benefit '),
(289, 'alt', 0, 1, ''),
(289, 'extension', 0, 1, ' svg '),
(289, 'filename', 0, 1, ' safran dsi family support benefit svg '),
(289, 'kind', 0, 1, ' image '),
(289, 'slug', 0, 1, ''),
(289, 'title', 0, 1, ' safran dsi family support benefit '),
(290, 'alt', 0, 1, ''),
(290, 'extension', 0, 1, ' svg '),
(290, 'filename', 0, 1, ' safran dsi extra benefits svg '),
(290, 'kind', 0, 1, ' image '),
(290, 'slug', 0, 1, ''),
(290, 'title', 0, 1, ' safran dsi extra benefits '),
(291, 'field', 11, 1, ' time for employees to rest and recharge flexible work arrangements competitive vacation time generous sick time floating holiday paid holidays paid time off for civic responsibility and bereavement '),
(291, 'slug', 0, 1, ' work life balance '),
(291, 'title', 0, 1, ' work life balance '),
(298, 'alt', 0, 1, ''),
(298, 'extension', 0, 1, ' webp '),
(298, 'filename', 0, 1, ' hero benefits webp '),
(298, 'kind', 0, 1, ' image '),
(298, 'slug', 0, 1, ''),
(298, 'title', 0, 1, ' hero benefits '),
(302, 'field', 6, 1, ' our leadership team at safran dsi combines deep industry expertise with a bold vision to drive innovation and support u s defense and security '),
(302, 'slug', 0, 1, ' leadership '),
(302, 'title', 0, 1, ' our leadership '),
(306, 'slug', 0, 1, ' joseph bogosian '),
(306, 'title', 0, 1, ' joseph bogosian '),
(313, 'field', 6, 1, ' joe bogosian is a distinguished executive with over 25 years of leadership experience across the aerospace defense technology and government sectors as the president ceo of safran defense space inc safran dsi joe is recognized for his ability to drive organizational transformation deliver significant financial results and manage complex multinational operations under his leadership safran dsi is positioned as a key partner to the us department of defense federal space and intelligence agencies and other government entities driving critical missions before joining safran joe held several prominent roles in both government and industry he served in the us department of transportation as assistant administrator for international aviation at the federal aviation administration faa where he successfully negotiated key aviation agreements on behalf of the us government he also served at the us department of commerce as deputy assistant secretary for manufacturing where he led initiatives to strengthen us manufacturing competitiveness on the global stage during his nearly 20 year tenure at safran joe has successfully led several key business units as president ceo of safran trusted 4d he oversaw post acquisition integration ensuring the delivery of resilient and assured positioning navigation and timing pnt solutions across defense and commercial markets while serving as president ceo of optics 1 inc joe successfully led the company through a significant restructuring and drove 4x revenue growth joes academic background includes a strong foundation in law international relations and business management he earned a juris doctor from the university of miami school of law where he focused on international law and litigation joe earned his bachelor of science from georgetown universitys edmund a walsh school of foreign service he also holds a georgetown university mcdonough school of business executive education certificate in international business management and a harvard business school certificate in finance for senior executives '),
(313, 'slug', 0, 1, ' joseph bogosian '),
(313, 'title', 0, 1, ' joseph bogosian '),
(314, 'alt', 0, 1, ''),
(314, 'extension', 0, 1, ' webp '),
(314, 'filename', 0, 1, ' safran dsi employee barbara giliberti webp '),
(314, 'kind', 0, 1, ' image '),
(314, 'slug', 0, 1, ''),
(314, 'title', 0, 1, ' safran dsi employee barbara giliberti '),
(315, 'alt', 0, 1, ''),
(315, 'extension', 0, 1, ' webp '),
(315, 'filename', 0, 1, ' safran dsi employee ben loveless webp '),
(315, 'kind', 0, 1, ' image '),
(315, 'slug', 0, 1, ''),
(315, 'title', 0, 1, ' safran dsi employee ben loveless '),
(316, 'alt', 0, 1, ''),
(316, 'extension', 0, 1, ' webp '),
(316, 'filename', 0, 1, ' safran dsi employee charles jones webp '),
(316, 'kind', 0, 1, ' image '),
(316, 'slug', 0, 1, ''),
(316, 'title', 0, 1, ' safran dsi employee charles jones '),
(317, 'alt', 0, 1, ''),
(317, 'extension', 0, 1, ' webp '),
(317, 'filename', 0, 1, ' safran dsi employee edward fortunato webp '),
(317, 'kind', 0, 1, ' image '),
(317, 'slug', 0, 1, ''),
(317, 'title', 0, 1, ' safran dsi employee edward fortunato '),
(318, 'alt', 0, 1, ''),
(318, 'extension', 0, 1, ' webp '),
(318, 'filename', 0, 1, ' safran dsi employee eric wilker webp '),
(318, 'kind', 0, 1, ' image '),
(318, 'slug', 0, 1, ''),
(318, 'title', 0, 1, ' safran dsi employee eric wilker '),
(319, 'alt', 0, 1, ''),
(319, 'extension', 0, 1, ' webp '),
(319, 'filename', 0, 1, ' safran dsi employee joseph bogosian webp '),
(319, 'kind', 0, 1, ' image '),
(319, 'slug', 0, 1, ''),
(319, 'title', 0, 1, ' safran dsi employee joseph bogosian '),
(320, 'alt', 0, 1, ''),
(320, 'extension', 0, 1, ' webp '),
(320, 'filename', 0, 1, ' safran dsi employee julien apollon webp '),
(320, 'kind', 0, 1, ' image '),
(320, 'slug', 0, 1, ''),
(320, 'title', 0, 1, ' safran dsi employee julien apollon '),
(321, 'alt', 0, 1, ''),
(321, 'extension', 0, 1, ' webp '),
(321, 'filename', 0, 1, ' safran dsi employee matt jordan webp '),
(321, 'kind', 0, 1, ' image '),
(321, 'slug', 0, 1, ''),
(321, 'title', 0, 1, ' safran dsi employee matt jordan '),
(322, 'alt', 0, 1, ''),
(322, 'extension', 0, 1, ' webp '),
(322, 'filename', 0, 1, ' safran dsi employee matt zylak webp '),
(322, 'kind', 0, 1, ' image '),
(322, 'slug', 0, 1, ''),
(322, 'title', 0, 1, ' safran dsi employee matt zylak '),
(326, 'alt', 0, 1, ''),
(326, 'extension', 0, 1, ' webp '),
(326, 'filename', 0, 1, ' hero leadership webp '),
(326, 'kind', 0, 1, ' image '),
(326, 'slug', 0, 1, ''),
(326, 'title', 0, 1, ' hero leadership '),
(337, 'field', 6, 1, ' julien apollon is the general counsel and corporate secretary of safran defense space inc safran dsi overseeing legal compliance and corporate transactions with over a decade of experience in ma cross border transactions and regulatory compliance he plays a pivotal role in shaping legal strategy ensuring regulatory compliance and driving corporate growth through strategic ma and corporate ventures initiatives prior to joining safran dsi julien served as legal counsel at vectronix inc during its merger with optics 1 inc where he played a critical role in post merger integrations and corporate structuring he also practiced law at skadden arps slate meagher flom llp and mayer brown llp advising multinational corporations on high value ma transactions securities offerings and regulatory matters julien is fluent in english french and portuguese enabling him to navigate complex international transactions and regulatory frameworks he also teaches legal and business issues in initial public offerings as an adjunct professor at the university of miami school of law julien holds a juris doctor from the university of miami school of law and a bachelor of science in foreign service from georgetown universitys edmund a walsh school of foreign service '),
(337, 'slug', 0, 1, ' julien apollon '),
(337, 'title', 0, 1, ' julien apollon '),
(341, 'field', 6, 1, ' barbara giliberti is advisor to the ceo at safran defense space inc safran dsi where she provides advice and counsel to the ceo and the board of directors on a wide range of issues particularly relating to ssa compliance and foci issues corporate governance and employment issues before safran dsi was established in may 2024 barbara was general counsel and vice president compliance at optics 1 inc where she was responsible for all legal affairs of the company and for oversight and management of human resources contracts export compliance trade compliance facility security information security and compliance with the companys special security agreement she also served as the secretary of the company barbara has spent the majority of her career focusing on employment matters and corporate governance in both public and private companies with annual revenues ranging from $6m to $1b barbara holds a ba in broadcast journalism from american university and a jd from washington college of law she has served as a board member and in multiple officer roles in the national capital region chapter of the association of corporate counsel '),
(341, 'slug', 0, 1, ' barbara giliberti '),
(341, 'title', 0, 1, ' barbara giliberti '),
(343, 'field', 6, 1, ' ed fortunato is the executive vice president of business development at safran defense space inc safran dsi where he leads strategy and growth initiatives across the defense and space portfolios before joining safran dsi ed held senior leadership positions at top defense companies at lockheed martin he served as vice president of enterprise operations overseeing all army aviation programs and mission systems from washington d c and driving strategic initiatives for global business growth previously ed led government relations at raytheon corporation where he managed relationships with congress state and local governments and industry associations his efforts resulted in $3 billion in annual revenue growth a 37% increase in shareholder value and helped facilitate raytheons merger with united technologies ed also served as senior vice president at orbital atk where he directed washington operations for defense nasa and international strategies under his leadership the company achieved $2 billion in revenue growth secured $7 billion in annual appropriations and delivered a 120% return in shareholder value earlier in his career at honeywell ed managed aerospace programs and government relations including leading a joint venture with pratt whitney for the improved turbine engine program a former u s army aviation and acquisition officer ed served as the secretary of the armys representative to congress for aviation programs and played a key role in shaping legislative strategies for national defense bills he was a combat leader during operation desert shield storm earning the bronze star medal ed holds an mba with honors from george washington university and a bs in business from george mason university he serves on the board of directors for the national defense industrial association and the george mason university business school advisory board ed is a commercial rated aviator competitive sculler and actively involved in charitable organizations '),
(343, 'slug', 0, 1, ' edward fortunato '),
(343, 'title', 0, 1, ' edward fortunato '),
(345, 'slug', 0, 1, ' charles jones '),
(345, 'title', 0, 1, ' charles jones '),
(348, 'field', 6, 1, ' charles jones serves as the head of marketing communications at safran defense space inc where he leads strategic communication and branding initiatives to support the companys defense and aerospace operations a former journalist with experience in television news charles brings over two decades of expertise in media relations strategic counsel executive communications and crisis management he holds a bachelors degree in journalism from the university of south carolina his career includes leadership roles at safran major law firms pharmaceutical companies and government agencies where he developed a strong reputation for navigating complex issues and delivering impactful messaging across global markets '),
(348, 'slug', 0, 1, ' charles jones 2 '),
(348, 'title', 0, 1, ' charles jones '),
(351, 'field', 6, 1, ' matt jordan is a strategic hr leader with a proven track record of driving talent initiatives that build high performing engaged workforces aligned with business objectives with extensive experience in human resources leadership across the aerospace defense and manufacturing sectors matt specializes in shaping organizational culture enhancing employee engagement and implementing leadership development programs as vice president of human resources at safran defense space inc safran dsi matt is a key member of the executive leadership team responsible for developing and executing strategic hr policies talent management strategies and organizational initiatives that foster a high performance culture he played a leadership role in the formation of safran dsi ensuring seamless business continuity and long term operational success previously matt served as director of human resources at optics 1 inc where he implemented strategic hr initiatives that significantly improved talent acquisition and employee engagement his expertise spans compliance risk mitigation succession planning and hr technology implementations including leading the rollout of learning management systems and structured compensation frameworks with over two decades of hr leadership experience including roles at stonyfield farm and public consulting group matt has a deep understanding of performance management organizational development and talent acquisition he is a results driven executive dedicated to building strong people first organizations that drive business success matt holds a bachelor of science in human resources management from bridgewater state university and is an active member of the hr community '),
(351, 'slug', 0, 1, ' matt jordan '),
(351, 'title', 0, 1, ' matt jordan '),
(353, 'field', 6, 1, ' ben holds the position of vice president of information security at safran defense space inc previously serving as senior director of information systems at optics 1 inc '),
(353, 'slug', 0, 1, ' ben loveless '),
(353, 'title', 0, 1, ' ben loveless '),
(355, 'field', 6, 1, ' eric serves as chief financial officer for safran defense space inc he was the co founder of fbrc ai an ai driven entertainment company and managed wilker media group as president previously eric held senior roles at amazon imdb and warnermedia '),
(355, 'slug', 0, 1, ' eric wilker '),
(355, 'title', 0, 1, ' eric wilker '),
(357, 'field', 6, 1, ' matt is the corporate vice president of finance at safran defense space inc with over a decade of experience in finance matt most recently served as chief financial officer and controller at optics 1 inc as well as various financial positions at safran vectronix inc '),
(357, 'slug', 0, 1, ' matt zylak '),
(357, 'title', 0, 1, ' matt zylak '),
(366, 'slug', 0, 1, ' financial wellness '),
(366, 'title', 0, 1, ' financial wellness '),
(373, 'field', 11, 1, ' at safran dsi our compensation strategy allows us to attract motivate and retain employees competitive pay 401k plan with up to 6% company match employee stock purchase program 401k and financial planning education employee referral program bonuses of up to $3500 if a referred candidate for an approved position is hired '),
(373, 'slug', 0, 1, ' financial wellness '),
(373, 'title', 0, 1, ' financial wellness '),
(380, 'field', 11, 1, ' we have a variety of programs to recognize our employees service awards given to employees who complete 5 10 15 20 years of service high 5 award employees nominate each other for accomplishments above and beyond their job responsibilities spot bonus award managers and the leadership team can recognize employees for exemplary performance on a variety of tasks such as saving the company a substantial amount of money or completing a crucial project with a tough deadline '),
(380, 'slug', 0, 1, ' employee recognition '),
(380, 'title', 0, 1, ' employee recognition '),
(381, 'field', 11, 1, ' we support our employees and their families employer paid short term disability paid parental leave pet insurance survivor income benefit flexible working environment '),
(381, 'slug', 0, 1, ' family support '),
(381, 'title', 0, 1, ' family support '),
(382, 'field', 11, 1, ' some locations may offer these fun extras monthly friday breakfasts frequent employee morale events fresh vending options corporate discounts monthly cupcake birthday celebrations on site fitness center '),
(382, 'slug', 0, 1, ' extras '),
(382, 'title', 0, 1, ' extras '),
(387, 'field', 6, 1, ' safran dsis business units are the driving force behind our success we provide comprehensive cutting edge solutions across the defense and aerospace sectors equipping our customers with the latest advancements to maintain a decisive edge in every mission our interconnected businesses work seamlessly together combining expertise and innovation to create cutting edge technology that strengthens our forces and secures our future as our growing portfolio expands we continue to push the boundaries of whats possible from advanced avionics and defense systems to secure communications and next generation propulsion we are committed to developing open modular and scalable solutions that enhance interoperability and adaptability every solution we deliver reflects our dedication to excellence adaptability and evolving mission based technology to protect those who serve '),
(387, 'field', 20, 1, ''),
(387, 'slug', 0, 1, ' business units '),
(387, 'title', 0, 1, ' business units '),
(389, 'alt', 0, 1, ''),
(389, 'extension', 0, 1, ' webp '),
(389, 'filename', 0, 1, ' hero business units webp '),
(389, 'kind', 0, 1, ' image '),
(389, 'slug', 0, 1, ''),
(389, 'title', 0, 1, ' hero business units '),
(390, 'alt', 0, 1, ''),
(390, 'extension', 0, 1, ' svg '),
(390, 'filename', 0, 1, ' safran dsi business units svg '),
(390, 'kind', 0, 1, ' image '),
(390, 'slug', 0, 1, ''),
(390, 'title', 0, 1, ' safran dsi business units '),
(394, 'slug', 0, 1, ' temp tguiavhamqnlpyggqzyfwvahogowkvjyibfu '),
(394, 'title', 0, 1, ''),
(401, 'slug', 0, 1, ' temp hcbxqkzlwzyhdrjiyruyheajipzzbflkcvri '),
(401, 'title', 0, 1, ''),
(404, 'alt', 0, 1, ''),
(404, 'extension', 0, 1, ' webp '),
(404, 'filename', 0, 1, ' safran dsi business unit apnt webp '),
(404, 'kind', 0, 1, ' image '),
(404, 'slug', 0, 1, ''),
(404, 'title', 0, 1, ' safran dsi business unit apnt '),
(405, 'alt', 0, 1, ''),
(405, 'extension', 0, 1, ' webp '),
(405, 'filename', 0, 1, ' safran dsi business unit corporate headquarters webp '),
(405, 'kind', 0, 1, ' image '),
(405, 'slug', 0, 1, ''),
(405, 'title', 0, 1, ' safran dsi business unit corporate headquarters '),
(406, 'alt', 0, 1, ''),
(406, 'extension', 0, 1, ' webp '),
(406, 'filename', 0, 1, ' safran dsi business unit electric and power webp '),
(406, 'kind', 0, 1, ' image '),
(406, 'slug', 0, 1, ''),
(406, 'title', 0, 1, ' safran dsi business unit electric and power '),
(407, 'alt', 0, 1, ''),
(407, 'extension', 0, 1, ' webp '),
(407, 'filename', 0, 1, ' safran dsi business unit geo ai webp '),
(407, 'kind', 0, 1, ' image '),
(407, 'slug', 0, 1, ''),
(407, 'title', 0, 1, ' safran dsi business unit geo ai '),
(408, 'alt', 0, 1, ''),
(408, 'extension', 0, 1, ' webp '),
(408, 'filename', 0, 1, ' safran dsi business unit helicopter engines webp '),
(408, 'kind', 0, 1, ' image '),
(408, 'slug', 0, 1, ''),
(408, 'title', 0, 1, ' safran dsi business unit helicopter engines '),
(409, 'alt', 0, 1, ''),
(409, 'extension', 0, 1, ' webp '),
(409, 'filename', 0, 1, ' safran dsi business unit optronics webp '),
(409, 'kind', 0, 1, ' image '),
(409, 'slug', 0, 1, ''),
(409, 'title', 0, 1, ' safran dsi business unit optronics '),
(410, 'alt', 0, 1, ''),
(410, 'extension', 0, 1, ' webp '),
(410, 'filename', 0, 1, ' safran dsi business unit power and propulsion webp '),
(410, 'kind', 0, 1, ' image '),
(410, 'slug', 0, 1, ''),
(410, 'title', 0, 1, ' safran dsi business unit power and propulsion '),
(411, 'alt', 0, 1, ''),
(411, 'extension', 0, 1, ' webp '),
(411, 'filename', 0, 1, ' safran dsi business unit space solutions webp '),
(411, 'kind', 0, 1, ' image '),
(411, 'slug', 0, 1, ''),
(411, 'title', 0, 1, ' safran dsi business unit space solutions '),
(412, 'alt', 0, 1, ''),
(412, 'extension', 0, 1, ' webp '),
(412, 'filename', 0, 1, ' safran dsi business unit testing and telemetry webp '),
(412, 'kind', 0, 1, ' image '),
(412, 'slug', 0, 1, ''),
(412, 'title', 0, 1, ' safran dsi business unit testing and telemetry '),
(413, 'alt', 0, 1, ''),
(413, 'extension', 0, 1, ' webp '),
(413, 'filename', 0, 1, ' safran dsi careers where we work 2025 03 25 114842 ofbe webp '),
(413, 'kind', 0, 1, ' image '),
(413, 'slug', 0, 1, ''),
(413, 'title', 0, 1, ' safran dsi careers where we work '),
(417, 'field', 30, 1, ' 4501 fairfax drive arlington virginia 22203 '),
(417, 'slug', 0, 1, ' corporate headquarters '),
(417, 'title', 0, 1, ' corporate headquarters '),
(458, 'field', 30, 1, ' 320 n goodman st 101 rochester new york 14607 '),
(458, 'slug', 0, 1, ' apnt '),
(458, 'title', 0, 1, ' apnt '),
(464, 'field', 30, 1, ' 3790 russell newman blvd denton texas 76208 2936 '),
(464, 'slug', 0, 1, ' electric power '),
(464, 'title', 0, 1, ' electric power '),
(465, 'field', 30, 1, ' 4501 fairfax drive arlington virginia 22203 '),
(465, 'slug', 0, 1, ' geo ai '),
(465, 'title', 0, 1, ' geo ai '),
(475, 'field', 30, 1, ' 2709 north forum drive grand prairie texas 75052 7027 '),
(475, 'slug', 0, 1, ' helicopter engines '),
(475, 'title', 0, 1, ' helicopter engines '),
(476, 'field', 30, 1, ' 2 cooper lane bedford new hampshire 03110 '),
(476, 'slug', 0, 1, ' optronics '),
(476, 'title', 0, 1, ' optronics '),
(477, 'field', 30, 1, ' 8380 darrow road twinsburg ohio 44087 2329 '),
(477, 'slug', 0, 1, ' power propulsion '),
(477, 'title', 0, 1, ' power propulsion '),
(478, 'field', 30, 1, ' 15020 compark blvd suite 110 englewood colorado 80112 '),
(478, 'slug', 0, 1, ' space solutions '),
(478, 'title', 0, 1, ' space solutions '),
(479, 'field', 30, 1, ' 3005 business park drive norcross georgia 30071 '),
(479, 'slug', 0, 1, ' testing telemetry '),
(479, 'title', 0, 1, ' testing telemetry '),
(516, 'field', 4, 1, ' advanced propulsion systems integrating pps hall effect plasma thrusters fluid management systems and electronic power processing units '),
(516, 'field', 6, 1, ' safran dsi offers comprehensive satellite propulsion systems featuring a diverse range of plasma thrusters fluid management systems and electronic power processing units ppu to enhance the sustainability of satellites and spacecraft '),
(516, 'field', 19, 1, ''),
(516, 'field', 20, 1, ''),
(516, 'slug', 0, 1, ' satellite propulsion systems '),
(516, 'title', 0, 1, ' satellite propulsion systems '),
(524, 'field', 4, 1, ''),
(524, 'field', 6, 1, ' the pps x00 plasma thruster hall effect takes benefit of safrans long experience with electric propulsion to propose a very efficient product pps x00 was designed to address the specific requirements inherent in the new space market environment with a lifespan exceeding 5 000 hours and very high specific impulse the pps x00 is an extremely versatile thruster making it ideal for all types of applications in its core market low earth orbit leo the major advantages of the pps x00 are its high life time capability for this power range and its excellent thrust to electrical power ratio which enable reducing operating time or the number of thrusters needed several innovations have been incorporated in the discharge chamber and magnetic circuit designs to propose competitive and reliable solutions while keeping a high performance level it can be delivered as part of an electric propulsion subsystem including power processing unit and propellant management system '),
(524, 'field', 19, 1, ' hall effect thruster '),
(524, 'field', 20, 1, ' very high performance our associated solutions '),
(524, 'slug', 0, 1, ' pps x00 '),
(524, 'title', 0, 1, ' pps x00 '),
(526, 'field', 4, 1, ''),
(526, 'field', 6, 1, ''),
(526, 'field', 19, 1, ''),
(526, 'field', 20, 1, ''),
(526, 'slug', 0, 1, ' pps 1350 '),
(526, 'title', 0, 1, ' pps 1350 '),
(528, 'field', 4, 1, ''),
(528, 'field', 6, 1, ''),
(528, 'field', 19, 1, ''),
(528, 'field', 20, 1, ''),
(528, 'slug', 0, 1, ' pps 5000 '),
(528, 'title', 0, 1, ' pps 5000 '),
(531, 'slug', 0, 1, ' temp grwsnoewjskafpxvubzuliknuxxmhruxqlzz '),
(531, 'title', 0, 1, ''),
(538, 'field', 11, 1, ' turboshaft engines for commercial and military helicopters '),
(538, 'slug', 0, 1, ' helicopter engines '),
(538, 'title', 0, 1, ' helicopter engines '),
(539, 'field', 11, 1, ' equipment electrification for electric and hybrid propulsion '),
(539, 'slug', 0, 1, ' electric power '),
(539, 'title', 0, 1, ' electric power '),
(540, 'slug', 0, 1, ' power units '),
(540, 'title', 0, 1, ' power units '),
(578, 'field', 11, 1, ' specialized design and manufacturing of auxiliary power units '),
(578, 'slug', 0, 1, ' power units '),
(578, 'title', 0, 1, ' power units '),
(587, 'slug', 0, 1, ' xyz '),
(587, 'title', 0, 1, ' xyz '),
(590, 'slug', 0, 1, ' xyz '),
(590, 'title', 0, 1, ' xyz '),
(603, 'field', 11, 1, ''),
(603, 'slug', 0, 1, ' satellite propulsion systems '),
(603, 'title', 0, 1, ' satellite propulsion systems '),
(608, 'field', 11, 1, ''),
(608, 'slug', 0, 1, ' pps x00 '),
(608, 'title', 0, 1, ' pps x00 '),
(624, 'alt', 0, 1, ''),
(624, 'extension', 0, 1, ' webp '),
(624, 'filename', 0, 1, ' safran dsi pps x00 main photo webp '),
(624, 'kind', 0, 1, ' image '),
(624, 'slug', 0, 1, ''),
(624, 'title', 0, 1, ' safran dsi pps x00 main photo '),
(625, 'alt', 0, 1, ''),
(625, 'extension', 0, 1, ' webp '),
(625, 'filename', 0, 1, ' hero safran dsi product pps x00 webp '),
(625, 'kind', 0, 1, ' image '),
(625, 'slug', 0, 1, ''),
(625, 'title', 0, 1, ' hero safran dsi product pps x00 '),
(633, 'field', 41, 1, ' 200 to 1 000 w '),
(633, 'slug', 0, 1, ' wide range power '),
(633, 'title', 0, 1, ' wide range power '),
(640, 'field', 41, 1, ' xenon also compatible with krypton '),
(640, 'slug', 0, 1, ' fuel compatibility '),
(640, 'title', 0, 1, ' fuel compatibility '),
(641, 'field', 41, 1, ''),
(641, 'slug', 0, 1, ' high total impulse reliability level '),
(641, 'title', 0, 1, ' high total impulse reliability level '),
(657, 'slug', 0, 1, ' temp tcclvhewumrqdptpqztmcrudappsgyyuworv '),
(657, 'title', 0, 1, ''),
(659, 'slug', 0, 1, ' temp eolvrxlnznolhjvtobjwlzsmdvpbppyruxaf '),
(659, 'title', 0, 1, ''),
(666, 'alt', 0, 1, ''),
(666, 'extension', 0, 1, ' webp '),
(666, 'filename', 0, 1, ' safran dsi pps x00 thumbnail webp '),
(666, 'kind', 0, 1, ' image '),
(666, 'slug', 0, 1, ''),
(666, 'title', 0, 1, ' safran dsi pps x00 thumbnail '),
(667, 'alt', 0, 1, ''),
(667, 'extension', 0, 1, ' webp '),
(667, 'filename', 0, 1, ' safran dsi pps x00 main photo 2025 04 02 110908 hkhv webp '),
(667, 'kind', 0, 1, ' image '),
(667, 'slug', 0, 1, ''),
(667, 'title', 0, 1, ' safran dsi pps x00 main photo '),
(668, 'alt', 0, 1, ''),
(668, 'extension', 0, 1, ' webp '),
(668, 'filename', 0, 1, ' safran dsi pps x00 main photo 2025 04 02 110954 vzvw webp '),
(668, 'kind', 0, 1, ' image '),
(668, 'slug', 0, 1, ''),
(668, 'title', 0, 1, ' safran dsi pps x00 main photo '),
(669, 'alt', 0, 1, ''),
(669, 'extension', 0, 1, ' webp '),
(669, 'filename', 0, 1, ' safran dsi pps x00 thumbnail 2025 04 02 110955 kzuj webp '),
(669, 'kind', 0, 1, ' image '),
(669, 'slug', 0, 1, ''),
(669, 'title', 0, 1, ' safran dsi pps x00 thumbnail '),
(670, 'alt', 0, 1, ''),
(670, 'extension', 0, 1, ' webp '),
(670, 'filename', 0, 1, ' safran dsi pps x00 video thumbnail webp '),
(670, 'kind', 0, 1, ' image '),
(670, 'slug', 0, 1, ''),
(670, 'title', 0, 1, ' safran dsi pps x00 video thumbnail '),
(672, 'slug', 0, 1, ' slide 1 '),
(672, 'title', 0, 1, ' slide 1 '),
(676, 'slug', 0, 1, ' temp pkysvgbdshfhakwhotmlvuqnndpzihmayhjy ');
INSERT INTO `searchindex` (`elementId`, `attribute`, `fieldId`, `siteId`, `keywords`) VALUES
(676, 'title', 0, 1, ''),
(678, 'slug', 0, 1, ' temp rxfambeyqsizvtiraokfdieukevlrqinvueo '),
(678, 'title', 0, 1, ''),
(681, 'alt', 0, 1, ''),
(681, 'extension', 0, 1, ' webp '),
(681, 'filename', 0, 1, ' safran dsi product pps x00 thumb webp '),
(681, 'kind', 0, 1, ' image '),
(681, 'slug', 0, 1, ''),
(681, 'title', 0, 1, ' safran dsi product pps x00 thumb '),
(682, 'slug', 0, 1, ' slide 2 '),
(682, 'title', 0, 1, ' slide 2 '),
(685, 'alt', 0, 1, ''),
(685, 'extension', 0, 1, ' webp '),
(685, 'filename', 0, 1, ' safran dsi business unit helicopter engines 2025 04 02 131854 yiun webp '),
(685, 'kind', 0, 1, ' image '),
(685, 'slug', 0, 1, ''),
(685, 'title', 0, 1, ' safran dsi business unit helicopter engines '),
(711, 'alt', 0, 1, ''),
(711, 'extension', 0, 1, ' webp '),
(711, 'filename', 0, 1, ' safran dsi testing telemetry webp '),
(711, 'kind', 0, 1, ' image '),
(711, 'slug', 0, 1, ''),
(711, 'title', 0, 1, ' safran dsi testing telemetry '),
(712, 'field', 11, 1, ' end to end flight test instrumentation aircraft data management tracking telemetry antennas and on the ground data collection and analysis solutions '),
(712, 'slug', 0, 1, ' testing telemetry '),
(712, 'title', 0, 1, ' testing telemetry '),
(721, 'alt', 0, 1, ''),
(721, 'extension', 0, 1, ' webp '),
(721, 'filename', 0, 1, ' eo ir laser 2 webp '),
(721, 'kind', 0, 1, ' image '),
(721, 'slug', 0, 1, ''),
(721, 'title', 0, 1, ' eo ir laser 2 '),
(723, 'alt', 0, 1, ''),
(723, 'extension', 0, 1, ' webp '),
(723, 'filename', 0, 1, ' safran dsi platform solutions webp '),
(723, 'kind', 0, 1, ' image '),
(723, 'slug', 0, 1, ''),
(723, 'title', 0, 1, ' safran dsi platform solutions '),
(725, 'alt', 0, 1, ''),
(725, 'extension', 0, 1, ' webp '),
(725, 'filename', 0, 1, ' safran dsi oem custom webp '),
(725, 'kind', 0, 1, ' image '),
(725, 'slug', 0, 1, ''),
(725, 'title', 0, 1, ' safran dsi oem custom '),
(726, 'field', 11, 1, ' compact multi spectral solutions for todays warfighter '),
(726, 'slug', 0, 1, ' dismounted soldier solutions '),
(726, 'title', 0, 1, ' dismounted soldier solutions '),
(727, 'field', 11, 1, ' high performing stabilized sights for land air and sea platforms '),
(727, 'slug', 0, 1, ' platform solutions '),
(727, 'title', 0, 1, ' platform solutions '),
(728, 'field', 11, 1, ' solutions for system integrators to fulfill mission requirements '),
(728, 'slug', 0, 1, ' oem modules custom solutions '),
(728, 'title', 0, 1, ' oem modules custom solutions '),
(734, 'alt', 0, 1, ''),
(734, 'extension', 0, 1, ' webp '),
(734, 'filename', 0, 1, ' safran dsi dismounted soldier webp '),
(734, 'kind', 0, 1, ' image '),
(734, 'slug', 0, 1, ''),
(734, 'title', 0, 1, ' safran dsi dismounted soldier '),
(739, 'field', 4, 1, ' designed to deliver reliable mission ready solutions that support aircrews passengers and medical applications on aircraft '),
(739, 'field', 6, 1, ' safran dsi is a leading provider of advanced fluid fuel and oxygen systems designed to meet the rigorous safety and performance requirements of u s military and aerospace platforms our comprehensive portfolio includes reliable solutions that support aircrews passengers and medical applications delivering reliable mission ready performance in demanding operational environments our systems are engineered to integrate seamlessly with both legacy and next generation aircraft providing unparalleled flexibility faster modernization cycles and reduced lifecycle costs whether operating in combat high altitude transport or commercial aviation our solutions are built to ensure optimal safety efficiency and interoperability '),
(739, 'field', 19, 1, ''),
(739, 'field', 20, 1, ''),
(739, 'slug', 0, 1, ' fluid fuel and oxygen systems '),
(739, 'title', 0, 1, ' fluid fuel and oxygen systems '),
(740, 'alt', 0, 1, ''),
(740, 'extension', 0, 1, ' webp '),
(740, 'filename', 0, 1, ' hero gen12 webp '),
(740, 'kind', 0, 1, ' image '),
(740, 'slug', 0, 1, ''),
(740, 'title', 0, 1, ' hero gen12 '),
(741, 'field', 11, 1, ' our crew oxygen systems provide reliable and continuous oxygen support for aircrew members integrating seamlessly with modern flight gear and protective equipment '),
(741, 'slug', 0, 1, ' crew oxygen systems '),
(741, 'title', 0, 1, ' crew oxygen systems '),
(742, 'alt', 0, 1, ''),
(742, 'extension', 0, 1, ' webp '),
(742, 'filename', 0, 1, ' crew oxygen systems webp '),
(742, 'kind', 0, 1, ' image '),
(742, 'slug', 0, 1, ''),
(742, 'title', 0, 1, ' crew oxygen systems '),
(743, 'field', 11, 1, ' safran dsis fluid management solutions are designed to ensure the accurate efficient and safe distribution of essential fluids within military and aerospace platforms '),
(743, 'slug', 0, 1, ' fluid management systems '),
(743, 'title', 0, 1, ' fluid management systems '),
(744, 'alt', 0, 1, ''),
(744, 'extension', 0, 1, ' webp '),
(744, 'filename', 0, 1, ' fluid management systems1 webp '),
(744, 'kind', 0, 1, ' image '),
(744, 'slug', 0, 1, ''),
(744, 'title', 0, 1, ' fluid management systems1 '),
(745, 'field', 11, 1, ' safran dsis fuel systems provide comprehensive fuel management including measurement gauging and inerting to optimize fuel efficiency while minimizing the risk of fuel related hazards '),
(745, 'slug', 0, 1, ' fuel systems '),
(745, 'title', 0, 1, ' fuel systems '),
(746, 'alt', 0, 1, ''),
(746, 'extension', 0, 1, ' webp '),
(746, 'filename', 0, 1, ' fuel systems webp '),
(746, 'kind', 0, 1, ' image '),
(746, 'slug', 0, 1, ''),
(746, 'title', 0, 1, ' fuel systems '),
(747, 'field', 11, 1, ' our medical oxygen systems are specifically designed for aeromedical evacuation and in flight patient care '),
(747, 'slug', 0, 1, ' medical oxygen systems '),
(747, 'title', 0, 1, ' medical oxygen systems '),
(748, 'alt', 0, 1, ''),
(748, 'extension', 0, 1, ' webp '),
(748, 'filename', 0, 1, ' medical oxygen systems webp '),
(748, 'kind', 0, 1, ' image '),
(748, 'slug', 0, 1, ''),
(748, 'title', 0, 1, ' medical oxygen systems '),
(749, 'field', 11, 1, ' providing continuous self generated oxygen for military aircrews enhancing mission endurance and reducing reliance on bottled oxygen '),
(749, 'slug', 0, 1, ' onboard oxygen generation systems obogs '),
(749, 'title', 0, 1, ' onboard oxygen generation systems obogs '),
(750, 'alt', 0, 1, ''),
(750, 'extension', 0, 1, ' webp '),
(750, 'filename', 0, 1, ' onboard oxygen generation systems webp '),
(750, 'kind', 0, 1, ' image '),
(750, 'slug', 0, 1, ''),
(750, 'title', 0, 1, ' onboard oxygen generation systems '),
(751, 'field', 11, 1, ' safran dsis passenger oxygen systems are designed for both commercial and defense platforms providing safe and reliable oxygen delivery during emergency situations '),
(751, 'slug', 0, 1, ' passenger oxygen systems '),
(751, 'title', 0, 1, ' passenger oxygen systems '),
(752, 'alt', 0, 1, ''),
(752, 'extension', 0, 1, ' webp '),
(752, 'filename', 0, 1, ' passenger oxygen webp '),
(752, 'kind', 0, 1, ' image '),
(752, 'slug', 0, 1, ''),
(752, 'title', 0, 1, ' passenger oxygen '),
(760, 'alt', 0, 1, ''),
(760, 'extension', 0, 1, ' webp '),
(760, 'filename', 0, 1, ' hero eo ir laser systems webp '),
(760, 'kind', 0, 1, ' image '),
(760, 'slug', 0, 1, ''),
(760, 'title', 0, 1, ' hero eo ir laser systems '),
(763, 'alt', 0, 1, ''),
(763, 'extension', 0, 1, ' webp '),
(763, 'filename', 0, 1, ' hero testing ground eval webp '),
(763, 'kind', 0, 1, ' image '),
(763, 'slug', 0, 1, ''),
(763, 'title', 0, 1, ' hero testing ground eval '),
(780, 'alt', 0, 1, ''),
(780, 'extension', 0, 1, ' webp '),
(780, 'filename', 0, 1, ' hero nav geo intel webp '),
(780, 'kind', 0, 1, ' image '),
(780, 'slug', 0, 1, ''),
(780, 'title', 0, 1, ' hero nav geo intel '),
(782, 'alt', 0, 1, ''),
(782, 'extension', 0, 1, ' webp '),
(782, 'filename', 0, 1, ' safran dsi apnt webp '),
(782, 'kind', 0, 1, ' image '),
(782, 'slug', 0, 1, ''),
(782, 'title', 0, 1, ' safran dsi apnt '),
(784, 'alt', 0, 1, ''),
(784, 'extension', 0, 1, ' webp '),
(784, 'filename', 0, 1, ' safran dsi custom solutions webp '),
(784, 'kind', 0, 1, ' image '),
(784, 'slug', 0, 1, ''),
(784, 'title', 0, 1, ' safran dsi custom solutions '),
(786, 'alt', 0, 1, ''),
(786, 'extension', 0, 1, ' webp '),
(786, 'filename', 0, 1, ' safran dsi gnss webp '),
(786, 'kind', 0, 1, ' image '),
(786, 'slug', 0, 1, ''),
(786, 'title', 0, 1, ' safran dsi gnss '),
(788, 'alt', 0, 1, ''),
(788, 'extension', 0, 1, ' webp '),
(788, 'filename', 0, 1, ' safran dsi inertial nav imu webp '),
(788, 'kind', 0, 1, ' image '),
(788, 'slug', 0, 1, ''),
(788, 'title', 0, 1, ' safran dsi inertial nav imu '),
(790, 'alt', 0, 1, ''),
(790, 'extension', 0, 1, ' webp '),
(790, 'filename', 0, 1, ' safran dsi nav war webp '),
(790, 'kind', 0, 1, ' image '),
(790, 'slug', 0, 1, ''),
(790, 'title', 0, 1, ' safran dsi nav war '),
(791, 'field', 11, 1, ' secure precise and resilient navigation solutions for defense and aerospace operations '),
(791, 'slug', 0, 1, ' assured pnt '),
(791, 'title', 0, 1, ' assured pnt '),
(792, 'field', 11, 1, ' open architecture approach to fulfill mission requirements '),
(792, 'slug', 0, 1, ' custom solutions '),
(792, 'title', 0, 1, ' custom solutions '),
(793, 'field', 11, 1, ' powerful scenario based testing and simulation solutions for mission critical results '),
(793, 'slug', 0, 1, ' gnss testing simulation '),
(793, 'title', 0, 1, ' gnss testing simulation '),
(794, 'field', 11, 1, ' revolutionary performance and reliability over existing technologies for applications across all domains '),
(794, 'slug', 0, 1, ' inertial navigation imus '),
(794, 'title', 0, 1, ' inertial navigation imus '),
(795, 'field', 11, 1, ' tools to confidently assure or deny access to pnt data in challenging conditions '),
(795, 'slug', 0, 1, ' navigation warfare '),
(795, 'title', 0, 1, ' navigation warfare '),
(803, 'alt', 0, 1, ''),
(803, 'extension', 0, 1, ' webp '),
(803, 'filename', 0, 1, ' hero power propulsion webp '),
(803, 'kind', 0, 1, ' image '),
(803, 'slug', 0, 1, ''),
(803, 'title', 0, 1, ' hero power propulsion '),
(811, 'alt', 0, 1, ''),
(811, 'extension', 0, 1, ' webp '),
(811, 'filename', 0, 1, ' hero join our mission 2025 04 03 080155 vuma webp '),
(811, 'kind', 0, 1, ' image '),
(811, 'slug', 0, 1, ''),
(811, 'title', 0, 1, ' hero join our mission '),
(815, 'alt', 0, 1, ''),
(815, 'extension', 0, 1, ' webp '),
(815, 'filename', 0, 1, ' safran dsi space radios webp '),
(815, 'kind', 0, 1, ' image '),
(815, 'slug', 0, 1, ''),
(815, 'title', 0, 1, ' safran dsi space radios '),
(817, 'alt', 0, 1, ''),
(817, 'extension', 0, 1, ' webp '),
(817, 'filename', 0, 1, ' safran dsi satellite ground stations modems 2 webp '),
(817, 'kind', 0, 1, ' image '),
(817, 'slug', 0, 1, ''),
(817, 'title', 0, 1, ' safran dsi satellite ground stations modems 2 '),
(821, 'alt', 0, 1, ''),
(821, 'extension', 0, 1, ' webp '),
(821, 'filename', 0, 1, ' safran dsi space ground aware webp '),
(821, 'kind', 0, 1, ' image '),
(821, 'slug', 0, 1, ''),
(821, 'title', 0, 1, ' safran dsi space ground aware '),
(823, 'alt', 0, 1, ''),
(823, 'extension', 0, 1, ' webp '),
(823, 'filename', 0, 1, ' safran dsi space optics 2 webp '),
(823, 'kind', 0, 1, ' image '),
(823, 'slug', 0, 1, ''),
(823, 'title', 0, 1, ' safran dsi space optics 2 '),
(824, 'field', 11, 1, ' radio communication equipment for small satellite platforms mini micro nano cube satellites in low earth orbit '),
(824, 'slug', 0, 1, ' on board radios '),
(824, 'title', 0, 1, ' on board radios '),
(825, 'field', 11, 1, ' ground antennas and cortex modems for earth observation scientific missions small satellites constellations and deep space applications '),
(825, 'slug', 0, 1, ' satellite ground stations modems '),
(825, 'title', 0, 1, ' satellite ground stations modems '),
(826, 'field', 11, 1, ' solutions to contribute to a peaceful and cooperative management of space and srt applications '),
(826, 'slug', 0, 1, ' space ground domain awareness '),
(826, 'title', 0, 1, ' space ground domain awareness '),
(827, 'field', 11, 1, ' optomechanical components for astronomy space defense and laser industry '),
(827, 'slug', 0, 1, ' space optics '),
(827, 'title', 0, 1, ' space optics '),
(835, 'alt', 0, 1, ''),
(835, 'extension', 0, 1, ' webp '),
(835, 'filename', 0, 1, ' hero space webp '),
(835, 'kind', 0, 1, ' image '),
(835, 'slug', 0, 1, ''),
(835, 'title', 0, 1, ' hero space '),
(845, 'alt', 0, 1, ''),
(845, 'extension', 0, 1, ' webp '),
(845, 'filename', 0, 1, ' safran dsi business unit testing and telemetry 2025 04 03 082310 iwud webp '),
(845, 'kind', 0, 1, ' image '),
(845, 'slug', 0, 1, ''),
(845, 'title', 0, 1, ' safran dsi business unit testing and telemetry '),
(862, 'alt', 0, 1, ''),
(862, 'extension', 0, 1, ' webp '),
(862, 'filename', 0, 1, ' safran dsi satellite propulsion webp '),
(862, 'kind', 0, 1, ' image '),
(862, 'slug', 0, 1, ''),
(862, 'title', 0, 1, ' safran dsi satellite propulsion '),
(864, 'alt', 0, 1, ''),
(864, 'extension', 0, 1, ' webp '),
(864, 'filename', 0, 1, ' hero satellite propulsion systems webp '),
(864, 'kind', 0, 1, ' image '),
(864, 'slug', 0, 1, ''),
(864, 'title', 0, 1, ' hero satellite propulsion systems '),
(867, 'field', 4, 1, ' the eps x00 plasma thruster hall effect takes benefit of safrans long experience with electric propulsion to propose a very efficient product '),
(867, 'field', 6, 1, ' the eps x00 plasma thruster hall effect takes benefit of safrans long experience with electric propulsion to propose a very efficient product eps x00 was designed to address the specific requirements inherent in the new space market environment with a lifespan exceeding 5 000 hours and very high specific impulse the eps x00 is an extremely versatile thruster making it ideal for all types of applications in its core market low earth orbit leo the major advantages of the eps x00 are its high life time capability for this power range and its excellent thrust to electrical power ratio which enable reducing operating time or the number of thrusters needed several innovations have been incorporated in the discharge chamber and magnetic circuit designs to propose competitive and reliable solutions while keeping a high performance level it can be delivered as part of an electric propulsion subsystem including power processing unit and propellant management system '),
(867, 'field', 19, 1, ' hall effect thruster '),
(867, 'field', 20, 1, ' very high performance our associated solutions '),
(867, 'slug', 0, 1, ' eps x00 '),
(867, 'title', 0, 1, ' eps x00 '),
(868, 'alt', 0, 1, ''),
(868, 'extension', 0, 1, ' webp '),
(868, 'filename', 0, 1, ' hero safran dsi product pps x00 2025 04 03 102953 ioey webp '),
(868, 'kind', 0, 1, ' image '),
(868, 'slug', 0, 1, ''),
(868, 'title', 0, 1, ' hero safran dsi product pps x00 '),
(869, 'alt', 0, 1, ''),
(869, 'extension', 0, 1, ' webp '),
(869, 'filename', 0, 1, ' safran dsi ppsx00 webp '),
(869, 'kind', 0, 1, ' image '),
(869, 'slug', 0, 1, ''),
(869, 'title', 0, 1, ' safran dsi ppsx00 '),
(870, 'field', 41, 1, ' 200 to 1 000 w '),
(870, 'slug', 0, 1, ' wide range power '),
(870, 'title', 0, 1, ' wide range power '),
(871, 'field', 41, 1, ' xenon also compatible with krypton '),
(871, 'slug', 0, 1, ' fuel compatibility '),
(871, 'title', 0, 1, ' fuel compatibility '),
(872, 'field', 41, 1, ''),
(872, 'slug', 0, 1, ' high total impulse reliability level '),
(872, 'title', 0, 1, ' high total impulse reliability level '),
(880, 'field', 4, 1, ' the eps 1350 hall effect plasma thruster draws on safrans long experience with electric propulsion '),
(880, 'field', 6, 1, ' the eps 1350 hall effect plasma thruster draws on safrans long experience with electric propulsion it is designed for orbital transfer station keeping and deorbiting satellites and other spacecraft in particular the eps 1350 was the primary engine on esas lunar probe smart 1 launched in 2003 by an ariane 5 rocket this mission was completed in september 2006 the major advantage of the eps 1350 is of course its very high specific impulse which allows significant weight savings versus platforms using conventional chemical propulsion it also offers an excellent thrust to electrical power ratio which enables reducing operating time or the number of thrusters needed in orbit experience the eps 1350 amply demonstrated its capabilities during esas smart 1 probes mission from earth orbit into orbit around the moon 5 000 hours cumulated operating time in space four of these thrusters handle north south station keeping duties on the alphasat satellite launched in 2013 the eps 1350 was selected by space systems loral in 2016 and will be used on the companys communications satellites for station keeping and for part of the orbit topping operation '),
(880, 'field', 19, 1, ''),
(880, 'field', 20, 1, ' very high performance our associated solutions '),
(880, 'slug', 0, 1, ' eps 1350 '),
(880, 'title', 0, 1, ' eps 1350 '),
(882, 'alt', 0, 1, ''),
(882, 'extension', 0, 1, ' webp '),
(882, 'filename', 0, 1, ' safran dsi pps x00 main photo 2025 04 03 104143 zhsc webp '),
(882, 'kind', 0, 1, ' image '),
(882, 'slug', 0, 1, ''),
(882, 'title', 0, 1, ' safran dsi pps x00 main photo '),
(884, 'alt', 0, 1, ''),
(884, 'extension', 0, 1, ' webp '),
(884, 'filename', 0, 1, ' safran eps 1350 webp '),
(884, 'kind', 0, 1, ' image '),
(884, 'slug', 0, 1, ''),
(884, 'title', 0, 1, ' safran eps 1350 '),
(885, 'alt', 0, 1, ''),
(885, 'extension', 0, 1, ' jpg '),
(885, 'filename', 0, 1, ' hero gen14 jpg '),
(885, 'kind', 0, 1, ' image '),
(885, 'slug', 0, 1, ''),
(885, 'title', 0, 1, ' hero gen14 '),
(893, 'field', 41, 1, ''),
(893, 'slug', 0, 1, ' designed for orbit topping and station keeping '),
(893, 'title', 0, 1, ' designed for orbit topping and station keeping '),
(894, 'field', 41, 1, ''),
(894, 'slug', 0, 1, ' 40 weight saving convention propulsion '),
(894, 'title', 0, 1, ' 40% weight saving convention propulsion '),
(895, 'field', 41, 1, ''),
(895, 'slug', 0, 1, ' excellent thrust to electrical power ratio '),
(895, 'title', 0, 1, ' excellent thrust to electrical power ratio '),
(904, 'field', 4, 1, ' the eps 5000 is a hall effect thruster purposely designed for all electric satellites '),
(904, 'field', 6, 1, ' the eps 5000 produced by safran spacecraft propulsion is a hall effect thruster purposely designed for all electric satellites it can operate in high thrust or high specific impulse mode and offers an operating lifespan of about 20 000 hours this means it can handle orbital positioning and station keeping duties for a wide range of telecom and navigation satellites as well as exploration spacecraft the eps 5000 was fully qualified in 2021 the major advantage of the eps 5000 is of course its very high specific impulse which allows significant weight savings versus platforms using conventional chemical propulsion it also offers an excellent thrust to electrical power ratio which enables reducing operating time or the number of thrusters needed it can be delivered as part of an electric propulsion subsystem including all thermal control functions upcoming missions the eps 5000 has been selected by airbus defence and space and thales alenia space for use on their eurostar neo and spacebus neo communications satellite platforms respectively it will handle both orbit raising and station keeping duties it has also been selected by boeing company for use in a cluster of three eps 5000 thrusters operating simultaneously for orbit raising at a power rating of 5 kw '),
(904, 'field', 19, 1, ''),
(904, 'field', 20, 1, ' very high performance our associated solutions '),
(904, 'slug', 0, 1, ' eps 5000 '),
(904, 'title', 0, 1, ' eps 5000 '),
(905, 'alt', 0, 1, ''),
(905, 'extension', 0, 1, ' jpg '),
(905, 'filename', 0, 1, ' hero gen14 2025 04 03 110115 dvxg jpg '),
(905, 'kind', 0, 1, ' image '),
(905, 'slug', 0, 1, ''),
(905, 'title', 0, 1, ' hero gen14 '),
(906, 'alt', 0, 1, ''),
(906, 'extension', 0, 1, ' webp '),
(906, 'filename', 0, 1, ' safran eps 5000 webp '),
(906, 'kind', 0, 1, ' image '),
(906, 'slug', 0, 1, ''),
(906, 'title', 0, 1, ' safran eps 5000 '),
(907, 'field', 41, 1, ''),
(907, 'slug', 0, 1, ' designed for orbit raising and station keeping '),
(907, 'title', 0, 1, ' designed for orbit raising and station keeping '),
(908, 'field', 41, 1, ''),
(908, 'slug', 0, 1, ' 40 weight saving convention propulsion '),
(908, 'title', 0, 1, ' 40% weight saving convention propulsion '),
(909, 'field', 41, 1, ''),
(909, 'slug', 0, 1, ' excellent thrust to electrical power ratio '),
(909, 'title', 0, 1, ' excellent thrust to electrical power ratio '),
(922, 'field', 11, 1, ''),
(922, 'slug', 0, 1, ' eps x00 hall effect thruster '),
(922, 'title', 0, 1, ' eps x00 hall effect thruster '),
(930, 'field', 11, 1, ''),
(930, 'slug', 0, 1, ' eps 1350 hall effect thruster '),
(930, 'title', 0, 1, ' eps 1350 hall effect thruster '),
(935, 'field', 11, 1, ''),
(935, 'slug', 0, 1, ' eps 5000 hall effect thruster '),
(935, 'title', 0, 1, ' eps 5000 hall effect thruster '),
(978, 'field', 6, 1, ' space symposium is the premier event uniting global space professionals from all sectors providing a unique platform to explore critical space issues foster dialogue and drive innovation across the space industry with hundreds of exhibitors and speakers confirmed join thousands of registered attendees and sign up today '),
(978, 'field', 46, 1, ' the broadmoor '),
(978, 'field', 47, 1, ' colorado springs co '),
(978, 'field', 48, 1, ' bae systems exhibit center north hall 1251 '),
(978, 'slug', 0, 1, ' space symposium '),
(978, 'title', 0, 1, ' space symposium '),
(1012, 'field', 6, 1, ' connect with safran dsi at trade shows and industry events for the latest in military space and navigation technologies '),
(1012, 'slug', 0, 1, ' events '),
(1012, 'title', 0, 1, ' events '),
(1014, 'alt', 0, 1, ''),
(1014, 'extension', 0, 1, ' webp '),
(1014, 'filename', 0, 1, ' hero events webp '),
(1014, 'kind', 0, 1, ' image '),
(1014, 'slug', 0, 1, ''),
(1014, 'title', 0, 1, ' hero events '),
(1060, 'slug', 0, 1, ' temp aoaijzwaazovfnnzdlsaltzggqbnyrpcukxe '),
(1060, 'title', 0, 1, ''),
(1063, 'slug', 0, 1, ' temp agagqafocspjubocvnqcejhjudalxarqtahq '),
(1063, 'title', 0, 1, ''),
(1065, 'field', 30, 1, ''),
(1065, 'slug', 0, 1, ' apnt '),
(1065, 'title', 0, 1, ' apnt '),
(1070, 'slug', 0, 1, ' temp lkhwgfbmiqocxcwrzzdnhqmrczsoejlnrxri '),
(1070, 'title', 0, 1, ''),
(1072, 'slug', 0, 1, ' temp grrrvamgekxitbdwneycnzrmahouogxcqguo '),
(1072, 'title', 0, 1, ''),
(1080, 'slug', 0, 1, ' temp vwqtlglqlwqidlcpigirqabcxwwwwglgmrdv '),
(1080, 'title', 0, 1, ''),
(1081, 'slug', 0, 1, ' temp xmciavxouaebysdvouihsxzcaocbipqanxxp '),
(1081, 'title', 0, 1, ''),
(1082, 'slug', 0, 1, ' temp nxiqpawinpmrnehavznnsfxumnfregixvdqd '),
(1082, 'title', 0, 1, ''),
(1085, 'slug', 0, 1, ' temp qjobzemwdorqtepgwvevmphsvnwlfyvwmnod '),
(1085, 'title', 0, 1, ''),
(1086, 'slug', 0, 1, ' temp nhuoinafcgatkbfkvafxzbvhihluminpceoe '),
(1086, 'title', 0, 1, ''),
(1087, 'slug', 0, 1, ' temp iaathxrtajxjcnahlenhyviukbwgkpmqbowl '),
(1087, 'title', 0, 1, ''),
(1088, 'slug', 0, 1, ' temp ujwgnacihyqmblpqqnowngenbocotonhshhs '),
(1088, 'title', 0, 1, ''),
(1089, 'slug', 0, 1, ' temp jrgoeecaxkedbvubtzslpmimfwudqhkvssnr '),
(1089, 'title', 0, 1, ''),
(1099, 'field', 6, 1, ' the annual michigan defense expo mdex is the premier event for fostering connections between department of defense dod leaders prime contractors and small businesses from across the country '),
(1099, 'field', 46, 1, ' macomb sports expo center '),
(1099, 'field', 47, 1, ' warren mi 48088 '),
(1099, 'field', 48, 1, ''),
(1099, 'slug', 0, 1, ' mdex michigan defense expo '),
(1099, 'title', 0, 1, ' mdex michigan defense expo '),
(1100, 'field', 30, 1, ''),
(1100, 'slug', 0, 1, ' optronics '),
(1100, 'title', 0, 1, ' optronics '),
(1101, 'alt', 0, 1, ''),
(1101, 'extension', 0, 1, ' webp '),
(1101, 'filename', 0, 1, ' business unit optronics 224x100 webp '),
(1101, 'kind', 0, 1, ' image '),
(1101, 'slug', 0, 1, ''),
(1101, 'title', 0, 1, ' business unit optronics 224x100 '),
(1104, 'field', 6, 1, ' warrior expo equips the warfighter with advanced capabilities to optimize performance and improve readiness while increasing lethality and survivability over two days warrior attendees receive a crash course in training and equipping the modern warfighter '),
(1104, 'field', 46, 1, ' town and country resort '),
(1104, 'field', 47, 1, ' san diego ca '),
(1104, 'field', 48, 1, ''),
(1104, 'slug', 0, 1, ' ads warrior expo west '),
(1104, 'title', 0, 1, ' ads warrior expo west '),
(1105, 'field', 30, 1, ''),
(1105, 'slug', 0, 1, ' optronics '),
(1105, 'title', 0, 1, ' optronics '),
(1108, 'field', 6, 1, ' the leading global conference for sensing imaging and photonics technologies for the defense and security communities '),
(1108, 'field', 46, 1, ' gaylord palms resort convention center '),
(1108, 'field', 47, 1, ' kissimmee florida '),
(1108, 'field', 48, 1, ' booth 1217 '),
(1108, 'slug', 0, 1, ' spie dcs '),
(1108, 'title', 0, 1, ' spie dcs '),
(1109, 'field', 30, 1, ''),
(1109, 'slug', 0, 1, ' optronics '),
(1109, 'title', 0, 1, ' optronics '),
(1112, 'field', 6, 1, ' the premiere law enforcement training and tradeshow for local and federal tactical officers '),
(1112, 'field', 46, 1, ' kalahari resorts conventions '),
(1112, 'field', 47, 1, ' austin tx '),
(1112, 'field', 48, 1, ''),
(1112, 'slug', 0, 1, ' ttpoa '),
(1112, 'title', 0, 1, ' ttpoa '),
(1113, 'field', 30, 1, ''),
(1113, 'slug', 0, 1, ' optronics '),
(1113, 'title', 0, 1, ' optronics '),
(1123, 'field', 6, 1, ' the 5th annual apnt summit will convene the relevant subject matter experts and solution providers from the dod federal government academia and industry to discuss strategies policies and technologies that are needed to boost resiliency and assure pnt services the summit will advance the development and integration of a robust resilient pnt enterprise across the united states to support critical operations and national security '),
(1123, 'field', 46, 1, ' national housing center '),
(1123, 'field', 47, 1, ' washington d c '),
(1123, 'field', 48, 1, ''),
(1123, 'slug', 0, 1, ' apnt summit '),
(1123, 'title', 0, 1, ' apnt summit '),
(1124, 'field', 30, 1, ''),
(1124, 'slug', 0, 1, ' assured pnt '),
(1124, 'title', 0, 1, ' assured pnt '),
(1125, 'alt', 0, 1, ''),
(1125, 'extension', 0, 1, ' webp '),
(1125, 'filename', 0, 1, ' business unit apnt 224x100 webp '),
(1125, 'kind', 0, 1, ' image '),
(1125, 'slug', 0, 1, ''),
(1125, 'title', 0, 1, ' business unit apnt 224x100 '),
(1128, 'field', 6, 1, ' the position location and navigation symposium plans is a biennial technical conference that occurs in the spring of odd numbered years our mission is to provide an international forum to share the latest advances in navigation technology '),
(1128, 'field', 46, 1, ' salt lake marriott downtown at city creek '),
(1128, 'field', 47, 1, ' salt lake city ut '),
(1128, 'field', 48, 1, ''),
(1128, 'slug', 0, 1, ' ieee ion plans '),
(1128, 'title', 0, 1, ' ieee ion plans '),
(1129, 'field', 30, 1, ''),
(1129, 'slug', 0, 1, ' assured pnt '),
(1129, 'title', 0, 1, ' assured pnt '),
(1132, 'field', 6, 1, ' modern day marine is the largest military equipment systems services and technology exposition exclusively targeted to marines and the corps the show floor hosts more than 300 exhibitors displaying the latest warfighting innovations and technology presentations from influential marines and dod personnel the obj1 wargaming convention and more '),
(1132, 'field', 46, 1, ' walter e washington convention center '),
(1132, 'field', 47, 1, ' washington d c '),
(1132, 'field', 48, 1, ' booth 1204 '),
(1132, 'slug', 0, 1, ' modern day marine '),
(1132, 'title', 0, 1, ' modern day marine '),
(1133, 'field', 30, 1, ''),
(1133, 'slug', 0, 1, ' optronics '),
(1133, 'title', 0, 1, ' optronics '),
(1134, 'field', 30, 1, ''),
(1134, 'slug', 0, 1, ' assured pnt '),
(1134, 'title', 0, 1, ' assured pnt '),
(1138, 'field', 6, 1, ' held in tampa florida sof week is an annual conference for the international sof community to learn connect and honor its members the event is jointly sponsored by ussocom and global sof the 2024 edition attracted over 19 000 attendees '),
(1138, 'field', 46, 1, ' tampa convention center '),
(1138, 'field', 47, 1, ' tampa fl '),
(1138, 'field', 48, 1, ' booth 1817 '),
(1138, 'slug', 0, 1, ' sof week '),
(1138, 'title', 0, 1, ' sof week '),
(1139, 'field', 30, 1, ''),
(1139, 'slug', 0, 1, ' optronics '),
(1139, 'title', 0, 1, ' optronics '),
(1140, 'field', 30, 1, ''),
(1140, 'slug', 0, 1, ' assured pnt '),
(1140, 'title', 0, 1, ' assured pnt '),
(1144, 'slug', 0, 1, ''),
(1145, 'slug', 0, 1, ''),
(1146, 'field', 11, 1, ''),
(1146, 'slug', 0, 1, ' company '),
(1146, 'title', 0, 1, ' company '),
(1147, 'field', 11, 1, ''),
(1147, 'slug', 0, 1, ' solutions '),
(1147, 'title', 0, 1, ' solutions '),
(1154, 'field', 11, 1, ''),
(1154, 'slug', 0, 1, ' leadership '),
(1154, 'title', 0, 1, ' leadership '),
(1155, 'field', 11, 1, ''),
(1155, 'slug', 0, 1, ' business units '),
(1155, 'title', 0, 1, ' business units '),
(1156, 'field', 11, 1, ''),
(1156, 'slug', 0, 1, ' contact '),
(1156, 'title', 0, 1, ' contact '),
(1159, 'field', 11, 1, ' eo ir and laser solutions for dismounted soldier airborne naval space and land vehicle operations '),
(1159, 'slug', 0, 1, ' eo ir laser systems '),
(1159, 'title', 0, 1, ' eo ir laser systems '),
(1160, 'field', 11, 1, ' safran dsi provides advanced fluid fuel oxygen systems designed to deliver reliable mission ready solutions that support aircrews passengers and medical applications on both legacy and next generation aircraft '),
(1160, 'slug', 0, 1, ' fluid fuel oxygen systems '),
(1160, 'title', 0, 1, ' fluid fuel oxygen systems '),
(1161, 'alt', 0, 1, ''),
(1161, 'extension', 0, 1, ' webp '),
(1161, 'filename', 0, 1, ' eo ir and laser systems featured img 2025 04 08 082223 vlnu webp '),
(1161, 'kind', 0, 1, ' image '),
(1161, 'slug', 0, 1, ''),
(1161, 'title', 0, 1, ' eo ir and laser systems featured img '),
(1164, 'alt', 0, 1, ''),
(1164, 'extension', 0, 1, ' webp '),
(1164, 'filename', 0, 1, ' fluid fuel and oxygen systems 517x314 webp '),
(1164, 'kind', 0, 1, ' image '),
(1164, 'slug', 0, 1, ''),
(1164, 'title', 0, 1, ' fluid fuel and oxygen systems 517x314 '),
(1171, 'alt', 0, 1, ''),
(1171, 'extension', 0, 1, ' webp '),
(1171, 'filename', 0, 1, ' navigation and geospatial intelligence featured img 2025 04 08 102839 ixwd webp '),
(1171, 'kind', 0, 1, ' image '),
(1171, 'slug', 0, 1, ''),
(1171, 'title', 0, 1, ' navigation and geospatial intelligence featured img '),
(1172, 'field', 11, 1, ' advanced positioning navigation and geospatial technologies '),
(1172, 'slug', 0, 1, ' navigation geospatial intelligence '),
(1172, 'title', 0, 1, ' navigation geospatial intelligence '),
(1176, 'alt', 0, 1, ''),
(1176, 'extension', 0, 1, ' webp '),
(1176, 'filename', 0, 1, ' power and propulsion featured img 2025 04 08 103209 labm webp '),
(1176, 'kind', 0, 1, ' image '),
(1176, 'slug', 0, 1, ''),
(1176, 'title', 0, 1, ' power and propulsion featured img '),
(1178, 'alt', 0, 1, ''),
(1178, 'extension', 0, 1, ' webp '),
(1178, 'filename', 0, 1, ' space solutions 517x314 webp '),
(1178, 'kind', 0, 1, ' image '),
(1178, 'slug', 0, 1, ''),
(1178, 'title', 0, 1, ' space solutions 517x314 '),
(1180, 'alt', 0, 1, ''),
(1180, 'extension', 0, 1, ' webp '),
(1180, 'filename', 0, 1, ' testing and ground evaluation featured img 2025 04 08 103447 qpvi webp '),
(1180, 'kind', 0, 1, ' image '),
(1180, 'slug', 0, 1, ''),
(1180, 'title', 0, 1, ' testing and ground evaluation featured img '),
(1181, 'slug', 0, 1, ' leadership '),
(1181, 'title', 0, 1, ' leadership '),
(1182, 'field', 11, 1, ' engineered systems that drive motion and supply energy '),
(1182, 'slug', 0, 1, ' power propulsion '),
(1182, 'title', 0, 1, ' power propulsion '),
(1183, 'field', 11, 1, ' advanced technologies and solutions to support critical space missions '),
(1183, 'slug', 0, 1, ' space solutions '),
(1183, 'title', 0, 1, ' space solutions '),
(1184, 'field', 11, 1, ' end to end testing solutions and performance analysis ensuring real time mission readiness '),
(1184, 'slug', 0, 1, ' testing ground evaluation '),
(1184, 'title', 0, 1, ' testing ground evaluation '),
(1185, 'field', 11, 1, ''),
(1185, 'slug', 0, 1, ' support '),
(1185, 'title', 0, 1, ' support '),
(1186, 'field', 11, 1, ''),
(1186, 'slug', 0, 1, ' careers '),
(1186, 'title', 0, 1, ' careers '),
(1190, 'field', 11, 1, ''),
(1190, 'slug', 0, 1, ' careers '),
(1190, 'title', 0, 1, ' work at safran dsi '),
(1191, 'field', 11, 1, ''),
(1191, 'slug', 0, 1, ' benefits '),
(1191, 'title', 0, 1, ' benefits '),
(1192, 'field', 11, 1, ''),
(1192, 'slug', 0, 1, ' news events '),
(1192, 'title', 0, 1, ' news events '),
(1196, 'field', 11, 1, ''),
(1196, 'slug', 0, 1, ' news press releases '),
(1196, 'title', 0, 1, ' news press releases '),
(1197, 'field', 11, 1, ''),
(1197, 'slug', 0, 1, ' events '),
(1197, 'title', 0, 1, ' events '),
(1199, 'slug', 0, 1, ' safran dsi secures contract with bell textron to deliver flight testing solutions and antennas for u s armys future long range assault aircraft '),
(1199, 'title', 0, 1, ' safran dsi secures contract with bell textron to deliver flight testing solutions and antennas for u s armys future long range assault aircraft '),
(1200, 'field', 6, 1, ' safran defense space inc safran dsi a world leader in testing and telemetry solutions has secured an order from bell textron inc a textron inc company to deliver comprehensive onboard and ground flight testing solutions for six aircraft under the u s armys future long range assault aircraft flraa program this marks a significant milestone in the development of next generation vertical lift capabilities safran dsi will provide a comprehensive end to end solution utilizing cutting edge technology to ensure precise data acquisition recording and analysis for the aircraft flraa is a key development in the u s armys modernization efforts and we are excited to contribute to this mission with our advanced flight testing solutions said andrei gugiu evp aerospace instrumentation mission systems for testing telemetry this contract underscores the dedication and expertise of our team in delivering reliable mission critical technologies for the u s government flraa is designed to revolutionize the armys vertical lift capabilities developed by bell flraa is a tiltrotor aircraft that combines the vertical takeoff and landing capabilities of a helicopter with the speed and range of a twin turboprop aircraft the aircraft is expected to serve as a critical element in the armys future air mobility strategy '),
(1200, 'field', 11, 1, ' safran defense space inc safran dsi a world leader in testing and telemetry solutions has secured an order from bell textron inc a textron inc company to deliver comprehensive onboard and ground flight testing solutions for six aircraft under the u s armys future long range assault aircraft flraa program this marks a significant milestone in the development of next generation vertical lift capabilities '),
(1200, 'field', 15, 1, ' norcross georgia '),
(1200, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1200, 'slug', 0, 1, ' safran dsi secures contract with bell textron to deliver flight testing solutions and antennas for u s armys future long range assault aircraft '),
(1200, 'title', 0, 1, ' safran dsi secures contract with bell textron to deliver flight testing solutions and antennas for u s armys future long range assault aircraft '),
(1201, 'alt', 0, 1, ''),
(1201, 'extension', 0, 1, ' webp '),
(1201, 'filename', 0, 1, ' contract with bell textron webp '),
(1201, 'kind', 0, 1, ' image '),
(1201, 'slug', 0, 1, ''),
(1201, 'title', 0, 1, ' contract with bell textron '),
(1203, 'field', 6, 1, ' safran federal systems a leading provider of m code and advanced navigation solutions is proud to announce the launch of two groundbreaking products at the institute of navigations 2024 joint navigation conference jnc these new offerings represent a major enhancement of safrans inertial navigation portfolio utilizing state of the art mems and hrg core technologies safran is thrilled to unveil a complete line of tactical grade inertial measurement units imus these units are engineered to address the evolving needs of unmanned applications and space based operations the advanced imus include iconyx a high performance hrg based imu that significantly outperforms legacy technologies offering superior accuracy and reliability for demanding navigation needs stim small tactical imu optimized for applications requiring lower size weight and power swap providing high performance in a compact form factor with the launch of these tactical grade imus were addressing the critical needs of our customers in the unmanned and space sectors said anthony full director of business development navigation systems at safran federal systems the stim and iconyx products represent a leap forward in inertial navigation technology safran is also upgrading its geonyx inertial navigation system ins which is based on hrg technology to incorporate m code capability this enhancement offers a fully integrated solution to tackle the challenges of gps denied or spoofing environments ensuring robust and reliable navigation even in the most demanding conditions adding m code to our hrg based geonyx ins significantly enhances its capabilities making it a premier solution for environments where gps signals are unreliable or compromised this development underscores our commitment to providing advanced navigation solutions that meet the highest standards of performance and security added full the launch of these innovative products highlights safran federal systems commitment to advancing the field of inertial navigation attendees of the joint navigation conference are invited to visit safran federal systems at booth a to learn more about these exciting new offerings and witness firsthand how they are setting new standards in navigation technology '),
(1203, 'field', 11, 1, ' safran federal systems unveils expanded inertial navigation portfolio with advanced mems and hrg technologies at 2024 joint navigation conference '),
(1203, 'field', 15, 1, ' rochester new york '),
(1203, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1203, 'slug', 0, 1, ' safran federal systems unveils expanded inertial navigation portfolio with advanced mems and hrg technologies at 2024 joint navigation conference '),
(1203, 'title', 0, 1, ' safran federal systems unveils expanded inertial navigation portfolio with advanced mems and hrg technologies at 2024 joint navigation conference '),
(1204, 'alt', 0, 1, ''),
(1204, 'extension', 0, 1, ' webp '),
(1204, 'filename', 0, 1, ' inertial navigation portfolio 770x601 webp '),
(1204, 'kind', 0, 1, ' image '),
(1204, 'slug', 0, 1, ''),
(1204, 'title', 0, 1, ' inertial navigation portfolio 770x601 '),
(1205, 'alt', 0, 1, ''),
(1205, 'extension', 0, 1, ' pdf '),
(1205, 'filename', 0, 1, ' 8db84530 1273 4113 pdf '),
(1205, 'kind', 0, 1, ' pdf '),
(1205, 'slug', 0, 1, ''),
(1205, 'title', 0, 1, ' 8db84530 1273 4113 '),
(1209, 'field', 6, 1, ' safran has developed a centrally controlled multiple antennas systems which overcomes the limitations of single receiving antennas when extending a data reception area answering existing challenges the use of a single receiving antenna poses several challenges to flight test the antenna needs to be located on a high spot for maximum visibility of the test article moreover flights at lower altitudes and uneven terrains limit the achievable visibility line of sight between the test article and the receiving antenna during the tests articles might be maneuvered in such a way that the transmitting antenna is not in direct view of the receiving site some techniques exist to address this limitation by using multiple transmitting antennas on the test article but they have limitations become the maestro of your station safrans tm maestro uses multiple receiving antennas to extend the usable area for flight tests optimizing data reception even when the aircraft is positioned behind obstacles the main station can be located anywhere with remote stations connected to it facilitating efficient coordination between several ground stations for optimum management of telemetry streams from multiple sources safran takes advantage of the dqe dqm specification introduced by irig 106 having implemented this specification enables the best source selector bss to access reception quality information from each receiver and select the best data stream the bss also aligns incoming streams over time to switch seamlessly between them automation of the management and control of multiple antennas becomes mandatory and safran offers a fully integrated solution so a single operator can monitor and control all his antennas from a centralized location this solution communicating via ethernet also simplifies the management of other system equipment accurate position acquisition from multiple sources remains crucial to track the test article safran has developed an alternative way using the ads b system used by any commercial aircraft for air traffic control in which the aircraft continuously sends its actual position telemetry stations can therefore easily ensure tracking and reception of the telemetry streams over the greatest possible distance safran approach to improve telemetry quality and efficiency through centrally controlled multiple receiving antennas and management systems underscores its commitment to provide the most advanced scalable solutions '),
(1209, 'field', 11, 1, ' revolutionizing telemetry with multi location ground stations centrally controlled '),
(1209, 'field', 15, 1, ' norcross georgia '),
(1209, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1209, 'slug', 0, 1, ' revolutionizing telemetry with multi location ground stations centrally controlled '),
(1209, 'title', 0, 1, ' revolutionizing telemetry with multi location ground stations centrally controlled '),
(1210, 'alt', 0, 1, ''),
(1210, 'extension', 0, 1, ' webp '),
(1210, 'filename', 0, 1, ' safran tm maestro 770x601 webp '),
(1210, 'kind', 0, 1, ' image '),
(1210, 'slug', 0, 1, ''),
(1210, 'title', 0, 1, ' safran tm maestro 770x601 '),
(1211, 'alt', 0, 1, ''),
(1211, 'extension', 0, 1, ' webp '),
(1211, 'filename', 0, 1, ' safran tm maestro 770x601 2025 04 08 124139 gcnz webp '),
(1211, 'kind', 0, 1, ' image '),
(1211, 'slug', 0, 1, ''),
(1211, 'title', 0, 1, ' safran tm maestro 770x601 '),
(1212, 'alt', 0, 1, ''),
(1212, 'extension', 0, 1, ' webp '),
(1212, 'filename', 0, 1, ' how safran tm maestro works webp '),
(1212, 'kind', 0, 1, ' image '),
(1212, 'slug', 0, 1, ''),
(1212, 'title', 0, 1, ' how safran tm maestro works '),
(1216, 'alt', 0, 1, ''),
(1216, 'extension', 0, 1, ' webp '),
(1216, 'filename', 0, 1, ' safran tm maestro webp '),
(1216, 'kind', 0, 1, ' image '),
(1216, 'slug', 0, 1, ''),
(1216, 'title', 0, 1, ' safran tm maestro '),
(1217, 'alt', 0, 1, ''),
(1217, 'extension', 0, 1, ' webp '),
(1217, 'filename', 0, 1, ' how safran tm maestro works 2025 04 08 124947 vzez webp '),
(1217, 'kind', 0, 1, ' image '),
(1217, 'slug', 0, 1, ''),
(1217, 'title', 0, 1, ' how safran tm maestro works '),
(1225, 'field', 6, 1, ' safran federal systems a leader in advanced navwar and simulation solutions is excited to announce the launch of its latest innovation at the joint navigation conference jnc attendees are invited to visit safran at booth a to witness the debut of the worlds first dual frequency gnss simulator designed specifically for testing military receivers in an unclassified environment lisa perdue product line director at safran federal systems highlights the significance of this launch as we introduce the broadsim duo at the joint navigation conference we are not merely launching a new product we are revolutionizing the accessibility of dual frequency military signal simulation the broadsim duo built upon the foundation of our successful broadsim solo offers this advanced capability in a compact and cost effective format that has not been available until now this strategic innovation not only caters to the immediate needs of our military clients but also sets a new standard for the market leading the way as the industry shifts towards more software defined solutions we are committed to democratizing access to state of the art gnss simulation ensuring that advanced tools are within reach of a broader audience introducing broadsim duo this cutting edge product integrates dual frequency capabilities within a single compact unit a groundbreaking achievement in the field of gps military signal testing key features include dual frequency capability essential for testing p code and aes m code providing comprehensive support for gps military signals compact and affordable this desktop device is available at an unprecedented price point making it accessible for a wide range of applications advanced technology enabled by a new software defined radio in an m 2 form factor ensuring robust and reliable performance skydel simulation environment integration seamlessly integrates with the skydel simulation environment enhancing its versatility and functionality live demonstration at jnc attendees of the joint navigation conference are encouraged to visit booth a to see a live demonstration of the broadsim duo this hands on experience will showcase the devices capabilities and illustrate how it can revolutionize testing processes for military applications '),
(1225, 'field', 11, 1, ' safran federal systems announces revolutionary dual frequency navigation warfare simulator at 2024 joint navigation conference '),
(1225, 'field', 15, 1, ' rochester new york '),
(1225, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1225, 'slug', 0, 1, ' safran federal systems announces revolutionary dual frequency navigation warfare simulator at 2024 joint navigation conference '),
(1225, 'title', 0, 1, ' safran federal systems announces revolutionary dual frequency navigation warfare simulator at 2024 joint navigation conference '),
(1226, 'alt', 0, 1, ''),
(1226, 'extension', 0, 1, ' webp '),
(1226, 'filename', 0, 1, ' broad sim duo 770x601 webp '),
(1226, 'kind', 0, 1, ' image '),
(1226, 'slug', 0, 1, ''),
(1226, 'title', 0, 1, ' broad sim duo 770x601 '),
(1227, 'alt', 0, 1, ''),
(1227, 'extension', 0, 1, ' pdf '),
(1227, 'filename', 0, 1, ' de9227aa 3550 450c 8829 56ba24ab4ecc pdf '),
(1227, 'kind', 0, 1, ' pdf '),
(1227, 'slug', 0, 1, ''),
(1227, 'title', 0, 1, ' de9227aa 3550 450c 8829 56ba24ab4ecc ');
INSERT INTO `searchindex` (`elementId`, `attribute`, `fieldId`, `siteId`, `keywords`) VALUES
(1229, 'field', 6, 1, ' safran electronics defense a global equipment supplier for defense and space is building its u s manufacturing capabilities for small satellite propulsion systems to meet the increasing demand in both the commercial and defense sectors this strategic initiative announced during the 2024 small satellite conference in logan utah will support the projected growth of the north american small satellite market which is expected to reach more than $5 billion by 2030 the made in the usa eps x00 system will be manufactured by safran electronics defense through its us based subsidiary with first delivery in q1 2026 by establishing a new production facility in colorado safran reaffirms its position as a trusted provider of satellite propulsion turnkey solutions for both american and global markets this initiative continues safrans long standing commitment to investing in the us to provide critical solutions and best in class support to us commercial and government customers strategically located the new colorado site will also host safrans u s team for satellite communications as well as space ground domain awareness safran is committed to advancing our manufacturing capabilities to meet the dynamic needs of the u s small satellite market said jean marie betermier space global business unit director safran electronics defense by targeting the global demand for electric propulsion in small satellites we will address the challenge of increasingly stringent international regulations for sustainability and resilience around the world our enhanced production efforts are poised to support these developments and foster innovation in satellite technology betermier added our advancements will also ensure greater spacecraft maneuverability to avoid collisions and facilitate the deorbiting of low earth orbit leo satellites at the end of their service life safrans electric propulsion system named eps x00 pronounced x hundred which includes the pps x00 thruster solidifies its position as a leading provider of electric propulsion for small satellites the pps x00 priced competitively to meet the specific requirements of the new space market environment boasts a total thrust time of up to 5 000 hours and a very high specific impulse making it extremely versatile and adapted to all types of applications in leo '),
(1229, 'field', 11, 1, ' safran boosts production of advanced satellite propulsion systems in the us '),
(1229, 'field', 15, 1, ' logan utah '),
(1229, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1229, 'slug', 0, 1, ' safran boosts production of advanced satellite propulsion systems in the us '),
(1229, 'title', 0, 1, ' safran boosts production of advanced satellite propulsion systems in the us '),
(1230, 'alt', 0, 1, ''),
(1230, 'extension', 0, 1, ' webp '),
(1230, 'filename', 0, 1, ' spacecraft propulsion 770x601 webp '),
(1230, 'kind', 0, 1, ' image '),
(1230, 'slug', 0, 1, ''),
(1230, 'title', 0, 1, ' spacecraft propulsion 770x601 '),
(1231, 'alt', 0, 1, ''),
(1231, 'extension', 0, 1, ' webp '),
(1231, 'filename', 0, 1, ' ppsx00 au tir tir x00 krypton 640x427 webp '),
(1231, 'kind', 0, 1, ' image '),
(1231, 'slug', 0, 1, ''),
(1231, 'title', 0, 1, ' ppsx00 au tir tir x00 krypton 640x427 '),
(1232, 'alt', 0, 1, ''),
(1232, 'extension', 0, 1, ' webp '),
(1232, 'filename', 0, 1, ' ppsx00 au tir tir x00 krypton 640x427 2025 04 08 130519 mbst webp '),
(1232, 'kind', 0, 1, ' image '),
(1232, 'slug', 0, 1, ''),
(1232, 'title', 0, 1, ' ppsx00 au tir tir x00 krypton 640x427 '),
(1233, 'alt', 0, 1, ''),
(1233, 'extension', 0, 1, ' webp '),
(1233, 'filename', 0, 1, ' spacecraft propulsion 770x601 2025 04 08 130521 fgaz webp '),
(1233, 'kind', 0, 1, ' image '),
(1233, 'slug', 0, 1, ''),
(1233, 'title', 0, 1, ' spacecraft propulsion 770x601 '),
(1234, 'alt', 0, 1, ''),
(1234, 'extension', 0, 1, ' pdf '),
(1234, 'filename', 0, 1, ' safran boosts production of advanced satellite propulsion systems in the us pdf '),
(1234, 'kind', 0, 1, ' pdf '),
(1234, 'slug', 0, 1, ''),
(1234, 'title', 0, 1, ' safran boosts production of advanced satellite propulsion systems in the us '),
(1238, 'field', 6, 1, ' safran federal systems a leading innovator in high tech positioning navigation and timing pnt products announced the opening of a 12 000 square foot expansion at its headquarters located at 320 north goodman street in downtown rochester new york this significant expansion marks the companys latest milestone in its ongoing commitment to growth innovation and community investment safran federal systems first established its presence in the village gate square within rochesters neighborhood of the arts nota in 2018 but its roots in the greater rochester area go back to 1972 over the years the company has progressively expanded its footprint most recently completing construction on a brand new second floor space earlier this year the newly opened space dubbed the north star operations center noc will be dedicated to the production and manufacturing of the companys cutting edge pnt products further accelerating safrans business operations and enhancing its capability to meet growing market demands the name north star pays tribute to its location on north goodman street the historical significance of the north star in navigation a key area of expertise for safran and the connection to the renowned abolitionist frederick douglass who resided in rochester for 25 years and published his influential anti slavery newspaper the north star from the city to commemorate this exciting development safran federal systems hosted a ribbon cutting ceremony in partnership with the greater rochester chamber of commerce featuring company executives elected officials and community leaders including congressman joe morelle ny 25 assembly member harry bronson ny 138 assemblymember jen lunsford ny 135 rochester deputy mayor michael burns greater rochester chamber of commerce president ceo robert j duffy and director of membership kevin donahue safran continues to lead the charge in innovative technologies like gps inertial navigation and even designing and maintaining the system of bells and clocks used throughout the united states capitol said congressman joe morelle this expansion is a testament to their commitment to our region and their place as a national leader in defense technologies im grateful for our close relationship and i look forward to our continued work together this expansion is not just a testament to our business growth but also to our deep rooted commitment to the rochester community said scott hildebrandt vice president operations of safran federal systems we are thrilled to be creating new jobs and contributing to the economic revitalization of this vibrant neighborhood our investment here reflects our confidence in the future of this city and our dedication to being a positive force for change the new facility underscores safran federal systems mission to drive innovation while fostering local economic development the companys expansion is expected to create dozens of new jobs providing valuable opportunities for local talent and supporting rochesters broader economic landscape as safran federal systems looks ahead the company remains focused on its goals of continued growth and innovation by investing in both its infrastructure and its community safran is not only positioning itself for long term success but also ensuring that the benefits of its growth are shared with the people and neighborhoods of rochester '),
(1238, 'field', 11, 1, ' safran federal systems expands operations in rochester ny with major facility upgrade '),
(1238, 'field', 15, 1, ' rochester new york '),
(1238, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1238, 'slug', 0, 1, ' safran federal systems expands operations in rochester ny with major facility upgrade '),
(1238, 'title', 0, 1, ' safran federal systems expands operations in rochester ny with major facility upgrade '),
(1239, 'field', 11, 1, ''),
(1239, 'slug', 0, 1, ' company '),
(1239, 'title', 0, 1, ' company '),
(1240, 'alt', 0, 1, ''),
(1240, 'extension', 0, 1, ' webp '),
(1240, 'filename', 0, 1, ' safran federal systems in rochester ny 770x601 webp '),
(1240, 'kind', 0, 1, ' image '),
(1240, 'slug', 0, 1, ''),
(1240, 'title', 0, 1, ' safran federal systems in rochester ny 770x601 '),
(1241, 'field', 11, 1, ''),
(1241, 'slug', 0, 1, ' leadership '),
(1241, 'title', 0, 1, ' leadership '),
(1242, 'alt', 0, 1, ''),
(1242, 'extension', 0, 1, ' pdf '),
(1242, 'filename', 0, 1, ' 6f59f947 ddc9 4c14 be50 5c8728eb1ef1 pdf '),
(1242, 'kind', 0, 1, ' pdf '),
(1242, 'slug', 0, 1, ''),
(1242, 'title', 0, 1, ' 6f59f947 ddc9 4c14 be50 5c8728eb1ef1 '),
(1244, 'field', 11, 1, ''),
(1244, 'slug', 0, 1, ' solutions '),
(1244, 'title', 0, 1, ' solutions '),
(1246, 'field', 6, 1, ' safran defense and space inc norcross georgia is awarded a $47 014 381 firm fixed price indefinite delivery indefinite quantity contract to procure airborne instrumentation modular data recorder system hardware to include solid state recorders recorder modules cameras connector kits and power supplies which come together to form completed airborne instrumentation modular data recording systems as well as associated repair services to support the naval air systems command special flight test instrumentation pool under the prototyping instrumentation and experimentation department airborne instrumentation division for use on f a 18 ea 18g v 22 f 35 e 6 c130 ch 53k mq 4 mq 8 mq 25 p 8 h 1 and mh 60 aircraft in addition to various other platforms for the navy work will be performed in patuxent river maryland and is expected to be completed in october 2029 no funds will be obligated at the time of award funds will be obligated on individual orders as they are issued this contract was not competed naval air warfare center aircraft division patuxent river maryland is the contracting activity n0042125d0003 '),
(1246, 'field', 11, 1, ' safran defense space inc is proud to have been awarded a $47 million firm fixed price indefinite delivery indefinite quantity contract by the us navy '),
(1246, 'field', 15, 1, ' norcross georgia '),
(1246, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1246, 'slug', 0, 1, ' safran defense space inc is proud to have been awarded a 47 million firm fixed price indefinite delivery indefinite quantity contract by the us navy '),
(1246, 'title', 0, 1, ' safran defense space inc is proud to have been awarded a $47 million firm fixed price indefinite delivery indefinite quantity contract by the us navy '),
(1249, 'alt', 0, 1, ''),
(1249, 'extension', 0, 1, ' webp '),
(1249, 'filename', 0, 1, ' safran dsi logo 770x601 webp '),
(1249, 'kind', 0, 1, ' image '),
(1249, 'slug', 0, 1, ''),
(1249, 'title', 0, 1, ' safran dsi logo 770x601 '),
(1250, 'field', 11, 1, ''),
(1250, 'slug', 0, 1, ' eo ir laser systems '),
(1250, 'title', 0, 1, ' eo ir laser systems '),
(1252, 'field', 6, 1, ' safran defense space inc safran dsi the newly established u s subsidiary of global aerospace leader safran has launched a strategic initiative to enhance its support for the u s defense and space sectors this includes major investments in u s manufacturing in several states for diverse technology capabilities with an emphasis on solutions to next generation challenges such as satellite propulsion and communication geospatial artificial intelligence and gps denied navigation safran dsi is committed to safeguarding national sovereignty protecting armed forces and space operations preparedness safran dsi is expanding its digital design model based systems engineering mbse modular open systems approach mosa and advanced manufacturing capabilities with significant growth at its facility for electro optics and infrared systems in bedford n h its future greenfield facility for small satellite propulsion in denver colorado and at the safran federal systems facility for assured positioning navigation timing pnt in rochester n y these investments along with its testing and telemetry operations in norcross georgia will boost safran dsis production capacity and strengthen domestic supply chains by leveraging safrans globally proven expertise and investing in u s engineering and product development safran dsi can offer tailored solutions today for fast evolving challenges across air land sea and space domains said joe bogosian president and ceo of safran dsi in doing so we are proud to support local communities through the creation of high technology jobs and contribute to impactful economic development with its new headquarters soon to open in arlington va safran dsi is strategically positioned to strengthen partnerships with key us defense entities both in government and industry and enhance collaboration and support for critical national security programs '),
(1252, 'field', 11, 1, ' safran defense space inc launches ambitious us growth strategy '),
(1252, 'field', 15, 1, ' arlington virginia '),
(1252, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1252, 'slug', 0, 1, ' safran defense space inc launches ambitious us growth strategy '),
(1252, 'title', 0, 1, ' safran defense space inc launches ambitious us growth strategy '),
(1253, 'alt', 0, 1, ''),
(1253, 'extension', 0, 1, ' pdf '),
(1253, 'filename', 0, 1, ' pr safran dsi dec2024 eng pdf '),
(1253, 'kind', 0, 1, ' pdf '),
(1253, 'slug', 0, 1, ''),
(1253, 'title', 0, 1, ' pr safran dsi dec2024 eng '),
(1255, 'field', 6, 1, ' safran defense space inc safran dsi a global leader in space solutions is proud to announce the successful completion of its first u s built full motion 5 5m vision leo low earth orbit satellite tracking antenna manufactured in norcross georgia the vision antenna is a satellite tracking antenna designed specifically for high duty cycle proliferated leo satellite operations vision represents a cutting edge solution for new space and proliferated leo operations as well as legacy space operations for all combinations of leo missions from satcom to remote sensing and is available with safrans state of the art tri band frequency capability supporting simultaneous operations in x s and ka bands building a new antenna here reflects our commitment to offering american made solutions for our customers and the u s government while also establishing the u s as a hub of expertise and support richard schgallis evp strategic business development and head of space solutions dsi reaffirms its commitment to u s manufacturing with plans to open a new factory in colorado for small satellite electric propulsion thrusters with the first deliveries expected in q2 2026 safran dsis norcross facility stands at the cutting edge of technology specializing in advanced antenna manufacturing validation and comprehensive service for various product lines and support this facility is as9100 certified ensuring the highest standards of quality and reliability in its operations '),
(1255, 'field', 11, 1, ' safran dsi marks milestone with first u s built vision antenna '),
(1255, 'field', 15, 1, ' norcross georgia '),
(1255, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1255, 'slug', 0, 1, ' safran dsi marks milestone with first u s built vision antenna '),
(1255, 'title', 0, 1, ' safran dsi marks milestone with first u s built vision antenna '),
(1256, 'alt', 0, 1, ''),
(1256, 'extension', 0, 1, ' webp '),
(1256, 'filename', 0, 1, ' vision antenna 770x601 webp '),
(1256, 'kind', 0, 1, ' image '),
(1256, 'slug', 0, 1, ''),
(1256, 'title', 0, 1, ' vision antenna 770x601 '),
(1257, 'alt', 0, 1, ''),
(1257, 'extension', 0, 1, ' webp '),
(1257, 'filename', 0, 1, ' vision antenna 770x601 2025 04 08 133409 zovw webp '),
(1257, 'kind', 0, 1, ' image '),
(1257, 'slug', 0, 1, ''),
(1257, 'title', 0, 1, ' vision antenna 770x601 '),
(1259, 'field', 6, 1, ' safran defense space inc safran dsi a world leader in testing telemetry solutions has been awarded a multimillion dollar preventive maintenance contract by a large u s army test range this contract underscores safran dsis commitment to sustainability and customer satisfaction while ensuring the reliability and performance of its advanced systems under the five year contract safran dsis testing telemetry business unit will maintain six mobile sparte 324 antennas 2 4 meters or 8 feet and four fixed sparte 555 antennas 5 5 meters or 18 feet these preventive services are designed to deliver further value to the army by extending the lifespan of the antennas especially in high use conditions safran dsi provides a range of telemetry tracking solutions designed for flight test applications the companys tracking stations manufactured in norcross georgia vary from lightweight models to large 13 meter antennas configurations include mobile trailer mounted skid mounted and shipborne options safrans antennas are used to track a variety of flying targets including aircraft helicopters missiles hypersonic and launch vehicles delivering our antennas along with preventive maintenance demonstrates safrans commitment to reliability and to supporting our customers in their critical time sensitive missions said allan begg telemetry director this contract reinforces our dedication to providing expert support and ensuring long term performance safran dsis testing telemetry unit offers solutions including data acquisition systems rf receivers transmitters telemetry tracking antennas and mission data management systems these technologies provide robust performance and reliability for flight testing '),
(1259, 'field', 11, 1, ' safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(1259, 'field', 15, 1, ' norcross georgia '),
(1259, 'field', 23, 1, ' safran defense space inc safran dsi is a leading provider of cutting edge solutions designed to address the evolving challenges of national defense and advanced space missions headquartered in arlington virginia safran dsi operates through specialized business units in optronics space solutions testing telemetry geospatial artificial intelligence ai and assured positioning navigation and timing pnt safran dsi leverages its parent companys innovative technologies and global resources to deliver unparalleled solutions across air land sea and space domains for more information www safran dsi com '),
(1259, 'slug', 0, 1, ' safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(1259, 'title', 0, 1, ' safran dsi wins preventive maintenance contract for 10 tracking antennas at u s army test range '),
(1260, 'alt', 0, 1, ''),
(1260, 'extension', 0, 1, ' webp '),
(1260, 'filename', 0, 1, ' safran dsi antenna 770x601 webp '),
(1260, 'kind', 0, 1, ' image '),
(1260, 'slug', 0, 1, ''),
(1260, 'title', 0, 1, ' safran dsi antenna 770x601 '),
(1261, 'alt', 0, 1, ''),
(1261, 'extension', 0, 1, ' webp '),
(1261, 'filename', 0, 1, ' safran dsi antenna 770x601 2025 04 08 133728 buaa webp '),
(1261, 'kind', 0, 1, ' image '),
(1261, 'slug', 0, 1, ''),
(1261, 'title', 0, 1, ' safran dsi antenna 770x601 '),
(1277, 'field', 6, 1, ' thank you for visiting the safran dsi website if you require further assistance please reach out to us and a dedicated member of administrative or sales personnel will assist '),
(1277, 'slug', 0, 1, ' contact us '),
(1277, 'title', 0, 1, ' contact us '),
(1279, 'alt', 0, 1, ''),
(1279, 'extension', 0, 1, ' webp '),
(1279, 'filename', 0, 1, ' hero contact webp '),
(1279, 'kind', 0, 1, ' image '),
(1279, 'slug', 0, 1, ''),
(1279, 'title', 0, 1, ' hero contact '),
(1285, 'field', 11, 1, ''),
(1285, 'slug', 0, 1, ' support requests '),
(1285, 'title', 0, 1, ' support requests '),
(1286, 'form', 0, 1, ' contact '),
(1286, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1286, 'fromname', 0, 1, ' test '),
(1286, 'slug', 0, 1, ''),
(1286, 'subject', 0, 1, ' test subject '),
(1287, 'form', 0, 1, ' contact '),
(1287, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1287, 'fromname', 0, 1, ' test '),
(1287, 'slug', 0, 1, ''),
(1287, 'subject', 0, 1, ' test subject '),
(1288, 'form', 0, 1, ' contact '),
(1288, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1288, 'fromname', 0, 1, ' test '),
(1288, 'slug', 0, 1, ''),
(1288, 'subject', 0, 1, ' test subject '),
(1289, 'form', 0, 1, ' contact '),
(1289, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1289, 'fromname', 0, 1, ' test '),
(1289, 'slug', 0, 1, ''),
(1289, 'subject', 0, 1, ' test subject '),
(1290, 'form', 0, 1, ' contact '),
(1290, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1290, 'fromname', 0, 1, ' test '),
(1290, 'slug', 0, 1, ''),
(1290, 'subject', 0, 1, ' test subject '),
(1291, 'form', 0, 1, ' contact '),
(1291, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1291, 'fromname', 0, 1, ' test '),
(1291, 'slug', 0, 1, ''),
(1291, 'subject', 0, 1, ' test subject '),
(1292, 'form', 0, 1, ' contact '),
(1292, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1292, 'fromname', 0, 1, ' test '),
(1292, 'slug', 0, 1, ''),
(1292, 'subject', 0, 1, ' test subject '),
(1293, 'form', 0, 1, ' contact '),
(1293, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1293, 'fromname', 0, 1, ' test '),
(1293, 'slug', 0, 1, ''),
(1293, 'subject', 0, 1, ' test subject '),
(1294, 'field', 11, 1, ''),
(1294, 'slug', 0, 1, ' support '),
(1294, 'title', 0, 1, ' support '),
(1298, 'field', 11, 1, ''),
(1298, 'slug', 0, 1, ' support requests '),
(1298, 'title', 0, 1, ' support requests '),
(1301, 'field', 11, 1, ''),
(1301, 'slug', 0, 1, ' business units '),
(1301, 'title', 0, 1, ' business units '),
(1306, 'form', 0, 1, ' contact '),
(1306, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1306, 'fromname', 0, 1, ' test '),
(1306, 'slug', 0, 1, ''),
(1306, 'subject', 0, 1, ' test subject '),
(1309, 'field', 11, 1, ''),
(1309, 'slug', 0, 1, ' fluid fuel oxygen systems '),
(1309, 'title', 0, 1, ' fluid fuel oxygen systems '),
(1310, 'field', 11, 1, ''),
(1310, 'slug', 0, 1, ' navigation geospatial intelligence '),
(1310, 'title', 0, 1, ' navigation geospatial intelligence '),
(1311, 'field', 11, 1, ''),
(1311, 'slug', 0, 1, ' power propulsion '),
(1311, 'title', 0, 1, ' power propulsion '),
(1312, 'field', 11, 1, ''),
(1312, 'slug', 0, 1, ' space solutions '),
(1312, 'title', 0, 1, ' space solutions '),
(1313, 'field', 11, 1, ''),
(1313, 'slug', 0, 1, ' testing ground evaluation '),
(1313, 'title', 0, 1, ' testing ground evaluation '),
(1314, 'field', 11, 1, ''),
(1314, 'slug', 0, 1, ' careers '),
(1314, 'title', 0, 1, ' careers '),
(1318, 'field', 11, 1, ''),
(1318, 'slug', 0, 1, ' work at safran dsi '),
(1318, 'title', 0, 1, ' work at safran dsi '),
(1319, 'field', 11, 1, ''),
(1319, 'slug', 0, 1, ' benefits '),
(1319, 'title', 0, 1, ' benefits '),
(1320, 'field', 11, 1, ''),
(1320, 'slug', 0, 1, ' news events '),
(1320, 'title', 0, 1, ' news events '),
(1325, 'field', 11, 1, ''),
(1325, 'slug', 0, 1, ' news press releases '),
(1325, 'title', 0, 1, ' news press releases '),
(1326, 'field', 11, 1, ''),
(1326, 'slug', 0, 1, ' event calendar '),
(1326, 'title', 0, 1, ' event calendar '),
(1327, 'field', 11, 1, ''),
(1327, 'slug', 0, 1, ' media contact '),
(1327, 'title', 0, 1, ' media contact '),
(1330, 'form', 0, 1, ' contact '),
(1330, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1330, 'fromname', 0, 1, ''),
(1330, 'slug', 0, 1, ''),
(1330, 'subject', 0, 1, ''),
(1331, 'city', 0, 1, ' city '),
(1331, 'comments', 0, 1, ' testing '),
(1331, 'companyname', 0, 1, ' company name '),
(1331, 'emailaddress', 0, 1, ' web front experts gmail com '),
(1331, 'firstname', 0, 1, ' first name '),
(1331, 'jobfunction', 0, 1, ' job '),
(1331, 'lastname', 0, 1, ' last name '),
(1331, 'phonenumber', 0, 1, ' 123456789 '),
(1331, 'slug', 0, 1, ''),
(1331, 'state', 0, 1, ' ca '),
(1331, 'title', 0, 1, ' 2025 04 10 03 42 28 '),
(1331, 'whatareyouinterestedin', 0, 1, ' support '),
(1331, 'whatproductsareyouinteres', 0, 1, ' product '),
(1331, 'whichbusinessunitdoyouwan', 0, 1, ' apnt '),
(1332, 'form', 0, 1, ' contact '),
(1332, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1332, 'fromname', 0, 1, ' test '),
(1332, 'slug', 0, 1, ''),
(1332, 'subject', 0, 1, ''),
(1333, 'form', 0, 1, ' contact '),
(1333, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1333, 'fromname', 0, 1, ' test '),
(1333, 'slug', 0, 1, ''),
(1333, 'subject', 0, 1, ''),
(1334, 'form', 0, 1, ' contact '),
(1334, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1334, 'fromname', 0, 1, ' test '),
(1334, 'slug', 0, 1, ''),
(1334, 'subject', 0, 1, ''),
(1335, 'form', 0, 1, ' contact '),
(1335, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1335, 'fromname', 0, 1, ' test '),
(1335, 'slug', 0, 1, ''),
(1335, 'subject', 0, 1, ''),
(1336, 'form', 0, 1, ' contact '),
(1336, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1336, 'fromname', 0, 1, ' test '),
(1336, 'slug', 0, 1, ''),
(1336, 'subject', 0, 1, ''),
(1337, 'form', 0, 1, ' contact '),
(1337, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1337, 'fromname', 0, 1, ' test '),
(1337, 'slug', 0, 1, ''),
(1337, 'subject', 0, 1, ''),
(1338, 'form', 0, 1, ' contact '),
(1338, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1338, 'fromname', 0, 1, ' test '),
(1338, 'slug', 0, 1, ''),
(1338, 'subject', 0, 1, ' footer contact form submission '),
(1339, 'form', 0, 1, ' contact '),
(1339, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1339, 'fromname', 0, 1, ' test '),
(1339, 'slug', 0, 1, ''),
(1339, 'subject', 0, 1, ' footer contact form submission '),
(1340, 'form', 0, 1, ' contact '),
(1340, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1340, 'fromname', 0, 1, ' testing '),
(1340, 'slug', 0, 1, ''),
(1340, 'subject', 0, 1, ' footer contact form submission '),
(1341, 'form', 0, 1, ' contact '),
(1341, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1341, 'fromname', 0, 1, ' testing '),
(1341, 'slug', 0, 1, ''),
(1341, 'subject', 0, 1, ' footer contact form submission '),
(1342, 'form', 0, 1, ' contact '),
(1342, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1342, 'fromname', 0, 1, ' new test '),
(1342, 'slug', 0, 1, ''),
(1342, 'subject', 0, 1, ' footer contact form submission '),
(1343, 'form', 0, 1, ' contact '),
(1343, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1343, 'fromname', 0, 1, ' hhome '),
(1343, 'slug', 0, 1, ''),
(1343, 'subject', 0, 1, ' footer contact form submission '),
(1344, 'form', 0, 1, ' contact '),
(1344, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1344, 'fromname', 0, 1, ''),
(1344, 'slug', 0, 1, ''),
(1344, 'subject', 0, 1, ' newsletter submission '),
(1345, 'city', 0, 1, ' city '),
(1345, 'comments', 0, 1, ' testing '),
(1345, 'companyname', 0, 1, ' company '),
(1345, 'emailaddress', 0, 1, ' testing seeders gmail com '),
(1345, 'firstname', 0, 1, ' first '),
(1345, 'jobfunction', 0, 1, ' job '),
(1345, 'lastname', 0, 1, ' last '),
(1345, 'phonenumber', 0, 1, ' 123456 '),
(1345, 'slug', 0, 1, ''),
(1345, 'state', 0, 1, ' select one '),
(1345, 'title', 0, 1, ' 2025 04 11 02 57 48 '),
(1345, 'whatareyouinterestedin', 0, 1, ' select one '),
(1345, 'whatproductsareyouinteres', 0, 1, ''),
(1345, 'whichbusinessunitdoyouwan', 0, 1, ' select one '),
(1346, 'form', 0, 1, ' contact '),
(1346, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1346, 'fromname', 0, 1, ' test '),
(1346, 'slug', 0, 1, ''),
(1346, 'subject', 0, 1, ' footer contact form submission '),
(1347, 'form', 0, 1, ' contact '),
(1347, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1347, 'fromname', 0, 1, ' test '),
(1347, 'slug', 0, 1, ''),
(1347, 'subject', 0, 1, ' newsletter form submission '),
(1348, 'form', 0, 1, ' contact '),
(1348, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1348, 'fromname', 0, 1, ''),
(1348, 'slug', 0, 1, ''),
(1348, 'subject', 0, 1, ' newsletter form submission '),
(1349, 'form', 0, 1, ' contact '),
(1349, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1349, 'fromname', 0, 1, ''),
(1349, 'slug', 0, 1, ''),
(1349, 'subject', 0, 1, ' newsletter form submission '),
(1350, 'form', 0, 1, ' contact '),
(1350, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1350, 'fromname', 0, 1, ''),
(1350, 'slug', 0, 1, ''),
(1350, 'subject', 0, 1, ' newsletter form submission '),
(1351, 'form', 0, 1, ' contact '),
(1351, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1351, 'fromname', 0, 1, ''),
(1351, 'slug', 0, 1, ''),
(1351, 'subject', 0, 1, ' newsletter form submission '),
(1352, 'form', 0, 1, ' contact '),
(1352, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1352, 'fromname', 0, 1, ''),
(1352, 'slug', 0, 1, ''),
(1352, 'subject', 0, 1, ' newsletter form submission '),
(1353, 'form', 0, 1, ' contact '),
(1353, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1353, 'fromname', 0, 1, ''),
(1353, 'slug', 0, 1, ''),
(1353, 'subject', 0, 1, ' newsletter form submission '),
(1354, 'form', 0, 1, ' contact '),
(1354, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1354, 'fromname', 0, 1, ' test '),
(1354, 'slug', 0, 1, ''),
(1354, 'subject', 0, 1, ' footer contact form submission '),
(1355, 'form', 0, 1, ' contact '),
(1355, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1355, 'fromname', 0, 1, ''),
(1355, 'slug', 0, 1, ''),
(1355, 'subject', 0, 1, ' newsletter form submission '),
(1356, 'form', 0, 1, ' contact '),
(1356, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1356, 'fromname', 0, 1, ''),
(1356, 'slug', 0, 1, ''),
(1356, 'subject', 0, 1, ' newsletter form submission '),
(1357, 'form', 0, 1, ' contact '),
(1357, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1357, 'fromname', 0, 1, ''),
(1357, 'slug', 0, 1, ''),
(1357, 'subject', 0, 1, ' newsletter form submission '),
(1358, 'form', 0, 1, ' contact '),
(1358, 'fromemail', 0, 1, ' testing seeders gmail co '),
(1358, 'fromname', 0, 1, ''),
(1358, 'slug', 0, 1, ''),
(1358, 'subject', 0, 1, ' newsletter form submission '),
(1359, 'form', 0, 1, ' contact '),
(1359, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1359, 'fromname', 0, 1, ''),
(1359, 'slug', 0, 1, ''),
(1359, 'subject', 0, 1, ' newsletter form submission '),
(1360, 'form', 0, 1, ' contact '),
(1360, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1360, 'fromname', 0, 1, ''),
(1360, 'slug', 0, 1, ''),
(1360, 'subject', 0, 1, ' newsletter form submission '),
(1361, 'form', 0, 1, ' contact '),
(1361, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1361, 'fromname', 0, 1, ''),
(1361, 'slug', 0, 1, ''),
(1361, 'subject', 0, 1, ' newsletter form submission '),
(1362, 'form', 0, 1, ' contact '),
(1362, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1362, 'fromname', 0, 1, ''),
(1362, 'slug', 0, 1, ''),
(1362, 'subject', 0, 1, ' newsletter form submission '),
(1363, 'form', 0, 1, ' contact '),
(1363, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1363, 'fromname', 0, 1, ''),
(1363, 'slug', 0, 1, ''),
(1363, 'subject', 0, 1, ' newsletter form submission '),
(1364, 'form', 0, 1, ' contact '),
(1364, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1364, 'fromname', 0, 1, ''),
(1364, 'slug', 0, 1, ''),
(1364, 'subject', 0, 1, ' newsletter form submission '),
(1365, 'form', 0, 1, ' contact '),
(1365, 'fromemail', 0, 1, ' testing seeders gmail net '),
(1365, 'fromname', 0, 1, ''),
(1365, 'slug', 0, 1, ''),
(1365, 'subject', 0, 1, ' newsletter form submission '),
(1366, 'form', 0, 1, ' contact '),
(1366, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1366, 'fromname', 0, 1, ''),
(1366, 'slug', 0, 1, ''),
(1366, 'subject', 0, 1, ' newsletter form submission '),
(1367, 'form', 0, 1, ' contact '),
(1367, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1367, 'fromname', 0, 1, ''),
(1367, 'slug', 0, 1, ''),
(1367, 'subject', 0, 1, ' newsletter form submission '),
(1368, 'form', 0, 1, ' contact '),
(1368, 'fromemail', 0, 1, ' test gmail com '),
(1368, 'fromname', 0, 1, ''),
(1368, 'slug', 0, 1, ''),
(1368, 'subject', 0, 1, ' newsletter form submission '),
(1369, 'form', 0, 1, ' contact '),
(1369, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1369, 'fromname', 0, 1, ''),
(1369, 'slug', 0, 1, ''),
(1369, 'subject', 0, 1, ' newsletter form submission '),
(1370, 'form', 0, 1, ' contact '),
(1370, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1370, 'fromname', 0, 1, ''),
(1370, 'slug', 0, 1, ''),
(1370, 'subject', 0, 1, ' newsletter form submission '),
(1371, 'form', 0, 1, ' contact '),
(1371, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1371, 'fromname', 0, 1, ''),
(1371, 'slug', 0, 1, ''),
(1371, 'subject', 0, 1, ' newsletter form submission '),
(1372, 'form', 0, 1, ' contact '),
(1372, 'fromemail', 0, 1, ' test gmail com '),
(1372, 'fromname', 0, 1, ''),
(1372, 'slug', 0, 1, ''),
(1372, 'subject', 0, 1, ' newsletter form submission '),
(1373, 'form', 0, 1, ' contact '),
(1373, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1373, 'fromname', 0, 1, ''),
(1373, 'slug', 0, 1, ''),
(1373, 'subject', 0, 1, ' newsletter form submission '),
(1374, 'form', 0, 1, ' contact '),
(1374, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1374, 'fromname', 0, 1, ''),
(1374, 'slug', 0, 1, ''),
(1374, 'subject', 0, 1, ' newsletter form submission '),
(1375, 'form', 0, 1, ' contact '),
(1375, 'fromemail', 0, 1, ' test gmail com '),
(1375, 'fromname', 0, 1, ''),
(1375, 'slug', 0, 1, ''),
(1375, 'subject', 0, 1, ' newsletter form submission '),
(1376, 'form', 0, 1, ' contact '),
(1376, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1376, 'fromname', 0, 1, ' new test '),
(1376, 'slug', 0, 1, ''),
(1376, 'subject', 0, 1, ' footer contact form submission '),
(1377, 'form', 0, 1, ' contact '),
(1377, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1377, 'fromname', 0, 1, ' test '),
(1377, 'slug', 0, 1, ''),
(1377, 'subject', 0, 1, ' footer contact form submission '),
(1378, 'form', 0, 1, ' contact '),
(1378, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1378, 'fromname', 0, 1, ''),
(1378, 'slug', 0, 1, ''),
(1378, 'subject', 0, 1, ' newsletter form submission '),
(1379, 'form', 0, 1, ' contact '),
(1379, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1379, 'fromname', 0, 1, ''),
(1379, 'slug', 0, 1, ''),
(1379, 'subject', 0, 1, ' newsletter form submission '),
(1380, 'form', 0, 1, ' contact '),
(1380, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1380, 'fromname', 0, 1, ' test '),
(1380, 'slug', 0, 1, ''),
(1380, 'subject', 0, 1, ' footer contact form submission '),
(1381, 'form', 0, 1, ' contact '),
(1381, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1381, 'fromname', 0, 1, ''),
(1381, 'slug', 0, 1, ''),
(1381, 'subject', 0, 1, ' newsletter form submission '),
(1382, 'form', 0, 1, ' contact '),
(1382, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1382, 'fromname', 0, 1, ' test '),
(1382, 'slug', 0, 1, ''),
(1382, 'subject', 0, 1, ' footer contact form submission '),
(1383, 'form', 0, 1, ' contact '),
(1383, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1383, 'fromname', 0, 1, ''),
(1383, 'slug', 0, 1, ''),
(1383, 'subject', 0, 1, ' newsletter form submission '),
(1384, 'form', 0, 1, ' contact '),
(1384, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1384, 'fromname', 0, 1, ' test '),
(1384, 'slug', 0, 1, ''),
(1384, 'subject', 0, 1, ' footer contact form submission '),
(1385, 'form', 0, 1, ' contact '),
(1385, 'fromemail', 0, 1, ' test gmail com '),
(1385, 'fromname', 0, 1, ''),
(1385, 'slug', 0, 1, ''),
(1385, 'subject', 0, 1, ' newsletter form submission '),
(1386, 'form', 0, 1, ' contact '),
(1386, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1386, 'fromname', 0, 1, ''),
(1386, 'slug', 0, 1, ''),
(1386, 'subject', 0, 1, ' newsletter form submission '),
(1387, 'form', 0, 1, ' contact '),
(1387, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1387, 'fromname', 0, 1, ''),
(1387, 'slug', 0, 1, ''),
(1387, 'subject', 0, 1, ' newsletter form submission '),
(1388, 'form', 0, 1, ' contact '),
(1388, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1388, 'fromname', 0, 1, ''),
(1388, 'slug', 0, 1, ''),
(1388, 'subject', 0, 1, ' newsletter form submission '),
(1389, 'form', 0, 1, ' contact '),
(1389, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1389, 'fromname', 0, 1, ''),
(1389, 'slug', 0, 1, ''),
(1389, 'subject', 0, 1, ' newsletter form submission '),
(1390, 'form', 0, 1, ' contact '),
(1390, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1390, 'fromname', 0, 1, ''),
(1390, 'slug', 0, 1, ''),
(1390, 'subject', 0, 1, ' newsletter form submission '),
(1391, 'form', 0, 1, ' contact '),
(1391, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1391, 'fromname', 0, 1, ''),
(1391, 'slug', 0, 1, ''),
(1391, 'subject', 0, 1, ' newsletter form submission '),
(1392, 'form', 0, 1, ' contact '),
(1392, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1392, 'fromname', 0, 1, ''),
(1392, 'slug', 0, 1, ''),
(1392, 'subject', 0, 1, ' newsletter form submission '),
(1393, 'form', 0, 1, ' contact '),
(1393, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1393, 'fromname', 0, 1, ' test '),
(1393, 'slug', 0, 1, ''),
(1393, 'subject', 0, 1, ' footer contact form submission '),
(1394, 'form', 0, 1, ' contact '),
(1394, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1394, 'fromname', 0, 1, ''),
(1394, 'slug', 0, 1, ''),
(1394, 'subject', 0, 1, ' newsletter form submission '),
(1395, 'form', 0, 1, ' contact '),
(1395, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1395, 'fromname', 0, 1, ''),
(1395, 'slug', 0, 1, ''),
(1395, 'subject', 0, 1, ' newsletter form submission '),
(1396, 'form', 0, 1, ' contact '),
(1396, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1396, 'fromname', 0, 1, ''),
(1396, 'slug', 0, 1, ''),
(1396, 'subject', 0, 1, ' newsletter form submission '),
(1397, 'form', 0, 1, ' contact '),
(1397, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1397, 'fromname', 0, 1, ''),
(1397, 'slug', 0, 1, ''),
(1397, 'subject', 0, 1, ' newsletter signup '),
(1398, 'form', 0, 1, ' contact '),
(1398, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1398, 'fromname', 0, 1, ' test '),
(1398, 'slug', 0, 1, ''),
(1398, 'subject', 0, 1, ' footer contact form submission '),
(1399, 'form', 0, 1, ' contact '),
(1399, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1399, 'fromname', 0, 1, ''),
(1399, 'slug', 0, 1, ''),
(1399, 'subject', 0, 1, ' newsletter signup '),
(1400, 'form', 0, 1, ' contact '),
(1400, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1400, 'fromname', 0, 1, ''),
(1400, 'slug', 0, 1, ''),
(1400, 'subject', 0, 1, ' newsletter signup '),
(1401, 'form', 0, 1, ' contact '),
(1401, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1401, 'fromname', 0, 1, ' test '),
(1401, 'slug', 0, 1, ''),
(1401, 'subject', 0, 1, ' footer contact form submission '),
(1402, 'form', 0, 1, ' contact '),
(1402, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1402, 'fromname', 0, 1, ''),
(1402, 'slug', 0, 1, ''),
(1402, 'subject', 0, 1, ' newsletter form submission '),
(1403, 'form', 0, 1, ' contact '),
(1403, 'fromemail', 0, 1, ' devtest140596 gmail com '),
(1403, 'fromname', 0, 1, ''),
(1403, 'slug', 0, 1, ''),
(1403, 'subject', 0, 1, ' newsletter form submission '),
(1404, 'form', 0, 1, ' contact '),
(1404, 'fromemail', 0, 1, ' contact test com '),
(1404, 'fromname', 0, 1, ' contact '),
(1404, 'slug', 0, 1, ''),
(1404, 'subject', 0, 1, ' footer contact form submission '),
(1405, 'form', 0, 1, ' contact '),
(1405, 'fromemail', 0, 1, ' news letter com '),
(1405, 'fromname', 0, 1, ''),
(1405, 'slug', 0, 1, ''),
(1405, 'subject', 0, 1, ' newsletter form submission '),
(1406, 'form', 0, 1, ' contact '),
(1406, 'fromemail', 0, 1, ' devtest140596 gmail com '),
(1406, 'fromname', 0, 1, ' sada '),
(1406, 'slug', 0, 1, ''),
(1406, 'subject', 0, 1, ' footer contact form submission '),
(1407, 'form', 0, 1, ' contact '),
(1407, 'fromemail', 0, 1, ' devtest140596 gmail com '),
(1407, 'fromname', 0, 1, ''),
(1407, 'slug', 0, 1, ''),
(1407, 'subject', 0, 1, ' newsletter form submission '),
(1408, 'form', 0, 1, ' contact '),
(1408, 'fromemail', 0, 1, ' asdasd fsdf dfg '),
(1408, 'fromname', 0, 1, ''),
(1408, 'slug', 0, 1, ''),
(1408, 'subject', 0, 1, ' newsletter form submission '),
(1409, 'form', 0, 1, ' contact '),
(1409, 'fromemail', 0, 1, ' devtest140596 gmail com '),
(1409, 'fromname', 0, 1, ''),
(1409, 'slug', 0, 1, ''),
(1409, 'subject', 0, 1, ' newsletter form submission '),
(1410, 'form', 0, 1, ' contact '),
(1410, 'fromemail', 0, 1, ' devtest140596 gmail com '),
(1410, 'fromname', 0, 1, ' sdf '),
(1410, 'slug', 0, 1, ''),
(1410, 'subject', 0, 1, ' footer contact form submission '),
(1411, 'form', 0, 1, ' contact '),
(1411, 'fromemail', 0, 1, ' devtest140596 gmail com '),
(1411, 'fromname', 0, 1, ''),
(1411, 'slug', 0, 1, ''),
(1411, 'subject', 0, 1, ' newsletter form submission '),
(1412, 'form', 0, 1, ' contact '),
(1412, 'fromemail', 0, 1, ' sdf dfsd dgf '),
(1412, 'fromname', 0, 1, ' tre '),
(1412, 'slug', 0, 1, ''),
(1412, 'subject', 0, 1, ' footer contact form submission '),
(1413, 'form', 0, 1, ' contact '),
(1413, 'fromemail', 0, 1, ' sdf fsdf dg '),
(1413, 'fromname', 0, 1, ' sffsf '),
(1413, 'slug', 0, 1, ''),
(1413, 'subject', 0, 1, ' footer contact form submission '),
(1414, 'form', 0, 1, ' contact '),
(1414, 'fromemail', 0, 1, ' asd asd gfg '),
(1414, 'fromname', 0, 1, ''),
(1414, 'slug', 0, 1, ''),
(1414, 'subject', 0, 1, ' newsletter form submission '),
(1415, 'form', 0, 1, ' contact '),
(1415, 'fromemail', 0, 1, ' fsdff fds fg '),
(1415, 'fromname', 0, 1, ''),
(1415, 'slug', 0, 1, ''),
(1415, 'subject', 0, 1, ' newsletter form submission '),
(1416, 'form', 0, 1, ' contact '),
(1416, 'fromemail', 0, 1, ' dfds fdg fg '),
(1416, 'fromname', 0, 1, ''),
(1416, 'slug', 0, 1, ''),
(1416, 'subject', 0, 1, ' newsletter form submission '),
(1417, 'form', 0, 1, ' contact '),
(1417, 'fromemail', 0, 1, ' fds dsdsg fg '),
(1417, 'fromname', 0, 1, ' sf '),
(1417, 'slug', 0, 1, ''),
(1417, 'subject', 0, 1, ' footer contact form submission '),
(1418, 'form', 0, 1, ' contact '),
(1418, 'fromemail', 0, 1, ' sdf dzf ds '),
(1418, 'fromname', 0, 1, ' sdf '),
(1418, 'slug', 0, 1, ''),
(1418, 'subject', 0, 1, ' footer contact form submission '),
(1419, 'form', 0, 1, ' contact '),
(1419, 'fromemail', 0, 1, ' sada dfs gf '),
(1419, 'fromname', 0, 1, ''),
(1419, 'slug', 0, 1, ''),
(1419, 'subject', 0, 1, ' newsletter form submission '),
(1420, 'form', 0, 1, ' contact '),
(1420, 'fromemail', 0, 1, ' sfsd dff fd '),
(1420, 'fromname', 0, 1, ''),
(1420, 'slug', 0, 1, ''),
(1420, 'subject', 0, 1, ' newsletter form submission '),
(1421, 'form', 0, 1, ' contact '),
(1421, 'fromemail', 0, 1, ' asd fsd fdg '),
(1421, 'fromname', 0, 1, ' sd '),
(1421, 'slug', 0, 1, ''),
(1421, 'subject', 0, 1, ' footer contact form submission '),
(1425, 'form', 0, 1, ' contact '),
(1425, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1425, 'fromname', 0, 1, ''),
(1425, 'slug', 0, 1, ''),
(1425, 'subject', 0, 1, ' newsletter form submission '),
(1426, 'form', 0, 1, ' contact '),
(1426, 'fromemail', 0, 1, ' testing seeders gmail com '),
(1426, 'fromname', 0, 1, ' test '),
(1426, 'slug', 0, 1, ''),
(1426, 'subject', 0, 1, ' footer contact form submission '),
(1433, 'field', 6, 1, ' for safran defense space inc media inquiries please contact charles jones head of marketing communications safran defense space inc media safran dsi com 1 603 289‑3743 4501 north fairfax drive 9th floor arlington virginia 22203 '),
(1433, 'slug', 0, 1, ' media contact '),
(1433, 'title', 0, 1, ' media contact '),
(1435, 'alt', 0, 1, ''),
(1435, 'extension', 0, 1, ' webp '),
(1435, 'filename', 0, 1, ' hero media contact webp '),
(1435, 'kind', 0, 1, ' image '),
(1435, 'slug', 0, 1, ''),
(1435, 'title', 0, 1, ' hero media contact '),
(1440, 'slug', 0, 1, ''),
(1441, 'slug', 0, 1, ' company '),
(1441, 'title', 0, 1, ' company '),
(1444, 'field', 11, 1, ''),
(1444, 'slug', 0, 1, ' leadership '),
(1444, 'title', 0, 1, ' leadership '),
(1445, 'field', 11, 1, ''),
(1445, 'slug', 0, 1, ' company '),
(1445, 'title', 0, 1, ' company '),
(1446, 'field', 11, 1, ''),
(1446, 'slug', 0, 1, ' leadership '),
(1446, 'title', 0, 1, ' leadership '),
(1449, 'field', 11, 1, ''),
(1449, 'slug', 0, 1, ' business units '),
(1449, 'title', 0, 1, ' business units '),
(1451, 'field', 11, 1, ''),
(1451, 'slug', 0, 1, ' news events '),
(1451, 'title', 0, 1, ' news events '),
(1452, 'field', 11, 1, ''),
(1452, 'slug', 0, 1, ' media contact '),
(1452, 'title', 0, 1, ' media contact '),
(1453, 'slug', 0, 1, ' temp mwqwrswydqwtrisluelvldlhxdyhtrccoehx '),
(1453, 'title', 0, 1, ''),
(1457, 'field', 11, 1, ''),
(1457, 'slug', 0, 1, ' news press releases '),
(1457, 'title', 0, 1, ' news press releases '),
(1458, 'field', 11, 1, ''),
(1458, 'slug', 0, 1, ' events '),
(1458, 'title', 0, 1, ' events '),
(1492, 'field', 6, 1, ' thank you for visiting the safran dsi website if you require further assistance please reach out to us and a dedicated member of administrative or sales personnel will assist '),
(1492, 'slug', 0, 1, ' contact us '),
(1492, 'title', 0, 1, ' contact us '),
(1493, 'field', 6, 1, ' we are committed to fostering a vibrant and inclusive company culture our mission is to create an environment where our employees thrive feel valued and actively contribute to the success of our organization all while making a positive impact on the communities we serve with our core value of mutual respect we communicate effectively while focusing on goals and results with integrity we are uncompromisingly committed to the health and safety of our employees and recognize the impact of work life balance and believe that a happy and fulfilled workforce is more productive '),
(1493, 'slug', 0, 1, ' home '),
(1493, 'title', 0, 1, ' home '),
(1494, 'slug', 0, 1, ' news '),
(1494, 'title', 0, 1, ' news press releases '),
(1495, 'field', 6, 1, ' our leadership team at safran dsi combines deep industry expertise with a bold vision to drive innovation and support u s defense and security '),
(1495, 'slug', 0, 1, ' leadership '),
(1495, 'title', 0, 1, ' our leadership '),
(1496, 'field', 6, 1, ' safran proudly holds a distinguished legacy in the united states spanning nearly five decades weve led the charge in pioneering cutting edge technologies bolstering national security and enhancing performance across varied industries key businesses including optronics space solutions testing telemetry and assured pnt epitomize our commitment to innovation and excellence this dedication has solidified our position as the preferred partner to federal state and local governments as well as armed forces and other essential stakeholders in the us market '),
(1496, 'field', 19, 1, ' careers at safran dsi '),
(1496, 'field', 20, 1, ' who we are what we do work at safran dsi '),
(1496, 'slug', 0, 1, ' join our mission '),
(1496, 'title', 0, 1, ' join our mission '),
(1497, 'field', 6, 1, ' at safran dsi we are global leaders in aerospace defense and security dedicated to delivering high tech solutions that power and protect industries worldwide innovation and sustainability drive everything we do from cutting edge propulsion systems and aircraft equipment to state of the art avionics and interiors that enhance performance and passenger comfort our expertise extends to defense technologies where we provide advanced navigation optronics and security solutions we also play a key role in space propulsion and drone systems pushing the boundaries of exploration and autonomy discover how our solutions can enhance safety efficiency and technological excellence across air land and space explore our solutions today '),
(1497, 'field', 20, 1, ' solutions '),
(1497, 'slug', 0, 1, ' solutions '),
(1497, 'title', 0, 1, ' solutions ');

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

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` int NOT NULL,
  `structureId` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('single','channel','structure') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'channel',
  `enableVersioning` tinyint(1) NOT NULL DEFAULT '0',
  `maxAuthors` smallint UNSIGNED NOT NULL DEFAULT '1',
  `propagationMethod` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'all',
  `defaultPlacement` enum('beginning','end') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'end',
  `previewTargets` json DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `structureId`, `name`, `handle`, `type`, `enableVersioning`, `maxAuthors`, `propagationMethod`, `defaultPlacement`, `previewTargets`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, NULL, 'Home Page', 'homePage', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-17 17:37:27', '2025-03-17 17:37:27', NULL, 'b2a824dd-7539-476d-b5d3-33a3a365e7e6'),
(2, 2, 'Solutions', 'solutions', 'structure', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-19 09:27:56', '2025-03-26 09:44:24', NULL, 'cdeec6c0-3d7a-465a-8a5d-26294df1655f'),
(3, NULL, 'Solution', 'solution', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-19 09:37:25', '2025-03-19 09:37:25', '2025-03-20 06:39:04', 'ac2db9f2-cde1-441d-9508-c51d76f067b3'),
(4, NULL, 'News Articles', 'newsArticles', 'channel', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-20 06:44:46', '2025-03-20 07:08:23', NULL, '6e1964ea-3876-4eba-987f-9839acde505d'),
(5, NULL, 'Solution', 'solution', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-20 06:50:48', '2025-03-20 06:51:39', NULL, '9b739a32-c372-4e4c-b0fc-d1404239f3b3'),
(6, NULL, 'News', 'news', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-20 07:09:44', '2025-03-20 07:09:44', NULL, 'ac284069-2a2b-42b5-bb58-55c136ef5645'),
(7, NULL, 'Join Our Mission', 'joinOurMission', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-21 08:14:58', '2025-03-21 08:14:58', NULL, '89efb2e0-7781-4144-b970-a51fc573f936'),
(8, NULL, 'Benefits', 'benefits', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-23 18:25:23', '2025-03-23 18:25:23', NULL, '8c40fa59-3e3b-41ff-8a89-1097bceb529e'),
(9, NULL, 'Leadership Bio', 'leadershipBio', 'channel', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-24 07:58:26', '2025-03-24 10:22:21', '2025-03-24 10:28:47', 'e3531d7e-e510-4956-8846-aa8bc7a5780c'),
(10, NULL, 'Leadership', 'leadership', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-24 08:08:42', '2025-03-24 10:18:17', NULL, '87415b08-b5cf-47a5-97e4-1c71f7ff2856'),
(11, NULL, 'Leadership Bio', 'leadershipBio', 'channel', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-24 10:29:31', '2025-03-24 10:29:31', NULL, '2355c00e-aea1-4e6c-abdc-fe71bcf6ca01'),
(12, NULL, 'Business Units', 'businessUnits', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-03-25 10:49:44', '2025-03-25 10:49:44', NULL, '9422a6e5-b739-43dc-b350-6e11af244af9'),
(13, NULL, 'Events List', 'eventsList', 'channel', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-04-03 11:55:31', '2025-04-03 12:34:10', NULL, '15dcaee4-4f5b-4fac-8bd6-66ffb8ffbe83'),
(14, NULL, 'Events', 'events', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-04-03 12:36:03', '2025-04-03 12:36:03', NULL, 'f740c3ea-3c5f-4b7d-ba45-72cf41e64466'),
(15, NULL, 'Contact Us', 'contactUs', 'single', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-04-09 08:14:04', '2025-04-09 08:14:04', NULL, '9f0fe959-abcd-4907-a6c5-3c75c7b55899'),
(16, NULL, 'General Pages', 'generalPages', 'channel', 1, 1, 'all', 'end', '[{\"label\": \"Primary entry page\", \"refresh\": \"1\", \"urlFormat\": \"{url}\"}]', '2025-04-14 11:01:32', '2025-04-14 11:01:32', NULL, 'fe188069-f80f-4f29-8ef4-df06ead8b078');

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

--
-- Table structure for table `sections_entrytypes`
--

CREATE TABLE `sections_entrytypes` (
  `sectionId` int NOT NULL,
  `typeId` int NOT NULL,
  `sortOrder` smallint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `handle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections_entrytypes`
--

INSERT INTO `sections_entrytypes` (`sectionId`, `typeId`, `sortOrder`, `name`, `handle`) VALUES
(1, 1, 1, NULL, NULL),
(2, 4, 1, NULL, NULL),
(3, 5, 1, NULL, NULL),
(4, 7, 1, NULL, NULL),
(5, 5, 1, NULL, NULL),
(6, 6, 1, NULL, NULL),
(7, 10, 1, NULL, NULL),
(8, 12, 1, NULL, NULL),
(9, 14, 1, NULL, NULL),
(10, 13, 1, NULL, NULL),
(11, 14, 1, NULL, NULL),
(12, 15, 1, NULL, NULL),
(13, 20, 1, NULL, NULL),
(14, 21, 1, NULL, NULL),
(15, 23, 1, NULL, NULL),
(16, 24, 1, NULL, NULL);

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

--
-- Table structure for table `sections_sites`
--

CREATE TABLE `sections_sites` (
  `id` int NOT NULL,
  `sectionId` int NOT NULL,
  `siteId` int NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT '1',
  `uriFormat` text COLLATE utf8mb4_unicode_ci,
  `template` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabledByDefault` tinyint(1) NOT NULL DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections_sites`
--

INSERT INTO `sections_sites` (`id`, `sectionId`, `siteId`, `hasUrls`, `uriFormat`, `template`, `enabledByDefault`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 1, 1, 1, '__home__', 'index.twig', 1, '2025-03-17 17:37:27', '2025-03-17 17:37:27', '43daa78c-1a83-473d-bcbd-7bd6d624ea12'),
(2, 2, 1, 1, '{% if level == 1 %}solutions{% else %}{parent.uri}{% endif %}/{slug}', 'solutions/_entry.twig', 1, '2025-03-19 09:27:56', '2025-03-26 10:29:16', 'b4d208c1-2a39-4cd3-9a38-cd1fbe286109'),
(3, 3, 1, 1, 'solutions', 'solutions.twig', 1, '2025-03-19 09:37:25', '2025-03-19 10:18:00', '11251752-3ab2-4804-9240-bb71113933e9'),
(4, 4, 1, 1, 'news/{slug}', 'news/_entry.twig', 1, '2025-03-20 06:44:46', '2025-03-20 06:44:46', '6644da21-5f87-41dc-b409-1262d636c043'),
(5, 5, 1, 1, 'solutions', 'solutions/index.twig', 1, '2025-03-20 06:50:48', '2025-03-24 08:05:44', '7d6e661b-95a9-41e4-9741-249d52e317b1'),
(6, 6, 1, 1, 'news', 'news/index.twig', 1, '2025-03-20 07:09:44', '2025-03-20 07:09:44', '6b70c9bf-8bb3-4da8-8da9-bda7badb0a77'),
(7, 7, 1, 1, 'join-our-mission', 'careers/join-our-mission.twig', 1, '2025-03-21 08:14:58', '2025-03-21 08:40:47', '39d19266-516c-4652-b8dd-a2badc36630e'),
(8, 8, 1, 1, 'benefits', 'careers/benefits.twig', 1, '2025-03-23 18:25:23', '2025-03-23 18:25:23', '8db85c6e-3bfc-4a94-b705-2cab188ad216'),
(9, 9, 1, 1, 'leadership/{slug}', 'leadership/_entry.twig', 1, '2025-03-24 07:58:26', '2025-03-24 07:58:26', 'd11691c4-189e-4262-b54c-e21058336a53'),
(10, 10, 1, 1, 'leadership', 'leadership/index.twig', 1, '2025-03-24 08:08:42', '2025-03-24 08:20:08', 'e438e55c-5c8b-432f-bdff-af8f775dd9af'),
(11, 11, 1, 1, 'leadership/{slug}', 'leadership/_entry.twig', 1, '2025-03-24 10:29:31', '2025-03-24 10:29:31', '4d932de9-409e-4d66-b892-9ee17a5f0d6b'),
(12, 12, 1, 1, 'business-units', 'business-units/index.twig', 1, '2025-03-25 10:49:44', '2025-03-25 10:49:44', '8d2c267d-a570-4934-9236-99b7ad175e79'),
(13, 13, 1, 1, 'events/{slug}', 'events/_entry.twig', 1, '2025-04-03 11:55:31', '2025-04-03 11:55:31', '35bc721a-293b-4086-a879-47e13a005367'),
(14, 14, 1, 1, 'events', 'events/index.twig', 1, '2025-04-03 12:36:03', '2025-04-03 12:36:03', '1fe6d295-3d05-48db-8ec4-a43f61a12622'),
(15, 15, 1, 1, 'contact-us', 'contact-us/index.twig', 1, '2025-04-09 08:14:04', '2025-04-09 08:14:04', 'b2eee5b6-7f41-42fb-bb2d-0d23f1a4032a'),
(16, 16, 1, 1, '{slug}', 'general-pages/_entry.twig', 1, '2025-04-14 11:01:32', '2025-04-14 11:01:32', 'df49cc41-6b41-4d2b-b26a-bfe4c8ea06aa');

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

--
-- Table structure for table `seo_redirects`
--

CREATE TABLE `seo_redirects` (
  `id` int NOT NULL,
  `uri` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `type` enum('301','302') NOT NULL,
  `siteId` int DEFAULT NULL,
  `order` int DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `seo_sitemap`
--

CREATE TABLE `seo_sitemap` (
  `id` int NOT NULL,
  `group` enum('sections','categories','productTypes','customUrls') NOT NULL,
  `url` varchar(255) NOT NULL,
  `frequency` enum('always','hourly','daily','weekly','monthly','yearly','never') NOT NULL,
  `priority` float NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `sequences`
--

CREATE TABLE `sequences` (
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `next` int UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shunnedmessages`
--

CREATE TABLE `shunnedmessages` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sitegroups`
--

CREATE TABLE `sitegroups` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sitegroups`
--

INSERT INTO `sitegroups` (`id`, `name`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 'Safran', '2025-03-12 11:47:38', '2025-03-12 11:47:38', NULL, '594bc5d9-2cb7-4162-bea0-4ba7dddd0c97');

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

--
-- Table structure for table `sites`
--

CREATE TABLE `sites` (
  `id` int NOT NULL,
  `groupId` int NOT NULL,
  `primary` tinyint(1) NOT NULL,
  `enabled` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT '0',
  `baseUrl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sortOrder` smallint UNSIGNED DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sites`
--

INSERT INTO `sites` (`id`, `groupId`, `primary`, `enabled`, `name`, `handle`, `language`, `hasUrls`, `baseUrl`, `sortOrder`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 1, 1, '1', 'Safran', 'default', 'en-US', 1, '$PRIMARY_SITE_URL', 1, '2025-03-12 11:47:38', '2025-03-17 17:34:25', NULL, 'f1c4732a-e2ac-4049-b0a2-6ce54688f3fd');

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

--
-- Table structure for table `sso_identities`
--

CREATE TABLE `sso_identities` (
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identityId` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `userId` int NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `structureelements`
--

CREATE TABLE `structureelements` (
  `id` int NOT NULL,
  `structureId` int NOT NULL,
  `elementId` int DEFAULT NULL,
  `root` int UNSIGNED DEFAULT NULL,
  `lft` int UNSIGNED NOT NULL,
  `rgt` int UNSIGNED NOT NULL,
  `level` smallint UNSIGNED NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `structureelements`
--

INSERT INTO `structureelements` (`id`, `structureId`, `elementId`, `root`, `lft`, `rgt`, `level`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 1, NULL, 1, 1, 6, 0, '2025-03-20 08:15:28', '2025-03-20 08:15:44', 'd5a5ef1e-9004-469c-a8ff-21975d05ab8d'),
(2, 1, 173, 1, 2, 3, 1, '2025-03-20 08:15:28', '2025-03-20 08:15:28', '8ef4b8f6-35ad-4ad0-95fb-9f477fe52356'),
(3, 1, 174, 1, 4, 5, 1, '2025-03-20 08:15:44', '2025-03-20 08:15:44', '5a428803-d170-42cf-96bd-bc86d84a8fc2'),
(4, 2, NULL, 4, 1, 30, 0, '2025-03-26 09:44:24', '2025-04-03 11:04:41', 'be77fef5-55a9-4816-9b31-e58a176055c2'),
(6, 2, 99, 4, 2, 3, 1, '2025-03-26 09:44:24', '2025-03-26 09:44:50', '2863ac0f-a5e8-4d3b-b199-6093d3205527'),
(7, 2, 102, 4, 4, 19, 1, '2025-03-26 09:44:24', '2025-04-03 11:04:41', 'c4a49c1c-3bcd-4ba5-8a81-36094fc1bd76'),
(8, 2, 105, 4, 26, 27, 1, '2025-03-26 09:44:24', '2025-04-03 11:04:41', '4b5053fa-e462-4230-9fa8-c141949dc617'),
(9, 2, 108, 4, 20, 21, 1, '2025-03-26 09:44:24', '2025-04-03 11:04:41', '43ae804f-3dbb-4cf1-9562-4961c8bf42e2'),
(10, 2, 111, 4, 24, 25, 1, '2025-03-26 09:44:24', '2025-04-03 11:04:41', 'eedc1c3f-2b51-49e2-b69f-f1a40b19f164'),
(11, 2, 114, 4, 22, 23, 1, '2025-03-26 09:44:24', '2025-04-03 11:04:41', '83320895-7d29-4c2b-b4a0-338c87cf3076'),
(13, 2, 516, 4, 5, 18, 2, '2025-03-26 09:46:26', '2025-04-03 11:04:41', 'ec4c9892-b610-43ab-b3e8-88aaa512f700'),
(15, 2, 524, 4, 6, 7, 3, '2025-03-26 10:40:40', '2025-03-26 10:40:58', 'acbf47fb-99e7-4e2d-a2e0-ace61c9b8fec'),
(16, 2, 526, 4, 8, 9, 3, '2025-03-26 10:47:53', '2025-03-26 10:48:11', 'bcae98e7-bf7a-4b09-85b0-c3005df9065b'),
(17, 2, 528, 4, 10, 11, 3, '2025-03-26 10:48:20', '2025-03-26 10:48:34', 'fbde0dae-318b-4aca-8b9a-0924adc5022c'),
(22, 2, 739, 4, 28, 29, 1, '2025-04-03 07:21:17', '2025-04-03 11:04:41', '00e6a28d-e49d-48e9-9988-674350464bae'),
(23, 2, 867, 4, 12, 13, 3, '2025-04-03 10:29:10', '2025-04-03 10:35:14', '635b2d22-a738-4860-a8d2-259a1e79a76f'),
(25, 2, 880, 4, 14, 15, 3, '2025-04-03 10:37:24', '2025-04-03 10:48:46', '7c22ae02-8821-4926-b0c5-3898c0982659'),
(26, 2, 904, 4, 16, 17, 3, '2025-04-03 10:58:24', '2025-04-03 11:04:41', '03967bc2-db86-40f3-a283-ec132b5b44b2');

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

--
-- Table structure for table `structures`
--

CREATE TABLE `structures` (
  `id` int NOT NULL,
  `maxLevels` smallint UNSIGNED DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `structures`
--

INSERT INTO `structures` (`id`, `maxLevels`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 1, '2025-03-20 08:14:52', '2025-03-20 08:14:52', NULL, '1e653036-af97-46bc-ade6-1218bc27fd33'),
(2, NULL, '2025-03-26 09:44:24', '2025-03-26 09:44:24', NULL, 'a95fb624-2ac4-4d24-b080-e2a437d7c860');

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

--
-- Table structure for table `taggroups`
--

CREATE TABLE `taggroups` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fieldLayoutId` int DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` int NOT NULL,
  `groupId` int NOT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `usergroups`
--

CREATE TABLE `usergroups` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `usergroups_users`
--

CREATE TABLE `usergroups_users` (
  `id` int NOT NULL,
  `groupId` int NOT NULL,
  `userId` int NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `userpermissions`
--

CREATE TABLE `userpermissions` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `userpermissions_usergroups`
--

CREATE TABLE `userpermissions_usergroups` (
  `id` int NOT NULL,
  `permissionId` int NOT NULL,
  `groupId` int NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `userpermissions_users`
--

CREATE TABLE `userpermissions_users` (
  `id` int NOT NULL,
  `permissionId` int NOT NULL,
  `userId` int NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `userpreferences`
--

CREATE TABLE `userpreferences` (
  `userId` int NOT NULL,
  `preferences` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `userpreferences`
--

INSERT INTO `userpreferences` (`userId`, `preferences`) VALUES
(1, '{\"language\": \"en-US\"}');

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

--
-- Table structure for table `volumefolders`
--

CREATE TABLE `volumefolders` (
  `id` int NOT NULL,
  `parentId` int DEFAULT NULL,
  `volumeId` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `volumefolders`
--

INSERT INTO `volumefolders` (`id`, `parentId`, `volumeId`, `name`, `path`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, NULL, 1, 'Uploads', NULL, '2025-03-18 18:22:06', '2025-03-19 08:17:57', 'c3edca7f-95a6-40c2-badb-c6d14a962f85'),
(2, NULL, NULL, 'Temporary Uploads', NULL, '2025-03-18 18:23:02', '2025-03-18 18:23:02', 'c3875d8a-9a9a-48ff-8aab-3fcf1c99ed28'),
(3, 2, NULL, 'user_1', 'user_1/', '2025-03-18 18:23:02', '2025-03-18 18:23:02', 'd56ff3b6-ecee-4f71-a964-9a544a63b7f9');

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

--
-- Table structure for table `volumes`
--

CREATE TABLE `volumes` (
  `id` int NOT NULL,
  `fieldLayoutId` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fs` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subpath` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transformFs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transformSubpath` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `titleTranslationMethod` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text COLLATE utf8mb4_unicode_ci,
  `altTranslationMethod` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'site',
  `altTranslationKeyFormat` text COLLATE utf8mb4_unicode_ci,
  `sortOrder` smallint UNSIGNED DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `volumes`
--

INSERT INTO `volumes` (`id`, `fieldLayoutId`, `name`, `handle`, `fs`, `subpath`, `transformFs`, `transformSubpath`, `titleTranslationMethod`, `titleTranslationKeyFormat`, `altTranslationMethod`, `altTranslationKeyFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 3, 'Uploads', 'uploads', 'uploads', '', 'uploads', '', 'site', NULL, 'none', NULL, 1, '2025-03-18 18:22:06', '2025-03-19 08:19:21', NULL, '2c4ea125-ccc2-4070-891e-c35d4ffedd04');

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

--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sortOrder` smallint UNSIGNED DEFAULT NULL,
  `colspan` tinyint DEFAULT NULL,
  `settings` json DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` (`id`, `userId`, `type`, `sortOrder`, `colspan`, `settings`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 1, 'craft\\widgets\\RecentEntries', 1, NULL, '{\"limit\": 10, \"siteId\": 1, \"section\": \"*\"}', 1, '2025-03-17 10:41:16', '2025-03-17 10:41:16', '5dc4e89d-9e6c-40a8-b81a-a635061f15dc'),
(2, 1, 'craft\\widgets\\CraftSupport', 2, NULL, '[]', 1, '2025-03-17 10:41:16', '2025-03-17 10:41:16', '521ba646-bbb2-41ad-8c90-85743f3fa3bb'),
(3, 1, 'craft\\widgets\\Updates', 3, NULL, '[]', 1, '2025-03-17 10:41:16', '2025-03-17 10:41:16', '7394d22e-da0e-428e-b109-5fa7bd0c2bdf'),
(4, 1, 'craft\\widgets\\Feed', 4, NULL, '{\"url\": \"https://craftcms.com/news.rss\", \"limit\": 5, \"title\": \"Craft News\"}', 1, '2025-03-17 10:41:16', '2025-03-17 10:41:16', '15d7f3aa-9c63-4cf9-b0e3-39fb28a1f505');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addresses`
--
ALTER TABLE `addresses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_ezshtsfnwmiuhxkdmevqhcbycftpsiajghty` (`primaryOwnerId`);

--
-- Indexes for table `announcements`
--
ALTER TABLE `announcements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_nllwodvusbkvfywmcasqjtobyddxtxlocisw` (`userId`,`unread`,`dateRead`,`dateCreated`),
  ADD KEY `idx_rmjwbsqsxkyrpirrbrcknfznyykahuqdsenq` (`dateRead`),
  ADD KEY `fk_rwtqyyvckgrrpcqtmxngspehbabhappihaob` (`pluginId`);

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

--
-- Indexes for table `assets`
--
ALTER TABLE `assets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tuvqhdmlmnyzdgndipebtvydjiuhsqommhij` (`filename`,`folderId`),
  ADD KEY `idx_tpevekmkozuwzqgxcdqxtltuevcxbsgoajwj` (`folderId`),
  ADD KEY `idx_vyhhghunfzywucodamffljaopoocawxkhgwu` (`volumeId`),
  ADD KEY `fk_ocmwwozrbnfjmqknuzaqxauntpivjoopoqby` (`uploaderId`);

--
-- Indexes for table `assets_sites`
--
ALTER TABLE `assets_sites`
  ADD PRIMARY KEY (`assetId`,`siteId`),
  ADD KEY `fk_fgejcrorsxcfxbayxhmlbqocksijjofbfhcn` (`siteId`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ywelmbhswxxulnilikzdxfmgytkhdfnmfvpf` (`groupId`),
  ADD KEY `fk_ajucokezfirnldxqzekkkvfprsyyjbkscjep` (`parentId`);

--
-- Indexes for table `categorygroups`
--
ALTER TABLE `categorygroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_zweqyockusrvseeutativmyienoeinuieqzy` (`name`),
  ADD KEY `idx_uuatahxtcgrvcaezbfpkysymsvsolumomfof` (`handle`),
  ADD KEY `idx_odixxymdbdfntagqdtfyegumrhxqhnfgovdk` (`structureId`),
  ADD KEY `idx_dgabtjckacksadypodiypwpfouxjnddlbaiy` (`fieldLayoutId`),
  ADD KEY `idx_agcrqvoyjxezyxnwmvitybmplvbiffoxygvi` (`dateDeleted`);

--
-- Indexes for table `categorygroups_sites`
--
ALTER TABLE `categorygroups_sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_quxiawwqxoacbqhigekjzezmnsozfurxxsxc` (`groupId`,`siteId`),
  ADD KEY `idx_pamndicdcsbrnyftivulmuchyzhvosqwhwcg` (`siteId`);

--
-- Indexes for table `changedattributes`
--
ALTER TABLE `changedattributes`
  ADD PRIMARY KEY (`elementId`,`siteId`,`attribute`),
  ADD KEY `idx_wqnamdftalipousnhdswsqkosimlnqrmlrrj` (`elementId`,`siteId`,`dateUpdated`),
  ADD KEY `fk_abbdmtbueexfijffjpzhqapzchhusuwuejae` (`siteId`),
  ADD KEY `fk_gusupxsrhgynttckgzqozhihuxulgrpgkvhi` (`userId`);

--
-- Indexes for table `changedfields`
--
ALTER TABLE `changedfields`
  ADD PRIMARY KEY (`elementId`,`siteId`,`fieldId`,`layoutElementUid`),
  ADD KEY `idx_ekexqittaudlvslwwrbtxwanptwldigelive` (`elementId`,`siteId`,`dateUpdated`),
  ADD KEY `fk_bhhejjkbmntmszidtvfqlwhyfedptsktxwtk` (`siteId`),
  ADD KEY `fk_wxurkwhzdkypxuetemlblvemqfeomvlagjit` (`fieldId`),
  ADD KEY `fk_fbhfkmdltzwudrgxjsrlszevygcfrapbykzo` (`userId`);

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

--
-- Indexes for table `drafts`
--
ALTER TABLE `drafts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_qzzltufmncikudwlwznfaygzhframamqqpsk` (`creatorId`,`provisional`),
  ADD KEY `idx_voqsuroxfigzwckzvakudboshocnzyihfqnt` (`saved`),
  ADD KEY `fk_xmxrunludakiuqkhkvdcrdgeczwxfpppsfny` (`canonicalId`);

--
-- Indexes for table `elementactivity`
--
ALTER TABLE `elementactivity`
  ADD PRIMARY KEY (`elementId`,`userId`,`type`),
  ADD KEY `idx_nbiciymlkkywvppodjcodmgmzooihjlzjxri` (`elementId`,`timestamp`,`userId`),
  ADD KEY `fk_ldrobfznqjqpcnnddcjicuyoglngvcdkvukg` (`userId`),
  ADD KEY `fk_lzsqxkwrtbcrgpijtxtdamwjqcikvrippmkl` (`siteId`),
  ADD KEY `fk_hhoisxiqupkzuqpfttbyelgyykbeenearabk` (`draftId`);

--
-- Indexes for table `elements`
--
ALTER TABLE `elements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_bexihilapachlvflteiupdjcmlheewjjrpyc` (`dateDeleted`),
  ADD KEY `idx_olskjhpzdcphnqvxufhvilrfiwoyjhshxlkw` (`fieldLayoutId`),
  ADD KEY `idx_gnjkulskwgrkijedwysxijjymiqeazlhkani` (`type`),
  ADD KEY `idx_sflygxzwhvtjmzzozfpcxnwqxvhpipkricor` (`enabled`),
  ADD KEY `idx_vppdtdrguguqbddfynreribtchpmceoesjqw` (`canonicalId`),
  ADD KEY `idx_qtcnxamaqezmpkurhfhkwlzqpdppfhzbolft` (`archived`,`dateCreated`),
  ADD KEY `idx_kglhmcinugrucllhqsmocndssbytkrypvwiy` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`),
  ADD KEY `idx_nkseyhvuejsgjducuheqzxpqlfzgviauuwrf` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`,`enabled`),
  ADD KEY `fk_wtnyuahrdfcsoxohnrrfdfqnifljvgcxtiny` (`draftId`),
  ADD KEY `fk_oewuurtogiwcuanqvxidkobsamzpahhqzres` (`revisionId`);

--
-- Indexes for table `elements_owners`
--
ALTER TABLE `elements_owners`
  ADD PRIMARY KEY (`elementId`,`ownerId`),
  ADD KEY `fk_lmbsadjsaedtsozdetbtnyhsegxobdrauvyz` (`ownerId`);

--
-- Indexes for table `elements_sites`
--
ALTER TABLE `elements_sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_ykkxftwtdcnkrvzpuclzqlsamqhscvplrezt` (`elementId`,`siteId`),
  ADD KEY `idx_xblirzogltizpkocnjecfzolhedshfynudbb` (`siteId`),
  ADD KEY `idx_xaehyhzuoljgamatrxoxbeaqrgmhsqgwevmq` (`title`,`siteId`),
  ADD KEY `idx_ykmnigilunsxqwzgmpkztszjygtilkwuiwdo` (`slug`,`siteId`),
  ADD KEY `idx_jlpppdcuiuqkfpzmijfcjsryqyvhkeshekls` (`enabled`),
  ADD KEY `idx_quslmotvdwcyhvuavoqvoraxfczwjuzdrdzk` (`uri`,`siteId`);

--
-- Indexes for table `entries`
--
ALTER TABLE `entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_qufenhlkflopxlxkxtzqseqzhkgaphkadtcn` (`postDate`),
  ADD KEY `idx_kzzbqfqbpjetuulvspucnxxgwgekqjsnvejn` (`expiryDate`),
  ADD KEY `idx_hkqvphcwgkcminnccwqdpidewtgczmodxber` (`sectionId`),
  ADD KEY `idx_wbpzfgnztdvmulvopkteddlguuhquhexcczp` (`typeId`),
  ADD KEY `idx_qahefgilqauaejcbiucpnbtajfliovjvopsl` (`primaryOwnerId`),
  ADD KEY `idx_zocazhcyrzlxamwitfihwqtrhquxfoxcviae` (`fieldId`),
  ADD KEY `fk_uucwgxhkrqxgkxoqbkgrwuakfmdwhcjoxyoc` (`parentId`);

--
-- Indexes for table `entries_authors`
--
ALTER TABLE `entries_authors`
  ADD PRIMARY KEY (`entryId`,`authorId`),
  ADD KEY `idx_jarlvcvelweksmuzouwfvgveahzvrhegyueq` (`authorId`),
  ADD KEY `idx_zcidduttbknumphisyjgbwqbgblvveiyajta` (`entryId`,`sortOrder`);

--
-- Indexes for table `entrytypes`
--
ALTER TABLE `entrytypes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_yovlgushcinlwgvmxpvybnvjqzxmtqcvgqqo` (`fieldLayoutId`),
  ADD KEY `idx_earzymkyuovelxpeczjivdeknqrsoazlbqjk` (`dateDeleted`);

--
-- Indexes for table `fieldlayouts`
--
ALTER TABLE `fieldlayouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_sakbuxfnkfrbmoipefntygyizmisjhkjrbgc` (`dateDeleted`),
  ADD KEY `idx_eyohcefcpwztouksnvacqqjzcpjrqjpocsoi` (`type`);

--
-- Indexes for table `fields`
--
ALTER TABLE `fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_buiyyyuuedxvwffmrwpsgoaphpajpnpdwhdm` (`handle`,`context`),
  ADD KEY `idx_nyoiwntoshrjpsdyldyhyfykexqhvraejaqs` (`context`),
  ADD KEY `idx_ithkslibdtvrsxijukrushxvaaadzbskczyx` (`dateDeleted`);

--
-- Indexes for table `freeform_crm_fields`
--
ALTER TABLE `freeform_crm_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_crm_fields_type_idx` (`type`),
  ADD KEY `freeform_crm_fields_integrationId_category_idx` (`integrationId`,`category`);

--
-- Indexes for table `freeform_email_marketing_fields`
--
ALTER TABLE `freeform_email_marketing_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_email_marketing_fields_type_idx` (`type`),
  ADD KEY `freeform_email_marketing_fields_mailingListId_category_idx` (`mailingListId`,`category`);

--
-- Indexes for table `freeform_email_marketing_lists`
--
ALTER TABLE `freeform_email_marketing_lists`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `freeform_email_marketing_lists_integrationId_resourceId_unq_idx` (`integrationId`,`resourceId`);

--
-- Indexes for table `freeform_export_notifications`
--
ALTER TABLE `freeform_export_notifications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `freeform_export_notifications_profileId_fk` (`profileId`);

--
-- Indexes for table `freeform_export_profiles`
--
ALTER TABLE `freeform_export_profiles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `freeform_export_profiles_formId_fk` (`formId`);

--
-- Indexes for table `freeform_export_settings`
--
ALTER TABLE `freeform_export_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_export_settings_userId_fk` (`userId`);

--
-- Indexes for table `freeform_favorite_fields`
--
ALTER TABLE `freeform_favorite_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_favorite_fields_userId_fk` (`userId`);

--
-- Indexes for table `freeform_feed_messages`
--
ALTER TABLE `freeform_feed_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_feed_messages_feedId_fk` (`feedId`);

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

--
-- Indexes for table `freeform_forms`
--
ALTER TABLE `freeform_forms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `handle` (`handle`),
  ADD KEY `freeform_forms_order_idx` (`order`),
  ADD KEY `freeform_forms_createdByUserId_fk` (`createdByUserId`),
  ADD KEY `freeform_forms_updatedByUserId_fk` (`updatedByUserId`);

--
-- Indexes for table `freeform_forms_fields`
--
ALTER TABLE `freeform_forms_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_forms_fields_rowId_order_idx` (`rowId`,`order`),
  ADD KEY `freeform_forms_fields_formId_fk` (`formId`);

--
-- Indexes for table `freeform_forms_groups`
--
ALTER TABLE `freeform_forms_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_forms_groups_siteId_fk` (`siteId`);

--
-- Indexes for table `freeform_forms_groups_entries`
--
ALTER TABLE `freeform_forms_groups_entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_forms_groups_entries_groupId_fk` (`groupId`),
  ADD KEY `freeform_forms_groups_entries_formId_fk` (`formId`);

--
-- Indexes for table `freeform_forms_integrations`
--
ALTER TABLE `freeform_forms_integrations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_forms_integrations_integrationId_fk` (`integrationId`),
  ADD KEY `freeform_forms_integrations_formId_fk` (`formId`);

--
-- Indexes for table `freeform_forms_layouts`
--
ALTER TABLE `freeform_forms_layouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_forms_layouts_formId_idx` (`formId`);

--
-- Indexes for table `freeform_forms_notifications`
--
ALTER TABLE `freeform_forms_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_forms_notifications_formId_fk` (`formId`);

--
-- Indexes for table `freeform_forms_pages`
--
ALTER TABLE `freeform_forms_pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_forms_pages_formId_order_idx` (`formId`,`order`),
  ADD KEY `freeform_forms_pages_layoutId_fk` (`layoutId`);

--
-- Indexes for table `freeform_forms_rows`
--
ALTER TABLE `freeform_forms_rows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_forms_rows_formId_order_idx` (`formId`,`order`),
  ADD KEY `freeform_forms_rows_layoutId_fk` (`layoutId`);

--
-- Indexes for table `freeform_forms_sites`
--
ALTER TABLE `freeform_forms_sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `freeform_forms_sites_siteId_formId_unq_idx` (`siteId`,`formId`),
  ADD KEY `freeform_forms_sites_formId_fk` (`formId`);

--
-- Indexes for table `freeform_forms_translations`
--
ALTER TABLE `freeform_forms_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `freeform_forms_translations_formId_siteId_unq_idx` (`formId`,`siteId`),
  ADD KEY `freeform_forms_translations_siteId_fk` (`siteId`);

--
-- Indexes for table `freeform_integrations`
--
ALTER TABLE `freeform_integrations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `handle` (`handle`),
  ADD KEY `freeform_integrations_type_idx` (`type`);

--
-- Indexes for table `freeform_integrations_queue`
--
ALTER TABLE `freeform_integrations_queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_integrations_queue_status_idx` (`status`),
  ADD KEY `freeform_integrations_queue_submissionId_fk` (`submissionId`);

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

--
-- Indexes for table `freeform_notification_log`
--
ALTER TABLE `freeform_notification_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_notification_log_type_dateCreated_idx` (`type`,`dateCreated`);

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

--
-- Indexes for table `freeform_payments`
--
ALTER TABLE `freeform_payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `freeform_payments_integrationId_resourceId_unq_idx` (`integrationId`,`resourceId`),
  ADD KEY `freeform_payments_integrationId_type_idx` (`integrationId`,`type`),
  ADD KEY `freeform_payments_resourceId_idx` (`resourceId`),
  ADD KEY `freeform_payments_fieldId_fk` (`fieldId`),
  ADD KEY `freeform_payments_submissionId_fk` (`submissionId`);

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

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

--
-- Indexes for table `freeform_rules_buttons`
--
ALTER TABLE `freeform_rules_buttons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_mqanzyduuwbosmfnywgfxbssnlciwiuzkgmc` (`pageId`);

--
-- Indexes for table `freeform_rules_conditions`
--
ALTER TABLE `freeform_rules_conditions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_rules_conditions_ruleId_fk` (`ruleId`),
  ADD KEY `fk_uxwbrioulrykihemdyddjvpirbalnnvgwtfr` (`fieldId`);

--
-- Indexes for table `freeform_rules_fields`
--
ALTER TABLE `freeform_rules_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_fjgaacrkrbxvuhioorpghhxxzillpddmaenl` (`fieldId`);

--
-- Indexes for table `freeform_rules_notifications`
--
ALTER TABLE `freeform_rules_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_crsjpfznkfwtxpfoclnygtsasenwzsfungwg` (`notificationId`);

--
-- Indexes for table `freeform_rules_pages`
--
ALTER TABLE `freeform_rules_pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_fnshbccfzpfawpkzlsybykkedeussznatodz` (`pageId`);

--
-- Indexes for table `freeform_rules_submit_form`
--
ALTER TABLE `freeform_rules_submit_form`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_salmgnimuqshonsoxpcoylbsivgqjbtflmvc` (`formId`);

--
-- Indexes for table `freeform_spam_reason`
--
ALTER TABLE `freeform_spam_reason`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_spam_reason_submissionId_reasonType_idx` (`submissionId`,`reasonType`);

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

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

--
-- Indexes for table `freeform_submission_notes`
--
ALTER TABLE `freeform_submission_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_submission_notes_submissionId_fk` (`submissionId`);

--
-- Indexes for table `freeform_survey_preferences`
--
ALTER TABLE `freeform_survey_preferences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `freeform_survey_preferences_userId_fk` (`userId`),
  ADD KEY `fk_itbjtoclhsvjfsudjbqppdgdcilrajazohso` (`fieldId`);

--
-- Indexes for table `globalsets`
--
ALTER TABLE `globalsets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_cwxjpnditduivrusixpgabxwgbiodavdevrw` (`name`),
  ADD KEY `idx_islluiullsltzszlylovedllbiwjsvreeugn` (`handle`),
  ADD KEY `idx_hgfzlragtvvbyvwumzhejtokbsguhkckbpvg` (`fieldLayoutId`),
  ADD KEY `idx_ydsvlcnkhppshixicungbgfqrxlorxulrpul` (`sortOrder`);

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

--
-- Indexes for table `imagetransformindex`
--
ALTER TABLE `imagetransformindex`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_bdvecnoktxbmhjutxfwndzzmuzpucymzvyih` (`assetId`,`transformString`);

--
-- Indexes for table `imagetransforms`
--
ALTER TABLE `imagetransforms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_urbalkvbnknputzgvhyqurrfxruzwxlgcuwd` (`name`),
  ADD KEY `idx_ulnydoskxvxkhegcxmxqnviudfdegoiqeipi` (`handle`);

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

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_cpppwqeapngbxrynwzdqsrafpeolgaovwmje` (`track`,`name`);

--
-- Indexes for table `plugins`
--
ALTER TABLE `plugins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_fzznonvkwmjiykhzrukbylumlhjbnvogzbyg` (`handle`);

--
-- Indexes for table `projectconfig`
--
ALTER TABLE `projectconfig`
  ADD PRIMARY KEY (`path`);

--
-- Indexes for table `queue`
--
ALTER TABLE `queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_cakebezvcuurshysxctrbcmxiadygabczpdb` (`channel`,`fail`,`timeUpdated`,`timePushed`),
  ADD KEY `idx_aevzdgbhagwffhaxfsuaamzvsisiizmnkitc` (`channel`,`fail`,`timeUpdated`,`delay`);

--
-- Indexes for table `relations`
--
ALTER TABLE `relations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_ecdgfvuousanpugrtvbpxlzjdmlbdyjhyomr` (`fieldId`,`sourceId`,`sourceSiteId`,`targetId`),
  ADD KEY `idx_qoefjesgdtjmjqafothhsedgkuevnivzdngr` (`sourceId`),
  ADD KEY `idx_qkointqqxuijrsnnedjyxmrlqxwtqbinyhcq` (`targetId`),
  ADD KEY `idx_mhyuktzdjxuwezfyrwhismdkrqteoacglonj` (`sourceSiteId`);

--
-- Indexes for table `revisions`
--
ALTER TABLE `revisions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_xcbcjzkmbccnhovxtoocgfyuypdczohfynjd` (`canonicalId`,`num`),
  ADD KEY `fk_gzwamngpaprpjyszfrhgpytkxhzttkbgugtx` (`creatorId`);

--
-- Indexes for table `searchindex`
--
ALTER TABLE `searchindex`
  ADD PRIMARY KEY (`elementId`,`attribute`,`fieldId`,`siteId`);
ALTER TABLE `searchindex` ADD FULLTEXT KEY `idx_xfgzxvdpsjqvkfketxepkpjbawpnpgdderur` (`keywords`);

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_vvcuvkylkurwdfwzkcviddbcqnkuvpfpfxnn` (`handle`),
  ADD KEY `idx_pfxvjxfgyiqkdrrelovbkwoezbderkqethfl` (`name`),
  ADD KEY `idx_qysbsyazzdexbyxprzmrcmjqfqaiqfyfrysr` (`structureId`),
  ADD KEY `idx_tyyvkpspunjlamazrkoplohuunqkeztyhjah` (`dateDeleted`);

--
-- Indexes for table `sections_entrytypes`
--
ALTER TABLE `sections_entrytypes`
  ADD PRIMARY KEY (`sectionId`,`typeId`),
  ADD KEY `fk_exkjhqiuwzollhtfdhbezbnnfrvvrvesenbq` (`typeId`);

--
-- Indexes for table `sections_sites`
--
ALTER TABLE `sections_sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_azygefeltrcjxxmtnnacrghfqbczmxfftevx` (`sectionId`,`siteId`),
  ADD KEY `idx_tucqfzaebvrejszgfcfumvdukfxhebaxspqd` (`siteId`);

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

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

--
-- Indexes for table `sequences`
--
ALTER TABLE `sequences`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `shunnedmessages`
--
ALTER TABLE `shunnedmessages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_xjxdnbwswfrdujwypslcjsizdbwferskxxxq` (`userId`,`message`);

--
-- Indexes for table `sitegroups`
--
ALTER TABLE `sitegroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_jrfjxvqowujtsknmjerpctjyzqgavkyuqpyi` (`name`);

--
-- Indexes for table `sites`
--
ALTER TABLE `sites`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_eqdlbzthxwjxtsftbxkfjxhbjgzsmvrthnlg` (`dateDeleted`),
  ADD KEY `idx_lzcsiegcgqhycsbnjgxflvpozmojbshzhqka` (`handle`),
  ADD KEY `idx_lpbmwlwahgavowronziwfmprcwzabsrqfvvf` (`sortOrder`),
  ADD KEY `fk_iwohwnhpcpomluswfnjumuhecnawhnqsaugw` (`groupId`);

--
-- Indexes for table `sso_identities`
--
ALTER TABLE `sso_identities`
  ADD PRIMARY KEY (`provider`,`identityId`,`userId`),
  ADD KEY `fk_srqutrsyuvbgeekjbuhfccdgbufmpinwywgm` (`userId`);

--
-- Indexes for table `structureelements`
--
ALTER TABLE `structureelements`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_cluqrnyfypfsgwzgefuvhjqikwouqowpjfxv` (`structureId`,`elementId`),
  ADD KEY `idx_sezgaeollppvldvsfrlozgnztjuamqwvtxqm` (`root`),
  ADD KEY `idx_uplczwobqojxzmesqjfmwvzjezgkvbicjzkk` (`lft`),
  ADD KEY `idx_bqnagmrhmzgjqfjxbrbwwzlboocvgiclzvmq` (`rgt`),
  ADD KEY `idx_apjmmeikgbybyfoiuwatldnznuyguvhvluwg` (`level`),
  ADD KEY `idx_zjxvmcbacjqxwgbxvzxwjjboaxitgpwhnunq` (`elementId`);

--
-- Indexes for table `structures`
--
ALTER TABLE `structures`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_czpqbjibshdiiwtetnvwzgkagsvodaqsegyy` (`dateDeleted`);

--
-- Indexes for table `taggroups`
--
ALTER TABLE `taggroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ckqstkcsyxmvvsplpautpxlzrjbjeyispwgo` (`name`),
  ADD KEY `idx_owyrciurnepbotfyvzeumrxftazqhahnqmpl` (`handle`),
  ADD KEY `idx_oaesmhnkvckbkkjbgmdtliyvnhauulaaxivu` (`dateDeleted`),
  ADD KEY `fk_gewmxthqhrkksqpwtouowzzzaztpqumlvxea` (`fieldLayoutId`);

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_gjctoetuurrjbenusyqjdzlcpmzfvwqhqllq` (`groupId`);

--
-- Indexes for table `usergroups`
--
ALTER TABLE `usergroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_bdeifsnejdkhusgrupzwkjtrzkxwmjvrbmgj` (`handle`),
  ADD KEY `idx_tigdtdoyukgamfycztrmuapkevryqzpcitkn` (`name`);

--
-- Indexes for table `usergroups_users`
--
ALTER TABLE `usergroups_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_pjvhvicppqtsmchqssagtyhqjnfoikjzwjrj` (`groupId`,`userId`),
  ADD KEY `idx_kckhtejwxvvxadijyejckkyivgcphhtuxtqs` (`userId`);

--
-- Indexes for table `userpermissions`
--
ALTER TABLE `userpermissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_yvnioxhrobvcfftqubvdcwbadvaugglpageo` (`name`);

--
-- Indexes for table `userpermissions_usergroups`
--
ALTER TABLE `userpermissions_usergroups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_fcnxfrnuiydzkhvnnxrqlahorroppmxabync` (`permissionId`,`groupId`),
  ADD KEY `idx_kugayiuyxuypyuyadbfzqcidrikmuflczmum` (`groupId`);

--
-- Indexes for table `userpermissions_users`
--
ALTER TABLE `userpermissions_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_vfozgpkgyoslgjtlmrdbtjtketowbnadmemj` (`permissionId`,`userId`),
  ADD KEY `idx_lnlsqubonmzdjtcipzlslskvknnbivmymyoz` (`userId`);

--
-- Indexes for table `userpreferences`
--
ALTER TABLE `userpreferences`
  ADD PRIMARY KEY (`userId`);

--
-- Indexes for table `volumefolders`
--
ALTER TABLE `volumefolders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_bogloweetzjqjlzxopgkzgnjeyxhgtgqamgs` (`name`,`parentId`,`volumeId`),
  ADD KEY `idx_jrrqsxdurswrermfiuimbnscohzvklvsuyyw` (`parentId`),
  ADD KEY `idx_lxnzmwtqdhvbspvnbiczirfwgjpmqfcegpou` (`volumeId`);

--
-- Indexes for table `volumes`
--
ALTER TABLE `volumes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_qzbdnejawrbiprppmamnukmqmnsuhnirqsbp` (`name`),
  ADD KEY `idx_cxsskjxqltunsowytzxyktpvkovbsdtlbsfo` (`handle`),
  ADD KEY `idx_xzrujerdvovadaratwoufwciwopeksjmpqch` (`fieldLayoutId`),
  ADD KEY `idx_gzxoehdjmqcieypsbwzvsexspgtoznfefdef` (`dateDeleted`);

--
-- Indexes for table `widgets`
--
ALTER TABLE `widgets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_sghgbcnqsfygeixcppmlbbohaajzflqhpble` (`userId`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `announcements`
--
ALTER TABLE `announcements`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assetindexingsessions`
--
ALTER TABLE `assetindexingsessions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `categorygroups`
--
ALTER TABLE `categorygroups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `categorygroups_sites`
--
ALTER TABLE `categorygroups_sites`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `drafts`
--
ALTER TABLE `drafts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=595;

--
-- AUTO_INCREMENT for table `elements`
--
ALTER TABLE `elements`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1498;

--
-- AUTO_INCREMENT for table `elements_sites`
--
ALTER TABLE `elements_sites`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1498;

--
-- AUTO_INCREMENT for table `entrytypes`
--
ALTER TABLE `entrytypes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `fieldlayouts`
--
ALTER TABLE `fieldlayouts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `fields`
--
ALTER TABLE `fields`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `freeform_crm_fields`
--
ALTER TABLE `freeform_crm_fields`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_email_marketing_fields`
--
ALTER TABLE `freeform_email_marketing_fields`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_email_marketing_lists`
--
ALTER TABLE `freeform_email_marketing_lists`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_export_notifications`
--
ALTER TABLE `freeform_export_notifications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_export_profiles`
--
ALTER TABLE `freeform_export_profiles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_export_settings`
--
ALTER TABLE `freeform_export_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_favorite_fields`
--
ALTER TABLE `freeform_favorite_fields`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_feed_messages`
--
ALTER TABLE `freeform_feed_messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_fields_type_groups`
--
ALTER TABLE `freeform_fields_type_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `freeform_forms`
--
ALTER TABLE `freeform_forms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `freeform_forms_fields`
--
ALTER TABLE `freeform_forms_fields`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `freeform_forms_groups`
--
ALTER TABLE `freeform_forms_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_forms_groups_entries`
--
ALTER TABLE `freeform_forms_groups_entries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_forms_integrations`
--
ALTER TABLE `freeform_forms_integrations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_forms_layouts`
--
ALTER TABLE `freeform_forms_layouts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `freeform_forms_notifications`
--
ALTER TABLE `freeform_forms_notifications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `freeform_forms_pages`
--
ALTER TABLE `freeform_forms_pages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `freeform_forms_rows`
--
ALTER TABLE `freeform_forms_rows`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `freeform_forms_sites`
--
ALTER TABLE `freeform_forms_sites`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `freeform_forms_translations`
--
ALTER TABLE `freeform_forms_translations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_integrations`
--
ALTER TABLE `freeform_integrations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_integrations_queue`
--
ALTER TABLE `freeform_integrations_queue`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_limited_users`
--
ALTER TABLE `freeform_limited_users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_notification_log`
--
ALTER TABLE `freeform_notification_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_notification_templates`
--
ALTER TABLE `freeform_notification_templates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `freeform_payments`
--
ALTER TABLE `freeform_payments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_pdf_templates`
--
ALTER TABLE `freeform_pdf_templates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_rules`
--
ALTER TABLE `freeform_rules`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_rules_buttons`
--
ALTER TABLE `freeform_rules_buttons`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_rules_conditions`
--
ALTER TABLE `freeform_rules_conditions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_rules_fields`
--
ALTER TABLE `freeform_rules_fields`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_rules_notifications`
--
ALTER TABLE `freeform_rules_notifications`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_rules_pages`
--
ALTER TABLE `freeform_rules_pages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_rules_submit_form`
--
ALTER TABLE `freeform_rules_submit_form`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_spam_reason`
--
ALTER TABLE `freeform_spam_reason`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_statuses`
--
ALTER TABLE `freeform_statuses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `freeform_submission_notes`
--
ALTER TABLE `freeform_submission_notes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `freeform_survey_preferences`
--
ALTER TABLE `freeform_survey_preferences`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `globalsets`
--
ALTER TABLE `globalsets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1441;

--
-- AUTO_INCREMENT for table `gqlschemas`
--
ALTER TABLE `gqlschemas`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `imagetransformindex`
--
ALTER TABLE `imagetransformindex`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `imagetransforms`
--
ALTER TABLE `imagetransforms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `info`
--
ALTER TABLE `info`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160;

--
-- AUTO_INCREMENT for table `plugins`
--
ALTER TABLE `plugins`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `queue`
--
ALTER TABLE `queue`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3090;

--
-- AUTO_INCREMENT for table `relations`
--
ALTER TABLE `relations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1816;

--
-- AUTO_INCREMENT for table `revisions`
--
ALTER TABLE `revisions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=543;

--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `sections_sites`
--
ALTER TABLE `sections_sites`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `seo_redirects`
--
ALTER TABLE `seo_redirects`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `seo_sitemap`
--
ALTER TABLE `seo_sitemap`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `shunnedmessages`
--
ALTER TABLE `shunnedmessages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sitegroups`
--
ALTER TABLE `sitegroups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sites`
--
ALTER TABLE `sites`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `structureelements`
--
ALTER TABLE `structureelements`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `structures`
--
ALTER TABLE `structures`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `taggroups`
--
ALTER TABLE `taggroups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usergroups`
--
ALTER TABLE `usergroups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usergroups_users`
--
ALTER TABLE `usergroups_users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userpermissions`
--
ALTER TABLE `userpermissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userpermissions_usergroups`
--
ALTER TABLE `userpermissions_usergroups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userpermissions_users`
--
ALTER TABLE `userpermissions_users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userpreferences`
--
ALTER TABLE `userpreferences`
  MODIFY `userId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `volumefolders`
--
ALTER TABLE `volumefolders`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `volumes`
--
ALTER TABLE `volumes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `widgets`
--
ALTER TABLE `widgets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `addresses`
--
ALTER TABLE `addresses`
  ADD CONSTRAINT `fk_ezshtsfnwmiuhxkdmevqhcbycftpsiajghty` FOREIGN KEY (`primaryOwnerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_vzwjybpyvdpdjonqkjdlhuxefpmtyondlwdf` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `announcements`
--
ALTER TABLE `announcements`
  ADD CONSTRAINT `fk_dqvrsktprktwebzpaisdcmrgcuqaitcwpbal` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_rwtqyyvckgrrpcqtmxngspehbabhappihaob` FOREIGN KEY (`pluginId`) REFERENCES `plugins` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `assets`
--
ALTER TABLE `assets`
  ADD CONSTRAINT `fk_cvwdaygrgkptybgtbwjpybtxmzkrcrywmjec` FOREIGN KEY (`folderId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_fhdvqgjbamxgjqqnexxlaviqarxejcurfhfs` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_ocmwwozrbnfjmqknuzaqxauntpivjoopoqby` FOREIGN KEY (`uploaderId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_wqgqubnopiwobjhgxvjqjmuekxfoxgcwzklk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `assets_sites`
--
ALTER TABLE `assets_sites`
  ADD CONSTRAINT `fk_fgejcrorsxcfxbayxhmlbqocksijjofbfhcn` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_mkvmjhsgyizuiamimotgmgmvkblabatmcjcq` FOREIGN KEY (`assetId`) REFERENCES `assets` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `fk_ajucokezfirnldxqzekkkvfprsyyjbkscjep` FOREIGN KEY (`parentId`) REFERENCES `categories` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_jjdeziudsivhkrnqktajbwrugglipgoevado` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_unpebfovaahpgojwpmbfvhxuhluraqnblypv` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `categorygroups`
--
ALTER TABLE `categorygroups`
  ADD CONSTRAINT `fk_fitonreroalxtcfbllbegnmtgmnvcyzngxks` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_jnnyaauqgxrirckmmhubmeyejfnsrtlducac` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `categorygroups_sites`
--
ALTER TABLE `categorygroups_sites`
  ADD CONSTRAINT `fk_afzivicksebhmiipqakqvtckqlpnqkyhddve` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_eydbacamvmbgcmstjcbjzrbnxisrjlozzcbu` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `changedattributes`
--
ALTER TABLE `changedattributes`
  ADD CONSTRAINT `fk_abbdmtbueexfijffjpzhqapzchhusuwuejae` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_gusupxsrhgynttckgzqozhihuxulgrpgkvhi` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_pvcgpvyykpgjlxdfkvozjaopijolbcxmdgwd` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `changedfields`
--
ALTER TABLE `changedfields`
  ADD CONSTRAINT `fk_bhhejjkbmntmszidtvfqlwhyfedptsktxwtk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_fbhfkmdltzwudrgxjsrlszevygcfrapbykzo` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_wkxakrdasbfvfoiungohmawdqlkuygblieuh` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_wxurkwhzdkypxuetemlblvemqfeomvlagjit` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `contactform_submissions`
--
ALTER TABLE `contactform_submissions`
  ADD CONSTRAINT `fk_vvmnqrjhdkzyumtkmyxxwcornrmjngtlsjtn` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `drafts`
--
ALTER TABLE `drafts`
  ADD CONSTRAINT `fk_xaeyytjjkfbpaqcwvodkwrbwmtoxtgphhnne` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_xmxrunludakiuqkhkvdcrdgeczwxfpppsfny` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `elementactivity`
--
ALTER TABLE `elementactivity`
  ADD CONSTRAINT `fk_hhoisxiqupkzuqpfttbyelgyykbeenearabk` FOREIGN KEY (`draftId`) REFERENCES `drafts` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_ldrobfznqjqpcnnddcjicuyoglngvcdkvukg` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_lzsqxkwrtbcrgpijtxtdamwjqcikvrippmkl` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_sifbzjmlzvozwppsmurjlzdiowrlmoaprkjl` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `elements`
--
ALTER TABLE `elements`
  ADD CONSTRAINT `fk_ndjafdkqhogmzzsrryusxzmbhuleevrhtntp` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_oewuurtogiwcuanqvxidkobsamzpahhqzres` FOREIGN KEY (`revisionId`) REFERENCES `revisions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_wtnyuahrdfcsoxohnrrfdfqnifljvgcxtiny` FOREIGN KEY (`draftId`) REFERENCES `drafts` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_yeadpdzhdlhqfbzqwxgakrtopablnfpgmltc` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;

--
-- Constraints for table `elements_owners`
--
ALTER TABLE `elements_owners`
  ADD CONSTRAINT `fk_dsyrcmzsasuhepllkyzbdtqbyitocrtilezc` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_lmbsadjsaedtsozdetbtnyhsegxobdrauvyz` FOREIGN KEY (`ownerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `elements_sites`
--
ALTER TABLE `elements_sites`
  ADD CONSTRAINT `fk_dzhiyofxolytsdhngnowxwefwylcdkgkfjmk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_ffdgcydonuqdfmxhtstxfkxzdremwpwvzraw` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `entries`
--
ALTER TABLE `entries`
  ADD CONSTRAINT `fk_avcylvtbolqzvewpmsmjznfuenyatybfeajy` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_rscoagfgoqqvkdnxgkvqkxgprlthlbygvmlq` FOREIGN KEY (`primaryOwnerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_uqnocyrsfmbtwpphqgajyugkvrvadffaykjm` FOREIGN KEY (`typeId`) REFERENCES `entrytypes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_uucwgxhkrqxgkxoqbkgrwuakfmdwhcjoxyoc` FOREIGN KEY (`parentId`) REFERENCES `entries` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_xaofdscprltkfsfkolzxjhtzhxaprshpudjf` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_zccsdbvdsvrkawcdaanjgonnfwomvybjmczp` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `entries_authors`
--
ALTER TABLE `entries_authors`
  ADD CONSTRAINT `fk_dikhekgvqbwjwrwivqybuorrpmtzoxgygyco` FOREIGN KEY (`entryId`) REFERENCES `entries` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_ixbiztapwkfxbslzoohjjhnsegzntymqqwqo` FOREIGN KEY (`authorId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `entrytypes`
--
ALTER TABLE `entrytypes`
  ADD CONSTRAINT `fk_xbxemdournkwolmdffoyykshpuhohtkbkfzm` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;

--
-- Constraints for table `freeform_crm_fields`
--
ALTER TABLE `freeform_crm_fields`
  ADD CONSTRAINT `freeform_crm_fields_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `freeform_integrations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_email_marketing_fields`
--
ALTER TABLE `freeform_email_marketing_fields`
  ADD CONSTRAINT `freeform_email_marketing_fields_mailingListId_fk` FOREIGN KEY (`mailingListId`) REFERENCES `freeform_email_marketing_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_email_marketing_lists`
--
ALTER TABLE `freeform_email_marketing_lists`
  ADD CONSTRAINT `freeform_email_marketing_lists_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `freeform_integrations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_export_notifications`
--
ALTER TABLE `freeform_export_notifications`
  ADD CONSTRAINT `freeform_export_notifications_profileId_fk` FOREIGN KEY (`profileId`) REFERENCES `freeform_export_profiles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_export_profiles`
--
ALTER TABLE `freeform_export_profiles`
  ADD CONSTRAINT `freeform_export_profiles_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_export_settings`
--
ALTER TABLE `freeform_export_settings`
  ADD CONSTRAINT `freeform_export_settings_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_favorite_fields`
--
ALTER TABLE `freeform_favorite_fields`
  ADD CONSTRAINT `freeform_favorite_fields_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_feed_messages`
--
ALTER TABLE `freeform_feed_messages`
  ADD CONSTRAINT `freeform_feed_messages_feedId_fk` FOREIGN KEY (`feedId`) REFERENCES `freeform_feeds` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms`
--
ALTER TABLE `freeform_forms`
  ADD CONSTRAINT `freeform_forms_createdByUserId_fk` FOREIGN KEY (`createdByUserId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `freeform_forms_updatedByUserId_fk` FOREIGN KEY (`updatedByUserId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `freeform_forms_fields`
--
ALTER TABLE `freeform_forms_fields`
  ADD CONSTRAINT `freeform_forms_fields_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_forms_fields_rowId_fk` FOREIGN KEY (`rowId`) REFERENCES `freeform_forms_rows` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `freeform_forms_groups`
--
ALTER TABLE `freeform_forms_groups`
  ADD CONSTRAINT `freeform_forms_groups_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms_groups_entries`
--
ALTER TABLE `freeform_forms_groups_entries`
  ADD CONSTRAINT `freeform_forms_groups_entries_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_forms_groups_entries_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `freeform_forms_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms_integrations`
--
ALTER TABLE `freeform_forms_integrations`
  ADD CONSTRAINT `freeform_forms_integrations_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_forms_integrations_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `freeform_integrations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms_layouts`
--
ALTER TABLE `freeform_forms_layouts`
  ADD CONSTRAINT `freeform_forms_layouts_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms_notifications`
--
ALTER TABLE `freeform_forms_notifications`
  ADD CONSTRAINT `freeform_forms_notifications_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms_pages`
--
ALTER TABLE `freeform_forms_pages`
  ADD CONSTRAINT `freeform_forms_pages_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_forms_pages_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `freeform_forms_layouts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms_rows`
--
ALTER TABLE `freeform_forms_rows`
  ADD CONSTRAINT `freeform_forms_rows_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_forms_rows_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `freeform_forms_layouts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms_sites`
--
ALTER TABLE `freeform_forms_sites`
  ADD CONSTRAINT `freeform_forms_sites_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_forms_sites_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_forms_translations`
--
ALTER TABLE `freeform_forms_translations`
  ADD CONSTRAINT `freeform_forms_translations_formId_fk` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_forms_translations_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_integrations_queue`
--
ALTER TABLE `freeform_integrations_queue`
  ADD CONSTRAINT `freeform_integrations_queue_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `freeform_submissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_payments`
--
ALTER TABLE `freeform_payments`
  ADD CONSTRAINT `freeform_payments_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `freeform_forms_fields` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_payments_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `freeform_integrations` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_payments_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `freeform_submissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_rules_buttons`
--
ALTER TABLE `freeform_rules_buttons`
  ADD CONSTRAINT `fk_mqanzyduuwbosmfnywgfxbssnlciwiuzkgmc` FOREIGN KEY (`pageId`) REFERENCES `freeform_forms_pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_tldfwtxhxkltvtwhuhdjiubhtworskobodwt` FOREIGN KEY (`id`) REFERENCES `freeform_rules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `freeform_rules_conditions`
--
ALTER TABLE `freeform_rules_conditions`
  ADD CONSTRAINT `fk_uxwbrioulrykihemdyddjvpirbalnnvgwtfr` FOREIGN KEY (`fieldId`) REFERENCES `freeform_forms_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `freeform_rules_conditions_ruleId_fk` FOREIGN KEY (`ruleId`) REFERENCES `freeform_rules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `freeform_rules_fields`
--
ALTER TABLE `freeform_rules_fields`
  ADD CONSTRAINT `fk_fjgaacrkrbxvuhioorpghhxxzillpddmaenl` FOREIGN KEY (`fieldId`) REFERENCES `freeform_forms_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_xmgxzkzenmvwoyeprqqufroaoemzhtcxvkfa` FOREIGN KEY (`id`) REFERENCES `freeform_rules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `freeform_rules_notifications`
--
ALTER TABLE `freeform_rules_notifications`
  ADD CONSTRAINT `fk_crsjpfznkfwtxpfoclnygtsasenwzsfungwg` FOREIGN KEY (`notificationId`) REFERENCES `freeform_forms_notifications` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_yfbcyaqhxplvocdwzcdsiitcrqayztrrveoq` FOREIGN KEY (`id`) REFERENCES `freeform_rules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `freeform_rules_pages`
--
ALTER TABLE `freeform_rules_pages`
  ADD CONSTRAINT `fk_fnshbccfzpfawpkzlsybykkedeussznatodz` FOREIGN KEY (`pageId`) REFERENCES `freeform_forms_pages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_simjkcpwdinegmcffpkdnwwszjxsxpxvyqtn` FOREIGN KEY (`id`) REFERENCES `freeform_rules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `freeform_rules_submit_form`
--
ALTER TABLE `freeform_rules_submit_form`
  ADD CONSTRAINT `fk_aaygdaqakpwfadqivgzgnxctwmmxkobnzrqz` FOREIGN KEY (`id`) REFERENCES `freeform_rules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_salmgnimuqshonsoxpcoylbsivgqjbtflmvc` FOREIGN KEY (`formId`) REFERENCES `freeform_forms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `freeform_spam_reason`
--
ALTER TABLE `freeform_spam_reason`
  ADD CONSTRAINT `freeform_spam_reason_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `freeform_submissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_submissions_contact_us_1`
--
ALTER TABLE `freeform_submissions_contact_us_1`
  ADD CONSTRAINT `fk_zbnbbfnzvaidmxwwtmzxvucscjkhvjyyqdva` FOREIGN KEY (`id`) REFERENCES `freeform_submissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_submission_notes`
--
ALTER TABLE `freeform_submission_notes`
  ADD CONSTRAINT `freeform_submission_notes_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `freeform_submissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `freeform_survey_preferences`
--
ALTER TABLE `freeform_survey_preferences`
  ADD CONSTRAINT `fk_itbjtoclhsvjfsudjbqppdgdcilrajazohso` FOREIGN KEY (`fieldId`) REFERENCES `freeform_forms_fields` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `freeform_survey_preferences_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `globalsets`
--
ALTER TABLE `globalsets`
  ADD CONSTRAINT `fk_kengsxczwtssptwprpiffdlxjatlnctunloz` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_opgjqosvjuqjtgwicxidetwuxpbcgufyrxaq` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;

--
-- Constraints for table `relations`
--
ALTER TABLE `relations`
  ADD CONSTRAINT `fk_gcemgdklmrnzznmbanpsvbjeybfgoeyqrfcq` FOREIGN KEY (`sourceSiteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_qqcrscvajkzheelhmjnghqhywnbyyefjcfkn` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_wseqbfpjlktousxtkvhcvixvcjsvndpkhbac` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `revisions`
--
ALTER TABLE `revisions`
  ADD CONSTRAINT `fk_gzwamngpaprpjyszfrhgpytkxhzttkbgugtx` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_uzmxblibkfpjdkdtznenkjnzmnbsbgigiled` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `sections`
--
ALTER TABLE `sections`
  ADD CONSTRAINT `fk_yegxpzcitpqusrgzxrlebnkceghoxqcfhzxp` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;

--
-- Constraints for table `sections_entrytypes`
--
ALTER TABLE `sections_entrytypes`
  ADD CONSTRAINT `fk_exkjhqiuwzollhtfdhbezbnnfrvvrvesenbq` FOREIGN KEY (`typeId`) REFERENCES `entrytypes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_vcccsljfbcfrbzjsmtxedpoqqdhzcvwyppuv` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `sections_sites`
--
ALTER TABLE `sections_sites`
  ADD CONSTRAINT `fk_dnwgeubgaalpvcnylylnsjkaqbygjluiypyj` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_pedepnenryymnbarvoxaghpzcqejlfvfvwen` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `shunnedmessages`
--
ALTER TABLE `shunnedmessages`
  ADD CONSTRAINT `fk_torvlmnylrwxpiooyumqgqjgviadczjckkao` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `sites`
--
ALTER TABLE `sites`
  ADD CONSTRAINT `fk_iwohwnhpcpomluswfnjumuhecnawhnqsaugw` FOREIGN KEY (`groupId`) REFERENCES `sitegroups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `sso_identities`
--
ALTER TABLE `sso_identities`
  ADD CONSTRAINT `fk_srqutrsyuvbgeekjbuhfccdgbufmpinwywgm` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `structureelements`
--
ALTER TABLE `structureelements`
  ADD CONSTRAINT `fk_dojezzwhgvcqpidjpamcvsswxrnunenqmiic` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `taggroups`
--
ALTER TABLE `taggroups`
  ADD CONSTRAINT `fk_gewmxthqhrkksqpwtouowzzzaztpqumlvxea` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;

--
-- Constraints for table `tags`
--
ALTER TABLE `tags`
  ADD CONSTRAINT `fk_adegjclqmjxvwcmdhxmrxcgtixrhmcpsoqbv` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_hzbpiksgoucwpsoednwrlttjwcoolmbuuzmi` FOREIGN KEY (`groupId`) REFERENCES `taggroups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `usergroups_users`
--
ALTER TABLE `usergroups_users`
  ADD CONSTRAINT `fk_sjkjctoruezckbzjjdaikyyuqmbvmyysgzdr` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_xgrkfdquwyvdoogmmuktrouwbpvdbplhpbod` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `userpermissions_usergroups`
--
ALTER TABLE `userpermissions_usergroups`
  ADD CONSTRAINT `fk_hxdvgszmrelmhwdlxaqgkttttthuifaklshj` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_xunvkdwfmpmfmgavakvprcobiylbndxgbfwx` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `userpermissions_users`
--
ALTER TABLE `userpermissions_users`
  ADD CONSTRAINT `fk_ffboulniweearghfhefgkmbitpfiojctkojb` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_qszlndlwwqwezmfxultcuhmhewjwfwcclpjx` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `userpreferences`
--
ALTER TABLE `userpreferences`
  ADD CONSTRAINT `fk_uifkormssyxcaswlopjvhisnawsgiandbioe` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `volumefolders`
--
ALTER TABLE `volumefolders`
  ADD CONSTRAINT `fk_xacgsqpltnranftvntossmxpjfvcquhfycwe` FOREIGN KEY (`parentId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  ADD CONSTRAINT `fk_xngeaiylpesrlhyprcvcovoytconcwpukxzc` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

--
-- Constraints for table `volumes`
--
ALTER TABLE `volumes`
  ADD CONSTRAINT `fk_tzktnfwjeotyldxsfiismamrotxnboqsfpfe` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;

--
-- Constraints for table `widgets`
--
ALTER TABLE `widgets`
  ADD CONSTRAINT `fk_gogpkicmjjnnwzmppwzrelwpmtvzosfmvrbn` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;
COMMIT;

