index_product_config.sql

gistfile1.txt

insert into trd_tenant (id, code) values (108835, 'NAV');

insert into trd_product (productid, active, code, name, tenantid)
    values (nextval('seq_trd_product'), true, 'slf_implicit_pricing', 'SLF: Implicit Pricing', 108835);

insert into trd_configuration (configurationid, fund_type, sequence_type, valid_from, creation_date)
    values (nextval('seq_trd_configuration'), 40, 'SURRENDER_FIRST', now(), now());

insert into trd_product_configuration (productid, configurationid)
select  (select productid from trd_product where code = 'slf_implicit_pricing') as productid,
        (select configurationid from trd_configuration order by configurationid desc limit 1) as configurationid
       from trd_product limit 1;

insert into trd_instruction_execution_configuration (id, instruction_type, transaction_factory_type) values
    (nextval('seq_trd_instruction_execution_configuration'), 'APPLICATION', 'DEFAULT_NEW_APPLICATION');

insert into trd_configuration_instruction (configurationid, instructionid)
    select  (select configurationid from trd_configuration order by configurationid desc limit 1) as configurationid,
            (select id from trd_instruction_execution_configuration order by id desc limit 1) as instructionid
    from trd_product limit 1;

insert into trd_instruction_execution_configuration (id, instruction_type, transaction_factory_type) values
    (nextval('seq_trd_instruction_execution_configuration'), 'SURRENDER', 'DEFAULT_PARTIAL_SURRENDER');

insert into trd_configuration_instruction (configurationid, instructionid)
    select  (select configurationid from trd_configuration order by configurationid desc limit 1) as configurationid,
            (select id from trd_instruction_execution_configuration order by id desc limit 1) as instructionid
    from trd_product limit 1;