maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_create_user_sac(integer, character varying, character varying)
Parameters
Name
Type
Mode
in_idclient
integer
IN
in_user
character varying
IN
in_correo
character varying
IN
Definition
DECLARE _idpreference int; BEGIN PERFORM 1 FROM mayauser WHERE idclient = in_idclient AND username = in_user; IF NOT FOUND THEN with pref as (INSERT INTO preference SELECT nextval('sec_preference'),0,now(),0,now(),1,true,3,6,0,0,0,0,0,0 RETURNING idpreference) ,rol as (select idrole from role where idclient = in_idclient and name ilike 'Admin' limit 1) INSERT INTO mayauser SELECT nextval('sec_mayauser'),(select idrole from rol),in_idclient,(select idpreference from pref),in_user,in_user,in_user,in_correo,'5555555555','e10adc3949ba59abbe56e057f20f883e',false,0,now(),0,now(),1,true,0,1,true,null,1,null; /* El ctrlcode es generado por el trigger tg_genctrlcode, posterior a la inserción */ ELSE RAISE WARNING 'El usuario ya existe para esa cuenta id:% , user:%' , in_idclient,in_user ; RETURN 1; END IF; RETURN 0; END