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
#	User	Rev	Content
1	lat	1.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	lat	1.7	name varchar (1000) not null);
10	lat	1.1
11			create table t_application
12			(id integer not null,
13	lat	1.3	executable varchar (1000) not null,
14			app_version varchar (1000) not null,
15	lat	1.8	app_family integer not null);
16	lat	1.1
17			create table t_app_config
18			(id integer not null,
19			application integer not null,
20	lat	1.8	parameter_set varchar (1000) not null);
21	lat	1.1
22			-- ======================================================================
23			alter table t_app_family
24			add constraint pk_app_family
25			primary key (id)
26	afaq	1.10	using index tablespace INDX01;
27	lat	1.1
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	afaq	1.10	using index tablespace INDX01;
37	lat	1.1
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	afaq	1.10	using index tablespace INDX01;
51	lat	1.1
52			alter table t_app_config
53			add constraint uq_app_config
54	lat	1.8	unique (application, parameter_set);
55	lat	1.1
56			alter table t_app_config
57			add constraint fk_app_config_app
58			foreign key (application) references t_application (id);