<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Mailing</base>
  <class>BounceType</class>
  <name>civicrm_mailing_bounce_type</name>
  <comment>Table to index the various bounce types and their properties</comment>
  <field>
    <name>id</name>
    <title>Bounce Type ID</title>
    <type>int unsigned</type>
    <required>true</required>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <title>Bounce Type Name</title>
    <type>varchar</type>
    <length>24</length>
    <required>true</required>
    <comment>Type of bounce</comment>
  </field>
  <field>
    <name>description</name>
    <title>Bounce Type Description</title>
    <type>varchar</type>
    <length>255</length>
    <comment>A description of this bounce type</comment>
  </field>
  <field>
    <name>hold_threshold</name>
    <title>Hold Threshold</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Number of bounces of this type required before the email address is put on bounce hold</comment>
  </field>
</table>
