-- --------------------------------------------------------
-- User data
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `skill_skills`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `skill_skills` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `beschreibung` longtext DEFAULT NULL,
  `fertigkeitswert` bigint(20) DEFAULT NULL,
  `bonus` bigint(20) DEFAULT NULL,
  `pp` bigint(20) DEFAULT NULL,
  `bemerkung` longtext DEFAULT NULL,
  `improvable` tinyint(1) DEFAULT NULL,
  `category` longtext DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `skill_skills`
--

INSERT INTO `skill_skills` (`id`, `name`, `character_id`, `beschreibung`, `fertigkeitswert`, `bonus`, `pp`, `bemerkung`, `improvable`, `category`, `user_id`) VALUES
(414, 'Hören', 15, '', 6, 0, 0, '', 0, '', NULL),
(415, 'Nachtsicht', 15, '', 6, 0, 0, '', 0, '', NULL),
(416, 'Riechen', 15, '', 6, 0, 0, '', 0, '', NULL),
(417, 'Sechster Sinn', 15, '', 6, 0, 0, '', 0, '', NULL),
(418, 'Sehen', 15, '', 8, 0, 0, '', 0, '', NULL),
(419, 'Wahrnehmung', 15, '', 6, 0, 0, '', 0, '', NULL),
(420, 'Balancieren', 15, '', 12, 2, 0, '', 0, '', NULL),
(421, 'Erste Hilfe', 15, '', 8, 0, 0, '', 0, '', NULL),
(422, 'Fallenmechanik', 15, '', 8, 0, 0, '', 0, '', NULL),
(423, 'Geländelauf', 15, '', 15, 0, 0, '', 0, '', NULL),
(424, 'Klettern', 15, '', 12, 2, 0, '', 0, '', NULL),
(425, 'Klettern', 15, '', 0, 0, 0, '', 0, '', NULL),
(426, 'Landeskunde', 15, '', 9, 0, 0, '', 0, '', NULL),
(427, 'Reiten', 15, '', 12, 0, 0, '', 0, '', NULL),
(428, 'Schleichen', 15, '', 12, 2, 0, '', 0, '', NULL),
(429, 'Schreiben', 15, '', 8, 0, 0, '', 0, '', 0),
(430, 'Schwimmen', 15, '', 12, 0, 0, '', 0, '', NULL),
(431, 'Sehen', 15, '', 2, 0, 0, '', 0, '', NULL),
(432, 'Sprache', 15, 'Morawisch', 18, 0, 0, 'Morawisch', 0, '', NULL),
(433, 'Sprache', 15, 'Tegarisch', 8, 0, 0, 'Tegarisch', 0, '', NULL),
(434, 'Sprache', 15, 'Valinga', 12, 0, 0, 'Valinga', 0, '', NULL),
(435, 'Sprache', 15, 'Waelska', 14, 0, 0, 'Waelska', 0, '', NULL),
(436, 'Springen', 15, '', 12, 2, 0, '', 0, '', NULL),
(437, 'Tierkunde', 15, '', 8, 0, 0, '', 0, '', NULL),
(438, 'Überleben', 15, '', 8, 0, 0, '', 0, '', NULL),
(439, 'Zauberkunde', 15, '', 8, 0, 0, '', 0, '', NULL),
(440, 'Hören', 16, '', 6, 0, 0, '', 0, '', NULL),
(441, 'Nachtsicht', 16, '', 6, 0, 0, '', 0, '', NULL),
(442, 'Riechen', 16, '', 6, 0, 0, '', 0, '', NULL),
(443, 'Sechster Sinn', 16, '', 6, 0, 0, '', 0, '', NULL),
(444, 'Sehen', 16, '', 6, 0, 0, '', 0, '', NULL),
(445, 'Wahrnehmung', 16, '', 6, 0, 0, '', 0, '', NULL),
(446, 'Alchimie', 16, '', 8, 0, 0, '', 0, '', NULL),
(447, 'Beredsamkeit', 16, '', 9, 0, 0, '', 0, '', NULL),
(448, 'Fallen entdecken', 16, '', 8, 0, 0, '', 0, '', NULL),
(449, 'Fallenmechanik', 16, '', 8, 0, 0, '', 0, '', NULL),
(450, 'Gaukeln', 16, '', 12, 0, 0, '', 0, '', NULL),
(451, 'Geschäftssinn', 16, '', 8, 0, 0, '', 0, '', NULL),
(452, 'Landeskunde', 16, 'Waeland', 8, 0, 0, 'Waeland', 0, '', NULL),
(453, 'Landeskunde', 16, 'Zwerge', 8, 0, 0, 'Zwerge', 0, '', NULL),
(454, 'Lesen von Zauberschrift', 16, '', 14, 0, 0, '', 0, '', NULL),
(455, 'Naturkunde', 16, '', 8, 0, 0, '', 0, '', NULL),
(456, 'Pflanzenkunde', 16, '', 8, 0, 0, '', 0, '', NULL),
(457, 'Reiten', 16, '', 12, 0, 0, '', 0, '', NULL),
(458, 'Richtungssinn', 16, '', 12, 0, 0, '', 0, '', NULL),
(459, 'Schlösser öffnen', 16, '', 8, 0, 0, '', 0, '', NULL),
(460, 'Schreiben', 16, '', 8, 0, 0, '', 0, '', NULL),
(461, 'Schreiben', 16, 'Waelska', 12, 0, 0, 'Waelska', 0, '', NULL),
(462, 'Sprache', 16, 'Albisch', 8, 0, 0, 'Albisch', 0, '', NULL),
(463, 'Sprache', 16, 'Comentang', 12, 0, 0, 'Comentang', 0, '', NULL),
(464, 'Sprache', 16, 'Dvarska', 8, 0, 0, 'Dvarska', 0, '', NULL),
(465, 'Sprache', 16, 'Twyneddisch', 10, 0, 0, 'Twyneddisch', 0, '', NULL),
(466, 'Sprache', 16, 'Valinga', 9, 0, 0, 'Valinga', 0, '', NULL),
(467, 'Sprache', 16, 'Waelska', 18, 0, 0, 'Waelska', 0, '', NULL),
(468, 'Thaumagraphie', 16, '', 10, 0, 0, '', 0, '', NULL),
(469, 'Thaumalogie', 16, '', 8, 0, 0, '', 0, '', NULL),
(470, 'Wagenlenken', 16, '', 12, 0, 0, '', 0, '', NULL),
(471, 'Zauberkunde', 16, '', 8, 0, 0, '', 0, '', NULL),
(472, 'Hören', 17, '', 6, 0, 0, '', 0, '', NULL),
(473, 'Nachtsicht', 17, '', 6, 0, 0, '', 0, '', NULL),
(474, 'Riechen', 17, '', 6, 0, 0, '', 0, '', NULL),
(475, 'Sechster Sinn', 17, '', 6, 0, 0, '', 0, '', NULL),
(476, 'Sehen', 17, '', 6, 0, 0, '', 0, '', NULL),
(477, 'Wahrnehmung', 17, '', 6, 0, 0, '', 0, '', NULL),
(478, 'Alchimie', 17, '+2 ABW 10', 8, 0, 0, '+2 ABW 10', 0, '', NULL),
(479, 'Erste Hilfe', 17, '', 11, 0, 0, '', 0, '', NULL),
(480, 'Geländelauf', 17, '', 12, 0, 0, '', 0, '', NULL),
(481, 'Heilkunde', 17, '+2 ABW 10', 10, 0, 0, '+2 ABW 10', 0, '', NULL),
(482, 'Landeskunde', 17, 'Valian', 8, 0, 0, 'Valian', 0, '', NULL),
(483, 'Lesen von Zauberschrift', 17, '', 12, 0, 0, '', 0, '', NULL),
(484, 'Musizieren', 17, '', 12, 0, 0, '', 0, '', NULL),
(485, 'Naturkunde', 17, '', 9, 0, 0, '', 0, '', NULL),
(486, 'Pflanzenkunde', 17, '', 9, 0, 0, '', 0, '', NULL),
(487, 'Reiten', 17, '', 12, 0, 0, '', 0, '', NULL),
(488, 'Reiten', 17, 'Flügelpferd', 15, 0, 0, 'Flügelpferd', 0, '', NULL),
(489, 'Schreiben', 17, 'Chryseisch', 8, 0, 0, 'Chryseisch', 0, '', NULL),
(490, 'Schreiben', 17, 'Comentang', 12, 0, 0, 'Comentang', 0, '', NULL),
(491, 'Schreiben', 17, 'Neu Valinga', 12, 0, 0, 'Neu Valinga', 0, '', NULL),
(492, 'Schreiben', 17, 'Valinga', 8, 0, 0, 'Valinga', 0, '', NULL),
(493, 'Schwimmen', 17, '', 12, 0, 0, '', 0, '', NULL),
(494, 'Seilkunst', 17, '', 12, 0, 0, '', 0, '', NULL),
(495, 'Sprache', 17, 'Chryseisch', 8, 0, 0, 'Chryseisch', 0, '', NULL),
(496, 'Sprache', 17, 'Comentang', 12, 0, 0, 'Comentang', 0, '', NULL),
(497, 'Sprache', 17, 'Tegarisch', 8, 0, 0, 'Tegarisch', 0, '', NULL),
(498, 'Sprache', 17, 'Valinga', 8, 0, 0, 'Valinga', 0, '', NULL),
(499, 'Thaumagraphie', 17, '', 8, 0, 0, '', 0, '', NULL),
(500, 'Tierkunde', 17, '', 9, 0, 0, '', 0, '', NULL),
(501, 'Wachgabe', 17, '', 6, 0, 0, '', 0, '', NULL),
(502, 'Zauberkunde', 17, '', 14, 0, 0, '', 0, '', NULL),
(503, 'Hören', 18, '', 6, 0, 0, '', 0, '', NULL),
(504, 'Nachtsicht', 18, '', 10, 0, 0, '', 0, '', NULL),
(505, 'Riechen', 18, '', 6, 0, 0, '', 0, '', NULL),
(506, 'Sechster Sinn', 18, '', 6, 0, 0, '', 0, '', NULL),
(507, 'Sehen', 18, '', 6, 0, 0, '', 0, '', NULL),
(508, 'Wahrnehmung', 18, '', 6, 0, 0, '', 0, '', NULL),
(509, 'Alchimie', 18, '', 9, 0, 0, '', 0, '', NULL),
(510, 'Balancieren', 18, '', 12, 0, 0, '', 0, '', NULL),
(511, 'Beredsamkeit', 18, '', 10, 0, 0, '', 0, '', NULL),
(512, 'Einprägen', 18, '', 4, 0, 0, '', 0, '', NULL),
(513, 'Fälschen', 18, '', 13, 0, 0, '', 0, '', NULL),
(514, 'Gassenwissen', 18, '', 10, 0, 0, '', 0, '', NULL),
(515, 'Gaukeln', 18, '', 12, 0, 0, '', 0, '', NULL),
(516, 'Geländelauf', 18, '', 13, 0, 0, '', 0, '', NULL),
(517, 'Klettern', 18, '', 14, 0, 0, '', 0, '', NULL),
(518, 'Landeskunde', 18, 'Küstenstaten', 11, 0, 0, 'Küstenstaten', 0, '', NULL),
(519, 'Lesen von Zauberschrift', 18, '', 13, 0, 0, '', 0, '', NULL),
(520, 'Nachtsicht', 18, '', 4, 0, 0, '', 0, '', NULL),
(521, 'Pflanzenkunde', 18, '', 8, 0, 0, '', 0, '', NULL),
(522, 'Reiten', 18, '', 12, 0, 0, '', 0, '', NULL),
(523, 'Schreiben', 18, 'Albisch', 8, 0, 0, 'Albisch', 0, '', NULL),
(524, 'Schreiben', 18, 'Geheimzeichen (Bettlerzinken)', 8, 0, 0, 'Geheimzeichen (Bettlerzinken)', 0, '', NULL),
(525, 'Schreiben', 18, 'Maralinga', 8, 0, 0, 'Maralinga', 0, '', NULL),
(526, 'Schreiben', 18, 'Morawisch', 10, 0, 0, 'Morawisch', 0, '', NULL),
(527, 'Schreiben', 18, 'Neu Valinga', 14, 0, 0, 'Neu Valinga', 0, '', NULL),
(528, 'Schreiben', 18, 'Waelska', 8, 0, 0, 'Waelska', 0, '', NULL),
(529, 'Schwimmen', 18, '', 13, 0, 0, '', 0, '', NULL),
(530, 'Seilkunst', 18, '', 13, 0, 0, '', 0, '', NULL),
(531, 'Sprache', 18, 'Albisch', 13, 0, 0, 'Albisch', 0, '', NULL),
(532, 'Sprache', 18, 'Maralinga', 8, 0, 0, 'Maralinga', 0, '', NULL),
(533, 'Sprache', 18, 'Morawisch', 12, 0, 0, 'Morawisch', 0, '', NULL),
(534, 'Sprache', 18, 'Neu Valinga', 19, 0, 0, 'Neu Valinga', 0, '', NULL),
(535, 'Sprache', 18, 'Rawindi', 8, 0, 0, 'Rawindi', 0, '', NULL),
(536, 'Sprache', 18, 'Waelska', 8, 0, 0, 'Waelska', 0, '', NULL),
(537, 'Spurensuche', 18, '', 8, 0, 0, '', 0, '', NULL),
(538, 'Stehlen', 18, '', 9, 0, 0, '', 0, '', NULL),
(539, 'Tarnen', 18, '', 8, 0, 0, '', 0, '', NULL),
(540, 'Tauchen', 18, '', 8, 0, 0, '', 0, '', NULL),
(541, 'Tierkunde', 18, '', 8, 0, 0, '', 0, '', NULL),
(542, 'Überleben:Schnee', 18, '', 5, 0, 0, '', 0, '', NULL),
(543, 'Überleben:Wald', 18, '', 5, 0, 0, '', 0, '', NULL),
(544, 'Verhören', 18, '', 8, 0, 0, '', 0, '', NULL),
(545, 'Verstellen', 18, '', 16, 0, 0, '', 0, '', NULL),
(546, 'Zauberkunde', 18, '', 11, 0, 0, '', 0, '', NULL),
(547, 'Zeichensprache', 18, '', 6, 0, 0, '', 0, '', NULL),
(548, 'Hören', 19, '', 6, 0, 0, '', 0, '', NULL),
(549, 'Nachtsicht', 19, '', 6, 0, 0, '', 0, '', NULL),
(550, 'Riechen', 19, '', 6, 0, 0, '', 0, '', NULL),
(551, 'Sechster Sinn', 19, '', 6, 0, 0, '', 0, '', NULL),
(552, 'Sehen', 19, '', 6, 0, 0, '', 0, '', NULL),
(553, 'Wahrnehmung', 19, '', 6, 0, 0, '', 0, '', NULL),
(554, 'Abrichten', 19, '(+4 bei Katzen)', 10, 0, 0, '(+4 bei Katzen)', 0, '', NULL),
(555, 'Akrobatik', 19, '', 11, 0, 0, '', 0, '', NULL),
(556, 'Balancieren', 19, '(Totem Katze)', 14, 2, 0, '(Totem Katze)', 0, '', NULL),
(557, 'Gaukeln', 19, '', 15, 0, 0, '', 0, '', NULL),
(558, 'Geländelauf', 19, '(Totem Katze)', 14, 2, 0, '(Totem Katze)', 0, '', NULL),
(559, 'Klettern', 19, '(Totem Katze)', 14, 2, 0, '(Totem Katze)', 0, '', NULL),
(560, 'Laufen', 19, '', 8, 0, 0, '', 0, '', NULL),
(561, 'Reiten', 19, '', 13, 0, 0, '', 0, '', NULL),
(562, 'Robustheit', 19, '', 9, 0, 0, '', 0, '', NULL),
(563, 'Schleichen', 19, '', 10, 0, 0, '', 0, '', NULL),
(564, 'Schwimmen', 19, '', 12, 0, 0, '', 0, '', NULL),
(565, 'Seilkunst', 19, '', 12, 0, 0, '', 0, '', NULL),
(566, 'Sprache', 19, 'Erainnisch', 12, 0, 0, 'Erainnisch', 0, '', NULL),
(567, 'Sprache', 19, 'Neu-Vallinga', 12, 0, 0, 'Neu-Vallinga', 0, '', NULL),
(568, 'Sprache', 19, 'Vallinga', 12, 0, 0, 'Vallinga', 0, '', NULL),
(569, 'Spurensuche', 19, '', 12, 0, 0, '', 0, '', NULL),
(570, 'Tarnen', 19, '', 8, 0, 0, '', 0, '', NULL),
(571, 'Tierkunde', 19, '', 10, 0, 0, '', 0, '', NULL),
(572, 'Überleben', 19, 'Gebirge', 14, 0, 0, 'Gebirge', 0, '', NULL),
(573, 'Verführen', 19, '', 10, 0, 0, '', 0, '', NULL),
(574, 'Wagenlenken', 19, '', 12, 0, 0, '', 0, '', NULL),
(575, 'Hören', 20, '', 6, 0, 0, '', 0, '', NULL),
(576, 'Nachtsicht', 20, '', 8, 0, 0, '', 0, '', NULL),
(577, 'Riechen', 20, '', 6, 0, 0, '', 0, '', NULL),
(578, 'Sechster Sinn', 20, '', 6, 0, 0, '', 0, '', NULL),
(579, 'Sehen', 20, '', 8, 0, 0, '', 0, '', NULL),
(580, 'Wahrnehmung', 20, '', 6, 0, 0, '', 0, '', NULL),
(581, 'Athletik', 20, '', 11, 0, 13, '', 0, '', NULL),
(582, 'Erste Hilfe', 20, '', 9, 0, 0, '', 0, '', NULL),
(583, 'Geländelauf', 20, '', 13, 0, 1, '', 0, '', NULL),
(584, 'Kampf in Vollrüstung', 20, '', 5, 0, 0, '', 0, '', NULL),
(585, 'Klettern', 20, '', 13, 0, 0, '', 0, '', NULL),
(586, 'Landeskunde', 20, 'Dvarska', 9, 0, 0, 'Dvarska', 0, '', NULL),
(587, 'Laufen', 20, '', 10, 0, 0, '', 0, '', NULL),
(588, 'Nachtsicht', 20, '', 2, 0, 0, '', 0, '', NULL),
(589, 'Robustheit', 20, '', 9, 0, 0, '', 0, '', NULL),
(590, 'Sehen', 20, '', 2, 0, 0, '', 0, '', NULL),
(591, 'Sprache', 20, 'Albisch', 8, 0, 0, 'Albisch', 0, '', NULL),
(592, 'Sprache', 20, 'Comentang', 12, 0, 0, 'Comentang', 0, '', NULL),
(593, 'Sprache', 20, 'Dvarska', 12, 0, 0, 'Dvarska', 0, '', NULL),
(594, 'Klettern', 21, '', 0, 0, 0, '', 1, 'Alltag', NULL),
(595, 'Reiten', 21, '', 0, 0, 0, '', 1, 'Alltag', NULL),
(596, 'Sprache', 21, '', 0, 0, 0, '', 1, 'Alltag', NULL),
(597, 'Verstellen', 21, '', 0, 0, 0, '', 1, 'Sozial', NULL),
(598, 'Anführen', 21, '', 0, 0, 0, '', 1, 'Sozial', NULL),
(599, 'Lesen von Zauberschrift', 21, '', 0, 0, 0, '', 1, 'Wissen', NULL),
(600, 'Schreiben', 21, '', 0, 0, 0, '', 1, 'Wissen', NULL),
(601, 'Schreiben', 22, '', 8, 0, 0, '', 1, 'Alltag', NULL),
(602, 'Anführen', 22, '', 10, 0, 0, '', 1, 'Sozial', NULL),
(603, 'Verstellen', 22, '', 16, 0, 0, '', 1, 'Sozial', NULL),
(604, 'Lesen von Zauberschrift', 22, '', 12, 0, 0, '', 1, 'Wissen', NULL),
(605, 'Zauberkunde', 22, '', 14, 0, 0, '', 1, 'Wissen', NULL),
(606, 'Tierkunde', 22, '', 9, 0, 0, '', 1, 'Wissen', NULL);

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

