[
  {
    "WORK_TYPE" : "FILE_COPY_LOOP",
    "REPORT_SQL" : " SELECT REPORT_CODE, REPORT_PATH FROM MTX_REPORT WHERE REPORT_CODE = '{VS_REPORT_CODE}' ",
    "FILE_COPY_SQL" : " SELECT ATTR5 AS REPORT_PATH, ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT' ",
    "FILE_PATHS" :  [ 
                      "{BACKUP_ROOT_PATH}/{REPORT_PATH}",
                      "{BACKUP_ROOT_PATH}/iGRID_DESIGN/{REPORT_CODE}",
                      "{BACKUP_ROOT_PATH}/SERVER_SCRIPT/{REPORT_CODE}"
                    ],
    "IGNORE_PATHS" : ["*.bak", "*.thumb", "Thumbs.db"]
  },
  {
    "WORK_TYPE" : "DB_BACKUP",
    "IMPORT_TYPE" : "D/I",
    "TABLES" : [
      {"IMPORT_TABLE":"MTX_FOLDER", "EXPORT_SQL":"SELECT * FROM MTX_FOLDER WHERE FOLDER_CODE IN (SELECT ATTR6 AS FOLDER FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='FOLDER')", "PRIMARY_KEYS":["FOLDER_CODE"]},
      {"IMPORT_TABLE":"MTX_REPORT", "EXPORT_SQL":"SELECT * FROM MTX_REPORT WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE"]},
      {"IMPORT_TABLE":"MTX_CATS_REPORT", "EXPORT_SQL":"SELECT * FROM MTX_CATS_REPORT WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["CATS_CODE", "REPORT_CODE"]},
      {"IMPORT_TABLE":"MTX_PROPERTY", "EXPORT_SQL":"SELECT * FROM MTX_PROPERTY WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE","SHEET_CODE"]},
      {"IMPORT_TABLE":"MTX_META_D_FIELD", "EXPORT_SQL":"SELECT * FROM MTX_META_D_FIELD WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "TABLE_CODE", "FIELD_CODE"]},
      {"IMPORT_TABLE":"MTX_META_D_LINK", "EXPORT_SQL":"SELECT * FROM MTX_META_D_LINK WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "LINK_CODE"]},
      {"IMPORT_TABLE":"MTX_META_D_TABLE", "EXPORT_SQL":"SELECT * FROM MTX_META_D_TABLE WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "TABLE_CODE"]},
      {"IMPORT_TABLE":"MTX_META_R_FIELD", "EXPORT_SQL":"SELECT * FROM MTX_META_R_FIELD WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "FIELD_CODE"]},
      {"IMPORT_TABLE":"MTX_META_REPORT", "EXPORT_SQL":"SELECT * FROM MTX_META_REPORT WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE"]},
      {"IMPORT_TABLE":"MTX_SQL", "EXPORT_SQL":"SELECT * FROM MTX_SQL WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE","SQL_ID"]},
      {"IMPORT_TABLE":"MTX_SQL_COLUMN", "EXPORT_SQL":"SELECT * FROM MTX_SQL_COLUMN WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "SQL_ID", "COLUMN_NAME"]},
      {"IMPORT_TABLE":"MTX_SQL_PARAM", "EXPORT_SQL":"SELECT * FROM MTX_SQL_PARAM WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "SQL_ID", "PARAM_NAME"]},
      {"IMPORT_TABLE":"MTX_SQL_REPORT", "EXPORT_SQL":"SELECT * FROM MTX_SQL_REPORT WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "SQL_ID"]},
      {"IMPORT_TABLE":"MTX_LANG_DICT_LINK", "EXPORT_SQL":"SELECT * FROM MTX_LANG_DICT_LINK WHERE LINK_OBJECT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["LINK_OBJECT_CODE", "DICT_CODE"]},
      {"IMPORT_TABLE":"MTX_META_USE_REPORT", "EXPORT_SQL":"SELECT * FROM MTX_META_USE_REPORT WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["META_REPORT_CODE","REPORT_CODE"]},
      {"IMPORT_TABLE":"MTX_SQL_ATTR_META", "EXPORT_SQL":"SELECT * FROM MTX_SQL_ATTR_META WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE","SQL_ID"]},
      {"IMPORT_TABLE":"MTX_MODULE_USE_REPORT", "EXPORT_SQL":"SELECT * FROM MTX_MODULE_USE_REPORT WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["MODULE_CODE", "REPORT_CODE"]},
      {"IMPORT_TABLE":"MTX_META_REPORT_TABLE", "EXPORT_SQL":"SELECT * FROM MTX_META_REPORT_TABLE WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "ENTITY_CODE"]},
      {"IMPORT_TABLE":"MTX_META_REPORT_COLUMN", "EXPORT_SQL":"SELECT * FROM MTX_META_REPORT_COLUMN WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE"]},
      {"IMPORT_TABLE":"MTX_META_INFO", "EXPORT_SQL":"SELECT * FROM MTX_META_INFO WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE"]},
      {"IMPORT_TABLE":"MTX_META_DIAGRAM_TABLE", "EXPORT_SQL":"SELECT * FROM MTX_META_DIAGRAM_TABLE WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "CODE"]},
      {"IMPORT_TABLE":"MTX_META_DIAGRAM_COLUMN", "EXPORT_SQL":"SELECT * FROM MTX_META_DIAGRAM_COLUMN WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "TABLE_CODE", "CODE"]},
      {"IMPORT_TABLE":"MTX_META_DIAGRAM_JOIN", "EXPORT_SQL":"SELECT * FROM MTX_META_DIAGRAM_JOIN WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "CODE"]},
      {"IMPORT_TABLE":"MTX_META_FIELD", "EXPORT_SQL":"SELECT * FROM MTX_META_FIELD WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "ID"]},
      {"IMPORT_TABLE":"MTX_META_RELATION_FIELD", "EXPORT_SQL":"SELECT * FROM MTX_META_RELATION_FIELD WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "PARENT_ID", "ID"]},
      {"IMPORT_TABLE":"MTX_META_CLOB_FIELD", "EXPORT_SQL":"SELECT * FROM MTX_META_CLOB_FIELD WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "ID"]},
      {"IMPORT_TABLE":"MTX_AUTHORITY",
        "EXPORT_SQL":"SELECT * FROM MTX_AUTHORITY WHERE AUTH_OBJECT_CODE IN (SELECT ATTR3 AS AUTH_OBJECT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT' UNION ALL SELECT ATTR6 AS AUTH_OBJECT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='FOLDER')", "PRIMARY_KEYS":["AUTH_SUBJECT_CODE", "AUTH_OBJECT_CODE", "SUBJECT_CODE", "OBJECT_CODE"]},
      {"IMPORT_TABLE":"MTX_META_AUTHORITY",
      "EXPORT_SQL":"SELECT * FROM MTX_META_AUTHORITY WHERE AUTH_OBJECT_CODE IN (SELECT ATTR_CODE FROM MTX_META_REPORT_COLUMN A INNER JOIN MTX_BACKUP_TEMP B ON (B.BACKUP_CODE = {MAIN_KEY_VAL} AND B.ATTR1='REPORT' AND A.REPORT_CODE = B.ATTR3) GROUP BY ATTR_CODE UNION ALL SELECT ENTITY_CODE FROM MTX_META_REPORT_COLUMN A INNER JOIN MTX_BACKUP_TEMP B ON (B.BACKUP_CODE = {MAIN_KEY_VAL} AND B.ATTR1='REPORT' AND A.REPORT_CODE = B.ATTR3) GROUP BY ENTITY_CODE)"
      , "PRIMARY_KEYS":["AUTH_SUBJECT_CODE", "AUTH_OBJECT_CODE", "SUBJECT_CODE", "OBJECT_CODE"]},
      {"IMPORT_TABLE":"MTX_META_ROWAUTH",
      "EXPORT_SQL":"SELECT * FROM MTX_META_ROWAUTH WHERE ROWAUTH_CODE IN (SELECT ROWAUTH_CODE FROM MTX_META_AUTHORITY WHERE AUTH_OBJECT_CODE IN (SELECT ATTR_CODE FROM MTX_META_REPORT_COLUMN A INNER JOIN MTX_BACKUP_TEMP B ON (B.BACKUP_CODE = {MAIN_KEY_VAL} AND B.ATTR1='REPORT' AND A.REPORT_CODE = B.ATTR3) GROUP BY ATTR_CODE UNION ALL SELECT ENTITY_CODE FROM MTX_META_REPORT_COLUMN A INNER JOIN MTX_BACKUP_TEMP B ON (B.BACKUP_CODE = {MAIN_KEY_VAL} AND B.ATTR1='REPORT' AND A.REPORT_CODE = B.ATTR3) GROUP BY ENTITY_CODE) GROUP BY  ROWAUTH_CODE)"
      , "PRIMARY_KEYS":["ROWAUTH_CODE", "ENTITY_CODE"]},
      {"IMPORT_TABLE":"MTX_CHILD_REPORT_CODE_LINK", "EXPORT_SQL":"SELECT * FROM MTX_CHILD_REPORT_CODE_LINK WHERE REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT')", "PRIMARY_KEYS":["REPORT_CODE", "CHILD_REPORT_CODE"], "IGNORE_ERROR":true}
    ]
  },
  {
    "WORK_TYPE" : "DB_BACKUP",
    "IMPORT_TYPE" : "N/I",
    "TABLES" : [
      {
        "IMPORT_TABLE": "MTX_META_ATTR",
        "EXPORT_SQL": "SELECT * FROM MTX_META_ATTR WHERE ATTR_CODE IN (SELECT A.ATTR_CODE FROM MTX_META_REPORT_COLUMN A INNER JOIN MTX_BACKUP_TEMP B ON (B.BACKUP_CODE = {MAIN_KEY_VAL} AND B.ATTR1='REPORT' AND A.REPORT_CODE = B.ATTR3) GROUP BY A.ATTR_CODE) AND ENTITY_CODE IN (SELECT A.ENTITY_CODE FROM MTX_META_REPORT_COLUMN A INNER JOIN MTX_BACKUP_TEMP B ON (B.BACKUP_CODE = {MAIN_KEY_VAL} AND B.ATTR1='REPORT' AND A.REPORT_CODE = B.ATTR3) GROUP BY A.ENTITY_CODE)",
        "PRIMARY_KEYS": [ "ATTR_CODE", "ENTITY_CODE" ]
      },
      {
        "IMPORT_TABLE":"MTX_META_RELATION",
        "EXPORT_SQL":"SELECT * FROM MTX_META_RELATION WHERE ENTITY_CODE IN (SELECT A.ENTITY_CODE FROM MTX_META_REPORT_COLUMN A INNER JOIN MTX_BACKUP_TEMP B ON (B.BACKUP_CODE = {MAIN_KEY_VAL} AND B.ATTR1='REPORT' AND A.REPORT_CODE = B.ATTR3) GROUP BY A.ENTITY_CODE)",
        "PRIMARY_KEYS":["ENTITY_CODE", "P_ENTITY_CODE"]
      },
      {
        "IMPORT_TABLE":"MTX_META_OBJECT",
        "EXPORT_SQL":"SELECT * FROM MTX_META_OBJECT WHERE ENTITY_CODE IN (SELECT A.ENTITY_CODE FROM MTX_META_REPORT_COLUMN A INNER JOIN MTX_BACKUP_TEMP B ON (B.BACKUP_CODE = {MAIN_KEY_VAL} AND B.ATTR1='REPORT' AND A.REPORT_CODE = B.ATTR3) GROUP BY A.ENTITY_CODE)",
        "PRIMARY_KEYS":["ENTITY_CODE"]
      },
      {
        "EXPORT_FILE_NAME":"MTX_DBMS.JSON",
        "EXPORT_SQL":"SELECT A.* FROM MTX_DBMS A WHERE A.DBMS_CODE IN (SELECT B.DBMS_CODE FROM (SELECT DBMS_CODE, REPORT_CODE FROM MTX_PROPERTY UNION SELECT DBMS_CODE, REPORT_CODE FROM MTX_SQL) B WHERE B.REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT') GROUP BY B.DBMS_CODE)",
        "IMPORT_TABLE":"MTX_DBMS",
        "PRIMARY_KEYS":["DBMS_CODE"]
      },
      {
        "EXPORT_FILE_NAME":"MTX_DBMS_OPTION.JSON",
        "EXPORT_SQL":"SELECT A.* FROM MTX_DBMS_OPTION A WHERE A.DBMS_CODE IN (SELECT B.DBMS_CODE FROM (SELECT DBMS_CODE, REPORT_CODE FROM MTX_PROPERTY UNION SELECT DBMS_CODE, REPORT_CODE FROM MTX_SQL) B WHERE B.REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT') GROUP BY B.DBMS_CODE)",
        "IMPORT_TABLE":"MTX_DBMS_OPTION",
        "PRIMARY_KEYS":["DBMS_CODE", "OPTION_CODE"]
      },
      {
        "EXPORT_FILE_NAME":"MTX_SERVER.JSON",
        "EXPORT_SQL":"SELECT A.* FROM MTX_SERVER A WHERE A.SERVER_CODE IN (SELECT SERVER_CODE FROM MTX_DBMS WHERE DBMS_CODE IN (SELECT B.DBMS_CODE FROM (SELECT DBMS_CODE, REPORT_CODE FROM MTX_PROPERTY UNION SELECT DBMS_CODE, REPORT_CODE FROM MTX_SQL) B WHERE B.REPORT_CODE IN (SELECT ATTR3 AS REPORT_CODE FROM MTX_BACKUP_TEMP WHERE BACKUP_CODE = {MAIN_KEY_VAL} AND ATTR1='REPORT') GROUP BY B.DBMS_CODE))",
        "IMPORT_TABLE":"MTX_SERVER",
        "PRIMARY_KEYS":["SERVER_CODE"]
      }
    ]
  }
]