: !/bin/sh

cd /u/catcom/database

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

su catcom -c runisql <<SQLCMD0
create table "catcom".wbuserlog 
  (
	dtstamp datetime year to second not null,
	userid char(50) not null,
	remote_addr char(15) not null,
	failed smallint not null,
	disabled smallint not null,
	on_off smallint not null,
	pwchange smallint not null
  );

create index "catcom".iwbuserlog_1 on "catcom".wbuserlog (dtstamp);
create index "catcom".iwbuserlog_2 on "catcom".wbuserlog (userid);
create index "catcom".iwbuserlog_3 on "catcom".wbuserlog (remote_addr);
create index "catcom".iwbuserlog_4 on "catcom".wbuserlog (failed);
create index "catcom".iwbuserlog_5 on "catcom".wbuserlog (disabled);
create index "catcom".iwbuserlog_6 on "catcom".wbuserlog (on_off);
create index "catcom".iwbuserlog_7 on "catcom".wbuserlog (pwchange);


SQLCMD0

exit 0