ViewVC Help
View File | Revision Log | Show Annotations | Root Listing
root/cvsroot/COMP/DBS/Schema/RefDBLegacy/OracleApps.sql
(Generate patch)

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

# Line 1 | Line 1
1   -- ======================================================================
2 – create sequence seq_collection_type;
2   create sequence seq_app_family;
3   create sequence seq_application;
4   create sequence seq_app_config;
5  
6   -- ======================================================================
8 – create table t_collection_type
9 –  (id                           integer         not null,
10 –   name                         varchar (1000)  not null,
11 –   created_at                   float           not null,
12 –   created_by                   integer         not null,
13 –   modified_at                  float,
14 –   modified_by                  integer);
15 –
7   create table t_app_family
8    (id                           integer         not null,
9 <   name                         varchar (1000)  not null,
19 <   created_at                   float           not null,
20 <   created_by                   integer         not null,
21 <   modified_at                  float,
22 <   modified_by                  integer);
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,
29 <   input_type                   integer         not null,
30 <   output_type                  integer         not null,
31 <   created_at                   float           not null,
32 <   created_by                   integer         not null,
33 <   modified_at                  float,
34 <   modified_by                  integer);
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,  -- FIXME!
40 <   conditions_version           varchar (1000)  not null,
41 <   created_at                   float           not null,
42 <   created_by                   integer         not null,
43 <   modified_at                  float,
44 <   modified_by                  integer);
20 >   parameter_set                varchar (1000)  not null);
21  
22   -- ======================================================================
47 – alter table t_collection_type
48 –  add constraint pk_collection_type
49 –  primary key (id)
50 –  using index tablespace CMS_DBS_INDX01;
51 –
52 – alter table t_collection_type
53 –  add constraint uq_collection_type_name
54 –  unique (name);
55 –
56 – alter table t_collection_type
57 –  add constraint fk_collection_type_creatby
58 –  foreign key (created_by) references t_person (id);
59 –
60 – alter table t_collection_type
61 –  add constraint fk_collection_type_modifby
62 –  foreign key (modified_by) references t_person (id);
63 –
64 – --
23   alter table t_app_family
24    add constraint pk_app_family
25    primary key (id)
26 <  using index tablespace CMS_DBS_INDX01;
26 >  using index tablespace INDX01;
27  
28   alter table t_app_family
29    add constraint uq_app_family_name
30    unique (name);
31  
74 – alter table t_app_family
75 –  add constraint fk_app_family_creatby
76 –  foreign key (created_by) references t_person (id);
77 –
78 – alter table t_app_family
79 –  add constraint fk_app_family_modifby
80 –  foreign key (modified_by) references t_person (id);
81 –
32   --
33   alter table t_application
34    add constraint pk_application
35    primary key (id)
36 <  using index tablespace CMS_DBS_INDX01;
36 >  using index tablespace INDX01;
37  
38   alter table t_application
39    add constraint uq_application_key
# Line 93 | Line 43 | alter table t_application
43    add constraint fk_app_family
44    foreign key (app_family) references t_app_family (id);
45  
96 – alter table t_application
97 –  add constraint fk_application_intype
98 –  foreign key (input_type) references t_collection_type (id);
99 –
100 – alter table t_application
101 –  add constraint fk_application_outtype
102 –  foreign key (output_type) references t_collection_type (id);
103 –
104 – alter table t_application
105 –  add constraint fk_application_creatby
106 –  foreign key (created_by) references t_person (id);
107 –
108 – alter table t_application
109 –  add constraint fk_application_modifby
110 –  foreign key (modified_by) references t_person (id);
111 –
46   --
47   alter table t_app_config
48    add constraint pk_app_config
49    primary key (id)
50 <  using index tablespace CMS_DBS_INDX01;
50 >  using index tablespace INDX01;
51  
52   alter table t_app_config
53    add constraint uq_app_config
54 <  unique (application, parameter_set, conditions_version);
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);
125 –
126 – alter table t_app_config
127 –  add constraint fk_app_config_creatby
128 –  foreign key (created_by) references t_person (id);
129 –
130 – alter table t_app_config
131 –  add constraint fk_app_config_modifby
132 –  foreign key (modified_by) references t_person (id);
133 –
134 – -- ======================================================================
135 – create index ix_collection_type_creatby
136 –  on t_collection_type (created_by)
137 –  tablespace CMS_DBS_INDX01;
138 –
139 – create index ix_collection_type_modifby
140 –  on t_collection_type (modified_by)
141 –  tablespace CMS_DBS_INDX01;
142 –
143 – --
144 – create index ix_app_family_creatby
145 –  on t_app_family (created_by)
146 –  tablespace CMS_DBS_INDX01;
147 –
148 – create index ix_app_family_modifby
149 –  on t_app_family (modified_by)
150 –  tablespace CMS_DBS_INDX01;
151 –
152 – --
153 – create index ix_application_intype
154 –  on t_application (input_type)
155 –  tablespace CMS_DBS_INDX01;
156 –
157 – create index ix_application_outtype
158 –  on t_application (output_type)
159 –  tablespace CMS_DBS_INDX01;
160 –
161 – create index ix_application_creatby
162 –  on t_application (created_by)
163 –  tablespace CMS_DBS_INDX01;
164 –
165 – create index ix_application_modifby
166 –  on t_application (modified_by)
167 –  tablespace CMS_DBS_INDX01;
168 –
169 – --
170 – create index ix_app_config_creatby
171 –  on t_app_config (created_by)
172 –  tablespace CMS_DBS_INDX01;
173 –
174 – create index ix_app_config_modifby
175 –  on t_app_config (modified_by)
176 –  tablespace CMS_DBS_INDX01;

Diff Legend

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