From e0536861dd75ecfc2e7a19bbb9dcc3f6db4930e6 Mon Sep 17 00:00:00 2001 From: kambizzandi Date: Sun, 8 May 2022 13:21:47 +0430 Subject: [PATCH] lockecby added to tblalerts --- Interfaces/ORM/intfAlerts.cpp | 1 + Interfaces/ORM/intfAlerts.h | 1 + .../db/m20220508_130709_Common_add_lockedby_to_tblalerts.sql | 5 +++++ 3 files changed, 7 insertions(+) create mode 100644 Modules/Common/migrations/db/m20220508_130709_Common_add_lockedby_to_tblalerts.sql diff --git a/Interfaces/ORM/intfAlerts.cpp b/Interfaces/ORM/intfAlerts.cpp index 8798226a..3b4a87ee 100644 --- a/Interfaces/ORM/intfAlerts.cpp +++ b/Interfaces/ORM/intfAlerts.cpp @@ -44,6 +44,7 @@ intfAlerts::intfAlerts() : { tblAlerts::alrReplacements, S(TAPI::DBText_t), QFV, QRequired, UPAdmin }, { tblAlerts::alrCreateDate, ORM_CREATED_ON }, { tblAlerts::alrLockedAt, S(TAPI::DateTime_t), QFV, QNull, UPAdmin }, + { tblAlerts::alrLockedBy, S(QString), QFV, QNull, UPAdmin }, { tblAlerts::alrLastTryAt, S(TAPI::DateTime_t), QFV, QNull, UPAdmin }, { tblAlerts::alrSentDate, S(TAPI::DateTime_t), QFV, QNull, UPAdmin }, { tblAlerts::alrStatus, ORM_STATUS_FIELD(Targoman::API::ORM::enuAlertStatus, Targoman::API::ORM::enuAlertStatus::New) }, diff --git a/Interfaces/ORM/intfAlerts.h b/Interfaces/ORM/intfAlerts.h index b5f05fda..1df585df 100644 --- a/Interfaces/ORM/intfAlerts.h +++ b/Interfaces/ORM/intfAlerts.h @@ -55,6 +55,7 @@ namespace tblAlerts { TARGOMAN_CREATE_CONSTEXPR(alrReplacements); TARGOMAN_CREATE_CONSTEXPR(alrCreateDate); TARGOMAN_CREATE_CONSTEXPR(alrLockedAt); + TARGOMAN_CREATE_CONSTEXPR(alrLockedBy); TARGOMAN_CREATE_CONSTEXPR(alrLastTryAt); TARGOMAN_CREATE_CONSTEXPR(alrSentDate); TARGOMAN_CREATE_CONSTEXPR(alrStatus); diff --git a/Modules/Common/migrations/db/m20220508_130709_Common_add_lockedby_to_tblalerts.sql b/Modules/Common/migrations/db/m20220508_130709_Common_add_lockedby_to_tblalerts.sql new file mode 100644 index 00000000..2def9baf --- /dev/null +++ b/Modules/Common/migrations/db/m20220508_130709_Common_add_lockedby_to_tblalerts.sql @@ -0,0 +1,5 @@ +/* Migration File: m20220508_130709_Common_add_lockedby_to_tblalerts.sql */ +/* CAUTION: don't forget to use {{dbprefix}} for schemas */ + +ALTER TABLE `tblAlerts` + ADD COLUMN `alrLockedBy` VARCHAR(50) NULL DEFAULT NULL AFTER `alrLockedAt`;