8 |
status varchar(80) not null, |
status varchar(80) not null, |
9 |
user_group_host varchar(80) not null, |
user_group_host varchar(80) not null, |
10 |
specification varchar(80) not null, |
specification varchar(80) not null, |
11 |
primary key (sessionid,type,status) |
device text, |
12 |
|
host text, |
13 |
|
primary key (sessionid,type,status,user_group_host) |
14 |
); |
); |
15 |
|
|
16 |
create index ind_sessionid on gantt ( sessionid ); |
create index ind_sessionid on gantt ( sessionid ); |
18 |
create index ind_status on gantt ( status ); |
create index ind_status on gantt ( status ); |
19 |
create index ind_user on gantt ( user_group_host ); |
create index ind_user on gantt ( user_group_host ); |
20 |
create index ind_specification on gantt ( specification ); |
create index ind_specification on gantt ( specification ); |
21 |
|
create index ind_device on gantt ( device ); |
22 |
|
create index ind_host on gantt ( host ); |
23 |
|
create index ind_start on gantt ( start ); |
24 |
|
create index ind_finish on gantt ( finish ); |
25 |
|
|