PHPCOUNTER VER 0.0.2

• ChangeLog
• READ ME
• TODO
• SQL
• INSTALL
• Manifest
• Download
• Document
• Live Demo

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : phpCounter

# --------------------------------------------------------
#
# Table structure for table 'counter'
#

CREATE TABLE counter_data (
counter_id mediumint(7) unsigned DEFAULT '0' NOT NULL auto_increment,
name char(16) NOT NULL,
since date DEFAULT '0000-00-00' NOT NULL,
host char(32) NOT NULL,
hit mediumint(7) DEFAULT '0' NOT NULL,
digit char(16) NOT NULL,
refresh enum('1','0') DEFAULT '1' NOT NULL,
PRIMARY KEY (counter_id),
UNIQUE name (name)
);


# --------------------------------------------------------
#
# Table structure for table 'hit'
#

CREATE TABLE counter_hit (
hit_id int(9) unsigned DEFAULT '0' NOT NULL auto_increment,
ip char(15) NOT NULL,
hit mediumint(7) unsigned DEFAULT '0' NOT NULL,
date date DEFAULT '0000-00-00' NOT NULL,
counter_id mediumint(7) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (hit_id)
);