Untitled

mail@pastecode.io avatar
unknown
sql
2 years ago
6.9 kB
3
Indexable
Never
-- FULL_SERVICE_2_MT_EKBATAN
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_MT_EKBATAN', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1750, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1750, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 2286, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_EKBATAN'), false, true, now(), now(), 0);


-- FULL_SERVICE_2_MT_Daryache
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_MT_Daryache', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1689, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_Daryache'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1689, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_Daryache'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 2209, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_Daryache'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_Daryache'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_Daryache'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_Daryache'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_Daryache'), false, true, now(), now(), 0);