--- gantt.sql 2002/09/11 20:54:24 1.2 +++ gantt.sql 2002/09/13 12:38:25 1.3 @@ -8,6 +8,8 @@ status varchar(80) not null, user_group_host varchar(80) not null, specification varchar(80) not null, + device text, + host text, primary key (sessionid,type,status) ); @@ -16,4 +18,6 @@ create index ind_status on gantt ( status ); create index ind_user on gantt ( user_group_host ); create index ind_specification on gantt ( specification ); +create index ind_device on gantt ( device ); +create index ind_host on gantt ( host );