Use NULL instead of actual values in the vars table, so that var tweaks result in smaller diffs.

1 files changed, 5 insertions, 0 deletions

diff --git a/modules/gallery/controllers/packager.php b/modules/gallery/controllers/packager.php
index 82c3c938..1354a01b 100644
--- a/modules/gallery/controllers/packager.php
+++ b/modules/gallery/controllers/packager.php
@@ -134,6 +134,11 @@ class Packager_Controller extends Controller {
         $line = preg_replace("/ENGINE=\S+ /", "", $line);
       }
 
+      // Null out ids in the vars table since it's an auto_increment table and this will result in
+      // more stable values so we'll have less churn in install.sql.
+      $line = preg_replace(
+        "/^INSERT INTO {vars} VALUES \(\d+/", "INSERT INTO {vars} VALUES (NULL", $line);
+
       $buf .= $line;
     }
     $fd = fopen($sql_file, "wb");