diff options
author | Alfred Egger <alfred.egger@gmx.at> | 2020-12-30 01:51:52 +0300 |
---|---|---|
committer | Alfred Egger <alfred.egger@gmx.at> | 2020-12-30 01:51:52 +0300 |
commit | 94a7175886dff13d950063fe23534cfb839fd8d0 (patch) | |
tree | e54095c22c70ba91807459267db903a53f4f5ab4 | |
parent | 224382ce9ba0726f9be5da0323757b5e11c396dc (diff) |
Fix SQL table names
-rw-r--r-- | db/conversationstatemapper.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/db/conversationstatemapper.php b/db/conversationstatemapper.php index 5e48d5f..8365069 100644 --- a/db/conversationstatemapper.php +++ b/db/conversationstatemapper.php @@ -26,7 +26,7 @@ class ConversationStateMapper extends Mapper { public function getLast ($userId) { $qb = $this->db->getQueryBuilder(); $qb->selectAlias($qb->createFunction('MAX(int_date)'), 'mx') - ->from('ocsms_conversation_read_states') + ->from('ocsms_conv_r_states') ->where($qb->expr()->andX( $qb->expr()->eq('user_id', $qb->createNamedParameter($userId)) )); @@ -42,7 +42,7 @@ class ConversationStateMapper extends Mapper { public function getLastForPhoneNumber ($userId, $phoneNumber) { $qb = $this->db->getQueryBuilder(); $qb->selectAlias($qb->createFunction('MAX(int_date)'), 'mx') - ->from('ocsms_conversation_read_states') + ->from('ocsms_conv_r_states') ->where($qb->expr()->andX( $qb->expr()->eq('user_id', $qb->createNamedParameter($userId)), $qb->expr()->eq('phone_number', $qb->createNamedParameter($phoneNumber)) @@ -59,7 +59,7 @@ class ConversationStateMapper extends Mapper { public function setLast ($userId, $phoneNumber, $lastDate) { $this->db->beginTransaction(); $qb = $this->db->getQueryBuilder(); - $qb->delete('ocsms_conversation_read_states') + $qb->delete('ocsms_conv_r_states') ->where($qb->expr()->andX( $qb->expr()->eq('user_id', $qb->createNamedParameter($userId)), $qb->expr()->eq('phone_number', $qb->createNamedParameter($phoneNumber)) @@ -67,7 +67,7 @@ class ConversationStateMapper extends Mapper { $qb->execute(); $qb = $this->db->getQueryBuilder(); - $qb->insert('ocsms_conversation_read_states') + $qb->insert('ocsms_conv_r_states') ->values(array( 'user_id' => $qb->createNamedParameter($userId), 'phone_number' => $qb->createNamedParameter($phoneNumber), |