12/08/2026 21:09:04(1786568944516) 12/08/2026 21:09:04(1786568944516) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> MYSQL DATABASE UPGRADATION STARTED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:04(1786568944516) 12/08/2026 21:09:04(1786568944516) 12/08/2026 21:09:04(1786568944516) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> MYSQL DATABASE UPGRADATION STARTED (1050 to 1250) <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:04(1786568944516) >>>>>>>>>>>>>>>>>> MYSQL DATABASE TABLE UPDATION START <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:04(1786568944817) ivms_30.v_channel_health_status isTableExist: true 12/08/2026 21:09:04(1786568944818) ivms_30.v_channel_report_status isTableExist: true 12/08/2026 21:09:04(1786568944818) >>>>>>>>>>>>>>>>>> MYSQL DATABASE TABLE UPDATION END <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:04(1786568944818) >>>>>>>>>>>>>>>>>> MYSQL DATABASE ALTER UPDATION STARTED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:04(1786568944835) v_recycle_clip.junk_flag isColumnExists: true 12/08/2026 21:09:04(1786568944835) >>>>>>>>>>>>>>>>>> MYSQL DATABASE ALTER UPDATION ENDED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:04(1786568944835) >>>>>>>>>>>>>>>>>> MYSQL DATABASE PROCEDURE UPDATION START <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:04(1786568944835) isProcedureExist getRecordingDetailsByChannel 12/08/2026 21:09:04(1786568944837) isExists true 12/08/2026 21:09:04(1786568944845) alterTable vReturn 0 12/08/2026 21:09:04(1786568944845) isProcedureExist getRecordingDetailsByChannel 12/08/2026 21:09:04(1786568944846) isExists false 12/08/2026 21:09:04(1786568944846) 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 12/08/2026 21:09:04(1786568944851) createProcedure vReturn 0 12/08/2026 21:09:04(1786568944851) isProcedureExist updateChannelHealthStatusAndReport 12/08/2026 21:09:04(1786568944852) isExists true 12/08/2026 21:09:04(1786568944853) ivms_30.v_track_layout isTableExist: true 12/08/2026 21:09:04(1786568944853) exits v_track_layout 12/08/2026 21:09:04(1786568944853) ivms_30.v_event_channel_track isTableExist: true 12/08/2026 21:09:04(1786568944853) exits v_event_channel_track 12/08/2026 21:09:04(1786568944853) isProcedureExist alterClipTable 12/08/2026 21:09:04(1786568944854) isExists true 12/08/2026 21:09:04(1786568944854) >>>>>>>>>>>>>>>>>> DATABASE PROCEDURE UPDATION ENDED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:04(1786568944855) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:04(1786568944856) v_channel.is_deleted isColumnExists: true 12/08/2026 21:09:04(1786568944857) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:04(1786568944859) v_channel.delete_timestamp isColumnExists: true 12/08/2026 21:09:04(1786568944860) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:04(1786568944862) v_user_profile.download_clip isColumnExists: true 12/08/2026 21:09:04(1786568944863) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:04(1786568944865) v_user_profile.download_report isColumnExists: true 12/08/2026 21:09:04(1786568944867) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:04(1786568944868) v_user_profile.download_clip isColumnExists: true 12/08/2026 21:09:04(1786568944870) v_user_profile.download_report isColumnExists: true 12/08/2026 21:09:04(1786568944870) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.download_clip.download_report 12/08/2026 21:09:04(1786568944872) isProcedureExist proc_delete_channel 12/08/2026 21:09:04(1786568944873) isExists true 12/08/2026 21:09:04(1786568944880) alterTable vReturn 0 12/08/2026 21:09:04(1786568944880) isProcedureExist proc_delete_channel 12/08/2026 21:09:04(1786568944882) isExists false 12/08/2026 21:09:04(1786568944883) 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 12/08/2026 21:09:04(1786568944895) createProcedure vReturn 0 12/08/2026 21:09:04(1786568944897) ivms_30.v_ccc_email isTableExist: true 12/08/2026 21:09:04(1786568944897) exits v_ccc_email 12/08/2026 21:09:04(1786568944899) ivms_30.v_ccc_sop isTableExist: true 12/08/2026 21:09:04(1786568944899) exits v_ccc_sop 12/08/2026 21:09:04(1786568944901) ivms_30.v_ccc_phone isTableExist: true 12/08/2026 21:09:04(1786568944901) exits v_ccc_phone 12/08/2026 21:09:04(1786568944903) ivms_30.v_ccc_instruction isTableExist: true 12/08/2026 21:09:04(1786568944903) exits v_ccc_instruction 12/08/2026 21:09:04(1786568944905) ivms_30.v_ccc_incident isTableExist: true 12/08/2026 21:09:04(1786568944905) exits v_ccc_incident 12/08/2026 21:09:04(1786568944907) ivms_30.v_ccc_incident_url isTableExist: true 12/08/2026 21:09:04(1786568944907) exits v_ccc_incident_url 12/08/2026 21:09:04(1786568944907) isProcedureExist markEventClips 12/08/2026 21:09:04(1786568944909) isExists true 12/08/2026 21:09:04(1786568944916) alterTable vReturn 0 12/08/2026 21:09:04(1786568944916) isProcedureExist markEventClips 12/08/2026 21:09:04(1786568944918) isExists false 12/08/2026 21:09:04(1786568944918) 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 12/08/2026 21:09:04(1786568944931) createProcedure vReturn 0 12/08/2026 21:09:04(1786568944933) ivms_30.v_login_user isTableExist: true 12/08/2026 21:09:04(1786568944936) v_login_user.is_encrypted isColumnExists: true 12/08/2026 21:09:04(1786568944936) >>>>>>>>>> Columns Does Exist >>>>>>>>>> v_login_user.is_encrypted 12/08/2026 21:09:04(1786568944937) getAllUser vReturn 0 12/08/2026 21:09:04(1786568944938) ******Doing no encrypt to SHA_512_ENCRYPTION for user admin, Password(already encrypted):c7ad44cbad762a5da0a452f9e854fdc1e0e7a52a38015f23f3eab1d80b931dd472634dfac71cd34ebc35d16ab7fb8a90c81f975113d6c7538dc69dd8de9077ec, is_encrypted:2 12/08/2026 21:09:04(1786568944938) ******Doing no encrypt to SHA_512_ENCRYPTION for user cadmin@videonetics.com, Password(already encrypted):a5011d749c39bceb78cbb5d657c887ca9545867a0d2ed49534fc4fea8851505fa7e531b258892051909011d62128ec5e6c2d6f181418ca072b8603c0d0b25fca, is_encrypted:2 12/08/2026 21:09:04(1786568944940) ivms_30.v_marked_clip isTableExist: true 12/08/2026 21:09:04(1786568944940) exits v_marked_clip 12/08/2026 21:09:04(1786568944941) ivms_30.v_marked_clip isTableExist: true 12/08/2026 21:09:04(1786568944943) v_marked_clip.deleted_at isColumnExists: true 12/08/2026 21:09:04(1786568944945) ivms_30.v_preset isTableExist: true 12/08/2026 21:09:04(1786568944945) exits v_preset 12/08/2026 21:09:04(1786568944946) ivms_30.v_storage_vms isTableExist: true 12/08/2026 21:09:04(1786568944946) >>>>>>>>>>>>>>>>>>>>>> v_storage_vms Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_storage_vms.path 12/08/2026 21:09:04(1786568944959) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_storage_vms` CHANGE COLUMN `path` `path` VARCHAR(128) 12/08/2026 21:09:04(1786568944961) ivms_30.v_storage_ms isTableExist: true 12/08/2026 21:09:04(1786568944961) >>>>>>>>>>>>>>>>>>>>>> v_storage_ms Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_storage_ms.path 12/08/2026 21:09:04(1786568944973) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_storage_ms` CHANGE COLUMN `path` `path` VARCHAR(128) 12/08/2026 21:09:04(1786568944973) isProcedureExist alterClipTableAddStreamClipMode 12/08/2026 21:09:04(1786568944975) isExists true 12/08/2026 21:09:04(1786568944977) ivms_30.v_trajectory isTableExist: true 12/08/2026 21:09:04(1786568944977) exits v_trajectory 12/08/2026 21:09:04(1786568944979) ivms_30.v_heatmap isTableExist: true 12/08/2026 21:09:04(1786568944979) exits v_heatmap 12/08/2026 21:09:04(1786568944981) ivms_30.v_channel_param isTableExist: true 12/08/2026 21:09:04(1786568944981) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_channel_param.param_5 12/08/2026 21:09:04(1786568944995) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_channel_param` CHANGE COLUMN `param_5` `param_5` VARCHAR(128) 12/08/2026 21:09:04(1786568944997) ivms_30.v_media_server isTableExist: true 12/08/2026 21:09:04(1786568944999) v_media_server.server_type isColumnExists: true 12/08/2026 21:09:05(1786568945001) ivms_30.rl_ms_rms isTableExist: true 12/08/2026 21:09:05(1786568945001) exits rl_ms_rms 12/08/2026 21:09:05(1786568945003) ivms_30.rl_channel_media_server_fixed isTableExist: true 12/08/2026 21:09:05(1786568945003) exits rl_channel_media_server_fixed 12/08/2026 21:09:05(1786568945005) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:05(1786568945007) v_channel.analytic_url_multicast isColumnExists: true 12/08/2026 21:09:05(1786568945009) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:05(1786568945011) v_channel.minor_url_multicast isColumnExists: true 12/08/2026 21:09:05(1786568945013) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:05(1786568945014) v_channel.major_url_multicast isColumnExists: true 12/08/2026 21:09:05(1786568945016) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:05(1786568945017) v_channel.current_transmission isColumnExists: true 12/08/2026 21:09:05(1786568945019) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:05(1786568945020) v_channel.description isColumnExists: true 12/08/2026 21:09:05(1786568945022) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945023) v_event.object_property_1 isColumnExists: true 12/08/2026 21:09:05(1786568945023) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945098) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_1` `object_property_1` SMALLINT(6) NULL DEFAULT NULL 12/08/2026 21:09:05(1786568945100) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945101) v_event.object_property_2 isColumnExists: true 12/08/2026 21:09:05(1786568945101) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945186) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_2` `object_property_2` SMALLINT(6) NULL DEFAULT NULL 12/08/2026 21:09:05(1786568945187) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945189) v_event.object_property_3 isColumnExists: true 12/08/2026 21:09:05(1786568945189) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945276) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_3` `object_property_3` SMALLINT(6) NULL DEFAULT NULL 12/08/2026 21:09:05(1786568945277) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945279) v_event.object_property_4 isColumnExists: true 12/08/2026 21:09:05(1786568945279) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945368) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `object_property_4` `object_property_4` SMALLINT(6) NULL DEFAULT NULL 12/08/2026 21:09:05(1786568945370) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945373) v_event.object_property_5 isColumnExists: false 12/08/2026 21:09:05(1786568945373) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945407) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_5` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_4` 12/08/2026 21:09:05(1786568945410) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945412) v_event.object_property_6 isColumnExists: false 12/08/2026 21:09:05(1786568945412) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945436) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_6` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_5` 12/08/2026 21:09:05(1786568945436) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945437) v_event.object_property_7 isColumnExists: false 12/08/2026 21:09:05(1786568945437) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945454) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_7` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_6` 12/08/2026 21:09:05(1786568945455) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945455) v_event.object_property_8 isColumnExists: false 12/08/2026 21:09:05(1786568945455) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945472) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_8` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_7` 12/08/2026 21:09:05(1786568945472) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945472) v_event.object_property_9 isColumnExists: false 12/08/2026 21:09:05(1786568945472) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945488) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_9` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_8` 12/08/2026 21:09:05(1786568945488) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945488) v_event.object_property_10 isColumnExists: false 12/08/2026 21:09:05(1786568945488) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945508) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_10` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_9` 12/08/2026 21:09:05(1786568945508) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945509) v_event.object_property_11 isColumnExists: false 12/08/2026 21:09:05(1786568945509) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945525) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_11` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_10` 12/08/2026 21:09:05(1786568945526) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945526) v_event.object_property_12 isColumnExists: false 12/08/2026 21:09:05(1786568945526) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945544) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_12` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_11` 12/08/2026 21:09:05(1786568945544) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945545) v_event.object_property_13 isColumnExists: false 12/08/2026 21:09:05(1786568945545) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945568) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_13` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_12` 12/08/2026 21:09:05(1786568945570) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945571) v_event.object_property_14 isColumnExists: false 12/08/2026 21:09:05(1786568945571) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945604) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_14` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_13` 12/08/2026 21:09:05(1786568945605) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945607) v_event.object_property_15 isColumnExists: false 12/08/2026 21:09:05(1786568945607) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.backup_state 12/08/2026 21:09:05(1786568945637) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` ADD COLUMN `object_property_15` SMALLINT(6) NULL DEFAULT NULL AFTER `object_property_14` 12/08/2026 21:09:05(1786568945639) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945641) v_event.backup_state isColumnExists: true 12/08/2026 21:09:05(1786568945642) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945644) v_event.storage_path isColumnExists: true 12/08/2026 21:09:05(1786568945646) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945647) v_event.rec_server_id isColumnExists: true 12/08/2026 21:09:05(1786568945648) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:05(1786568945648) exits rl_channel_media_server_fixed 12/08/2026 21:09:05(1786568945648) isProcedureExist alterClipTableAddParallelRecording 12/08/2026 21:09:05(1786568945649) isExists true 12/08/2026 21:09:05(1786568945649) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:05(1786568945651) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945652) v_event.attribute isColumnExists: true 12/08/2026 21:09:05(1786568945653) ivms_30.v_network_storage isTableExist: true 12/08/2026 21:09:05(1786568945655) v_network_storage.STORAGE_CLASS_TYPE isColumnExists: true 12/08/2026 21:09:05(1786568945656) ivms_30.v_chat_message isTableExist: true 12/08/2026 21:09:05(1786568945656) exits v_chat_message 12/08/2026 21:09:05(1786568945658) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945658) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.event_message 12/08/2026 21:09:05(1786568945680) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `event_message` `event_message` VARCHAR(256) 12/08/2026 21:09:05(1786568945682) ivms_30.v_event isTableExist: true 12/08/2026 21:09:05(1786568945682) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_event.attribute 12/08/2026 21:09:05(1786568945714) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_event` CHANGE COLUMN `attribute` `attribute` VARCHAR(512) 12/08/2026 21:09:05(1786568945716) ivms_30.v_group isTableExist: true 12/08/2026 21:09:05(1786568945718) v_group.name isColumnExists: true 12/08/2026 21:09:05(1786568945718) >>>>>>>>>>>>>>>>>>>>>> Columns Does Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_group.name 12/08/2026 21:09:05(1786568945721) ivms_30.v_location isTableExist: true 12/08/2026 21:09:05(1786568945723) v_location.name isColumnExists: true 12/08/2026 21:09:05(1786568945723) >>>>>>>>>>>>>>>>>>>>>> Columns Does Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_location.name 12/08/2026 21:09:05(1786568945729) ivms_30.v_login_user isTableExist: true 12/08/2026 21:09:05(1786568945731) v_login_user.password_history isColumnExists: true 12/08/2026 21:09:05(1786568945733) ivms_30.v_login_user isTableExist: true 12/08/2026 21:09:05(1786568945734) v_login_user.double_password isColumnExists: true 12/08/2026 21:09:05(1786568945736) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:05(1786568945738) v_channel.is_encrypted isColumnExists: true 12/08/2026 21:09:05(1786568945739) ivms_30.rl_channel_collection isTableExist: true 12/08/2026 21:09:05(1786568945740) >>>>>>>>>>>>>>>>>>>>>> PRIMARY KEY Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_collection.channel_id, rl_channel_collection.collection_id, rl_channel_collection.timestamp 12/08/2026 21:09:05(1786568945850) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`rl_channel_collection`ADD PRIMARY KEY(`channel_id`, `collection_id`, `timestamp`) 12/08/2026 21:09:05(1786568945852) ivms_30.rl_child_collection isTableExist: true 12/08/2026 21:09:05(1786568945852) >>>>>>>>>>>>>>>>>>>>>> PRIMARY KEY Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_child_collection.child_id, rl_child_collection.collection_id, rl_child_collection.timestamp 12/08/2026 21:09:05(1786568945925) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`rl_child_collection`ADD PRIMARY KEY(`child_id`, `collection_id`, `timestamp`) 12/08/2026 21:09:05(1786568945927) ivms_30.v_dr_details isTableExist: true 12/08/2026 21:09:05(1786568945927) does not exits v_dr_details 12/08/2026 21:09:05(1786568945929) ivms_30.v_data_safekeeping_configuration isTableExist: true 12/08/2026 21:09:05(1786568945930) does exist v_data_safekeeping_configuration 12/08/2026 21:09:05(1786568945932) ivms_30.v_business_continuity_recording_configuration isTableExist: true 12/08/2026 21:09:05(1786568945932) does exist v_business_continuity_recording_configuration 12/08/2026 21:09:05(1786568945934) ivms_30.v_business_continuity_analytics_configuration isTableExist: true 12/08/2026 21:09:05(1786568945934) does exist v_business_continuity_analytics_configuration 12/08/2026 21:09:05(1786568945936) ivms_30.db_query_logs isTableExist: true 12/08/2026 21:09:05(1786568945936) does not exits db_query_logs 12/08/2026 21:09:05(1786568945938) ivms_30.db_query_logs isTableExist: true 12/08/2026 21:09:05(1786568945940) db_query_logs.channel_id isColumnExists: true 12/08/2026 21:09:05(1786568945942) ivms_30.db_query_logs isTableExist: true 12/08/2026 21:09:05(1786568945943) db_query_logs.event_type isColumnExists: true 12/08/2026 21:09:05(1786568945945) ivms_30.v_collection isTableExist: true 12/08/2026 21:09:05(1786568945945) v_collection exist 12/08/2026 21:09:05(1786568945947) ivms_30.rl_channel_collection isTableExist: true 12/08/2026 21:09:05(1786568945947) rl_channel_collection exist 12/08/2026 21:09:05(1786568945949) ivms_30.rl_child_collection isTableExist: true 12/08/2026 21:09:05(1786568945949) rl_child_collection exist 12/08/2026 21:09:05(1786568945950) ivms_30.v_task_dc isTableExist: true 12/08/2026 21:09:05(1786568945950) v_task_dc exist 12/08/2026 21:09:05(1786568945952) ivms_30.v_task_dr isTableExist: true 12/08/2026 21:09:05(1786568945952) v_task_dr exist 12/08/2026 21:09:05(1786568945952) isProcedureExist alterClipTableAddDrFileFatchStatus 12/08/2026 21:09:05(1786568945955) isExists true 12/08/2026 21:09:05(1786568945955) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:05(1786568945955) isProcedureExist alterClipTableAddSecondaryId 12/08/2026 21:09:05(1786568945956) isExists true 12/08/2026 21:09:05(1786568945957) >>>>>>>>>>>>>>>>>>>>>> alterClipTableAddParallelRecording procedure Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< 12/08/2026 21:09:05(1786568945958) ivms_30.v_event_snap isTableExist: true 12/08/2026 21:09:05(1786568945960) v_event_snap.dr_file_fatch_status isColumnExists: true 12/08/2026 21:09:05(1786568945962) ivms_30.v_alarm_action isTableExist: true 12/08/2026 21:09:05(1786568945963) v_alarm_action.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945964) ivms_30.v_alerm_listener_group isTableExist: true 12/08/2026 21:09:05(1786568945966) v_alerm_listener_group.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945967) ivms_30.v_analytic_server isTableExist: true 12/08/2026 21:09:05(1786568945969) v_analytic_server.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945970) ivms_30.v_ccc_email isTableExist: true 12/08/2026 21:09:05(1786568945972) v_ccc_email.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945974) ivms_30.v_ccc_incident isTableExist: true 12/08/2026 21:09:05(1786568945975) v_ccc_incident.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945977) ivms_30.v_ccc_incident_url isTableExist: true 12/08/2026 21:09:05(1786568945978) v_ccc_incident_url.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945980) ivms_30.v_ccc_instruction isTableExist: true 12/08/2026 21:09:05(1786568945981) v_ccc_instruction.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945982) ivms_30.v_ccc_phone isTableExist: true 12/08/2026 21:09:05(1786568945985) v_ccc_phone.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945987) ivms_30.v_ccc_sop isTableExist: true 12/08/2026 21:09:05(1786568945989) v_ccc_sop.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945991) ivms_30.v_channel_report_status isTableExist: true 12/08/2026 21:09:05(1786568945992) v_channel_report_status.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945994) ivms_30.v_channel_health_status isTableExist: true 12/08/2026 21:09:05(1786568945995) v_channel_health_status.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945996) ivms_30.v_chat_message isTableExist: true 12/08/2026 21:09:05(1786568945997) v_chat_message.secondary_id isColumnExists: true 12/08/2026 21:09:05(1786568945998) ivms_30.v_vehicle_registry isTableExist: true 12/08/2026 21:09:05(1786568945999) v_vehicle_registry.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946000) ivms_30.v_event_channel_track isTableExist: true 12/08/2026 21:09:06(1786568946001) v_event_channel_track.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946002) ivms_30.v_event_snap isTableExist: true 12/08/2026 21:09:06(1786568946003) v_event_snap.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946003) ivms_30.v_event isTableExist: true 12/08/2026 21:09:06(1786568946004) v_event.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946005) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:06(1786568946005) v_external_device_registration.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946006) ivms_30.v_group isTableExist: true 12/08/2026 21:09:06(1786568946006) v_group.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946006) ivms_30.v_heatmap isTableExist: true 12/08/2026 21:09:06(1786568946007) v_heatmap.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946007) ivms_30.v_junction isTableExist: true 12/08/2026 21:09:06(1786568946007) v_junction.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946008) ivms_30.v_location isTableExist: true 12/08/2026 21:09:06(1786568946008) v_location.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946008) ivms_30.v_log isTableExist: true 12/08/2026 21:09:06(1786568946009) v_log.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946009) ivms_30.v_map isTableExist: true 12/08/2026 21:09:06(1786568946009) v_map.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946010) ivms_30.v_marked_clip isTableExist: true 12/08/2026 21:09:06(1786568946010) v_marked_clip.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946010) ivms_30.v_motion isTableExist: true 12/08/2026 21:09:06(1786568946011) v_motion.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946011) ivms_30.v_network_storage isTableExist: true 12/08/2026 21:09:06(1786568946011) v_network_storage.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946012) ivms_30.v_parking_monitoring isTableExist: false 12/08/2026 21:09:06(1786568946012) ivms_30.v_preset isTableExist: true 12/08/2026 21:09:06(1786568946012) v_preset.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946013) ivms_30.v_recording isTableExist: true 12/08/2026 21:09:06(1786568946013) v_recording.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946013) ivms_30.v_recycle_clip isTableExist: true 12/08/2026 21:09:06(1786568946014) v_recycle_clip.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946014) ivms_30.v_recyle_event_snap isTableExist: true 12/08/2026 21:09:06(1786568946014) v_recyle_event_snap.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946015) ivms_30.v_recycle_event isTableExist: true 12/08/2026 21:09:06(1786568946015) v_recycle_event.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946015) ivms_30.v_redundant_channel isTableExist: true 12/08/2026 21:09:06(1786568946016) v_redundant_channel.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946016) ivms_30.v_redundant_recording_clip isTableExist: true 12/08/2026 21:09:06(1786568946016) v_redundant_recording_clip.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946017) ivms_30.v_remote_recycle_upload isTableExist: true 12/08/2026 21:09:06(1786568946017) v_remote_recycle_upload.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946018) ivms_30.v_remote_upload isTableExist: true 12/08/2026 21:09:06(1786568946018) v_remote_upload.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946018) ivms_30.v_rlvd_temp isTableExist: true 12/08/2026 21:09:06(1786568946019) v_rlvd_temp.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946019) ivms_30.v_storage_ms isTableExist: true 12/08/2026 21:09:06(1786568946020) v_storage_ms.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946020) ivms_30.v_storage_vms isTableExist: true 12/08/2026 21:09:06(1786568946020) v_storage_vms.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946021) ivms_30.v_third_party_vms_server isTableExist: true 12/08/2026 21:09:06(1786568946021) v_third_party_vms_server.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946022) ivms_30.v_track_layout isTableExist: true 12/08/2026 21:09:06(1786568946022) v_track_layout.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946023) ivms_30.v_trajectory isTableExist: true 12/08/2026 21:09:06(1786568946023) v_trajectory.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946024) ivms_30.v_user_complain isTableExist: true 12/08/2026 21:09:06(1786568946024) v_user_complain.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946025) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946025) v_user_profile.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946026) ivms_30.v_network_storage isTableExist: true 12/08/2026 21:09:06(1786568946027) v_network_storage.REGION isColumnExists: true 12/08/2026 21:09:06(1786568946028) ivms_30.v_deletable_clip isTableExist: true 12/08/2026 21:09:06(1786568946029) v_deletable_clip.backup_state isColumnExists: true 12/08/2026 21:09:06(1786568946029) ivms_30.v_recycle_clip isTableExist: true 12/08/2026 21:09:06(1786568946030) v_recycle_clip.backup_state isColumnExists: true 12/08/2026 21:09:06(1786568946031) ivms_30.v_recycle_clip isTableExist: true 12/08/2026 21:09:06(1786568946031) v_recycle_clip.media_server_id isColumnExists: true 12/08/2026 21:09:06(1786568946032) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946032) exits v_external_device_configuration 12/08/2026 21:09:06(1786568946033) ivms_30.v_task_dc isTableExist: true 12/08/2026 21:09:06(1786568946033) v_task_dc.service_id isColumnExists: true 12/08/2026 21:09:06(1786568946033) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:06(1786568946034) v_external_device_registration.status isColumnExists: true 12/08/2026 21:09:06(1786568946034) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946034) v_external_device_configuration.status isColumnExists: true 12/08/2026 21:09:06(1786568946034) ivms_30.v_redundant_recording_clip isTableExist: true 12/08/2026 21:09:06(1786568946035) v_redundant_recording_clip.media_server_id isColumnExists: true 12/08/2026 21:09:06(1786568946035) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946035) v_external_device_configuration.snap_required isColumnExists: true 12/08/2026 21:09:06(1786568946036) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946036) v_external_device_configuration.snap_channel_id isColumnExists: true 12/08/2026 21:09:06(1786568946036) ivms_30.v_event_prepost_setting isTableExist: true 12/08/2026 21:09:06(1786568946036) exits v_external_device_configuration 12/08/2026 21:09:06(1786568946036) ivms_30.v_recording isTableExist: true 12/08/2026 21:09:06(1786568946037) v_recording.schedule_type isColumnExists: true 12/08/2026 21:09:06(1786568946037) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946037) v_external_device_configuration.secondary_id isColumnExists: true 12/08/2026 21:09:06(1786568946037) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:06(1786568946037) >>>>>>>>>>>>>>>>>>>>>> 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', '') 12/08/2026 21:09:06(1786568946057) insertTable vReturn 1002 12/08/2026 21:09:06(1786568946058) ivms_30.rl_channel_group isTableExist: true 12/08/2026 21:09:06(1786568946058) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_group INSERT INTO `ivms_30`.`rl_channel_group` (`channel_id`, `group_id`) VALUES ('-1', '1') 12/08/2026 21:09:06(1786568946059) insertTable vReturn 1002 12/08/2026 21:09:06(1786568946059) ivms_30.rl_channel_location isTableExist: true 12/08/2026 21:09:06(1786568946059) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_location INSERT INTO `ivms_30`.`rl_channel_location` (`channel_id`, `location_id`) VALUES ('-1', '1') 12/08/2026 21:09:06(1786568946060) insertTable vReturn 1002 12/08/2026 21:09:06(1786568946060) ivms_30.rl_channel_recording isTableExist: true 12/08/2026 21:09:06(1786568946060) >>>>>>>>>>>>>>>>>>>>>> insertSql <<<<<<<<<<<<<<<<<<<<<<<<<<< rl_channel_recording INSERT INTO `ivms_30`.`rl_channel_recording` (`channel_id`, `recording_id`) VALUES ('-1', '1') 12/08/2026 21:09:06(1786568946061) insertTable vReturn 1002 12/08/2026 21:09:06(1786568946061) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:06(1786568946061) v_channel.protocol isColumnExists: true 12/08/2026 21:09:06(1786568946061) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:06(1786568946062) v_channel.channel_index isColumnExists: true 12/08/2026 21:09:06(1786568946062) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:06(1786568946062) v_channel.is_secured isColumnExists: true 12/08/2026 21:09:06(1786568946063) ivms_30.v_redundant_recording_clip isTableExist: true 12/08/2026 21:09:06(1786568946063) v_redundant_recording_clip.end_timestamp isColumnExists: true 12/08/2026 21:09:06(1786568946063) ivms_30.v_redundant_recording_clip isTableExist: true 12/08/2026 21:09:06(1786568946063) v_redundant_recording_clip.is_secured isColumnExists: false 12/08/2026 21:09:06(1786568946063) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_redundant_recording_clip.is_secured 12/08/2026 21:09:06(1786568946064) alterTable vReturn 1002 Query :ALTER TABLE `ivms_30`.`v_redundant_recording_clip` ADD COLUMN `clip_size` BIGINT(20) NOT NULL DEFAULT '0' 12/08/2026 21:09:06(1786568946064) ivms_30.v_collection isTableExist: true 12/08/2026 21:09:06(1786568946065) v_collection.description isColumnExists: true 12/08/2026 21:09:06(1786568946065) >>>>>>>>>>>>>>>>>>>>>> Columns Does Not Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_redundant_recording_clip.is_secured 12/08/2026 21:09:06(1786568946072) alterTable vReturn 0 Query :ALTER TABLE `ivms_30`.`v_collection` CHANGE COLUMN `description` `description` VARCHAR(12288) NULL DEFAULT NULL 12/08/2026 21:09:06(1786568946073) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:06(1786568946073) v_external_device_registration.camera_association_mode isColumnExists: true 12/08/2026 21:09:06(1786568946074) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:06(1786568946074) v_external_device_registration.number_fixed_cam_to_associate isColumnExists: true 12/08/2026 21:09:06(1786568946075) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:06(1786568946075) v_external_device_registration.ip isColumnExists: true 12/08/2026 21:09:06(1786568946075) exits v_external_device_registration 12/08/2026 21:09:06(1786568946159) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:06(1786568946160) v_external_device_registration.number_ptz_cam_to_associate isColumnExists: true 12/08/2026 21:09:06(1786568946162) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:06(1786568946164) v_external_device_registration.fixed_camera_dictance_to_associat isColumnExists: true 12/08/2026 21:09:06(1786568946165) ivms_30.v_external_device_registration isTableExist: true 12/08/2026 21:09:06(1786568946165) v_external_device_registration.ptz_camera_dictance_to_associat isColumnExists: true 12/08/2026 21:09:06(1786568946166) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946166) v_external_device_configuration.associate_channels isColumnExists: true 12/08/2026 21:09:06(1786568946166) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946166) v_external_device_configuration.zone_id isColumnExists: true 12/08/2026 21:09:06(1786568946167) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946167) v_external_device_configuration.location_id isColumnExists: true 12/08/2026 21:09:06(1786568946169) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946170) v_external_device_configuration.controller_id isColumnExists: true 12/08/2026 21:09:06(1786568946172) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946173) v_external_device_configuration.pos_x isColumnExists: true 12/08/2026 21:09:06(1786568946175) ivms_30.v_external_device_configuration isTableExist: true 12/08/2026 21:09:06(1786568946176) v_external_device_configuration.pos_y isColumnExists: true 12/08/2026 21:09:06(1786568946177) ivms_30.v_external_device_controller isTableExist: true 12/08/2026 21:09:06(1786568946178) exits v_external_device_controller 12/08/2026 21:09:06(1786568946179) ivms_30.v_external_device_location isTableExist: true 12/08/2026 21:09:06(1786568946179) exits v_external_device_location 12/08/2026 21:09:06(1786568946181) ivms_30.v_external_device_zone isTableExist: true 12/08/2026 21:09:06(1786568946181) exits v_external_device_zone 12/08/2026 21:09:06(1786568946182) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946183) v_user_profile.unmasked_live_play isColumnExists: true 12/08/2026 21:09:06(1786568946185) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946186) v_user_profile.unmasked_archive_play isColumnExists: true 12/08/2026 21:09:06(1786568946187) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946188) v_user_profile.unmasked_clip_download isColumnExists: true 12/08/2026 21:09:06(1786568946190) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946192) v_user_profile.unmasked_live_play isColumnExists: true 12/08/2026 21:09:06(1786568946193) v_user_profile.unmasked_archive_play isColumnExists: true 12/08/2026 21:09:06(1786568946194) v_user_profile.unmasked_clip_download isColumnExists: true 12/08/2026 21:09:06(1786568946194) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.download_clip.unmasked_live_play 12/08/2026 21:09:06(1786568946198) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946200) v_user_profile.event_management isColumnExists: true 12/08/2026 21:09:06(1786568946202) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946204) v_user_profile.system_configuration isColumnExists: true 12/08/2026 21:09:06(1786568946205) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946205) v_user_profile.system_settings isColumnExists: true 12/08/2026 21:09:06(1786568946206) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946206) v_user_profile.bookmarks isColumnExists: true 12/08/2026 21:09:06(1786568946206) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946207) v_user_profile.maps isColumnExists: true 12/08/2026 21:09:06(1786568946207) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946207) v_user_profile.external_systems isColumnExists: true 12/08/2026 21:09:06(1786568946208) ivms_30.v_user_profile isTableExist: true 12/08/2026 21:09:06(1786568946208) v_user_profile.event_management isColumnExists: true 12/08/2026 21:09:06(1786568946208) v_user_profile.system_configuration isColumnExists: true 12/08/2026 21:09:06(1786568946209) v_user_profile.system_settings isColumnExists: true 12/08/2026 21:09:06(1786568946209) v_user_profile.bookmarks isColumnExists: true 12/08/2026 21:09:06(1786568946210) v_user_profile.maps isColumnExists: true 12/08/2026 21:09:06(1786568946210) v_user_profile.external_systems isColumnExists: true 12/08/2026 21:09:06(1786568946210) >>>>>>>>>>>>>>>>>>>>>> Columns Exists <<<<<<<<<<<<<<<<<<<<<<<<<<< v_user_profile.event_management 12/08/2026 21:09:06(1786568946212) ivms_30.v_user_restriction isTableExist: true 12/08/2026 21:09:06(1786568946212) exits v_user_restriction 12/08/2026 21:09:06(1786568946221) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:06(1786568946222) v_channel.grabber_library isColumnExists: true 12/08/2026 21:09:06(1786568946222) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:06(1786568946223) v_channel.grabbing_protocol isColumnExists: true 12/08/2026 21:09:06(1786568946223) ivms_30.v_channel isTableExist: true 12/08/2026 21:09:06(1786568946223) v_channel.audio_grabbing isColumnExists: true 12/08/2026 21:09:06(1786568946223) >>>>>>>>>>>>>>>>>> MYSQL DATABASE PROCEDURE UPDATION END <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<