Merge pull request #2649 from rocxa/master

[civicrm-core.git] / xml / schema / Mailing / Event / Queue.xml

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

<table>
    <base>CRM/Mailing/Event</base>
    <class>Queue</class>
    <name>civicrm_mailing_event_queue</name>
    <comment>A collection of all intended recipients of a job</comment>
    <archive>true</archive>
    <field>
        <name>id</name>
        <type>int unsigned</type>
        <required>true</required>
    </field>
    <primaryKey>
        <name>id</name>
        <autoincrement>true</autoincrement>
    </primaryKey>
    <field>
        <name>job_id</name>
        <type>int unsigned</type>
        <required>true</required>
        <comment>FK to Job</comment>
    </field>
    <foreignKey>
        <name>job_id</name>
        <table>civicrm_mailing_job</table>
        <key>id</key>
        <onDelete>CASCADE</onDelete>
    </foreignKey>
    <field>
        <name>email_id</name>
        <type>int unsigned</type>
  <default>NULL</default>
        <comment>FK to Email</comment>
    </field>
    <foreignKey>
        <name>email_id</name>
        <table>civicrm_email</table>
        <key>id</key>
        <onDelete>CASCADE</onDelete>
    </foreignKey>
    <field>
        <name>contact_id</name>
        <type>int unsigned</type>
        <required>true</required>
        <comment>FK to Contact</comment>
    </field>
    <foreignKey>
        <name>contact_id</name>
        <table>civicrm_contact</table>
        <key>id</key>
        <onDelete>CASCADE</onDelete>
    </foreignKey>
    <field>
        <name>hash</name>
        <type>varchar</type>
        <length>255</length>
        <required>true</required>
        <comment>Security hash</comment>
    </field>
    <field>
        <name>phone_id</name>
        <type>int unsigned</type>
        <default>NULL</default>
        <comment>FK to Phone</comment>
    </field>
    <foreignKey>
        <name>phone_id</name>
        <table>civicrm_phone</table>
        <key>id</key>
        <onDelete>CASCADE</onDelete>
    </foreignKey>
</table>