--
-- iCagenda: Install Database `icagenda tickets`
--

-- --------------------------------------------------------

--
-- Table structure for table `#__icagenda_tickets`
--

CREATE TABLE IF NOT EXISTS `#__icagenda_tickets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `ref` varchar(10) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `published` tinyint(3) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ref` (`ref`),
  KEY `idx_published` (`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;