projects / civicrm-core.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Merge remote-tracking branch 'upstream/4.4' into 4.4-4.5-2014-09-29-14-51-22
[civicrm-core.git] / xml / schema / Core / MessageTemplate.xml
diff --git a/xml/schema/Core/MessageTemplate.xml b/xml/schema/Core/MessageTemplate.xml
index 464a9d5b85201839a60b3f2fb024cfa947bea073..ea69244281027d6da5dc93b3b61cf317ca519eb1 100644 (file)
--- a/xml/schema/Core/MessageTemplate.xml
+++ b/xml/schema/Core/MessageTemplate.xml
@@ -7,91 +7,104 @@
   <comment>Users will need a way to save and retrieve templates with tokens for use in recurring email communication tasks</comment>
   <add>1.6</add>
   <field>
-      <name>id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>Message Template ID</comment>
-      <add>1.6</add>
+    <name>id</name>
+    <title>Message Template ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>Message Template ID</comment>
+    <add>1.6</add>
   </field>
   <primaryKey>
-      <name>id</name>
-      <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>msg_title</name>
-      <type>varchar</type>
-      <length>255</length>
-      <comment>Descriptive title of message</comment>
-      <add>1.6</add>
+    <name>msg_title</name>
+    <title>Message Template Title</title>
+    <type>varchar</type>
+    <length>255</length>
+    <comment>Descriptive title of message</comment>
+    <add>1.6</add>
   </field>
   <field>
-      <name>msg_subject</name>
-      <type>text</type>
-      <comment>Subject for email message.</comment>
-      <add>1.6</add>
-      <!-- type changed from VARCHAR(255) to TEXT in 3.1 -->
+    <name>msg_subject</name>
+    <title>Message Template Subject</title>
+    <type>text</type>
+    <comment>Subject for email message.</comment>
+    <add>1.6</add>
+    <!-- type changed from VARCHAR(255) to TEXT in 3.1 -->
   </field>
   <field>
-      <name>msg_text</name>
-      <type>longtext</type>
-      <html>
-          <type>TextArea</type>
-          <rows>10</rows>
-          <cols>75</cols>
-      </html>
-      <comment>Text formatted message</comment>
-      <add>1.6</add>
-      <!-- type changed from TEXT to LONGTEXT in 4.3 -->
+    <name>msg_text</name>
+    <title>Message Template Text</title>
+    <type>longtext</type>
+    <html>
+      <type>TextArea</type>
+      <rows>10</rows>
+      <cols>75</cols>
+    </html>
+    <comment>Text formatted message</comment>
+    <add>1.6</add>
+    <!-- type changed from TEXT to LONGTEXT in 4.3 -->
   </field>
   <field>
-      <name>msg_html</name>
-      <type>longtext</type>
-      <html>
-          <type>RichTextEditor</type>
-          <rows>10</rows>
-          <cols>75</cols>
-      </html>
-      <comment>HTML formatted message</comment>
-      <add>1.6</add>
-      <!-- type changed from TEXT to LONGTEXT in 4.3 -->
+    <name>msg_html</name>
+    <title>Message Template HTML</title>
+    <type>longtext</type>
+    <html>
+      <type>RichTextEditor</type>
+      <rows>10</rows>
+      <cols>75</cols>
+    </html>
+    <comment>HTML formatted message</comment>
+    <add>1.6</add>
+    <!-- type changed from TEXT to LONGTEXT in 4.3 -->
   </field>
   <field>
-      <name>is_active</name>
-      <title>Is Active</title>
-      <type>boolean</type>
-      <default>1</default>
-      <add>1.6</add>
+    <name>is_active</name>
+    <title>Is Active</title>
+    <type>boolean</type>
+    <default>1</default>
+    <add>1.6</add>
   </field>
   <field>
-      <name>workflow_id</name>
-      <type>int unsigned</type>
-      <comment>a pseudo-FK to civicrm_option_value</comment>
-      <add>3.1</add>
+    <name>workflow_id</name>
+    <title>Message Template Workflow</title>
+    <type>int unsigned</type>
+    <comment>a pseudo-FK to civicrm_option_value</comment>
+    <add>3.1</add>
   </field>
   <field>
-      <name>is_default</name>
-      <type>boolean</type>
-      <default>1</default>
-      <comment>is this the default message template for the workflow referenced by workflow_id?</comment>
-      <add>3.1</add>
+    <name>is_default</name>
+    <title>Message Template Is Default?</title>
+    <type>boolean</type>
+    <default>1</default>
+    <comment>is this the default message template for the workflow referenced by workflow_id?</comment>
+    <add>3.1</add>
   </field>
   <field>
-      <name>is_reserved</name>
-      <type>boolean</type>
-      <comment>is this the reserved message template which we ship for the workflow referenced by workflow_id?</comment>
-      <add>3.1</add>
+    <name>is_reserved</name>
+    <title>Message Template Is Reserved?</title>
+    <type>boolean</type>
+    <comment>is this the reserved message template which we ship for the workflow referenced by workflow_id?</comment>
+    <add>3.1</add>
   </field>
   <field>
-      <name>pdf_format_id</name>
-      <type>int unsigned</type>
-      <comment>FK to civicrm_option_value containing PDF Page Format.</comment>
-      <add>3.4</add>
+    <name>is_sms</name>
+    <title>Message Template is used for SMS?</title>
+    <type>boolean</type>
+    <default>0</default>
+    <comment>Is this message template used for sms?</comment>
+    <add>4.5</add>
+  </field>
+  <field>
+    <name>pdf_format_id</name>
+    <title>Message Template Format</title>
+    <type>int unsigned</type>
+    <comment>a pseudo-FK to civicrm_option_value containing PDF Page Format.</comment>
+    <pseudoconstant>
+      <optionGroupName>pdf_format</optionGroupName>
+    </pseudoconstant>
+    <add>3.4</add>
   </field>
-  <foreignKey>
-      <name>pdf_format_id</name>
-      <table>civicrm_option_value</table>
-      <key>id</key>
-      <onDelete>SET NULL</onDelete>
-      <add>3.4</add>
-  </foreignKey>
 </table>