DROP TRIGGER /*!50032 IF EXISTS */ `sfc`.`R102_IDD`$$
CREATE
/*!50017 DEFINER = 'root'@'%' */
TRIGGER `R102_IDD` BEFORE INSERT ON `r_station_rec_t`
FOR EACH ROW BEGIN
DECLARE msg VARCHAR(255);
IF length(ifnull(NEW.idd,''))<2 THEN
-- set NEW.idd=md5(concat(NEW.MO_NUMBER,'-',NEW.WORK_DATE,'-',NEW.WORK_SECTION,'-',NEW.LINE_NAME,'-',NEW.SECTION_NAME,'-',NEW.GROUP_NAME));
set NEW.idd=uuid();
END IF ;
END;
$$