: !/bin/sh

cd /u/catcom/database

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

su catcom -c runisql <<SQLCMD0
create table "catcom".importdatatype 
  (
	importdatatypeid serial,
	importdatatypedesc char(32),
	datafileext char(20),
	serviceproviderdir char(32),
	sidmainttype char(32),
	email char(150),
	servicetypeID integer
  );

create index "catcom".i_importdatatype1 on "catcom".importdatatype (importdatatypeid);
create index "catcom".i_importdatatype2 on "catcom".importdatatype (importdatatypedesc);

SQLCMD0

exit 0