Merge pull request #18411 from MegaphoneJon/pcp-wysiwyg
[civicrm-core.git] / xml / schema / Member / MembershipLog.xml
index 1c092bc14cb897cfeb594b5ae4b2b8c85d9889c0..51dd870a1f440143ab5a980a2b3d546349f24230 100644 (file)
@@ -8,21 +8,23 @@
   <comment>Logs actions which affect a Membership record (signup, status override, renewal, etc.)</comment>
   <add>1.5</add>
   <field>
-      <name>id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <add>1.5</add>
+    <name>id</name>
+    <title>Membership Log ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <add>1.5</add>
   </field>
   <primaryKey>
-      <name>id</name>
-      <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>membership_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>FK to Membership table</comment>
-      <add>1.5</add>
+    <name>membership_id</name>
+    <title>Membership ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>FK to Membership table</comment>
+    <add>1.5</add>
   </field>
   <foreignKey>
     <name>membership_id</name>
     <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>status_id</name>
-      <title>Membership Status</title>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>New status assigned to membership by this action. FK to Membership Status</comment>
-      <add>1.5</add>
+    <name>status_id</name>
+    <title>Membership Status</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>New status assigned to membership by this action. FK to Membership Status</comment>
+    <add>1.5</add>
   </field>
   <foreignKey>
-      <name>status_id</name>
-      <table>civicrm_membership_status</table>
-      <key>id</key>
-      <add>1.5</add>
-      <onDelete>CASCADE</onDelete>
+    <name>status_id</name>
+    <table>civicrm_membership_status</table>
+    <key>id</key>
+    <add>1.5</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>start_date</name>
-      <type>date</type>
-      <dataPattern>/\d{4}-?\d{2}-?\d{2}/</dataPattern>
-      <comment>New membership period start date</comment>
-      <add>1.5</add>
+    <name>start_date</name>
+    <title>Membership Log Start Date</title>
+    <type>date</type>
+    <dataPattern>/\d{4}-?\d{2}-?\d{2}/</dataPattern>
+    <comment>New membership period start date</comment>
+    <add>1.5</add>
   </field>
   <field>
-      <name>end_date</name>
-      <type>date</type>
-      <dataPattern>/\d{4}-?\d{2}-?\d{2}/</dataPattern>
-      <comment>New membership period expiration date.</comment>
-      <add>1.5</add>
+    <name>end_date</name>
+    <title>Membership Log End Date</title>
+    <type>date</type>
+    <dataPattern>/\d{4}-?\d{2}-?\d{2}/</dataPattern>
+    <comment>New membership period expiration date.</comment>
+    <add>1.5</add>
   </field>
   <field>
-       <name>modified_id</name>
-       <type>int unsigned</type>
-       <comment>FK to Contact ID of person under whose credentials this data modification was made.</comment>
-       <add>1.5</add>
+    <name>modified_id</name>
+    <title>Membership Log modified By</title>
+    <type>int unsigned</type>
+    <comment>FK to Contact ID of person under whose credentials this data modification was made.</comment>
+    <add>1.5</add>
   </field>
   <foreignKey>
-       <name>modified_id</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>1.5</add>
-       <onDelete>SET NULL</onDelete>
+    <name>modified_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>1.5</add>
+    <onDelete>SET NULL</onDelete>
   </foreignKey>
   <field>
-      <name>modified_date</name>
-      <title>Membership Change Date</title>
-      <type>date</type>
-      <dataPattern>/\d{4}-?\d{2}-?\d{2}/</dataPattern>
-      <comment>Date this membership modification action was logged.</comment>
-      <add>1.5</add>
+    <name>modified_date</name>
+    <title>Membership Change Date</title>
+    <type>date</type>
+    <dataPattern>/\d{4}-?\d{2}-?\d{2}/</dataPattern>
+    <comment>Date this membership modification action was logged.</comment>
+    <add>1.5</add>
   </field>
   <field>
-       <name>membership_type_id</name>
-       <type>int unsigned</type>
-       <comment>FK to Membership Type.</comment>
-       <add>3.4</add>
+    <name>membership_type_id</name>
+    <title>Membership Type ID</title>
+    <type>int unsigned</type>
+    <comment>FK to Membership Type.</comment>
+    <add>3.4</add>
   </field>
   <foreignKey>
-       <name>membership_type_id</name>
-       <table>civicrm_membership_type</table>
-       <key>id</key>
-       <add>3.4</add>
-       <onDelete>SET NULL</onDelete>
+    <name>membership_type_id</name>
+    <table>civicrm_membership_type</table>
+    <key>id</key>
+    <add>3.4</add>
+    <onDelete>SET NULL</onDelete>
   </foreignKey>
   <field>
-       <name>max_related</name>
-       <type>int</type>
-       <comment>Maximum number of related memberships.</comment>
-       <add>4.3</add>
+    <name>max_related</name>
+    <title>Maximum Related Memberships</title>
+    <type>int</type>
+    <comment>Maximum number of related memberships.</comment>
+    <add>4.3</add>
   </field>
 </table>