--
-- Tabellenstruktur für Tabelle `skill_spells`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `skill_spells` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `beschreibung` longtext DEFAULT NULL,
  `bonus` bigint(20) DEFAULT NULL,
  `quelle` longtext DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `skill_spells`
--

INSERT INTO `skill_spells` (`id`, `name`, `character_id`, `beschreibung`, `bonus`, `quelle`, `user_id`) VALUES
(214, 'Bannen von Dunkelheit', 15, '', 0, 'ARK5 136', NULL),
(215, 'Bannen von Gift', 15, '', 0, 'ARK5 138', NULL),
(216, 'Bannen von Licht', 15, '', 0, 'ARK5 66', NULL),
(217, 'Bärenwut', 15, '', 0, 'ARK5 149', NULL),
(218, 'Schwäche', 15, '', 0, 'ARK5 110', NULL),
(219, 'Schwingenkeule', 15, '', 0, 'ARK5 146', NULL),
(220, 'Segnen', 15, '', 0, 'ARK5 146', NULL),
(221, 'Verursachen von Krankheit', 15, '', 0, 'ARK5 124', NULL),
(222, 'Wagemut', 15, '', 0, 'ARK5 148', NULL),
(223, 'Wundersame Tarnung', 15, '', 0, 'ARK5 161', NULL),
(224, 'Befestigen (S)', 16, '', 0, 'MYS5 55', NULL),
(225, 'Beschleunigen (S)', 16, '', 0, 'MYS5 56', NULL),
(226, 'Eisenhaut (S)', 16, '', 0, 'MYS5 56', NULL),
(227, 'Fesselbann (R)', 16, '', 0, 'MYS5 53', NULL),
(228, 'Feuerfinger (R)', 16, '', 0, 'MYS5 53', NULL),
(229, 'Feuerlanze (R)', 16, '', 0, 'MYS5 53', NULL),
(230, 'Feuerlauf (S)', 16, '', 0, 'MYS5 56', NULL),
(231, 'Flammenkreis (S)', 16, '', 0, 'MYS5 57', NULL),
(232, 'Fliegensalz', 16, '', 0, 'MYS5 46', NULL),
(233, 'Frostball (R)', 16, '', 0, 'MYS5 53', NULL),
(234, 'Geistesschutz (S)', 16, '', 0, 'MYS5 57', NULL),
(235, 'Haarsalz', 16, '', 0, 'MYS5 46', NULL),
(236, 'Hauch der Verwesung (S)', 16, '', 0, 'MYS5 58', NULL),
(237, 'Heranholen (S)', 16, '', 0, 'MYS5 58', NULL),
(238, 'Kräftigen (S)', 16, '', 0, 'MYS5 58', NULL),
(239, 'Lauschen (S)', 16, '', 0, 'MYS5 58', NULL),
(240, 'Löschsalz', 16, '', 0, 'MYS5 48', NULL),
(241, 'Rost (S)', 16, '', 0, 'MYS5 59', NULL),
(242, 'Rutschsalz', 16, '', 0, 'MYS5 48', NULL),
(243, 'Schleichsalz', 16, '', 0, 'MYS5 49', NULL),
(244, 'Sehen in Dunkelheit (S)', 16, '', 0, 'MYS5 60', NULL),
(245, 'Sehen von Verborgenem (S)', 16, '', 0, 'MYS5 60', NULL),
(246, 'Silberne Bannsphäre (S)', 16, '', 0, 'MYS5 61', NULL),
(247, 'Silberstaub (S)', 16, '', 0, 'MYS5 61', NULL),
(248, 'Stärke (S)', 16, '', 0, 'MYS5 61', NULL),
(249, 'Stottersalz', 16, '', 0, 'MYS5 49', NULL),
(250, 'Trampelsalz', 16, '', 0, 'MYS5 50', NULL),
(251, 'Unsichtbarkeit (S)', 16, '', 0, 'MYS5 61', NULL),
(252, 'Wasseratmen (S)', 16, '', 0, 'MYS5 64', NULL),
(253, 'Wehsalz', 16, '', 0, 'MYS5 50', NULL),
(254, 'Windstoß (R)', 16, '', 0, 'MYS5 53', NULL),
(255, 'Zauberlicht (R)', 16, '', 0, 'MYS5 53', NULL),
(256, 'Zauberschild (S)', 16, '', 0, 'MYS5 66', NULL),
(257, 'Zauberschloss (S)', 16, '', 0, 'MYS5 66', NULL),
(258, 'Zauberschlüssel (R)', 16, '', 0, 'MYS5 53', NULL),
(259, 'Zauberschmiede (S)', 16, '', 0, 'MYS5 66', NULL),
(260, 'Zwiesprache (S)', 16, '', 0, 'MYS5 66', NULL),
(261, 'Aktivieren Spruchrolle', 17, '', 0, 'MYS5 129', NULL),
(262, 'Aktivieren Thaumagrammblatt', 17, '', 0, 'MYS5 129', NULL),
(263, 'Bannen von Zauberwerk', 17, '', 0, 'ARK5 66', NULL),
(264, 'Befestigen', 17, '', 0, 'ARK5 67', NULL),
(265, 'Erkennen von Leben', 17, '', 0, 'ARK5 78', NULL),
(266, 'Erkennen von Zauberei', 17, '', 0, 'ARK5 78', NULL),
(267, 'Feuerkugel', 17, '', 0, 'ARK5 81', NULL),
(268, 'Feuerwand', 17, '', 0, 'ARK5 84', NULL),
(269, 'Fixieren', 17, '', 0, 'MYS5 127', NULL),
(270, 'Flammenkreis', 17, '', 0, 'ARK5 85', NULL),
(271, 'Flammenteppich', 17, '', 0, 'ARK5 85', NULL),
(272, 'Frostball', 17, '', 0, 'ARK5 86', NULL),
(273, 'Geräusche dämpfen', 17, '', 0, 'ARK5 88', NULL),
(274, 'Heranholen', 17, '', 0, 'ARK5 91', NULL),
(275, 'Höhenblick', 17, '', 0, 'ARK5 92', NULL),
(276, 'Macht über die Sinne', 17, '', 0, 'ARK5 98', NULL),
(277, 'Regenzauber', 17, '', 0, 'ARK+5 11', NULL),
(278, 'Schwäche', 17, '', 0, 'ARK5 110', NULL),
(279, 'Silberstaub', 17, '', 0, 'ARK5 114', NULL),
(280, 'Stille', 17, '', 0, 'ARK5 115', NULL),
(281, 'Stimmenwerfen', 17, '', 0, 'ARK5 116', NULL),
(282, 'Verursachen von Wunden', 17, '', 0, 'ARK5 124', NULL),
(283, 'Zauberstimme', 17, '', 0, 'ARK5 132', NULL),
(284, 'Zwiesprache', 17, '', 0, 'ARK5 134', NULL),
(285, 'Angst', 18, '', 0, 'ARK5 63', NULL),
(286, 'Bannen von Licht', 18, '', 0, 'ARK5 66', NULL),
(287, 'Bannen von Zauberwerk', 18, '', 0, 'ARK5 66', NULL),
(288, 'Beeinflussen', 18, '', 0, 'ARK5 67', NULL),
(289, 'Befestigen', 18, '', 0, 'ARK5 67', NULL),
(290, 'Beschleunigen', 18, '', 0, 'ARK5 68', NULL),
(291, 'Binden des Vertrauten', 18, '', 0, 'ARK5 68', NULL),
(292, 'Böser Blick', 18, '', 0, 'ARK5 70', NULL),
(293, 'Brot und Wasser', 18, '', 0, 'ARK5 71', NULL),
(294, 'Dämonische Zaubermacht', 18, '', 0, 'ARK5 72', NULL),
(295, 'Dinge verbergen', 18, '', 0, 'ARK5 73', NULL),
(296, 'Dinge wiederfinden', 18, '', 0, 'ARK5 73', NULL),
(297, 'Elementenwandlung', 18, '', 0, 'ARK5 76', NULL),
(298, 'Erkennen von Leben', 18, '', 0, 'ARK5 78', NULL),
(299, 'Erkennen von Zauberei', 18, '', 0, 'ARK5 78', NULL),
(300, 'Feuerlauf', 18, '', 0, 'ARK5 82', NULL),
(301, 'Flammenteppich', 18, '', 0, 'ARK5 85', NULL),
(302, 'Fliegen', 18, '', 0, 'ARK5 86', NULL),
(303, 'Frostkreis', 18, '', 0, 'RAW5 102', NULL),
(304, 'Geistesschild', 18, '', 0, 'ARK5 87', NULL),
(305, 'Heranholen', 18, '', 0, 'ARK5 91', NULL),
(306, 'Hitzeschutz', 18, '', 0, 'ARK5 91', NULL),
(307, 'Hören der Geister', 18, '', 0, 'ARK5 92', NULL),
(308, 'Macht über die Sinne', 18, '', 0, 'ARK5 98', NULL),
(309, 'Macht über Unbelebtes', 18, '', 0, 'ARK5 100', NULL),
(310, 'Modeln', 18, '', 0, 'ARK+5 10', NULL),
(311, 'Nebel wecken', 18, '', 0, 'ARK5 103', NULL),
(312, 'Rauchwolke', 18, '', 0, 'ARK5 105', NULL),
(313, 'Scharfblick', 18, '', 0, 'ARK5 108', NULL),
(314, 'Schatten verstärken', 18, '', 0, 'ARK5 108', NULL),
(315, 'Schmerzen', 18, '', 0, 'ARK5 109', NULL),
(316, 'Schwäche', 18, '', 0, 'ARK5 110', NULL),
(317, 'Schwarm', 18, '', 0, 'ARK5 159', NULL),
(318, 'Schwarze Zone', 18, '', 0, 'ARK5 111', NULL),
(319, 'Sehen in Dunkelheit', 18, '', 0, 'ARK5 113', NULL),
(320, 'Sehen von Verborgenem', 18, '', 0, 'ARK5 113', NULL),
(321, 'Stärke', 18, '', 0, 'ARK5 115', NULL),
(322, 'Stille', 18, '', 0, 'ARK5 115', NULL),
(323, 'Stimmenwerfen', 18, '', 0, 'ARK5 116', NULL),
(324, 'Tiergestalt', 18, '', 0, 'ARK5 160', NULL),
(325, 'Unsichtbarkeit', 18, '', 0, 'ARK5 120', NULL),
(326, 'Verlangsamen', 18, '', 0, 'ARK5 122', NULL),
(327, 'Vermehren', 18, '', 0, 'ARK5 122', NULL),
(328, 'Versetzen', 18, '', 0, 'ARK5 123', NULL),
(329, 'Verursachen schwerer Wunden', 18, '', 0, 'ARK5 124', NULL),
(330, 'Verwirren', 18, '', 0, 'ARK5 125', NULL),
(331, 'Wasseratmen', 18, '', 0, 'ARK5 127', NULL),
(332, 'Zauberschloss', 18, '', 0, 'ARK5 132', NULL),
(333, 'Zauberschlüssel', 18, '', 0, 'ARK5 132', NULL),
(334, 'Zaubersprung', 18, '', 0, 'ARK5 161', NULL),
(335, 'Zauberstimme', 18, '', 0, 'ARK5 132', NULL),
(336, 'Zauberzunge', 18, '', 0, 'ARK5 133', NULL),
(337, 'Zielsuche', 18, '', 0, 'ARK5 133', NULL),
(338, 'Zweite Haut', 18, '', 0, 'ARK5 133', NULL),
(339, 'Zwiesprache', 18, '', 0, 'ARK5 134', NULL),
(340, 'Bärenwut', 19, '', 0, 'ARK5 149', NULL),
(341, 'Freundesauge', 19, '', 0, 'MYS5 93', NULL),
(342, 'Gefährtenruf', 19, '', 0, 'MYS5 93', NULL),
(343, 'Katzenaugen', 19, '', 0, 'MYS5 93', NULL),
(344, 'Kraftband', 19, '', 0, 'MYS5 93', NULL),
(345, 'Laufen wie der Wind', 19, '', 0, 'ARK5 154', NULL),
(346, 'Lebensstärkung', 19, '', 0, 'ARK5 154', NULL),
(347, 'Mutlosigkeit', 19, '', 0, 'ARK5 156', NULL),
(348, 'Naturgeist rufen', 19, '', 0, 'ARK5 156', NULL),
(349, 'Rindenhaut', 19, '', 0, 'ARK5 157', NULL),
(350, 'Tiersprache', 19, '', 0, 'MYS5 94', NULL),
(351, 'Wandeln wie der Wind', 19, '', 0, 'ARK5 160', NULL),
(352, 'Wittern', 19, '', 0, 'ARK5 161', NULL),
(353, 'Wundersame Tarnung', 19, '', 0, 'ARK5 161', NULL),
(354, 'Zähmen', 19, '', 0, 'ARK5 161', NULL),
(355, 'Zaubersprung', 19, '', 0, 'ARK5 161', NULL),
(356, 'Angst', 20, '', 0, 'ARK5 63', NULL),
(357, 'Brot und Wasser', 21, '', 0, '', NULL),
(358, 'Auffrischen', 21, '', 0, '', NULL),
(359, 'Geisterhorn', 21, '', 0, '', NULL),
(360, 'Scharfblick', 21, '', 0, '', NULL),
(361, 'Macht über die Sinne', 21, '', 0, '', NULL),
(362, 'Flicken', 21, '', 0, '', NULL);

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

