# List of known commands to run
    cmds = {
        # Local Method Commands
        "printSessionValue": {
            "params": ["sessionKey"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "string",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "printVar": {
            "params": ["varRef"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "string",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getSessionValue": {
            "params": ["sessionKey"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "mixed",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "setSessionValue": {
            "params": ["sessionKey", "value"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "bool",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "listSessionKeys": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "printSessionValueType": {
            "params": ["sessionKey"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "if": {
            "params": ["left", "right", "operator", "if", "else"],
            "paramTypes": ["string", "string", "operator", "command", "command"],
            "paramCount": 5,
            "returnType": "bool",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "setVerbose": {
            "params": ["value"],
            "paramTypes": ["bool"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "setFailOnIssue": {
            "params": ["value"],
            "paramTypes": ["bool"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "localMethod",
            "method": None,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Method Commands
        "scanDir": {
            "params": ["targetDir", "recurse"],
            "paramTypes": ["string", "bool"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.scanDir,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "testDbConn": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.testDbConn,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - Apache Log Files
        "clearApacheLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearApacheLogFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getApacheLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getApacheLogFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countApacheLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countApacheLogFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateApacheLogFile": {
            "params": ["filePath", "fileName", "size", "lastModifiedOn", "lastLogRowRead"],
            "paramTypes": ["string", "string", "int", "datetime", "int"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateApacheLogFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "storeApacheLogFile": {
            "params": ["targetLogFile", "lastRowRead"],
            "paramTypes": ["string", "int"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.storeApacheLogFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "processApacheLogFile": {
            "params": ["targetLogFile"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.processApacheLogFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getApacheLogFilesByFileNameFilePath": {
            "params": ["targetLogFile", "filePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getApacheLogFileByFileNameFilePath,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - SSHD Log Files
        "clearSshdLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearSshdLogFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getSshdLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getSshdLogFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countSshdLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countSshdLogFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateSshdLogFile": {
            "params": ["filePath", "fileName", "size", "lastModifiedOn", "lastLogRowRead"],
            "paramTypes": ["string", "string", "int", "datetime", "int"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateSshdLogFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "storeSshdLogFile": {
            "params": ["targetLogFile", "lastRowRead"],
            "paramTypes": ["string", "int"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.storeSshdLogFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "processSshdLogFile": {
            "params": ["targetLogFile"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.processSshdLogFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getSshdLogFilesByFileNameFilePath": {
            "params": ["targetLogFile", "filePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getSshdLogFileByFileNameFilePath,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - Blocked Ips
        "expireBlockedIps": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.expireBlockedIps,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "clearBlockedIps": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearBlockedIps,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getBlockedIps": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getBlockedIps,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countBlockedIps": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countBlockedIps,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addBlockedIp": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateBlockedIp,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateBlockedIp": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateBlockedIp,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "storeBlockedIps": {
            "params": ["targetFile"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.storeBlockedIps,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "blockIpsUbuntu16": {
            "params": ["targetIpFile", "targetDenyFile"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.blockIpsUbuntu16Db,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "blockIpsUbuntu16Db": {
            "params": ["targetIpFile", "targetDenyFile"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.blockIpsUbuntu16Db,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "blockIpsUbuntu16File": {
            "params": ["targetIpFile", "targetDenyFile"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.blockIpsUbuntu16File,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - Training Files
        "clearTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearTrainingFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getTrainingFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countTrainingFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateTrainingFile": {
            "params": ["filePath", "fileName", "size", "lastModifiedOn"],
            "paramTypes": ["string", "string", "int", "datetime"],
            "paramCount": 4,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateTrainingFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "storeTrainingFiles": {
            "params": ["targetDir"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.storeTrainingFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - Bi3 Installed Versions
        "clearBi3InstalledVersions": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearBi3InstalledVersions,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getBi3InstalledVersions": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getBi3InstalledVersions,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countBi3InstalledVersions": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countBi3InstalledVersions,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateBi3InstalledVersion": {
            "params": ["version", "fullPath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateBi3InstalledVersion,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "deactivateBi3InstalledVersionByVersion": {
            "params": ["version"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.deactivateBi3InstalledVersionByVersion,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "storeBi3InstalledVersions": {
            "params": ["targetCsv"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.storeBi3InstalledVersions,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - SSHD Training Files
        "clearSshdTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearSshdTrainingFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getSshdTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getSshdTrainingFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countSshdTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countSshdTrainingFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateSshdTrainingFile": {
            "params": ["filePath", "fileName", "size", "lastModifiedOn"],
            "paramTypes": ["string", "string", "int", "datetime"],
            "paramCount": 4,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateSshdTrainingFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "storeSshdTrainingFiles": {
            "params": ["targetDir"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.storeSshdTrainingFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - Valid Web Files
        "clearValidWebFiles": {
            "params": ["siteName"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearValidWebFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getValidWebFiles": {
            "params": ["siteName"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getValidWebFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countValidWebFiles": {
            "params": ["siteName"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countValidWebFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateValidWebFile": {
            "params": ["filePath", "fileName", "size", "lastModifiedOn", "siteName"],
            "paramTypes": ["string", "string", "int", "datetime", "string"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateValidWebFile,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "storeValidWebFiles": {
            "params": ["targetDir", "siteName"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.storeValidWebFiles,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - Bi3 Input Clients
        "clearBi3InputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearBi3InputClients,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getBi3InputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getBi3InputClients,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countBi3InputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countBi3InputClients,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateBi3InputClient": {
            "params": ["ipAddress", "webSvcKey1", "webSvcKey2"],
            "paramTypes": ["string", "string", "string"],
            "paramCount": 3,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateBi3InputClient,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Main Methods - Bi3 Output Clients
        "clearBi3OutputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.clearBi3OutputClients,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "getBi3OutputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "recordTable",
            "jobType": "mainMethod",
            "method": mn.getBi3OutputClients,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "countBi3OutputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "mainMethod",
            "method": mn.countBi3OutputClients,
            "sql": "",
            "version": "1.0",
            "error": False
        },
        "addActivateBi3OutputClient": {
            "params": ["ipAddress", "webSvcKey1", "webSvcKey2"],
            "paramTypes": ["string", "string", "string"],
            "paramCount": 3,
            "returnType": "none",
            "jobType": "mainMethod",
            "method": mn.addActivateBi3OutputClient,
            "sql": "",
            "version": "1.0",
            "error": False
        },

        # Apache Log Files Table
        "AddActivateApacheLogFile": {
            "params": ["targetFilePath", "targetFileName", "targetFileSize", "lastModefiedDateTime", "lastLogRowRead"],
            "paramTypes": ["string", "string", "int", "datetime", "int"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateApacheLogFile",
            "version": "1.0",
            "error": False
        },
        "CountAllApacheLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `apache_log_files`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveApacheLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `apache_log_files` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateApacheLogFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateApacheLogFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeactivateApacheLogFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateApacheLogFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllApacheLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllApacheLogFiles",
            "version": "1.0",
            "error": False
        },
        "DeleteApacheLogFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteApacheLogFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeleteApacheLogFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteApacheLogFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetApacheLogFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "out_zzRowId", "out_fileSize", "out_lastModifiedOn", "out_lastLogRowRead"],
            "paramTypes": ["string", "string", "int", "int", "datetime", "int"],
            "paramCount": 6,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetApacheLogFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "GetApacheLogFileByZzRowId": {
            "params": ["zzRowId", "out_targetFileName", "out_targetFilePath", "out_fileSize", "out_lastModifiedOn", "out_lastLogRowRead"],
            "paramTypes": ["int", "string", "string", "int", "datetime", "int"],
            "paramCount": 6,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetApacheLogFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListApacheLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListApacheLogFiles",
            "version": "1.0",
            "error": False
        },
        "UpdateApacheLogFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active", "lastLogRowRead"],
            "paramTypes": ["string", "string", "int", "datetime", "int", "int"],
            "paramCount": 6,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateApacheLogFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "UpdateApacheLogFileByZzRowId": {
            "params": ["zzRowId", "targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active", "lastLogRowRead"],
            "paramTypes": ["int", "string", "string", "int", "datetime", "int", "int"],
            "paramCount": 7,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateApacheLogFileByZzRowId",
            "version": "1.0",
            "error": False
        },


        # Bi3 Input Clients Table
        "AddActivateBi3InputClient": {
            "params": ["ipAddress", "webSvcKey1", "webSvcKey2"],
            "paramTypes": ["string", "string", "string"],
            "paramCount": 3,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateBi3InputClient",
            "version": "1.0",
            "error": False
        },
        "CountAllBi3InputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `bi3_input_clients`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveBi3InputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `bi3_input_clients` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateBi3InputClientByIpAddress": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBi3InputClientByIpAddress",
            "version": "1.0",
            "error": False
        },
        "DeactivateBi3InputClientByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBi3InputClientByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllBi3InputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllBi3InputClients",
            "version": "1.0",
            "error": False
        },
        "DeleteBi3InputClientByIpAddress": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBi3InputClientByIpAddress",
            "version": "1.0",
            "error": False
        },
        "DeleteBi3InputClientByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBi3InputClientByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetBi3InputClientByIpAddress": {
            "params": ["ipAddress", "out_ipAddress", "out_zzRowId"],
            "paramTypes": ["string", "string", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBi3InputClientByIpAddress",
            "version": "1.0",
            "error": False
        },
        "GetBi3InputClientByZzRowId": {
            "params": ["zzRowId", "out_ipAddress"],
            "paramTypes": ["int", "string"],
            "paramCount": 2,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBi3InputClientByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListBi3InputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListBi3InputClients",
            "version": "1.0",
            "error": False
        },
        "UpdateBi3InputClientByIpAddress": {
            "params": ["ipAddress", "active", "ignore"],
            "paramTypes": ["string", "int", "int"],
            "paramCount": 3,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBi3InputClientByIpAddress",
            "version": "1.0",
            "error": False
        },
        "UpdateBi3InputClientByZzRowId": {
            "params": ["zzRowId", "active", "ignore"],
            "paramTypes": ["int", "int", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBi3InputClientByZzRowId",
            "version": "1.0",
            "error": False
        },


        # Bi3 Installed Versions Table
        "AddActivateBi3InstalledVersion": {
            "params": ["version", "fullPath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateBi3InstalledVersion",
            "version": "1.0",
            "error": False
        },
        "CountAllBi3InstalledVersions": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `bi3_installed_versions`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveBi3InstalledVersions": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `bi3_installed_versions` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateBi3InstalledVersionByVersion": {
            "params": ["version"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBi3InstalledVersionByVersion",
            "version": "1.0",
            "error": False
        },
        "DeactivateBi3InstalledVersionByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBi3InstalledVersionByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllBi3InstalledVersions": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllBi3InstalledVersions",
            "version": "1.0",
            "error": False
        },
        "DeleteBi3InstalledVersionByVersion": {
            "params": ["version"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBi3InstalledVersionByVersion",
            "version": "1.0",
            "error": False
        },
        "DeleteBi3InstalledVersionByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBi3InstalledVersionByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetBi3InstalledVersionByVersion": {
            "params": ["version", "out_version", "out_zzRowId", "out_fullPath"],
            "paramTypes": ["string", "string", "int", "string"],
            "paramCount": 4,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBi3InstalledVersionByVersion",
            "version": "1.0",
            "error": False
        },
        "GetBi3InstalledVersionByZzRowId": {
            "params": ["zzRowId", "out_version", "out_zzRowId", "out_fullPath"],
            "paramTypes": ["int", "string", "int", "string"],
            "paramCount": 4,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBi3InstalledVersionByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListBi3InstalledVersions": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListBi3InstalledVersions",
            "version": "1.0",
            "error": False
        },
        "UpdateBi3InstalledVersionByVersion": {
            "params": ["version", "active", "ignore"],
            "paramTypes": ["string", "int", "int"],
            "paramCount": 3,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBi3InstalledVersionByVersion",
            "version": "1.0",
            "error": False
        },
        "UpdateBi3InstalledVersionByZzRowId": {
            "params": ["zzRowId", "active", "ignore"],
            "paramTypes": ["int", "int", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBi3InstalledVersionByZzRowId",
            "version": "1.0",
            "error": False
        },


        # Bi3 Output Clients Table
        "AddActivateBi3OutputClient": {
            "params": ["ipAddress", "webSvcKey1", "webSvcKey2"],
            "paramTypes": ["string", "string", "string"],
            "paramCount": 3,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateBi3OutputClient",
            "version": "1.0",
            "error": False
        },
        "CountAllBi3OutputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `bi3_output_clients`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveBi3OutputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `bi3_output_clients` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateBi3OutputClientByIpAddress": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBi3OutputClientByIpAddress",
            "version": "1.0",
            "error": False
        },
        "DeactivateBi3OutputClientByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBi3OutputClientByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllBi3OutputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllBi3OutputClients",
            "version": "1.0",
            "error": False
        },
        "DeleteBi3OutputClientByIpAddress": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBi3OutputClientByIpAddress",
            "version": "1.0",
            "error": False
        },
        "DeleteBi3OutputClientByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBi3OutputClientByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetBi3OutputClientByIpAddress": {
            "params": ["ipAddress", "out_ipAddress", "out_zzRowId"],
            "paramTypes": ["string", "string", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBi3OutputClientByIpAddress",
            "version": "1.0",
            "error": False
        },
        "GetBi3OutputClientByZzRowId": {
            "params": ["zzRowId", "out_ipAddress"],
            "paramTypes": ["int", "string"],
            "paramCount": 2,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBi3OutputClientByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListBi3OutputClients": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListBi3OutputClients",
            "version": "1.0",
            "error": False
        },
        "UpdateBi3OutputClientByIpAddress": {
            "params": ["ipAddress", "active", "ignore"],
            "paramTypes": ["string", "int", "int"],
            "paramCount": 3,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBi3OutputClientByIpAddress",
            "version": "1.0",
            "error": False
        },
        "UpdateBi3OutputClientByZzRowId": {
            "params": ["zzRowId", "active", "ignore"],
            "paramTypes": ["int", "int", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBi3OutputClientByZzRowId",
            "version": "1.0",
            "error": False
        },


        # Blocked Ips Table
        "AddActivateBlockedIp": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateBlockedIp",
            "version": "1.0",
            "error": False
        },
        "CountAllBlockedIps": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `blocked_ips`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveBlockedIps": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `blocked_ips` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateBlockedIpByIpAddress": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBlockedIpByIpAddress",
            "version": "1.0",
            "error": False
        },
        "DeactivateBlockedIpByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBlockedIpByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllBlockedIps": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllBlockedIps",
            "version": "1.0",
            "error": False
        },
        "DeleteBlockedIpByIpAddress": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBlockedIpByIpAddress",
            "version": "1.0",
            "error": False
        },
        "DeleteBlockedIpByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBlockedIpByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetBlockedIpByIpAddress": {
            "params": ["ipAddress", "out_ipAddress", "out_zzRowId"],
            "paramTypes": ["string", "string", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBlockedIpByIpAddress",
            "version": "1.0",
            "error": False
        },
        "GetBlockedIpByZzRowId": {
            "params": ["zzRowId", "out_ipAddress"],
            "paramTypes": ["int", "string"],
            "paramCount": 2,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBlockedIpByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListBlockedIps": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListBlockedIps",
            "version": "1.0",
            "error": False
        },
        "UpdateBlockedIpByIpAddress": {
            "params": ["ipAddress", "active"],
            "paramTypes": ["string", "int"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBlockedIpByIpAddress",
            "version": "1.0",
            "error": False
        },
        "UpdateBlockedIpByZzRowId": {
            "params": ["zzRowId", "ipAddress", "active"],
            "paramTypes": ["int", "string", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBlockedIpByZzRowId",
            "version": "1.0",
            "error": False
        },


        # Blocked Ips Details Table
        "AddActivateBlockedIpsDetails": {
            "params": ["ipAddress", "httpCode", "httpUrl", "httpIsZeroLen", "blockedIpsTypesId"],
            "paramTypes": ["string", "string", "string", "int", "int"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateBlockedIpsDetails",
            "version": "1.0",
            "error": False
        },
        "CountAllBlockedIpsDetails": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `blocked_ips_details`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveBlockedIpsDetails": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `blocked_ips_details` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateBlockedIpsDetailByIpAddress": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBlockedIpsDetailByIpAddress",
            "version": "1.0",
            "error": False
        },
        "DeactivateBlockedIpsDetailByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateBlockedIpsDetailByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllBlockedIpsDetails": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllBlockedIpsDetails",
            "version": "1.0",
            "error": False
        },
        "DeleteBlockedIpsDetailByIpAddress": {
            "params": ["ipAddress"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBlockedIpsDetailByIpAddress",
            "version": "1.0",
            "error": False
        },
        "DeleteBlockedIpsDetailByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteBlockedIpsDetailByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetBlockedIpsDetailByIpAddress": {
            "params": ["ipAddress", "out_ipAddress", "out_zzRowId"],
            "paramTypes": ["string", "string", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBlockedIpsDetailByIpAddress",
            "version": "1.0",
            "error": False
        },
        "GetBlockedIpsDetailByZzRowId": {
            "params": ["zzRowId", "out_ipAddress"],
            "paramTypes": ["int", "string"],
            "paramCount": 2,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetBlockedIpsDetailByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListBlockedIpsDetails": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListBlockedIpsDetails",
            "version": "1.0",
            "error": False
        },
        "UpdateBlockedIpsDetailByIpAddress": {
            "params": ["ipAddress", "active"],
            "paramTypes": ["string", "int"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBlockedIpsDetailByIpAddress",
            "version": "1.0",
            "error": False
        },
        "UpdateBlockedIpsDetailByZzRowId": {
            "params": ["zzRowId", "ipAddress", "active"],
            "paramTypes": ["int", "string", "int"],
            "paramCount": 3,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateBlockedIpsDetailByZzRowId",
            "version": "1.0",
            "error": False
        },


        # SSHD Log Files Table
        "AddActivateSshdLogFile": {
            "params": ["targetFilePath", "targetFileName", "targetFileSize", "lastModefiedDateTime", "lastLogRowRead"],
            "paramTypes": ["string", "string", "int", "datetime", "int"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateApacheLogFile",
            "version": "1.0",
            "error": False
        },
        "CountAllSshdLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `sshd_log_files`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveSshdLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `sshd_log_files` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateSshdLogFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateSshdLogFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeactivateSshdLogFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateSshdLogFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllSshdLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllSshdLogFiles",
            "version": "1.0",
            "error": False
        },
        "DeleteSshdLogFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteSshdLogFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeleteSshdLogFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteSshdLogFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetSshdLogFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "out_zzRowId", "out_fileSize", "out_lastModifiedOn", "out_lastLogRowRead"],
            "paramTypes": ["string", "string", "int", "int", "datetime", "int"],
            "paramCount": 6,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetSshdLogFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "GetSshdLogFileByZzRowId": {
            "params": ["zzRowId", "out_targetFileName", "out_targetFilePath", "out_fileSize", "out_lastModifiedOn", "out_lastLogRowRead"],
            "paramTypes": ["int", "string", "string", "int", "datetime", "int"],
            "paramCount": 6,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetSshdLogFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListSshdLogFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListSshdLogFiles",
            "version": "1.0",
            "error": False
        },
        "UpdateSshdLogFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active", "lastLogRowRead"],
            "paramTypes": ["string", "string", "int", "datetime", "int", "int"],
            "paramCount": 6,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateSshdLogFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "UpdateSshdLogFileByZzRowId": {
            "params": ["zzRowId", "targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active", "lastLogRowRead"],
            "paramTypes": ["int", "string", "string", "int", "datetime", "int", "int"],
            "paramCount": 7,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateSshdLogFileByZzRowId",
            "version": "1.0",
            "error": False
        },


        # SSHD Training Files Table
        "AddActivateSshdTrainingFile": {
            "params": ["targetFilePath", "targetFileName", "targetFileSize", "lastModefiedDateTime"],
            "paramTypes": ["string", "string", "int", "datetime"],
            "paramCount": 4,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateSshdTrainingFile",
            "version": "1.0",
            "error": False
        },
        "CountAllSshdTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `sshd_training_files`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveSshdTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `sshd_training_files` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateSshdTrainingFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateSshdTrainingFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeactivateSshdTrainingFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateSshdTrainingFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllSshdTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllSshdTrainingFiles",
            "version": "1.0",
            "error": False
        },
        "DeleteSshdTrainingFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteSshdTrainingFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeleteSshdTrainingFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteSshdTrainingFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetSshdTrainingFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "out_zzRowId", "out_fileSize", "out_lastModifiedOn"],
            "paramTypes": ["string", "string", "int", "int", "datetime"],
            "paramCount": 5,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetSshdTrainingFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "GetSshdTrainingFileByZzRowId": {
            "params": ["zzRowId", "out_targetFileName", "out_targetFilePath", "out_fileSize", "out_lastModifiedOn"],
            "paramTypes": ["int", "string", "string", "int", "datetime"],
            "paramCount": 5,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetSshdTrainingFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListSshdTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListSshdTrainingFiles",
            "version": "1.0",
            "error": False
        },
        "UpdateSshdTrainingFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active"],
            "paramTypes": ["string", "string", "int", "datetime", "int"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateSshdTrainingFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "UpdateSshdTrainingFileByZzRowId": {
            "params": ["zzRowId", "targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active"],
            "paramTypes": ["int", "string", "string", "int", "datetime", "int"],
            "paramCount": 6,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateSshdTrainingFileByZzRowId",
            "version": "1.0",
            "error": False
        },


        # Training Files Table
        "AddActivateTrainingFile": {
            "params": ["targetFilePath", "targetFileName", "targetFileSize", "lastModefiedDateTime"],
            "paramTypes": ["string", "string", "int", "datetime"],
            "paramCount": 4,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateTrainingFile",
            "version": "1.0",
            "error": False
        },
        "CountAllTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `training_files`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `training_files` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateTrainingFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateTrainingFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeactivateTrainingFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateTrainingFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllTrainingFiles",
            "version": "1.0",
            "error": False
        },
        "DeleteTrainingFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteTrainingFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeleteTrainingFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteTrainingFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetTrainingFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "out_zzRowId", "out_fileSize", "out_lastModifiedOn"],
            "paramTypes": ["string", "string", "int", "int", "datetime"],
            "paramCount": 5,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetTrainingFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "GetTrainingFileByZzRowId": {
            "params": ["zzRowId", "out_targetFileName", "out_targetFilePath", "out_fileSize", "out_lastModifiedOn"],
            "paramTypes": ["int", "string", "string", "int", "datetime"],
            "paramCount": 5,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetTrainingFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListTrainingFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListTrainingFiles",
            "version": "1.0",
            "error": False
        },
        "UpdateTrainingFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active"],
            "paramTypes": ["string", "string", "int", "datetime", "int"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateTrainingFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "UpdateTrainingFileByZzRowId": {
            "params": ["zzRowId", "targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active"],
            "paramTypes": ["int", "string", "string", "int", "datetime", "int"],
            "paramCount": 6,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateTrainingFileByZzRowId",
            "version": "1.0",
            "error": False
        },


        # Valid Web Files Table
        "AddActivateValidWebFile": {
            "params": ["targetFilePath", "targetFileName", "targetFileSize", "lastModefiedDateTime", "siteName"],
            "paramTypes": ["string", "string", "int", "datetime", "string"],
            "paramCount": 5,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "AddActivateValidWebFile",
            "version": "1.0",
            "error": False
        },
        "CountAllValidWebFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `valid_web_files`;",
            "version": "1.0",
            "error": False
        },
        "CountActiveValidWebFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "int",
            "jobType": "execute",
            "method": "",
            "sql": "SELECT COUNT(*) AS `cnt` FROM `valid_web_files` WHERE `active` = 1;",
            "version": "1.0",
            "error": False
        },
        "DeactivateValidWebFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateValidWebFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeactivateValidWebFileBySiteName": {
            "params": ["siteName"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateValidWebFileBySiteName",
            "version": "1.0",
            "error": False
        },
        "DeactivateValidWebFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeactivateValidWebFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "DeleteAllValidWebFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllValidWebFiles",
            "version": "1.0",
            "error": False
        },
        "DeleteAllValidWebFilesBySiteName": {
            "params": ["siteName"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteAllValidWebFilesBySiteName",
            "version": "1.0",
            "error": False
        },
        "DeleteValidWebFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath"],
            "paramTypes": ["string", "string"],
            "paramCount": 2,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteValidWebFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "DeleteValidWebFileByZzRowId": {
            "params": ["zzRowId"],
            "paramTypes": ["int"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "DeleteValidWebFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "GetValidWebFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "out_zzRowId", "out_fileSize", "out_lastModifiedOn", "out_siteName"],
            "paramTypes": ["string", "string", "int", "int", "datetime", "string"],
            "paramCount": 6,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetValidWebFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "GetValidWebFileByZzRowId": {
            "params": ["zzRowId", "out_targetFileName", "out_targetFilePath", "out_fileSize", "out_lastModifiedOn", "out_siteName"],
            "paramTypes": ["int", "string", "string", "int", "datetime", "string"],
            "paramCount": 6,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "GetValidWebFileByZzRowId",
            "version": "1.0",
            "error": False
        },
        "ListValidWebFiles": {
            "params": [],
            "paramTypes": [],
            "paramCount": 0,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListValidWebFiles",
            "version": "1.0",
            "error": False
        },
        "ListValidWebFilesBySiteName": {
            "params": ["siteName"],
            "paramTypes": ["string"],
            "paramCount": 1,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "ListValidWebFilesBySiteName",
            "version": "1.0",
            "error": False
        },
        "UpdateValidWebFileByFileNameFilePath": {
            "params": ["targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active", "siteName"],
            "paramTypes": ["string", "string", "int", "datetime", "int", "string"],
            "paramCount": 6,
            "returnType": "none",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateValidWebFileByFileNameFilePath",
            "version": "1.0",
            "error": False
        },
        "UpdateValidWebFileByZzRowId": {
            "params": ["zzRowId", "targetFileName", "targetFilePath", "fileSize", "lastModifiedOn", "active", "siteName"],
            "paramTypes": ["int", "string", "string", "int", "datetime", "int", "string"],
            "paramCount": 7,
            "returnType": "recordTable",
            "jobType": "callProc",
            "method": "",
            "sql": "UpdateValidWebFileByZzRowId",
            "version": "1.0",
            "error": False
        },
    }