/[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.1 by dpavlin, Wed Sep 11 16:09:47 2002 UTC revision 1.2 by dpavlin, Wed Sep 11 20:54:24 2002 UTC
# Line 3  drop table gantt; Line 3  drop table gantt;
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 );

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

  ViewVC Help
Powered by ViewVC 1.1.26