shorten table name

2 files changed, 9 insertions, 9 deletions

diff --git a/appinfo/database.xml b/appinfo/database.xml
index 2c58641..c9b3a33 100644
--- a/appinfo/database.xml
+++ b/appinfo/database.xml
@@ -104,7 +104,7 @@
         </declaration>
     </table>
     <table>
-        <name>*dbprefix*ransomware_detection_recov</name>
+        <name>*dbprefix*rd_recovery</name>
         <declaration>
             <field>
                 <name>id</name>
diff --git a/lib/Db/RecoveredFileOperationMapper.php b/lib/Db/RecoveredFileOperationMapper.php
index 14c24be..7c57226 100644
--- a/lib/Db/RecoveredFileOperationMapper.php
+++ b/lib/Db/RecoveredFileOperationMapper.php
@@ -47,7 +47,7 @@ class RecoveredFileOperationMapper extends Mapper
      */
     public function find($id, $userId)
     {
-        $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` '.
+        $sql = 'SELECT * FROM `*PREFIX*rd_recovery` '.
             'WHERE `id` = ? AND `user_id` = ?';
 
         return $this->findEntity($sql, [$id, $userId]);
@@ -65,7 +65,7 @@ class RecoveredFileOperationMapper extends Mapper
      */
     public function findOneByFileName($name, $userId)
     {
-        $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` '.
+        $sql = 'SELECT * FROM `*PREFIX*rd_recovery` '.
             'WHERE `original_name` = ? AND `user_id` = ?';
 
         return $this->findEntity($sql, [$name, $userId]);
@@ -81,7 +81,7 @@ class RecoveredFileOperationMapper extends Mapper
      */
     public function findOneWithHighestId($userId)
     {
-        $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` WHERE `user_id` = ?'.
+        $sql = 'SELECT * FROM `*PREFIX*rd_recovery` WHERE `user_id` = ?'.
             'ORDER BY id DESC LIMIT 1';
 
         return $this->findEntity($sql, [$userId]);
@@ -97,7 +97,7 @@ class RecoveredFileOperationMapper extends Mapper
      */
     public function findAll(array $params = [], $limit = null, $offset = null)
     {
-        $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` WHERE `user_id` = ?';
+        $sql = 'SELECT * FROM `*PREFIX*rd_recovery` WHERE `user_id` = ?';
 
         return $this->findEntities($sql, $params, $limit, $offset);
     }
@@ -113,7 +113,7 @@ class RecoveredFileOperationMapper extends Mapper
      */
     public function findSequenceById(array $params = [], $limit = null, $offset = null)
     {
-        $sql = 'SELECT * FROM `*PREFIX*ransomware_detection_recov` WHERE `sequence` = ? AND `user_id` = ?';
+        $sql = 'SELECT * FROM `*PREFIX*rd_recovery` WHERE `sequence` = ? AND `user_id` = ?';
 
         return $this->findEntities($sql, $params, $limit, $offset);
     }
@@ -125,7 +125,7 @@ class RecoveredFileOperationMapper extends Mapper
      */
     public function deleteById($id, $userId)
     {
-        $sql = 'DELETE FROM `*PREFIX*ransomware_detection_recov` WHERE `id` = ? AND `user_id` = ?';
+        $sql = 'DELETE FROM `*PREFIX*rd_recovery` WHERE `id` = ? AND `user_id` = ?';
         $stmt = $this->execute($sql, [$id, $userId]);
         $stmt->closeCursor();
     }
@@ -137,7 +137,7 @@ class RecoveredFileOperationMapper extends Mapper
      */
     public function deleteSequenceById($sequence, $userId)
     {
-        $sql = 'DELETE FROM `*PREFIX*ransomware_detection_recov` WHERE `sequence` = ? AND `user_id` = ?';
+        $sql = 'DELETE FROM `*PREFIX*rd_recovery` WHERE `sequence` = ? AND `user_id` = ?';
         $stmt = $this->execute($sql, [$sequence, $userId]);
         $stmt->closeCursor();
     }
@@ -149,7 +149,7 @@ class RecoveredFileOperationMapper extends Mapper
      */
     public function deleteFileOperationsBefore($timestamp)
     {
-        $sql = 'DELETE FROM `*PREFIX*ransomware_detection_recov` WHERE `timestamp` < ?';
+        $sql = 'DELETE FROM `*PREFIX*rd_recovery` WHERE `timestamp` < ?';
         $stmt = $this->execute($sql, [$timestamp]);
         $stmt->closeCursor();
     }