fedorm

-- Добавление процессинга Подарочные карты ЦФТ
INSERT INTO service_type (id, name) SELECT NEXTVAL('hibernate_sequence'), 'giftcards' WHERE NOT EXISTS (SELECT 1 FROM service_type WHERE name = 'giftcards');
INSERT INTO service_provider (id, DELETED, name, registered_name, service_type) VALUES (NEXTVAL('hibernate_sequence'), FALSE, 'CFTGiftCards', 'Подарочные карты ЦФТ', (SELECT id FROM service_type WHERE name LIKE 'giftcards'));

-- Добавление префиксов для Подарочных карт ЦФТ
INSERT INTO service_provider_settings (id, name, VALUE, provider) VALUES (NEXTVAL('hibernate_sequence'), 'barCodePrefixes', '778,777,776', (SELECT id FROM service_provider WHERE name LIKE 'CFTGiftCards'));
INSERT INTO service_provider_settings (id, name, VALUE, provider) VALUES (NEXTVAL('hibernate_sequence'), 'cardPrefixes', '778,777,776', (SELECT id FROM service_provider WHERE name LIKE 'CFTGiftCards'));