Login   Register  
PHP Classes
elePHPant
Icontem

File: visits.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Olaf Lederer  >  Counter & visitor statistics  >  visits.sql  >  Download  
File: visits.sql
Role: Auxiliary data
Content type: text/plain
Description: sql visits table
Class: Counter & visitor statistics
System to track users and visitor statistics
Author: By
Last change: added a new col: country
Date: 2005-02-03 13:24
Size: 408 bytes
 

Contents

Class file image Download 
CREATE TABLE `visits` (
  `id` int(11) NOT NULL auto_increment,
  `ip_adr` varchar(15) NOT NULL default '',
  `referer` varchar(250) NOT NULL default '',
  `country` char(2) NOT NULL default '',
  `client` varchar(100) NOT NULL default '',
  `visit_date` date default NULL,
  `time` time NOT NULL default '00:00:00',
  `on_page` varchar(35) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;