projects / civicrm-core.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Merge pull request #13154 from civicrm/5.8
[civicrm-core.git] / xml / schema / Case / Case.xml
diff --git a/xml/schema/Case/Case.xml b/xml/schema/Case/Case.xml
index 37d19180771f609da7c182b413ab7b7a66d289d5..7487fc7b6c782b71246c212d0aa582c42168d46c 100644 (file)
--- a/xml/schema/Case/Case.xml
+++ b/xml/schema/Case/Case.xml
@@ -133,6 +133,7 @@
     <comment>Date on which given case starts.</comment>
     <html>
       <type>Select Date</type>
+      <formatType>activityDateTime</formatType>
     </html>
     <add>1.8</add>
   </field>
@@ -145,6 +146,7 @@
     <comment>Date on which given case ends.</comment>
     <html>
       <type>Select Date</type>
+      <formatType>activityDateTime</formatType>
     </html>
     <add>1.8</add>
   </field>
@@ -191,4 +193,24 @@
     <fieldName>is_deleted</fieldName>
     <add>2.2</add>
   </index>
+  <field>
+    <name>created_date</name>
+    <uniqueName>case_created_date</uniqueName>
+    <type>timestamp</type>
+    <comment>When was the case was created.</comment>
+    <required>false</required>
+    <export>true</export>
+    <default>NULL</default>
+    <add>4.7</add>
+  </field>
+  <field>
+    <name>modified_date</name>
+    <uniqueName>case_modified_date</uniqueName>
+    <type>timestamp</type>
+    <comment>When was the case (or closely related entity) was created or modified or deleted.</comment>
+    <required>false</required>
+    <export>true</export>
+    <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</default>
+    <add>4.7</add>
+  </field>
 </table>