: !/bin/sh

cd /u/catcom/database

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

su catcom -c runisql <<SQLCMD0
create table "catcom".sidpick 
  (
	pickid serial,
	sidmainttype char(32),
	fldrefid char(32),
	ref1 char(50),
	ref2 char(50),
	ref3 char(50)
  );

create index "catcom".isidpick_1 on "catcom".sidpick (fldrefid);
create index "catcom".isidpick_2 on "catcom".sidpick (ref1);
create index "catcom".isidpick_3 on "catcom".sidpick (ref2);
create index "catcom".isidpick_4 on "catcom".sidpick (ref3);


SQLCMD0

exit 0