ViewVC Help

View File | Revision Log | Show Annotations | Root Listing

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

Comparing COMP/DBS/Schema/RefDBLegacy/OracleApps.sql (file contents):
Revision 1.3 by lat, Thu Oct 6 21:41:37 2005 UTC vs.
Revision 1.4 by lat, Mon Oct 10 20:19:48 2005 UTC

#	Line 53 | Line 53 | alter table t_collection_type
53		unique (name);
54
55		alter table t_collection_type
56	<	add constraint fk_collection_type_creat
56	>	add constraint fk_collection_type_creatby
57		foreign key (created_by) references t_person (id);
58
59		alter table t_collection_type
60	<	add constraint fk_collection_type_mod
60	>	add constraint fk_collection_type_modifby
61		foreign key (modified_by) references t_person (id);
62
63		--
#	Line 71 | Line 71 | alter table t_app_family
71		unique (name);
72
73		alter table t_app_family
74	<	add constraint fk_app_family_creat
74	>	add constraint fk_app_family_creatby
75		foreign key (created_by) references t_person (id);
76
77		alter table t_app_family
78	<	add constraint fk_app_family_mod
78	>	add constraint fk_app_family_modifby
79		foreign key (modified_by) references t_person (id);
80
81		--
#	Line 101 | Line 101 | alter table t_application
101		foreign key (output_type) references t_collection_type (id);
102
103		alter table t_application
104	<	add constraint fk_application_creat
104	>	add constraint fk_application_creatby
105		foreign key (created_by) references t_person (id);
106
107		alter table t_application
108	<	add constraint fk_application_mod
108	>	add constraint fk_application_modifby
109		foreign key (modified_by) references t_person (id);
110
111		--
#	Line 123 | Line 123 | alter table t_app_config
123		foreign key (application) references t_application (id);
124
125		alter table t_app_config
126	<	add constraint fk_app_config_creat
126	>	add constraint fk_app_config_creatby
127		foreign key (created_by) references t_person (id);
128
129		alter table t_app_config
130	<	add constraint fk_app_config_mod
130	>	add constraint fk_app_config_modifby
131		foreign key (modified_by) references t_person (id);
132
133		-- ======================================================================
134	<	create index ix_collection_type_creat
134	>	create index ix_collection_type_creatby
135		on t_collection_type (created_by)
136		tablespace CMS_DBS_INDX01;
137
138	<	create index ix_collection_type_mod
138	>	create index ix_collection_type_modifby
139		on t_collection_type (modified_by)
140		tablespace CMS_DBS_INDX01;
141
142		--
143	<	create index ix_app_family_creat
143	>	create index ix_app_family_creatby
144		on t_app_family (created_by)
145		tablespace CMS_DBS_INDX01;
146
147	<	create index ix_app_family_mod
147	>	create index ix_app_family_modifby
148		on t_app_family (modified_by)
149		tablespace CMS_DBS_INDX01;
150
#	Line 157 | Line 157 | create index ix_application_outtype
157		on t_application (output_type)
158		tablespace CMS_DBS_INDX01;
159
160	<	create index ix_application_creat
160	>	create index ix_application_creatby
161		on t_application (created_by)
162		tablespace CMS_DBS_INDX01;
163
164	<	create index ix_application_mod
164	>	create index ix_application_modifby
165		on t_application (modified_by)
166		tablespace CMS_DBS_INDX01;
167
168		--
169	<	create index ix_app_config_creat
169	>	create index ix_app_config_creatby
170		on t_app_config (created_by)
171		tablespace CMS_DBS_INDX01;
172
173	<	create index ix_app_config_mod
173	>	create index ix_app_config_modifby
174		on t_app_config (modified_by)
175		tablespace CMS_DBS_INDX01;

Diff Legend

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