﻿<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE database [
  <!ENTITY ID_FILTER_UNKOWN	"0">
	<!ENTITY ID_FILTER_AV 		"1">
	<!ENTITY ID_FILTER_CF 		"2">
	<!ENTITY ID_FILTER_AB 		"4">
	<!ENTITY ID_FILTER_US 		"64">
	<!ENTITY ID_FILTER_WTP    	"128">
	<!ENTITY ID_FILTER_DLP		"512">
  <!ENTITY SR_UNKNOWN       "0">
  <!ENTITY SR_QUARANTINE    "1">
  <!ENTITY SR_BACKUP        "2">
  <!ENTITY SR_ARCHIVE       "3">
  <!ENTITY _POSTFIX   SYSTEM        "dbcfg_Postfix.txt">
  <!ENTITY POSTFIX                  "&_POSTFIX;">
]>
<database>
  <schema>
    <table name="tblMsgEntries">
      <field name="msg_entry_id"           type="identity"  primary-key="primary-key"/>
      <field name="msg_task_id"            type="integer"   default="0"/>
      <field name="msg_protocol"           type="integer"   default="0"/>
      <field name="msg_found_at"           type="text"      size="255" allow-null="true"/>
      <field name="msg_source"             type="text"      size="255" allow-null="true"/>
      <field name="msg_destination"        type="text"      size="255" allow-null="true"/>
      <field name="msg_subject"            type="text"      size="255" allow-null="true"/>
      <field name="msg_delivery_time"      type="datetime"  default="0"/>
      <field name="msg_submit_time"        type="datetime"  default="0"/>
    </table>
    <table name="tblFilterEntries">
      <field name="filter_entry_id"        type="identity"  primary-key="primary-key"/>
      <field name="msg_entry_id"           type="integer"   allow-null="false" index="asc" constraint="FK_msg_entry_id&POSTFIX; foreign key (msg_entry_id) REFERENCES tblMsgEntries&POSTFIX; (msg_entry_id)" constraintid="FK_msg_entry_id"/>
      <field name="filter_id"              type="smallint"  default="&ID_FILTER_UNKOWN;" index="asc"/>
      <field name="filter_rule"            type="text"      size="255" allow-null="true"/>
      <field name="filter_rule_supplement" type="integer"   default="0"/>
      <field name="filter_engine"          type="text"      size="32" default="0"/>
      <field name="filter_pattern"         type="integer"   default="0"/>
      <field name="filter_action"          type="integer"   default="0"/>
      <field name="filter_scan_time"       type="datetime"  default="0" index="desc"/>
      <field name="filter_reason"          type="text"      size="255" allow-null="true"/>
      <field name="file_original"          type="text"      size="255" allow-null="true"/>
      <field name="sent_to_csm"            type="smallint"  default="0"/>
    </table>
    <table name="tblStorageEntries">
      <field name="storage_entry_id"       type="identity"  primary-key="primary-key"/>
      <field name="msg_entry_id"           type="integer"   allow-null="false" index="index" constraint="FK_msg_entry_id_&POSTFIX; foreign key (msg_entry_id) REFERENCES tblMsgEntries&POSTFIX; (msg_entry_id)" constraintid="FK_msg_entry_id_"/>
      <field name="msg_destination_full"   type="longtext"  allow-null="true"/>
      <field name="filter_scan_time"       type="datetime"  default="0" allow-null="true" index="desc"/>
      <field name="filter_entry_id"        type="integer"   allow-null="true"/>
      <field name="filter_id"              type="smallint"  default="0" allow-null="true" index="index"/>
      <field name="filter_action"          type="integer"   default="0" allow-null="true"/>
      <field name="filter_rule"            type="text"      size="255"  allow-null="true"/>
      <field name="file_original"          type="text"      size="255" allow-null="true"/>
      <field name="storage_guid"           type="guid"      allow-null="true"/>
      <field name="storage_reason"         type="smallint"  default="0"/>
      <field name="storage_path"           type="text"      size="255" allow-null="true"/>
      <field name="storage_type"           type="smallint"  default="0"/>
      <field name="storage_resend_count"   type="smallint"  default="0"/>
      <field name="sent_to_csm"            type="smallint"  default="0"/>
    </table>
    <table name="tblActivityEntries">
      <field name="activity_entry_id"      type="identity"  primary-key="primary-key"/>
      <field name="activity_severity"      type="integer"   default="0"/>
      <field name="activity_id"            type="integer"   default="134217726"/>
      <field name="activity_time"          type="datetime"  default="0"/>
      <field name="activity_description"   type="longtext"  allow-null="true"/>
      <field name="activity_parameters"    type="longtext"  allow-null="true"/>
      <field name="activity_duration_mark" type="smallint"  default="0"/>
      <field name="sent_to_csm"            type="smallint"  default="0"/>
    </table>
	<table name="tblAuditLog">
      <field name="storage_entry_id"       type="identity"  primary-key="primary-key"/>
      <field name="ServerName"             type="text"      size="255" allow-null="true"/>
      <field name="EventTime"              type="datetime"  default="0"/>
	  <field name="UserName"               type="text"      size="255" allow-null="true"/> 
      <field name="IpAddress"              type="text"      size="255" allow-null="true"/>
      <field name="EventType"              type="smallint"  default="0"/>
      <field name="SourceType"             type="smallint"  default="0"/>
      <field name="LogDescription"         type="longtext"  allow-null="true"/>    
    </table>
    <table name="tblManagementGroupList">
      <field name="mgl_id"                 type="identity"  primary-key="primary-key"/>
      <field name="mgl_group_name"         type="longtext"  allow-null="false"/>
    </table>
    <table name="tblManagementServerList">
      <field name="msl_id"                 type="identity"  primary-key="primary-key"/>
      <field name="msl_server_name"        type="longtext"  allow-null="true"/>
      <field name="msl_group_id"           type="integer"   default="0" constraint="FK_mgl_group_entry_id&POSTFIX;  foreign key (msl_group_id) REFERENCES tblManagementGroupList&POSTFIX; (mgl_id)" constraintid="FK_mgl_group_entry_id"/>
    </table>
    <table name="tblManagementGroupMemberList">
      <field name="mgml_id"                type="identity"  primary-key="primary-key"/>
      <field name="mgml_group_id"          type="integer"   default="0" constraint="FK_mgl_group_id&POSTFIX; foreign key (mgml_group_id) REFERENCES tblManagementGroupList&POSTFIX; (mgl_id)" constraintid="FK_mgl_group_id"/>
      <field name="mgml_server_id"         type="integer"   default="0" constraint="FK_mgl_server_id&POSTFIX; foreign key (mgml_server_id) REFERENCES tblManagementServerList&POSTFIX; (msl_id)" constraintid="FK_mgl_server_id"/>
    </table>
    <table name="tblScanningSummary">
      <field name="ss_id"                  type="identity"  primary-key="primary-key"/>
      <field name="ss_type"                type="integer"   allow-null="false"/>
      <field name="ss_time"                type="datetime"  default="0"/>
      <field name="ss_count"               type="integer"   default="0"/>
    </table>
    <table name="tblPatternEngineInfo">
      <field name="pei_type"               type="integer"   primary-key="primary-key"/>
      <field name="pei_current_version"    type="longtext"  default=""/>
      <field name="pei_latest_version"     type="longtext"  default=""/>
      <field name="pei_last_query_time"    type="datetime"  default="0"/>
      <field name="pei_last_update_time"   type="datetime"  default="0"/>
      <field name="pei_last_successful_update_time" type="datetime" default="0"/>
      <field name="pei_last_upate_status"  type="integer"   default="0"/>
      <field name="pei_last_update_status_description" type="longtext" default=""/>
      <instance pei_type="1"/>
      <instance pei_type="2"/>
      <!--<instance pei_type="4"/>-->
      <!--<instance pei_type="8"/>-->
      <instance pei_type="16"/>
      <!--<instance pei_type="32"/>-->
      <instance pei_type="64"/>
      <instance pei_type="128"/>
      <instance pei_type="256"/>
      <instance pei_type="512"/>
    </table>
    <table name="tblCfgReplication">
      <field name="cr_session_guid"        type="guid"      primary-key="primary-key"/>
      <field name="cr_time"                type="datetime"  default="0"/>
      <field name="cr_server_list"         type="longtext"  default=""/>
      <field name="cr_selection_list"      type="longtext"  default=""/>
      <field name="cr_id"                  type="identity"  allow-null="false"/>
    </table>
    <table name="tblCfgReplicationStatus">
      <field name="crs_id"                 type="identity"  primary-key="primary-key"/>
      <field name="crs_session_guid"       type="guid"      allow-null="true"/>
      <field name="crs_start_time"         type="datetime"  default="0"/>
      <field name="crs_end_time"           type="datetime"  default="0"/>
      <field name="crs_server"             type="longtext"  default=""/>
      <field name="crs_status"             type="integer"   default="0"/>
      <field name="crs_description"        type="longtext"  default=""/>
    </table>
    <table name="tblCfgReplicationHistory">
      <field name="crh_id"                 type="identity"  primary-key="primary-key"/>
      <field name="crh_session_guid"       type="guid"      allow-null="true"/>
      <field name="crh_time"               type="datetime"  default="0"/>
    </table>
    <view name="vwMsgFilterEntriesTmp">
      <from>
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblFilterEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblFilterEntries"/>
        </inner-join>
      </from>
      <column name="msg_entry_id"          from-table="tblFilterEntries"     from-field="msg_entry_id" />
      <column name="msg_delivery_time"     from-table="tblMsgEntries"        from-field="msg_delivery_time"/>
      <column name="msg_found_at"          from-table="tblMsgEntries"        from-field="msg_found_at"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_entry_id"       from-table="tblFilterEntries"     from-field="filter_entry_id"/>
      <column name="filter_id"             from-table="tblFilterEntries"     from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblFilterEntries"     from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblFilterEntries"     from-field="filter_rule"/>
      <column name="file_original"         from-table="tblFilterEntries"     from-field="file_original"/>
      <column name="filter_action"         from-table="tblFilterEntries"     from-field="filter_action"/>
      <column name="filter_reason"         from-table="tblFilterEntries"     from-field="filter_reason"/>
      <column name="filter_rule_supplement"         from-table="tblFilterEntries"     from-field="filter_rule_supplement"/>
    </view>
    <view name="vwMsgFilterEntries">
      <from>
        <left-join on="((vwMsgFilterEntriesTmp&POSTFIX;.msg_entry_id = tblStorageEntries&POSTFIX;.msg_entry_id) AND (vwMsgFilterEntriesTmp&POSTFIX;.filter_entry_id = tblStorageEntries&POSTFIX;.filter_entry_id))">
          <table name="vwMsgFilterEntriesTmp"/>
          <table name="tblStorageEntries"/>
        </left-join>
      </from>
      <column name="filter_scan_time"      from-table="vwMsgFilterEntriesTmp" from-field="filter_scan_time"/>
      <column name="msg_delivery_time"     from-table="vwMsgFilterEntriesTmp" from-field="msg_delivery_time"/>
      <column name="msg_found_at"          from-table="vwMsgFilterEntriesTmp" from-field="msg_found_at"/>
      <column name="msg_source"            from-table="vwMsgFilterEntriesTmp" from-field="msg_source"/>
      <column name="msg_destination"       from-table="vwMsgFilterEntriesTmp" from-field="msg_destination"/>
      <column name="msg_subject"           from-table="vwMsgFilterEntriesTmp" from-field="msg_subject"/>
      <column name="filter_rule"           from-table="vwMsgFilterEntriesTmp" from-field="filter_rule"/>
      <column name="filter_reason"         from-table="vwMsgFilterEntriesTmp" from-field="filter_reason"/>
      <column name="file_original"         from-table="vwMsgFilterEntriesTmp" from-field="file_original"/>
      <column name="msg_entry_id"          from-table="vwMsgFilterEntriesTmp" from-field="msg_entry_id" />
      <column name="filter_id"             from-table="vwMsgFilterEntriesTmp" from-field="filter_id"/>
      <column name="filter_action"         from-table="vwMsgFilterEntriesTmp" from-field="filter_action"/>
      <column name="filter_rule_supplement"         from-table="vwMsgFilterEntriesTmp" from-field="filter_rule_supplement"/>
      <column name="storage_entry_id"      from-table="tblStorageEntries"     from-field="storage_entry_id"/>
      <column name="storage_path"          from-table="tblStorageEntries"     from-field="storage_path"/>
      <column name="storage_reason"        from-table="tblStorageEntries"     from-field="storage_reason"/>
    </view>
    <view name="vwMsgStorageEntries">
      <from>
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblStorageEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblStorageEntries"/>
        </inner-join>
      </from>
      <column name="storage_entry_id"      from-table="tblStorageEntries"    from-field="storage_entry_id"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblStorageEntries"    from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblStorageEntries"    from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblStorageEntries"    from-field="filter_rule"/>
      <column name="file_original"         from-table="tblStorageEntries"    from-field="file_original"/>
      <column name="filter_action"         from-table="tblStorageEntries"    from-field="filter_action"/>
      <column name="storage_reason"        from-table="tblStorageEntries"    from-field="storage_reason"/>
      <column name="storage_resend_count"  from-table="tblStorageEntries"    from-field="storage_resend_count"/>
    </view>
    <view name="vwAVLogs">
      <!--<from where="filter_id = &ID_FILTER_AV; And Not ((vwMsgFilterEntries.filter_action=29 OR vwMsgFilterEntries.filter_action=23 OR vwMsgFilterEntries.filter_action=73) And (vwMsgFilterEntries.storage_reason is not null and(vwMsgFilterEntries.storage_reason=&SR_BACKUP; Or vwMsgFilterEntries.storage_reason=&SR_ARCHIVE;)))">-->
	  <from where="filter_id = &ID_FILTER_AV; And Not ((vwMsgFilterEntries&POSTFIX;.filter_action=28 OR vwMsgFilterEntries&POSTFIX;.filter_action=34 OR vwMsgFilterEntries&POSTFIX;.filter_action=73 OR vwMsgFilterEntries&POSTFIX;.filter_action=38 OR vwMsgFilterEntries&POSTFIX;.filter_action=136 OR vwMsgFilterEntries&POSTFIX;.filter_action= 139) And (vwMsgFilterEntries&POSTFIX;.storage_reason is not null and(vwMsgFilterEntries&POSTFIX;.storage_reason=&SR_BACKUP; Or vwMsgFilterEntries&POSTFIX;.storage_reason=&SR_ARCHIVE;)))">
		<table name="vwMsgFilterEntries"/>
      </from>
      <column name="storage_entry_id"      from-table="vwMsgFilterEntries"   from-field="storage_entry_id"/>
      <column name="filter_scan_time"      from-table="vwMsgFilterEntries"   from-field="filter_scan_time"/>
      <column name="msg_delivery_time"     from-table="vwMsgFilterEntries"   from-field="msg_delivery_time"/>
      <column name="msg_source"            from-table="vwMsgFilterEntries"   from-field="msg_source"/>
      <column name="msg_destination"       from-table="vwMsgFilterEntries"   from-field="msg_destination"/>
      <column name="msg_subject"           from-table="vwMsgFilterEntries"   from-field="msg_subject"/>
      <column name="filter_rule_av"        from-table="vwMsgFilterEntries"   from-field="filter_rule"/>
      <column name="filter_action"         from-table="vwMsgFilterEntries"   from-field="filter_action"/>
      <column name="file_original"         from-table="vwMsgFilterEntries"   from-field="file_original"/>
      <column name="msg_found_at"          from-table="vwMsgFilterEntries"   from-field="msg_found_at"/>
      <column name="filter_reason_av"         from-table="vwMsgFilterEntries"   from-field="filter_reason"/>
      <column name="filter_rule_supplement"          from-table="vwMsgFilterEntries"   from-field="filter_rule_supplement"/>
    </view>
    <view name="vwCFLogs">
      <from where="filter_id = &ID_FILTER_CF;">
        <table name="vwMsgFilterEntries"/>
      </from>
      <column name="storage_entry_id"      from-table="vwMsgFilterEntries"   from-field="storage_entry_id"/>
      <column name="filter_scan_time"      from-table="vwMsgFilterEntries"   from-field="filter_scan_time"/>
      <column name="msg_delivery_time"     from-table="vwMsgFilterEntries"   from-field="msg_delivery_time"/>
      <column name="msg_source"            from-table="vwMsgFilterEntries"   from-field="msg_source"/>
      <column name="msg_destination"       from-table="vwMsgFilterEntries"   from-field="msg_destination"/>
      <column name="msg_subject"           from-table="vwMsgFilterEntries"   from-field="msg_subject"/>
      <column name="filter_rule_cf"        from-table="vwMsgFilterEntries"   from-field="filter_rule"/>
      <column name="filter_action"         from-table="vwMsgFilterEntries"   from-field="filter_action"/>
      <column name="file_original_cf"         from-table="vwMsgFilterEntries"   from-field="file_original"/>
      <column name="filter_reason"         from-table="vwMsgFilterEntries"   from-field="filter_reason"/>
      <column name="msg_found_at"          from-table="vwMsgFilterEntries"   from-field="msg_found_at"/>
    </view>
    <view name="vwABLogs">
      <from where="filter_id = &ID_FILTER_AB;">
        <table name="vwMsgFilterEntries"/>
      </from>
      <column name="storage_entry_id"      from-table="vwMsgFilterEntries"   from-field="storage_entry_id"/>
      <column name="filter_scan_time"      from-table="vwMsgFilterEntries"   from-field="filter_scan_time"/>
      <column name="msg_delivery_time"     from-table="vwMsgFilterEntries"   from-field="msg_delivery_time"/>
      <column name="msg_source"            from-table="vwMsgFilterEntries"   from-field="msg_source"/>
      <column name="msg_destination"       from-table="vwMsgFilterEntries"   from-field="msg_destination"/>
      <column name="msg_subject"           from-table="vwMsgFilterEntries"   from-field="msg_subject"/>
      <column name="filter_rule_cf"        from-table="vwMsgFilterEntries"   from-field="filter_rule"/>
      <column name="filter_action"         from-table="vwMsgFilterEntries"   from-field="filter_action"/>
      <column name="file_original"         from-table="vwMsgFilterEntries"   from-field="file_original"/>
      <column name="filter_reason_ab"         from-table="vwMsgFilterEntries"   from-field="filter_reason"/>
      <column name="msg_found_at"          from-table="vwMsgFilterEntries"   from-field="msg_found_at"/>
    </view>
    <view name="vwWTPLogs">
      <from where="filter_id = &ID_FILTER_WTP;">
        <table name="vwMsgFilterEntries"/>
      </from>
	  <column name="storage_entry_id"      from-table="vwMsgFilterEntries"   from-field="storage_entry_id"/>
      <column name="filter_scan_time"      from-table="vwMsgFilterEntries"   from-field="filter_scan_time"/>
      <column name="msg_delivery_time"     from-table="vwMsgFilterEntries"   from-field="msg_delivery_time"/>
      <column name="msg_source"            from-table="vwMsgFilterEntries"   from-field="msg_source"/>
      <column name="msg_destination"       from-table="vwMsgFilterEntries"   from-field="msg_destination"/>
      <column name="msg_subject"           from-table="vwMsgFilterEntries"   from-field="msg_subject"/>
      <column name="filter_rule_uf"        from-table="vwMsgFilterEntries"   from-field="filter_rule"/>
      <column name="file_original_wtp"         from-table="vwMsgFilterEntries"   from-field="file_original"/>
      <column name="suspicious_url"        from-table="vwMsgFilterEntries"   from-field="filter_reason"/>
      <column name="filter_action"         from-table="vwMsgFilterEntries"   from-field="filter_action"/>
      <column name="msg_found_at"          from-table="vwMsgFilterEntries"   from-field="msg_found_at"/>
    </view>
	<view name="vwDLPLogs">
      <from where="filter_id = &ID_FILTER_DLP;">
        <table name="vwMsgFilterEntries"/>
      </from>
	   <column name="storage_entry_id"      from-table="vwMsgFilterEntries"   from-field="storage_entry_id"/>
      <column name="filter_scan_time"      from-table="vwMsgFilterEntries"   from-field="filter_scan_time"/>
      <column name="msg_delivery_time"     from-table="vwMsgFilterEntries"   from-field="msg_delivery_time"/>
      <column name="msg_source"            from-table="vwMsgFilterEntries"   from-field="msg_source"/>
      <column name="msg_destination"       from-table="vwMsgFilterEntries"   from-field="msg_destination"/>
      <column name="msg_subject"           from-table="vwMsgFilterEntries"   from-field="msg_subject"/>
      <column name="filter_rule_dlp"        from-table="vwMsgFilterEntries"   from-field="filter_rule"/>
      <column name="filter_action"         from-table="vwMsgFilterEntries"   from-field="filter_action"/>
      <column name="file_original_dlp"         from-table="vwMsgFilterEntries"   from-field="file_original"/>
      <column name="filter_template"         from-table="vwMsgFilterEntries"   from-field="filter_reason"/>
      <column name="msg_found_at"          from-table="vwMsgFilterEntries"   from-field="msg_found_at"/>
    </view>
    <view name="vwUSLogs">
      <from where="filter_id = &ID_FILTER_US; AND NOT((vwMsgFilterEntries&POSTFIX;.filter_action=28 OR vwMsgFilterEntries&POSTFIX;.filter_action=34 OR vwMsgFilterEntries&POSTFIX;.filter_action=73) AND (vwMsgFilterEntries&POSTFIX;.storage_reason IS NOT NULL AND (vwMsgFilterEntries&POSTFIX;.storage_reason=&SR_BACKUP; OR vwMsgFilterEntries&POSTFIX;.storage_reason=&SR_ARCHIVE;)))">
        <table name="vwMsgFilterEntries"/>
      </from>
      <column name="storage_entry_id"      from-table="vwMsgFilterEntries"   from-field="storage_entry_id"/>
      <column name="filter_scan_time"      from-table="vwMsgFilterEntries"   from-field="filter_scan_time"/>
      <column name="msg_delivery_time"     from-table="vwMsgFilterEntries"   from-field="msg_delivery_time"/>
      <column name="msg_source"            from-table="vwMsgFilterEntries"   from-field="msg_source"/>
      <column name="msg_destination"       from-table="vwMsgFilterEntries"   from-field="msg_destination"/>
      <column name="msg_subject"           from-table="vwMsgFilterEntries"   from-field="msg_subject"/>
      <column name="filter_rule_us"        from-table="vwMsgFilterEntries"   from-field="filter_rule"/>
      <column name="filter_action"         from-table="vwMsgFilterEntries"   from-field="filter_action"/>
	  <column name="file_original"         from-table="vwMsgFilterEntries"   from-field="file_original"/>    
	  <column name="msg_found_at"          from-table="vwMsgFilterEntries"   from-field="msg_found_at"/>
    </view>
    <view name="vwQuarantineLogs">
      <from where="storage_reason = &SR_QUARANTINE;">
        <table name="vwMsgStorageEntries"/>
      </from>
      <column name="storage_entry_id"      from-table="vwMsgStorageEntries"  from-field="storage_entry_id"/>
      <column name="filter_scan_time"      from-table="vwMsgStorageEntries"  from-field="filter_scan_time"/>
      <column name="msg_source"            from-table="vwMsgStorageEntries"  from-field="msg_source"/>
      <column name="msg_destination"       from-table="vwMsgStorageEntries"  from-field="msg_destination"/>
      <column name="msg_subject"           from-table="vwMsgStorageEntries"  from-field="msg_subject"/>
      <column name="filter_rule"           from-table="vwMsgStorageEntries"  from-field="filter_rule"/>
      <column name="storage_resend_count"  from-table="vwMsgStorageEntries"  from-field="storage_resend_count"/>
    </view>
 		<!-- ============================== CSM Log views ======================================= -->
		<!-- vwCSMIncidenceLogs -->
		<view name="vwCSMIncidenceLogs">
      <from>
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblFilterEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblFilterEntries"/>
        </inner-join>
      </from>
      <column name="msg_task_id"					 from-table="tblMsgEntries"				 from-field="msg_task_id"/>
      <column name="msg_delivery_time"     from-table="tblMsgEntries"        from-field="msg_delivery_time"/>
      <column name="msg_found_at"          from-table="tblMsgEntries"        from-field="msg_found_at"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblFilterEntries"     from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblFilterEntries"     from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblFilterEntries"     from-field="filter_rule"/>
      <column name="file_original"         from-table="tblFilterEntries"     from-field="file_original"/>
      <column name="filter_action"         from-table="tblFilterEntries"     from-field="filter_action"/>
      <column name="sent_to_csm"       		 from-table="tblFilterEntries"     from-field="sent_to_csm"/>
      <column name="filter_entry_id"       from-table="tblFilterEntries"     from-field="filter_entry_id"/>
		</view>
		<!-- vwCSMVSLogs -->
		<view name="vwCSMVSLogs">
      <from where="filter_id = &ID_FILTER_AV;">
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblFilterEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblFilterEntries"/>
        </inner-join>
      </from>
      <column name="msg_task_id"					 from-table="tblMsgEntries"				 from-field="msg_task_id"/>
      <column name="msg_delivery_time"     from-table="tblMsgEntries"        from-field="msg_delivery_time"/>
      <column name="msg_found_at"          from-table="tblMsgEntries"        from-field="msg_found_at"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblFilterEntries"     from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblFilterEntries"     from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblFilterEntries"     from-field="filter_rule"/>
      <column name="file_original"         from-table="tblFilterEntries"     from-field="file_original"/>
      <column name="filter_action"         from-table="tblFilterEntries"     from-field="filter_action"/>
      <column name="sent_to_csm"       		 from-table="tblFilterEntries"     from-field="sent_to_csm"/>
      <column name="filter_entry_id"       from-table="tblFilterEntries"     from-field="filter_entry_id"/>
		</view>
		<!-- vwCSMABLogs -->
		<view name="vwCSMABLogs">
      <from where="filter_id = &ID_FILTER_AB;">
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblFilterEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblFilterEntries"/>
        </inner-join>
      </from>
      <column name="msg_task_id"					 from-table="tblMsgEntries"				 from-field="msg_task_id"/>
      <column name="msg_delivery_time"     from-table="tblMsgEntries"        from-field="msg_delivery_time"/>
      <column name="msg_found_at"          from-table="tblMsgEntries"        from-field="msg_found_at"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblFilterEntries"     from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblFilterEntries"     from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblFilterEntries"     from-field="filter_rule"/>
      <column name="file_original"         from-table="tblFilterEntries"     from-field="file_original"/>
      <column name="filter_action"         from-table="tblFilterEntries"     from-field="filter_action"/>
      <column name="sent_to_csm"       		 from-table="tblFilterEntries"     from-field="sent_to_csm"/>
      <column name="filter_entry_id"       from-table="tblFilterEntries"     from-field="filter_entry_id"/>
		</view>
		<!-- vwCSMCFLogs -->
		<view name="vwCSMCFLogs">
      <from where="filter_id = &ID_FILTER_CF;">
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblFilterEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblFilterEntries"/>
        </inner-join>
      </from>
      <column name="msg_task_id"					 from-table="tblMsgEntries"				 from-field="msg_task_id"/>
      <column name="msg_delivery_time"     from-table="tblMsgEntries"        from-field="msg_delivery_time"/>
      <column name="msg_found_at"          from-table="tblMsgEntries"        from-field="msg_found_at"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblFilterEntries"     from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblFilterEntries"     from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblFilterEntries"     from-field="filter_rule"/>
      <column name="file_original"         from-table="tblFilterEntries"     from-field="file_original"/>
      <column name="filter_action"         from-table="tblFilterEntries"     from-field="filter_action"/>
      <column name="sent_to_csm"       		 from-table="tblFilterEntries"     from-field="sent_to_csm"/>
      <column name="filter_entry_id"       from-table="tblFilterEntries"     from-field="filter_entry_id"/>
		</view>
		<!-- vwCSMUSLogs -->
    <view name="vwCSMUSLogs">
      <from where="filter_id = &ID_FILTER_US;">
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblFilterEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblFilterEntries"/>
        </inner-join>
      </from>
      <column name="msg_task_id"					 from-table="tblMsgEntries"				 from-field="msg_task_id"/>
      <column name="msg_delivery_time"     from-table="tblMsgEntries"        from-field="msg_delivery_time"/>
      <column name="msg_found_at"          from-table="tblMsgEntries"        from-field="msg_found_at"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblFilterEntries"     from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblFilterEntries"     from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblFilterEntries"     from-field="filter_rule"/>
      <column name="file_original"         from-table="tblFilterEntries"     from-field="file_original"/>
      <column name="filter_action"         from-table="tblFilterEntries"     from-field="filter_action"/>
      <column name="sent_to_csm"       		 from-table="tblFilterEntries"     from-field="sent_to_csm"/>
      <column name="filter_entry_id"       from-table="tblFilterEntries"     from-field="filter_entry_id"/>
    </view>
		<!-- vwCSMStorageLogs -->
		<view name="vwCSMStorageLogs">
      <from>
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblStorageEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblStorageEntries"/>
        </inner-join>
      </from>
      <column name="storage_entry_id"      from-table="tblStorageEntries"    from-field="storage_entry_id"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblStorageEntries"    from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblStorageEntries"    from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblStorageEntries"    from-field="filter_rule"/>
      <column name="file_original"         from-table="tblStorageEntries"    from-field="file_original"/>
      <column name="filter_action"         from-table="tblStorageEntries"    from-field="filter_action"/>
      <column name="storage_reason"        from-table="tblStorageEntries"    from-field="storage_reason"/>
      <column name="storage_resend_count"  from-table="tblStorageEntries"    from-field="storage_resend_count"/>
      <column name="storage_path"				   from-table="tblStorageEntries"    from-field="storage_path"/>
      <column name="sent_to_csm" 					 from-table="tblStorageEntries"    from-field="sent_to_csm"/>
      <column name="filter_entry_id"  		 from-table="tblStorageEntries"    from-field="filter_entry_id"/>
		</view>
		<!-- vwCSMBackupLogs -->
		<view name="vwCSMBackupLogs">
      <from where="storage_reason = &SR_BACKUP;">
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblStorageEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblStorageEntries"/>
        </inner-join>
      </from>
      <column name="storage_entry_id"      from-table="tblStorageEntries"    from-field="storage_entry_id"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblStorageEntries"    from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblStorageEntries"    from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblStorageEntries"    from-field="filter_rule"/>
      <column name="file_original"         from-table="tblStorageEntries"    from-field="file_original"/>
      <column name="filter_action"         from-table="tblStorageEntries"    from-field="filter_action"/>
      <column name="storage_reason"        from-table="tblStorageEntries"    from-field="storage_reason"/>
      <column name="storage_resend_count"  from-table="tblStorageEntries"    from-field="storage_resend_count"/>
      <column name="storage_path"				   from-table="tblStorageEntries"    from-field="storage_path"/>
      <column name="sent_to_csm" 					 from-table="tblStorageEntries"    from-field="sent_to_csm"/>
      <column name="filter_entry_id"  		 from-table="tblStorageEntries"    from-field="filter_entry_id"/>
		</view>
		<!-- vwCSMArchiveLogs -->
		<view name="vwCSMArchiveLogs">
      <from where="storage_reason = &SR_ARCHIVE;">
        <inner-join on="tblMsgEntries&POSTFIX;.msg_entry_id = tblStorageEntries&POSTFIX;.msg_entry_id">
          <table name="tblMsgEntries"/>
          <table name="tblStorageEntries"/>
        </inner-join>
      </from>
      <column name="storage_entry_id"      from-table="tblStorageEntries"    from-field="storage_entry_id"/>
      <column name="msg_source"            from-table="tblMsgEntries"        from-field="msg_source"/>
      <column name="msg_destination"       from-table="tblMsgEntries"        from-field="msg_destination"/>
      <column name="msg_subject"           from-table="tblMsgEntries"        from-field="msg_subject"/>
      <column name="filter_id"             from-table="tblStorageEntries"    from-field="filter_id"/>
      <column name="filter_scan_time"      from-table="tblStorageEntries"    from-field="filter_scan_time"/>
      <column name="filter_rule"           from-table="tblStorageEntries"    from-field="filter_rule"/>
      <column name="file_original"         from-table="tblStorageEntries"    from-field="file_original"/>
      <column name="filter_action"         from-table="tblStorageEntries"    from-field="filter_action"/>
      <column name="storage_reason"        from-table="tblStorageEntries"    from-field="storage_reason"/>
      <column name="storage_resend_count"  from-table="tblStorageEntries"    from-field="storage_resend_count"/>
      <column name="storage_path"				   from-table="tblStorageEntries"    from-field="storage_path"/>
      <column name="sent_to_csm" 					 from-table="tblStorageEntries"    from-field="sent_to_csm"/>
      <column name="filter_entry_id"  		 from-table="tblStorageEntries"    from-field="filter_entry_id"/>
		</view>
  </schema>
</database>
