CREATE TABLE `psi_notification_targets` (
  `notar_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notar_date` date DEFAULT NULL,
  `notar_msg` mediumtext COLLATE utf8mb4_unicode_ci,
  `notar_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `notar_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `notar_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `notar_gsm` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `notar_sent` tinyint(1) unsigned DEFAULT '0',
  `notar_seen` tinyint(1) unsigned DEFAULT '0',
  `not_id` bigint(20) unsigned DEFAULT '0',
  `u_id` bigint(20) unsigned DEFAULT '0',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` date DEFAULT NULL,
  `date_encoded` datetime DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `encoder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `updater` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `region_id` bigint(20) unsigned DEFAULT '6',
  PRIMARY KEY (`notar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

