SHOW CREATE TRIGGER plc_tx_cmbAndKeep_R_U




Trigger                sql_mode                                    SQL Original Statement                                                                                                                                                                                                                                                                                                                                                                                                                                    character_set_client  collation_connection  Database Collation  Created                 
---------------------  ------------------------------------------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  --------------------  --------------------  ------------------  ------------------------
plc_tx_cmbAndKeep_R_U  STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION  CREATE DEFINER=`root`@`localhost` TRIGGER plc_tx_cmbAndKeep_R_U                                                                                                                                                                                                                                                                                                                                                                                           utf8                  utf8_general_ci       utf8mb4_general_ci  2025-12-21 18:22:45.52  
                                                                   BEFORE UPDATE ON PLC_CMB_OUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
                                                                   FOR EACH ROW                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
                                                                   BEGIN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                                                                     IF OLD.Status <> 'Y' AND NEW.Status = 'Y' THEN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
                                                                       SET NEW.dateOpen = appTime();                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                     ELSEIF OLD.Status = 'Y' AND NEW.Status = 'R' THEN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                       SET NEW.dateClose = appTime();                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                                                     ELSEIF (OLD.Status <> 'A' AND NEW.Status = 'A') OR                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
                                                                            (OLD.Status <> 'F' AND NEW.Status = 'F') THEN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                                                       SET NEW.dateFinish = appTime();                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                     END IF;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
                                                                   END