: !/bin/sh

cd /u/catcom/database

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

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

#	dialxx char(1),
#	status1 char(1),
#	print char(1),
#	cdgroup char(8),

su catcom -c runisql <<SQLCOMMAND
DATABASE catcom;

create table "catcom".wbdconf 
  (
	recordno integer not null,
	distid serial not null,
	distiddesc char(40) not null,
	lastdist char(8),
	lastdistdate date,

	altemail char(50),
	altemailyn char(1),

	wbd_method char(15) not null,
	wbd_type char(15) not null,
	userid char(25),
	passwd char(132),

	sdate date not null,
	edate date
  );

create index "catcom".iwbdconf_1 on "catcom".wbdconf (recordno);
create index "catcom".iwbdconf_2 on "catcom".wbdconf (distid);


create table "catcom".wbdlist 
  (
	distid integer not null,
	grid char(20) not null
  );

create index "catcom".iwbdlist_1 on "catcom".wbdlist (distid);
create index "catcom".iwbdlist_2 on "catcom".wbdlist (grid);

SQLCOMMAND

exit 0