BLOB, TEXT, GEOMETRY or JSON column can't have a default value filtres_com : ALTER TABLE `filtres_com` CHANGE `asso` `asso` LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL; monedes: ALTER TABLE `monedes` CHANGE `sectorMoneda` `sectorMoneda` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL; monedes_entitat: ALTER TABLE `monedes_entitat` CHANGE `sectorMoneda` `sectorMoneda` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL; date NOT NULL DEFAULT current_timestamp informacions_per_establiments: ALTER TABLE `informacions_per_establiments` CHANGE `dataCreacio` `dataCreacio` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; informacions_per_entitats_gestores: ALTER TABLE `informacions_per_entitats_gestores` CHANGE `dataCreacio` `dataCreacio` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;