Forum OpenACS Development: Scope & Timeline

[28/Sep/2000:23:06:23][8795.4101][-conn0-] Notice: No errors.

[28/Sep/2000:23:06:24][8795.4101][-conn0-] Notice: 	check (min_n_values <= max_n_values)

[28/Sep/2000:23:06:24][8795.4101][-conn0-] Notice: 	                       *

[28/Sep/2000:23:06:24][8795.4101][-conn0-] Notice: ERROR at line 26:

[28/Sep/2000:23:06:24][8795.4101][-conn0-] Notice: ORA-01450: maximum key length (1578) exceeded

[28/Sep/2000:23:06:24][8795.4101][-conn0-] Notice: comment on table apm_parameters is '

create table apm_parameters (
	parameter_id		constraint apm_parameters_fk 
				references acs_objects(object_id)
			        constraint apm_parameters_pk primary key,
	package_key		varchar(100)
				constraint apm_pack_param_pack_key_nn not null 	
				constraint apm_pack_param_type_fk
			        references apm_package_types (package_key),
	parameter_name		varchar(100) 
				constraint apm_pack_params_name_nn not null,
        description		varchar(2000),
	section_name		varchar(2000),
	datatype	        varchar(100) not null
			        constraint apm_parameter_datatype_ck 
				check(datatype in ('number', 'string')),
	default_value		varchar(4000),
	min_n_values		integer default 1 not null
			        constraint apm_paramters_min_n_ck
			        check (min_n_values >= 0),
	max_n_values		integer default 1 not null
			        constraint apm_paramters_max_n_ck
			        check (max_n_values >= 0),
	constraint apm_paramters_attr_name_un
	unique (section_name, parameter_name, package_key),
	constraint apm_paramters_n_values_ck
	check (min_n_values <= max_n_values)
);