<?php defined("_VALID_ACCESS") || die('Direct access forbidden'); // this patch has been splitted from the other one. // 8fd8dd050f628900ac035305d0cab140 is: // modules/Utils/RecordBrowser/patches/20140826_add_id_key_to_tables2.php $db = new PatchesDB(); if ($db->was_applied('8fd8dd050f628900ac035305d0cab140')) { return; } $columns = DB::MetaColumnNames('recordbrowser_table_properties'); if (!isset($columns['ID'])) { $tab_ids_checkpoint = Patch::checkpoint('tab_ids'); if (!$tab_ids_checkpoint->is_done()) { Patch::require_time(20); if (DB::is_postgresql()) { DB::Execute('ALTER TABLE recordbrowser_table_properties DROP CONSTRAINT recordbrowser_table_properties_pkey'); DB::Execute('ALTER TABLE recordbrowser_table_properties ADD COLUMN id SERIAL PRIMARY KEY'); } else { DB::Execute('ALTER TABLE recordbrowser_table_properties DROP PRIMARY KEY'); DB::Execute('ALTER TABLE recordbrowser_table_properties ADD id SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY'); } DB::CreateIndex('recordbrowser_table_properties_tab', 'recordbrowser_table_properties', 'tab', array('UNIQUE' => 1)); $tab_ids_checkpoint->done(); } } $field_ids_checkpoint = Patch::checkpoint('field_ids'); if (!$field_ids_checkpoint->is_done()) { Patch::require_time(20); $recordsets = Utils_RecordBrowserCommon::list_installed_recordsets(); foreach ($recordsets as $tab => $caption) {
<?php defined("_VALID_ACCESS") || die('Direct access forbidden'); $pdb = new PatchesDB(); if ($pdb->was_applied(md5('modules/Utils/RecordBrowser/patches/20140827_search_include.php'))) { return; } PatchUtil::db_add_column('recordbrowser_table_properties', 'search_include', 'I1 DEFAULT 0'); PatchUtil::db_add_column('recordbrowser_table_properties', 'search_priority', 'I1 DEFAULT 0'); Utils_RecordBrowserCommon::set_search('company', 1, 2); Utils_RecordBrowserCommon::set_search('contact', 1, 2); Utils_RecordBrowserCommon::set_search('crm_meeting', 2, 0); Utils_RecordBrowserCommon::set_search('phonecall', 2, 0); Utils_RecordBrowserCommon::set_search('task', 2, 0); Utils_RecordBrowserCommon::set_search('crm_assets', 2, 0); Utils_RecordBrowserCommon::set_search('rc_mail_threads', 2, -1); Utils_RecordBrowserCommon::set_search('rc_mails', 2, -1); Utils_RecordBrowserCommon::set_search('rc_multiple_emails', 2, 0); Utils_RecordBrowserCommon::set_search('custom_projects', 1, 1); Utils_RecordBrowserCommon::set_search('custom_personalequipment', 2, -2); Utils_RecordBrowserCommon::set_search('custom_jobsearch', 2, 0); Utils_RecordBrowserCommon::set_search('custom_jobsearch_history', 2, -1); Utils_RecordBrowserCommon::set_search('custom_ccn_sales', 2, 0); Utils_RecordBrowserCommon::set_search('custom_monthlycost', 2, 0); Utils_RecordBrowserCommon::set_search('custom_merlin_licence', 2, 0); Utils_RecordBrowserCommon::set_search('custom_merlin_sent', 2, -2); Utils_RecordBrowserCommon::set_search('utils_attachment', 1, 0); Utils_RecordBrowserCommon::set_search('premium_listmanager', 2, 0); Utils_RecordBrowserCommon::set_search('premium_listmanager_element', 2, -1); Utils_RecordBrowserCommon::set_search('premium_warehouse', 2, 0); Utils_RecordBrowserCommon::set_search('premium_projects', 2, 0);
<?php defined("_VALID_ACCESS") || die('Direct access forbidden'); // this patch has been renamed to make update process right // 4bb2048388cd0807ac707edeaa67dfa2 is: // modules/Utils/RecordBrowser/patches/20140814_add_processing_order.php $db = new PatchesDB(); if ($db->was_applied('4bb2048388cd0807ac707edeaa67dfa2')) { return; } $recordsets = Utils_RecordBrowserCommon::list_installed_recordsets(); $checkpoint = Patch::checkpoint('recordset'); $processed = $checkpoint->get('processed', array()); foreach ($recordsets as $tab => $caption) { if (isset($processed[$tab])) { continue; } $processed[$tab] = true; Patch::require_time(3); $tab = $tab . "_field"; $columns = DB::MetaColumnNames($tab); if (!isset($columns['PROCESSING_ORDER'])) { PatchUtil::db_add_column($tab, 'processing_order', 'I2'); DB::Execute("UPDATE {$tab} SET processing_order=position"); } $checkpoint->set('processed', $processed); }
<?php defined("_VALID_ACCESS") || die('Direct access forbidden'); $patches_db = new PatchesDB(); $patches = PatchUtil::list_patches(false); foreach ($patches as $patch) { $needle = 'patches/'; $filename = $patch->get_file(); $backslash_pos = strpos($filename, $needle); if ($backslash_pos !== false) { $filename[$backslash_pos + strlen($needle) - 1] = '\\'; $id = md5($filename); if ($patches_db->was_applied($id) && !$patch->was_applied()) { $patch->mark_applied(); } } }