adm_program/installation/db_scripts/update_4_0.xml
<?xml version="1.0" encoding="UTF-8"?>
<update>
<step id="5">UPDATE %PREFIX%_preferences SET prf_value = 'simple' WHERE prf_name = 'theme'</step>
<step id="7">UPDATE %PREFIX%_preferences SET prf_value = 'adm_program/overview.php' WHERE prf_name = 'homepage_logout' AND prf_value = 'adm_program/index.php'</step>
<step id="8">UPDATE %PREFIX%_preferences SET prf_value = 'adm_program/overview.php' WHERE prf_name = 'homepage_login' AND prf_value = 'adm_program/index.php'</step>
<step id="9">UPDATE %PREFIX%_menu SET men_url = '/adm_program/overview.php' WHERE men_name_intern = 'overview' AND men_url = '/adm_program/index.php'</step>
<step id="10">UPDATE %PREFIX%_menu SET men_icon = 'fa-home' WHERE men_icon = 'home.png'</step>
<step id="20">UPDATE %PREFIX%_menu SET men_icon = 'fa-newspaper' WHERE men_icon = 'announcements.png'</step>
<step id="30">UPDATE %PREFIX%_menu SET men_icon = 'fa-download' WHERE men_icon = 'download.png'</step>
<step id="40">UPDATE %PREFIX%_menu SET men_icon = 'fa-envelope' WHERE men_icon = 'email.png'</step>
<step id="50">UPDATE %PREFIX%_menu SET men_icon = 'fa-image' WHERE men_icon = 'photo.png'</step>
<step id="60">UPDATE %PREFIX%_menu SET men_icon = 'fa-book' WHERE men_icon = 'guestbook.png'</step>
<step id="70">UPDATE %PREFIX%_menu SET men_icon = 'fa-list' WHERE men_icon = 'lists.png'</step>
<step id="80">UPDATE %PREFIX%_menu SET men_icon = 'fa-calendar-alt' WHERE men_icon = 'dates.png'</step>
<step id="90">UPDATE %PREFIX%_menu SET men_icon = 'fa-link' WHERE men_icon = 'weblinks.png'</step>
<step id="100">UPDATE %PREFIX%_menu SET men_icon = 'fa-list-alt' WHERE men_icon = 'mylist.png'</step>
<step id="110">UPDATE %PREFIX%_menu SET men_icon = 'fa-address-card' WHERE men_icon = 'new_registrations.png'</step>
<step id="120">UPDATE %PREFIX%_menu SET men_icon = 'fa-users-cog' WHERE men_icon = 'user_administration.png'</step>
<step id="130">UPDATE %PREFIX%_menu SET men_icon = 'fa-database' WHERE men_icon = 'backup.png'</step>
<step id="140">UPDATE %PREFIX%_menu SET men_icon = 'fa-cog' WHERE men_icon = 'options.png'</step>
<step id="150">UPDATE %PREFIX%_menu SET men_icon = 'fa-user-tie' WHERE men_icon = 'roles.png'</step>
<step id="160">UPDATE %PREFIX%_menu SET men_icon = 'fa-stream' WHERE men_icon = 'application_view_tile.png'</step>
<step id="170">UPDATE %PREFIX%_user_fields SET usf_value_list = 'fa-mars|SYS_MALE
fa-venus|SYS_FEMALE' WHERE usf_name_intern = 'GENDER' AND usf_value_list LIKE 'male.png|%'</step>
<step id="180">UPDATE %PREFIX%_user_fields SET usf_icon = 'fab fa-facebook' WHERE usf_name_intern = 'FACEBOOK' AND usf_icon = 'facebook.png'</step>
<step id="190">UPDATE %PREFIX%_user_fields SET usf_icon = 'fab fa-google-plus' WHERE usf_name_intern = 'GOOGLE_PLUS' AND usf_icon = 'google_plus.png'</step>
<step id="200">UPDATE %PREFIX%_user_fields SET usf_icon = 'fab fa-skype' WHERE usf_name_intern = 'SKYPE' AND usf_icon = 'skype.png'</step>
<step id="210">UPDATE %PREFIX%_user_fields SET usf_icon = 'fab fa-twitter' WHERE usf_name_intern = 'TWITTER' AND usf_icon = 'twitter.png'</step>
<step id="220">UPDATE %PREFIX%_user_fields SET usf_icon = 'fab fa-xing' WHERE usf_name_intern = 'XING' AND usf_icon = 'xing.png'</step>
<step id="230">UPDATE %PREFIX%_user_fields SET usf_icon = 'fab fa-yahoo' WHERE usf_name_intern = 'YAHOO_MESSENGER' AND usf_icon = 'yahoo.png'</step>
<step id="240">UPDATE %PREFIX%_user_fields SET usf_icon = null WHERE usf_icon = 'aim.png'</step>
<step id="250" database="mysql">ALTER TABLE %PREFIX%_users MODIFY COLUMN usr_login_name varchar(254)</step>
<step id="260" database="pgsql">ALTER TABLE %PREFIX%_users ALTER COLUMN usr_login_name TYPE varchar(254)</step>
<step id="270">UPDATE %PREFIX%_preferences SET prf_value = 'pt-BR' WHERE prf_name = 'system_language' AND prf_value = 'pt'</step>
<step id="280">UPDATE %PREFIX%_preferences SET prf_value = 'de-DE' WHERE prf_name = 'system_language' AND prf_value = 'de_sie'</step>
<step id="290">UPDATE %PREFIX%_menu SET men_name_intern = 'documents-files', men_name = 'SYS_DOCUMENTS_FILES', men_description = 'SYS_DOCUMENTS_FILES_DESC', men_url = '/adm_program/modules/documents-files/documents_files.php', men_icon = 'fa-file-download' WHERE men_name_intern = 'download'</step>
<step id="300">UPDATE %PREFIX%_components SET com_name_intern = 'DOCUMENTS-FILES', com_name = 'SYS_DOCUMENTS_FILES' WHERE com_name_intern = 'DOWNLOADS'</step>
<step id="310">UPDATE %PREFIX%_components SET com_name = 'SYS_ROOM_MANAGEMENT' WHERE com_name_intern = 'ROOMS'</step>
<step id="320">UPDATE %PREFIX%_preferences SET prf_value = '200' WHERE prf_name = 'photo_thumbs_scale'</step>
<step id="330">ALTER TABLE %PREFIX%_photos ADD COLUMN pho_description varchar(4000)</step>
<step id="340">ComponentUpdateSteps::updateStep40AddEmailTemplate</step>
<step id="350" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'mail_send_method' AND pr2.prf_value = 'phpmail' AND pr1.prf_org_id = pr2.prf_org_id SET pr1.prf_value = '' WHERE pr1.prf_name = 'mail_smtp_authentication_type'</step>
<step id="360" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = '' FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'mail_send_method' AND pr2.prf_value = 'phpmail' AND pr1.prf_name = 'mail_smtp_authentication_type' AND pr1.prf_org_id = pr2.prf_org_id</step>
<step id="370">UPDATE %PREFIX%_components SET com_name = 'SYS_PHOTOS' WHERE com_name = 'PHO_PHOTOS'</step>
<step id="380">UPDATE %PREFIX%_menu SET men_name = 'SYS_PHOTOS' WHERE men_name = 'PHO_PHOTOS'</step>
<step id="390">UPDATE %PREFIX%_menu SET men_name_intern = 'groups-roles', men_name = 'SYS_GROUPS_ROLES', men_description = 'SYS_GROUPS_ROLES_DESC', men_url = '/adm_program/modules/groups-roles/groups_roles.php', men_icon = 'fa-users' WHERE men_name_intern = 'lists'</step>
<step id="400">UPDATE %PREFIX%_components SET com_name_intern = 'GROUPS-ROLES', com_name = 'SYS_GROUPS_ROLES' WHERE com_name_intern = 'LISTS'</step>
<step id="410">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'lists_hide_overview_details'</step>
<step id="420">DELETE FROM %PREFIX%_menu WHERE men_name_intern = 'mylist'</step>
<step id="430">DELETE FROM %PREFIX%_menu WHERE men_name_intern = 'roladm'</step>
<step id="440">DELETE FROM %PREFIX%_components WHERE com_name_intern = 'ROLES'</step>
<step id="450">UPDATE %PREFIX%_preferences SET prf_value = '#eeeeee' WHERE prf_name = 'system_js_editor_color'</step>
<step id="460">UPDATE %PREFIX%_menu SET men_name = 'SYS_PLUGINS' WHERE men_name_intern = 'plugins'</step>
<step id="470" database="mysql">ALTER TABLE %PREFIX%_roles CHANGE rol_download rol_documents_files boolean NOT NULL DEFAULT '0'</step>
<step id="480" database="pgsql">ALTER TABLE %PREFIX%_roles RENAME COLUMN rol_download TO rol_documents_files</step>
<step id="490" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'enable_download_module' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'documents_files_enable_module'</step>
<step id="500" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'enable_download_module' AND pr1.prf_name = 'documents_files_enable_module'</step>
<step id="510">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'enable_download_module'</step>
<step id="520">UPDATE %PREFIX%_menu SET men_name = 'SYS_ANNOUNCEMENTS', men_description = 'SYS_ANNOUNCEMENTS_DESC' WHERE men_name_intern = 'announcements'</step>
<step id="530">UPDATE %PREFIX%_components SET com_name = 'SYS_ANNOUNCEMENTS' WHERE com_name_intern = 'ANNOUNCEMENTS'</step>
<step id="540">UPDATE %PREFIX%_menu SET men_name = 'SYS_DATABASE_BACKUP', men_description = 'SYS_DATABASE_BACKUP_DESC' WHERE men_name_intern = 'dbback'</step>
<step id="550">UPDATE %PREFIX%_components SET com_name = 'SYS_DATABASE_BACKUP' WHERE com_name_intern = 'BACKUP'</step>
<step id="560" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'lists_enable_module' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'groups_roles_enable_module'</step>
<step id="570" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'lists_enable_module' AND pr1.prf_name = 'groups_roles_enable_module'</step>
<step id="580">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'lists_enable_module'</step>
<step id="590" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'lists_roles_per_page' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'groups_roles_roles_per_page'</step>
<step id="600" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'lists_roles_per_page' AND pr1.prf_name = 'groups_roles_roles_per_page'</step>
<step id="610">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'lists_roles_per_page'</step>
<step id="620" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'lists_members_per_page' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'groups_roles_members_per_page'</step>
<step id="630" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'lists_members_per_page' AND pr1.prf_name = 'groups_roles_members_per_page'</step>
<step id="640">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'lists_members_per_page'</step>
<step id="650" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'lists_default_configuration' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'groups_roles_default_configuration'</step>
<step id="660" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'lists_default_configuration' AND pr1.prf_name = 'groups_roles_default_configuration'</step>
<step id="670">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'lists_default_configuration'</step>
<step id="680" database="mysql">UPDATE %PREFIX%_preferences pr1 INNER JOIN %PREFIX%_preferences pr2 ON pr2.prf_name = 'lists_show_former_members' SET pr1.prf_value = pr2.prf_value WHERE pr1.prf_name = 'groups_roles_show_former_members'</step>
<step id="690" database="pgsql">UPDATE %PREFIX%_preferences pr1 SET prf_value = pr2.prf_value FROM %PREFIX%_preferences pr2 WHERE pr2.prf_name = 'lists_show_former_members' AND pr1.prf_name = 'groups_roles_show_former_members'</step>
<step id="700">DELETE FROM %PREFIX%_preferences WHERE prf_name = 'lists_show_former_members'</step>
<step id="710" database="mysql">ALTER TABLE %PREFIX%_dates MODIFY COLUMN dat_allow_comments boolean NOT NULL default 0</step>
<step id="720" database="pgsql">ALTER TABLE %PREFIX%_dates ALTER COLUMN dat_allow_comments TYPE boolean</step>
<step id="730" database="mysql">ALTER TABLE %PREFIX%_dates MODIFY COLUMN dat_additional_guests boolean NOT NULL default 0</step>
<step id="740" database="pgsql">ALTER TABLE %PREFIX%_dates ALTER COLUMN dat_additional_guests TYPE boolean</step>
<step id="750">ComponentUpdateSteps::updateStep40RenameParticipationRoles</step>
<step id="760">UPDATE %PREFIX%_preferences SET prf_value = '24' WHERE prf_name = 'groups_roles_roles_per_page' AND prf_value = '10'</step>
<step id="770">UPDATE %PREFIX%_preferences SET prf_value = '24' WHERE prf_name = 'photo_albums_per_page' AND prf_value = '10'</step>
<step id="780">UPDATE %PREFIX%_folders SET fol_type = 'DOCUMENTS' WHERE fol_type = 'DOWNLOAD'</step>
<step id="790">ComponentUpdateSteps::updateStep40RenameDownloadRootFolder</step>
<step id="800">DELETE FROM %PREFIX%_folders WHERE fol_type = 'DOWNLOAD'</step>
<step>stop</step>
</update>