--
-- Tabellenstruktur für Tabelle `skill_weaponskills`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `skill_weaponskills` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `beschreibung` longtext DEFAULT NULL,
  `fertigkeitswert` bigint(20) DEFAULT NULL,
  `bonus` bigint(20) DEFAULT NULL,
  `pp` bigint(20) DEFAULT NULL,
  `bemerkung` longtext DEFAULT NULL,
  `improvable` tinyint(1) DEFAULT NULL,
  `category` longtext DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `skill_weaponskills`
--

INSERT INTO `skill_weaponskills` (`id`, `name`, `character_id`, `beschreibung`, `fertigkeitswert`, `bonus`, `pp`, `bemerkung`, `improvable`, `category`, `user_id`) VALUES
(59, 'Einhandschlagwaffen', 15, '', 8, 0, 0, '', 0, '', NULL),
(60, 'Stichwaffen', 15, '', 8, 0, 0, '', 0, '', NULL),
(61, 'Stielwurfwaffen', 15, '', 8, 0, 0, '', 0, '', NULL),
(62, 'Einhandschlagwaffen', 16, '', 7, 0, 0, '', 0, '', NULL),
(63, 'Stichwaffen', 16, '', 8, 0, 0, '', 0, '', NULL),
(64, 'Zauberstäbe', 16, '', 11, 0, 0, '', 0, '', NULL),
(65, 'Stichwaffen', 17, '', 8, 0, 0, '', 0, '', NULL),
(66, 'Zauberstäbe', 17, '', 11, 0, 0, '', 0, '', NULL),
(67, 'Stichwaffen', 18, '', 12, 0, 0, '', 0, '', NULL),
(68, 'Zauberstäbe', 18, '', 11, 0, 0, '', 0, '', NULL),
(69, 'Fechtwaffen', 19, '', 10, 0, 0, '', 0, '', NULL),
(70, 'Schilde', 19, '', 3, 0, 0, '', 0, '', NULL),
(71, 'Spießwaffen', 19, '', 5, 0, 0, '', 0, '', NULL),
(72, 'Stichwaffen', 19, '', 5, 0, 0, '', 0, '', NULL),
(73, 'Wurfklingen', 19, '', 9, 0, 0, '', 0, '', NULL),
(74, 'Armbrüste', 20, '', 8, 0, 0, '', 0, '', NULL),
(75, 'Einhandschlagwaffen', 20, '', 8, 0, 0, '', 0, '', NULL),
(76, 'Schilde', 20, '', 3, 0, 0, '', 0, '', NULL),
(77, 'Spießwaffen', 20, '', 8, 0, 0, '', 0, '', NULL),
(78, 'Stichwaffen', 20, '', 8, 0, 0, '', 0, '', NULL),
(79, 'Stielwurfwaffen', 20, '', 5, 0, 0, '', 0, '', NULL),
(80, 'Waffenloser Kampf', 20, '', 8, 0, 0, '', 0, '', NULL),
(81, 'Zweihandschlagwaffen', 20, '', 8, 0, 0, '', 0, '', NULL),
(82, 'Stichwaffen', 21, '', 0, 0, 0, '', 1, 'Waffen', NULL),
(83, 'Zauberstäbe', 22, '', 0, 0, 0, '', 1, 'Waffen', NULL);

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

