: !/bin/sh

cd /u/catcom/database

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

su catcom -c runisql <<SQLCMD0
create table "catcom".sidconf 
  (
	RecordNo serial,
	sid char(32) not null,
	sidmainttype char(32),
	sdate date not null,
	edate date,

	grid char(8),
	directoryid integer,

	serialnumber char(32),
	purchased date,
	manufacturer char(32),
	model char(32),
	supplier char(32),
	datatype char(32),
	carriercode char(32),
	servicetype char(32),

	intfld1 integer,
	intfld2 integer,
	intfld3 integer,
	intfld4 integer,
	intfld5 integer,
	intfld6 integer,
	intfld7 integer,
	intfld8 integer,
	intfld9 integer,

	floatfld1 float,
	floatfld2 float,
	floatfld3 float,
	floatfld4 float,
	floatfld5 float,
	floatfld6 float,
	floatfld7 float,
	floatfld8 float,
	floatfld9 float,

	datefld1 date,
	datefld2 date,
	datefld3 date,
	datefld4 date,
	datefld5 date,
	datefld6 date,
	datefld7 date,
	datefld8 date,
	datefld9 date,

	costfld1 MONEY(10,2),
	costfld2 MONEY(10,2),
	costfld3 MONEY(10,2),
	costfld4 MONEY(10,2),
	costfld5 MONEY(10,2),
	costfld6 MONEY(10,2),
	costfld7 MONEY(10,2),
	costfld8 MONEY(10,2),
	costfld9 MONEY(10,2),

	genfld1 char(50),
	genfld2 char(50),
	genfld3 char(50),
	genfld4 char(50),
	genfld5 char(50),
	genfld6 char(50),
	genfld7 char(50),
	genfld8 char(50),
	genfld9 char(50),

	dateupdated date not null,

	msg1 char(132),
	msg2 char(132),
	msg3 char(132),
	msg4 char(132),
	msg5 char(132),
	msg6 char(132),
	msg7 char(132),
	msg8 char(132),
	msg9 char(132)
  );

create index "catcom".isidconf_1 on "catcom".sidconf (sid);
create index "catcom".isidconf_2 on "catcom".sidconf (sdate);
create index "catcom".isidconf_3 on "catcom".sidconf (edate);
create index "catcom".isidconf_4 on "catcom".sidconf (dateupdated);


SQLCMD0

exit 0