CREATE TABLE `tblstaff_fcm_notification_registrations` (
  `id` varchar(191) NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL DEFAULT 1,
  `staff_id` bigint(20) UNSIGNED NOT NULL,
  `device_id` varchar(191) DEFAULT NULL,
  `fcm_token` varchar(191) NOT NULL,
  `device_type` enum('android','ios'),
  `is_current` tinyint(1) NOT NULL DEFAULT '1',
  `last_activity_done_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `tblstaff_fcm_notification_registrations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tenant_id` (`tenant_id`),
  ADD KEY `staff_id` (`staff_id`);