--
-- Tabellenstruktur für Tabelle `equi_weapons`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `equi_weapons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ist_magisch` tinyint(1) DEFAULT NULL,
  `abw` bigint(20) DEFAULT NULL,
  `ausgebrannt` tinyint(1) DEFAULT NULL,
  `beschreibung` longtext DEFAULT NULL,
  `abwb` bigint(20) DEFAULT NULL,
  `anb` bigint(20) DEFAULT NULL,
  `anzahl` bigint(20) DEFAULT NULL,
  `beinhaltet_in` longtext DEFAULT NULL,
  `contained_in` bigint(20) UNSIGNED DEFAULT NULL,
  `container_type` longtext DEFAULT NULL,
  `gewicht` double DEFAULT NULL,
  `name_fuer_spezialisierung` longtext DEFAULT NULL,
  `schb` bigint(20) DEFAULT NULL,
  `wert` double DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `equi_weapons`
--

INSERT INTO `equi_weapons` (`id`, `name`, `character_id`, `ist_magisch`, `abw`, `ausgebrannt`, `beschreibung`, `abwb`, `anb`, `anzahl`, `beinhaltet_in`, `contained_in`, `container_type`, `gewicht`, `name_fuer_spezialisierung`, `schb`, `wert`, `user_id`) VALUES
(64, 'Dolch', 15, 0, 0, 0, '', 0, 0, 1, '', 0, '', 0.5, 'Dolch', 0, 5, NULL),
(65, 'Keule', 15, 0, 0, 0, '', 0, 0, 1, '', 0, '', 2.5, 'Keule', 0, 8, NULL),
(66, 'Wurfkeule', 15, 0, 0, 0, '', 0, 0, 1, '', 0, '', 2, 'Wurfkeule', 0, 12, NULL),
(67, 'Dolch', 16, 0, 0, 0, '', 0, 0, 1, '', 0, '', 0.5, 'Dolch', 0, 5, NULL),
(68, 'Dolch', 16, 0, 0, 0, '', 0, 0, 1, '', 0, '', 0.5, 'Dolch', 0, 5, NULL),
(69, 'Dolch', 16, 0, 0, 0, 'Todbringer', 0, 0, 1, '', 0, '', 0.5, 'Dolch', 0, 5, NULL),
(70, 'Dolch', 16, 1, 0, 0, 'Blutbefreier', 0, 1, 1, '', 0, '', 0.5, 'Dolch', 1, 5, NULL),
(71, 'Magierstab', 16, 0, 0, 0, 'Vilbratr', 0, 0, 1, '', 0, '', 1.5, 'Magierstab', 0, 15, NULL),
(72, 'Streitaxt', 16, 0, 0, 0, 'Brustöffner', 0, 0, 1, '', 0, '', 2.5, 'Streitaxt', 0, 20, NULL),
(73, 'Dolch', 17, 0, 0, 0, '', 0, 0, 1, '', 0, '', 0.5, 'Dolch', 0, 5, NULL),
(74, 'Dolch der Kurtisane', 17, 1, 0, 0, '', 1, 2, 1, '', 0, '', 0.5, 'Dolch', 1, 10000, NULL),
(75, 'Dolch', 17, 1, 0, 0, '', 0, 1, 1, '', 0, '', 0.5, 'Dolch', 1, 5, NULL),
(76, 'Magierstecken', 17, 0, 0, 0, 'Abwehr +1', 0, 0, 1, '', 0, '', 2, 'Magierstecken', 0, 20, NULL),
(77, 'Turmschild der Alpanu', 17, 1, 0, 0, 'Halbrelief der strahlenden Alpanu', 1, 1, 1, '', 0, '', 5, 'Schild:groß', 1, 1500, NULL),
(78, 'Dolch', 18, 0, 0, 0, '', 0, 0, 1, '', 0, '', 0.5, 'Dolch', 0, 5, NULL),
(79, 'Handaxt', 18, 0, 0, 0, '', 0, 0, 1, '', 0, '', 1.5, 'Handaxt', 0, 10, NULL),
(80, 'Magierstab', 18, 1, 5, 0, 'Thaumagral: Heranholen, sofortiges Versetzen', 0, 0, 1, '', 0, '', 1.5, 'Magierstab', 0, 15, NULL),
(81, 'Ochsenzunge', 18, 0, 0, 0, '', 0, 0, 1, '', 0, '', 1, 'Ochsenzunge', 0, 10, NULL),
(82, 'Peitsche', 18, 0, 0, 0, '', 0, 0, 1, '', 0, '', 1, 'Peitsche', 0, 8, NULL),
(83, 'Buckler', 19, 0, 0, 0, '', 0, 0, 1, '', 0, '', 1, 'Buckler', 0, 10, NULL),
(84, 'Dolch', 19, 0, 0, 0, '', 0, 0, 1, '', 0, '', 0.5, 'Dolch', 0, 5, NULL),
(85, 'Fuchtel', 19, 0, 0, 0, '', 0, 0, 1, '', 0, '', 2, 'Fuchtel', 0, 100, NULL),
(86, 'Stoßspeer', 19, 0, 0, 0, '', 0, 0, 1, '', 0, '', 2.5, 'Stoßspeer', 0, 8, NULL),
(87, 'Triste - Rapier', 19, 1, 0, 0, '+1/+1 Rapier; unzerbrechlich\n+2/ +2 bei Fechtangriff', 0, 1, 1, '', 0, '', 1.5, 'Rapier', 1, 70, NULL),
(88, 'Wurfmesser', 19, 0, 0, 0, '', 0, 0, 3, '', 0, '', 0.3, 'Wurfmesser', 0, 10, NULL),
(89, 'Armbrust:schwer', 20, 0, 0, 0, '', 0, 0, 1, 'moam-container-47363', 62, '', 5, 'Armbrust:schwer', 0, 40, NULL);

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

