| Server IP : 104.20.45.2 / Your IP : 172.16.20.3 Web Server : Apache/2.4.25 (Debian) System : Linux f64a392e70de 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : application ( 1000) PHP Version : 5.6.40 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /app/dbscripts/xml/upgrade/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd"> <!-- * 2.4.0_idupdate_issues.xml * * Copyright (c) 2013-2019 Simon Fraser University * Copyright (c) 2003-2019 John Willinsky * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING. * * 2.4.0 id update pre-migration script, run prior to schema sync. * --> <data> <!-- Prepare migration of public ids and DOIs to settings tables --> <sql> <query>INSERT INTO issue_settings (issue_id, setting_name, setting_value, setting_type, locale) SELECT issue_id, 'pub-id::publisher-id', public_issue_id, 'string', '' FROM issues WHERE public_issue_id IS NOT NULL AND public_issue_id != ''</query> <query driver="postgres7"> DROP INDEX issues_journal_id </query> </sql> </data>