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.6 by lat, Thu Oct 27 16:57:38 2005 UTC vs.
Revision 1.7 by lat, Fri Jan 20 11:53:17 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
#	Line 65 | Line 65 | alter table t_block
65		alter table t_file_status
66		add constraint pk_file_status
67		primary key (id)
68	<	using index tablespace CMS_DBS_INDX01;
68	>	using index tablespace INDX01;
69
70		alter table t_file_status
71		add constraint uq_file_status_key
#	Line 75 | Line 75 | alter table t_file_status
75		alter table t_file_type
76		add constraint pk_file_type
77		primary key (id)
78	<	using index tablespace CMS_DBS_INDX01;
78	>	using index tablespace INDX01;
79
80		alter table t_file_type
81		add constraint uq_file_type
#	Line 85 | Line 85 | alter table t_file_type
85		alter table t_file
86		add constraint pk_file
87		primary key (id)
88	<	using index tablespace CMS_DBS_INDX01;
88	>	using index tablespace INDX01;
89
90		alter table t_file
91		add constraint uq_file_lfn
#	Line 107 | Line 107 | alter table t_file
107		alter table t_evcoll_file
108		add constraint pk_evcoll_file
109		primary key (id)
110	<	using index tablespace CMS_DBS_INDX01;
110	>	using index tablespace INDX01;
111
112		alter table t_evcoll_file
113		add constraint uq_evcoll_file_key
#	Line 125 | Line 125 | alter table t_evcoll_file
125		-- ======================================================================
126		create index ix_block_status
127		on t_block (status)
128	<	tablespace CMS_DBS_INDX01;
128	>	tablespace INDX01;
129
130		--
131		create index ix_file_status
132		on t_file (status)
133	<	tablespace CMS_DBS_INDX01;
133	>	tablespace INDX01;
134
135		create index ix_file_type
136		on t_file (type)
137	<	tablespace CMS_DBS_INDX01;
137	>	tablespace INDX01;
138
139		create index ix_file_inblock
140		on t_file (inblock)
141	<	tablespace CMS_DBS_INDX01;
141	>	tablespace INDX01;

Diff Legend

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