ViewVC Help
View File | Revision Log | Show Annotations | Root Listing
root/cvsroot/COMP/DBS/Schema/RefDBLegacy/OracleCMS.sql
(Generate patch)

Comparing COMP/DBS/Schema/RefDBLegacy/OracleCMS.sql (file contents):
Revision 1.1 by lat, Tue Oct 4 21:46:23 2005 UTC vs.
Revision 1.3 by lat, Mon Oct 10 20:19:48 2005 UTC

# Line 5 | Line 5 | create sequence seq_physics_group;
5   -- ======================================================================
6   create table t_person
7    (id                           integer         not null,
8 <   name                         varchar (80)    not null,
9 <   distinguished_name           varchar (255)   not null,
10 <   contact_info                 varchar (255)   not null,
8 >   name                         varchar (1000)  not null,
9 >   distinguished_name           varchar (1000)  not null,
10 >   contact_info                 varchar (1000)  not null,
11     created_at                   float           not null,
12     created_by                   integer         not null,
13     modified_at                  float           not null,
# Line 15 | Line 15 | create table t_person
15  
16   create table t_physics_group
17    (id                           integer         not null,
18 <   name                         varchar (80)    not null,
18 >   name                         varchar (1000)  not null,
19     convenor                     integer         /* not null? */,
20     created_at                   float           not null,
21     created_by                   integer         not null,
# Line 37 | Line 37 | alter table t_person
37    unique (distinguished_name);
38  
39   alter table t_person
40 <  add constraint fk_person_creat
40 >  add constraint fk_person_creatby
41    foreign key (created_by) references t_person (id);
42  
43   alter table t_person
44 <  add constraint fk_person_mod
44 >  add constraint fk_person_modifby
45    foreign key (modified_by) references t_person (id);
46  
47   --
# Line 59 | Line 59 | alter table t_physics_group
59    foreign key (convenor) references t_person (id);
60  
61   alter table t_physics_group
62 <  add constraint fk_physicsgroup_creat
62 >  add constraint fk_physicsgroup_creatby
63    foreign key (created_by) references t_person (id);
64  
65   alter table t_physics_group
66 <  add constraint fk_physicsgroup_mod
66 >  add constraint fk_physicsgroup_modifby
67    foreign key (modified_by) references t_person (id);
68  
69   -- ======================================================================
70 < create index ix_person_creat
70 > create index ix_person_creatby
71    on t_person (created_by)
72    tablespace CMS_DBS_INDX01;
73  
74 < create index ix_person_mod
74 > create index ix_person_modifby
75    on t_person (modified_by)
76    tablespace CMS_DBS_INDX01;
77  
# Line 80 | Line 80 | create index ix_physicsgroup_convener
80    on t_physics_group (convenor)
81    tablespace CMS_DBS_INDX01;
82  
83 < create index ix_physicsgroup_creat
83 > create index ix_physicsgroup_creatby
84    on t_physics_group (created_by)
85    tablespace CMS_DBS_INDX01;
86  
87 < create index ix_physicsgroup_mod
87 > create index ix_physicsgroup_modifby
88    on t_physics_group (modified_by)
89    tablespace CMS_DBS_INDX01;

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines