-- Downgrades from 0.6

ALTER TABLE `contacts` DROP `words`;
ALTER TABLE `contacts` CHANGE `vcard` `vcard` text NULL;

ALTER TABLE `contactgroupmembers` DROP FOREIGN KEY `contact_id_fk_contacts`;
-- pek: similar to 0.4_0.3.1/mysql, DROP FORIEGN KEY needed before DROP INDEX
--   to avoid "Error on rename"
ALTER TABLE `contactgroupmembers` DROP INDEX `contactgroupmembers_contact_index`;

TRUNCATE TABLE `messages`;
TRUNCATE TABLE `cache`;
