1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
| -- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 26, 2007 at 05:34 PM
-- Server version: 5.0.30
-- PHP Version: 4.4.4-8
--
-- Database: `stats`
--
-- --------------------------------------------------------
--
-- Table structure for table `stats_access`
--
CREATE TABLE `stats_access` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`dt` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`page` varchar(255) collate utf8_unicode_ci NOT NULL,
`ip` varchar(15) collate utf8_unicode_ci NOT NULL,
`ua` varchar(255) collate utf8_unicode_ci NOT NULL,
`ua_info` varchar(255) collate utf8_unicode_ci NOT NULL,
`ua_type` varchar(32) collate utf8_unicode_ci NOT NULL,
`ua_ver` varchar(10) collate utf8_unicode_ci NOT NULL,
`os` varchar(32) collate utf8_unicode_ci NOT NULL,
`ref_md5` varchar(32) collate utf8_unicode_ci NOT NULL,
`ref_type` varchar(32) collate utf8_unicode_ci NOT NULL,
`ref` text collate utf8_unicode_ci NOT NULL,
`screen_x` int(10) unsigned NOT NULL,
`screen_y` int(10) unsigned NOT NULL,
`view_x` int(10) unsigned NOT NULL,
`view_y` int(10) unsigned NOT NULL,
`user` varchar(255) collate utf8_unicode_ci NOT NULL,
`session` varchar(255) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `ref_type` (`ref_type`),
KEY `page` (`page`),
KEY `ref_md5` (`ref_md5`),
KEY `dt` (`dt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `stats_iplocation`
--
CREATE TABLE `stats_iplocation` (
`ip` varchar(15) collate utf8_unicode_ci NOT NULL,
`code` varchar(3) collate utf8_unicode_ci NOT NULL,
`country` varchar(255) collate utf8_unicode_ci NOT NULL,
`city` varchar(255) collate utf8_unicode_ci NOT NULL,
`host` varchar(255) collate utf8_unicode_ci NOT NULL,
`lastupd` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`ip`),
KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- added 2007-01-28
ALTER TABLE `stats_access` CHANGE `dt` `dt` DATETIME NOT NULL ;
ALTER TABLE `stats_access` ADD `js` TINYINT( 1 ) NOT NULL AFTER `view_y` ;
UPDATE `stats_access` SET js = 1 ;
-- added 2007-01-31
ALTER TABLE `stats_access` ADD `uid` VARCHAR( 50 ) NOT NULL ;
CREATE TABLE `stats_outlinks` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`dt` datetime NOT NULL,
`session` varchar(255) collate utf8_unicode_ci NOT NULL,
`link_md5` varchar(32) collate utf8_unicode_ci NOT NULL,
`link` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `link_md5` (`link_md5`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- added 2007-02-04
ALTER TABLE `stats_outlinks` ADD `page` VARCHAR( 255 ) NOT NULL AFTER `dt` ;
CREATE TABLE `stats_search` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`dt` datetime NOT NULL,
`page` varchar(255) collate utf8_unicode_ci NOT NULL,
`query` varchar(255) collate utf8_unicode_ci NOT NULL,
`engine` varchar(255) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `stats_searchwords` (
`sid` BIGINT UNSIGNED NOT NULL ,
`word` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `sid` , `word` )
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- statistic fixes
update stats_access set ref_type='external' where ref LIKE 'http://digg.com/%';
update stats_access set ref_type='external' where ref LIKE 'http://del.icio.us/%';
update stats_access set ref_type='external' where ref LIKE 'http://www.stumbleupon.com/%';
update stats_access set ref_type='external' where ref LIKE 'http://swik.net/%';
update stats_access set ref_type='external' where ref LIKE 'http://segnalo.alice.it/%';
-- added 2008-06-15
CREATE TABLE `stats_refseen` (
`ref_md5` varchar(32) collate utf8_unicode_ci NOT NULL,
`dt` datetime NOT NULL,
PRIMARY KEY ( `ref_md5` ),
KEY `dt` (`dt`)
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-- This will take some time...
INSERT INTO stats_refseen (ref_md5,dt) SELECT ref_md5, MIN(dt) FROM stats_access GROUP BY ref_md5; |
Partager