1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>MessageTemplate
</class>
6 <name>civicrm_msg_template
</name>
7 <comment>Users will need a way to save and retrieve templates with tokens for use in recurring email communication tasks
</comment>
11 <type>int unsigned
</type>
12 <required>true
</required>
13 <comment>Message Template ID
</comment>
18 <autoincrement>true
</autoincrement>
21 <name>msg_title
</name>
24 <comment>Descriptive title of message
</comment>
28 <name>msg_subject
</name>
30 <comment>Subject for email message.
</comment>
32 <!-- type changed from VARCHAR(255) to TEXT in 3.1 -->
39 <comment>Text formatted message
</comment>
41 <!-- type changed from TEXT to LONGTEXT in 4.3 -->
48 <comment>HTML formatted message
</comment>
50 <!-- type changed from TEXT to LONGTEXT in 4.3 -->
53 <name>is_active
</name>
54 <title>Is Active
</title>
60 <name>workflow_id
</name>
61 <type>int unsigned
</type>
62 <comment>a pseudo-FK to civicrm_option_value
</comment>
66 <name>is_default
</name>
69 <comment>is this the default message template for the workflow referenced by workflow_id?
</comment>
73 <name>is_reserved
</name>
75 <comment>is this the reserved message template which we ship for the workflow referenced by workflow_id?
</comment>
79 <name>pdf_format_id
</name>
80 <type>int unsigned
</type>
81 <comment>FK to civicrm_option_value containing PDF Page Format.
</comment>
85 <name>pdf_format_id
</name>
86 <table>civicrm_option_value
</table>
88 <onDelete>SET NULL
</onDelete>