3 |
create table gantt ( |
create table gantt ( |
4 |
start datetime default now(), |
start datetime default now(), |
5 |
finish datetime default now(), |
finish datetime default now(), |
6 |
sessionid varchar(20) primary key, |
sessionid varchar(20) not null, |
7 |
type varchar(80) not null, |
type varchar(80) not null, |
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) |
12 |
); |
); |
13 |
|
|
14 |
create index ind_sessionid on gantt ( sessionid ); |
create index ind_sessionid on gantt ( sessionid ); |