Uncancel in MGMT: Difference between revisions

From JCWiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 2: Line 2:


* customers: status->1
* customers: status->1
** update customers set status="1" where cid="col02001";
* ipmap: (for each ip) relen_date->null, status->1
* 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
* 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
* 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";

Latest revision as of 19:20, 2 April 2013

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";