PHP Classes

File: database.txt

Recommend this page to a friend!
  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: 14 years ago
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 ;