trig_i_i_syst_instances()

-- File:        trig_i_i_syst_instances.eex.sql

-- Location:    musebms/database/components/system/mscmp_syst_instance/ms_syst/api_views/syst_instances/trig_i_i_syst_instances.eex.sql

-- Project:     Muse Systems Business Management System

--

-- Copyright © Lima Buttgereit Holdings LLC d/b/a Muse Systems

-- This file may include content copyrighted and licensed from third parties.

--

-- See the LICENSE file in the project root for license terms and conditions.

-- See the NOTICE file in the project root for copyright ownership information.

--

-- muse.information@musesystems.com  :: https://muse.systems

​

BEGIN

​

    INSERT INTO ms_syst_data.syst_instances

        ( internal_name

        , display_name

        , application_id

        , instance_type_id

        , instance_state_id

        , owner_id

        , owning_instance_id

        , dbserver_name

        , instance_code

        , instance_options )

    VALUES

        ( new.internal_name

        , new.display_name

        , new.application_id

        , new.instance_type_id

        , new.instance_state_id

        , new.owner_id

        , new.owning_instance_id

        , new.dbserver_name

        , new.instance_code

        , new.instance_options )

    RETURNING * INTO new;

​

    RETURN new;

​

END;