Justoverclock So the table exists, but it is empty? If the structure matches the one I sent, it is correct...
I can't reproduce this on my end so I will have to investigate more... It might be that the original migration was wrong and that messed up the tables? Maybe redoing the tables helps?
CREATE TABLE `flarum_achievements` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`computation` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`points` int(11) NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`rectangle` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE `flarum_achievements`
ADD PRIMARY KEY (`id`);
ALTER TABLE `flarum_achievements`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
CREATE TABLE `flarum_achievement_user` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`achievement_id` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`new` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Índices para tablas volcadas
--
--
-- Indices de la tabla `flarum_achievement_user`
--
ALTER TABLE `flarum_achievement_user`
ADD PRIMARY KEY (`id`),
ADD KEY `flarum_achievement_user_user_id_achievement_id_index` (`user_id`,`achievement_id`),
ADD KEY `flarum_achievement_user_achievement_id_foreign` (`achievement_id`);
ALTER TABLE `flarum_achievement_user`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `flarum_achievement_user`
ADD CONSTRAINT `flarum_achievement_user_achievement_id_foreign` FOREIGN KEY (`achievement_id`) REFERENCES `flarum_achievements` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `flarum_achievement_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `flarum_users` (`id`) ON DELETE CASCADE;
COMMIT;
