Schema/RefDBLegacy/OracleRun.sql

-- ======================================================================
create sequence seq_run_quality;
create sequence seq_run;
create sequence seq_evcoll_run;

-- ======================================================================
create table t_run_quality
  (id                           integer         not null,
   name                         varchar (1000)  not null);

create table t_run
  (id                           integer         not null,
   run_number                   integer         not null,
   run_quality                  integer         not null);

create table t_evcoll_run
  (event_collection             integer         not null,
   run                          integer         not null);

-- ======================================================================
alter table t_run_quality
  add constraint pk_run_quality
  primary key (id)
  using index tablespace CMS_DBS_INDX01;

alter table t_run_quality
  add constraint uq_run_quality_name
  unique (name);

--
alter table t_run
  add constraint pk_run
  primary key (id)
  using index tablespace CMS_DBS_INDX01;

alter table t_run
  add constraint uq_run_number
  unique (run_number);

alter table t_run
  add constraint fk_run_quality
  foreign key (run_quality) references t_run_quality (id);

--
alter table t_evcoll_run
  add constraint pk_evcoll_run
  primary key (event_collection, run)
  using index tablespace CMS_DBS_INDX01;

alter table t_evcoll_run
  add constraint fk_evcoll_run_evcoll
  foreign key (event_collection) references t_event_collection (id);

alter table t_evcoll_run
  add constraint fk_evcoll_run_run
  foreign key (run) references t_run (id);
Revision:	1.2
Committed:	Wed Oct 19 12:54:56 2005 UTC (19 years, 6 months ago) by lat
Content type:	application/sql
Branch:	MAIN
CVS Tags:	before_message_removal
Changes since 1.1:	+2 -44 lines
Log Message:	Store object history in separate table. Make not-understood columns nullable, and don't fill them. Add key for event collection parentage type.
#	User	Rev	Content
1	lat	1.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	lat	1.2	name varchar (1000) not null);
10	lat	1.1
11			create table t_run
12			(id integer not null,
13			run_number integer not null,
14	lat	1.2	run_quality integer not null);
15	lat	1.1
16			create table t_evcoll_run
17			(event_collection integer not null,
18			run integer not null);
19
20			-- ======================================================================
21			alter table t_run_quality
22			add constraint pk_run_quality
23			primary key (id)
24			using index tablespace CMS_DBS_INDX01;
25
26			alter table t_run_quality
27			add constraint uq_run_quality_name
28			unique (name);
29
30			--
31			alter table t_run
32			add constraint pk_run
33			primary key (id)
34			using index tablespace CMS_DBS_INDX01;
35
36			alter table t_run
37			add constraint uq_run_number
38			unique (run_number);
39
40			alter table t_run
41			add constraint fk_run_quality
42			foreign key (run_quality) references t_run_quality (id);
43
44			--
45			alter table t_evcoll_run
46			add constraint pk_evcoll_run
47			primary key (event_collection, run)
48			using index tablespace CMS_DBS_INDX01;
49
50			alter table t_evcoll_run
51			add constraint fk_evcoll_run_evcoll
52			foreign key (event_collection) references t_event_collection (id);
53
54			alter table t_evcoll_run
55			add constraint fk_evcoll_run_run
56			foreign key (run) references t_run (id);