--
-- Tabellenstruktur für Tabelle `audit_log_entries`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `audit_log_entries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `character_id` bigint(20) UNSIGNED NOT NULL,
  `field_name` longtext NOT NULL,
  `old_value` bigint(20) DEFAULT NULL,
  `new_value` bigint(20) DEFAULT NULL,
  `difference` bigint(20) DEFAULT NULL,
  `reason` longtext DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `timestamp` datetime(3) DEFAULT NULL,
  `notes` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `audit_log_entries`
--

INSERT INTO `audit_log_entries` (`id`, `character_id`, `field_name`, `old_value`, `new_value`, `difference`, `reason`, `user_id`, `timestamp`, `notes`) VALUES
(1, 21, 'experience_points', 0, 120, 120, 'manual', 0, '2025-08-28 09:15:28.019', 'Manual adjustment: Added 120 EP'),
(2, 21, 'experience_points', 120, 110, -10, 'manual', 0, '2025-08-28 09:15:36.192', 'Manual adjustment: Added 10 EP'),
(3, 22, 'gold', 0, 20, 20, 'manual', 0, '2025-08-28 09:52:10.988', 'Manual adjustment: Added 20 GS'),
(4, 22, 'experience_points', 0, 20, 20, 'manual', 0, '2025-08-28 09:54:31.816', 'Manual adjustment: Added 20 EP'),
(5, 22, 'experience_points', 20, 23, 3, 'manual', 0, '2025-08-28 09:58:51.755', 'Manual adjustment: Added 3 EP');

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

--
-- Tabellenstruktur für Tabelle `char_bennies`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_bennies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `gg` bigint(20) DEFAULT NULL,
  `gp` bigint(20) DEFAULT NULL,
  `sg` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_bennies`
--

INSERT INTO `char_bennies` (`id`, `name`, `character_id`, `gg`, `gp`, `sg`, `user_id`) VALUES
(15, 'bennies', 15, 0, 0, 4, NULL),
(16, 'bennies', 16, 0, 0, 9, NULL),
(17, 'bennies', 17, 0, 0, 5, NULL),
(18, 'bennies', 18, 5, 0, 12, NULL),
(19, 'bennies', 19, 0, 0, 4, NULL),
(20, 'bennies', 20, 0, 0, 1, NULL);

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

--
-- Tabellenstruktur für Tabelle `char_characteristics`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_characteristics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `augenfarbe` longtext DEFAULT NULL,
  `haarfarbe` longtext DEFAULT NULL,
  `sonstige` longtext DEFAULT NULL,
  `breite` longtext DEFAULT NULL,
  `groesse` longtext DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_characteristics`
--

INSERT INTO `char_characteristics` (`id`, `name`, `character_id`, `augenfarbe`, `haarfarbe`, `sonstige`, `breite`, `groesse`, `user_id`) VALUES
(15, '', 15, '', '', '', 'breit', 'klein', NULL),
(16, '', 16, '', '', '', 'normal', 'mittel', NULL),
(17, '', 17, 'grün', 'blau', '', 'normal', 'mittel', NULL),
(18, '', 18, 'blau-grau,grün-grau', 'dunkelbraun', 'Brandnarben im Gesicht', 'schlank', 'groß', NULL),
(19, '', 19, 'braun', 'schwarz', '', 'normal', 'mittel', NULL),
(20, '', 20, 'blau', 'sandfarben', '', 'breit', 'klein', NULL);

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

--
-- Tabellenstruktur für Tabelle `char_chars`
--
-- Erstellt am: 24. Dez 2025 um 07:02
-- Zuletzt aktualisiert: 24. Dez 2025 um 07:25
--

CREATE TABLE `char_chars` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 1,
  `rasse` longtext DEFAULT NULL,
  `typ` longtext DEFAULT NULL,
  `alter` bigint(20) DEFAULT NULL,
  `anrede` longtext DEFAULT NULL,
  `grad` bigint(20) DEFAULT NULL,
  `groesse` bigint(20) DEFAULT NULL,
  `gewicht` bigint(20) DEFAULT NULL,
  `glaube` longtext DEFAULT NULL,
  `hand` longtext DEFAULT NULL,
  `public` tinyint(1) DEFAULT NULL,
  `spezialisierung` text DEFAULT NULL,
  `image` longtext DEFAULT NULL,
  `gender` longtext DEFAULT NULL,
  `social_class` longtext DEFAULT NULL,
  `herkunft` longtext DEFAULT NULL,
  `resistenz_koerper` bigint(20) DEFAULT NULL,
  `resistenz_geist` bigint(20) DEFAULT NULL,
  `abwehr` bigint(20) DEFAULT NULL,
  `zaubern` bigint(20) DEFAULT NULL,
  `raufen` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_chars`
--

