| Server IP : 195.130.67.5 / Your IP : 216.73.217.154 Web Server : Microsoft-IIS/10.0 System : Windows NT WEBSERVER1 10.0 build 17763 (Windows Server 2016) i586 User : IUSR ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /inetpub/wwwroot/Topogeo/ojs/dbscripts/xml/upgrade/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd"> <!-- * 2.3.3_preaffiliations1.xml * * Copyright (c) 2003-2010 John Willinsky * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING. * * 2.3.3 affiliations update XML file, run prior to schema sync. * * $Id$ --> <data> <!-- Bug #5550: make affiliations localized --> <sql> <query> <!-- Make the process idempotent --> DELETE FROM user_settings WHERE setting_name = 'affiliation' </query> <query> INSERT INTO user_settings (user_id, setting_name, setting_type, setting_value, locale) SELECT u.user_id, 'affiliation', 'string', u.affiliation, s.primary_locale FROM users u, site s </query> </sql> </data>