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.5 by lat, Tue Oct 11 17:39:45 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 >   conditions_version           varchar (1000)  not null,
40     created_at                   float           not null,
41     created_by                   integer         not null,
42 <   modified_at                  float           not null,
43 <   modified_by                  integer         not null);
42 >   modified_at                  float,
43 >   modified_by                  integer);
44  
45   -- ======================================================================
46   alter table t_collection_type
# Line 53 | Line 53 | alter table t_collection_type
53    unique (name);
54  
55   alter table t_collection_type
56 <  add constraint fk_collection_type_creat
56 >  add constraint fk_collection_type_creatby
57    foreign key (created_by) references t_person (id);
58  
59   alter table t_collection_type
60 <  add constraint fk_collection_type_mod
60 >  add constraint fk_collection_type_modifby
61    foreign key (modified_by) references t_person (id);
62  
63   --
# Line 71 | Line 71 | alter table t_app_family
71    unique (name);
72  
73   alter table t_app_family
74 <  add constraint fk_app_family_creat
74 >  add constraint fk_app_family_creatby
75    foreign key (created_by) references t_person (id);
76  
77   alter table t_app_family
78 <  add constraint fk_app_family_mod
78 >  add constraint fk_app_family_modifby
79    foreign key (modified_by) references t_person (id);
80 <  
80 >
81   --
82   alter table t_application
83    add constraint pk_application
# Line 101 | Line 101 | alter table t_application
101    foreign key (output_type) references t_collection_type (id);
102  
103   alter table t_application
104 <  add constraint fk_application_creat
104 >  add constraint fk_application_creatby
105    foreign key (created_by) references t_person (id);
106  
107   alter table t_application
108 <  add constraint fk_application_mod
108 >  add constraint fk_application_modifby
109    foreign key (modified_by) references t_person (id);
110 <  
110 >
111   --
112   alter table t_app_config
113    add constraint pk_app_config
# Line 123 | Line 123 | alter table t_app_config
123    foreign key (application) references t_application (id);
124  
125   alter table t_app_config
126 <  add constraint fk_app_config_creat
126 >  add constraint fk_app_config_creatby
127    foreign key (created_by) references t_person (id);
128  
129   alter table t_app_config
130 <  add constraint fk_app_config_mod
130 >  add constraint fk_app_config_modifby
131    foreign key (modified_by) references t_person (id);
132  
133   -- ======================================================================
134 < create index ix_collection_type_creat
134 > create index ix_collection_type_creatby
135    on t_collection_type (created_by)
136    tablespace CMS_DBS_INDX01;
137  
138 < create index ix_collection_type_mod
138 > create index ix_collection_type_modifby
139    on t_collection_type (modified_by)
140    tablespace CMS_DBS_INDX01;
141  
142   --
143 < create index ix_app_family_creat
143 > create index ix_app_family_creatby
144    on t_app_family (created_by)
145    tablespace CMS_DBS_INDX01;
146  
147 < create index ix_app_family_mod
147 > create index ix_app_family_modifby
148    on t_app_family (modified_by)
149    tablespace CMS_DBS_INDX01;
150  
# Line 157 | Line 157 | create index ix_application_outtype
157    on t_application (output_type)
158    tablespace CMS_DBS_INDX01;
159  
160 < create index ix_application_creat
160 > create index ix_application_creatby
161    on t_application (created_by)
162    tablespace CMS_DBS_INDX01;
163  
164 < create index ix_application_mod
164 > create index ix_application_modifby
165    on t_application (modified_by)
166    tablespace CMS_DBS_INDX01;
167  
168   --
169 < create index ix_app_config_creat
169 > create index ix_app_config_creatby
170    on t_app_config (created_by)
171    tablespace CMS_DBS_INDX01;
172  
173 < create index ix_app_config_mod
173 > create index ix_app_config_modifby
174    on t_app_config (modified_by)
175    tablespace CMS_DBS_INDX01;

Diff Legend

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