xml/schema/Core/MessageTemplate.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   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>
   8   <add>1.6</add>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <comment>Message Template ID</comment>
  14       <add>1.6</add>
  15   </field>
  16   <primaryKey>
  17       <name>id</name>
  18       <autoincrement>true</autoincrement>
  19   </primaryKey>
  20   <field>
  21       <name>msg_title</name>
  22       <type>varchar</type>
  23       <length>255</length>
  24       <comment>Descriptive title of message</comment>
  25       <add>1.6</add>
  26   </field>
  27   <field>
  28       <name>msg_subject</name>
  29       <type>text</type>
  30       <comment>Subject for email message.</comment>
  31       <add>1.6</add>
  32       <!-- type changed from VARCHAR(255) to TEXT in 3.1 -->
  33   </field>
  34   <field>
  35       <name>msg_text</name>
  36       <type>longtext</type>
  37       <html>
  38           <type>TextArea</type>
  39           <rows>10</rows>
  40           <cols>75</cols>
  41       </html>
  42       <comment>Text formatted message</comment>
  43       <add>1.6</add>
  44       <!-- type changed from TEXT to LONGTEXT in 4.3 -->
  45   </field>
  46   <field>
  47       <name>msg_html</name>
  48       <type>longtext</type>
  49       <html>
  50           <type>RichTextEditor</type>
  51           <rows>10</rows>
  52           <cols>75</cols>
  53       </html>
  54       <comment>HTML formatted message</comment>
  55       <add>1.6</add>
  56       <!-- type changed from TEXT to LONGTEXT in 4.3 -->
  57   </field>
  58   <field>
  59       <name>is_active</name>
  60       <title>Is Active</title>
  61       <type>boolean</type>
  62       <default>1</default>
  63       <add>1.6</add>
  64   </field>
  65   <field>
  66       <name>workflow_id</name>
  67       <type>int unsigned</type>
  68       <comment>a pseudo-FK to civicrm_option_value</comment>
  69       <add>3.1</add>
  70   </field>
  71   <field>
  72       <name>is_default</name>
  73       <type>boolean</type>
  74       <default>1</default>
  75       <comment>is this the default message template for the workflow referenced by workflow_id?</comment>
  76       <add>3.1</add>
  77   </field>
  78   <field>
  79       <name>is_reserved</name>
  80       <type>boolean</type>
  81       <comment>is this the reserved message template which we ship for the workflow referenced by workflow_id?</comment>
  82       <add>3.1</add>
  83   </field>
  84   <field>
  85       <name>pdf_format_id</name>
  86       <type>int unsigned</type>
  87       <comment>a pseudo-FK to civicrm_option_value containing PDF Page Format.</comment>
  88       <pseudoconstant>
  89         <optionGroupName>pdf_format</optionGroupName>
  90       </pseudoconstant>
  91       <add>3.4</add>
  92   </field>
  93 </table>