﻿<?xml version="1.0" encoding="utf-8"?>
<database>
  <schema>
    <table name="tblSummary">
      <field name="id"                                      type="identity" primary-key="primary-key"/>
      <field name="summary_datetime"                        type="datetime" default="0"/>
      <field name="summary_total_message_count"             type="integer"  default="0"/>
      <field name="summary_total_attachment_count"          type="integer"  default="0"/>
      <field name="summary_virus_detected_count"            type="integer"  default="0"/>
      <field name="summary_virus_uncleanable_count"         type="integer"  default="0"/>
      <field name="summary_attachment_blocked_count"        type="integer"  default="0"/>
      <field name="summary_content_filtered_count"          type="integer"  default="0"/>
      <field name="summary_dlp_filtered_count"          type="integer"  default="0"/>
      <field name="summary_spam_detected_count"             type="integer"  default="0"/>
      <field name="summary_phish_detected_count"            type="integer"  default="0"/>
      <field name="summary_false_positive_count"            type="integer"  default="0"/>
      <field name="summary_unscannable_entity_count"        type="integer"  default="0"/>
      <field name="sent_to_csm"                             type="smallint" default="0"/>
      <field name="summary_ers_count"                       type="integer"  default="0"/>
      <field name="summary_suspicious_url_count"            type="integer"  default="0"/>
      <field name="summary_spyware_detected_count"          type="integer"  default="0"/>
    </table>

    <table name="tblSpamInfo">
      <field name="id"                                      type="identity" primary-key="primary-key"/>
      <field name="spaminfo_datetime"                       type="datetime" default="0"/>
      <field name="spaminfo_cate_id"                        type="integer"  default="0"/>
      <field name="spaminfo_value"                          type="text"     size="64"  default=""/>
      <field name="spaminfo_count"                          type="integer"  default="0"/>
    </table>

    <table name="tblContentInfo">
      <field name="id"                                      type="identity" primary-key="primary-key"/>
      <field name="contentinfo_datetime"                    type="datetime" default="0"/>
      <field name="contentinfo_cate_id"                     type="integer"  default="0"/>
      <field name="contentinfo_value"                       type="text"     size="64"  default=""/>
      <field name="contentinfo_count"                       type="integer"  default="0"/>
    </table>
    
    <table name="tblDLPInfo">
      <field name="id"                                      type="identity" primary-key="primary-key"/>
      <field name="dlpinfo_datetime"                    type="datetime" default="0"/>
      <field name="dlpinfo_cate_id"                     type="integer"  default="0"/>
      <field name="dlpinfo_value"                       type="text"     size="64"  default=""/>
      <field name="dlpinfo_count"                       type="integer"  default="0"/>
    </table>

    <table name="tblAttachmentInfo">
      <field name="id"                                      type="identity" primary-key="primary-key"/>
      <field name="attachinfo_datetime"                     type="datetime" default="0"/>
      <field name="attachinfo_cate_id"                      type="integer"  default="0"/>
      <field name="attachinfo_value"                        type="text"     size="255"  default=""/>
      <field name="attachinfo_count"                        type="integer"  default="0"/>
    </table>

    <table name="tblVirusInfo">
      <field name="id"                                      type="identity" primary-key="primary-key"/>
      <field name="virusinfo_datetime"                      type="datetime" default="0"/>
      <field name="virusinfo_cate_id"                       type="integer"  default="0"/>
      <field name="virusinfo_value"                         type="text"     size="64"  default=""/>
      <field name="virusinfo_count"                         type="integer"  default="0"/>
    </table>

    <table name="tblUnscannableInfo">
      <field name="id"                                      type="identity" primary-key="primary-key"/>
      <field name="unscannableinfo_datetime"                type="datetime" default="0"/>
      <field name="unscannableinfo_cate_id"                 type="integer"  default="0"/>
      <field name="unscannableinfo_value"                   type="text"     size="64"  default=""/>
      <field name="unscannableinfo_count"                   type="integer"  default="0"/>
    </table>
    
    <table name="tblURLInfo">
      <field name="id"                                      type="identity" primary-key="primary-key"/>
      <field name="urlinfo_datetime"                        type="datetime" default="0"/>
      <field name="urlinfo_cate_id"                         type="integer"  default="0"/>
      <field name="urlinfo_value"                           type="text"     size="64"  default=""/>
      <field name="urlinfo_count"                           type="integer"  default="0"/>
    </table>

    <table name="tblReportCollectionSummary">
      <field name="id"                                              type="integer" primary-key="primary-key"/>
      <field name="summary_total_message_count"                     type="integer"  default="1"/>
      <field name="summary_total_attachment_count"                  type="integer"  default="1"/>
      <field name="summary_virus_detected_count"                    type="integer"  default="1"/>
      <field name="summary_virus_uncleanable_count"                 type="integer"  default="1"/>
      <field name="summary_attachment_blocked_count"                type="integer"  default="1"/>
      <field name="summary_content_filtered_count"                  type="integer"  default="1"/>
      <field name="summary_dlp_filtered_count"                  type="integer"  default="1"/>
      <field name="summary_spam_detected_count"                     type="integer"  default="1"/>
      <field name="summary_phish_detected_count"                    type="integer"  default="1"/>
      <field name="summary_unscannable_entity_count"                type="integer"  default="1"/>
      <field name="summary_worm_trojan_virus_type_count"            type="integer"  default="1"/>
      <field name="summary_packed_file_virus_type_count"            type="integer"  default="1"/>
      <field name="summary_generic_virus_type_count"                type="integer"  default="1"/>
      <field name="summary_virus_virus_type_count"                  type="integer"  default="1"/>
      <field name="summary_other_malicious_code_virus_type_count"   type="integer"  default="1"/>
      <field name="summary_additional_threat_virus_type_count"      type="integer"  default="1"/>
      <field name="summary_ers_count"                               type="integer"  default="1"/>
      <field name="summary_suspicious_url_count" 		    type="integer"  default="1"/>
      <instance id="1"/>
    </table>
  </schema>
</database>
