authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_change_work_shift
Parameters
Name
Type
Mode
user_id
integer
IN
prop_id
integer
IN
new_shift
character varying
IN
Definition
UPDATE user_property SET work_shift = new_shift WHERE user_id = $1 AND prop_id = $2;