phpOpenTracker/phpOpenTracker/Database/Driver MySQL_Merge.php,1.8,1.9
Sebastian Bergmann <[email protected]> Thu, 27 May 2004 05:53:54 +0000
| Newsgroups | gmane.comp.web.phpopentracker.cvs |
|---|---|
| Message-ID | <[email protected]> |
Update of /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/Database/Driver
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16214/phpOpenTracker/Database/Driver
Modified Files:
MySQL_Merge.php
Log Message:
De-normalize database schema.
Index: MySQL_Merge.php
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/Database/Driver/MySQL_Merge.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- MySQL_Merge.php 11 Apr 2004 17:20:21 -0000 1.8
+++ MySQL_Merge.php 27 May 2004 05:53:52 -0000 1.9
@@ -22,37 +22,38 @@
require_once POT_INCLUDE_PATH . 'Database/Driver/MySQL.php';
class phpOpenTracker_Database_Driver_MySQL_Merge extends phpOpenTracker_Database_Driver_MySQL {
- const accesslogSchema = "CREATE %s TABLE %s %s (
- accesslog_id INT(11) NOT NULL,
- timestamp INT(10) UNSIGNED NOT NULL,
- weekday TINYINT(1) UNSIGNED NOT NULL,
- hour TINYINT(2) UNSIGNED NOT NULL,
- document_id INT(11) NOT NULL,
- exit_target_id INT(11) DEFAULT '0' NOT NULL,
- entry_document TINYINT(1) UNSIGNED NOT NULL,
-
- KEY accesslog_id (accesslog_id),
- KEY timestamp (timestamp),
- KEY document_id (document_id),
- KEY exit_target_id (exit_target_id)
- ) %s";
+ const pageImpressionsSchema = 'CREATE %s TABLE %s %s (
+ visit_id INT(11) NOT NULL,
+ timestamp INT(10) UNSIGNED NOT NULL,
+ weekday TINYINT(1) UNSIGNED NOT NULL,
+ `hour` TINYINT(2) UNSIGNED NOT NULL,
+ document VARCHAR(255) NOT NULL,
+ document_url VARCHAR(255) NOT NULL,
+ exit_target VARCHAR(255) NOT NULL,
+ entry_document TINYINT(1) UNSIGNED NOT NULL,
- const visitorsSchema = 'CREATE %s TABLE %s %s (
- accesslog_id INT(11) NOT NULL,
- visitor_id INT(11) NOT NULL,
- client_id INT(10) UNSIGNED NOT NULL,
- operating_system_id INT(11) NOT NULL,
- user_agent_id INT(11) NOT NULL,
- host_id INT(11) NOT NULL,
- referer_id INT(11) NOT NULL,
- timestamp INT(10) UNSIGNED NOT NULL,
- weekday TINYINT(1) UNSIGNED NOT NULL,
- hour TINYINT(2) UNSIGNED NOT NULL,
- returning_visitor TINYINT(1) UNSIGNED NOT NULL,
-
- PRIMARY KEY (accesslog_id),
- KEY client_time (client_id, timestamp)
- ) %s';
+ KEY visit_id (visit_id),
+ KEY timestamp (timestamp),
+ KEY document (document),
+ KEY exit_target (exit_target)
+ ) %s;';
+
+ const visitsSchema = 'CREATE %s TABLE %s %s (
+ visit_id INT(11) NOT NULL,
+ visitor_id INT(11) NOT NULL,
+ client_id INT(10) UNSIGNED NOT NULL,
+ timestamp INT(10) UNSIGNED NOT NULL,
+ weekday TINYINT(1) UNSIGNED NOT NULL,
+ `hour` TINYINT(2) UNSIGNED NOT NULL,
+ returning_visitor TINYINT(1) UNSIGNED NOT NULL,
+ host VARCHAR(255) NOT NULL,
+ operating_system VARCHAR(255) NOT NULL,
+ user_agent VARCHAR(255) NOT NULL,
+ referer VARCHAR(255) NOT NULL,
+
+ PRIMARY KEY (visit_id),
+ KEY client_time (client_id, timestamp)
+ ) %s;';
/**
* Rewrites an SQL query, for instance to LIMIT it.
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click