Uncancel in MGMT

From JCWiki
Jump to navigation Jump to search

this is a manual database update to the following tables: fields

  • customers: status->1
    • update customers set status="1" where cid="col02001";
  • ipmap: (for each ip) relen_date->null, status->1
    • update ipmap set status="1", relen_date="null" where ip="69.55.229.82";
  • subs: (for last/current sub(s)) status->1, stop_date->null
    • select * from subs where sysid="5162";
    • update subs set status="1", stop_date="null" where subid="6350";
  • systems: status->1, stop_date->null, cancel_date->null
    • select * from systems where sysid="5162";
    • update systems set status="1", stop_date="null", cancel_date="null" where sysid="5162";