USE [% cpm %];

ALTER TABLE `[% table_prefix %]_users`
ADD COLUMN `user_email_valid` enum('YES','') NOT NULL DEFAULT '';

UPDATE `[% table_prefix %]_languages`
SET `available`='YES'
WHERE `lang_id` IN ('catalan');

UPDATE `[% table_prefix %]_languages`
SET `available`='YES', `enabled`='YES'
WHERE `lang_id` IN ('icelandic', 'portuguese', 'swedish');

UPDATE `[% table_prefix %]_languages`
SET `available`='YES', `enabled`='YES', `complete`='YES'
WHERE `lang_id` IN ('italian');

