now_session

CREATE TABLE `now_session` (
  `id` bigint(19) unsigned NOT NULL AUTO_INCREMENT,
  `log_call_id` bigint(20) unsigned DEFAULT NULL,
  `log_listen_id` bigint(20) DEFAULT NULL,
  `log_campaign_id` bigint(20) unsigned DEFAULT NULL,
  `log_campaign_siptransfer_id` bigint(20) unsigned DEFAULT NULL,
  `device_user_agent` varchar(128) DEFAULT NULL,
  `call_server_id` bigint(19) unsigned DEFAULT NULL,
  `call_type` enum('PHONE','WIDGET','ANDROID','IOS') DEFAULT 'PHONE',
  `call_date_start` datetime DEFAULT NULL,
  `call_asterisk_sip_ip` varchar(15) DEFAULT NULL,
  `call_asterisk_channel` char(64) DEFAULT NULL,
  `call_asterisk_uniqueid` char(64) DEFAULT NULL,
  `call_widget_listener_ip` char(15) DEFAULT NULL,
  `call_widget_refer` char(128) DEFAULT NULL,
  `call_ani_e164` char(32) DEFAULT NULL,
  `call_did_e164` char(32) DEFAULT NULL,
  `call_token` char(64) DEFAULT NULL,
  `call_listener_play_welcome` tinyint(1) DEFAULT '1',
  `call_listener_token_id` bigint(20) unsigned DEFAULT NULL,
  `call_listener_ani_id` bigint(20) unsigned DEFAULT NULL,
  `call_listener_id` bigint(19) unsigned DEFAULT NULL,
  `call_listener_is_anonymous` tinyint(1) DEFAULT NULL,
  `call_entryway_id` bigint(19) unsigned DEFAULT NULL,
  `call_gateway_id` bigint(19) unsigned DEFAULT NULL,
  `listen_active` tinyint(1) DEFAULT '0',
  `listen_date_start` datetime DEFAULT NULL,
  `listen_extension` char(16) DEFAULT NULL,
  `listen_content_id` bigint(19) unsigned DEFAULT NULL,
  `listen_gateway_conference_id` bigint(20) unsigned DEFAULT NULL,
  `listen_server_id` bigint(20) DEFAULT NULL,
  `listen_last_played_campaign_id` bigint(20) unsigned DEFAULT NULL,
  `listen_last_played_campaign_timestamp` datetime DEFAULT NULL,
  `listen_last_played_campaign_log_id` bigint(20) unsigned DEFAULT NULL,
  `listen_last_played_campaigns_interruption_timestamps` char(255) DEFAULT NULL,
  `listen_last_played_campaigns_interruption_ids` char(255) DEFAULT NULL,
  `listen_asterisk_channel` char(64) DEFAULT NULL,
  `listen_asterisk_uniqueid` char(64) DEFAULT NULL,
  `listen_interactive_handup_active` tinyint(1) DEFAULT '0',
  `listen_interactive_handup_active_timestamp` datetime DEFAULT NULL,
  `listen_interactive_handup_count` int(10) unsigned DEFAULT '0',
  `listen_interactive_poll_opt_1` int(10) unsigned DEFAULT '0',
  `listen_interactive_poll_opt_2` int(10) unsigned DEFAULT '0',
  `listen_interactive_poll_opt_3` int(10) unsigned DEFAULT '0',
  `listen_interactive_poll_lastchange` datetime DEFAULT NULL,
  `listen_interactive_status_talk_count` int(10) unsigned DEFAULT '0',
  `listen_interactive_status_privatetalk_count` int(10) unsigned DEFAULT '0',
  `engine_type` enum('LISTEN','TALK','PRIVATETALK','ADVERTISE','ADVERTISESIPTRANSFER','HANGUP') DEFAULT NULL,
  `engine_date_start` datetime DEFAULT NULL,
  `engine_server_id` bigint(19) unsigned DEFAULT NULL,
  `engine_asterisk_channel` char(64) DEFAULT NULL,
  `engine_asterisk_uniqueid` char(64) DEFAULT NULL,
  `engine_sip_call_id` varchar(255) DEFAULT NULL,
  `engine_advertise_trigger_type` enum('LISTENERMANUAL','LISTENERTIMEOUT','LISTENERPREROLL','LISTENERREQUEST','CONFERENCEMANUAL','CONFERENCETIMEOUT','CONFERENCEADREPLACE') DEFAULT NULL,
  `engine_campaign_id` bigint(20) unsigned DEFAULT NULL,
  `next_step_1_engine_type` enum('LISTEN','TALK','PRIVATETALK','ADVERTISE','ADVERTISESIPTRANSFER','HANGUP') DEFAULT NULL,
  `next_step_1_engine_advertise_trigger_type` enum('LISTENERMANUAL','LISTENERTIMEOUT','LISTENERPREROLL','LISTENERREQUEST','CONFERENCEMANUAL','CONFERENCETIMEOUT','CONFERENCEADREPLACE') DEFAULT NULL,
  `next_step_1_engine_campaign_id` bigint(20) unsigned DEFAULT NULL,
  `next_step_2_engine_type` enum('LISTEN','TALK','PRIVATETALK','ADVERTISE','ADVERTISESIPTRANSFER','HANGUP') DEFAULT NULL,
  `next_step_2_engine_advertise_trigger_type` enum('LISTENERMANUAL','LISTENERTIMEOUT','LISTENERPREROLL','LISTENERREQUEST','CONFERENCEMANUAL','CONFERENCETIMEOUT','CONFERENCEADREPLACE') DEFAULT NULL,
  `next_step_2_engine_campaign_id` bigint(20) unsigned DEFAULT NULL,
  `last_engine_type` enum('LISTEN','TALK','PRIVATETALK','ADVERTISE','ADVERTISESIPTRANSFER','HANGUP') DEFAULT NULL,
  `last_engine_advertise_trigger_type` enum('LISTENERMANUAL','LISTENERTIMEOUT','LISTENERPREROLL','LISTENERREQUEST','CONFERENCEMANUAL','CONFERENCETIMEOUT','CONFERENCEADREPLACE') DEFAULT NULL,
  `last_engine_campaign_id` bigint(20) unsigned DEFAULT NULL,
  `talk_volume_percent` int(10) DEFAULT '100',
  `device_has_microphone` tinyint(1) DEFAULT '0',
  `device_listener_ip` varchar(15) DEFAULT NULL,
  `device_website` varchar(128) DEFAULT NULL,
  `engine_mpe_id` varchar(255) DEFAULT NULL,
  `listen_volume_percent` int(10) DEFAULT '100',
  PRIMARY KEY (`id`),
  KEY `call_server` (`call_server_id`),
  KEY `date_start` (`call_date_start`),
  KEY `search_call_by_channel` (`call_asterisk_channel`,`call_server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8