/[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

Contents of /gantt.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.5 - (show annotations)
Mon Nov 18 10:51:42 2002 UTC (21 years, 4 months ago) by dpavlin
Branch: MAIN
CVS Tags: HEAD
Changes since 1.4: +2 -0 lines
make SQL query use indexes

1 drop table gantt;
2
3 create table gantt (
4 start datetime default now(),
5 finish datetime default now(),
6 sessionid varchar(20) not null,
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 device text,
12 host text,
13 primary key (sessionid,type,status,user_group_host)
14 );
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 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

  ViewVC Help
Powered by ViewVC 1.1.26