USE [% cpm %];

ALTER TABLE [% table_prefix %]_temp_messages CHANGE COLUMN message_id message_id varchar(80) NOT NULL; # was varchar(80) NOT NULL DEFAULT '';

-- Update the language values
UPDATE [% table_prefix %]_languages SET `flag` = 'lu' WHERE `lang_id`='luxembourgish';
UPDATE [% table_prefix %]_languages SET `available` = 'YES' WHERE `lang_id`='norwegian';
UPDATE [% table_prefix %]_languages SET `available` = 'YES' WHERE `lang_id`='persian';

-- Removed unused configuration value
DELETE FROM [% table_prefix %]_config WHERE `name` = 'theme_list';

-- Add new configuration values
INSERT INTO [% table_prefix %]_config VALUES ('album_sort_order', 'pa');
INSERT INTO [% table_prefix %]_config VALUES ('cookies_need_consent', '0');
INSERT INTO [% table_prefix %]_config VALUES ('custom_sortorder_thumbs', '1');
