xml/schema/Member/MembershipStatus.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Member</base>
   5   <class>MembershipStatus</class>
   6   <name>civicrm_membership_status</name>
   7   <comment>Membership Status stores admin configurable rules for assigning status to memberships.</comment>
   8   <add>1.5</add>
   9   <log>true</log>
  10   <field>
  11       <name>id</name>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <comment>Membership Id</comment>
  15       <add>1.5</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22        <name>name</name>
  23        <uniqueName>membership_status</uniqueName>
  24        <title>Membership Status</title>
  25        <type>varchar</type>
  26        <import>true</import>
  27        <length>128</length>
  28        <comment>Name for Membership Status</comment>
  29        <add>1.5</add>
  30   </field>
  31   <field>
  32        <name>label</name>
  33        <type>varchar</type>
  34        <length>128</length>
  35        <localizable>true</localizable>
  36        <comment>Label for Membership Status</comment>
  37        <add>3.2</add>
  38   </field>
  39   <field>
  40        <name>start_event</name>
  41        <type>enum</type>
  42        <values>start_date, end_date, join_date</values>
  43        <comment>Event when this status starts.</comment>
  44        <add>1.5</add>
  45        <html>
  46          <type>Select</type>
  47        </html>
  48   </field>
  49   <field>
  50       <name>start_event_adjust_unit</name>
  51       <type>enum</type>
  52       <values>day, month, year</values>
  53       <comment>Unit used for adjusting from start_event.</comment>
  54       <add>1.5</add>
  55       <html>
  56         <type>Select</type>
  57       </html>
  58   </field>
  59   <field>
  60       <name>start_event_adjust_interval</name>
  61       <type>int</type>
  62       <comment>Status range begins this many units from start_event.</comment>
  63       <add>1.5</add>
  64   </field>
  65   <field>
  66       <name>end_event</name>
  67       <type>enum</type>
  68       <values>start_date, end_date, join_date</values>
  69       <comment>Event after which this status ends.</comment>
  70       <add>1.5</add>
  71       <html>
  72         <type>Select</type>
  73       </html>
  74   </field>
  75   <field>
  76       <name>end_event_adjust_unit</name>
  77       <type>enum</type>
  78       <values>day, month, year</values>
  79       <comment>Unit used for adjusting from the ending event.</comment>
  80       <add>1.5</add>
  81       <html>
  82         <type>Select</type>
  83       </html>
  84   </field>
  85  <field>
  86       <name>end_event_adjust_interval</name>
  87       <type>int</type>
  88       <comment>Status range ends this many units from end_event.</comment>
  89       <add>1.5</add>
  90   </field>
  91   <field>
  92       <name>is_current_member</name>
  93       <title>Current Membership?</title>
  94       <type>boolean</type>
  95       <comment>Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE).</comment>
  96       <add>1.5</add>
  97   </field>
  98   <field>
  99       <name>is_admin</name>
 100       <title>Admin Assigned Only?</title>
 101       <type>boolean</type>
 102       <comment>Is this status for admin/manual assignment only.</comment>
 103       <add>1.5</add>
 104   </field>
 105   <field>
 106       <name>weight</name>
 107       <title>Weight</title>
 108       <type>int</type>
 109       <add>1.5</add>
 110   </field>
 111   <field>
 112       <name>is_default</name>
 113       <title>Default Status?</title>
 114       <type>boolean</type>
 115       <comment>Assign this status to a membership record if no other status match is found.</comment>
 116       <add>1.5</add>
 117   </field>
 118   <field>
 119       <name>is_active</name>
 120       <title>Is Active</title>
 121       <type>boolean</type>
 122       <default>1</default>
 123       <comment>Is this membership_status enabled.</comment>
 124       <add>1.5</add>
 125   </field>
 126  <field>
 127       <name>is_reserved</name>
 128       <title>Is Reserved</title>
 129       <type>boolean</type>
 130       <default>0</default>
 131       <comment>Is this membership_status reserved.</comment>
 132       <add>2.1</add>
 133   </field>
 134 </table>