Server : Apache/2.4.41 (Ubuntu) System : Linux journalup 5.4.0-198-generic #218-Ubuntu SMP Fri Sep 27 20:18:53 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory :  /var/www/html/dbscripts/xml/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data SYSTEM "../../lib/pkp/dtd/xmlData.dtd">
<!--
  * dbscripts/xml/indexes.xml
  *
  * Copyright (c) 2014-2020 Simon Fraser University
  * Copyright (c) 2003-2020 John Willinsky
  * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
  *
  * Indexes descriptor file (for indexes that need more than ADODB's XMLSchema
  * descriptor can handle, e.g. database driver-specific DDL)
  *
  -->

<data>
	<sql>
		<query driver="mysql">CREATE INDEX issue_settings_name_value ON issue_settings (setting_name(50), setting_value(150))</query>
		<query driver="mysql">CREATE INDEX publication_settings_name_value ON publication_settings (setting_name(50), setting_value(150))</query>
		<query driver="mysql">CREATE INDEX publication_galley_settings_name_value ON publication_galley_settings (setting_name(50), setting_value(150))</query>

		<query driver="mysqli">CREATE INDEX issue_settings_name_value ON issue_settings (setting_name(50), setting_value(150))</query>
		<query driver="mysqli">CREATE INDEX publication_settings_name_value ON publication_settings (setting_name(50), setting_value(150))</query>
		<query driver="mysqli">CREATE INDEX publication_galley_settings_name_value ON publication_galley_settings (setting_name(50), setting_value(150))</query>

		<query driver="postgres7">CREATE INDEX issue_settings_name_value ON issue_settings (setting_name, setting_value) WHERE setting_name IN ('medra::registeredDoi', 'datacite::registeredDoi')</query>
		<query driver="postgres7">CREATE INDEX publication_settings_name_value ON publication_settings (setting_name, setting_value) WHERE setting_name IN ('indexingState', 'medra::registeredDoi', 'datacite::registeredDoi', 'pub-id::publisher-id')</query>
		<query driver="postgres7">CREATE INDEX publication_galley_settings_name_value ON publication_galley_settings (setting_name, setting_value)</query>
	</sql>
</data>