-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Host: mysql9.servage.net
-- Generation Time: Mar 18, 2006 at 07:15 AM
-- Server version: 4.0.26
-- PHP Version: 4.3.3
-- 
-- Database: `sore4x4_stats`
-- 
-- CREATE DATABASE `sore4x4_stats`;
-- USE sore4x4_stats;

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

-- 
-- Table structure for table `browser_stats`
-- 

CREATE TABLE `browser_stats` (
  `browser` varchar(75) NOT NULL default '',
  `hits` int(5) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Dumping data for table `browser_stats`
-- 


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

-- 
-- Table structure for table `os_stats`
-- 

CREATE TABLE `os_stats` (
  `os` varchar(75) NOT NULL default '',
  `hits` int(5) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Dumping data for table `os_stats`
-- 


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

-- 
-- Table structure for table `referer_stats`
-- 

CREATE TABLE `referer_stats` (
  `referer` varchar(250) NOT NULL default '',
  `hits` int(5) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Dumping data for table `referer_stats`
-- 


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

-- 
-- Table structure for table `stats`
-- 

CREATE TABLE `stats` (
  `entry` varchar(75) NOT NULL default '',
  `value` int(5) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Dumping data for table `stats`
-- 


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

-- 
-- Table structure for table `visitors`
-- 

CREATE TABLE `visitors` (
  `id` int(5) NOT NULL auto_increment,
  `uid` varchar(35) NOT NULL default '',
  `date` varchar(75) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `user_agent` varchar(75) NOT NULL default '',
  `hostname` varchar(75) NOT NULL default '',
  `referer` varchar(125) NOT NULL default '',
  `port` int(5) NOT NULL default '0',
  `os` varchar(25) NOT NULL default '',
  `browser` varchar(50) NOT NULL default '',
  `version` varchar(10) NOT NULL default '',
  `city` varchar(50) NOT NULL default '',
  `country` varchar(50) NOT NULL default '',
  `countryabbrev` varchar(10) NOT NULL default '',
  `coordinates` varchar(50) NOT NULL default '',
  `entry` varchar(75) NOT NULL default '',
  `exit` varchar(75) NOT NULL default '',
  `pages` int(5) NOT NULL default '0',
  `timein` int(50) NOT NULL default '0',
  `timeout` int(50) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `visitors`
--