ALTER TABLE `events`
DROP COLUMN `questionOne`,
DROP COLUMN `questionTwo`,
DROP COLUMN `questionThree`,
MODIFY COLUMN `localOrganisers`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `id`,
ADD COLUMN `shortDescription`  varchar(300) NULL AFTER `photos`,
ADD COLUMN `description`  text(0) NULL AFTER `shortDescription`;