-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Erstellungszeit: 12. Dez 2023 um 16:51
-- Server-Version: 10.5.21-MariaDB-0+deb11u1
-- PHP-Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Datenbank: `iprona_db`
--
CREATE DATABASE IF NOT EXISTS `iprona_db` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `iprona_db`;

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

--
-- Tabellenstruktur für Tabelle `ipronav5_pages`
--

DROP TABLE IF EXISTS `ipronav5_pages`;
CREATE TABLE `ipronav5_pages` (
  `id` int(255) NOT NULL,
  `pid` int(255) NOT NULL,
  `deleted` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `ipronav5_pages`
--

INSERT INTO `ipronav5_pages` (`id`, `pid`, `deleted`) VALUES
(1, 0, 0),
(2, 0, 0),
(3, 0, 0),
(4, 0, 0),
(5, 0, 0),
(6, 0, 0),
(7, 6, 0),
(8, 6, 0),
(9, 1, 0),
(11, 1, 2),
(12, 1, 2),
(13, 6, 0),
(18, 0, 0),
(19, 0, 0),
(20, 18, 0),
(21, 18, 0),
(23, 3, 0),
(24, 1, 0),
(26, 0, 0),
(31, 1, 2),
(32, 19, 0),
(33, 19, 0),
(34, 32, 2),
(35, 348, 0),
(36, 19, 0),
(37, 342, 0),
(38, 37, 2),
(39, 37, 0),
(40, 37, 0),
(41, 37, 0),
(42, 37, 0),
(44, 342, 0),
(45, 44, 2),
(46, 19, 0),
(48, 19, 0),
(49, 44, 2),
(50, 19, 0),
(51, 339, 0),
(52, 51, 0),
(53, 19, 0),
(54, 51, 0),
(55, 353, 0),
(56, 353, 0),
(57, 353, 0),
(58, 19, 2),
(59, 19, 0),
(60, 19, 0),
(61, 348, 0),
(62, 6, 0),
(63, 342, 0),
(64, 63, 0),
(65, 63, 0),
(66, 63, 0),
(67, 63, 0),
(68, 335, 0),
(69, 68, 0),
(70, 68, 0),
(71, 19, 2),
(72, 71, 2),
(74, 2, 0),
(75, 2, 0),
(76, 2, 0),
(77, 19, 0),
(79, 33, 2),
(80, 33, 2),
(81, 33, 2),
(82, 33, 2),
(83, 51, 0),
(84, 52, 0),
(85, 52, 0),
(86, 52, 0),
(87, 348, 0),
(88, 59, 0),
(90, 59, 0),
(91, 59, 0),
(92, 63, 0),
(93, 68, 0),
(96, 19, 0),
(97, 96, 0),
(98, 96, 0),
(99, 96, 0),
(100, 63, 0),
(102, 74, 0),
(103, 74, 0),
(104, 74, 0),
(105, 74, 0),
(106, 2, 0),
(107, 2, 0),
(108, 2, 0),
(109, 2, 0),
(110, 2, 0),
(111, 2, 0),
(112, 93, 0),
(113, 93, 0),
(114, 93, 0),
(117, 3, 0),
(118, 117, 0),
(119, 117, 1),
(120, 117, 0),
(121, 117, 0),
(122, 335, 0),
(123, 335, 0),
(124, 335, 0),
(125, 335, 0),
(126, 4, 0),
(127, 4, 0),
(128, 127, 0),
(129, 127, 0),
(130, 127, 0),
(131, 127, 0),
(132, 4, 0),
(133, 4, 0),
(134, 4, 0),
(135, 4, 0),
(136, 4, 0),
(137, 4, 0),
(138, 4, 0),
(139, 4, 0),
(140, 4, 0),
(141, 4, 0),
(142, 1, 0),
(143, 142, 0),
(144, 142, 0),
(145, 142, 0),
(146, 142, 0),
(148, 69, 0),
(149, 69, 0),
(150, 69, 0),
(151, 48, 0),
(152, 48, 0),
(153, 48, 0),
(154, 48, 0),
(155, 2, 0),
(156, 335, 0),
(157, 342, 0),
(158, 157, 0),
(159, 64, 0),
(160, 64, 0),
(161, 64, 0),
(162, 51, 0),
(163, 19, 0),
(164, 339, 0),
(165, 164, 0),
(166, 164, 0),
(167, 164, 0),
(168, 96, 2),
(169, 4, 0),
(170, 93, 0),
(171, 335, 0),
(172, 0, 0),
(173, 0, 0),
(174, 32, 2),
(175, 44, 2),
(177, 68, 0),
(178, 19, 0),
(179, 178, 0),
(180, 178, 0),
(181, 178, 0),
(182, 178, 0),
(183, 178, 0),
(184, 178, 0),
(185, 37, 0),
(190, 185, 0),
(192, 19, 2),
(193, 274, 0),
(195, 274, 0),
(196, 185, 0),
(197, 185, 0),
(198, 185, 0),
(199, 274, 0),
(201, 274, 0),
(202, 185, 0),
(204, 274, 0),
(209, 274, 0),
(211, 274, 0),
(213, 185, 0),
(214, 185, 0),
(215, 274, 0),
(222, 274, 0),
(223, 185, 0),
(224, 274, 0),
(225, 274, 0),
(226, 274, 0),
(227, 178, 0),
(231, 178, 0),
(232, 178, 0),
(233, 274, 0),
(234, 274, 0),
(235, 185, 0),
(237, 274, 0),
(240, 185, 0),
(241, 185, 0),
(242, 335, 0),
(243, 274, 0),
(244, 274, 0),
(247, 274, 0),
(249, 185, 0),
(250, 2, 0),
(251, 274, 0),
(252, 274, 0),
(255, 274, 0),
(256, 3, 0),
(257, 335, 0),
(258, 335, 0),
(259, 274, 0),
(260, 274, 0),
(261, 274, 0),
(263, 274, 0),
(264, 274, 0),
(265, 185, 0),
(266, 274, 0),
(267, 273, 0),
(271, 185, 0),
(272, 273, 0),
(273, 19, 0),
(274, 273, 0),
(275, 192, 2),
(278, 178, 0),
(279, 178, 0),
(280, 178, 0),
(281, 178, 0),
(282, 178, 0),
(283, 273, 0),
(284, 273, 0),
(285, 273, 0),
(286, 273, 0),
(287, 185, 0),
(288, 273, 0),
(289, 273, 0),
(290, 273, 0),
(291, 273, 0),
(292, 273, 0),
(293, 1, 0),
(294, 1, 0),
(295, 3, 0),
(296, 44, 2),
(297, 132, 0),
(298, 132, 0),
(299, 132, 0),
(300, 4, 2),
(301, 133, 0),
(302, 133, 0),
(303, 133, 0),
(304, 134, 0),
(305, 134, 2),
(306, 134, 0),
(307, 135, 0),
(308, 135, 0),
(309, 135, 0),
(310, 136, 0),
(311, 136, 0),
(312, 136, 0),
(313, 137, 0),
(314, 137, 0),
(315, 137, 2),
(316, 137, 0),
(317, 138, 0),
(318, 138, 0),
(319, 138, 0),
(320, 139, 0),
(321, 139, 0),
(322, 139, 0),
(323, 140, 0),
(324, 140, 0),
(325, 140, 0),
(326, 141, 0),
(327, 141, 0),
(328, 141, 0),
(329, 3, 2),
(330, 1, 2),
(331, 19, 0),
(332, 1, 0),
(333, 1, 0),
(334, 1, 0),
(335, 3, 0),
(336, 273, 0),
(337, 273, 0),
(338, 273, 0),
(339, 19, 0),
(340, 1, 2),
(341, 19, 1),
(342, 0, 0),
(343, 19, 2),
(344, 19, 0),
(345, 19, 0),
(346, 19, 0),
(347, 19, 1),
(348, 342, 0),
(349, 331, 0),
(350, 331, 0),
(351, 331, 0),
(352, 19, 2),
(353, 342, 0),
(354, 19, 0),
(355, 2, 2),
(356, 19, 0),
(357, 19, 2),
(358, 3, 0),
(359, 53, 0),
(360, 53, 0),
(361, 53, 0),
(362, 53, 0),
(363, 53, 2),
(364, 53, 2),
(365, 2, 0),
(366, 3, 0),
(367, 3, 2),
(368, 33, 0),
(369, 33, 0),
(370, 33, 0),
(371, 33, 0),
(372, 3, 2),
(373, 134, 0),
(374, 19, 2),
(375, 6, 0),
(376, 19, 1),
(377, 96, 1),
(378, 4, 0),
(379, 378, 0),
(380, 378, 0),
(381, 378, 0),
(382, 273, 0),
(383, 273, 0),
(384, 273, 0),
(385, 273, 0),
(386, 273, 0),
(387, 178, 0),
(388, 2, 0),
(389, 4, 0),
(390, 348, 0),
(391, 178, 0),
(392, 178, 0),
(393, 0, 0),
(394, 273, 0),
(395, 273, 0),
(396, 273, 0),
(397, 273, 0),
(398, 185, 0),
(399, 273, 0),
(400, 273, 0),
(401, 185, 0),
(402, 185, 0),
(403, 273, 0),
(404, 273, 0),
(405, 273, 0),
(406, 273, 0),
(407, 273, 0),
(408, 185, 0),
(409, 0, 0),
(410, 273, 0),
(411, 4, 0),
(412, 411, 0),
(413, 411, 0),
(414, 411, 0),
(415, 185, 0),
(416, 3, 0),
(417, 185, 0),
(418, 185, 0),
(419, 185, 0),
(420, 273, 0),
(421, 273, 0),
(422, 185, 0),
(423, 273, 0),
(424, 185, 0),
(425, 273, 0),
(426, 273, 0),
(427, 273, 0),
(428, 273, 0),
(429, 185, 0),
(430, 185, 0),
(431, 185, 0),
(432, 273, 0),
(433, 273, 0),
(434, 273, 0),
(435, 273, 0),
(436, 273, 0),
(437, 273, 0),
(438, 185, 0),
(439, 273, 0),
(440, 273, 0),
(441, 273, 0),
(442, 273, 0),
(443, 0, 0),
(444, 0, 0),
(445, 0, 0),
(446, 445, 0),
(447, 445, 0),
(448, 445, 0),
(449, 445, 0),
(450, 445, 0),
(451, 446, 1),
(452, 446, 1),
(453, 446, 0),
(454, 273, 0),
(455, 178, 0),
(456, 445, 0),
(457, 446, 0),
(458, 446, 0),
(459, 450, 0),
(460, 449, 0),
(461, 448, 0),
(462, 447, 0),
(463, 456, 0),
(464, 450, 0),
(465, 450, 0),
(466, 447, 0),
(467, 447, 0),
(468, 448, 0),
(469, 448, 0),
(470, 449, 0),
(471, 449, 1),
(472, 456, 1),
(473, 456, 1),
(474, 450, 0),
(475, 447, 0),
(476, 448, 0),
(477, 456, 0),
(478, 449, 0),
(479, 0, 0),
(480, 479, 0),
(481, 479, 0),
(482, 480, 1),
(483, 480, 1),
(484, 480, 1),
(485, 480, 1),
(486, 480, 1),
(487, 480, 1),
(488, 481, 0),
(489, 481, 1),
(490, 481, 1),
(491, 481, 0),
(492, 481, 0),
(493, 446, 0),
(494, 480, 1),
(495, 185, 0),
(496, 479, 1),
(497, 496, 1),
(498, 612, 0),
(499, 613, 0),
(500, 613, 0),
(501, 613, 0),
(502, 481, 0),
(503, 613, 0),
(504, 613, 1),
(505, 480, 0),
(506, 613, 0),
(507, 613, 1),
(508, 613, 1),
(509, 613, 0),
(510, 613, 1),
(511, 613, 0),
(512, 481, 0),
(513, 481, 0),
(514, 613, 0),
(515, 613, 1),
(516, 481, 0),
(517, 481, 0),
(518, 481, 1),
(519, 481, 1),
(520, 613, 0),
(521, 613, 0),
(522, 613, 1),
(523, 613, 1),
(524, 613, 1),
(525, 613, 1),
(526, 613, 0),
(527, 613, 0),
(528, 613, 0),
(529, 613, 1),
(530, 613, 1),
(531, 613, 1),
(532, 613, 0),
(533, 481, 0),
(534, 613, 0),
(535, 613, 1),
(536, 613, 1),
(537, 613, 0),
(538, 613, 0),
(539, 613, 1),
(540, 481, 0),
(541, 481, 1),
(542, 481, 1),
(543, 481, 0),
(544, 496, 1),
(545, 480, 0),
(546, 612, 0),
(547, 480, 1),
(548, 481, 1),
(549, 481, 0),
(550, 481, 0),
(551, 481, 0),
(552, 481, 0),
(553, 614, 1),
(554, 481, 1),
(555, 481, 1),
(556, 496, 1),
(557, 496, 1),
(558, 612, 0),
(559, 480, 0),
(560, 496, 1),
(561, 481, 0),
(562, 481, 0),
(563, 481, 0),
(564, 481, 1),
(565, 481, 0),
(566, 481, 0),
(567, 481, 0),
(568, 481, 0),
(569, 480, 0),
(570, 612, 0),
(571, 612, 0),
(572, 480, 0),
(573, 480, 0),
(574, 480, 0),
(575, 480, 0),
(576, 612, 0),
(577, 612, 0),
(578, 481, 0),
(579, 480, 0),
(580, 480, 0),
(581, 480, 0),
(582, 480, 0),
(583, 480, 0),
(584, 480, 0),
(585, 480, 0),
(586, 480, 1),
(587, 480, 0),
(588, 480, 0),
(589, 614, 1),
(590, 614, 1),
(591, 614, 0),
(592, 614, 0),
(593, 614, 1),
(594, 614, 1),
(595, 614, 1),
(596, 614, 1),
(597, 480, 0),
(598, 612, 0),
(599, 480, 0),
(600, 612, 0),
(601, 612, 0),
(602, 612, 0),
(603, 612, 1),
(604, 613, 0),
(605, 613, 1),
(606, 612, 0),
(607, 612, 0),
(608, 612, 0),
(609, 612, 0),
(610, 481, 0),
(611, 273, 0),
(612, 479, 0),
(613, 479, 0),
(614, 479, 0),
(615, 446, 0),
(616, 612, 0),
(617, 446, 0),
(618, 445, 0),
(619, 618, 0),
(620, 618, 0),
(621, 620, 1),
(622, 618, 0),
(623, 618, 0),
(624, 613, 0),
(625, 445, 0),
(626, 446, 0),
(627, 618, 0),
(628, 450, 0),
(629, 480, 0),
(630, 450, 0),
(631, 456, 0),
(632, 613, 1),
(633, 612, 1),
(634, 613, 1),
(635, 613, 0),
(636, 613, 0),
(637, 456, 0),
(638, 447, 0),
(639, 447, 0),
(640, 456, 1),
(641, 456, 0),
(642, 481, 0),
(643, 448, 0),
(644, 448, 0),
(645, 625, 0),
(646, 625, 0),
(647, 625, 0),
(648, 625, 0),
(649, 625, 0),
(650, 625, 0),
(651, 450, 0),
(652, 447, 0),
(653, 448, 0),
(654, 625, 0),
(655, 449, 0),
(656, 456, 0),
(657, 185, 0),
(658, 185, 0),
(659, 185, 0),
(660, 185, 0),
(661, 481, 0),
(662, 185, 0),
(663, 273, 0),
(664, 273, 0),
(665, 273, 0),
(666, 665, 0),
(667, 273, 0),
(668, 273, 0),
(669, 273, 0),
(670, 273, 0),
(671, 273, 0);

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

--
-- Tabellenstruktur für Tabelle `ipronav5_requests`
--

DROP TABLE IF EXISTS `ipronav5_requests`;
CREATE TABLE `ipronav5_requests` (
  `id` int(11) NOT NULL,
  `pid` int(11) DEFAULT NULL,
  `createDate` int(11) DEFAULT NULL,
  `lng` varchar(255) DEFAULT NULL,
  `fromMail` varchar(255) DEFAULT NULL,
  `mailRaw` text DEFAULT NULL,
  `mailData` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Tabellenstruktur für Tabelle `ipronav5_seoredirects`
--

DROP TABLE IF EXISTS `ipronav5_seoredirects`;
CREATE TABLE `ipronav5_seoredirects` (
  `id` int(11) NOT NULL,
  `pid` int(11) DEFAULT NULL,
  `offline` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `urltarget` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Daten für Tabelle `ipronav5_seoredirects`
--

INSERT INTO `ipronav5_seoredirects` (`id`, `pid`, `offline`, `url`, `urltarget`) VALUES
(1, 0, 0, 'umfrage-2019', 'survey/de');

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `ipronav5_pages`
--
ALTER TABLE `ipronav5_pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pid` (`pid`),
  ADD KEY `deleted` (`deleted`);

--
-- Indizes für die Tabelle `ipronav5_requests`
--
ALTER TABLE `ipronav5_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ipronav5_seoredirects`
--
ALTER TABLE `ipronav5_seoredirects`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `ipronav5_pages`
--
ALTER TABLE `ipronav5_pages`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=672;

--
-- AUTO_INCREMENT für Tabelle `ipronav5_requests`
--
ALTER TABLE `ipronav5_requests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT für Tabelle `ipronav5_seoredirects`
--
ALTER TABLE `ipronav5_seoredirects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
