Uncancel in MGMT: Difference between revisions
Jump to navigation
Jump to search
Created page with "placeholder" |
No edit summary |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
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"; | |||
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";