create table "catcom".trk_extsum ( siteid smallint not null, inouttype char(1) not null, inoutno integer not null, grid char(8), sumdate date not null, exceptionrec char(1) not null, calltype char(1) not null, shortconnect smallint not null, duration integer not null, callcount smallint not null, meterpulses smallint not null, callcost money(10,2) not null ); --#create unique index "catcom".i_trk_extsum on "catcom".trk_extsum (sumdate,siteid,inoutno,inouttype,calltype); --#create index "catcom".i_2_trk_extsum on "catcom".trk_extsum (sumdate,siteid,grid); --#create index "catcom".i_3_trk_extsum on "catcom".trk_extsum (sumdate);