: !/bin/sh

cd /u/catcom/database

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

su catcom -c runisql <<SQLCOMMAND
DATABASE catcom;

create table "catcom".wbdcreate 
  (
	distid integer not null,
	createfrom char(8),
	created char(8),
	createddate date,
	completeddate date
  );

create unique index "catcom".iwbdcreate_1 on "catcom".wbdcreate (distid);

SQLCOMMAND

exit 0