##############################################################################
# Netcool/OMNIbus Bi-directional ObjectServer Gateway 8.1.0
#
# AGG_GATE Multitier map definition file for WEBHA
#
# Revision History:
#       1.0:    Initial revision. for WEBHA
#       1.2:    Add tables: 
#                   dashdb.TRANSFORMATIONS
#                   dashdb.WIRES
#
# Notes:
#       Append the content of this  gateway mapping definition file to the 
#       aggregation bi-di gateway (AGG_GATE.map) file in your system.
#
# Fields that are marked as 'ON INSERT ONLY' will only be passed when an event
# is inserted for the first time. (ie. they will not be updated). The ordering
# of the fields is not important as the gateway will use named value insertion.
#
##############################################################################

##############################################################################
# DASH HA table mappings

CREATE MAPPING dashhanodesmap
(
        'NODE_ID'               =   '@NODE_ID'          ON INSERT ONLY,
        'KEY'                   =   '@KEY',
        'URI'                   =   '@URI',
        'NAME'                  =   '@NAME',
        'LAST_UPDATED'          =   '@LAST_UPDATED',
        'LOCKED'                =   '@LOCKED',
        'STATUS'                =   '@STATUS'        
);

CREATE MAPPING dashhachartpropmap
(
        'id1'                   =   '@id1'              ON INSERT ONLY,
        'value'                 =   '@value'
);

CREATE MAPPING dashhaconnectionsmap
(
        'CONTEXT_ROOT'          =   '@CONTEXT_ROOT',
        'PASSWORD1'             =   '@PASSWORD1',
        'CONNECTION_TYPE'       =   '@CONNECTION_TYPE',
        'PORT'                  =   '@PORT',
        'HOST1'                 =   '@HOST1',
        'CREDENTIAL_TYPE'       =   '@CREDENTIAL_TYPE',
        'USERNAME'              =   '@USERNAME',
        'RENDER_FORMAT'         =   '@RENDER_FORMAT',
        'MSS_NAME'              =   '@MSS_NAME',
        'PROTOCOL'              =   '@PROTOCOL',
        'NAME'                  =   '@NAME'             ON INSERT ONLY,
        'SERVICE_NAME'          =   '@SERVICE_NAME'
);

CREATE MAPPING dashhaconsoleanalyticsdbaccessmap
(
        'PAGEID'                =   '@PAGEID'           ON INSERT ONLY,
        'PAGETITLE'             =   '@PAGETITLE',
        'LAST_TIME_ACCESSED'    =   '@LAST_TIME_ACCESSED',
        'PAGE_ACCESS_COUNT'     =   '@PAGE_ACCESS_COUNT',
        'INTERNAL_TS'           =   '@INTERNAL_TS',
        'MODULEREF'             =   '@MODULEREF'
);

CREATE MAPPING dashhaconsoleanalyticstblnamesmap
(
        'INTERNAL_TS'           =   '@INTERNAL_TS',
        'TABLENAME'             =   '@TABLENAME'        ON INSERT ONLY,
        'TBLSCHEMA'             =   '@TBLSCHEMA'
);

CREATE MAPPING dashhadatasetsmap
(
        'RESOURCEBUNDLE'        =   '@RESOURCEBUNDLE',
        'ID1'                   =   '@ID1'              ON INSERT ONLY,
        'VALUE'                 =   '@VALUE',
        'LABEL'                 =   '@LABEL',
        'DATA_SOURCE_TYPE'      =   '@DATA_SOURCE_TYPE' ON INSERT ONLY
);

CREATE MAPPING dashhadatasourcesmap
(
        'LABEL'                 =   '@LABEL',
        'RESOURCEBUNDLE'        =   '@RESOURCEBUNDLE',
        'WARNAME'               =   '@WARNAME',
        'TYPE'                  =   '@TYPE'             ON INSERT ONLY
);

CREATE MAPPING dashhafederationsmap
(
        'LOCATION'              =   '@LOCATION',
        'URL'                   =   '@URL',
        'NAME'                  =   '@NAME',
        'ID1'                   =   '@ID1'              ON INSERT ONLY,
        'VIEWMEMBER'            =   '@VIEWMEMBER'
);

CREATE MAPPING dashhaglobalconfigmap
(
        'KEY'                   =   '@KEY'              ON INSERT ONLY,
        'VALUE'                 =   '@VALUE'
);

