BillMax questions -- SQL Question About BillMax 2.0.4 - Deleting Users & Services

["Brian Wallace" <brianw@cwo.com>]

Hi,

We've recently upgraded from 1.5.4 to 2.0.4. Everything seems to be
working fine. My boss wants me to clean up a lot of the old data. We
have a ton of old users and services which are cancelled. The first type
of user and service I need to delete is an email account that we never
charged for.

Do to how we had to import the data from our old billing system we have
1000's of cancelled users whose first name is listed as 'mailbox'.

My first question is this: Will the following SQL command delete all
closed users whose firstname is 'mailbox' and any services associated
with those users?

delete from users, services where (user.state=1 and user.fname='mailbox'
and user.number = services.user)

Next question: Is this all I need to do to delete these users and
services, or am I missing something? These were always free services,
but do I need to delete anything from the payhist table as well.

Thanks for your time and have a great day!

Brian Wallace
Coastal Web Online




-----------------------------------------------------------------------------
To unsubscribe from the "BillMax Questions" mailing list, please
send a message to "majordomo@billmax.com" with "unsubscribe questions"
in the message body. The message must be sent from the exact email
address on the list.