projects / civicrm-core.git / blame
| Commit | Line | Data |
|---|---|---|
| 6a488035 TO |
1 | <?xml version="1.0" encoding="iso-8859-1" ?> |
| 2 | ||
| 3 | <table> | |
| 4 | <base>CRM/Mailing</base> | |
| 5 | <class>Spool</class> | |
| 6 | <name>civicrm_mailing_spool</name> | |
| 7 | <comment>Stores the outbond mails</comment> | |
| d31fb4e3 | 8 | <component>CiviMail</component> |
| 6a488035 | 9 | <field> |
| 5435b737 | 10 | <name>id</name> |
| f3ea5182 | 11 | <title>Spool ID</title> |
| 5435b737 EM |
12 | <type>int unsigned</type> |
| 13 | <required>true</required> | |
| 0481e12c A |
14 | <html> |
| 15 | <type>Number</type> | |
| 16 | </html> | |
| 6a488035 TO |
17 | </field> |
| 18 | <primaryKey> | |
| 5435b737 EM |
19 | <name>id</name> |
| 20 | <autoincrement>true</autoincrement> | |
| 6a488035 TO |
21 | </primaryKey> |
| 22 | <field> | |
| 5435b737 | 23 | <name>job_id</name> |
| 047c5009 | 24 | <title>Job ID</title> |
| 5435b737 EM |
25 | <type>int unsigned</type> |
| 26 | <required>true</required> | |
| 27 | <comment>The ID of the Job .</comment> | |
| 57e94608 | 28 | <html> |
| 047c5009 | 29 | <label>Job</label> |
| 57e94608 | 30 | </html> |
| 6a488035 TO |
31 | </field> |
| 32 | <foreignKey> | |
| 5435b737 EM |
33 | <name>job_id</name> |
| 34 | <table>civicrm_mailing_job</table> | |
| 35 | <key>id</key> | |
| 36 | <onDelete>CASCADE</onDelete> | |
| 6a488035 TO |
37 | </foreignKey> |
| 38 | <field> | |
| 5435b737 | 39 | <name>recipient_email</name> |
| f3ea5182 | 40 | <title>Recipient Email</title> |
| 5435b737 | 41 | <type>text</type> |
| e017d14b | 42 | <comment>The email of the recipients this mail is to be sent.</comment> |
| 6a488035 TO |
43 | </field> |
| 44 | <field> | |
| 5435b737 | 45 | <name>headers</name> |
| f3ea5182 | 46 | <title>Headers</title> |
| 5435b737 EM |
47 | <type>text</type> |
| 48 | <comment>The header information of this mailing .</comment> | |
| 6a488035 TO |
49 | </field> |
| 50 | <field> | |
| 5435b737 | 51 | <name>body</name> |
| f3ea5182 | 52 | <title>Body</title> |
| 5435b737 EM |
53 | <type>text</type> |
| 54 | <comment>The body of this mailing.</comment> | |
| 6a488035 TO |
55 | </field> |
| 56 | <field> | |
| 5435b737 | 57 | <name>added_at</name> |
| f3ea5182 | 58 | <title>Added</title> |
| 4387c66f | 59 | <type>timestamp</type> |
| 60 | <required>false</required> | |
| 61 | <default>NULL</default> | |
| 5435b737 | 62 | <comment>date on which this job was added.</comment> |
| 6a488035 TO |
63 | </field> |
| 64 | <field> | |
| 5435b737 | 65 | <name>removed_at</name> |
| f3ea5182 | 66 | <title>Removed</title> |
| 4387c66f | 67 | <type>timestamp</type> |
| 68 | <required>false</required> | |
| 69 | <default>NULL</default> | |
| 5435b737 | 70 | <comment>date on which this job was removed.</comment> |
| 6a488035 TO |
71 | </field> |
| 72 | </table> |