insert into portal_element_parameters
(parameter_id, element_id, configured_p, key, value)
values
(:parameter_id, :element_id, 't', :key, :value)
delete
from portal_element_parameters
where element_id = :element_id
and key = :key
and parameter_id = :parameter_id
delete
from portal_element_parameters
where element_id = :element_id
and key = :key
select value
from portal_element_parameters
where element_id = :element_id
and key = :key
update portal_element_parameters
set value = :value
where element_id = :element_id
and key = :key
and parameter_id = :parameter_id
select key,
value
from portal_element_parameters
where element_id = :element_id