diff -r 0c6ad9e0f143 -r d06ddc4d1af0 www/import/from_brouwhulp.php --- a/www/import/from_brouwhulp.php Sun Nov 18 22:15:31 2018 +0100 +++ b/www/import/from_brouwhulp.php Mon Nov 19 13:44:07 2018 +0100 @@ -477,11 +477,14 @@ $pSugar = 0; $svg = 77; $colorw = 0; + $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); if ($brews) - $sql = "INSERT INTO production SET name='" . mysqli_real_escape_string($db, $recipe->NAME); + $sql = "INSERT INTO brews SET uuid='" . $uuid; else - $sql = "INSERT INTO recipes SET name='" . mysqli_real_escape_string($db, $recipe->NAME); + $sql = "INSERT INTO recipes SET uuid='" . $uuid; + $sql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); + $sql .= "', locked='0"; if ($recipe->NOTES) $sql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); else