Database and New Plugin

I am working on a new plug-in and I need to store "last reported inventory values." The easiest thing to do is to add a field to the products table (SBA is another consideration for later). Is that considered the best practice? I guess as long as I include both field creation in the install script and deletion in the uninstall script I should be okay, right?

Quote:

---

Originally Posted by g2ktcf

I am working on a new plug-in and I need to store "last reported inventory values." The easiest thing to do is to add a field to the products table (SBA is another consideration for later). Is that considered the best practice? I guess as long as I include both field creation in the install script and deletion in the uninstall script I should be okay, right?

---

FWIW, adding that field to the products table would be the approach I'd use. Just name the field 'appropriately' so that it's not likely to be overwritten by a Zen Cart upgrade that adds such a field.

Quote:

---

Originally Posted by lat9

FWIW, adding that field to the products table would be the approach I'd use. Just name the field 'appropriately' so that it's not likely to be overwritten by a Zen Cart upgrade that adds such a field.

---

Good Point, I never considered that another upgrade would overwrite it! Thanks!