1 <?xml version=
"1.0" encoding=
"UTF-8" ?>
2 <!-- $Id: mailing_delivered.xml 30511 2013-04-30 11:36:36Z shot $ -->
4 <table name=
"civicrm_mailing">
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>
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>
41 <value>2</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 -->
78 <table name=
"civicrm_mailing_job">
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>
96 <value>complete
</value>
104 <table name=
"civicrm_mailing_event_queue">
106 <column>job_id
</column>
107 <column>email_id
</column>
108 <column>contact_id
</column>
109 <column>hash
</column>
110 <column>phone_id
</column>
116 <value>80569af03942f016
</value>
120 <table name=
"civicrm_mailing_event_bounce">
122 <column>event_queue_id
</column>
123 <column>bounce_type_id
</column>
124 <column>bounce_reason
</column>
125 <column>time_stamp
</column>
131 <value>2013-
04-
30 18:
11:
26</value>