Schema/RefDBLegacy/OracleApps.sql

-- ======================================================================
create sequence seq_app_family;
create sequence seq_application;
create sequence seq_app_config;

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

create table t_application
  (id                           integer         not null,
   executable                   varchar (1000)  not null,
   app_version                  varchar (1000)  not null,
   app_family                   integer         not null);

create table t_app_config
  (id                           integer         not null,
   application                  integer         not null,
   parameter_set                varchar (1000)  not null);

-- ======================================================================
alter table t_app_family
  add constraint pk_app_family
  primary key (id)
  using index tablespace INDX01;

alter table t_app_family
  add constraint uq_app_family_name
  unique (name);

--
alter table t_application
  add constraint pk_application
  primary key (id)
  using index tablespace INDX01;

alter table t_application
  add constraint uq_application_key
  unique (executable, app_version, app_family);

alter table t_application
  add constraint fk_app_family
  foreign key (app_family) references t_app_family (id);

--
alter table t_app_config
  add constraint pk_app_config
  primary key (id)
  using index tablespace INDX01;

alter table t_app_config
  add constraint uq_app_config
  unique (application, parameter_set);

alter table t_app_config
  add constraint fk_app_config_app
  foreign key (application) references t_application (id);
Revision:	1.10
Committed:	Mon Feb 6 23:18:54 2006 UTC (19 years, 2 months ago) by afaq
Content type:	application/sql
Branch:	MAIN
CVS Tags:	DBS_1_0_0_pre6, DBS_1_0_0_pre5, pre5_v01_00_00, pre4_v01_00_00, pre3_v01_00_00, pre2_v01_00_00, pre_v01_00_00, v00_00_14, v00_00_13, v00_00_12, v00_00_11, v00_00_10, v00_00_09, v00_00_08, v00_00_07, v00_00_06, v00_00_05, v00_00_004, DBS_0_0_3a, DBS_0_0_3, DBS_0_0_2, DBS_0_0_1, pre_DBS_0_0_1, post_dict_type_checking_merge, post_MiniPythonAPI_merged_to_trunk, pre_MiniPythonAPI_merge_to_trunk, DBS_0_0_0, vs20060320, AfterJan2006SchemaChanges_v01_00_01, AfterJan2006SchemaChanges_v01_00_00, AfterJan2006SchemaChanges, HEAD
Branch point for:	BranchForCPPWebServiceTesting
Changes since 1.9:	+3 -3 lines
Log Message:	Non working set, Checking IN for securing the changes, will resume working
#	Content
1	-- ======================================================================
2	create sequence seq_app_family;
3	create sequence seq_application;
4	create sequence seq_app_config;
5
6	-- ======================================================================
7	create table t_app_family
8	(id integer not null,
9	name varchar (1000) not null);
10
11	create table t_application
12	(id integer not null,
13	executable varchar (1000) not null,
14	app_version varchar (1000) not null,
15	app_family integer not null);
16
17	create table t_app_config
18	(id integer not null,
19	application integer not null,
20	parameter_set varchar (1000) not null);
21
22	-- ======================================================================
23	alter table t_app_family
24	add constraint pk_app_family
25	primary key (id)
26	using index tablespace INDX01;
27
28	alter table t_app_family
29	add constraint uq_app_family_name
30	unique (name);
31
32	--
33	alter table t_application
34	add constraint pk_application
35	primary key (id)
36	using index tablespace INDX01;
37
38	alter table t_application
39	add constraint uq_application_key
40	unique (executable, app_version, app_family);
41
42	alter table t_application
43	add constraint fk_app_family
44	foreign key (app_family) references t_app_family (id);
45
46	--
47	alter table t_app_config
48	add constraint pk_app_config
49	primary key (id)
50	using index tablespace INDX01;
51
52	alter table t_app_config
53	add constraint uq_app_config
54	unique (application, parameter_set);
55
56	alter table t_app_config
57	add constraint fk_app_config_app
58	foreign key (application) references t_application (id);