ViewVC Help

View File | Revision Log | Show Annotations | Root Listing

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

Comparing COMP/DBS/Schema/RefDBLegacy/OracleRun.sql (file contents):
Revision 1.1 by lat, Thu Oct 13 07:08:23 2005 UTC vs.
Revision 1.3 by lat, Fri Jan 20 11:53:17 2006 UTC

#	Line 1 | Line 0
1	–	-- ======================================================================
2	–	create sequence seq_run_quality;
3	–	create sequence seq_run;
4	–	create sequence seq_evcoll_run;
5	–
6	–	-- ======================================================================
7	–	create table t_run_quality
8	–	(id                           integer         not null,
9	–	name                         varchar (1000)  not null,
10	–	created_at                   float           not null,
11	–	created_by                   integer         not null,
12	–	modified_at                  float,
13	–	modified_by                  integer);
14	–
15	–	create table t_run
16	–	(id                           integer         not null,
17	–	run_number                   integer         not null,
18	–	run_quality                  integer         not null,
19	–	created_at                   float           not null,
20	–	created_by                   integer         not null,
21	–	modified_at                  float,
22	–	modified_by                  integer);
23	–
24	–	create table t_evcoll_run
25	–	(event_collection             integer         not null,
26	–	run                          integer         not null);
27	–
28	–	-- ======================================================================
29	–	alter table t_run_quality
30	–	add constraint pk_run_quality
31	–	primary key (id)
32	–	using index tablespace CMS_DBS_INDX01;
33	–
34	–	alter table t_run_quality
35	–	add constraint uq_run_quality_name
36	–	unique (name);
37	–
38	–	alter table t_run_quality
39	–	add constraint fk_run_quality_creatby
40	–	foreign key (created_by) references t_person (id);
41	–
42	–	alter table t_run_quality
43	–	add constraint fk_run_quality_modifby
44	–	foreign key (modified_by) references t_person (id);
45	–
46	–	--
47	–	alter table t_run
48	–	add constraint pk_run
49	–	primary key (id)
50	–	using index tablespace CMS_DBS_INDX01;
51	–
52	–	alter table t_run
53	–	add constraint uq_run_number
54	–	unique (run_number);
55	–
56	–	alter table t_run
57	–	add constraint fk_run_quality
58	–	foreign key (run_quality) references t_run_quality (id);
59	–
60	–	alter table t_run
61	–	add constraint fk_run_creatby
62	–	foreign key (created_by) references t_person (id);
63	–
64	–	alter table t_run
65	–	add constraint fk_run_modifby
66	–	foreign key (modified_by) references t_person (id);
67	–
68	–	--
69	–	alter table t_evcoll_run
70	–	add constraint pk_evcoll_run
71	–	primary key (event_collection, run)
72	–	using index tablespace CMS_DBS_INDX01;
73	–
74	–	alter table t_evcoll_run
75	–	add constraint fk_evcoll_run_evcoll
76	–	foreign key (event_collection) references t_event_collection (id);
77	–
78	–	alter table t_evcoll_run
79	–	add constraint fk_evcoll_run_run
80	–	foreign key (run) references t_run (id);
81	–
82	–	-- ======================================================================
83	–	create index ix_run_quality_creatby
84	–	on t_run_quality (created_by)
85	–	tablespace CMS_DBS_INDX01;
86	–
87	–	create index ix_run_quality_modifby
88	–	on t_run_quality (modified_by)
89	–	tablespace CMS_DBS_INDX01;
90	–
91	–	--
92	–	create index ix_run_creatby
93	–	on t_run (created_by)
94	–	tablespace CMS_DBS_INDX01;
95	–
96	–	create index ix_run_modifby
97	–	on t_run (modified_by)
98	–	tablespace CMS_DBS_INDX01;

Diff Legend

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