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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `location` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `is_academic` tinyint(1) NOT NULL DEFAULT '0',
  `cenos_app` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'INDUCTION',
  `license_key` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `first_use` timestamp NULL DEFAULT NULL,
  `last_use` timestamp NULL DEFAULT NULL,
  `machine_changes_left` smallint(6) NOT NULL DEFAULT '5',
  `last_machine` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `is_developer` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `license_key` (`license_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2962 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- RELATIONS FOR TABLE `users`:
--
