Changeset 601 for trunk/lib/Version.inc.php

Timestamp:

Apr 27, 2017 4:43:35 PM (7 years ago)

Author:

anonymous

Message:

Updated every instance of 'zero' date 0000-00-00 to use 1000-01-01 if mysql version >= 5.7.4

File:

• trunk/lib/Version.inc.php (modified) (2 diffs)

trunk/lib/Version.inc.php

@@ -123 +123 @@
                 $app->logMsg(sprintf('Dropping and recreating table %s.', $this->getParam('db_table')), LOG_INFO, __FILE__, __LINE__);
             }
-            $db->query("CREATE TABLE IF NOT EXISTS " . $db->escapeString($this->getParam('db_table')) . " (
+            $db->query(sprintf("CREATE TABLE IF NOT EXISTS %s (
                 version_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
                 record_table VARCHAR(255) NOT NULL DEFAULT '',
@@ -133 +133 @@
                 version_notes VARCHAR(255) NOT NULL DEFAULT '',
                 saved_by_user_id SMALLINT(11) NOT NULL DEFAULT '0',
-                version_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+                version_datetime DATETIME NOT NULL DEFAULT '%s 00:00:00',
                 KEY record_table (record_table),
                 KEY record_key (record_key),
                 KEY record_val (record_val)
-            )");
+            )", $db->escapeString($this->getParam('db_table')), $db->getParam('zero_date')));
 
             if (!$db->columnExists($this->getParam('db_table'), array(