ALTER TABLE `make_and_models` CHANGE `name` `name` VARCHAR( 499 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ; ALTER TABLE `technical_specs` CHANGE `details` `details` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ; ALTER TABLE `users` CHANGE `first_name` `first_name` VARCHAR( 499 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ; ALTER TABLE `users` CHANGE `last_name` `last_name` VARCHAR( 499 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ; ALTER TABLE `users` CHANGE `email` `email` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ; ALTER TABLE `users` CHANGE `phone` `phone` VARCHAR( 499 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL ;