--- gantt.sql	2002/09/11 16:09:47	1.1
+++ gantt.sql	2002/09/13 12:38:25	1.3
@@ -3,11 +3,14 @@
 create table gantt (
 	start datetime default now(),
 	finish datetime default now(),
-	sessionid varchar(20) primary key,
+	sessionid varchar(20) not null,
 	type varchar(80) not null,
 	status varchar(80) not null,
 	user_group_host varchar(80) not null,
-	specification varchar(80) not null
+	specification varchar(80) not null,
+	device text,
+	host text,
+	primary key (sessionid,type,status)
 );
 
 create index ind_sessionid on gantt ( sessionid );
@@ -15,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 );
 
