crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/tests/phpunit/api/v3/dataset/mailing_delivered.xml

   1 <?xml version="1.0" encoding="UTF-8" ?>
   2 <!--  $Id: mailing_delivered.xml 30511 2013-04-30 11:36:36Z shot $  -->
   3 <dataset>
   4   <table name="civicrm_mailing">
   5   <column>id</column>
   6   <column>domain_id</column>
   7   <column>header_id</column>
   8   <column>footer_id</column>
   9   <column>reply_id</column>
  10   <column>unsubscribe_id</column>
  11   <column>resubscribe_id</column>
  12   <column>optout_id</column>
  13   <column>name</column>
  14   <column>from_name</column>
  15   <column>from_email</column>
  16   <column>replyto_email</column>
  17   <column>subject</column>
  18   <column>body_text</column>
  19   <column>body_html</column>
  20   <column>url_tracking</column>
  21   <column>forward_replies</column>
  22   <column>auto_responder</column>
  23   <column>open_tracking</column>
  24   <column>is_completed</column>
  25   <column>msg_template_id</column>
  26   <column>override_verp</column>
  27   <column>created_id</column>
  28   <column>created_date</column>
  29   <column>scheduled_id</column>
  30   <column>scheduled_date</column>
  31   <column>approver_id</column>
  32   <column>approval_date</column>
  33   <column>approval_status_id</column>
  34   <column>approval_note</column>
  35   <column>is_archived</column>
  36   <column>visibility</column>
  37   <column>campaign_id</column>
  38   <column>dedupe_email</column>
  39   <column>sms_provider_id</column>
  40   <row>
  41     <value>1</value> <!--  id  -->
  42     <value>1</value> <!--  domain_id -->
  43     <value>1</value> <!--  header_id -->
  44     <value>2</value> <!--  footer_id -->
  45     <null /> <!--  reply_id  -->
  46     <null /> <!--  unsubscribe_id  -->
  47     <null /> <!--  resubscribe_id  -->
  48     <null /> <!--  optout_id  -->
  49     <value>Test Mailing</value> <!--  name  -->
  50     <null /> <!--  from_name  -->
  51     <null /> <!--  from_email  -->
  52     <value>somereply@testing.org</value> <!--  replyto_email  -->
  53     <value>Some Subject</value> <!--  subject            -->
  54     <value>Just a body... nothing to see here.</value> <!--  body_text          -->
  55     <value><html>Just some html...</html></value> <!--  body_html          -->
  56     <null /> <!--  url_tracking       -->
  57     <null /> <!--  forward_replies    -->
  58     <null /> <!--  auto_responder     -->
  59     <value>0</value> <!--  open_tracking      -->
  60     <value>1</value> <!--  is_completed       -->
  61     <null /> <!--  msg_template_id    -->
  62     <null /> <!--  override_verp      -->
  63     <value>3</value> <!--  created_id         -->
  64     <null /> <!--  created_date       -->
  65     <null /> <!--  scheduled_id       -->
  66     <null /> <!--  scheduled_date     -->
  67     <null /> <!--  approver_id        -->
  68     <null /> <!--  approval_date      -->
  69     <null /> <!--  approval_status_id -->
  70     <null /> <!--  approval_note      -->
  71     <value>0</value> <!--  is_archived        -->
  72     <value>User and User Admin Only</value> <!--  visibility         -->
  73     <null /> <!--  campaign_id        -->
  74     <value>0</value> <!--  dedupe_email       -->
  75     <null /> <!--  sms_provider_id    -->
  76   </row>
  77   </table>
  78   <table name="civicrm_mailing_job">
  79   <column>id</column>
  80   <column>mailing_id</column>
  81   <column>scheduled_date</column>
  82   <column>start_date</column>
  83   <column>end_date</column>
  84   <column>status</column>
  85   <column>is_test</column>
  86   <column>job_type</column>
  87   <column>parent_id</column>
  88   <column>job_offset</column>
  89   <column>job_limit</column>
  90   <row>
  91     <value>1</value>
  92     <value>1</value>
  93     <null />
  94     <null />
  95     <null />
  96     <value>complete</value>
  97     <value>0</value>
  98     <null />
  99     <null />
 100     <value>0</value>
 101     <value>0</value>
 102   </row>
 103   </table>
 104   <table name="civicrm_mailing_event_queue">
 105   <column>id</column>
 106   <column>job_id</column>
 107   <column>email_id</column>
 108   <column>contact_id</column>
 109   <column>hash</column>
 110   <column>phone_id</column>
 111   <row>
 112   <value>1</value>
 113   <value>1</value>
 114   <value>1</value>
 115   <value>23</value>
 116   <value>80569af03942f016</value>
 117   <null />
 118   </row>
 119   </table>
 120   <table name="civicrm_mailing_event_delivered">
 121   <column>id</column>
 122   <column>event_queue_id</column>
 123   <column>time_stamp</column>
 124   <row>
 125     <value>1</value>
 126     <value>1</value>
 127     <value>2013-04-30 18:11:26</value>
 128   </row>
 129   </table>
 130 </dataset>