Changes between Version 19 and Version 20 of DatabaseProgramming

Timestamp:

06/15/26 11:49:56 (2 days ago)

Author:

231072

Comment:

--

DatabaseProgramming

@@ -349 +349 @@
     SET quantity = quantity - p_quantity
     WHERE product_id = p_product_id;
-   --ako e 0 da go deaktivira
+
+    UPDATE product
+    SET is_active = 0
+    WHERE product_id = p_product_id
+    AND quantity <= 0;
+   
+
 
 END;