[update] 舊資料的已預約的預約單其view_time與read_time皆壓上appointment_time

wayne

2021-12-06 2aca3bd5a9664e71ff132712bf9f893e0634928e

[update] 舊資料的已預約的預約單其view_time與read_time皆壓上appointment_time

因appointment_time在舊版中設為last_modify_time

 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';