ViewVC Help

View File | Revision Log | Show Annotations | Root Listing

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

Comparing COMP/DBS/Schema/RefDBLegacy/OracleFiles.sql (file contents):
Revision 1.8 by lat, Fri Jan 20 16:55:06 2006 UTC vs.
Revision 1.10 by sekhri, Tue Feb 7 20:32:13 2006 UTC

#	Line 45 | Line 45 | create table t_evcoll_file
45		alter table t_block_status
46		add constraint pk_block_status
47		primary key (id)
48	<	using index tablespace CMS_DBS_INDX01;
48	>	using index tablespace INDX01;
49
50		alter table t_block_status
51		add constraint uq_block_status_key
#	Line 55 | Line 55 | alter table t_block_status
55		alter table t_block
56		add constraint pk_block
57		primary key (id)
58	<	using index tablespace CMS_DBS_INDX01;
58	>	using index tablespace INDX01;
59
60		alter table t_block
61		add constraint fk_block_status
62		foreign key (status) references t_block_status (id);
63
64	+	alter table t_block
65	+	add constraint fk_processed_dataset
66	+	foreign key (processed_dataset) references t_processed_dataset (id);
67	+
68		--
69		alter table t_file_status
70		add constraint pk_file_status
71		primary key (id)
72	<	using index tablespace CMS_DBS_INDX01;
72	>	using index tablespace INDX01;
73
74		alter table t_file_status
75		add constraint uq_file_status_key
#	Line 75 | Line 79 | alter table t_file_status
79		alter table t_file_type
80		add constraint pk_file_type
81		primary key (id)
82	<	using index tablespace CMS_DBS_INDX01;
82	>	using index tablespace INDX01;
83
84		alter table t_file_type
85		add constraint uq_file_type
#	Line 85 | Line 89 | alter table t_file_type
89		alter table t_file
90		add constraint pk_file
91		primary key (id)
92	<	using index tablespace CMS_DBS_INDX01;
92	>	using index tablespace INDX01;
93
94		alter table t_file
95		add constraint uq_file_lfn
#	Line 101 | Line 105 | alter table t_file
105
106		alter table t_file
107		add constraint fk_file_inblock
108	<	foreign key (status) references t_block (id);
108	>	foreign key (inblock) references t_block (id);
109
110		--
111		alter table t_evcoll_file
112		add constraint pk_evcoll_file
113		primary key (id)
114	<	using index tablespace CMS_DBS_INDX01;
114	>	using index tablespace INDX01;
115
116		alter table t_evcoll_file
117		add constraint uq_evcoll_file_key
#	Line 125 | Line 129 | alter table t_evcoll_file
129		-- ======================================================================
130		create index ix_block_status
131		on t_block (status)
132	<	tablespace CMS_DBS_INDX01;
132	>	tablespace INDX01;
133
134		--
135		create index ix_file_status
136		on t_file (status)
137	<	tablespace CMS_DBS_INDX01;
137	>	tablespace INDX01;
138
139		create index ix_file_type
140		on t_file (type)
141	<	tablespace CMS_DBS_INDX01;
141	>	tablespace INDX01;
142
143		create index ix_file_inblock
144		on t_file (inblock)
145	<	tablespace CMS_DBS_INDX01;
145	>	tablespace INDX01;

Diff Legend

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