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;
|