Merge remote-tracking branch 'upstream/4.4' into 4.4-master-2014-07-16-12-52-48

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

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

<table>
    <base>CRM/Mailing/Event</base>
    <class>Forward</class>
    <name>civicrm_mailing_event_forward</name>
    <comment>Tracks when a contact forwards a mailing to a (new) contact</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>event_queue_id</name>
        <type>int unsigned</type>
        <required>true</required>
        <comment>FK to EventQueue</comment>
    </field>
    <foreignKey>
        <name>event_queue_id</name>
        <table>civicrm_mailing_event_queue</table>
        <key>id</key>
        <onDelete>CASCADE</onDelete>
    </foreignKey>
    <field>
        <name>dest_queue_id</name>
        <type>int unsigned</type>
        <comment>FK to EventQueue for destination</comment>
    </field>
    <foreignKey>
        <name>dest_queue_id</name>
        <table>civicrm_mailing_event_queue</table>
        <key>id</key>
        <onDelete>SET NULL</onDelete>
    </foreignKey>
    <field>
        <name>time_stamp</name>
        <type>datetime</type>
        <required>true</required>
        <comment>When this forward event occurred.</comment>
    </field>
</table>