--- gantt.sql 2002/09/13 12:38:25 1.3 +++ gantt.sql 2002/11/18 10:51:42 1.5 @@ -10,7 +10,7 @@ specification varchar(80) not null, device text, host text, - primary key (sessionid,type,status) + primary key (sessionid,type,status,user_group_host) ); create index ind_sessionid on gantt ( sessionid ); @@ -20,4 +20,6 @@ create index ind_specification on gantt ( specification ); create index ind_device on gantt ( device ); create index ind_host on gantt ( host ); +create index ind_start on gantt ( start ); +create index ind_finish on gantt ( finish );