CRM-14181, more clean and fixes to support callback
[civicrm-core.git] / xml / schema / Member / MembershipBlock.xml
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>
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>entity_table</name>
23 <type>varchar</type>
24 <length>64</length>
25 <comment>Name for Membership Status</comment>
26 <add>1.5</add>
27 </field>
28 <field>
29 <name>entity_id</name>
30 <type>int unsigned</type>
31 <required>true</required>
32 <comment>FK to civicrm_contribution_page.id</comment>
33 <add>1.5</add>
34 </field>
35 <foreignKey>
36 <name>entity_id</name>
37 <table>civicrm_contribution_page</table>
38 <key>id</key>
39 <add>1.5</add>
40 </foreignKey>
41 <field>
42 <name>membership_types</name>
43 <type>varchar</type>
44 <length>255</length>
45 <comment>Membership types to be exposed by this block</comment>
46 <add>1.5</add>
47 </field>
48 <field>
49 <name>membership_type_default</name>
50 <type>int unsigned</type>
51 <comment>Optional foreign key to membership_type</comment>
52 <add>1.5</add>
53 </field>
54 <foreignKey>
55 <name>membership_type_default</name>
56 <table>civicrm_membership_type</table>
57 <key>id</key>
58 <add>1.5</add>
59 </foreignKey>
60 <field>
61 <name>display_min_fee</name>
62 <type>boolean</type>
63 <default>1</default>
64 <comment>Display minimum membership fee</comment>
65 <add>1.5</add>
66 </field>
67 <field>
68 <name>is_separate_payment</name>
69 <type>boolean</type>
70 <default>1</default>
71 <comment>Should membership transactions be processed separately</comment>
72 <add>1.5</add>
73 </field>
74 <field>
75 <name>new_title</name>
76 <type>varchar</type>
77 <length>255</length>
78 <localizable>true</localizable>
79 <comment>Title to display at top of block</comment>
80 <add>1.5</add>
81 </field>
82 <field>
83 <name>new_text</name>
84 <type>text</type>
85 <localizable>true</localizable>
86 <comment>Text to display below title</comment>
87 <add>1.5</add>
88 </field>
89 <field>
90 <name>renewal_title</name>
91 <type>varchar</type>
92 <length>255</length>
93 <localizable>true</localizable>
94 <comment>Title for renewal</comment>
95 <add>1.5</add>
96 </field>
97 <field>
98 <name>renewal_text</name>
99 <type>text</type>
100 <localizable>true</localizable>
101 <comment>Text to display for member renewal</comment>
102 <add>1.5</add>
103 </field>
104 <field>
105 <name>is_required</name>
106 <title>Is Required</title>
107 <type>boolean</type>
108 <default>0</default>
109 <comment>Is membership sign up optional</comment>
110 <add>1.5</add>
111 </field>
112 <field>
113 <name>is_active</name>
114 <title>Is Active</title>
115 <type>boolean</type>
116 <default>1</default>
117 <comment>Is this membership_block enabled</comment>
118 <add>1.5</add>
119 </field>
120 </table>