-- Downgrades from version 0.5

ALTER TABLE `users` DROP INDEX `username`;
ALTER TABLE `users` ADD INDEX `username_index` (`username`);

-- note: truncates
ALTER TABLE `contacts` MODIFY `email` varchar(128) NOT NULL;

DELETE FROM messages;
