1 |
dpavlin |
1.1 |
drop table gantt; |
2 |
|
|
|
3 |
|
|
create table gantt ( |
4 |
|
|
start datetime default now(), |
5 |
|
|
finish datetime default now(), |
6 |
|
|
sessionid varchar(20) primary key, |
7 |
|
|
type varchar(80) not null, |
8 |
|
|
status varchar(80) not null, |
9 |
|
|
user_group_host varchar(80) not null, |
10 |
|
|
specification varchar(80) not null |
11 |
|
|
); |
12 |
|
|
|
13 |
|
|
create index ind_sessionid on gantt ( sessionid ); |
14 |
|
|
create index ind_type on gantt ( type ); |
15 |
|
|
create index ind_status on gantt ( status ); |
16 |
|
|
create index ind_user on gantt ( user_group_host ); |
17 |
|
|
create index ind_specification on gantt ( specification ); |
18 |
|
|
|