adm_program/installation/db_scripts/update_4_3.xml
<?xml version="1.0" encoding="UTF-8"?>
<update>
<step id="10">UPDATE %PREFIX%_preferences SET prf_value = '500' WHERE prf_name = 'ecard_thumbs_scale'</step>
<step id="20">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'ecard_card_picture_width'</step>
<step id="30">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'ecard_card_picture_height'</step>
<step id="40">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'photo_save_scale'</step>
<step id="50" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'enable_ecard_module' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'photo_ecard_enabled'</step>
<step id="60" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'enable_ecard_module' AND pr1.prf_name = 'photo_ecard_enabled'</step>
<step id="70">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'enable_ecard_module'</step>
<step id="80" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'ecard_thumbs_scale' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'photo_ecard_scale'</step>
<step id="90" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'ecard_thumbs_scale' AND pr1.prf_name = 'photo_ecard_scale'</step>
<step id="100">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'ecard_thumbs_scale'</step>
<step id="110" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'ecard_template' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'photo_ecard_template'</step>
<step id="120" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'ecard_template' AND pr1.prf_name = 'photo_ecard_template'</step>
<step id="130">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'ecard_template'</step>
<step id="140" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'enable_photo_module' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'photo_module_enabled'</step>
<step id="150" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'enable_photo_module' AND pr1.prf_name = 'photo_module_enabled'</step>
<step id="160">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'enable_photo_module'</step>
<step id="170">ALTER TABLE %PREFIX%_registrations ADD COLUMN reg_validation_id varchar(50)</step>
<step id="180">UPDATE %PREFIX%_registrations SET reg_validation_id = %UUID%</step>
<step id="190" database="mysql">ALTER TABLE %PREFIX%_texts MODIFY COLUMN txt_name varchar(100) NOT NULL</step>
<step id="200" database="pgsql">ALTER TABLE %PREFIX%_texts ALTER COLUMN txt_name TYPE varchar(100)</step>
<step id="210">UPDATE %PREFIX%_texts SET txt_name = 'SYSMAIL_REGISTRATION_REFUSED' WHERE txt_name = 'SYSMAIL_REFUSE_REGISTRATION'</step>
<step id="220">UPDATE %PREFIX%_texts SET txt_name = 'SYSMAIL_REGISTRATION_APPROVED' WHERE txt_name = 'SYSMAIL_REGISTRATION_USER'</step>
<step id="230">UPDATE %PREFIX%_texts SET txt_name = 'SYSMAIL_REGISTRATION_NEW' WHERE txt_name = 'SYSMAIL_REGISTRATION_WEBMASTER'</step>
<step id="240">ComponentUpdateSteps::updateStep43AddNewNotificationText</step>
<step id="250" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'enable_registration_admin_mail' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'registration_send_notification_email'</step>
<step id="260" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'enable_registration_admin_mail' AND pr1.prf_name = 'registration_send_notification_email'</step>
<step id="270">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'enable_registration_admin_mail'</step>
<step id="280" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'enable_registration_captcha' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'registration_enable_captcha'</step>
<step id="290" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'enable_registration_captcha' AND pr1.prf_name = 'registration_enable_captcha'</step>
<step id="300">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'enable_registration_captcha'</step>
<step id="320">UPDATE %PREFIX%_user_fields SET usf_description = 'SYS_SOCIAL_NETWORK_FIELD_URL_DESC' WHERE usf_description IN ('INS_FACEBOOK_DESC', 'INS_TWITTER_DESC', 'INS_XING_DESC')</step>
<step id="325">UPDATE %PREFIX%_user_fields SET usf_description = 'SYS_SOCIAL_NETWORK_FIELD_DESC' WHERE usf_description IN ('INS_SKYPE_DESC', 'INS_ICQ_DESC')</step>
<step id="330">UPDATE %PREFIX%_user_fields SET usf_name = 'SYS_FACEBOOK' WHERE usf_name LIKE 'INS_FACEBOOK'</step>
<step id="340">UPDATE %PREFIX%_user_fields SET usf_name = 'SYS_SKYPE' WHERE usf_name LIKE 'INS_SKYPE'</step>
<step id="350">UPDATE %PREFIX%_user_fields SET usf_name = 'SYS_TWITTER' WHERE usf_name LIKE 'INS_TWITTER'</step>
<step id="360">UPDATE %PREFIX%_user_fields SET usf_name = 'SYS_XING' WHERE usf_name LIKE 'INS_XING'</step>
<step id="370">UPDATE %PREFIX%_user_fields SET usf_name = 'SYS_ICQ' WHERE usf_name LIKE 'INS_ICQ'</step>
<step id="380">UPDATE %PREFIX%_components SET com_name = 'SYS_CONTACTS', com_name_intern = 'CONTACTS' WHERE com_name_intern = 'MEMBERS'</step>
<step id="390">UPDATE %PREFIX%_menu SET men_name = 'SYS_CONTACTS', men_name_intern = 'contacts', men_icon='fa-address-card', men_url='/adm_program/modules/contacts/contacts.php', men_description='SYS_CONTACTS_DESC', men_men_id_parent = 1 WHERE men_name_intern = 'usrmgt'</step>
<step id="400">UPDATE %PREFIX%_menu SET men_icon='fa-file-signature' WHERE men_name_intern = 'newreg'</step>
<step id="410">UPDATE %PREFIX%_components SET com_name = 'SYS_EVENTS', com_name_intern = 'EVENTS' WHERE com_name_intern = 'DATES'</step>
<step id="420">UPDATE %PREFIX%_menu SET men_name = 'SYS_EVENTS', men_name_intern = 'events', men_url='/adm_program/modules/events/events.php' WHERE men_name_intern = 'dates'</step>
<step id="430">UPDATE %PREFIX%_categories SET cat_type = 'EVT' WHERE cat_type = 'DAT'</step>
<step id="440" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'enable_dates_module' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_module_enabled'</step>
<step id="450" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'enable_dates_module' AND pr1.prf_name = 'events_module_enabled'</step>
<step id="460">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'enable_dates_module'</step>
<step id="470" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_per_page' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_per_page'</step>
<step id="480" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_per_page' AND pr1.prf_name = 'events_per_page'</step>
<step id="490">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_per_page'</step>
<step id="500" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_view' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_view'</step>
<step id="510" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_view' AND pr1.prf_name = 'events_view'</step>
<step id="520">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_view'</step>
<step id="530" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_show_map_link' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_show_map_link'</step>
<step id="540" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_show_map_link' AND pr1.prf_name = 'events_show_map_link'</step>
<step id="550">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_show_map_link'</step>
<step id="560" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_show_rooms' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_rooms_enabled'</step>
<step id="570" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_show_rooms' AND pr1.prf_name = 'events_rooms_enabled'</step>
<step id="580">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_show_rooms'</step>
<step id="590" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'enable_dates_ical' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_ical_export_enabled'</step>
<step id="600" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'enable_dates_ical' AND pr1.prf_name = 'events_ical_export_enabled'</step>
<step id="610">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'enable_dates_ical'</step>
<step id="620" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_ical_days_past' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_ical_days_past'</step>
<step id="630" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_ical_days_past' AND pr1.prf_name = 'events_ical_days_past'</step>
<step id="640">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_ical_days_past'</step>
<step id="650" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_ical_days_future' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_ical_days_future'</step>
<step id="660" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_ical_days_future' AND pr1.prf_name = 'events_ical_days_future'</step>
<step id="670">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_ical_days_future'</step>
<step id="680" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_default_list_configuration' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_list_configuration'</step>
<step id="690" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_default_list_configuration' AND pr1.prf_name = 'events_list_configuration'</step>
<step id="700">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_default_list_configuration'</step>
<step id="710" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_save_all_confirmations' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_save_cancellations'</step>
<step id="720" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_save_all_confirmations' AND pr1.prf_name = 'events_save_cancellations'</step>
<step id="730">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_save_all_confirmations'</step>
<step id="740" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'dates_may_take_part' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'events_may_take_part'</step>
<step id="750" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'dates_may_take_part' AND pr1.prf_name = 'events_may_take_part'</step>
<step id="760">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'dates_may_take_part'</step>
<step id="770" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'members_enable_user_relations' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'contacts_user_relations_enabled'</step>
<step id="780" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'members_enable_user_relations' AND pr1.prf_name = 'contacts_user_relations_enabled'</step>
<step id="790">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'members_enable_user_relations'</step>
<step id="800" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'members_days_field_history' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'contacts_field_history_days'</step>
<step id="810" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'members_days_field_history' AND pr1.prf_name = 'contacts_field_history_days'</step>
<step id="820">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'members_days_field_history'</step>
<step id="830" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'members_list_configuration' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'contacts_list_configuration'</step>
<step id="840" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'members_list_configuration' AND pr1.prf_name = 'contacts_list_configuration'</step>
<step id="850">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'members_list_configuration'</step>
<step id="860" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'members_show_all_users' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'contacts_show_all'</step>
<step id="870" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'members_show_all_users' AND pr1.prf_name = 'contacts_show_all'</step>
<step id="880">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'members_show_all_users'</step>
<step id="890" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'members_users_per_page' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'contacts_per_page'</step>
<step id="900" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'members_users_per_page' AND pr1.prf_name = 'contacts_per_page'</step>
<step id="910">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'members_users_per_page'</step>
<step id="920" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'enable_announcements_module' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'announcements_module_enabled'</step>
<step id="930" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'enable_announcements_module' AND pr1.prf_name = 'announcements_module_enabled'</step>
<step id="940">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'enable_announcements_module'</step>
<step id="950" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'documents_files_enable_module' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'documents_files_module_enabled'</step>
<step id="960" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'documents_files_enable_module' AND pr1.prf_name = 'documents_files_module_enabled'</step>
<step id="970">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'documents_files_enable_module'</step>
<step id="980" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'max_file_upload_size' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'documents_files_max_upload_size'</step>
<step id="990" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'max_file_upload_size' AND pr1.prf_name = 'documents_files_max_upload_size'</step>
<step id="1000">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'max_file_upload_size'</step>
<step id="1010">UPDATE %PREFIX%_components SET com_name = 'SYS_PROFILE' WHERE com_name_intern = 'PROFILE'</step>
<step id="1020">UPDATE %PREFIX%_menu SET men_description = 'SYS_PHOTOS_DESC' WHERE men_name_intern = 'photo'</step>
<step id="1030" database="mysql">RENAME TABLE %PREFIX%_dates TO %PREFIX%_events</step>
<step id="1040" database="pgsql">ALTER TABLE %PREFIX%_dates RENAME TO %PREFIX%_events</step>
<step id="1050">ALTER TABLE %PREFIX%_roles ADD COLUMN rol_events boolean not null default false</step>
<step id="1060">UPDATE %PREFIX%_roles SET rol_events = rol_dates</step>
<step id="1070">ALTER TABLE %PREFIX%_roles DROP COLUMN rol_dates</step>
<step id="1080">ComponentUpdateSteps::updateStep43AddSocialNetworkProfileFields</step>
<step id="1090">DELETE FROM %PREFIX%_roles_rights_data WHERE rrd_id IN (SELECT temp.id FROM (SELECT rrd.rrd_id as id FROM %PREFIX%_roles_rights ror INNER JOIN %PREFIX%_roles_rights_data rrd ON rrd.rrd_ror_id = ror.ror_id INNER JOIN %PREFIX%_menu men ON men.men_id = rrd.rrd_object_id AND men.men_standard = true WHERE ror.ror_name_intern = 'menu_view') AS temp)</step>
<step id="1100">UPDATE %PREFIX%_menu SET men_name = 'SYS_MESSAGES', men_name_intern = 'messages', men_icon='fa-comments', men_url='/adm_program/modules/messages/messages.php', men_description='SYS_MESSAGES_DESC' WHERE men_name_intern = 'mail'</step>
<step id="1110">UPDATE %PREFIX%_menu SET men_name = 'SYS_REGISTRATIONS', men_name_intern = 'registration' WHERE men_name_intern = 'newreg'</step>
<step id="1120">UPDATE %PREFIX%_categories SET cat_name_intern = 'EVT_ALL_ORGANIZATIONS' WHERE cat_name_intern = 'DAT_ALL_ORGANIZATIONS'</step>
<step id="1130">UPDATE %PREFIX%_menu SET men_description = 'SYS_EVENTS_DESC' WHERE men_name_intern = 'events'</step>
<step id="1140">ComponentUpdateSteps::updateStep43RemoveInvalidVisibleRoleRights</step>
<step id="1150">UPDATE %PREFIX%_menu SET men_standard = false WHERE men_name_intern IN ('statistics', 'statistics_editor');</step>
<step id="1160" database="mysql">UPDATE %PREFIX%_preferences SET prf_value = '500' WHERE prf_name = 'photo_thumbs_scale' AND CAST(prf_value AS unsigned) < 500</step>
<step id="1170" database="pgsql">UPDATE %PREFIX%_preferences SET prf_value = '500' WHERE prf_name = 'photo_thumbs_scale' AND prf_value::int < 500</step>
<step id="1180" database="mysql">UPDATE %PREFIX%_preferences SET prf_value = '1200' WHERE prf_name = 'photo_show_width' AND CAST(prf_value AS unsigned) < 1200</step>
<step id="1190" database="pgsql">UPDATE %PREFIX%_preferences SET prf_value = '1200' WHERE prf_name = 'photo_show_width' AND prf_value::int < 1200</step>
<step id="1200" database="mysql">UPDATE %PREFIX%_preferences SET prf_value = '1200' WHERE prf_name = 'photo_show_height' AND CAST(prf_value AS unsigned) < 800</step>
<step id="1210" database="pgsql">UPDATE %PREFIX%_preferences SET prf_value = '1200' WHERE prf_name = 'photo_show_height' AND prf_value::int < 800</step>
<step id="1220" database="mysql">UPDATE %PREFIX%_preferences SET prf_value = '24' WHERE prf_name = 'photo_thumbs_page' AND CAST(prf_value AS unsigned) = 16</step>
<step id="1230" database="pgsql">UPDATE %PREFIX%_preferences SET prf_value = '24' WHERE prf_name = 'photo_thumbs_page' AND prf_value::int = 16</step>
<step>stop</step>
</update>