projects / civicrm-core.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
CRM-12167: Start Implementation of Visibility per Price Option
[civicrm-core.git] / xml / schema / Report / ReportInstance.xml
diff --git a/xml/schema/Report/ReportInstance.xml b/xml/schema/Report/ReportInstance.xml
index 461a94fed0faa27e290eb9b27ff5dc4a36b5cdc9..6b556a445a127cc46e53b55a72e7cd7f74219b4c 100644 (file)
--- a/xml/schema/Report/ReportInstance.xml
+++ b/xml/schema/Report/ReportInstance.xml
@@ -52,7 +52,7 @@
     <name>report_id</name>
     <title>Report template ID</title>
     <type>varchar</type>
-    <length>64</length>
+    <length>512</length>
     <required>true</required>
     <comment>FK to civicrm_option_value for the report template</comment>
     <html>
@@ -133,6 +133,34 @@
     </html>
     <add>2.2</add>
   </field>
+  <field>
+    <name>created_id</name>
+    <type>int unsigned</type>
+    <title>Report Instance Created By</title>
+    <comment>FK to contact table.</comment>
+    <add>4.6</add>
+  </field>
+  <foreignKey>
+    <name>created_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>4.6</add>
+    <onDelete>SET NULL</onDelete>
+  </foreignKey>
+  <field>
+    <name>owner_id</name>
+    <type>int unsigned</type>
+    <title>Report Instance Owned By</title>
+    <comment>FK to contact table.</comment>
+    <add>4.6</add>
+  </field>
+  <foreignKey>
+    <name>owner_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>4.6</add>
+    <onDelete>SET NULL</onDelete>
+  </foreignKey>
   <field>
     <name>email_subject</name>
     <title>Report Instance email Subject</title>