: !/bin/sh

cd /u/catcom/database

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

su catcom -c runisql <<SQLCMD0
create table "catcom".dataplan 
  (
	dataplan char(25),
	chargecat char(32),
	monthlyfee money(8,2),
	centspermeg smallfloat,
	centspermin smallfloat,
	centsflagfall smallfloat,
	markup smallfloat
  );

create index "catcom".i_dataplan1 on "catcom".dataplan (dataplan);
create index "catcom".i_dataplan2 on "catcom".dataplan (dataplan, chargecat);

SQLCMD0

exit 0