: !/bin/sh

cd /u/catcom/database

unload -d catcom -t chargecat -f chargecat.$$
droptable -d catcom -t chargecat

su catcom -c runisql <<SQLCMD0
create table "catcom".chargecat 
  (
	chargecatid serial,
	chargecat char(32),
	importdatatypeid integer,
	carriercode char(1),
	rectype char(32),
	chargeclasstype char(32),
	globalroaming char(1)
  );

create index "catcom".i_chargecat1 on "catcom".chargecat (chargecatid);
create index "catcom".i_chargecat2 on "catcom".chargecat (carriercode, rectype, chargecat);

SQLCMD0

exit 0