: !/bin/sh

cd /u/catcom/database

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

su catcom -c runisql <<SQLCOMMAND
DATABASE catcom;

create table "catcom".wbdfeature 
  (
	distid integer not null,
	feature char(32),
	value char(16)
  );

create unique index "catcom".iwbdfeature_1 on "catcom".wbdfeature (distid);

SQLCOMMAND

exit 0