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

Diff of /gantt.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by dpavlin, Wed Sep 11 20:54:24 2002 UTC revision 1.4 by dpavlin, Mon Sep 16 16:10:36 2002 UTC
# Line 8  create table gantt ( Line 8  create table gantt (
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 );
# Line 16  create index ind_type on gantt ( type ); Line 18  create index ind_type on gantt ( type );
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    

Legend:
Removed from v.1.2  
changed lines
  Added in v.1.4

  ViewVC Help
Powered by ViewVC 1.1.26