CREATE MAPPING dashhagroupsmap
(
        'DATA_SOURCE_TYPE'      =   '@DATA_SOURCE_TYPE' ON INSERT ONLY,
        'LABEL'                 =   '@LABEL',
        'ID1'                   =   '@ID1'              ON INSERT ONLY,
        'PROVIDER_TYPE'         =   '@PROVIDER_TYPE'    ON INSERT ONLY,
        'DESCRIPTION'           =   '@DESCRIPTION',
        'RESOURCEBUNDLE'        =   '@RESOURCEBUNDLE'
);

CREATE MAPPING dashhamodulesmap
(
        'VERSION'               =   '@VERSION',
        'NAME'                  =   '@NAME',
        'MODULE_ID'             =   '@MODULE_ID'        ON INSERT ONLY,
        'LAST_UPDATED'          =   '@LAST_UPDATED'
);

CREATE MAPPING dashhanlresourcesmap
(
        'NL_KEY'                =   '@NL_KEY'           ON INSERT ONLY,
        'VALUE'                 =   '@VALUE',
        'RESOURCE_BUNDLE'       =   '@RESOURCE_BUNDLE'  ON INSERT ONLY,
        'LOCALE'                =   '@LOCALE'           ON INSERT ONLY
);

CREATE MAPPING dashhanodesstoresmap
(
        'NODE_ID'               =   '@NODE_ID',
        'LAST_UPDATED'          =   '@LAST_UPDATED',
        'STORE_ID'              =   '@STORE_ID',
        'DUMMI'                 =   '@DUMMI'            ON INSERT ONLY
);

CREATE MAPPING dashhapasswdkeysmap
(
        'ID1'                   =   '@ID1'              ON INSERT ONLY,
        'PASSWORD_KEY'          =   '@PASSWORD_KEY'
);

CREATE MAPPING dashhaprofilesmap
(
        'ATTR_NAME'             =   '@ATTR_NAME',
        'TYPE'                  =   '@TYPE',
        'PROFILE_ID'            =   '@PROFILE_ID',
        'USERNAME'              =   '@USERNAME',
        'VALUE'                 =   '@VALUE',
        'LARGE_VALUE'           =   '@LARGE_VALUE',
        'DUMMI'                 =   '@DUMMI'            ON INSERT ONLY
);


CREATE MAPPING dashhaprofimetadatamap
(
        'PAGE_ID'               =   '@PAGE_ID',
        'PROFILE_ID'            =   '@PROFILE_ID',
        'WINDOW_ID'             =   '@WINDOW_ID',
        'DUMMI'                 =   '@DUMMI'            ON INSERT ONLY,
        'PAGE_NAME'             =   '@PAGE_NAME'
);

CREATE MAPPING dashhaprovidersmap
(
        'RESOURCE_BUNDLE'        =  '@RESOURCE_BUNDLE',
        'TYPE'                   =  '@TYPE'             ON INSERT ONLY,
        'LABEL'                  =  '@LABEL',
        'DESCRIPTION'            =  '@DESCRIPTION'
);

CREATE MAPPING dashhasapmuiconmgrmap
(
        'NAME'                   =  '@NAME'             ON INSERT ONLY,
        'DISPLAYNAME'            =  '@DISPLAYNAME',
        'CURRENTVALUE'           =  '@CURRENTVALUE',
        'DEFAULTVALUE'           =  '@DEFAULTVALUE',
        'FIELDTYPE'              =  '@FIELDTYPE',
        'FIELDNAME'              =  '@FIELDNAME'        ON INSERT ONLY,
        'FIELDORDER'             =  '@FIELDORDER'
);

CREATE MAPPING dashhastoresmap
(
        'NAME'                  =   '@NAME',
        'DUMMI'                 =   '@DUMMI'            ON INSERT ONLY,
        'LAST_UPDATED'          =   '@LAST_UPDATED',
        'STORE_ID'              =   '@STORE_ID',
        'DATA'                  =   '@DATA'
);

CREATE MAPPING dashhawidgetsmap
(
        'LAST_MODIFIED'         =   '@LAST_MODIFIED',
        'VERSION'               =   '@VERSION'          ON INSERT ONLY,
        'LABEL'                 =   '@LABEL',
        'DESCRIPTION'           =   '@DESCRIPTION',
        'SUBTYPE'               =   '@SUBTYPE',
        'CREATED_BY'            =   '@CREATED_BY',
        'CREATED_ON'            =   '@CREATED_ON',
        'ID1'                   =   '@ID1'              ON INSERT ONLY,
        'PROVIDER_TYPE'         =   '@PROVIDER_TYPE'    ON INSERT ONLY,
        'DESIGN'                =   '@DESIGN',
        'DATA_SOURCE_TYPE'      =   '@DATA_SOURCE_TYPE' ON INSERT ONLY,
        'RESOURCEBUNDLE'        =   '@RESOURCEBUNDLE',
        'SCHEMA_ID'             =   '@SCHEMA_ID',
        'FORMAT1'               =   '@FORMAT1',
        'LAST_MODIFIED_BY'      =   '@LAST_MODIFIED_BY',
        'SCHEMA_VERSION'        =   '@SCHEMA_VERSION'
);

