20/08/2026 04:28:37(1787200117049) 20/08/2026 04:28:37(1787200117049) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> MYSQL DATABASE UPGRADATION STARTED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:37(1787200117049) 20/08/2026 04:28:37(1787200117049) 20/08/2026 04:28:37(1787200117049) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> MYSQL DATABASE UPGRADATION STARTED (1050 to 1250) <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:37(1787200117049) >>>>>>>>>>>>>>>>>> MYSQL DATABASE TABLE UPDATION START <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:37(1787200117370) ivms_30.v_channel_health_status isTableExist: true 20/08/2026 04:28:37(1787200117371) ivms_30.v_channel_report_status isTableExist: true 20/08/2026 04:28:37(1787200117371) >>>>>>>>>>>>>>>>>> MYSQL DATABASE TABLE UPDATION END <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:37(1787200117371) >>>>>>>>>>>>>>>>>> MYSQL DATABASE ALTER UPDATION STARTED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:37(1787200117402) v_recycle_clip.junk_flag isColumnExists: true 20/08/2026 04:28:37(1787200117402) >>>>>>>>>>>>>>>>>> MYSQL DATABASE ALTER UPDATION ENDED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:37(1787200117402) >>>>>>>>>>>>>>>>>> MYSQL DATABASE PROCEDURE UPDATION START <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:37(1787200117402) isProcedureExist getRecordingDetailsByChannel 20/08/2026 04:28:37(1787200117406) isExists true 20/08/2026 04:28:37(1787200117417) alterTable vReturn 0 20/08/2026 04:28:37(1787200117417) isProcedureExist getRecordingDetailsByChannel 20/08/2026 04:28:37(1787200117418) isExists false 20/08/2026 04:28:37(1787200117418) createProcedureString CREATE DEFINER=`root`@`%` PROCEDURE `getRecordingDetailsByChannel`(IN channelId SMALLINT, IN startTimeStamp BIGINT, IN endTimeStamp BIGINT) BEGIN BLOCK1:BEGIN DECLARE ch_id SMALLINT; DECLARE recordingPresent SMALLINT DEFAULT 0; DECLARE criticalMark SMALLINT DEFAULT 0; DECLARE incidentMark SMALLINT DEFAULT 0; DECLARE x BIGINT; DECLARE GetName VARCHAR(255); DECLARE recordingId BIGINT; DROP TEMPORARY TABLE IF EXISTS recordMax; CREATE TEMPORARY TABLE recordMax ( recording SMALLINT DEFAULT 0 , criticalmark SMALLINT DEFAULT 0 , incidentmark SMALLINT DEFAULT 0 ) ENGINE=MEMORY; IF (endTimeStamp - startTimeStamp) > (24 * 60 * 60 * 1000) THEN SET x = startTimeStamp + (24 * 60 * 60 * 1000); ELSE SET x = endTimeStamp; END IF; WHILE x > startTimeStamp DO SET @GetName = CONCAT( 'SELECT count(*) INTO @var1 FROM v_video_clip_', channelId, ' WHERE start_timestamp >=', startTimeStamp, ' AND start_timestamp <= ', x ); PREPARE stmt FROM @GetName; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET recordingId = @var1; IF recordingId > 0 THEN SET recordingPresent = @var1; ELSE SET recordingPresent = 0; END IF; SET @GetName1 = CONCAT('SELECT count(*) INTO @var2 FROM v_video_clip_', channelId, ' WHERE start_timestamp >=', startTimeStamp , ' AND start_timestamp <= ', x ,' AND dont_delete=1'); PREPARE stmt1 FROM @GetName1; EXECUTE stmt1; DEALLOCATE PREPARE stmt1; SET recordingId = @var2; IF recordingId > 0 THEN SET criticalMark = @var2; ELSE SET criticalMark = 0; END IF; SET @GetName3 = CONCAT('SELECT count(*) INTO @var3 FROM v_video_clip_', channelId, ' WHERE start_timestamp >=', startTimeStamp , ' AND start_timestamp <= ', x ,' AND incident_bookmark=1'); PREPARE stmt3 FROM @GetName3; EXECUTE stmt3; DEALLOCATE PREPARE stmt3; SET recordingId = @var3; IF recordingId > 0 THEN SET incidentMark = @var3; ELSE SET incidentMark = 0; END IF; insert into recordMax values(recordingPresent,criticalMark, incidentMark); SET startTimeStamp = x; IF (endTimeStamp - x) > (24 * 60 * 60 * 1000) THEN SET x = startTimeStamp + (24 * 60 * 60 * 1000); ELSE SET x = endTimeStamp; END IF; END WHILE; SELECT * FROM recordMax; DROP TABLE recordMax; END BLOCK1; END 20/08/2026 04:28:37(1787200117426) createProcedure vReturn 0 20/08/2026 04:28:37(1787200117426) isProcedureExist updateChannelHealthStatusAndReport 20/08/2026 04:28:37(1787200117428) isExists true 20/08/2026 04:28:37(1787200117429) ivms_30.v_track_layout isTableExist: true 20/08/2026 04:28:37(1787200117430) exits v_track_layout 20/08/2026 04:28:37(1787200117431) ivms_30.v_event_channel_track isTableExist: true 20/08/2026 04:28:37(1787200117431) exits v_event_channel_track 20/08/2026 04:28:37(1787200117431) isProcedureExist alterClipTable 20/08/2026 04:28:37(1787200117433) isExists true 20/08/2026 04:28:37(1787200117433) >>>>>>>>>>>>>>>>>> DATABASE PROCEDURE UPDATION ENDED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:37(1787200117435) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:37(1787200117437) v_channel.is_deleted isColumnExists: true 20/08/2026 04:28:37(1787200117439) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:37(1787200117441) v_channel.delete_timestamp isColumnExists: true 20/08/2026 04:28:37(1787200117443) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:37(1787200117445) v_user_profile.download_clip isColumnExists: true 20/08/2026 04:28:37(1787200117447) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:37(1787200117448) v_user_profile.download_report isColumnExists: true 20/08/2026 04:28:37(1787200117450) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:37(1787200117452) v_user_profile.download_clip isColumnExists: true 20/08/2026 04:28:37(1787200117452) v_user_profile.download_report isColumnExists: true 20/08/2026 04:28:37(1787200117452) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.download_clip.download_report 20/08/2026 04:28:37(1787200117452) isProcedureExist proc_delete_channel 20/08/2026 04:28:37(1787200117453) isExists true 20/08/2026 04:28:37(1787200117458) alterTable vReturn 0 20/08/2026 04:28:37(1787200117458) isProcedureExist proc_delete_channel 20/08/2026 04:28:37(1787200117459) isExists false 20/08/2026 04:28:37(1787200117459) alterClipTableProcedureString CREATE DEFINER=`root`@`%` PROCEDURE `proc_delete_channel`(IN channelId SMALLINT,OUT p_return_code SMALLINT) BEGIN BLOCK1:BEGIN DECLARE total_recod_count BIGINT; DECLARE record_total INTEGER; DECLARE exit handler for sqlexception BEGIN SET p_return_code := 1; DROP VIEW IF EXISTS test_prepare_vw; rollback; END; DECLARE exit handler for sqlwarning BEGIN set p_return_code = 2; rollback; END; SET p_return_code:= 0; START TRANSACTION; BLOCK2: begin DECLARE cursor_end CONDITION FOR SQLSTATE '02000'; DECLARE clip_id BIGINT; DECLARE selectCahnnelId SMALLINT; DECLARE backupState tinyint; DECLARE clipStartTimestamp BIGINT; DECLARE clipUrl,mediaServerId VARCHAR(256); DECLARE clip_not_found INTEGER DEFAULT 0; DECLARE done INT DEFAULT 0; DECLARE clip_select_cursor CURSOR FOR SELECT * FROM test_prepare_vw; DECLARE CONTINUE HANDLER FOR cursor_end SET clip_not_found = 1; SET @query = CONCAT('CREATE VIEW test_prepare_vw as select ID,CHANNEL_ID,BACKUP_STATE,MEDIA_SERVER_ID,START_TIMESTAMP,CLIP_URL from v_video_clip_', channelId ); PREPARE stmt from @query; EXECUTE stmt; DEALLOCATE PREPARE stmt; OPEN clip_select_cursor; clip_loop: LOOP FETCH clip_select_cursor INTO clip_id,selectCahnnelId,backupState,mediaServerId,clipStartTimestamp,clipUrl; IF clip_not_found THEN CLOSE clip_select_cursor; DROP VIEW IF EXISTS test_prepare_vw; LEAVE clip_loop; ELSE INSERT INTO v_deletable_clip (CHANNEL_ID,BACKUP_STATE,MEDIA_SERVER_ID,clip_start_timestamp,CLIP_URL) values (selectCahnnelId,backupState,mediaServerId,clipStartTimestamp,clipUrl); END IF; END LOOP clip_loop; DROP VIEW IF EXISTS test_prepare_vw; BLOCKEVENT: begin DECLARE pEventId BIGINT; DECLARE pChannelId SMALLINT; DECLARE pEventType SMALLINT; DECLARE pEventMessage VARCHAR(64); DECLARE pAction VARCHAR(256); DECLARE pObjectId VARCHAR(64); DECLARE pModifiedObjectId VARCHAR(64); DECLARE pClipReview TINYINT; DECLARE pAcknowledge TINYINT; DECLARE pAcknowledgeUser VARCHAR(16); DECLARE pPriority TINYINT; DECLARE pEventStartTimestamp BIGINT; DECLARE pEventEndTimestamp BIGINT; DECLARE event_record_not_found INTEGER DEFAULT 0; DECLARE event_record_cursor CURSOR FOR SELECT id,channel_id,event_type,event_message,action,object_id,modified_object_id, clip_review,acknowledge,acknowledge_user,priority,event_starttime,event_endtime FROM v_event WHERE channel_id= channelId; DECLARE CONTINUE HANDLER FOR cursor_end SET event_record_not_found = 1; OPEN event_record_cursor; event_loop: LOOP FETCH event_record_cursor INTO pEventId,pChannelId,pEventType,pEventMessage,pAction,pObjectId,pModifiedObjectId,pClipReview,pAcknowledge,pAcknowledgeUser,pPriority,pEventStartTimestamp,pEventEndTimestamp; IF event_record_not_found THEN CLOSE event_record_cursor; LEAVE event_loop; ELSE INSERT INTO v_deletable_event (id, channel_id,event_type,event_message,action,object_id,modified_object_id, clip_review,acknowledge,acknowledge_user,priority,event_starttime,event_endtime) values (pEventId, pChannelId,pEventType,pEventMessage,pAction,pObjectId,pModifiedObjectId,pClipReview,pAcknowledge, pAcknowledgeUser,pPriority,pEventStartTimestamp,pEventEndTimestamp); IF pEventType <> 314 THEN BLOCKEVENTSNAP: begin DECLARE pEventSnapId BIGINT; DECLARE pEventSnapUrl VARCHAR(256); DECLARE pEventRecordId BIGINT; DECLARE event_snap_not_found INTEGER DEFAULT 0; DECLARE event_record_snap_cursor CURSOR FOR SELECT id,snap_url,event_id FROM v_event_snap WHERE event_id= pEventId; DECLARE CONTINUE HANDLER FOR cursor_end SET event_snap_not_found = 1; OPEN event_record_snap_cursor; event_snap_loop: LOOP FETCH event_record_snap_cursor INTO pEventSnapId,pEventSnapUrl,pEventRecordId; IF event_snap_not_found THEN CLOSE event_record_snap_cursor; LEAVE event_snap_loop; ELSE IF(pEventSnapId IS NOT NULL) THEN INSERT INTO v_deletable_event_snap (snap_url,event_snap_id) values (pEventSnapUrl,pEventRecordId); DELETE FROM v_event_snap WHERE id = pEventSnapId; ElSE CLOSE event_record_snap_cursor; LEAVE event_snap_loop; END IF; END IF; END LOOP event_snap_loop; END BLOCKEVENTSNAP; else select ' no need to transfer in deletable'; END IF; DELETE FROM v_event WHERE id = pEventId; END IF; END LOOP event_loop; END BLOCKEVENT; END BLOCK2; SET @queryDropClipChTable = CONCAT('DROP TABLE v_video_clip_', channelId); select @queryDropClipChTable; PREPARE stmtdrop from @queryDropClipChTable; EXECUTE stmtdrop; DEALLOCATE PREPARE stmtdrop; DELETE FROM v_channel WHERE id = channelId; COMMIT; select'return_val',p_return_code; END BLOCK1; END 20/08/2026 04:28:37(1787200117467) createProcedure vReturn 0 20/08/2026 04:28:37(1787200117469) ivms_30.v_ccc_email isTableExist: true 20/08/2026 04:28:37(1787200117469) exits v_ccc_email 20/08/2026 04:28:37(1787200117470) ivms_30.v_ccc_sop isTableExist: true 20/08/2026 04:28:37(1787200117470) exits v_ccc_sop 20/08/2026 04:28:37(1787200117472) ivms_30.v_ccc_phone isTableExist: true 20/08/2026 04:28:37(1787200117472) exits v_ccc_phone 20/08/2026 04:28:37(1787200117473) ivms_30.v_ccc_instruction isTableExist: true 20/08/2026 04:28:37(1787200117473) exits v_ccc_instruction 20/08/2026 04:28:37(1787200117474) ivms_30.v_ccc_incident isTableExist: true 20/08/2026 04:28:37(1787200117474) exits v_ccc_incident 20/08/2026 04:28:37(1787200117476) ivms_30.v_ccc_incident_url isTableExist: true 20/08/2026 04:28:37(1787200117476) exits v_ccc_incident_url 20/08/2026 04:28:37(1787200117476) isProcedureExist markEventClips 20/08/2026 04:28:37(1787200117477) isExists true 20/08/2026 04:28:37(1787200117483) alterTable vReturn 0 20/08/2026 04:28:37(1787200117483) isProcedureExist markEventClips 20/08/2026 04:28:37(1787200117485) isExists false 20/08/2026 04:28:37(1787200117485) markEventClipsProcedureString CREATE DEFINER=`root`@`localhost` PROCEDURE `markEventClips`(IN channelId SMALLINT, IN thresholdTime BIGINT, OUT return_val SMALLINT) BEGIN BLOCK1:BEGIN DECLARE n SMALLINT DEFAULT 0; DECLARE event_id BIGINT; DECLARE ch_id SMALLINT; DECLARE event_time BIGINT; DECLARE event_s_time BIGINT; DECLARE event_e_time BIGINT; DECLARE record_not_found INTEGER DEFAULT 0; DECLARE countval INTEGER DEFAULT 0; DECLARE event_select_cursor CURSOR FOR SELECT id,channel_id,event_starttime FROM v_event WHERE clip_review = 0 AND channel_id = channelId AND (unix_timestamp(now())- event_starttime/1000) <= (thresholdTime * 24 * 60 *60); DECLARE CONTINUE HANDLER FOR NOT FOUND SET record_not_found = 1; SET return_val := 1; OPEN event_select_cursor; event_loop: LOOP FETCH event_select_cursor INTO event_id,ch_id,event_time; IF record_not_found THEN CLOSE event_select_cursor; LEAVE event_loop; ELSE SET n := -1; SET event_s_time := (event_time - 5*60*1000); SET event_e_time := (event_time + 5*60*1000); SET @qry_update = CONCAT('UPDATE v_video_clip_', channelId ,' SET junk_flag = 4 WHERE (START_TIMESTAMP >= ', event_s_time , ' AND END_TIMESTAMP <= ' ,event_e_time , ')'); PREPARE stmnx FROM @qry_update; EXECUTE stmnx; SET n := ROW_COUNT(); update v_event set clip_review = 1 where id=event_id; IF n > 0 THEN select n; SET return_val := n; ELSE SET return_val := -1; END IF; DEALLOCATE PREPARE stmnx; END IF; END LOOP event_loop; select'return_val',return_val; END BLOCK1; END 20/08/2026 04:28:37(1787200117492) createProcedure vReturn 0 20/08/2026 04:28:37(1787200117494) ivms_30.v_login_user isTableExist: true 20/08/2026 04:28:37(1787200117496) v_login_user.is_encrypted isColumnExists: true 20/08/2026 04:28:37(1787200117496) >>>>>>>>>> Columns Does Exist >>>>>>>>>> v_login_user.is_encrypted 20/08/2026 04:28:37(1787200117498) getAllUser vReturn 0 20/08/2026 04:28:37(1787200117498) ******Doing no encrypt to SHA_512_ENCRYPTION for user admin, Password(already encrypted):c7ad44cbad762a5da0a452f9e854fdc1e0e7a52a38015f23f3eab1d80b931dd472634dfac71cd34ebc35d16ab7fb8a90c81f975113d6c7538dc69dd8de9077ec, is_encrypted:2 20/08/2026 04:28:37(1787200117498) ******Doing no encrypt to SHA_512_ENCRYPTION for user cadmin@videonetics.com, Password(already encrypted):a5011d749c39bceb78cbb5d657c887ca9545867a0d2ed49534fc4fea8851505fa7e531b258892051909011d62128ec5e6c2d6f181418ca072b8603c0d0b25fca, is_encrypted:2 20/08/2026 04:28:37(1787200117500) ivms_30.v_marked_clip isTableExist: true 20/08/2026 04:28:37(1787200117500) exits v_marked_clip 20/08/2026 04:28:37(1787200117502) ivms_30.v_marked_clip isTableExist: true 20/08/2026 04:28:37(1787200117503) v_marked_clip.deleted_at isColumnExists: true 20/08/2026 04:28:37(1787200117505) ivms_30.v_preset isTableExist: true 20/08/2026 04:28:37(1787200117505) exits v_preset 20/08/2026 04:28:37(1787200117507) ivms_30.v_storage_vms isTableExist: true 20/08/2026 04:28:37(1787200117507) >>>>>>>>>>>>>>>>>>>>>> v_storage_vms Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_storage_vms.path 20/08/2026 04:28:37(1787200117521) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_storage_vms` CHANGE COLUMN `path` `path` VARCHAR(128) 20/08/2026 04:28:37(1787200117524) ivms_30.v_storage_ms isTableExist: true 20/08/2026 04:28:37(1787200117524) >>>>>>>>>>>>>>>>>>>>>> v_storage_ms Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_storage_ms.path 20/08/2026 04:28:37(1787200117534) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_storage_ms` CHANGE COLUMN `path` `path` VARCHAR(128) 20/08/2026 04:28:37(1787200117534) isProcedureExist alterClipTableAddStreamClipMode 20/08/2026 04:28:37(1787200117537) isExists true 20/08/2026 04:28:37(1787200117538) ivms_30.v_trajectory isTableExist: true 20/08/2026 04:28:37(1787200117538) exits v_trajectory 20/08/2026 04:28:37(1787200117540) ivms_30.v_heatmap isTableExist: true 20/08/2026 04:28:37(1787200117540) exits v_heatmap 20/08/2026 04:28:37(1787200117542) ivms_30.v_channel_param isTableExist: true 20/08/2026 04:28:37(1787200117542) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_channel_param.param_5 20/08/2026 04:28:37(1787200117553) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_channel_param` CHANGE COLUMN `param_5` `param_5` VARCHAR(128) 20/08/2026 04:28:37(1787200117555) ivms_30.v_media_server isTableExist: true 20/08/2026 04:28:37(1787200117556) v_media_server.server_type isColumnExists: true 20/08/2026 04:28:37(1787200117558) ivms_30.rl_ms_rms isTableExist: true 20/08/2026 04:28:37(1787200117558) exits rl_ms_rms 20/08/2026 04:28:37(1787200117560) ivms_30.rl_channel_media_server_fixed isTableExist: true 20/08/2026 04:28:37(1787200117560) exits rl_channel_media_server_fixed 20/08/2026 04:28:37(1787200117561) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:37(1787200117562) v_channel.analytic_url_multicast isColumnExists: true 20/08/2026 04:28:37(1787200117564) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:37(1787200117565) v_channel.minor_url_multicast isColumnExists: true 20/08/2026 04:28:37(1787200117566) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:37(1787200117567) v_channel.major_url_multicast isColumnExists: true 20/08/2026 04:28:37(1787200117568) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:37(1787200117569) v_channel.current_transmission isColumnExists: true 20/08/2026 04:28:37(1787200117570) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:37(1787200117571) v_channel.description isColumnExists: true 20/08/2026 04:28:37(1787200117572) ivms_30.v_event isTableExist: true 20/08/2026 04:28:37(1787200117573) v_event.object_property_1 isColumnExists: true 20/08/2026 04:28:37(1787200117573) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:37(1787200117655) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_1` `object_property_1` SMALLINT(6) NULL DEFAULT NULL 20/08/2026 04:28:37(1787200117657) ivms_30.v_event isTableExist: true 20/08/2026 04:28:37(1787200117659) v_event.object_property_2 isColumnExists: true 20/08/2026 04:28:37(1787200117659) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:37(1787200117742) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_2` `object_property_2` SMALLINT(6) NULL DEFAULT NULL 20/08/2026 04:28:37(1787200117745) ivms_30.v_event isTableExist: true 20/08/2026 04:28:37(1787200117746) v_event.object_property_3 isColumnExists: true 20/08/2026 04:28:37(1787200117747) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:37(1787200117831) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_3` `object_property_3` SMALLINT(6) NULL DEFAULT NULL 20/08/2026 04:28:37(1787200117834) ivms_30.v_event isTableExist: true 20/08/2026 04:28:37(1787200117836) v_event.object_property_4 isColumnExists: true 20/08/2026 04:28:37(1787200117837) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:37(1787200117915) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_4` `object_property_4` SMALLINT(6) NULL DEFAULT NULL 20/08/2026 04:28:37(1787200117916) ivms_30.v_event isTableExist: true 20/08/2026 04:28:37(1787200117918) v_event.object_property_5 isColumnExists: false 20/08/2026 04:28:37(1787200117918) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:37(1787200117945) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_5` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_4` 20/08/2026 04:28:37(1787200117946) ivms_30.v_event isTableExist: true 20/08/2026 04:28:37(1787200117948) v_event.object_property_6 isColumnExists: false 20/08/2026 04:28:37(1787200117948) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:37(1787200117983) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_6` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_5` 20/08/2026 04:28:37(1787200117984) ivms_30.v_event isTableExist: true 20/08/2026 04:28:37(1787200117985) v_event.object_property_7 isColumnExists: false 20/08/2026 04:28:37(1787200117985) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118035) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_7` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_6` 20/08/2026 04:28:38(1787200118037) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118039) v_event.object_property_8 isColumnExists: false 20/08/2026 04:28:38(1787200118039) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118066) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_8` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_7` 20/08/2026 04:28:38(1787200118068) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118069) v_event.object_property_9 isColumnExists: false 20/08/2026 04:28:38(1787200118069) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118103) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_9` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_8` 20/08/2026 04:28:38(1787200118105) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118106) v_event.object_property_10 isColumnExists: false 20/08/2026 04:28:38(1787200118107) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118139) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_10` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_9` 20/08/2026 04:28:38(1787200118141) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118142) v_event.object_property_11 isColumnExists: false 20/08/2026 04:28:38(1787200118142) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118167) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_11` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_10` 20/08/2026 04:28:38(1787200118169) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118171) v_event.object_property_12 isColumnExists: false 20/08/2026 04:28:38(1787200118171) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118208) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_12` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_11` 20/08/2026 04:28:38(1787200118210) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118212) v_event.object_property_13 isColumnExists: false 20/08/2026 04:28:38(1787200118212) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118247) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_13` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_12` 20/08/2026 04:28:38(1787200118249) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118252) v_event.object_property_14 isColumnExists: false 20/08/2026 04:28:38(1787200118252) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118286) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_14` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_13` 20/08/2026 04:28:38(1787200118287) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118289) v_event.object_property_15 isColumnExists: false 20/08/2026 04:28:38(1787200118289) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 20/08/2026 04:28:38(1787200118321) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_15` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_14` 20/08/2026 04:28:38(1787200118322) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118324) v_event.backup_state isColumnExists: true 20/08/2026 04:28:38(1787200118325) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118327) v_event.storage_path isColumnExists: true 20/08/2026 04:28:38(1787200118328) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118330) v_event.rec_server_id isColumnExists: true 20/08/2026 04:28:38(1787200118331) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118331) exits rl_channel_media_server_fixed 20/08/2026 04:28:38(1787200118331) isProcedureExist alterClipTableAddParallelRecording 20/08/2026 04:28:38(1787200118333) isExists true 20/08/2026 04:28:38(1787200118333) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:38(1787200118335) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118336) v_event.attribute isColumnExists: true 20/08/2026 04:28:38(1787200118338) ivms_30.v_network_storage isTableExist: true 20/08/2026 04:28:38(1787200118340) v_network_storage.STORAGE_CLASS_TYPE isColumnExists: true 20/08/2026 04:28:38(1787200118341) ivms_30.v_chat_message isTableExist: true 20/08/2026 04:28:38(1787200118341) exits v_chat_message 20/08/2026 04:28:38(1787200118343) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118343) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.event_message 20/08/2026 04:28:38(1787200118364) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `event_message` `event_message` VARCHAR(256) 20/08/2026 04:28:38(1787200118366) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118366) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.attribute 20/08/2026 04:28:38(1787200118438) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `attribute` `attribute` VARCHAR(512) 20/08/2026 04:28:38(1787200118440) ivms_30.v_group isTableExist: true 20/08/2026 04:28:38(1787200118443) v_group.name isColumnExists: true 20/08/2026 04:28:38(1787200118443) >>>>>>>>>>>>>>>>>>>>>> Columns Does Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_group.name 20/08/2026 04:28:38(1787200118448) ivms_30.v_location isTableExist: true 20/08/2026 04:28:38(1787200118450) v_location.name isColumnExists: true 20/08/2026 04:28:38(1787200118450) >>>>>>>>>>>>>>>>>>>>>> Columns Does Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_location.name 20/08/2026 04:28:38(1787200118458) ivms_30.v_login_user isTableExist: true 20/08/2026 04:28:38(1787200118460) v_login_user.password_history isColumnExists: true 20/08/2026 04:28:38(1787200118462) ivms_30.v_login_user isTableExist: true 20/08/2026 04:28:38(1787200118464) v_login_user.double_password isColumnExists: true 20/08/2026 04:28:38(1787200118466) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:38(1787200118468) v_channel.is_encrypted isColumnExists: true 20/08/2026 04:28:38(1787200118470) ivms_30.rl_channel_collection isTableExist: true 20/08/2026 04:28:38(1787200118470) >>>>>>>>>>>>>>>>>>>>>> PRIMARY KEY Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_collection.channel_id, rl_channel_collection.collection_id, rl_channel_collection.timestamp 20/08/2026 04:28:38(1787200118551) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`rl_channel_collection`ADD PRIMARY KEY(`channel_id`, `collection_id`, `timestamp`) 20/08/2026 04:28:38(1787200118554) ivms_30.rl_child_collection isTableExist: true 20/08/2026 04:28:38(1787200118554) >>>>>>>>>>>>>>>>>>>>>> PRIMARY KEY Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_child_collection.child_id, rl_child_collection.collection_id, rl_child_collection.timestamp 20/08/2026 04:28:38(1787200118606) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`rl_child_collection`ADD PRIMARY KEY(`child_id`, `collection_id`, `timestamp`) 20/08/2026 04:28:38(1787200118609) ivms_30.v_dr_details isTableExist: true 20/08/2026 04:28:38(1787200118609) does not exits v_dr_details 20/08/2026 04:28:38(1787200118611) ivms_30.v_data_safekeeping_configuration isTableExist: true 20/08/2026 04:28:38(1787200118611) does exist v_data_safekeeping_configuration 20/08/2026 04:28:38(1787200118614) ivms_30.v_business_continuity_recording_configuration isTableExist: true 20/08/2026 04:28:38(1787200118614) does exist v_business_continuity_recording_configuration 20/08/2026 04:28:38(1787200118616) ivms_30.v_business_continuity_analytics_configuration isTableExist: true 20/08/2026 04:28:38(1787200118616) does exist v_business_continuity_analytics_configuration 20/08/2026 04:28:38(1787200118618) ivms_30.db_query_logs isTableExist: true 20/08/2026 04:28:38(1787200118618) does not exits db_query_logs 20/08/2026 04:28:38(1787200118620) ivms_30.db_query_logs isTableExist: true 20/08/2026 04:28:38(1787200118623) db_query_logs.channel_id isColumnExists: true 20/08/2026 04:28:38(1787200118625) ivms_30.db_query_logs isTableExist: true 20/08/2026 04:28:38(1787200118627) db_query_logs.event_type isColumnExists: true 20/08/2026 04:28:38(1787200118629) ivms_30.v_collection isTableExist: true 20/08/2026 04:28:38(1787200118629) v_collection exist 20/08/2026 04:28:38(1787200118631) ivms_30.rl_channel_collection isTableExist: true 20/08/2026 04:28:38(1787200118631) rl_channel_collection exist 20/08/2026 04:28:38(1787200118633) ivms_30.rl_child_collection isTableExist: true 20/08/2026 04:28:38(1787200118634) rl_child_collection exist 20/08/2026 04:28:38(1787200118636) ivms_30.v_task_dc isTableExist: true 20/08/2026 04:28:38(1787200118636) v_task_dc exist 20/08/2026 04:28:38(1787200118638) ivms_30.v_task_dr isTableExist: true 20/08/2026 04:28:38(1787200118638) v_task_dr exist 20/08/2026 04:28:38(1787200118638) isProcedureExist alterClipTableAddDrFileFatchStatus 20/08/2026 04:28:38(1787200118641) isExists true 20/08/2026 04:28:38(1787200118641) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:38(1787200118641) isProcedureExist alterClipTableAddSecondaryId 20/08/2026 04:28:38(1787200118643) isExists true 20/08/2026 04:28:38(1787200118643) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 20/08/2026 04:28:38(1787200118645) ivms_30.v_event_snap isTableExist: true 20/08/2026 04:28:38(1787200118647) v_event_snap.dr_file_fatch_status isColumnExists: true 20/08/2026 04:28:38(1787200118649) ivms_30.v_alarm_action isTableExist: true 20/08/2026 04:28:38(1787200118651) v_alarm_action.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118654) ivms_30.v_alerm_listener_group isTableExist: true 20/08/2026 04:28:38(1787200118656) v_alerm_listener_group.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118658) ivms_30.v_analytic_server isTableExist: true 20/08/2026 04:28:38(1787200118660) v_analytic_server.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118662) ivms_30.v_ccc_email isTableExist: true 20/08/2026 04:28:38(1787200118664) v_ccc_email.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118666) ivms_30.v_ccc_incident isTableExist: true 20/08/2026 04:28:38(1787200118668) v_ccc_incident.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118670) ivms_30.v_ccc_incident_url isTableExist: true 20/08/2026 04:28:38(1787200118672) v_ccc_incident_url.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118674) ivms_30.v_ccc_instruction isTableExist: true 20/08/2026 04:28:38(1787200118676) v_ccc_instruction.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118678) ivms_30.v_ccc_phone isTableExist: true 20/08/2026 04:28:38(1787200118680) v_ccc_phone.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118683) ivms_30.v_ccc_sop isTableExist: true 20/08/2026 04:28:38(1787200118684) v_ccc_sop.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118687) ivms_30.v_channel_report_status isTableExist: true 20/08/2026 04:28:38(1787200118688) v_channel_report_status.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118691) ivms_30.v_channel_health_status isTableExist: true 20/08/2026 04:28:38(1787200118692) v_channel_health_status.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118693) ivms_30.v_chat_message isTableExist: true 20/08/2026 04:28:38(1787200118694) v_chat_message.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118696) ivms_30.v_vehicle_registry isTableExist: true 20/08/2026 04:28:38(1787200118696) v_vehicle_registry.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118697) ivms_30.v_event_channel_track isTableExist: true 20/08/2026 04:28:38(1787200118698) v_event_channel_track.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118699) ivms_30.v_event_snap isTableExist: true 20/08/2026 04:28:38(1787200118699) v_event_snap.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118700) ivms_30.v_event isTableExist: true 20/08/2026 04:28:38(1787200118700) v_event.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118701) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118701) v_external_device_registration.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118701) ivms_30.v_group isTableExist: true 20/08/2026 04:28:38(1787200118701) v_group.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118702) ivms_30.v_heatmap isTableExist: true 20/08/2026 04:28:38(1787200118702) v_heatmap.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118702) ivms_30.v_junction isTableExist: true 20/08/2026 04:28:38(1787200118703) v_junction.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118703) ivms_30.v_location isTableExist: true 20/08/2026 04:28:38(1787200118703) v_location.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118704) ivms_30.v_log isTableExist: true 20/08/2026 04:28:38(1787200118704) v_log.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118704) ivms_30.v_map isTableExist: true 20/08/2026 04:28:38(1787200118704) v_map.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118705) ivms_30.v_marked_clip isTableExist: true 20/08/2026 04:28:38(1787200118705) v_marked_clip.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118705) ivms_30.v_motion isTableExist: true 20/08/2026 04:28:38(1787200118706) v_motion.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118706) ivms_30.v_network_storage isTableExist: true 20/08/2026 04:28:38(1787200118706) v_network_storage.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118706) ivms_30.v_parking_monitoring isTableExist: false 20/08/2026 04:28:38(1787200118707) ivms_30.v_preset isTableExist: true 20/08/2026 04:28:38(1787200118707) v_preset.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118707) ivms_30.v_recording isTableExist: true 20/08/2026 04:28:38(1787200118707) v_recording.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118708) ivms_30.v_recycle_clip isTableExist: true 20/08/2026 04:28:38(1787200118708) v_recycle_clip.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118708) ivms_30.v_recyle_event_snap isTableExist: true 20/08/2026 04:28:38(1787200118709) v_recyle_event_snap.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118709) ivms_30.v_recycle_event isTableExist: true 20/08/2026 04:28:38(1787200118709) v_recycle_event.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118709) ivms_30.v_redundant_channel isTableExist: true 20/08/2026 04:28:38(1787200118710) v_redundant_channel.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118710) ivms_30.v_redundant_recording_clip isTableExist: true 20/08/2026 04:28:38(1787200118710) v_redundant_recording_clip.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118711) ivms_30.v_remote_recycle_upload isTableExist: true 20/08/2026 04:28:38(1787200118711) v_remote_recycle_upload.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118711) ivms_30.v_remote_upload isTableExist: true 20/08/2026 04:28:38(1787200118711) v_remote_upload.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118712) ivms_30.v_rlvd_temp isTableExist: true 20/08/2026 04:28:38(1787200118712) v_rlvd_temp.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118712) ivms_30.v_storage_ms isTableExist: true 20/08/2026 04:28:38(1787200118712) v_storage_ms.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118713) ivms_30.v_storage_vms isTableExist: true 20/08/2026 04:28:38(1787200118713) v_storage_vms.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118713) ivms_30.v_third_party_vms_server isTableExist: true 20/08/2026 04:28:38(1787200118714) v_third_party_vms_server.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118714) ivms_30.v_track_layout isTableExist: true 20/08/2026 04:28:38(1787200118714) v_track_layout.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118714) ivms_30.v_trajectory isTableExist: true 20/08/2026 04:28:38(1787200118714) v_trajectory.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118715) ivms_30.v_user_complain isTableExist: true 20/08/2026 04:28:38(1787200118715) v_user_complain.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118715) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118716) v_user_profile.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118716) ivms_30.v_network_storage isTableExist: true 20/08/2026 04:28:38(1787200118716) v_network_storage.REGION isColumnExists: true 20/08/2026 04:28:38(1787200118717) ivms_30.v_deletable_clip isTableExist: true 20/08/2026 04:28:38(1787200118717) v_deletable_clip.backup_state isColumnExists: true 20/08/2026 04:28:38(1787200118717) ivms_30.v_recycle_clip isTableExist: true 20/08/2026 04:28:38(1787200118718) v_recycle_clip.backup_state isColumnExists: true 20/08/2026 04:28:38(1787200118718) ivms_30.v_recycle_clip isTableExist: true 20/08/2026 04:28:38(1787200118719) v_recycle_clip.media_server_id isColumnExists: true 20/08/2026 04:28:38(1787200118719) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118719) exits v_external_device_configuration 20/08/2026 04:28:38(1787200118719) ivms_30.v_task_dc isTableExist: true 20/08/2026 04:28:38(1787200118720) v_task_dc.service_id isColumnExists: true 20/08/2026 04:28:38(1787200118720) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118721) v_external_device_registration.status isColumnExists: true 20/08/2026 04:28:38(1787200118721) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118721) v_external_device_configuration.status isColumnExists: true 20/08/2026 04:28:38(1787200118722) ivms_30.v_redundant_recording_clip isTableExist: true 20/08/2026 04:28:38(1787200118722) v_redundant_recording_clip.media_server_id isColumnExists: true 20/08/2026 04:28:38(1787200118723) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118723) v_external_device_configuration.snap_required isColumnExists: true 20/08/2026 04:28:38(1787200118723) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118724) v_external_device_configuration.snap_channel_id isColumnExists: true 20/08/2026 04:28:38(1787200118724) ivms_30.v_event_prepost_setting isTableExist: true 20/08/2026 04:28:38(1787200118724) exits v_external_device_configuration 20/08/2026 04:28:38(1787200118724) ivms_30.v_recording isTableExist: true 20/08/2026 04:28:38(1787200118725) v_recording.schedule_type isColumnExists: true 20/08/2026 04:28:38(1787200118725) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118725) v_external_device_configuration.secondary_id isColumnExists: true 20/08/2026 04:28:38(1787200118726) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:38(1787200118726) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< v_channel INSERT INTO `ivms_30`.`v_channel` (`id`, `model`, `ip`, `command_port`, `name`, `is_ptz`, `snap_url`, `analytic_url`, `minor_url`, `major_url`, `username`, `password`, `is_encrypted`, `recording_stream`, `ch_number`, `ch_type`, `latitude`, `longitude`, `is_deleted`, `delete_timestamp`, `analytic_url_multicast`, `minor_url_multicast`, `major_url_multicast`, `current_transmission`, `description`) VALUES ('-1', 'ONVIF', '127.0.0.1', '08000', 'System', '0', 'http://127.0.0.1', 'rtsp://127.0.0.1', 'rtsp://127.0.0.1', 'rtsp://127.0.0.1', 'admin', 'CLiEEJQanjw4DKYzyx9ifQ==', '1', '0', '-1', '1', '0', '0', '2', '0', 'rtsp://127.0.0.1', 'rtsp://127.0.0.1', 'rtsp://127.0.0.1', '0', '') 20/08/2026 04:28:38(1787200118772) insertTable vReturn 1002 20/08/2026 04:28:38(1787200118772) ivms_30.rl_channel_group isTableExist: true 20/08/2026 04:28:38(1787200118772) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_group INSERT INTO `ivms_30`.`rl_channel_group` (`channel_id`, `group_id`) VALUES ('-1', '1') 20/08/2026 04:28:38(1787200118773) insertTable vReturn 1002 20/08/2026 04:28:38(1787200118773) ivms_30.rl_channel_location isTableExist: true 20/08/2026 04:28:38(1787200118773) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_location INSERT INTO `ivms_30`.`rl_channel_location` (`channel_id`, `location_id`) VALUES ('-1', '1') 20/08/2026 04:28:38(1787200118774) insertTable vReturn 1002 20/08/2026 04:28:38(1787200118774) ivms_30.rl_channel_recording isTableExist: true 20/08/2026 04:28:38(1787200118774) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_recording INSERT INTO `ivms_30`.`rl_channel_recording` (`channel_id`, `recording_id`) VALUES ('-1', '1') 20/08/2026 04:28:38(1787200118775) insertTable vReturn 1002 20/08/2026 04:28:38(1787200118775) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:38(1787200118775) v_channel.protocol isColumnExists: true 20/08/2026 04:28:38(1787200118776) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:38(1787200118776) v_channel.channel_index isColumnExists: true 20/08/2026 04:28:38(1787200118776) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:38(1787200118777) v_channel.is_secured isColumnExists: true 20/08/2026 04:28:38(1787200118777) ivms_30.v_redundant_recording_clip isTableExist: true 20/08/2026 04:28:38(1787200118777) v_redundant_recording_clip.end_timestamp isColumnExists: true 20/08/2026 04:28:38(1787200118778) ivms_30.v_redundant_recording_clip isTableExist: true 20/08/2026 04:28:38(1787200118778) v_redundant_recording_clip.is_secured isColumnExists: false 20/08/2026 04:28:38(1787200118778) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_redundant_recording_clip.is_secured 20/08/2026 04:28:38(1787200118779) alterTable vReturn 1002 Query :ALTER TABLE `ivms_30`.`v_redundant_recording_clip` ADD COLUMN `clip_size` BIGINT(20) NOT NULL DEFAULT '0' 20/08/2026 04:28:38(1787200118779) ivms_30.v_collection isTableExist: true 20/08/2026 04:28:38(1787200118780) v_collection.description isColumnExists: true 20/08/2026 04:28:38(1787200118780) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_redundant_recording_clip.is_secured 20/08/2026 04:28:38(1787200118791) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_collection` CHANGE COLUMN `description` `description` VARCHAR(12288) NULL DEFAULT NULL 20/08/2026 04:28:38(1787200118792) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118793) v_external_device_registration.camera_association_mode isColumnExists: true 20/08/2026 04:28:38(1787200118794) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118795) v_external_device_registration.number_fixed_cam_to_associate isColumnExists: true 20/08/2026 04:28:38(1787200118796) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118797) v_external_device_registration.ip isColumnExists: true 20/08/2026 04:28:38(1787200118797) exits v_external_device_registration 20/08/2026 04:28:38(1787200118880) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118882) v_external_device_registration.number_ptz_cam_to_associate isColumnExists: true 20/08/2026 04:28:38(1787200118884) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118886) v_external_device_registration.fixed_camera_dictance_to_associat isColumnExists: true 20/08/2026 04:28:38(1787200118888) ivms_30.v_external_device_registration isTableExist: true 20/08/2026 04:28:38(1787200118890) v_external_device_registration.ptz_camera_dictance_to_associat isColumnExists: true 20/08/2026 04:28:38(1787200118891) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118892) v_external_device_configuration.associate_channels isColumnExists: true 20/08/2026 04:28:38(1787200118894) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118895) v_external_device_configuration.zone_id isColumnExists: true 20/08/2026 04:28:38(1787200118897) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118898) v_external_device_configuration.location_id isColumnExists: true 20/08/2026 04:28:38(1787200118900) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118902) v_external_device_configuration.controller_id isColumnExists: true 20/08/2026 04:28:38(1787200118903) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118904) v_external_device_configuration.pos_x isColumnExists: true 20/08/2026 04:28:38(1787200118906) ivms_30.v_external_device_configuration isTableExist: true 20/08/2026 04:28:38(1787200118907) v_external_device_configuration.pos_y isColumnExists: true 20/08/2026 04:28:38(1787200118909) ivms_30.v_external_device_controller isTableExist: true 20/08/2026 04:28:38(1787200118909) exits v_external_device_controller 20/08/2026 04:28:38(1787200118910) ivms_30.v_external_device_location isTableExist: true 20/08/2026 04:28:38(1787200118910) exits v_external_device_location 20/08/2026 04:28:38(1787200118912) ivms_30.v_external_device_zone isTableExist: true 20/08/2026 04:28:38(1787200118912) exits v_external_device_zone 20/08/2026 04:28:38(1787200118913) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118915) v_user_profile.unmasked_live_play isColumnExists: true 20/08/2026 04:28:38(1787200118916) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118918) v_user_profile.unmasked_archive_play isColumnExists: true 20/08/2026 04:28:38(1787200118919) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118921) v_user_profile.unmasked_clip_download isColumnExists: true 20/08/2026 04:28:38(1787200118922) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118924) v_user_profile.unmasked_live_play isColumnExists: true 20/08/2026 04:28:38(1787200118925) v_user_profile.unmasked_archive_play isColumnExists: true 20/08/2026 04:28:38(1787200118927) v_user_profile.unmasked_clip_download isColumnExists: true 20/08/2026 04:28:38(1787200118927) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.download_clip.unmasked_live_play 20/08/2026 04:28:38(1787200118930) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118932) v_user_profile.event_management isColumnExists: true 20/08/2026 04:28:38(1787200118933) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118934) v_user_profile.system_configuration isColumnExists: true 20/08/2026 04:28:38(1787200118935) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118935) v_user_profile.system_settings isColumnExists: true 20/08/2026 04:28:38(1787200118935) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118936) v_user_profile.bookmarks isColumnExists: true 20/08/2026 04:28:38(1787200118936) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118936) v_user_profile.maps isColumnExists: true 20/08/2026 04:28:38(1787200118937) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118938) v_user_profile.external_systems isColumnExists: true 20/08/2026 04:28:38(1787200118940) ivms_30.v_user_profile isTableExist: true 20/08/2026 04:28:38(1787200118942) v_user_profile.event_management isColumnExists: true 20/08/2026 04:28:38(1787200118943) v_user_profile.system_configuration isColumnExists: true 20/08/2026 04:28:38(1787200118944) v_user_profile.system_settings isColumnExists: true 20/08/2026 04:28:38(1787200118946) v_user_profile.bookmarks isColumnExists: true 20/08/2026 04:28:38(1787200118947) v_user_profile.maps isColumnExists: true 20/08/2026 04:28:38(1787200118949) v_user_profile.external_systems isColumnExists: true 20/08/2026 04:28:38(1787200118949) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.event_management 20/08/2026 04:28:38(1787200118952) ivms_30.v_user_restriction isTableExist: true 20/08/2026 04:28:38(1787200118952) exits v_user_restriction 20/08/2026 04:28:38(1787200118967) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:38(1787200118969) v_channel.grabber_library isColumnExists: true 20/08/2026 04:28:38(1787200118971) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:38(1787200118973) v_channel.grabbing_protocol isColumnExists: true 20/08/2026 04:28:38(1787200118974) ivms_30.v_channel isTableExist: true 20/08/2026 04:28:38(1787200118976) v_channel.audio_grabbing isColumnExists: true 20/08/2026 04:28:38(1787200118976) >>>>>>>>>>>>>>>>>> MYSQL DATABASE PROCEDURE UPDATION END <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<