phpOpenTracker/phpOpenTracker/Database/Driver MySQL_Merge.php,1.4,1.5

Update of /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/Database/Driver
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31383/phpOpenTracker/Database/Driver

Modified Files:
	MySQL_Merge.php 
Log Message:
Flush.

Index: MySQL_Merge.php
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/Database/Driver/MySQL_Merge.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** MySQL_Merge.php	27 Feb 2004 06:50:49 -0000	1.4
--- MySQL_Merge.php	29 Feb 2004 10:39:08 -0000	1.5
***************
*** 23,26 ****
--- 23,58 ----
  
  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,
+ 
+                             PRIMARY KEY         (accesslog_id),
+                             KEY client_time     (client_id, timestamp)
+                           ) %s';
+ 
      protected function prepareQuery(&$query, $parameters, $isManip) {
          parent::prepareQuery($query, $parameters, $isManip);



-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click