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.7 by lat, Fri Jan 20 11:53:17 2006 UTC vs.
Revision 1.10 by sekhri, Tue Feb 7 20:32:13 2006 UTC

#	Line 61 | Line 61 | 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
#	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

Diff Legend

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