ViewVC Help

View File | Revision Log | Show Annotations | Root Listing

root/cvsroot/COMP/DBS/Schema/RefDBLegacy/OracleApps.sql

Comparing COMP/DBS/Schema/RefDBLegacy/OracleApps.sql (file contents):
Revision 1.5 by lat, Tue Oct 11 17:39:45 2005 UTC vs.
Revision 1.6 by lat, Thu Oct 13 07:08:23 2005 UTC

#	Line 36 | Line 36 | create table t_application
36		create table t_app_config
37		(id                           integer         not null,
38		application                  integer         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,
#	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

Diff Legend

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