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.5 by lat, Wed Oct 19 12:54:56 2005 UTC vs.
Revision 1.6 by lat, Fri Jan 20 11:53:17 2006 UTC

#	Line 1 | Line 1
1		-- ======================================================================
2		create sequence seq_person;
3	–	create sequence seq_physics_group;
3
4		-- ======================================================================
5		create table t_person
#	Line 9 | Line 8 | create table t_person
8		distinguished_name           varchar (1000)  not null,
9		contact_info                 varchar (1000)  not null);
10
12	–	create table t_physics_group
13	–	(id                           integer         not null,
14	–	name                         varchar (1000)  not null,
15	–	convenor                     integer         /* not null? */);
16	–
11		-- ======================================================================
12		alter table t_person
13		add constraint pk_person
14		primary key (id)
15	<	using index tablespace CMS_DBS_INDX01;
15	>	using index tablespace INDX01;
16
17		alter table t_person
18		add constraint uq_person_name
#	Line 27 | Line 21 | alter table t_person
21		alter table t_person
22		add constraint uq_person_distinguished
23		unique (distinguished_name);
30	–
31	–	--
32	–	alter table t_physics_group
33	–	add constraint pk_physicsgroup
34	–	primary key (id)
35	–	using index tablespace CMS_DBS_INDX01;
36	–
37	–	alter table t_physics_group
38	–	add constraint uq_physicsgroup_name
39	–	unique (name);
40	–
41	–	alter table t_physics_group
42	–	add constraint fk_physicsgroup_convener
43	–	foreign key (convenor) references t_person (id);
44	–
45	–	-- ======================================================================
46	–	create index ix_physicsgroup_convener
47	–	on t_physics_group (convenor)
48	–	tablespace CMS_DBS_INDX01;

Diff Legend

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