/[omni_gantt]/gantt.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Annotation of /gantt.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.3 - (hide annotations)
Fri Sep 13 12:38:25 2002 UTC (21 years, 6 months ago) by dpavlin
Branch: MAIN
Changes since 1.2: +4 -0 lines
added device, host and cache-ing of those results.

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

  ViewVC Help
Powered by ViewVC 1.1.26