PHP Classes

File: db_install.sql

Recommend this page to a friend!
  Classes of Cesar D. Rodas   gStats   db_install.sql   Download  
File: db_install.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL for store information
Class: gStats
Keep track of site visits and link clicks
Author: By
Last change: * adding a missing table
Date: 17 years ago
Size: 1,528 bytes
 

Contents

Class file image Download 
DROP TABLE IF EXISTS `gstats_out_clicks`;
CREATE TABLE `gstats_ads_click` (
`userId` int(11) NOT NULL,
`visitor` int(11) NOT NULL,
`page` varchar(250) NOT NULL,
`ads` varchar(50) NOT NULL,
`size` varchar(10) NOT NULL,
`dtime` datetime NOT NULL
);

DROP TABLE IF EXISTS `gstats_out_clicks`;
CREATE TABLE `gstats_out_clicks` (
  `usrId` int(11) NOT NULL,
  `visitorId` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `url` varchar(250) NOT NULL,
  `goto` varchar(250) NOT NULL,
  `text` text NOT NULL,
  KEY `usrId` (`usrId`,`date`)
) ;


DROP TABLE IF EXISTS `gstats_referer_info`;
CREATE TABLE `gstats_referer_info` (
  `usrId` int(11) NOT NULL,
  `visitorId` int(11) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `url` varchar(250) NOT NULL,
  `referer` varchar(250) NOT NULL,
  PRIMARY KEY  (`usrId`,`visitorId`,`url`),
  KEY `usrId` (`usrId`,`date`)
) ;


DROP TABLE IF EXISTS `gstats_unique_visitors`;
CREATE TABLE `gstats_unique_visitors` (
  `visitorId` int(11) NOT NULL auto_increment,
  `cookieId` varchar(32) NOT NULL,
  `IP` varchar(15) NOT NULL,
  `startTime` datetime NOT NULL,
  `user-agent` varchar(100) NOT NULL,
  PRIMARY KEY  (`visitorId`)
) ;


DROP TABLE IF EXISTS `gstats_users`;
CREATE TABLE `gstats_users` (
  `usrId` int(11) NOT NULL auto_increment,
  `usrEmail` varchar(50) NOT NULL,
  `usrPass` varchar(50) NOT NULL,
  `usrSite` varchar(50) NOT NULL,
  PRIMARY KEY  (`usrId`),
  KEY `usrEmail` (`usrEmail`)
) ;