-- http://www.phpmyadmin.net
--




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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_visitor_remote_addr` text NOT NULL,
  `message_content` text NOT NULL,
  `message_by` text NOT NULL,
  `message_time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `message_alert_toclient` int(11) NOT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `no_of_client_msg`
--

CREATE TABLE IF NOT EXISTS `no_of_client_msg` (
  `client_msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_ip` text NOT NULL,
  PRIMARY KEY (`client_msg_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `visitors_online`
--

CREATE TABLE IF NOT EXISTS `visitors_online` (
  `visitor_online_id` int(50) NOT NULL AUTO_INCREMENT,
  `visOn_server_unique_id` text NOT NULL,
  `visOn_http_host` text NOT NULL,
  `visOn_user_agent` text NOT NULL,
  `visOn_remote_addr` text NOT NULL,
  `visOn_server_addr` text NOT NULL,
  `visOn_request_time` int(11) NOT NULL,
  `visOn_script_filename` text NOT NULL,
  `visOn_recent_interaction` int(11) NOT NULL,
  `visOn_time_stay` int(11) NOT NULL,
  `visOn_browser` text NOT NULL,
  `visOn_platform` text NOT NULL,
  `visitor_incoming_msg` int(11) NOT NULL,
  PRIMARY KEY (`visitor_online_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `visitors_online`
--

INSERT INTO `visitors_online` (`visitor_online_id`, `visOn_server_unique_id`, `visOn_http_host`, `visOn_user_agent`, `visOn_remote_addr`, `visOn_server_addr`, `visOn_request_time`, `visOn_script_filename`, `visOn_recent_interaction`, `visOn_time_stay`, `visOn_browser`, `visOn_platform`, `visitor_incoming_msg`) VALUES
(22, 'UwBZDH8AAQEAAAvnMWUAAAAC', 'localhost', 'Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:21.0) Gecko/20100101 Firefox/21.0', '127.0.0.1', '127.0.0.1', 1392531724, 'http://localhost/ravi/chatscript/newcss/script/client/clientChatBox.php', 1392532028, 1392531724, 'Firefox', 'Linux', 0);

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

--
-- Table structure for table `visitors_record`
--

CREATE TABLE IF NOT EXISTS `visitors_record` (
  `visitors_record_id` int(50) NOT NULL AUTO_INCREMENT,
  `visRec_server_unique_id` text NOT NULL,
  `visRec_http_host` text NOT NULL,
  `visRec_user_agent` text NOT NULL,
  `visRec_remote_addr` text NOT NULL,
  `visRec_server_addr` text NOT NULL,
  `visRec_request_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `visRec_script_filename` text NOT NULL,
  `visRec_browser` text NOT NULL,
  `visRec_platform` text NOT NULL,
  PRIMARY KEY (`visitors_record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `visitor_location`
--

CREATE TABLE IF NOT EXISTS `visitor_location` (
  `visitor_location_id` int(11) NOT NULL AUTO_INCREMENT,
  `visitor_remote_addr` text NOT NULL,
  `visitor_country_code` text NOT NULL,
  `visitor_country_name` text NOT NULL,
  `visitor_region_name` text NOT NULL,
  `visitor_city_name` text NOT NULL,
  `visitor_zipCode` text NOT NULL,
  `visitor_time_zone` text NOT NULL,
  `visitor_email` text NOT NULL,
  PRIMARY KEY (`visitor_location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

