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.2 by lat, Wed Oct 5 07:25:42 2005 UTC vs.
Revision 1.6 by lat, Thu Oct 13 07:08:23 2005 UTC

# Line 7 | Line 7 | create sequence seq_app_config;
7   -- ======================================================================
8   create table t_collection_type
9    (id                           integer         not null,
10 <   name                         varchar (80)    not null,
10 >   name                         varchar (1000)  not null,
11     created_at                   float           not null,
12     created_by                   integer         not null,
13 <   modified_at                  float           not null,
14 <   modified_by                  integer         not null);
13 >   modified_at                  float,
14 >   modified_by                  integer);
15  
16   create table t_app_family
17    (id                           integer         not null,
18 <   name                         varchar (80)    not null,
18 >   name                         varchar (1000)  not null,
19     created_at                   float           not null,
20     created_by                   integer         not null,
21 <   modified_at                  float           not null,
22 <   modified_by                  integer         not null);
21 >   modified_at                  float,
22 >   modified_by                  integer);
23  
24   create table t_application
25    (id                           integer         not null,
26 <   executable                   varchar (80)    not null,
27 <   app_version                  varchar (80)    not null,
26 >   executable                   varchar (1000)  not null,
27 >   app_version                  varchar (1000)  not null,
28     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           not null,
34 <   modified_by                  integer         not null);
33 >   modified_at                  float,
34 >   modified_by                  integer);
35  
36   create table t_app_config
37    (id                           integer         not null,
38     application                  integer         not null,
39 <   conditions_version           varchar (80)    not null,
39 >   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           not null,
44 <   modified_by                  integer         not null);
43 >   modified_at                  float,
44 >   modified_by                  integer);
45  
46   -- ======================================================================
47   alter table t_collection_type
# Line 53 | Line 54 | alter table t_collection_type
54    unique (name);
55  
56   alter table t_collection_type
57 <  add constraint fk_collection_type_creat
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_mod
61 >  add constraint fk_collection_type_modifby
62    foreign key (modified_by) references t_person (id);
63  
64   --
# Line 71 | Line 72 | alter table t_app_family
72    unique (name);
73  
74   alter table t_app_family
75 <  add constraint fk_app_family_creat
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_mod
79 >  add constraint fk_app_family_modifby
80    foreign key (modified_by) references t_person (id);
81  
82   --
# Line 101 | Line 102 | alter table t_application
102    foreign key (output_type) references t_collection_type (id);
103  
104   alter table t_application
105 <  add constraint fk_application_creat
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_mod
109 >  add constraint fk_application_modifby
110    foreign key (modified_by) references t_person (id);
111  
112   --
# Line 116 | Line 117 | alter table t_app_config
117  
118   alter table t_app_config
119    add constraint uq_app_config
120 <  unique (application, conditions_version);
120 >  unique (application, parameter_set, conditions_version);
121  
122   alter table t_app_config
123    add constraint fk_app_config_app
124    foreign key (application) references t_application (id);
125  
126   alter table t_app_config
127 <  add constraint fk_app_config_creat
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_mod
131 >  add constraint fk_app_config_modifby
132    foreign key (modified_by) references t_person (id);
133  
134   -- ======================================================================
135 < create index ix_collection_type_creat
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_mod
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_creat
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_mod
148 > create index ix_app_family_modifby
149    on t_app_family (modified_by)
150    tablespace CMS_DBS_INDX01;
151  
# Line 157 | Line 158 | create index ix_application_outtype
158    on t_application (output_type)
159    tablespace CMS_DBS_INDX01;
160  
161 < create index ix_application_creat
161 > create index ix_application_creatby
162    on t_application (created_by)
163    tablespace CMS_DBS_INDX01;
164  
165 < create index ix_application_mod
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_creat
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_mod
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