Uncancel in MGMT: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| 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 | ||
* subs: status->1, stop_date->null | ** 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 | * 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";