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.1 by lat, Tue Oct 4 21:46:23 2005 UTC vs.
Revision 1.7 by lat, Wed Oct 19 12:54:56 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,
11 <   created_at                   float           not null,
12 <   created_by                   integer         not null,
13 <   modified_at                  float           not null,
14 <   modified_by                  integer         not null);
10 >   name                         varchar (1000)  not null);
11  
12   create table t_app_family
13    (id                           integer         not null,
14 <   name                         varchar (80)    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);
14 >   name                         varchar (1000)  not null);
15  
16   create table t_application
17    (id                           integer         not null,
18 <   executable                   varchar (80)    not null,
19 <   app_version                  varchar (80)    not null,
18 >   executable                   varchar (1000)  not null,
19 >   app_version                  varchar (1000)  not null,
20     app_family                   integer         not null,
21 <   input_type                   integer         not null,
22 <   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);
21 >   input_type                   integer         /* not null */,
22 >   output_type                  integer         /* not null */);
23  
24   create table t_app_config
25    (id                           integer         not null,
26     application                  integer         not null,
27 <   conditions_version           varchar (80)    not null,
28 <   created_at                   float           not null,
41 <   created_by                   integer         not null,
42 <   modified_at                  float           not null,
43 <   modified_by                  integer         not null);
27 >   parameter_set                varchar (1000)  not null,  -- FIXME!
28 >   conditions_version           varchar (1000)  /* not null */);
29  
30   -- ======================================================================
31   alter table t_collection_type
# Line 52 | Line 37 | alter table t_collection_type
37    add constraint uq_collection_type_name
38    unique (name);
39  
55 – alter table t_collection_type
56 –  add constraint fk_collection_type_creat
57 –  foreign key (created_by) references t_person (id);
58 –
59 – alter table t_collection_type
60 –  add constraint fk_collection_type_mod
61 –  foreign key (modified_by) references t_person (id);
62 –
40   --
41   alter table t_app_family
42    add constraint pk_app_family
# Line 70 | Line 47 | alter table t_app_family
47    add constraint uq_app_family_name
48    unique (name);
49  
73 – alter table t_app_family
74 –  add constraint fk_app_family_creat
75 –  foreign key (created_by) references t_person (id);
76 –
77 – alter table t_app_family
78 –  add constraint fk_app_family_mod
79 –  foreign key (modified_by) references t_person (id);
80 –  
50   --
51   alter table t_application
52    add constraint pk_application
# Line 100 | Line 69 | alter table t_application
69    add constraint fk_application_outtype
70    foreign key (output_type) references t_collection_type (id);
71  
103 – alter table t_application
104 –  add constraint fk_application_creat
105 –  foreign key (created_by) references t_person (id);
106 –
107 – alter table t_application
108 –  add constraint fk_application_mod
109 –  foreign key (modified_by) references t_person (id);
110 –  
72   --
73   alter table t_app_config
74    add constraint pk_app_config
# Line 116 | Line 77 | alter table t_app_config
77  
78   alter table t_app_config
79    add constraint uq_app_config
80 <  unique (application, conditions_version);
80 >  unique (application, parameter_set, conditions_version);
81  
82   alter table t_app_config
83    add constraint fk_app_config_app
84    foreign key (application) references t_application (id);
85  
125 – alter table t_app_config
126 –  add constraint fk_app_config_creat
127 –  foreign key (created_by) references t_person (id);
128 –
129 – alter table t_app_config
130 –  add constraint fk_app_config_mod
131 –  foreign key (modified_by) references t_person (id);
132 –
86   -- ======================================================================
134 – create index ix_collection_type_creat
135 –  on t_collection_type (created_by)
136 –  tablespace CMS_DBS_INDX01;
137 –
138 – create index ix_collection_type_mod
139 –  on t_collection_type (modified_by)
140 –  tablespace CMS_DBS_INDX01;
141 –
142 – --
143 – create index ix_app_family_creat
144 –  on t_app_family (created_by)
145 –  tablespace CMS_DBS_INDX01;
146 –
147 – create index ix_app_family_mod
148 –  on t_app_family (modified_by)
149 –  tablespace CMS_DBS_INDX01;
150 –
151 – --
87   create index ix_application_intype
88    on t_application (input_type)
89    tablespace CMS_DBS_INDX01;
# Line 156 | Line 91 | create index ix_application_intype
91   create index ix_application_outtype
92    on t_application (output_type)
93    tablespace CMS_DBS_INDX01;
159 –
160 – create index ix_application_creat
161 –  on t_application (created_by)
162 –  tablespace CMS_DBS_INDX01;
163 –
164 – create index ix_application_mod
165 –  on t_application (modified_by)
166 –  tablespace CMS_DBS_INDX01;
167 –
168 – --
169 – create index ix_app_config_creat
170 –  on t_app_config (created_by)
171 –  tablespace CMS_DBS_INDX01;
172 –
173 – create index ix_app_config_mod
174 –  on t_app_config (modified_by)
175 –  tablespace CMS_DBS_INDX01;

Diff Legend

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