<table>civicrm_domain</table>
<key>id</key>
<add>3.0</add>
- </foreignKey>
+ </foreignKey>
<field>
<name>name</name>
- <uniqueName>membership_type</uniqueName>
+ <uniqueName>membership_type</uniqueName>
<title>Membership Type</title>
<type>varchar</type>
<import>true</import>
<field>
<name>description</name>
<type>varchar</type>
- <htmlType>textarea</htmlType>
- <rows>6</rows>
- <cols>50</cols>
+ <html>
+ <type>TextArea</type>
+ <rows>6</rows>
+ <cols>50</cols>
+ </html>
<length>255</length>
<localizable>true</localizable>
<comment>Description of Membership Type</comment>
<comment>Owner organization for this membership type. FK to Contact ID</comment>
<add>1.5</add>
</field>
- <foreignKey>
- <name>member_of_contact_id</name>
- <table>civicrm_contact</table>
+ <foreignKey>
+ <name>member_of_contact_id</name>
+ <table>civicrm_contact</table>
<key>id</key>
<add>1.5</add>
<onDelete>RESTRICT</onDelete>
<add>1.5</add>
<drop>4.3</drop>
</field>
- <foreignKey>
- <name>contribution_type_id</name>
- <table>civicrm_contribution_type</table>
- <key>id</key>
+ <foreignKey>
+ <name>contribution_type_id</name>
+ <table>civicrm_contribution_type</table>
+ <key>id</key>
<add>1.5</add>
<drop>4.3</drop>
</foreignKey>
<comment>If membership is paid by a contribution - what financial type should be used. FK to civicrm_financial_type.id</comment>
<add>4.3</add>
</field>
- <foreignKey>
- <name>financial_type_id</name>
- <table>civicrm_financial_type</table>
- <key>id</key>
+ <foreignKey>
+ <name>financial_type_id</name>
+ <table>civicrm_financial_type</table>
+ <key>id</key>
<add>4.3</add>
</foreignKey>
- <field>
- <name>minimum_fee</name>
- <type>decimal</type>
- <comment>Minimum fee for this membership (0 for free/complimentary memberships).</comment>
+ <field>
+ <name>minimum_fee</name>
+ <type>decimal</type>
+ <comment>Minimum fee for this membership (0 for free/complimentary memberships).</comment>
<default>0</default>
- <add>1.5</add>
- </field>
- <field>
- <name>duration_unit</name>
+ <add>1.5</add>
+ </field>
+ <field>
+ <name>duration_unit</name>
<type>enum</type>
<values>day, month, year, lifetime</values>
- <comment>Unit in which membership period is expressed.</comment>
- <add>1.5</add>
- </field>
- <field>
+ <comment>Unit in which membership period is expressed.</comment>
+ <add>1.5</add>
+ <html>
+ <type>Select</type>
+ </html>
+ </field>
+ <field>
<name>duration_interval</name>
<type>int</type>
- <comment>Number of duration units in membership period (e.g. 1 year, 12 months).</comment>
- <add>1.5</add>
- </field>
- <field>
- <name>period_type</name>
+ <comment>Number of duration units in membership period (e.g. 1 year, 12 months).</comment>
+ <add>1.5</add>
+ </field>
+ <field>
+ <name>period_type</name>
<type>enum</type>
<values>rolling, fixed</values>
- <comment>Rolling membership period starts on signup date. Fixed membership periods start on fixed_period_start_day.</comment>
- <add>1.5</add>
- </field>
- <field>
- <name>fixed_period_start_day</name>
- <type>int</type>
- <comment>For fixed period memberships, month and day (mmdd) on which subscription/membership will start. Period start is back-dated unless after rollover day.</comment>
- <add>1.5</add>
- </field>
- <field>
- <name>fixed_period_rollover_day</name>
+ <comment>Rolling membership period starts on signup date. Fixed membership periods start on fixed_period_start_day.</comment>
+ <add>1.5</add>
+ </field>
+ <field>
+ <name>fixed_period_start_day</name>
<type>int</type>
- <comment>For fixed period memberships, signups after this day (mmdd) rollover to next period.</comment>
- <add>1.5</add>
- </field>
+ <comment>For fixed period memberships, month and day (mmdd) on which subscription/membership will start. Period start is back-dated unless after rollover day.</comment>
+ <add>1.5</add>
+ </field>
+ <field>
+ <name>fixed_period_rollover_day</name>
+ <type>int</type>
+ <comment>For fixed period memberships, signups after this day (mmdd) rollover to next period.</comment>
+ <add>1.5</add>
+ </field>
<field>
<name>relationship_type_id</name>
<type>varchar</type>
<comment>FK to Relationship Type ID</comment>
<add>1.5</add>
</field>
- <foreignKey>
- <name>relationship_type_id</name>
- <table>civicrm_relationship_type</table>
- <key>id</key>
+ <foreignKey>
+ <name>relationship_type_id</name>
+ <table>civicrm_relationship_type</table>
+ <key>id</key>
<add>1.5</add>
<drop>3.3</drop>
</foreignKey>
<fieldName>relationship_type_id</fieldName>
<add>3.3</add>
</index>
- <field>
- <name>relationship_direction</name>
- <type>varchar</type>
- <length>128</length>
- <add>1.7</add>
+ <field>
+ <name>relationship_direction</name>
+ <type>varchar</type>
+ <length>128</length>
+ <add>1.7</add>
</field>
<field>
<name>max_related</name>
<add>4.3</add>
</field>
<field>
- <name>visibility</name>
+ <name>visibility</name>
<title>Visible</title>
<type>varchar</type>
<length>64</length>
<pseudoconstant>
<optionGroupName>visibility</optionGroupName>
</pseudoconstant>
+ <html>
+ <type>Select</type>
+ </html>
</field>
- <field>
- <name>weight</name>
+ <field>
+ <name>weight</name>
<title>Weight</title>
<type>int</type>
- <add>1.5</add>
+ <add>1.5</add>
</field>
<field>
<name>receipt_text_signup</name>
<type>varchar</type>
- <htmlType>textarea</htmlType>
- <rows>6</rows>
- <cols>50</cols>
+ <html>
+ <type>TextArea</type>
+ <rows>6</rows>
+ <cols>50</cols>
+ </html>
<length>255</length>
<comment>Receipt Text for membership signup</comment>
<add>2.0</add>
<field>
<name>receipt_text_renewal</name>
<type>varchar</type>
- <htmlType>textarea</htmlType>
- <rows>6</rows>
- <cols>50</cols>
+ <html>
+ <type>TextArea</type>
+ <rows>6</rows>
+ <cols>50</cols>
+ </html>
<length>255</length>
<comment>Receipt Text for membership renewal</comment>
<add>2.0</add>
</field>
- <field>
- <name>auto_renew</name>
+ <field>
+ <name>auto_renew</name>
<type>boolean</type>
<default>0</default>
- <comment>0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required;</comment>
- <add>3.3</add>
- </field>
- <field>
- <name>is_active</name>
+ <comment>0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required;</comment>
+ <add>3.3</add>
+ </field>
+ <field>
+ <name>is_active</name>
<title>Is Active</title>
<type>boolean</type>
<default>1</default>
- <comment>Is this membership_type enabled</comment>
- <add>1.5</add>
- </field>
+ <comment>Is this membership_type enabled</comment>
+ <add>1.5</add>
+ </field>
</table>