| 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.2.1_usersettings.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.2.1 database updates XML file (run before schema is reconciled). * --> <data> <!-- Bug #3607: User settings primary key needs to include journal id --> <sql> <!-- Syntax for MySQL. --> <query driver="mysql"> UPDATE user_settings SET journal_id = 0 WHERE journal_id IS NULL </query> <query driver="mysql"> ALTER TABLE user_settings CHANGE COLUMN journal_id journal_id BIGINT NOT NULL DEFAULT 0 </query> <query driver="mysql"> ALTER TABLE user_settings DROP INDEX user_settings_pkey, ADD INDEX user_settings_pkey (user_id, locale, setting_name, journal_id) </query> <!-- Syntax for PostgreSQL. --> <query driver="postgres7"> UPDATE user_settings SET journal_id = 0 WHERE journal_id IS NULL </query> <query driver="postgres7"> ALTER TABLE user_settings ALTER COLUMN journal_id SET NOT NULL </query> <query driver="postgres7"> ALTER TABLE user_settings ALTER COLUMN journal_id SET DEFAULT 0 </query> <query driver="postgres7"> DROP INDEX user_settings_pkey </query> <query driver="postgres7"> CREATE UNIQUE INDEX user_settings_pkey ON user_settings (user_id, locale, setting_name, journal_id) </query> </sql> </data>