Login   Register  
PHP Classes
elePHPant
Icontem

File: database.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of mahabub  >  webstat  >  database.txt  >  Download  
File: database.txt
Role: Auxiliary data
Content type: text/plain
Description: database file
Class: webstat
Get statistics of users accessing a site
Author: By
Last change: spelling correction
Date: 2008-10-29 10:49
Size: 3,378 bytes
 

Contents

Class file image Download
--
-- 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 ;