CREATE MAPPING dashhawidgetdatasetsmap
(
        'WIDGET_ID'             =   '@WIDGET_ID'        ON INSERT ONLY,
        'PROVIDER_TYPE'         =   '@PROVIDER_TYPE'    ON INSERT ONLY,
        'DATA_SET_ID'           =   '@DATA_SET_ID'      ON INSERT ONLY,
        'WIDGET_VERSION'        =   '@WIDGET_VERSION'   ON INSERT ONLY,
        'DATA_SOURCE_TYPE'      =   '@DATA_SOURCE_TYPE' ON INSERT ONLY
);

CREATE MAPPING dashhawidgetgroupsmap
(
        'DATA_SOURCE_TYPE'      =   '@DATA_SOURCE_TYPE' ON INSERT ONLY,
        'WIDGET_ID'             =   '@WIDGET_ID'        ON INSERT ONLY,
        'PROVIDER_TYPE'         =   '@PROVIDER_TYPE'    ON INSERT ONLY,
        'GROUP_ID'              =   '@GROUP_ID'         ON INSERT ONLY,
        'WIDGET_VERSION'        =   '@WIDGET_VERSION'   ON INSERT ONLY
);

CREATE MAPPING dashhawidgetschemamap
(
        'RESOURCE_BUNDLE'       =   '@RESOURCE_BUNDLE',
        'DESCRIPTION'           =   '@DESCRIPTION',
        'LABEL'                 =   '@LABEL',
        'WIDGET_SCHEMA'         =   '@WIDGET_SCHEMA',
        'VERSION'               =   '@VERSION'          ON INSERT ONLY,
        'ID1'                   =   '@ID1'              ON INSERT ONLY
);

CREATE MAPPING dashhaxmldocumentsmap
(
        'XML_DOCUMENT'          =   '@XML_DOCUMENT',
        'ID1'                   =   '@ID1'              ON INSERT ONLY
);

CREATE MAPPING dashhatransformationsmap
(
        'DATA'                  = '@DATA',
        'DUMMI'                 = '@DUMMI' ON INSERT ONLY,
        'FILENAME'              = '@FILENAME',
        'FOLDER'                = '@FOLDER',
        'LAST_UPDATED'          = '@LAST_UPDATED'
);

CREATE MAPPING dashhawiresmap
(
        'DATA'                  = '@DATA',
        'DUMMI'                 = '@DUMMI' ON INSERT ONLY,
        'FILENAME'              = '@FILENAME',
        'FOLDER'                = '@FOLDER',
        'LAST_UPDATED'          = '@LAST_UPDATED'
);

##############################################################################
# WebGUI HA table mapping

CREATE MAPPING NcwHaConfigItemsMap
(
       'ConfigItemId'           =   '@ConfigItemId' ON INSERT ONLY,
       'Type'                   =   '@Type',
       'ConfigItemContentId'    =   '@ConfigItemContentId',
       'Key'                    =   '@Key',
       'Namespace'              =   '@Namespace',
       'Checksum'               =   '@Checksum',
       'Path'                   =   '@Path',
       'LastUpdated'            =   '@LastUpdated',
       'LastUpdatedText'        =   '@LastUpdatedText'
);
CREATE MAPPING NcwHaConfigItemsContentMap
(
       'ContentId'              =   '@ContentId' ON INSERT ONLY,
       'PartNumber'             =   '@PartNumber',
       'Key'                    =   '@Key',
       'ConfigItemIdRef'        =   '@ConfigItemIdRef',
       'Content'                =   '@Content'
);
CREATE MAPPING NcwHaNodesMap
(
       'Uri'                    =   '@Uri' ON INSERT ONLY,
       'NodeId'                 =   '@NodeId' ON INSERT ONLY
);
CREATE MAPPING NcwHaNodesConfigItemsMap
(
       'AssociationId'          =   '@AssociationId' ON INSERT ONLY,
       'ConfigItemId'           =   '@ConfigItemId',
       'LastUpdated'            =   '@LastUpdated',
       'LastUpdatedText'        =   '@LastUpdatedText',
       'NodeId'                 =   '@NodeId'
);

##############################################################################
# End: DASH table mapping definitions
##############################################################################