openspecimen
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
add_cfg_prop
Parameters
Name
Type
Mode
moduleName
text
IN
propName
text
IN
propCode
text
IN
propDesc
text
IN
propType
text
IN
defValue
text
IN
Definition
begin select identifier into @module_id from os_modules where name = moduleName; insert into os_cfg_props (identifier, name, display_name_code, desc_code, data_type, module_id) values (default, propName, propCode, propDesc, propType, @module_id); select last_insert_id() into @prop_id; select identifier into @user_id from catissue_user where login_name = '$system'; insert into os_cfg_settings (identifier, property_id, value, activated_by, activation_date, activity_status) values (default, @prop_id, defValue, @user_id, current_timestamp(), 'Active'); end