--- gantt.sql	2002/09/11 20:54:24	1.2
+++ gantt.sql	2002/11/18 10:51:42	1.5
@@ -8,7 +8,9 @@
 	status varchar(80) not null,
 	user_group_host varchar(80) not null,
 	specification varchar(80) not null,
-	primary key (sessionid,type,status)
+	device text,
+	host text,
+	primary key (sessionid,type,status,user_group_host)
 );
 
 create index ind_sessionid on gantt ( sessionid );
@@ -16,4 +18,8 @@
 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 );
+create index ind_start on gantt ( start );
+create index ind_finish on gantt ( finish );