BLENDTECH, A division of PT Industrial Electric Co.

This script resets few fields to NULL in BayProfile, PresetProfile and MeterProfile tables

Script:

mysql -u ttadmin -ptoptech -A Tms6Data -e "update BayProfile set rcu_ticket_no = '0000';"

mysql -u ttadmin -ptoptech -A Tms6Data -e "update PresetProfile set gross_totalizer = NULL, net_totalizer = NULL, min_preset = '0100', batch_cnt = NULL, meter_factor_A1 = NULL, meter_factor_A2 = NULL, meter_factor_A3 = NULL, meter_factor_A4 = NULL, meter_factor_A5 = NULL, meter_factor_A6 = NULL;"

mysql -u ttadmin -ptoptech -A Tms6Data -e "update MeterProfile set active_tank = NULL, gross_totalizer = NULL, actual_gross_totalizer = NULL, meter_factor_A1 = NULL, meter_factor_rate_A1 = NULL, meter_factor_A2 = NULL, meter_factor_rate_A2 = NULL, meter_factor_A3 = NULL, meter_factor_rate_A3 = NULL, meter_factor_A4 = NULL, meter_factor_rate_A4 = NULL, meter_factor_A5 = NULL, meter_factor_rate_A5 = NULL, meter_factor_A6 = NULL, meter_factor_rate_A6 = NULL;"