fedorm

INSERT INTO service_type (id, name) SELECT NEXTVAL('hibernate_sequence'), 'bonuses' WHERE NOT EXISTS (SELECT 1 FROM service_type WHERE name = 'bonuses');
INSERT INTO service_provider (id, DELETED, name, registered_name, service_type)
VALUES (NEXTVAL('hibernate_sequence'), FALSE, 'CFTBonuses', 'Бонусные карты ЦФТ', (SELECT id FROM service_type WHERE name LIKE 'bonuses'));
INSERT INTO service_provider_settings(id, name, VALUE, provider, shop)
VALUES (NEXTVAL('hibernate_sequence'), 'cardPrefixes', '998877', (SELECT id FROM service_provider WHERE name='CFTBonuses' AND deleted=FALSE), 0);
INSERT INTO service_provider_settings(id, name, VALUE, provider, shop)
VALUES (NEXTVAL('hibernate_sequence'), 'maxPercentDiscount', '90', (SELECT id FROM service_provider WHERE name='CFTBonuses' AND deleted=FALSE), 0);
INSERT INTO service_provider_settings(id, name, VALUE, provider, shop)
VALUES (NEXTVAL('hibernate_sequence'), 'actionCardsPrefixes', '998878', (SELECT id FROM service_provider WHERE name='CFTBonuses' AND deleted=FALSE), 0);
INSERT INTO service_provider_settings(id, name, VALUE, provider, shop)
VALUES (NEXTVAL('hibernate_sequence'), 'actionMaxPercentDiscount', '90', (SELECT id FROM service_provider WHERE name='CFTBonuses' AND deleted=FALSE), 0);