INSERT INTO `char_chars` (`id`, `name`, `user_id`, `rasse`, `typ`, `alter`, `anrede`, `grad`, `groesse`, `gewicht`, `glaube`, `hand`, `public`, `spezialisierung`, `image`, `gender`, `social_class`, `herkunft`, `resistenz_koerper`, `resistenz_geist`, `abwehr`, `zaubern`, `raufen`) VALUES
(15, 'Example 1', 1, 'Mensch', 'Schamane', 18, 'er', 8, 26, 17, 'Schamanistisch', 'beide', 0, 'null', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 'Example 2', 1, 'Mensch', 'Thaumaturg', 28, 'er', 18, 173, 77, 'Fjörgün', 'rechts', 0, 'null', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `char_chars` (`id`, `name`, `user_id`, `rasse`, `typ`, `alter`, `anrede`, `grad`, `groesse`, `gewicht`, `glaube`, `hand`, `public`, `spezialisierung`, `image`, `gender`, `social_class`, `herkunft`, `resistenz_koerper`, `resistenz_geist`, `abwehr`, `zaubern`, `raufen`) VALUES
(17, 'Example 3', 1, 'Mensch', 'Magier', 23, 'er', 11, 171, 74, 'Notun', 'links', 0, '[\"Erschaffen\"]', 'data:image;base64,[encoded data, 102376 characters]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `char_chars` (`id`, `name`, `user_id`, `rasse`, `typ`, `alter`, `anrede`, `grad`, `groesse`, `gewicht`, `glaube`, `hand`, `public`, `spezialisierung`, `image`, `gender`, `social_class`, `herkunft`, `resistenz_koerper`, `resistenz_geist`, `abwehr`, `zaubern`, `raufen`) VALUES
(18, 'Example 4', 1, 'Mensch', 'Hexer', 33, 'er', 23, 186, 65, '', 'rechts', 0, 'null', 'data:image;base64,[encoded data, 462208 characters]', 'Männlich', 'Mittelschicht', 'Küstenstaaten', 16, 16, 16, 18, 8);
INSERT INTO `char_chars` (`id`, `name`, `user_id`, `rasse`, `typ`, `alter`, `anrede`, `grad`, `groesse`, `gewicht`, `glaube`, `hand`, `public`, `spezialisierung`, `image`, `gender`, `social_class`, `herkunft`, `resistenz_koerper`, `resistenz_geist`, `abwehr`, `zaubern`, `raufen`) VALUES
(19, 'Example 5', 1, 'Mensch', 'Tiermeister', 25, 'er', 12, 169, 70, 'schamanistisch', 'rechts', 0, '[\"Fuchtel\"]', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `char_chars` (`id`, `name`, `user_id`, `rasse`, `typ`, `alter`, `anrede`, `grad`, `groesse`, `gewicht`, `glaube`, `hand`, `public`, `spezialisierung`, `image`, `gender`, `social_class`, `herkunft`, `resistenz_koerper`, `resistenz_geist`, `abwehr`, `zaubern`, `raufen`) VALUES
(20, 'Example 6', 1, 'Zwerg', 'Krieger', 39, 'er', 3, 140, 82, 'Torkin', 'rechts', 0, '[\"Kriegshammer\",\"Armbrust:schwer\",\"Stielhammer\"]', 'data:image;base64,[encoded data, 399904 characters]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `char_chars` (`id`, `name`, `user_id`, `rasse`, `typ`, `alter`, `anrede`, `grad`, `groesse`, `gewicht`, `glaube`, `hand`, `public`, `spezialisierung`, `image`, `gender`, `social_class`, `herkunft`, `resistenz_koerper`, `resistenz_geist`, `abwehr`, `zaubern`, `raufen`) VALUES
(21, 'Example 7', 4, 'Mensch', 'Hexer', 0, '', 1, 0, 0, '', '', 0, 'null', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, 'Example 8', 4, 'Elf', 'Magier', 0, '', 1, 0, 0, '', '', 1, 'null', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Tabellenstruktur für Tabelle `char_char_creation_session`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_char_creation_session` (
  `id` varchar(191) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `rasse` longtext DEFAULT NULL,
  `typ` longtext DEFAULT NULL,
  `herkunft` longtext DEFAULT NULL,
  `glaube` longtext DEFAULT NULL,
  `attributes` text DEFAULT NULL,
  `derived_values` text DEFAULT NULL,
  `skills` text DEFAULT NULL,
  `spells` text DEFAULT NULL,
  `skill_points` text DEFAULT NULL,
  `created_at` datetime(3) DEFAULT NULL,
  `updated_at` datetime(3) DEFAULT NULL,
  `expires_at` datetime(3) DEFAULT NULL,
  `current_step` bigint(20) DEFAULT NULL,
  `geschlecht` longtext DEFAULT NULL,
  `stand` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Tabellenstruktur für Tabelle `char_eigenschaften`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_eigenschaften` (
  `id` bigint(20) UNSIGNED DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `value` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_eigenschaften`
--

INSERT INTO `char_eigenschaften` (`id`, `character_id`, `name`, `value`, `user_id`) VALUES
(0, 15, 'Au', 51, NULL),
(0, 15, 'Gs', 59, NULL),
(0, 15, 'Gw', 91, NULL),
(0, 15, 'In', 69, NULL),
(0, 15, 'Ko', 83, NULL),
(0, 15, 'PA', 80, NULL),
(0, 15, 'St', 73, NULL),
(0, 15, 'Wk', 71, NULL),
(0, 15, 'Zt', 53, NULL),
(0, 16, 'Au', 69, NULL),
(0, 16, 'Gs', 80, NULL),
(0, 16, 'Gw', 37, NULL),
(0, 16, 'In', 96, NULL),
(0, 16, 'Ko', 82, NULL),
(0, 16, 'PA', 69, NULL),
(0, 16, 'St', 79, NULL),
(0, 16, 'Wk', 91, NULL),
(0, 16, 'Zt', 74, NULL),
(0, 17, 'Au', 80, NULL),
(0, 17, 'Gs', 78, NULL),
(0, 17, 'Gw', 70, NULL),
(0, 17, 'In', 100, NULL),
(0, 17, 'Ko', 74, NULL),
(0, 17, 'PA', 36, NULL),
(0, 17, 'St', 89, NULL),
(0, 17, 'Wk', 66, NULL),
(0, 17, 'Zt', 91, NULL),
(0, 18, 'Au', 12, NULL),
(0, 18, 'Gs', 91, NULL),
(0, 18, 'Gw', 100, NULL),
(0, 18, 'In', 93, NULL),
(0, 18, 'Ko', 59, NULL),
(0, 18, 'PA', 90, NULL),
(0, 18, 'St', 61, NULL),
(0, 18, 'Wk', 100, NULL),
(0, 18, 'Zt', 50, NULL),
(0, 19, 'Au', 84, NULL),
(0, 19, 'Gs', 69, NULL),
(0, 19, 'Gw', 98, NULL),
(0, 19, 'In', 64, NULL),
(0, 19, 'Ko', 85, NULL),
(0, 19, 'PA', 93, NULL),
(0, 19, 'St', 91, NULL),
(0, 19, 'Wk', 34, NULL),
(0, 19, 'Zt', 60, NULL),
(0, 20, 'Au', 74, NULL),
(0, 20, 'Gs', 96, NULL),
(0, 20, 'Gw', 70, NULL),
(0, 20, 'In', 65, NULL),
(0, 20, 'Ko', 85, NULL),
(0, 20, 'PA', 75, NULL),
(0, 20, 'St', 95, NULL),
(0, 20, 'Wk', 71, NULL),
(0, 20, 'Zt', 35, NULL),
(0, 21, 'Au', 10, NULL),
(0, 21, 'Gs', 74, NULL),
(0, 21, 'Gw', 84, NULL),
(0, 21, 'In', 94, NULL),
(0, 21, 'Ko', 48, NULL),
(0, 21, 'pA', 38, NULL),
(0, 21, 'St', 81, NULL),
(0, 21, 'Wk', 93, NULL),
(0, 21, 'Zt', 75, NULL),
(0, 22, 'Au', 88, NULL),
(0, 22, 'Gs', 8, NULL),
(0, 22, 'Gw', 76, NULL),
(0, 22, 'In', 82, NULL),
(0, 22, 'Ko', 31, NULL),
(0, 22, 'pA', 31, NULL),
(0, 22, 'St', 74, NULL),
(0, 22, 'Wk', 57, NULL),
(0, 22, 'Zt', 91, NULL);

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

--
-- Tabellenstruktur für Tabelle `char_endurances`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_endurances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `max` bigint(20) DEFAULT NULL,
  `value` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_endurances`
--

INSERT INTO `char_endurances` (`id`, `character_id`, `max`, `value`) VALUES
(15, 15, 38, 12),
(16, 16, 61, 58),
(17, 17, 45, 33),
(18, 18, 68, 63),
(19, 19, 53, 51),
(20, 20, 31, 31),
(21, 21, 13, 13),
(22, 22, 12, 12);

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

--
-- Tabellenstruktur für Tabelle `char_experiances`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_experiances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `es` bigint(20) DEFAULT NULL,
  `ep` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_experiances`
--

INSERT INTO `char_experiances` (`id`, `name`, `character_id`, `es`, `ep`, `user_id`) VALUES
(14, '', 15, 100, 0, NULL),
(15, '', 16, 7249, 0, NULL),
(16, '', 17, 2799, 0, NULL),
(17, '', 18, 15950, 600, NULL),
(18, '', 19, 3125, 0, NULL),
(19, '', 20, 326, 260, NULL),
(20, '', 21, 0, 110, 0),
(21, '', 22, 0, 23, 0);

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

--
-- Tabellenstruktur für Tabelle `char_health`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_health` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `max` bigint(20) DEFAULT NULL,
  `value` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_health`
--

INSERT INTO `char_health` (`id`, `character_id`, `max`, `value`) VALUES
(15, 15, 6, 6),
(16, 16, 17, 17),
(17, 17, 15, 15),
(18, 18, 15, 15),
(19, 19, 18, 18),
(20, 20, 17, 17),
(21, 21, 15, 15),
(22, 22, 11, 11);

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

--
-- Tabellenstruktur für Tabelle `char_motionranges`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_motionranges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `max` bigint(20) DEFAULT NULL,
  `value` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_motionranges`
--

INSERT INTO `char_motionranges` (`id`, `character_id`, `max`, `value`) VALUES
(15, 15, 7, 0),
(16, 16, 23, 0),
(17, 17, 25, 0),
(18, 18, 27, 0),
(19, 19, 27, 0),
(20, 20, 18, 18),
(21, 21, 25, 25),
(22, 22, 26, 26);

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

--
-- Tabellenstruktur für Tabelle `char_wealth`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `char_wealth` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `goldstücke` bigint(20) DEFAULT NULL,
  `silberstücke` bigint(20) DEFAULT NULL,
  `kupferstücke` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `goldstuecke` bigint(20) DEFAULT NULL,
  `silberstuecke` bigint(20) DEFAULT NULL,
  `kupferstuecke` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `char_wealth`
--

INSERT INTO `char_wealth` (`id`, `name`, `character_id`, `goldstücke`, `silberstücke`, `kupferstücke`, `user_id`, `goldstuecke`, `silberstuecke`, `kupferstuecke`) VALUES
(1, '', 20, 310, 0, 0, NULL, NULL, NULL, NULL),
(2, '', 15, 250, 50, 200, NULL, NULL, NULL, NULL),
(3, '', 18, 1900, 0, 0, NULL, NULL, NULL, NULL),
(5, '', 22, 20, 0, 0, 1, NULL, NULL, NULL);

-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `equi_containers`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `equi_containers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ist_magisch` tinyint(1) DEFAULT NULL,
  `abw` bigint(20) DEFAULT NULL,
  `ausgebrannt` tinyint(1) DEFAULT NULL,
  `beschreibung` longtext DEFAULT NULL,
  `beinhaltet_in` longtext DEFAULT NULL,
  `contained_in` bigint(20) UNSIGNED DEFAULT NULL,
  `is_transportation` tinyint(1) DEFAULT NULL,
  `gewicht` double DEFAULT NULL,
  `wert` double DEFAULT NULL,
  `tragkraft` double DEFAULT NULL,
  `volumen` double DEFAULT NULL,
  `ext_id` longtext DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `equi_containers`
--

INSERT INTO `equi_containers` (`id`, `name`, `character_id`, `ist_magisch`, `abw`, `ausgebrannt`, `beschreibung`, `beinhaltet_in`, `contained_in`, `is_transportation`, `gewicht`, `wert`, `tragkraft`, `volumen`, `ext_id`, `user_id`) VALUES
(50, 'Satteltaschen', 17, 0, 0, 0, '', '', 0, 0, 1, 8, 30, 25, 'moam-container-43858', NULL),
(51, 'Amphore, Keramik', 18, 0, 0, 0, '1 Liter', '', 0, 0, 0.4, 0.7, 1, 1, 'moam-container-25068', NULL),
(52, 'Beutel, Leder', 18, 0, 0, 0, 'für 20 Münzen', '', 0, 0, 0.01, 0.5, 1, 0.25, 'moam-container-25069', NULL),
(53, 'Beutel, Leder', 18, 0, 0, 0, 'für 20 Münzen', '', 0, 0, 0.01, 0.5, 1, 0.25, 'moam-container-37424', NULL),
(54, 'Gürteltasche, Leder', 18, 0, 0, 0, 'für 20 Münzen', '', 0, 0, 0.01, 2, 1, 0.25, 'moam-container-25070', NULL),
(55, 'Lederhülle', 18, 0, 0, 0, 'wasserdicht für Schriftrollen', '', 0, 0, 0.03, 3, 0.5, 0.3, 'moam-container-25067', NULL),
(56, 'Lederrucksack', 18, 0, 0, 0, 'für 25 kg', '', 0, 0, 0.5, 4, 25, 25, 'moam-container-25072', NULL),
(57, 'Sack, klein', 18, 0, 0, 0, 'für 25 kg', '', 0, 0, 0.05, 0.2, 25, 15, 'moam-container-25071', NULL),
(58, 'Becher, Holz', 19, 0, 0, 0, '1/4 Liter', '', 0, 0, 0.05, 0.1, 0.25, 0.25, 'moam-container-41053', NULL),
(59, 'Beutel, Leder', 19, 0, 0, 0, 'für 20 Münzen', '', 0, 0, 0.01, 0.5, 1, 0.25, 'moam-container-41054', NULL),
(60, 'Lederrucksack', 19, 0, 0, 0, 'für 25 kg', '', 0, 0, 0.5, 4, 25, 25, 'moam-container-41055', NULL),
(61, 'Sack, klein', 19, 0, 0, 0, 'für 25 kg', '', 0, 0, 0.05, 0.2, 25, 15, 'moam-container-41056', NULL),
(62, 'Lederrucksack', 20, 0, 0, 0, 'für 25 kg', '', 0, 0, 0.5, 4, 25, 25, 'moam-container-47363', NULL),
(63, 'Karren', 20, 0, 0, 0, 'für 250 kg', '', 0, 1, 40, 14, 250, 0, 'moam-container-47000', NULL);

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

--
-- Tabellenstruktur für Tabelle `equi_equipments`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `equi_equipments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext DEFAULT NULL,
  `character_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ist_magisch` tinyint(1) DEFAULT NULL,
  `abw` bigint(20) DEFAULT NULL,
  `ausgebrannt` tinyint(1) DEFAULT NULL,
  `beschreibung` longtext DEFAULT NULL,
  `anzahl` bigint(20) DEFAULT NULL,
  `beinhaltet_in` longtext DEFAULT NULL,
  `contained_in` bigint(20) UNSIGNED DEFAULT NULL,
  `container_type` longtext DEFAULT NULL,
  `bonus` bigint(20) DEFAULT NULL,
  `gewicht` double DEFAULT NULL,
  `wert` double DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `equi_equipments`
--

INSERT INTO `equi_equipments` (`id`, `name`, `character_id`, `ist_magisch`, `abw`, `ausgebrannt`, `beschreibung`, `anzahl`, `beinhaltet_in`, `contained_in`, `container_type`, `bonus`, `gewicht`, `wert`, `user_id`) VALUES
(155, 'Lederrüstung', 15, 0, 0, 0, '', 1, '', 0, '', 0, 13, 30, NULL),
(156, 'Lederrüstung', 16, 0, 0, 0, '', 1, '', 0, '', 0, 13, 30, NULL),
(157, 'Panzerkette', 16, 1, 0, 0, '4 Meter lange Metallkette mit Runenverzierungen. Kann auf dem Boden in beliebiger Form ausgelegt werden und mit dem thaumaturgischen Siegel Zauberschild aktiviert werden. Dann erscheint der Zauberschild über der gesamten Länge der Kette und auch exakt in der ausgelegten Form. Solange der Zauber wirkt, kann die Kette nicht wieder aufgehoben werden. ABW: 10', 1, '', 0, '', 0, 0, 0, NULL),
(158, 'Lederrüstung', 17, 0, 0, 0, '', 1, '', 0, '', 0, 13, 30, NULL),
(159, 'Bronzeglöckchen, klein', 17, 0, 0, 0, '', 1, '', 0, '', 0, 0.05, 2, NULL),
(160, 'Estoleischer Diplomatenpass', 17, 0, 0, 0, '', 1, '', 0, '', 0, 0, 0, NULL),
(161, 'Fackeln', 17, 0, 0, 0, '', 10, '', 0, '', 0, 0.5, 0.3, NULL),
(162, 'Flügelpferd', 17, 1, 0, 0, 'Dreibeiniges mythisches geflügeltes Pferd', 1, '', 0, '', 0, 500, 150, NULL),
(163, 'Handschuhe, Leder', 17, 0, 0, 0, '', 1, '', 0, '', 0, 0, 3, NULL),
(164, 'Hemd', 17, 0, 0, 0, '', 1, '', 0, '', 0, 0, 3, NULL),
(165, 'Hose', 17, 0, 0, 0, '', 1, '', 0, '', 0, 0, 5, NULL),
(166, 'Magisches Buch mit Zaubersprüchen', 17, 1, 0, 0, 'Zum Erlernen der Zaubersprüche:\r\nBrot und Wasser\r\nEiswand\r\nBlitze schleudern\r\nAuffrischen\r\nVergrößern', 1, 'moam-container-43858', 50, '', 0, 2, 3200, NULL),
(167, 'Reitpferd', 17, 0, 0, 0, 'schöner kräftiger Fuchs', 1, '', 0, '', 0, 500, 150, NULL),
(168, 'Schriftrolle', 17, 1, 0, 0, 'Wassermeisterschaft', 1, '', 0, '', 0, 0.1, 1000, NULL),
(169, 'Schuhe', 17, 0, 0, 0, '', 1, '', 0, '', 0, 0, 5, NULL),
(170, 'Seil', 17, 0, 0, 0, '', 20, '', 0, '', 0, 0.075, 1, NULL),
(171, 'Silber-Brokat', 17, 0, 0, 0, '2qm Silber-Brokat mit floralem Muster', 1, 'moam-container-43858', 50, '', 0, 2, 0, NULL),
(172, 'Turban', 17, 0, 0, 0, '', 1, '', 0, '', 0, 0, 0, NULL),
(173, 'Umhang der Reisenden', 17, 1, 0, 0, 'schwarzer Brokat mit goldenen überbordende orientalen Stickereien', 1, '', 0, '', 0, 1.5, 8, NULL),
(174, 'Lederrüstung', 18, 0, 0, 0, '', 1, '', 0, '', 0, 13, 30, NULL),
(175, 'Alltagskleidung', 18, 0, 0, 0, 'dunkel', 1, '', 0, '', 0, 0, 0, NULL),
(176, 'Angelhaken', 18, 0, 0, 0, '', 1, 'moam-container-25070', 54, '', 0, 0.05, 2, NULL),
(177, 'Angelschnur', 18, 0, 0, 0, '', 20, 'moam-container-25070', 54, '', 0, 0, 1, NULL),
(178, 'Armreif der gesammelten Energie', 18, 1, 10, 0, 'siehe Notiz', 1, '', 0, '', 0, 0, 0, NULL),
(179, 'Armreif, Deckmantel', 18, 1, 10, 0, '', 1, '', 0, '', 0, 0, 0, NULL),
(180, 'Decke, leicht', 18, 0, 0, 0, '', 1, '', 0, '', 0, 1, 2, NULL),
(181, 'Eisbärenstiefel', 18, 1, 5, 0, 'siehe Notiz', 1, '', 0, '', 0, 0, 0, NULL),
(182, 'elegante Kleidung', 18, 0, 0, 0, 'Hose Wams Hut Schuhe...', 1, '', 0, '', 0, 0, 0, NULL),
(183, 'Heiltrunk (1W6)', 18, 0, 0, 0, '', 2, 'moam-container-25072', 56, '', 0, 0, 200, NULL),
(184, 'Katzenaugen', 18, 1, 3, 0, 'siehe Notiz', 1, '', 0, '', 0, 0, 0, NULL),
(185, 'Krafttrunk (1W6)', 18, 0, 0, 0, '', 3, 'moam-container-25072', 56, '', 0, 0, 100, NULL),
(186, 'Krafttrunk (3W6)', 18, 0, 0, 0, '', 1, 'moam-container-25072', 56, '', 0, 0, 300, NULL),
(187, 'Kreidestück', 18, 0, 0, 0, '', 1, 'moam-container-25069', 52, '', 0, 0.02, 0.2, NULL),
(188, 'Kupferkessel klein mit Deckel', 18, 0, 0, 0, 'mit Deckel', 1, 'moam-container-25072', 56, '', 0, 0, 0, NULL),
(189, 'Maganbrot', 18, 0, 0, 0, '', 1, 'moam-container-25072', 56, '', 0, 0, 100, NULL),
(190, 'Pergament', 18, 0, 0, 0, '', 5, 'moam-container-25067', 55, '', 0, 0.05, 1, NULL),
(191, 'Schnellkraut', 18, 0, 0, 0, '', 1, 'moam-container-25070', 54, '', 0, 0, 500, NULL),
(192, 'Schreibpinsel', 18, 0, 0, 0, '', 1, 'moam-container-25069', 52, '', 0, 0.02, 0.5, NULL),
(193, 'Seil', 18, 0, 0, 0, '', 20, 'moam-container-25072', 56, '', 0, 0.075, 1, NULL),
(194, 'Siegelwachs', 18, 0, 0, 0, '', 1, 'moam-container-25069', 52, '', 0, 0.25, 1, NULL),
(195, 'Tusche', 18, 0, 0, 0, 'Tinte in schwarz, blau, rot, unsichtbar', 4, 'moam-container-25070', 54, '', 0, 0.05, 2, NULL),
(196, 'Umhang', 18, 0, 0, 0, 'Wolle, schwarz mit Kaputze', 1, '', 0, '', 0, 0, 12, NULL),
(197, 'Zauberöl', 18, 0, 0, 0, '', 5, 'moam-container-25068', 51, '', 0, 0.2, 20, NULL),
(198, 'Zauberwürfel', 18, 1, 6, 0, '', 1, '', 0, '', 0, 0.2, 0, NULL),
(199, 'Zeichenkohle', 18, 0, 0, 0, '', 1, 'moam-container-25069', 52, '', 0, 0.03, 0.1, NULL),
(200, 'Zwielichtstab', 18, 1, 5, 0, 'Einst gehörte er einem mächtigen Zauberer aus den Chaoswelten. Er ist sehr begehrt im Multiversum. T\'challinek übergibt ihn nicht zuletzt deswegen an Fanjo, weil er das verfluchte Teil endlich einmal eine Weile los sein will.\r\n\r\nAussehen\r\nEin Zauberstab aus Schatten, der auf einen Gedanklichen Befehl in der Hand erscheint und ebenso wieder verschwindet. Nur in manifestierter Form kann er den Besitzer wechseln.\r\n\r\nEigenschaften\r\nEr ist magisch *(+3/+3) und magisch unerspürbar (bei Zauberduellen Zaubern+30). Er durchdringt tote Materie (außer Metall). Mit ihm kann ein Zauberer Berührungszauber als Gedankenzauber vollbringen, selbst wenn sie eigentlich Geste oder Wort sind (dabei muss der Stab das Ziel berühren, außerdem ABW 5).\r\n\r\nEr vermag es gegen Entzug sämtlicher AP aller bis zu 6 Personen diese ins Zwiellicht zu ziehen (ABW 1). Dort können sie wie körperlose Geister nur von magischen Waffen verletzt werden und können Materie durchdringen. Sie können weder sprechen noch Materie verletzen. In gewisser Weise sind sie mit körperlosen Geistern vergleichbar. Darüber hinaus gleichen sie Schatten und können so auch recht schlecht entdeckt werden. Um zurück aus dem Zwielicht zu treten muss der Zauberer LP vergießen (nicht unbedingt eigene). Da das nicht auf normalem Wege geht, rät T\'challinek zu dem Zauber Verursachen von Wunden, den er zu diesem Zweck lehren würde.)', 1, '', 0, '', 0, 0, 0, NULL),
(201, 'Lederrüstung', 19, 0, 0, 0, '', 1, '', 0, '', 0, 13, 30, NULL),
(202, 'Berglöwin \"Massima\"', 19, 0, 0, 0, 'Massimas Spieldaten:\nGrad 6 (e)\nLP 18, AP 28 - TR\nSt 70, Gw 90, In t60 - B 36 - Abwehr+16; Resistenz+13/14\nAngriff: Tatze+10 (1W6-1), im Handgemenge zusätzlich Biss+10 (1W6+1), Hinterpfoten+10 (1W6-1) - Raufen+8 (1W6-1)\n_Geländelauf+15, Schleichen+17, Tarnen+17, Nachtsicht+2_\nAnspringen (= +4 ab einer Distanz von 2m auf den Tatzenangriff)\n\nBeherrschte Tricks (siehe Mys, S. 20):  \nAngreifen, Beruhigen, Suchen', 1, '', 0, '', 0, 100, 150, NULL),
(203, 'Decke, warm', 19, 0, 0, 0, '', 1, 'moam-container-41055', 60, '', 0, 2, 4, NULL),
(204, 'Dolchscheide, einfach', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0.1, 2, NULL),
(205, 'Feuerstein und Zunder', 19, 0, 0, 0, '', 1, 'moam-container-41054', 59, '', 0, 0, 1, NULL),
(206, 'Gürtel', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0, 2, NULL),
(207, 'Handschuhe, Leder', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0, 3, NULL),
(208, 'Heiltrunk (1W6)', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0, 200, NULL),
(209, 'Hemd', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0, 3, NULL),
(210, 'Hose', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0, 5, NULL),
(211, 'Hut, Stoff', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0, 2, NULL),
(212, 'Kreidestück', 19, 0, 0, 0, '', 1, 'moam-container-41054', 59, '', 0, 0.02, 0.2, NULL),
(213, 'Lampenöl', 19, 0, 0, 0, '', 3, 'moam-container-41055', 60, '', 0, 0.3, 0.5, NULL),
(214, 'Laterne, abblendbar', 19, 0, 0, 0, '', 1, 'moam-container-41055', 60, '', 0, 1.5, 15, NULL),
(215, 'Maganbrot', 19, 0, 0, 0, '', 1, 'moam-container-41054', 59, '', 0, 0, 100, NULL),
(216, 'Reitpferd \"Acaimo\"', 19, 0, 0, 0, 'Wendiges Bergkleinpferd der Guacondas.\nMittleres Pferd - Grad 2\nLP 15, AP 15 - OR\nSt 80, Gw 60, In t50 - B 48 - Abwehr+12; Resistenz+11/13\nAngriff: Hufschlag+7 (1W6) - Raufen+7 (1W6–2) -Stampede (1W6)\n\nBeherrschte Tricks (siehe Mys, S. 20):  \nHeimlaufen, Herbeieilen, Warten', 1, '', 0, '', 0, 500, 150, NULL),
(217, 'Schuhe', 19, 0, 0, 0, '', 1, 'moam-container-41055', 60, '', 0, 0, 5, NULL),
(218, 'Schultergut, Wurfmesser', 19, 0, 0, 0, '', 0, '', 0, '', 0, 0.3, 8, NULL),
(219, 'Schwertscheide, einfach', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0.7, 5, NULL),
(220, 'Seil', 19, 0, 0, 0, '', 20, 'moam-container-41055', 60, '', 0, 0.075, 1, NULL),
(221, 'Sperber \"Costa\"', 19, 0, 0, 0, 'Grad 0\nLP 7, AP 6 - OR\nSt 20, Gw 100, In t40 - B 3/100 - Abwehr+12; Resistenz+10/12\nAngriff: Schnabel+7 (1W6-3), im Flug Klauen+7 (1W3) - Raufen+8 (1W3-1)\n_Tarnen+15_ (bei Erfolg +4 auf EW:Angriff)\n\nBeherrschte Tricks (siehe Mys, S. 20):  \nAngreifen, Apportieren, Suchen', 1, '', 0, '', 0, 0, 50, NULL),
(222, 'Stiefel, halbhoch', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0, 8, NULL),
(223, 'Stirnreif', 19, 1, 0, 0, 'erhöht Aussehen, erhöht Intelligenz', 1, '', 0, '', 0, 0, 0, NULL),
(224, 'Tamburin', 19, 0, 0, 0, '', 1, 'moam-container-41055', 60, '', 0, 2, 5, NULL),
(225, 'Umhang', 19, 0, 0, 0, '', 1, '', 0, '', 0, 0, 8, NULL),
(226, 'Zeichenkohle', 19, 0, 0, 0, '', 1, 'moam-container-41054', 59, '', 0, 0.03, 0.1, NULL),
(227, 'Lederrüstung', 20, 0, 0, 0, '', 1, '', 0, '', 0, 13, 30, NULL);

-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `users`
--
-- Erstellt am: 21. Dez 2025 um 09:25
--

CREATE TABLE `users` (
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(191) DEFAULT NULL,
  `password_hash` longtext DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `created_at` datetime(3) DEFAULT NULL,
  `updated_at` datetime(3) DEFAULT NULL,
  `reset_pw_hash` varchar(191) DEFAULT NULL,
  `reset_pw_hash_expires` datetime(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `users`
--

INSERT INTO `users` (`user_id`, `username`, `password_hash`, `email`, `created_at`, `updated_at`, `reset_pw_hash`, `reset_pw_hash_expires`) VALUES
(1, 'bebe', 'ee8b1834c791b857b5dd2b746a403000', 'frank@wuenscheonline.de', '2025-01-04 09:01:44.911', '2025-08-13 06:28:09.989', NULL, NULL),
(4, 'testuser', '179ad45c6ce2cb97cf1029e212046e81', '', '2025-07-20 21:00:28.601', '2025-07-20 21:00:28.601', NULL, NULL);
