phpOpenTracker/phpOpenTracker/Database/Driver MySQL_Merge.php,1.7,1.8
Sebastian Bergmann <[email protected]> Sun, 11 Apr 2004 17:20:24 +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-serv20463
Modified Files:
MySQL_Merge.php
Log Message:
Whitespace fix.
Index: MySQL_Merge.php
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/Database/Driver/MySQL_Merge.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- MySQL_Merge.php 8 Mar 2004 05:16:07 -0000 1.7
+++ MySQL_Merge.php 11 Apr 2004 17:20:21 -0000 1.8
@@ -22,37 +22,37 @@
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 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,
+ 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";
- PRIMARY KEY (accesslog_id),
- KEY client_time (client_id, timestamp)
- ) %s';
+ 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';
/**
* Rewrites an SQL query, for instance to LIMIT it.
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click