From 1e1a1294f86d52ff0c9313aed89d2cdd6ba1e347 Mon Sep 17 00:00:00 2001 From: Mila <Mila@pollex.com.tw> Date: 星期二, 25 一月 2022 08:53:07 +0800 Subject: [PATCH] Merge branch 'Phase3' of https://192.168.0.10:8443/r/pcalife/PAM into Phase3 --- pamapi/src/doc/sql/20211203_w.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/pamapi/src/doc/sql/20211203_w.sql b/pamapi/src/doc/sql/20211203_w.sql index b6adcdc..1d45563 100644 --- a/pamapi/src/doc/sql/20211203_w.sql +++ b/pamapi/src/doc/sql/20211203_w.sql @@ -1 +1,3 @@ UPDATE omo.appointment SET contact_time = appointment_date where communicate_status = 'CONTACTED'; +UPDATE omo.appointment SET consultant_view_time = appointment_date where communicate_status = 'CONTACTED'; +UPDATE omo.appointment SET consultant_read_time = appointment_date where communicate_status = 'CONTACTED'; -- Gitblit v1.8.0