Commit | Line | Data |
---|---|---|
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> | |
d31fb4e3 | 10 | <component>CiviMember</component> |
6a488035 | 11 | <field> |
5435b737 | 12 | <name>id</name> |
0d94665e | 13 | <title>Membership Block ID</title> |
5435b737 EM |
14 | <type>int unsigned</type> |
15 | <required>true</required> | |
16 | <comment>Membership Id</comment> | |
17 | <add>1.5</add> | |
6a488035 TO |
18 | </field> |
19 | <primaryKey> | |
5435b737 EM |
20 | <name>id</name> |
21 | <autoincrement>true</autoincrement> | |
6a488035 TO |
22 | </primaryKey> |
23 | <field> | |
5435b737 | 24 | <name>entity_table</name> |
0d94665e | 25 | <title>Membership Block Entity Table</title> |
5435b737 EM |
26 | <type>varchar</type> |
27 | <length>64</length> | |
28 | <comment>Name for Membership Status</comment> | |
29 | <add>1.5</add> | |
6a488035 TO |
30 | </field> |
31 | <field> | |
5435b737 | 32 | <name>entity_id</name> |
0d94665e | 33 | <title>Membership Block Entity ID</title> |
5435b737 EM |
34 | <type>int unsigned</type> |
35 | <required>true</required> | |
36 | <comment>FK to civicrm_contribution_page.id</comment> | |
37 | <add>1.5</add> | |
6a488035 | 38 | </field> |
3c7d2158 | 39 | <foreignKey> |
5435b737 EM |
40 | <name>entity_id</name> |
41 | <table>civicrm_contribution_page</table> | |
42 | <key>id</key> | |
43 | <add>1.5</add> | |
6a488035 TO |
44 | </foreignKey> |
45 | <field> | |
5435b737 | 46 | <name>membership_types</name> |
0d94665e | 47 | <title>Membership Block Membership Types</title> |
5435b737 | 48 | <type>varchar</type> |
baf5e798 | 49 | <length>1024</length> |
5435b737 | 50 | <comment>Membership types to be exposed by this block</comment> |
2a5c9b4d | 51 | <serialize>PHP</serialize> |
5435b737 | 52 | <add>1.5</add> |
baf5e798 DG |
53 | <!-- changed from varchar 255 to 1024 in 4.6 beta 2 --> |
54 | <change>4.6</change> | |
6a488035 | 55 | </field> |
3c7d2158 | 56 | <field> |
5435b737 | 57 | <name>membership_type_default</name> |
0d94665e | 58 | <title>Membership Block Default Type</title> |
5435b737 EM |
59 | <type>int unsigned</type> |
60 | <comment>Optional foreign key to membership_type</comment> | |
61 | <add>1.5</add> | |
6a488035 | 62 | </field> |
5435b737 EM |
63 | <foreignKey> |
64 | <name>membership_type_default</name> | |
65 | <table>civicrm_membership_type</table> | |
66 | <key>id</key> | |
67 | <add>1.5</add> | |
6a488035 | 68 | </foreignKey> |
3c7d2158 | 69 | <field> |
5435b737 | 70 | <name>display_min_fee</name> |
0d94665e | 71 | <title>Membership Block Display Minimum Fee</title> |
5435b737 EM |
72 | <type>boolean</type> |
73 | <default>1</default> | |
74 | <comment>Display minimum membership fee</comment> | |
75 | <add>1.5</add> | |
3c7d2158 | 76 | </field> |
77 | <field> | |
5435b737 | 78 | <name>is_separate_payment</name> |
0d94665e | 79 | <title>Membership Block Is Separate Payment</title> |
5435b737 EM |
80 | <type>boolean</type> |
81 | <default>1</default> | |
82 | <comment>Should membership transactions be processed separately</comment> | |
83 | <add>1.5</add> | |
3c7d2158 | 84 | </field> |
85 | <field> | |
5435b737 | 86 | <name>new_title</name> |
0d94665e | 87 | <title>Membership Block New Title</title> |
5435b737 EM |
88 | <type>varchar</type> |
89 | <length>255</length> | |
90 | <localizable>true</localizable> | |
91 | <comment>Title to display at top of block</comment> | |
92 | <add>1.5</add> | |
3c7d2158 | 93 | </field> |
94 | <field> | |
5435b737 | 95 | <name>new_text</name> |
0d94665e | 96 | <title>Membership Block New Text</title> |
5435b737 EM |
97 | <type>text</type> |
98 | <localizable>true</localizable> | |
99 | <comment>Text to display below title</comment> | |
100 | <add>1.5</add> | |
3c7d2158 | 101 | </field> |
5435b737 EM |
102 | <field> |
103 | <name>renewal_title</name> | |
0d94665e | 104 | <title>Membership Block Renewal Title</title> |
5435b737 EM |
105 | <type>varchar</type> |
106 | <length>255</length> | |
107 | <localizable>true</localizable> | |
108 | <comment>Title for renewal</comment> | |
109 | <add>1.5</add> | |
6a488035 | 110 | </field> |
5435b737 EM |
111 | <field> |
112 | <name>renewal_text</name> | |
0d94665e | 113 | <title>Membership Block Renewal Text</title> |
5435b737 EM |
114 | <type>text</type> |
115 | <localizable>true</localizable> | |
116 | <comment>Text to display for member renewal</comment> | |
117 | <add>1.5</add> | |
3c7d2158 | 118 | </field> |
5435b737 EM |
119 | <field> |
120 | <name>is_required</name> | |
121 | <title>Is Required</title> | |
122 | <type>boolean</type> | |
123 | <default>0</default> | |
124 | <comment>Is membership sign up optional</comment> | |
125 | <add>1.5</add> | |
3c7d2158 | 126 | </field> |
127 | <field> | |
5435b737 EM |
128 | <name>is_active</name> |
129 | <title>Is Active</title> | |
130 | <type>boolean</type> | |
131 | <default>1</default> | |
132 | <comment>Is this membership_block enabled</comment> | |
133 | <add>1.5</add> | |
3c7d2158 | 134 | </field> |
6a488035 | 135 | </table> |