trig_i_i_syst_settings()

-- File:        trig_i_i_syst_settings.eex.sql

-- Location:    musebms/database/components/system/mscmp_syst_settings/ms_syst/api_views/syst_settings/trig_i_i_syst_settings.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_settings

        ( internal_name

        , display_name

        , syst_defined

        , syst_description

        , user_description

        , setting_flag

        , setting_integer

        , setting_integer_range

        , setting_decimal

        , setting_decimal_range

        , setting_interval

        , setting_date

        , setting_date_range

        , setting_time

        , setting_timestamp

        , setting_timestamp_range

        , setting_json

        , setting_text

        , setting_uuid

        , setting_blob )

    VALUES

        ( new.internal_name

        , new.display_name

        , FALSE

        , '(System Description Not Available)'

        , new.user_description

        , new.setting_flag

        , new.setting_integer

        , new.setting_integer_range

        , new.setting_decimal

        , new.setting_decimal_range

        , new.setting_interval

        , new.setting_date

        , new.setting_date_range

        , new.setting_time

        , new.setting_timestamp

        , new.setting_timestamp_range

        , new.setting_json

        , new.setting_text

        , new.setting_uuid

        , new.setting_blob )

    RETURNING * INTO new;

​

    RETURN new;

​

END;