-- +--------------------------------------------------------------------+
-- | Copyright CiviCRM LLC. All rights reserved.                        |
-- |                                                                    |
-- | This work is published under the GNU AGPLv3 license with some      |
-- | permitted exceptions and without any warranty. For full license    |
-- | and copyright information, see https://civicrm.org/licensing       |
-- +--------------------------------------------------------------------+
--
-- Generated from schema.tpl
-- DO NOT EDIT.  Generated by CRM_Core_CodeGen
--
-- /*******************************************************
-- *
-- * Clean up the existing tables - this section generated from drop.tpl
-- *
-- *******************************************************/



-- /*******************************************************
-- *
-- * Create new tables
-- *
-- *******************************************************/

-- /*******************************************************
-- *
-- * civicrm_eventics
-- *
-- * Details for ics attachments for event registrations
-- *
-- *******************************************************/
CREATE TABLE `civicrm_eventics` (
  `id` int unsigned AUTO_INCREMENT COMMENT 'PK',
  `event_id` int unsigned COMMENT 'FK to Event',
  `ics_enabled` tinyint COMMENT 'Should the ics file be sent for this event?',
  `event_location` text COMMENT 'The URL or physical location of the event',
  `event_description` text COMMENT 'Details about the event',
  `event_timezone` text COMMENT 'Override the event timezone',
  PRIMARY KEY (`id`),
  CONSTRAINT FK_civicrm_eventics_event_id FOREIGN KEY (`event_id`) REFERENCES `civicrm_event`(`id`) ON DELETE CASCADE
)
ENGINE=InnoDB;
