x
1
-- File: trig_i_i_syst_credentials.eex.sql
2
-- Location: musebms/database/components/system/mscmp_syst_authn/ms_syst/api_views/syst_credentials/trig_i_i_syst_credentials.eex.sql
3
-- Project: Muse Systems Business Management System
4
--
5
-- Copyright © Lima Buttgereit Holdings LLC d/b/a Muse Systems
6
-- This file may include content copyrighted and licensed from third parties.
7
--
8
-- See the LICENSE file in the project root for license terms and conditions.
9
-- See the NOTICE file in the project root for copyright ownership information.
10
--
11
-- muse.information@musesystems.com :: https://muse.systems
12
13
BEGIN
14
15
INSERT INTO ms_syst_data.syst_credentials
16
( access_account_id
17
, credential_type_id
18
, credential_for_identity_id
19
, credential_data
20
, last_updated
21
, force_reset )
22
VALUES
23
( new.access_account_id
24
, new.credential_type_id
25
, new.credential_for_identity_id
26
, new.credential_data
27
, new.last_updated
28
, new.force_reset )
29
RETURNING * INTO new;
30
31
RETURN new;
32
33
END;