billmax documentation   BillMax Billing Solutions
  877.245.5629
  sales@billmax.com
 
alterdb
Prev  BillMax Executables  Next

Name

alterdb — Modify/Create a BillMax database

Synopsis

/usr/local/billmax/bin/alterdb [-h] [-c] [-d] [-u database] [-t table [-q] ] [-s] [-v] [file]

DESCRIPTION

alterdb creates a new database based on a database schema or modifies an existing database to conform to a database schema. alterdb will always modify the indices of a table to match those in the database schema.

OPTIONS

-h

Show help for this program.

-c

Capture the database schema of the specified database and write the resulting schema to file in the form similar to /usr/local/billmax/cfg/dbschema. file may then be used as input to create a copy of the database schema in another database.

-u database

Specify the database to create, modify or examine. If this parameter is not specified, then the database specified in /usr/local/billmax/local/billmax.conf is used.

-t table

Create the database table table based on information in file.

-q

Create a table using a generated unique name. The name is derived from table specified with the -t. The unique tablename is printed to stdout.

-v

Prints the database commands that are executed.

-s

Run in safe mode. Print the database commands that would be executed.

-d

The following actions are taken:

  1. Delete tables in the database that are not in file.

  2. Delete fields from tables in the database that are not in file.

file

The name of the database schema file. The default is /usr/local/billmax/cfg/dbschema.

RETURN VALUE

0 for success.

NOTES

NONE

SEE ALSO

/usr/local/billmax/cfg/dbschema

Prev  Up  Next
BillMax Executables  Home  archivetable
Document Revision A for BillMax 2.2.0   -   Copyright © 1997-2006 The iSpark Group, Inc.

All rights reserved. No part of this documentation may be reproduced or transmitted in any fashion without written permission by The iSpark Group, Inc. This documentation is for the sole use of licensees of the BillMax billing software created by The iSpark Group, Inc. Making the documentation available to a non-licensee of BillMax without written permission of The iSpark Group, Inc. is a violation of the use of this documentation.

While precautions have been taken in the preparation of this documentation, The iSpark Group, Inc. assumes neither liability nor responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

All terms mentioned that are known to be trademarks have been appropriately capitalized. Use of the a trademark does not affect the validity of any trademark or service mark.

Links to third-party Web sites are provided for convenience. The iSpark Group, Inc. is not responsible for any content contained in the third-party Web sites.

Comments about this documentation may be sent to doc@billmax.com