: !/bin/sh

#cd /u/catcom/database
unload -d catcom -t exwebconf -f exwebconf.$$
droptable -d catcom -t exwebconf

su catcom -c runisql <<SQLCOMMAND
DATABASE catcom;

create table "catcom".exwebconf 
  (
    parent char(8) not null,
    dialxx char(1) not null,
    email char(200),
    emailyn char(1) not null,
    status1 char(1),
    lastemailed char(8),
    lastemaileddate date,
    print char(1),
    cdgroup char(8)
  );

create unique index "catcom".iexwebconf_1 on "catcom".exwebconf (parent);

SQLCOMMAND

exit 0