-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 24, 2014 at 09:53 AM
-- Server version: 5.6.12-log
-- PHP Version: 5.4.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `e_court`
--

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

--
-- Table structure for table `site_trafic`
--

CREATE TABLE IF NOT EXISTS `site_trafic` (
  `uni_id` int(11) NOT NULL AUTO_INCREMENT,
  `hit_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `country_code` varchar(50) CHARACTER SET utf8 NOT NULL,
  `country_name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `continent_Code` varchar(10) CHARACTER SET utf8 NOT NULL,
  `city_details` varchar(50) CHARACTER SET utf8 NOT NULL,
  `region_details` varchar(50) CHARACTER SET utf8 NOT NULL,
  `Longitude` text CHARACTER SET utf8 NOT NULL,
  `Latitude` text CHARACTER SET utf8 NOT NULL,
  `currency_code` varchar(10) CHARACTER SET utf8 NOT NULL,
  `visited_url` text CHARACTER SET utf8 NOT NULL,
  `ip_address` text CHARACTER SET utf8 NOT NULL,
  `hits` text CHARACTER SET utf8 NOT NULL,
  `reff_url` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`uni_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `site_trafic`
--

INSERT INTO `site_trafic` (`uni_id`, `hit_date`, `country_code`, `country_name`, `continent_Code`, `city_details`, `region_details`, `Longitude`, `Latitude`, `currency_code`, `visited_url`, `ip_address`, `hits`, `reff_url`) VALUES
(1, '2014-12-24 13:04:55', '', '', '', '', '', '', '', '', 'http://localhost/calendar/index2.php', '', '1', ''),
(2, '2014-12-24 13:04:55', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/site_trafic/index2.php', '127.0.0.1', '1', ''),
(3, '2014-12-24 13:04:55', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/site_trafic/index2.php', '127.0.0.1', '1', ''),
(4, '2014-12-24 13:04:55', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/site_trafic/index2.php', '127.0.0.1', '1', ''),
(5, '2014-12-24 13:18:00', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(6, '2014-12-24 13:20:16', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(7, '2014-12-24 13:21:06', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(8, '2014-12-24 14:23:56', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(9, '2014-12-24 14:24:13', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(10, '2014-12-24 14:29:40', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'http://localhost/PHP_HTML_Version/Welcome.php', 'a', '1', ''),
(11, '2014-12-24 14:29:49', '', '', '', '', '', '', '', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '', '1', ''),
(12, '2014-12-24 14:31:30', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(13, '2014-12-24 14:32:00', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(14, '2014-12-24 14:37:12', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(15, '2014-12-24 14:40:29', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', 'ipadpeek.com'),
(16, '2014-12-24 14:40:45', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(17, '2014-12-24 14:41:08', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(18, '2014-12-24 14:41:20', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(19, '2014-12-24 14:41:33', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(20, '2014-12-24 14:41:49', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', 'ipadpeek.com'),
(21, '2014-12-24 14:42:17', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', 'ipadpeek.com'),
(22, '2014-12-24 14:58:47', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(23, '2014-12-24 15:08:05', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(24, '2014-12-24 15:08:09', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(25, '2014-12-24 15:08:20', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(26, '2014-12-24 15:11:33', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', ''),
(27, '2014-12-24 15:14:53', '', '', '', '', '', '0', '0', '', 'http://localhost/PHP_HTML_Version/Welcome.php', '127.0.0.1', '1', '');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
