CRM-14181 fixes - migrate enums to varchar in schema for all tables
[civicrm-core.git] / xml / schema / Mailing / BounceType.xml
1 <?xml version="1.0" encoding="iso-8859-1" ?>
2
3 <table>
4 <base>CRM/Mailing</base>
5 <class>BounceType</class>
6 <name>civicrm_mailing_bounce_type</name>
7 <comment>Table to index the various bounce types and their properties</comment>
8 <field>
9 <name>id</name>
10 <type>int unsigned</type>
11 <required>true</required>
12 </field>
13 <primaryKey>
14 <name>id</name>
15 <autoincrement>true</autoincrement>
16 </primaryKey>
17 <field>
18 <name>name</name>
19 <type>varchar</type>
20 <length>8</length>
21 <required>true</required>
22 <comment>Type of bounce</comment>
23 <html>
24 <type>Select</type>
25 </html>
26 </field>
27 <field>
28 <name>description</name>
29 <type>varchar</type>
30 <length>255</length>
31 <comment>A description of this bounce type</comment>
32 </field>
33 <field>
34 <name>hold_threshold</name>
35 <type>int unsigned</type>
36 <required>true</required>
37 <comment>Number of bounces of this type required before the email address is put on bounce hold</comment>
38 </field>
39 </table>