19/08/2026 21:34:43(1787175283950) 19/08/2026 21:34:43(1787175283950) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> MYSQL DATABASE UPGRADATION STARTED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:43(1787175283950) 19/08/2026 21:34:43(1787175283950) 19/08/2026 21:34:43(1787175283950) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> MYSQL DATABASE UPGRADATION STARTED (1050 to 1250) <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:43(1787175283950) >>>>>>>>>>>>>>>>>> MYSQL DATABASE TABLE UPDATION START <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:44(1787175284441) ivms_30.v_channel_health_status isTableExist: true 19/08/2026 21:34:44(1787175284442) ivms_30.v_channel_report_status isTableExist: true 19/08/2026 21:34:44(1787175284442) >>>>>>>>>>>>>>>>>> MYSQL DATABASE TABLE UPDATION END <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:44(1787175284442) >>>>>>>>>>>>>>>>>> MYSQL DATABASE ALTER UPDATION STARTED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:44(1787175284478) v_recycle_clip.junk_flag isColumnExists: true 19/08/2026 21:34:44(1787175284478) >>>>>>>>>>>>>>>>>> MYSQL DATABASE ALTER UPDATION ENDED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:44(1787175284478) >>>>>>>>>>>>>>>>>> MYSQL DATABASE PROCEDURE UPDATION START <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:44(1787175284478) isProcedureExist getRecordingDetailsByChannel 19/08/2026 21:34:44(1787175284481) isExists true 19/08/2026 21:34:44(1787175284500) alterTable vReturn 0 19/08/2026 21:34:44(1787175284500) isProcedureExist getRecordingDetailsByChannel 19/08/2026 21:34:44(1787175284502) isExists false 19/08/2026 21:34:44(1787175284502) 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 19/08/2026 21:34:44(1787175284521) createProcedure vReturn 0 19/08/2026 21:34:44(1787175284521) isProcedureExist updateChannelHealthStatusAndReport 19/08/2026 21:34:44(1787175284523) isExists true 19/08/2026 21:34:44(1787175284524) ivms_30.v_track_layout isTableExist: true 19/08/2026 21:34:44(1787175284524) exits v_track_layout 19/08/2026 21:34:44(1787175284525) ivms_30.v_event_channel_track isTableExist: true 19/08/2026 21:34:44(1787175284525) exits v_event_channel_track 19/08/2026 21:34:44(1787175284525) isProcedureExist alterClipTable 19/08/2026 21:34:44(1787175284526) isExists true 19/08/2026 21:34:44(1787175284526) >>>>>>>>>>>>>>>>>> DATABASE PROCEDURE UPDATION ENDED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:44(1787175284527) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:44(1787175284528) v_channel.is_deleted isColumnExists: true 19/08/2026 21:34:44(1787175284529) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:44(1787175284530) v_channel.delete_timestamp isColumnExists: true 19/08/2026 21:34:44(1787175284531) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:44(1787175284532) v_user_profile.download_clip isColumnExists: true 19/08/2026 21:34:44(1787175284533) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:44(1787175284534) v_user_profile.download_report isColumnExists: true 19/08/2026 21:34:44(1787175284535) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:44(1787175284536) v_user_profile.download_clip isColumnExists: true 19/08/2026 21:34:44(1787175284537) v_user_profile.download_report isColumnExists: true 19/08/2026 21:34:44(1787175284537) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.download_clip.download_report 19/08/2026 21:34:44(1787175284538) isProcedureExist proc_delete_channel 19/08/2026 21:34:44(1787175284539) isExists true 19/08/2026 21:34:44(1787175284561) alterTable vReturn 0 19/08/2026 21:34:44(1787175284561) isProcedureExist proc_delete_channel 19/08/2026 21:34:44(1787175284562) isExists false 19/08/2026 21:34:44(1787175284562) 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 19/08/2026 21:34:44(1787175284579) createProcedure vReturn 0 19/08/2026 21:34:44(1787175284580) ivms_30.v_ccc_email isTableExist: true 19/08/2026 21:34:44(1787175284580) exits v_ccc_email 19/08/2026 21:34:44(1787175284582) ivms_30.v_ccc_sop isTableExist: true 19/08/2026 21:34:44(1787175284582) exits v_ccc_sop 19/08/2026 21:34:44(1787175284582) ivms_30.v_ccc_phone isTableExist: true 19/08/2026 21:34:44(1787175284582) exits v_ccc_phone 19/08/2026 21:34:44(1787175284583) ivms_30.v_ccc_instruction isTableExist: true 19/08/2026 21:34:44(1787175284583) exits v_ccc_instruction 19/08/2026 21:34:44(1787175284584) ivms_30.v_ccc_incident isTableExist: true 19/08/2026 21:34:44(1787175284584) exits v_ccc_incident 19/08/2026 21:34:44(1787175284585) ivms_30.v_ccc_incident_url isTableExist: true 19/08/2026 21:34:44(1787175284585) exits v_ccc_incident_url 19/08/2026 21:34:44(1787175284585) isProcedureExist markEventClips 19/08/2026 21:34:44(1787175284586) isExists true 19/08/2026 21:34:44(1787175284599) alterTable vReturn 0 19/08/2026 21:34:44(1787175284599) isProcedureExist markEventClips 19/08/2026 21:34:44(1787175284601) isExists false 19/08/2026 21:34:44(1787175284601) 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 19/08/2026 21:34:44(1787175284613) createProcedure vReturn 0 19/08/2026 21:34:44(1787175284615) ivms_30.v_login_user isTableExist: true 19/08/2026 21:34:44(1787175284616) v_login_user.is_encrypted isColumnExists: true 19/08/2026 21:34:44(1787175284616) >>>>>>>>>> Columns Does Exist >>>>>>>>>> v_login_user.is_encrypted 19/08/2026 21:34:44(1787175284617) getAllUser vReturn 0 19/08/2026 21:34:44(1787175284617) ******Doing no encrypt to SHA_512_ENCRYPTION for user admin, Password(already encrypted):c7ad44cbad762a5da0a452f9e854fdc1e0e7a52a38015f23f3eab1d80b931dd472634dfac71cd34ebc35d16ab7fb8a90c81f975113d6c7538dc69dd8de9077ec, is_encrypted:2 19/08/2026 21:34:44(1787175284617) ******Doing no encrypt to SHA_512_ENCRYPTION for user cadmin@videonetics.com, Password(already encrypted):a5011d749c39bceb78cbb5d657c887ca9545867a0d2ed49534fc4fea8851505fa7e531b258892051909011d62128ec5e6c2d6f181418ca072b8603c0d0b25fca, is_encrypted:2 19/08/2026 21:34:44(1787175284617) ivms_30.v_marked_clip isTableExist: true 19/08/2026 21:34:44(1787175284618) exits v_marked_clip 19/08/2026 21:34:44(1787175284618) ivms_30.v_marked_clip isTableExist: true 19/08/2026 21:34:44(1787175284619) v_marked_clip.deleted_at isColumnExists: true 19/08/2026 21:34:44(1787175284620) ivms_30.v_preset isTableExist: true 19/08/2026 21:34:44(1787175284620) exits v_preset 19/08/2026 21:34:44(1787175284621) ivms_30.v_storage_vms isTableExist: true 19/08/2026 21:34:44(1787175284621) >>>>>>>>>>>>>>>>>>>>>> v_storage_vms Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_storage_vms.path 19/08/2026 21:34:44(1787175284636) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_storage_vms` CHANGE COLUMN `path` `path` VARCHAR(128) 19/08/2026 21:34:44(1787175284638) ivms_30.v_storage_ms isTableExist: true 19/08/2026 21:34:44(1787175284638) >>>>>>>>>>>>>>>>>>>>>> v_storage_ms Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_storage_ms.path 19/08/2026 21:34:44(1787175284660) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_storage_ms` CHANGE COLUMN `path` `path` VARCHAR(128) 19/08/2026 21:34:44(1787175284660) isProcedureExist alterClipTableAddStreamClipMode 19/08/2026 21:34:44(1787175284661) isExists true 19/08/2026 21:34:44(1787175284662) ivms_30.v_trajectory isTableExist: true 19/08/2026 21:34:44(1787175284662) exits v_trajectory 19/08/2026 21:34:44(1787175284663) ivms_30.v_heatmap isTableExist: true 19/08/2026 21:34:44(1787175284663) exits v_heatmap 19/08/2026 21:34:44(1787175284664) ivms_30.v_channel_param isTableExist: true 19/08/2026 21:34:44(1787175284664) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_channel_param.param_5 19/08/2026 21:34:44(1787175284683) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_channel_param` CHANGE COLUMN `param_5` `param_5` VARCHAR(128) 19/08/2026 21:34:44(1787175284684) ivms_30.v_media_server isTableExist: true 19/08/2026 21:34:44(1787175284685) v_media_server.server_type isColumnExists: true 19/08/2026 21:34:44(1787175284686) ivms_30.rl_ms_rms isTableExist: true 19/08/2026 21:34:44(1787175284686) exits rl_ms_rms 19/08/2026 21:34:44(1787175284687) ivms_30.rl_channel_media_server_fixed isTableExist: true 19/08/2026 21:34:44(1787175284687) exits rl_channel_media_server_fixed 19/08/2026 21:34:44(1787175284687) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:44(1787175284688) v_channel.analytic_url_multicast isColumnExists: true 19/08/2026 21:34:44(1787175284689) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:44(1787175284690) v_channel.minor_url_multicast isColumnExists: true 19/08/2026 21:34:44(1787175284690) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:44(1787175284691) v_channel.major_url_multicast isColumnExists: true 19/08/2026 21:34:44(1787175284692) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:44(1787175284693) v_channel.current_transmission isColumnExists: true 19/08/2026 21:34:44(1787175284693) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:44(1787175284694) v_channel.description isColumnExists: true 19/08/2026 21:34:44(1787175284695) ivms_30.v_event isTableExist: true 19/08/2026 21:34:44(1787175284695) v_event.object_property_1 isColumnExists: true 19/08/2026 21:34:44(1787175284695) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:44(1787175284849) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_1` `object_property_1` SMALLINT(6) NULL DEFAULT NULL 19/08/2026 21:34:44(1787175284850) ivms_30.v_event isTableExist: true 19/08/2026 21:34:44(1787175284851) v_event.object_property_2 isColumnExists: true 19/08/2026 21:34:44(1787175284851) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285019) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_2` `object_property_2` SMALLINT(6) NULL DEFAULT NULL 19/08/2026 21:34:45(1787175285020) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285021) v_event.object_property_3 isColumnExists: true 19/08/2026 21:34:45(1787175285021) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285187) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_3` `object_property_3` SMALLINT(6) NULL DEFAULT NULL 19/08/2026 21:34:45(1787175285188) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285189) v_event.object_property_4 isColumnExists: true 19/08/2026 21:34:45(1787175285189) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285354) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_4` `object_property_4` SMALLINT(6) NULL DEFAULT NULL 19/08/2026 21:34:45(1787175285355) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285355) v_event.object_property_5 isColumnExists: false 19/08/2026 21:34:45(1787175285355) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285398) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_5` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_4` 19/08/2026 21:34:45(1787175285399) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285400) v_event.object_property_6 isColumnExists: false 19/08/2026 21:34:45(1787175285400) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285444) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_6` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_5` 19/08/2026 21:34:45(1787175285444) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285445) v_event.object_property_7 isColumnExists: false 19/08/2026 21:34:45(1787175285445) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285483) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_7` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_6` 19/08/2026 21:34:45(1787175285484) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285485) v_event.object_property_8 isColumnExists: false 19/08/2026 21:34:45(1787175285485) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285534) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_8` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_7` 19/08/2026 21:34:45(1787175285535) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285536) v_event.object_property_9 isColumnExists: false 19/08/2026 21:34:45(1787175285536) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285577) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_9` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_8` 19/08/2026 21:34:45(1787175285579) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285579) v_event.object_property_10 isColumnExists: false 19/08/2026 21:34:45(1787175285579) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285627) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_10` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_9` 19/08/2026 21:34:45(1787175285628) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285629) v_event.object_property_11 isColumnExists: false 19/08/2026 21:34:45(1787175285629) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285675) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_11` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_10` 19/08/2026 21:34:45(1787175285676) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285677) v_event.object_property_12 isColumnExists: false 19/08/2026 21:34:45(1787175285677) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285720) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_12` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_11` 19/08/2026 21:34:45(1787175285722) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285723) v_event.object_property_13 isColumnExists: false 19/08/2026 21:34:45(1787175285723) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285770) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_13` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_12` 19/08/2026 21:34:45(1787175285771) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285772) v_event.object_property_14 isColumnExists: false 19/08/2026 21:34:45(1787175285772) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285809) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_14` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_13` 19/08/2026 21:34:45(1787175285811) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285812) v_event.object_property_15 isColumnExists: false 19/08/2026 21:34:45(1787175285812) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 19/08/2026 21:34:45(1787175285854) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_15` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_14` 19/08/2026 21:34:45(1787175285855) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285856) v_event.backup_state isColumnExists: true 19/08/2026 21:34:45(1787175285857) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285858) v_event.storage_path isColumnExists: true 19/08/2026 21:34:45(1787175285859) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285859) v_event.rec_server_id isColumnExists: true 19/08/2026 21:34:45(1787175285860) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:45(1787175285860) exits rl_channel_media_server_fixed 19/08/2026 21:34:45(1787175285860) isProcedureExist alterClipTableAddParallelRecording 19/08/2026 21:34:45(1787175285861) isExists true 19/08/2026 21:34:45(1787175285861) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:45(1787175285862) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285862) v_event.attribute isColumnExists: true 19/08/2026 21:34:45(1787175285863) ivms_30.v_network_storage isTableExist: true 19/08/2026 21:34:45(1787175285864) v_network_storage.STORAGE_CLASS_TYPE isColumnExists: true 19/08/2026 21:34:45(1787175285865) ivms_30.v_chat_message isTableExist: true 19/08/2026 21:34:45(1787175285865) exits v_chat_message 19/08/2026 21:34:45(1787175285866) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285866) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.event_message 19/08/2026 21:34:45(1787175285887) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `event_message` `event_message` VARCHAR(256) 19/08/2026 21:34:45(1787175285888) ivms_30.v_event isTableExist: true 19/08/2026 21:34:45(1787175285888) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.attribute 19/08/2026 21:34:45(1787175285930) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `attribute` `attribute` VARCHAR(512) 19/08/2026 21:34:45(1787175285930) ivms_30.v_group isTableExist: true 19/08/2026 21:34:45(1787175285931) v_group.name isColumnExists: true 19/08/2026 21:34:45(1787175285931) >>>>>>>>>>>>>>>>>>>>>> Columns Does Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_group.name 19/08/2026 21:34:45(1787175285932) ivms_30.v_location isTableExist: true 19/08/2026 21:34:45(1787175285932) v_location.name isColumnExists: true 19/08/2026 21:34:45(1787175285932) >>>>>>>>>>>>>>>>>>>>>> Columns Does Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_location.name 19/08/2026 21:34:45(1787175285934) ivms_30.v_login_user isTableExist: true 19/08/2026 21:34:45(1787175285934) v_login_user.password_history isColumnExists: true 19/08/2026 21:34:45(1787175285934) ivms_30.v_login_user isTableExist: true 19/08/2026 21:34:45(1787175285935) v_login_user.double_password isColumnExists: true 19/08/2026 21:34:45(1787175285935) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:45(1787175285935) v_channel.is_encrypted isColumnExists: true 19/08/2026 21:34:45(1787175285936) ivms_30.rl_channel_collection isTableExist: true 19/08/2026 21:34:45(1787175285936) >>>>>>>>>>>>>>>>>>>>>> PRIMARY KEY Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_collection.channel_id, rl_channel_collection.collection_id, rl_channel_collection.timestamp 19/08/2026 21:34:46(1787175286046) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`rl_channel_collection`ADD PRIMARY KEY(`channel_id`, `collection_id`, `timestamp`) 19/08/2026 21:34:46(1787175286048) ivms_30.rl_child_collection isTableExist: true 19/08/2026 21:34:46(1787175286048) >>>>>>>>>>>>>>>>>>>>>> PRIMARY KEY Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_child_collection.child_id, rl_child_collection.collection_id, rl_child_collection.timestamp 19/08/2026 21:34:46(1787175286159) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`rl_child_collection`ADD PRIMARY KEY(`child_id`, `collection_id`, `timestamp`) 19/08/2026 21:34:46(1787175286160) ivms_30.v_dr_details isTableExist: true 19/08/2026 21:34:46(1787175286160) does not exits v_dr_details 19/08/2026 21:34:46(1787175286161) ivms_30.v_data_safekeeping_configuration isTableExist: true 19/08/2026 21:34:46(1787175286161) does exist v_data_safekeeping_configuration 19/08/2026 21:34:46(1787175286162) ivms_30.v_business_continuity_recording_configuration isTableExist: true 19/08/2026 21:34:46(1787175286162) does exist v_business_continuity_recording_configuration 19/08/2026 21:34:46(1787175286163) ivms_30.v_business_continuity_analytics_configuration isTableExist: true 19/08/2026 21:34:46(1787175286163) does exist v_business_continuity_analytics_configuration 19/08/2026 21:34:46(1787175286164) ivms_30.db_query_logs isTableExist: true 19/08/2026 21:34:46(1787175286164) does not exits db_query_logs 19/08/2026 21:34:46(1787175286164) ivms_30.db_query_logs isTableExist: true 19/08/2026 21:34:46(1787175286165) db_query_logs.channel_id isColumnExists: true 19/08/2026 21:34:46(1787175286166) ivms_30.db_query_logs isTableExist: true 19/08/2026 21:34:46(1787175286166) db_query_logs.event_type isColumnExists: true 19/08/2026 21:34:46(1787175286167) ivms_30.v_collection isTableExist: true 19/08/2026 21:34:46(1787175286167) v_collection exist 19/08/2026 21:34:46(1787175286167) ivms_30.rl_channel_collection isTableExist: true 19/08/2026 21:34:46(1787175286167) rl_channel_collection exist 19/08/2026 21:34:46(1787175286168) ivms_30.rl_child_collection isTableExist: true 19/08/2026 21:34:46(1787175286168) rl_child_collection exist 19/08/2026 21:34:46(1787175286169) ivms_30.v_task_dc isTableExist: true 19/08/2026 21:34:46(1787175286169) v_task_dc exist 19/08/2026 21:34:46(1787175286169) ivms_30.v_task_dr isTableExist: true 19/08/2026 21:34:46(1787175286169) v_task_dr exist 19/08/2026 21:34:46(1787175286169) isProcedureExist alterClipTableAddDrFileFatchStatus 19/08/2026 21:34:46(1787175286170) isExists true 19/08/2026 21:34:46(1787175286170) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:46(1787175286170) isProcedureExist alterClipTableAddSecondaryId 19/08/2026 21:34:46(1787175286171) isExists true 19/08/2026 21:34:46(1787175286171) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 19/08/2026 21:34:46(1787175286172) ivms_30.v_event_snap isTableExist: true 19/08/2026 21:34:46(1787175286173) v_event_snap.dr_file_fatch_status isColumnExists: true 19/08/2026 21:34:46(1787175286173) ivms_30.v_alarm_action isTableExist: true 19/08/2026 21:34:46(1787175286174) v_alarm_action.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286175) ivms_30.v_alerm_listener_group isTableExist: true 19/08/2026 21:34:46(1787175286175) v_alerm_listener_group.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286176) ivms_30.v_analytic_server isTableExist: true 19/08/2026 21:34:46(1787175286177) v_analytic_server.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286177) ivms_30.v_ccc_email isTableExist: true 19/08/2026 21:34:46(1787175286178) v_ccc_email.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286178) ivms_30.v_ccc_incident isTableExist: true 19/08/2026 21:34:46(1787175286179) v_ccc_incident.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286180) ivms_30.v_ccc_incident_url isTableExist: true 19/08/2026 21:34:46(1787175286180) v_ccc_incident_url.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286181) ivms_30.v_ccc_instruction isTableExist: true 19/08/2026 21:34:46(1787175286181) v_ccc_instruction.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286182) ivms_30.v_ccc_phone isTableExist: true 19/08/2026 21:34:46(1787175286182) v_ccc_phone.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286183) ivms_30.v_ccc_sop isTableExist: true 19/08/2026 21:34:46(1787175286184) v_ccc_sop.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286185) ivms_30.v_channel_report_status isTableExist: true 19/08/2026 21:34:46(1787175286185) v_channel_report_status.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286186) ivms_30.v_channel_health_status isTableExist: true 19/08/2026 21:34:46(1787175286187) v_channel_health_status.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286188) ivms_30.v_chat_message isTableExist: true 19/08/2026 21:34:46(1787175286188) v_chat_message.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286189) ivms_30.v_vehicle_registry isTableExist: true 19/08/2026 21:34:46(1787175286190) v_vehicle_registry.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286191) ivms_30.v_event_channel_track isTableExist: true 19/08/2026 21:34:46(1787175286192) v_event_channel_track.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286192) ivms_30.v_event_snap isTableExist: true 19/08/2026 21:34:46(1787175286193) v_event_snap.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286194) ivms_30.v_event isTableExist: true 19/08/2026 21:34:46(1787175286195) v_event.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286195) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:46(1787175286196) v_external_device_registration.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286197) ivms_30.v_group isTableExist: true 19/08/2026 21:34:46(1787175286198) v_group.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286198) ivms_30.v_heatmap isTableExist: true 19/08/2026 21:34:46(1787175286199) v_heatmap.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286200) ivms_30.v_junction isTableExist: true 19/08/2026 21:34:46(1787175286200) v_junction.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286201) ivms_30.v_location isTableExist: true 19/08/2026 21:34:46(1787175286202) v_location.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286202) ivms_30.v_log isTableExist: true 19/08/2026 21:34:46(1787175286203) v_log.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286204) ivms_30.v_map isTableExist: true 19/08/2026 21:34:46(1787175286204) v_map.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286205) ivms_30.v_marked_clip isTableExist: true 19/08/2026 21:34:46(1787175286206) v_marked_clip.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286207) ivms_30.v_motion isTableExist: true 19/08/2026 21:34:46(1787175286207) v_motion.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286208) ivms_30.v_network_storage isTableExist: true 19/08/2026 21:34:46(1787175286209) v_network_storage.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286210) ivms_30.v_parking_monitoring isTableExist: false 19/08/2026 21:34:46(1787175286210) ivms_30.v_preset isTableExist: true 19/08/2026 21:34:46(1787175286211) v_preset.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286212) ivms_30.v_recording isTableExist: true 19/08/2026 21:34:46(1787175286212) v_recording.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286213) ivms_30.v_recycle_clip isTableExist: true 19/08/2026 21:34:46(1787175286214) v_recycle_clip.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286214) ivms_30.v_recyle_event_snap isTableExist: true 19/08/2026 21:34:46(1787175286215) v_recyle_event_snap.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286216) ivms_30.v_recycle_event isTableExist: true 19/08/2026 21:34:46(1787175286217) v_recycle_event.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286217) ivms_30.v_redundant_channel isTableExist: true 19/08/2026 21:34:46(1787175286218) v_redundant_channel.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286218) ivms_30.v_redundant_recording_clip isTableExist: true 19/08/2026 21:34:46(1787175286219) v_redundant_recording_clip.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286220) ivms_30.v_remote_recycle_upload isTableExist: true 19/08/2026 21:34:46(1787175286220) v_remote_recycle_upload.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286221) ivms_30.v_remote_upload isTableExist: true 19/08/2026 21:34:46(1787175286222) v_remote_upload.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286222) ivms_30.v_rlvd_temp isTableExist: true 19/08/2026 21:34:46(1787175286223) v_rlvd_temp.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286224) ivms_30.v_storage_ms isTableExist: true 19/08/2026 21:34:46(1787175286225) v_storage_ms.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286226) ivms_30.v_storage_vms isTableExist: true 19/08/2026 21:34:46(1787175286226) v_storage_vms.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286227) ivms_30.v_third_party_vms_server isTableExist: true 19/08/2026 21:34:46(1787175286228) v_third_party_vms_server.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286229) ivms_30.v_track_layout isTableExist: true 19/08/2026 21:34:46(1787175286229) v_track_layout.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286230) ivms_30.v_trajectory isTableExist: true 19/08/2026 21:34:46(1787175286231) v_trajectory.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286232) ivms_30.v_user_complain isTableExist: true 19/08/2026 21:34:46(1787175286232) v_user_complain.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286233) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286234) v_user_profile.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286234) ivms_30.v_network_storage isTableExist: true 19/08/2026 21:34:46(1787175286235) v_network_storage.REGION isColumnExists: true 19/08/2026 21:34:46(1787175286236) ivms_30.v_deletable_clip isTableExist: true 19/08/2026 21:34:46(1787175286237) v_deletable_clip.backup_state isColumnExists: true 19/08/2026 21:34:46(1787175286237) ivms_30.v_recycle_clip isTableExist: true 19/08/2026 21:34:46(1787175286238) v_recycle_clip.backup_state isColumnExists: true 19/08/2026 21:34:46(1787175286239) ivms_30.v_recycle_clip isTableExist: true 19/08/2026 21:34:46(1787175286239) v_recycle_clip.media_server_id isColumnExists: true 19/08/2026 21:34:46(1787175286240) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286240) exits v_external_device_configuration 19/08/2026 21:34:46(1787175286241) ivms_30.v_task_dc isTableExist: true 19/08/2026 21:34:46(1787175286241) v_task_dc.service_id isColumnExists: true 19/08/2026 21:34:46(1787175286242) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:46(1787175286243) v_external_device_registration.status isColumnExists: true 19/08/2026 21:34:46(1787175286244) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286244) v_external_device_configuration.status isColumnExists: true 19/08/2026 21:34:46(1787175286245) ivms_30.v_redundant_recording_clip isTableExist: true 19/08/2026 21:34:46(1787175286245) v_redundant_recording_clip.media_server_id isColumnExists: true 19/08/2026 21:34:46(1787175286246) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286247) v_external_device_configuration.snap_required isColumnExists: true 19/08/2026 21:34:46(1787175286247) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286248) v_external_device_configuration.snap_channel_id isColumnExists: true 19/08/2026 21:34:46(1787175286249) ivms_30.v_event_prepost_setting isTableExist: true 19/08/2026 21:34:46(1787175286249) exits v_external_device_configuration 19/08/2026 21:34:46(1787175286249) ivms_30.v_recording isTableExist: true 19/08/2026 21:34:46(1787175286250) v_recording.schedule_type isColumnExists: true 19/08/2026 21:34:46(1787175286250) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286251) v_external_device_configuration.secondary_id isColumnExists: true 19/08/2026 21:34:46(1787175286252) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:46(1787175286252) >>>>>>>>>>>>>>>>>>>>>> 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', '') 19/08/2026 21:34:46(1787175286275) insertTable vReturn 1002 19/08/2026 21:34:46(1787175286276) ivms_30.rl_channel_group isTableExist: true 19/08/2026 21:34:46(1787175286276) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_group INSERT INTO `ivms_30`.`rl_channel_group` (`channel_id`, `group_id`) VALUES ('-1', '1') 19/08/2026 21:34:46(1787175286277) insertTable vReturn 1002 19/08/2026 21:34:46(1787175286277) ivms_30.rl_channel_location isTableExist: true 19/08/2026 21:34:46(1787175286277) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_location INSERT INTO `ivms_30`.`rl_channel_location` (`channel_id`, `location_id`) VALUES ('-1', '1') 19/08/2026 21:34:46(1787175286279) insertTable vReturn 1002 19/08/2026 21:34:46(1787175286279) ivms_30.rl_channel_recording isTableExist: true 19/08/2026 21:34:46(1787175286279) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_recording INSERT INTO `ivms_30`.`rl_channel_recording` (`channel_id`, `recording_id`) VALUES ('-1', '1') 19/08/2026 21:34:46(1787175286281) insertTable vReturn 1002 19/08/2026 21:34:46(1787175286282) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:46(1787175286282) v_channel.protocol isColumnExists: true 19/08/2026 21:34:46(1787175286283) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:46(1787175286283) v_channel.channel_index isColumnExists: true 19/08/2026 21:34:46(1787175286284) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:46(1787175286285) v_channel.is_secured isColumnExists: true 19/08/2026 21:34:46(1787175286285) ivms_30.v_redundant_recording_clip isTableExist: true 19/08/2026 21:34:46(1787175286286) v_redundant_recording_clip.end_timestamp isColumnExists: true 19/08/2026 21:34:46(1787175286287) ivms_30.v_redundant_recording_clip isTableExist: true 19/08/2026 21:34:46(1787175286288) v_redundant_recording_clip.is_secured isColumnExists: false 19/08/2026 21:34:46(1787175286288) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_redundant_recording_clip.is_secured 19/08/2026 21:34:46(1787175286289) alterTable vReturn 1002 Query :ALTER TABLE `ivms_30`.`v_redundant_recording_clip` ADD COLUMN `clip_size` BIGINT(20) NOT NULL DEFAULT '0' 19/08/2026 21:34:46(1787175286290) ivms_30.v_collection isTableExist: true 19/08/2026 21:34:46(1787175286291) v_collection.description isColumnExists: true 19/08/2026 21:34:46(1787175286291) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_redundant_recording_clip.is_secured 19/08/2026 21:34:46(1787175286309) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_collection` CHANGE COLUMN `description` `description` VARCHAR(12288) NULL DEFAULT NULL 19/08/2026 21:34:46(1787175286310) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:46(1787175286310) v_external_device_registration.camera_association_mode isColumnExists: true 19/08/2026 21:34:46(1787175286311) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:46(1787175286311) v_external_device_registration.number_fixed_cam_to_associate isColumnExists: true 19/08/2026 21:34:46(1787175286312) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:46(1787175286313) v_external_device_registration.ip isColumnExists: true 19/08/2026 21:34:46(1787175286313) exits v_external_device_registration 19/08/2026 21:34:46(1787175286442) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:46(1787175286443) v_external_device_registration.number_ptz_cam_to_associate isColumnExists: true 19/08/2026 21:34:46(1787175286443) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:46(1787175286444) v_external_device_registration.fixed_camera_dictance_to_associat isColumnExists: true 19/08/2026 21:34:46(1787175286445) ivms_30.v_external_device_registration isTableExist: true 19/08/2026 21:34:46(1787175286445) v_external_device_registration.ptz_camera_dictance_to_associat isColumnExists: true 19/08/2026 21:34:46(1787175286446) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286447) v_external_device_configuration.associate_channels isColumnExists: true 19/08/2026 21:34:46(1787175286447) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286448) v_external_device_configuration.zone_id isColumnExists: true 19/08/2026 21:34:46(1787175286449) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286449) v_external_device_configuration.location_id isColumnExists: true 19/08/2026 21:34:46(1787175286450) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286450) v_external_device_configuration.controller_id isColumnExists: true 19/08/2026 21:34:46(1787175286451) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286452) v_external_device_configuration.pos_x isColumnExists: true 19/08/2026 21:34:46(1787175286452) ivms_30.v_external_device_configuration isTableExist: true 19/08/2026 21:34:46(1787175286453) v_external_device_configuration.pos_y isColumnExists: true 19/08/2026 21:34:46(1787175286453) ivms_30.v_external_device_controller isTableExist: true 19/08/2026 21:34:46(1787175286453) exits v_external_device_controller 19/08/2026 21:34:46(1787175286454) ivms_30.v_external_device_location isTableExist: true 19/08/2026 21:34:46(1787175286454) exits v_external_device_location 19/08/2026 21:34:46(1787175286455) ivms_30.v_external_device_zone isTableExist: true 19/08/2026 21:34:46(1787175286455) exits v_external_device_zone 19/08/2026 21:34:46(1787175286455) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286456) v_user_profile.unmasked_live_play isColumnExists: true 19/08/2026 21:34:46(1787175286457) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286457) v_user_profile.unmasked_archive_play isColumnExists: true 19/08/2026 21:34:46(1787175286458) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286458) v_user_profile.unmasked_clip_download isColumnExists: true 19/08/2026 21:34:46(1787175286459) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286460) v_user_profile.unmasked_live_play isColumnExists: true 19/08/2026 21:34:46(1787175286460) v_user_profile.unmasked_archive_play isColumnExists: true 19/08/2026 21:34:46(1787175286461) v_user_profile.unmasked_clip_download isColumnExists: true 19/08/2026 21:34:46(1787175286461) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.download_clip.unmasked_live_play 19/08/2026 21:34:46(1787175286462) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286463) v_user_profile.event_management isColumnExists: true 19/08/2026 21:34:46(1787175286464) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286464) v_user_profile.system_configuration isColumnExists: true 19/08/2026 21:34:46(1787175286465) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286466) v_user_profile.system_settings isColumnExists: true 19/08/2026 21:34:46(1787175286466) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286467) v_user_profile.bookmarks isColumnExists: true 19/08/2026 21:34:46(1787175286468) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286468) v_user_profile.maps isColumnExists: true 19/08/2026 21:34:46(1787175286469) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286469) v_user_profile.external_systems isColumnExists: true 19/08/2026 21:34:46(1787175286470) ivms_30.v_user_profile isTableExist: true 19/08/2026 21:34:46(1787175286470) v_user_profile.event_management isColumnExists: true 19/08/2026 21:34:46(1787175286471) v_user_profile.system_configuration isColumnExists: true 19/08/2026 21:34:46(1787175286472) v_user_profile.system_settings isColumnExists: true 19/08/2026 21:34:46(1787175286472) v_user_profile.bookmarks isColumnExists: true 19/08/2026 21:34:46(1787175286473) v_user_profile.maps isColumnExists: true 19/08/2026 21:34:46(1787175286473) v_user_profile.external_systems isColumnExists: true 19/08/2026 21:34:46(1787175286473) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.event_management 19/08/2026 21:34:46(1787175286474) ivms_30.v_user_restriction isTableExist: true 19/08/2026 21:34:46(1787175286474) exits v_user_restriction 19/08/2026 21:34:46(1787175286492) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:46(1787175286493) v_channel.grabber_library isColumnExists: true 19/08/2026 21:34:46(1787175286493) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:46(1787175286494) v_channel.grabbing_protocol isColumnExists: true 19/08/2026 21:34:46(1787175286495) ivms_30.v_channel isTableExist: true 19/08/2026 21:34:46(1787175286495) v_channel.audio_grabbing isColumnExists: true 19/08/2026 21:34:46(1787175286495) >>>>>>>>>>>>>>>>>> MYSQL DATABASE PROCEDURE UPDATION END <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<