ALTER TABLE `technical_specs` ADD `details_sort` INT NULL AFTER `details`;
ALTER TABLE `locations` ADD `room_name_sort` INT NULL AFTER `room_name`;
ALTER TABLE `locations` CHANGE `room_name` `room_name` VARCHAR(499) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `locations` CHANGE `address` `address` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `locations` CHANGE `floor` `floor` VARCHAR(499) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `locations` CHANGE `city` `city` VARCHAR(499) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `locations` CHANGE `zip` `zip` VARCHAR(499) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `locations` CHANGE `location_email` `location_email` VARCHAR(499) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;
ALTER TABLE `users` ADD `first_name_sort` INT NULL AFTER `last_name`;