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.3 by lat, Mon Oct 10 20:19:48 2005 UTC

#	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