-- Run this in phpMyAdmin's SQL tab against your existing wbcorp_webapp database.
-- Live weight is now stored as the EXACT string received (e.g. "56700.80" stays
-- "56700.80" instead of being reinterpreted as the number 56700.8), matching what
-- a real indicator sends. gross/tare/net on tblTransaction stay numeric (DOUBLE)
-- since those feed billing/report totals and need real arithmetic, not just display.

ALTER TABLE tblLive_Weight MODIFY weight VARCHAR(20) DEFAULT '0';
ALTER TABLE tblTransaction MODIFY gross_weight DOUBLE;
ALTER TABLE tblTransaction MODIFY tare_weight DOUBLE;
ALTER TABLE tblTransaction MODIFY net_weight DOUBLE;