aboutsummaryrefslogtreecommitdiffstats
path: root/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/01_initial_ref_data_v1.sql
blob: 44d86f0a208afbd0d7dfea7418d55d64cfc50636 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
--liquibase formatted sql
--changeset ref_data_load_p1:18_10_ref_data_load_p1.sql

--comment: 07/23/2018 Intial Data Load - LOAD PARAMETERS

--set @@autocommit:=0;

--delete all records
delete from SERVICE_PARAMETER;

INSERT INTO SERVICE_PARAMETER(NAME, VALUE, CREATED_BY) VALUES ('initial_increment','10,40,50,100','Initial');
INSERT INTO SERVICE_PARAMETER(NAME, VALUE, CREATED_BY) VALUES ('recipe_separator','|":",','Initial');

delete from IDENTIFIER_MAP;

INSERT INTO IDENTIFIER_MAP(POLICY_FN_NAME, JS_FN_NAME, CREATED_BY) VALUES ('substr','substring', 'Initial'); 

commit;