CRM-15773 - Use the term Order instead of Weight consistently
[civicrm-core.git] / xml / schema / Member / MembershipBlock.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
4 <base>CRM/Member</base>
5 <class>MembershipBlock</class>
6 <name>civicrm_membership_block</name>
7 <comment>A Membership Block stores admin configurable status options and rules</comment>
8 <add>1.5</add>
9 <log>true</log>
10 <field>
5435b737 11 <name>id</name>
0d94665e 12 <title>Membership Block ID</title>
5435b737
EM
13 <type>int unsigned</type>
14 <required>true</required>
15 <comment>Membership Id</comment>
16 <add>1.5</add>
6a488035
TO
17 </field>
18 <primaryKey>
5435b737
EM
19 <name>id</name>
20 <autoincrement>true</autoincrement>
6a488035
TO
21 </primaryKey>
22 <field>
5435b737 23 <name>entity_table</name>
0d94665e 24 <title>Membership Block Entity Table</title>
5435b737
EM
25 <type>varchar</type>
26 <length>64</length>
27 <comment>Name for Membership Status</comment>
28 <add>1.5</add>
6a488035
TO
29 </field>
30 <field>
5435b737 31 <name>entity_id</name>
0d94665e 32 <title>Membership Block Entity ID</title>
5435b737
EM
33 <type>int unsigned</type>
34 <required>true</required>
35 <comment>FK to civicrm_contribution_page.id</comment>
36 <add>1.5</add>
6a488035 37 </field>
3c7d2158 38 <foreignKey>
5435b737
EM
39 <name>entity_id</name>
40 <table>civicrm_contribution_page</table>
41 <key>id</key>
42 <add>1.5</add>
6a488035
TO
43 </foreignKey>
44 <field>
5435b737 45 <name>membership_types</name>
0d94665e 46 <title>Membership Block Membership Types</title>
5435b737
EM
47 <type>varchar</type>
48 <length>255</length>
49 <comment>Membership types to be exposed by this block</comment>
50 <add>1.5</add>
6a488035 51 </field>
3c7d2158 52 <field>
5435b737 53 <name>membership_type_default</name>
0d94665e 54 <title>Membership Block Default Type</title>
5435b737
EM
55 <type>int unsigned</type>
56 <comment>Optional foreign key to membership_type</comment>
57 <add>1.5</add>
6a488035 58 </field>
5435b737
EM
59 <foreignKey>
60 <name>membership_type_default</name>
61 <table>civicrm_membership_type</table>
62 <key>id</key>
63 <add>1.5</add>
6a488035 64 </foreignKey>
3c7d2158 65 <field>
5435b737 66 <name>display_min_fee</name>
0d94665e 67 <title>Membership Block Display Minimum Fee</title>
5435b737
EM
68 <type>boolean</type>
69 <default>1</default>
70 <comment>Display minimum membership fee</comment>
71 <add>1.5</add>
3c7d2158 72 </field>
73 <field>
5435b737 74 <name>is_separate_payment</name>
0d94665e 75 <title>Membership Block Is Separate Payment</title>
5435b737
EM
76 <type>boolean</type>
77 <default>1</default>
78 <comment>Should membership transactions be processed separately</comment>
79 <add>1.5</add>
3c7d2158 80 </field>
81 <field>
5435b737 82 <name>new_title</name>
0d94665e 83 <title>Membership Block New Title</title>
5435b737
EM
84 <type>varchar</type>
85 <length>255</length>
86 <localizable>true</localizable>
87 <comment>Title to display at top of block</comment>
88 <add>1.5</add>
3c7d2158 89 </field>
90 <field>
5435b737 91 <name>new_text</name>
0d94665e 92 <title>Membership Block New Text</title>
5435b737
EM
93 <type>text</type>
94 <localizable>true</localizable>
95 <comment>Text to display below title</comment>
96 <add>1.5</add>
3c7d2158 97 </field>
5435b737
EM
98 <field>
99 <name>renewal_title</name>
0d94665e 100 <title>Membership Block Renewal Title</title>
5435b737
EM
101 <type>varchar</type>
102 <length>255</length>
103 <localizable>true</localizable>
104 <comment>Title for renewal</comment>
105 <add>1.5</add>
6a488035 106 </field>
5435b737
EM
107 <field>
108 <name>renewal_text</name>
0d94665e 109 <title>Membership Block Renewal Text</title>
5435b737
EM
110 <type>text</type>
111 <localizable>true</localizable>
112 <comment>Text to display for member renewal</comment>
113 <add>1.5</add>
3c7d2158 114 </field>
5435b737
EM
115 <field>
116 <name>is_required</name>
117 <title>Is Required</title>
118 <type>boolean</type>
119 <default>0</default>
120 <comment>Is membership sign up optional</comment>
121 <add>1.5</add>
3c7d2158 122 </field>
123 <field>
5435b737
EM
124 <name>is_active</name>
125 <title>Is Active</title>
126 <type>boolean</type>
127 <default>1</default>
128 <comment>Is this membership_block enabled</comment>
129 <add>1.5</add>
3c7d2158 130 </field>
6a488035 131</table>