| 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/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data SYSTEM "../../lib/pkp/dtd/xmlData.dtd">
<!--
* ...
-->
<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 article_settings_name_value ON article_settings (setting_name(50), setting_value(150))
</query>
<query driver="mysql">
CREATE INDEX article_supp_file_settings_name_value ON article_supp_file_settings (setting_name(50), setting_value(150))
</query>
<query driver="mysql">
CREATE INDEX article_galley_settings_name_value ON article_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 article_settings_name_value ON article_settings (setting_name, setting_value) WHERE setting_name IN ('indexingState', 'medra::registeredDoi', 'datacite::registeredDoi')
</query>
<query driver="postgres7">
CREATE INDEX article_supp_file_settings_name_value ON article_supp_file_settings (setting_name, setting_value)
</query>
<query driver="postgres7">
CREATE INDEX article_galley_settings_name_value ON article_galley_settings (setting_name, setting_value)
</query>
</sql>
</data>