ALTER TABLE `an_Certificate`
    MODIFY `signature` varchar(255) NOT NULL;

UPDATE `an_Certificate` SET `signature` = '';

ALTER TABLE `an_User`
    ADD `businessName` varchar(255) DEFAULT NULL AFTER `company`,
    ADD `city` varchar(255) NOT NULL AFTER `address`,
    ADD `state` varchar(2) NOT NULL AFTER `city`,
    ADD `zip` varchar(16) NOT NULL AFTER `state`;

ALTER TABLE `an_ResultAttemptQuestion` CHANGE `answerId` `answerId` INT(10) UNSIGNED NULL DEFAULT NULL;

UPDATE `an_Settings` SET `description` = 'Constants: {name} {email} {company} {address} {city} {state} {zip}' WHERE `name` = 'certificateEmailBody';
UPDATE `an_Settings` SET `description` = 'Constants: {name} {email} {company} {address} {city} {state} {zip} {test} {link}' WHERE `name` = 'userCertificateAdminEmailBody';
UPDATE `an_Settings` SET `description` = 'Constants: {name} {email} {company} {address} {city} {state} {zip} {test} {link}' WHERE `name` = 'userCertificateFailAdminEmailBody';

ALTER TABLE `an_Test`
    ADD `prematurelyFailedMessage` text NOT NULL DEFAULT '' AFTER `failedMessage`;

ALTER TABLE `an_ResultAttemptQuestion`
  ADD `correctAnswerText` varchar(255) DEFAULT NULL AFTER `answerText`;
 
UPDATE an_ResultAttemptQuestion SET `correctAnswerText` =  `answerText`;
