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: 15 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`) ) ;