PHP Classes

File: visits.sql

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