--
-- Table structure for table `ip2country`
--
CREATE TABLE IF NOT EXISTS `ip2country` (
`Ip2CountryID` int(10) unsigned NOT NULL auto_increment,
`Country` char(3) NOT NULL,
`Registry` char(10) NOT NULL,
`IpRangeFirst` bigint(20) NOT NULL,
`IpRangeLast` bigint(20) NOT NULL,
`IpRangeDate` datetime NOT NULL,
`IpRangeLength` int(11) NOT NULL,
`name` text NOT NULL,
`continent` text NOT NULL,
PRIMARY KEY (`Ip2CountryID`),
KEY `INDEX` (`Country`,`Registry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_additional_details`
--
CREATE TABLE IF NOT EXISTS `tbl_additional_details` (
`id` bigint(20) NOT NULL auto_increment,
`visit_id` bigint(20) NOT NULL,
`web_id` text NOT NULL,
`date` date default NULL,
`time` time NOT NULL,
`operting_system` varchar(500) NOT NULL,
`browser` varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_color`
--
CREATE TABLE IF NOT EXISTS `tbl_color` (
`id` bigint(20) NOT NULL auto_increment,
`visit_id` bigint(20) NOT NULL,
`web_id` text NOT NULL,
`date` date NOT NULL,
`time` time NOT NULL,
`color` text NOT NULL,
`resulation` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_country`
--
CREATE TABLE IF NOT EXISTS `tbl_country` (
`id` bigint(20) NOT NULL auto_increment,
`visit_id` bigint(20) NOT NULL,
`date` date NOT NULL,
`time` time NOT NULL,
`web_id` text NOT NULL,
`ip` varchar(30) NOT NULL,
`countrycode` varchar(10) NOT NULL,
`country` varchar(500) NOT NULL,
`continent` varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_refer_url`
--
CREATE TABLE IF NOT EXISTS `tbl_refer_url` (
`id` bigint(20) NOT NULL auto_increment,
`visit_id` bigint(20) NOT NULL,
`web_id` text NOT NULL,
`date` date NOT NULL,
`time` time NOT NULL,
`url` text NOT NULL,
`searchkey` text NOT NULL,
`searchengine` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_reload`
--
CREATE TABLE IF NOT EXISTS `tbl_reload` (
`id` bigint(20) NOT NULL auto_increment,
`website_id` text NOT NULL,
`date` date NOT NULL,
`time` time NOT NULL,
`javascript` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tbl_visitors`
--
CREATE TABLE IF NOT EXISTS `tbl_visitors` (
`id` bigint(20) NOT NULL auto_increment,
`website_id` text NOT NULL,
`date` date NOT NULL,
`time` time NOT NULL,
`javascript` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|