[phpwiki-checkins] SF.net SVN: phpwiki:[7117] trunk/schemas/mysql-initialize.sql

[<ru...@us...>]

Revision: 7117
          http://phpwiki.svn.sourceforge.net/phpwiki/?rev=7117&view=rev
Author:   rurban
Date:     2009-09-15 08:02:20 +0000 (Tue, 15 Sep 2009)

Log Message:
-----------
Bug#2761192 mysql 5.1 timestamp changes
change to no automatic update per default, only if supported

Modified Paths:
--------------
    trunk/schemas/mysql-initialize.sql

Modified: trunk/schemas/mysql-initialize.sql
===================================================================
--- trunk/schemas/mysql-initialize.sql	2009-09-14 16:30:20 UTC (rev 7116)
+++ trunk/schemas/mysql-initialize.sql	2009-09-15 08:02:20 UTC (rev 7117)
@@ -113,7 +113,11 @@
         rateepage INT(11) NOT NULL,
         ratingvalue FLOAT NOT NULL,
         rateeversion INT(11) NOT NULL,
-        tstamp TIMESTAMP(14) NOT NULL,
+        tstamp TIMESTAMP,
+-- before:
+--      tstamp TIMESTAMP(14) NOT NULL,
+-- since mysql 5.1 better use:
+--      tstamp TIMESTAMP DEFAULT 0,
         PRIMARY KEY (dimension, raterpage, rateepage)
 );
 -- for empty dimensions use extra indices. see lib/wikilens/RatingsDb.php


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.