<length>255</length>
<localizable>true</localizable>
<comment>Event Title (e.g. Fall Fundraiser Dinner)</comment>
+ <html>
+ <type>Text</type>
+ </html>
<add>1.7</add>
</field>
<field>
<pseudoconstant>
<optionGroupName>event_type</optionGroupName>
</pseudoconstant>
+ <html>
+ <type>Select></type>
+ </html>
<comment>Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type.</comment>
<add>1.7</add>
</field>
<default>0</default>
<comment>Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.</comment>
<add>2.0</add>
+ <html>
+ <type>Select</type>
+ </html>
</field>
<index>
<name>index_participant_listing_id</name>
<default>1</default>
<comment>Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.</comment>
<add>1.7</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>start_date</name>
<import>true</import>
<comment>Date and time that event starts.</comment>
<add>1.7</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>end_date</name>
<import>true</import>
<comment>Date and time that event ends. May be NULL if no defined end date/time</comment>
<add>1.7</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>is_online_registration</name>
<default>0</default>
<comment>If true, include registration link on Event Info page.</comment>
<add>1.7</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>registration_link_text</name>
<localizable>true</localizable>
<comment>Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.</comment>
<add>1.7</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>registration_start_date</name>
<type>datetime</type>
<comment>Date and time that online registration starts.</comment>
<add>1.8</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>registration_end_date</name>
<type>datetime</type>
<comment>Date and time that online registration ends.</comment>
<add>1.8</add>
+ <html>
+ <type>Select Date</type>
+ </html>
</field>
<field>
<name>max_participants</name>
<default>NULL</default>
<comment>Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants.</comment>
<add>1.7</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>event_full_text</name>
<default>0</default>
<comment>If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration.</comment>
<add>1.7</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>contribution_type_id</name>
<keyColumn>id</keyColumn>
<labelColumn>name</labelColumn>
</pseudoconstant>
+ <html>
+ <type>Select></type>
+ </html>
<add>4.3</add>
</field>
<field>
<keyColumn>id</keyColumn>
<labelColumn>name</labelColumn>
</pseudoconstant>
+ <html>
+ <type>Select></type>
+ </html>
<add>1.8</add>
</field>
<field>
<default>0</default>
<comment>Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified?</comment>
<add>1.7</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>is_active</name>
<default>0</default>
<comment>Is this Event enabled or disabled/cancelled?</comment>
<add>1.7</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>fee_label</name>
<headerPattern>/^fee|(f(ee\s)?label)$/i</headerPattern>
<length>255</length>
<localizable>true</localizable>
+ <html>
+ <type>Text</type>
+ </html>
<add>1.8</add>
</field>
<field>
<default>1</default>
<comment>If true, show event location.</comment>
<add>1.7</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>loc_block_id</name>
<default>1</default>
<comment>Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role.</comment>
<add>2.0</add>
+ <html>
+ <type>Select</type>
+ </html>
</field>
<field>
<name>intro_text</name>
<default>NULL</default>
<localizable>true</localizable>
<comment>Title for Confirmation page.</comment>
+ <html>
+ <type>Text</type>
+ </html>
<add>1.7</add>
</field>
<field>
<default>0</default>
<comment>If true, confirmation is automatically emailed to contact on successful registration.</comment>
<add>1.7</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>confirm_email_text</name>
<localizable>true</localizable>
<comment>FROM email name used for confirmation emails.</comment>
<add>1.7</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>confirm_from_email</name>
<length>255</length>
<comment>FROM email address used for confirmation emails.</comment>
<add>1.7</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>cc_confirm</name>
<type>varchar</type>
<length>255</length>
<comment>comma-separated list of email addresses to cc each time a confirmation is sent</comment>
+ <html>
+ <type>Text</type>
+ </html>
<add>1.7</add>
</field>
<field>
<type>varchar</type>
<length>255</length>
<comment>comma-separated list of email addresses to bcc each time a confirmation is sent</comment>
+ <html>
+ <type>Text</type>
+ </html>
<add>1.7</add>
</field>
<field>
<localizable>true</localizable>
<comment>Title for ThankYou page.</comment>
<add>1.7</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>thankyou_text</name>
<default>0</default>
<comment>if true - allows the user to send payment directly to the org later</comment>
<add>2.0</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>pay_later_text</name>
<localizable>true</localizable>
<comment>The text displayed to the user in the main form</comment>
<add>2.0</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>pay_later_receipt</name>
<localizable>true</localizable>
<comment>The receipt sent to the user instead of the normal receipt text</comment>
<add>2.0</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>is_partial_payment</name>
<default>0</default>
<comment>is partial payment enabled for this event</comment>
<add>4.3</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>initial_amount_label</name>
<localizable>true</localizable>
<comment>Initial amount label for partial payment</comment>
<add>4.3</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>initial_amount_help_text</name>
<localizable>true</localizable>
<comment>Initial amount help text for partial payment</comment>
<add>4.3</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>min_initial_amount</name>
<type>decimal</type>
<comment>Minimum initial amount for partial payment</comment>
<add>4.3</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>is_multiple_registrations</name>
<default>0</default>
<comment>if true - allows the user to register multiple participants for event</comment>
<add>2.1</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>allow_same_participant_emails</name>
<default>0</default>
<comment>if true - allows the user to register multiple registrations from same email address.</comment>
<add>2.2</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>has_waitlist</name>
<type>boolean</type>
<comment>Whether the event has waitlist support.</comment>
<add>3.0</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>requires_approval</name>
<type>boolean</type>
<comment>Whether participants require approval before they can finish registering.</comment>
<add>3.0</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>expiration_time</name>
<type>int unsigned</type>
<comment>Expire pending but unconfirmed registrations after this many hours.</comment>
<add>3.0</add>
+ <html>
+ <type>Text</type>
+ </html>
</field>
<field>
<name>waitlist_text</name>
<default>0</default>
<comment>whether the event has template</comment>
<add>3.0</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>template_title</name>
<length>255</length>
<localizable>true</localizable>
<comment>Event Template Title</comment>
+ <html>
+ <type>Text</type>
+ </html>
<add>3.0</add>
</field>
<field>
<labelColumn>full_name</labelColumn>
<nameColumn>numeric_code</nameColumn>
</pseudoconstant>
+ <html>
+ <type>Select></type>
+ </html>
</field>
<field>
<name>campaign_id</name>
<title>Campaign ID</title>
<comment>The campaign for which this event has been created.</comment>
<add>3.4</add>
+ <html>
+ <type>Autocomplete-Select</type>
+ </html>
</field>
<foreignKey>
<name>campaign_id</name>
<default>1</default>
<comment>Can people share the event through social media?</comment>
<add>4.1</add>
+ <html>
+ <type>CheckBox</type>
+ </html>
</field>
<field>
<name>parent_event_id</name>
<title>Parent Event ID</title>
<default>NULL</default>
<comment>Implicit FK to civicrm_event: parent event</comment>
+ <html>
+ <type>Autocomplete-Select</type>
+ </html>
<add>4.1</add>
</field>
<index>
<default>NULL</default>
<comment>Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot.</comment>
<add>4.1</add>
+ <html>
+ <type>Select</type>
+ </html>
</field>
</table>