One Hat Cyber Team
Your IP :
216.73.216.182
Server IP :
203.175.9.166
Server :
Linux tanggamus.iixcp.rumahweb.net 5.14.0-427.28.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Aug 2 03:44:10 EDT 2024 x86_64
Server Software :
LiteSpeed
PHP Version :
7.4.33
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
cite5577
/
www
/
backup
/
dbscripts
/
xml
/
upgrade
/
View File Name :
3.2.0_last_activity.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd"> <!-- * dbscripts/xml/upgrade/3.2.0_preupdate_last_activity.xml * * Copyright (c) 2013-2021 Simon Fraser University * Copyright (c) 2003-2021 John Willinsky * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING. * * Migrate the old date_status_modified column in the submissions table to the * new date_last_activity column. * --> <data> <sql> <query> UPDATE submissions s SET date_last_activity = ( SELECT date_status_modified FROM temp_last_activity_submissions tlas WHERE tlas.submission_id = s.submission_id ) </query> <drop table="temp_last_activity_submissions" /> </sql> </data>