-- --------------------------------------------------------
-- Server versie:                10.6.11-MariaDB-log - MariaDB Server
-- Server OS:                    Linux
-- --------------------------------------------------------


-- Create database
CREATE DATABASE IF NOT EXISTS `learning` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `learning`;

-- Create table learning.test
CREATE TABLE IF NOT EXISTS `test` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `resultid` bigint(10) NOT NULL,
  `linenumber` bigint(10) NOT NULL DEFAULT 0,
  `postprocessed` tinyint(2) NOT NULL DEFAULT 0,
  `htmlcode` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbfplerro_pos_ix` (`postprocessed`),
  KEY `mdl_toolbfplerro_res_ix` (`resultid`)
) ENGINE=InnoDB AUTO_INCREMENT=606782 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Errors during the accessibility checks';

-- Insert offending data into learning.test
INSERT INTO `test` (`id`, `resultid`, `linenumber`, `postprocessed`, `htmlcode`) VALUES
	(6, 1193756, 1, 0, '<img src="data:image/png;base64,[encoded data, 7700 characters]">'),
	(7, 1193810, 1, 0, '<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADgAAAA5CAYAAABj2ui7AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAqPSURBVGhDvVtpjBRFFK5d7htE7lsFBEHOzQrhDBACfwgSznAliFw/IEBMCISbdcEg4CoLqxERRSHcIgjGA1EXVG4JEBISCCxsIBBuVuh6vu9N9XTN7sxsz+zMfklnu+tV99TX9d6r917XphBDlRJozRqlHj9WKQsWmJZSAAiWCrKySJcrRzolhfSKFaYx+SgVgvqTT4jKl4eqyKFTU0mvXGmkyUXyCW7cSLpSpSC5IMmyZUl/8IHplDwklaDOyQkl99prRG3aeNc8q/rDD03v5CBpBPWmTaSrVPHItGhB9NdfROfPE7VrF2wXu1y3ztyVeCSFoJCrXt0j16wZ0ZEjRsr45x+i1q09Oc+y/vhjI0wsEk5Qf/016WrVvME3bkz0888ic7SWv4Ljx4latQr20xUrkt6wwQgTh8QS/OYbcmrW9Mg1akT0449GSLR79266fPmyuWL8+SfRK694JFml9aefGmFikDCCevt20rVqeeQaNiT64QcjDWDs2LGUmZlprgyOHiV69dUQkvT550ZYciSEoN6xg5zatT1y9esT7d9vpAE4jkODBg2iXr16UUFBgWk1+PXXgJ26JFnF9RdfGGHJUHKCe/aEkqtbl2jfPiP08OjRI+rduzdVrlyZzpw5Y1ot/PQTUdOmHkl2Uvqrr4wwfpSIoN67lzRmyyX38stEO3caKdGTJ09IG8dy8+ZNXgLbcDfFGhhBBQ8fDtitS5JVHk6rJIifIKugxmy55DCLrKo2tm3bxmYYsMOLFy9SnTp1hOCUKVOk7cqVK3T16lU5D+LAgYD92iS//dYIY0d8BA8dIsd60wTPyR60MCZOnEhdu3alFy9e0K5du6hMmTJCcPDgwSJfv349zZw5MzjLQXz3XcCOXZL88mDn8SB2guz2dZMmoeTCqNHDhw+pZ8+eQggqOWPGDDnH0aNHD7HJ8ePHs8nWpevXr5u7LLBtiz2b34G2aLTFiNgIsiPQlrcjRCuWt4OnPHXqFD19+pTu3bvHEVk7IdSQVa4Rz7hLsHnz5jRhwgSqwktCRV7gT5w4YZ5QCLBnm2S9ekRs97HAP8FffiHHJodoJYwrX8G5XkZGhjiY9PR0IRTtAMHc3FxRY7yUIoBqvvSSR7JBA6LvvzfC4uGLoP7tN9LWYkxVqxJFiDiys7NlKQBJm2CFChWoCat2Cie8NsHqrAVHOE5dunQpa3oEjwknYy1FDmuEPnjQCKOjWIKaIw3dsqVHjgfPLIy0KPayCmHgIFKe0yGXSC32hlu2bKEhQ4YE23BgBrt16yYOaMmSJeYpYQDyNWp4JPllaXZ2xSEqQc2qo62AGFE/ITsPA8SYsL1jx47JbGHwIFiNVRnnsME7d+7Qdg7pbIL2sa64tOnLLwNOjfviEJJWrBsOkQly7qbfeMMjx2+aR2CERQHbGz16NG3dupUasJ1gwF26dKGhQ4fK+YgRI6Tfec4H4TnR1oxtuhK/NJxDVQ/xjOzjKOjWrVvSNyxg91a24nCeqdk/REJ4gpyvFSG3Zo0RhsfatWtloPXY08EGcT5p0iTJIMpxUgviLhCP4iXsYbfvRjfwuLNmzZJgwA0OIuKzz0JJckai7XzTQlGCJ0+S8+abHjkUi3zUTjZv3iwDtY+FCxeKLC0tTewLhOBI+vTpQ3PmzBHZsGHDpK8bBOBYtmyZyKIiJ4d4nQmOE34C/qIwQgjq06dJd+gQSm7VKiONDswQBte2bVuaPHkym0pNmjZtGi9lOznnbSwy+4D67udwb/bs2XJdtmzZoLrifl9AgmyTZH+hkWNa8AiePUsOh1VuZ/5FGBazLhRGRQBUEYNryhkBYkx4TKihuyy0YFsZMGAA9evXT2wPbfCgII9raMDw4cOlfdSoUeapPoBSh1XY0vyCNTs6F0JQ//svOfxG3U6sL8R6gtBEOvnB8ePHxVFggCC7aNEiOa/N69fq1avpwoULEr49ePCAzp07J+ue62H79u0rz5g+fbpcjxs3Tq5946OPQkmy/9AocDGUxsy99ZZHDos4/3gs5IAbN24EZwYOA0sEHA48YyTs4CgFJKGeCLzHjBkj90NtYwZIWhUFp317WQmU8847HjkceJv//Wfu8g+EZt27d+dHeHYGz1oc5s2bJ31dVcU51Dsu8JLEDwgeeuRInkFezIWtK8BCGmedcvHixfyIADkM9tq1a0YSGZcuXZKZdu+Dk8rLyzPSGMA2zA/yyKHIzOsjX7ENsv04dsUZ656Pt18YSGrhZDDQ/v370+PHj40kMtAHy4hLcGU83yxQIbDDOKyLqPMwhKCAPQ88kNtJSGZlGaF/LF++XAY6cOBACd2KA/ogFsU9sF0/sx4ChG9I28y4HU7FNOo7Bh5B4I8/QmPPYgLrcDjKiy0WbeR8+fn5pjUyULJwQ7uNGzeaVp9AAG45Fs3aUzg2DSXIkOwB+muTjOGHYT8tOapITU3lLKf4WgoCbJDDC4nJ9vBsmxwq6GE8dhGCAtZf6HGQJOI+xH8+MX/+fBl069atJbiOBGQeyPbRd+7cuabVB7ZtC1TwzPhQH9IRkuDwBAEmqfFFyDxESG7aZITRgRJh586dZeAdO3aUDOHu3bsiQ4Hp9u3bMrut2BzQpz17cd+2hzKGleE79euTLlRkthGZIAP6jJzLfZh4Khi1DyCy6cBxLQig9oJoBYWnqVOnStHJzRmxLCCj9wWOkOxqm4NC1K5dRhgeUQkKWK9Fv81DZZ30WXFGeIbSYQ1+MSBjH1U5YkJIhj6+gGKTVYByOK0qjhzga5cFHTyIEF+l3rgRaKhVS6nsbKVGjgxcWzh79qzKyclRHGQrJqF4GVA8Q+r06dOmRwC8JChOm6QPR0GqoKBAcW6oOB5VnD+aXgYHDijFv6/y8uRS166tUvj3U4YPl+uoEJp+wHruWJFCuEo2ANvCY+M5oNJFggMUlwpXuuFkfCK2fTL79in97rsqNT8/cF2njlIbNij19tuBa0Zubq7KyMiQc14q8AJlNnHYQLsrA549e6Y6deqkODFWbJ/Spg4fDszctWtyqWvWVCorS6WOHSvXvgCCsUCzoWvWf/eNSvxnVZyfP38uKVGsx/3790NnDwu29bXJYTuO52tTzASBIt8DQTKKq44ZiCN54Xefr9kh4bt/PIiLIKDDfa72WYyNCiwZ9hdfkCvBZ+24CQL4dleEJL7xxQvUUyxyDoeJTgk3JpSIIKB54XesEp7YjdlVERNQR7G2lmADkcNZfklRYoKAg30xNklOdsWO/OLvv4lef90jx6laovbNJIQgoDkYD9nZBFX7/XcjjYKTJ4mD0eB9TvnypIspMseChBEUsDMI2ZsGkrm5RhgG2IxQaFuXk+C9a4klyNCcIEPFgiSRQGNXU2GcO0fUqZNHDrsPk7DFMuEEAZ2VRQ5nC0GSqPdgf5oL5Ig2uTJlSL//vhEmFkkhCOi1a0mj9O+SxMccELtyhSg93SOXkkIO6rBJQtIICmBPbFdBkvjukZYWQk4nkRyQXIIMvWqV2FeQpEuOD2fBAu7g79tHvEg6QUFmpsyWTdCZP5/oxQvTIXkoHYIMvXy5bEYXcu+9l/SZc1G6/zfBuZ7830RmJpJF05pMKPU/n1sfAcbe8EMAAAAASUVORK5CYII=">');

-- This crashes MariaDB process
ALTER TABLE test ADD exception TINYINT(1) NOT NULL DEFAULT 0 AFTER htmlcode;