ViewVC Help

View File | Revision Log | Show Annotations | Root Listing

root/cvsroot/COMP/DBS/Schema/RefDBLegacy/OracleCMS.sql

Comparing COMP/DBS/Schema/RefDBLegacy/OracleCMS.sql (file contents):
Revision 1.2 by lat, Thu Oct 6 21:41:37 2005 UTC vs.
Revision 1.4 by lat, Tue Oct 11 17:39:45 2005 UTC

#	Line 10 | Line 10 | create table t_person
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,
14	<	modified_by                  integer         not null);
13	>	modified_at                  float,
14	>	modified_by                  integer);
15
16		create table t_physics_group
17		(id                           integer         not null,
#	Line 19 | Line 19 | create table t_physics_group
19		convenor                     integer         /* not null? */,
20		created_at                   float           not null,
21		created_by                   integer         not null,
22	<	modified_at                  float           not null,
23	<	modified_by                  integer         not null);
22	>	modified_at                  float,
23	>	modified_by                  integer);
24
25		-- ======================================================================
26		alter table t_person
#	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