Merge pull request #22980 from civicrm/5.48
[civicrm-core.git] / xml / schema / Event / Event.xml
index 10c768ca808cd485eb775b39210e294213f4c08b..1dcc7615b2e2604a6c47d6bff4749847d54367bb 100644 (file)
   <field>
     <name>is_public</name>
     <type>boolean</type>
+    <required>true</required>
     <title>Is Event Public</title>
     <default>1</default>
     <comment>Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs.</comment>
   </field>
   <field>
     <name>start_date</name>
-    <type>datetime</type>
+    <type>timestamp</type>
     <uniqueName>event_start_date</uniqueName>
     <title>Event Start Date</title>
     <headerPattern>/^start|(s(tart\s)?date)$/i</headerPattern>
     <import>true</import>
     <comment>Date and time that event starts.</comment>
     <add>1.7</add>
+    <required>false</required>
+    <default>NULL</default>
     <html>
       <type>Select Date</type>
       <formatType>activityDateTime</formatType>
   </field>
   <field>
     <name>end_date</name>
-    <type>datetime</type>
+    <type>timestamp</type>
     <uniqueName>event_end_date</uniqueName>
     <title>Event End Date</title>
     <headerPattern>/^end|(e(nd\s)?date)$/i</headerPattern>
     <import>true</import>
     <comment>Date and time that event ends. May be NULL if no defined end date/time</comment>
     <add>1.7</add>
+    <required>false</required>
+    <default>NULL</default>
     <html>
       <type>Select Date</type>
       <formatType>activityDateTime</formatType>
   <field>
     <name>is_online_registration</name>
     <type>boolean</type>
+    <required>true</required>
     <title>Is Online Registration</title>
     <default>0</default>
     <comment>If true, include registration link on Event Info page.</comment>
   </field>
   <field>
     <name>registration_start_date</name>
-    <type>datetime</type>
+    <type>timestamp</type>
     <comment>Date and time that online registration starts.</comment>
     <add>1.8</add>
+    <required>false</required>
+    <default>NULL</default>
     <html>
       <type>Select Date</type>
       <formatType>activityDateTime</formatType>
   </field>
   <field>
     <name>registration_end_date</name>
-    <type>datetime</type>
+    <type>timestamp</type>
     <comment>Date and time that online registration ends.</comment>
     <add>1.8</add>
+    <required>false</required>
+    <default>NULL</default>
     <html>
       <type>Select Date</type>
       <formatType>activityDateTime</formatType>
     <name>is_monetary</name>
     <title>Is this a PAID event?</title>
     <type>boolean</type>
+    <required>true</required>
     <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>
     <name>is_map</name>
     <title>Map Enabled</title>
     <type>boolean</type>
+    <required>true</required>
     <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>
     <name>is_active</name>
     <title>Is Active</title>
     <type>boolean</type>
+    <required>true</required>
     <default>0</default>
     <comment>Is this Event enabled or disabled/cancelled?</comment>
     <add>1.7</add>
   <field>
     <name>is_show_location</name>
     <type>boolean</type>
+    <required>true</required>
     <title>show location</title>
     <default>1</default>
     <comment>If true, show event location.</comment>
   <field>
     <name>is_email_confirm</name>
     <type>boolean</type>
+    <required>true</required>
     <title>Is confirm email</title>
     <default>0</default>
     <comment>If true, confirmation is automatically emailed to contact on successful registration.</comment>
     <name>is_pay_later</name>
     <title>Pay Later Allowed</title>
     <type>boolean</type>
+    <required>true</required>
     <default>0</default>
     <comment>if true - allows the user to send payment directly to the org later</comment>
     <add>2.0</add>
     <name>is_partial_payment</name>
     <title>Partial Payments Enabled</title>
     <type>boolean</type>
+    <required>true</required>
     <default>0</default>
     <comment>is partial payment enabled for this event</comment>
     <add>4.3</add>
     <name>is_multiple_registrations</name>
     <title>Allow Multiple Registrations</title>
     <type>boolean</type>
+    <required>true</required>
     <default>0</default>
     <comment>if true - allows the user to register multiple participants for event</comment>
     <add>2.1</add>
   <field>
     <name>allow_same_participant_emails</name>
     <type>boolean</type>
+    <required>true</required>
     <title>Does Event allow multiple registrations from same email address?</title>
     <default>0</default>
     <comment>if true - allows the user to register multiple registrations from same email address.</comment>
     <name>has_waitlist</name>
     <title>Waitlist Enabled</title>
     <type>boolean</type>
+    <required>true</required>
+    <default>0</default>
     <comment>Whether the event has waitlist support.</comment>
     <add>3.0</add>
     <html>
   <field>
     <name>requires_approval</name>
     <type>boolean</type>
+    <required>true</required>
+    <default>0</default>
     <comment>Whether participants require approval before they can finish registering.</comment>
     <add>3.0</add>
     <html>
   <field>
     <name>allow_selfcancelxfer</name>
     <type>boolean</type>
+    <required>true</required>
     <default>0</default>
     <title>Allow Self-service Cancellation or Transfer</title>
     <comment>Allow self service cancellation or transfer for event?</comment>
     <name>is_template</name>
     <title>Is an Event Template</title>
     <type>boolean</type>
+    <required>true</required>
     <default>0</default>
     <required>true</required>
     <comment>whether the event has template</comment>
        <type>EntityRef</type>
        <label>Campaign</label>
     </html>
+    <pseudoconstant>
+      <table>civicrm_campaign</table>
+      <keyColumn>id</keyColumn>
+      <labelColumn>title</labelColumn>
+      <prefetch>FALSE</prefetch>
+    </pseudoconstant>
   </field>
   <foreignKey>
     <name>campaign_id</name>
     <name>is_share</name>
     <title>Is shared through social media</title>
     <type>boolean</type>
+    <required>true</required>
     <default>1</default>
     <comment>Can people share the event through social media?</comment>
     <add>4.1</add>
     <name>is_confirm_enabled</name>
     <title>Is the booking confirmation screen enabled?</title>
     <type>boolean</type>
+    <required>true</required>
     <default>1</default>
     <comment>If false, the event booking confirmation screen gets skipped</comment>
     <add>4.5</add>
     <name>is_billing_required</name>
     <title>Is billing block required</title>
     <type>boolean</type>
+    <required>true</required>
     <default>0</default>
     <comment>if true than billing block is required this event</comment>
     <add>4.6</add>
       <type>CheckBox</type>
     </html>
   </field>
+  <field>
+    <name>event_tz</name>
+    <type>text</type>
+    <uniqueName>event_tz</uniqueName>
+    <title>Event Time Zone</title>
+    <import>true</import>
+    <comment>Event's native time zone</comment>
+    <add>5.47</add>
+    <default>NULL</default>
+    <html>
+      <type>Select</type>
+    </html>
+    <pseudoconstant>
+      <callback>CRM_Core_SelectValues::timezone</callback>
+    </pseudoconstant>
+  </field>
 </table>