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