phpOpenTracker/phpOpenTracker/DB mysql_merge.php,1.22.2.12.2.2,1.22.2.12.2.3

Sebastian Bergmann <[email protected]> Sat, 08 May 2004 13:11:30 +0000
Newsgroups gmane.comp.web.phpopentracker.cvs
Message-ID <[email protected]>
Update of /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/DB
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26923/phpOpenTracker/DB

Modified Files:
      Tag: phpOpenTracker_1_5
	mysql_merge.php 
Log Message:
MFB: Properly escape 'hour' columns.

Index: mysql_merge.php
===================================================================
RCS file: /cvsroot/phpopencounter/phpOpenTracker/phpOpenTracker/DB/Attic/mysql_merge.php,v
retrieving revision 1.22.2.12.2.2
retrieving revision 1.22.2.12.2.3
diff -u -d -r1.22.2.12.2.2 -r1.22.2.12.2.3
--- mysql_merge.php	8 May 2004 13:05:26 -0000	1.22.2.12.2.2
+++ mysql_merge.php	8 May 2004 13:11:28 -0000	1.22.2.12.2.3
@@ -44,7 +44,7 @@
          accesslog_id      INT(11)                NOT NULL,
          timestamp         INT(10)    UNSIGNED    NOT NULL,
          weekday           TINYINT(1) UNSIGNED    NOT NULL,
-         hour              TINYINT(2) 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,
@@ -72,7 +72,7 @@
          referer_id          INT(11)             NOT NULL,
          timestamp           INT(10)    UNSIGNED NOT NULL,
          weekday             TINYINT(1) UNSIGNED NOT NULL,
-         hour                TINYINT(2) UNSIGNED NOT NULL,
+         `hour`              TINYINT(2) UNSIGNED NOT NULL,
          returning_visitor   TINYINT(1) UNSIGNED NOT NULL,
 
          PRIMARY KEY         (accesslog_id),



-------------------------------------------------------
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver
higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3