# HG changeset patch
# User Michiel Broek <mbroek@mbse.eu>
# Date 1542631447 -3600
# Node ID d06ddc4d1af04a2aab278894465a4143757e1560
# Parent  0c6ad9e0f143cb757289ebb03cb37613fd73807e
Added uuid and locked fields to the recipes table.

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